xFScKVrj

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