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

Vie Feb 16 15:43:08 CET 2007

Author: ftoledo
Date: 2007-02-16 11:43:06 -0300 (Fri, 16 Feb 2007)
New Revision: 4230

Modified:
   prosistem/alba/trunk/alba/data/sql/schema.sql
Log:
build del ultimo schema


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

--- prosistem/alba/trunk/alba/data/sql/schema.sql	2007-02-16 14:22:09 UTC (rev 4229)
+++ prosistem/alba/trunk/alba/data/sql/schema.sql	2007-02-16 14:43:06 UTC (rev 4230)
@@ -470,6 +470,7 @@
 	`codigo_postal` VARCHAR(20) default '' NOT NULL,
 	`fk_provincia_id` INTEGER default 0 NOT NULL,
 	`telefono` VARCHAR(20) default '',
+	`lugar_nacimiento` VARCHAR(128) default '',
 	`fk_tipodocumento_id` INTEGER(11) default 0 NOT NULL,
 	`nro_documento` VARCHAR(16) default '' NOT NULL,
 	`sexo` CHAR(1) default '' NOT NULL,
@@ -482,6 +483,7 @@
 	`certificado_medico` INTEGER default 0 NOT NULL,
 	`activo` INTEGER default 1 NOT NULL,
 	`fk_conceptobaja_id` INTEGER default 0 NOT NULL,
+	`fk_pais_id` INTEGER default 0 NOT NULL,
 	PRIMARY KEY (`id`),
 	INDEX `alumno_FI_1` (`fk_tipodocumento_id`),
 	CONSTRAINT `alumno_FK_1`
@@ -502,7 +504,11 @@
 	INDEX `alumno_FI_5` (`fk_conceptobaja_id`),
 	CONSTRAINT `alumno_FK_5`
 		FOREIGN KEY (`fk_conceptobaja_id`)
-		REFERENCES `conceptobaja` (`id`)
+		REFERENCES `conceptobaja` (`id`),
+	INDEX `alumno_FI_6` (`fk_pais_id`),
+	CONSTRAINT `alumno_FK_6`
+		FOREIGN KEY (`fk_pais_id`)
+		REFERENCES `pais` (`id`)
 )Type=InnoDB;
 
 #-----------------------------------------------------------------------------


