后台用户表

Question

/**

• 后台用户表
• @type｛[type]｝

*/
CREATE TABLE cms_admin (
admin_id mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
username varchar(20) NOT NULL DEFAULT ‘’,
password varchar(32) NOT NULL DEFAULT ‘’,
lastloginip varchar(15) DEFAULT ‘0’,
lastlogintime int(10) unsigned DEFAULT ‘0’ ,
email varchar(40) DEFAULT ‘’,
realname varchar(50) NOT NULL DEFAULT ‘’,
status tinyint(1) NOT NULL DEFAULT ‘1’,
PRIMARY KEY (admin_id),
KEY username (username)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;