Config 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>