www.pudn.com > 200402121144312230.rar > 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);