news.sql

小虫新闻管理系统 V1.0用JSP与servlet实现.

# Dumping Table class
#
CREATE TABLE class (
	id int(4) NOT NULL  auto_increment, 
	name varchar(20) NOT NULL  , 
	master varchar(20)    ,
	PRIMARY KEY (id)	
) ;

# Dumping Table master
#
CREATE TABLE master (
	id int(4) NOT NULL  auto_increment, 
	name varchar(20) NOT NULL  , 
	pass varchar(16) NOT NULL  , 
	total int(10) NOT NULL  DEFAULT '0' , 
	joindate varchar(10) NOT NULL  DEFAULT '0000-00-00' , 
	classid int(4) NOT NULL  DEFAULT '0' , 
	loginnum int(10) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) ;

# Dumping Table news
#
CREATE TABLE news (
	id int(10) NOT NULL  auto_increment, 
	topic varchar(255) NOT NULL  , 
	body text NOT NULL  , 
	hits int(10) NOT NULL  DEFAULT '0' , 
	adddate varchar(30) NOT NULL  DEFAULT '0000-00-00 00:00:00' , 
	adduser varchar(20) NOT NULL  , 
	rootid int(4) NOT NULL  DEFAULT '0' , 
	pic varchar(100)    ,
	PRIMARY KEY (id)	
) ;

INSERT INTO master ( name,pass,joindate,classid ) VALUES ( "admin","admin","2003-03-08",0 );