Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Navicat MySQL Data Transfer
- Source Server : OVH.Server
- Source Server Version : 50541
- Source Host : localhost:3306
- Source Database : dva
- Target Server Type : MYSQL
- Target Server Version : 50541
- File Encoding : 65001
- Date: 2015-04-19 21:02:02
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for verwaltung_genre
- -- ----------------------------
- DROP TABLE IF EXISTS `verwaltung_genre`;
- CREATE TABLE `verwaltung_genre` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `genrename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `genrename` (`genrename`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of verwaltung_genre
- -- ----------------------------
- INSERT INTO `verwaltung_genre` VALUES ('2', 'Abenteuerfilm');
- INSERT INTO `verwaltung_genre` VALUES ('1', 'Actionfilm');
- INSERT INTO `verwaltung_genre` VALUES ('4', 'Dokumentation');
- INSERT INTO `verwaltung_genre` VALUES ('3', 'Drama');
- INSERT INTO `verwaltung_genre` VALUES ('5', 'Horrorfilm');
- INSERT INTO `verwaltung_genre` VALUES ('6', 'Kinderfilm');
- INSERT INTO `verwaltung_genre` VALUES ('8', 'Kriegsfilm');
- INSERT INTO `verwaltung_genre` VALUES ('7', 'Kriminalfim');
- -- ----------------------------
- -- Table structure for verwaltung_media
- -- ----------------------------
- DROP TABLE IF EXISTS `verwaltung_media`;
- CREATE TABLE `verwaltung_media` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `titel` varchar(255) NOT NULL,
- `publisherid` int(255) NOT NULL,
- `erscheinungsjahr` int(4) NOT NULL,
- `genereid` int(255) NOT NULL,
- `mediatypeid` int(255) NOT NULL,
- `regal` int(255) NOT NULL,
- `regalplatz` int(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `regal` (`regal`,`regalplatz`) USING BTREE,
- KEY `publisherid` (`publisherid`),
- KEY `genereid` (`genereid`),
- KEY `mediatypeid` (`mediatypeid`),
- CONSTRAINT `verwaltung_media_ibfk_1` FOREIGN KEY (`publisherid`) REFERENCES `verwaltung_publisher` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT `verwaltung_media_ibfk_2` FOREIGN KEY (`genereid`) REFERENCES `verwaltung_publisher` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT `verwaltung_media_ibfk_3` FOREIGN KEY (`mediatypeid`) REFERENCES `verwaltung_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of verwaltung_media
- -- ----------------------------
- INSERT INTO `verwaltung_media` VALUES ('1', 'Harry Potter und der Stein der Weisen', '5', '2001', '2', '3', '1', '1');
- INSERT INTO `verwaltung_media` VALUES ('3', 'Avatar', '3', '2009', '1', '5', '1', '2');
- -- ----------------------------
- -- Table structure for verwaltung_publisher
- -- ----------------------------
- DROP TABLE IF EXISTS `verwaltung_publisher`;
- CREATE TABLE `verwaltung_publisher` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `publishername` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `publishername` (`publishername`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of verwaltung_publisher
- -- ----------------------------
- INSERT INTO `verwaltung_publisher` VALUES ('2', 'Metro Goldwyn Mayer');
- INSERT INTO `verwaltung_publisher` VALUES ('7', 'Paramount');
- INSERT INTO `verwaltung_publisher` VALUES ('4', 'Paramount Studios');
- INSERT INTO `verwaltung_publisher` VALUES ('3', 'Twentieth Century Fox');
- INSERT INTO `verwaltung_publisher` VALUES ('1', 'Universal');
- INSERT INTO `verwaltung_publisher` VALUES ('6', 'Walt Disney');
- INSERT INTO `verwaltung_publisher` VALUES ('5', 'Warner Bros');
- -- ----------------------------
- -- Table structure for verwaltung_type
- -- ----------------------------
- DROP TABLE IF EXISTS `verwaltung_type`;
- CREATE TABLE `verwaltung_type` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `mediatypename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `mediatypename` (`mediatypename`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of verwaltung_type
- -- ----------------------------
- INSERT INTO `verwaltung_type` VALUES ('5', '3D Blu-ray');
- INSERT INTO `verwaltung_type` VALUES ('3', 'Blu-ray');
- INSERT INTO `verwaltung_type` VALUES ('1', 'CD');
- INSERT INTO `verwaltung_type` VALUES ('2', 'DVD');
- INSERT INTO `verwaltung_type` VALUES ('4', 'HDDVD');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement