5 files changed, 52 insertions, 52 deletions

diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
index b9c1b97..2c750fe 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/CreateAssetsTable.sql
@@ -1,11 +1,11 @@
-CREATE TABLE `assets` (

-  `id` binary(16) NOT NULL,

-  `name` varchar(64) NOT NULL,

-  `description` varchar(64) NOT NULL,

-  `assetType` tinyint(4) NOT NULL,

-  `invType` tinyint(4) NOT NULL,

-  `local` tinyint(1) NOT NULL,

-  `temporary` tinyint(1) NOT NULL,

-  `data` longblob NOT NULL,

-  PRIMARY KEY (`id`)

+CREATE TABLE `assets` (
+  `id` binary(16) NOT NULL,
+  `name` varchar(64) NOT NULL,
+  `description` varchar(64) NOT NULL,
+  `assetType` tinyint(4) NOT NULL,
+  `invType` tinyint(4) NOT NULL,
+  `local` tinyint(1) NOT NULL,
+  `temporary` tinyint(1) NOT NULL,
+  `data` longblob NOT NULL,
+  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
\ No newline at end of file
diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql
index 2bb5553..b5bddde 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql
@@ -1,11 +1,11 @@
-CREATE TABLE `inventoryfolders` (

-  `folderID` varchar(36) NOT NULL default '',

-  `agentID` varchar(36) default NULL,

-  `parentFolderID` varchar(36) default NULL,

-  `folderName` varchar(64) default NULL,

-  `type` smallint NOT NULL default 0,

-  `version` int NOT NULL default 0,

-  PRIMARY KEY  (`folderID`),

-  KEY `owner` (`agentID`),

-  KEY `parent` (`parentFolderID`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';

+CREATE TABLE `inventoryfolders` (
+  `folderID` varchar(36) NOT NULL default '',
+  `agentID` varchar(36) default NULL,
+  `parentFolderID` varchar(36) default NULL,
+  `folderName` varchar(64) default NULL,
+  `type` smallint NOT NULL default 0,
+  `version` int NOT NULL default 0,
+  PRIMARY KEY  (`folderID`),
+  KEY `owner` (`agentID`),
+  KEY `parent` (`parentFolderID`)
+) 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 @@
-CREATE TABLE `inventoryitems` (

-  `inventoryID` varchar(36) NOT NULL default '',

-  `assetID` varchar(36) default NULL,

-  `assetType` int(11) default NULL,

-  `parentFolderID` varchar(36) default NULL,

-  `avatarID` varchar(36) default NULL,

-  `inventoryName` varchar(64) default NULL,

-  `inventoryDescription` varchar(64) default NULL,

-  `inventoryNextPermissions` int(10) unsigned default NULL,

-  `inventoryCurrentPermissions` int(10) unsigned default NULL,

-  `invType` int(11) default NULL,

-  `creatorID` varchar(36) default NULL,

-  `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,

-  `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,

-  PRIMARY KEY  (`inventoryID`),

-  KEY `owner` (`avatarID`),

-  KEY `folder` (`parentFolderID`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';

+CREATE TABLE `inventoryitems` (
+  `inventoryID` varchar(36) NOT NULL default '',
+  `assetID` varchar(36) default NULL,
+  `assetType` int(11) default NULL,
+  `parentFolderID` varchar(36) default NULL,
+  `avatarID` varchar(36) default NULL,
+  `inventoryName` varchar(64) default NULL,
+  `inventoryDescription` varchar(64) default NULL,
+  `inventoryNextPermissions` int(10) unsigned default NULL,
+  `inventoryCurrentPermissions` int(10) unsigned default NULL,
+  `invType` int(11) default NULL,
+  `creatorID` varchar(36) default NULL,
+  `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
+  `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
+  PRIMARY KEY  (`inventoryID`),
+  KEY `owner` (`avatarID`),
+  KEY `folder` (`parentFolderID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeFoldersTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeFoldersTableToVersion2.sql
index 813c7c4..b5a7964 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/UpgradeFoldersTableToVersion2.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/UpgradeFoldersTableToVersion2.sql
@@ -1,4 +1,4 @@
-ALTER TABLE `inventoryfolders` 

-        ADD COLUMN `type` smallint NOT NULL default 0,

-        ADD COLUMN `version` int NOT NULL default 0,

-COMMENT='Rev. 2';

+ALTER TABLE `inventoryfolders` 
+        ADD COLUMN `type` smallint NOT NULL default 0,
+        ADD COLUMN `version` int NOT NULL default 0,
+COMMENT='Rev. 2';
diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql
index c47786c..d1ef504 100644
--- a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql
+++ b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql
@@ -1,9 +1,9 @@
-ALTER TABLE `inventoryitems` 

-        CHANGE COLUMN `type` `assetType` int(11) default NULL,

-        ADD COLUMN `invType` int(11) default NULL,

-        ADD COLUMN `creatorID` varchar(36) default NULL,

-        ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,

-        ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,

-COMMENT='Rev. 2';

-

-UPDATE `inventoryitems` SET invType=assetType;

+ALTER TABLE `inventoryitems` 
+        CHANGE COLUMN `type` `assetType` int(11) default NULL,
+        ADD COLUMN `invType` int(11) default NULL,
+        ADD COLUMN `creatorID` varchar(36) default NULL,
+        ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
+        ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
+COMMENT='Rev. 2';
+
+UPDATE `inventoryitems` SET invType=assetType;