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/OpenProfile
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** OpenProfile for OpenSim
*** DB
**** profile_classifieds
MariaDB [opensim_op]> show columns from profile_classifi...
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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)
**** profile_usernotes
MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | | ...
| targetuuid | varchar(36) | NO | PRI | | ...
| notes | longtext | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** profile_userpicks
MariaDB [opensim_op]> show columns from profile_userpic...
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| 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)
**** profile_userprofile
MariaDB [opensim_op]> show columns from profile_userprof...
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | ...
| profilepartner | varchar(36) | NO | | ...
| profileimage | varchar(36) | NO | | ...
| profileabouttext | longtext | NO | | NUL...
| profileallowpublish | binary(1) | NO | | NUL...
| profilematurepublish | binary(1) | NO | | NUL...
| profileurl | varchar(255) | NO | | ...
| profilewanttomask | smallint(3) | NO | | NUL...
| profilewanttotext | longtext | NO | | NUL...
| profileskillsmask | smallint(3) | NO | | NUL...
| profileskillstext | longtext | NO | | NUL...
| profilelanguagestext | longtext | NO | | NUL...
| profilefirstimage | varchar(36) | NO | | ...
| profilefirsttext | longtext | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** profile_usersettings
MariaDB [opensim_op]> show columns from profile_usersett...
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
終了行:
** OpenProfile for OpenSim
*** DB
**** profile_classifieds
MariaDB [opensim_op]> show columns from profile_classifi...
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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)
**** profile_usernotes
MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | | ...
| targetuuid | varchar(36) | NO | PRI | | ...
| notes | longtext | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** profile_userpicks
MariaDB [opensim_op]> show columns from profile_userpic...
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| 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)
**** profile_userprofile
MariaDB [opensim_op]> show columns from profile_userprof...
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | ...
| profilepartner | varchar(36) | NO | | ...
| profileimage | varchar(36) | NO | | ...
| profileabouttext | longtext | NO | | NUL...
| profileallowpublish | binary(1) | NO | | NUL...
| profilematurepublish | binary(1) | NO | | NUL...
| profileurl | varchar(255) | NO | | ...
| profilewanttomask | smallint(3) | NO | | NUL...
| profilewanttotext | longtext | NO | | NUL...
| profileskillsmask | smallint(3) | NO | | NUL...
| profileskillstext | longtext | NO | | NUL...
| profilelanguagestext | longtext | NO | | NUL...
| profilefirstimage | varchar(36) | NO | | ...
| profilefirsttext | longtext | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** profile_usersettings
MariaDB [opensim_op]> show columns from profile_usersett...
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2025年 2月
日
月
火
水
木
金
土
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
<今日>
オンライン状況
83 人のユーザが現在オンラインです。 (2 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 83
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com