aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/AuthStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-06 23:16:36 +0300
committerAlexRa2010-05-18 22:16:13 +0300
commit020f38774fbe8e0f53b0cb28ab49b378b9dcd325 (patch)
tree5d936d6450d580cf24e133047df7ff8d759de557 /OpenSim/Data/MSSQL/Resources/AuthStore.migrations
parentMigrations for SQLite converted to new format (diff)
downloadopensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.zip
opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.gz
opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.bz2
opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.xz
MS SQL migrations converted to the new format
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/AuthStore.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/AuthStore.migrations28
1 files changed, 28 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AuthStore.migrations b/OpenSim/Data/MSSQL/Resources/AuthStore.migrations
new file mode 100644
index 0000000..5b90ca3
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/AuthStore.migrations
@@ -0,0 +1,28 @@
1:VERSION 1
2
3BEGIN TRANSACTION
4
5CREATE TABLE [auth] (
6 [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000',
7 [passwordHash] [varchar](32) NOT NULL,
8 [passwordSalt] [varchar](32) NOT NULL,
9 [webLoginKey] [varchar](255) NOT NULL,
10 [accountType] VARCHAR(32) NOT NULL DEFAULT 'UserAccount',
11) ON [PRIMARY]
12
13CREATE TABLE [tokens] (
14 [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000',
15 [token] [varchar](255) NOT NULL,
16 [validity] [datetime] NOT NULL )
17 ON [PRIMARY]
18
19COMMIT
20
21:VERSION 2
22
23BEGIN TRANSACTION
24
25INSERT 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;
26
27
28COMMIT \ No newline at end of file