AV3ejj2a

1DROP TABLE if exists ORDER_LINES;
2DROP TABLE if exists ORDERS;
3DROP TABLE if exists MENUCARD;
4 
5CREATE TABLE ORDERS(  
6    ORDERNO INTEGER not null,
7    ORDER_TIME TIMESTAMP,
8    PICKUP_TIME TIMESTAMP,
9    ORDERSTATUS TINYINT,
10    PRIMARY KEY (ORDERNO)
11);
12 
13CREATE TABLE MENUCARD(
14    PIZZANO INTEGER not null,
15    PIZZANAME VARCHAR(30),
16    PRICE FLOAT,
17    PRIMARY KEY (PIZZANO)
18);
19 
20CREATE TABLE ORDER_LINES(
21PIZZANO INTEGER not null,
22ORDERNO INTEGER NOT NULL,
23Qty INTEGER,
24PRIMARY KEY (ORDERNO, PIZZANO),
25FOREIGN KEY (ORDERNO) REFERENCES ORDERS(ORDERNO),
26FOREIGN KEY (PIZZANO) REFERENCES MENUCARD(PIZZANO)
27);
28 
29Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (01, 'Vesuvio', 57.00);
30Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (02, 'Amerikaner', 53.00);
31Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (03, 'Cacciatore', 57.00);
32Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (04, 'Carbona', 63.00);
33Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (05, 'Dennis', 65.00);
34Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (06, 'Bertil', 57.00);
35Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (07, 'Silvia', 61.00);
36Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (08, 'Victoria', 61.00);
37Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (09, 'Toronfo', 61.00);
38Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (10, 'Capricciosa', 61.00);
39Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (11, 'Hawai', 61.00);
40Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (12, 'Le Blissola', 61.00);
41Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (13, 'Venezia', 61.00);
42Insert into MENUCARD (PIZZANO, PIZZANAME, PRICE) values (14, 'Mafia', 61.00);
43 
44commit;