From a03c40719f6e9fd1ee66dfb286a5486715e4b519 Mon Sep 17 00:00:00 2001
From: "Michael J. Rubinsky" <mrubinsk@horde.org>
Date: Sun, 11 Oct 2009 15:19:38 -0400
Subject: [PATCH] add resoruce fields/tables to the schema file

---
 kronolith/scripts/sql/kronolith.xml | 73 +++++++++++++++++++++++++++++++++++++
 1 file changed, 73 insertions(+)

diff --git a/kronolith/scripts/sql/kronolith.xml b/kronolith/scripts/sql/kronolith.xml
index 20a1e10c0..d2072e143 100644
--- a/kronolith/scripts/sql/kronolith.xml
+++ b/kronolith/scripts/sql/kronolith.xml
@@ -61,6 +61,11 @@
    </field>
 
    <field>
+    <name>event_resources</name>
+    <type>clob</type>
+   </field>
+   
+   <field>
     <name>event_exceptions</name>
     <type>clob</type>
    </field>
@@ -469,4 +474,72 @@
 
  </table>
 
+ <table>
+ 
+  <name>kronolith_resources</name>
+  
+  <declaration>
+  
+   <field>
+    <name>resource_id</name>
+    <type>integer</type>
+    <default></default>
+    <notnull>true</notnull>
+    <length>4</length>
+   </field>
+   
+   <field>
+    <name>resource_name</name>
+    <type>text</type>
+    <default></default>
+    <notnull>false</notnull>
+    <length>255</length>
+   </field>
+    
+   <field>
+    <name>resource_calendar</name>
+    <type>text</type>
+    <default></default>
+    <notnull>false</notnull>
+    <length>255</length>
+   </field>
+   
+   <field>
+    <name>resource_description</name>
+    <type>clob</type>
+   </field>
+   
+   <field>
+    <name>resource_category</name>
+    <type>text</type>
+    <default></default>
+    <notnull>false</notnull>
+    <length>255</length>
+   </field>
+   
+   <field>
+    <name>resource_response_type</name>
+    <type>integer</type>
+    <default>0</default>
+    <notnull>true</notnull>
+    <length>4</length>
+   </field>
+   
+   <field>
+    <name>resource_type</name>
+    <type>text</type>
+    <default></default>
+    <notnull>true</notnull>
+    <length>255</length>
+   </field>
+
+   <field>
+    <name>resource_members</name>
+    <type>clob</type>
+   </field>
+   
+  </declaration>
+  
+ </table>
+ 
 </database>
-- 
2.11.0