NAME
Foorum::Schema::User - Table 'user'
COLUMNS
- user_id
-
INT(11)
NOT NULL, PRIMARY KEY
- username
-
VARCHAR(32)
NOT NULL
- password
-
VARCHAR(32)
NOT NULL, DEFAULT VALUE '000000'
- nickname
-
VARCHAR(100)
NOT NULL
- gender
-
ENUM(2)
NOT NULL, DEFAULT VALUE 'NA'
-
VARCHAR(255)
NOT NULL
- point
-
INT(8)
NOT NULL
- register_time
-
INT(11)
NOT NULL
- register_ip
-
VARCHAR(32)
NOT NULL
- last_login_on
-
INT(11)
- last_login_ip
-
VARCHAR(32)
- login_times
-
MEDIUMINT(8)
NOT NULL, DEFAULT VALUE '1'
- status
-
ENUM(10)
NOT NULL, DEFAULT VALUE 'unverified'
- threads
-
INT(11)
NOT NULL
- replies
-
INT(11)
NOT NULL
- lang
-
CHAR(2)
DEFAULT VALUE 'cn'
- country
-
CHAR(2)
DEFAULT VALUE 'cn'
- state_id
-
INT(11)
NOT NULL
- city_id
-
INT(11)
NOT NULL
AUTHOR
Fayland Lam <fayland at gmail.com>