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

DB anchor.png

Page Top
profile_classifieds anchor.png
MariaDB [opensim_op]> show columns from profile_classifieds;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| classifieduuid  | varchar(36)  | NO   | PRI |         |       |
| creatoruuid     | varchar(36)  | NO   |     |         |       |
| creationdate    | bigint(20)   | NO   |     | NULL    |       |
| expirationdate  | bigint(20)   | NO   |     | NULL    |       |
| category        | varchar(20)  | NO   |     |         |       |
| name            | varchar(255) | NO   |     |         |       |
| description     | longtext     | NO   |     | NULL    |       |
| parceluuid      | varchar(36)  | NO   |     |         |       |
| parentestate    | bigint(11)   | NO   |     | NULL    |       |
| snapshotuuid    | varchar(36)  | NO   |     |         |       |
| simname         | varchar(255) | NO   |     |         |       |
| posglobal       | varchar(255) | NO   |     |         |       |
| parcelname      | varchar(255) | NO   |     |         |       |
| classifiedflags | int(8)       | NO   |     | NULL    |       |
| priceforlisting | mediumint(5) | NO   |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
15 rows in set (0.01 sec)
Page Top
profile_usernotes anchor.png
MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| useruuid   | varchar(36) | NO   | PRI |         |       |
| targetuuid | varchar(36) | NO   | PRI |         |       |
| notes      | longtext    | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
Page Top
profile_userpicks anchor.png
MariaDB [opensim_op]> show columns from  profile_userpicks;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| pickuuid     | varchar(36)  | NO   | PRI |         |       |
| creatoruuid  | varchar(36)  | NO   |     |         |       |
| toppick      | varchar(6)   | NO   |     | false   |       |
| parceluuid   | varchar(36)  | NO   |     |         |       |
| name         | varchar(255) | NO   |     |         |       |
| description  | longtext     | NO   |     | NULL    |       |
| snapshotuuid | varchar(36)  | NO   |     |         |       |
| user         | varchar(255) | NO   |     |         |       |
| originalname | varchar(255) | NO   |     |         |       |
| simname      | varchar(255) | NO   |     |         |       |
| posglobal    | varchar(255) | NO   |     |         |       |
| sortorder    | tinyint(2)   | NO   |     | NULL    |       |
| enabled      | varchar(6)   | NO   |     | false   |       |
+--------------+--------------+------+-----+---------+-------+
13 rows in set (0.00 sec)
Page Top
profile_userprofile anchor.png
MariaDB [opensim_op]> show columns from profile_userprofile;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| useruuid             | varchar(36)  | NO   | PRI |         |       |
| profilepartner       | varchar(36)  | NO   |     |         |       |
| profileimage         | varchar(36)  | NO   |     |         |       |
| profileabouttext     | longtext     | NO   |     | NULL    |       |
| profileallowpublish  | binary(1)    | NO   |     | NULL    |       |
| profilematurepublish | binary(1)    | NO   |     | NULL    |       |
| profileurl           | varchar(255) | NO   |     |         |       |
| profilewanttomask    | smallint(3)  | NO   |     | NULL    |       |
| profilewanttotext    | longtext     | NO   |     | NULL    |       |
| profileskillsmask    | smallint(3)  | NO   |     | NULL    |       |
| profileskillstext    | longtext     | NO   |     | NULL    |       |
| profilelanguagestext | longtext     | NO   |     | NULL    |       |
| profilefirstimage    | varchar(36)  | NO   |     |         |       |
| profilefirsttext     | longtext     | NO   |     | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
Page Top
profile_usersettings anchor.png
MariaDB [opensim_op]> show columns from profile_usersettings;
+------------+----------------------+------+-----+---------+-------+
| Field      | Type                 | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+-------+
| useruuid   | varchar(36)          | NO   | PRI |         |       |
| imviaemail | enum('true','false') | NO   |     | false   |       |
| visible    | enum('true','false') | NO   |     | true    |       |
| email      | varchar(254)         | NO   |     |         |       |
+------------+----------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

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

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 3月翌月
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
<今日>

オンライン状況

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

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

もっと...

アクセスカウンタ

今日 : 1034810348103481034810348
昨日 : 6869686968696869
総計 : 2318463123184631231846312318463123184631231846312318463123184631
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com