diff options
author | Justin Clarke Casey | 2007-12-17 22:19:23 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2007-12-17 22:19:23 +0000 |
commit | e3a53ffc7abdeeaf31d1d378695c1cba883098ac (patch) | |
tree | d5799d42a3724a92fae9cc80243ca1c52834f5c4 /share/sql | |
parent | * Turned all instances of ForEach loops in ClientManager into Local Arrays. (diff) | |
download | opensim-SC-e3a53ffc7abdeeaf31d1d378695c1cba883098ac.zip opensim-SC-e3a53ffc7abdeeaf31d1d378695c1cba883098ac.tar.gz opensim-SC-e3a53ffc7abdeeaf31d1d378695c1cba883098ac.tar.bz2 opensim-SC-e3a53ffc7abdeeaf31d1d378695c1cba883098ac.tar.xz |
Remove now redundant mysql files from share/sql and replace with mysql_README.txt
Diffstat (limited to 'share/sql')
-rw-r--r-- | share/sql/mysql-agents.sql | 24 | ||||
-rw-r--r-- | share/sql/mysql-inventoryfolders.sql | 34 | ||||
-rw-r--r-- | share/sql/mysql-inventoryitems.sql | 32 | ||||
-rw-r--r-- | share/sql/mysql-logs.sql | 10 | ||||
-rw-r--r-- | share/sql/mysql-regions.sql | 30 | ||||
-rw-r--r-- | share/sql/mysql-reservations.txt | 16 | ||||
-rw-r--r-- | share/sql/mysql-users.sql | 34 | ||||
-rw-r--r-- | share/sql/mysql_README.txt | 12 |
8 files changed, 12 insertions, 180 deletions
diff --git a/share/sql/mysql-agents.sql b/share/sql/mysql-agents.sql deleted file mode 100644 index 8194ca9..0000000 --- a/share/sql/mysql-agents.sql +++ /dev/null | |||
@@ -1,24 +0,0 @@ | |||
1 | SET FOREIGN_KEY_CHECKS=0; | ||
2 | -- ---------------------------- | ||
3 | -- Table structure for agents | ||
4 | -- ---------------------------- | ||
5 | CREATE TABLE `agents` ( | ||
6 | `UUID` varchar(36) NOT NULL, | ||
7 | `sessionID` varchar(36) NOT NULL, | ||
8 | `secureSessionID` varchar(36) NOT NULL, | ||
9 | `agentIP` varchar(16) NOT NULL, | ||
10 | `agentPort` int(11) NOT NULL, | ||
11 | `agentOnline` tinyint(4) NOT NULL, | ||
12 | `loginTime` int(11) NOT NULL, | ||
13 | `logoutTime` int(11) NOT NULL, | ||
14 | `currentRegion` varchar(36) NOT NULL, | ||
15 | `currentHandle` bigint(20) unsigned NOT NULL, | ||
16 | `currentPos` varchar(64) NOT NULL, | ||
17 | PRIMARY KEY (`UUID`), | ||
18 | UNIQUE KEY `session` (`sessionID`), | ||
19 | UNIQUE KEY `ssession` (`secureSessionID`) | ||
20 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
21 | |||
22 | -- ---------------------------- | ||
23 | -- Records | ||
24 | -- ---------------------------- | ||
diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql deleted file mode 100644 index af6ee08..0000000 --- a/share/sql/mysql-inventoryfolders.sql +++ /dev/null | |||
@@ -1,34 +0,0 @@ | |||
1 | -- phpMyAdmin SQL Dump | ||
2 | -- version 2.11.2.2deb1 | ||
3 | -- http://www.phpmyadmin.net | ||
4 | -- | ||
5 | -- Host: localhost | ||
6 | -- Generation Time: Nov 23, 2007 at 10:19 PM | ||
7 | -- Server version: 5.0.45 | ||
8 | -- PHP Version: 5.2.4-2 | ||
9 | |||
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | ||
11 | |||
12 | -- | ||
13 | -- Database: `opensim` | ||
14 | -- | ||
15 | |||
16 | -- -------------------------------------------------------- | ||
17 | |||
18 | -- | ||
19 | -- Table structure for table `inventoryfolders` | ||
20 | -- | ||
21 | |||
22 | CREATE TABLE IF NOT EXISTS `inventoryfolders` ( | ||
23 | `folderID` varchar(36) NOT NULL default '', | ||
24 | `agentID` varchar(36) default NULL, | ||
25 | `parentFolderID` varchar(36) default NULL, | ||
26 | `folderName` varchar(64) default NULL, | ||
27 | PRIMARY KEY (`folderID`), | ||
28 | KEY `owner` (`agentID`), | ||
29 | KEY `parent` (`parentFolderID`) | ||
30 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
31 | |||
32 | -- | ||
33 | -- Dumping data for table `inventoryfolders` | ||
34 | -- | ||
diff --git a/share/sql/mysql-inventoryitems.sql b/share/sql/mysql-inventoryitems.sql deleted file mode 100644 index dea12e8..0000000 --- a/share/sql/mysql-inventoryitems.sql +++ /dev/null | |||
@@ -1,32 +0,0 @@ | |||
1 | -- PHP Version: 5.2.4-2 | ||
2 | |||
3 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | ||
4 | |||
5 | -- | ||
6 | -- Database: `opensim` | ||
7 | -- | ||
8 | |||
9 | -- -------------------------------------------------------- | ||
10 | |||
11 | -- | ||
12 | -- Table structure for table `inventoryitems` | ||
13 | -- | ||
14 | |||
15 | CREATE TABLE IF NOT EXISTS `inventoryitems` ( | ||
16 | `inventoryID` varchar(36) NOT NULL default '', | ||
17 | `assetID` varchar(36) default NULL, | ||
18 | `type` int(11) default NULL, | ||
19 | `parentFolderID` varchar(36) default NULL, | ||
20 | `avatarID` varchar(36) default NULL, | ||
21 | `inventoryName` varchar(64) default NULL, | ||
22 | `inventoryDescription` varchar(64) default NULL, | ||
23 | `inventoryNextPermissions` int(10) unsigned default NULL, | ||
24 | `inventoryCurrentPermissions` int(10) unsigned default NULL, | ||
25 | PRIMARY KEY (`inventoryID`), | ||
26 | KEY `owner` (`avatarID`), | ||
27 | KEY `folder` (`parentFolderID`) | ||
28 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
29 | |||
30 | -- | ||
31 | -- Dumping data for table `inventoryitems` | ||
32 | -- | ||
diff --git a/share/sql/mysql-logs.sql b/share/sql/mysql-logs.sql deleted file mode 100644 index 05c19e8..0000000 --- a/share/sql/mysql-logs.sql +++ /dev/null | |||
@@ -1,10 +0,0 @@ | |||
1 | CREATE TABLE `logs` ( | ||
2 | `logID` int(10) unsigned NOT NULL auto_increment, | ||
3 | `target` varchar(36) default NULL, | ||
4 | `server` varchar(64) default NULL, | ||
5 | `method` varchar(64) default NULL, | ||
6 | `arguments` varchar(255) default NULL, | ||
7 | `priority` int(11) default NULL, | ||
8 | `message` text, | ||
9 | PRIMARY KEY (`logID`) | ||
10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file | ||
diff --git a/share/sql/mysql-regions.sql b/share/sql/mysql-regions.sql deleted file mode 100644 index 9301af2..0000000 --- a/share/sql/mysql-regions.sql +++ /dev/null | |||
@@ -1,30 +0,0 @@ | |||
1 | CREATE TABLE `regions` ( | ||
2 | `uuid` varchar(36) NOT NULL, | ||
3 | `regionHandle` bigint(20) unsigned NOT NULL, | ||
4 | `regionName` varchar(32) default NULL, | ||
5 | `regionRecvKey` varchar(128) default NULL, | ||
6 | `regionSendKey` varchar(128) default NULL, | ||
7 | `regionSecret` varchar(128) default NULL, | ||
8 | `regionDataURI` varchar(255) default NULL, | ||
9 | `serverIP` varchar(64) default NULL, | ||
10 | `serverPort` int(10) unsigned default NULL, | ||
11 | `serverURI` varchar(255) default NULL, | ||
12 | `locX` int(10) unsigned default NULL, | ||
13 | `locY` int(10) unsigned default NULL, | ||
14 | `locZ` int(10) unsigned default NULL, | ||
15 | `eastOverrideHandle` bigint(20) unsigned default NULL, | ||
16 | `westOverrideHandle` bigint(20) unsigned default NULL, | ||
17 | `southOverrideHandle` bigint(20) unsigned default NULL, | ||
18 | `northOverrideHandle` bigint(20) unsigned default NULL, | ||
19 | `regionAssetURI` varchar(255) default NULL, | ||
20 | `regionAssetRecvKey` varchar(128) default NULL, | ||
21 | `regionAssetSendKey` varchar(128) default NULL, | ||
22 | `regionUserURI` varchar(255) default NULL, | ||
23 | `regionUserRecvKey` varchar(128) default NULL, | ||
24 | `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL, | ||
25 | `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL, | ||
26 | PRIMARY KEY (`uuid`), | ||
27 | KEY `regionName` (`regionName`), | ||
28 | KEY `regionHandle` (`regionHandle`), | ||
29 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) | ||
30 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED | ||
diff --git a/share/sql/mysql-reservations.txt b/share/sql/mysql-reservations.txt deleted file mode 100644 index 9dab31d..0000000 --- a/share/sql/mysql-reservations.txt +++ /dev/null | |||
@@ -1,16 +0,0 @@ | |||
1 | CREATE TABLE `reservations` ( | ||
2 | `resID` int(10) unsigned NOT NULL auto_increment, | ||
3 | `userUUID` varchar(36) default NULL, | ||
4 | `gridSendKey` varchar(64) default NULL, | ||
5 | `gridRecvKey` varchar(64) default NULL, | ||
6 | `resName` varchar(255) default NULL, | ||
7 | `resCompany` varchar(128) default NULL, | ||
8 | `resXMin` int(10) unsigned default NULL, | ||
9 | `resXMax` int(10) unsigned default NULL, | ||
10 | `resYMin` int(10) unsigned default NULL, | ||
11 | `resYMax` int(10) unsigned default NULL, | ||
12 | `status` int(10) unsigned default NULL, | ||
13 | PRIMARY KEY (`resID`), | ||
14 | KEY `resident` (`userUUID`), | ||
15 | KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`) | ||
16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; | ||
diff --git a/share/sql/mysql-users.sql b/share/sql/mysql-users.sql deleted file mode 100644 index 5ce4d1c..0000000 --- a/share/sql/mysql-users.sql +++ /dev/null | |||
@@ -1,34 +0,0 @@ | |||
1 | SET FOREIGN_KEY_CHECKS=0; | ||
2 | -- ---------------------------- | ||
3 | -- Table structure for users | ||
4 | -- ---------------------------- | ||
5 | CREATE TABLE `users` ( | ||
6 | `UUID` varchar(36) NOT NULL default '', | ||
7 | `username` varchar(32) NOT NULL, | ||
8 | `lastname` varchar(32) NOT NULL, | ||
9 | `passwordHash` varchar(32) NOT NULL, | ||
10 | `passwordSalt` varchar(32) NOT NULL, | ||
11 | `homeRegion` bigint(20) unsigned default NULL, | ||
12 | `homeLocationX` float default NULL, | ||
13 | `homeLocationY` float default NULL, | ||
14 | `homeLocationZ` float default NULL, | ||
15 | `homeLookAtX` float default NULL, | ||
16 | `homeLookAtY` float default NULL, | ||
17 | `homeLookAtZ` float default NULL, | ||
18 | `created` int(11) NOT NULL, | ||
19 | `lastLogin` int(11) NOT NULL, | ||
20 | `userInventoryURI` varchar(255) default NULL, | ||
21 | `userAssetURI` varchar(255) default NULL, | ||
22 | `profileCanDoMask` int(10) unsigned default NULL, | ||
23 | `profileWantDoMask` int(10) unsigned default NULL, | ||
24 | `profileAboutText` text, | ||
25 | `profileFirstText` text, | ||
26 | `profileImage` varchar(36) default NULL, | ||
27 | `profileFirstImage` varchar(36) default NULL, | ||
28 | PRIMARY KEY (`UUID`), | ||
29 | UNIQUE KEY `usernames` (`username`,`lastname`) | ||
30 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
31 | |||
32 | -- ---------------------------- | ||
33 | -- Records | ||
34 | -- ---------------------------- | ||
diff --git a/share/sql/mysql_README.txt b/share/sql/mysql_README.txt new file mode 100644 index 0000000..6907c7a --- /dev/null +++ b/share/sql/mysql_README.txt | |||
@@ -0,0 +1,12 @@ | |||
1 | mysql_README | ||
2 | |||
3 | This directory used to contain sql files for mysql that needed to be manually sourced in order to | ||
4 | set up the database tables required by OpenSim. This is no longer necessary - OpenSim now sets | ||
5 | up these tables automatically. All you need to do is | ||
6 | create the database that OpenSim is to use and set the configuration in bin/mysql_connection.ini | ||
7 | (using bin/mysql_connection.ini.example as a reference). | ||
8 | |||
9 | If you do need to source the mysql files manually, they can be found in OpenSim/Framework/Data.MySQL/Resources | ||
10 | |||
11 | Please note that if you are setting up a MSSQL database, the appropriate mssql files do still need to be | ||
12 | executed manually. | ||