App-AltSQL
view release on metacpan or search on metacpan
t/sql/sakila-data.sql view on Meta::CPAN
-- Sakila Sample Database Data
-- Version 0.8
-- Copyright (c) 2006, MySQL AB
-- All rights reserved.
-- Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
-- * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
-- * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
-- * Neither the name of MySQL AB nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
-- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO ...
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
USE sakila;
--
-- Dumping data for table actor
--
SET AUTOCOMMIT=0;
INSERT INTO actor VALUES (1,'PENELOPE','GUINESS','2006-02-15 04:34:33'),(2,'NICK','WAHLBERG','2006-02-15 04:34:33'),(3,'ED','CHASE','2006-02-15 04:34:33'),(4,'JENNIFER','DAVIS','2006-02-15 04:34:33'),(5,'JOHNNY','LOLLOBRIGIDA','2006-02-15 04:34:33'),...
COMMIT;
--
-- Dumping data for table address
--
SET AUTOCOMMIT=0;
INSERT INTO address VALUES (1,'47 MySakila Drive',NULL,'Alberta',300,'','','2006-02-15 04:45:30'),(2,'28 MySQL Boulevard',NULL,'QLD',576,'','','2006-02-15 04:45:30'),(3,'23 Workhaven Lane',NULL,'Alberta',300,'','14033335568','2006-02-15 04:45:30'),(4...
COMMIT;
--
-- Dumping data for table category
--
SET AUTOCOMMIT=0;
INSERT INTO category VALUES (1,'Action','2006-02-15 04:46:27'),(2,'Animation','2006-02-15 04:46:27'),(3,'Children','2006-02-15 04:46:27'),(4,'Classics','2006-02-15 04:46:27'),(5,'Comedy','2006-02-15 04:46:27'),(6,'Documentary','2006-02-15 04:46:27'),...
COMMIT;
--
-- Dumping data for table city
--
SET AUTOCOMMIT=0;
INSERT INTO city VALUES (1,'A Corua (La Corua)',87,'2006-02-15 04:45:25'),(2,'Abha',82,'2006-02-15 04:45:25'),(3,'Abu Dhabi',101,'2006-02-15 04:45:25'),(4,'Acua',60,'2006-02-15 04:45:25'),(5,'Adana',97,'2006-02-15 04:45:25'),(6,'Addis Abeba',31,'2006...
COMMIT;
--
-- Dumping data for table country
--
SET AUTOCOMMIT=0;
INSERT INTO country VALUES (1,'Afghanistan','2006-02-15 04:44:00'),(2,'Algeria','2006-02-15 04:44:00'),(3,'American Samoa','2006-02-15 04:44:00'),(4,'Angola','2006-02-15 04:44:00'),(5,'Anguilla','2006-02-15 04:44:00'),(6,'Argentina','2006-02-15 04:44...
COMMIT;
--
-- Dumping data for table customer
--
SET AUTOCOMMIT=0;
INSERT INTO customer VALUES (1,1,'MARY','SMITH','MARY.SMITH@sakilacustomer.org',5,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(2,1,'PATRICIA','JOHNSON','PATRICIA.JOHNSON@sakilacustomer.org',6,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(3,1,'LI...
COMMIT;
--
-- Trigger to enforce create dates on INSERT
--
CREATE TRIGGER customer_create_date BEFORE INSERT ON customer
FOR EACH ROW SET NEW.create_date = NOW();
--
-- Dumping data for table film
--
SET AUTOCOMMIT=0;
INSERT INTO film VALUES (1,'ACADEMY DINOSAUR','A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies',2006,1,NULL,6,'0.99',86,'20.99','PG','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42'),(2,'ACE GO...
COMMIT;
--
-- Dumping data for table film_actor
--
SET AUTOCOMMIT=0;
INSERT INTO film_actor VALUES (1,1,'2006-02-15 05:05:03'),(1,23,'2006-02-15 05:05:03'),(1,25,'2006-02-15 05:05:03'),(1,106,'2006-02-15 05:05:03'),(1,140,'2006-02-15 05:05:03'),(1,166,'2006-02-15 05:05:03'),(1,277,'2006-02-15 05:05:03'),(1,361,'2006-0...
COMMIT;
--
-- 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;
( run in 1.383 second using v1.01-cache-2.11-cpan-39bf76dae61 )