1 files changed, 18 insertions, 18 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql
index 8c79483..53d2db0 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql
@@ -1,18 +1,18 @@
-CREATE TABLE `inventoryitems` (
+CREATE TABLE `inventoryitems` (
-  `inventoryID` varchar(36) NOT NULL default '',
+  `inventoryID` varchar(36) NOT NULL default '',
-  `assetID` varchar(36) default NULL,
+  `assetID` varchar(36) default NULL,
-  `assetType` int(11) default NULL,
+  `assetType` int(11) default NULL,
-  `parentFolderID` varchar(36) default NULL,
+  `parentFolderID` varchar(36) default NULL,
-  `avatarID` varchar(36) default NULL,
+  `avatarID` varchar(36) default NULL,
-  `inventoryName` varchar(64) default NULL,
+  `inventoryName` varchar(64) default NULL,
-  `inventoryDescription` varchar(64) default NULL,
+  `inventoryDescription` varchar(64) default NULL,
-  `inventoryNextPermissions` int(10) unsigned default NULL,
+  `inventoryNextPermissions` int(10) unsigned default NULL,
-  `inventoryCurrentPermissions` int(10) unsigned default NULL,
+  `inventoryCurrentPermissions` int(10) unsigned default NULL,
-  `invType` int(11) default NULL,
+  `invType` int(11) default NULL,
-  `creatorID` varchar(36) default NULL,
+  `creatorID` varchar(36) default NULL,
-  `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
+  `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
-  `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
+  `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
-  PRIMARY KEY  (`inventoryID`),
+  PRIMARY KEY  (`inventoryID`),
-  KEY `owner` (`avatarID`),
+  KEY `owner` (`avatarID`),
-  KEY `folder` (`parentFolderID`)
+  KEY `folder` (`parentFolderID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';

diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql index 8c79483..53d2db0 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql
@@ -1,18 +1,18 @@
1	CREATE TABLE `inventoryitems` (	1	CREATE TABLE `inventoryitems` (
2	`inventoryID` varchar(36) NOT NULL default '',	2	`inventoryID` varchar(36) NOT NULL default '',
3	`assetID` varchar(36) default NULL,	3	`assetID` varchar(36) default NULL,
4	`assetType` int(11) default NULL,	4	`assetType` int(11) default NULL,
5	`parentFolderID` varchar(36) default NULL,	5	`parentFolderID` varchar(36) default NULL,
6	`avatarID` varchar(36) default NULL,	6	`avatarID` varchar(36) default NULL,
7	`inventoryName` varchar(64) default NULL,	7	`inventoryName` varchar(64) default NULL,
8	`inventoryDescription` varchar(64) default NULL,	8	`inventoryDescription` varchar(64) default NULL,
9	`inventoryNextPermissions` int(10) unsigned default NULL,	9	`inventoryNextPermissions` int(10) unsigned default NULL,
10	`inventoryCurrentPermissions` int(10) unsigned default NULL,	10	`inventoryCurrentPermissions` int(10) unsigned default NULL,
11	`invType` int(11) default NULL,	11	`invType` int(11) default NULL,
12	`creatorID` varchar(36) default NULL,	12	`creatorID` varchar(36) default NULL,
13	`inventoryBasePermissions` int(10) unsigned NOT NULL default 0,	13	`inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
14	`inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,	14	`inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
15	PRIMARY KEY (`inventoryID`),	15	PRIMARY KEY (`inventoryID`),
16	KEY `owner` (`avatarID`),	16	KEY `owner` (`avatarID`),
17	KEY `folder` (`parentFolderID`)	17	KEY `folder` (`parentFolderID`)
18	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';	18	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';