

INSERT INTO `customer` (`CITY`,`CUSTOMER_ID`,`FIRST_NAME`,`LAST_NAME`,`MEMBER_SINCE`,`PHONE`,`STATE`,`STREET_ADDRESS`,`ZIP`)
VALUES
	('San Francisco',1,'William','Anthony','1996-01-25 05:55:00','4155552525','CA','200 Arroyo Drive','94567'),
	('Menlo Park',2,'Joanne','Boyles','1996-01-25 06:00:00','4155553636','CA','29 Timber Creek Drive','93211'),
	('San Francisco',4,'Jerry','Drummber','1996-01-25 06:04:00','4155558989','CA','59 Fowler St.','96857'),
	('San Bruno',5,'Mark','Capra','1996-01-25 06:02:00','4155558787','CA','2777 North Capitol #26','98564'),
	('San Bruno',6,'Maria','Eyler','1996-01-25 06:06:00','4155557171','CA','150 Saratoga St.','99874'),
	('San Francisco',7,'Freddy','Filmore','1996-01-25 06:07:00','4155552426','CA','9 Geary St.','96321'),
	('Woodside',8,'Jamie','Grace','1996-01-25 06:09:00','4155556687','CA','555 Custer Ave.','97485'),
	('San Mateo',9,'Craig','Hartnell','1996-01-25 06:11:00','4155559817','CA','67 Lazy River Way','91586'),
	('Hillsborough',10,'Richard','Ingle','1996-01-25 06:12:00','4155557428','CA','56 Sedgewood','96487'),
	('San Francisco',11,'Julia','Jeffers','1996-01-25 06:14:00','4155558875','CA','260 Forbes Lane','98612'),
	('San Mateo',13,'Franklin','Lewis','1996-01-25 06:17:00','4155556644','CA','44 Desertwood Circle','97578'),
	('Palo Alto',14,'Lisa','Mathews','1996-01-25 06:18:00','4155554849','CA','1 Main Street','94848'),
	('San Francisco',15,'Elliot','Nunez','1996-01-25 06:20:00','4155552581','CA','100 Union St.','98787'),
	('Woodside',16,'Paul','Peters','1996-01-25 06:22:00','4155554789','CA','685 Almaden Road','98758'),
	('Menlo Park',17,'Linda','Stark','1996-01-25 06:23:00','4155553374','CA','108 Melrose Ave','93588');

INSERT INTO `fee` (`AMOUNT`,`DATE_PAID`,`FEE_ID`,`FEE_TYPE_ID`,`RENTAL_ID`)
VALUES
	(14.9900,'1996-01-23 02:28:00',4,1,4),
	(2.9900,'1996-01-25 03:08:00',5,1,5),
	(4.9900,'1996-01-25 03:08:00',6,1,6),
	(2.9900,'1996-01-25 03:08:00',7,1,7),
	(4.9900,'1996-01-25 07:39:00',8,1,8);

INSERT INTO `feetype` (`ENABLED`,`FEE_TYPE`,`FEE_TYPE_ID`,`ORDER_BY`)
VALUES
	(1,'Rent',1,1),
	(1,'Late',2,2);

INSERT INTO `rental` (`CUSTOMER_ID`,`DATE_OUT`,`DATE_RETURNED`,`RENTAL_ID`,`UNIT_ID`)
VALUES
	(9,'1997-02-01 02:26:00',NULL,4,3),
	(2,'1997-02-15 03:07:00',NULL,5,115),
	(2,'1997-02-18 03:07:00',NULL,6,43),
	(2,'1997-02-19 03:08:00',NULL,7,110),
	(7,'1997-01-25 07:39:00',NULL,8,46);

INSERT INTO `rentalterms` (`CHECK_OUT_LENGTH`,`COST`,`DEPOSIT_AMOUNT`,`NAME`,`RENTAL_TERMS_ID`)
VALUES
	(2,3.9900,20.0000,'New release',1),
	(2,14.9900,200.0000,'16 Bits game console',10),
	(3,4.9900,50.0000,'Video games',11),
	(5,2.9900,20.0000,'Economy',13),
	(3,19.9900,0.0000,'2 Bits game console',14);

INSERT INTO `unit` (`DATE_ACQUIRED`,`NOTES`,`UNIT_ID`,`VIDEO_ID`)
VALUES
	('1996-01-05 20:00:00',NULL,3,1),
	('1996-01-05 20:00:00',NULL,5,7),
	('1996-01-05 20:00:00',NULL,6,7),
	('1996-01-05 20:00:00',NULL,7,8),
	('1996-01-05 20:00:00',NULL,26,1),
	('1996-01-05 20:00:00',NULL,28,1),
	('1996-01-05 20:00:00',NULL,29,1),
	('1996-01-05 20:00:00',NULL,43,1),
	('1996-01-05 20:00:00',NULL,46,1),
	('1995-01-06 20:00:00',NULL,47,14),
	('1990-01-06 20:00:00',NULL,48,15),
	('1992-01-06 20:00:00',NULL,49,16),
	('1991-01-06 20:00:00',NULL,50,16),
	('1994-01-06 20:00:00',NULL,51,18),
	('1982-01-06 20:00:00',NULL,52,17),
	('1995-01-06 20:00:00',NULL,53,18),
	('1982-01-06 20:00:00',NULL,54,17),
	('1991-01-06 20:00:00',NULL,55,19),
	('1991-01-06 20:00:00',NULL,56,19),
	('1991-01-06 20:00:00',NULL,57,19),
	('1981-01-06 20:00:00',NULL,58,20),
	('1981-01-06 20:00:00',NULL,59,20),
	('1981-01-06 20:00:00',NULL,60,20),
	('1981-01-06 20:00:00',NULL,61,20),
	('1989-01-06 20:00:00',NULL,62,21),
	('1979-01-06 20:00:00',NULL,63,24),
	('1996-01-09 02:47:00',NULL,81,2),
	('1996-01-09 02:47:00',NULL,82,2),
	('1996-01-09 02:47:00',NULL,83,2),
	('1996-01-11 06:48:00',NULL,88,14),
	('1996-01-11 06:53:00',NULL,90,5),
	('1996-01-11 06:53:00',NULL,91,5),
	('1996-01-11 09:32:00','needs to be replaced',92,44),
	('1996-01-11 09:25:00',NULL,93,8),
	('1996-01-11 09:29:00','slightly warped',94,43),
	('1996-01-11 09:31:00',NULL,95,9),
	('1996-01-11 09:33:00',NULL,96,41),
	('1996-01-11 09:29:00',NULL,97,43),
	('1996-01-11 09:30:00',NULL,99,40),
	('1996-01-11 09:40:00',NULL,100,48),
	('1996-01-11 09:39:00',NULL,101,54),
	('1996-01-11 09:38:00',NULL,102,49),
	('1996-01-11 09:38:00',NULL,103,49),
	('1996-01-11 09:41:00','needs to be replaced',104,50),
	('1996-01-11 09:38:00','cover is stained',105,49),
	('1996-01-11 09:39:00','needs to be cleaned',106,54),
	('1996-01-11 09:39:00',NULL,107,54),
	('1996-01-11 09:35:00',NULL,108,53),
	('1996-01-11 09:39:00',NULL,109,54),
	('1996-01-11 09:40:00',NULL,110,47),
	('1996-01-11 09:43:00',NULL,112,51),
	('1996-01-11 09:40:00','slightly damaged',113,47),
	('1996-01-11 09:38:00',NULL,114,49),
	('1996-01-11 09:43:00',NULL,115,51),
	('1996-01-11 09:37:00','needs to be cleaned',117,45),
	('1996-01-11 09:38:00',NULL,118,49),
	('1996-01-13 07:04:00','torn cover',119,55),
	('1996-01-13 07:04:00',NULL,120,55),
	('1996-01-15 21:22:00',NULL,121,24),
	('1996-01-16 03:09:00',NULL,122,64),
	('1996-01-16 03:09:00',NULL,123,64),
	('1996-01-17 21:46:00',NULL,124,24),
	('1996-01-21 00:35:00',NULL,125,24);

INSERT INTO `video` (`MOVIE_ID`,`RENTAL_TERMS_ID`,`VIDEO_ID`)
VALUES
	(121,13,1),
	(120,13,7),
	(118,13,8),
	(158,1,14),
	(128,13,15),
	(131,13,16),
	(115,13,17),
	(132,13,18),
	(142,13,19),
	(198,13,20),
	(144,13,21),
	(159,13,24),
	(102,1,32),
	(114,13,35),
	(179,13,38),
	(186,13,39),
	(190,13,40),
	(171,13,41),
	(146,13,43),
	(175,1,44),
	(188,13,45),
	(187,13,47),
	(185,13,48),
	(164,1,49),
	(162,13,50),
	(180,13,51),
	(203,13,53),
	(169,1,54),
	(135,13,55),
	(111,1,64);
