Script Camara Diputado

lunes, 19 de noviembre de 2012 23:41

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS =0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ; USE `mydb` ; -- ------------------------------------------------------ Table`mydb`.`Partido` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `mydb`.`Partido` ( `IdPartido` INT NOT NULL , `Nombre` VARCHAR(45) NULL , `No_Militantes` INT NULL , PRIMARY KEY (`IdPartido`) ) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Camara` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS`mydb`.`Camara` ( `IdCamara` INT NOT NULL , `Id_Iniciativa` INT NULL , `Tipo_Camara` TINYINT(2) NULL , `Nombre_Camara` VARCHAR(45) NULL , `Direccion_Camara` VARCHAR(45) NULL , PRIMARY KEY (`IdCamara`) , INDEX `Fk_Id_Iniciativa` (`Id_Iniciativa` ASC) , CONSTRAINT `Fk_Id_Iniciativa` FOREIGN KEY (`Id_Iniciativa` ) REFERENCES `mydb`.`Iniciativa` (`idIniciativa` ) ON DELETE NO ACTION ON UPDATE NOACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Tramite` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `mydb`.`Tramite` (
-1-

C:\Users\Franz\Desktop\ScriptCamaraDeDiputado.sql

lunes, 19 de noviembre de 2012 23:41

`Id_Tramite` INT NOT NULL , `Id_Camara` INT NULL , `Fecha_Tramite` DATETIME NULL ,`Cumple_Formato` VARCHAR(45) NULL , PRIMARY KEY (`Id_Tramite`) , INDEX `Fk_Id_Camara` (`Id_Camara` ASC) , CONSTRAINT `Fk_Id_Camara` FOREIGN KEY (`Id_Camara` ) REFERENCES `mydb`.`Camara` (`IdCamara` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Iniciativa` -- ----------------------------------------------------CREATE TABLE IFNOT EXISTS `mydb`.`Iniciativa` ( `idIniciativa` INT NOT NULL , `Id_Partido` INT NULL , `No_Validantes` INT NULL , `Id_Tramite` INT NULL , `Id_Camara` INT NULL , PRIMARY KEY (`idIniciativa`) , INDEX `FK_ID_partido` (`Id_Partido` ASC) , INDEX `FK_ID_Tramite` (`Id_Tramite` ASC) , INDEX `FK_Id_Camara` (`Id_Camara` ASC) , CONSTRAINT `FK_ID_partido` FOREIGN KEY (`Id_Partido` ) REFERENCES`mydb`.`Partido` (`IdPartido` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_ID_Tramite` FOREIGN KEY (`Id_Tramite` ) REFERENCES `mydb`.`Tramite` (`Id_Tramite` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Id_Camara` FOREIGN KEY (`Id_Camara` ) REFERENCES `mydb`.`Camara` (`IdCamara` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
-2-C:\Users\Franz\Desktop\ScriptCamaraDeDiputado.sql

lunes, 19 de noviembre de 2012 23:41

-- ------------------------------------------------------ Table `mydb`.`Discusion` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `mydb`.`Discusion` ( `Id_Discusion` INT NOT NULL , `Id_Estudio` INT NULL , `Acuerdo` VARCHAR(45) NULL , `Id_Iniciativa` INT NULL , `Fecha_Discusion` DATETIME NULL , `Quorum` INT NULL, PRIMARY KEY (`Id_Discusion`) , INDEX `Fk_id_Estudio` (`Id_Estudio` ASC) , INDEX `Fk_id_Iniciativa` (`Id_Iniciativa` ASC) , CONSTRAINT `Fk_id_Estudio` FOREIGN KEY (`Id_Estudio` ) REFERENCES `mydb`.`Estudio` (`Id_Estudio` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `Fk_id_Iniciativa` FOREIGN KEY (`Id_Iniciativa` ) REFERENCES `mydb`.`Iniciativa` (`idIniciativa` ) ON DELETE NO ACTION ONUPDATE NO ACTION) ENGINE = InnoDB; -- ------------------------------------------------------ Table `mydb`.`Votacion` -- ----------------------------------------------------CREATE TABLE IF NOT EXISTS `mydb`.`Votacion` ( `Id_Votacion` INT NOT NULL , `Id_Camara` INT NULL , `Id_Iniciativa` INT NULL , `Aprobada` TINYINT(2) NULL , PRIMARY KEY (`Id_Votacion`) , INDEX `Fk_ID_camara` (`Id_Camara` ASC) ,...