aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/001_InventoryStore.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_InventoryStore.sql48
1 files changed, 27 insertions, 21 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
index e4951b0..554d5c2 100644
--- a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
@@ -1,26 +1,32 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3CREATE TABLE inventoryitems(
4 UUID varchar(255) primary key,
5 assetID varchar(255),
6 assetType integer,
7 invType integer,
8 parentFolderID varchar(255),
9 avatarID varchar(255),
10 creatorsID varchar(255),
11 inventoryName varchar(255),
12 inventoryDescription varchar(255),
13 inventoryNextPermissions integer,
14 inventoryCurrentPermissions integer,
15 inventoryBasePermissions integer,
16 inventoryEveryOnePermissions integer);
17
18CREATE TABLE inventoryfolders( 3CREATE TABLE inventoryfolders(
19 UUID varchar(255) primary key, 4 UUID varchar(255) primary key,
20 name varchar(255), 5 name varchar(255),
21 agentID varchar(255), 6 agentID varchar(255),
22 parentID varchar(255), 7 parentID varchar(255),
23 type integer, 8 type integer,
24 version 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);
25 31
26COMMIT; 32COMMIT;