source:
sandbox/2.3-MailArchiver/phpgwapi/inc/adodb/session/adodb-sessions.mysql.sql
@
6779
Revision 6779, 396 bytes checked in by rafaelraymundo, 12 years ago (diff) |
---|
Rev | Line | |
---|---|---|
[6779] | 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 | ); |
Note: See TracBrowser
for help on using the repository browser.