a.sql

来自「随着信息技术的飞速发展、网上信息量发布的不断增大。针对文章管理这一环节」· SQL 代码 · 共 106 行

drop  table   Article_USER cascade constraints;
drop table  Article_ADMIN cascade constraints;
drop  table   ARTICLE_MANAGER   cascade constraints; 

select * from ARTICLE_MANAGER;
select * from Article_Admin;
select * from Article_User;
delete from article_manager;

insert into Article_Admin(id,name,password,email,address)
 		values(1,'lyq',111111,'df','ddd');
 
insert into Article_User(id,name,password,email,address,question,answer)
		 values(1,'lyq',111111,'df','ddd','fdgd','sf');
		 
create table   ARTICLE_USER (
	ID number(19,0) not null, 
	NAME varchar2(20 char) not null unique, 
	PASSWORD varchar2(100 char) not null, 
	QUESTION varchar2(50),
	ANSWER varchar(50),
	EMAIL varchar2(50 char) not null unique,
	SEX char,
 	ADDRESS varchar2(200 char) not null,
 	REGISTER_DATE date, 
 	TELEPHONE varchar2(20),
	ZIP varchar2(20), primary key (ID)
	);
 	
 create table  ARTICLE_ADMIN (
 		ID number(19,0) not null, 
 		NAME varchar2(20 char) not null unique,
 		PASSWORD varchar2(100 char) not null, 
 		EMAIL varchar2(50 char) not null unique, 
 		SEX char,
 		ADDRESS varchar2(200 char) not null, 
 		REGISTER_DATE date, 
 		TELEPHONE varchar2(20), 
 		ZIP varchar2(20),primary key (ID)
 		);
 		
create  table ARTICLE_MANAGER(
		ID number(19) not null,
		TOPIC   varchar2(50)  not  null,
		TYPE   varchar2(10)   not  null,
		AUTHOR varchar2(10) not null,
		ARTICLE_FROM varchar2(50) not null,
		CONTENT varchar2(4000) not null,
		HITS number(10),
		SENDDATE   Date,
		PUBNAME   varchar2(20)  not  null,primary key(ID)		
		); 
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(1,'aa','小说','zhandbgsan','biejfing','dfdsfdsffdfd',0,'liesi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(2,'ara','文学','zhanan','biedfjing','dfdssffdsfdfd',0,'lisigg');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(3,'agja','文学','zhmgsan','biejdging','dfdssffdsfdfd',0,'lisgsi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(4,'asha','体育','zbkgsan','biejging','dfdsfsfdsfdfd',0,'lisdgi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(5,'asaka','体育','zhangn','biejsging','dfdsfdfdsfdfd',0,'ldfisi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(6,'aksa','计算机','zdglan','biesfjing','dfdfdssfdsfdfd',0,'lifdssi');		


insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(7,'awea','小说','zhweandbgsan','bieweejfing','dfdsfetdsffdfd',0,'lreiesi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(8,'arera','文学','zhanrtan','biedfytjing','dfduyssffdsfdfd',0,'lwqeisigg');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(9,'agqeja','文学','zthmgsan','bieajdging','dfdssfrtfdsfdfd',0,'lisgwesi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(10,'ashdsga','体育','zbkdggsan','biejgisfng','dfdsfsfdssfdfd',0,'lisdgqei');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(11,'ashgaka','体育','zhagjhgngn','biejsdgsging','dfdsfdfdjgsfdfd',0,'ldffdisi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(12,'aadg','小说','zhandbgsfsan','biejahgfhfing','dfdsfddfsffdfd',0,'lifsdesi');
			 
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(13,'arhha','文学','zhanajhn','biekjhdfjing','dfdssflfdsfdfd',0,'lisidfgg');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(14,'agdgja','文学','zhmgshan','biejdfsging','dfdssfdfdsfdfd',0,'lisfgsi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(15,'asgfha','体育','zbkgsfgan','biejgdsing','dfdsfgfsfdsfdfd',0,'lgisdgi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(16,'asgfjaka','体育','zhjhjangn','biejsgking','dfdsfdfddfsfdfd',0,'ldsdfisi');
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(17,'akgfsa','计算df机','zdsglan','biessffjing','dfdfdssffdsfdfd',0,'lifddssi');		
			 
insert into ARTICLE_MANAGER(id,topic,type,author,article_from,content,hits,pubname)
			 values(18,'akhgjsa','计算机','zdkjglan','biesfjindsfg','dfdfsdfdssfdsfdfd',0,'liffddssi');