oracle简单的新闻发布管理系统之数据建立

drop table userinfo;

create table userinfo (
      uname varchar2(20) primary key,
      upass varchar2(20) not null,
      sex varchar2(20),
      birth date,
      score number(5,0)
);



insert into userinfo values('admin','123456','男',to_date('2010-2-12','YYYY-MM-DD'),100);




create table newsType(
  tid number(8) primary key,
  title varchar2(100) not null,
  discription varchar2(200)
);

create sequence sq_ntype start with 1 increment by 1 minvalue-1;
create sequence sq_Ninfo  start with 1 incrementby 1 minvalue -1;
create table newsInfo(
  nid number(8) primary key,
  title varchar2(100) not null,
  ncontent varchar2(1000),
  tid number(8),
  picPath varchar2(100),
  creator varchar2(20),
  cdate date ,
  mdate date,
  constraint fk_creatidr foreign key(tid)references newsType(tid),
  constraint fk_creator foreign key(creator)references userinfo(uname)
);


insert into newsTypevalues(sq_ntype.nextval,'娱乐新闻','报道娱乐界的八卦事件');
insert into newsTypevalues(sq_ntype.nextval,'体育新闻','报道体育界的事件');
insert into newsTypevalues(sq_ntype.nextval,'财经新闻','报道有关财经方面的事件');
insert into newsTypevalues(sq_ntype.nextval,'图片新闻','报道图片相关的事件');
insert into newsTypevalues(sq_ntype.nextval,'国际新闻','报道国际事件');
insert into newsTypevalues(sq_ntype.nextval,'房产新闻','报道房产行业的事件');
insert into newsTypevalues(sq_ntype.nextval,'汽车新闻','报道汽车行业的事件');
insert into newsTypevalues(sq_ntype.nextval,'教育新闻','报道教育相关的事件');
commit;

insert into newsTypevalues(sq_ntype.nextval,'教育新闻','报道教育相关的事件');



insert into newsinfovalues(sq_ninfo.nextval,'房产新闻','报道教此次ccccccccc育相关的事件',7,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'教育新闻','报道教此次ccccccccc育相关的事件',9,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'娱乐新闻','报道教此次ccccccccc育相关的事件',2,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'体育新闻','报道教此次ccccccccc育相关的事件',3,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'财经新闻','报道教此次ccccccccc育相关的事件',4,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'汽车新闻','报道教此次ccccccccc育相关的事件',8,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'图片新闻','报道教此次ccccccccc育相关的事件',8,'jpg','admin',sysdate,sysdate);
insert into newsinfovalues(sq_ninfo.nextval,'国际新闻','报道教此次ccccccccc育相关的事件',6,'jpg','admin',sysdate,sysdate);

delete newsinfo

select * from newsType ;

select * from newsinfo;

select * from newsinfo where tid=7;