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;