Details |
Last modification |
View Log
| Rev |
Author |
Line No. |
Line |
| 36 |
kaklik |
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 |
);
|