1: 2016-07-20 (水) 16:19:28 iseki  |
現: 2016-07-20 (水) 16:25:30 iseki |
| | +-------------+--------------+------+-----+---------+-------+ | | +-------------+--------------+------+-----+---------+-------+ |
| | 14 rows in set (0.00 sec) | | 14 rows in set (0.00 sec) |
| | + | **** search_hostsregister [#b36fc9f2] |
| | + | MariaDB [opensim_op]> show columns from search_hostsregister; |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | | host | varchar(255) | NO | PRI | | | |
| | + | | port | mediumint(5) | NO | PRI | NULL | | |
| | + | | register | bigint(10) | NO | | NULL | | |
| | + | | nextcheck | bigint(10) | NO | | NULL | | |
| | + | | checked | tinyint(1) | NO | | NULL | | |
| | + | | failcounter | bigint(10) | NO | | NULL | | |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | 6 rows in set (0.00 sec) |
| | + | |
| | + | **** search_objects [#y43db85c] |
| | + | MariaDB [opensim_op]> show columns from search_objects; |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | | objectuuid | varchar(36) | NO | PRI | | | |
| | + | | parceluuid | varchar(36) | NO | PRI | | | |
| | + | | location | varchar(255) | NO | | | | |
| | + | | name | varchar(255) | NO | | | | |
| | + | | description | varchar(255) | NO | | | | |
| | + | | regionuuid | varchar(36) | NO | | | | |
| | + | +-------------+--------------+------+-----+---------+-------+ |
| | + | 6 rows in set (0.00 sec) |
| | + | **** search_parcels [#wa192da9] |
| | + | MariaDB [opensim_op]> show columns from search_parcels; |
| | + | +----------------+----------------------+------+-----+---------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +----------------+----------------------+------+-----+---------+-------+ |
| | + | | regionuuid | varchar(36) | NO | PRI | | | |
| | + | | parcelname | varchar(255) | NO | MUL | | | |
| | + | | parceluuid | varchar(36) | NO | PRI | | | |
| | + | | landingpoint | varchar(255) | NO | | | | |
| | + | | description | varchar(255) | NO | MUL | | | |
| | + | | searchcategory | varchar(50) | NO | MUL | | | |
| | + | | build | enum('true','false') | NO | | false | | |
| | + | | script | enum('true','false') | NO | | false | | |
| | + | | public | enum('true','false') | NO | | false | | |
| | + | | dwell | decimal(20,8) | NO | MUL | NULL | | |
| | + | | infouuid | varchar(36) | NO | | | | |
| | + | | mature | varchar(10) | NO | | PG | | |
| | + | +----------------+----------------------+------+-----+---------+-------+ |
| | + | 12 rows in set (0.00 sec) |
| | + | **** search_parcelsales [#w72050ef] |
| | + | MariaDB [opensim_op]> show columns from search_parcelsales; |
| | + | +--------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +--------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | regionuuid | varchar(36) | NO | PRI | | | |
| | + | | parcelname | varchar(255) | NO | | | | |
| | + | | parceluuid | varchar(36) | NO | PRI | | | |
| | + | | area | mediumint(6) | NO | | NULL | | |
| | + | | saleprice | bigint(11) | NO | | NULL | | |
| | + | | landingpoint | varchar(255) | NO | | | | |
| | + | | infouuid | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | dwell | bigint(11) | NO | | NULL | | |
| | + | | parentestate | bigint(11) | NO | | 1 | | |
| | + | | mature | varchar(10) | NO | | PG | | |
| | + | +--------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | 10 rows in set (0.00 sec) |
| | + | **** search_popularplaces [#l6987d8e] |
| | + | MariaDB [opensim_op]> show columns from search_popularplaces; |
| | + | +-------------+---------------+------+-----+---------+----------------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-------------+---------------+------+-----+---------+----------------+ |
| | + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| | + | | regionuuid | varchar(36) | NO | | | | |
| | + | | name | varchar(255) | NO | | | | |
| | + | | dwell | decimal(20,8) | NO | | NULL | | |
| | + | | infouuid | varchar(32) | NO | | | | |
| | + | | has_picture | smallint(4) | NO | | NULL | | |
| | + | | mature | smallint(4) | NO | | NULL | | |
| | + | +-------------+---------------+------+-----+---------+----------------+ |
| | + | 7 rows in set (0.00 sec) |
| | + | **** search_regions [#a2583959] |
| | + | MariaDB [opensim_op]> show columns from search_regions; |
| | + | +--------------+--------------+------+-----+---------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +--------------+--------------+------+-----+---------+-------+ |
| | + | | regionname | varchar(255) | NO | | | | |
| | + | | regionuuid | varchar(36) | NO | PRI | | | |
| | + | | regionhandle | varchar(255) | NO | | | | |
| | + | | url | varchar(255) | NO | | | | |
| | + | | owner | varchar(255) | NO | | | | |
| | + | | owneruuid | varchar(36) | NO | | | | |
| | + | +--------------+--------------+------+-----+---------+-------+ |
| | + | 6 rows in set (0.00 sec) |
