OpenSim/UserProfile
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** UserProfile Module [#z55da6e4]
*** DB [#k7dfac55]
**** classifieds [#haaefa8a]
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 [#t23838ca]
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 [#u4b91612]
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 [#q836110a]
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 [#f4a0f5a2]
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 [#z2e7fe39]
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 [#z55da6e4]
*** DB [#k7dfac55]
**** classifieds [#haaefa8a]
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 [#t23838ca]
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 [#u4b91612]
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 [#q836110a]
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 [#f4a0f5a2]
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 [#z2e7fe39]
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)
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
