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'

email

VARCHAR(255)

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>