1-- $CVSHeader$ 2 3CREATE DATABASE /*! IF NOT EXISTS */ adodb_sessions; 4 5USE adodb_sessions; 6 7DROP TABLE /*! IF EXISTS */ sessions; 8 9CREATE 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); 17