--Oracle 入门 作业-- --创建一个名为DAVID的用户,口令为davidpass-- --并授予其连接数据库和创建表对象的权限。-- --同时授予其访问另一用户MARTIN的表TEST的权限.-- create user DAVID identified by davidpass; grant connect to DAVID; grant select on MAERIN.TEST to DAVID; --bbsUsers用户表,存储注册的用户信息,用户注册后才能发贴和回贴-- --bbsTopic主贴表,存储主贴的内容-- --bbsReply跟贴表,存储跟贴的内容-- --bbsSection存储版块的信息-- create sequence bbs_seq increment by 1 start with 1 maxvalue 999999999 nocycle cache 10; create table bbsUsers( uuid int primary key not null,upwd varchar2(20) default '888888' check(length(upwd)>=6),usex char(1) default '1',urdate date default sysdate,ustate int default 0 not null,ujb int default 1 not null,ujf number default 20,uemail varchar2(30) check(uemail like '%@%') ); create table bbsSection( sid int primary key not null,sname varchar2(32) not null,smasterID int references bbsUsers(uuid),sprofile varchar2(20),sclickCount int,stopicCount int ); create table bbsTopic( tid int primary key not null,tsid int references bbsSection(sid),tuid int references bbsUsers(uuid),treplyCount int,tface int,ttopic varchar2(20) not null,tcontents varchar2(30) not null,ttime date,tclickCount int,tstate int not null,tlastReply date ); create table bbsReply( rid int primary key not null,rtid references bbsTopic(tid),rsid references bbsSection(sid),ruid references bbsUsers(uuid),rface int,rcontents varchar2(20) check (length(rcontents)>6) not null,rtime date,rclickCount int ); select * from bbsusers; select * from bbsTopic; select * from bbsReply; select * from bbsSection; drop table bbsTopic; drop table bbsReply; drop table bbsSection; drop table bbsusers;
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。