clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | vero | 1 | :VERSION 1 |
| 2 | |||
| 3 | BEGIN TRANSACTION |
||
| 4 | |||
| 5 | CREATE 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 | |||
| 13 | CREATE 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 | |||
| 19 | COMMIT |
||
| 20 | |||
| 21 | :VERSION 2 |
||
| 22 | |||
| 23 | BEGIN TRANSACTION |
||
| 24 | |||
| 25 | IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type in (N'U')) |
||
| 26 | 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; |
||
| 27 | |||
| 28 | COMMIT |
||
| 29 | |||
| 30 | |||
| 31 | |||
| 32 |