View file restdininguide/make.sql

create database resturaunts ;

connect resturaunts ;

create table auth 
(username VARCHAR(30), 
password VARCHAR(30), 
admin INT, 
ID INT NOT NULL AUTO_INCREMENT, 
primary key(id));

create table info 
(name VARCHAR(30), 
location VARCHAR(30), 
phone_number INT, 
type_of_food VARCHAR(30),
description TEXT,
ID INT NOT NULL AUTO_INCREMENT, 
primary key(id));

create table finance 
(name VARCHAR(30), 
location VARCHAR(30), 
phone_number INT, 
type_of_food VARCHAR(30),
description TEXT,
ID INT NOT NULL AUTO_INCREMENT, 
primary key(id));