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

Lun Abr 30 22:03:03 CEST 2007

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;
 
 #-----------------------------------------------------------------------------


