changed to native line ending encoding

author: Sean Dague 2007-07-16 15:40:11 +0000
committer: Sean Dague 2007-07-16 15:40:11 +0000
commit: 2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6 (patch)
tree: e3f80ad51736cf17e856547b1bcf956010927434 /share/sql
parent: *Trunk compiles now (diff)
download: opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.zip
opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.gz
opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.bz2
opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.xz
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` (
+CREATE TABLE `inventoryfolders` (
-  `folderID` varchar(36) NOT NULL default '',
+  `folderID` varchar(36) NOT NULL default '',
-  `agentID` varchar(36) default NULL,
+  `agentID` varchar(36) default NULL,
-  `parentFolderID` varchar(36) default NULL,
+  `parentFolderID` varchar(36) default NULL,
-  `folderName` varchar(64) default NULL,
+  `folderName` varchar(64) default NULL,
-  PRIMARY KEY  (`folderID`),
+  PRIMARY KEY  (`folderID`),
-  KEY `owner` (`agentID`),
+  KEY `owner` (`agentID`),
-  KEY `parent` (`parentFolderID`)
+  KEY `parent` (`parentFolderID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) 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` (
+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,
-  `type` int(11) default NULL,
+  `type` 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,
-  PRIMARY KEY  (`inventoryID`),
+  PRIMARY KEY  (`inventoryID`),
-  KEY `owner` (`avatarID`),
+  KEY `owner` (`avatarID`),
-  KEY `folder` (`parentFolderID`)
+  KEY `folder` (`parentFolderID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) 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` (
+CREATE TABLE `reservations` (
-  `resID` int(10) unsigned NOT NULL auto_increment,
+  `resID` int(10) unsigned NOT NULL auto_increment,
-  `userUUID` varchar(36) default NULL,
+  `userUUID` varchar(36) default NULL,
-  `gridSendKey` varchar(64) default NULL,
+  `gridSendKey` varchar(64) default NULL,
-  `gridRecvKey` varchar(64) default NULL,
+  `gridRecvKey` varchar(64) default NULL,
-  `resName` varchar(255) default NULL,
+  `resName` varchar(255) default NULL,
-  `resCompany` varchar(128) default NULL,
+  `resCompany` varchar(128) default NULL,
-  `resXMin` int(10) unsigned default NULL,
+  `resXMin` int(10) unsigned default NULL,
-  `resXMax` int(10) unsigned default NULL,
+  `resXMax` int(10) unsigned default NULL,
-  `resYMin` int(10) unsigned default NULL,
+  `resYMin` int(10) unsigned default NULL,
-  `resYMax` int(10) unsigned default NULL,
+  `resYMax` int(10) unsigned default NULL,
-  `status` int(10) unsigned default NULL,
+  `status` int(10) unsigned default NULL,
-  PRIMARY KEY  (`resID`),
+  PRIMARY KEY  (`resID`),
-  KEY `resident` (`userUUID`),
+  KEY `resident` (`userUUID`),
-  KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
+  KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
author	Sean Dague	2007-07-16 15:40:11 +0000
committer	Sean Dague	2007-07-16 15:40:11 +0000
commit	2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6 (patch)
tree	e3f80ad51736cf17e856547b1bcf956010927434 /share/sql
parent	*Trunk compiles now (diff)
download	opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.zip opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.gz opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.bz2 opensim-SC_OLD-2a3c79df83e800d5dfe75a1a3b140ed81da2b1d6.tar.xz

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 @@
1	CREATE TABLE `inventoryfolders` (	1	CREATE TABLE `inventoryfolders` (
2	`folderID` varchar(36) NOT NULL default '',	2	`folderID` varchar(36) NOT NULL default '',
3	`agentID` varchar(36) default NULL,	3	`agentID` varchar(36) default NULL,
4	`parentFolderID` varchar(36) default NULL,	4	`parentFolderID` varchar(36) default NULL,
5	`folderName` varchar(64) default NULL,	5	`folderName` varchar(64) default NULL,
6	PRIMARY KEY (`folderID`),	6	PRIMARY KEY (`folderID`),
7	KEY `owner` (`agentID`),	7	KEY `owner` (`agentID`),
8	KEY `parent` (`parentFolderID`)	8	KEY `parent` (`parentFolderID`)
9	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	9	) 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 @@
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	`type` int(11) default NULL,	4	`type` 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	PRIMARY KEY (`inventoryID`),	11	PRIMARY KEY (`inventoryID`),
12	KEY `owner` (`avatarID`),	12	KEY `owner` (`avatarID`),
13	KEY `folder` (`parentFolderID`)	13	KEY `folder` (`parentFolderID`)
14	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	14	) 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 @@
1	CREATE TABLE `reservations` (	1	CREATE TABLE `reservations` (
2	`resID` int(10) unsigned NOT NULL auto_increment,	2	`resID` int(10) unsigned NOT NULL auto_increment,
3	`userUUID` varchar(36) default NULL,	3	`userUUID` varchar(36) default NULL,
4	`gridSendKey` varchar(64) default NULL,	4	`gridSendKey` varchar(64) default NULL,
5	`gridRecvKey` varchar(64) default NULL,	5	`gridRecvKey` varchar(64) default NULL,
6	`resName` varchar(255) default NULL,	6	`resName` varchar(255) default NULL,
7	`resCompany` varchar(128) default NULL,	7	`resCompany` varchar(128) default NULL,
8	`resXMin` int(10) unsigned default NULL,	8	`resXMin` int(10) unsigned default NULL,
9	`resXMax` int(10) unsigned default NULL,	9	`resXMax` int(10) unsigned default NULL,
10	`resYMin` int(10) unsigned default NULL,	10	`resYMin` int(10) unsigned default NULL,
11	`resYMax` int(10) unsigned default NULL,	11	`resYMax` int(10) unsigned default NULL,
12	`status` int(10) unsigned default NULL,	12	`status` int(10) unsigned default NULL,
13	PRIMARY KEY (`resID`),	13	PRIMARY KEY (`resID`),
14	KEY `resident` (`userUUID`),	14	KEY `resident` (`userUUID`),
15	KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)	15	KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
16	) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;	16	) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;