aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/InventoryStore.migrations')
-rw-r--r--OpenSim/Data/SQLite/Resources/InventoryStore.migrations39
1 files changed, 0 insertions, 39 deletions
diff --git a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations b/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
deleted file mode 100644
index 2b48623..0000000
--- a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
+++ /dev/null
@@ -1,39 +0,0 @@
1:VERSION 5
2
3BEGIN TRANSACTION;
4
5CREATE TABLE IF NOT EXISTS 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');
12CREATE INDEX inventoryfolders_agentid on inventoryfolders(agentID);
13CREATE INDEX inventoryfolders_parentid on inventoryfolders(parentFolderID);
14
15CREATE TABLE IF NOT EXISTS inventoryitems(
16 assetID varchar(36),
17 assetType integer,
18 inventoryName varchar(64),
19 inventoryDescription varchar(128),
20 inventoryNextPermissions integer,
21 inventoryCurrentPermissions integer,
22 invType integer,
23 creatorID varchar(128),
24 inventoryBasePermissions integer,
25 inventoryEveryOnePermissions integer,
26 salePrice integer default 99,
27 saleType integer default 0,
28 creationDate integer default 2000,
29 groupID varchar(36) default '00000000-0000-0000-0000-000000000000',
30 groupOwned integer default 0,
31 flags integer default 0,
32 inventoryID varchar(36) primary key,
33 parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000',
34 avatarID varchar(36) not null default '00000000-0000-0000-0000-000000000000',
35 inventoryGroupPermissions integer not null default 0);
36CREATE INDEX inventoryitems_parentfolderid on inventoryitems(parentFolderID);
37CREATE INDEX inventoryitems_avatarid on inventoryitems(avatarID);
38
39COMMIT;