view release on metacpan or  search on metacpan

migrations/001-sample-data.sql  view on Meta::CPAN

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
SET @OLD_TIME_ZONE=@@TIME_ZONE;
SET TIME_ZONE='+00:00';
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

LOCK TABLES `ACCESSORY_TYPE` WRITE;
ALTER TABLE `ACCESSORY_TYPE` DISABLE KEYS;
INSERT INTO `ACCESSORY_TYPE` VALUES (1,'Power winder'),(2,'Battery grip'),(3,'Viewfinder'),(4,'Focusing screen'),(5,'Film back'),(6,'Lens hood'),(7,'Case');
ALTER TABLE `ACCESSORY_TYPE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `ARCHIVE_TYPE` WRITE;
ALTER TABLE `ARCHIVE_TYPE` DISABLE KEYS;
INSERT INTO `ARCHIVE_TYPE` VALUES (1,'Film'),(2,'Slide'),(3,'Print');
ALTER TABLE `ARCHIVE_TYPE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `BODY_TYPE` WRITE;
ALTER TABLE `BODY_TYPE` DISABLE KEYS;
INSERT INTO `BODY_TYPE` VALUES (1,'Box'),(2,'Compact'),(3,'Folder'),(4,'SLR'),(5,'TLR'),(6,'Bridge'),(7,'View'),(8,'Pistol grip');
ALTER TABLE `BODY_TYPE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `EXPOSURE_PROGRAM` WRITE;
ALTER TABLE `EXPOSURE_PROGRAM` DISABLE KEYS;
INSERT INTO `EXPOSURE_PROGRAM` VALUES (0,'Fixed'),(1,'Manual'),(2,'Program AE'),(3,'Aperture-priority AE'),(4,'Shutter speed priority AE'),(5,'Creative (Slow speed)'),(6,'Action (High speed)'),(7,'Portrait'),(8,'Landscape'),(9,'Bulb');
ALTER TABLE `EXPOSURE_PROGRAM` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `FORMAT` WRITE;
ALTER TABLE `FORMAT` DISABLE KEYS;
INSERT INTO `FORMAT` VALUES (1,'120',0),(2,'135',0),(3,'620',0),(4,'APS-C',1),(5,'1/1.6\"',1),(6,'Super 8mm',0),(7,'8mm',0),(8,'Quarter plate',0),(9,'Polaroid 600',0),(10,'2.25x3.25\" sheet',0),(11,'6.5x9 sheet',0),(12,'4x5\"',0),(13,'126',0),(14,'16...
ALTER TABLE `FORMAT` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `MANUFACTURER` WRITE;
ALTER TABLE `MANUFACTURER` DISABLE KEYS;
INSERT INTO `MANUFACTURER` VALUES (1,'Boots','Nottingham','England','http://www.boots.com/',1849,NULL),(2,'Braun','Nuremberg','Germany','http://www.braun-phototechnik.de/',1915,NULL),(3,'Canon','Tokyo','Japan','http://www.canon.com/',1937,NULL),(4,'S...
ALTER TABLE `MANUFACTURER` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `METERING_TYPE` WRITE;
ALTER TABLE `METERING_TYPE` DISABLE KEYS;
INSERT INTO `METERING_TYPE` VALUES (1,'Cadmium sulphide'),(2,'Selenium'),(7,'Silicon');
ALTER TABLE `METERING_TYPE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `METERING_MODE` WRITE;
ALTER TABLE `METERING_MODE` DISABLE KEYS;
INSERT INTO `METERING_MODE` VALUES (0,'None'),(1,'Average'),(2,'Center-weighted average'),(3,'Spot'),(4,'Multi-spot'),(5,'Multi-segment'),(6,'Partial');
ALTER TABLE `METERING_MODE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `NEGATIVE_SIZE` WRITE;
ALTER TABLE `NEGATIVE_SIZE` DISABLE KEYS;
INSERT INTO `NEGATIVE_SIZE` VALUES (5,70.0,56.0,'6x7',0.48,3920,1.25),(6,56.0,56.0,'6x6',0.55,3136,1.00),(7,56.0,41.5,'6x4.5',0.62,2324,1.35),(8,84.0,56.0,'6x9',0.43,4704,1.50),(9,36.0,24.0,'35mm',1.00,864,1.50),(10,22.2,14.8,'APS-C',1.62,329,1.50),(...
ALTER TABLE `NEGATIVE_SIZE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `PROCESS` WRITE;
ALTER TABLE `PROCESS` DISABLE KEYS;
INSERT INTO `PROCESS` VALUES (1,'C41',1,0),(2,'B&W',0,0),(3,'E6',1,1),(4,'Instant',0,1),(5,'K-14',1,1),(6,'B&W Reversal',0,1),(7,'Cyanotype',0,0);
ALTER TABLE `PROCESS` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `SHUTTER_SPEED` WRITE;
ALTER TABLE `SHUTTER_SPEED` DISABLE KEYS;
INSERT INTO `SHUTTER_SPEED` VALUES ('0.3',0.30000),('0.7',0.70000),('1',1.00000),('1.5',1.50000),('1/10',0.10000),('1/100',0.01000),('1/1000',0.00100),('1/12',0.08333),('1/125',0.00800),('1/1250',0.00080),('1/15',0.06670),('1/150',0.00667),('1/1500',...
ALTER TABLE `SHUTTER_SPEED` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `SHUTTER_TYPE` WRITE;
ALTER TABLE `SHUTTER_TYPE` DISABLE KEYS;
INSERT INTO `SHUTTER_TYPE` VALUES (1,'Focal plane (horizontal travelling)'),(2,'Leaf'),(3,'Rotary'),(4,'Focal plane (vertical travelling)'),(5,'Sliding'),(6,'Ball bearing'),(7,'Electronic');
ALTER TABLE `SHUTTER_TYPE` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `FILMSTOCK` WRITE;
ALTER TABLE `FILMSTOCK` DISABLE KEYS;
INSERT INTO `FILMSTOCK` VALUES (1,6,'Reala 100',100,1,1,1),(2,9,'FP4+ 125',125,0,2,1),(3,9,'HP5+ 400',400,0,2,1),(4,6,'Acros 100',100,0,2,1),(5,6,'Neopan 1600',1600,0,2,1),(6,11,'Gold',400,1,1,1),(7,6,'S 400',400,1,1,1),(8,11,'GT 800',800,1,1,1),(9,6...
ALTER TABLE `FILMSTOCK` ENABLE KEYS;
UNLOCK TABLES;

LOCK TABLES `MOUNT` WRITE;
ALTER TABLE `MOUNT` DISABLE KEYS;
INSERT INTO `MOUNT` VALUES (1,'EF',0,0,'Bayonet','Camera','EF cameras can not take EF-S lenses',0,3),(2,'EF-S',0,0,'Bayonet','Camera','EF cameras can not take EF-S lenses',1,3),(3,'M39 Rangefinder',0,0,'Screw','Camera','Has focus flange',0,NULL),(4,'...
ALTER TABLE `MOUNT` ENABLE KEYS;
UNLOCK TABLES;

SET TIME_ZONE=@OLD_TIME_ZONE;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
SET SQL_NOTES=@OLD_SQL_NOTES;