· 8 years ago · Aug 01, 2018, 10:12 AM
1Undefined Errors preventing creation of tables
2#1005 - Can't create table './cbw222_inspections/Melons.frm' (errno: 150)
3
4LATEST FOREIGN KEY ERROR
5------------------------
6120305 12:33:51 Error in foreign key constraint of table temp/Melons:
7FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
8 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
9 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1:
10
11Cannot resolve table name close to:
12(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
13 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
14 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1
15
16DROP TABLE IF EXISTS `Customer`;
17CREATE TABLE `Customer` (
18
19 `CustomerID` INT UNSIGNED AUTO_INCREMENT,
20 `Customer_Number` VARCHAR(70),
21 `Customer_Name` VARCHAR(70),
22 `Website` VARCHAR(255),
23 `Logo` VARCHAR(100),
24
25 PRIMARY KEY(`CustomerID`)
26) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
27
28
29 DROP TABLE IF EXISTS `Reports`;
30 CREATE TABLE `Reports` (
31
32 `ReportID` INT UNSIGNED AUTO_INCREMENT,
33 `Role` VARCHAR(70),
34 `Region` VARCHAR(70),
35 `Inpection_Type` VARCHAR(70),
36 `CustomerID` INT UNSIGNED NOT NULL,
37 `Report_Date` DATE NOT NULL DEFAULT '0000-00-00',
38 `Order_Date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
39 `Customer_Name` VARCHAR(100),
40 `Customer_Division` VARCHAR(70),
41 `Memo` VARCHAR(255),
42 `Billing_Key` VARCHAR(70),
43
44 PRIMARY KEY(`ReportID`),
45 FOREIGN KEY (`CustomerID`) REFERENCES Customer(`CustomerID`) ON DELETE CASCADE ON UPDATE CASCADE
46 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
47
48 DROP TABLE IF EXISTS `Customer_Contact`;
49 CREATE TABLE `Customer_Contact` (
50
51 `ContactID` INT UNSIGNED AUTO_INCREMENT,
52 `CustomerID` INT UNSIGNED NOT NULL,
53 `Division` VARCHAR(100),
54 `Contact` VARCHAR(100),
55 `Address` VARCHAR(255),
56 `Phone` VARCHAR(100),
57 `Fax` VARCHAR(100),
58 `Email` VARCHAR(100),
59 `Mobile` VARCHAR(100),
60
61 PRIMARY KEY(`ContactID`),
62 CONSTRAINT FOREIGN KEY (`CustomerID`) REFERENCES Customer(`CustomerID`) ON DELETE CASCADE ON UPDATE CASCADE
63 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
64
65
66DROP TABLE IF EXISTS `Inspectors`;
67CREATE TABLE `Inspectors` (
68
69 `InspectorID` INT UNSIGNED AUTO_INCREMENT,
70 `Name` VARCHAR(70),
71 `Phone` VARCHAR(70),
72 `Address` VARCHAR(255),
73 `Email` VARCHAR(100),
74 `Fax` VARCHAR(70),
75
76 PRIMARY KEY(`InspectorID`)
77) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
78
79
80 DROP TABLE IF EXISTS `Lists`;
81 CREATE TABLE `Lists` (
82
83 `ListID` INT UNSIGNED AUTO_INCREMENT,
84 `Commodity` VARCHAR(70),
85 `Region` VARCHAR(70),
86 `Shipper` VARCHAR(100),
87 `Variety` VARCHAR(70),
88 `Style` VARCHAR(70),
89 `Label` VARCHAR(70),
90 `Pack_Date` DATE NOT NULL default '0000-00-00',
91 `Grower_Lot` VARCHAR(70),
92 `Berry_Size1` VARCHAR(5),
93 `Berry_Size2` VARCHAR(5),
94 `Berry_Size3` VARCHAR(5),
95 `Berry_Size4` VARCHAR(5),
96 `Bunch_Count1` VARCHAR(5),
97 `Bunch_Count2` VARCHAR(5),
98 `Color1` VARCHAR(15),
99 `Color2` VARCHAR(15),
100 `Rating` VARCHAR(25),
101 `InspectorID` INT UNSIGNED NOT NULL,
102 `Comments` VARCHAR(255),
103
104 PRIMARY KEY(`ListID`),
105 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
106 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
107
108
109 DROP TABLE IF EXISTS `Melons`;
110 CREATE TABLE `Melons` (
111
112 `MelonsID` INT UNSIGNED AUTO_INCREMENT,
113 `ReportID` INT UNSIGNED NOT NULL,
114 `ShipperID` INT UNSIGNED NOT NULL,
115 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
116 `PO` VARCHAR(15),
117 `Location` VARCHAR(75),
118 `InspectorID` INT UNSIGNED NOT NULL,
119 `Commodity` VARCHAR(25),
120 `Count` VARCHAR(20),
121 `Size` VARCHAR(20),
122 `Label` VARCHAR(100),
123 `Variety` VARCHAR(25),
124 `Pack_Date` DATE NOT NULL default '0000-00-00',
125 `Grower_Lot` VARCHAR(25),
126 `Color1` VARCHAR(15),
127 `Color2` VARCHAR(15),
128 `Ground_Color1` VARCHAR(15),
129 `Ground_Color2` VARCHAR(15),
130 `Texture1` VARCHAR(5),
131 `Texture2` VARCHAR(5),
132 `Scar1` VARCHAR(5),
133 `Scar2` VARCHAR(5),
134 `Solidity1` VARCHAR(5),
135 `Solidity2` VARCHAR(5),
136 `Cut1` VARCHAR(5),
137 `Cut2` VARCHAR(5),
138 `Sugar_Brix1` VARCHAR(5),
139 `Sugar_Brix2` VARCHAR(5),
140 `Rating` VARCHAR(35),
141 `Comments` VARCHAR(255),
142
143 PRIMARY KEY(`MelonsID`),
144 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
145 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
146 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
147 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
148
149 DROP TABLE IF EXISTS `Melon_Photos`;
150 CREATE TABLE `Melon_Photos` (
151
152 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
153 `MelonsID` INT UNSIGNED NOT NULL,
154 `Photo` VARCHAR(70),
155 `Caption` VARCHAR(255),
156 `Catalog` VARCHAR(50),
157
158 PRIMARY KEY(`MelonsID`),
159 FOREIGN KEY (`MelonsID`) REFERENCES Melons(`MelonsID`) ON DELETE CASCADE ON UPDATE CASCADE
160 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
161
162
163 DROP TABLE IF EXISTS `Table_Grapes`;
164 CREATE TABLE `Table_Grapes` (
165
166 `GrapeID` INT UNSIGNED AUTO_INCREMENT,
167 `ReportID` INT UNSIGNED NOT NULL,
168 `ShipperID` INT UNSIGNED NOT NULL,
169 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
170 `PO` VARCHAR(15),
171 `Location` VARCHAR(75),
172 `InspectorID` INT UNSIGNED NOT NULL,
173 `Commodity` VARCHAR(25),
174 `Pack_Type` VARCHAR(35),
175 `Count` VARCHAR(20),
176 `Label` VARCHAR(100),
177 `Variety` VARCHAR(25),
178 `Style` VARCHAR(35),
179 `Pack_Date` DATE NOT NULL default '0000-00-00',
180 `Grower_Lot` VARCHAR(25),
181 `Berry_Sizing1` VARCHAR(15),
182 `Berry_Sizing2` VARCHAR(15),
183 `Berry_Sizing3` VARCHAR(15),
184 `Berry_Sizing4` VARCHAR(15),
185 `Bunch_Count1` VARCHAR(15),
186 `Bunch_Count2` VARCHAR(15),
187 `Color1` VARCHAR(15),
188 `Color2` VARCHAR(15),
189 `Stem_Cond1` VARCHAR(15),
190 `Stem_Cond2` VARCHAR(15),
191 `Stem_Cond3` VARCHAR(15),
192 `Shatter1` VARCHAR(5),
193 `Shatter2` VARCHAR(5),
194 `Decay_Count1` VARCHAR(15),
195 `Decay_Count2` VARCHAR(15),
196 `Sugar_Brix1` VARCHAR(5),
197 `Sugar_Brix2` VARCHAR(5),
198 `Rating` VARCHAR(35),
199 `Comments` VARCHAR(255),
200
201 PRIMARY KEY(`GrapeID`),
202 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
203 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
204 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
205 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
206
207 DROP TABLE IF EXISTS `Grape_Photos`;
208 CREATE TABLE `Grape_Photos` (
209
210 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
211 `GrapeID` INT UNSIGNED NOT NULL,
212 `Photo` VARCHAR(70),
213 `Caption` VARCHAR(255),
214 `Catalog` VARCHAR(50),
215
216 PRIMARY KEY(`GrapeID`),
217 FOREIGN KEY (`GrapeID`) REFERENCES Grape(`GrapeID`) ON DELETE CASCADE ON UPDATE CASCADE
218 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
219
220
221 DROP TABLE IF EXISTS `Berries`;
222 CREATE TABLE `Berries` (
223
224 `BerryID` INT UNSIGNED AUTO_INCREMENT,
225 `ReportID` INT UNSIGNED NOT NULL,
226 `ShipperID` INT UNSIGNED NOT NULL,
227 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
228 `PO` VARCHAR(15),
229 `Location` VARCHAR(75),
230 `InspectorID` INT UNSIGNED NOT NULL,
231 `Commodity` VARCHAR(25),
232 `Count` VARCHAR(20),
233 `Size` VARCHAR(20),
234 `Label` VARCHAR(100),
235 `Variety` VARCHAR(25),
236 `Pack_Date` DATE NOT NULL default '0000-00-00',
237 `Grower_Lot` VARCHAR(25),
238 `Color1` VARCHAR(15),
239 `Color2` VARCHAR(15),
240 `Berry_Sizing1` VARCHAR(15),
241 `Berry_Sizing2` VARCHAR(15),
242 `Berry_Sizing3` VARCHAR(15),
243 `Berry_Sizing4` VARCHAR(15),
244 `Firmness1` VARCHAR(5),
245 `Firmness2` VARCHAR(5),
246 `Scar1` VARCHAR(5),
247 `Scar2` VARCHAR(5),
248 `Bruise_Count1` VARCHAR(5),
249 `Bruise_Count2` VARCHAR(5),
250 `Decay_Count1` VARCHAR(5),
251 `Decay_Count2` VARCHAR(5),
252 `Sugar_Brix1` VARCHAR(5),
253 `Sugar_Brix2` VARCHAR(5),
254 `Rating` VARCHAR(35),
255 `Comments` VARCHAR(255),
256
257 PRIMARY KEY(`BerryID`),
258 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
259 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
260 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
261 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
262
263 DROP TABLE IF EXISTS `Berries_Photos`;
264 CREATE TABLE `Berries_Photos` (
265
266 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
267 `BerryID` INT UNSIGNED NOT NULL,
268 `Photo` VARCHAR(70),
269 `Caption` VARCHAR(255),
270 `Catalog` VARCHAR(50),
271
272 PRIMARY KEY(`BerryID`),
273 FOREIGN KEY (`BerryID`) REFERENCES Berries(`BerryID`) ON DELETE CASCADE ON UPDATE CASCADE
274 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
275
276
277 DROP TABLE IF EXISTS `Citrus`;
278 CREATE TABLE `Citrus` (
279
280 `CitrusID` INT UNSIGNED AUTO_INCREMENT,
281 `ReportID` INT UNSIGNED NOT NULL,
282 `ShipperID` INT UNSIGNED NOT NULL,
283 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
284 `PO` VARCHAR(15),
285 `Location` VARCHAR(75),
286 `InspectorID` INT UNSIGNED NOT NULL,
287 `Commodity` VARCHAR(25),
288 `Count` VARCHAR(20),
289 `Size` VARCHAR(20),
290 `Label` VARCHAR(100),
291 `Variety` VARCHAR(25),
292 `Pack_Date` DATE NOT NULL default '0000-00-00',
293 `Grower_Lot` VARCHAR(25),
294 `Color1` VARCHAR(15),
295 `Color2` VARCHAR(15),
296 `Texture1` VARCHAR(15),
297 `Texture2` VARCHAR(15),
298 `Puff1` VARCHAR(15),
299 `Puff2` VARCHAR(15),
300 `Scar1` VARCHAR(5),
301 `Scar2` VARCHAR(5),
302 `Solidity1` VARCHAR(15),
303 `Solidity2` VARCHAR(15),
304 `Green1` VARCHAR(15),
305 `Green2` VARCHAR(15),
306 `Sugar_Brix1` VARCHAR(5),
307 `Sugar_Brix2` VARCHAR(5),
308 `Rating` VARCHAR(35),
309 `Comments` VARCHAR(255),
310
311 PRIMARY KEY(`CitrusID`),
312 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
313 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
314 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
315 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
316
317 DROP TABLE IF EXISTS `Citrus_Photos`;
318 CREATE TABLE `Citrus_Photos` (
319
320 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
321 `CitrusID` INT UNSIGNED NOT NULL,
322 `Photo` VARCHAR(70),
323 `Caption` VARCHAR(255),
324 `Catalog` VARCHAR(50),
325
326 PRIMARY KEY(`CitrusID`),
327 FOREIGN KEY (`CitrusID`) REFERENCES Citrus(`CitrusID`) ON DELETE CASCADE ON UPDATE CASCADE
328 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
329
330
331 DROP TABLE IF EXISTS `Tree_Fruit`;
332 CREATE TABLE `Tree_Fruit` (
333
334 `TreeID` INT UNSIGNED AUTO_INCREMENT,
335 `ReportID` INT UNSIGNED NOT NULL,
336 `ShipperID` INT UNSIGNED NOT NULL,
337 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
338 `PO` VARCHAR(15),
339 `Location` VARCHAR(75),
340 `InspectorID` INT UNSIGNED NOT NULL,
341 `Commodity` VARCHAR(25),
342 `Count` VARCHAR(20),
343 `Size` VARCHAR(20),
344 `Label` VARCHAR(100),
345 `Variety` VARCHAR(25),
346 `Pack_Date` DATE NOT NULL default '0000-00-00',
347 `Grower_Lot` VARCHAR(25),
348 `Color1` VARCHAR(15),
349 `Color2` VARCHAR(15),
350 `Ground_Color1` VARCHAR(15),
351 `Ground_Color2` VARCHAR(15),
352 `Solidity1` VARCHAR(15),
353 `Solidity2` VARCHAR(15),
354 `Scar1` VARCHAR(5),
355 `Scar2` VARCHAR(5),
356 `Bruise_Count1` VARCHAR(5),
357 `Bruise_Count2` VARCHAR(5),
358 `Decay_Count1` VARCHAR(5),
359 `Decay_Count2` VARCHAR(5),
360 `Sugar_Brix1` VARCHAR(5),
361 `Sugar_Brix2` VARCHAR(5),
362 `Rating` VARCHAR(35),
363 `Comments` VARCHAR(255),
364
365 PRIMARY KEY(`TreeID`),
366 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
367 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
368 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
369 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
370
371 DROP TABLE IF EXISTS `Tree_Fruit_Photos`;
372 CREATE TABLE `Tree_Fruit_Photos` (
373
374 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
375 `TreeID` INT UNSIGNED NOT NULL,
376 `Photo` VARCHAR(70),
377 `Caption` VARCHAR(255),
378 `Catalog` VARCHAR(50),
379
380 PRIMARY KEY(`TreeID`),
381 FOREIGN KEY (`TreeID`) REFERENCES Tree_Fruit(`TreeID`) ON DELETE CASCADE ON UPDATE CASCADE
382 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
383
384
385 DROP TABLE IF EXISTS `Lot`;
386 CREATE TABLE `Lot` (
387
388 `LotID` INT UNSIGNED AUTO_INCREMENT,
389 `ReportID` INT UNSIGNED NOT NULL,
390 `ShipperID` INT UNSIGNED NOT NULL,
391 `Status` ENUM('0','1','2') NOT NULL DEFAULT 0,
392 `PO` VARCHAR(15),
393 `Location` VARCHAR(75),
394 `InspectorID` INT UNSIGNED NOT NULL,
395 `Commodity` VARCHAR(25),
396 `Pack_Type` VARCHAR(35),
397 `Count` VARCHAR(20),
398 `Label` VARCHAR(100),
399 `Variety` VARCHAR(25),
400 `Style` VARCHAR(35),
401 `Pack_Date` DATE NOT NULL default '0000-00-00',
402 `Grower_Lot` VARCHAR(25),
403 `Berry_Sizing1` VARCHAR(15),
404 `Berry_Sizing2` VARCHAR(15),
405 `Berry_Sizing3` VARCHAR(15),
406 `Berry_Sizing4` VARCHAR(15),
407 `Bunch_Count1` VARCHAR(15),
408 `Bunch_Count2` VARCHAR(15),
409 `Color1` VARCHAR(15),
410 `Color2` VARCHAR(15),
411 `Stem_Cond1` VARCHAR(15),
412 `Stem_Cond2` VARCHAR(15),
413 `Stem_Cond3` VARCHAR(15),
414 `Shatter1` VARCHAR(5),
415 `Shatter2` VARCHAR(5),
416 `Splits1` VARCHAR(5),
417 `Splits2` VARCHAR(5),
418 `Decay_Count1` VARCHAR(15),
419 `Decay_Count2` VARCHAR(15),
420 `Wet_Sticky1` VARCHAR(15),
421 `Wet_Sticky2` VARCHAR(15),
422 `Overall_Quality` VARCHAR(25),
423 `Sugar_Brix1` VARCHAR(5),
424 `Sugar_Brix2` VARCHAR(5),
425 `Overall_Condition` VARCHAR(25),
426 `Rating` VARCHAR(35),
427 `Comments` VARCHAR(255),
428
429 PRIMARY KEY(`LotID`),
430 FOREIGN KEY (`ReportID`) REFERENCES Reports(`ReportID`) ON DELETE CASCADE ON UPDATE CASCADE,
431 FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE,
432 FOREIGN KEY (`InspectorID`) REFERENCES Inspectors(`InspectorID`) ON DELETE CASCADE ON UPDATE CASCADE
433 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
434
435 DROP TABLE IF EXISTS `Lot_Photos`;
436 CREATE TABLE `Lot_Photos` (
437
438 `PhotoID` INT UNSIGNED AUTO_INCREMENT,
439 `LotID` INT UNSIGNED NOT NULL,
440 `Photo` VARCHAR(70),
441 `Caption` VARCHAR(255),
442 `Catalog` VARCHAR(50),
443
444 PRIMARY KEY(`LotID`),
445 FOREIGN KEY (`LotID`) REFERENCES Lot(`LotID`) ON DELETE CASCADE ON UPDATE CASCADE
446 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
447
448
449DROP TABLE IF EXISTS `Shipper`;
450CREATE TABLE `Shipper` (
451
452 `ShipperID` INT UNSIGNED AUTO_INCREMENT,
453 `Shipper_Name` VARCHAR(70),
454 `Shipper_Number` VARCHAR(70),
455 `Website` VARCHAR(255),
456
457 PRIMARY KEY(`ShipperID`)
458) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
459
460 DROP TABLE IF EXISTS `Shipper_Contact`;
461 CREATE TABLE `Shipper_Contact` (
462
463 `SContactID` INT UNSIGNED AUTO_INCREMENT,
464 `ShipperID` INT UNSIGNED NOT NULL,
465 `CustomerID` INT UNSIGNED NOT NULL,
466 `Division` VARCHAR(100),
467 `Contact` VARCHAR(100),
468 `Address` VARCHAR(255),
469 `Phone` VARCHAR(100),
470 `Fax` VARCHAR(100),
471 `Email` VARCHAR(100),
472 `Mobile` VARCHAR(100),
473
474 PRIMARY KEY(`SContactID`),
475 CONSTRAINT FOREIGN KEY (`CustomerID`) REFERENCES Customer(`CustomerID`) ON DELETE CASCADE ON UPDATE CASCADE,
476 CONSTRAINT FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE
477 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
478
479 DROP TABLE IF EXISTS `Shipper_Label`;
480 CREATE TABLE `Shipper_Label` (
481
482 `ShipperLabelID` INT UNSIGNED AUTO_INCREMENT,
483 `ShipperID` INT UNSIGNED NOT NULL,
484 `Shipper_Name` VARCHAR(70),
485 `Shipper_Label` VARCHAR(255),
486
487 PRIMARY KEY(`ShipperLabelID`),
488 CONSTRAINT FOREIGN KEY (`ShipperID`) REFERENCES Shipper(`ShipperID`) ON DELETE CASCADE ON UPDATE CASCADE
489 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
490
491SET FOREIGN_KEY_CHECKS = 0;