Config Table

From EA-Geier

Database Config Table Clients Table ClientConfig Table Users Table UserConfig Table Session2 Table SimpleTest Table Cash-Book Table Assets-Book Table Purchase-Book Table Traveling-Expenses Table Balance Table

The config table holds the system configuration data.

The what value defines the type of the configuration value. Possible values are text (for normal text values), or encrypt (for text stored encrypted in the table).

The context value defines the context of the configuration value. Possible values are system (for system-specific data), client (for client-specific data), or user (for user-specific data).

The rights value defines who is allowed to modify the value. Possible values are admin (the system administrator), owner (the owner of client), user (a normal user).

<?xml version="1.0"?>
<schema version="0.3">
  <table name="config">
    <field name="id" type="I" size="6">
      <KEY/>
      <AUTOINCREMENT/>
      <UNSIGNED/>
    </field>
    <field name="name" type="C" size="32">
      <NOTNULL/>
    </field>
    <field name="value" type="X">
      <NOTNULL/>
    </field>
    <field name="what" type="C" size="255">
      <NOTNULL/>
      <DEFAULT value="text"/>
    </field>
    <field name="context" type="C" size="255">
      <NOTNULL/>
      <DEFAULT value="user"/>
    </field>
    <field name="rights" type="C" size="255">
      <NOTNULL/>
      <DEFAULT value="admin"/>
    </field>
    <field name="lastModified" type="T">
      <NOTNULL/>
    </field>
    <data>
      <row>
        <f>1</f>
        <f>txtMailServer</f>
        <f>localhost</f>
        <f>text</f>
        <f>system</f>
        <f>admin</f>
        <f>2007-05-25 18:29:00</f>
      </row>
      <row>
        <f>2</f>
        <f>numMailPort</f>
        <f>10025</f>
        <f>text</f>
        <f>system</f>
        <f>admin</f>
        <f>2007-05-25 18:29:00</f>
      </row>
      <row>
        <f>3</f>
        <f>mailFrom</f>
        <f>server@ea-geier.at</f>
        <f>text</f>
        <f>system</f>
        <f>admin</f>
        <f>2007-05-01 08:17:12</f>
      </row>
      <row>
        <f>111</f>
        <f>dsnNewClientDB</f>
        <f></f>
        <f>encrypt</f>
        <f>system</f>
        <f>admin</f>
        <f>2007-05-22 22:53:43</f>
      </row>
    </data>
  </table>
</schema>