aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/AuthStore.migrations
blob: 5b90ca3d3687f035aad027cac3add880b0bb3ef0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
: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

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