INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15305,'2005-08-22 19:46:05',671,529,'2005-08-27 19:11:05',2,'2006-02-15 21:30:53'),
 (15306,'2005-08-22 19:46:36',521,340,'2005-08-27 14:09:36',1,'2006-02-15 21:30:53'),
 (15307,'2005-08-22 19:54:26',4525,598,'2005-08-29 01:38:26',2,'2006-02-15 21:30:53'),
 (15308,'2005-08-22 19:54:31',987,329,'2005-08-26 23:09:31',1,'2006-02-15 21:30:53'),
 (15309,'2005-08-22 19:54:52',2743,141,'2005-08-24 23:00:52',2,'2006-02-15 21:30:53'),
 (15310,'2005-08-22 19:56:41',2546,360,'2005-08-24 16:32:41',2,'2006-02-15 21:30:53'),
 (15311,'2005-08-22 19:56:52',3612,176,'2005-08-31 20:15:52',2,'2006-02-15 21:30:53'),
 (15312,'2005-08-22 19:58:15',2509,280,'2005-08-25 19:21:15',2,'2006-02-15 21:30:53'),
 (15313,'2005-08-22 19:59:42',2587,333,'2005-08-24 15:03:42',2,'2006-02-15 21:30:53'),
 (15314,'2006-02-14 15:16:03',2754,412,NULL,1,'2006-02-15 21:30:53'),
 (15315,'2005-08-22 20:03:46',312,1,'2005-08-30 01:51:46',2,'2006-02-15 21:30:53'),
 (15316,'2005-08-22 20:07:03',1830,422,'2005-08-27 18:45:03',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15317,'2005-08-22 20:14:13',2325,512,'2005-08-29 18:32:13',1,'2006-02-15 21:30:53'),
 (15318,'2005-08-22 20:15:16',1738,60,'2005-08-25 14:17:16',1,'2006-02-15 21:30:53'),
 (15319,'2005-08-22 20:17:17',3041,188,'2005-08-25 01:06:17',2,'2006-02-15 21:30:53'),
 (15320,'2005-08-22 20:17:49',648,407,'2005-08-28 17:31:49',1,'2006-02-15 21:30:53'),
 (15321,'2005-08-22 20:20:04',4152,384,'2005-08-24 23:26:04',2,'2006-02-15 21:30:53'),
 (15322,'2005-08-22 20:20:30',3553,263,'2005-08-25 01:26:30',2,'2006-02-15 21:30:53'),
 (15323,'2005-08-22 20:22:40',1153,178,'2005-08-26 00:35:40',1,'2006-02-15 21:30:53'),
 (15324,'2005-08-22 20:23:13',161,93,'2005-08-29 18:23:13',1,'2006-02-15 21:30:53'),
 (15325,'2005-08-22 20:27:38',3549,74,'2005-08-23 15:24:38',1,'2006-02-15 21:30:53'),
 (15326,'2006-02-14 15:16:03',3320,58,NULL,1,'2006-02-15 21:30:53'),
 (15327,'2005-08-22 20:31:24',1018,450,'2005-08-30 23:52:24',1,'2006-02-15 21:30:53'),
 (15328,'2005-08-22 20:31:38',4546,274,'2005-08-29 20:17:38',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15329,'2005-08-22 20:32:39',1900,521,'2005-08-23 17:15:39',1,'2006-02-15 21:30:53'),
 (15330,'2005-08-22 20:35:30',689,427,'2005-08-30 21:54:30',1,'2006-02-15 21:30:53'),
 (15331,'2005-08-22 20:37:57',146,147,'2005-08-25 21:56:57',1,'2006-02-15 21:30:53'),
 (15332,'2005-08-22 20:41:53',3368,162,'2005-08-24 01:45:53',1,'2006-02-15 21:30:53'),
 (15333,'2005-08-22 20:44:06',1839,142,'2005-08-29 22:34:06',2,'2006-02-15 21:30:53'),
 (15334,'2005-08-22 20:44:35',3882,407,'2005-08-29 23:03:35',2,'2006-02-15 21:30:53'),
 (15335,'2005-08-22 20:44:55',1593,363,'2005-08-28 21:43:55',1,'2006-02-15 21:30:53'),
 (15336,'2005-08-22 20:47:48',490,461,'2005-08-31 18:17:48',2,'2006-02-15 21:30:53'),
 (15337,'2005-08-22 20:49:51',280,237,'2005-08-26 23:27:51',1,'2006-02-15 21:30:53'),
 (15338,'2005-08-22 20:51:24',502,13,'2005-08-24 23:41:24',2,'2006-02-15 21:30:53'),
 (15339,'2005-08-22 20:52:12',1660,331,'2005-08-26 00:36:12',2,'2006-02-15 21:30:53'),
 (15340,'2005-08-22 20:55:56',3653,313,'2005-08-27 18:52:56',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15341,'2005-08-22 20:56:31',3359,91,'2005-08-30 17:25:31',1,'2006-02-15 21:30:53'),
 (15342,'2005-08-22 20:56:41',3287,459,'2005-08-26 22:51:41',2,'2006-02-15 21:30:53'),
 (15343,'2005-08-22 21:01:25',2589,538,'2005-08-28 16:15:25',1,'2006-02-15 21:30:53'),
 (15344,'2005-08-22 21:01:48',3560,193,'2005-08-27 15:47:48',1,'2006-02-15 21:30:53'),
 (15345,'2005-08-22 21:05:50',3481,277,'2005-08-26 20:30:50',1,'2006-02-15 21:30:53'),
 (15346,'2005-08-22 21:06:00',3525,266,'2005-08-28 22:08:00',1,'2006-02-15 21:30:53'),
 (15347,'2005-08-22 21:12:19',3764,519,'2005-08-24 20:12:19',1,'2006-02-15 21:30:53'),
 (15348,'2005-08-22 21:13:46',3846,587,'2005-08-24 17:06:46',1,'2006-02-15 21:30:53'),
 (15349,'2005-08-22 21:13:51',4055,587,'2005-08-23 20:55:51',1,'2006-02-15 21:30:53'),
 (15350,'2005-08-22 21:15:29',1170,488,'2005-08-24 02:56:29',1,'2006-02-15 21:30:53'),
 (15351,'2005-08-22 21:15:46',3260,154,'2005-08-23 17:38:46',1,'2006-02-15 21:30:53'),
 (15352,'2005-08-22 21:16:54',16,560,'2005-08-31 00:38:54',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15353,'2005-08-22 21:18:08',3470,368,'2005-08-25 20:29:08',2,'2006-02-15 21:30:53'),
 (15354,'2005-08-22 21:18:59',4212,412,'2005-08-27 20:12:59',2,'2006-02-15 21:30:53'),
 (15355,'2005-08-22 21:19:24',3477,493,'2005-08-28 20:36:24',2,'2006-02-15 21:30:53'),
 (15356,'2005-08-22 21:24:19',4507,539,'2005-08-25 22:32:19',2,'2006-02-15 21:30:53'),
 (15357,'2005-08-22 21:28:59',727,24,'2005-08-25 17:15:59',1,'2006-02-15 21:30:53'),
 (15358,'2005-08-22 21:29:14',822,448,'2005-08-31 00:10:14',2,'2006-02-15 21:30:53'),
 (15359,'2005-08-22 21:34:00',4505,77,'2005-08-29 18:59:00',1,'2006-02-15 21:30:53'),
 (15360,'2005-08-22 21:36:51',1950,531,'2005-08-24 16:46:51',1,'2006-02-15 21:30:53'),
 (15361,'2005-08-22 21:39:45',1407,380,'2005-08-23 17:32:45',2,'2006-02-15 21:30:53'),
 (15362,'2005-08-22 21:40:20',1023,497,'2005-08-29 15:55:20',1,'2006-02-15 21:30:53'),
 (15363,'2005-08-22 21:41:40',2326,480,'2005-08-23 21:40:40',1,'2006-02-15 21:30:53'),
 (15364,'2005-08-22 21:41:41',4184,204,'2005-08-28 00:49:41',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15365,'2005-08-22 21:42:17',3382,327,'2005-09-01 03:14:17',2,'2006-02-15 21:30:53'),
 (15366,'2005-08-22 21:45:57',1453,374,'2005-08-30 16:35:57',1,'2006-02-15 21:30:53'),
 (15367,'2005-08-22 21:47:53',160,355,'2005-08-27 17:54:53',2,'2006-02-15 21:30:53'),
 (15368,'2005-08-22 21:57:15',1130,370,'2005-08-29 16:28:15',1,'2006-02-15 21:30:53'),
 (15369,'2005-08-22 21:58:06',881,121,'2005-08-26 00:27:06',2,'2006-02-15 21:30:53'),
 (15370,'2005-08-22 21:59:29',67,10,'2005-08-27 16:32:29',1,'2006-02-15 21:30:53'),
 (15371,'2006-02-14 15:16:03',3672,94,NULL,2,'2006-02-15 21:30:53'),
 (15372,'2005-08-22 21:59:51',3876,273,'2005-08-23 17:01:51',1,'2006-02-15 21:30:53'),
 (15373,'2005-08-22 22:08:11',4439,14,'2005-08-24 01:05:11',2,'2006-02-15 21:30:53'),
 (15374,'2005-08-22 22:09:09',4275,8,'2005-08-31 01:10:09',1,'2006-02-15 21:30:53'),
 (15375,'2005-08-22 22:12:02',3864,191,'2005-08-24 00:50:02',2,'2006-02-15 21:30:53'),
 (15376,'2005-08-22 22:21:35',2963,390,'2005-08-28 20:56:35',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15377,'2005-08-22 22:22:33',3405,551,'2005-08-29 18:41:33',1,'2006-02-15 21:30:53'),
 (15378,'2005-08-22 22:25:17',1483,340,'2005-08-30 17:04:17',1,'2006-02-15 21:30:53'),
 (15379,'2005-08-22 22:26:13',1899,148,'2005-08-31 18:19:13',1,'2006-02-15 21:30:53'),
 (15380,'2005-08-22 22:28:15',3642,423,'2005-08-28 23:21:15',1,'2006-02-15 21:30:53'),
 (15381,'2005-08-22 22:28:36',845,110,'2005-08-24 19:26:36',2,'2006-02-15 21:30:53'),
 (15382,'2005-08-22 22:30:50',333,376,'2005-08-24 04:07:50',2,'2006-02-15 21:30:53'),
 (15383,'2005-08-22 22:31:20',686,405,'2005-08-28 17:43:20',1,'2006-02-15 21:30:53'),
 (15384,'2005-08-22 22:34:44',3208,26,'2005-08-23 23:25:44',2,'2006-02-15 21:30:53'),
 (15385,'2005-08-22 22:37:34',140,434,'2005-08-26 00:36:34',2,'2006-02-15 21:30:53'),
 (15386,'2005-08-22 22:41:14',3056,327,'2005-08-29 22:29:14',1,'2006-02-15 21:30:53'),
 (15387,'2005-08-22 22:49:13',3879,323,'2005-08-29 01:49:13',2,'2006-02-15 21:30:53'),
 (15388,'2005-08-22 22:49:23',3995,50,'2005-09-01 03:50:23',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15389,'2005-08-22 22:51:13',2077,231,'2005-08-28 23:46:13',1,'2006-02-15 21:30:53'),
 (15390,'2005-08-22 22:57:25',462,551,'2005-08-31 18:06:25',1,'2006-02-15 21:30:53'),
 (15391,'2005-08-22 23:01:45',3918,482,'2005-08-29 02:59:45',2,'2006-02-15 21:30:53'),
 (15392,'2005-08-22 23:02:15',538,410,'2005-09-01 01:14:15',2,'2006-02-15 21:30:53'),
 (15393,'2005-08-22 23:04:09',2924,443,'2005-08-27 02:23:09',2,'2006-02-15 21:30:53'),
 (15394,'2005-08-22 23:04:21',3455,507,'2005-08-25 20:53:21',2,'2006-02-15 21:30:53'),
 (15395,'2005-08-22 23:06:25',2880,526,'2005-08-30 19:18:25',1,'2006-02-15 21:30:53'),
 (15396,'2005-08-22 23:07:57',4050,319,'2005-08-28 19:39:57',2,'2006-02-15 21:30:53'),
 (15397,'2005-08-22 23:08:46',1482,261,'2005-08-25 20:58:46',1,'2006-02-15 21:30:53'),
 (15398,'2005-08-22 23:10:49',4451,109,'2005-08-28 00:49:49',2,'2006-02-15 21:30:53'),
 (15399,'2005-08-22 23:11:59',3858,379,'2005-08-26 22:16:59',2,'2006-02-15 21:30:53'),
 (15400,'2005-08-22 23:13:03',2664,473,'2005-08-28 18:34:03',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15401,'2005-08-22 23:13:10',1721,103,'2005-09-01 03:44:10',1,'2006-02-15 21:30:53'),
 (15402,'2005-08-22 23:17:41',1575,293,'2005-08-30 20:07:41',2,'2006-02-15 21:30:53'),
 (15403,'2005-08-22 23:18:10',4315,581,'2005-08-23 18:08:10',2,'2006-02-15 21:30:53'),
 (15404,'2005-08-22 23:19:44',3557,211,'2005-08-30 19:58:44',2,'2006-02-15 21:30:53'),
 (15405,'2005-08-22 23:20:41',3263,596,'2005-08-25 23:53:41',1,'2006-02-15 21:30:53'),
 (15406,'2005-08-22 23:21:22',400,227,'2005-08-28 22:21:22',1,'2006-02-15 21:30:53'),
 (15407,'2006-02-14 15:16:03',3330,42,NULL,2,'2006-02-15 21:30:53'),
 (15408,'2005-08-22 23:26:32',165,156,'2005-08-30 20:22:32',1,'2006-02-15 21:30:53'),
 (15409,'2005-08-22 23:26:32',560,188,'2005-08-24 22:44:32',1,'2006-02-15 21:30:53'),
 (15410,'2005-08-22 23:27:43',2052,403,'2005-08-29 05:12:43',2,'2006-02-15 21:30:53'),
 (15411,'2005-08-22 23:35:41',4423,461,'2005-08-26 00:51:41',1,'2006-02-15 21:30:53'),
 (15412,'2005-08-22 23:37:11',1267,199,'2005-08-28 23:26:11',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15413,'2005-08-22 23:38:01',2494,476,'2005-08-23 19:27:01',2,'2006-02-15 21:30:53'),
 (15414,'2005-08-22 23:43:54',718,532,'2005-08-30 18:26:54',1,'2006-02-15 21:30:53'),
 (15415,'2005-08-22 23:48:56',4176,204,'2005-09-01 02:05:56',1,'2006-02-15 21:30:53'),
 (15416,'2005-08-22 23:51:23',1167,383,'2005-08-29 20:03:23',1,'2006-02-15 21:30:53'),
 (15417,'2005-08-22 23:54:04',1826,305,'2005-08-26 22:25:04',1,'2006-02-15 21:30:53'),
 (15418,'2005-08-22 23:54:14',808,205,'2005-08-28 04:23:14',2,'2006-02-15 21:30:53'),
 (15419,'2005-08-22 23:54:36',1120,450,'2005-08-25 00:52:36',1,'2006-02-15 21:30:53'),
 (15420,'2005-08-22 23:55:51',1396,161,'2005-08-31 20:09:51',2,'2006-02-15 21:30:53'),
 (15421,'2005-08-22 23:56:37',3,541,'2005-08-25 18:58:37',2,'2006-02-15 21:30:53'),
 (15422,'2005-08-22 23:58:09',2601,309,'2005-08-30 19:03:09',2,'2006-02-15 21:30:53'),
 (15423,'2006-02-14 15:16:03',1786,596,NULL,1,'2006-02-15 21:30:53'),
 (15424,'2005-08-23 00:03:01',3452,138,'2005-08-27 23:27:01',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15425,'2005-08-23 00:05:57',551,259,'2005-09-01 05:08:57',1,'2006-02-15 21:30:53'),
 (15426,'2005-08-23 00:07:19',3280,347,'2005-08-26 23:19:19',1,'2006-02-15 21:30:53'),
 (15427,'2005-08-23 00:07:53',2775,448,'2005-09-01 02:55:53',2,'2006-02-15 21:30:53'),
 (15428,'2005-08-23 00:11:52',4379,402,'2005-08-24 02:35:52',1,'2006-02-15 21:30:53'),
 (15429,'2005-08-23 00:20:31',740,241,'2005-08-23 20:22:31',1,'2006-02-15 21:30:53'),
 (15430,'2006-02-14 15:16:03',4353,282,NULL,1,'2006-02-15 21:30:53'),
 (15431,'2005-08-23 00:26:47',3251,550,'2005-08-31 23:26:47',2,'2006-02-15 21:30:53'),
 (15432,'2005-08-23 00:26:52',1896,117,'2005-08-27 06:11:52',1,'2006-02-15 21:30:53'),
 (15433,'2005-08-23 00:27:18',155,198,'2005-08-26 21:36:18',1,'2006-02-15 21:30:53'),
 (15434,'2005-08-23 00:28:16',4378,518,'2005-08-26 04:27:16',2,'2006-02-15 21:30:53'),
 (15435,'2005-08-23 00:28:19',2103,468,'2005-08-26 00:44:19',2,'2006-02-15 21:30:53'),
 (15436,'2005-08-23 00:30:26',1527,505,'2005-08-28 06:29:26',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15437,'2005-08-23 00:31:09',4236,368,'2005-08-30 06:17:09',2,'2006-02-15 21:30:53'),
 (15438,'2005-08-23 00:31:57',2030,46,'2005-08-26 20:02:57',1,'2006-02-15 21:30:53'),
 (15439,'2005-08-23 00:34:28',3848,136,'2005-08-27 01:07:28',1,'2006-02-15 21:30:53'),
 (15440,'2005-08-23 00:37:21',2254,559,'2005-08-24 23:24:21',1,'2006-02-15 21:30:53'),
 (15441,'2006-02-14 15:16:03',258,422,NULL,2,'2006-02-15 21:30:53'),
 (15442,'2005-08-23 00:42:49',1452,42,'2005-08-27 00:35:49',1,'2006-02-15 21:30:53'),
 (15443,'2005-08-23 00:44:15',742,598,'2005-09-01 05:33:15',2,'2006-02-15 21:30:53'),
 (15444,'2005-08-23 00:46:52',959,153,'2005-08-29 20:37:52',2,'2006-02-15 21:30:53'),
 (15445,'2005-08-23 00:48:29',196,28,'2005-08-28 00:33:29',1,'2006-02-15 21:30:53'),
 (15446,'2005-08-23 00:49:24',503,379,'2005-08-26 02:09:24',2,'2006-02-15 21:30:53'),
 (15447,'2005-08-23 00:53:57',4090,331,'2005-08-29 06:19:57',2,'2006-02-15 21:30:53'),
 (15448,'2005-08-23 00:55:24',2903,490,'2005-08-25 02:20:24',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15449,'2005-08-23 00:55:43',2856,461,'2005-08-28 03:41:43',1,'2006-02-15 21:30:53'),
 (15450,'2005-08-23 00:56:01',1102,322,'2005-08-24 01:00:01',2,'2006-02-15 21:30:53'),
 (15451,'2005-08-23 00:56:27',231,514,'2005-08-24 00:15:27',2,'2006-02-15 21:30:53'),
 (15452,'2005-08-23 00:57:12',717,115,'2005-08-28 00:19:12',1,'2006-02-15 21:30:53'),
 (15453,'2005-08-23 01:01:01',2,359,'2005-08-30 20:08:01',1,'2006-02-15 21:30:53'),
 (15454,'2006-02-14 15:16:03',2946,142,NULL,2,'2006-02-15 21:30:53'),
 (15455,'2005-08-23 01:05:00',3991,238,'2005-08-26 22:56:00',1,'2006-02-15 21:30:53'),
 (15456,'2005-08-23 01:07:01',2451,262,'2005-08-24 23:28:01',2,'2006-02-15 21:30:53'),
 (15457,'2005-08-23 01:07:37',4539,306,'2005-08-26 19:46:37',1,'2006-02-15 21:30:53'),
 (15458,'2006-02-14 15:16:03',25,590,NULL,2,'2006-02-15 21:30:53'),
 (15459,'2005-08-23 01:09:48',2058,346,'2005-08-24 04:52:48',1,'2006-02-15 21:30:53'),
 (15460,'2005-08-23 01:10:42',2907,20,'2005-08-28 20:49:42',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15461,'2005-08-23 01:13:52',4542,103,'2005-08-30 00:44:52',1,'2006-02-15 21:30:53'),
 (15462,'2005-08-23 01:14:01',3267,389,'2005-08-29 19:52:01',1,'2006-02-15 21:30:53'),
 (15463,'2005-08-23 01:15:07',863,127,'2005-08-29 06:50:07',1,'2006-02-15 21:30:53'),
 (15464,'2005-08-23 01:15:18',3235,62,'2005-08-29 02:58:18',2,'2006-02-15 21:30:53'),
 (15465,'2005-08-23 01:16:33',362,520,'2005-08-28 20:08:33',2,'2006-02-15 21:30:53'),
 (15466,'2005-08-23 01:16:55',571,418,'2005-08-29 22:57:55',1,'2006-02-15 21:30:53'),
 (15467,'2005-08-23 01:22:12',3658,103,'2005-08-29 23:42:12',2,'2006-02-15 21:30:53'),
 (15468,'2005-08-23 01:25:30',2440,399,'2005-08-28 01:40:30',2,'2006-02-15 21:30:53'),
 (15469,'2005-08-23 01:29:59',1939,597,'2005-08-27 04:02:59',1,'2006-02-15 21:30:53'),
 (15470,'2005-08-23 01:35:12',3009,416,'2005-09-01 05:33:12',1,'2006-02-15 21:30:53'),
 (15471,'2005-08-23 01:38:48',2591,139,'2005-08-31 19:47:48',1,'2006-02-15 21:30:53'),
 (15472,'2005-08-23 01:39:05',4293,226,'2005-08-25 04:43:05',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15473,'2005-08-23 01:39:10',356,259,'2005-08-25 03:48:10',1,'2006-02-15 21:30:53'),
 (15474,'2005-08-23 01:39:10',3015,188,'2005-08-23 21:46:10',2,'2006-02-15 21:30:53'),
 (15475,'2005-08-23 01:44:43',4503,562,'2005-08-23 23:53:43',2,'2006-02-15 21:30:53'),
 (15476,'2005-08-23 01:45:07',2478,433,'2005-08-26 21:07:07',2,'2006-02-15 21:30:53'),
 (15477,'2005-08-23 01:46:35',2406,142,'2005-08-28 22:12:35',1,'2006-02-15 21:30:53'),
 (15478,'2005-08-23 01:50:31',4563,167,'2005-08-27 21:40:31',2,'2006-02-15 21:30:53'),
 (15479,'2005-08-23 01:50:53',4182,149,'2005-08-29 00:53:53',1,'2006-02-15 21:30:53'),
 (15480,'2005-08-23 01:57:20',3298,577,'2005-08-26 04:43:20',2,'2006-02-15 21:30:53'),
 (15481,'2005-08-23 01:59:14',3262,414,'2005-08-27 04:38:14',1,'2006-02-15 21:30:53'),
 (15482,'2005-08-23 02:01:20',3923,181,'2005-08-24 03:25:20',2,'2006-02-15 21:30:53'),
 (15483,'2005-08-23 02:02:53',2970,173,'2005-08-26 04:13:53',1,'2006-02-15 21:30:53'),
 (15484,'2005-08-23 02:04:49',642,342,'2005-08-24 05:46:49',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15485,'2005-08-23 02:04:57',281,114,'2005-08-28 07:05:57',2,'2006-02-15 21:30:53'),
 (15486,'2005-08-23 02:05:20',1666,502,'2005-08-29 07:52:20',2,'2006-02-15 21:30:53'),
 (15487,'2005-08-23 02:05:51',2636,469,'2005-08-25 04:45:51',1,'2006-02-15 21:30:53'),
 (15488,'2005-08-23 02:06:01',4535,385,'2005-08-29 21:35:01',2,'2006-02-15 21:30:53'),
 (15489,'2005-08-23 02:06:41',764,285,'2005-08-25 06:50:41',1,'2006-02-15 21:30:53'),
 (15490,'2005-08-23 02:08:18',3922,493,'2005-08-30 06:15:18',1,'2006-02-15 21:30:53'),
 (15491,'2005-08-23 02:08:40',2059,28,'2005-08-23 20:23:40',2,'2006-02-15 21:30:53'),
 (15492,'2005-08-23 02:13:46',1298,520,'2005-08-26 21:53:46',2,'2006-02-15 21:30:53'),
 (15493,'2005-08-23 02:20:53',3521,308,'2005-08-25 23:02:53',1,'2006-02-15 21:30:53'),
 (15494,'2005-08-23 02:25:09',2968,455,'2005-08-27 00:18:09',1,'2006-02-15 21:30:53'),
 (15495,'2005-08-23 02:26:10',4310,193,'2005-08-30 01:07:10',2,'2006-02-15 21:30:53'),
 (15496,'2005-08-23 02:30:23',1863,275,'2005-08-31 03:31:23',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15497,'2006-02-14 15:16:03',363,107,NULL,1,'2006-02-15 21:30:53'),
 (15498,'2005-08-23 02:33:27',1583,83,'2005-08-23 22:30:27',1,'2006-02-15 21:30:53'),
 (15499,'2005-08-23 02:37:19',630,488,'2005-08-23 20:57:19',1,'2006-02-15 21:30:53'),
 (15500,'2005-08-23 02:39:37',886,74,'2005-08-27 06:42:37',1,'2006-02-15 21:30:53'),
 (15501,'2005-08-23 02:39:56',4468,138,'2005-08-25 04:39:56',1,'2006-02-15 21:30:53'),
 (15502,'2005-08-23 02:40:04',3219,433,'2005-08-31 00:36:04',2,'2006-02-15 21:30:53'),
 (15503,'2005-08-23 02:44:49',4519,582,'2005-08-27 06:33:49',2,'2006-02-15 21:30:53'),
 (15504,'2005-08-23 02:45:21',1967,315,'2005-09-01 03:24:21',2,'2006-02-15 21:30:53'),
 (15505,'2005-08-23 02:46:13',1144,375,'2005-08-26 23:34:13',2,'2006-02-15 21:30:53'),
 (15506,'2005-08-23 02:48:24',1914,553,'2005-08-28 04:10:24',1,'2006-02-15 21:30:53'),
 (15507,'2005-08-23 02:48:26',3130,563,'2005-08-27 01:32:26',1,'2006-02-15 21:30:53'),
 (15508,'2005-08-23 02:49:04',4035,293,'2005-08-29 00:58:04',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15509,'2005-08-23 02:51:24',1291,6,'2005-08-31 06:21:24',2,'2006-02-15 21:30:53'),
 (15510,'2005-08-23 02:51:27',3239,209,'2005-09-01 02:44:27',2,'2006-02-15 21:30:53'),
 (15511,'2005-08-23 02:55:42',3327,303,'2005-08-31 03:14:42',2,'2006-02-15 21:30:53'),
 (15512,'2005-08-23 02:57:30',4336,25,'2005-08-25 01:47:30',2,'2006-02-15 21:30:53'),
 (15513,'2005-08-23 03:01:56',3779,147,'2005-08-24 23:46:56',2,'2006-02-15 21:30:53'),
 (15514,'2005-08-23 03:03:40',2824,366,'2005-08-24 01:06:40',1,'2006-02-15 21:30:53'),
 (15515,'2005-08-23 03:03:53',3940,307,'2005-08-25 08:27:53',2,'2006-02-15 21:30:53'),
 (15516,'2005-08-23 03:12:54',219,82,'2005-08-30 04:02:54',1,'2006-02-15 21:30:53'),
 (15517,'2005-08-23 03:13:01',2221,187,'2005-08-25 21:14:01',2,'2006-02-15 21:30:53'),
 (15518,'2005-08-23 03:19:34',3522,410,'2005-08-24 02:55:34',1,'2006-02-15 21:30:53'),
 (15519,'2005-08-23 03:23:32',542,443,'2005-08-25 03:48:32',1,'2006-02-15 21:30:53'),
 (15520,'2005-08-23 03:30:45',1792,163,'2005-09-01 00:20:45',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15521,'2005-08-23 03:30:51',134,331,'2005-08-28 22:09:51',1,'2006-02-15 21:30:53'),
 (15522,'2005-08-23 03:32:31',2396,468,'2005-08-30 02:17:31',2,'2006-02-15 21:30:53'),
 (15523,'2005-08-23 03:32:36',2570,432,'2005-08-26 22:08:36',2,'2006-02-15 21:30:53'),
 (15524,'2005-08-23 03:36:26',2886,68,'2005-08-26 06:28:26',2,'2006-02-15 21:30:53'),
 (15525,'2005-08-23 03:43:32',3509,123,'2005-08-25 07:31:32',2,'2006-02-15 21:30:53'),
 (15526,'2005-08-23 03:44:30',2892,516,'2005-08-30 08:19:30',1,'2006-02-15 21:30:53'),
 (15527,'2005-08-23 03:44:51',88,393,'2005-08-25 03:09:51',1,'2006-02-15 21:30:53'),
 (15528,'2005-08-23 03:45:40',3033,114,'2005-08-25 01:16:40',1,'2006-02-15 21:30:53'),
 (15529,'2005-08-23 03:46:47',4015,19,'2005-08-24 00:59:47',1,'2006-02-15 21:30:53'),
 (15530,'2005-08-23 03:50:48',154,167,'2005-08-28 22:17:48',2,'2006-02-15 21:30:53'),
 (15531,'2005-08-23 03:52:36',2410,355,'2005-08-25 23:21:36',1,'2006-02-15 21:30:53'),
 (15532,'2006-02-14 15:16:03',1061,23,NULL,1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15533,'2005-08-23 03:54:39',1895,400,'2005-08-26 08:27:39',2,'2006-02-15 21:30:53'),
 (15534,'2005-08-23 03:55:54',544,169,'2005-08-24 03:54:54',1,'2006-02-15 21:30:53'),
 (15535,'2005-08-23 03:58:02',2371,346,'2005-08-25 05:06:02',2,'2006-02-15 21:30:53'),
 (15536,'2005-08-23 03:58:28',4004,98,'2005-08-31 03:28:28',2,'2006-02-15 21:30:53'),
 (15537,'2005-08-23 04:00:30',2958,137,'2005-08-24 01:45:30',2,'2006-02-15 21:30:53'),
 (15538,'2005-08-23 04:07:37',4226,211,'2005-08-28 07:37:37',1,'2006-02-15 21:30:53'),
 (15539,'2005-08-23 04:09:03',2853,582,'2005-08-26 04:01:03',1,'2006-02-15 21:30:53'),
 (15540,'2005-08-23 04:12:52',1696,197,'2005-08-31 04:25:52',1,'2006-02-15 21:30:53'),
 (15541,'2005-08-23 04:13:53',2762,148,'2005-08-29 05:51:53',1,'2006-02-15 21:30:53'),
 (15542,'2006-02-14 15:16:03',21,111,NULL,1,'2006-02-15 21:30:53'),
 (15543,'2005-08-23 04:15:41',3836,282,'2005-09-01 05:09:41',2,'2006-02-15 21:30:53'),
 (15544,'2005-08-23 04:17:56',1918,30,'2005-09-01 00:43:56',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15545,'2005-08-23 04:20:16',843,513,'2005-08-29 08:22:16',1,'2006-02-15 21:30:53'),
 (15546,'2005-08-23 04:20:38',2087,223,'2005-09-01 09:57:38',2,'2006-02-15 21:30:53'),
 (15547,'2005-08-23 04:25:50',1488,69,'2005-08-26 00:57:50',1,'2006-02-15 21:30:53'),
 (15548,'2005-08-23 04:26:20',2350,334,'2005-08-28 01:27:20',1,'2006-02-15 21:30:53'),
 (15549,'2005-08-23 04:27:06',369,170,'2005-09-01 06:07:06',1,'2006-02-15 21:30:53'),
 (15550,'2005-08-23 04:27:54',1375,465,'2005-08-29 01:29:54',1,'2006-02-15 21:30:53'),
 (15551,'2005-08-23 04:28:25',3570,345,'2005-08-26 07:19:25',1,'2006-02-15 21:30:53'),
 (15552,'2005-08-23 04:33:23',4347,527,'2005-09-01 10:25:23',2,'2006-02-15 21:30:53'),
 (15553,'2005-08-23 04:33:39',1659,232,'2005-08-25 07:53:39',2,'2006-02-15 21:30:53'),
 (15554,'2005-08-23 04:48:12',198,280,'2005-08-29 05:11:12',1,'2006-02-15 21:30:53'),
 (15555,'2005-08-23 04:51:52',1869,347,'2005-08-24 01:01:52',1,'2006-02-15 21:30:53'),
 (15556,'2005-08-23 04:52:16',3683,108,'2005-09-01 02:05:16',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15557,'2005-08-23 04:52:17',3641,444,'2005-08-30 02:15:17',2,'2006-02-15 21:30:53'),
 (15558,'2005-08-23 04:52:22',638,474,'2005-09-01 02:26:22',1,'2006-02-15 21:30:53'),
 (15559,'2005-08-23 04:55:05',1773,517,'2005-08-30 09:01:05',2,'2006-02-15 21:30:53'),
 (15560,'2005-08-23 05:01:13',3616,107,'2005-09-01 05:02:13',1,'2006-02-15 21:30:53'),
 (15561,'2005-08-23 05:02:31',68,469,'2005-09-01 02:51:31',1,'2006-02-15 21:30:53'),
 (15562,'2005-08-23 05:04:33',4238,149,'2005-08-27 09:58:33',1,'2006-02-15 21:30:53'),
 (15563,'2005-08-23 05:08:58',170,372,'2005-08-24 04:24:58',1,'2006-02-15 21:30:53'),
 (15564,'2005-08-23 05:10:42',1268,353,'2005-08-30 03:17:42',1,'2006-02-15 21:30:53'),
 (15565,'2005-08-23 05:13:09',71,546,'2005-08-30 08:58:09',2,'2006-02-15 21:30:53'),
 (15566,'2005-08-23 05:17:23',4344,76,'2005-09-01 08:09:23',2,'2006-02-15 21:30:53'),
 (15567,'2005-08-23 05:20:36',2506,54,'2005-08-24 10:09:36',2,'2006-02-15 21:30:53'),
 (15568,'2005-08-23 05:24:09',988,556,'2005-08-27 08:57:09',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15569,'2005-08-23 05:24:29',1071,313,'2005-08-30 08:23:29',2,'2006-02-15 21:30:53'),
 (15570,'2005-08-23 05:24:55',4014,557,'2005-08-31 07:06:55',2,'2006-02-15 21:30:53'),
 (15571,'2005-08-23 05:26:30',716,57,'2005-08-29 00:54:30',2,'2006-02-15 21:30:53'),
 (15572,'2005-08-23 05:28:01',2816,506,'2005-08-27 00:14:01',2,'2006-02-15 21:30:53'),
 (15573,'2005-08-23 05:28:36',3133,561,'2005-08-27 05:37:36',2,'2006-02-15 21:30:53'),
 (15574,'2005-08-23 05:29:32',3253,130,'2005-09-01 01:25:32',2,'2006-02-15 21:30:53'),
 (15575,'2005-08-23 05:30:19',3916,218,'2005-08-27 05:19:19',2,'2006-02-15 21:30:53'),
 (15576,'2005-08-23 05:32:03',3257,595,'2005-08-26 02:31:03',1,'2006-02-15 21:30:53'),
 (15577,'2006-02-14 15:16:03',539,29,NULL,2,'2006-02-15 21:30:53'),
 (15578,'2005-08-23 05:37:13',2829,302,'2005-08-27 01:11:13',1,'2006-02-15 21:30:53'),
 (15579,'2005-08-23 05:38:41',3986,480,'2005-08-29 09:18:41',1,'2006-02-15 21:30:53'),
 (15580,'2005-08-23 05:39:06',754,279,'2005-09-01 01:14:06',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15581,'2005-08-23 05:42:13',4010,462,'2005-08-28 00:03:13',1,'2006-02-15 21:30:53'),
 (15582,'2005-08-23 05:45:44',4264,297,'2005-08-25 07:54:44',2,'2006-02-15 21:30:53'),
 (15583,'2005-08-23 05:47:55',4299,215,'2005-08-26 01:46:55',1,'2006-02-15 21:30:53'),
 (15584,'2005-08-23 05:49:21',3526,500,'2005-08-27 04:49:21',1,'2006-02-15 21:30:53'),
 (15585,'2005-08-23 05:55:22',1177,545,'2005-08-24 11:45:22',2,'2006-02-15 21:30:53'),
 (15586,'2005-08-23 05:57:04',3232,148,'2005-08-31 01:59:04',1,'2006-02-15 21:30:53'),
 (15587,'2005-08-23 06:00:28',2510,499,'2005-08-29 10:15:28',1,'2006-02-15 21:30:53'),
 (15588,'2005-08-23 06:02:35',1810,503,'2005-08-30 04:01:35',2,'2006-02-15 21:30:53'),
 (15589,'2005-08-23 06:03:31',2379,22,'2005-08-30 07:44:31',2,'2006-02-15 21:30:53'),
 (15590,'2005-08-23 06:09:44',4048,599,'2005-09-01 06:53:44',2,'2006-02-15 21:30:53'),
 (15591,'2005-08-23 06:11:52',64,62,'2005-08-25 05:34:52',1,'2006-02-15 21:30:53'),
 (15593,'2005-08-23 06:15:09',3734,153,'2005-08-27 07:47:09',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15594,'2005-08-23 06:18:43',4227,567,'2005-09-01 09:09:43',2,'2006-02-15 21:30:53'),
 (15595,'2005-08-23 06:19:12',4046,264,'2005-08-31 04:52:12',1,'2006-02-15 21:30:53'),
 (15596,'2005-08-23 06:19:51',3834,186,'2005-08-25 03:32:51',1,'2006-02-15 21:30:53'),
 (15597,'2005-08-23 06:21:20',3795,420,'2005-08-28 02:47:20',2,'2006-02-15 21:30:53'),
 (15598,'2005-08-23 06:23:26',2794,66,'2005-09-01 05:43:26',1,'2006-02-15 21:30:53'),
 (15599,'2005-08-23 06:25:07',4560,103,'2005-08-29 00:48:07',1,'2006-02-15 21:30:53'),
 (15600,'2005-08-23 06:31:24',2260,113,'2005-08-28 06:53:24',1,'2006-02-15 21:30:53'),
 (15601,'2005-08-23 06:33:26',3643,579,'2005-08-24 04:10:26',1,'2006-02-15 21:30:53'),
 (15602,'2005-08-23 06:41:07',1429,81,'2005-08-24 07:16:07',1,'2006-02-15 21:30:53'),
 (15603,'2005-08-23 06:41:32',2565,6,'2005-08-28 08:51:32',1,'2006-02-15 21:30:53'),
 (15604,'2005-08-23 06:44:19',4000,458,'2005-08-29 07:17:19',1,'2006-02-15 21:30:53'),
 (15605,'2005-08-23 06:48:47',3152,544,'2005-08-28 06:09:47',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15606,'2005-08-23 06:50:27',1811,279,'2005-08-28 04:23:27',2,'2006-02-15 21:30:53'),
 (15607,'2005-08-23 06:54:06',4118,484,'2005-08-26 05:03:06',2,'2006-02-15 21:30:53'),
 (15608,'2005-08-23 06:55:26',2921,454,'2005-08-28 10:24:26',1,'2006-02-15 21:30:53'),
 (15609,'2005-08-23 06:56:04',1730,256,'2005-09-01 03:25:04',1,'2006-02-15 21:30:53'),
 (15610,'2005-08-23 06:56:15',2076,215,'2005-08-24 07:37:15',2,'2006-02-15 21:30:53'),
 (15611,'2005-08-23 06:56:18',1713,184,'2005-08-25 06:10:18',1,'2006-02-15 21:30:53'),
 (15612,'2005-08-23 06:59:07',3367,305,'2005-09-01 11:26:07',2,'2006-02-15 21:30:53'),
 (15613,'2005-08-23 07:03:19',307,461,'2005-08-31 07:50:19',2,'2006-02-15 21:30:53'),
 (15614,'2005-08-23 07:05:15',1216,287,'2005-09-01 11:41:15',1,'2006-02-15 21:30:53'),
 (15615,'2005-08-23 07:06:00',899,584,'2005-08-30 11:21:00',2,'2006-02-15 21:30:53'),
 (15616,'2005-08-23 07:06:38',2947,70,'2005-08-30 04:16:38',1,'2006-02-15 21:30:53'),
 (15617,'2005-08-23 07:07:22',4085,569,'2005-08-27 01:24:22',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15618,'2005-08-23 07:07:58',1903,60,'2005-08-29 03:48:58',1,'2006-02-15 21:30:53'),
 (15619,'2005-08-23 07:10:14',2468,3,'2005-08-26 07:21:14',2,'2006-02-15 21:30:53'),
 (15620,'2005-08-23 07:10:22',1173,270,'2005-08-28 06:51:22',2,'2006-02-15 21:30:53'),
 (15621,'2005-08-23 07:13:43',3832,123,'2005-08-29 08:19:43',1,'2006-02-15 21:30:53'),
 (15622,'2005-08-23 07:22:02',3335,302,'2005-09-01 06:08:02',2,'2006-02-15 21:30:53'),
 (15623,'2005-08-23 07:23:29',3003,525,'2005-08-31 01:47:29',1,'2006-02-15 21:30:53'),
 (15624,'2005-08-23 07:24:27',396,105,'2005-08-29 12:36:27',2,'2006-02-15 21:30:53'),
 (15625,'2005-08-23 07:25:29',4200,207,'2005-08-27 13:17:29',2,'2006-02-15 21:30:53'),
 (15626,'2005-08-23 07:25:34',640,370,'2005-08-28 11:01:34',1,'2006-02-15 21:30:53'),
 (15627,'2005-08-23 07:25:38',1364,453,'2005-08-31 02:53:38',2,'2006-02-15 21:30:53'),
 (15628,'2005-08-23 07:28:04',1348,408,'2005-08-26 04:23:04',1,'2006-02-15 21:30:53'),
 (15629,'2005-08-23 07:28:22',3725,286,'2005-08-29 06:29:22',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15630,'2005-08-23 07:29:13',3590,580,'2005-08-31 04:33:13',2,'2006-02-15 21:30:53'),
 (15631,'2005-08-23 07:30:23',2458,93,'2005-08-24 07:23:23',1,'2006-02-15 21:30:53'),
 (15632,'2005-08-23 07:30:26',2941,60,'2005-08-24 07:53:26',2,'2006-02-15 21:30:53'),
 (15633,'2005-08-23 07:31:10',882,497,'2005-08-26 04:35:10',2,'2006-02-15 21:30:53'),
 (15634,'2005-08-23 07:34:18',2517,576,'2005-08-24 12:00:18',2,'2006-02-15 21:30:53'),
 (15635,'2005-08-23 07:43:00',3308,4,'2005-08-27 10:47:00',1,'2006-02-15 21:30:53'),
 (15636,'2005-08-23 07:50:46',1169,380,'2005-08-26 07:59:46',2,'2006-02-15 21:30:53'),
 (15637,'2005-08-23 07:53:38',445,172,'2005-08-29 03:16:38',2,'2006-02-15 21:30:53'),
 (15638,'2005-08-23 07:54:54',3358,563,'2005-08-30 13:33:54',2,'2006-02-15 21:30:53'),
 (15639,'2005-08-23 08:03:25',42,214,'2005-08-24 10:21:25',2,'2006-02-15 21:30:53'),
 (15640,'2005-08-23 08:04:40',3505,262,'2005-08-24 06:38:40',1,'2006-02-15 21:30:53'),
 (15641,'2005-08-23 08:06:49',3126,240,'2005-08-24 13:17:49',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15642,'2005-08-23 08:09:11',2627,160,'2005-08-28 05:57:11',1,'2006-02-15 21:30:53'),
 (15643,'2005-08-23 08:13:26',103,298,'2005-08-25 05:18:26',2,'2006-02-15 21:30:53'),
 (15644,'2006-02-14 15:16:03',3139,43,NULL,2,'2006-02-15 21:30:53'),
 (15645,'2006-02-14 15:16:03',3838,214,NULL,2,'2006-02-15 21:30:53'),
 (15646,'2005-08-23 08:19:55',3217,114,'2005-08-29 02:32:55',1,'2006-02-15 21:30:53'),
 (15647,'2005-08-23 08:23:56',2051,251,'2005-08-26 11:00:56',1,'2006-02-15 21:30:53'),
 (15648,'2005-08-23 08:27:57',4039,80,'2005-08-30 08:53:57',2,'2006-02-15 21:30:53'),
 (15649,'2005-08-23 08:28:03',415,60,'2005-08-30 05:11:03',1,'2006-02-15 21:30:53'),
 (15650,'2005-08-23 08:29:53',2447,353,'2005-08-25 07:23:53',2,'2006-02-15 21:30:53'),
 (15651,'2005-08-23 08:31:49',3393,451,'2005-08-26 02:57:49',1,'2006-02-15 21:30:53'),
 (15652,'2005-08-23 08:34:10',4440,578,'2005-08-30 12:31:10',1,'2006-02-15 21:30:53'),
 (15653,'2005-08-23 08:34:42',2736,439,'2005-09-01 03:07:42',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15654,'2005-08-23 08:34:53',4360,471,'2005-08-30 04:18:53',2,'2006-02-15 21:30:53'),
 (15655,'2006-02-14 15:16:03',604,359,NULL,1,'2006-02-15 21:30:53'),
 (15656,'2005-08-23 08:38:58',4239,334,'2005-08-24 04:08:58',2,'2006-02-15 21:30:53'),
 (15657,'2005-08-23 08:42:40',1897,36,'2005-09-01 13:08:40',1,'2006-02-15 21:30:53'),
 (15658,'2005-08-23 08:48:43',3565,22,'2005-08-25 05:38:43',1,'2006-02-15 21:30:53'),
 (15659,'2005-08-23 08:48:43',4573,131,'2005-08-27 14:19:43',2,'2006-02-15 21:30:53'),
 (15660,'2005-08-23 08:51:21',3223,388,'2005-08-28 06:26:21',2,'2006-02-15 21:30:53'),
 (15661,'2005-08-23 08:52:03',1599,346,'2005-08-30 08:17:03',2,'2006-02-15 21:30:53'),
 (15662,'2005-08-23 08:52:50',3028,223,'2005-08-24 08:08:50',1,'2006-02-15 21:30:53'),
 (15663,'2005-08-23 08:54:26',3291,291,'2005-08-29 02:56:26',1,'2006-02-15 21:30:53'),
 (15664,'2005-08-23 08:57:11',2029,351,'2005-08-31 14:19:11',2,'2006-02-15 21:30:53'),
 (15665,'2005-08-23 08:59:12',3471,487,'2005-08-24 12:50:12',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15666,'2005-08-23 09:01:10',3406,586,'2005-08-31 12:32:10',2,'2006-02-15 21:30:53'),
 (15667,'2005-08-23 09:02:03',1302,73,'2005-08-24 05:47:03',1,'2006-02-15 21:30:53'),
 (15668,'2005-08-23 09:02:04',1963,38,'2005-08-29 03:17:04',2,'2006-02-15 21:30:53'),
 (15669,'2005-08-23 09:06:17',1542,334,'2005-08-30 08:10:17',2,'2006-02-15 21:30:53'),
 (15670,'2005-08-23 09:07:11',2834,211,'2005-08-31 04:32:11',2,'2006-02-15 21:30:53'),
 (15671,'2005-08-23 09:08:16',3716,112,'2005-08-29 14:01:16',1,'2006-02-15 21:30:53'),
 (15672,'2005-08-23 09:09:18',701,210,'2005-08-27 06:19:18',1,'2006-02-15 21:30:53'),
 (15673,'2005-08-23 09:12:50',3096,321,'2005-08-29 12:45:50',2,'2006-02-15 21:30:53'),
 (15674,'2005-08-23 09:16:39',4482,90,'2005-09-01 11:57:39',1,'2006-02-15 21:30:53'),
 (15675,'2005-08-23 09:18:52',4153,293,'2005-08-30 14:59:52',2,'2006-02-15 21:30:53'),
 (15676,'2005-08-23 09:23:08',3874,353,'2005-08-30 06:19:08',2,'2006-02-15 21:30:53'),
 (15677,'2005-08-23 09:23:36',2050,109,'2005-08-27 05:01:36',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15678,'2005-08-23 09:23:45',1345,413,'2005-08-27 11:38:45',2,'2006-02-15 21:30:53'),
 (15679,'2005-08-23 09:27:29',2945,103,'2005-08-28 09:14:29',1,'2006-02-15 21:30:53'),
 (15680,'2005-08-23 09:33:22',1370,169,'2005-08-31 13:29:22',2,'2006-02-15 21:30:53'),
 (15681,'2005-08-23 09:35:34',2813,61,'2005-08-27 08:33:34',1,'2006-02-15 21:30:53'),
 (15682,'2005-08-23 09:37:34',3293,31,'2005-08-31 06:01:34',1,'2006-02-15 21:30:53'),
 (15683,'2005-08-23 09:38:17',3787,168,'2005-08-30 12:31:17',2,'2006-02-15 21:30:53'),
 (15684,'2005-08-23 09:40:04',3976,586,'2005-08-28 15:28:04',1,'2006-02-15 21:30:53'),
 (15685,'2005-08-23 09:41:28',370,491,'2005-08-30 10:11:28',1,'2006-02-15 21:30:53'),
 (15686,'2005-08-23 09:42:21',2041,206,'2005-08-29 12:22:21',1,'2006-02-15 21:30:53'),
 (15687,'2005-08-23 09:46:33',276,112,'2005-09-01 06:07:33',1,'2006-02-15 21:30:53'),
 (15688,'2005-08-23 09:48:45',2851,105,'2005-08-30 10:28:45',2,'2006-02-15 21:30:53'),
 (15689,'2005-08-23 09:52:55',248,259,'2005-08-29 11:15:55',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15690,'2005-08-23 09:53:30',2102,554,'2005-08-29 10:27:30',1,'2006-02-15 21:30:53'),
 (15691,'2005-08-23 09:53:54',784,200,'2005-08-27 10:14:54',1,'2006-02-15 21:30:53'),
 (15692,'2005-08-23 10:00:02',1852,503,'2005-08-24 05:25:02',1,'2006-02-15 21:30:53'),
 (15693,'2005-08-23 10:00:24',748,94,'2005-08-25 08:23:24',1,'2006-02-15 21:30:53'),
 (15694,'2005-08-23 10:02:46',3017,506,'2005-08-31 05:46:46',2,'2006-02-15 21:30:53'),
 (15695,'2006-02-14 15:16:03',2954,300,NULL,1,'2006-02-15 21:30:53'),
 (15696,'2005-08-23 10:04:17',2836,93,'2005-08-25 08:47:17',2,'2006-02-15 21:30:53'),
 (15697,'2005-08-23 10:04:36',1987,380,'2005-08-24 05:00:36',2,'2006-02-15 21:30:53'),
 (15698,'2005-08-23 10:11:40',4465,395,'2005-08-28 08:50:40',2,'2006-02-15 21:30:53'),
 (15699,'2005-08-23 10:20:35',4155,501,'2005-08-30 13:56:35',1,'2006-02-15 21:30:53'),
 (15700,'2005-08-23 10:21:21',2935,552,'2005-08-24 15:37:21',1,'2006-02-15 21:30:53'),
 (15701,'2005-08-23 10:22:21',2942,516,'2005-08-24 10:52:21',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15702,'2005-08-23 10:23:28',1602,56,'2005-08-29 11:08:28',2,'2006-02-15 21:30:53'),
 (15703,'2005-08-23 10:23:48',2883,322,'2005-09-01 06:54:48',2,'2006-02-15 21:30:53'),
 (15704,'2005-08-23 10:25:45',738,71,'2005-08-29 16:06:45',2,'2006-02-15 21:30:53'),
 (15705,'2005-08-23 10:32:52',936,356,'2005-08-29 13:18:52',2,'2006-02-15 21:30:53'),
 (15706,'2005-08-23 10:32:52',4486,220,'2005-08-24 07:03:52',2,'2006-02-15 21:30:53'),
 (15707,'2005-08-23 10:35:45',3646,91,'2005-08-27 10:57:45',1,'2006-02-15 21:30:53'),
 (15708,'2005-08-23 10:35:51',1974,46,'2005-08-27 16:02:51',1,'2006-02-15 21:30:53'),
 (15709,'2005-08-23 10:36:00',346,206,'2005-08-28 06:18:00',2,'2006-02-15 21:30:53'),
 (15710,'2006-02-14 15:16:03',1020,421,NULL,1,'2006-02-15 21:30:53'),
 (15711,'2005-08-23 10:43:00',789,297,'2005-08-29 16:29:00',1,'2006-02-15 21:30:53'),
 (15712,'2005-08-23 10:43:56',1882,351,'2005-08-29 15:35:56',2,'2006-02-15 21:30:53'),
 (15713,'2005-08-23 10:56:15',337,432,'2005-08-29 09:14:15',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15714,'2006-02-14 15:16:03',2083,56,NULL,1,'2006-02-15 21:30:53'),
 (15715,'2005-08-23 10:57:40',3808,86,'2005-08-28 12:40:40',1,'2006-02-15 21:30:53'),
 (15716,'2005-08-23 11:02:00',2812,408,'2005-08-28 14:46:00',1,'2006-02-15 21:30:53'),
 (15717,'2006-02-14 15:16:03',902,208,NULL,2,'2006-02-15 21:30:53'),
 (15718,'2005-08-23 11:05:17',2180,276,'2005-08-28 12:50:17',1,'2006-02-15 21:30:53'),
 (15719,'2005-08-23 11:08:46',3990,599,'2005-08-25 07:25:46',1,'2006-02-15 21:30:53'),
 (15720,'2005-08-23 11:15:20',2490,456,'2005-08-31 09:49:20',1,'2006-02-15 21:30:53'),
 (15721,'2005-08-23 11:16:16',685,154,'2005-08-28 10:21:16',1,'2006-02-15 21:30:53'),
 (15722,'2005-08-23 11:16:29',2809,26,'2005-09-01 13:24:29',2,'2006-02-15 21:30:53'),
 (15723,'2005-08-23 11:17:26',3915,504,'2005-08-31 13:58:26',2,'2006-02-15 21:30:53'),
 (15724,'2005-08-23 11:22:09',1025,478,'2005-08-28 12:56:09',2,'2006-02-15 21:30:53'),
 (15725,'2005-08-23 11:25:00',378,599,'2005-08-26 11:46:00',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15726,'2005-08-23 11:28:26',906,503,'2005-08-28 11:23:26',2,'2006-02-15 21:30:53'),
 (15727,'2005-08-23 11:28:49',2184,416,'2005-08-24 06:24:49',2,'2006-02-15 21:30:53'),
 (15728,'2005-08-23 11:30:32',2567,323,'2005-08-28 09:52:32',2,'2006-02-15 21:30:53'),
 (15729,'2006-02-14 15:16:03',2699,193,NULL,2,'2006-02-15 21:30:53'),
 (15730,'2005-08-23 11:32:35',947,147,'2005-08-30 13:46:35',2,'2006-02-15 21:30:53'),
 (15731,'2005-08-23 11:33:25',3403,118,'2005-08-24 07:19:25',2,'2006-02-15 21:30:53'),
 (15732,'2005-08-23 11:35:12',3247,412,'2005-08-26 12:50:12',2,'2006-02-15 21:30:53'),
 (15733,'2005-08-23 11:37:32',4185,512,'2005-08-28 16:27:32',1,'2006-02-15 21:30:53'),
 (15734,'2005-08-23 11:40:08',3952,302,'2005-08-27 08:16:08',1,'2006-02-15 21:30:53'),
 (15735,'2006-02-14 15:16:03',3167,295,NULL,1,'2006-02-15 21:30:53'),
 (15736,'2005-08-23 11:40:30',4272,127,'2005-08-30 12:40:30',1,'2006-02-15 21:30:53'),
 (15737,'2005-08-23 11:52:18',996,83,'2005-08-28 15:28:18',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15738,'2005-08-23 11:55:50',556,38,'2005-08-30 15:07:50',1,'2006-02-15 21:30:53'),
 (15739,'2005-08-23 11:56:22',266,74,'2005-08-29 16:10:22',2,'2006-02-15 21:30:53'),
 (15740,'2005-08-23 12:07:51',100,229,'2005-08-24 13:23:51',2,'2006-02-15 21:30:53'),
 (15741,'2005-08-23 12:10:54',4243,126,'2005-08-24 10:08:54',2,'2006-02-15 21:30:53'),
 (15742,'2005-08-23 12:11:37',1339,200,'2005-08-31 07:28:37',2,'2006-02-15 21:30:53'),
 (15743,'2005-08-23 12:12:05',1625,139,'2005-08-26 11:35:05',1,'2006-02-15 21:30:53'),
 (15744,'2005-08-23 12:15:51',2364,59,'2005-08-31 17:19:51',1,'2006-02-15 21:30:53'),
 (15745,'2006-02-14 15:16:03',2737,43,NULL,1,'2006-02-15 21:30:53'),
 (15746,'2005-08-23 12:26:19',2241,246,'2005-08-26 09:51:19',2,'2006-02-15 21:30:53'),
 (15747,'2005-08-23 12:29:24',1517,381,'2005-08-31 08:27:24',2,'2006-02-15 21:30:53'),
 (15748,'2005-08-23 12:33:00',2757,380,'2005-08-25 15:15:00',2,'2006-02-15 21:30:53'),
 (15749,'2005-08-23 12:33:41',4224,575,'2005-08-24 10:52:41',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15750,'2005-08-23 12:36:05',4474,496,'2005-08-24 17:40:05',2,'2006-02-15 21:30:53'),
 (15751,'2005-08-23 12:41:07',697,199,'2005-08-29 07:03:07',2,'2006-02-15 21:30:53'),
 (15752,'2005-08-23 12:41:38',2112,17,'2005-09-01 14:06:38',1,'2006-02-15 21:30:53'),
 (15753,'2005-08-23 12:43:30',3451,144,'2005-09-01 09:07:30',2,'2006-02-15 21:30:53'),
 (15754,'2005-08-23 12:43:42',2306,356,'2005-08-27 17:45:42',2,'2006-02-15 21:30:53'),
 (15755,'2005-08-23 12:46:38',511,423,'2005-08-25 12:59:38',1,'2006-02-15 21:30:53'),
 (15756,'2005-08-23 12:47:05',878,112,'2005-08-28 08:34:05',2,'2006-02-15 21:30:53'),
 (15757,'2005-08-23 12:47:16',1308,356,'2005-08-29 17:19:16',1,'2006-02-15 21:30:53'),
 (15758,'2005-08-23 12:47:26',152,46,'2005-08-29 11:05:26',2,'2006-02-15 21:30:53'),
 (15759,'2005-08-23 12:47:37',1341,361,'2005-09-01 11:28:37',2,'2006-02-15 21:30:53'),
 (15760,'2005-08-23 12:50:00',3050,273,'2005-08-29 15:41:00',2,'2006-02-15 21:30:53'),
 (15761,'2005-08-23 12:55:51',4362,416,'2005-08-26 16:51:51',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15762,'2005-08-23 13:01:43',887,351,'2005-08-26 16:35:43',1,'2006-02-15 21:30:53'),
 (15763,'2005-08-23 13:02:59',124,158,'2005-08-24 17:45:59',2,'2006-02-15 21:30:53'),
 (15764,'2005-08-23 13:05:10',2937,8,'2005-08-25 16:15:10',1,'2006-02-15 21:30:53'),
 (15765,'2005-08-23 13:06:19',1250,408,'2005-08-31 12:18:19',1,'2006-02-15 21:30:53'),
 (15766,'2005-08-23 13:10:16',1996,436,'2005-08-30 09:27:16',1,'2006-02-15 21:30:53'),
 (15767,'2005-08-23 13:14:15',3492,241,'2005-08-27 14:43:15',2,'2006-02-15 21:30:53'),
 (15768,'2005-08-23 13:14:47',662,267,'2005-08-29 14:17:47',2,'2006-02-15 21:30:53'),
 (15769,'2005-08-23 13:16:15',2392,276,'2005-08-28 18:31:15',1,'2006-02-15 21:30:53'),
 (15770,'2005-08-23 13:18:16',1424,113,'2005-08-29 11:31:16',1,'2006-02-15 21:30:53'),
 (15771,'2005-08-23 13:18:46',3667,262,'2005-08-26 07:29:46',1,'2006-02-15 21:30:53'),
 (15772,'2005-08-23 13:22:56',4343,202,'2005-08-26 10:35:56',2,'2006-02-15 21:30:53'),
 (15773,'2005-08-23 13:24:57',1626,189,'2005-08-31 14:16:57',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15774,'2005-08-23 13:25:08',1273,254,'2005-08-28 10:08:08',2,'2006-02-15 21:30:53'),
 (15775,'2005-08-23 13:25:44',2146,173,'2005-09-01 16:56:44',1,'2006-02-15 21:30:53'),
 (15776,'2005-08-23 13:26:01',43,514,'2005-08-29 18:17:01',1,'2006-02-15 21:30:53'),
 (15777,'2005-08-23 13:29:08',4241,130,'2005-08-27 18:50:08',2,'2006-02-15 21:30:53'),
 (15778,'2006-02-14 15:16:03',1269,234,NULL,1,'2006-02-15 21:30:53'),
 (15779,'2005-08-23 13:33:46',1560,419,'2005-08-28 08:40:46',2,'2006-02-15 21:30:53'),
 (15780,'2006-02-14 15:16:03',2911,120,NULL,2,'2006-02-15 21:30:53'),
 (15781,'2005-08-23 13:41:05',4449,412,'2005-08-31 13:11:05',1,'2006-02-15 21:30:53'),
 (15782,'2005-08-23 13:43:26',3282,245,'2005-08-30 14:03:26',1,'2006-02-15 21:30:53'),
 (15783,'2005-08-23 13:45:44',397,247,'2005-08-26 09:18:44',2,'2006-02-15 21:30:53'),
 (15784,'2005-08-23 13:46:00',126,425,'2005-08-30 11:49:00',2,'2006-02-15 21:30:53'),
 (15785,'2005-08-23 13:46:27',1758,543,'2005-08-27 10:16:27',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15786,'2005-08-23 13:48:34',3132,371,'2005-08-27 15:59:34',1,'2006-02-15 21:30:53'),
 (15787,'2005-08-23 13:51:57',2932,123,'2005-08-27 17:06:57',1,'2006-02-15 21:30:53'),
 (15788,'2005-08-23 13:54:39',13,269,'2005-08-26 10:17:39',1,'2006-02-15 21:30:53'),
 (15789,'2005-08-23 13:56:40',1213,350,'2005-08-27 15:25:40',1,'2006-02-15 21:30:53'),
 (15790,'2005-08-23 14:01:07',2887,233,'2005-08-30 10:32:07',2,'2006-02-15 21:30:53'),
 (15791,'2005-08-23 14:02:13',4147,445,'2005-09-01 09:03:13',2,'2006-02-15 21:30:53'),
 (15792,'2005-08-23 14:05:37',2175,581,'2005-08-28 10:54:37',1,'2006-02-15 21:30:53'),
 (15793,'2005-08-23 14:06:19',2863,22,'2005-08-24 19:59:19',2,'2006-02-15 21:30:53'),
 (15794,'2006-02-14 15:16:03',3917,579,NULL,2,'2006-02-15 21:30:53'),
 (15795,'2005-08-23 14:07:56',4371,417,'2005-08-25 12:10:56',2,'2006-02-15 21:30:53'),
 (15796,'2005-08-23 14:12:22',1425,158,'2005-08-28 17:03:22',2,'2006-02-15 21:30:53'),
 (15797,'2005-08-23 14:13:47',497,503,'2005-08-25 09:16:47',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15798,'2005-08-23 14:23:03',3803,203,'2005-08-30 17:39:03',2,'2006-02-15 21:30:53'),
 (15799,'2005-08-23 14:23:23',2519,215,'2005-08-24 17:15:23',2,'2006-02-15 21:30:53'),
 (15800,'2005-08-23 14:23:44',963,43,'2005-08-29 17:04:44',2,'2006-02-15 21:30:53'),
 (15801,'2005-08-23 14:26:04',1590,165,'2005-08-28 15:04:04',1,'2006-02-15 21:30:53'),
 (15802,'2005-08-23 14:26:51',41,158,'2005-08-29 16:28:51',2,'2006-02-15 21:30:53'),
 (15803,'2005-08-23 14:27:07',500,105,'2005-08-28 12:01:07',2,'2006-02-15 21:30:53'),
 (15804,'2005-08-23 14:29:16',3338,585,'2005-08-26 08:41:16',1,'2006-02-15 21:30:53'),
 (15805,'2005-08-23 14:31:19',4511,8,'2005-08-25 19:01:19',2,'2006-02-15 21:30:53'),
 (15806,'2005-08-23 14:31:50',2683,166,'2005-08-27 16:08:50',2,'2006-02-15 21:30:53'),
 (15807,'2005-08-23 14:35:10',2705,350,'2005-08-29 19:06:10',2,'2006-02-15 21:30:53'),
 (15808,'2005-08-23 14:38:37',1663,446,'2005-08-27 14:45:37',2,'2006-02-15 21:30:53'),
 (15809,'2005-08-23 14:42:07',1885,431,'2005-08-27 15:00:07',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15810,'2005-08-23 14:43:15',2196,171,'2005-08-25 17:41:15',1,'2006-02-15 21:30:53'),
 (15811,'2005-08-23 14:43:46',3487,300,'2005-08-27 16:43:46',1,'2006-02-15 21:30:53'),
 (15812,'2005-08-23 14:47:26',4457,45,'2005-09-01 10:51:26',2,'2006-02-15 21:30:53'),
 (15813,'2006-02-14 15:16:03',981,9,NULL,1,'2006-02-15 21:30:53'),
 (15814,'2005-08-23 14:52:50',4361,459,'2005-08-27 16:12:50',2,'2006-02-15 21:30:53'),
 (15815,'2005-08-23 14:55:47',316,444,'2005-08-24 12:37:47',1,'2006-02-15 21:30:53'),
 (15816,'2005-08-23 14:58:06',3628,31,'2005-08-28 13:30:06',1,'2006-02-15 21:30:53'),
 (15817,'2005-08-23 14:59:51',598,348,'2005-08-25 15:27:51',1,'2006-02-15 21:30:53'),
 (15818,'2005-08-23 14:59:58',2620,439,'2005-08-27 13:13:58',2,'2006-02-15 21:30:53'),
 (15819,'2005-08-23 15:01:54',3639,274,'2005-08-31 20:01:54',2,'2006-02-15 21:30:53'),
 (15820,'2005-08-23 15:03:13',4553,308,'2005-08-25 20:12:13',1,'2006-02-15 21:30:53'),
 (15821,'2005-08-23 15:03:58',1714,233,'2005-08-24 17:46:58',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15822,'2005-08-23 15:05:59',3602,492,'2005-08-24 11:13:59',1,'2006-02-15 21:30:53'),
 (15823,'2005-08-23 15:08:00',3047,81,'2005-08-24 17:52:00',2,'2006-02-15 21:30:53'),
 (15824,'2005-08-23 15:09:17',2933,371,'2005-08-28 15:14:17',2,'2006-02-15 21:30:53'),
 (15825,'2005-08-23 15:10:42',149,346,'2005-08-29 09:28:42',2,'2006-02-15 21:30:53'),
 (15826,'2005-08-23 15:15:02',215,311,'2005-08-31 20:39:02',2,'2006-02-15 21:30:53'),
 (15827,'2005-08-23 15:15:19',1732,346,'2005-08-24 10:50:19',2,'2006-02-15 21:30:53'),
 (15828,'2005-08-23 15:16:32',428,327,'2005-08-29 12:20:32',1,'2006-02-15 21:30:53'),
 (15829,'2005-08-23 15:17:14',4387,30,'2005-08-27 13:04:14',1,'2006-02-15 21:30:53'),
 (15830,'2005-08-23 15:19:15',309,467,'2005-08-25 18:42:15',2,'2006-02-15 21:30:53'),
 (15831,'2005-08-23 15:21:19',3123,401,'2005-08-24 15:47:19',2,'2006-02-15 21:30:53'),
 (15832,'2005-08-23 15:21:35',1468,537,'2005-08-30 15:01:35',2,'2006-02-15 21:30:53'),
 (15833,'2005-08-23 15:22:15',801,349,'2005-08-31 14:54:15',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15834,'2005-08-23 15:23:50',217,165,'2005-09-01 19:31:50',1,'2006-02-15 21:30:53'),
 (15835,'2005-08-23 15:25:27',1362,128,'2005-09-01 16:14:27',2,'2006-02-15 21:30:53'),
 (15836,'2005-08-23 15:29:17',260,468,'2005-08-26 11:44:17',2,'2006-02-15 21:30:53'),
 (15837,'2005-08-23 15:29:41',4388,283,'2005-08-27 18:17:41',1,'2006-02-15 21:30:53'),
 (15838,'2005-08-23 15:30:48',2194,579,'2005-08-31 11:20:48',2,'2006-02-15 21:30:53'),
 (15839,'2005-08-23 15:34:46',3726,294,'2005-08-30 21:00:46',2,'2006-02-15 21:30:53'),
 (15840,'2005-08-23 15:34:49',1901,316,'2005-08-24 16:54:49',1,'2006-02-15 21:30:53'),
 (15841,'2005-08-23 15:35:59',2865,571,'2005-08-30 19:30:59',2,'2006-02-15 21:30:53'),
 (15842,'2005-08-23 15:36:05',1850,146,'2005-08-30 14:05:05',2,'2006-02-15 21:30:53'),
 (15843,'2005-08-23 15:37:31',611,215,'2005-08-28 18:41:31',2,'2006-02-15 21:30:53'),
 (15844,'2005-08-23 15:38:12',2027,119,'2005-08-26 15:18:12',1,'2006-02-15 21:30:53'),
 (15845,'2005-08-23 15:38:34',4312,89,'2005-08-25 10:06:34',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15846,'2005-08-23 15:39:18',3635,47,'2005-08-27 14:28:18',2,'2006-02-15 21:30:53'),
 (15847,'2005-08-23 15:39:38',2287,163,'2005-08-24 11:46:38',1,'2006-02-15 21:30:53'),
 (15848,'2005-08-23 15:41:12',2141,336,'2005-08-26 10:29:12',2,'2006-02-15 21:30:53'),
 (15849,'2005-08-23 15:41:20',4077,482,'2005-08-27 15:47:20',2,'2006-02-15 21:30:53'),
 (15850,'2005-08-23 15:45:42',586,563,'2005-08-27 19:24:42',1,'2006-02-15 21:30:53'),
 (15851,'2005-08-23 15:46:33',2286,469,'2005-08-29 15:52:33',1,'2006-02-15 21:30:53'),
 (15852,'2005-08-23 15:47:02',1506,140,'2005-08-25 19:37:02',1,'2006-02-15 21:30:53'),
 (15853,'2005-08-23 15:54:20',225,500,'2005-08-24 18:53:20',2,'2006-02-15 21:30:53'),
 (15854,'2005-08-23 15:58:05',1648,464,'2005-08-26 19:23:05',1,'2006-02-15 21:30:53'),
 (15855,'2005-08-23 15:59:01',2528,192,'2005-08-29 20:26:01',1,'2006-02-15 21:30:53'),
 (15856,'2005-08-23 15:59:12',3379,395,'2005-08-25 15:36:12',1,'2006-02-15 21:30:53'),
 (15857,'2005-08-23 15:59:51',2733,575,'2005-08-26 12:01:51',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15858,'2005-08-23 16:07:15',4515,81,'2005-08-25 19:36:15',2,'2006-02-15 21:30:53'),
 (15859,'2005-08-23 16:08:15',4269,465,'2005-08-28 11:08:15',1,'2006-02-15 21:30:53'),
 (15860,'2005-08-23 16:08:40',2583,41,'2005-08-28 15:35:40',1,'2006-02-15 21:30:53'),
 (15861,'2005-08-23 16:15:45',1859,256,'2005-09-01 11:37:45',2,'2006-02-15 21:30:53'),
 (15862,'2006-02-14 15:16:03',925,215,NULL,1,'2006-02-15 21:30:53'),
 (15863,'2005-08-23 16:17:09',2783,328,'2005-08-28 16:10:09',2,'2006-02-15 21:30:53'),
 (15864,'2005-08-23 16:18:12',3014,256,'2005-08-29 17:10:12',2,'2006-02-15 21:30:53'),
 (15865,'2005-08-23 16:18:25',2031,482,'2005-08-26 10:57:25',2,'2006-02-15 21:30:53'),
 (15866,'2005-08-23 16:19:02',3828,296,'2005-08-31 12:29:02',2,'2006-02-15 21:30:53'),
 (15867,'2006-02-14 15:16:03',837,505,NULL,2,'2006-02-15 21:30:53'),
 (15868,'2005-08-23 16:19:14',2186,306,'2005-08-29 16:14:14',2,'2006-02-15 21:30:53'),
 (15869,'2005-08-23 16:22:20',1344,357,'2005-08-27 11:52:20',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15870,'2005-08-23 16:23:08',590,251,'2005-08-28 20:30:08',2,'2006-02-15 21:30:53'),
 (15871,'2005-08-23 16:24:24',425,57,'2005-09-01 13:48:24',2,'2006-02-15 21:30:53'),
 (15872,'2005-08-23 16:27:24',3391,212,'2005-08-31 11:57:24',1,'2006-02-15 21:30:53'),
 (15873,'2005-08-23 16:27:59',4548,577,'2005-08-26 11:11:59',2,'2006-02-15 21:30:53'),
 (15874,'2005-08-23 16:30:55',621,132,'2005-08-28 20:57:55',1,'2006-02-15 21:30:53'),
 (15875,'2006-02-14 15:16:03',3611,41,NULL,1,'2006-02-15 21:30:53'),
 (15876,'2005-08-23 16:32:10',1735,87,'2005-08-24 18:16:10',1,'2006-02-15 21:30:53'),
 (15877,'2005-08-23 16:33:33',2307,559,'2005-08-26 10:36:33',2,'2006-02-15 21:30:53'),
 (15878,'2005-08-23 16:34:31',1592,493,'2005-08-27 21:51:31',2,'2006-02-15 21:30:53'),
 (15879,'2005-08-23 16:42:53',235,482,'2005-08-29 16:21:53',2,'2006-02-15 21:30:53'),
 (15880,'2005-08-23 16:43:54',2538,528,'2005-08-31 14:40:54',2,'2006-02-15 21:30:53'),
 (15881,'2005-08-23 16:44:25',617,383,'2005-08-29 13:58:25',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15882,'2005-08-23 16:44:31',2028,312,'2005-09-01 15:44:31',2,'2006-02-15 21:30:53'),
 (15883,'2005-08-23 16:44:56',2792,550,'2005-08-24 22:42:56',1,'2006-02-15 21:30:53'),
 (15884,'2005-08-23 16:45:28',2255,81,'2005-08-27 20:18:28',1,'2006-02-15 21:30:53'),
 (15885,'2005-08-23 16:50:43',2116,565,'2005-08-29 20:19:43',1,'2006-02-15 21:30:53'),
 (15886,'2005-08-23 16:50:53',3038,91,'2005-08-26 15:38:53',2,'2006-02-15 21:30:53'),
 (15887,'2005-08-23 16:54:09',4263,201,'2005-08-26 13:20:09',2,'2006-02-15 21:30:53'),
 (15888,'2005-08-23 16:56:14',2955,321,'2005-08-31 14:32:14',1,'2006-02-15 21:30:53'),
 (15889,'2005-08-23 16:57:43',787,137,'2005-08-27 22:14:43',1,'2006-02-15 21:30:53'),
 (15890,'2005-08-23 16:58:12',3625,87,'2005-08-24 12:23:12',1,'2006-02-15 21:30:53'),
 (15891,'2005-08-23 17:00:12',2168,52,'2005-08-31 21:12:12',1,'2006-02-15 21:30:53'),
 (15892,'2005-08-23 17:01:00',1365,174,'2005-08-28 12:50:00',1,'2006-02-15 21:30:53'),
 (15893,'2005-08-23 17:02:00',2571,438,'2005-08-30 12:45:00',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15894,'2006-02-14 15:16:03',4416,168,NULL,1,'2006-02-15 21:30:53'),
 (15895,'2005-08-23 17:09:31',2275,342,'2005-08-30 17:15:31',1,'2006-02-15 21:30:53'),
 (15896,'2005-08-23 17:09:56',528,585,'2005-08-31 14:51:56',2,'2006-02-15 21:30:53'),
 (15897,'2005-08-23 17:12:31',1652,15,'2005-08-30 17:22:31',1,'2006-02-15 21:30:53'),
 (15898,'2005-08-23 17:13:01',3502,88,'2005-08-29 11:22:01',2,'2006-02-15 21:30:53'),
 (15899,'2005-08-23 17:16:28',3851,596,'2005-08-29 21:46:28',2,'2006-02-15 21:30:53'),
 (15900,'2005-08-23 17:16:30',1112,562,'2005-08-27 18:02:30',1,'2006-02-15 21:30:53'),
 (15901,'2005-08-23 17:19:17',2761,226,'2005-08-30 14:24:17',2,'2006-02-15 21:30:53'),
 (15902,'2005-08-23 17:28:03',4500,172,'2005-08-30 18:36:03',1,'2006-02-15 21:30:53'),
 (15903,'2005-08-23 17:30:40',1289,267,'2005-08-29 14:12:40',1,'2006-02-15 21:30:53'),
 (15904,'2005-08-23 17:32:19',179,37,'2005-08-24 21:05:19',2,'2006-02-15 21:30:53'),
 (15905,'2005-08-23 17:33:04',3631,59,'2005-08-26 17:38:04',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15906,'2005-08-23 17:36:00',3230,445,'2005-08-28 15:32:00',2,'2006-02-15 21:30:53'),
 (15907,'2005-08-23 17:39:35',2898,2,'2005-08-25 23:23:35',1,'2006-02-15 21:30:53'),
 (15908,'2005-08-23 17:42:00',2453,135,'2005-08-31 22:32:00',1,'2006-02-15 21:30:53'),
 (15909,'2005-08-23 17:42:42',404,452,'2005-08-26 20:25:42',1,'2006-02-15 21:30:53'),
 (15910,'2005-08-23 17:43:16',254,456,'2005-08-24 21:55:16',2,'2006-02-15 21:30:53'),
 (15911,'2005-08-23 17:44:53',3006,582,'2005-09-01 19:14:53',1,'2006-02-15 21:30:53'),
 (15912,'2005-08-23 17:47:40',3079,229,'2005-08-31 14:43:40',2,'2006-02-15 21:30:53'),
 (15913,'2005-08-23 17:48:30',3894,93,'2005-08-31 21:17:30',2,'2006-02-15 21:30:53'),
 (15914,'2005-08-23 17:49:26',747,557,'2005-08-24 12:20:26',1,'2006-02-15 21:30:53'),
 (15915,'2005-08-23 17:52:01',3566,167,'2005-08-24 20:40:01',2,'2006-02-15 21:30:53'),
 (15916,'2005-08-23 17:56:01',4580,327,'2005-08-31 21:49:01',2,'2006-02-15 21:30:53'),
 (15917,'2005-08-23 17:57:28',2093,589,'2005-08-29 20:03:28',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15918,'2005-08-23 17:57:35',1456,262,'2005-08-28 14:16:35',2,'2006-02-15 21:30:53'),
 (15919,'2005-08-23 18:01:31',1746,497,'2005-08-24 16:27:31',1,'2006-02-15 21:30:53'),
 (15920,'2005-08-23 18:05:10',243,212,'2005-08-26 18:09:10',1,'2006-02-15 21:30:53'),
 (15921,'2005-08-23 18:06:54',223,522,'2005-08-30 20:19:54',2,'2006-02-15 21:30:53'),
 (15922,'2005-08-23 18:07:31',1702,263,'2005-09-01 22:27:31',1,'2006-02-15 21:30:53'),
 (15923,'2005-08-23 18:08:19',1693,276,'2005-08-26 18:06:19',2,'2006-02-15 21:30:53'),
 (15924,'2005-08-23 18:08:59',1114,541,'2005-08-27 12:20:59',2,'2006-02-15 21:30:53'),
 (15925,'2005-08-23 18:15:06',3394,440,'2005-08-26 18:09:06',2,'2006-02-15 21:30:53'),
 (15926,'2005-08-23 18:20:56',2231,151,'2005-08-24 18:20:56',2,'2006-02-15 21:30:53'),
 (15927,'2005-08-23 18:23:11',2450,401,'2005-08-24 15:09:11',1,'2006-02-15 21:30:53'),
 (15928,'2005-08-23 18:23:24',2086,75,'2005-09-01 23:43:24',2,'2006-02-15 21:30:53'),
 (15929,'2005-08-23 18:23:30',1832,477,'2005-08-27 17:04:30',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15930,'2005-08-23 18:26:51',180,379,'2005-08-31 16:12:51',1,'2006-02-15 21:30:53'),
 (15931,'2005-08-23 18:28:09',1128,237,'2005-08-28 23:08:09',1,'2006-02-15 21:30:53'),
 (15932,'2005-08-23 18:31:40',4554,405,'2005-08-24 16:30:40',2,'2006-02-15 21:30:53'),
 (15933,'2005-08-23 18:36:44',3493,176,'2005-08-26 12:41:44',2,'2006-02-15 21:30:53'),
 (15934,'2005-08-23 18:40:41',994,216,'2005-08-25 00:18:41',2,'2006-02-15 21:30:53'),
 (15935,'2005-08-23 18:41:11',907,361,'2005-08-25 20:59:11',1,'2006-02-15 21:30:53'),
 (15936,'2005-08-23 18:43:11',1293,411,'2005-08-26 00:19:11',1,'2006-02-15 21:30:53'),
 (15937,'2005-08-23 18:43:22',2882,194,'2005-08-24 22:53:22',1,'2006-02-15 21:30:53'),
 (15938,'2005-08-23 18:43:31',2884,341,'2005-08-31 00:26:31',2,'2006-02-15 21:30:53'),
 (15939,'2005-08-23 18:44:21',3209,382,'2005-09-01 17:25:21',2,'2006-02-15 21:30:53'),
 (15940,'2005-08-23 18:45:06',1606,86,'2005-08-30 13:00:06',2,'2006-02-15 21:30:53'),
 (15941,'2005-08-23 18:46:44',4304,424,'2005-08-31 17:31:44',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15942,'2005-08-23 18:48:40',1096,210,'2005-09-01 18:39:40',2,'2006-02-15 21:30:53'),
 (15943,'2005-08-23 18:49:32',706,462,'2005-08-27 19:20:32',1,'2006-02-15 21:30:53'),
 (15944,'2005-08-23 18:50:54',4559,348,'2005-08-25 18:04:54',2,'2006-02-15 21:30:53'),
 (15945,'2005-08-23 18:51:41',3633,43,'2005-08-28 18:42:41',1,'2006-02-15 21:30:53'),
 (15946,'2005-08-23 18:54:07',4549,561,'2005-08-28 21:21:07',1,'2006-02-15 21:30:53'),
 (15947,'2005-08-23 18:54:32',1877,580,'2005-08-24 22:39:32',2,'2006-02-15 21:30:53'),
 (15948,'2005-08-23 18:59:33',432,520,'2005-08-31 13:02:33',2,'2006-02-15 21:30:53'),
 (15949,'2005-08-23 19:06:04',1199,386,'2005-08-26 18:39:04',2,'2006-02-15 21:30:53'),
 (15950,'2005-08-23 19:09:39',1374,280,'2005-08-31 17:03:39',2,'2006-02-15 21:30:53'),
 (15951,'2005-08-23 19:10:32',3018,446,'2005-08-29 14:17:32',1,'2006-02-15 21:30:53'),
 (15952,'2005-08-23 19:11:29',1314,224,'2005-08-28 14:41:29',1,'2006-02-15 21:30:53'),
 (15953,'2005-08-23 19:13:46',3727,540,'2005-08-28 23:05:46',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15954,'2005-08-23 19:14:07',576,460,'2005-08-24 20:21:07',1,'2006-02-15 21:30:53'),
 (15955,'2005-08-23 19:19:06',2247,349,'2005-08-31 23:34:06',1,'2006-02-15 21:30:53'),
 (15956,'2005-08-23 19:19:21',2763,354,'2005-08-25 22:15:21',2,'2006-02-15 21:30:53'),
 (15957,'2005-08-23 19:21:22',74,418,'2005-08-31 16:42:22',1,'2006-02-15 21:30:53'),
 (15958,'2005-08-23 19:22:36',4164,492,'2005-08-30 01:03:36',1,'2006-02-15 21:30:53'),
 (15959,'2005-08-23 19:27:04',547,415,'2005-08-24 15:24:04',1,'2006-02-15 21:30:53'),
 (15960,'2005-08-23 19:35:42',1497,431,'2005-08-26 17:36:42',2,'2006-02-15 21:30:53'),
 (15961,'2005-08-23 19:35:42',4006,200,'2005-08-30 22:52:42',1,'2006-02-15 21:30:53'),
 (15962,'2005-08-23 19:42:04',3491,160,'2005-08-25 23:53:04',1,'2006-02-15 21:30:53'),
 (15963,'2005-08-23 19:42:46',3819,134,'2005-08-25 22:12:46',1,'2006-02-15 21:30:53'),
 (15964,'2005-08-23 19:45:25',251,141,'2005-08-26 22:43:25',2,'2006-02-15 21:30:53'),
 (15965,'2005-08-23 19:46:39',3449,509,'2005-08-24 20:08:39',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15966,'2006-02-14 15:16:03',4472,374,NULL,1,'2006-02-15 21:30:53'),
 (15967,'2005-08-23 19:50:06',321,257,'2005-08-29 14:51:06',1,'2006-02-15 21:30:53'),
 (15968,'2005-08-23 19:51:29',3598,257,'2005-08-24 15:07:29',1,'2006-02-15 21:30:53'),
 (15969,'2005-08-23 19:51:30',1807,327,'2005-08-31 23:50:30',1,'2006-02-15 21:30:53'),
 (15970,'2005-08-23 19:54:24',4509,395,'2005-08-24 18:07:24',1,'2006-02-15 21:30:53'),
 (15971,'2005-08-23 19:59:33',3456,187,'2005-09-02 01:28:33',1,'2006-02-15 21:30:53'),
 (15972,'2005-08-23 20:00:30',4428,25,'2005-08-30 00:25:30',1,'2006-02-15 21:30:53'),
 (15973,'2005-08-23 20:04:41',2766,343,'2005-09-01 20:08:41',2,'2006-02-15 21:30:53'),
 (15974,'2005-08-23 20:06:04',3518,201,'2005-08-27 17:33:04',2,'2006-02-15 21:30:53'),
 (15975,'2005-08-23 20:06:23',2723,174,'2005-08-27 19:52:23',1,'2006-02-15 21:30:53'),
 (15976,'2005-08-23 20:07:08',835,227,'2005-08-25 01:47:08',2,'2006-02-15 21:30:53'),
 (15977,'2005-08-23 20:07:10',1031,550,'2005-09-01 22:12:10',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15978,'2005-08-23 20:08:18',4444,536,'2005-08-31 17:35:18',2,'2006-02-15 21:30:53'),
 (15979,'2005-08-23 20:08:26',3733,536,'2005-08-26 19:19:26',1,'2006-02-15 21:30:53'),
 (15980,'2005-08-23 20:10:13',3365,196,'2005-08-24 17:44:13',2,'2006-02-15 21:30:53'),
 (15981,'2005-08-23 20:12:17',2867,489,'2005-08-30 20:43:17',1,'2006-02-15 21:30:53'),
 (15982,'2005-08-23 20:13:31',2920,370,'2005-09-01 21:51:31',2,'2006-02-15 21:30:53'),
 (15983,'2005-08-23 20:13:38',3318,464,'2005-08-30 18:42:38',1,'2006-02-15 21:30:53'),
 (15984,'2005-08-23 20:16:27',2011,495,'2005-08-27 01:43:27',1,'2006-02-15 21:30:53'),
 (15985,'2005-08-23 20:20:23',2646,179,'2005-08-26 20:55:23',1,'2006-02-15 21:30:53'),
 (15986,'2005-08-23 20:20:37',3472,226,'2005-08-29 20:49:37',1,'2006-02-15 21:30:53'),
 (15987,'2005-08-23 20:22:17',3150,302,'2005-08-31 21:46:17',2,'2006-02-15 21:30:53'),
 (15988,'2005-08-23 20:23:08',3932,400,'2005-08-28 20:50:08',1,'2006-02-15 21:30:53'),
 (15989,'2005-08-23 20:24:36',38,96,'2005-08-26 20:35:36',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (15990,'2005-08-23 20:25:11',3233,512,'2005-08-25 15:01:11',2,'2006-02-15 21:30:53'),
 (15991,'2005-08-23 20:27:34',2078,203,'2005-08-28 16:48:34',2,'2006-02-15 21:30:53'),
 (15992,'2005-08-23 20:28:32',3334,589,'2005-08-24 21:35:32',1,'2006-02-15 21:30:53'),
 (15993,'2005-08-23 20:28:44',1638,12,'2005-08-27 16:23:44',2,'2006-02-15 21:30:53'),
 (15994,'2005-08-23 20:29:10',438,595,'2005-08-28 01:41:10',2,'2006-02-15 21:30:53'),
 (15995,'2005-08-23 20:29:56',1122,377,'2005-08-30 18:09:56',1,'2006-02-15 21:30:53'),
 (15996,'2005-08-23 20:31:38',3098,151,'2005-08-29 20:58:38',1,'2006-02-15 21:30:53'),
 (15997,'2005-08-23 20:40:31',2843,447,'2005-08-26 19:47:31',1,'2006-02-15 21:30:53'),
 (15998,'2005-08-23 20:41:09',1229,545,'2005-08-27 00:20:09',1,'2006-02-15 21:30:53'),
 (15999,'2005-08-23 20:44:10',2584,377,'2005-08-31 02:38:10',2,'2006-02-15 21:30:53'),
 (16000,'2005-08-23 20:44:36',282,71,'2005-08-25 02:29:36',1,'2006-02-15 21:30:53'),
 (16001,'2005-08-23 20:45:53',245,108,'2005-08-27 15:52:53',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (16002,'2005-08-23 20:47:12',2770,73,'2005-08-27 23:07:12',1,'2006-02-15 21:30:53'),
 (16003,'2005-08-23 20:47:28',3413,577,'2005-08-31 23:22:28',1,'2006-02-15 21:30:53'),
 (16004,'2005-08-23 20:53:20',2223,147,'2005-08-31 15:15:20',2,'2006-02-15 21:30:53'),
 (16005,'2005-08-23 21:00:22',3265,466,'2005-09-02 02:35:22',1,'2006-02-15 21:30:53'),
 (16006,'2005-08-23 21:01:09',240,533,'2005-08-25 19:33:09',1,'2006-02-15 21:30:53'),
 (16007,'2005-08-23 21:02:43',3236,126,'2005-08-30 23:37:43',2,'2006-02-15 21:30:53'),
 (16008,'2005-08-23 21:04:51',3273,189,'2005-08-31 22:09:51',1,'2006-02-15 21:30:53'),
 (16009,'2005-08-23 21:07:59',3055,133,'2005-08-29 16:54:59',2,'2006-02-15 21:30:53'),
 (16010,'2005-08-23 21:10:24',2539,173,'2005-08-25 17:58:24',1,'2006-02-15 21:30:53'),
 (16011,'2005-08-23 21:11:33',1093,389,'2005-08-31 17:51:33',1,'2006-02-15 21:30:53'),
 (16012,'2005-08-23 21:13:39',2421,80,'2005-08-30 23:52:39',2,'2006-02-15 21:30:53'),
 (16013,'2005-08-23 21:17:17',561,462,'2005-08-26 21:15:17',1,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (16014,'2005-08-23 21:18:31',3322,532,'2005-08-31 17:28:31',2,'2006-02-15 21:30:53'),
 (16015,'2005-08-23 21:25:03',3113,50,'2005-08-24 20:05:03',2,'2006-02-15 21:30:53'),
 (16016,'2005-08-23 21:26:35',3374,595,'2005-08-28 16:06:35',2,'2006-02-15 21:30:53'),
 (16017,'2005-08-23 21:27:11',664,535,'2005-08-24 23:22:11',1,'2006-02-15 21:30:53'),
 (16018,'2005-08-23 21:27:35',897,439,'2005-08-30 00:36:35',1,'2006-02-15 21:30:53'),
 (16019,'2005-08-23 21:30:45',3093,278,'2005-08-27 23:45:45',2,'2006-02-15 21:30:53'),
 (16020,'2005-08-23 21:34:33',277,311,'2005-09-01 18:17:33',1,'2006-02-15 21:30:53'),
 (16021,'2005-08-23 21:37:59',3057,314,'2005-08-31 01:52:59',1,'2006-02-15 21:30:53'),
 (16022,'2005-08-23 21:44:27',2925,504,'2005-08-28 01:52:27',1,'2006-02-15 21:30:53'),
 (16023,'2005-08-23 21:45:02',2347,124,'2005-08-24 21:28:02',1,'2006-02-15 21:30:53'),
 (16024,'2005-08-23 21:46:47',2910,473,'2005-08-27 02:06:47',1,'2006-02-15 21:30:53'),
 (16025,'2005-08-23 21:48:54',1777,569,'2005-08-24 22:05:54',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (16026,'2005-08-23 21:49:22',467,484,'2005-08-27 00:47:22',1,'2006-02-15 21:30:53'),
 (16027,'2005-08-23 21:49:33',1724,160,'2005-08-30 16:19:33',2,'2006-02-15 21:30:53'),
 (16028,'2005-08-23 21:52:56',2515,119,'2005-08-30 18:16:56',2,'2006-02-15 21:30:53'),
 (16029,'2005-08-23 21:54:02',953,143,'2005-08-29 23:55:02',1,'2006-02-15 21:30:53'),
 (16030,'2005-08-23 21:56:04',4161,137,'2005-08-31 01:24:04',2,'2006-02-15 21:30:53'),
 (16031,'2005-08-23 21:59:26',1843,102,'2005-08-29 20:15:26',1,'2006-02-15 21:30:53'),
 (16032,'2005-08-23 21:59:57',2527,447,'2005-08-31 22:46:57',2,'2006-02-15 21:30:53'),
 (16033,'2005-08-23 22:06:15',760,226,'2005-09-01 02:36:15',2,'2006-02-15 21:30:53'),
 (16034,'2005-08-23 22:06:34',655,502,'2005-08-29 18:44:34',1,'2006-02-15 21:30:53'),
 (16035,'2005-08-23 22:08:04',549,37,'2005-08-28 03:46:04',1,'2006-02-15 21:30:53'),
 (16036,'2005-08-23 22:12:44',1372,425,'2005-08-25 17:48:44',2,'2006-02-15 21:30:53'),
 (16037,'2005-08-23 22:13:04',341,45,'2005-09-01 02:48:04',2,'2006-02-15 21:30:53');
INSERT INTO "rental" ("rental_id","rental_date","inventory_id","customer_id","return_date","staff_id","last_update") VALUES 
 (16038,'2005-08-23 22:14:31',2612,172,'2005-08-30 03:28:31',1,'2006-02-15 21:30:53'),
 (16039,'2005-08-23 22:18:51',545,78,'2005-08-31 19:55:51',2,'2006-02-15 21:30:53'),
 (16040,'2005-08-23 22:19:33',3524,195,'2005-09-02 02:19:33',2,'2006-02-15 21:30:53'),
 (16041,'2005-08-23 22:20:26',4116,121,'2005-08-25 20:14:26',2,'2006-02-15 21:30:53'),
 (16042,'2005-08-23 22:20:40',629,131,'2005-08-24 17:54:40',1,'2006-02-15 21:30:53'),
 (16043,'2005-08-23 22:21:03',3869,526,'2005-08-31 03:09:03',2,'2006-02-15 21:30:53'),
 (16044,'2005-08-23 22:24:39',1312,468,'2005-08-25 04:08:39',1,'2006-02-15 21:30:53'),
 (16045,'2005-08-23 22:25:26',772,14,'2005-08-25 23:54:26',1,'2006-02-15 21:30:53'),
 (16046,'2005-08-23 22:26:47',4364,74,'2005-08-27 18:02:47',2,'2006-02-15 21:30:53'),
 (16047,'2005-08-23 22:42:48',2088,114,'2005-08-25 02:48:48',2,'2006-02-15 21:30:53'),
 (16048,'2005-08-23 22:43:07',2019,103,'2005-08-31 21:33:07',1,'2006-02-15 21:30:53'),
 (16049,'2005-08-23 22:50:12',2666,393,'2005-08-30 01:01:12',2,'2006-02-15 21:30:53');
COMMIT;


--
-- Definition of trigger "rental_date"
--

DELIMITER $$

CREATE DEFINER = "root"@"%" TRIGGER "rental_date" BEFORE INSERT ON "rental" FOR EACH ROW SET NEW.rental_date = NOW() $$

DELIMITER ;

--
-- Definition of table "staff"
--

CREATE TABLE "staff" (
  "staff_id" tinyint(3) unsigned NOT NULL auto_increment,
  "first_name" varchar(45) NOT NULL,
  "last_name" varchar(45) NOT NULL,
  "address_id" smallint(5) unsigned NOT NULL,
  "picture" blob,
  "email" varchar(50) default NULL,
  "store_id" tinyint(3) unsigned NOT NULL,
  "active" tinyint(1) NOT NULL default '1',
  "username" varchar(16) NOT NULL,
  "password" varchar(40) character set utf8 collate utf8_bin default NULL,
  "last_update" timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  ("staff_id"),
  KEY "idx_fk_store_id" ("store_id"),
  KEY "idx_fk_address_id" ("address_id"),
  CONSTRAINT "fk_staff_store" FOREIGN KEY ("store_id") REFERENCES "store" ("store_id") ON UPDATE CASCADE,
  CONSTRAINT "fk_staff_address" FOREIGN KEY ("address_id") REFERENCES "address" ("address_id") ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table "staff"
--

INSERT INTO "staff" ("staff_id","first_name","last_name","address_id","picture","email","store_id","active","username","password","last_update") VALUES 
 (1,'Mike','Hillyer',3,0x[encoded data, 72730 characters],'Mike.Hillyer@sakilastaff.com',1,1,'Mike',0x38636232323337643036373963613838646236343634656163363064613936333435353133393634,'2006-02-15 04:57:16'),
 (2,'Jon','Stephens',4,NULL,'Jon.Stephens@sakilastaff.com',2,1,'Jon',0x38636232323337643036373963613838646236343634656163363064613936333435353133393634,'2006-02-15 04:57:16');
COMMIT;


--
-- Definition of table "store"
--

CREATE TABLE "store" (
  "store_id" tinyint(3) unsigned NOT NULL auto_increment,
  "manager_staff_id" tinyint(3) unsigned NOT NULL,
  "address_id" smallint(5) unsigned NOT NULL,
  "last_update" timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  ("store_id"),
  UNIQUE KEY "idx_unique_manager" ("manager_staff_id"),
  KEY "idx_fk_address_id" ("address_id"),
  CONSTRAINT "fk_store_staff" FOREIGN KEY ("manager_staff_id") REFERENCES "staff" ("staff_id") ON UPDATE CASCADE,
  CONSTRAINT "fk_store_address" FOREIGN KEY ("address_id") REFERENCES "address" ("address_id") ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table "store"
--

INSERT INTO "store" ("store_id","manager_staff_id","address_id","last_update") VALUES 
 (1,1,1,'2006-02-15 04:57:12'),
 (2,2,2,'2006-02-15 04:57:12');
COMMIT;


--
-- Definition of function "get_customer_balance"
--

DROP FUNCTION IF EXISTS `get_customer_balance`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` FUNCTION `get_customer_balance`(p_customer_id INT, p_effective_date DATETIME) RETURNS decimal(5,2)
    READS SQL DATA
    DETERMINISTIC
BEGIN

       #OK, WE NEED TO CALCULATE THE CURRENT BALANCE GIVEN A CUSTOMER_ID AND A DATE
       #THAT WE WANT THE BALANCE TO BE EFFECTIVE FOR. THE BALANCE IS:
       #   1) RENTAL FEES FOR ALL PREVIOUS RENTALS
       #   2) ONE DOLLAR FOR EVERY DAY THE PREVIOUS RENTALS ARE OVERDUE
       #   3) IF A FILM IS MORE THAN RENTAL_DURATION * 2 OVERDUE, CHARGE THE REPLACEMENT_COST
       #   4) SUBTRACT ALL PAYMENTS MADE BEFORE THE DATE SPECIFIED

  DECLARE v_rentfees DECIMAL(5,2); #FEES PAID TO RENT THE VIDEOS INITIALLY
  DECLARE v_overfees INTEGER;      #LATE FEES FOR PRIOR RENTALS
  DECLARE v_payments DECIMAL(5,2); #SUM OF PAYMENTS MADE PREVIOUSLY

  SELECT IFNULL(SUM(film.rental_rate),0) INTO v_rentfees
    FROM film, inventory, rental
    WHERE film.film_id = inventory.film_id
      AND inventory.inventory_id = rental.inventory_id
      AND rental.rental_date <= p_effective_date
      AND rental.customer_id = p_customer_id;

  SELECT IFNULL(SUM(IF((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) > film.rental_duration,
        ((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) - film.rental_duration),0)),0) INTO v_overfees
    FROM rental, inventory, film
    WHERE film.film_id = inventory.film_id
      AND inventory.inventory_id = rental.inventory_id
      AND rental.rental_date <= p_effective_date
      AND rental.customer_id = p_customer_id;


  SELECT IFNULL(SUM(payment.amount),0) INTO v_payments
    FROM payment

    WHERE payment.payment_date <= p_effective_date
    AND payment.customer_id = p_customer_id;

  RETURN v_rentfees + v_overfees - v_payments;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of function "inventory_held_by_customer"
--

DROP FUNCTION IF EXISTS `inventory_held_by_customer`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` FUNCTION `inventory_held_by_customer`(p_inventory_id INT) RETURNS int(11)
    READS SQL DATA
BEGIN
  DECLARE v_customer_id INT;
  DECLARE EXIT HANDLER FOR NOT FOUND RETURN NULL;

  SELECT customer_id INTO v_customer_id
  FROM rental
  WHERE return_date IS NULL
  AND inventory_id = p_inventory_id;

  RETURN v_customer_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of function "inventory_in_stock"
--

DROP FUNCTION IF EXISTS `inventory_in_stock`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` FUNCTION `inventory_in_stock`(p_inventory_id INT) RETURNS tinyint(1)
    READS SQL DATA
BEGIN
    DECLARE v_rentals INT;
    DECLARE v_out     INT;

    #AN ITEM IS IN-STOCK IF THERE ARE EITHER NO ROWS IN THE rental TABLE
    #FOR THE ITEM OR ALL ROWS HAVE return_date POPULATED

    SELECT COUNT(*) INTO v_rentals
    FROM rental
    WHERE inventory_id = p_inventory_id;

    IF v_rentals = 0 THEN
      RETURN TRUE;
    END IF;

    SELECT COUNT(rental_id) INTO v_out
    FROM inventory LEFT JOIN rental USING(inventory_id)
    WHERE inventory.inventory_id = p_inventory_id
    AND rental.return_date IS NULL;

    IF v_out > 0 THEN
      RETURN FALSE;
    ELSE
      RETURN TRUE;
    END IF;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure "film_in_stock"
--

DROP PROCEDURE IF EXISTS `film_in_stock`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` PROCEDURE `film_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)
    READS SQL DATA
BEGIN
     SELECT inventory_id
     FROM inventory
     WHERE film_id = p_film_id
     AND store_id = p_store_id
     AND inventory_in_stock(inventory_id);

     SELECT FOUND_ROWS() INTO p_film_count;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure "film_not_in_stock"
--

DROP PROCEDURE IF EXISTS `film_not_in_stock`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` PROCEDURE `film_not_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)
    READS SQL DATA
BEGIN
     SELECT inventory_id
     FROM inventory
     WHERE film_id = p_film_id
     AND store_id = p_store_id
     AND NOT inventory_in_stock(inventory_id);

     SELECT FOUND_ROWS() INTO p_film_count;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure "rewards_report"
--

DROP PROCEDURE IF EXISTS `rewards_report`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`%` PROCEDURE `rewards_report`(
    IN min_monthly_purchases TINYINT UNSIGNED
    , IN min_dollar_amount_purchased DECIMAL(10,2) UNSIGNED
    , OUT count_rewardees INT
)
    READS SQL DATA
    COMMENT 'Provides a customizable report on best customers'
proc: BEGIN
    
    DECLARE last_month_start DATE;
    DECLARE last_month_end DATE;

    /* Some sanity checks... */
    IF min_monthly_purchases = 0 THEN
        SELECT 'Minimum monthly purchases parameter must be > 0';
        LEAVE proc;
    END IF;
    IF min_dollar_amount_purchased = 0.00 THEN
        SELECT 'Minimum monthly dollar amount purchased parameter must be > $0.00';
        LEAVE proc;
    END IF;

    /* Determine start and end time periods */
    SET last_month_start = DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH);
    SET last_month_start = STR_TO_DATE(CONCAT(YEAR(last_month_start),'-',MONTH(last_month_start),'-01'),'%Y-%m-%d');
    SET last_month_end = LAST_DAY(last_month_start);

    /* 
        Create a temporary storage area for 
        Customer IDs.  
    */
    CREATE TEMPORARY TABLE tmpCustomer (customer_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY);

    /* 
        Find all customers meeting the 
        monthly purchase requirements
    */
    INSERT INTO tmpCustomer (customer_id)
    SELECT p.customer_id 
    FROM payment AS p
    WHERE DATE(p.payment_date) BETWEEN last_month_start AND last_month_end
    GROUP BY customer_id
    HAVING SUM(p.amount) > min_dollar_amount_purchased
    AND COUNT(customer_id) > min_monthly_purchases;

    /* Populate OUT parameter with count of found customers */
    SELECT COUNT(*) FROM tmpCustomer INTO count_rewardees;

    /* 
        Output ALL customer information of matching rewardees.
        Customize output as needed.
    */
    SELECT c.* 
    FROM tmpCustomer AS t   
    INNER JOIN customer AS c ON t.customer_id = c.customer_id;

    /* Clean up */
    DROP TABLE tmpCustomer;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of view "actor_info"
--

DROP VIEW IF EXISTS "actor_info";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY INVOKER VIEW "actor_info" AS select "a"."actor_id" AS "actor_id","a"."first_name" AS "first_name","a"."last_name" AS "last_name",group_concat(distinct concat("c"."name",_utf8': ',(select group_concat("f"."title" order by "f"."title" ASC separator ', ') AS "GROUP_CONCAT(f.title ORDER BY f.title SEPARATOR ', ')" from (("film" "f" join "film_category" "fc" on(("f"."film_id" = "fc"."film_id"))) join "film_actor" "fa" on(("f"."film_id" = "fa"."film_id"))) where (("fc"."category_id" = "c"."category_id") and ("fa"."actor_id" = "a"."actor_id")))) order by "c"."name" ASC separator '; ') AS "film_info" from ((("actor" "a" left join "film_actor" "fa" on(("a"."actor_id" = "fa"."actor_id"))) left join "film_category" "fc" on(("fa"."film_id" = "fc"."film_id"))) left join "category" "c" on(("fc"."category_id" = "c"."category_id"))) group by "a"."actor_id","a"."first_name","a"."last_name";

--
-- Definition of view "customer_list"
--

DROP VIEW IF EXISTS "customer_list";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "customer_list" AS select "cu"."customer_id" AS "ID",concat("cu"."first_name",_utf8' ',"cu"."last_name") AS "name","a"."address" AS "address","a"."postal_code" AS "zip code","a"."phone" AS "phone","city"."city" AS "city","country"."country" AS "country",if("cu"."active",_utf8'active',_utf8'') AS "notes","cu"."store_id" AS "SID" from ((("customer" "cu" join "address" "a" on(("cu"."address_id" = "a"."address_id"))) join "city" on(("a"."city_id" = "city"."city_id"))) join "country" on(("city"."country_id" = "country"."country_id")));

--
-- Definition of view "film_list"
--

DROP VIEW IF EXISTS "film_list";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "film_list" AS select "film"."film_id" AS "FID","film"."title" AS "title","film"."description" AS "description","category"."name" AS "category","film"."rental_rate" AS "price","film"."length" AS "length","film"."rating" AS "rating",group_concat(concat("actor"."first_name",_utf8' ',"actor"."last_name") separator ', ') AS "actors" from (((("category" left join "film_category" on(("category"."category_id" = "film_category"."category_id"))) left join "film" on(("film_category"."film_id" = "film"."film_id"))) join "film_actor" on(("film"."film_id" = "film_actor"."film_id"))) join "actor" on(("film_actor"."actor_id" = "actor"."actor_id"))) group by "film"."film_id";

--
-- Definition of view "nicer_but_slower_film_list"
--

DROP VIEW IF EXISTS "nicer_but_slower_film_list";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "nicer_but_slower_film_list" AS select "film"."film_id" AS "FID","film"."title" AS "title","film"."description" AS "description","category"."name" AS "category","film"."rental_rate" AS "price","film"."length" AS "length","film"."rating" AS "rating",group_concat(concat(concat(ucase(substr("actor"."first_name",1,1)),lcase(substr("actor"."first_name",2,length("actor"."first_name"))),_utf8' ',concat(ucase(substr("actor"."last_name",1,1)),lcase(substr("actor"."last_name",2,length("actor"."last_name")))))) separator ', ') AS "actors" from (((("category" left join "film_category" on(("category"."category_id" = "film_category"."category_id"))) left join "film" on(("film_category"."film_id" = "film"."film_id"))) join "film_actor" on(("film"."film_id" = "film_actor"."film_id"))) join "actor" on(("film_actor"."actor_id" = "actor"."actor_id"))) group by "film"."film_id";

--
-- Definition of view "sales_by_film_category"
--

DROP VIEW IF EXISTS "sales_by_film_category";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "sales_by_film_category" AS select "c"."name" AS "category",sum("p"."amount") AS "total_sales" from ((((("payment" "p" join "rental" "r" on(("p"."rental_id" = "r"."rental_id"))) join "inventory" "i" on(("r"."inventory_id" = "i"."inventory_id"))) join "film" "f" on(("i"."film_id" = "f"."film_id"))) join "film_category" "fc" on(("f"."film_id" = "fc"."film_id"))) join "category" "c" on(("fc"."category_id" = "c"."category_id"))) group by "c"."name" order by sum("p"."amount") desc;

--
-- Definition of view "sales_by_store"
--

DROP VIEW IF EXISTS "sales_by_store";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "sales_by_store" AS select concat("c"."city",_utf8',',"cy"."country") AS "store",concat("m"."first_name",_utf8' ',"m"."last_name") AS "manager",sum("p"."amount") AS "total_sales" from ((((((("payment" "p" join "rental" "r" on(("p"."rental_id" = "r"."rental_id"))) join "inventory" "i" on(("r"."inventory_id" = "i"."inventory_id"))) join "store" "s" on(("i"."store_id" = "s"."store_id"))) join "address" "a" on(("s"."address_id" = "a"."address_id"))) join "city" "c" on(("a"."city_id" = "c"."city_id"))) join "country" "cy" on(("c"."country_id" = "cy"."country_id"))) join "staff" "m" on(("s"."manager_staff_id" = "m"."staff_id"))) group by "s"."store_id" order by "cy"."country","c"."city";

--
-- Definition of view "staff_list"
--

DROP VIEW IF EXISTS "staff_list";
CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL SECURITY DEFINER VIEW "staff_list" AS select "s"."staff_id" AS "ID",concat("s"."first_name",_utf8' ',"s"."last_name") AS "name","a"."address" AS "address","a"."postal_code" AS "zip code","a"."phone" AS "phone","city"."city" AS "city","country"."country" AS "country","s"."store_id" AS "SID" from ((("staff" "s" join "address" "a" on(("s"."address_id" = "a"."address_id"))) join "city" on(("a"."city_id" = "city"."city_id"))) join "country" on(("city"."country_id" = "country"."country_id")));



