[Phpgroupware-cvs] phpgwapi/inc/adodb/session/adodb-sessions.oracle.sql, 1.1.2.1

[nomail]

Update of /phpgwapi/inc/adodb/session
Added Files:
        Branch: proposed-0_9_18-branch
          adodb-sessions.oracle.sql

date: 2004/12/30 04:51:48;  author: skwashd;  state: Exp;  lines: +16 -0

Log Message:
switch to ADOdb
=====================================================================
-- $CVSHeader$

DROP TABLE adodb_sessions;

CREATE TABLE sessions (
        sesskey         CHAR(32)        DEFAULT '' NOT NULL,
        expiry          INT             DEFAULT 0 NOT NULL,
        expireref       VARCHAR(64)     DEFAULT '',
        data            VARCHAR(4000)   DEFAULT '',
        PRIMARY KEY     (sesskey),
        INDEX expiry (expiry)
);

CREATE INDEX ix_expiry ON sessions (expiry);

QUIT;