opensim – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 |
2 | |||
3 | BEGIN TRANSACTION; |
||
4 | |||
5 | -- useraccounts table |
||
6 | CREATE TABLE UserAccounts ( |
||
7 | PrincipalID CHAR(36) primary key, |
||
8 | ScopeID CHAR(36) NOT NULL, |
||
9 | FirstName VARCHAR(64) NOT NULL, |
||
10 | LastName VARCHAR(64) NOT NULL, |
||
11 | Email VARCHAR(64), |
||
12 | ServiceURLs TEXT, |
||
13 | Created INT(11), |
||
14 | UserLevel integer NOT NULL DEFAULT 0, |
||
15 | UserFlags integer NOT NULL DEFAULT 0, |
||
16 | UserTitle varchar(64) NOT NULL DEFAULT '' |
||
17 | ); |
||
18 | |||
19 | COMMIT; |
||
20 | |||
21 | :VERSION 2 |
||
22 | |||
23 | BEGIN TRANSACTION; |
||
24 | |||
25 | INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, surname AS LastName, '' as Email, '' AS ServiceURLs, created as Created FROM users; |
||
26 | |||
27 | COMMIT; |