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

[commits en pressenter.com.ar]

Author: hsanchez
Date: 2007-04-25 18:11:32 -0300 (Wed, 25 Apr 2007)
New Revision: 4585

Modified:
   prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql
Log:
Agregando tabla rel_rolresponsable_responsable

Modified: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql
===================================================================
--- prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql	2007-04-25 20:55:19 UTC (rev 4584)
+++ prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql	2007-04-25 21:11:32 UTC (rev 4585)
@@ -39,5 +39,22 @@
     PRIMARY KEY (`id`)
 )Type=InnoDB;
 
+CREATE TABLE `rel_rolresponsable_responsable` 
+(      
+    `id` INTEGER  NOT NULL AUTO_INCREMENT,      
+    `fk_rolresponsable_id` INTEGER default 0 NOT NULL,      
+    `fk_responsable_id` INTEGER default 0 NOT NULL,      
+    `descripcion` VARCHAR(255) default "" NOT NULL,      
+    PRIMARY KEY (`id`),      
+    INDEX `rel_rolresponsable_responsable_FI_1` (`fk_rolresponsable_id`),      
+        CONSTRAINT `rel_rolresponsable_responsable_FK_1`         
+        FOREIGN KEY (`fk_rolresponsable_id`)         
+        REFERENCES `rol_responsable` (`id`),    
+    INDEX `rel_rolresponsable_responsable_FI_2` (`fk_responsable_id`),      
+        CONSTRAINT `rel_rolresponsable_responsable_FK_2`         
+        FOREIGN KEY (`fk_responsable_id`)       
+        REFERENCES `responsable` (`id`)  
+)Type=InnoDB;
+
 SET FOREIGN_KEY_CHECKS = 1;