diff options
Diffstat (limited to 'OGS.sql')
-rw-r--r-- | OGS.sql | 134 |
1 files changed, 134 insertions, 0 deletions
@@ -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 | |||
19 | DROP TABLE IF EXISTS `Grid_settings`; | ||
20 | CREATE 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 | |||
29 | INSERT INTO `Grid_settings` (`Setting`, `value`) VALUES ('highest_LLUUID', '51AEFF430000000000000000000002fd'); | ||
30 | |||
31 | -- -------------------------------------------------------- | ||
32 | |||
33 | -- | ||
34 | -- Table structure for table `foreign_profiles` | ||
35 | -- | ||
36 | |||
37 | DROP TABLE IF EXISTS `foreign_profiles`; | ||
38 | CREATE 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 | |||
65 | DROP TABLE IF EXISTS `local_user_profiles`; | ||
66 | CREATE 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 | |||
84 | INSERT 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 | |||
92 | DROP TABLE IF EXISTS `region_profiles`; | ||
93 | CREATE 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 | |||
108 | INSERT 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 | |||
116 | DROP TABLE IF EXISTS `sessions`; | ||
117 | CREATE 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 | |||
134 | INSERT 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); | ||