OpenSim/DB/0.7.0/UserAccounts
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
*** UserAccounts [#k81079c2]
- アバターアカウントの状態
- create userコマンドでアバター登録時に作成される．
mysql> show columns from UserAccounts;
+-------------+-------------+------+-----+---------+----...
| Field | Type | Null | Key | Default | Ext...
+-------------+-------------+------+-----+---------+----...
| PrincipalID | char(36) | NO | PRI | NULL | ...
| ScopeID | char(36) | NO | | NULL | ...
| FirstName | varchar(64) | NO | MUL | NULL | ...
| LastName | varchar(64) | NO | MUL | NULL | ...
| Email | varchar(64) | YES | MUL | NULL | ...
| ServiceURLs | text | YES | | NULL | ...
| Created | int(11) | YES | | NULL | ...
| UserLevel | int(11) | NO | | 0 | ...
| UserFlags | int(11) | NO | | 0 | ...
| UserTitle | varchar(64) | NO | | | ...
+-------------+-------------+------+-----+---------+----...
mysql> select * from UserAccounts;
+--------------------------------------+----------------...
| PrincipalID | ScopeID ...
+--------------------------------------+----------------...
| 4a1d4c70-ab8c-47be-a4d1-c914fd42413d | 00000000-0000-0...
| 018fdfb4-3667-4d49-a5ad-10c21ad5c463 | 00000000-0000-0...
+--------------------------------------+----------------...
終了行:
*** UserAccounts [#k81079c2]
- アバターアカウントの状態
- create userコマンドでアバター登録時に作成される．
mysql> show columns from UserAccounts;
+-------------+-------------+------+-----+---------+----...
| Field | Type | Null | Key | Default | Ext...
+-------------+-------------+------+-----+---------+----...
| PrincipalID | char(36) | NO | PRI | NULL | ...
| ScopeID | char(36) | NO | | NULL | ...
| FirstName | varchar(64) | NO | MUL | NULL | ...
| LastName | varchar(64) | NO | MUL | NULL | ...
| Email | varchar(64) | YES | MUL | NULL | ...
| ServiceURLs | text | YES | | NULL | ...
| Created | int(11) | YES | | NULL | ...
| UserLevel | int(11) | NO | | 0 | ...
| UserFlags | int(11) | NO | | 0 | ...
| UserTitle | varchar(64) | NO | | | ...
+-------------+-------------+------+-----+---------+----...
mysql> select * from UserAccounts;
+--------------------------------------+----------------...
| PrincipalID | ScopeID ...
+--------------------------------------+----------------...
| 4a1d4c70-ab8c-47be-a4d1-c914fd42413d | 00000000-0000-0...
| 018fdfb4-3667-4d49-a5ad-10c21ad5c463 | 00000000-0000-0...
+--------------------------------------+----------------...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
