Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Navicat MySQL Data Transfer
- Source Server : local
- Source Server Version : 50540
- Source Host : localhost:3306
- Source Database : eya
- Target Server Type : MYSQL
- Target Server Version : 50540
- File Encoding : 65001
- Date: 2014-11-11 18:24:36
- */
- -- ----------------------------
- -- Table structure for articulo
- -- ----------------------------
- DROP TABLE IF EXISTS `articulo`;
- CREATE TABLE `articulo` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `titulo` VARCHAR(50) DEFAULT NULL,
- `contenido` longtext,
- `fechaEscritura` DATE NOT NULL,
- `fechaPub` DATE DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for autor
- -- ----------------------------
- DROP TABLE IF EXISTS `autor`;
- CREATE TABLE `autor` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) DEFAULT NULL,
- `fechaUltimaPublicacion` DATE DEFAULT NULL,
- `tipo` VARCHAR(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for cartaEditorJefe
- -- ----------------------------
- DROP TABLE IF EXISTS `cartaEditorJefe`;
- CREATE TABLE `cartaEditorJefe` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `contenido` longtext,
- `idEditor` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for consejo
- -- ----------------------------
- DROP TABLE IF EXISTS `consejo`;
- CREATE TABLE `consejo` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `fechaInicio` DATE NOT NULL,
- `fechaFin` DATE DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for editorJefe
- -- ----------------------------
- DROP TABLE IF EXISTS `editorJefe`;
- CREATE TABLE `editorJefe` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) DEFAULT NULL,
- `idConsejo` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for guru
- -- ----------------------------
- DROP TABLE IF EXISTS `guru`;
- CREATE TABLE `guru` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) DEFAULT NULL,
- `direccion` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for guruPub
- -- ----------------------------
- DROP TABLE IF EXISTS `guruPub`;
- CREATE TABLE `guruPub` (
- `idGuru` INT(11) NOT NULL,
- `idPub` INT(11) NOT NULL,
- `fechaEnvio` DATE DEFAULT NULL,
- PRIMARY KEY (`idGuru`,`idPub`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for juez
- -- ----------------------------
- DROP TABLE IF EXISTS `juez`;
- CREATE TABLE `juez` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) DEFAULT NULL,
- `idConsejo` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for publicacion
- -- ----------------------------
- DROP TABLE IF EXISTS `publicacion`;
- CREATE TABLE `publicacion` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `idJefe` INT(11) NOT NULL,
- `idCarta` INT(11) NOT NULL,
- `fechaPub` DATE NOT NULL,
- `titulo` VARCHAR(50) NOT NULL,
- `tema` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for puestoRevista
- -- ----------------------------
- DROP TABLE IF EXISTS `puestoRevistas`;
- CREATE TABLE `puestoRevistas` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `direccion` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for puestoRevistasPub
- -- ----------------------------
- DROP TABLE IF EXISTS `puestoRevistasPub`;
- CREATE TABLE `puestoRevistasPub` (
- `idPuesto` INT(11) NOT NULL,
- `idPub` INT(11) NOT NULL,
- `fechaEnvio` DATE DEFAULT NULL,
- `cantidadEnviada` INT(11) DEFAULT NULL,
- `fechaRegreso` DATE DEFAULT NULL,
- `cantidadRegresada` INT(11) DEFAULT NULL,
- PRIMARY KEY (`idPuesto`,`idPub`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for subscripcion
- -- ----------------------------
- DROP TABLE IF EXISTS `subscripcion`;
- CREATE TABLE `subscripcion` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `idSubscriptor` INT(11) NOT NULL,
- `anios` INT(11) DEFAULT NULL,
- `total` DOUBLE DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for subscriptor
- -- ----------------------------
- DROP TABLE IF EXISTS `subscriptor`;
- CREATE TABLE `subscriptor` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(50) NOT NULL,
- `tipo` VARCHAR(30) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for subscriptorPub
- -- ----------------------------
- DROP TABLE IF EXISTS `subscriptorPub`;
- CREATE TABLE `subscriptorPub` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `idSub` INT(11) NOT NULL,
- `idPub` INT(11) NOT NULL,
- `fechaEnvio` DATE NOT NULL,
- `costoAdicional` DOUBLE DEFAULT NULL,
- PRIMARY KEY (`id`,`idSub`,`idPub`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for temaSugerido
- -- ----------------------------
- DROP TABLE IF EXISTS `temaSugerido`;
- CREATE TABLE `temaSugerido` (
- `idJuez` INT(11) NOT NULL,
- `idPub` INT(11) NOT NULL,
- `tema` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`idJuez`,`idPub`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Table structure for autorArticulo
- -- ----------------------------
- DROP TABLE IF EXISTS `autorArticulo`;
- CREATE TABLE `autorArticulo` (
- `idAutor` INT(11) NOT NULL,
- `idArticulo` INT(11) NOT NULL,
- PRIMARY KEY (`idAutor`,`idArticulo`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- ALTER TABLE cartaEditorJefe
- ADD CONSTRAINT
- FOREIGN KEY (idEditor) REFERENCES editorJefe(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE editorJefe
- ADD CONSTRAINT
- FOREIGN KEY (idConsejo) REFERENCES consejo(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE guruPub
- ADD CONSTRAINT
- FOREIGN KEY (idGuru) REFERENCES guru(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idPub) REFERENCES publicacion(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE juez
- ADD CONSTRAINT
- FOREIGN KEY (idConsejo) REFERENCES consejo(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE publicacion
- ADD CONSTRAINT
- FOREIGN KEY (idJefe) REFERENCES editorJefe(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idCarta) REFERENCES cartaEditorJefe(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE puestoRevistasPub
- ADD CONSTRAINT
- FOREIGN KEY (idPuesto) REFERENCES puestoRevistas(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idPub) REFERENCES publicacion(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE subscripcion
- ADD CONSTRAINT
- FOREIGN KEY (idSubscriptor) REFERENCES subscriptor(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE subscriptorPub
- ADD CONSTRAINT
- FOREIGN KEY (idSub) REFERENCES subscriptor(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idPub) REFERENCES publicacion(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE temaSugerido
- ADD CONSTRAINT
- FOREIGN KEY (idPub) REFERENCES publicacion(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idJuez) REFERENCES juez(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
- ALTER TABLE autorArticulo
- ADD CONSTRAINT
- FOREIGN KEY (idAutor) REFERENCES autor(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE,
- ADD CONSTRAINT
- FOREIGN KEY (idArticulo) REFERENCES articulo(id)
- ON UPDATE CASCADE
- ON DELETE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment