Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
If you want to see English page, please click "English" Button at Left.
[
タイトル一覧
|
ページ一覧
|
新規
|
単語検索
|
最終更新
|
ヘルプ
]
OpenSim/UserProfile
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** UserProfile Module
*** DB
**** classifieds
mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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)
**** userdata
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)
**** usernotes
mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | NULL | ...
| targetuuid | varchar(36) | NO | PRI | NULL | ...
| notes | text | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** userpicks
mysql> show columns from userpicks;
+--------------+----------------------+------+-----+----...
| Field | Type | Null | Key | Def...
+--------------+----------------------+------+-----+----...
| pickuuid | varchar(36) | NO | PRI | NUL...
| creatoruuid | varchar(36) | NO | | NUL...
| toppick | enum('true','false') | NO | | NUL...
| parceluuid | varchar(36) | NO | | NUL...
| name | varchar(255) | NO | | NUL...
| description | text | NO | | NUL...
| snapshotuuid | varchar(36) | NO | | NUL...
| user | varchar(255) | NO | | NUL...
| originalname | varchar(255) | NO | | NUL...
| simname | varchar(255) | NO | | NUL...
| posglobal | varchar(255) | NO | | NUL...
| sortorder | int(2) | NO | | NUL...
| enabled | enum('true','false') | NO | | NUL...
| gatekeeper | varchar(255) | YES | | NUL...
+--------------+----------------------+------+-----+----...
14 rows in set (0.00 sec)
**** userprofile
mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | NUL...
| profilePartner | varchar(36) | NO | | NUL...
| profileAllowPublish | binary(1) | NO | | NUL...
| profileMaturePublish | binary(1) | NO | | NUL...
| profileURL | varchar(255) | NO | | NUL...
| profileWantToMask | int(3) | NO | | NUL...
| profileWantToText | text | NO | | NUL...
| profileSkillsMask | int(3) | NO | | NUL...
| profileSkillsText | text | NO | | NUL...
| profileLanguages | text | NO | | NUL...
| profileImage | varchar(36) | NO | | NUL...
| profileAboutText | text | NO | | NUL...
| profileFirstImage | varchar(36) | NO | | NUL...
| profileFirstText | text | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** usersettings
mysql> show columns from usersettings;
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
終了行:
** UserProfile Module
*** DB
**** classifieds
mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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)
**** userdata
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)
**** usernotes
mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | NULL | ...
| targetuuid | varchar(36) | NO | PRI | NULL | ...
| notes | text | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** userpicks
mysql> show columns from userpicks;
+--------------+----------------------+------+-----+----...
| Field | Type | Null | Key | Def...
+--------------+----------------------+------+-----+----...
| pickuuid | varchar(36) | NO | PRI | NUL...
| creatoruuid | varchar(36) | NO | | NUL...
| toppick | enum('true','false') | NO | | NUL...
| parceluuid | varchar(36) | NO | | NUL...
| name | varchar(255) | NO | | NUL...
| description | text | NO | | NUL...
| snapshotuuid | varchar(36) | NO | | NUL...
| user | varchar(255) | NO | | NUL...
| originalname | varchar(255) | NO | | NUL...
| simname | varchar(255) | NO | | NUL...
| posglobal | varchar(255) | NO | | NUL...
| sortorder | int(2) | NO | | NUL...
| enabled | enum('true','false') | NO | | NUL...
| gatekeeper | varchar(255) | YES | | NUL...
+--------------+----------------------+------+-----+----...
14 rows in set (0.00 sec)
**** userprofile
mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | NUL...
| profilePartner | varchar(36) | NO | | NUL...
| profileAllowPublish | binary(1) | NO | | NUL...
| profileMaturePublish | binary(1) | NO | | NUL...
| profileURL | varchar(255) | NO | | NUL...
| profileWantToMask | int(3) | NO | | NUL...
| profileWantToText | text | NO | | NUL...
| profileSkillsMask | int(3) | NO | | NUL...
| profileSkillsText | text | NO | | NUL...
| profileLanguages | text | NO | | NUL...
| profileImage | varchar(36) | NO | | NUL...
| profileAboutText | text | NO | | NUL...
| profileFirstImage | varchar(36) | NO | | NUL...
| profileFirstText | text | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** usersettings
mysql> show columns from usersettings;
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2025年 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
<今日>
オンライン状況
92 人のユーザが現在オンラインです。 (4 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 92
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com