Author: hsanchez Date: 2007-12-26 17:45:14 -0300 (Wed, 26 Dec 2007) New Revision: 5359 Added: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0_luego.sql Removed: prosistem/alba/trunk/alba/data/sql/actualizacion_luego_1.0.sql Log: Corrigiendo el orden del nombre en el archivo Copied: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0_luego.sql (from rev 5355, prosistem/alba/trunk/alba/data/sql/actualizacion_luego_1.0.sql) =================================================================== --- prosistem/alba/trunk/alba/data/sql/actualizacion_1.0_luego.sql (rev 0) +++ prosistem/alba/trunk/alba/data/sql/actualizacion_1.0_luego.sql 2007-12-26 20:45:14 UTC (rev 5359) @@ -0,0 +1,44 @@ +SET CHARACTER SET utf8; +SET FOREIGN_KEY_CHECKS = 0; + + +DROP TABLE IF EXISTS `informe`; + + +CREATE TABLE `informe` +( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `nombre` VARCHAR(128) NOT NULL, + `descripcion` VARCHAR(255), + `fk_adjunto_id` INTEGER(11) NOT NULL, + `fk_tipoinforme_id` INTEGER(11) NOT NULL, + `listado` INTEGER default 0 NOT NULL, + `variables` VARCHAR(128), + PRIMARY KEY (`id`), + INDEX `informe_FI_1` (`fk_adjunto_id`), + CONSTRAINT `informe_FK_1` + FOREIGN KEY (`fk_adjunto_id`) + REFERENCES `adjunto` (`id`), + INDEX `informe_FI_2` (`fk_tipoinforme_id`), + CONSTRAINT `informe_FK_2` + FOREIGN KEY (`fk_tipoinforme_id`) + REFERENCES `tipoinforme` (`id`) +)Type=InnoDB; + +#----------------------------------------------------------------------------- +#-- tipoinforme +#----------------------------------------------------------------------------- + +DROP TABLE IF EXISTS `tipoinforme`; + + +CREATE TABLE `tipoinforme` +( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `nombre` VARCHAR(128) NOT NULL, + `descripcion` VARCHAR(255), + PRIMARY KEY (`id`) +)Type=InnoDB; + +# This restores the fkey checks, after having unset them earlier +SET FOREIGN_KEY_CHECKS = 1; Deleted: prosistem/alba/trunk/alba/data/sql/actualizacion_luego_1.0.sql =================================================================== --- prosistem/alba/trunk/alba/data/sql/actualizacion_luego_1.0.sql 2007-12-26 20:43:21 UTC (rev 5358) +++ prosistem/alba/trunk/alba/data/sql/actualizacion_luego_1.0.sql 2007-12-26 20:45:14 UTC (rev 5359) @@ -1,44 +0,0 @@ -SET CHARACTER SET utf8; -SET FOREIGN_KEY_CHECKS = 0; - - -DROP TABLE IF EXISTS `informe`; - - -CREATE TABLE `informe` -( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `nombre` VARCHAR(128) NOT NULL, - `descripcion` VARCHAR(255), - `fk_adjunto_id` INTEGER(11) NOT NULL, - `fk_tipoinforme_id` INTEGER(11) NOT NULL, - `listado` INTEGER default 0 NOT NULL, - `variables` VARCHAR(128), - PRIMARY KEY (`id`), - INDEX `informe_FI_1` (`fk_adjunto_id`), - CONSTRAINT `informe_FK_1` - FOREIGN KEY (`fk_adjunto_id`) - REFERENCES `adjunto` (`id`), - INDEX `informe_FI_2` (`fk_tipoinforme_id`), - CONSTRAINT `informe_FK_2` - FOREIGN KEY (`fk_tipoinforme_id`) - REFERENCES `tipoinforme` (`id`) -)Type=InnoDB; - -#----------------------------------------------------------------------------- -#-- tipoinforme -#----------------------------------------------------------------------------- - -DROP TABLE IF EXISTS `tipoinforme`; - - -CREATE TABLE `tipoinforme` -( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `nombre` VARCHAR(128) NOT NULL, - `descripcion` VARCHAR(255), - PRIMARY KEY (`id`) -)Type=InnoDB; - -# This restores the fkey checks, after having unset them earlier -SET FOREIGN_KEY_CHECKS = 1;