· 6 years ago · Jan 29, 2020, 01:34 PM
1-- MySQL dump 10.13 Distrib 5.5.58, for debian-linux-gnu (i686)
2--
3-- Host: localhost Database: osvlgridtest
4-- ------------------------------------------------------
5-- Server version 5.5.58-0+deb7u1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `regions`
20--
21
22DROP TABLE IF EXISTS `regions`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `regions` (
26 `uuid` varchar(36) NOT NULL,
27 `regionHandle` bigint(20) unsigned NOT NULL,
28 `regionName` varchar(128) DEFAULT NULL,
29 `regionRecvKey` varchar(128) DEFAULT NULL,
30 `regionSendKey` varchar(128) DEFAULT NULL,
31 `regionSecret` varchar(128) DEFAULT NULL,
32 `regionDataURI` varchar(255) DEFAULT NULL,
33 `serverIP` varchar(64) DEFAULT NULL,
34 `serverPort` int(10) unsigned DEFAULT NULL,
35 `serverURI` varchar(255) DEFAULT NULL,
36 `locX` int(10) unsigned DEFAULT NULL,
37 `locY` int(10) unsigned DEFAULT NULL,
38 `locZ` int(10) unsigned DEFAULT NULL,
39 `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
40 `westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
41 `southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
42 `northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
43 `regionAssetURI` varchar(255) DEFAULT NULL,
44 `regionAssetRecvKey` varchar(128) DEFAULT NULL,
45 `regionAssetSendKey` varchar(128) DEFAULT NULL,
46 `regionUserURI` varchar(255) DEFAULT NULL,
47 `regionUserRecvKey` varchar(128) DEFAULT NULL,
48 `regionUserSendKey` varchar(128) DEFAULT NULL,
49 `regionMapTexture` varchar(36) DEFAULT NULL,
50 `serverHttpPort` int(10) DEFAULT NULL,
51 `serverRemotingPort` int(10) DEFAULT NULL,
52 `owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
53 `originUUID` varchar(36) DEFAULT NULL,
54 `access` int(10) unsigned DEFAULT '1',
55 `ScopeID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
56 `sizeX` int(11) NOT NULL DEFAULT '0',
57 `sizeY` int(11) NOT NULL DEFAULT '0',
58 `flags` int(11) NOT NULL DEFAULT '0',
59 `last_seen` int(11) NOT NULL DEFAULT '0',
60 `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
61 `Token` varchar(255) NOT NULL,
62 `parcelMapTexture` varchar(36) DEFAULT NULL,
63 PRIMARY KEY (`uuid`),
64 KEY `regionName` (`regionName`),
65 KEY `regionHandle` (`regionHandle`),
66 KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
67 KEY `ScopeID` (`ScopeID`),
68 KEY `flags` (`flags`)
69) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
70/*!40101 SET character_set_client = @saved_cs_client */;
71
72--
73-- Dumping data for table `regions`
74--
75
76LOCK TABLES `regions` WRITE;
77/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
78INSERT INTO `regions` VALUES ('96d040d5-4811-4ef5-90a1-4f6297c66647',12314530233958400,'Deep Space 33',NULL,NULL,'555c4090-0fac-4dfd-894c-8864c8965a75',NULL,'192.168.1.77',9621,'http://192.168.1.77:9621/',2867200,2867200,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'6128f437-2d3b-4418-aab5-0c44932b579e',9621,NULL,'69ad5452-158b-45f3-b237-6e20eaed5230',NULL,13,'00000000-0000-0000-0000-000000000000',512,512,4,1566858383,'00000000-0000-0000-0000-000000000000','','00000000-0000-0000-0000-000000000000');
79/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
80UNLOCK TABLES;
81/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
82
83/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
84/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
85/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
86/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
87/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
88/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
89/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
90
91-- Dump completed on 2020-01-29 6:23:51