create database news;

create database news;
use news;
create table manager(
  uname varchar(20) primary key,
  upass varchar(20) not null
);


create table users(
  uid int(8) primary key auto_increment,
  uname varchar(20) not null unique,
  upass varchar(20) not null,
  sex char(2) default '男',
  score int(8) default 0,
  constraint ck_sex check(sex in('男','女'))
);


create table newsType(
  tid int(8) primary key auto_increment,
  title varchar(100) not null,
  discription varchar(200)
);


create table newsInfo(
  nid int(8) primary key auto_increment,
  title varchar(100) not null,
  content varchar(1000),
  picPath varchar(100),
  creator varchar(20),
  cdate datetime ,
  mdate datetime,
  constraint fk_creator foreign key(creator) references manager(uname)
);


create table comments(
  cid int(8) primary key auto_increment,
  title varchar(50) not null,
  content varchar(500) ,
  creator int(8),
  cdate datetime,
  constraint fk_comments foreign key(creator) references users(uid)
);