forked from ludoch/jcandystore
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathjcandystore-data.sql
153 lines (147 loc) · 16 KB
/
jcandystore-data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
INSERT INTO A_SEQUENCE VALUES ('ORDER_NUM', 1000);
INSERT INTO A_SEQUENCE VALUES ('LINE_NUM', 1000);
INSERT INTO CATEGORY VALUES ('REGLISSE','Réglisse','<image src="./assets/img/candies/reglisse_icon.jpg"><font size="5" color="blue"> Réglisse</font>');
INSERT INTO CATEGORY VALUES ('CARAMEL','Caramel','<image src="./assets/img/candies/caramel_icon.jpg"><font size="5" color="blue"> Caramel</font>');
INSERT INTO CATEGORY VALUES ('CHOCOLAT','Chocolat','<image src="./assets/img/candies/chocolat_icon.jpg"><font size="5" color="blue"> Chocolat</font>');
INSERT INTO CATEGORY VALUES ('SUCETTE','Sucette','<image src="./assets/img/candies/sucette_icon.jpg"><font size="5" color="blue"> Sucettes</font>');
INSERT INTO CATEGORY VALUES ('ACIDULE','Acidulé','<image src="./assets/img/candies/acidule_icon.jpg"><font size="5" color="blue"> Acidulés</font>');
INSERT INTO CATEGORY VALUES ('GELIFIE','Gelifié','<image src="./assets/img/candies/gelifie_icon.jpg"><font size="5" color="blue"> Gelifiés</font>');
INSERT INTO CATEGORY VALUES ('BONBON','Bonbon','<image src="./assets/img/candies/bonbon_icon.jpg"><font size="5" color="blue"> Bonbons</font>');
INSERT INTO CATEGORY VALUES ('PATISSERIE','Patisserie','<images src="./assets/img/candies/patisseries_icon.jpg"><font size="5" color="blue"> Patisseries</font>');
INSERT INTO PRODUCT VALUES ('CH-SW-01','CHOCOLAT','Assortiment Chocolats','<image src="./assets/img/candies/AssortimentChocolats.jpg">Assortiment de chocolats de qualité');
INSERT INTO PRODUCT VALUES ('AC-SW-02','ACIDULE','Assortiment Bonbons','<image src="./assets/img/candies/AssortimentsBonbons.png">Assortiment de bonbons acidulés');
INSERT INTO PRODUCT VALUES ('RE-FW-01','REGLISSE', 'Baton de réglisse.','<image src="./assets/img/candies/BatonReglisse.png">Baton de réglisse. Souvenir, souvenir...');
INSERT INTO PRODUCT VALUES ('BO-FW-02','BONBON', 'Berlingots','<image src="./assets/img/candies/Berlingots.png">Berlingots de toutes les couleurs');
INSERT INTO PRODUCT VALUES ('CH-BD-01','CHOCOLAT','Boite de chocolats','<image src="./assets/img/candies/BoiteChocolats.png">Boite de chocolats fins');
INSERT INTO PRODUCT VALUES ('AC-DL-01','ACIDULE','Bonbons en vrac','<image src="./assets/img/candies/BonbonsVrac.png">Bonbons acidulés en vrac');
INSERT INTO PRODUCT VALUES ('CA-RT-01','CARAMEL','Carambar','<image src="./assets/img/candies/Carambar.png">Carambar, favori des dentistes');
INSERT INTO PRODUCT VALUES ('CA-RT-02','CARAMEL','Caramel','<image src="./assets/img/candies/Caramel.png">Caramel au beurre salé');
INSERT INTO PRODUCT VALUES ('AC-CW-01','ACIDULE','Carensac','<image src="./assets/img/candies/Carensac.png">Carensac, en sachet de 80');
INSERT INTO PRODUCT VALUES ('GE-SN-01','GELIFIE','Cerises','<image src="./assets/img/candies/Cerises.png">Cerises');
INSERT INTO PRODUCT VALUES ('CH-LI-02','CHOCOLAT','Chocolat au lait','<image src="./assets/img/candies/ChocolatLait.png">Chocolat au lait pour enfant de tout age');
INSERT INTO PRODUCT VALUES ('CH-DSH-01','CHOCOLAT','Chocolat fins','<image src="./assets/img/candies/ChocolatsFins.png">Chocolat fins, idéal avec un café.');
INSERT INTO PRODUCT VALUES ('SU-DLH-02','SUCETTE','Chupa Chupps','<image src="./assets/img/candies/ChupaChupps.png">Chuppa Chupps, par 2');
INSERT INTO PRODUCT VALUES ('PA-PO-02','PATISSERIE','Cup Cake','<image src="./assets/img/candies/Cupcake.png">Cup, cake, the one and only');
INSERT INTO PRODUCT VALUES ('GE-PO-03','GELIFIE','Dents Dracula','<image src="./assets/img/candies/DentsDracula.png">Dents de Dracula');
INSERT INTO PRODUCT VALUES ('BO-PO-03','BONBON','Distributeur de bonbons','<image src="./assets/img/candies/DistributeurBonbons.png">Distributeur de bonbons. Oui, mais combien?');
INSERT INTO PRODUCT VALUES ('PA-PO-03','PATISSERIE','Donut','<image src="./assets/img/candies/Donut.png">Donut, the one and only');
INSERT INTO PRODUCT VALUES ('AC-PO-03','ACIDULE','Dragibus','<image src="./assets/img/candies/Dragibus.png">Dragibus, en sachet de 25');
INSERT INTO PRODUCT VALUES ('PA-PO-04','PATISSERIE','Eclair','<image src="./assets/img/candies/Eclair.png">Eclair, the one and only');
INSERT INTO PRODUCT VALUES ('GE-PO-02','GELIFIE','Fraises','<image src="./assets/img/candies/Fraises.png">Fraises. Gelifiées');
INSERT INTO PRODUCT VALUES ('GE-PO-04','GELIFIE','Fraises tagada','<image src="./assets/img/candies/FraisesTagada.png">Fraises tagada, en sachet de beaucoup');
INSERT INTO PRODUCT VALUES ('PA-PO-05','PATISSERIE','Frozen Yogurt','<image src="./assets/img/candies/FrozenYogurt.png">Frozen Yogurt, the one and only');
INSERT INTO PRODUCT VALUES ('PA-PO-06','PATISSERIE','Ginger Bread','<image src="./assets/img/candies/Gingerbread.png">Ginger Bread, the one and only');
INSERT INTO PRODUCT VALUES ('BO-PO-02','BONBON','Guimauve fondante','<image src="./assets/img/candies/GuimauveFondante.png">Guimauve fondante, ourson');
INSERT INTO PRODUCT VALUES ('GE-PO-15','GELIFIE','Oursons','<image src="./assets/img/candies/GummyBears.png">Oursons');
INSERT INTO PRODUCT VALUES ('PA-PO-07','PATISSERIE','Honeycomb','<image src="./assets/img/candies/Honeycomb.png">Honeycomb, the one and only');
INSERT INTO PRODUCT VALUES ('PA-PO-08','PATISSERIE','Icecream Sandwich','<image src="./assets/img/candies/IceCreamSandwich.png">Icecream Sandwich, the one and only');
INSERT INTO PRODUCT VALUES ('GE-PO-05','GELIFIE','Jelly Bean','<image src="./assets/img/candies/JellyBeans.png">Jelly Bean, the one and only');
INSERT INTO PRODUCT VALUES ('SU-PO-02','SUCETTE','Lollies Up','<image src="./assets/img/candies/LolliesUp.png">Sucettes Lollies Up');
INSERT INTO PRODUCT VALUES ('BO-PO-03','BONBON','Malabar','<image src="./assets/img/candies/MalabarOriginal.png">Malabar, version originale');
INSERT INTO PRODUCT VALUES ('BO-PO-14','BONBON','Michoko','<image src="./assets/img/candies/Michoko.png">Michoko, de la pie qui chante');
INSERT INTO PRODUCT VALUES ('GE-PO-06','GELIFIE','Oeuf au plat','<image src="./assets/img/candies/OeufPlat.png">Oeuf au plat');
INSERT INTO PRODUCT VALUES ('BO-PO-04','BONBON','Pates de fruit','<image src="./assets/img/candies/PatesFruit.png">Pates de fruit, parfums variés');
INSERT INTO PRODUCT VALUES ('BO-PO-05','BONBON','Pierrot Gourmant','<image src="./assets/img/candies/PierrotGourmand.png">Pierrot Gourmand');
INSERT INTO PRODUCT VALUES ('PA-PO-09','PATISSERIE','Pomme d''amour','<image src="./assets/img/candies/PommeAmour.png">Pomme d''amour avec un grand A');
INSERT INTO PRODUCT VALUES ('RE-PO-02','REGLISSE','Reglisses','<image src="./assets/img/candies/ReglisseCouleur.png">Rélglisse multi-couleur');
INSERT INTO PRODUCT VALUES ('RE-PO-03','REGLISSE','Reglisse en rouleau','<image src="./assets/img/candies/Rotella.png">Rouleau de réglisse');
INSERT INTO PRODUCT VALUES ('SU-PO-03','SUCETTE','Roudoudou','<image src="./assets/img/candies/Roudoudou.png">Roudoudou, le vrai, l''unique');
INSERT INTO PRODUCT VALUES ('GE-PO-07','GELIFIE','Schtroumpfs','<image src="./assets/img/candies/Schtroumpfs.png">Schtroumpfs, grand et petits');
INSERT INTO PRODUCT VALUES ('CH-PO-02','CHOCOLAT','Smarties','<image src="./assets/img/candies/Smarties.png">Smarties, de toutes les couleurs. Sauf noir');
INSERT INTO PRODUCT VALUES ('SU-PO-04','SUCETTE','Sucettes anciennes','<image src="./assets/img/candies/SucettesAnciennes.png">Sucettes de fête foraine');
INSERT INTO PRODUCT VALUES ('SU-PO-05','SUCETTE','Sucette sifflet','<image src="./assets/img/candies/SucettesSifflet.png">Deux en un, sucettes et sifflet');
INSERT INTO PRODUCT VALUES ('CA-PO-02','CARAMEL','Werthers','<image src="./assets/img/candies/WerthersOriginal.png">Werthers. Enough said');
INSERT INTO PRODUCT VALUES ('AC-CB-01','ACIDULE','Cola Bizz','<image src="./assets/img/candies/ColaBizz.png">Bouteilles de cola');
INSERT INTO PRODUCT VALUES ('AC-SB-02','ACIDULE','Collier','<image src="./assets/img/candies/Collier.png">Collier à croquer');
INSERT INTO SUPPLIER VALUES (1,'iCandy','AC','1200 Addicted Street','','San Francisco','CA','94024','415-427-1999');
INSERT INTO SUPPLIER VALUES (2,'Le Bonbon','AC','13, rue des confiseries','','Paris','','75008','01-45-92-22-34');
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-1','CH-SW-01',2.40,1.90,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-2','AC-SW-02',4.90,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-3','RE-FW-01',3.20,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-4','BO-FW-02',4.90,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-5','CH-BD-01',2.90,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-6','AC-DL-01',1.40,1.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-7','CA-RT-01',1.90,1.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-8','CA-RT-02',3.40,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-9','AC-CW-01',4.30,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-10','GE-SN-01',2.90,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-11','CH-LI-02',2.30,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-12','CH-DSH-01',3.50,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-13','SU-DLH-02',3.10,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-14','AC-CB-01',3.20,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-15','AC-SB-02',4.00,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-16','PA-PO-02',3.99,2.00,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-17','GE-PO-03',2.90,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-18','BO-PO-03',3.90,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-19','PA-PO-03',3.49,2.99,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-20','AC-PO-03',4.80,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-21','PA-PO-04',2.95,2.10,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-22','GE-PO-02',2.80,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-23','GE-PO-04',4.30,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-24','PA-PO-05',3.95,2.99,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-25','PA-PO-06',2.45,1.99,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-26','BO-PO-02',2.70,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-27','GE-PO-15',4.70,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-28','PA-PO-07',3.95,3.49,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-29','PA-PO-08',3.99,1.99,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-30','GE-PO-05',1.49,0.99,2);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-31','SU-PO-02',4.80,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-32','BO-PO-03',2.90,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-33','BO-PO-14',3.10,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-34','GE-PO-06',4.20,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-35','BO-PO-04',3.90,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-36','BO-PO-05',3.00,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-37','PA-PO-09',3.90,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-38','RE-PO-02',3.60,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-39','RE-PO-03',2.60,2.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-40','SU-PO-03',3.90,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-41','GE-PO-07',4.80,4.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-42','CH-PO-02',3.20,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-43','SU-PO-04',3.90,3.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-44','SU-PO-05',1.60,1.00,1);
INSERT INTO ITEM (ITEM_ID, PRODUCT_ID, LIST_PRICE, UNIT_COST, SUPPLIER) VALUES ('EST-45','CA-PO-02',2.60,2.00,1);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-1',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-2',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-3',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-4',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-5',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-6',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-7',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-8',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-9',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-10',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-11',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-12',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-13',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-14',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-15',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-16',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-17',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-18',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-19',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-20',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-21',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-22',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-23',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-24',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-25',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-26',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-27',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-28',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-29',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-30',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-31',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-32',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-33',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-34',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-35',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-36',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-37',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-38',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-39',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-40',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-41',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-42',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-43',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-44',10000);
INSERT INTO INVENTORY (ITEM_ID, QUANTITY ) VALUES ('EST-45',10000);