aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/InventoryStore.migrations
diff options
context:
space:
mode:
authorDiva Canto2016-02-21 10:37:12 -0800
committerDiva Canto2016-02-21 10:37:12 -0800
commitcd54bbe7892f3863ca8fae4fb1af01f8faf1ec20 (patch)
treed7bdef5a0e5152694f07f0f0b05b51a62f9f5fc5 /OpenSim/Data/SQLite/Resources/InventoryStore.migrations
parentSQLite: Removed obsolete migration file (diff)
downloadopensim-SC-cd54bbe7892f3863ca8fae4fb1af01f8faf1ec20.zip
opensim-SC-cd54bbe7892f3863ca8fae4fb1af01f8faf1ec20.tar.gz
opensim-SC-cd54bbe7892f3863ca8fae4fb1af01f8faf1ec20.tar.bz2
opensim-SC-cd54bbe7892f3863ca8fae4fb1af01f8faf1ec20.tar.xz
The old sqlite inventory data interface was still around and causing problems: the only part of the code using it was the data (sqlite) tests. Given that this old interface has been obsolete for several years, it has now been removed, including the tests. TODO: Writing tests for the new (ah!) inventory data interface.
Diffstat (limited to '')
-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;