普通记录会员资料的数据库结构:
CREATE TABLE `php_user`(
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`username` VARCHAR(30) NOT NULL,
`cnname` VARCHAR(30) NOT NULL,
`password` CHAR(32) NOT NULL,
`email` VARCHAR(100) NOT NULL,
`reg_date` DATETIME NOT NULL,
`last_login_date` DATETIME NOT NULL,
`last_login_ip` CHAR(20) NOT NULL,
`active` ENUM('0','1') NOT NULL,
`authority` ENUM('0','1') NOT NULL,
`params` TEXT NOT NULL,
UNIQUE(`username`),
UNIQUE(`email`)
)ENGINE=MYISAM DEFAULT CHARSET=UTF8;