59UkmkrJ

1drop database if exists `Georgia_PPE_Management`;
2create database `Georgia_PPE_Management`;
3use `Georgia_PPE_Management`;
4
5
6drop table if exists product;
7create table product
8(P_id Char(5) NOT NULL, 
9color VarCHAR(15) NOT NULL,
10P_type VarCHAR(20) NOT NULL,
11PRIMARY KEY (P_id),
12CONSTRAINT P_Name UNIQUE(color, p_type));
13
14drop table if exists business;
15create table business
16(B_Name varchar(100) NOT NULL,
17Street VarChar(30),
18City VarChar(20),
19State VarChar(20),
20Zip Char(5),
21Primary Key (B_Name),
22CONSTRAINT address UNIQUE (street, city, state, zip));
23
24drop table if exists doctor;
25create table doctor
26(Username varchar(40) NOT NULL,
27Fname varchar(20) NOT NULL,
28Lname varchar(20) NOT NULL,
29APassword varchar(20) NOT NULL,
30Email varchar(50) NOT NULL,
31H_Name varchar(100) NOT NULL,
32Manager varchar(40),
33primary key (username),
34foreign key (manager) REFERENCES doctor(username),
35foreign key (H_name) REFERENCES business(b_name),
36unique (email));
37
38drop table if exists Usage_log;
39create table Usage_Log
40(UL_id Char(5) NOT NULL,
41Time_stamp datetime NOT NULL,
42Doc_Name VARCHAR(25) NOT NULL,
43PRIMARY KEY (UL_id),
44FOREIGN KEY (Doc_Name) REFERENCES Doctor(Username));
45
46drop table if exists transactions;
47create table transactions
48(T_id Char(4) NOT NULL,
49Date_Accessed date NOT NULL,
50H_Name VarChar(100) NOT NULL,
51PRIMARY KEY (T_id),
52FOREIGN KEY (H_Name) REFERENCES Business(B_Name));
53
54drop table if exists inventory;
55create table inventory
56(B_name VarChar(100) NOT NULL,
57Street VarChar(30),
58City VarChar(20),
59State VarChar(20),
60Zip Char(5),
61Primary Key (B_name),
62Foreign key (B_name) REFERENCES Business(B_name),
63CONSTRAINT Address UNIQUE (Street, City, State, Zip));
64
65drop table if exists catalog_item;
66create table catalog_item
67(P_id Char(5) NOT NULL,
68M_Name Varchar(100) NOT NULL,
69Price decimal(6,2) NOT NULL,
70Primary Key (P_id, M_Name),
71Foreign Key (P_id) REFERENCES product(p_id),
72Foreign Key (M_name) REFERENCES business(b_name));
73
74drop table if exists hospital;
75create table hospital
76(H_name varchar(100) NOT NULL,
77Budget int(10) NOT NULL, 
78Max_Doctors int(3) NOT NULL,
79Primary Key (H_name),
80Foreign Key (H_name) REFERENCES business(B_name));
81
82drop table if exists manufacturer;
83create table manufacturer
84(M_name varchar(100) NOT NULL,
85Catalog_Capacity int(4) NOT NULL,
86Primary Key (M_Name),
87Foreign Key (M_Name) REFERENCES business(B_name));
88
89drop table if exists administrator;
90create table administrator
91(Username varchar(40) NOT NULL,
92Fname varchar(20) NOT NULL,
93Lname varchar(20) NOT NULL,
94APassword varchar(20) NOT NULL,
95Email varchar(50) NOT NULL,
96Manages varchar(100) NOT NULL,
97primary key (username),
98foreign key (manages) REFERENCES business(b_name),
99unique (email));
100
101drop table if exists has_product;
102create table has_product
103(product_id char(5) NOT NULL,
104inv_name varchar(100) NOT NULL,
105item_count int(6) NOT NULL,
106primary key (product_id, inv_name),
107foreign key (product_id) references product(p_id),
108foreign key (inv_name) references inventory(b_name));
109
110drop table if exists txncontains;
111create table txncontains
112(item_id char(5) NOT NULL,
113transaction_id char(4) NOT NULL,
114item_count int(6) NOT NULL,
115primary key (item_id),
116foreign key (item_id) references catalog_item(p_id),
117foreign key (transaction_id) references transactions(t_id));
118
119drop table if exists used;
120create table used
121(UL_id char(5) NOT NULL,
122P_Name char(5) NOT NULL,
123item_count int(5) NOT NULL,
124primary key (UL_id, P_Name),
125foreign key (UL_id) REFERENCES usage_log(UL_id),
126foreign key (P_Name) references product(P_id));
127
128-- INSERT DATA --
129insert into product
130values
131('WHMSK','white','mask'),
132('BLMSK','blue','mask'),
133('RDMSK','red','mask'),
134('GRMSK','green','mask'),
135('WHRES','white','respirator'),
136('YLRES','yellow','respirator'),
137('ORRES','orange','repirator'),
138('CLSHD','clear','shield'),
139('GRGOG','green','goggles'),
140('ORGOG','orange','goggles'),
141('WHGOG','white','goggles'),
142('BKGOG','black','goggles'),
143('BLSHC','blue','shoe cover'),
144('BLHOD','blue','hood'),
145('BLGWN','blue','gown'),
146('GRSHC','green','shoe cover'),
147('GRHOD','green','hood'),
148('GRGWN','green','gown'),
149('GYSHC','grey','shoe cover'),
150('GYHOD','grey','hood'),
151('GYGWN','grey','gown'),
152('WHSHC','white','shoe cover'),
153('WHHOD','white','hood'),
154('WHGWN','white','gown'),
155('BKSTE','black','stethoscope'),
156('WHSTE','white','stethoscope'),
157('SISTE','silver','stethoscope'),
158('BKGLO','black','gloves'),
159('WHGLO','white','gloves'),
160('GRGLO','green','gloves');
161
162insert into business
163values
164("Children's Healthcare of Atlanta",'Clifton Rd NE','Atlanta','Georgia','30332'),
165("Piedmont Hospital",'Peachtree Rd NW','Atlanta','Georgia','30309'),
166("Northside Hospital",'Johnson Ferry Road NE','Sandy Springs','Georgia','30342'),
167("Emory Midtown",'Peachtree St NE','Atlanta','Georgia','30308'),
168("Grady Hospital",'Jesse Hill Jr Dr SE','Atlanta','Georgia','30303'),
169("PPE Empire",'Ponce De Leon Ave','Atlanta','Georgia','30308'),
170("Buy Personal Protective Equipment, Inc",'Spring St','Atlanta','Georgia','30313'),
171("Healthcare Supplies of Atlanta",'Peachstree St','Atlanta','Georgia','30308'),
172("Georgia Tech Protection Lab",'North Ave NW','Atlanta','Georgia','30332'),
173("Marietta Mask Production Company",'Appletree Way','Marietta','Georgia','30061'),
174("S&J Corporation",'Juniper St','Atlanta','Georgia','30339');
175
176insert into hospital
177values
178("Children's Healthcare of Atlanta",80000,6),
179('Piedmont Hospital',95000,7),
180('Northside Hospital',72000,9),
181('Emory Midtown',120000,13),
182('Grady Hospital',81000,10);
183
184insert into manufacturer
185values
186('PPE Empire',20),
187("Buy Personal Protective Equipment, Inc",25),
188('Healthcare Supplies of Atlanta',20),
189('Georgia Tech Protection Lab',27),
190('Marietta Mask Production Company',15),
191('S&J Corporation',22);
192
193insert into doctor
194values
195('drCS4400','Computer','Science','30003000','cs4400@gatech.edu',"Children's Healthcare of Atlanta", NULL),
196('doctor_moss','Mark','Moss','12341234','mmoss7@gatech.edu','Piedmont Hospital', NULL),
197('drmcdaniel','Melinda','McDaniel','12345678','mcdaniel@cc.gatech.edu','Northside Hospital', NULL),
198('musaev_doc','Aibek','Musaev','87654321','aibek.musaev@gatech.edu','Emory Midtown', NULL),
199('doctor1','Doctor','One','10001000','doctor1@gatech.edu','Grady Hospital', NULL),
200('doctor2','Doctor','Two','20002000','doctor2@gatech.edu',"Children's Healthcare of Atlanta",'drCS4400'),
201('fantastic','Chris','Eccleston','99999999','ninth_doctor@gatech.edu','Piedmont Hospital','doctor_moss'),
202('allons_y','David','Tennant','10101010','tenth_doctor@gatech.edu','Northside Hospital','drmcdaniel'),
203('bow_ties_are_cool','Matt','Smith','11111111','eleventh_doctor@gatech.edu','Emory Midtown','musaev_doc'),
204('sonic_shades','Peter','Capaldi','12121212','twelfth_doctor@gatech.edu','Grady Hospital','doctor1'),
205('mcdreamy','Derek','Shepard','13311332','dr_shepard@gatech.edu',"Children's Healthcare of Atlanta",'drCS4400'),
206('grey_jr','Meredith','Shepard','87878787','dr_grey@gatech.edu','Piedmont Hospital','doctor_moss'),
207('young_doc','Doogie','Howser','80088008','howser@gatech.edu','Northside Hospital','drmcdaniel'),
208('dr_dolittle','John','Dolittle','37377373','dog_doc@gatech.edu','Emory Midtown','musaev_doc'),
209('bones','Leonard','McCoy','11223344','doctor_mccoy@gatech.edu','Grady Hospital','doctor1'),
210('doc_in_da_house','Gregory','House','30854124','tv_doctor@gatech.edu',"Children's Healthcare of Atlanta",'drCS4400'),
211('jekyll_not_hyde','Henry','Jekyll','56775213','jekyll1886@gatech.edu','Piedmont Hospital','doctor_moss'),
212('drake_remoray','Joey','Tribbiani','24598543','f_r_i_e_n_d_s@gatech.edu','Northside Hospital','drmcdaniel'),
213('Jones01','Johnes','Boys','52935481','jones01@gatech.edu','Emory Midtown','musaev_doc'),
214('hannah_hills','Hannah','Hills','13485102','managerEHH@gatech.edu','Grady Hospital','doctor1'),
215('henryjk','Henry','Kims','54238912','HenryJK@gatech.edu',"Children's Healthcare of Atlanta",'drCS4400'),
216('aziz_01','Amit','Aziz','90821348','ehh01@gatech.edu','Piedmont Hospital','doctor_moss'),
217('dr_mory','Jack','Mory','12093015','JackMM@gatech.edu','Northside Hospital','drmcdaniel'),
218('Burdell','George','Burdell','12345678','GeorgeBurdell@gatech.edu','Northside Hospital','drmcdaniel'),
219('Buzz','Buzz','Tech','98765432','THWG@gatech.edu','Piedmont Hospital','doctor_moss');
220
221insert into usage_log
222values
223('10000','2020-6-11 16:30:00','fantastic'),
224('10001','2020-6-11 17:00:00','jekyll_not_hyde'),
225('10002','2020-6-11 17:03:00','young_doc'),
226('10003','2020-6-12 8:23:00','fantastic'),
227('10004','2020-6-12 8:42:00','hannah_hills'),
228('10005','2020-6-12 9:00:00','mcdreamy'),
229('10006','2020-6-12 9:43:00','fantastic'),
230('10007','2020-6-12 10:11:00','doctor1'),
231('10008','2020-6-12 10:12:00','Jones01'),
232('10009','2020-6-12 10:23:00','henryjk'),
233('10010','2020-6-12 10:32:00','bones'),
234('10011','2020-6-12 11:00:00','dr_dolittle'),
235('10012','2020-6-12 11:14:00','drake_remoray'),
236('10013','2020-6-12 12:11:00','allons_y'),
237('10014','2020-6-12 13:23:00','dr_mory'),
238('10015','2020-6-12 13:52:00','Jones01');
239
240insert into transactions
241values
242("0001", "2020-3-10", "Children’s Healthcare of Atlanta"),
243("0002", "2020-3-10", "Children’s Healthcare of Atlanta"),
244("0003", "2020-3-10", "Emory Midtown"),
245("0004", "2020-3-10", "Grady Hospital"),
246("0005", "2020-3-10", "Northside Hospital"),
247("0006", "2020-3-10", "Emory Midtown"),
248("0007", "2020-3-10", "Piedmont Hospital"),
249("0008", "2020-5-01", "Northside Hospital"),
250("0009", "2020-5-01", "Children's Healthcare of Atlanta"),
251("0010", "2020-5-01", "Northside Hospital"),
252("0011", "2020-5-01", "Northside Hospital"),
253("0012", "2020-5-25", "Emory Midtown"),
254("0013", "2020-5-25", "Children's Healthcare of Atlanta"),
255("0014", "2020-5-25", "Emory Midtown"),
256("0015", "2020-5-25", "Emory Midtown"),
257("0016", "2020-5-25", "Northside Hospital"),
258("0017", "2020-6-03", "Grady Hospital"),
259("0018", "2020-6-03", "Grady Hospital"),
260("0019", "2020-6-03", "Grady Hospital"),
261("0020", "2020-6-03", "Piedmont Hospital"),
262("0021", "2020-6-04", "Piedmont Hospital");
263
264insert into inventory
265values
266("Children's Healthcare of Atlanta","Storage St","Atlanta","Georgia","30309"),
267("Piedmont Hospital","Warehouse Way","Atlanta","Georgia","30332"),
268("Northside Hospital","Depot Dr","Dunwoody","Georgia","30338"),
269("Emory Midtown","Inventory Ct","Atlanta","Georgia","30308"),
270("Grady Hospital","Storehouse Pkwy","Atlanta","Georgia","30313"),
271("PPE Empire","Cache Ct","Lawrenceville","Georgia","30043"),
272("Buy Personal Protective Equipment, Inc","Stockpile St",	"Decatur",	"Georgia","30030"),
273("Healthcare Supplies of Atlanta","Depository Dr","Atlanta","Georgia","30303"),
274("Georgia Tech Protection Lab","Storehouse St","Atlanta","Georgia","30332"),
275("Marietta Mask Production Company","Repository Way","Marietta","Georgia","30008"),
276("S&J Corporation","Stash St","Suwanee","Georgia","30024");
277
278insert into catalog_item
279values
280('WHMSK','PPE Empire',1.25),
281('BLMSK','PPE Empire',1.35),
282('RDMSK','PPE Empire',1.30),
283('GRMSK','PPE Empire',1.45),
284('WHRES','PPE Empire',4.80),
285('YLRES','PPE Empire',5.10),
286('ORRES','PPE Empire',4.50),
287('BLSHC',"Buy Personal Protective Equipment, Inc",0.90),
288('BLHOD',"Buy Personal Protective Equipment, Inc",2.10),
289('BLGWN',"Buy Personal Protective Equipment, Inc",3.15),
290('GRSHC',"Buy Personal Protective Equipment, Inc",0.90),
291('GRHOD',"Buy Personal Protective Equipment, Inc",2.10),
292('GRGWN',"Buy Personal Protective Equipment, Inc",3.15),
293('GYSHC',"Buy Personal Protective Equipment, Inc",0.90),
294('GYHOD',"Buy Personal Protective Equipment, Inc",2.10),
295('GYGWN',"Buy Personal Protective Equipment, Inc",3.15),
296('WHSHC',"Buy Personal Protective Equipment, Inc",0.90),
297('WHHOD',"Buy Personal Protective Equipment, Inc",2.10),
298('WHGWN',"Buy Personal Protective Equipment, Inc",3.15),
299('ORGOG','Healthcare Supplies of Atlanta',3.00),
300('RDMSK','Healthcare Supplies of Atlanta',1.45),
301('CLSHD','Healthcare Supplies of Atlanta',6.05),
302('BLSHC','Healthcare Supplies of Atlanta',1.00),
303('BLHOD','Healthcare Supplies of Atlanta',2.00),
304('BLGWN','Healthcare Supplies of Atlanta',3.00),
305('YLRES','Healthcare Supplies of Atlanta',5.50),
306('WHMSK','Healthcare Supplies of Atlanta',1.10),
307('BLMSK','Healthcare Supplies of Atlanta',1.05),
308('CLSHD','Georgia Tech Protection Lab',5.95),
309('ORGOG','Georgia Tech Protection Lab',3.20),
310('WHGOG','Georgia Tech Protection Lab',3.20),
311('BKGOG','Georgia Tech Protection Lab',3.20),
312('GYSHC','Georgia Tech Protection Lab',0.75),
313('GYHOD','Georgia Tech Protection Lab',1.80),
314('GYGWN','Georgia Tech Protection Lab',3.25),
315('GRSHC','Marietta Mask Production Company',0.80),
316('GRHOD','Marietta Mask Production Company',1.65),
317('GRGWN','Marietta Mask Production Company',2.95),
318('GRMSK','Marietta Mask Production Company',1.25),
319('GRGOG','Marietta Mask Production Company',3.25),
320('BKSTE','S&J Corporation',5.20),
321('WHSTE','S&J Corporation',5.00),
322('SISTE','S&J Corporation',5.10),
323('BKGLO','S&J Corporation',0.30),
324('WHGLO','S&J Corporation',0.30),
325('GRGLO','S&J Corporation',0.30);
326
327insert into administrator
328values
329('ppee_admin','Admin','One','27536292','ppee_admin@gatech.edu','PPE Empire'),
330('bppe_admin','Admin','Two','35045790','bppe_admin@gatech.edu',"Buy Personal Protective Equipment, Inc"),
331('hsa_admin','Jennifer','Tree','75733271','hsa_admin@gatech.edu','Healthcare Supplies of Atlanta'),
332('gtpl_admin','Shaundra','Apple','14506524','gtpl_admin@gatech.edu','Georgia Tech Protection Lab'),
333('mmpc_admin','Nicholas','Cage','22193897','mmpc_admin@gatech.edu','Marietta Mask Production Company'),
334('sjc_admin','Trey','Germs','74454118','sjc_admin@gatech.edu','S&J Corporation'),
335('choa_admin','Addison','Ambulance','62469488','choa_admin@gatech.edu',"Children's Healthcare of Atlanta"),
336('piedmont_admin','Rohan','Right','36846830','piedmont_admin@gatech.edu','Piedmont Hospital'),
337('northside_admin','Johnathan','Smith','38613312','northside_admin@gatech.edu','Northside Hospital'),
338('emory_admin','Elizabeth','Tucker','33202257','emory_admin@gatech.edu','Emory Midtown'),
339('grady_admin','Taylor','Booker','67181125','grady_admin@gatech.edu','Grady Hospital'),
340('Burdell','George','Burdell','12345678','GeorgeBurdell@gatech.edu','Northside Hospital'),
341('Buzz','Buzz','Tech','98765432','THWG@gatech.edu','Piedmont Hospital');
342
343insert into has_product
344values
345('WHMSK',"Children's Healthcare of Atlanta",5),
346('BLMSK',"Children's Healthcare of Atlanta",220),
347('WHRES',"Children's Healthcare of Atlanta",280),
348('CLSHD',"Children's Healthcare of Atlanta",100),
349('GRGOG',"Children's Healthcare of Atlanta",780),
350('ORGOG',"Children's Healthcare of Atlanta",100),
351('BLSHC',"Children's Healthcare of Atlanta",460),
352('BLHOD',"Children's Healthcare of Atlanta",100),
353('BLGWN',"Children's Healthcare of Atlanta",80),
354('GRSHC',"Children's Healthcare of Atlanta",5),
355('WHSTE',"Children's Healthcare of Atlanta",330),
356('BKGLO',"Children's Healthcare of Atlanta",410),
357('BLSHC','Piedmont Hospital',3000),
358('BLHOD','Piedmont Hospital',3000),
359('BLGWN','Piedmont Hospital',420),
360('GRSHC','Piedmont Hospital',740),
361('GRHOD','Piedmont Hospital',560),
362('GRGWN','Piedmont Hospital',840),
363('SISTE','Piedmont Hospital',460),
364('BKGLO','Piedmont Hospital',4210),
365('WHRES','Northside Hospital',110),
366('YLRES','Northside Hospital',170),
367('ORRES','Northside Hospital',350),
368('CLSHD','Northside Hospital',410),
369('GRGOG','Northside Hospital',1),
370('ORGOG','Northside Hospital',100),
371('WHMSK','Emory Midtown',80),
372('BLMSK','Emory Midtown',210),
373('RDMSK','Emory Midtown',320),
374('GRMSK','Emory Midtown',40),
375('WHRES','Emory Midtown',760),
376('YLRES','Emory Midtown',140),
377('ORRES','Emory Midtown',20),
378('CLSHD','Emory Midtown',50),
379('GRGOG','Emory Midtown',70),
380('ORGOG','Emory Midtown',320),
381('WHGOG','Emory Midtown',140),
382('BKGOG','Emory Midtown',210),
383('BLSHC','Emory Midtown',630),
384('BLHOD','Grady Hospital',970),
385('BLGWN','Grady Hospital',310),
386('GRSHC','Grady Hospital',340),
387('GRHOD','Grady Hospital',570),
388('GRGWN','Grady Hospital',10),
389('GYSHC','Grady Hospital',20),
390('GYHOD','Grady Hospital',280),
391('GYGWN','Grady Hospital',240),
392('WHSHC','Grady Hospital',180),
393('WHHOD','Grady Hospital',140),
394('WHGWN','Grady Hospital',150),
395('BKSTE','Grady Hospital',210),
396('WHSTE','Grady Hospital',170),
397('SISTE','Grady Hospital',180),
398('BKGLO','Grady Hospital',70),
399('WHGLO','Grady Hospital',140),
400('GRGLO','Grady Hospital',80),
401('WHMSK','PPE Empire',850),
402('BLMSK','PPE Empire',1320),
403('RDMSK','PPE Empire',540),
404('GRMSK','PPE Empire',870),
405('WHRES','PPE Empire',500),
406('ORRES','PPE Empire',320),
407('BLSHC',"Buy Personal Protective Equipment, Inc",900),
408('BLGWN',"Buy Personal Protective Equipment, Inc",820),
409('GRSHC',"Buy Personal Protective Equipment, Inc",700),
410('GRHOD',"Buy Personal Protective Equipment, Inc",770),
411('GYSHC',"Buy Personal Protective Equipment, Inc",250),
412('GYHOD',"Buy Personal Protective Equipment, Inc",350),
413('GYGWN',"Buy Personal Protective Equipment, Inc",850),
414('WHSHC',"Buy Personal Protective Equipment, Inc",860),
415('WHHOD',"Buy Personal Protective Equipment, Inc",700),
416('WHGWN',"Buy Personal Protective Equipment, Inc",500),
417('ORGOG','Healthcare Supplies of Atlanta',860),
418('RDMSK','Healthcare Supplies of Atlanta',370),
419('CLSHD','Healthcare Supplies of Atlanta',990),
420('BLSHC','Healthcare Supplies of Atlanta',1370),
421('BLHOD','Healthcare Supplies of Atlanta',210),
422('BLGWN','Healthcare Supplies of Atlanta',680),
423('YLRES','Healthcare Supplies of Atlanta',890),
424('WHMSK','Healthcare Supplies of Atlanta',980),
425('BLMSK','Healthcare Supplies of Atlanta',5000),
426('CLSHD','Georgia Tech Protection Lab',620),
427('ORGOG','Georgia Tech Protection Lab',970),
428('WHGOG','Georgia Tech Protection Lab',940),
429('BKGOG','Georgia Tech Protection Lab',840),
430('GYSHC','Georgia Tech Protection Lab',610),
431('GYHOD','Georgia Tech Protection Lab',940),
432('GYGWN','Georgia Tech Protection Lab',700),
433('GRSHC','Marietta Mask Production Company',970),
434('GRHOD','Marietta Mask Production Company',750),
435('GRMSK','Marietta Mask Production Company',750),
436('GRGOG','Marietta Mask Production Company',320),
437('BKSTE','S&J Corporation',200),
438('WHSTE','S&J Corporation',860),
439('WHGLO','S&J Corporation',500),
440('GRGLO','S&J Corporation',420),
441('BKGLO','S&J Corporation',740);
442
443insert into txncontains
444values("WHMSK","1",500),
445("BLMSK","1",500),
446("BLSHC","2",300),
447("BLMSK","3",500),
448("ORGOG","4",150),
449("RDMSK",4,150),
450("CLSHD","4",200),
451("BLSHC","4",100),
452("WHMSK","5",300),
453("BLSHC","6",400),
454("GRMSK","7",100),
455("GRGOG","7",300),
456("ORGOG","8",200),
457("WHGOG","8",200),
458("GRSHC","9",500),
459("GRHOD","9",500),
460("WHGLO","10",500),
461("WHHOD","11",200),
462("WHGWN","11",200),
463("BLSHC","12",50),
464("BLHOD","13",100),
465("BLGWN","13",100),
466("WHRES","14",300),
467("YLRES","14",200),
468("ORRES","14",300),
469("GYGWN","15",50),
470("CLSHD","16",20),
471("ORGOG","16",300),
472("BLHOD","16",100),
473("RDMSK","17",200),
474("CLSHD","17",180),
475("WHHOD","18",500),
476("GYGWN","19",300),
477("BKSTE","20",50),
478("WHSTE","20",50),
479("CLSHD","21",100),
480("ORGOG","21",200);
481
482insert into used
483values
484('10000','GRMSK',3),
485('10000','GRGOG',3),
486('10000','WHSTE',1),
487('10001','GRMSK',5),
488('10001','BKSTE',1),
489('10002','WHMSK',4),
490('10003','CLSHD',2),
491('10003','ORGOG',1),
492('10003','GRMSK',2),
493('10003','GRGOG',1),
494('10003','BKSTE',1),
495('10004','ORGOG',2),
496('10004','RDMSK',4),
497('10004','CLSHD',2),
498('10004','BLSHC',4),
499('10005','WHMSK',4),
500('10005','BLMSK',4),
501('10005','BLSHC',8),
502('10006','GRMSK',2),
503('10007','RDMSK',3),
504('10007','CLSHD',3),
505('10008','BLMSK',5),
506('10009','GRSHC',4),
507('10009','GRHOD',4),
508('10009','WHMSK',4),
509('10010','RDMSK',3),
510('10010','BLSHC',3),
511('10011','BLMSK',8),
512('10012','ORGOG',1),
513('10012','WHGOG',1),
514('10012','WHGLO',2),
515('10013','WHHOD',2),
516('10014','WHGOG',2),
517('10014','WHGWN',2),
518('10015','BLMSK',4);