OpenSim/DB/0.9.0/UserAccounts
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
*** Columns [#v322c82c]
MariaDB [jogrid_db]> 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 | | | ...
| active | int(11) | NO | | 1 | ...
+-------------+-------------+------+-----+---------+----...
11 rows in set (0.00 sec)
*** Select [#l8f7f95b]
MariaDB [jogrid_db]> select PrincipalID,FirstName,LastNa...
+--------------------------------------+----------------...
| PrincipalID | FirstName ...
+--------------------------------------+----------------...
| 00731c45-1a0d-4a2f-9b64-3c8cadfed6b1 | Yougao ...
| 008863f2-8c67-47b4-9d6f-f13ef902f4a5 | toshiko ...
| 00ea5a70-c983-4f1a-8e93-5f8dc49c5f75 | Shirousa ...
| 010ce6ca-f43c-45d7-aee9-dacd5b2fc7a6 | Ley ...
| 0154a644-697c-42a8-ba9f-680980c8a2fb | rurimi ...
| 029562fa-101a-4393-a312-3da9eb5dfbb9 | totoro ...
......
+--------------------------------------+----------------...
379 rows in set (0.00 sec)
#br
終了行:
*** Columns [#v322c82c]
MariaDB [jogrid_db]> 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 | | | ...
| active | int(11) | NO | | 1 | ...
+-------------+-------------+------+-----+---------+----...
11 rows in set (0.00 sec)
*** Select [#l8f7f95b]
MariaDB [jogrid_db]> select PrincipalID,FirstName,LastNa...
+--------------------------------------+----------------...
| PrincipalID | FirstName ...
+--------------------------------------+----------------...
| 00731c45-1a0d-4a2f-9b64-3c8cadfed6b1 | Yougao ...
| 008863f2-8c67-47b4-9d6f-f13ef902f4a5 | toshiko ...
| 00ea5a70-c983-4f1a-8e93-5f8dc49c5f75 | Shirousa ...
| 010ce6ca-f43c-45d7-aee9-dacd5b2fc7a6 | Ley ...
| 0154a644-697c-42a8-ba9f-680980c8a2fb | rurimi ...
| 029562fa-101a-4393-a312-3da9eb5dfbb9 | totoro ...
......
+--------------------------------------+----------------...
379 rows in set (0.00 sec)
#br
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
