opensim – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 |
2 | |||
3 | BEGIN TRANSACTION; |
||
4 | |||
5 | CREATE TABLE inventoryfolders( |
||
6 | folderName varchar(64), |
||
7 | type integer, |
||
8 | version integer, |
||
9 | folderID varchar(36) primary key, |
||
10 | agentID varchar(36) not null default '00000000-0000-0000-0000-000000000000', |
||
11 | parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000'); |
||
12 | |||
13 | CREATE TABLE inventoryitems( |
||
14 | assetID varchar(36), |
||
15 | assetType integer, |
||
16 | inventoryName varchar(64), |
||
17 | inventoryDescription varchar(128), |
||
18 | inventoryNextPermissions integer, |
||
19 | inventoryCurrentPermissions integer, |
||
20 | invType integer, |
||
21 | creatorID varchar(128), |
||
22 | inventoryBasePermissions integer, |
||
23 | inventoryEveryOnePermissions integer, |
||
24 | salePrice integer default 99, |
||
25 | saleType integer default 0, |
||
26 | creationDate integer default 2000, |
||
27 | groupID varchar(36) default '00000000-0000-0000-0000-000000000000', |
||
28 | groupOwned integer default 0, |
||
29 | flags integer default 0, |
||
30 | inventoryID varchar(36) primary key, |
||
31 | parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000', |
||
32 | avatarID varchar(36) not null default '00000000-0000-0000-0000-000000000000', |
||
33 | inventoryGroupPermissions integer not null default 0); |
||
34 | |||
35 | create index inventoryfolders_agentid on inventoryfolders(agentID); |
||
36 | create index inventoryfolders_parentid on inventoryfolders(parentFolderID); |
||
37 | create index inventoryitems_parentfolderid on inventoryitems(parentFolderID); |
||
38 | create index inventoryitems_avatarid on inventoryitems(avatarID); |
||
39 | |||
40 | COMMIT; |
||
41 | |||
42 | :VERSION 2 |
||
43 | |||
44 | BEGIN TRANSACTION; |
||
45 | |||
46 | INSERT INTO inventoryfolders (folderName, type, version, folderID, agentID, parentFolderID) SELECT `name` AS folderName, `type` AS type, `version` AS version, `UUID` AS folderID, `agentID` AS agentID, `parentID` AS parentFolderID from old.inventoryfolders; |
||
47 | INSERT INTO inventoryitems (assetID, assetType, inventoryName, inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType, creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, salePrice, saleType, creationDate, groupID, groupOwned, flags, inventoryID, parentFolderID, avatarID, inventoryGroupPermissions) SELECT `assetID`, `assetType` AS assetType, `inventoryName` AS inventoryName, `inventoryDescription` AS inventoryDescription, `inventoryNextPermissions` AS inventoryNextPermissions, `inventoryCurrentPermissions` AS inventoryCurrentPermissions, `invType` AS invType, `creatorsID` AS creatorID, `inventoryBasePermissions` AS inventoryBasePermissions, `inventoryEveryOnePermissions` AS inventoryEveryOnePermissions, `salePrice` AS salePrice, `saleType` AS saleType, `creationDate` AS creationDate, `groupID` AS groupID, `groupOwned` AS groupOwned, `flags` AS flags, `UUID` AS inventoryID, `parentFolderID` AS parentFolderID, `avatarID` AS avatarID, `inventoryGroupPermissions` AS inventoryGroupPermissions FROM old.inventoryitems; |
||
48 | |||
49 | COMMIT; |