[TASK] Merge submodule fluid into core
[Packages/TYPO3.CMS.git] / typo3 / sysext / adodb / adodb / session / adodb-sessions.oracle.sql
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;