|
1: 2016-07-20 (Wed) 16:19:28 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) |
