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

DB anchor.png

Page Top
classifieds anchor.png
mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| classifieduuid  | char(36)     | NO   | PRI | NULL    |       |
| creatoruuid     | char(36)     | NO   |     | NULL    |       |
| creationdate    | int(20)      | NO   |     | NULL    |       |
| expirationdate  | int(20)      | NO   |     | NULL    |       |
| category        | varchar(20)  | NO   |     | NULL    |       |
| name            | varchar(255) | NO   |     | NULL    |       |
| description     | text         | NO   |     | NULL    |       |
| parceluuid      | char(36)     | NO   |     | NULL    |       |
| parentestate    | int(11)      | NO   |     | NULL    |       |
| snapshotuuid    | char(36)     | NO   |     | NULL    |       |
| simname         | varchar(255) | NO   |     | NULL    |       |
| posglobal       | varchar(255) | NO   |     | NULL    |       |
| parcelname      | varchar(255) | NO   |     | NULL    |       |
| classifiedflags | int(8)       | NO   |     | NULL    |       |
| priceforlisting | int(5)       | NO   |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
Page Top
userdata anchor.png
mysql> show columns from userdata;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| UserId  | char(36)     | NO   | PRI | NULL    |       |
| TagId   | varchar(64)  | NO   | PRI | NULL    |       |
| DataKey | varchar(255) | YES  |     | NULL    |       |
| DataVal | varchar(255) | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
Page Top
usernotes anchor.png
mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| useruuid   | varchar(36) | NO   | PRI | NULL    |       |
| targetuuid | varchar(36) | NO   | PRI | NULL    |       |
| notes      | text        | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
Page Top
userpicks anchor.png
mysql> show columns from userpicks;
+--------------+----------------------+------+-----+---------+-------+
| Field        | Type                 | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+-------+
| pickuuid     | varchar(36)          | NO   | PRI | NULL    |       |
| creatoruuid  | varchar(36)          | NO   |     | NULL    |       |
| toppick      | enum('true','false') | NO   |     | NULL    |       |
| parceluuid   | varchar(36)          | NO   |     | NULL    |       |
| name         | varchar(255)         | NO   |     | NULL    |       |
| description  | text                 | NO   |     | NULL    |       |
| snapshotuuid | varchar(36)          | NO   |     | NULL    |       |
| user         | varchar(255)         | NO   |     | NULL    |       |
| originalname | varchar(255)         | NO   |     | NULL    |       |
| simname      | varchar(255)         | NO   |     | NULL    |       |
| posglobal    | varchar(255)         | NO   |     | NULL    |       |
| sortorder    | int(2)               | NO   |     | NULL    |       |
| enabled      | enum('true','false') | NO   |     | NULL    |       |
| gatekeeper   | varchar(255)         | YES  |     | NULL    |       |
+--------------+----------------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
Page Top
userprofile anchor.png
mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| useruuid             | varchar(36)  | NO   | PRI | NULL    |       |
| profilePartner       | varchar(36)  | NO   |     | NULL    |       |
| profileAllowPublish  | binary(1)    | NO   |     | NULL    |       |
| profileMaturePublish | binary(1)    | NO   |     | NULL    |       |
| profileURL           | varchar(255) | NO   |     | NULL    |       |
| profileWantToMask    | int(3)       | NO   |     | NULL    |       |
| profileWantToText    | text         | NO   |     | NULL    |       |
| profileSkillsMask    | int(3)       | NO   |     | NULL    |       |
| profileSkillsText    | text         | NO   |     | NULL    |       |
| profileLanguages     | text         | NO   |     | NULL    |       |
| profileImage         | varchar(36)  | NO   |     | NULL    |       |
| profileAboutText     | text         | NO   |     | NULL    |       |
| profileFirstImage    | varchar(36)  | NO   |     | NULL    |       |
| profileFirstText     | text         | NO   |     | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
Page Top
usersettings anchor.png
mysql> show columns from usersettings;
+------------+----------------------+------+-----+---------+-------+
| Field      | Type                 | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+-------+
| useruuid   | varchar(36)          | NO   | PRI | NULL    |       |
| imviaemail | enum('true','false') | NO   |     | NULL    |       |
| visible    | enum('true','false') | NO   |     | NULL    |       |
| email      | varchar(254)         | NO   |     | NULL    |       |
+------------+----------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

トップ   凍結 差分 バックアップ 複製 名前変更 リロード   新規 ページ一覧 単語検索 最終更新   ヘルプ   最終更新のRSS 1.0 最終更新のRSS 2.0 最終更新のRSS Atom
Counter: 603, today: 1, yesterday: 0
最終更新: 2016-08-08 (月) 10:46:51 (JST) (1225d) by iseki

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2019年 12月翌月
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
<今日>

オンライン状況

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

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

もっと...

アクセスカウンタ

今日 : 2251225122512251
昨日 : 2852285228522852
総計 : 1302543813025438130254381302543813025438130254381302543813025438
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com