[Phpgroupware-cvs] api/setup/tables.xml, 1.1.2.2

[nomail]

Update of /api/setup
Modified Files:
        Branch: proposal-branch
          tables.xml

date: 2004/05/14 05:52:22;  author: jengo;  state: Exp;  lines: +29 -0

Log Message:
These tables are for the new preferences system
=====================================================================
Index: api/setup/tables.xml
diff -u api/setup/tables.xml:1.1.2.1 api/setup/tables.xml:1.1.2.2
--- api/setup/tables.xml:1.1.2.1        Fri Apr 16 20:59:49 2004
+++ api/setup/tables.xml        Fri May 14 05:52:22 2004
@@ -85,6 +85,35 @@
                </index>
        </table>
 
+       <table name="phpgw_apps_prefs">
+               <desc>Cached preferences options for applications</desc>
+               <field name="pref_id" type="I">
+                       <descr>A unique ID assigned to each record</descr>
+                       <KEY/>
+                       <AUTOINCREMENT/>
+                       <NOTNULL/>
+               </field>
+               <field name="pref_appname" type="C" size="50"><NOTNULL/></field>
+               <field name="pref_type" type="C" size="1"><NOTNULL/></field>
+               <field name="pref_name" type="C" size="100"><NOTNULL/></field>
+               <field name="pref_label" type="C" size="200"><NOTNULL/></field>
+               <index name="app">
+                       <descr>Put an index on pref_app</descr>
+                       <col>pref_appname</col>
+               </index>
+       </table>
+
+       <table name="phpgw_apps_prefs_values">
+               <desc>Cached preference values for applications</desc>
+               <field name="pv_id" type="I"></field>
+               <field name="pv_text" type="C" size="200"></field>
+               <field name="pv_value" type="C" size="100"><NOTNULL/></field>
+               <index name="pv">
+                       <descr>Put an index on pv_id</descr>
+                       <col>pv_id</col>
+               </index>
+       </table>
+
        <table name="phpgw_accounts">
                <desc>A typical users table for our application.</desc>
                <field name="account_id" type="I">