# MySQL-Front Dump 2.5
#
# Host: localhost   Database: jspcndb
# --------------------------------------------------------
# Server version 4.0.14-nt

USE jspcndb;


#
# Table structure for table 'wh_board'
#

DROP TABLE IF EXISTS wh_board;
CREATE TABLE wh_board (  board_id int(11) NOT NULL auto_increment,  type_id int(11) NOT NULL default '0',  board_name char(30) default NULL,  board_audit int(11) default NULL,  board_describ char(100) default NULL,  PRIMARY KEY  (board_id)) TYPE=MyISAM;



#
# Dumping data for table 'wh_board'
#

INSERT INTO wh_board VALUES("1", "1", "JSP中文網", "1", "JSP中文網");
INSERT INTO wh_board VALUES("2", "2", "JSP基礎", "1", "JSP基礎");
INSERT INTO wh_board VALUES("3", "2", "JSP中文", "1", "JSP中文");
INSERT INTO wh_board VALUES("4", "2", "JSP上傳", "1", "JSP上傳");
INSERT INTO wh_board VALUES("5", "3", "ASP基礎", "1", "ASP基礎");
INSERT INTO wh_board VALUES("6", "4", "PHP基礎", "1", "PHP基礎");
INSERT INTO wh_board VALUES("7", "4", "PHP配置", "1", "PHP配置");


#
# Table structure for table 'wh_keyword'
#

DROP TABLE IF EXISTS wh_keyword;
CREATE TABLE wh_keyword (  keyword_id int(11) NOT NULL auto_increment,  news_id int(11) default NULL,  keyword_value char(50) default NULL,  PRIMARY KEY  (keyword_id),  KEY wh_keyword_value (keyword_value)) TYPE=MyISAM;



#
# Dumping data for table 'wh_keyword'
#

INSERT INTO wh_keyword VALUES("12", "1", "jspcn");
INSERT INTO wh_keyword VALUES("11", "1", "發布系統");
INSERT INTO wh_keyword VALUES("10", "1", "新聞");
INSERT INTO wh_keyword VALUES("9", "1", "jsp");
INSERT INTO wh_keyword VALUES("13", "3", "Eclipse");
INSERT INTO wh_keyword VALUES("14", "3", "入門");
INSERT INTO wh_keyword VALUES("15", "4", "jspcn");
INSERT INTO wh_keyword VALUES("16", "5", "jspcn");
INSERT INTO wh_keyword VALUES("17", "6", "jspcn");


#
# Table structure for table 'wh_logrecord'
#

DROP TABLE IF EXISTS wh_logrecord;
CREATE TABLE wh_logrecord (  logrecord_id int(11) NOT NULL auto_increment,  user_name varchar(100) default NULL,  operation_time datetime default NULL,  logrecord_operation varchar(100) default NULL,  PRIMARY KEY  (logrecord_id),  KEY wh_logrecord_user_name (user_name)) TYPE=MyISAM;



#
# Dumping data for table 'wh_logrecord'
#

INSERT INTO wh_logrecord VALUES("1", "王輝", "2004-09-29 21:55:41", "add type name: jsp");
INSERT INTO wh_logrecord VALUES("2", "王輝", "2004-09-29 21:55:45", "add type name: asp");
INSERT INTO wh_logrecord VALUES("3", "王輝", "2004-09-29 21:56:04", "modify type name to: JSP技術 type_id: 1");
INSERT INTO wh_logrecord VALUES("4", "王輝", "2004-09-29 21:56:19", "modify type name to: ASP技術 type_id: 2");
INSERT INTO wh_logrecord VALUES("5", "王輝", "2004-09-29 21:58:01", "add board name: JSP基礎 type: 1");
INSERT INTO wh_logrecord VALUES("6", "王輝", "2004-09-29 21:58:15", "add board name: ASP基礎 type: 2");
INSERT INTO wh_logrecord VALUES("7", "王輝", "2004-09-29 21:58:59", "add news type: 1,board: 1, news title: jsp");
INSERT INTO wh_logrecord VALUES("8", "王輝", "2004-09-29 22:02:04", "add news type: 1,board: 1, news title: jsp入門");
INSERT INTO wh_logrecord VALUES("9", "王輝", "2004-09-29 22:03:19", "modify type name to: 技術新聞 type_id: 1");
INSERT INTO wh_logrecord VALUES("10", "王輝", "2004-09-29 22:03:39", "update board name to JSP新聞,type_id: 1");
INSERT INTO wh_logrecord VALUES("11", "王輝", "2004-09-29 22:03:49", "delete news type: 1,board: 1, news_id: 2");
INSERT INTO wh_logrecord VALUES("12", "王輝", "2004-09-29 22:04:38", "update news where news_id is 1");
INSERT INTO wh_logrecord VALUES("13", "王輝", "2004-09-29 22:38:35", "王輝 login system");
INSERT INTO wh_logrecord VALUES("14", "王輝", "2004-09-29 22:39:13", "update board name to JSP中文網,type_id: 1");
INSERT INTO wh_logrecord VALUES("15", "王輝", "2004-09-29 22:39:34", "modify type name to: JSP技術 type_id: 2");
INSERT INTO wh_logrecord VALUES("16", "王輝", "2004-09-29 22:39:49", "update board name to JSP基礎,type_id: 2");
INSERT INTO wh_logrecord VALUES("17", "王輝", "2004-09-29 22:40:01", "add board name: JSP中文 type: 1");
INSERT INTO wh_logrecord VALUES("18", "王輝", "2004-09-29 22:40:07", "update board name to JSP中文,type_id: 2");
INSERT INTO wh_logrecord VALUES("19", "王輝", "2004-09-29 22:40:21", "add board name: JSP上傳 type: 2");
INSERT INTO wh_logrecord VALUES("20", "王輝", "2004-09-29 22:40:33", "add type name: ASP技術");
INSERT INTO wh_logrecord VALUES("21", "王輝", "2004-09-29 22:40:44", "add board name: ASP基礎 type: 3");
INSERT INTO wh_logrecord VALUES("22", "王輝", "2004-09-29 22:40:55", "add type name: PHP技術");
INSERT INTO wh_logrecord VALUES("23", "王輝", "2004-09-29 22:41:07", "add board name: PHP基礎 type: 4");
INSERT INTO wh_logrecord VALUES("24", "王輝", "2004-09-29 22:41:36", "add board name: PHP配置 type: 4");
INSERT INTO wh_logrecord VALUES("25", "王輝", "2004-09-29 22:43:55", "update news where news_id is 1");
INSERT INTO wh_logrecord VALUES("26", "王輝", "2004-09-29 22:50:00", "add news type: 2,board: 2, news title: Eclipse使用入門");
INSERT INTO wh_logrecord VALUES("27", "王輝", "2004-09-29 22:51:29", "add news type: 1,board: 1, news title: JSP新聞發布系統2");
INSERT INTO wh_logrecord VALUES("28", "王輝", "2004-09-29 22:52:53", "add news type: 1,board: 1, news title: JSP新聞發布系統3");
INSERT INTO wh_logrecord VALUES("29", "王輝", "2004-09-29 22:53:54", "add news type: 1,board: 1, news title: JSP新聞發布系統4");


#
# Table structure for table 'wh_news'
#

DROP TABLE IF EXISTS wh_news;
CREATE TABLE wh_news (  news_id int(11) NOT NULL auto_increment,  type_id int(11) default NULL,  board_id int(11) default NULL,  news_title varchar(200) default NULL,  news_hits int(11) default NULL,  news_source varchar(100) default NULL,