3 files changed, 39 insertions, 39 deletions

diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql
index c30239e..8704702 100644
--- a/share/sql/mysql-inventoryfolders.sql
+++ b/share/sql/mysql-inventoryfolders.sql
@@ -1,9 +1,9 @@
-CREATE TABLE `inventoryfolders` (

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

-  `agentID` varchar(36) default NULL,

-  `parentFolderID` varchar(36) default NULL,

-  `folderName` varchar(64) default NULL,

-  PRIMARY KEY  (`folderID`),

-  KEY `owner` (`agentID`),

-  KEY `parent` (`parentFolderID`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+CREATE TABLE `inventoryfolders` (
+  `folderID` varchar(36) NOT NULL default '',
+  `agentID` varchar(36) default NULL,
+  `parentFolderID` varchar(36) default NULL,
+  `folderName` varchar(64) default NULL,
+  PRIMARY KEY  (`folderID`),
+  KEY `owner` (`agentID`),
+  KEY `parent` (`parentFolderID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/share/sql/mysql-inventoryitems.sql b/share/sql/mysql-inventoryitems.sql
index 6e90005..5e03b8d 100644
--- a/share/sql/mysql-inventoryitems.sql
+++ b/share/sql/mysql-inventoryitems.sql
@@ -1,14 +1,14 @@
-CREATE TABLE `inventoryitems` (

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

-  `assetID` varchar(36) default NULL,

-  `type` 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,

-  PRIMARY KEY  (`inventoryID`),

-  KEY `owner` (`avatarID`),

-  KEY `folder` (`parentFolderID`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+CREATE TABLE `inventoryitems` (
+  `inventoryID` varchar(36) NOT NULL default '',
+  `assetID` varchar(36) default NULL,
+  `type` 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,
+  PRIMARY KEY  (`inventoryID`),
+  KEY `owner` (`avatarID`),
+  KEY `folder` (`parentFolderID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/share/sql/mysql-reservations.txt b/share/sql/mysql-reservations.txt
index d6d84b9..9dab31d 100644
--- a/share/sql/mysql-reservations.txt
+++ b/share/sql/mysql-reservations.txt
@@ -1,16 +1,16 @@
-CREATE TABLE `reservations` (

-  `resID` int(10) unsigned NOT NULL auto_increment,

-  `userUUID` varchar(36) default NULL,

-  `gridSendKey` varchar(64) default NULL,

-  `gridRecvKey` varchar(64) default NULL,

-  `resName` varchar(255) default NULL,

-  `resCompany` varchar(128) default NULL,

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

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

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

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

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

-  PRIMARY KEY  (`resID`),

-  KEY `resident` (`userUUID`),

-  KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

+CREATE TABLE `reservations` (
+  `resID` int(10) unsigned NOT NULL auto_increment,
+  `userUUID` varchar(36) default NULL,
+  `gridSendKey` varchar(64) default NULL,
+  `gridRecvKey` varchar(64) default NULL,
+  `resName` varchar(255) default NULL,
+  `resCompany` varchar(128) default NULL,
+  `resXMin` int(10) unsigned default NULL,
+  `resXMax` int(10) unsigned default NULL,
+  `resYMin` int(10) unsigned default NULL,
+  `resYMax` int(10) unsigned default NULL,
+  `status` int(10) unsigned default NULL,
+  PRIMARY KEY  (`resID`),
+  KEY `resident` (`userUUID`),
+  KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;