summaryrefslogtreecommitdiff
path: root/vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql')
-rw-r--r--vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql b/vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql
new file mode 100644
index 0000000..c5c4f2d
--- /dev/null
+++ b/vendor/adodb/adodb-php/session/adodb-sessions.oracle.clob.sql
@@ -0,0 +1,15 @@
+-- $CVSHeader$
+
+DROP TABLE adodb_sessions;
+
+CREATE TABLE sessions (
+ sesskey CHAR(32) DEFAULT '' NOT NULL,
+ expiry INT DEFAULT 0 NOT NULL,
+ expireref VARCHAR(64) DEFAULT '',
+ data CLOB DEFAULT '',
+ PRIMARY KEY (sesskey)
+);
+
+CREATE INDEX ix_expiry ON sessions (expiry);
+
+QUIT;