1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
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(64) default NULL,
`ServerPort` int(10) unsigned default NULL,
`ServerURI` varchar(255) default NULL,
`RegionLocX` int(10) unsigned default NULL,
`RegionLocY` int(10) unsigned default NULL,
`RegionLocZ` 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,
`ServerHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
`Owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
`OriginUUID` varchar(36),
PRIMARY KEY (`uuid`),
KEY `region_name` (`RegionName`),
KEY `region_handle` (`RegionHandle`),
KEY `overrideHandles` (`EastOverrideHandle`,`WestOverrideHandle`,`SouthOverrideHandle`,`NorthOverrideHandle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
|
