![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T05:15:44+00:00","default:iseki","iseki") ** OpenSearch Module for OpenSim [#gbf2eb2f] *** DB [#waee20c8] **** search_allparcels [#r38e2e3e] MariaDB [opensim_op]> show columns from search_allparcels; +--------------+--------------+------+-----+--------------------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+--------------------------------------+-------+ | regionuuid | varchar(36) | NO | MUL | | | | parcelname | varchar(255) | NO | | | | | owneruuid | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | groupuuid | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | landingpoint | varchar(255) | NO | | | | | parceluuid | varchar(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | | infouuid | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | parcelarea | bigint(11) | NO | | NULL | | +--------------+--------------+------+-----+--------------------------------------+-------+ 8 rows in set (0.00 sec) **** search_events [#g5151100] MariaDB [opensim_op]> show columns from search_events; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | uid | int(8) | NO | | 0 | | | owneruuid | varchar(36) | NO | | | | | name | varchar(255) | NO | | | | | eventid | bigint(11) | NO | PRI | NULL | | | creatoruuid | varchar(36) | NO | | | | | category | tinyint(2) | NO | | NULL | | | description | longtext | NO | | NULL | | | dateutc | bigint(10) | NO | | NULL | | | duration | bigint(10) | NO | | NULL | | | covercharge | bigint(10) | NO | | NULL | | | coveramount | bigint(10) | NO | | NULL | | | simname | varchar(255) | NO | | | | | globalpos | varchar(255) | NO | | | | | eventflags | tinyint(1) | NO | | NULL | | +-------------+--------------+------+-----+---------+-------+ 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)
