source:
companies/serpro/phpgwapi/inc/adodb/session/adodb-sessions.oracle.clob.sql
@
903
Revision 903, 281 bytes checked in by niltonneto, 15 years ago (diff) |
---|
Rev | Line | |
---|---|---|
[903] | 1 | -- $CVSHeader$ |
2 | ||
3 | DROP TABLE adodb_sessions; | |
4 | ||
5 | CREATE TABLE sessions ( | |
6 | sesskey CHAR(32) DEFAULT '' NOT NULL, | |
7 | expiry INT DEFAULT 0 NOT NULL, | |
8 | expireref VARCHAR(64) DEFAULT '', | |
9 | data CLOB DEFAULT '', | |
10 | PRIMARY KEY (sesskey) | |
11 | ); | |
12 | ||
13 | CREATE INDEX ix_expiry ON sessions (expiry); | |
14 | ||
15 | QUIT; |
Note: See TracBrowser
for help on using the repository browser.