# MySQL dump 4.0 # # Host: localhost Database: bighit #-------------------------------------------------------- # # Table structure for table 'Customer' # CREATE TABLE Customer ( accountId int(11) DEFAULT '0' NOT NULL, lastName varchar(32), firstName varchar(32), street varchar(100), city varchar(32), state char(2), zipcode varchar(9), PRIMARY KEY (accountId) ); # # Dumping data for table 'Customer' # INSERT INTO Customer VALUES (101,'Block','Tim','1010 Main St.','Apopka','FL','30458'); INSERT INTO Customer VALUES (102,'Gina','Allotova','5656 DangerPowers Lane','Tallahassee','FL','32301'); INSERT INTO Customer VALUES (103,'McCrevis','Phil','78 Riccardis Great','Tampa','FL','32101'); INSERT INTO Customer VALUES (104,'Simpson','Homer','1222 Doh Way','Springfield','FL','11223'); INSERT INTO Customer VALUES (106,'nara','suri','kl','malaysia','LA','53000'); INSERT INTO Customer VALUES (444,'Jandt','Matt','1710 hwy 720 E. #167','Little Elm','FL','75068'); INSERT INTO Customer VALUES (888,'Nole','Semi','Victory Way','Tallahassee','ff','33333'); # # Table structure for table 'Employee' # CREATE TABLE Employee ( ssn varchar(9) DEFAULT '' NOT NULL, lastName varchar(32), firstName varchar(32), PRIMARY KEY (ssn) ); # # Dumping data for table 'Employee' # INSERT INTO Employee VALUES ('145-09-09','Uno','Jane'); INSERT INTO Employee VALUES ('245-11-45','Toulouse','Jie'); INSERT INTO Employee VALUES ('376-77-00','Threat','Ayisha'); INSERT INTO Employee VALUES ('479-98-00','Fortune','Julian'); INSERT INTO Employee VALUES ('579-98-87','Fivozinsky','Bruce'); # # Table structure for table 'HourlyEmployee' # CREATE TABLE HourlyEmployee ( ssn char(9) DEFAULT '' NOT NULL, hourlyRate double(16,4), PRIMARY KEY (ssn) ); # # Dumping data for table 'HourlyEmployee' # INSERT INTO HourlyEmployee VALUES ('145-09-09',6.0500); INSERT INTO HourlyEmployee VALUES ('245-11-45',5.5000); INSERT INTO HourlyEmployee VALUES ('376-77-00',10.7500); INSERT INTO HourlyEmployee VALUES ('479-98-00',9.5000); INSERT INTO HourlyEmployee VALUES ('579-98-87',5.5000); # # Table structure for table 'Movie' # CREATE TABLE Movie ( movieId int(11) DEFAULT '0' NOT NULL, title varchar(32), genre varchar(32), length int(11), rating varchar(5), PRIMARY KEY (movieId) ); # # Dumping data for table 'Movie' # INSERT INTO Movie VALUES (101,'Men in Black','action comedy',101,'R'); INSERT INTO Movie VALUES (123,'The Truth About Cats and Dogs','romantic comedy',110,'R'); INSERT INTO Movie VALUES (145,'The Prince of Egypt','animated drama',93,'PG'); INSERT INTO Movie VALUES (189,'Eraser','action comedy',87,'R'); INSERT INTO Movie VALUES (450,'Elizabeth','costume drama',123,'PG-13'); INSERT INTO Movie VALUES (553,'Armageddon','action',130,'R'); INSERT INTO Movie VALUES (987,'The Waterboy','comedy',99,'PG-13'); # # Table structure for table 'OtherUser' # CREATE TABLE OtherUser ( accountId int(11) DEFAULT '0' NOT NULL, name varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (accountId,name) ); # # Dumping data for table 'OtherUser' # INSERT INTO OtherUser VALUES (101,'Greg Jones'); INSERT INTO OtherUser VALUES (101,'Joe Block'); INSERT INTO OtherUser VALUES (104,'Cyrus Lambeaux'); INSERT INTO OtherUser VALUES (104,'Jean Deaux'); INSERT INTO OtherUser VALUES (104,'Judy Breaux'); # # Table structure for table 'PayStatement' # CREATE TABLE PayStatement ( ssn char(9) DEFAULT '' NOT NULL, hourlyRate double(16,4), numHours double(16,4), amountPaid double(16,4), datePaid date DEFAULT '0000-00-00' NOT NULL, PRIMARY KEY (ssn,datePaid) ); # # Dumping data for table 'PayStatement' # INSERT INTO PayStatement VALUES ('145-09-09',6.0500,8.0000,45.3800,'1999-05-17'); INSERT INTO PayStatement VALUES ('245-11-45',5.5000,4.0000,20.6300,'1999-05-17'); INSERT INTO PayStatement VALUES ('376-77-00',10.7500,16.0000,172.0000,'1999-05-17'); # # Table structure for table 'PreviousRental' # CREATE TABLE PreviousRental ( accountId int(11) DEFAULT '0' NOT NULL, videoId int(11) DEFAULT '0' NOT NULL, dateRented datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, dateReturned datetime, cost double(16,4), PRIMARY KEY (accountId,videoId,dateRented) ); # # Dumping data for table 'PreviousRental' # INSERT INTO PreviousRental VALUES (101,1013,'1999-04-27 14:23:06','1999-04-28 00:50:29',2.9900); INSERT INTO PreviousRental VALUES (444,1011,'1999-04-27 14:21:35','1999-04-28 00:50:28',2.9900); INSERT INTO PreviousRental VALUES (201,909387,'1999-04-26 16:48:21','1999-04-27 08:40:39',5.0000); INSERT INTO PreviousRental VALUES (102,113,'1998-12-01 00:00:00','1998-12-03 00:00:00',2.4900); INSERT INTO PreviousRental VALUES (111,101,'1998-12-04 00:00:00','1998-12-06 00:00:00',2.4900); INSERT INTO PreviousRental VALUES (111,77564,'1999-01-01 00:00:00','1999-01-04 00:00:00',3.9500); INSERT INTO PreviousRental VALUES (201,113,'1998-12-09 00:00:00','1998-12-14 00:00:00',3.9900); INSERT INTO PreviousRental VALUES (201,77564,'1999-01-14 00:00:00','1999-01-24 00:00:00',3.3500); INSERT INTO PreviousRental VALUES (201,909287,'1999-04-26 16:47:15','1999-04-27 08:40:39',5.0000); INSERT INTO PreviousRental VALUES (888,909187,'1999-04-26 16:43:14','1999-04-27 08:40:39',2.9900); INSERT INTO PreviousRental VALUES (201,775364,'1999-04-26 17:02:30','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-26 17:37:10','1999-04-27 08:40:38',3.0000); INSERT INTO PreviousRental VALUES (103,123,'1998-12-01 00:00:00','1999-04-19 04:05:22',10.9900); INSERT INTO PreviousRental VALUES (888,775164,'1999-04-26 16:35:33','1999-04-27 08:40:38',2.9900); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-26 17:31:54','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (201,1232,'1999-04-26 17:02:26','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-26 16:44:19','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (102,1113,'1999-04-26 17:24:40','1999-04-27 08:40:38',3.0000); INSERT INTO PreviousRental VALUES (201,1112,'1999-04-26 16:54:46','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (888,1111,'1999-04-26 16:41:19','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 22:41:34','1999-04-27 08:40:38',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-26 22:49:33','1999-04-27 08:40:37',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-26 20:55:59','1999-04-27 08:40:37',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 17:37:10','1999-04-26 20:51:55',3.0000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-26 17:24:40','1999-04-26 20:51:55',3.0000); INSERT INTO PreviousRental VALUES (201,1011,'1999-04-26 17:02:26','1999-04-26 20:51:53',5.0000); INSERT INTO PreviousRental VALUES (102,1142,'1999-04-26 13:42:16','1999-04-26 17:41:44',5.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-26 12:37:33','1999-04-26 17:41:44',5.0000); INSERT INTO PreviousRental VALUES (888,909387,'1999-04-26 16:11:55','1999-04-26 16:13:06',2.9900); INSERT INTO PreviousRental VALUES (888,909287,'1999-04-26 16:11:51','1999-04-26 16:13:06',2.9900); INSERT INTO PreviousRental VALUES (888,909187,'1999-04-26 16:12:44','1999-04-26 16:13:06',2.9900); INSERT INTO PreviousRental VALUES (888,909187,'1999-04-26 16:03:17','1999-04-26 16:12:16',2.9900); INSERT INTO PreviousRental VALUES (888,909187,'1999-04-26 15:48:18','1999-04-26 15:48:49',2.9900); INSERT INTO PreviousRental VALUES (888,909187,'1999-04-26 15:34:26','1999-04-26 15:35:23',2.9900); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-26 15:30:40','1999-04-26 15:35:22',2.9900); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 15:29:44','1999-04-26 15:35:22',2.9900); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 15:29:02','1999-04-26 15:29:32',2.9900); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 15:28:41','1999-04-26 15:29:32',2.9900); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-26 15:26:59','1999-04-26 15:28:26',2.9900); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-26 15:22:55','1999-04-26 15:26:55',2.9900); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-26 15:18:30','1999-04-26 15:21:37',1.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-26 15:17:48','1999-04-26 15:21:37',1.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-26 15:17:07','1999-04-26 15:21:35',1.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-26 15:18:21','1999-04-26 15:21:35',1.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-26 15:17:10','1999-04-26 15:21:34',1.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 15:16:36','1999-04-26 15:21:34',1.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-26 15:13:10','1999-04-26 15:14:41',1.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-26 15:11:39','1999-04-26 15:14:41',1.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-26 15:08:53','1999-04-26 15:14:41',1.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 15:11:39','1999-04-26 15:14:40',1.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-26 15:13:10','1999-04-26 15:14:40',1.0000); INSERT INTO PreviousRental VALUES (104,997387,'1999-04-26 00:43:49','1999-04-26 14:08:47',5.0000); INSERT INTO PreviousRental VALUES (102,1453,'1999-04-26 13:42:16','1999-04-26 14:08:46',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-26 14:06:51','1999-04-26 14:07:03',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 14:06:52','1999-04-26 14:07:02',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-26 12:51:09','1999-04-26 14:03:47',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-26 12:38:16','1999-04-26 14:03:47',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-26 12:37:33','1999-04-26 14:03:47',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-26 13:33:56','1999-04-26 14:03:47',5.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-26 13:39:08','1999-04-26 14:03:46',5.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-26 14:02:08','1999-04-26 14:03:46',5.0000); INSERT INTO PreviousRental VALUES (102,1232,'1999-04-26 13:41:52','1999-04-26 14:03:46',5.0000); INSERT INTO PreviousRental VALUES (106,1231,'1999-04-26 12:42:21','1999-04-26 14:03:45',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-26 13:58:44','1999-04-26 14:03:45',2.9900); INSERT INTO PreviousRental VALUES (102,1112,'1999-04-26 13:39:08','1999-04-26 14:03:45',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 13:03:07','1999-04-26 14:03:44',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 13:18:46','1999-04-26 14:03:44',5.0000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-26 13:41:52','1999-04-26 14:03:43',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-26 13:33:57','1999-04-26 14:03:43',5.0000); INSERT INTO PreviousRental VALUES (104,1453,'1999-04-26 00:43:49','1999-04-26 13:33:10',NULL); INSERT INTO PreviousRental VALUES (104,997187,'1999-04-26 00:42:22','1999-04-26 12:31:16',NULL); INSERT INTO PreviousRental VALUES (102,1133,'1999-04-26 00:18:31','1999-04-31 00:18:31',5.0000); INSERT INTO PreviousRental VALUES (102,1123,'1999-04-26 00:13:49','1999-04-31 00:13:49',5.0000); INSERT INTO PreviousRental VALUES (102,1132,'1999-04-26 00:13:27','1999-04-31 00:13:27',5.0000); INSERT INTO PreviousRental VALUES (102,1122,'1999-04-26 00:12:11','1999-04-31 00:12:11',5.0000); INSERT INTO PreviousRental VALUES (102,1131,'1999-04-26 00:11:37','1999-04-31 00:11:37',5.0000); INSERT INTO PreviousRental VALUES (102,1121,'1999-04-26 00:07:19','1999-04-31 00:07:19',5.0000); INSERT INTO PreviousRental VALUES (102,1142,'1999-04-26 03:55:57','1999-04-31 03:55:57',5.0000); INSERT INTO PreviousRental VALUES (101,1143,'1999-04-26 04:47:16','1999-04-31 04:47:16',5.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-26 01:30:00','1999-04-29 01:30:00',3.0000); INSERT INTO PreviousRental VALUES (201,1011,'1999-04-26 02:01:02','1999-04-31 02:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-26 04:19:33','1999-04-31 04:19:33',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-26 04:19:33','1999-04-31 04:19:33',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-26 04:39:14','1999-04-31 04:39:14',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-26 03:00:53','1999-04-31 03:00:53',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-26 01:50:50','1999-04-31 01:50:50',5.0000); INSERT INTO PreviousRental VALUES (103,1110,'1999-04-26 04:11:05','1999-04-31 04:11:05',5.0000); INSERT INTO PreviousRental VALUES (201,1110,'1999-04-26 02:00:47','1999-04-26 02:13:55',5.0000); INSERT INTO PreviousRental VALUES (104,909287,'1999-04-26 00:37:38','1999-04-26 02:00:46',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-26 01:30:00','1999-04-26 02:00:46',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 01:49:23','1999-04-26 02:00:46',5.0000); INSERT INTO PreviousRental VALUES (104,909187,'1999-04-26 01:30:00','1999-04-26 01:45:14',3.0000); INSERT INTO PreviousRental VALUES (103,123,'1999-04-19 08:28:36','1999-04-19 09:21:56',3.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-26 01:30:00','1999-04-26 01:45:14',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-26 01:30:00','1999-04-26 01:45:14',3.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-26 01:30:00','1999-04-26 01:30:18',3.0000); INSERT INTO PreviousRental VALUES (104,1111,'1999-04-26 01:30:00','1999-04-26 01:30:18',3.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-26 01:20:39','1999-04-26 01:28:10',2.9500); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-26 01:23:36','1999-04-26 01:24:09',2.9500); INSERT INTO PreviousRental VALUES (444,1110,'1999-04-26 01:23:36','1999-04-26 01:24:09',2.9500); INSERT INTO PreviousRental VALUES (444,775164,'1999-04-26 01:23:36','1999-04-26 01:24:09',2.9500); INSERT INTO PreviousRental VALUES (444,909387,'1999-04-26 01:23:36','1999-04-26 01:24:09',2.9500); INSERT INTO PreviousRental VALUES (444,1141,'1999-04-26 01:21:28','1999-04-26 01:22:02',2.9500); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-26 01:19:38','1999-04-26 01:20:22',2.9500); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-26 01:19:38','1999-04-26 01:20:22',2.9500); INSERT INTO PreviousRental VALUES (102,1233,'1999-04-26 00:18:54','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-26 00:18:54','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-26 00:28:13','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-26 00:19:58','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-26 00:18:54','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-26 00:38:56','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-26 00:34:35','1999-04-26 01:17:36',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-25 23:44:05','1999-04-26 01:16:09',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 23:35:08','1999-04-26 01:16:09',2.9900); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 23:35:08','1999-04-26 01:16:09',2.9900); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 23:35:08','1999-04-26 01:16:09',2.9900); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 23:35:08','1999-04-26 01:16:09',2.9900); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-26 01:15:00','1999-04-26 01:15:33',2.9500); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-26 00:18:47','1999-04-26 01:00:43',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 23:35:08','1999-04-26 01:00:42',2.9900); INSERT INTO PreviousRental VALUES (101,775264,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,775364,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,909287,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,909187,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,909387,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,1013,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (106,101,'1999-04-19 22:22:45','1999-04-19 22:23:52',3.0000); INSERT INTO PreviousRental VALUES (102,111,'1999-04-19 22:22:45','1999-04-19 22:23:52',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 23:13:21','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (104,1013,'1999-04-19 22:22:45','1999-04-19 22:23:52',3.0000); INSERT INTO PreviousRental VALUES (103,775164,'1999-04-25 23:13:35','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-25 23:13:21','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (104,1231,'1999-04-19 22:22:45','1999-04-19 22:23:53',3.0000); INSERT INTO PreviousRental VALUES (102,77564,'1999-04-19 22:22:45','1999-04-19 22:24:27',3.0000); INSERT INTO PreviousRental VALUES (103,1232,'1999-04-25 23:13:35','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (104,775164,'1999-04-19 22:22:45','1999-04-19 22:24:28',3.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 23:13:22','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 23:13:22','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (103,1110,'1999-04-25 23:13:35','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-25 23:13:21','1999-04-25 23:13:54',5.0000); INSERT INTO PreviousRental VALUES (104,909387,'1999-04-19 22:22:45','1999-04-19 22:24:28',3.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-25 23:10:03','1999-04-25 23:12:59',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-25 23:10:03','1999-04-25 23:12:59',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-25 23:10:04','1999-04-25 23:12:59',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-25 23:10:04','1999-04-25 23:12:59',5.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 23:10:05','1999-04-25 23:12:59',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-25 23:10:05','1999-04-25 23:12:58',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 23:10:05','1999-04-25 23:12:58',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 23:10:04','1999-04-25 23:12:58',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 23:10:04','1999-04-25 23:12:58',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-25 23:10:04','1999-04-25 23:12:35',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-25 23:10:04','1999-04-25 23:12:16',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 23:10:03','1999-04-25 23:10:55',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 23:10:04','1999-04-25 23:10:55',5.0000); INSERT INTO PreviousRental VALUES (102,997387,'1999-04-19 22:22:45','1999-04-20 11:50:36',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 23:10:03','1999-04-25 23:10:27',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 23:10:04','1999-04-25 23:10:21',5.0000); INSERT INTO PreviousRental VALUES (102,1131,'1999-04-19 22:22:45','1999-04-20 13:25:46',3.0000); INSERT INTO PreviousRental VALUES (106,101,'1999-04-25 19:03:57','1999-04-30 19:03:57',5.0000); INSERT INTO PreviousRental VALUES (103,101,'1999-04-25 19:21:46','1999-04-30 19:21:46',5.0000); INSERT INTO PreviousRental VALUES (104,101,'1999-04-25 19:09:28','1999-04-30 19:09:28',5.0000); INSERT INTO PreviousRental VALUES (103,997187,'1999-04-25 17:37:01','1999-04-25 23:04:43',3.0000); INSERT INTO PreviousRental VALUES (103,77564,'1999-04-20 15:28:26','1999-04-20 15:29:09',3.0000); INSERT INTO PreviousRental VALUES (102,114,'1999-04-20 15:28:26','1999-04-20 17:44:52',3.0000); INSERT INTO PreviousRental VALUES (102,1451,'1999-04-25 17:37:01','1999-04-25 23:04:43',3.0000); INSERT INTO PreviousRental VALUES (103,1142,'1999-04-25 17:37:01','1999-04-25 23:04:43',3.0000); INSERT INTO PreviousRental VALUES (102,1141,'1999-04-25 17:37:01','1999-04-25 23:04:43',3.0000); INSERT INTO PreviousRental VALUES (103,1131,'1999-04-25 17:37:01','1999-04-25 23:04:43',3.0000); INSERT INTO PreviousRental VALUES (102,1123,'1999-04-25 18:47:50','1999-04-25 23:04:42',5.0000); INSERT INTO PreviousRental VALUES (201,775164,'1999-04-20 21:01:59','1999-04-21 00:35:12',3.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-20 21:01:59','1999-04-21 00:35:12',3.0000); INSERT INTO PreviousRental VALUES (111,1121,'1999-04-25 17:37:01','1999-04-25 23:04:42',3.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-25 22:35:25','1999-04-25 23:03:51',3.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 22:58:01','1999-04-25 23:03:51',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 22:58:01','1999-04-25 23:03:21',5.0000); INSERT INTO PreviousRental VALUES (444,1113,'1999-04-21 03:55:15','1999-04-21 03:55:34',5.0000); INSERT INTO PreviousRental VALUES (444,1232,'1999-04-21 03:55:15','1999-04-21 03:55:34',5.0000); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-25 22:35:03','1999-04-25 22:56:05',3.0000); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-21 03:55:15','1999-04-21 03:55:34',5.0000); INSERT INTO PreviousRental VALUES (102,101,'1999-04-20 21:01:59','1999-04-21 11:40:59',3.0000); INSERT INTO PreviousRental VALUES (101,997287,'1999-04-25 22:51:59','1999-04-25 22:52:30',2.9500); INSERT INTO PreviousRental VALUES (201,1110,'1999-04-20 21:01:59','1999-04-21 11:41:00',3.0000); INSERT INTO PreviousRental VALUES (101,1122,'1999-04-25 22:51:59','1999-04-25 22:52:30',2.9500); INSERT INTO PreviousRental VALUES (101,1452,'1999-04-25 22:51:59','1999-04-25 22:52:30',2.9500); INSERT INTO PreviousRental VALUES (101,1143,'1999-04-25 22:51:59','1999-04-25 22:52:30',2.9500); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 22:38:53','1999-04-25 22:48:22',5.0000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-25 22:35:03','1999-04-25 22:44:58',3.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-25 22:35:25','1999-04-25 22:39:29',3.0000); INSERT INTO PreviousRental VALUES (111,1141,'1999-04-20 21:01:59','1999-04-21 16:35:32',3.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 22:38:53','1999-04-25 22:39:14',5.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-25 22:35:03','1999-04-25 22:38:45',3.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-25 22:35:25','1999-04-25 22:38:45',3.0000); INSERT INTO PreviousRental VALUES (102,1231,'1999-04-25 22:35:25','1999-04-25 22:38:22',3.0000); INSERT INTO PreviousRental VALUES (103,1013,'1999-04-21 17:38:22','1999-04-21 18:36:09',3.5000); INSERT INTO PreviousRental VALUES (103,1110,'1999-04-21 17:29:53','1999-04-21 18:36:09',3.5000); INSERT INTO PreviousRental VALUES (103,1111,'1999-04-21 17:38:54','1999-04-21 18:36:10',3.5000); INSERT INTO PreviousRental VALUES (103,1112,'1999-04-21 17:38:54','1999-04-21 18:36:10',3.5000); INSERT INTO PreviousRental VALUES (103,1113,'1999-04-21 17:38:54','1999-04-21 18:36:10',3.5000); INSERT INTO PreviousRental VALUES (103,1231,'1999-04-21 17:38:54','1999-04-21 18:48:34',3.5000); INSERT INTO PreviousRental VALUES (103,1233,'1999-04-21 17:38:54','1999-04-21 18:48:34',3.5000); INSERT INTO PreviousRental VALUES (102,1111,'1999-04-25 22:35:03','1999-04-25 22:38:22',3.0000); INSERT INTO PreviousRental VALUES (444,775164,'1999-04-21 03:55:15','1999-04-21 18:48:35',5.0000); INSERT INTO PreviousRental VALUES (103,775364,'1999-04-21 17:38:42','1999-04-21 18:48:35',3.5000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 22:34:08','1999-04-25 22:37:34',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 22:34:09','1999-04-25 22:37:34',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 22:37:24','1999-04-25 22:37:34',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-25 22:37:24','1999-04-25 22:37:34',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 22:34:09','1999-04-25 22:34:51',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 22:34:09','1999-04-25 22:34:51',5.0000); INSERT INTO PreviousRental VALUES (102,123,'1999-04-22 00:25:52','1999-04-22 00:31:00',3.5000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 21:48:59','1999-04-25 22:32:04',5.0000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-22 00:29:01','1999-04-22 00:31:00',3.5000); INSERT INTO PreviousRental VALUES (444,1110,'1999-04-25 21:48:59','1999-04-25 22:32:04',5.0000); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 21:48:58','1999-04-25 22:32:04',5.0000); INSERT INTO PreviousRental VALUES (102,1231,'1999-04-22 00:28:41','1999-04-22 00:31:01',3.5000); INSERT INTO PreviousRental VALUES (103,1232,'1999-04-21 17:38:54','1999-04-22 00:31:01',3.5000); INSERT INTO PreviousRental VALUES (103,1011,'1999-04-25 22:21:07','1999-04-25 22:32:04',5.0000); INSERT INTO PreviousRental VALUES (102,90987,'1999-04-21 21:21:08','1999-04-22 00:31:01',3.0000); INSERT INTO PreviousRental VALUES (101,1452,'1999-04-25 22:30:35','1999-04-25 22:30:56',2.9500); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-21 21:21:08','1999-04-22 00:31:02',3.0000); INSERT INTO PreviousRental VALUES (101,1143,'1999-04-25 22:30:35','1999-04-25 22:30:56',2.9500); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 22:25:48','1999-04-25 22:30:31',2.9500); INSERT INTO PreviousRental VALUES (444,775264,'1999-04-25 21:48:58','1999-04-25 22:27:56',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 22:25:48','1999-04-25 22:27:56',2.9500); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 21:48:58','1999-04-25 22:27:52',5.0000); INSERT INTO PreviousRental VALUES (102,101,'1999-04-22 00:32:14','1999-04-22 00:36:34',3.5000); INSERT INTO PreviousRental VALUES (102,111,'1999-04-22 00:32:14','1999-04-22 00:36:34',3.5000); INSERT INTO PreviousRental VALUES (102,123,'1999-04-22 00:32:14','1999-04-22 00:36:34',3.5000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-22 00:32:14','1999-04-22 00:36:34',3.5000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-22 00:32:14','1999-04-22 00:36:35',3.5000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-22 00:32:14','1999-04-22 00:36:35',3.5000); INSERT INTO PreviousRental VALUES (102,1111,'1999-04-22 00:32:14','1999-04-22 00:36:35',3.5000); INSERT INTO PreviousRental VALUES (102,1112,'1999-04-22 00:32:14','1999-04-22 00:36:36',3.5000); INSERT INTO PreviousRental VALUES (102,1113,'1999-04-22 00:32:14','1999-04-22 00:36:36',3.5000); INSERT INTO PreviousRental VALUES (102,1231,'1999-04-22 00:32:14','1999-04-22 00:36:36',3.5000); INSERT INTO PreviousRental VALUES (102,1232,'1999-04-22 00:32:14','1999-04-22 00:36:36',3.5000); INSERT INTO PreviousRental VALUES (102,1233,'1999-04-22 00:32:14','1999-04-22 00:36:37',3.5000); INSERT INTO PreviousRental VALUES (102,77564,'1999-04-22 00:32:14','1999-04-22 00:36:37',3.5000); INSERT INTO PreviousRental VALUES (102,90987,'1999-04-22 00:32:14','1999-04-22 00:36:37',3.5000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-22 00:32:14','1999-04-22 00:36:37',3.5000); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-22 00:32:14','1999-04-22 00:36:37',3.5000); INSERT INTO PreviousRental VALUES (103,1452,'1999-04-25 17:37:01','1999-04-25 22:17:32',3.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-22 00:32:14','1999-04-22 00:36:38',3.5000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-22 00:32:14','1999-04-22 00:36:38',3.5000); INSERT INTO PreviousRental VALUES (444,1011,'1999-04-25 21:48:58',NULL,5.0000); INSERT INTO PreviousRental VALUES (103,1121,'1999-04-21 16:58:38','1999-04-22 11:19:06',3.5000); INSERT INTO PreviousRental VALUES (103,1141,'1999-04-21 18:14:11','1999-04-22 11:19:07',3.5000); INSERT INTO PreviousRental VALUES (102,99787,'1999-04-20 21:01:59','1999-04-22 11:19:07',3.0000); INSERT INTO PreviousRental VALUES (444,775264,'1999-04-25 21:47:10','1999-04-25 21:47:18',2.9500); INSERT INTO PreviousRental VALUES (111,113,'1999-04-20 21:01:59','1999-04-22 11:54:32',3.0000); INSERT INTO PreviousRental VALUES (103,114,'1999-04-21 17:56:05','1999-04-22 11:54:32',3.5000); INSERT INTO PreviousRental VALUES (444,1011,'1999-04-25 21:46:18','1999-04-25 21:46:23',2.9500); INSERT INTO PreviousRental VALUES (444,1231,'1999-04-25 21:25:46','1999-04-25 21:45:20',2.9500); INSERT INTO PreviousRental VALUES (111,997187,'1999-04-20 21:01:59','1999-04-22 11:54:33',3.0000); INSERT INTO PreviousRental VALUES (444,1113,'1999-04-25 21:22:54','1999-04-25 21:45:20',5.0000); INSERT INTO PreviousRental VALUES (103,1123,'1999-04-21 14:07:59','1999-04-22 11:55:14',5.0000); INSERT INTO PreviousRental VALUES (444,1112,'1999-04-25 21:44:58','1999-04-25 21:45:20',2.9500); INSERT INTO PreviousRental VALUES (201,1132,'1999-04-21 17:52:09','1999-04-22 11:55:14',3.5000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 21:22:53','1999-04-25 21:45:20',5.0000); INSERT INTO PreviousRental VALUES (111,1452,'1999-04-20 21:01:59','1999-04-22 11:55:14',3.0000); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 21:22:53','1999-04-25 21:45:20',5.0000); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 21:22:53','1999-04-25 21:45:20',5.0000); INSERT INTO PreviousRental VALUES (444,1112,'1999-04-25 21:22:53','1999-04-25 21:33:22',5.0000); INSERT INTO PreviousRental VALUES (444,1113,'1999-04-25 21:08:55','1999-04-25 21:09:58',5.0000); INSERT INTO PreviousRental VALUES (106,123,'1999-04-22 12:54:39','1999-04-22 17:53:53',3.0000); INSERT INTO PreviousRental VALUES (444,1112,'1999-04-25 21:08:55','1999-04-25 21:09:58',5.0000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 21:08:55','1999-04-25 21:09:58',5.0000); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 21:08:55','1999-04-25 21:09:58',5.0000); INSERT INTO PreviousRental VALUES (103,1111,'1999-04-22 15:54:46','1999-04-22 17:53:55',3.0000); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 21:08:54','1999-04-25 21:09:58',5.0000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 21:06:00','1999-04-25 21:07:08',2.9500); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 21:06:00','1999-04-25 21:07:08',2.9500); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 21:06:00','1999-04-25 21:07:08',2.9500); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 20:58:09','1999-04-25 21:01:42',2.9500); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 20:58:08','1999-04-25 21:01:42',2.9500); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 20:58:08','1999-04-25 21:01:42',2.9500); INSERT INTO PreviousRental VALUES (103,775364,'1999-04-25 20:33:07','1999-04-25 20:35:44',5.0000); INSERT INTO PreviousRental VALUES (103,775264,'1999-04-25 20:32:57','1999-04-25 20:35:44',5.0000); INSERT INTO PreviousRental VALUES (103,909387,'1999-04-25 20:32:57','1999-04-25 20:35:44',5.0000); INSERT INTO PreviousRental VALUES (103,909287,'1999-04-25 20:33:07','1999-04-25 20:35:44',5.0000); INSERT INTO PreviousRental VALUES (102,1132,'1999-04-25 18:47:42','1999-04-25 23:47:42',5.0000); INSERT INTO PreviousRental VALUES (102,1122,'1999-04-25 18:45:01','1999-04-25 23:45:01',5.0000); INSERT INTO PreviousRental VALUES (102,1453,'1999-04-25 18:45:01','1999-04-25 23:45:01',5.0000); INSERT INTO PreviousRental VALUES (102,1143,'1999-04-25 18:48:46','1999-04-25 23:48:46',5.0000); INSERT INTO PreviousRental VALUES (201,111,'1999-04-22 17:55:15','1999-04-22 17:55:15',2.5000); INSERT INTO PreviousRental VALUES (104,111,'1999-04-22 17:57:53','1999-04-22 17:57:53',2.5000); INSERT INTO PreviousRental VALUES (104,145,'1999-04-22 17:57:53','1999-04-22 17:57:53',2.5000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 20:29:16','1999-04-25 20:30:44',5.0000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 19:35:05','1999-04-25 20:30:24',5.0000); INSERT INTO PreviousRental VALUES (104,1131,'1999-04-22 11:55:56','1999-04-22 19:35:56',5.0000); INSERT INTO PreviousRental VALUES (102,99787,'1999-04-22 13:13:31','1999-04-22 19:35:56',5.0000); INSERT INTO PreviousRental VALUES (444,111,'1999-04-22 18:06:22','1999-04-22 20:37:41',3.5000); INSERT INTO PreviousRental VALUES (102,112,'1999-04-22 13:13:30','1999-04-22 21:20:01',5.0000); INSERT INTO PreviousRental VALUES (102,145,'0000-00-00 00:00:00','1999-04-22 21:20:01',0.0000); INSERT INTO PreviousRental VALUES (104,1121,'1999-04-22 11:55:56','1999-04-22 21:20:01',5.0000); INSERT INTO PreviousRental VALUES (103,1122,'1999-04-21 16:59:41','1999-04-22 21:20:02',3.5000); INSERT INTO PreviousRental VALUES (104,1123,'1999-04-22 11:55:56','1999-04-22 21:20:02',5.0000); INSERT INTO PreviousRental VALUES (201,1133,'1999-04-21 17:55:46','1999-04-22 21:20:02',3.5000); INSERT INTO PreviousRental VALUES (103,1143,'1999-04-21 17:31:03','1999-04-22 21:20:02',5.0000); INSERT INTO PreviousRental VALUES (104,1451,'1999-04-22 11:55:55','1999-04-22 21:20:02',5.0000); INSERT INTO PreviousRental VALUES (103,997287,'1999-04-21 16:44:06','1999-04-22 21:20:03',3.5000); INSERT INTO PreviousRental VALUES (103,997387,'1999-04-21 17:39:45','1999-04-22 21:20:03',3.5000); INSERT INTO PreviousRental VALUES (102,123,'0000-00-00 00:00:00','1999-04-22 21:20:37',0.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-22 20:30:31','1999-04-22 21:20:38',5.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-22 20:30:31','1999-04-22 21:20:38',5.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-22 20:30:31','1999-04-22 21:20:38',5.0000); INSERT INTO PreviousRental VALUES (444,1013,'1999-04-25 19:52:28','1999-04-25 20:30:09',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 19:36:16','1999-04-25 20:30:09',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-25 20:29:16','1999-04-25 20:30:09',5.0000); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 19:39:49','1999-04-25 20:29:33',5.0000); INSERT INTO PreviousRental VALUES (201,77564,'1999-04-22 22:37:06','1999-04-22 22:42:23',3.0000); INSERT INTO PreviousRental VALUES (201,90987,'1999-04-22 22:37:06','1999-04-22 22:42:24',3.0000); INSERT INTO PreviousRental VALUES (103,112,'1999-04-22 21:59:44','1999-04-22 22:43:01',3.0000); INSERT INTO PreviousRental VALUES (444,775164,'1999-04-25 19:39:49','1999-04-25 19:47:45',5.0000); INSERT INTO PreviousRental VALUES (103,114,'1999-04-22 21:59:44','1999-04-22 22:43:02',3.0000); INSERT INTO PreviousRental VALUES (103,145,'1999-04-22 21:59:44','1999-04-22 22:43:02',3.0000); INSERT INTO PreviousRental VALUES (444,909387,'1999-04-25 19:39:49','1999-04-25 19:44:14',5.0000); INSERT INTO PreviousRental VALUES (103,1141,'1999-04-22 22:37:06','1999-04-22 22:43:02',3.0000); INSERT INTO PreviousRental VALUES (106,1142,'1999-04-22 22:37:06','1999-04-22 22:43:03',3.0000); INSERT INTO PreviousRental VALUES (444,909287,'1999-04-25 19:39:49','1999-04-25 19:44:14',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-25 19:32:51','1999-04-25 19:34:35',5.0000); INSERT INTO PreviousRental VALUES (106,1452,'1999-04-22 22:37:06','1999-04-22 22:43:04',3.0000); INSERT INTO PreviousRental VALUES (111,909387,'1999-04-25 17:37:57','1999-04-25 19:32:16',3.0000); INSERT INTO PreviousRental VALUES (111,909287,'1999-04-25 17:37:01','1999-04-25 19:32:16',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 19:28:46','1999-04-25 19:32:16',5.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-22 23:18:19','1999-04-27 23:18:19',5.0000); INSERT INTO PreviousRental VALUES (102,111,'1999-04-22 22:43:50','1999-04-27 22:43:50',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,111,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,123,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,90987,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-23 00:01:20','1999-04-28 00:01:20',5.0000); INSERT INTO PreviousRental VALUES (111,775364,'1999-04-25 17:37:57','1999-04-25 19:32:15',3.0000); INSERT INTO PreviousRental VALUES (102,90987,'1999-04-23 00:03:27','1999-04-28 00:03:27',5.0000); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,77564,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,111,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,123,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,90987,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-23 00:21:39','1999-04-28 00:21:39',5.0000); INSERT INTO PreviousRental VALUES (102,114,'1999-04-23 01:19:47','1999-04-23 01:19:47',2.5000); INSERT INTO PreviousRental VALUES (102,114,'1999-04-23 01:35:59','1999-04-23 01:35:59',2.5000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 18:40:16','1999-04-25 19:32:15',0.0500); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-23 00:21:39','1999-04-23 02:26:15',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-25 18:38:25','1999-04-25 19:32:15',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 18:40:09','1999-04-25 19:32:15',0.0500); INSERT INTO PreviousRental VALUES (103,775164,'1999-04-23 10:48:32','1999-04-23 11:40:07',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-25 19:28:46','1999-04-25 19:32:15',5.0000); INSERT INTO PreviousRental VALUES (111,775264,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (111,1231,'1999-04-25 17:37:57','1999-04-25 19:08:01',3.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-25 17:37:01','1999-04-25 19:00:19',3.0000); INSERT INTO PreviousRental VALUES (102,123,'1999-04-23 11:50:41','1999-04-23 12:22:55',5.0000); INSERT INTO PreviousRental VALUES (104,1133,'1999-04-23 02:30:21','1999-04-23 12:23:03',5.0000); INSERT INTO PreviousRental VALUES (104,1143,'1999-04-23 02:30:21','1999-04-23 12:23:03',5.0000); INSERT INTO PreviousRental VALUES (104,1453,'1999-04-23 02:30:21','1999-04-23 12:23:03',5.0000); INSERT INTO PreviousRental VALUES (104,997387,'1999-04-23 02:30:22','1999-04-23 12:23:03',5.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-25 17:37:01','1999-04-25 19:00:19',3.0000); INSERT INTO PreviousRental VALUES (111,1112,'1999-04-25 17:37:57','1999-04-25 19:00:19',3.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 17:31:13','1999-04-25 19:00:18',5.0000); INSERT INTO PreviousRental VALUES (111,1110,'1999-04-25 17:37:01','1999-04-25 19:00:18',3.0000); INSERT INTO PreviousRental VALUES (111,1013,'1999-04-25 17:37:57','1999-04-25 19:00:18',3.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 17:31:13','1999-04-25 19:00:18',5.0000); INSERT INTO PreviousRental VALUES (201,997387,'1999-04-25 16:48:07','1999-04-25 17:16:53',5.0000); INSERT INTO PreviousRental VALUES (104,997287,'1999-04-25 16:43:08','1999-04-25 17:16:53',5.0000); INSERT INTO PreviousRental VALUES (101,1453,'1999-04-25 16:54:57','1999-04-25 17:16:53',3.0000); INSERT INTO PreviousRental VALUES (444,1113,'1999-04-22 18:12:51','1999-04-23 14:04:39',3.5000); INSERT INTO PreviousRental VALUES (444,1233,'1999-04-22 18:12:57','1999-04-23 14:06:25',3.5000); INSERT INTO PreviousRental VALUES (101,1452,'1999-04-25 16:39:34','1999-04-25 17:16:53',3.0000); INSERT INTO PreviousRental VALUES (101,1143,'1999-04-25 16:54:57','1999-04-25 17:16:53',3.0000); INSERT INTO PreviousRental VALUES (444,101,'1999-04-22 18:12:30','1999-04-23 14:18:42',3.5000); INSERT INTO PreviousRental VALUES (201,1142,'1999-04-25 17:02:10','1999-04-25 17:16:53',5.0000); INSERT INTO PreviousRental VALUES (104,111,'1999-04-23 12:53:52','1999-04-23 19:23:23',5.0000); INSERT INTO PreviousRental VALUES (201,1141,'1999-04-25 16:21:29','1999-04-25 17:16:52',5.0000); INSERT INTO PreviousRental VALUES (201,997187,'1999-04-25 16:25:44','1999-04-25 17:16:39',5.0000); INSERT INTO PreviousRental VALUES (104,77564,'1999-04-23 12:53:52','1999-04-23 20:01:03',5.0000); INSERT INTO PreviousRental VALUES (201,1451,'1999-04-25 16:54:17','1999-04-25 17:16:38',5.0000); INSERT INTO PreviousRental VALUES (101,1133,'1999-04-25 16:38:41','1999-04-25 17:16:38',3.0000); INSERT INTO PreviousRental VALUES (201,1132,'1999-04-25 16:57:46','1999-04-25 17:16:38',5.0000); INSERT INTO PreviousRental VALUES (103,775364,'1999-04-23 14:20:47','1999-04-23 20:01:04',5.0000); INSERT INTO PreviousRental VALUES (104,909187,'1999-04-23 12:53:52','1999-04-23 20:01:04',5.0000); INSERT INTO PreviousRental VALUES (101,1131,'1999-04-25 16:54:57','1999-04-25 17:16:38',3.0000); INSERT INTO PreviousRental VALUES (201,1123,'1999-04-25 17:03:12','1999-04-25 17:16:38',5.0000); INSERT INTO PreviousRental VALUES (101,1122,'1999-04-25 16:54:57','1999-04-25 17:16:37',3.0000); INSERT INTO PreviousRental VALUES (101,1121,'1999-04-25 16:54:57','1999-04-25 17:16:37',3.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-25 17:12:16','1999-04-25 17:16:37',3.0000); INSERT INTO PreviousRental VALUES (104,112,'1999-04-23 19:46:26','1999-04-23 20:27:33',3.0000); INSERT INTO PreviousRental VALUES (102,113,'1999-04-23 19:46:26','1999-04-23 20:27:33',3.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-25 17:12:16','1999-04-25 17:15:26',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 17:12:16','1999-04-25 17:15:26',3.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-25 17:12:49','1999-04-25 17:15:26',3.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-25 17:12:49','1999-04-25 17:15:25',3.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 17:12:49','1999-04-25 17:15:25',3.0000); INSERT INTO PreviousRental VALUES (102,1142,'1999-04-23 19:46:26','1999-04-23 20:27:34',3.0000); INSERT INTO PreviousRental VALUES (104,1451,'1999-04-23 19:46:26','1999-04-23 20:27:34',3.0000); INSERT INTO PreviousRental VALUES (102,1452,'1999-04-23 19:46:26','1999-04-23 20:27:34',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 17:12:32','1999-04-25 17:15:25',3.0000); INSERT INTO PreviousRental VALUES (104,99787,'1999-04-23 19:46:26','1999-04-23 20:27:35',3.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-25 17:13:28','1999-04-25 17:15:25',3.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 17:13:28','1999-04-25 17:15:25',3.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 17:12:32','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 17:13:28','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 17:12:32','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-25 17:12:49','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-25 17:12:32','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 17:13:28','1999-04-25 17:15:24',3.0000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-24 00:25:18','1999-04-24 01:37:10',3.5000); INSERT INTO PreviousRental VALUES (102,1113,'1999-04-23 22:07:45','1999-04-24 01:37:10',3.0000); INSERT INTO PreviousRental VALUES (102,1233,'1999-04-23 22:09:44','1999-04-24 01:37:10',3.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-25 16:28:54','1999-04-25 17:06:15',3.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-25 16:21:26','1999-04-25 17:04:48',3.0000); INSERT INTO PreviousRental VALUES (444,909187,'1999-04-25 15:29:46','1999-04-25 17:04:48',3.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-23 22:07:45','1999-04-24 01:37:10',3.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-25 15:35:57','1999-04-25 17:04:47',2.9900); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-25 16:28:54','1999-04-25 17:04:47',3.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 15:35:33','1999-04-25 17:04:47',2.9900); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 16:48:07','1999-04-25 17:04:46',2.9900); INSERT INTO PreviousRental VALUES (104,1232,'1999-04-25 15:39:56','1999-04-25 17:04:46',2.9900); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 16:31:48','1999-04-25 17:04:45',5.0000); INSERT INTO PreviousRental VALUES (201,1113,'1999-04-25 16:31:12','1999-04-25 17:04:45',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 16:17:19','1999-04-25 17:04:44',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-25 15:32:26','1999-04-25 17:04:44',5.0000); INSERT INTO PreviousRental VALUES (111,1110,'1999-04-25 15:23:19','1999-04-25 17:04:44',3.5000); INSERT INTO PreviousRental VALUES (111,1013,'1999-04-25 15:28:41','1999-04-25 17:04:43',3.5000); INSERT INTO PreviousRental VALUES (103,1011,'1999-04-25 15:20:39','1999-04-25 17:04:43',2.9900); INSERT INTO PreviousRental VALUES (101,1453,'1999-04-25 16:35:37','1999-04-25 16:50:55',5.0000); INSERT INTO PreviousRental VALUES (101,1451,'1999-04-25 16:39:34','1999-04-25 16:50:54',3.0000); INSERT INTO PreviousRental VALUES (201,1143,'1999-04-25 16:25:30','1999-04-25 16:50:54',5.0000); INSERT INTO PreviousRental VALUES (201,1142,'1999-04-25 16:25:20','1999-04-25 16:50:54',5.0000); INSERT INTO PreviousRental VALUES (101,1132,'1999-04-25 16:38:41','1999-04-25 16:50:53',3.0000); INSERT INTO PreviousRental VALUES (201,1131,'1999-04-25 16:25:44','1999-04-25 16:50:53',5.0000); INSERT INTO PreviousRental VALUES (104,1123,'1999-04-25 16:42:39','1999-04-25 16:50:53',5.0000); INSERT INTO PreviousRental VALUES (101,1122,'1999-04-25 16:38:41','1999-04-25 16:50:52',3.0000); INSERT INTO PreviousRental VALUES (201,1121,'1999-04-25 15:47:04','1999-04-25 16:50:52',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,997387,'1999-04-25 16:40:53','1999-04-25 16:45:41',3.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-25 15:40:45','1999-04-25 15:56:21',5.0000); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-25 15:03:19','1999-04-25 15:56:21',2.9900); INSERT INTO PreviousRental VALUES (102,1231,'1999-04-25 14:55:46','1999-04-25 15:56:21',2.9900); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 15:32:26','1999-04-25 15:56:20',5.0000); INSERT INTO PreviousRental VALUES (104,775264,'1999-04-24 03:28:57','1999-04-24 11:53:23',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-25 15:32:26','1999-04-25 15:56:20',5.0000); INSERT INTO PreviousRental VALUES (201,1133,'1999-04-25 15:39:32','1999-04-25 15:41:50',3.0000); INSERT INTO PreviousRental VALUES (201,1132,'1999-04-25 15:39:28','1999-04-25 15:41:50',3.0000); INSERT INTO PreviousRental VALUES (102,1123,'1999-04-23 22:37:10','1999-04-24 14:12:17',3.0000); INSERT INTO PreviousRental VALUES (102,1141,'1999-04-23 22:37:10','1999-04-24 14:12:17',3.0000); INSERT INTO PreviousRental VALUES (102,1451,'1999-04-23 22:34:40','1999-04-24 14:12:17',5.0000); INSERT INTO PreviousRental VALUES (102,997187,'1999-04-23 22:37:10','1999-04-24 14:12:17',3.0000); INSERT INTO PreviousRental VALUES (201,1131,'1999-04-25 15:39:27','1999-04-25 15:41:49',3.0000); INSERT INTO PreviousRental VALUES (104,909287,'1999-04-24 03:28:57','1999-04-24 14:43:42',5.0000); INSERT INTO PreviousRental VALUES (201,1123,'1999-04-25 15:39:29','1999-04-25 15:41:49',3.0000); INSERT INTO PreviousRental VALUES (201,1122,'1999-04-25 15:39:28','1999-04-25 15:41:48',3.0000); INSERT INTO PreviousRental VALUES (201,1121,'1999-04-25 15:29:11','1999-04-25 15:41:48',3.0000); INSERT INTO PreviousRental VALUES (444,909387,'1999-04-25 15:32:57','1999-04-25 15:38:37',NULL); INSERT INTO PreviousRental VALUES (201,1112,'1999-04-25 15:12:23','1999-04-25 15:23:14',NULL); INSERT INTO PreviousRental VALUES (106,1121,'1999-04-25 15:20:49','1999-04-25 15:22:08',3.0000); INSERT INTO PreviousRental VALUES (104,997287,'1999-04-25 14:59:59','1999-04-25 15:20:32',5.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-25 15:15:28','1999-04-25 15:20:31',5.0000); INSERT INTO PreviousRental VALUES (106,1132,'1999-04-25 15:19:21','1999-04-25 15:20:31',3.0000); INSERT INTO PreviousRental VALUES (106,1123,'1999-04-25 15:19:26','1999-04-25 15:20:31',3.0000); INSERT INTO PreviousRental VALUES (106,1122,'1999-04-25 15:16:47','1999-04-25 15:20:30',3.0000); INSERT INTO PreviousRental VALUES (106,1121,'1999-04-25 15:19:14','1999-04-25 15:20:30',3.0000); INSERT INTO PreviousRental VALUES (106,1121,'1999-04-25 15:18:58','1999-04-25 15:19:03',NULL); INSERT INTO PreviousRental VALUES (106,1121,'1999-04-25 15:16:10','1999-04-25 15:18:26',3.0000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-25 15:04:33','1999-04-25 15:12:01',2.9900); INSERT INTO PreviousRental VALUES (201,1112,'1999-04-25 15:06:35','1999-04-25 15:11:17',NULL); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-25 15:03:00','1999-04-25 15:07:28',2.9900); INSERT INTO PreviousRental VALUES (102,909287,'1999-04-25 14:52:42','1999-04-25 15:02:48',2.9900); INSERT INTO PreviousRental VALUES (104,1143,'1999-04-25 14:59:59','1999-04-25 15:01:39',5.0000); INSERT INTO PreviousRental VALUES (102,1453,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (102,1143,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (444,1453,'1999-04-25 15:00:25','1999-04-25 15:01:20',5.0000); INSERT INTO PreviousRental VALUES (444,1122,'1999-04-25 15:00:25','1999-04-25 15:01:20',5.0000); INSERT INTO PreviousRental VALUES (102,997187,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (102,1133,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (102,1451,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (103,1011,'1999-04-24 18:02:17','1999-04-24 18:43:59',2.9900); INSERT INTO PreviousRental VALUES (103,1013,'1999-04-24 18:02:53','1999-04-24 18:43:59',2.9900); INSERT INTO PreviousRental VALUES (104,1110,'1999-04-24 18:15:40','1999-04-24 18:43:59',5.0000); INSERT INTO PreviousRental VALUES (111,1111,'1999-04-24 18:33:29','1999-04-24 18:44:00',5.0000); INSERT INTO PreviousRental VALUES (103,1112,'1999-04-24 17:57:14','1999-04-24 18:44:00',2.9900); INSERT INTO PreviousRental VALUES (103,1113,'1999-04-24 17:59:37','1999-04-24 18:44:00',2.9900); INSERT INTO PreviousRental VALUES (103,1231,'1999-04-24 17:55:56','1999-04-24 18:44:00',2.9900); INSERT INTO PreviousRental VALUES (103,1232,'1999-04-24 17:58:34','1999-04-24 18:44:00',2.9900); INSERT INTO PreviousRental VALUES (103,1233,'1999-04-24 17:59:52','1999-04-24 18:44:00',2.9900); INSERT INTO PreviousRental VALUES (101,90987,'1999-04-23 20:54:08','1999-04-25 15:01:00',5.0000); INSERT INTO PreviousRental VALUES (104,775264,'1999-04-24 18:16:16','1999-04-24 18:44:00',5.0000); INSERT INTO PreviousRental VALUES (104,775364,'1999-04-24 18:16:17','1999-04-24 18:44:01',5.0000); INSERT INTO PreviousRental VALUES (103,909187,'1999-04-24 18:00:06','1999-04-24 18:44:01',2.9900); INSERT INTO PreviousRental VALUES (103,909287,'1999-04-24 18:00:41','1999-04-24 18:44:01',2.9900); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-25 14:59:38','1999-04-25 15:00:48',NULL); INSERT INTO PreviousRental VALUES (102,1452,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (103,1110,'1999-04-24 20:14:41','1999-04-24 20:14:41',2.5000); INSERT INTO PreviousRental VALUES (103,1131,'1999-04-24 20:19:09','1999-04-24 20:19:09',2.5000); INSERT INTO PreviousRental VALUES (103,1231,'1999-04-24 20:19:52','1999-04-24 20:19:52',2.5000); INSERT INTO PreviousRental VALUES (101,1451,'1999-04-25 14:59:38','1999-04-25 15:00:43',5.0000); INSERT INTO PreviousRental VALUES (103,1232,'1999-04-24 20:22:28','1999-04-24 20:22:28',2.5000); INSERT INTO PreviousRental VALUES (101,997187,'1999-04-25 14:59:38','1999-04-25 15:00:34',5.0000); INSERT INTO PreviousRental VALUES (104,1121,'1999-04-24 20:32:26','1999-04-24 20:32:26',2.5000); INSERT INTO PreviousRental VALUES (104,1132,'1999-04-24 20:32:26','1999-04-24 20:32:26',2.5000); INSERT INTO PreviousRental VALUES (101,1121,'1999-04-25 14:59:38','1999-04-25 15:00:34',5.0000); INSERT INTO PreviousRental VALUES (111,1110,'1999-04-25 14:58:53','1999-04-25 15:00:18',5.0000); INSERT INTO PreviousRental VALUES (201,1232,'1999-04-24 20:43:04','0000-00-00 00:00:00',2.9900); INSERT INTO PreviousRental VALUES (102,1142,'1999-04-23 22:34:40','1999-04-28 22:34:40',5.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-25 14:57:22','1999-04-25 14:57:32',NULL); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-25 14:49:02','0000-00-00 00:00:00',2.9900); INSERT INTO PreviousRental VALUES (104,997187,'1999-04-24 18:05:00','1999-04-24 18:05:02',2.9900); INSERT INTO PreviousRental VALUES (102,1233,'1999-04-24 21:31:57','1999-04-29 21:31:57',5.0000); INSERT INTO PreviousRental VALUES (102,1231,'1999-04-25 14:53:28','0000-00-00 00:00:00',2.9900); INSERT INTO PreviousRental VALUES (201,1013,'1999-04-24 20:32:54','1999-04-24 22:28:32',2.9900); INSERT INTO PreviousRental VALUES (201,1110,'1999-04-24 20:32:24','1999-04-24 22:28:32',2.9900); INSERT INTO PreviousRental VALUES (102,775264,'1999-04-25 14:48:36','1999-04-25 14:53:35',2.9900); INSERT INTO PreviousRental VALUES (201,1112,'1999-04-24 20:25:31','1999-04-24 22:28:33',2.9900); INSERT INTO PreviousRental VALUES (201,1231,'1999-04-24 20:24:19','1999-04-24 22:28:33',2.9900); INSERT INTO PreviousRental VALUES (201,775164,'1999-04-24 20:42:41','1999-04-24 22:28:34',2.9900); INSERT INTO PreviousRental VALUES (102,1111,'1999-04-25 14:50:24','1999-04-25 14:53:35',2.9900); INSERT INTO PreviousRental VALUES (101,77564,'1999-04-23 20:54:08','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (201,909187,'1999-04-24 20:40:50','1999-04-24 22:28:35',2.9900); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-25 14:41:36','1999-04-25 14:46:56',5.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-25 14:44:41','1999-04-25 14:46:56',5.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-25 14:44:33','1999-04-25 14:46:56',5.0000); INSERT INTO PreviousRental VALUES (103,1011,'1999-04-24 22:40:37','1999-04-29 22:40:37',5.0000); INSERT INTO PreviousRental VALUES (103,1110,'1999-04-24 22:40:37','1999-04-24 22:41:59',5.0000); INSERT INTO PreviousRental VALUES (103,1112,'1999-04-24 22:40:37','1999-04-24 22:41:59',5.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-25 14:46:16','1999-04-25 14:46:34',5.0000); INSERT INTO PreviousRental VALUES (103,775264,'1999-04-24 22:40:37','1999-04-29 22:40:37',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 14:40:25','1999-04-25 14:46:34',3.0000); INSERT INTO PreviousRental VALUES (104,1110,'1999-04-25 00:45:29','1999-04-25 01:19:05',3.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-25 14:03:57','1999-04-25 14:46:04',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 14:40:25','1999-04-25 14:46:04',3.0000); INSERT INTO PreviousRental VALUES (103,1113,'1999-04-24 22:40:38','1999-04-25 01:19:05',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-25 14:11:38','1999-04-25 14:46:04',3.0000); INSERT INTO PreviousRental VALUES (104,1232,'1999-04-25 00:46:02','1999-04-25 01:19:05',5.0000); INSERT INTO PreviousRental VALUES (103,1233,'1999-04-25 00:49:05','1999-04-25 01:19:05',3.0000); INSERT INTO PreviousRental VALUES (102,775164,'1999-04-24 23:18:53','1999-04-25 01:19:05',3.0000); INSERT INTO PreviousRental VALUES (444,997287,'1999-04-25 14:02:08','1999-04-25 14:45:14',5.0000); INSERT INTO PreviousRental VALUES (102,775364,'1999-04-25 00:38:04','1999-04-25 01:19:05',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-24 23:18:53','1999-04-25 01:19:06',3.0000); INSERT INTO PreviousRental VALUES (104,909287,'1999-04-25 00:45:29','1999-04-25 01:19:06',3.0000); INSERT INTO PreviousRental VALUES (102,909387,'1999-04-25 00:38:04','1999-04-25 01:19:06',5.0000); INSERT INTO PreviousRental VALUES (102,1121,'1999-04-24 22:50:30','1999-04-25 01:51:53',3.0000); INSERT INTO PreviousRental VALUES (104,1122,'1999-04-24 19:32:26','1999-04-25 01:51:53',2.9900); INSERT INTO PreviousRental VALUES (102,1123,'1999-04-25 00:54:24','1999-04-25 01:51:53',5.0000); INSERT INTO PreviousRental VALUES (102,1131,'1999-04-24 23:01:16','1999-04-25 01:51:53',3.0000); INSERT INTO PreviousRental VALUES (102,1132,'1999-04-24 23:02:04','1999-04-25 01:51:53',3.0000); INSERT INTO PreviousRental VALUES (104,997187,'1999-04-25 14:01:49','1999-04-25 14:45:14',5.0000); INSERT INTO PreviousRental VALUES (201,1141,'1999-04-24 22:58:05','1999-04-25 01:51:53',3.0000); INSERT INTO PreviousRental VALUES (102,1143,'1999-04-24 22:49:35','1999-04-25 01:51:53',5.0000); INSERT INTO PreviousRental VALUES (102,1451,'1999-04-24 22:49:35','1999-04-25 01:51:54',5.0000); INSERT INTO PreviousRental VALUES (102,1452,'1999-04-24 22:49:35','1999-04-25 01:51:54',5.0000); INSERT INTO PreviousRental VALUES (102,1453,'1999-04-24 22:50:30','1999-04-25 01:51:54',3.0000); INSERT INTO PreviousRental VALUES (102,997287,'1999-04-23 23:19:39','1999-04-25 01:51:54',3.0000); INSERT INTO PreviousRental VALUES (201,997387,'1999-04-24 22:58:05','1999-04-25 01:51:54',3.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-25 01:52:50','1999-04-25 01:53:32',3.0000); INSERT INTO PreviousRental VALUES (106,1452,'1999-04-25 14:42:46','1999-04-25 14:45:14',5.0000); INSERT INTO PreviousRental VALUES (104,1110,'1999-04-25 01:52:50','1999-04-25 01:53:32',3.0000); INSERT INTO PreviousRental VALUES (104,1111,'1999-04-25 01:52:50','1999-04-25 01:53:33',3.0000); INSERT INTO PreviousRental VALUES (444,1231,'1999-04-25 01:52:50','1999-04-25 01:53:33',3.0000); INSERT INTO PreviousRental VALUES (444,1451,'1999-04-25 14:02:08','1999-04-25 14:45:14',5.0000); INSERT INTO PreviousRental VALUES (104,1143,'1999-04-25 14:01:49','1999-04-25 14:45:13',5.0000); INSERT INTO PreviousRental VALUES (106,1141,'1999-04-25 14:42:45','1999-04-25 14:45:12',5.0000); INSERT INTO PreviousRental VALUES (101,1133,'1999-04-25 14:11:59','1999-04-25 14:45:11',3.0000); INSERT INTO PreviousRental VALUES (103,775364,'1999-04-25 01:52:50','1999-04-25 01:53:34',3.0000); INSERT INTO PreviousRental VALUES (106,1122,'1999-04-25 14:42:46','1999-04-25 14:45:11',5.0000); INSERT INTO PreviousRental VALUES (444,1121,'1999-04-25 14:02:08','1999-04-25 14:45:11',5.0000); INSERT INTO PreviousRental VALUES (201,909387,'1999-04-25 01:52:50','1999-04-25 01:53:35',3.0000); INSERT INTO PreviousRental VALUES (104,909287,'1999-04-25 14:24:40','1999-04-25 14:44:35',3.0000); INSERT INTO PreviousRental VALUES (201,1122,'1999-04-25 01:52:50','1999-04-25 01:53:58',3.0000); INSERT INTO PreviousRental VALUES (104,909187,'1999-04-25 14:24:40','1999-04-25 14:44:25',3.0000); INSERT INTO PreviousRental VALUES (102,1111,'1999-04-25 14:41:36','1999-04-25 14:42:53',5.0000); INSERT INTO PreviousRental VALUES (102,1013,'1999-04-25 14:41:36','1999-04-25 14:42:53',5.0000); INSERT INTO PreviousRental VALUES (103,1133,'1999-04-25 01:52:50','1999-04-25 01:54:00',3.0000); INSERT INTO PreviousRental VALUES (102,1110,'1999-04-25 14:40:44','1999-04-25 14:42:43',5.0000); INSERT INTO PreviousRental VALUES (444,1143,'1999-04-25 01:52:50','1999-04-25 01:54:01',3.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-25 14:41:36','1999-04-25 14:42:17',5.0000); INSERT INTO PreviousRental VALUES (103,1452,'1999-04-25 01:52:50','1999-04-25 01:54:02',3.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-04-25 14:40:44','1999-04-25 14:41:32',5.0000); INSERT INTO PreviousRental VALUES (101,1123,'1999-04-25 14:14:23','1999-04-25 14:14:28',3.0000); INSERT INTO PreviousRental VALUES (444,1121,'1999-04-25 01:58:45','1999-04-25 02:05:47',5.0000); INSERT INTO PreviousRental VALUES (444,1123,'1999-04-25 01:58:46','1999-04-25 02:05:47',5.0000); INSERT INTO PreviousRental VALUES (444,1141,'1999-04-25 01:58:45','1999-04-25 02:05:47',5.0000); INSERT INTO PreviousRental VALUES (444,1451,'1999-04-25 01:58:45','1999-04-25 02:05:47',5.0000); INSERT INTO PreviousRental VALUES (444,1453,'1999-04-25 01:58:45','1999-04-25 02:05:48',5.0000); INSERT INTO PreviousRental VALUES (101,1142,'1999-04-25 14:16:09','1999-04-25 14:38:06',3.0000); INSERT INTO PreviousRental VALUES (444,1121,'1999-04-25 11:28:54','1999-04-25 11:28:54',2.5000); INSERT INTO PreviousRental VALUES (444,1011,'1999-04-25 11:10:08','1999-04-25 11:33:37',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-25 14:09:53','1999-04-25 14:38:06',3.0000); INSERT INTO PreviousRental VALUES (101,1011,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,123,'1999-04-23 20:59:53','1999-04-28 20:59:53',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-25 14:01:17','1999-04-25 14:29:28',5.0000); INSERT INTO PreviousRental VALUES (101,1452,'1999-04-25 14:11:59','1999-04-25 14:29:28',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 14:08:48','1999-04-25 14:29:28',3.0000); INSERT INTO PreviousRental VALUES (104,775364,'1999-04-25 14:01:31','1999-04-25 14:19:36',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-25 14:03:57','1999-04-25 14:18:39',3.0000); INSERT INTO PreviousRental VALUES (101,997387,'1999-04-25 14:11:59','1999-04-25 14:18:12',3.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-25 14:02:42','1999-04-25 14:18:12',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-25 14:01:17','1999-04-25 14:18:11',5.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-04-25 14:11:59','1999-04-25 14:18:11',3.0000); INSERT INTO PreviousRental VALUES (101,1132,'1999-04-25 14:11:59','1999-04-25 14:18:11',3.0000); INSERT INTO PreviousRental VALUES (101,1122,'1999-04-25 14:16:36','1999-04-25 14:17:47',3.0000); INSERT INTO PreviousRental VALUES (444,1451,'1999-04-25 11:36:37','1999-04-25 11:36:37',2.5000); INSERT INTO PreviousRental VALUES (104,1110,'1999-04-25 11:39:54','1999-04-25 11:51:27',5.0000); INSERT INTO PreviousRental VALUES (101,1131,'1999-04-25 14:11:59','1999-04-25 14:17:47',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-25 14:11:38','1999-04-25 14:17:47',3.0000); INSERT INTO PreviousRental VALUES (106,775164,'1999-04-25 11:39:35','1999-04-25 11:51:27',5.0000); INSERT INTO PreviousRental VALUES (104,775364,'1999-04-25 11:39:54','1999-04-25 11:51:27',5.0000); INSERT INTO PreviousRental VALUES (106,909187,'1999-04-25 11:39:35','1999-04-25 11:51:28',5.0000); INSERT INTO PreviousRental VALUES (104,1013,'1999-04-25 14:01:31','1999-04-25 14:05:11',NULL); INSERT INTO PreviousRental VALUES (101,1111,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,1141,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (444,1141,'1999-04-25 02:08:11','1999-04-25 12:32:13',NULL); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-25 14:01:18','1999-04-25 14:02:30',NULL); INSERT INTO PreviousRental VALUES (106,1451,'1999-04-25 14:00:18','1999-04-25 14:01:12',5.0000); INSERT INTO PreviousRental VALUES (104,997387,'1999-04-25 13:56:22','1999-04-25 13:57:29',NULL); INSERT INTO PreviousRental VALUES (104,1143,'1999-04-25 13:56:20','1999-04-25 13:57:29',NULL); INSERT INTO PreviousRental VALUES (104,1142,'1999-04-25 13:56:20','1999-04-25 13:57:29',NULL); INSERT INTO PreviousRental VALUES (104,1141,'1999-04-25 13:56:20','1999-04-25 13:57:29',NULL); INSERT INTO PreviousRental VALUES (444,1123,'1999-04-25 02:08:11','1999-04-25 12:39:23',NULL); INSERT INTO PreviousRental VALUES (444,1453,'1999-04-25 02:08:11','1999-04-25 12:39:23',NULL); INSERT INTO PreviousRental VALUES (106,1452,'1999-04-25 14:00:18','1999-04-25 14:00:45',5.0000); INSERT INTO PreviousRental VALUES (106,1232,'1999-04-25 12:41:19','1999-04-25 12:42:38',NULL); INSERT INTO PreviousRental VALUES (103,1121,'1999-04-25 12:41:38','1999-04-25 12:43:46',NULL); INSERT INTO PreviousRental VALUES (103,1141,'1999-04-25 12:41:37','1999-04-25 12:43:46',NULL); INSERT INTO PreviousRental VALUES (104,1011,'1999-04-25 12:40:43','1999-04-25 12:51:12',5.0000); INSERT INTO PreviousRental VALUES (104,1453,'1999-04-25 13:56:20','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (444,1111,'1999-04-25 12:40:57','1999-04-25 12:51:12',5.0000); INSERT INTO PreviousRental VALUES (104,1133,'1999-04-25 13:56:21','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (102,1113,'1999-04-25 12:41:10','1999-04-25 12:51:12',5.0000); INSERT INTO PreviousRental VALUES (104,775164,'1999-04-25 12:40:43','1999-04-25 12:51:12',5.0000); INSERT INTO PreviousRental VALUES (104,997287,'1999-04-25 13:56:21','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (104,1452,'1999-04-25 13:56:20','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (102,909187,'1999-04-25 12:41:10','1999-04-25 12:51:13',5.0000); INSERT INTO PreviousRental VALUES (444,909287,'1999-04-25 12:40:57','1999-04-25 12:51:13',5.0000); INSERT INTO PreviousRental VALUES (104,1132,'1999-04-25 13:56:21','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (201,1122,'1999-04-25 12:42:02','1999-04-25 12:54:06',NULL); INSERT INTO PreviousRental VALUES (104,1142,'1999-04-25 12:41:49','1999-04-25 12:55:12',NULL); INSERT INTO PreviousRental VALUES (111,1121,'1999-04-25 12:55:57','1999-04-25 12:56:50',NULL); INSERT INTO PreviousRental VALUES (104,997187,'1999-04-25 13:56:21','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (104,1451,'1999-04-25 13:56:20','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (104,1131,'1999-04-25 13:56:20','1999-04-25 13:57:11',5.0000); INSERT INTO PreviousRental VALUES (104,997387,'0000-00-00 00:00:00','1999-04-25 13:59:00',NULL); INSERT INTO PreviousRental VALUES (106,1453,'1999-04-25 14:00:18','1999-04-25 14:00:45',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-25 13:53:39','1999-04-30 13:53:39',5.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-25 13:49:42','1999-04-25 13:58:45',NULL); INSERT INTO PreviousRental VALUES (201,1452,'1999-04-25 12:42:02','1999-04-25 13:55:34',NULL); INSERT INTO PreviousRental VALUES (104,775364,'1999-04-25 13:39:36','1999-04-25 13:46:27',5.0000); INSERT INTO PreviousRental VALUES (111,1453,'1999-04-25 12:42:11','1999-04-25 13:55:34',NULL); INSERT INTO PreviousRental VALUES (111,1131,'1999-04-25 12:55:57','1999-04-25 13:55:34',NULL); INSERT INTO PreviousRental VALUES (111,1123,'1999-04-25 12:42:11','1999-04-25 13:55:34',NULL); INSERT INTO PreviousRental VALUES (201,997387,'1999-04-25 12:42:02','1999-04-25 13:54:03',NULL); INSERT INTO PreviousRental VALUES (104,997287,'1999-04-25 12:41:50','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (104,1011,'1999-04-25 13:39:36','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (104,1231,'1999-04-25 13:39:37','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (104,1451,'1999-04-25 13:39:49','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (103,997187,'1999-04-25 13:40:01','1999-04-25 13:41:34',5.0000); INSERT INTO PreviousRental VALUES (103,997187,'1999-04-25 12:41:38','1999-04-25 13:37:31',5.0000); INSERT INTO PreviousRental VALUES (104,1122,'1999-04-25 12:56:09','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (104,1142,'1999-04-25 12:56:09','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (103,1451,'1999-04-25 12:41:37','1999-04-30 12:41:37',5.0000); INSERT INTO PreviousRental VALUES (104,1132,'1999-04-25 13:39:49','1999-04-25 13:44:08',5.0000); INSERT INTO PreviousRental VALUES (201,1143,'1999-04-25 12:42:02','1999-04-25 13:54:46',NULL); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-27 12:56:22','1999-04-28 00:50:29',1.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-27 12:54:26','1999-04-28 00:50:29',1.0000); INSERT INTO PreviousRental VALUES (444,1112,'1999-04-27 16:39:12','1999-04-28 00:50:29',2.9900); INSERT INTO PreviousRental VALUES (106,1113,'1999-04-27 14:24:07','1999-04-28 00:50:29',2.9900); INSERT INTO PreviousRental VALUES (103,1231,'1999-04-27 12:56:09','1999-04-28 00:50:29',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-28 00:49:53','1999-04-28 00:50:29',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-27 12:56:22','1999-04-28 00:50:30',1.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-27 12:59:52','1999-04-28 00:50:30',1.0000); INSERT INTO PreviousRental VALUES (104,775364,'1999-04-27 13:46:14','1999-04-28 00:50:30',2.9900); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-27 12:54:26','1999-04-28 00:50:31',1.0000); INSERT INTO PreviousRental VALUES (103,909287,'1999-04-27 12:56:09','1999-04-28 00:50:31',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-27 12:56:22','1999-04-28 00:50:31',1.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 00:57:18','1999-04-28 00:57:36',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 00:50:42','1999-04-28 00:57:37',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-28 00:50:42','1999-04-28 00:57:37',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 00:50:42','1999-04-28 00:57:37',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 00:50:42','1999-04-28 00:57:37',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 00:57:18','1999-04-28 00:57:37',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 00:57:50','1999-04-28 01:05:53',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 00:57:50','1999-04-28 01:05:53',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 00:57:57','1999-04-28 01:05:53',2.9900); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 01:12:24','1999-04-28 01:12:45',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-28 01:12:28','1999-04-28 01:12:45',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 01:06:06','1999-04-28 01:12:45',2.9900); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-28 01:06:06','1999-04-28 01:12:45',2.9900); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-28 01:12:28','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-28 01:12:24','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-28 01:12:31','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 01:06:06','1999-04-28 01:12:46',2.9900); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 01:12:24','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-28 01:12:28','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 01:06:05','1999-04-28 01:12:46',2.9900); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 01:12:24','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-28 01:12:28','1999-04-28 01:12:46',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 01:33:18','1999-04-28 01:33:31',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 01:19:39','1999-04-28 01:33:31',2.9900); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-28 01:19:39','1999-04-28 01:33:31',2.9900); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-28 01:33:18','1999-04-28 01:33:31',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 01:19:39','1999-04-28 01:33:31',2.9900); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 01:22:02','1999-04-28 01:33:31',2.9900); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-28 01:33:18','1999-04-28 01:33:31',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 01:19:39','1999-04-28 01:33:32',2.9900); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 01:33:18','1999-04-28 01:33:32',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 01:33:38','1999-04-28 02:20:53',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 02:04:59','1999-04-28 02:20:53',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 02:04:59','1999-04-28 02:21:12',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 01:46:38','1999-04-28 02:21:12',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-28 01:50:22','1999-04-28 02:21:12',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 01:50:22','1999-04-28 02:21:12',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-28 02:30:28','1999-04-28 02:33:24',2.9900); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-28 02:30:28','1999-04-28 02:33:24',2.9900); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 03:13:05','1999-04-28 03:19:46',3.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-28 03:23:01','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 03:23:02','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-28 03:23:02','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-28 03:23:02','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 03:23:01','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 03:23:01','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-28 03:37:03','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 03:23:01','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 03:23:01','1999-04-28 04:01:02',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-28 03:23:01','1999-04-28 04:01:03',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 03:23:01','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,909387,'1999-04-28 04:19:46','1999-04-28 05:01:41',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 05:25:14','1999-04-28 05:40:20',NULL); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-28 03:23:02','1999-04-28 05:40:20',NULL); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-28 04:39:09','1999-04-28 05:40:36',NULL); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 04:19:39','1999-04-28 05:40:48',NULL); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-28 04:19:43','1999-04-28 05:41:00',NULL); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 04:01:10','1999-04-28 05:51:45',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-28 03:23:02','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-28 03:23:02','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-04-28 06:35:16','1999-04-29 02:01:39',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-28 06:35:20','1999-04-29 15:21:54',5.0000); INSERT INTO PreviousRental VALUES (201,1233,'1999-04-29 04:14:32','1999-04-29 15:21:54',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-28 04:19:43','1999-04-29 15:21:54',5.0000); INSERT INTO PreviousRental VALUES (104,1451,'1999-04-26 00:42:22','1999-04-29 15:22:22',5.0000); INSERT INTO PreviousRental VALUES (104,997287,'1999-04-26 00:43:16','1999-04-29 15:22:22',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-28 04:01:10','1999-04-29 15:29:53',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-30 08:30:39','1999-04-30 11:06:51',5.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-28 06:35:23','1999-04-30 11:06:51',5.0000); INSERT INTO PreviousRental VALUES (201,1011,'1999-04-29 04:14:32','1999-04-30 11:24:43',NULL); INSERT INTO PreviousRental VALUES (101,997287,'1999-04-29 15:28:08','1999-04-30 15:50:54',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-04-28 06:35:20','1999-04-30 15:51:30',NULL); INSERT INTO PreviousRental VALUES (101,1232,'1999-04-30 11:09:01','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-05-01 22:15:14','1999-05-03 16:53:47',NULL); INSERT INTO PreviousRental VALUES (101,1232,'1999-05-03 11:09:55','1999-05-08 11:09:55',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-05-03 11:09:55','1999-05-06 19:35:21',NULL); INSERT INTO PreviousRental VALUES (101,1110,'1999-04-30 14:59:08','1999-05-07 15:42:31',NULL); INSERT INTO PreviousRental VALUES (102,1123,'1999-04-26 22:44:41','1999-05-09 17:56:54',5.0000); INSERT INTO PreviousRental VALUES (102,1132,'1999-04-26 20:20:28','1999-05-09 17:56:55',5.0000); INSERT INTO PreviousRental VALUES (103,1141,'1999-04-26 18:24:20','1999-05-09 17:56:55',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-04-28 06:35:16','1999-05-09 18:01:36',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-04-30 11:08:19','1999-05-09 18:01:36',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-04-28 04:19:39','1999-05-09 18:01:36',5.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-04-30 11:08:19','1999-05-10 07:58:41',NULL); INSERT INTO PreviousRental VALUES (101,775364,'1999-04-30 11:08:19','1999-05-13 16:56:11',NULL); INSERT INTO PreviousRental VALUES (101,909187,'1999-05-11 17:15:00','1999-05-16 17:15:00',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-04-28 06:37:07','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-04-28 06:37:11','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-05-17 15:59:20','1999-05-22 15:59:20',5.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-05-10 15:02:14','1999-05-15 15:02:14',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-05-13 17:49:47','1999-05-18 17:49:47',5.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-05-17 15:59:35','1999-05-22 15:59:35',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-05-10 15:02:14','1999-05-15 15:02:14',5.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-04-28 03:23:02','0000-00-00 00:00:00',5.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-05-13 17:50:07','1999-05-18 17:50:07',5.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-04-28 04:51:13','0000-00-00 00:00:00',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-04-30 11:08:19','0000-00-00 00:00:00',3.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-06-16 12:50:58','1999-06-16 18:15:07',3.0000); INSERT INTO PreviousRental VALUES (103,775164,'1999-05-20 14:02:50','1999-06-16 18:15:07',2.9900); INSERT INTO PreviousRental VALUES (101,775364,'1999-06-03 09:15:06','1999-06-19 22:07:45',3.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-05-21 10:06:04','1999-06-19 22:07:45',5.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-05-21 10:06:04','1999-06-21 11:35:16',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-06-03 09:15:06','1999-06-21 11:36:01',3.0000); INSERT INTO PreviousRental VALUES (101,1141,'1999-06-21 11:40:13','1999-06-24 09:22:41',3.0000); INSERT INTO PreviousRental VALUES (101,1453,'1999-04-26 17:37:10','1999-06-24 09:22:41',3.0000); INSERT INTO PreviousRental VALUES (102,1011,'1999-06-21 11:40:13','1999-06-24 21:07:06',3.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-06-21 11:37:18','1999-06-24 21:07:06',5.0000); INSERT INTO PreviousRental VALUES (101,775164,'1999-06-21 11:40:13','1999-06-24 21:07:06',3.0000); INSERT INTO PreviousRental VALUES (101,1112,'1999-06-21 11:40:13','1999-06-28 16:56:47',3.0000); INSERT INTO PreviousRental VALUES (101,1231,'1999-06-06 00:54:35','1999-06-28 16:56:47',3.0000); INSERT INTO PreviousRental VALUES (101,1233,'1999-05-22 23:27:56','1999-06-28 16:56:47',5.0000); INSERT INTO PreviousRental VALUES (101,1011,'1999-07-14 11:52:37','1999-08-06 12:02:00',3.0000); INSERT INTO PreviousRental VALUES (101,1013,'1999-06-03 09:15:06','1999-08-06 12:02:00',3.0000); INSERT INTO PreviousRental VALUES (101,1110,'1999-05-21 14:13:51','1999-08-06 12:02:00',5.0000); INSERT INTO PreviousRental VALUES (101,1111,'1999-07-20 19:43:34','1999-08-06 12:02:01',5.0000); INSERT INTO PreviousRental VALUES (103,1112,'1999-07-10 21:57:47','1999-08-06 12:02:01',3.0000); INSERT INTO PreviousRental VALUES (101,1113,'1999-06-21 11:40:13','1999-08-06 12:02:01',3.0000); INSERT INTO PreviousRental VALUES (103,1231,'1999-07-10 21:57:47','1999-08-06 12:02:01',3.0000); INSERT INTO PreviousRental VALUES (101,1232,'1999-06-21 11:40:13','1999-08-06 12:02:02',3.0000); INSERT INTO PreviousRental VALUES (103,1233,'1999-07-10 22:00:07','1999-08-06 12:02:02',3.0000); INSERT INTO PreviousRental VALUES (103,775164,'1999-07-10 21:57:47','1999-08-06 12:02:02',3.0000); INSERT INTO PreviousRental VALUES (101,775264,'1999-05-21 16:49:39','1999-08-06 12:02:02',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-06-21 11:40:13','1999-08-06 12:02:02',3.0000); INSERT INTO PreviousRental VALUES (101,909187,'1999-06-21 11:40:13','1999-08-06 12:02:02',3.0000); INSERT INTO PreviousRental VALUES (101,909287,'1999-06-21 11:40:13','1999-08-06 12:02:03',3.0000); INSERT INTO PreviousRental VALUES (888,909387,'1999-04-30 11:08:19','1999-08-06 12:02:03',3.0000); INSERT INTO PreviousRental VALUES (201,1011,'1999-08-06 12:02:29','1999-08-07 21:16:11',3.5000); INSERT INTO PreviousRental VALUES (201,1113,'1999-08-06 12:02:29','1999-08-07 21:16:11',3.5000); INSERT INTO PreviousRental VALUES (201,909387,'1999-08-06 12:02:29','1999-08-07 21:16:11',3.5000); INSERT INTO PreviousRental VALUES (101,1110,'1999-08-08 13:57:01','1999-08-09 16:55:38',5.0000); INSERT INTO PreviousRental VALUES (101,775364,'1999-08-08 13:57:01','1999-08-11 11:13:33',NULL); INSERT INTO PreviousRental VALUES (101,1111,'1999-08-08 13:57:01','1999-11-01 19:13:06',NULL); INSERT INTO PreviousRental VALUES (101,775164,'1999-09-17 14:20:57','1999-11-13 21:00:42',NULL); INSERT INTO PreviousRental VALUES (101,909387,'1999-08-08 13:57:01','1999-12-08 14:44:46',NULL); INSERT INTO PreviousRental VALUES (101,1453,'1999-07-20 19:52:08','1999-12-17 21:43:37',NULL); INSERT INTO PreviousRental VALUES (101,1451,'1999-04-30 11:09:45','2000-01-20 18:23:22',NULL); INSERT INTO PreviousRental VALUES (104,1452,'1999-04-26 00:43:16','2000-01-20 18:23:22',NULL); INSERT INTO PreviousRental VALUES (101,1133,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (102,1110,'2000-01-31 13:29:19','2000-02-04 21:38:46',NULL); INSERT INTO PreviousRental VALUES (102,909187,'2000-01-31 13:29:19','2000-02-04 21:38:46',NULL); INSERT INTO PreviousRental VALUES (101,1132,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (101,1142,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL); INSERT INTO PreviousRental VALUES (102,1111,'2000-01-31 13:29:19','2000-03-23 00:49:07',NULL); INSERT INTO PreviousRental VALUES (102,1121,'1999-04-26 13:42:16','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (106,1122,'1999-04-26 17:40:57','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (101,1123,'1999-07-26 12:16:30','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (201,1131,'1999-04-26 20:55:05','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (106,1132,'1999-06-21 11:40:13','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (102,1142,'1999-04-26 20:20:28','2000-03-30 00:42:47',NULL); INSERT INTO PreviousRental VALUES (102,775164,'2000-01-31 13:29:19','2000-04-23 09:00:18',NULL); INSERT INTO PreviousRental VALUES (102,997187,'1999-04-26 13:42:16','2000-07-03 12:35:11',NULL); INSERT INTO PreviousRental VALUES (102,1143,'1999-04-26 22:44:41','2000-07-06 23:25:26',NULL); INSERT INTO PreviousRental VALUES (103,997387,'1999-04-26 18:23:19','2000-07-06 23:25:26',NULL); INSERT INTO PreviousRental VALUES (104,997287,'1999-06-21 11:40:13','2000-07-06 23:30:43',NULL); INSERT INTO PreviousRental VALUES (101,1011,'2000-09-01 06:28:36','2000-09-20 22:34:43',NULL); INSERT INTO PreviousRental VALUES (101,1013,'2000-09-01 06:28:36','2000-09-23 05:27:36',NULL); INSERT INTO PreviousRental VALUES (101,1232,'2000-09-01 06:28:36','2000-10-08 18:02:48',NULL); # # Table structure for table 'PurchaseOrder' # CREATE TABLE PurchaseOrder ( purchaseOrderId int(11) DEFAULT '0' NOT NULL, date date, total double(16,4), supplierId char(10), PRIMARY KEY (purchaseOrderId) ); # # Dumping data for table 'PurchaseOrder' # INSERT INTO PurchaseOrder VALUES (99001,'1999-01-15',100.0000,'101101'); # # Table structure for table 'PurchaseOrderDetail' # CREATE TABLE PurchaseOrderDetail ( purchaseOrderId int(11) DEFAULT '0' NOT NULL, movieId int(11) DEFAULT '0' NOT NULL, quantity int(11), price double(16,4), PRIMARY KEY (purchaseOrderId,movieId) ); # # Dumping data for table 'PurchaseOrderDetail' # INSERT INTO PurchaseOrderDetail VALUES (99001,450,3,25.0000); INSERT INTO PurchaseOrderDetail VALUES (99001,987,1,25.0000); # # Table structure for table 'Rental' # CREATE TABLE Rental ( accountId int(11) DEFAULT '0' NOT NULL, videoId int(11) DEFAULT '0' NOT NULL, dateRented datetime, dateDue datetime, cost double(16,4), PRIMARY KEY (accountId,videoId) ); # # Dumping data for table 'Rental' # INSERT INTO Rental VALUES (102,189,'1999-04-26 20:51:38','1999-04-31 20:51:38',5.0000); INSERT INTO Rental VALUES (101,189,'1999-04-26 20:49:57','1999-04-31 20:49:57',5.0000); INSERT INTO Rental VALUES (0,189,'1999-04-25 16:11:03','1999-04-30 16:11:03',5.0000); INSERT INTO Rental VALUES (103,189,'1999-04-25 19:21:46','1999-04-30 19:21:46',5.0000); INSERT INTO Rental VALUES (103,123,'1999-04-26 12:54:20','1999-04-31 12:54:20',5.0000); INSERT INTO Rental VALUES (101,450,'1999-04-26 14:29:54','1999-04-31 14:29:54',5.0000); INSERT INTO Rental VALUES (111,123,'1999-04-26 12:55:57','1999-04-31 12:55:57',5.0000); INSERT INTO Rental VALUES (101,101,'1999-04-26 14:38:12','1999-04-31 14:38:12',5.0000); INSERT INTO Rental VALUES (0,123,'1999-04-25 16:02:26','1999-04-30 16:02:26',5.0000); INSERT INTO Rental VALUES (103,987,'1999-04-26 12:54:20','1999-04-31 12:54:20',5.0000); INSERT INTO Rental VALUES (0,987,'1999-04-25 16:11:03','1999-04-30 16:11:03',5.0000); INSERT INTO Rental VALUES (106,987,'1999-04-25 18:59:41','1999-04-30 18:59:41',5.0000); INSERT INTO Rental VALUES (102,450,'1999-04-25 19:53:18','1999-04-30 19:53:18',5.0000); INSERT INTO Rental VALUES (0,145,'1999-04-25 16:11:03','1999-04-30 16:11:03',5.0000); INSERT INTO Rental VALUES (106,450,'1999-04-25 19:03:27','1999-04-30 19:03:27',5.0000); INSERT INTO Rental VALUES (102,123,'1999-04-26 20:52:01','1999-04-31 20:52:01',5.0000); INSERT INTO Rental VALUES (106,189,'1999-04-26 12:55:28','1999-04-31 12:55:28',5.0000); INSERT INTO Rental VALUES (0,450,'1999-04-25 16:18:09','1999-04-30 16:18:09',5.0000); INSERT INTO Rental VALUES (104,123,'1999-04-25 19:09:28','1999-04-30 19:09:28',5.0000); INSERT INTO Rental VALUES (101,123,'1999-04-28 00:08:13','0000-00-00 00:00:00',5.0000); # # Table structure for table 'Reservation' # CREATE TABLE Reservation ( accountId int(11), videoId int(11), dateReserved date ); # # Dumping data for table 'Reservation' # INSERT INTO Reservation VALUES (101,775264,'1999-10-09'); INSERT INTO Reservation VALUES (101,1110,'1999-08-07'); INSERT INTO Reservation VALUES (101,1231,'1999-09-27'); INSERT INTO Reservation VALUES (101,909187,'1999-09-08'); INSERT INTO Reservation VALUES (101,1110,'1999-09-27'); INSERT INTO Reservation VALUES (101,1110,'1999-10-09'); INSERT INTO Reservation VALUES (201,909187,'1999-12-08'); INSERT INTO Reservation VALUES (201,775164,'1999-12-08'); INSERT INTO Reservation VALUES (201,1110,'1999-12-08'); INSERT INTO Reservation VALUES (201,1111,'1999-12-08'); INSERT INTO Reservation VALUES (111,1110,'2000-01-28'); INSERT INTO Reservation VALUES (111,1111,'2000-01-28'); INSERT INTO Reservation VALUES (101,909287,'2000-02-01'); INSERT INTO Reservation VALUES (101,909287,'2000-02-01'); INSERT INTO Reservation VALUES (101,775264,'2000-02-01'); INSERT INTO Reservation VALUES (101,1451,'2000-02-01'); INSERT INTO Reservation VALUES (101,1110,'2000-02-19'); INSERT INTO Reservation VALUES (101,775264,'2000-02-26'); INSERT INTO Reservation VALUES (101,909187,'2000-03-23'); INSERT INTO Reservation VALUES (101,775264,'2000-03-23'); INSERT INTO Reservation VALUES (102,775264,'2000-04-06'); INSERT INTO Reservation VALUES (101,1110,'2000-04-06'); INSERT INTO Reservation VALUES (102,909187,'2000-04-07'); INSERT INTO Reservation VALUES (102,1110,'2000-04-07'); INSERT INTO Reservation VALUES (102,1111,'2000-04-07'); INSERT INTO Reservation VALUES (101,909187,'2000-04-07'); INSERT INTO Reservation VALUES (101,909187,'2000-04-07'); INSERT INTO Reservation VALUES (101,775264,'2000-04-07'); INSERT INTO Reservation VALUES (102,775264,'2000-04-07'); INSERT INTO Reservation VALUES (102,1110,'2000-04-07'); INSERT INTO Reservation VALUES (101,909187,'2000-04-08'); INSERT INTO Reservation VALUES (101,775264,'2000-04-08'); INSERT INTO Reservation VALUES (101,775264,'2000-04-08'); INSERT INTO Reservation VALUES (101,909187,'2000-04-08'); INSERT INTO Reservation VALUES (101,775264,'2000-04-08'); INSERT INTO Reservation VALUES (101,909187,'2000-04-08'); INSERT INTO Reservation VALUES (101,1141,'2000-04-08'); INSERT INTO Reservation VALUES (101,1451,'2000-04-08'); INSERT INTO Reservation VALUES (101,1121,'2000-04-08'); INSERT INTO Reservation VALUES (101,775264,'2000-04-08'); INSERT INTO Reservation VALUES (102,909187,'2000-04-08'); INSERT INTO Reservation VALUES (102,775264,'2000-04-08'); INSERT INTO Reservation VALUES (101,909187,'2000-04-09'); INSERT INTO Reservation VALUES (101,775264,'2000-04-09'); INSERT INTO Reservation VALUES (101,909187,'2000-04-10'); INSERT INTO Reservation VALUES (101,909187,'2000-04-10'); INSERT INTO Reservation VALUES (101,775264,'2000-04-10'); INSERT INTO Reservation VALUES (101,1110,'2000-04-10'); INSERT INTO Reservation VALUES (101,1111,'2000-04-10'); INSERT INTO Reservation VALUES (101,909187,'2000-04-10'); INSERT INTO Reservation VALUES (103,1110,'2000-04-10'); INSERT INTO Reservation VALUES (103,1111,'2000-04-10'); INSERT INTO Reservation VALUES (103,1110,'2000-04-10'); INSERT INTO Reservation VALUES (103,1111,'2000-04-10'); INSERT INTO Reservation VALUES (101,775264,'2000-04-11'); INSERT INTO Reservation VALUES (101,1111,'2000-04-11'); INSERT INTO Reservation VALUES (101,1110,'2000-04-11'); INSERT INTO Reservation VALUES (101,909187,'2000-04-11'); INSERT INTO Reservation VALUES (101,775264,'2000-04-12'); INSERT INTO Reservation VALUES (101,1110,'2000-04-12'); INSERT INTO Reservation VALUES (101,1111,'2000-04-12'); INSERT INTO Reservation VALUES (101,1110,'2000-04-12'); INSERT INTO Reservation VALUES (101,1141,'2000-04-19'); INSERT INTO Reservation VALUES (101,775264,'2000-04-21'); INSERT INTO Reservation VALUES (101,1110,'2000-04-21'); INSERT INTO Reservation VALUES (101,775164,'2000-04-24'); INSERT INTO Reservation VALUES (101,775164,'2000-05-30'); INSERT INTO Reservation VALUES (102,909187,'2000-07-20'); INSERT INTO Reservation VALUES (102,775164,'2000-07-20'); INSERT INTO Reservation VALUES (101,909187,'2000-07-26'); INSERT INTO Reservation VALUES (101,775164,'2000-07-26'); INSERT INTO Reservation VALUES (102,775164,'2000-08-22'); INSERT INTO Reservation VALUES (102,1110,'2000-08-22'); INSERT INTO Reservation VALUES (103,1141,'2000-08-22'); INSERT INTO Reservation VALUES (103,1451,'2000-08-22'); INSERT INTO Reservation VALUES (101,775164,'2000-08-31'); INSERT INTO Reservation VALUES (101,1111,'2000-08-31'); INSERT INTO Reservation VALUES (101,1110,'2000-09-05'); INSERT INTO Reservation VALUES (101,1111,'2000-09-05'); INSERT INTO Reservation VALUES (101,909187,'2000-09-06'); INSERT INTO Reservation VALUES (101,775164,'2000-09-06'); INSERT INTO Reservation VALUES (101,909187,'2000-09-12'); INSERT INTO Reservation VALUES (101,775164,'2000-09-12'); INSERT INTO Reservation VALUES (101,1110,'2000-09-12'); INSERT INTO Reservation VALUES (101,1111,'2000-09-12'); INSERT INTO Reservation VALUES (104,909187,'2000-09-15'); INSERT INTO Reservation VALUES (104,1110,'2000-09-15'); INSERT INTO Reservation VALUES (101,909187,'2000-09-18'); INSERT INTO Reservation VALUES (101,1110,'2000-09-18'); INSERT INTO Reservation VALUES (101,1110,'2000-09-21'); INSERT INTO Reservation VALUES (101,909187,'2000-09-21'); INSERT INTO Reservation VALUES (101,909187,'2000-10-04'); INSERT INTO Reservation VALUES (102,909187,'2000-10-12'); INSERT INTO Reservation VALUES (102,775164,'2000-10-12'); # # Table structure for table 'SalariedEmployee' # CREATE TABLE SalariedEmployee ( ssn char(9) DEFAULT '' NOT NULL, weeklyPayRate double(16,4), vacationLeaveHours int(11), sickLeaveHours int(11), PRIMARY KEY (ssn) ); # # Dumping data for table 'SalariedEmployee' # INSERT INTO SalariedEmployee VALUES ('145-09-09',0.0000,0,0); # # Table structure for table 'Store' # CREATE TABLE Store ( storeId int(11) DEFAULT '0' NOT NULL, street varchar(100), city varchar(32), state char(2), zipcode varchar(9), manager varchar(9), PRIMARY KEY (storeId) ); # # Dumping data for table 'Store' # INSERT INTO Store VALUES (3,'2010 Liberty Rd.','Apopka','FL','34505','145-09-09'); INSERT INTO Store VALUES (5,'1004 N. Monroe St.','Apopka','FL','34506','588-99-00'); # # Table structure for table 'Supplier' # CREATE TABLE Supplier ( supplierId varchar(10) DEFAULT '' NOT NULL, name varchar(32), street varchar(100), city varchar(32), state char(2), zipcode varchar(9), PRIMARY KEY (supplierId) ); # # Dumping data for table 'Supplier' # INSERT INTO Supplier VALUES ('101101','Acme Video','101 Main','Smithfield','LA','54545'); # # Table structure for table 'TimeCard' # CREATE TABLE TimeCard ( ssn char(9) DEFAULT '' NOT NULL, dateWork date DEFAULT '0000-00-00' NOT NULL, startTime time DEFAULT '00:00:00' NOT NULL, endTime time, storeId int(11), paid enum('yes','no') DEFAULT 'yes', PRIMARY KEY (ssn,dateWork,startTime) ); # # Dumping data for table 'TimeCard' # INSERT INTO TimeCard VALUES ('145-09-09','1999-01-14','08:15:00','12:00:00',3,'yes'); INSERT INTO TimeCard VALUES ('145-09-09','1999-01-16','08:15:00','12:00:00',3,'yes'); INSERT INTO TimeCard VALUES ('245-11-45','1999-01-14','08:15:00','12:00:00',3,'yes'); INSERT INTO TimeCard VALUES ('376-77-00','1999-01-13','10:00:00','02:00:00',5,'yes'); INSERT INTO TimeCard VALUES ('376-77-00','1999-02-23','02:00:00','10:00:00',5,'yes'); INSERT INTO TimeCard VALUES ('376-77-00','1999-02-23','03:00:00','07:00:00',5,'yes'); # # Table structure for table 'Videotape' # CREATE TABLE Videotape ( videoId int(11) DEFAULT '0' NOT NULL, dateAcquired date, movieId int(11), storeId int(11), PRIMARY KEY (videoId) ); # # Dumping data for table 'Videotape' # INSERT INTO Videotape VALUES (1110,'1998-01-25',101,3); INSERT INTO Videotape VALUES (1111,'1997-02-05',123,3); INSERT INTO Videotape VALUES (1121,'1995-12-31',123,5); INSERT INTO Videotape VALUES (1131,'1998-04-05',123,5); INSERT INTO Videotape VALUES (1141,'1998-04-05',189,5); INSERT INTO Videotape VALUES (1231,'1986-03-25',123,3); INSERT INTO Videotape VALUES (1451,'1995-05-12',145,5); INSERT INTO Videotape VALUES (775164,'1991-04-29',189,3); INSERT INTO Videotape VALUES (909187,'1999-03-25',450,3); INSERT INTO Videotape VALUES (997187,'1997-10-10',987,5); INSERT INTO Videotape VALUES (1011,'1998-01-25',101,3); INSERT INTO Videotape VALUES (1112,'1997-02-05',123,3); INSERT INTO Videotape VALUES (1122,'1995-12-31',123,5); INSERT INTO Videotape VALUES (1132,'1998-04-05',123,5); INSERT INTO Videotape VALUES (1142,'1998-04-05',189,5); INSERT INTO Videotape VALUES (1232,'1986-03-25',123,3); INSERT INTO Videotape VALUES (1452,'1995-05-12',145,5); INSERT INTO Videotape VALUES (775264,'1991-04-29',189,3); INSERT INTO Videotape VALUES (909287,'1999-03-25',450,3); INSERT INTO Videotape VALUES (997287,'1997-10-10',987,5); INSERT INTO Videotape VALUES (1013,'1998-01-25',101,3); INSERT INTO Videotape VALUES (1113,'1997-02-05',123,3); INSERT INTO Videotape VALUES (1123,'1995-12-31',123,5); INSERT INTO Videotape VALUES (1133,'1998-04-05',123,5); INSERT INTO Videotape VALUES (1143,'1998-04-05',189,5); INSERT INTO Videotape VALUES (1233,'1986-03-25',123,3); INSERT INTO Videotape VALUES (1453,'1995-05-12',145,5); INSERT INTO Videotape VALUES (775364,'1991-04-29',189,3); INSERT INTO Videotape VALUES (909387,'1999-03-25',450,3); INSERT INTO Videotape VALUES (997387,'1997-10-10',987,5); # # Table structure for table 'WorksAt' # CREATE TABLE WorksAt ( ssn char(9) DEFAULT '' NOT NULL, storeId int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ssn,storeId) ); # # Dumping data for table 'WorksAt' # INSERT INTO WorksAt VALUES ('145-09-09',3); INSERT INTO WorksAt VALUES ('145-09-09',5); INSERT INTO WorksAt VALUES ('245-11-45',3); INSERT INTO WorksAt VALUES ('245-11-45',5); INSERT INTO WorksAt VALUES ('376-77-00',5);