view release on metacpan or  search on metacpan

t/sql/sakila-data.sql  view on Meta::CPAN

-- Dumping data for table film_category
--

SET AUTOCOMMIT=0;
INSERT INTO film_category VALUES (1,6,'2006-02-15 05:07:09'),(2,11,'2006-02-15 05:07:09'),(3,6,'2006-02-15 05:07:09'),(4,11,'2006-02-15 05:07:09'),(5,8,'2006-02-15 05:07:09'),(6,9,'2006-02-15 05:07:09'),(7,5,'2006-02-15 05:07:09'),(8,11,'2006-02-15 0...
COMMIT;

--
-- Dumping data for table inventory
--

SET AUTOCOMMIT=0;
INSERT INTO inventory VALUES (1,1,1,'2006-02-15 05:09:17'),(2,1,1,'2006-02-15 05:09:17'),(3,1,1,'2006-02-15 05:09:17'),(4,1,1,'2006-02-15 05:09:17'),(5,1,2,'2006-02-15 05:09:17'),(6,1,2,'2006-02-15 05:09:17'),(7,1,2,'2006-02-15 05:09:17'),(8,1,2,'200...
COMMIT;

--
-- Dumping data for table language
--

SET AUTOCOMMIT=0;
INSERT INTO language VALUES (1,'English','2006-02-15 05:02:19'),(2,'Italian','2006-02-15 05:02:19'),(3,'Japanese','2006-02-15 05:02:19'),(4,'Mandarin','2006-02-15 05:02:19'),(5,'French','2006-02-15 05:02:19'),(6,'German','2006-02-15 05:02:19');
COMMIT;

--
-- Dumping data for table payment
--

SET AUTOCOMMIT=0;
INSERT INTO payment VALUES (1,1,1,76,'2.99','2005-05-25 11:30:37','2006-02-15 22:12:30'),(2,1,1,573,'0.99','2005-05-28 10:35:23','2006-02-15 22:12:30'),(3,1,1,1185,'5.99','2005-06-15 00:54:12','2006-02-15 22:12:30'),(4,1,2,1422,'0.99','2005-06-15 18:...
INSERT INTO payment VALUES (14886,555,2,12182,'2.99','2005-08-18 01:30:19','2006-02-15 22:21:53'),(14887,555,1,12388,'2.99','2005-08-18 08:48:09','2006-02-15 22:21:53'),(14888,555,1,12883,'4.99','2005-08-19 03:33:47','2006-02-15 22:21:53'),(14889,555...
COMMIT;

--
-- Trigger to enforce payment_date during INSERT
--

CREATE TRIGGER payment_date BEFORE INSERT ON payment
	FOR EACH ROW SET NEW.payment_date = NOW();

--
-- Dumping data for table rental
--

SET AUTOCOMMIT=0;
INSERT INTO rental VALUES (1,'2005-05-24 22:53:30',367,130,'2005-05-26 22:04:30',1,'2006-02-15 21:30:53'),(2,'2005-05-24 22:54:33',1525,459,'2005-05-28 19:40:33',1,'2006-02-15 21:30:53'),(3,'2005-05-24 23:03:39',1711,408,'2005-06-01 22:12:39',1,'2006...
INSERT INTO rental VALUES (12382,'2005-08-18 08:32:33',3049,566,'2005-08-26 03:45:33',2,'2006-02-15 21:30:53'),(12383,'2005-08-18 08:36:03',1641,295,'2005-08-23 03:30:03',2,'2006-02-15 21:30:53'),(12384,'2005-08-18 08:36:58',2557,193,'2005-08-23 05:0...
COMMIT;

--
-- Trigger to enforce rental_date on INSERT
--

CREATE TRIGGER rental_date BEFORE INSERT ON rental
	FOR EACH ROW SET NEW.rental_date = NOW();

--
-- Dumping data for table staff
--

SET AUTOCOMMIT=0;
INSERT INTO staff VALUES (1,'Mike','Hillyer',3,'‰PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0y\0\0\0u\0\0\0åZÙe\0\0\0	pHYs\0\0Ã\0\0Ã
Ço¨d\0\0 \0IDATxœL»w”$gyÿ»÷{~¾FawgwrÎ=fz¦{¦\'vÎ9TUWÎ9tîž°I«•V9\"ABX0Ñ°IL°1ÙÁ`„PZíîLÝ?¸·ÎsÞSõÖuÎç¼õ<Ï÷ûV»|é­—/½õ®Ë...
COMMIT;

--
-- Dumping data for table store
--

SET AUTOCOMMIT=0;
INSERT INTO store VALUES (1,1,1,'2006-02-15 04:57:12'),(2,2,2,'2006-02-15 04:57:12');
COMMIT;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;