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

[nomail]

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

date: 2004/07/06 07:24:05;  author: jengo;  state: Exp;  lines: +18 -0

Log Message:
Initial work to ACL, more info is in the wiki journal
=====================================================================
Index: api/setup/tables.xml
diff -u api/setup/tables.xml:1.1.2.4 api/setup/tables.xml:1.1.2.5
--- api/setup/tables.xml:1.1.2.4        Thu Jun 10 07:07:36 2004
+++ api/setup/tables.xml        Tue Jul  6 07:24:05 2004
@@ -1,5 +1,22 @@
 <?xml version="1.0"?>
 <schema version="0.2">
+       <table name="phpgw_settings">
+               <desc>Table for applications to store config data</desc>
+               <field name="setting_id" type="I">
+                       <descr>A unique ID assigned to each record.</descr>
+                       <KEY/>
+                       <AUTOINCREMENT/>
+                       <NOTNULL/>
+               </field>
+               <field name="setting_location" type="C" 
size="64"><NOTNULL/></field>
+               <field name="setting_key" type="C" size="32"><NOTNULL/></field>
+               <field name="setting_value" type="T"><NOTNULL/></field>
+               <index name="setting_location">
+                       <descr>Put an index on the setting_location</descr>
+                       <col>setting_location</col>
+               </index>
+       </table>
+
        <table name="phpgw_categories">
                <desc>Table for managing Category data.</desc>
                <field name="cat_id" type="I">
@@ -190,6 +207,7 @@
 
        <table name="phpgw_acl">
                <desc>Table to store the acl records.</desc>
+               <field name="acl_id" type="I"><NOTNULL /></field>
                <field name="acl_host" type="I"><NOTNULL/></field>
                <field name="acl_account" type="I"><NOTNULL/></field>
                <field name="acl_op" type="C" size="50"><NOTNULL/></field>