opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1 # -------------------------------
2  
3 begin;
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 PRIMARY KEY (`UUID`)
11 ) ENGINE=InnoDB;
12  
13 CREATE TABLE `tokens` (
14 `UUID` char(36) NOT NULL,
15 `token` varchar(255) NOT NULL,
16 `validity` datetime NOT NULL,
17 UNIQUE KEY `uuid_token` (`UUID`,`token`),
18 KEY `UUID` (`UUID`),
19 KEY `token` (`token`),
20 KEY `validity` (`validity`)
21 ) ENGINE=InnoDB;
22  
23 commit;
24  
25 :VERSION 2 # -------------------------------
26  
27 BEGIN;
28  
29 INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users;
30  
31 COMMIT;
32  
33 :VERSION 3 # -------------------------------
34  
35 BEGIN;
36  
37 ALTER TABLE `auth` ADD COLUMN `accountType` VARCHAR(32) NOT NULL DEFAULT 'UserAccount';
38  
39 COMMIT;