clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 1 # ------------------------- |
2 | |||
3 | BEGIN; |
||
4 | |||
5 | CREATE TABLE `UserAccounts` ( |
||
6 | `PrincipalID` CHAR(36) NOT NULL, |
||
7 | `ScopeID` CHAR(36) NOT NULL, |
||
8 | `FirstName` VARCHAR(64) NOT NULL, |
||
9 | `LastName` VARCHAR(64) NOT NULL, |
||
10 | `Email` VARCHAR(64), |
||
11 | `ServiceURLs` TEXT, |
||
12 | `Created` INT(11) |
||
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
14 | |||
15 | COMMIT; |
||
16 | |||
17 | :VERSION 2 # ------------------------- |
||
18 | |||
19 | BEGIN; |
||
20 | |||
21 | INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, lastname AS LastName, email as Email, CONCAT('AssetServerURI=', userAssetURI, ' InventoryServerURI=', userInventoryURI, ' GatewayURI= HomeURI=') AS ServiceURLs, created as Created FROM users; |
||
22 | |||
23 | COMMIT; |
||
24 | |||
25 | :VERSION 3 # ------------------------- |
||
26 | |||
27 | BEGIN; |
||
28 | |||
29 | CREATE UNIQUE INDEX PrincipalID ON UserAccounts(PrincipalID); |
||
30 | CREATE INDEX Email ON UserAccounts(Email); |
||
31 | CREATE INDEX FirstName ON UserAccounts(FirstName); |
||
32 | CREATE INDEX LastName ON UserAccounts(LastName); |
||
33 | CREATE INDEX Name ON UserAccounts(FirstName,LastName); |
||
34 | |||
35 | COMMIT; |
||
36 | |||
37 | :VERSION 4 # ------------------------- |
||
38 | |||
39 | BEGIN; |
||
40 | |||
41 | ALTER TABLE UserAccounts ADD COLUMN UserLevel integer NOT NULL DEFAULT 0; |
||
42 | ALTER TABLE UserAccounts ADD COLUMN UserFlags integer NOT NULL DEFAULT 0; |
||
43 | ALTER TABLE UserAccounts ADD COLUMN UserTitle varchar(64) NOT NULL DEFAULT ''; |
||
44 | |||
45 | COMMIT; |
||
46 | |||
47 |