PC Professionell 2005 June/PCpro_2005_06.ISO/files/opensource/xamp/xampp-win32.exe/xampp/adodb-sessions.oracle.clob.sql

Text File | 2003-11-04 | 281 b | 16 lines

-- $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        CLOB        DEFAULT '',
    PRIMARY KEY    (sesskey)
);

CREATE INDEX ix_expiry ON sessions (expiry);

QUIT;