CREATE TABLE actor (
 ID_actor numeric NOT NULL ,
 firstName VARCHAR(45) NOT NULL,
 familyName VARCHAR(45) NOT NULL,
 ""last updated"" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_actor)
 );

CREATE TABLE country (
 ID_country SMALLINT NOT NULL,
 countryName VARCHAR(50) NOT NULL,
 "last updated" TIMESTAMP,
 PRIMARY KEY (ID_country)
);

CREATE TABLE city (
 ID_city int NOT NULL,
 cityName VARCHAR(50) NOT NULL,
 ID_country SMALLINT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_city),
 CONSTRAINT fk_city_country FOREIGN KEY (ID_country) REFERENCES country (ID_country) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE address (
 ID_address int NOT NULL,
 mainAddress VARCHAR(50) NOT NULL,
 secondaryAddress VARCHAR(50) DEFAULT NULL,
 cityZone VARCHAR(20) NOT NULL,
 ID_city INT NOT NULL,
 postal VARCHAR(10) DEFAULT NULL,
 "phone#" VARCHAR(20) NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_address),
 CONSTRAINT fk_address_city FOREIGN KEY (ID_city) REFERENCES city (ID_city) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE language (
 ID_language SMALLINT NOT NULL ,
 langName CHAR(20) NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_language)
);

CREATE TABLE category (
 ID_category SMALLINT NOT NULL,
 categoryName VARCHAR(25) NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_category)
);

CREATE TABLE customer (
 ID_customer INT NOT NULL,
 ID_store INT NOT NULL,
 firstName VARCHAR(45) NOT NULL,
 familyName VARCHAR(45) NOT NULL,
 mailAddress VARCHAR(50) DEFAULT NULL,
 ID_address INT NOT NULL,
 isActive CHAR(1) DEFAULT 'Y' NOT NULL,
 "created@" TIMESTAMP NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_customer),
 CONSTRAINT fk_customer_store FOREIGN KEY (ID_store) REFERENCES store (ID_store) ON DELETE NO ACTION ON UPDATE CASCADE,
 CONSTRAINT fk_customer_address FOREIGN KEY (ID_address) REFERENCES address (ID_address) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE film (
 ID_film int NOT NULL,
 filmTitle VARCHAR(255) NOT NULL,
 filmDesc BLOB SUB_TYPE TEXT DEFAULT NULL,
 yearReleased VARCHAR(4) DEFAULT NULL,
 ID_language SMALLINT NOT NULL,
 ID_orig_language SMALLINT DEFAULT NULL,
 rentalDays SMALLINT DEFAULT 3 NOT NULL,
 rateRental DECIMAL(4,2) DEFAULT 4.99 NOT NULL,
 filmLength SMALLINT DEFAULT NULL,
 costReplacement DECIMAL(5,2) DEFAULT 19.99 NOT NULL,
 filmRating VARCHAR(10) DEFAULT 'G',
 specialAttr VARCHAR(100) DEFAULT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_film),
 CONSTRAINT CHECK_special_features CHECK(specialAttr is null or
                              specialAttr like '%Trailers%' or
                              specialAttr like '%Commentaries%' or
                              specialAttr like '%Deleted Scenes%' or
                              specialAttr like '%Behind the Scenes%'),
 CONSTRAINT CHECK_special_rating CHECK(filmRating in ('G','PG','PG-13','R','NC-17')),
 CONSTRAINT fk_film_language FOREIGN KEY (ID_language) REFERENCES language (ID_language) ,
 CONSTRAINT fk_film_language_original FOREIGN KEY (ID_orig_language) REFERENCES language (ID_language)
);

CREATE TABLE film_actor (
 ID_actor INT NOT NULL,
 ID_film INT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_actor,ID_film),
 CONSTRAINT fk_film_actor_actor FOREIGN KEY (ID_actor) REFERENCES actor (ID_actor) ON DELETE NO ACTION ON UPDATE CASCADE,
 CONSTRAINT fk_film_actor_film FOREIGN KEY (ID_film) REFERENCES film (ID_film) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE film_category (
 ID_film INT NOT NULL,
 ID_category SMALLINT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_film, ID_category),
 CONSTRAINT fk_film_category_film FOREIGN KEY (ID_film) REFERENCES film (ID_film) ON DELETE NO ACTION ON UPDATE CASCADE,
 CONSTRAINT fk_film_category_category FOREIGN KEY (ID_category) REFERENCES category (ID_category) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE inventory (
 ID_inventory INT NOT NULL,
 ID_film INT NOT NULL,
 ID_store INT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_inventory),
 CONSTRAINT fk_inventory_store FOREIGN KEY (ID_store) REFERENCES store (ID_store) ON DELETE NO ACTION ON UPDATE CASCADE,
 CONSTRAINT fk_inventory_film FOREIGN KEY (ID_film) REFERENCES film (ID_film) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE staff (
 ID_staff SMALLINT NOT NULL,
 firstName VARCHAR(45) NOT NULL,
 familyName VARCHAR(45) NOT NULL,
 ID_address INT NOT NULL,
 image BLOB DEFAULT NULL,
 mailAddress VARCHAR(50) DEFAULT NULL,
 ID_store INT NOT NULL,
 isActive SMALLINT DEFAULT 1 NOT NULL,
 user VARCHAR(16) NOT NULL,
 userPass VARCHAR(40) DEFAULT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_staff),
 CONSTRAINT fk_staff_store FOREIGN KEY (ID_store) REFERENCES store (ID_store) ON DELETE NO ACTION ON UPDATE CASCADE,
 CONSTRAINT fk_staff_address FOREIGN KEY (ID_address) REFERENCES address (ID_address) ON DELETE NO ACTION ON UPDATE CASCADE
);

CREATE TABLE store (
 ID_store INT NOT NULL,
 ID_address INT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_store),
 CONSTRAINT fk_store_address FOREIGN KEY (ID_address) REFERENCES address (ID_address)
);

CREATE TABLE payment (
 ID_payment int NOT NULL,
 ID_customer INT NOT NULL,
 ID_staff SMALLINT NOT NULL,
 ID_rental INT DEFAULT NULL,
 "$paymentAmount" DECIMAL(5,2) NOT NULL,
 datePaid TIMESTAMP NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_payment),
 CONSTRAINT fk_payment_rental FOREIGN KEY (ID_rental) REFERENCES rental (ID_rental) ON DELETE SET NULL ON UPDATE CASCADE,
 CONSTRAINT fk_payment_customer FOREIGN KEY (ID_customer) REFERENCES customer (ID_customer) ,
 CONSTRAINT fk_payment_staff FOREIGN KEY (ID_staff) REFERENCES staff (ID_staff)
);

CREATE TABLE rental (
 ID_rental INT NOT NULL,
 dateRented TIMESTAMP NOT NULL,
 ID_inventory INT NOT NULL,
 ID_customer INT NOT NULL,
 dateReturned TIMESTAMP DEFAULT NULL,
 ID_staff SMALLINT NOT NULL,
 "last updated" TIMESTAMP NOT NULL,
 PRIMARY KEY (ID_rental),
 CONSTRAINT fk_rental_staff FOREIGN KEY (ID_staff) REFERENCES staff (ID_staff) ,
 CONSTRAINT fk_rental_inventory FOREIGN KEY (ID_inventory) REFERENCES inventory (ID_inventory) ,
 CONSTRAINT fk_rental_customer FOREIGN KEY (ID_customer) REFERENCES customer (ID_customer)
);

Insert into store Values ('1','1','2006-02-15 04:57:12.000');
Insert into store Values ('2','2','2006-02-15 04:57:12.000');
Insert into address Values ('1','47 MySakila Drive',NULL,' ','300',NULL,' ','2006-02-15 04:45:30.000');
Insert into address Values ('2','28 MySQL Boulevard',NULL,' ','576',NULL,' ','2006-02-15 04:45:30.000');
Insert into address Values ('132','1050 Garden Grove Avenue',NULL,' ','236','4999',' ','2006-02-15 04:45:30.000');
Insert into address Values ('279','1884 Shikarpur Avenue',NULL,' ','263','85548',' ','2006-02-15 04:45:30.000');
Insert into address Values ('500','362 Rajkot Lane',NULL,' ','47','98030',' ','2006-02-15 04:45:30.000');
Insert into address Values ('177','1010 Klerksdorp Way',NULL,' ','186','6802',' ','2006-02-15 04:45:30.000');
Insert into address Values ('245','1103 Bilbays Parkway',NULL,' ','578','87660',' ','2006-02-15 04:45:30.000');
Insert into address Values ('269','446 Kirovo-Tepetsk Lane',NULL,' ','203','19428',' ','2006-02-15 04:45:30.000');
Insert into address Values ('147','374 Bat Yam Boulevard',NULL,' ','266','97700',' ','2006-02-15 04:45:30.000');
Insert into address Values ('83','586 Tete Way',NULL,' ','256','1079',' ','2006-02-15 04:45:30.000');
Insert into address Values ('503','1416 San Juan Bautista Tuxtepec Avenue',NULL,' ','444','50592',' ','2006-02-15 04:45:30.000');
Insert into address Values ('321','651 Pathankot Loop',NULL,' ','336','59811',' ','2006-02-15 04:45:30.000');
Insert into address Values ('206','642 Nador Drive',NULL,' ','77','3924',' ','2006-02-15 04:45:30.000');
Insert into address Values ('497','1013 Tabuk Boulevard',NULL,' ','261','96203',' ','2006-02-15 04:45:30.000');
Insert into address Values ('9','53 Idfu Parkway',NULL,' ','361','42399',' ','2006-02-15 04:45:30.000');
Insert into address Values ('524','680 A Corua (La Corua) Manor',NULL,' ','482','49806',' ','2006-02-15 04:45:30.000');
Insert into address Values ('149','999 Sanaa Loop',NULL,' ','491','3439',' ','2006-02-15 04:45:30.000');
Insert into address Values ('152','1952 Pune Lane',NULL,' ','442','92150',' ','2006-02-15 04:45:30.000');
Insert into address Values ('58','1964 Allappuzha (Alleppey) Street',NULL,' ','227','48980',' ','2006-02-15 04:45:30.000');
Insert into address Values ('536','166 Jinchang Street',NULL,' ','165','86760',' ','2006-02-15 04:45:30.000');
Insert into address Values ('309','827 Yuncheng Drive',NULL,' ','99','79047',' ','2006-02-15 04:45:30.000');
Insert into address Values ('263','532 Toulon Street',NULL,' ','460','69517',' ','2006-02-15 04:45:30.000');
Insert into address Values ('137','261 Saint Louis Way',NULL,' ','541','83401',' ','2006-02-15 04:45:30.000');
Insert into address Values ('38','61 Tama Street',NULL,' ','284','94065',' ','2006-02-15 04:45:30.000');
Insert into address Values ('385','1642 Charlotte Amalie Drive',NULL,' ','549','75442',' ','2006-02-15 04:45:30.000');
Insert into address Values ('445','495 Bhimavaram Lane',NULL,' ','144','3',' ','2006-02-15 04:45:30.000');
Insert into address Values ('176','29 Pyongyang Loop',NULL,' ','58','47753',' ','2006-02-15 04:45:30.000');
Insert into address Values ('408','990 Etawah Loop',NULL,' ','564','79940',' ','2006-02-15 04:45:30.000');
Insert into address Values ('478','1078 Stara Zagora Drive',NULL,' ','301','69221',' ','2006-02-15 04:45:30.000');
Insert into address Values ('324','1145 Vilnius Manor',NULL,' ','451','73170',' ','2006-02-15 04:45:30.000');
Insert into address Values ('29','934 San Felipe de Puerto Plata Street',NULL,' ','472','99780',' ','2006-02-15 04:45:30.000');
Insert into address Values ('525','1949 Sanya Street',NULL,' ','224','61244',' ','2006-02-15 04:45:30.000');
Insert into address Values ('430','355 Vitria de Santo Anto Way',NULL,' ','452','81758',' ','2006-02-15 04:45:30.000');
Insert into address Values ('41','1440 Fukuyama Loop',NULL,' ','362','47929',' ','2006-02-15 04:45:30.000');
Insert into address Values ('7','692 Joliet Street',NULL,' ','38','83579',' ','2006-02-15 04:45:30.000');
Insert into address Values ('78','1206 Dos Quebradas Place',NULL,' ','431','20207',' ','2006-02-15 04:45:30.000');
Insert into address Values ('522','1768 Udine Loop',NULL,' ','60','32347',' ','2006-02-15 04:45:30.000');
Insert into address Values ('178','1848 Salala Boulevard',NULL,' ','373','25220',' ','2006-02-15 04:45:30.000');
Insert into address Values ('602','1101 Bucuresti Boulevard',NULL,' ','401','97661',' ','2006-02-15 04:45:30.000');
Insert into address Values ('80','602 Paarl Street',NULL,' ','402','98889',' ','2006-02-15 04:45:30.000');
Insert into address Values ('399','331 Bydgoszcz Parkway',NULL,' ','181','966',' ','2006-02-15 04:45:30.000');
Insert into address Values ('433','1823 Hoshiarpur Lane',NULL,' ','510','33191',' ','2006-02-15 04:45:30.000');
Insert into address Values ('562','869 Shikarpur Way',NULL,' ','496','57380',' ','2006-02-15 04:45:30.000');
Insert into address Values ('367','1163 London Parkway',NULL,' ','66','6066',' ','2006-02-15 04:45:30.000');
Insert into address Values ('362','482 Kowloon and New Kowloon Manor',NULL,' ','90','97056',' ','2006-02-15 04:45:30.000');
Insert into address Values ('145','928 Jaffna Loop',NULL,' ','172','93762',' ','2006-02-15 04:45:30.000');
Insert into address Values ('182','1891 Rizhao Boulevard',NULL,' ','456','47288',' ','2006-02-15 04:45:30.000');
Insert into address Values ('365','1009 Zanzibar Lane',NULL,' ','32','64875',' ','2006-02-15 04:45:30.000');
Insert into address Values ('162','369 Papeete Way',NULL,' ','187','66639',' ','2006-02-15 04:45:30.000');
Insert into address Values ('491','1789 Saint-Denis Parkway',NULL,' ','4','8268',' ','2006-02-15 04:45:30.000');
Insert into address Values ('25','262 A Corua (La Corua) Parkway',NULL,' ','525','34418',' ','2006-02-15 04:45:30.000');
Insert into address Values ('366','114 Jalib al-Shuyukh Manor',NULL,' ','585','60440',' ','2006-02-15 04:45:30.000');
Insert into address Values ('305','41 El Alto Parkway',NULL,' ','398','56883',' ','2006-02-15 04:45:30.000');
Insert into address Values ('26','28 Charlotte Amalie Street',NULL,' ','443','37551',' ','2006-02-15 04:45:30.000');
Insert into address Values ('374','433 Florencia Street',NULL,' ','250','91330',' ','2006-02-15 04:45:30.000');
Insert into address Values ('236','885 Yingkou Manor',NULL,' ','596','31390',' ','2006-02-15 04:45:30.000');
Insert into address Values ('4','1411 Lillydale Drive',NULL,' ','576',NULL,' ','2006-02-15 04:45:30.000');
Insert into address Values ('3','23 Workhaven Lane',NULL,' ','300',NULL,' ','2006-02-15 04:45:30.000');
Insert into address Values ('56','939 Probolinggo Loop',NULL,' ','1','4166',' ','2006-02-15 04:45:30.000');
Insert into address Values ('451','1704 Tambaram Manor',NULL,' ','554','2834',' ','2006-02-15 04:45:30.000');
Insert into address Values ('502','1515 Korla Way',NULL,' ','589','57197',' ','2006-02-15 04:45:30.000');
Insert into address Values ('565','1741 Hoshiarpur Boulevard',NULL,' ','79','22372',' ','2006-02-15 04:45:30.000');
Insert into address Values ('512','1269 Ipoh Avenue',NULL,' ','163','54674',' ','2006-02-15 04:45:30.000');
Insert into address Values ('28','96 Tafuna Way',NULL,' ','128','99865',' ','2006-02-15 04:45:30.000');
Insert into address Values ('40','334 Munger (Monghyr) Lane',NULL,' ','31','38145',' ','2006-02-15 04:45:30.000');
Insert into address Values ('118','442 Rae Bareli Place',NULL,' ','148','24321',' ','2006-02-15 04:45:30.000');
Insert into address Values ('470','1088 Ibirit Place',NULL,' ','595','88502',' ','2006-02-15 04:45:30.000');
Insert into address Values ('298','44 Najafabad Way',NULL,' ','146','61391',' ','2006-02-15 04:45:30.000');
Insert into address Values ('215','1333 Haldia Street',NULL,' ','174','82161',' ','2006-02-15 04:45:30.000');
Insert into address Values ('133','1854 Tieli Street',NULL,' ','302','15819',' ','2006-02-15 04:45:30.000');
Insert into address Values ('547','379 Lublin Parkway',NULL,' ','309','74568',' ','2006-02-15 04:45:30.000');
Insert into address Values ('211','850 Salala Loop',NULL,' ','371','10800',' ','2006-02-15 04:45:30.000');
Insert into address Values ('342','124 al-Manama Way',NULL,' ','382','52368',' ','2006-02-15 04:45:30.000');
Insert into address Values ('175','316 Uruapan Street',NULL,' ','223','58194',' ','2006-02-15 04:45:30.000');
Insert into address Values ('511','1152 al-Qatif Lane',NULL,' ','412','44816',' ','2006-02-15 04:45:30.000');
Insert into address Values ('64','81 Hodeida Way',NULL,' ','231','55561',' ','2006-02-15 04:45:30.000');
Insert into address Values ('208','1215 Pyongyang Parkway',NULL,' ','557','25238',' ','2006-02-15 04:45:30.000');
Insert into address Values ('31','217 Botshabelo Place',NULL,' ','138','49521',' ','2006-02-15 04:45:30.000');
Insert into address Values ('375','1049 Matamoros Parkway',NULL,' ','191','69640',' ','2006-02-15 04:45:30.000');
Insert into address Values ('330','981 Kumbakonam Place',NULL,' ','89','87611',' ','2006-02-15 04:45:30.000');
Insert into city Values ('300','Lethbridge','20','2006-02-15 04:45:25.000');
Insert into city Values ('576','Woodridge','8','2006-02-15 04:45:25.000');
Insert into city Values ('236','Jastrzebie-Zdrj','76','2006-02-15 04:45:25.000');
Insert into city Values ('263','Karnal','44','2006-02-15 04:45:25.000');
Insert into city Values ('47','Baiyin','23','2006-02-15 04:45:25.000');
Insert into city Values ('186','Graz','9','2006-02-15 04:45:25.000');
Insert into city Values ('578','Xiangfan','23','2006-02-15 04:45:25.000');
Insert into city Values ('203','Higashiosaka','50','2006-02-15 04:45:25.000');
Insert into city Values ('266','Kilis','97','2006-02-15 04:45:25.000');
Insert into city Values ('256','Kamakura','50','2006-02-15 04:45:25.000');
Insert into city Values ('444','Salala','71','2006-02-15 04:45:25.000');
Insert into city Values ('336','Miraj','44','2006-02-15 04:45:25.000');
Insert into city Values ('77','Bhusawal','44','2006-02-15 04:45:25.000');
Insert into city Values ('261','Kanchrapara','44','2006-02-15 04:45:25.000');
Insert into city Values ('361','Nantou','92','2006-02-15 04:45:25.000');
Insert into city Values ('482','Sivas','97','2006-02-15 04:45:25.000');
Insert into city Values ('491','Soshanguve','85','2006-02-15 04:45:25.000');
Insert into city Values ('442','Saint-Denis','79','2006-02-15 04:45:25.000');
Insert into city Values ('227','Iwakuni','50','2006-02-15 04:45:25.000');
Insert into city Values ('165','Ezeiza','6','2006-02-15 04:45:25.000');
Insert into city Values ('99','Callao','74','2006-02-15 04:45:25.000');
Insert into city Values ('460','Santiago de los Caballeros','27','2006-02-15 04:45:25.000');
Insert into city Values ('541','Torren','60','2006-02-15 04:45:25.000');
Insert into city Values ('284','Kurashiki','50','2006-02-15 04:45:25.000');
Insert into city Values ('549','Tychy','76','2006-02-15 04:45:25.000');
Insert into city Values ('144','Dhule (Dhulia)','44','2006-02-15 04:45:25.000');
Insert into city Values ('58','Batman','97','2006-02-15 04:45:25.000');
Insert into city Values ('564','Valparai','44','2006-02-15 04:45:25.000');
Insert into city Values ('301','Lhokseumawe','45','2006-02-15 04:45:25.000');
Insert into city Values ('451','San Felipe del Progreso','60','2006-02-15 04:45:25.000');
Insert into city Values ('472','Shikarpur','72','2006-02-15 04:45:25.000');
Insert into city Values ('224','Isesaki','50','2006-02-15 04:45:25.000');
Insert into city Values ('452','San Juan Bautista Tuxtepec','60','2006-02-15 04:45:25.000');
Insert into city Values ('362','Nanyang','23','2006-02-15 04:45:25.000');
Insert into city Values ('38','Athenai','39','2006-02-15 04:45:25.000');
Insert into city Values ('431','Rio Claro','15','2006-02-15 04:45:25.000');
Insert into city Values ('60','Battambang','18','2006-02-15 04:45:25.000');
Insert into city Values ('373','Ocumare del Tuy','104','2006-02-15 04:45:25.000');
Insert into city Values ('401','Patras','39','2006-02-15 04:45:25.000');
Insert into city Values ('402','Pavlodar','51','2006-02-15 04:45:25.000');
Insert into city Values ('181','Gijn','87','2006-02-15 04:45:25.000');
Insert into city Values ('510','Syktyvkar','80','2006-02-15 04:45:25.000');
Insert into city Values ('496','Southport','102','2006-02-15 04:45:25.000');
Insert into city Values ('66','Belm','15','2006-02-15 04:45:25.000');
Insert into city Values ('90','Bratislava','84','2006-02-15 04:45:25.000');
Insert into city Values ('172','Fukuyama','50','2006-02-15 04:45:25.000');
Insert into city Values ('456','Santa Brbara dOeste','15','2006-02-15 04:45:25.000');
Insert into city Values ('32','Arecibo','77','2006-02-15 04:45:25.000');
Insert into city Values ('187','Greensboro','103','2006-02-15 04:45:25.000');
Insert into city Values ('4','Acua','60','2006-02-15 04:45:25.000');
Insert into city Values ('525','Tangail','12','2006-02-15 04:45:25.000');
Insert into city Values ('585','Yaound','19','2006-02-15 04:45:25.000');
Insert into city Values ('398','Parbhani','44','2006-02-15 04:45:25.000');
Insert into city Values ('443','Sal','62','2006-02-15 04:45:25.000');
Insert into city Values ('250','Jurez','60','2006-02-15 04:45:25.000');
Insert into city Values ('596','Zaria','69','2006-02-15 04:45:25.000');
Insert into city Values ('1','A Corua (La Corua)','87','2006-02-15 04:45:25.000');
Insert into city Values ('554','Uluberia','44','2006-02-15 04:45:25.000');
Insert into city Values ('589','York','102','2006-02-15 04:45:25.000');
Insert into city Values ('79','Bilbays','29','2006-02-15 04:45:25.000');
Insert into city Values ('163','Eskisehir','97','2006-02-15 04:45:25.000');
Insert into city Values ('128','Crdoba','6','2006-02-15 04:45:25.000');
Insert into city Values ('31','Arak','46','2006-02-15 04:45:25.000');
Insert into city Values ('148','Duisburg','38','2006-02-15 04:45:25.000');
Insert into city Values ('595','Zapopan','60','2006-02-15 04:45:25.000');
Insert into city Values ('146','Donostia-San Sebastin','87','2006-02-15 04:45:25.000');
Insert into city Values ('174','Fuyu','23','2006-02-15 04:45:25.000');
Insert into city Values ('302','Liaocheng','23','2006-02-15 04:45:25.000');
Insert into city Values ('309','Livorno','49','2006-02-15 04:45:25.000');
Insert into city Values ('371','Nuuk','40','2006-02-15 04:45:25.000');
Insert into city Values ('382','Onomichi','50','2006-02-15 04:45:25.000');
Insert into city Values ('223','Ipoh','59','2006-02-15 04:45:25.000');
Insert into city Values ('412','Pontianak','45','2006-02-15 04:45:25.000');
Insert into city Values ('231','Jaipur','44','2006-02-15 04:45:25.000');
Insert into city Values ('557','Usak','97','2006-02-15 04:45:25.000');
Insert into city Values ('138','Davao','75','2006-02-15 04:45:25.000');
Insert into city Values ('191','Gulbarga','44','2006-02-15 04:45:25.000');
Insert into city Values ('89','Braslia','15','2006-02-15 04:45:25.000');
Insert into country Values ('20','Canada','2006-02-15 04:44:00.000');
Insert into country Values ('8','Australia','2006-02-15 04:44:00.000');
Insert into country Values ('76','Poland','2006-02-15 04:44:00.000');
Insert into country Values ('44','India','2006-02-15 04:44:00.000');
Insert into country Values ('23','China','2006-02-15 04:44:00.000');
Insert into country Values ('9','Austria','2006-02-15 04:44:00.000');
Insert into country Values ('50','Japan','2006-02-15 04:44:00.000');
Insert into country Values ('97','Turkey','2006-02-15 04:44:00.000');
Insert into country Values ('71','Oman','2006-02-15 04:44:00.000');
Insert into country Values ('92','Taiwan','2006-02-15 04:44:00.000');
Insert into country Values ('85','South Africa','2006-02-15 04:44:00.000');
Insert into country Values ('79','Runion','2006-02-15 04:44:00.000');
Insert into country Values ('6','Argentina','2006-02-15 04:44:00.000');
Insert into country Values ('74','Peru','2006-02-15 04:44:00.000');
Insert into country Values ('27','Dominican Republic','2006-02-15 04:44:00.000');
Insert into country Values ('60','Mexico','2006-02-15 04:44:00.000');
Insert into country Values ('45','Indonesia','2006-02-15 04:44:00.000');
Insert into country Values ('72','Pakistan','2006-02-15 04:44:00.000');
Insert into country Values ('39','Greece','2006-02-15 04:44:00.000');
Insert into country Values ('15','Brazil','2006-02-15 04:44:00.000');
Insert into country Values ('18','Cambodia','2006-02-15 04:44:00.000');
Insert into country Values ('104','Venezuela','2006-02-15 04:44:00.000');
Insert into country Values ('51','Kazakstan','2006-02-15 04:44:00.000');
Insert into country Values ('87','Spain','2006-02-15 04:44:00.000');
Insert into country Values ('80','Russian Federation','2006-02-15 04:44:00.000');
Insert into country Values ('102','United Kingdom','2006-02-15 04:44:00.000');
Insert into country Values ('84','Slovakia','2006-02-15 04:44:00.000');
Insert into country Values ('77','Puerto Rico','2006-02-15 04:44:00.000');
Insert into country Values ('103','United States','2006-02-15 04:44:00.000');
Insert into country Values ('12','Bangladesh','2006-02-15 04:44:00.000');
Insert into country Values ('19','Cameroon','2006-02-15 04:44:00.000');
Insert into country Values ('62','Morocco','2006-02-15 04:44:00.000');
Insert into country Values ('69','Nigeria','2006-02-15 04:44:00.000');
Insert into country Values ('29','Egypt','2006-02-15 04:44:00.000');
Insert into country Values ('46','Iran','2006-02-15 04:44:00.000');
Insert into country Values ('38','Germany','2006-02-15 04:44:00.000');
Insert into country Values ('49','Italy','2006-02-15 04:44:00.000');
Insert into country Values ('40','Greenland','2006-02-15 04:44:00.000');
Insert into country Values ('59','Malaysia','2006-02-15 04:44:00.000');
Insert into country Values ('75','Philippines','2006-02-15 04:44:00.000');
Insert into film Values ('806','SLEEPY JAPANESE','A Emotional Epistle of a Moose And a Composer who must Fight a Technical Writer in The Outback','2006','1',NULL,'4','2.99','137','25.99','PG','Trailers,Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('607','MUPPET MILE','A Lacklusture Story of a Madman And a Teacher who must Kill a Frisbee in The Gulf of Mexico','2006','1',NULL,'5','4.99','50','18.99','PG','Trailers,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('895','TOMORROW HUSTLER','A Thoughtful Story of a Moose And a Husband who must Face a Secret Agent in The Sahara Desert','2006','1',NULL,'3','2.99','142','21.99','R','Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('894','TOMATOES HELLFIGHTERS','A Thoughtful Epistle of a Madman And a Astronaut who must Overcome a Monkey in A Shark Tank','2006','1',NULL,'6','0.99','68','23.99','PG','Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('282','ENCOUNTERS CURTAIN','A Insightful Epistle of a Pastry Chef And a Womanizer who must Build a Boat in New Orleans','2006','1',NULL,'5','0.99','92','20.99','NC-17','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('921','UNCUT SUICIDES','A Intrepid Yarn of a Explorer And a Pastry Chef who must Pursue a Mad Cow in A U-Boat','2006','1',NULL,'7','2.99','172','29.99','PG-13','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('507','LADYBUGS ARMAGEDDON','A Fateful Reflection of a Dog And a Mad Scientist who must Meet a Mad Scientist in New Orleans','2006','1',NULL,'4','0.99','113','13.99','NC-17','Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('423','HOLLYWOOD ANONYMOUS','A Fast-Paced Epistle of a Boy And a Explorer who must Escape a Dog in A U-Boat','2006','1',NULL,'7','0.99','69','29.99','PG','Trailers,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('524','LION UNCUT','A Intrepid Display of a Pastry Chef And a Cat who must Kill a A Shark in Ancient China','2006','1',NULL,'6','0.99','50','13.99','PG','Trailers,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('83','BLUES INSTINCT','A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House','2006','1',NULL,'5','2.99','50','18.99','G','Trailers,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('769','SCHOOL JACKET','A Intrepid Yarn of a Monkey And a Boy who must Fight a Composer in A Manhattan Penthouse','2006','1',NULL,'5','4.99','151','21.99','PG-13','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('883','TEQUILA PAST','A Action-Packed Panorama of a Mad Scientist And a Robot who must Challenge a Student in Nigeria','2006','1',NULL,'6','4.99','53','17.99','PG','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('693','POTTER CONNECTICUT','A Thrilling Epistle of a Frisbee And a Cat who must Fight a Technical Writer in Berlin','2006','1',NULL,'5','2.99','115','16.99','PG','Trailers,Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('568','MEMENTO ZOOLANDER','A Touching Epistle of a Squirrel And a Explorer who must Redeem a Pastry Chef in The Sahara Desert','2006','1',NULL,'4','4.99','77','11.99','NC-17','Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('206','DANCING FEVER','A Stunning Story of a Explorer And a Forensic Psychologist who must Face a Crocodile in A Shark Tank','2006','1',NULL,'6','0.99','144','25.99','G','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('781','SEVEN SWARM','A Unbelieveable Character Study of a Dog And a Mad Cow who must Kill a Monkey in Berlin','2006','1',NULL,'4','4.99','127','15.99','R','Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('273','EFFECT GLADIATOR','A Beautiful Display of a Pastry Chef And a Pastry Chef who must Outgun a Forensic Psychologist in A Manhattan Penthouse','2006','1',NULL,'6','0.99','107','14.99','PG','Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('64','BEETHOVEN EXORCIST','A Epic Display of a Pioneer And a Student who must Challenge a Butler in The Gulf of Mexico','2006','1',NULL,'6','0.99','151','26.99','PG-13','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('882','TENENBAUMS COMMAND','A Taut Display of a Pioneer And a Man who must Reach a Girl in The Gulf of Mexico','2006','1',NULL,'4','0.99','99','24.99','PG-13','Trailers,Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('459','INFORMER DOUBLE','A Action-Packed Display of a Woman And a Dentist who must Redeem a Forensic Psychologist in The Canadian Rockies','2006','1',NULL,'4','4.99','74','23.99','NC-17','Trailers,Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('577','MILE MULAN','A Lacklusture Epistle of a Cat And a Husband who must Confront a Boy in A MySQL Convention','2006','1',NULL,'4','0.99','64','10.99','PG','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('116','CANDIDATE PERDITION','A Brilliant Epistle of a Composer And a Database Administrator who must Vanquish a Mad Scientist in The First Manned Space Station','2006','1',NULL,'4','2.99','70','10.99','R','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('404','HATE HANDICAP','A Intrepid Reflection of a Mad Scientist And a Pioneer who must Overcome a Hunter in The First Manned Space Station','2006','1',NULL,'4','0.99','107','26.99','PG','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('480','JEEPERS WEDDING','A Astounding Display of a Composer And a Dog who must Kill a Pastry Chef in Soviet Georgia','2006','1',NULL,'3','2.99','84','29.99','R','Trailers,Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('837','STAGE WORLD','A Lacklusture Panorama of a Woman And a Frisbee who must Chase a Crocodile in A Jet Boat','2006','1',NULL,'4','2.99','85','19.99','PG','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('926','UNTOUCHABLES SUNRISE','A Amazing Documentary of a Woman And a Astronaut who must Outrace a Teacher in An Abandoned Fun House','2006','1',NULL,'5','2.99','120','11.99','NC-17','Trailers,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('35','ARACHNOPHOBIA ROLLERCOASTER','A Action-Packed Reflection of a Pastry Chef And a Composer who must Discover a Mad Scientist in The First Manned Space Station','2006','1',NULL,'4','2.99','147','24.99','PG-13','Trailers,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('596','MOONSHINE CABIN','A Thoughtful Display of a Astronaut And a Feminist who must Chase a Frisbee in A Jet Boat','2006','1',NULL,'4','4.99','171','25.99','PG-13','Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('510','LAWLESS VISION','A Insightful Yarn of a Boy And a Sumo Wrestler who must Outgun a Car in The Outback','2006','1',NULL,'6','4.99','181','29.99','G','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('763','SATISFACTION CONFIDENTIAL','A Lacklusture Yarn of a Dentist And a Butler who must Meet a Secret Agent in Ancient China','2006','1',NULL,'3','4.99','75','26.99','G','Commentaries,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('903','TRAFFIC HOBBIT','A Amazing Epistle of a Squirrel And a Lumberjack who must Succumb a Database Administrator in A U-Boat','2006','1',NULL,'5','4.99','139','13.99','G','Trailers,Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('496','KICK SAVANNAH','A Emotional Drama of a Monkey And a Robot who must Defeat a Monkey in New Orleans','2006','1',NULL,'3','0.99','179','10.99','PG-13','Trailers,Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('300','FALCON VOLUME','A Fateful Saga of a Sumo Wrestler And a Hunter who must Redeem a A Shark in New Orleans','2006','1',NULL,'5','4.99','102','21.99','PG-13','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('28','ANTHEM LUKE','A Touching Panorama of a Waitress And a Woman who must Outrace a Dog in An Abandoned Amusement Park','2006','1',NULL,'5','4.99','91','16.99','PG-13','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('500','KISS GLORY','A Lacklusture Reflection of a Girl And a Husband who must Find a Robot in The Canadian Rockies','2006','1',NULL,'5','4.99','163','11.99','PG-13','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('375','GRAIL FRANKENSTEIN','A Unbelieveable Saga of a Teacher And a Monkey who must Fight a Girl in An Abandoned Mine Shaft','2006','1',NULL,'4','2.99','85','17.99','NC-17','Commentaries,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('816','SNOWMAN ROLLERCOASTER','A Fateful Display of a Lumberjack And a Girl who must Succumb a Mad Cow in A Manhattan Penthouse','2006','1',NULL,'3','0.99','62','27.99','G','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('326','FLYING HOOK','A Thrilling Display of a Mad Cow And a Dog who must Challenge a Frisbee in Nigeria','2006','1',NULL,'6','2.99','69','18.99','NC-17','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('433','HORN WORKING','A Stunning Display of a Mad Scientist And a Technical Writer who must Succumb a Monkey in A Shark Tank','2006','1',NULL,'4','2.99','95','23.99','PG','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('68','BETRAYED REAR','A Emotional Character Study of a Boat And a Pioneer who must Find a Explorer in A Shark Tank','2006','1',NULL,'5','4.99','122','26.99','NC-17','Commentaries,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('227','DETAILS PACKER','A Epic Saga of a Waitress And a Composer who must Face a Boat in A U-Boat','2006','1',NULL,'4','4.99','88','17.99','R','Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('929','USUAL UNTOUCHABLES','A Touching Display of a Explorer And a Lumberjack who must Fight a Forensic Psychologist in A Shark Tank','2006','1',NULL,'5','4.99','128','21.99','PG-13','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('303','FANTASY TROOPERS','A Touching Saga of a Teacher And a Monkey who must Overcome a Secret Agent in A MySQL Convention','2006','1',NULL,'6','0.99','58','27.99','PG-13','Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('932','VALLEY PACKER','A Astounding Documentary of a Astronaut And a Boy who must Outrace a Sumo Wrestler in Berlin','2006','1',NULL,'3','0.99','73','21.99','G','Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('797','SILENCE KANE','A Emotional Drama of a Sumo Wrestler And a Dentist who must Confront a Sumo Wrestler in A Baloon','2006','1',NULL,'7','0.99','67','23.99','R','Trailers,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('843','STEEL SANTA','A Fast-Paced Yarn of a Composer And a Frisbee who must Face a Moose in Nigeria','2006','1',NULL,'4','4.99','143','15.99','NC-17','Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('80','BLANKET BEVERLY','A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria','2006','1',NULL,'7','2.99','148','21.99','G','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('407','HAWK CHILL','A Action-Packed Drama of a Mad Scientist And a Composer who must Outgun a Car in Australia','2006','1',NULL,'5','0.99','47','12.99','PG-13','Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('103','BUCKET BROTHERHOOD','A Amazing Display of a Girl And a Womanizer who must Succumb a Lumberjack in A Baloon Factory','2006','1',NULL,'7','4.99','133','27.99','PG','Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('650','PACIFIC AMISTAD','A Thrilling Yarn of a Dog And a Moose who must Kill a Pastry Chef in A Manhattan Penthouse','2006','1',NULL,'3','0.99','144','27.99','G','Trailers,Commentaries,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('166','COLOR PHILADELPHIA','A Thoughtful Panorama of a Car And a Crocodile who must Sink a Monkey in The Sahara Desert','2006','1',NULL,'6','2.99','149','19.99','G','Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('506','LADY STAGE','A Beautiful Character Study of a Woman And a Man who must Pursue a Explorer in A U-Boat','2006','1',NULL,'4','4.99','67','14.99','PG','Trailers,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('873','SWEETHEARTS SUSPECTS','A Brilliant Character Study of a Frisbee And a Sumo Wrestler who must Confront a Woman in The Gulf of Mexico','2006','1',NULL,'3','0.99','108','13.99','G','Trailers,Commentaries,Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('594','MONTEZUMA COMMAND','A Thrilling Reflection of a Waitress And a Butler who must Battle a Butler in A Jet Boat','2006','1',NULL,'6','0.99','126','22.99','NC-17','Trailers','2006-02-15 05:03:42.000');
Insert into film Values ('161','CLUE GRAIL','A Taut Tale of a Butler And a Mad Scientist who must Build a Crocodile in Ancient China','2006','1',NULL,'6','4.99','70','27.99','NC-17','Trailers,Commentaries,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('906','TRAMP OTHERS','A Brilliant Display of a Composer And a Cat who must Succumb a A Shark in Ancient India','2006','1',NULL,'4','0.99','171','27.99','PG','Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('344','FURY MURDER','A Lacklusture Reflection of a Boat And a Forensic Psychologist who must Fight a Waitress in A Monastery','2006','1',NULL,'3','0.99','178','28.99','PG-13','Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('768','SCARFACE BANG','A Emotional Yarn of a Teacher And a Girl who must Find a Teacher in A Baloon Factory','2006','1',NULL,'3','4.99','102','11.99','PG-13','Commentaries,Deleted Scenes','2006-02-15 05:03:42.000');
Insert into film Values ('244','DORADO NOTTING','A Action-Packed Tale of a Sumo Wrestler And a A Shark who must Meet a Frisbee in California','2006','1',NULL,'5','4.99','139','26.99','NC-17','Commentaries','2006-02-15 05:03:42.000');
Insert into film Values ('305','FATAL HAUNTED','A Beautiful Drama of a Student And a Secret Agent who must Confront a Dentist in Ancient Japan','2006','1',NULL,'6','2.99','91','24.99','PG','Trailers,Behind the Scenes','2006-02-15 05:03:42.000');
Insert into language Values ('1','English','2006-02-15 05:02:19.000');
Insert into language Values ('4','Mandarin','2006-02-15 05:02:19.000');
Insert into language Values ('5','French','2006-02-15 05:02:19.000');
Insert into language Values ('6','German','2006-02-15 05:02:19.000');
Insert into language Values ('3','Japanese','2006-02-15 05:02:19.000');
Insert into language Values ('2','Italian','2006-02-15 05:02:19.000');
Insert into customer Values ('25','1','DEBORAH','WALKER','DEBORAH.WALKER@sakilacustomer.org','29','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('519','2','RON','DELUCA','RON.DELUCA@sakilacustomer.org','525','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('425','2','FRANCIS','SIKES','FRANCIS.SIKES@sakilacustomer.org','430','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('37','1','PAMELA','BAKER','PAMELA.BAKER@sakilacustomer.org','41','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('241','2','HEIDI','LARSON','HEIDI.LARSON@sakilacustomer.org','245','0','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('3','1','LINDA','WILLIAMS','LINDA.WILLIAMS@sakilacustomer.org','7','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('74','1','DENISE','KELLY','DENISE.KELLY@sakilacustomer.org','78','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('202','2','CARLA','GUTIERREZ','CARLA.GUTIERREZ@sakilacustomer.org','206','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('516','2','ELMER','NOE','ELMER.NOE@sakilacustomer.org','522','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('174','2','YVONNE','WATKINS','YVONNE.WATKINS@sakilacustomer.org','178','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('596','1','ENRIQUE','FORSYTHE','ENRIQUE.FORSYTHE@sakilacustomer.org','602','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('76','2','IRENE','PRICE','IRENE.PRICE@sakilacustomer.org','80','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('394','2','CHRIS','BROTHERS','CHRIS.BROTHERS@sakilacustomer.org','399','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('428','2','HERBERT','KRUGER','HERBERT.KRUGER@sakilacustomer.org','433','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('556','2','ARMANDO','GRUBER','ARMANDO.GRUBER@sakilacustomer.org','562','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('362','1','NICHOLAS','BARFIELD','NICHOLAS.BARFIELD@sakilacustomer.org','367','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('357','1','KEITH','RICO','KEITH.RICO@sakilacustomer.org','362','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('141','1','DEBBIE','REYES','DEBBIE.REYES@sakilacustomer.org','145','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('178','2','MARION','SNYDER','MARION.SNYDER@sakilacustomer.org','182','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('360','2','RALPH','MADRIGAL','RALPH.MADRIGAL@sakilacustomer.org','365','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('158','1','VERONICA','STONE','VERONICA.STONE@sakilacustomer.org','162','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('486','1','GLEN','TALBERT','GLEN.TALBERT@sakilacustomer.org','491','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('128','1','MARJORIE','TUCKER','MARJORIE.TUCKER@sakilacustomer.org','132','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('21','1','MICHELLE','CLARK','MICHELLE.CLARK@sakilacustomer.org','25','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('361','2','LAWRENCE','LAWTON','LAWRENCE.LAWTON@sakilacustomer.org','366','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('300','1','JOHN','FARNSWORTH','JOHN.FARNSWORTH@sakilacustomer.org','305','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('22','1','LAURA','RODRIGUEZ','LAURA.RODRIGUEZ@sakilacustomer.org','26','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('369','2','FRED','WHEAT','FRED.WHEAT@sakilacustomer.org','374','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('380','1','RUSSELL','BRINSON','RUSSELL.BRINSON@sakilacustomer.org','385','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('232','2','CONSTANCE','REID','CONSTANCE.REID@sakilacustomer.org','236','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('52','1','JULIE','SANCHEZ','JULIE.SANCHEZ@sakilacustomer.org','56','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('446','2','THEODORE','CULP','THEODORE.CULP@sakilacustomer.org','451','0','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('497','2','GILBERT','SLEDGE','GILBERT.SLEDGE@sakilacustomer.org','502','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('559','2','EVERETT','BANDA','EVERETT.BANDA@sakilacustomer.org','565','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('145','1','LUCILLE','HOLMES','LUCILLE.HOLMES@sakilacustomer.org','149','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('507','2','EDGAR','RHOADS','EDGAR.RHOADS@sakilacustomer.org','512','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('24','2','KIMBERLY','LEE','KIMBERLY.LEE@sakilacustomer.org','28','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('36','2','KATHLEEN','ADAMS','KATHLEEN.ADAMS@sakilacustomer.org','40','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('114','2','GRACE','ELLIS','GRACE.ELLIS@sakilacustomer.org','118','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('465','1','FLOYD','GANDY','FLOYD.GANDY@sakilacustomer.org','470','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('293','2','MAE','FLETCHER','MAE.FLETCHER@sakilacustomer.org','298','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('211','1','STACEY','MONTGOMERY','STACEY.MONTGOMERY@sakilacustomer.org','215','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('129','1','CARRIE','PORTER','CARRIE.PORTER@sakilacustomer.org','133','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('541','2','DARREN','WINDHAM','DARREN.WINDHAM@sakilacustomer.org','547','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('207','1','GERTRUDE','CASTILLO','GERTRUDE.CASTILLO@sakilacustomer.org','211','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('274','1','NAOMI','JENNINGS','NAOMI.JENNINGS@sakilacustomer.org','279','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('337','1','JERRY','JORDON','JERRY.JORDON@sakilacustomer.org','342','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('171','2','DOLORES','WAGNER','DOLORES.WAGNER@sakilacustomer.org','175','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('506','2','LESLIE','SEWARD','LESLIE.SEWARD@sakilacustomer.org','511','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('60','1','MILDRED','BAILEY','MILDRED.BAILEY@sakilacustomer.org','64','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('204','1','ROSEMARY','SCHMIDT','ROSEMARY.SCHMIDT@sakilacustomer.org','208','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('27','2','SHIRLEY','ALLEN','SHIRLEY.ALLEN@sakilacustomer.org','31','1','2006-02-14 22:04:36.000','2006-02-15 04:57:20.000');
Insert into customer Values ('370','2','WAYNE','TRUONG','WAYNE.TRUONG@sakilacustomer.org','375','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into customer Values ('325','1','TIMOTHY','BUNN','TIMOTHY.BUNN@sakilacustomer.org','330','1','2006-02-14 22:04:37.000','2006-02-15 04:57:20.000');
Insert into staff Values ('2','Jon','Stephens','4',NULL,'Jon.Stephens@sakilastaff.com','2','1','Jon','8cb2237d0679ca88db6464eac60da96345513964','2006-02-15 04:57:16.000');
Insert into staff Values ('1','Mike','Hillyer','3',NULL,'Mike.Hillyer@sakilastaff.com','1','1','Mike','8cb2237d0679ca88db6464eac60da96345513964','2006-02-15 04:57:16.000');
Insert into actor Values ('59','DUSTIN','TAUTOU','2006-02-15 04:34:33.000');
Insert into actor Values ('8','MATTHEW','JOHANSSON','2006-02-15 04:34:33.000');
Insert into actor Values ('73','GARY','PENN','2006-02-15 04:34:33.000');
Insert into actor Values ('173','ALAN','DREYFUSS','2006-02-15 04:34:33.000');
Insert into actor Values ('168','WILL','WILSON','2006-02-15 04:34:33.000');
Insert into actor Values ('182','DEBBIE','AKROYD','2006-02-15 04:34:33.000');
Insert into actor Values ('13','UMA','WOOD','2006-02-15 04:34:33.000');
Insert into actor Values ('69','KENNETH','PALTROW','2006-02-15 04:34:33.000');
Insert into actor Values ('11','ZERO','CAGE','2006-02-15 04:34:33.000');
Insert into actor Values ('32','TIM','HACKMAN','2006-02-15 04:34:33.000');
Insert into actor Values ('43','KIRK','JOVOVICH','2006-02-15 04:34:33.000');
Insert into actor Values ('24','CAMERON','STREEP','2006-02-15 04:34:33.000');
Insert into actor Values ('114','MORGAN','MCDORMAND','2006-02-15 04:34:33.000');
Insert into actor Values ('156','FAY','WOOD','2006-02-15 04:34:33.000');
Insert into actor Values ('111','CAMERON','ZELLWEGER','2006-02-15 04:34:33.000');
Insert into actor Values ('162','OPRAH','KILMER','2006-02-15 04:34:33.000');
Insert into actor Values ('123','JULIANNE','DENCH','2006-02-15 04:34:33.000');
Insert into actor Values ('150','JAYNE','NOLTE','2006-02-15 04:34:33.000');
Insert into actor Values ('76','ANGELINA','ASTAIRE','2006-02-15 04:34:33.000');
Insert into actor Values ('85','MINNIE','ZELLWEGER','2006-02-15 04:34:33.000');
Insert into actor Values ('110','SUSAN','DAVIS','2006-02-15 04:34:33.000');
Insert into actor Values ('192','JOHN','SUVARI','2006-02-15 04:34:33.000');
Insert into actor Values ('136','ED','MANSFIELD','2006-02-15 04:34:33.000');
Insert into actor Values ('46','PARKER','GOLDBERG','2006-02-15 04:34:33.000');
Insert into actor Values ('147','FAY','WINSLET','2006-02-15 04:34:33.000');
Insert into actor Values ('151','GEOFFREY','HESTON','2006-02-15 04:34:33.000');
Insert into actor Values ('50','NATALIE','HOPKINS','2006-02-15 04:34:33.000');
Insert into actor Values ('117','RENEE','TRACY','2006-02-15 04:34:33.000');
Insert into actor Values ('101','SUSAN','DAVIS','2006-02-15 04:34:33.000');
Insert into actor Values ('152','BEN','HARRIS','2006-02-15 04:34:33.000');
Insert into category Values ('2','Animation','2006-02-15 04:46:27.000');
Insert into category Values ('6','Documentary','2006-02-15 04:46:27.000');
Insert into category Values ('10','Games','2006-02-15 04:46:27.000');
Insert into category Values ('9','Foreign','2006-02-15 04:46:27.000');
Insert into category Values ('7','Drama','2006-02-15 04:46:27.000');
Insert into category Values ('14','Sci-Fi','2006-02-15 04:46:27.000');
Insert into category Values ('5','Comedy','2006-02-15 04:46:27.000');
Insert into category Values ('15','Sports','2006-02-15 04:46:27.000');
Insert into category Values ('1','Action','2006-02-15 04:46:27.000');
Insert into category Values ('13','New','2006-02-15 04:46:27.000');
Insert into category Values ('16','Travel','2006-02-15 04:46:27.000');
Insert into category Values ('11','Horror','2006-02-15 04:46:27.000');
Insert into category Values ('8','Family','2006-02-15 04:46:27.000');
Insert into category Values ('3','Children','2006-02-15 04:46:27.000');
Insert into category Values ('12','Music','2006-02-15 04:46:27.000');
Insert into category Values ('4','Classics','2006-02-15 04:46:27.000');
Insert into rental Values ('8686','2005-07-29 16:17:49.000','4160','52','2005-08-01 12:50:49.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('2498','2005-06-18 22:56:26.000','2291','74','2005-06-22 20:02:26.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('12130','2006-02-14 15:16:03.000','1358','516',NULL,'2','2006-02-15 21:30:53.000');
Insert into rental Values ('355','2005-05-27 06:15:33.000','141','446','2005-06-01 02:50:33.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('13159','2005-08-19 13:19:59.000','2300','497','2005-08-21 09:22:59.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('10146','2005-07-31 22:17:56.000','1721','559','2005-08-02 21:27:56.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('7954','2005-07-28 13:25:05.000','3735','145','2005-07-29 18:50:05.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('7770','2005-07-28 06:49:35.000','1486','507','2005-08-06 08:16:35.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('1077','2005-05-31 10:22:54.000','1986','24','2005-06-02 12:21:54.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('4560','2005-07-08 04:58:48.000','303','36','2005-07-10 04:27:48.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('5624','2005-07-10 05:43:16.000','1015','114','2005-07-12 05:33:16.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('15859','2005-08-23 16:08:15.000','4269','465','2005-08-28 11:08:15.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('3906','2005-07-06 19:35:55.000','1383','293','2005-07-15 22:35:55.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('14812','2005-08-22 01:10:32.000','4282','211','2005-08-26 05:21:32.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('5127','2005-07-09 07:25:47.000','3649','129','2005-07-13 11:44:47.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('12306','2005-08-18 05:47:55.000','3853','541','2005-08-21 01:56:55.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('3584','2005-07-06 04:16:43.000','367','207','2005-07-13 07:08:43.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('14012','2005-08-20 20:42:12.000','1866','274','2005-08-23 23:10:12.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('12045','2005-08-17 20:40:46.000','469','556','2005-08-20 18:18:46.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('2014','2005-06-17 12:03:28.000','2969','337','2005-06-25 16:00:28.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('6905','2005-07-12 22:02:18.000','763','25','2005-07-18 23:30:18.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('14615','2005-08-21 18:06:32.000','2332','171','2005-08-30 13:19:32.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('410','2005-05-27 14:11:22.000','4010','506','2005-06-02 20:06:22.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('12084','2005-08-17 22:16:49.000','2706','60','2005-08-24 17:42:49.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('12737','2005-08-18 22:11:37.000','736','204','2005-08-26 04:08:37.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('9147','2005-07-30 10:38:59.000','4167','394','2005-08-02 11:45:59.000','2','2006-02-15 21:30:53.000');
Insert into rental Values ('12461','2005-08-18 11:28:14.000','1569','27','2005-08-21 09:47:14.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('7226','2005-07-27 09:47:53.000','3507','370','2005-08-01 08:24:53.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('6858','2005-07-12 19:53:51.000','1095','516','2005-07-19 14:12:51.000','1','2006-02-15 21:30:53.000');
Insert into rental Values ('10030','2005-07-31 18:39:36.000','1392','325','2005-08-03 15:29:36.000','2','2006-02-15 21:30:53.000');
Insert into inventory Values ('4160','903','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('2291','496','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('1358','300','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('141','28','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('2300','500','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('1721','375','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('3735','816','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('1486','326','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1986','433','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('303','68','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('1015','227','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('4269','929','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1383','303','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('4282','932','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('3649','797','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('3853','843','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('367','80','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1866','407','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('469','103','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('2969','650','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('763','166','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('2332','506','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('4010','873','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('2706','594','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('736','161','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('4167','906','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1569','344','2','2006-02-15 05:09:17.000');
Insert into inventory Values ('3507','768','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1095','244','1','2006-02-15 05:09:17.000');
Insert into inventory Values ('1392','305','1','2006-02-15 05:09:17.000');