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: 1543, today: 1, yesterday: 1
Last-modified: 2010-05-21 (Fri) 18:37:38 (JST) (5060d) by admin

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMar 2024Next 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

57 user(s) are online (8 user(s) are browsing xpwiki)

Members: 0
Guests: 57

more...

Access Counter

Today : 3175317531753175
Yesterday : 6869686968696869
Total : 2317745823177458231774582317745823177458231774582317745823177458
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com