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

Mie Abr 25 22:45:52 CEST 2007

Author: hsanchez
Date: 2007-04-25 17:45:49 -0300 (Wed, 25 Apr 2007)
New Revision: 4577

Modified:
   prosistem/alba/trunk/alba/data/sql/schema.sql
Log:
Agregando al schema la tabla para relacionar rolresponsables con responsables

Modified: prosistem/alba/trunk/alba/data/sql/schema.sql
===================================================================

--- prosistem/alba/trunk/alba/data/sql/schema.sql	2007-04-25 18:59:20 UTC (rev 4576)
+++ prosistem/alba/trunk/alba/data/sql/schema.sql	2007-04-25 20:45:49 UTC (rev 4577)
@@ -1413,5 +1413,29 @@
 	PRIMARY KEY (`id`)
 )Type=InnoDB;
 
+#-----------------------------------------------------------------------------
+#-- rel_rolresponsable_responsable
+#-----------------------------------------------------------------------------
+
+DROP TABLE IF EXISTS `rel_rolresponsable_responsable`;
+
+
+CREATE TABLE `rel_rolresponsable_responsable`
+(
+	`id` INTEGER(11)  NOT NULL AUTO_INCREMENT,
+	`fk_rolresponsable_id` INTEGER(11) default 0 NOT NULL,
+	`fk_responsable_id` INTEGER(11) default 0 NOT NULL,
+	`descripcion` VARCHAR(255) default '',
+	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;
+
 # This restores the fkey checks, after having unset them earlier
 SET FOREIGN_KEY_CHECKS = 1;


