From e1aa83e965440b3e830d599e18ff078104e8a886 Mon Sep 17 00:00:00 2001
From: Teravus Ovares
Date: Wed, 9 Jan 2008 04:13:04 +0000
Subject: * Added a hashtable based HTTP processor in preparation of the
 web_login_key * Added the web_login_key to the users table * Added happy
 configurable http error message pages * This update is large enough to have
 'awe' value..    so backup your users or weep. * Not tested on MSSQL, even
 though I added code to update the tables!

---
 OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql')

diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql
index faac541..d9e8ae2 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql
@@ -25,9 +25,10 @@ CREATE TABLE `users` (
   `profileFirstText` text,
   `profileImage` varchar(36) default NULL,
   `profileFirstImage` varchar(36) default NULL,
+  `webLoginKey` varchar(36) default NULL,
   PRIMARY KEY  (`UUID`),
   UNIQUE KEY `usernames` (`username`,`lastname`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
 
 -- ----------------------------
 -- Records 
-- 
cgit v1.1