aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
-rw-r--r--share/sql/mysql-agents.sql24
-rw-r--r--share/sql/mysql-inventoryfolders.sql34
-rw-r--r--share/sql/mysql-inventoryitems.sql32
-rw-r--r--share/sql/mysql-logs.sql10
-rw-r--r--share/sql/mysql-regions.sql30
-rw-r--r--share/sql/mysql-reservations.txt16
-rw-r--r--share/sql/mysql-users.sql34
-rw-r--r--share/sql/mysql_README.txt12
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 @@
1SET FOREIGN_KEY_CHECKS=0;
2-- ----------------------------
3-- Table structure for agents
4-- ----------------------------
5CREATE 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
10SET 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
22CREATE 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
3SET 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
15CREATE 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 @@
1CREATE 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 @@
1CREATE 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 @@
1CREATE 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 @@
1SET FOREIGN_KEY_CHECKS=0;
2-- ----------------------------
3-- Table structure for users
4-- ----------------------------
5CREATE 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 @@
1mysql_README
2
3This directory used to contain sql files for mysql that needed to be manually sourced in order to
4set up the database tables required by OpenSim. This is no longer necessary - OpenSim now sets
5up these tables automatically. All you need to do is
6create 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
9If you do need to source the mysql files manually, they can be found in OpenSim/Framework/Data.MySQL/Resources
10
11Please note that if you are setting up a MSSQL database, the appropriate mssql files do still need to be
12executed manually.