whilvydy.sql

来自「用JAVA写的5款不错的新闻发布系统。希望对大家有所帮助」· SQL 代码 · 共 262 行 · 第 1/2 页

# 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,