Author: hsanchez Date: 2007-04-30 17:03:02 -0300 (Mon, 30 Apr 2007) New Revision: 4595 Modified: prosistem/alba/trunk/alba/data/sql/schema.sql Log: Agregando relacion con roles de responsables Modified: prosistem/alba/trunk/alba/data/sql/schema.sql =================================================================== --- prosistem/alba/trunk/alba/data/sql/schema.sql 2007-04-30 20:01:28 UTC (rev 4594) +++ prosistem/alba/trunk/alba/data/sql/schema.sql 2007-04-30 20:03:02 UTC (rev 4595) @@ -537,6 +537,7 @@ `observacion` VARCHAR(255) default '', `autorizacion_retiro` INTEGER default 0 NOT NULL, `fk_cuenta_id` INTEGER default 0 NOT NULL, + `fk_rolresponsable_id` INTEGER default 1 NOT NULL, PRIMARY KEY (`id`), INDEX `responsable_FI_1` (`fk_cuenta_id`), CONSTRAINT `responsable_FK_1` @@ -549,7 +550,11 @@ INDEX `responsable_FI_3` (`fk_tipodocumento_id`), CONSTRAINT `responsable_FK_3` FOREIGN KEY (`fk_tipodocumento_id`) - REFERENCES `tipodocumento` (`id`) + REFERENCES `tipodocumento` (`id`), + INDEX `responsable_FI_4` (`fk_rolresponsable_id`), + CONSTRAINT `responsable_FK_4` + FOREIGN KEY (`fk_rolresponsable_id`) + REFERENCES `rol_responsable` (`id`) )Type=InnoDB; #-----------------------------------------------------------------------------