|
現: 2016-05-16 (月) 17:56:33 iseki  |
| | + | MariaDB [jogrid_db]> show columns from regions; |
| | + | +---------------------+---------------------+------+-----+--------------------------------------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +---------------------+---------------------+------+-----+--------------------------------------+-------+ |
| | + | | uuid | varchar(36) | NO | PRI | NULL | | |
| | + | | regionHandle | bigint(20) unsigned | NO | MUL | NULL | | |
| | + | | regionName | varchar(128) | YES | MUL | NULL | | |
| | + | | regionRecvKey | varchar(128) | YES | | NULL | | |
| | + | | regionSendKey | varchar(128) | YES | | NULL | | |
| | + | | regionSecret | varchar(128) | YES | | NULL | | |
| | + | | regionDataURI | varchar(255) | YES | | NULL | | |
| | + | | serverIP | varchar(64) | YES | | NULL | | |
| | + | | serverPort | int(10) unsigned | YES | | NULL | | |
| | + | | serverURI | varchar(255) | YES | | NULL | | |
| | + | | locX | int(10) unsigned | YES | | NULL | | |
| | + | | locY | int(10) unsigned | YES | | NULL | | |
| | + | | locZ | int(10) unsigned | YES | | NULL | | |
| | + | | eastOverrideHandle | bigint(20) unsigned | YES | MUL | NULL | | |
| | + | | westOverrideHandle | bigint(20) unsigned | YES | | NULL | | |
| | + | | southOverrideHandle | bigint(20) unsigned | YES | | NULL | | |
| | + | | northOverrideHandle | bigint(20) unsigned | YES | | NULL | | |
| | + | | regionAssetURI | varchar(255) | YES | | NULL | | |
| | + | | regionAssetRecvKey | varchar(128) | YES | | NULL | | |
| | + | | regionAssetSendKey | varchar(128) | YES | | NULL | | |
| | + | | regionUserURI | varchar(255) | YES | | NULL | | |
| | + | | regionUserRecvKey | varchar(128) | YES | | NULL | | |
| | + | | regionUserSendKey | varchar(128) | YES | | NULL | | |
| | + | | regionMapTexture | varchar(36) | YES | | NULL | | |
| | + | | serverHttpPort | int(10) | YES | | NULL | | |
| | + | | serverRemotingPort | int(10) | YES | | NULL | | |
| | + | | owner_uuid | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | originUUID | varchar(36) | YES | | NULL | | |
| | + | | access | int(10) unsigned | YES | | 1 | | |
| | + | | ScopeID | char(36) | NO | MUL | 00000000-0000-0000-0000-000000000000 | | |
| | + | | sizeX | int(11) | NO | | 0 | | |
| | + | | sizeY | int(11) | NO | | 0 | | |
| | + | | flags | int(11) | NO | MUL | 0 | | |
| | + | | last_seen | int(11) | NO | | 0 | | |
| | + | | PrincipalID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | Token | varchar(255) | NO | | NULL | | |
| | + | | parcelMapTexture | varchar(36) | YES | | NULL | | |
| | + | +---------------------+---------------------+------+-----+--------------------------------------+-------+ |
| | + | 37 rows in set (0.00 sec) |
