flagflag  

users anchor.png

  • Avatar の情報
  • 0.7 で廃止
mysql> show columns from users;
+-------------------+---------------------+------+-----+--------------------------------------+-------+
| Field             | Type                | Null | Key | Default                              | Extra |
+-------------------+---------------------+------+-----+--------------------------------------+-------+
| UUID              | varchar(36)         | NO   | PRI |                                      |       | 
| username          | varchar(32)         | NO   | MUL | NULL                                 |       | 
| lastname          | varchar(32)         | NO   |     | NULL                                 |       | 
| passwordHash      | varchar(32)         | NO   |     | NULL                                 |       | 
| passwordSalt      | varchar(32)         | NO   |     | NULL                                 |       | 
| homeRegion        | bigint(20) unsigned | YES  |     | NULL                                 |       | 
| homeLocationX     | float               | YES  |     | NULL                                 |       | 
| homeLocationY     | float               | YES  |     | NULL                                 |       | 
| homeLocationZ     | float               | YES  |     | NULL                                 |       | 
| homeLookAtX       | float               | YES  |     | NULL                                 |       | 
| homeLookAtY       | float               | YES  |     | NULL                                 |       | 
| homeLookAtZ       | float               | YES  |     | NULL                                 |       | 
| created           | int(11)             | NO   |     | NULL                                 |       | 
| lastLogin         | int(11)             | NO   |     | NULL                                 |       | 
| userInventoryURI  | varchar(255)        | YES  |     | NULL                                 |       | 
| userAssetURI      | varchar(255)        | YES  |     | NULL                                 |       | 
| profileCanDoMask  | int(10) unsigned    | YES  |     | NULL                                 |       | 
| profileWantDoMask | int(10) unsigned    | YES  |     | NULL                                 |       | 
| profileAboutText  | text                | YES  |     | NULL                                 |       | 
| profileFirstText  | text                | YES  |     | NULL                                 |       | 
| profileImage      | varchar(36)         | YES  |     | NULL                                 |       | 
| profileFirstImage | varchar(36)         | YES  |     | NULL                                 |       | 
| webLoginKey       | varchar(36)         | YES  |     | NULL                                 |       | 
| homeRegionID      | char(36)            | NO   |     | 00000000-0000-0000-0000-000000000000 |       | 
| userFlags         | int(11)             | NO   |     | 0                                    |       | 
| godLevel          | int(11)             | NO   |     | 0                                    |       | 
| customType        | varchar(32)         | NO   |     |                                      |       | 
| partner           | char(36)            | NO   |     | 00000000-0000-0000-0000-000000000000 |       | 
| email             | varchar(250)        | YES  |     | NULL                                 |       | 
| scopeID           | char(36)            | NO   |     | 00000000-0000-0000-0000-000000000000 |       | 
+-------------------+---------------------+------+-----+--------------------------------------+-------+

Front page   Freeze Diff Backup Copy Rename Reload   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Counter: 1775, today: 3, yesterday: 1
Last-modified: 2010-05-21 (Fri) 18:37:38 (JST) (5524d) by admin

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthJul 2025Next Month
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

70 user(s) are online (3 user(s) are browsing xpwiki)

Members: 0
Guests: 70

more...

Access Counter

Today : 3749374937493749
Yesterday : 9851985198519851
Total : 2741609927416099274160992741609927416099274160992741609927416099
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com