summaryrefslogtreecommitdiff
path: root/plugins/session/install.sql
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/session/install.sql')
-rw-r--r--plugins/session/install.sql8
1 files changed, 5 insertions, 3 deletions
diff --git a/plugins/session/install.sql b/plugins/session/install.sql
index 074e4a9..ecf59f9 100644
--- a/plugins/session/install.sql
+++ b/plugins/session/install.sql
@@ -1,5 +1,7 @@
CREATE TABLE `{TAB}` (
- username TEXT PRIMARY KEY,
- secret VARCHAR(40) PRIMARY KEY,
- created INT INDEX,
+ username VARCHAR(255),
+ secret VARCHAR(40),
+ created INT,
+ PRIMARY KEY(username, secret),
+ INDEX(created)
);