创建数据库
�
创建think_user数据库表
CREATE TABLE `joys_user` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 150 ) NOT NULL ,
`password` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
`email` VARCHAR( 100 ) NOT NULL ,
`reg_date` DATETIME NOT NULL ,
`last_login_date` DATETIME NOT NULL ,
`active` TINYINT( 1 ) NOT NULL ,
`params` TEXT NOT NULL ,
INDEX ( `name` ) ,
UNIQUE ( `username` ),
UNIQUE ( `email` )
) ENGINE = MYISAM ;