flagflag  If you want to see English page, please click "English" Button at Left.
Page Top

DB anchor.png

Page Top
search_allparcels anchor.png
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)
Page Top
search_events anchor.png
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)
Page Top
search_hostsregister anchor.png
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)
Page Top
search_objects anchor.png
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)
Page Top
search_parcels anchor.png
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)
Page Top
search_parcelsales anchor.png
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)
Page Top
search_popularplaces anchor.png
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)
Page Top
search_regions anchor.png
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)

トップ   凍結 差分 バックアップ 複製 名前変更 リロード   新規 ページ一覧 単語検索 最終更新   ヘルプ   最終更新のRSS 1.0 最終更新のRSS 2.0 最終更新のRSS Atom
Counter: 793, today: 1, yesterday: 0
最終更新: 2016-07-20 (水) 16:25:30 (JST) (2859d) by iseki

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 5月翌月
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
<今日>

オンライン状況

35 人のユーザが現在オンラインです。 (5 人のユーザが xpwiki を参照しています。)

登録ユーザ: 0
ゲスト: 35

もっと...

アクセスカウンタ

今日 : 1888188818881888
昨日 : 5790579057905790
総計 : 2365468423654684236546842365468423654684236546842365468423654684
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com