[Alba-desarrollo] SVN Alba r4592 - in prosistem/alba/trunk/alba: config data/sql

Lun Abr 30 21:40:12 CEST 2007

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;
 


