clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 1 # ------------ |
2 | BEGIN; |
||
3 | |||
4 | CREATE TABLE `inventoryfolders` ( |
||
5 | `folderID` varchar(36) NOT NULL default '', |
||
6 | `agentID` varchar(36) default NULL, |
||
7 | `parentFolderID` varchar(36) default NULL, |
||
8 | `folderName` varchar(64) default NULL, |
||
9 | `type` smallint NOT NULL default 0, |
||
10 | `version` int NOT NULL default 0, |
||
11 | PRIMARY KEY (`folderID`), |
||
12 | KEY `owner` (`agentID`), |
||
13 | KEY `parent` (`parentFolderID`) |
||
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
15 | |||
16 | CREATE TABLE `inventoryitems` ( |
||
17 | `inventoryID` varchar(36) NOT NULL default '', |
||
18 | `assetID` varchar(36) default NULL, |
||
19 | `assetType` int(11) default NULL, |
||
20 | `parentFolderID` varchar(36) default NULL, |
||
21 | `avatarID` varchar(36) default NULL, |
||
22 | `inventoryName` varchar(64) default NULL, |
||
23 | `inventoryDescription` varchar(128) default NULL, |
||
24 | `inventoryNextPermissions` int(10) unsigned default NULL, |
||
25 | `inventoryCurrentPermissions` int(10) unsigned default NULL, |
||
26 | `invType` int(11) default NULL, |
||
27 | `creatorID` varchar(36) default NULL, |
||
28 | `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, |
||
29 | `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, |
||
30 | `salePrice` int(11) NOT NULL default 0, |
||
31 | `saleType` tinyint(4) NOT NULL default 0, |
||
32 | `creationDate` int(11) NOT NULL default 0, |
||
33 | `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
||
34 | `groupOwned` tinyint(4) NOT NULL default 0, |
||
35 | `flags` int(11) unsigned NOT NULL default 0, |
||
36 | PRIMARY KEY (`inventoryID`), |
||
37 | KEY `owner` (`avatarID`), |
||
38 | KEY `folder` (`parentFolderID`) |
||
39 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
40 | |||
41 | COMMIT; |
||
42 | |||
43 | :VERSION 2 # ------------ |
||
44 | |||
45 | BEGIN; |
||
46 | |||
47 | ALTER TABLE inventoryfolders change folderID folderIDold varchar(36); |
||
48 | ALTER TABLE inventoryfolders change agentID agentIDold varchar(36); |
||
49 | ALTER TABLE inventoryfolders change parentFolderID parentFolderIDold varchar(36); |
||
50 | ALTER TABLE inventoryfolders add folderID char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
51 | ALTER TABLE inventoryfolders add agentID char(36) default NULL; |
||
52 | ALTER TABLE inventoryfolders add parentFolderID char(36) default NULL; |
||
53 | UPDATE inventoryfolders set folderID = folderIDold, agentID = agentIDold, parentFolderID = parentFolderIDold; |
||
54 | ALTER TABLE inventoryfolders drop folderIDold; |
||
55 | ALTER TABLE inventoryfolders drop agentIDold; |
||
56 | ALTER TABLE inventoryfolders drop parentFolderIDold; |
||
57 | ALTER TABLE inventoryfolders add constraint primary key(folderID); |
||
58 | ALTER TABLE inventoryfolders add index inventoryfolders_agentid(agentID); |
||
59 | ALTER TABLE inventoryfolders add index inventoryfolders_parentFolderid(parentFolderID); |
||
60 | |||
61 | ALTER TABLE inventoryitems change inventoryID inventoryIDold varchar(36); |
||
62 | ALTER TABLE inventoryitems change avatarID avatarIDold varchar(36); |
||
63 | ALTER TABLE inventoryitems change parentFolderID parentFolderIDold varchar(36); |
||
64 | ALTER TABLE inventoryitems add inventoryID char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
65 | ALTER TABLE inventoryitems add avatarID char(36) default NULL; |
||
66 | ALTER TABLE inventoryitems add parentFolderID char(36) default NULL; |
||
67 | UPDATE inventoryitems set inventoryID = inventoryIDold, avatarID = avatarIDold, parentFolderID = parentFolderIDold; |
||
68 | ALTER TABLE inventoryitems drop inventoryIDold; |
||
69 | ALTER TABLE inventoryitems drop avatarIDold; |
||
70 | ALTER TABLE inventoryitems drop parentFolderIDold; |
||
71 | ALTER TABLE inventoryitems add constraint primary key(inventoryID); |
||
72 | ALTER TABLE inventoryitems add index inventoryitems_avatarid(avatarID); |
||
73 | ALTER TABLE inventoryitems add index inventoryitems_parentFolderid(parentFolderID); |
||
74 | |||
75 | COMMIT; |
||
76 | |||
77 | :VERSION 3 # ------------ |
||
78 | |||
79 | BEGIN; |
||
80 | |||
81 | alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; |
||
82 | |||
83 | COMMIT; |
||
84 | |||
85 | :VERSION 4 # ------------ |
||
86 | |||
87 | BEGIN; |
||
88 | |||
89 | update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID is NULL; |
||
90 | update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID = ''; |
||
91 | alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000'; |
||
92 | |||
93 | COMMIT; |
||
94 | |||
95 | :VERSION 5 # ------------ |
||
96 | |||
97 | BEGIN; |
||
98 | |||
99 | alter table inventoryitems modify column creatorID varchar(128) not NULL default '00000000-0000-0000-0000-000000000000'; |
||
100 | |||
101 | COMMIT; |
||
102 | |||
103 | :VERSION 6 # ------------ |
||
104 | |||
105 | BEGIN; |
||
106 | |||
107 | alter table inventoryitems modify column creatorID varchar(255) not NULL default '00000000-0000-0000-0000-000000000000'; |
||
108 | |||
109 | COMMIT; |