aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/001_InventoryStore.sql')
-rw-r--r--OpenSim/Data/MySQL/Resources/001_InventoryStore.sql35
1 files changed, 35 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql b/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
new file mode 100644
index 0000000..84701db
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
@@ -0,0 +1,35 @@
1CREATE TABLE `inventoryfolders` (
2 `folderID` varchar(36) NOT NULL default '',
3 `agentID` varchar(36) default NULL,
4 `parentFolderID` varchar(36) default NULL,
5 `folderName` varchar(64) default NULL,
6 `type` smallint NOT NULL default 0,
7 `version` int NOT NULL default 0,
8 PRIMARY KEY (`folderID`),
9 KEY `owner` (`agentID`),
10 KEY `parent` (`parentFolderID`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
12CREATE TABLE `inventoryitems` (
13 `inventoryID` varchar(36) NOT NULL default '',
14 `assetID` varchar(36) default NULL,
15 `assetType` int(11) default NULL,
16 `parentFolderID` varchar(36) default NULL,
17 `avatarID` varchar(36) default NULL,
18 `inventoryName` varchar(64) default NULL,
19 `inventoryDescription` varchar(128) default NULL,
20 `inventoryNextPermissions` int(10) unsigned default NULL,
21 `inventoryCurrentPermissions` int(10) unsigned default NULL,
22 `invType` int(11) default NULL,
23 `creatorID` varchar(36) default NULL,
24 `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
25 `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
26 `salePrice` int(11) NOT NULL default 0,
27 `saleType` tinyint(4) NOT NULL default 0,
28 `creationDate` int(11) NOT NULL default 0,
29 `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
30 `groupOwned` tinyint(4) NOT NULL default 0,
31 `flags` int(11) unsigned NOT NULL default 0,
32 PRIMARY KEY (`inventoryID`),
33 KEY `owner` (`avatarID`),
34 KEY `folder` (`parentFolderID`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 3';