aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
diff options
context:
space:
mode:
authorAlexRa2010-05-06 22:44:57 +0300
committerAlexRa2010-05-18 22:16:10 +0300
commit6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9 (patch)
treed9a809d417ed531fbde0f041156b449d4030708a /OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
parentConverted MySQL migration history to the new format (diff)
downloadopensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.zip
opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.gz
opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.bz2
opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.xz
Migrations for SQLite converted to new format
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_InventoryStore.sql32
1 files changed, 0 insertions, 32 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
deleted file mode 100644
index 554d5c2..0000000
--- a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
+++ /dev/null
@@ -1,32 +0,0 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE inventoryfolders(
4 UUID varchar(255) primary key,
5 name varchar(255),
6 agentID varchar(255),
7 parentID varchar(255),
8 type integer,
9 version integer);
10
11CREATE TABLE inventoryitems(
12 UUID varchar(255) primary key,
13 assetID varchar(255),
14 assetType integer,
15 invType integer,
16 parentFolderID varchar(255),
17 avatarID varchar(255),
18 creatorsID varchar(255),
19 inventoryName varchar(255),
20 inventoryDescription varchar(255),
21 inventoryNextPermissions integer,
22 inventoryCurrentPermissions integer,
23 inventoryBasePermissions integer,
24 inventoryEveryOnePermissions integer,
25 salePrice integer default 99,
26 saleType integer default 0,
27 creationDate integer default 2000,
28 groupID varchar(255) default '00000000-0000-0000-0000-000000000000',
29 groupOwned integer default 0,
30 flags integer default 0);
31
32COMMIT;