opensim – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1
2  
3 BEGIN TRANSACTION;
4  
5 CREATE TABLE auth (
6 UUID char(36) NOT NULL,
7 passwordHash char(32) NOT NULL default '',
8 passwordSalt char(32) NOT NULL default '',
9 webLoginKey varchar(255) NOT NULL default '',
10 accountType VARCHAR(32) NOT NULL DEFAULT 'UserAccount',
11 PRIMARY KEY (`UUID`)
12 );
13  
14 CREATE TABLE tokens (
15 UUID char(36) NOT NULL,
16 token varchar(255) NOT NULL,
17 validity datetime NOT NULL
18 );
19  
20 COMMIT;
21  
22 :VERSION 2
23  
24 BEGIN TRANSACTION;
25  
26 INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users;
27  
28 COMMIT;
29