create_member.sql

希望这个对大家有用

-- 创建member数据库
CREATE DATABASE IF NOT EXISTS member
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
-- 选择member数据库
USE member;
-- 创建members表
CREATE TABLE members (
  userid smallint(5) unsigned NOT NULL auto_increment COMMENT '会员编号',
  username varchar(20) NOT NULL COMMENT '会员账号',
  gender varchar(10) NOT NULL COMMENT '性别',
  password varchar(20) NOT NULL COMMENT '密码',
  birthdate date NOT NULL default '0000-00-00' COMMENT '生日',
  question varchar(30) NOT NULL COMMENT '安全问题',
  answer varchar(35) NOT NULL COMMENT '答案',
  email varchar(45) NOT NULL COMMENT '电子信箱',
  photo varchar(45) default NULL COMMENT '照片路径',
  introduce varchar(200) NOT NULL COMMENT '自我介绍',
  role tinyint(3) unsigned NOT NULL default '0' COMMENT '角色',
  regtime datetime NOT NULL default '0000-00-00 00:00:00' COMMENT '注册时间',
  PRIMARY KEY  (userid)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='会员表';