[Alba-desarrollo] SVN Alba r5359 - prosistem/alba/trunk/alba/data/sql

Mie Dic 26 21:45:14 CET 2007

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;


