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) |
---|
Line | |
---|---|
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.