Moved this into releng/dist (otherwise it doesn't turn up in binary builds)

author: gareth 2007-05-27 23:38:17 +0000
committer: gareth 2007-05-27 23:38:17 +0000
commit: 4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07 (patch)
tree: 37f11d87fe38e13d527ac254466d1797ad73e041 /releng/dist
parent: I don't know WHY this fixes it but it does (diff)
download: opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.zip
opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.gz
opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.bz2
opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.xz
3 files changed, 87 insertions, 0 deletions
diff --git a/releng/dist/SQL/mysql-agents.sql b/releng/dist/SQL/mysql-agents.sql
new file mode 100644
index 0000000..8194ca9
--- /dev/null
+++ b/releng/dist/SQL/mysql-agents.sql
@@ -0,0 +1,24 @@
+SET FOREIGN_KEY_CHECKS=0;
+-- ----------------------------
+-- Table structure for agents
+-- ----------------------------
+CREATE TABLE `agents` (
+  `UUID` varchar(36) NOT NULL,
+  `sessionID` varchar(36) NOT NULL,
+  `secureSessionID` varchar(36) NOT NULL,
+  `agentIP` varchar(16) NOT NULL,
+  `agentPort` int(11) NOT NULL,
+  `agentOnline` tinyint(4) NOT NULL,
+  `loginTime` int(11) NOT NULL,
+  `logoutTime` int(11) NOT NULL,
+  `currentRegion` varchar(36) NOT NULL,
+  `currentHandle` bigint(20) unsigned NOT NULL,
+  `currentPos` varchar(64) NOT NULL,
+  PRIMARY KEY  (`UUID`),
+  UNIQUE KEY `session` (`sessionID`),
+  UNIQUE KEY `ssession` (`secureSessionID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+-- ----------------------------
+-- Records 
+-- ----------------------------
diff --git a/releng/dist/SQL/mysql-regions.sql b/releng/dist/SQL/mysql-regions.sql
new file mode 100644
index 0000000..4f98826
--- /dev/null
+++ b/releng/dist/SQL/mysql-regions.sql
@@ -0,0 +1,29 @@
+CREATE TABLE `regions` (
+  `uuid` varchar(36) NOT NULL,
+  `regionHandle` bigint(20) unsigned NOT NULL,
+  `regionName` varchar(32) default NULL,
+  `regionRecvKey` varchar(128) default NULL,
+  `regionSendKey` varchar(128) default NULL,
+  `regionSecret` varchar(128) default NULL,
+  `regionDataURI` varchar(255) default NULL,
+  `serverIP` varchar(16) default NULL,
+  `serverPort` int(10) unsigned default NULL,
+  `serverURI` varchar(255) default NULL,
+  `locX` int(10) unsigned default NULL,
+  `locY` int(10) unsigned default NULL,
+  `locZ` int(10) unsigned default NULL,
+  `eastOverrideHandle` bigint(20) unsigned default NULL,
+  `westOverrideHandle` bigint(20) unsigned default NULL,
+  `southOverrideHandle` bigint(20) unsigned default NULL,
+  `northOverrideHandle` bigint(20) unsigned default NULL,
+  `regionAssetURI` varchar(255) default NULL,
+  `regionAssetRecvKey` varchar(128) default NULL,
+  `regionAssetSendKey` varchar(128) default NULL,
+  `regionUserURI` varchar(255) default NULL,
+  `regionUserRecvKey` varchar(128) default NULL,
+  `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
+  PRIMARY KEY  (`uuid`),
+  KEY `regionName` (`regionName`),
+  KEY `regionHandle` (`regionHandle`),
+  KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
+\ No newline at end of file
diff --git a/releng/dist/SQL/mysql-users.sql b/releng/dist/SQL/mysql-users.sql
new file mode 100644
index 0000000..5ce4d1c
--- /dev/null
+++ b/releng/dist/SQL/mysql-users.sql
@@ -0,0 +1,34 @@
+SET FOREIGN_KEY_CHECKS=0;
+-- ----------------------------
+-- Table structure for users
+-- ----------------------------
+CREATE TABLE `users` (
+  `UUID` varchar(36) NOT NULL default '',
+  `username` varchar(32) NOT NULL,
+  `lastname` varchar(32) NOT NULL,
+  `passwordHash` varchar(32) NOT NULL,
+  `passwordSalt` varchar(32) NOT NULL,
+  `homeRegion` bigint(20) unsigned default NULL,
+  `homeLocationX` float default NULL,
+  `homeLocationY` float default NULL,
+  `homeLocationZ` float default NULL,
+  `homeLookAtX` float default NULL,
+  `homeLookAtY` float default NULL,
+  `homeLookAtZ` float default NULL,
+  `created` int(11) NOT NULL,
+  `lastLogin` int(11) NOT NULL,
+  `userInventoryURI` varchar(255) default NULL,
+  `userAssetURI` varchar(255) default NULL,
+  `profileCanDoMask` int(10) unsigned default NULL,
+  `profileWantDoMask` int(10) unsigned default NULL,
+  `profileAboutText` text,
+  `profileFirstText` text,
+  `profileImage` varchar(36) default NULL,
+  `profileFirstImage` varchar(36) default NULL,
+  PRIMARY KEY  (`UUID`),
+  UNIQUE KEY `usernames` (`username`,`lastname`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+-- ----------------------------
+-- Records 
+-- ----------------------------
author	gareth	2007-05-27 23:38:17 +0000
committer	gareth	2007-05-27 23:38:17 +0000
commit	4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07 (patch)
tree	37f11d87fe38e13d527ac254466d1797ad73e041 /releng/dist
parent	I don't know WHY this fixes it but it does (diff)
download	opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.zip opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.gz opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.bz2 opensim-SC_OLD-4bc85e83316b60fdbae2350f4a14ae1c9f8f4a07.tar.xz

diff --git a/releng/dist/SQL/mysql-agents.sql b/releng/dist/SQL/mysql-agents.sql new file mode 100644 index 0000000..8194ca9 --- /dev/null +++ b/releng/dist/SQL/mysql-agents.sql
@@ -0,0 +1,24 @@
	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/releng/dist/SQL/mysql-regions.sql b/releng/dist/SQL/mysql-regions.sql new file mode 100644 index 0000000..4f98826 --- /dev/null +++ b/releng/dist/SQL/mysql-regions.sql
@@ -0,0 +1,29 @@
	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(16) 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	PRIMARY KEY (`uuid`),
	26	KEY `regionName` (`regionName`),
	27	KEY `regionHandle` (`regionHandle`),
	28	KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
	29	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED \ No newline at end of file


diff --git a/releng/dist/SQL/mysql-users.sql b/releng/dist/SQL/mysql-users.sql new file mode 100644 index 0000000..5ce4d1c --- /dev/null +++ b/releng/dist/SQL/mysql-users.sql
@@ -0,0 +1,34 @@
	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	-- ----------------------------