ijsp_news.sql

一个简单的新闻论坛实例

# Dumping Table admin
#
CREATE TABLE admin (
	id int(6) NOT NULL  auto_increment, 
	username varchar(50) NOT NULL  , 
	password varchar(32) NOT NULL  , 
	flag smallint(3) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) TYPE=MyISAM;

# Dumping Data - 2 rows

INSERT INTO admin VALUES(1,"admin","7FEF6171469E80D32C0559F88B377245",1);
INSERT INTO admin VALUES(7,"edit","213BF3C9C5B51F435BF9F1B6D04E578A",0);

# Dumping Table class1
#
CREATE TABLE class1 (
	id int(6) NOT NULL  auto_increment, 
	classname varchar(50) NOT NULL  , 
	parentid int(6) NOT NULL  DEFAULT '0' , 
	orders int(6) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) TYPE=MyISAM;

# Dumping Data - 6 rows

INSERT INTO class1 VALUES(20,"首页",20,0);
INSERT INTO class1 VALUES(21,"新手上路",20,20);
INSERT INTO class1 VALUES(22,"JAVA技术",20,20);
INSERT INTO class1 VALUES(23,"JSP编程",20,20);
INSERT INTO class1 VALUES(24,"数据库",20,20);
INSERT INTO class1 VALUES(25,"程序人生",20,20);

# Dumping Table counter1
#
CREATE TABLE counter1 (
	createDate date   DEFAULT '0000-00-00' , 
	counter int(11)   DEFAULT '0' , 
	todayDate date   DEFAULT '0000-00-00' , 
	todayCounter int(11)   DEFAULT '0' , 
	maxDate date   DEFAULT '0000-00-00' , 
	maxCounter int(11)   DEFAULT '0'  ) TYPE=MyISAM;

# Dumping Data - 1 rows

INSERT INTO counter1 VALUES("2002-06-08",34833,"2003-04-21",6,"2003-03-03",1056);

# Dumping Table news
#
CREATE TABLE news (
	id int(11) NOT NULL  auto_increment, 
	class int(6) NOT NULL  DEFAULT '0' , 
	editer varchar(50) NOT NULL  , 
	title varchar(255) NOT NULL  , 
	newsfile varchar(50) NOT NULL  , 
	date bigint(20) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id),
	KEY class (class)	
) TYPE=MyISAM;

# Dumping Data - 15 rows

INSERT INTO news VALUES(38,23,"yangtse","jsp与ejb通信","2002/6/9/1023552000000.shtml",1023552000000);
INSERT INTO news VALUES(37,23,"yangtse","如何设置application 变量","2002/6/9/1023552000000.shtml",1023552000000);
INSERT INTO news VALUES(42,22,"yangtse","Java技术一瞥","2002/6/9/1023552779000.shtml",1023552779000);
INSERT INTO news VALUES(43,22,"yangtse","如何设置classpath","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(44,23,"yangtse","写bean类的准则（一）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(45,23,"yangtse","写bean类的准则 （二）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(46,23,"yangtse","写bean类的准则 （三）","2002/6/11/1023724800000.shtml",1023724800000);
INSERT INTO news VALUES(47,25,"yangtse","JAVA学习，是一条漫长的道路 （一）","2002/6/9/1023553155000.shtml",1023553155000);
INSERT INTO news VALUES(48,25,"yangtse","JAVA学习，是一条漫长的道路（二）","2002/6/9/1023553175000.shtml",1023553175000);
INSERT INTO news VALUES(49,25,"yangtse","java学习体悟 （一）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(50,25,"yangtse","java学习体悟 （二）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(51,25,"yangtse","java学习体悟 （三）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(52,22,"yangtse","异常处理优劣观 （一）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(53,22,"yangtse","异常处理优劣观（二）","2002/6/10/1023638400000.shtml",1023638400000);
INSERT INTO news VALUES(54,22,"yangtse","JavaHead：Java小程序的是是非非之一","2002/6/11/1023724800000.shtml",1023724800000);