users

CREATE TABLE `jydshop_users` (
`user_id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`email` VARCHAR(60) NOT NULL DEFAULT '',
`user_name` VARCHAR(60) NOT NULL DEFAULT '',
`password` VARCHAR(32) NOT NULL DEFAULT '',
`question` VARCHAR(255) NOT NULL DEFAULT '',
`answer` VARCHAR(255) NOT NULL DEFAULT '',
`sex` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`birthday` DATE NULL DEFAULT NULL,
`user_money` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
`frozen_money` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
`pay_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`rank_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`address_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`reg_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`last_login` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`last_time` DATETIME NULL DEFAULT NULL,
`last_ip` VARCHAR(15) NOT NULL DEFAULT '',
`visit_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`user_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`is_special` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`ec_salt` VARCHAR(10) NULL DEFAULT NULL,
`salt` VARCHAR(10) NOT NULL DEFAULT '0',
`parent_id` MEDIUMINT(9) NOT NULL DEFAULT '0',
`flag` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`alias` VARCHAR(60) NOT NULL,
`msn` VARCHAR(60) NULL DEFAULT NULL,
`qq` VARCHAR(20) NULL DEFAULT NULL,
`office_phone` VARCHAR(20) NULL DEFAULT NULL,
`home_phone` VARCHAR(20) NULL DEFAULT NULL,
`mobile_phone` VARCHAR(20) NULL DEFAULT NULL,
`is_validated` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`credit_line` DECIMAL(10,2) UNSIGNED NOT NULL,
`passwd_question` VARCHAR(50) NULL DEFAULT NULL,
`passwd_answer` VARCHAR(255) NULL DEFAULT NULL,
`im_id` VARCHAR(45) NULL DEFAULT NULL,
`cell_phone_type` CHAR(1) NULL DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE INDEX `user_name` (`user_name`),
INDEX `email` (`email`),
INDEX `parent_id` (`parent_id`),
INDEX `flag` (`flag`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=31
;