summaryrefslogtreecommitdiff
path: root/vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql')
-rw-r--r--vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql b/vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql
new file mode 100644
index 0000000..8fd5a34
--- /dev/null
+++ b/vendor/adodb/adodb-php/session/adodb-sessions.oracle.sql
@@ -0,0 +1,16 @@
+-- $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 VARCHAR(4000) DEFAULT '',
+ PRIMARY KEY (sesskey),
+ INDEX expiry (expiry)
+);
+
+CREATE INDEX ix_expiry ON sessions (expiry);
+
+QUIT;