betoesquivel

AMSS DDL Proyecto Final

Nov 11th, 2014
421
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.93 KB | None | 0 0
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server         : local
  5. Source Server Version : 50540
  6. Source Host           : localhost:3306
  7. Source Database       : eya
  8.  
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50540
  11. File Encoding         : 65001
  12.  
  13. Date: 2014-11-11 18:24:36
  14. */
  15.  
  16. -- ----------------------------
  17. -- Table structure for articulo
  18. -- ----------------------------
  19. DROP TABLE IF EXISTS `articulo`;
  20. CREATE TABLE `articulo` (
  21.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  22.   `titulo` VARCHAR(50) DEFAULT NULL,
  23.   `contenido` longtext,
  24.   `fechaEscritura` DATE NOT NULL,
  25.   `fechaPub` DATE DEFAULT NULL,
  26.   PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  28.  
  29. -- ----------------------------
  30. -- Table structure for autor
  31. -- ----------------------------
  32. DROP TABLE IF EXISTS `autor`;
  33. CREATE TABLE `autor` (
  34.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  35.   `nombre` VARCHAR(50) DEFAULT NULL,
  36.   `fechaUltimaPublicacion` DATE DEFAULT NULL,
  37.   `tipo` VARCHAR(50) NOT NULL,
  38.   PRIMARY KEY (`id`)
  39. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  40.  
  41. -- ----------------------------
  42. -- Table structure for cartaEditorJefe
  43. -- ----------------------------
  44. DROP TABLE IF EXISTS `cartaEditorJefe`;
  45. CREATE TABLE `cartaEditorJefe` (
  46.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  47.   `contenido` longtext,
  48.   `idEditor` INT(11) NOT NULL,
  49.   PRIMARY KEY (`id`)
  50. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  51.  
  52. -- ----------------------------
  53. -- Table structure for consejo
  54. -- ----------------------------
  55. DROP TABLE IF EXISTS `consejo`;
  56. CREATE TABLE `consejo` (
  57.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  58.   `fechaInicio` DATE NOT NULL,
  59.   `fechaFin` DATE DEFAULT NULL,
  60.   PRIMARY KEY (`id`)
  61. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  62.  
  63. -- ----------------------------
  64. -- Table structure for editorJefe
  65. -- ----------------------------
  66. DROP TABLE IF EXISTS `editorJefe`;
  67. CREATE TABLE `editorJefe` (
  68.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  69.   `nombre` VARCHAR(50) DEFAULT NULL,
  70.   `idConsejo` INT(11) NOT NULL,
  71.   PRIMARY KEY (`id`)
  72. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  73.  
  74. -- ----------------------------
  75. -- Table structure for guru
  76. -- ----------------------------
  77. DROP TABLE IF EXISTS `guru`;
  78. CREATE TABLE `guru` (
  79.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  80.   `nombre` VARCHAR(50) DEFAULT NULL,
  81.   `direccion` VARCHAR(255) DEFAULT NULL,
  82.   PRIMARY KEY (`id`)
  83. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  84.  
  85. -- ----------------------------
  86. -- Table structure for guruPub
  87. -- ----------------------------
  88. DROP TABLE IF EXISTS `guruPub`;
  89. CREATE TABLE `guruPub` (
  90.   `idGuru` INT(11) NOT NULL,
  91.   `idPub` INT(11) NOT NULL,
  92.   `fechaEnvio` DATE DEFAULT NULL,
  93.   PRIMARY KEY (`idGuru`,`idPub`)
  94. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  95.  
  96. -- ----------------------------
  97. -- Table structure for juez
  98. -- ----------------------------
  99. DROP TABLE IF EXISTS `juez`;
  100. CREATE TABLE `juez` (
  101.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  102.   `nombre` VARCHAR(50) DEFAULT NULL,
  103.   `idConsejo` INT(11) NOT NULL,
  104.   PRIMARY KEY (`id`)
  105. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  106.  
  107. -- ----------------------------
  108. -- Table structure for publicacion
  109. -- ----------------------------
  110. DROP TABLE IF EXISTS `publicacion`;
  111. CREATE TABLE `publicacion` (
  112.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  113.   `idJefe` INT(11) NOT NULL,
  114.   `idCarta` INT(11) NOT NULL,
  115.   `fechaPub` DATE NOT NULL,
  116.   `titulo` VARCHAR(50) NOT NULL,
  117.   `tema` VARCHAR(255) DEFAULT NULL,
  118.   PRIMARY KEY (`id`)
  119. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  120.  
  121. -- ----------------------------
  122. -- Table structure for puestoRevista
  123. -- ----------------------------
  124. DROP TABLE IF EXISTS `puestoRevistas`;
  125. CREATE TABLE `puestoRevistas` (
  126.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  127.   `direccion` VARCHAR(255) DEFAULT NULL,
  128.   PRIMARY KEY (`id`)
  129. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  130.  
  131. -- ----------------------------
  132. -- Table structure for puestoRevistasPub
  133. -- ----------------------------
  134. DROP TABLE IF EXISTS `puestoRevistasPub`;
  135. CREATE TABLE `puestoRevistasPub` (
  136.   `idPuesto` INT(11) NOT NULL,
  137.   `idPub` INT(11) NOT NULL,
  138.   `fechaEnvio` DATE DEFAULT NULL,
  139.   `cantidadEnviada` INT(11) DEFAULT NULL,
  140.   `fechaRegreso` DATE DEFAULT NULL,
  141.   `cantidadRegresada` INT(11) DEFAULT NULL,
  142.   PRIMARY KEY (`idPuesto`,`idPub`)
  143. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  144.  
  145. -- ----------------------------
  146. -- Table structure for subscripcion
  147. -- ----------------------------
  148. DROP TABLE IF EXISTS `subscripcion`;
  149. CREATE TABLE `subscripcion` (
  150.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  151.   `idSubscriptor` INT(11) NOT NULL,
  152.   `anios` INT(11) DEFAULT NULL,
  153.   `total` DOUBLE DEFAULT NULL,
  154.   PRIMARY KEY (`id`)
  155. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  156.  
  157. -- ----------------------------
  158. -- Table structure for subscriptor
  159. -- ----------------------------
  160. DROP TABLE IF EXISTS `subscriptor`;
  161. CREATE TABLE `subscriptor` (
  162.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  163.   `nombre` VARCHAR(50) NOT NULL,
  164.   `tipo` VARCHAR(30) NOT NULL,
  165.   PRIMARY KEY (`id`)
  166. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  167.  
  168. -- ----------------------------
  169. -- Table structure for subscriptorPub
  170. -- ----------------------------
  171. DROP TABLE IF EXISTS `subscriptorPub`;
  172. CREATE TABLE `subscriptorPub` (
  173.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  174.   `idSub` INT(11) NOT NULL,
  175.   `idPub` INT(11) NOT NULL,
  176.   `fechaEnvio` DATE NOT NULL,
  177.   `costoAdicional` DOUBLE DEFAULT NULL,
  178.   PRIMARY KEY (`id`,`idSub`,`idPub`)
  179. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  180.  
  181. -- ----------------------------
  182. -- Table structure for temaSugerido
  183. -- ----------------------------
  184. DROP TABLE IF EXISTS `temaSugerido`;
  185. CREATE TABLE `temaSugerido` (
  186.   `idJuez` INT(11) NOT NULL,
  187.   `idPub` INT(11) NOT NULL,
  188.   `tema` VARCHAR(255) DEFAULT NULL,
  189.   PRIMARY KEY (`idJuez`,`idPub`)
  190. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  191.  
  192.  
  193. -- ----------------------------
  194. -- Table structure for autorArticulo
  195. -- ----------------------------
  196. DROP TABLE IF EXISTS `autorArticulo`;
  197. CREATE TABLE `autorArticulo` (
  198.   `idAutor` INT(11) NOT NULL,
  199.   `idArticulo` INT(11) NOT NULL,
  200.   PRIMARY KEY (`idAutor`,`idArticulo`)
  201. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  202.  
  203.  
  204. ALTER TABLE cartaEditorJefe
  205.  
  206. ADD CONSTRAINT
  207. FOREIGN KEY (idEditor) REFERENCES editorJefe(id)
  208. ON UPDATE CASCADE
  209. ON DELETE CASCADE;
  210.  
  211.  
  212. ALTER TABLE editorJefe
  213.  
  214. ADD CONSTRAINT
  215. FOREIGN KEY (idConsejo) REFERENCES consejo(id)
  216. ON UPDATE CASCADE
  217. ON DELETE CASCADE;
  218.  
  219.  
  220. ALTER TABLE guruPub
  221.  
  222. ADD CONSTRAINT
  223. FOREIGN KEY (idGuru) REFERENCES guru(id)
  224. ON UPDATE CASCADE
  225. ON DELETE CASCADE,
  226.  
  227. ADD CONSTRAINT
  228. FOREIGN KEY (idPub) REFERENCES publicacion(id)
  229. ON UPDATE CASCADE
  230. ON DELETE CASCADE;
  231.  
  232.  
  233. ALTER TABLE juez
  234.  
  235. ADD CONSTRAINT
  236. FOREIGN KEY (idConsejo) REFERENCES consejo(id)
  237. ON UPDATE CASCADE
  238. ON DELETE CASCADE;
  239.  
  240.  
  241. ALTER TABLE publicacion
  242.  
  243. ADD CONSTRAINT
  244. FOREIGN KEY (idJefe) REFERENCES editorJefe(id)
  245. ON UPDATE CASCADE
  246. ON DELETE CASCADE,
  247.  
  248. ADD CONSTRAINT
  249. FOREIGN KEY (idCarta) REFERENCES cartaEditorJefe(id)
  250. ON UPDATE CASCADE
  251. ON DELETE CASCADE;
  252.  
  253.  
  254. ALTER TABLE puestoRevistasPub
  255.  
  256. ADD CONSTRAINT
  257. FOREIGN KEY (idPuesto) REFERENCES puestoRevistas(id)
  258. ON UPDATE CASCADE
  259. ON DELETE CASCADE,
  260.  
  261. ADD CONSTRAINT
  262. FOREIGN KEY (idPub) REFERENCES publicacion(id)
  263. ON UPDATE CASCADE
  264. ON DELETE CASCADE;
  265.  
  266.  
  267. ALTER TABLE subscripcion
  268.  
  269. ADD CONSTRAINT
  270. FOREIGN KEY (idSubscriptor) REFERENCES subscriptor(id)
  271. ON UPDATE CASCADE
  272. ON DELETE CASCADE;
  273.  
  274.  
  275. ALTER TABLE subscriptorPub
  276.  
  277. ADD CONSTRAINT
  278. FOREIGN KEY (idSub) REFERENCES subscriptor(id)
  279. ON UPDATE CASCADE
  280. ON DELETE CASCADE,
  281.  
  282. ADD CONSTRAINT
  283. FOREIGN KEY (idPub) REFERENCES publicacion(id)
  284. ON UPDATE CASCADE
  285. ON DELETE CASCADE;
  286.  
  287.  
  288. ALTER TABLE temaSugerido
  289.  
  290. ADD CONSTRAINT
  291. FOREIGN KEY (idPub) REFERENCES publicacion(id)
  292. ON UPDATE CASCADE
  293. ON DELETE CASCADE,
  294.  
  295. ADD CONSTRAINT
  296. FOREIGN KEY (idJuez) REFERENCES juez(id)
  297. ON UPDATE CASCADE
  298. ON DELETE CASCADE;
  299.  
  300.  
  301. ALTER TABLE autorArticulo
  302.  
  303. ADD CONSTRAINT
  304. FOREIGN KEY (idAutor) REFERENCES autor(id)
  305. ON UPDATE CASCADE
  306. ON DELETE CASCADE,
  307.  
  308. ADD CONSTRAINT
  309. FOREIGN KEY (idArticulo) REFERENCES articulo(id)
  310. ON UPDATE CASCADE
  311. ON DELETE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment