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.sql9
1 files changed, 7 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql b/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
index 84701db..40dc91c 100644
--- a/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
+++ b/OpenSim/Data/MySQL/Resources/001_InventoryStore.sql
@@ -1,3 +1,5 @@
1BEGIN;
2
1CREATE TABLE `inventoryfolders` ( 3CREATE TABLE `inventoryfolders` (
2 `folderID` varchar(36) NOT NULL default '', 4 `folderID` varchar(36) NOT NULL default '',
3 `agentID` varchar(36) default NULL, 5 `agentID` varchar(36) default NULL,
@@ -8,7 +10,8 @@ CREATE TABLE `inventoryfolders` (
8 PRIMARY KEY (`folderID`), 10 PRIMARY KEY (`folderID`),
9 KEY `owner` (`agentID`), 11 KEY `owner` (`agentID`),
10 KEY `parent` (`parentFolderID`) 12 KEY `parent` (`parentFolderID`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; 13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
12CREATE TABLE `inventoryitems` ( 15CREATE TABLE `inventoryitems` (
13 `inventoryID` varchar(36) NOT NULL default '', 16 `inventoryID` varchar(36) NOT NULL default '',
14 `assetID` varchar(36) default NULL, 17 `assetID` varchar(36) default NULL,
@@ -32,4 +35,6 @@ CREATE TABLE `inventoryitems` (
32 PRIMARY KEY (`inventoryID`), 35 PRIMARY KEY (`inventoryID`),
33 KEY `owner` (`avatarID`), 36 KEY `owner` (`avatarID`),
34 KEY `folder` (`parentFolderID`) 37 KEY `folder` (`parentFolderID`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 3'; 38) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
40COMMIT; \ No newline at end of file