From 2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Mon, 16 Jul 2007 15:40:11 +0000 Subject: changed to native line ending encoding --- share/sql/mysql-inventoryfolders.sql | 18 +++++++++--------- share/sql/mysql-inventoryitems.sql | 28 ++++++++++++++-------------- share/sql/mysql-reservations.txt | 32 ++++++++++++++++---------------- 3 files changed, 39 insertions(+), 39 deletions(-) (limited to 'share/sql') 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 ; -- cgit v1.1