[Summary view] [Print] [Text view]

   1  -- $CVSHeader$
   2  
   3  CREATE DATABASE /*! IF NOT EXISTS */ adodb_sessions;
   4  
   5  USE adodb_sessions;
   6  
   7  DROP TABLE /*! IF EXISTS */ sessions;
   8  
   9  CREATE TABLE /*! IF NOT EXISTS */ sessions (
  10      sesskey        CHAR(32)    /*! BINARY */ NOT NULL DEFAULT '',
  11      expiry        INT(11)        /*! UNSIGNED */ NOT NULL DEFAULT 0,
  12      expireref    VARCHAR(64)    DEFAULT '',
  13      data        LONGTEXT    DEFAULT '',
  14      PRIMARY KEY	(sesskey),
  15      INDEX expiry (expiry)
  16  );