Revision 727,
396 bytes
checked in by niltonneto, 16 years ago
(diff) |
Commit inicial.
|
Rev | Line | |
---|
[727] | 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.