Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.45 KB | None | 0 0
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server : OVH.Server
  5. Source Server Version : 50541
  6. Source Host : localhost:3306
  7. Source Database : dva
  8.  
  9. Target Server Type : MYSQL
  10. Target Server Version : 50541
  11. File Encoding : 65001
  12.  
  13. Date: 2015-04-19 21:02:02
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17.  
  18. -- ----------------------------
  19. -- Table structure for verwaltung_genre
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `verwaltung_genre`;
  22. CREATE TABLE `verwaltung_genre` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT,
  24. `genrename` varchar(255) NOT NULL,
  25. PRIMARY KEY (`id`),
  26. UNIQUE KEY `genrename` (`genrename`) USING BTREE
  27. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  28.  
  29. -- ----------------------------
  30. -- Records of verwaltung_genre
  31. -- ----------------------------
  32. INSERT INTO `verwaltung_genre` VALUES ('2', 'Abenteuerfilm');
  33. INSERT INTO `verwaltung_genre` VALUES ('1', 'Actionfilm');
  34. INSERT INTO `verwaltung_genre` VALUES ('4', 'Dokumentation');
  35. INSERT INTO `verwaltung_genre` VALUES ('3', 'Drama');
  36. INSERT INTO `verwaltung_genre` VALUES ('5', 'Horrorfilm');
  37. INSERT INTO `verwaltung_genre` VALUES ('6', 'Kinderfilm');
  38. INSERT INTO `verwaltung_genre` VALUES ('8', 'Kriegsfilm');
  39. INSERT INTO `verwaltung_genre` VALUES ('7', 'Kriminalfim');
  40.  
  41. -- ----------------------------
  42. -- Table structure for verwaltung_media
  43. -- ----------------------------
  44. DROP TABLE IF EXISTS `verwaltung_media`;
  45. CREATE TABLE `verwaltung_media` (
  46. `id` int(11) NOT NULL AUTO_INCREMENT,
  47. `titel` varchar(255) NOT NULL,
  48. `publisherid` int(255) NOT NULL,
  49. `erscheinungsjahr` int(4) NOT NULL,
  50. `genereid` int(255) NOT NULL,
  51. `mediatypeid` int(255) NOT NULL,
  52. `regal` int(255) NOT NULL,
  53. `regalplatz` int(255) NOT NULL,
  54. PRIMARY KEY (`id`),
  55. UNIQUE KEY `regal` (`regal`,`regalplatz`) USING BTREE,
  56. KEY `publisherid` (`publisherid`),
  57. KEY `genereid` (`genereid`),
  58. KEY `mediatypeid` (`mediatypeid`),
  59. CONSTRAINT `verwaltung_media_ibfk_1` FOREIGN KEY (`publisherid`) REFERENCES `verwaltung_publisher` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  60. CONSTRAINT `verwaltung_media_ibfk_2` FOREIGN KEY (`genereid`) REFERENCES `verwaltung_publisher` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  61. CONSTRAINT `verwaltung_media_ibfk_3` FOREIGN KEY (`mediatypeid`) REFERENCES `verwaltung_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  62. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  63.  
  64. -- ----------------------------
  65. -- Records of verwaltung_media
  66. -- ----------------------------
  67. INSERT INTO `verwaltung_media` VALUES ('1', 'Harry Potter und der Stein der Weisen', '5', '2001', '2', '3', '1', '1');
  68. INSERT INTO `verwaltung_media` VALUES ('3', 'Avatar', '3', '2009', '1', '5', '1', '2');
  69.  
  70. -- ----------------------------
  71. -- Table structure for verwaltung_publisher
  72. -- ----------------------------
  73. DROP TABLE IF EXISTS `verwaltung_publisher`;
  74. CREATE TABLE `verwaltung_publisher` (
  75. `id` int(11) NOT NULL AUTO_INCREMENT,
  76. `publishername` varchar(255) NOT NULL,
  77. PRIMARY KEY (`id`),
  78. UNIQUE KEY `publishername` (`publishername`) USING BTREE
  79. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  80.  
  81. -- ----------------------------
  82. -- Records of verwaltung_publisher
  83. -- ----------------------------
  84. INSERT INTO `verwaltung_publisher` VALUES ('2', 'Metro Goldwyn Mayer');
  85. INSERT INTO `verwaltung_publisher` VALUES ('7', 'Paramount');
  86. INSERT INTO `verwaltung_publisher` VALUES ('4', 'Paramount Studios');
  87. INSERT INTO `verwaltung_publisher` VALUES ('3', 'Twentieth Century Fox');
  88. INSERT INTO `verwaltung_publisher` VALUES ('1', 'Universal');
  89. INSERT INTO `verwaltung_publisher` VALUES ('6', 'Walt Disney');
  90. INSERT INTO `verwaltung_publisher` VALUES ('5', 'Warner Bros');
  91.  
  92. -- ----------------------------
  93. -- Table structure for verwaltung_type
  94. -- ----------------------------
  95. DROP TABLE IF EXISTS `verwaltung_type`;
  96. CREATE TABLE `verwaltung_type` (
  97. `id` int(11) NOT NULL AUTO_INCREMENT,
  98. `mediatypename` varchar(255) NOT NULL,
  99. PRIMARY KEY (`id`),
  100. UNIQUE KEY `mediatypename` (`mediatypename`) USING BTREE
  101. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  102.  
  103. -- ----------------------------
  104. -- Records of verwaltung_type
  105. -- ----------------------------
  106. INSERT INTO `verwaltung_type` VALUES ('5', '3D Blu-ray');
  107. INSERT INTO `verwaltung_type` VALUES ('3', 'Blu-ray');
  108. INSERT INTO `verwaltung_type` VALUES ('1', 'CD');
  109. INSERT INTO `verwaltung_type` VALUES ('2', 'DVD');
  110. INSERT INTO `verwaltung_type` VALUES ('4', 'HDDVD');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement