source:
sandbox/2.3-MailArchiver/phpgwapi/inc/adodb/session/adodb-sessions.oracle.sql
@
6779
Revision 6779, 313 bytes checked in by rafaelraymundo, 12 years ago (diff) |
---|
Line | |
---|---|
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 VARCHAR(4000) DEFAULT '', |
10 | PRIMARY KEY (sesskey), |
11 | INDEX expiry (expiry) |
12 | ); |
13 | |
14 | CREATE INDEX ix_expiry ON sessions (expiry); |
15 | |
16 | QUIT; |
Note: See TracBrowser
for help on using the repository browser.