aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorgareth2007-03-08 01:34:55 +0000
committergareth2007-03-08 01:34:55 +0000
commitc8a9387cda70e3d6ea33b8fa0ac4782413f30f94 (patch)
tree958b0ed58e38be3536e365ee23cba1d8bee31ab4
parentPrimitives movement and rotation updates are now sent to all clients (diff)
downloadopensim-SC_OLD-c8a9387cda70e3d6ea33b8fa0ac4782413f30f94.zip
opensim-SC_OLD-c8a9387cda70e3d6ea33b8fa0ac4782413f30f94.tar.gz
opensim-SC_OLD-c8a9387cda70e3d6ea33b8fa0ac4782413f30f94.tar.bz2
opensim-SC_OLD-c8a9387cda70e3d6ea33b8fa0ac4782413f30f94.tar.xz
Brought OGS.sql back into trunk
-rw-r--r--OGS.sql134
1 files changed, 134 insertions, 0 deletions
diff --git a/OGS.sql b/OGS.sql
new file mode 100644
index 0000000..5efaf97
--- /dev/null
+++ b/OGS.sql
@@ -0,0 +1,134 @@
1-- phpMyAdmin SQL Dump
2-- version 2.6.3-pl1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 16, 2007 at 09:54 PM
7-- Server version: 4.0.23
8-- PHP Version: 4.4.0
9--
10-- Database: `OGS`
11--
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `Grid_settings`
17--
18
19DROP TABLE IF EXISTS `Grid_settings`;
20CREATE TABLE IF NOT EXISTS `Grid_settings` (
21 `Setting` text NOT NULL,
22 `value` text NOT NULL
23) TYPE=MyISAM;
24
25--
26-- Dumping data for table `Grid_settings`
27--
28
29INSERT INTO `Grid_settings` (`Setting`, `value`) VALUES ('highest_LLUUID', '51AEFF430000000000000000000002fd');
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `foreign_profiles`
35--
36
37DROP TABLE IF EXISTS `foreign_profiles`;
38CREATE TABLE IF NOT EXISTS `foreign_profiles` (
39 `userprofile_LLUUID` varchar(32) NOT NULL default '',
40 `foreigngrid` text NOT NULL,
41 `profile_firstname` text NOT NULL,
42 `profile_lastname` text NOT NULL,
43 `profile_passwdmd5` text NOT NULL,
44 `homesim_ip` text NOT NULL,
45 `homesim_port` int(11) NOT NULL default '0',
46 `homeasset_url` text NOT NULL,
47 `homeuser_url` text NOT NULL,
48 `look_at` text NOT NULL,
49 `region_handle` text NOT NULL,
50 `position` text NOT NULL,
51 PRIMARY KEY (`userprofile_LLUUID`)
52) TYPE=MyISAM;
53
54--
55-- Dumping data for table `foreign_profiles`
56--
57
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `local_user_profiles`
63--
64
65DROP TABLE IF EXISTS `local_user_profiles`;
66CREATE TABLE IF NOT EXISTS `local_user_profiles` (
67 `userprofile_LLUUID` varchar(32) NOT NULL default '',
68 `profile_firstname` text NOT NULL,
69 `profile_lastname` text NOT NULL,
70 `profile_passwdmd5` text NOT NULL,
71 `homesim_ip` text NOT NULL,
72 `homesim_port` int(11) NOT NULL default '0',
73 `homeasset_url` text NOT NULL,
74 `look_at` text NOT NULL,
75 `region_handle` text NOT NULL,
76 `position` text NOT NULL,
77 PRIMARY KEY (`userprofile_LLUUID`)
78) TYPE=MyISAM;
79
80--
81-- Dumping data for table `local_user_profiles`
82--
83
84INSERT INTO `local_user_profiles` (`userprofile_LLUUID`, `profile_firstname`, `profile_lastname`, `profile_passwdmd5`, `homesim_ip`, `homesim_port`, `homeasset_url`, `look_at`, `region_handle`, `position`) VALUES ('51AEFF43000000000000000000000100', 'Test', 'User', '$1$098f6bcd4621d373cade4e832627b4f6', '127.0.0.1', 1000, 'http://dummyassetserver.net/', 'r-0.57343, r-0.819255,r0', 'r255232,254976', 'r41.6589, r100.8374, r22.5072');
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `region_profiles`
90--
91
92DROP TABLE IF EXISTS `region_profiles`;
93CREATE TABLE IF NOT EXISTS `region_profiles` (
94 `RegionID` varchar(32) NOT NULL default '',
95 `Name` text NOT NULL,
96 `GridLocX` bigint(20) NOT NULL default '0',
97 `GridLocY` bigint(20) NOT NULL default '0',
98 `region_handle` text NOT NULL,
99 `ip_addr` text NOT NULL,
100 `port` text NOT NULL,
101 PRIMARY KEY (`RegionID`)
102) TYPE=MyISAM;
103
104--
105-- Dumping data for table `region_profiles`
106--
107
108INSERT INTO `region_profiles` (`RegionID`, `Name`, `GridLocX`, `GridLocY`, `region_handle`, `ip_addr`, `port`) VALUES ('51AEFF43000000000000000000000200', 'Test sandbox', 997, 996, 'r255232,254976', '127.0.0.1', '1000');
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `sessions`
114--
115
116DROP TABLE IF EXISTS `sessions`;
117CREATE TABLE IF NOT EXISTS `sessions` (
118 `session_id` varchar(32) NOT NULL default '',
119 `secure_session_id` text NOT NULL,
120 `agent_id` text NOT NULL,
121 `session_start` datetime NOT NULL default '0000-00-00 00:00:00',
122 `session_end` datetime NOT NULL default '0000-00-00 00:00:00',
123 `session_active` tinyint(4) NOT NULL default '0',
124 `current_location` text NOT NULL,
125 `remote_ip` text NOT NULL,
126 `circuit_code` int(11) NOT NULL default '0',
127 PRIMARY KEY (`session_id`)
128) TYPE=MyISAM;
129
130--
131-- Dumping data for table `sessions`
132--
133
134INSERT INTO `sessions` (`session_id`, `secure_session_id`, `agent_id`, `session_start`, `session_end`, `session_active`, `current_location`, `remote_ip`, `circuit_code`) VALUES ('51AEFF430000000000000000000002fc', '51AEFF430000000000000000000002fd', '51AEFF43000000000000000000000100', '2007-02-16 21:13:19', '0000-00-00 00:00:00', 1, 'r255232,254976', '81.174.255.70', 0);