Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/DB/0.9.0/UserAccounts
[
Front page
]
[ ]
Start:
*** Columns
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)
#br
*** Select
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
End:
*** Columns
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)
#br
*** Select
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
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
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
Today
Who's Online
124 user(s) are online (6 user(s) are browsing xpwiki)
Members: 0
Guests: 124
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com