summaryrefslogtreecommitdiff
path: root/vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql')
-rw-r--r--vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql b/vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql
new file mode 100644
index 0000000..f90de44
--- /dev/null
+++ b/vendor/adodb/adodb-php/session/adodb-sessions.mysql.sql
@@ -0,0 +1,16 @@
+-- $CVSHeader$
+
+CREATE DATABASE /*! IF NOT EXISTS */ adodb_sessions;
+
+USE adodb_sessions;
+
+DROP TABLE /*! IF EXISTS */ sessions;
+
+CREATE TABLE /*! IF NOT EXISTS */ sessions (
+ sesskey CHAR(32) /*! BINARY */ NOT NULL DEFAULT '',
+ expiry INT(11) /*! UNSIGNED */ NOT NULL DEFAULT 0,
+ expireref VARCHAR(64) DEFAULT '',
+ data LONGTEXT DEFAULT '',
+ PRIMARY KEY (sesskey),
+ INDEX expiry (expiry)
+);