· 10 years ago · Jan 29, 2016, 07:21 PM
1
2-- -----------------------------------------------------
3-- Creates Table menzies.OUTLET
4-- -----------------------------------------------------
5CREATE TABLE IF NOT EXISTS menzies.OUTLET (
6 out_ID INT AUTO_INCREMENT NOT NULL,
7 out_name VARCHAR(45) NULL,
8 out_manager VARCHAR(45) NULL,
9 out_address VARCHAR(100) NULL,
10 out_phone VARCHAR(15) NULL,
11 out_email VARCHAR(45) NULL,
12 PRIMARY KEY (out_ID)
13);
14
15
16-- -----------------------------------------------------
17-- Creates Table menzies.ACCOUNT
18-- -----------------------------------------------------
19CREATE TABLE IF NOT EXISTS menzies.ACCOUNT (
20 acc_ID INT AUTO_INCREMENT NOT NULL,
21 acc_name VARCHAR(45) NOT NULL,
22 acc_manager VARCHAR(45) NOT NULL,
23 acc_balance VARCHAR(45) NOT NULL,
24 acc_transactionLimit INT NOT NULL,
25 acc_creditLimit INT NOT NULL,
26 OUTLET_out_ID INT NOT NULL,
27 PRIMARY KEY (acc_ID),
28 FOREIGN KEY (OUTLET_out_ID) REFERENCES OUTLET(out_ID) ON UPDATE CASCADE
29);
30
31
32-- -----------------------------------------------------
33-- Creates Table menzies.ORD
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS menzies.ORD (
36 ord_ID INT NOT NULL AUTO_INCREMENT,
37 ord_data DATETIME NOT NULL,
38 ord_value VARCHAR(45) NOT NULL,
39 OUTLET_out_ID INT NOT NULL,
40 PRIMARY KEY (ord_ID),
41 FOREIGN KEY (OUTLET_out_ID) REFERENCES OUTLET(out_ID) ON UPDATE CASCADE
42);
43
44
45-- -----------------------------------------------------
46-- Creates Table menzies.PUBLISHER
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS menzies.PUBLISHER (
49 publisher_ID INT NOT NULL AUTO_INCREMENT,
50 publisher_name VARCHAR(45) NOT NULL,
51 publisher_address VARCHAR(45) NOT NULL,
52 publisher_phone VARCHAR(15) NOT NULL,
53 publisher_email VARCHAR(45) NOT NULL,
54 PRIMARY KEY (publisher_ID)
55 );
56
57
58-- -----------------------------------------------------
59-- Creates Table menzies.PUBLICATION
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS menzies.PUBLICATION (
62 pub_ID INT NOT NULL AUTO_INCREMENT,
63 pub_name VARCHAR(45) NOT NULL,
64 pub_price DECIMAL(6) NOT NULL,
65 PUBLISHER_publisher_ID INT NOT NULL,
66 PRIMARY KEY (pub_ID),
67 FOREIGN KEY (PUBLISHER_publisher_ID) REFERENCES PUBLISHER(publisher_ID) ON UPDATE CASCADE
68 );
69
70
71-- -----------------------------------------------------
72-- Creates Table menzies.CONTRACT
73-- -----------------------------------------------------
74CREATE TABLE IF NOT EXISTS menzies.CONTRACT (
75 con_number INT NOT NULL AUTO_INCREMENT,
76 con_startDate DATETIME NOT NULL,
77 con_endDate DATETIME NOT NULL,
78 PUBLICATION_pub_ID INT NOT NULL,
79 PRIMARY KEY (con_number),
80 FOREIGN KEY (PUBLICATION_pub_ID) REFERENCES PUBLICATION(pub_ID) ON UPDATE CASCADE
81 );
82
83
84-- -----------------------------------------------------
85-- Creates Table menzies.DRIVER
86-- -----------------------------------------------------
87CREATE TABLE IF NOT EXISTS menzies.DRIVER (
88 dr_ID INT NOT NULL AUTO_INCREMENT,
89 dr_title VARCHAR(15) NOT NULL,
90 dr_fname VARCHAR(45) NOT NULL,
91 dr_lname VARCHAR(45) NOT NULL,
92 dr_DOB DATETIME NOT NULL,
93 dr_licenceNo VARCHAR(45) NOT NULL,
94 dr_phone VARCHAR(15) NOT NULL,
95 dr_email VARCHAR(45) NOT NULL,
96 PRIMARY KEY (dr_ID)
97 );
98
99
100-- -----------------------------------------------------
101-- Creates Table menzies.VEHICLE
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS menzies.VEHICLE (
104 veh_ID INT NOT NULL AUTO_INCREMENT,
105 veh_reg VARCHAR(15) NOT NULL,
106 veh_make VARCHAR(45) NOT NULL,
107 veh_model VARCHAR(45) NOT NULL,
108 veh_mileage INT NOT NULL,
109 veh_MOTdate DATETIME NOT NULL,
110 veh_servicedate DATETIME NOT NULL,
111 PRIMARY KEY (veh_ID)
112 );
113
114
115-- -----------------------------------------------------
116-- Creates Table menzies.DELIVERY
117-- -----------------------------------------------------
118CREATE TABLE IF NOT EXISTS menzies.DELIVERY (
119 del_ID INT NOT NULL AUTO_INCREMENT,
120 del_time DATETIME NOT NULL,
121 VEHICLE_veh_ID INT NOT NULL,
122 DRIVER_dr_ID INT NOT NULL,
123 PRIMARY KEY (del_ID),
124 FOREIGN KEY (VEHICLE_veh_ID) REFERENCES VEHICLE(veh_ID) ON UPDATE CASCADE,
125 FOREIGN KEY (DRIVER_dr_ID) REFERENCES DRIVER(dr_ID) ON UPDATE CASCADE
126 );
127
128
129-- -----------------------------------------------------
130-- Creates Table menzies.ORDER_has_PUBLICATION
131-- -----------------------------------------------------
132CREATE TABLE IF NOT EXISTS menzies.ORDER_has_PUBLICATION (
133 ORDER_out_ID INT NOT NULL,
134 PUBLICATION_pub_ID INT NOT NULL,
135 DELIVERY_del_ID INT NOT NULL,
136 DELIVERY_VEHICLE_veh_ID INT NOT NULL,
137 DELIVERY_DRIVER_dr_ID INT NOT NULL,
138 PRIMARY KEY (ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID),
139 FOREIGN KEY (DELIVERY_del_ID) REFERENCES DELIVERY(del_ID) ON UPDATE CASCADE,
140 FOREIGN KEY (ORDER_out_ID) REFERENCES ORD(OUTLET_out_ID) ON UPDATE CASCADE,
141 FOREIGN KEY (PUBLICATION_pub_ID) REFERENCES PUBLICATION(pub_ID) ON UPDATE CASCADE,
142 FOREIGN KEY (DELIVERY_VEHICLE_veh_ID) REFERENCES DELIVERY(VEHICLE_veh_ID) ON UPDATE CASCADE,
143 FOREIGN KEY (DELIVERY_DRIVER_dr_ID) REFERENCES DELIVERY(DRIVER_dr_ID) ON UPDATE CASCADE
144 );
145
146
147-- -----------------------------------------------------
148-- Creates Table menzies.RETURNITEM
149-- -----------------------------------------------------
150CREATE TABLE IF NOT EXISTS menzies.RETURNITEM (
151 ret_ID INT NOT NULL AUTO_INCREMENT,
152 ret_date DATETIME NOT NULL,
153 ret_weight DECIMAL(6) NOT NULL,
154 ret_noOfParcels INT NOT NULL,
155 OUTLET_out_ID INT NOT NULL,
156 DELIVERY_del_ID INT NOT NULL,
157 PRIMARY KEY (ret_ID),
158 FOREIGN KEY (OUTLET_out_ID) REFERENCES OUTLET(out_ID) ON UPDATE CASCADE,
159 FOREIGN KEY (DELIVERY_del_ID) REFERENCES DELIVERY(del_ID) ON UPDATE CASCADE
160 );
161
162-- -----------------------------------------------------
163-- Creates Table menzies.ROUTE
164-- -----------------------------------------------------
165CREATE TABLE IF NOT EXISTS menzies.ROUTE (
166 route_ID INT NOT NULL AUTO_INCREMENT,
167 route_name VARCHAR(45) NOT NULL,
168 DELIVERY_VEHICLE_veh_ID INT NOT NULL,
169 DELIVERY_DRIVER_dr_ID INT NOT NULL,
170 PRIMARY KEY (route_ID),
171 FOREIGN KEY (DELIVERY_VEHICLE_veh_ID) REFERENCES DELIVERY(VEHICLE_veh_ID) ON UPDATE CASCADE,
172 FOREIGN KEY (DELIVERY_DRIVER_dr_ID) REFERENCES DELIVERY(DRIVER_dr_ID) ON UPDATE CASCADE
173);
174
175
176
177
178
179INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Kennedy-Thomas', 'Dylan Mitchell', '33 Thompson Lights New Jasmine T8 0RT', '+44 04640375925', 'Charlie.Stewart@Allen.org');
180
181INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Evans LLC', 'Tony Fox', '99 Shaw Row Port Teaganshire WO1 8EP', '+44 09523715994', 'aWhite@Baker.info');
182
183INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Clark-Murphy', 'Tanya Holmes', 'Flat 46 Richards Plain Port Megan E26 5HU', '+44 02292369859', 'Lauren.Brown@Graham.org');
184
185INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Saunders-Walsh', 'Dale Davis', '032 Rowena Hollow South Isobel T43 6OQ', '+44 03170151588', 'aMitchell@Butler.co.uk');
186
187INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Walker-Hunter', 'Steve Davies', 'Studio 18 Joel River South Jade HX7Z 7WZ', '+44 05072964865', 'Matthew96@Smith.org');
188
189INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Matthews, Davis and Gray', 'Joel Bailey', '4 Harrison Underpass East Aidenmouth W1P 0XU', '+44 05318812157', 'aGreen@Young.com');
190
191INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('King-Campbell', 'Leo Butler', '2 Clark Circles West Katie XY82 8XV', '+44 00200905928', 'iCollins@Jackson.org');
192
193INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Fox-Reid', 'Suzanne Williams', '311 Murphy Green Louismouth A0 5LK', '+44 05372223462', 'Lisa07@Richards.biz');
194
195INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Hall-Mason', 'Stefan Murphy', 'Flat 92a Hunter Creek Tinaview PQ6H 6XY', '+44 00050322629', 'Jane22@Jackson.co.uk');
196
197INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Murphy Inc', 'Anthony Marshall', '331 Neil Falls East Reeceview K15 1GG', '+44 05206072587', 'pMurray@Price.info');
198
199INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Scott, Bailey and Stewart', 'Tara Rogers', '39 Carter Common Lake Stephen Z0E 6TQ', '+44 05789394564', 'uWilliams@Martin.co.uk');
200
201INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Harrison-Holmes', 'Colin Moore', '4 Karl Valley East Jasonfort X1 5LK', '+44 07773816729', 'yHarrison@Jackson.net');
202
203INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Thomas, Hall and Cox', 'Alex Anderson', '38 Erin Forest West Isabella US31 9UL', '+44 07292033279', 'Walsh.Ellie@Campbell.com');
204
205INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Taylor, Patel and Marshall', 'Damien Collins', 'Flat 62a Bradley Circle Richardsonport I1 9VX', '+44 02573461511', 'Alan.Turner@Edwards.com');
206
207INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Robinson, Holmes and Mitchell', 'Charles Graham', '9 Ellis Bridge Josephhaven L9 3UD', '+44 02766706709', 'Imogen53@Chapman.com');
208
209INSERT INTO menzies.OUTLET(out_name,out_manager, out_address, out_phone, out_email) VALUES ('Harrison and Sons', 'Isabelle Stevens', 'Studio 46 Davis Via Lake Alexaland Y8 1LL', '+44 07689412015', 'Elliott.Bailey@Ross.com');
210
211-- Account
212
213INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Richards', 'Rob Jackson', 924, 13, 1436, 1);
214
215INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Ross', 'Max Cook', 849, 15, 2180, 2);
216
217INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Wright', 'Theo Matthews', 197,16 , 2842, 3);
218
219INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Martin', 'Evie Khan', 405, 10, 1275, 4);
220
221INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('White', 'Jessica King', 1097, 19, 1957, 5);
222
223INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Stewart', 'Finley Young', 891, 10, 2241, 6);
224
225INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Morris', 'Chelsea Murray', 775, 22, 2580, 7);
226
227INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Chapman', 'Isobel Russell', 687, 11, 1364, 8);
228
229INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Stevens', 'Pauline Clark', 82, 6, 2886, 9);
230
231INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Lee', 'Dan Cox', 1140, 17 , 2946, 10);
232
233INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Kennedy', 'Colin Wilson', 288, 25, 2766, 11);
234
235INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Shaw', 'Kirsty Khan', 1332, 6, 2244, 12);
236
237INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Hunt', 'Jasmine Khan', 21, 6, 2043', '13);
238
239INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Chapman', 'Eden Murray', 763, 11 , 2632, 14);
240
241INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Jones', 'Fred Cooper', 168, 11, 1436, 15);
242
243INSERT INTO menzies.ACCOUNT(acc_name, acc_manager, acc_balance, acc_transactionLimit, acc_creditLimit, OUTLET_out_ID) VALUES ('Gray', 'Christian Robertson', 431, 16, 2219, 16);
244
245-- ORD
246
247INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-08-07 00:02:37', 199, 2);
248
249INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-05-03 22:34:37', 147, 13);
250
251INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-02-06 12:44:37', 491, 16);
252
253INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-08-08 02:07:37', 440, 4);
254
255INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2016-01-10 10:56:37', 56, 7);
256
257INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-04-23 14:32:37', 155, 14);
258
259INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-23 22:05:37', 190, 12);
260
261INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-06-06 20:21:37', 378, 11);
262
263INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-02-02 01:18:37', 186, 6);
264
265INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-04-19 17:38:37', 316, 5);
266
267INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-03-15 16:52:37', 431, 7);
268
269INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-02-01 15:23:37', 367, 9);
270
271INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-23 14:36:37', 247, 7);
272
273INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-04-28 20:50:37', 456, 14);
274
275INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-02-25 06:09:37', 303, 15);
276
277INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-09-17 22:50:37', 391, 7);
278
279INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-04-21 03:36:37', 153, 4);
280
281INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-11-22 09:56:37', 268, 13);
282
283INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-03-24 21:23:37', 206, 15);
284
285INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-11-15 11:44:37', 456, 8);
286
287INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-15 03:32:37', 192, 6);
288
289INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-08-10 22:15:37', 390, 16);
290
291INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-08-25 09:20:37', 149, 5);
292
293INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-29 09:54:37', 96, 1);
294
295INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-19 14:29:37', 445, 8);
296
297INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-06-20 10:04:37', 436, 12);
298
299INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-12-11 22:07:37', 161, 1);
300
301INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-10-27 05:57:37', 254, 1);
302
303INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-06-03 14:47:37', 264, 2);
304
305INSERT INTO menzies.ORD(ord_data, ord_value, OUTLET_out_id) VALUES ('2015-06-07 00:38:37', 296, 14);
306
307-- Publisher
308
309INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Reid-Mitchell', 'Flat 98y Morgan Junctions Baileyfort T3 7FQ', '+44 04458031556', 'zWalker@example.com');
310
311INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Kelly Ltd', 'Flat 97p Becky Turnpike Collinsville FR4B 8PN', '+44 08821348974', 'aLewis@example.net');
312
313INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Harrison Inc', '9 James Heights East Jordan UO8C 3ZK', '+44 05799560195', 'Davis.Anthony@example.com');
314
315INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Harris-Simpson', 'Flat 03 Jessica Way Adrianfurt N0 0VZ', '+44 06550668317', 'Barry.Saunders@example.net');
316
317INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Anderson, Mason and Jackson', '1 King Row Kylebury G34 6AE', '+44 06702660589', 'Anderson.Jennifer@example.net');
318
319INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Roberts and Sons', '124 Nathan Hollow Lake Beckybury GO6P 5SV', '+44 07066837458', 'Davies.Dennis@example.net');
320
321INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Morgan, Clark and Matthews', '13 Lexi Pass Edwardsville NW5 3WK', '+44 04774440521', 'Reynolds.Evie@example.net');
322
323INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Shaw and Sons', '3 Bell Ville Matthewberg YZ4 7GA', '+44 07421501659', 'Ellis.Pauline@example.net');
324
325INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Moore and Sons', '0 Bradley Junction South Harrison E5J 8YM', '+44 04235495126', 'Stevens.Jim@example.net');
326
327INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Knight, Lewis and White', '306 Tina Valleys New Evelyn X6 1GM', '+44 03602424502', 'Dean.Thompson@example.com');
328
329INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Davies PLC', '08 Thomas Square Victoriamouth T4 9VA', '+44 03801840285', 'vJackson@example.net');
330
331INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Gray, Wright and White', 'Studio 84 Olivia Wells Robinsonmouth CH1 1TG', '+44 00914014025', 'Reid.Daniel@example.org');
332
333INSERT INTO menzies.PUBLISHER(publisher_name, publisher_address, publisher_phone, publisher_email) VALUES ('Jackson, Adams and Watson', 'Studio 61 Ellis Grove Port Damienton ON37 0WF', '+44 04046790867', 'hCarter@example.org');
334
335-- Publication
336
337INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Laudantium voluptatum commodi.', 5, 1);
338
339INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Ut cupiditate laudantium.', 7, 2);
340
341INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Aliquam ut.', 2, 3);
342
343INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Voluptas nobis sequi.', 15, 4);
344
345INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Quia voluptatem.', 7, 5);
346
347INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Consequuntur veniam ut.', 6, 6);
348
349INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Similique ut omnis.', 3, 7);
350
351INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Occaecati corrupti.', 14, 8);
352
353INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Porro omnis recusandae.', 10, 9);
354
355INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Voluptatem aliquam.', 4, 10);
356
357INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Ratione perferendis magni.', 9, 11);
358
359INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Sed et.', 3, 12);
360
361INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Adipisci quas.', 6, 13);
362
363INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Quam dignissimos.', 10, 9);
364
365INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Corrupti ipsum deserunt.', 3, 14);
366
367INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Dolor et voluptatem.', 5, 16);
368
369INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Molestiae repudiandae.', 7, 14);
370
371INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Tempore fuga.', 15, 15);
372
373INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Aperiam minus.', 8, 4);
374
375INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Cupiditate laborum.', 8, 14);
376
377INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Doloremque quae.', 7, 2);
378
379INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Debitis aliquid.', 2, 1);
380
381INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Atque voluptatem esse.', 4, 4);
382
383INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Sed laboriosam.', 4, 9);
384
385INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Et ea.', 14, 8);
386
387INSERT INTO menzies.PUBLICATION(pub_name, pub_price, PUBLISHER_publisher_ID) VALUES ('Sed sunt numquam.', 14, 1);
388
389-- Contract
390
391INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-29 09:57:24', '2016-03-12 22:42:24', 6);
392
393INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-28 21:34:24', '2016-05-29 10:56:24', 1);
394
395INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-21 02:22:24', '2016-04-12 05:23:24', 6);
396
397INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-29 00:57:24', '2016-03-18 00:18:24', 4);
398
399INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2016-01-17 09:11:24', '2016-02-16 15:52:24', 1);
400
401INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-16 01:52:24', '2016-08-09 14:12:24', 6);
402
403INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-25 16:14:24', '2016-07-13 16:25:24', 9);
404
405INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-20 20:16:24', '2016-04-09 05:53:24', 9);
406
407INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2016-01-10 23:48:24', '2016-04-14 08:04:24', 8);
408
409INSERT INTO menzies.CONTRACT(con_startDate, con_endDate, PUBLICATION_pub_ID) VALUES ('2015-12-30 20:53:24', '2016-05-11 20:05:24', 6);
410
411-- Driver
412
413INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Reece', 'Carter', '2015-09-22', 'matth01622924', '+44 01771214857', 'cCook@James.net');
414
415INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Jackson', 'Smith', '1986-11-30', 'walke17859723', '+44 08583715390', 'Karen37@Kennedy.com');
416
417INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Luke', 'Cooper', '1988-01-07', 'murph10475610', '+44 02530602320', 'Cook.Nick@hotmail.com');
418
419INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Dominic', 'Scott', '1996-11-24', 'scott33319456', '+44 08286278087', 'Young.Kyle@hotmail.co.uk');
420
421INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Katie', 'Clarke', '2008-04-01', 'wilso75853491', '+44 03941034587', 'Fred18@Palmer.com');
422
423INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Joshua', 'Cooper', '2002-03-09', 'rober13167350', '+44 04394776076', 'Scott.Abigail@Khan.info');
424
425INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Kevin', 'Ward', '1982-10-31', 'richa46450665', '+44 00659279794', 'Quentin62@Hughes.org');
426
427INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Ethan', 'Kennedy', '1971-09-01', 'jones65961931', '+44 08691959938', 'Mary.Walker@hotmail.com');
428
429INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Maria', 'Bennett', '1977-09-05', 'wilso83813683', '+44 01090516725', 'Rose.Sonia@hotmail.co.uk');
430
431INSERT INTO menzies.DRIVER(dr_title, dr_fname, dr_lname, dr_DOB, dr_licenceNo, dr_phone, dr_email) VALUES ('Mr', 'Lily', 'Clark', '2011-09-07', 'mitch38301434', '+44 00150859010', 'oShaw@yahoo.co.uk');
432
433
434-- Vehicle
435
436INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('ATU999484', 'Fiat', 'alias10', '98355', '2017-01-15 09:13:16', '2016-11-29 09:58:16');
437
438INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('AMA824493', 'Renault', 'doloremque79', '2176', '2016-09-14 11:01:16', '2016-05-14 12:15:16');
439
440INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('AFM876189', 'Ferrari', 'incidunt97', '75856', '2016-08-11 12:43:16', '2016-12-20 16:07:16');
441
442INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('ADT372479', 'Chrisler', 'perspiciatis19', '28176', '2016-09-16 05:06:16', '2016-11-22 05:21:16');
443
444INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('ADN022855', 'Chrisler', 'et74', '10756', '2016-08-15 16:04:16', '2016-05-26 00:49:16');
445
446INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('ASU959115', 'Renault', 'aliquam11', '22541', '2016-12-30 16:40:16', '2016-02-21 23:12:16');
447
448INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('ANC971644', 'Fiat', 'ad51', '74060', '2016-11-16 07:25:16', '2017-01-15 08:39:16');
449
450INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('AHM586888', 'Ford', 'vel83', '97151', '2016-07-14 22:49:16', '2016-12-11 11:40:16');
451
452INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('AYZ696394', 'Ford', 'cumque49', '88414', '2016-06-25 15:10:16', '2016-10-27 18:29:16');
453
454INSERT INTO menzies.VEHICLE(veh_reg, veh_make, veh_model, veh_mileage, veh_MOTdate, veh_servicedate) VALUES ('AAX116573', 'Ford', 'beatae07', '56446', '2016-05-23 07:47:16', '2016-06-24 20:19:16');
455
456-- Delivery
457
458INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-03 21:04:18', 9, 7);
459
460INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 16:42:18', 1, 7);
461
462INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-06 01:20:18', 9, 6);
463
464INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-07 18:02:18', 6, 3);
465
466INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-03 11:07:18', 9, 6);
467
468INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 02:16:18', 9, 1);
469
470INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 18:03:18', 5, 8);
471
472INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 19:11:18', 6, 8);
473
474INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-01-31 09:23:18', 7, 2);
475
476INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-05 12:01:18', 3, 9);
477
478INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 13:00:18', 6, 3);
479
480INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 00:42:18', 2, 2);
481
482INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-01 02:35:18', 9, 8);
483
484INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-07 15:58:18', 7, 4);
485
486INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 00:36:18', 2, 4);
487
488INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 00:21:18', 2, 4);
489
490INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-01-31 14:14:18', 5, 8);
491
492INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-01-31 19:21:18', 8, 8);
493
494INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 15:23:18', 5, 10);
495
496INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 15:07:18', 6, 1);
497
498INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-02 10:47:18', 9, 6);
499
500INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-04 08:45:18', 3, 10);
501
502INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-03 04:46:18', 5, 9);
503
504INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-01-30 22:24:18', 8, 6);
505
506INSERT INTO menzies.DELIVERY(del_date, VEHICLE_veh_ID, DRIVER_dr_ID) VALUES ('2016-02-08 07:54:18', 4, 3);
507
508-- Order has Publiction
509
510INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (12, 4, 3, 1, 2);
511
512INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (2,14, 2, 9, 8);
513
514INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (3, 2, 3, 8, 6);
515
516INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (4, 2, 4, 3, 1);
517
518INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (5, 16, 5, 1, 8);
519
520INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (6, 22, 6, 8, 6);
521
522INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (7,11, 7, 6, 1);
523
524INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (8,22, 8, 3, 8);
525
526INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (9, 25, 9, 8, 10);
527
528INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (10, 11, 10, 5, 7);
529
530INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (11, 13, 11, 6, 1);
531
532INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (12, 19, 12, 8, 7);
533
534INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (13, 14, 13, 4, 8);
535
536INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (14, 1, 14, 4, 9);
537
538INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (15, 3, 15, 2, 4);
539
540INSERT INTO menzies.ORDER_has_PUBLICATION(ORDER_out_ID, PUBLICATION_pub_ID, DELIVERY_del_ID, DELIVERY_VEHICLE_veh_ID, DELIVERY_DRIVER_dr_ID) VALUES (16, 10, 16, 7, 7);
541
542-- Return Item
543
544INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-20 17:52:01', 9.52, 15, 10, 9);
545
546INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-17 00:02:01', 5.12, 15, 7, 1);
547
548INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-18 21:50:01', 14.94, 1, 5, 6);
549
550INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-22 18:40:01', 6.38, 6, 1, 2);
551
552INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-26 04:43:01', 10.16, 1, 2, 5);
553
554INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-16 19:13:01', 19.36, 13, 9, 1);
555
556INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-23 02:15:01', 19.31, 10, 1, 5);
557
558INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-14 01:22:01', 8.07, 6, 8, 6);
559
560INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-20 23:14:01', 5.67, 9, 9, 3);
561
562INSERT INTO menzies.RETURNITEM(ret_date, ret_weight, ret_noOfParcels, OUTLET_out_ID, DELIVERY_del_ID) VALUES ('2016-01-13 22:40:01', 13.09, 5, 10, 4);