From 134f86e8d5c414409631b25b8c6f0ee45fbd8631 Mon Sep 17 00:00:00 2001 From: David Walter Seikel Date: Thu, 3 Nov 2016 21:44:39 +1000 Subject: Initial update to OpenSim 0.8.2.1 source code. --- OpenSim/Data/MSSQL/Resources/AuthStore.migrations | 32 ----------------------- 1 file changed, 32 deletions(-) delete mode 100644 OpenSim/Data/MSSQL/Resources/AuthStore.migrations (limited to 'OpenSim/Data/MSSQL/Resources/AuthStore.migrations') diff --git a/OpenSim/Data/MSSQL/Resources/AuthStore.migrations b/OpenSim/Data/MSSQL/Resources/AuthStore.migrations deleted file mode 100644 index eb91296..0000000 --- a/OpenSim/Data/MSSQL/Resources/AuthStore.migrations +++ /dev/null @@ -1,32 +0,0 @@ -:VERSION 1 - -BEGIN TRANSACTION - -CREATE TABLE [auth] ( - [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000', - [passwordHash] [varchar](32) NOT NULL, - [passwordSalt] [varchar](32) NOT NULL, - [webLoginKey] [varchar](255) NOT NULL, - [accountType] VARCHAR(32) NOT NULL DEFAULT 'UserAccount', -) ON [PRIMARY] - -CREATE TABLE [tokens] ( - [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000', - [token] [varchar](255) NOT NULL, - [validity] [datetime] NOT NULL ) - ON [PRIMARY] - -COMMIT - -:VERSION 2 - -BEGIN TRANSACTION - -IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type in (N'U')) - INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey, accountType) SELECT [UUID] AS UUID, [passwordHash] AS passwordHash, [passwordSalt] AS passwordSalt, [webLoginKey] AS webLoginKey, 'UserAccount' as [accountType] FROM users; - -COMMIT - - - - -- cgit v1.1