OpenSim​/OpenSearch

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)

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)

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)

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)

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)

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)

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)

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)