1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- :VERSION 1
- BEGIN TRANSACTION;
- CREATE TABLE inventoryfolders(
- UUID varchar(255) primary key,
- name varchar(255),
- agentID varchar(255),
- parentID varchar(255),
- type integer,
- version integer);
- CREATE TABLE inventoryitems(
- UUID varchar(255) primary key,
- assetID varchar(255),
- assetType integer,
- invType integer,
- parentFolderID varchar(255),
- avatarID varchar(255),
- creatorsID varchar(255),
- inventoryName varchar(255),
- inventoryDescription varchar(255),
- inventoryNextPermissions integer,
- inventoryCurrentPermissions integer,
- inventoryBasePermissions integer,
- inventoryEveryOnePermissions integer,
- salePrice integer default 99,
- saleType integer default 0,
- creationDate integer default 2000,
- groupID varchar(255) default '00000000-0000-0000-0000-000000000000',
- groupOwned integer default 0,
- flags integer default 0);
- COMMIT;
- :VERSION 2
- BEGIN TRANSACTION;
- create index inventoryfolders_agentid on inventoryfolders(agentid);
- create index inventoryfolders_parentid on inventoryfolders(parentid);
- create index inventoryitems_parentfolderid on inventoryitems(parentfolderid);
- create index inventoryitems_avatarid on inventoryitems(avatarid);
- COMMIT;
- :VERSION 3
- BEGIN;
- alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0;
- COMMIT;
- :VERSION 4
- BEGIN;
- update inventoryitems
- set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
- where UUID not like '%-%';
- update inventoryitems
- set assetID = substr(assetID, 1, 8) || "-" || substr(assetID, 9, 4) || "-" || substr(assetID, 13, 4) || "-" || substr(assetID, 17, 4) || "-" || substr(assetID, 21, 12)
- where assetID not like '%-%';
- update inventoryitems
- set parentFolderID = substr(parentFolderID, 1, 8) || "-" || substr(parentFolderID, 9, 4) || "-" || substr(parentFolderID, 13, 4) || "-" || substr(parentFolderID, 17, 4) || "-" || substr(parentFolderID, 21, 12)
- where parentFolderID not like '%-%';
- update inventoryitems
- set avatarID = substr(avatarID, 1, 8) || "-" || substr(avatarID, 9, 4) || "-" || substr(avatarID, 13, 4) || "-" || substr(avatarID, 17, 4) || "-" || substr(avatarID, 21, 12)
- where avatarID not like '%-%';
- update inventoryitems
- set creatorsID = substr(creatorsID, 1, 8) || "-" || substr(creatorsID, 9, 4) || "-" || substr(creatorsID, 13, 4) || "-" || substr(creatorsID, 17, 4) || "-" || substr(creatorsID, 21, 12)
- where creatorsID not like '%-%';
- update inventoryfolders
- set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
- where UUID not like '%-%';
- update inventoryfolders
- set agentID = substr(agentID, 1, 8) || "-" || substr(agentID, 9, 4) || "-" || substr(agentID, 13, 4) || "-" || substr(agentID, 17, 4) || "-" || substr(agentID, 21, 12)
- where agentID not like '%-%';
- update inventoryfolders
- set parentID = substr(parentID, 1, 8) || "-" || substr(parentID, 9, 4) || "-" || substr(parentID, 13, 4) || "-" || substr(parentID, 17, 4) || "-" || substr(parentID, 21, 12)
- where parentID not like '%-%';
- COMMIT;
|