<?xml version="1.0"?>
<schema version="0.3">
  <table name="sessions2">
    <descr>Table for ADOdb session management</descr>
    <field name="SESSKEY" type="C" size="64">
      <descr>Session key to identify a user's browser session.</descr>
      <KEY/>
      <NOTNULL/>
    </field>
    <field name="EXPIRY" type="T">
      <descr>Slightly redundant as it can be dynamically calculated by NOW() and MODIFIED field,
        but it enables forcing a fixed timeout for specific sessions.
      </descr>
      <NOTNULL/>
    </field>
    <field name="CREATED" type="T">
      <descr>New session creation Timestamp.</descr>
      <NOTNULL/>
    </field>
    <field name="MODIFIED" type="T">
      <descr>Timestamp which is usually updated when the user interacts with a site, to extend the expire time.</descr>
      <NOTNULL/>
    </field>
    <field name="EXPIREREF" type="C" size="250">
      <descr>Usually a User Id or unique username of your application.
        The name EXPIREREF is a bit weird, it may be better to call it USERREF?
      </descr>
    </field>
    <field name="SESSDATA" type="XL">
      <descr>PHP's serialized session data or encrypted serialized session data.</descr>
      <NOTNULL/>
    </field>
  </table>
</schema>
