opensim-development – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 |
2 | |||
3 | BEGIN TRANSACTION; |
||
4 | |||
5 | CREATE TABLE auth ( |
||
6 | uuid uuid 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 | ) ; |
||
12 | |||
13 | CREATE TABLE tokens ( |
||
14 | uuid uuid NOT NULL default '00000000-0000-0000-0000-000000000000', |
||
15 | token varchar(255) NOT NULL, |
||
16 | validity TIMESTAMP NOT NULL ) |
||
17 | ; |
||
18 | |||
19 | COMMIT; |
||
20 | |||
21 | :VERSION 2 |
||
22 | |||
23 | BEGIN TRANSACTION; |
||
24 | |||
25 | INSERT INTO auth (uuid, "passwordHash", "passwordSalt", "webLoginKey", "accountType") |
||
26 | SELECT uuid AS UUID, passwordHash AS passwordHash, passwordSalt AS passwordSalt, webLoginKey AS webLoginKey, 'UserAccount' as accountType |
||
27 | FROM users |
||
28 | where exists ( Select * from information_schema.tables where table_name = 'users' ) |
||
29 | ; |
||
30 | |||
31 | COMMIT; |
||
32 |