mysqldata

又一个新闻发布系统,jsp开发的,想和大家交流一下

#
# Table structure for table 'news_admin'
#

CREATE TABLE `news_admin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `account` varchar(30) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `level` tinyint(4) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_imgs'
#

CREATE TABLE `news_imgs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `info_id` int(10) unsigned NOT NULL default '0',
  `img_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_info'
#

CREATE TABLE `news_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type_id` int(10) unsigned NOT NULL default '0',
  `topic` varchar(255) NOT NULL default '',
  `light` varchar(8) NOT NULL default '',
  `content` text NOT NULL,
  `content_type` tinyint(4) NOT NULL default '0',
  `pagination` varchar(14) NOT NULL default '',
  `keywords` varchar(50) NOT NULL default '',
  `click` int(11) NOT NULL default '0',
  `source` varchar(200) NOT NULL default '',
  `publish_html` tinyint(4) NOT NULL default '0',
  `commend` tinyint(4) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `pagination` (`pagination`),
  KEY `type_id` (`type_id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_module'
#

CREATE TABLE `news_module` (
  `mid` int(10) unsigned NOT NULL auto_increment,
  `module` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`mid`)
) TYPE=MyISAM;



#
# Table structure for table 'news_type_module'
#

CREATE TABLE `news_type_module` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `mid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_type'
#

CREATE TABLE `news_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_visit_limit'
#

CREATE TABLE `news_visit_limit` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `page` varchar(100) NOT NULL default '',
  `visitor` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'news_visitor_type'
#

CREATE TABLE `news_visitor_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `type_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


INSERT INTO news_visit_limit VALUES (1, '帐号管理', 'admin_account.jsp', '1');
INSERT INTO news_visit_limit VALUES (9, '预览新闻', 'pre_view.jsp', '1,0,-1');
INSERT INTO news_visit_limit VALUES (2, '生成新闻', 'dealing1.jsp', '1,0');
INSERT INTO news_visit_limit VALUES (3, '数据统计', 'analyse.jsp', '1');
INSERT INTO news_visit_limit VALUES (4, '发布新闻', 'publish_buttom.jsp', '1,0,-1');
INSERT INTO news_visit_limit VALUES (5, '管理新闻', 'control.jsp', '1,0,-1');
INSERT INTO news_visit_limit VALUES (6, '管理栏目', 'control_type.jsp', '1,0');
INSERT INTO news_visit_limit VALUES (7, '推荐新闻', 'commend_news.jsp', '1,0');
INSERT INTO news_visit_limit VALUES (8, '批量转移', 'move.jsp', '1,0');
INSERT INTO news_visit_limit VALUES (10, '修改密码', 'modify_pwd.jsp', '1,0,-1');
INSERT INTO news_visit_limit VALUES (11, '', 'admin_account_limit2.jsp', '1');
INSERT INTO news_visit_limit VALUES (12, '', 'admin_account_limit1.jsp', '1');
INSERT INTO news_visit_limit VALUES (13, '管理模版', 'control_module.jsp', '1');

INSERT INTO news_module VALUES (32, '11');
INSERT INTO news_module VALUES (33, '22');
INSERT INTO news_module VALUES (34, '33');
INSERT INTO news_module VALUES (35, '44');
INSERT INTO news_module VALUES (36, '55');


INSERT INTO news_admin VALUES (1, 'admin', '21232F297A57A5A743894A0E4A801FC3', 1, '0000-00-00 00:00:00');
INSERT INTO news_admin VALUES (2, 'm_editor', '21232F297A57A5A743894A0E4A801FC3', 0, '0000-00-00 00:00:00');
INSERT INTO news_admin VALUES (3, 'editor', '21232F297A57A5A743894A0E4A801FC3', -1, '0000-00-00 00:00:00');
INSERT INTO news_admin VALUES (11, 'q', '7694F4A66316E53C8CDD9D9954BD611D', -1, '2003-06-12 16:13:36');