OpenSim/OpenSearch
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** OpenSearch Module for OpenSim [#gbf2eb2f]
*** DB [#waee20c8]
**** search_allparcels [#r38e2e3e]
MariaDB [opensim_op]> show columns from search_allparcels;
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | MUL | ...
| parcelname | varchar(255) | NO | | ...
| owneruuid | varchar(36) | NO | | 00000000-00...
| groupuuid | varchar(36) | NO | | 00000000-00...
| landingpoint | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | 00000000-00...
| infouuid | varchar(36) | NO | | 00000000-00...
| 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 | Ex...
+-------------+--------------+------+-----+---------+---...
| 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_hostsregi...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 | D...
+----------------+----------------------+------+-----+--...
| 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 | | f...
| script | enum('true','false') | NO | | f...
| public | enum('true','false') | NO | | f...
| dwell | decimal(20,8) | NO | MUL | N...
| infouuid | varchar(36) | NO | | ...
| mature | varchar(10) | NO | | P...
+----------------+----------------------+------+-----+--...
12 rows in set (0.00 sec)
**** search_parcelsales [#w72050ef]
MariaDB [opensim_op]> show columns from search_parcelsal...
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| 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-00...
| 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_popularpl...
+-------------+---------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+-------------+---------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| 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 | E...
+--------------+--------------+------+-----+---------+--...
| 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)
終了行:
** OpenSearch Module for OpenSim [#gbf2eb2f]
*** DB [#waee20c8]
**** search_allparcels [#r38e2e3e]
MariaDB [opensim_op]> show columns from search_allparcels;
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | MUL | ...
| parcelname | varchar(255) | NO | | ...
| owneruuid | varchar(36) | NO | | 00000000-00...
| groupuuid | varchar(36) | NO | | 00000000-00...
| landingpoint | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | 00000000-00...
| infouuid | varchar(36) | NO | | 00000000-00...
| 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 | Ex...
+-------------+--------------+------+-----+---------+---...
| 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_hostsregi...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 | D...
+----------------+----------------------+------+-----+--...
| 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 | | f...
| script | enum('true','false') | NO | | f...
| public | enum('true','false') | NO | | f...
| dwell | decimal(20,8) | NO | MUL | N...
| infouuid | varchar(36) | NO | | ...
| mature | varchar(10) | NO | | P...
+----------------+----------------------+------+-----+--...
12 rows in set (0.00 sec)
**** search_parcelsales [#w72050ef]
MariaDB [opensim_op]> show columns from search_parcelsal...
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| 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-00...
| 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_popularpl...
+-------------+---------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+-------------+---------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| 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 | E...
+--------------+--------------+------+-----+---------+--...
| 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)
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
