INSERT INTO Waiter (WName) VALUES ('Peter');
INSERT INTO Waiter (WName) VALUES ('Steen');
INSERT INTO Waiter (WName) VALUES ('Michael');
INSERT INTO Waiter (WName) VALUES ('Ebbe');
INSERT INTO Waiter (WName) VALUES ('Homayoon');
INSERT INTO Waiter (WName) VALUES ('Vibeke');
INSERT INTO Waiter (WName) VALUES ('Lars');
INSERT INTO Waiter (WName) VALUES ('Martin');
INSERT INTO Waiter (WName) VALUES ('Anders');
select * from Waiter;

INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 1, 1);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 0, 1);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 1);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (6, 0, 1);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 1, 1);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 2);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (8, 0, 2);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 2);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 0, 2);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 1, 2);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 3);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (6, 0, 3);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (3, 0, 4);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 1, 4);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 0, 4);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 5);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 1, 5);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (8, 0, 5);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 0, 6);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (2, 1, 7);
INSERT INTO RestaurantTable (Seats, WindowSite, Waiter) VALUES (4, 0, 8);
select * from RestaurantTable;


INSERT INTO MenuCard VALUES ('Breakfast', 'B');
INSERT INTO MenuCard VALUES ('Lunch', 'L');
INSERT INTO MenuCard VALUES ('Evening', 'E');
INSERT INTO MenuCard VALUES ('Drinking', 'D');
select * from MenuCard;


INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Coffee', 'Hot Drink', 'Normal Americano', 25, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Cappocino', 'Hot Drink', 'Coffee with some milk', 35, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Latte', 'Hot Drink', 'Coffee and milk', 35, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Tea', 'Hot Drink', 'Different sorts ask waiter', 25, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Apple Juice', 'Cold Drink', 'Fruity', 20, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Orange Juice', 'Cold Drink', 'Best Spanish Orange', 20, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Milk', 'Cold Drink', 'Glass of Milk', 30, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Water', 'Cold Drink', 'Still tapped water ', 20, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Softdrink', 'Cold Drink', 'Cola,Fanta,Sprite', 25, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Danish Breakfast', 'Breakfast', 'grains, bread, butter cheese', 98, 'Breakfast');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Bread bun', 'Breakfast', 'Bread Bun, butter, jam, cheese', 55, 'Breakfast');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Danish Pastry', 'Breakfast', 'Choose between different sorts', 35, 'Breakfast');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Yogurt', 'Breakfast', 'Yogurt with grains', 42, 'Breakfast');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Beer', 'Cold Drink', 'Tuborg', 40, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('House Red Wine', 'Wine', 'Good Spanish red Wine', 40, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('House White Wine', 'Wine', 'Good German white wine', 42, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Danish Lunch', 'Cold Meal', 'Herring, Roast pork, Salami, Cheese', 136, 'Lunch');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Sandwich', 'Cold Meal', 'Sandwich ham, cheese or salami', 65, 'Lunch');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Fish "N Chips', 'Hot Meal', 'Fish of cod with chips', 71, 'Lunch');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('House Burger', 'Hot Meal', '200g beef-burger with cheese and chips', 80, 'Lunch');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Special Beer', 'Cold Drink', 'Different types ask waiter', 55, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Champagne', 'Cold Drink', 'Best Frensh Champagne', 105, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Rioja', 'Wine', 'Good Red Wine', 68, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Provance', 'Wine', 'Good Rose from Provance', 75, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Loire', 'Wine', 'Good French white wine', 82, 'Drinking');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Prawns', 'Starter', 'prawns with salat', 67, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Charcuterie', 'Starter', 'Different sausages, dried ham', 91, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Soupe', 'Starter', 'Soupe of the day with bread', 65, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Evening Burger', 'Main', '300g beef-burger with cheese,chips vegetables', 135, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Chicken', 'Main', '½Chicken, potatoes vegetables', 163, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Sole', 'Main', 'Good Sole with potatoes and vegetables', 175, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Steak', 'Main', '300g Ox-filet with baked potatoes,  vegetables', 235, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Margherita', 'Pizza', 'Plain pizza with tomatoes, onion, cheese', 71, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Vesuvio', 'Pizza', 'pizza with tomatoes, ham and cheese', 71, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Capricciosa', 'Pizza', 'pizza with tomatoes, ham, cheese and mushrooms', 71, 'Evening');
INSERT INTO MenuItem (MenuName, TypeOfItem, MenuDescription, Price, MenuCardName)
VALUES ('Peters', 'Pizza', 'pizza with tomatoes, beef, bacon, mushrooms, two types cheese', 88, 'Evening');
select * from MenuItem;


INSERT INTO Customer VALUES('11223344', 'King Lear');
INSERT INTO Customer VALUES('22446699', 'King Arthur');
INSERT INTO Customer VALUES('55443322', 'King Bluetooth');
INSERT INTO Customer VALUES('44229955', 'Prince Hamlet');
INSERT INTO Customer VALUES('54657687', 'King Kong');
INSERT INTO Customer VALUES('12345678', 'King Wilhem');
INSERT INTO Customer VALUES('87654321', 'King Valdemar');
select * from Customer;


INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (1,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (3,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (1,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (9,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (10,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (10,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (12,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (13,'12345678');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (4,'87654321');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (1,'87654321');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (11,'87654321');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (12,'87654321');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (13,'87654321');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (2,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (3,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (5,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (10,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (10,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (10,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (12,'22446699');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (8,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (8,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (21,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (21,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (17,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (18,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (19,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (20,'44229955');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (15,'11223344');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (16,'11223344');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (20,'11223344');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (20,'11223344');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (25,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (25,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (26,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (28,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (31,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (30,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (27,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (26,'54657687');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (30,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (30,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (30,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (31,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (31,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (32,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (32,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (32,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (22,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (23,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (24,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (24,'55443322');
INSERT INTO OrderLine (MenuItemId, CustomerNo) VALUES (25,'55443322');
select * from OrderLine;

INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-14 10:00:00', '55443322');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-22 18:30:00', '55443322');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-03-15 12:15:00', '55443322');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-01-24 20:00:00', '54657687');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-11 18:00:00', '54657687');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-03-17 19:00:00', '54657687');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-04-01 12:00:00', '11223344');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-04-03 10:00:00', '11223344');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-04-03 12:30:00', '11223344');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-04-03 19:45:00', '11223344');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-14 18:00:00', '87654321');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-16 18:00:00', '87654321');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-20 18:00:00', '87654321');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-14 12:30:00', '11223344');
INSERT INTO Booking (DayAndTime, CustomerNo) Values ('2018-02-14 12:15:00', '22446699');
select * from Booking;


INSERT INTO Reservation VALUES (1,1);
INSERT INTO Reservation VALUES (1,3);
INSERT INTO Reservation VALUES (1,5);
INSERT INTO Reservation VALUES (2,2);
INSERT INTO Reservation VALUES (2,10);
INSERT INTO Reservation VALUES (3,11);
INSERT INTO Reservation VALUES (4,21);
INSERT INTO Reservation VALUES (5,10);
INSERT INTO Reservation VALUES (5,11);
INSERT INTO Reservation VALUES (6,14);
INSERT INTO Reservation VALUES (6,15);
INSERT INTO Reservation VALUES (6,16);
INSERT INTO Reservation VALUES (7,9);
INSERT INTO Reservation VALUES (7,8);
INSERT INTO Reservation VALUES (8,11);
INSERT INTO Reservation VALUES (9,5);
INSERT INTO Reservation VALUES (10,6);
INSERT INTO Reservation VALUES (11,17);
INSERT INTO Reservation VALUES (12,18);
INSERT INTO Reservation VALUES (13,19);
INSERT INTO Reservation VALUES (14,2);
INSERT INTO Reservation VALUES (14,3);
INSERT INTO Reservation VALUES (15,6);
INSERT INTO Reservation VALUES (15,8);
INSERT INTO Reservation VALUES (2,19);
INSERT INTO Reservation VALUES (3,1);
INSERT INTO Reservation VALUES (4,10);
INSERT INTO Reservation VALUES (5,14);
INSERT INTO Reservation VALUES (6,19);
select * from Reservation;


