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;