[Alba-desarrollo] SVN Alba r4578 - prosistem/alba/trunk/alba/config

Mie Abr 25 22:46:32 CEST 2007

Author: hsanchez
Date: 2007-04-25 17:46:30 -0300 (Wed, 25 Apr 2007)
New Revision: 4578

Modified:
   prosistem/alba/trunk/alba/config/schema.xml
Log:
Agregando tabla al schema

Modified: prosistem/alba/trunk/alba/config/schema.xml
===================================================================

--- prosistem/alba/trunk/alba/config/schema.xml	2007-04-25 20:45:49 UTC (rev 4577)
+++ prosistem/alba/trunk/alba/config/schema.xml	2007-04-25 20:46:30 UTC (rev 4578)
@@ -741,4 +741,16 @@
         <column name="recurrencia_dias" type="INTEGER" required="true" default="0"/>
         <column name="estado" type="INTEGER" required="true" default="0"/>
     </table>
+    <table name="rel_rolresponsable_responsable" idMethod="native">
+        <column name="id" type="INTEGER" size="11" required="true" autoIncrement="true" primaryKey="true"/>
+        <column name="fk_rolresponsable_id" type="INTEGER" size="11" required="true" default="0"/>
+        <column name="fk_responsable_id" type="INTEGER" size="11" required="true" default="0"/>
+        <column name="descripcion" type="VARCHAR" size="255" default=""/>
+        <foreign-key foreignTable="rol_responsable">
+            <reference local="fk_rolresponsable_id" foreign="id"/>       
+        </foreign-key>
+        <foreign-key foreignTable="responsable">
+            <reference local="fk_responsable_id" foreign="id"/>       
+        </foreign-key>
+    </table>
 </database>
\ No newline at end of file


