Author: hsanchez Date: 2007-04-30 16:40:11 -0300 (Mon, 30 Apr 2007) New Revision: 4592 Modified: prosistem/alba/trunk/alba/config/schema.xml prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql Log: Agregando campo al responsable para relacionar con el rol Modified: prosistem/alba/trunk/alba/config/schema.xml =================================================================== --- prosistem/alba/trunk/alba/config/schema.xml 2007-04-30 19:34:36 UTC (rev 4591) +++ prosistem/alba/trunk/alba/config/schema.xml 2007-04-30 19:40:11 UTC (rev 4592) @@ -285,6 +285,7 @@ <column name="observacion" type="VARCHAR" size="255" required="false" default=""/> <column name="autorizacion_retiro" type="boolean" required="true" default="false"/> <column name="fk_cuenta_id" type="INTEGER" required="true" default="0"/> + <column name="fk_rolresponsable_id" type="INTEGER" required="true" default="1"/> <foreign-key foreignTable="cuenta"> <reference local="fk_cuenta_id" foreign="id"/> </foreign-key> @@ -294,6 +295,9 @@ <foreign-key foreignTable="tipodocumento"> <reference local="fk_tipodocumento_id" foreign="id"/> </foreign-key> + <foreign-key foreignTable="rol_responsable"> + <reference local="fk_rolresponsable_id" foreign="id"/> + </foreign-key> </table> <table name="ciclolectivo" idMethod="native"> <column name="id" type="integer" size="11" required="true" autoIncrement="true" primaryKey="true"/> 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-30 19:34:36 UTC (rev 4591) +++ prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql 2007-04-30 19:40:11 UTC (rev 4592) @@ -56,5 +56,6 @@ REFERENCES `responsable` (`id`) )Type=InnoDB; +ALTER TABLE responsable ADD COLUMN fk_rolresponsable_id INT NOT NULL DEFAULT 1; SET FOREIGN_KEY_CHECKS = 1;