From 67f803c919324f49e21279faa43c9578b625529e Mon Sep 17 00:00:00 2001
From: Melanie
Date: Fri, 4 Sep 2009 08:10:05 +0100
Subject: Add the new AuthStore to migrations. Update OpenSim.Server.ini

---
 OpenSim/Data/MySQL/Resources/001_AuthStore.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/001_AuthStore.sql

(limited to 'OpenSim/Data/MySQL/Resources/001_AuthStore.sql')

diff --git a/OpenSim/Data/MySQL/Resources/001_AuthStore.sql b/OpenSim/Data/MySQL/Resources/001_AuthStore.sql
new file mode 100644
index 0000000..c7e16fb
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/001_AuthStore.sql
@@ -0,0 +1,21 @@
+begin;
+
+CREATE TABLE `auth` (
+  `UUID` char(36) NOT NULL,
+  `passwordHash` char(32) NOT NULL default '',
+  `passwordSalt` char(32) NOT NULL default '',
+  `webLoginKey` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`UUID`)
+) ENGINE=InnoDB;
+
+CREATE TABLE `tokens` (
+  `UUID` char(36) NOT NULL,
+  `token` varchar(255) NOT NULL,
+  `validity` datetime NOT NULL,
+  UNIQUE KEY `uuid_token` (`UUID`,`token`),
+  KEY `UUID` (`UUID`),
+  KEY `token` (`token`),
+  KEY `validity` (`validity`)
+) ENGINE=InnoDB;
+
+commit;
-- 
cgit v1.1

