Yurttas/PL/DBL/mssql/F/01/SPJ/I-all.sql

  1/*
  2REM
  3REM I-all.sql
  4REM
  5REM Insert into yurttas-SPJ database tables.
  6REM
  7*/
  8
  9
 10/*
 11REM
 12REM
 13REM Suppliers-ins.sql
 14REM
 15REM
 16*/
 17
 18INSERT INTO Suppliers
 19  VALUES('S01', 'Frank', 20, 'Houston');  
 20 
 21INSERT INTO Suppliers
 22  VALUES('S02', 'David', 20, 'Houston'); 
 23
 24INSERT INTO Suppliers
 25  VALUES('S03', 'David', 30, 'Houston'); 
 26
 27INSERT INTO Suppliers
 28  VALUES('S04', 'Jason', 10, 'Denver');
 29
 30INSERT INTO Suppliers
 31  VALUES('S05', 'Richard', 30, 'Denver');
 32
 33 INSERT INTO Suppliers
 34  VALUES('S06', 'Carlos', 20, 'Phoenix');
 35
 36INSERT INTO Suppliers
 37  VALUES('S07', 'John', 40, 'Phoenix');
 38
 39INSERT INTO Suppliers
 40  VALUES('S08', 'Ajay', 30, 'Detroit');
 41
 42
 43/*
 44REM
 45REM
 46REM Parts-ins.sql
 47REM
 48REM
 49*/
 50
 51INSERT INTO Parts
 52  VALUES('P01', 'Nut', 'Red', 12, 'Houston');
 53
 54INSERT INTO Parts
 55  VALUES('P02', 'Nut', 'Blue', 18, 'Phoenix');
 56
 57INSERT INTO Parts
 58  VALUES('P03', 'Cam', 'Blue', 22, 'Phoenix');
 59
 60INSERT INTO Parts
 61  VALUES('P04', 'Cam', 'Red', 45, 'Atlanta');
 62
 63INSERT INTO Parts
 64  VALUES('P05', 'Cam', 'Red', 18, 'Phoenix');
 65
 66INSERT INTO Parts
 67  VALUES('P06', 'Cam', 'Yellow', 19, 'Phoenix');
 68
 69INSERT INTO Parts
 70  VALUES('P07', 'Cog', 'Red', 59, 'Houston');
 71
 72INSERT INTO Parts
 73  VALUES('P08', 'Cog', 'Red', 46, 'Houston');
 74
 75INSERT INTO Parts
 76  VALUES('P09', 'Nut', 'Red', 22, 'Phoenix');
 77
 78INSERT INTO Parts
 79  VALUES('P10', 'Nut', 'Yellow', 59, 'Houston');
 80
 81INSERT INTO Parts
 82  VALUES('P11', 'Cam', 'Blue', 17, 'Atlanta');
 83
 84INSERT INTO Parts
 85  VALUES('P12', 'Cog', 'Blue', 24, 'Atlanta');
 86
 87
 88/*
 89REM
 90REM
 91REM Projects-ins.sql
 92REM
 93REM
 94*/
 95
 96INSERT INTO Projects
 97  VALUES('J01', 'Monitor', 'Boston');
 98
 99INSERT INTO Projects
100  VALUES('J02', 'Monitor', 'Portland');
101
102INSERT INTO Projects
103  VALUES('J03', 'Monitor', 'Denver');
104
105INSERT INTO Projects
106  VALUES('J04', 'Monitor', 'Houston');
107
108INSERT INTO Projects
109  VALUES('J05', 'Monitor', 'Dallas');
110
111INSERT INTO Projects
112  VALUES('J06', 'Monitor', 'Phoenix');
113
114INSERT INTO Projects
115  VALUES('J07', 'Monitor', 'Detroit');
116
117INSERT INTO Projects
118  VALUES('J08', 'Monitor', 'New York');
119
120INSERT INTO Projects
121  VALUES('J09', 'Monitor', 'Philadelphia');
122
123INSERT INTO Projects
124  VALUES('J10', 'CD-ROM', 'Boston');
125
126INSERT INTO Projects
127  VALUES('J11', 'CD-ROM', 'Houston');
128
129INSERT INTO Projects
130  VALUES('J12', 'CD-ROM', 'Dallas');
131
132INSERT INTO Projects
133  VALUES('J13', 'CD-ROM', 'New York');
134
135INSERT INTO Projects
136  VALUES('J14', 'CD-ROM', 'Portland');
137
138
139/*
140REM
141REM
142REM Shipments-ins.sql
143REM
144REM
145*/
146
147INSERT INTO Shipments
148  VALUES('S01', 'P01', 'J01', 100);
149
150INSERT INTO Shipments
151  VALUES('S01', 'P01', 'J03', 200);
152
153INSERT INTO Shipments  
154  VALUES('S01', 'P01', 'J04', 200);
155
156INSERT INTO Shipments 
157  VALUES('S01', 'P01', 'J07', 200);
158
159INSERT INTO Shipments 
160  VALUES('S01', 'P01', 'J08', 400);
161
162INSERT INTO Shipments
163  VALUES('S01', 'P01', 'J09', 300);
164
165INSERT INTO Shipments 
166  VALUES('S01', 'P01', 'J10', 200);
167
168INSERT INTO Shipments
169  VALUES('S01', 'P02', 'J01', 200);
170
171INSERT INTO Shipments
172  VALUES('S01', 'P02', 'J02', 400);
173
174INSERT INTO Shipments
175  VALUES('S01', 'P03', 'J01', 200);
176
177INSERT INTO Shipments
178  VALUES('S01', 'P05', 'J02', 100);
179
180INSERT INTO Shipments
181  VALUES('S01', 'P06', 'J10', 100);
182
183INSERT INTO Shipments
184  VALUES('S02', 'P01', 'J01', 200);
185
186INSERT INTO Shipments
187  VALUES('S02', 'P01', 'J02', 200);
188
189INSERT INTO Shipments
190  VALUES('S02', 'P02', 'J01', 300);
191
192INSERT INTO Shipments
193  VALUES('S02', 'P04', 'J01', 500);
194
195INSERT INTO Shipments
196  VALUES('S03', 'P01', 'J01', 100);
197
198INSERT INTO Shipments
199  VALUES('S03', 'P02', 'J01', 100);
200
201INSERT INTO Shipments
202  VALUES('S03', 'P02', 'J02', 200);
203
204INSERT INTO Shipments
205  VALUES('S03', 'P02', 'J03', 200);
206
207INSERT INTO Shipments
208  VALUES('S03', 'P02', 'J04', 200);
209
210INSERT INTO Shipments
211  VALUES('S03', 'P02', 'J05', 200);
212
213INSERT INTO Shipments
214  VALUES('S03', 'P02', 'J06', 100);
215
216INSERT INTO Shipments
217  VALUES('S03', 'P02', 'J07', 200);
218
219INSERT INTO Shipments
220  VALUES('S03', 'P02', 'J08', 400);
221
222INSERT INTO Shipments
223  VALUES('S03', 'P02', 'J09', 300);
224
225INSERT INTO Shipments
226  VALUES('S03', 'P02', 'J10', 200);
227
228INSERT INTO Shipments
229  VALUES('S03', 'P02', 'J11', 200);
230
231INSERT INTO Shipments
232  VALUES('S04', 'P02', 'J03', 200);
233
234INSERT INTO Shipments
235  VALUES('S05', 'P01', 'J01', 200);
236
237INSERT INTO Shipments
238  VALUES('S05', 'P06', 'J04', 200);
239
240INSERT INTO Shipments
241  VALUES('S05', 'P07', 'J04', 200);
242
243INSERT INTO Shipments
244  VALUES('S06', 'P01', 'J04', 200);
245
246INSERT INTO Shipments
247  VALUES('S06', 'P01', 'J11', 200);
248
249INSERT INTO Shipments
250  VALUES('S07', 'P03', 'J02', 100);