Permalink
Whether you own a fast food restaurant, fine dining establishment, or a gastropub, install the restaurant management app to get the most out of your restaurant business. INSTALL NOW INSTALL NOW INSTALL NOW.
Join GitHub today
C4d renders pack s. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
It is also an invaluable text/reference for graduate students, scientists, and engineers in computer science, mathematics, and engineering. Introduction to parallel algorithms and architectures leighton pdf pdf.
Sign up
Find file Copy path
1 contributor
dropdatabase if exists `restaurant`; |
createdatabase `restaurant`; |
use `restaurant`; |
droptable if exists `USER`; |
createtable `USER`( |
`User_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(50) NOT NULL, |
`Lname`varchar(50) NOT NULL, |
`Password`varchar(50) NOT NULL, |
PRIMARY KEY (`User_Id`) |
)ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `RESTAURANT`; |
createtable `RESTAURANT`( |
`Name`varchar(100) NOT NULL, |
`Location`varchar(100) NOT NULL, |
`Contact`varchar(100) NOT NULL, |
`Opening_Closing_Time`varchar(100) NOT NULL, |
`Details`varchar(500) default NULL, |
PRIMARY KEY (`Name`) |
)ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `OWNER`; |
createtable `OWNER`( |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(100) NOT NULL, |
`Rest_Name`varchar(100) NOT NULL, |
PRIMARY KEY (`Fname`,`Lname`,`Contact`), |
FOREIGN KEY (`Rest_Name`) REFERENCES`RESTAURANT`(`Name`) |
ONUPDATE CASCADE |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `BILL`; |
createtable `BILL`( |
`Order_Id`intNOT NULL AUTO_INCREMENT, |
`Customer_Fname`varchar (20) NOT NULL, |
`Customer_Lname`varchar (20) NOT NULL, |
`Customer_id`intNOT NULL, |
`Total_Amount` double NOT NULL, |
PRIMARY KEY (`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MENU_BILL`; |
createtable `MENU_BILL`( |
`Order_Id`intNOT NULL, |
`Name`varchar(100) NOT NULL, |
`Quantity`varchar(20) NOT NULL, |
`Price`varchar(20) NOT NULL, |
FOREIGN KEY(`Order_Id`) REFERENCES`BILL`(`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `CUSTOMER`; |
createtable `CUSTOMER`( |
`Customer_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) DEFAULT NULL, |
`Email_Id`varchar(50) DEFAULT NULL, |
PRIMARY KEY (`Customer_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MANAGER`; |
createtable `MANAGER`( |
`Manager_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Manager_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `WAITER`; |
createtable `WAITER`( |
`Waiter_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Waiter_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `CASHIER`; |
createtable `CASHIER`( |
`Cashier_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Cashier_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `COOK`; |
createtable `COOK`( |
`Cook_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
`Specialization`varchar(50) DEFAULT NULL, |
PRIMARY KEY (`Cook_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `HOME_DELIVERY`; |
createtable `HOME_DELIVERY`( |
`Delivery_Id`intNOT NULL AUTO_INCREMENT, |
`Address`varchar(50) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Cust_Id`intNOT NULL, |
`Order_Id`intNOT NULL, |
PRIMARY KEY(`Delivery_Id`), |
FOREIGN KEY (`Cust_Id`) REFERENCES`CUSTOMER`(`Customer_Id`), |
FOREIGN KEY (`Order_Id`) REFERENCES`BILL`(`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `DELIVERY_BOY`; |
createtable `DELIVERY_BOY`( |
`Delivery_Boy_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Delivery_Boy_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `DELIVERY_BOY_2`; |
createtable `DELIVERY_BOY_2`( |
`Boy_Id`intNOT NULL, |
`Delivery_Id`intNOT NULL, |
FOREIGN KEY (`Boy_Id`) REFERENCES`DELIVERY_BOY`(`Delivery_Boy_Id`), |
FOREIGN KEY (`Delivery_Id`) REFERENCES`HOME_DELIVERY`(`Delivery_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MENU`; |
createtable `MENU`( |
`Menu_Id`intNOT NULL AUTO_INCREMENT, |
`Name`varchar(100) NOT NULL, |
`Price`varchar(20) NOT NULL, |
`Type`varchar(20) DEFAULT NULL, |
`Category`varchar(30) NOT NULL, |
PRIMARY KEY(`Menu_Id`,`Name`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `SALE_DETAIL`; |
createtable `SALE_DETAIL`( |
`Date`dateNOT NULL, |
`Daily`intNOT NULL, |
`Weekly`int DEFAULT NULL, |
`Monthly`int DEFAULT NULL, |
`Rname`varchar(30) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `SUPPLIER`; |
createtable `SUPPLIER`( |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Address`varchar(30) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Details`varchar(500) DEFAULT NULL, |
PRIMARY KEY (`Fname`,`Lname`,`Address`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `TABLES`; |
createtable `TABLES`( |
`Table_Number`varchar(9) NOT NULL, |
`Details`varchar(200) DEFAULT NULL, |
PRIMARY KEY (`Table_Number`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `BOOKING`; |
createtable `BOOKING`( |
`Booking_Id`intNOT NULL AUTO_INCREMENT, |
`Table_Num`varchar(30) NOT NULL, |
`Date`varchar(30) NOT NULL, |
`Time`varchar(30) NOT NULL, |
`Cust_Id`intNOT NULL, |
PRIMARY KEY (`Booking_Id`), |
FOREIGN KEY (`Cust_Id`) REFERENCES`CUSTOMER`(`Customer_Id`), |
FOREIGN KEY (`Table_Num`) REFERENCES`TABLES`(`Table_Number`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `INGREDIENT`; |
createtable `INGREDIENT`( |
`Ingredient_Id`intNOT NULL AUTO_INCREMENT, |
`Name`varchar(30) NOT NULL, |
`Quantity`varchar(15) NOT NULL, |
`Description`varchar(100) DEFAULT NULL, |
`Supp_Name`varchar(50) NOT NULL, |
PRIMARY KEY (`Ingredient_Id`,`Name`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
insert into`RESTAURANT`(`Name`,`Location`,`Contact`,`Opening_Closing_Time`,`Details`) |
values |
('Tandoori By Nature','Gandhi Nagar Jammu And Kashmir','09642540626/09581871321','10:00 AM - 12:00 AM','None'); |
insert into`OWNER`(`Fname`,`Lname`,`Contact`,`Rest_Name`) |
values |
('Yash','Vadalia','9999999999','Tandoori By Nature'); |
insert into`MANAGER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Rishi Raj','Singh Jhelumi','9642540626','E-28 OBH , IIIT Hyderabad','30000','M','1992-09-29','2012-08-01'), |
('Prachish','Gora','9581871321','E-27 OBH , IIIT Hyderabad','30000','M','1993-11-18','2012-08-01'); |
insert into`WAITER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Raghav','Sharma','123456','E-22 OBH , IIIT Hyderabad','8000','U','1993-10-12','2012-08-01'), |
('Rishav','Kumar','132244','E-28 OBH , IIIT Hyderabad','8000','M','1992-12-22','2012-08-01'), |
('Vinil','Narang','213122','E-27 OBH , IIIT Hyderabad','8000','M','1993-05-12','2012-08-01'), |
('Bharat','Jain','121232','E-26 OBH , IIIT Hyderabad','8000','M','1992-03-12','2012-08-01'), |
('Megan','Fox','213122','Hollywood USA','9000','F','1986-10-13','2012-08-01'), |
('Sunny','Leone','323322','Bollywood INDIA','9000','F','1982-10-13','2012-08-01'); |
insert into`CASHIER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Abhinav','Mittal','124142','E-19 OBH , IIIT Hyderabad','12000','M','1993-11-30','2012-08-01'), |
('Sanchit','Gangwar','113332','E-24 OBH , IIIT Hyderabad','12000','M','1993-02-21','2012-08-01'), |
('Abhishek','Kumar','122121','E-25 OBH , IIIT Hyderabad','12000','M','1992-07-21','2012-08-01'); |
insert into`COOK`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Specialization`,`Bdate`,`Join_Date`) |
values |
('Bhavshuk','Jindal','123211','E-18 OBH , IIIT Hyderabad','15000','M','Maggi','1992-08-02','2012-08-01'), |
('Japneet','Singh','231312','E-19 OBH , IIIT Hyderabad','15000','M','Samosa','1992-10-12','2012-08-01'), |
('Dinesh','Singla','874594','E-18 OBH , IIIT Hyderabad','15000','M','Omlette','1992-03-14','2012-08-01'), |
('Siddharth','Sinha','587654','E-26 OBH , IIIT Hyderabad','15000','M','Bonda','1992-01-01','2012-08-01'), |
('Himanshu','Aggarwal','142355','E-24 OBH , IIIT Hyderabad','15000','M','Jalebi','1992-02-22','2012-08-01'), |
('Priya','Rai','897933','HOLLYWOOD USA','15000','F','None','1980-01-02','2012-08-01'); |
insert into`DELIVERY_BOY`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Tarang','Goyal','133132','E-17 OBH , IIIT Hyderabad','10000','M','1993-02-21','2012-08-01'), |
('Saksham','Maheshwari','657569','E-17 OBH , IIIT Hyderabad','10000','M','1992-10-21','2012-08-01'), |
('Rajat','Agarwal','596509','E-16 OBH , IIIT Hyderabad','10000','M','1993-02-21','2012-08-01'), |
('Vidit','Bhaskar','344244','E-15 OBH , IIIT Hyderabad','10000','M','1993-10-22','2012-08-01'); |
insert into`MENU`(`Name`,`Price`,`Type`,`Category`) |
values |
('Vegetable Pakora','3.00','Veg','Starters'), |
('Vegetable Samosa','3.00','Veg','Starters'), |
('Onion Bhaji ','3.00','Veg','Starters'), |
('Potato and Mushroom Chaat','3.00','Veg','Starters'), |
('Mushroom Garlic Fry','3.00','Veg','Starters'), |
('Chicken Tikka','4.00','Non-Veg','Starters'), |
('Tandoori Chicken','4.00','Non-Veg','Starters'), |
('Chicken Garlic Fry','4.00','Non-Veg','Starters'), |
('Chicken Tikka on Puree','4.00','Non-Veg','Starters'), |
('Lamb Tikka','4.00','Non-Veg','Starters'), |
('Tandoori King Prawn','6.95','Non-Veg','SeaFood'), |
('King Prawn Rosun','5.95','Non-Veg','SeaFood'), |
('King Prawn on Puree','5.95','Non-Veg','SeaFood'), |
('Prawn Bhuna on Puree','3.95','Non-Veg','SeaFood'), |
('Prawn Cocktail','3.95','Non-Veg','SeaFood'), |
('Chi/Lam Sashlik Chi','9.95','Non-Veg','Tandoori Specials'), |
('Tandoori Deluxe','12.95','Non-Veg','Tandoori Specials'), |
('Tandoori Chicken Main','9.95','Non-Veg','Tandoori Specials'), |
('Chicken Tikka','7.95','Non-Veg','Tandoori Specials'), |
('Lamb Tikka','9.95','Non-Veg','Tandoori Specials'), |
('Bombay Aloo ','6.50','Veg','Vegetable Dishes'), |
('Mushroom Bhaji ','6.50','Veg','Vegetable Dishes'), |
('Saag Dall','6.50','Veg','Vegetable Dishes'), |
('Mattor Paneer','6.50','Veg','Vegetable Dishes'), |
('Vegetable Roshun','6.50','Veg','Vegetable Dishes'), |
('Boiled Rice','2.50','Veg','Side Orders - Rice'), |
('Keema Pilau Rice','3.50','Non-Veg','Side Orders - Rice'), |
('Mushroom Rice','3.20','Veg','Side Orders - Rice'), |
('Garlic Naan','3.00','Veg','Side Orders - Bread'), |
('Stuffed Naan','3.50','Veg','Side Orders - Bread'), |
('Chapati','1.00','Veg','Side Orders - Bread'), |
('Green Salad','2.00','Veg','Side Orders - Sundries'), |
('Spice Popadum','0.80','Veg','Side Orders - Sundries'), |
('Chutney','0.70','Veg','Side Orders - Sundries'), |
('Ras Malai','2.95','Veg','Dessert'), |
('Ice Cream','2.95','Veg','Dessert'), |
('Gulab Jamun','2.95','Veg','Dessert'), |
('Kulfi','2.95','Veg','Dessert'), |
('Kheer','2.95','Veg','Dessert'); |
insert into`SUPPLIER`(`Fname`,`Lname`,`Address`,`Contact`,`Details`) |
values |
('Varun','Vashisht','E-121 OBH , IIIT Hyderabad','123211','Provides Non-Veg Stuff.'), |
('Aneeq','Dholakia','E-15 OBH , IIIT Hyderabad','678668','Provides Sea Food.'), |
('Sharad','Gupta','E-16 OBH , IIIT Hyderabad','856855','Provides Grocery.'); |
insert into`TABLES`(`Table_Number`,`Details`) |
values |
('1','Capacity 4 People'), |
('2','Capacity 4 People Near Window'), |
('3','Capacity 3 People'), |
('4','Capacity 2 People'), |
('5','Capacity 8 People Family Table'); |
insert into`CUSTOMER`(`Fname`,`Lname`,`Contact`,`Email_Id`) |
values |
('Arpit','Sharma','938912','[email protected]'), |
('Yash','Shah','289374','[email protected]'), |
('Darshit','Serna','234322','[email protected]'), |
('Aditya','Sharma','778989','[email protected]'), |
('Pallav','Shah','364932','[email protected]'), |
('Rajat','Bharadwaj','734277','[email protected]'), |
('Achintya','Madhav','347534','[email protected]'); |
insert into`USER`(`Fname`,`Lname`,`Password`) |
values |
('admin','admin','admin'), |
('Akhil','Jindal','cheetah'), |
('Deepak','Goyal','manga'), |
('RoopGUN','Deeep','sodhi'); |
Transport Management Software In India
Copy lines Copy permalink