# --------------------------------------------------------
#
# 表的结构 `NEAT_category`
#
DROP TABLE IF EXISTS `NEAT_category`;
CREATE TABLE `NEAT_category` (
`id` int(10) unsigned NOT NULL auto_increment,
`pid` int(10) NOT NULL default '0',
`orderid` int(10) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 表的结构 `NEAT_datas`
#
DROP TABLE IF EXISTS `NEAT_datas`;
CREATE TABLE `NEAT_datas` (
`id` int(10) unsigned NOT NULL auto_increment,
`link_id` int(10) unsigned NOT NULL default '0',
`rules` int(10) unsigned NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`body` text NOT NULL,
`author` varchar(200) NOT NULL default '',
`data_from` varchar(200) NOT NULL default '',
`intro` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`date` int(10) unsigned NOT NULL default '0',
`img_geted` int(1) NOT NULL default '0',
PRIMARY KEY (`id`,`link_id`),
KEY `rules` (`rules`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 表的结构 `NEAT_export`
#
DROP TABLE IF EXISTS `NEAT_export`;
CREATE TABLE `NEAT_export` (
`id` int(10) unsigned NOT NULL auto_increment,
`db_type` varchar(200) NOT NULL default '',
`rules` text NOT NULL,
`name` varchar(200) NOT NULL default '',
`host` varchar(200) NOT NULL default '',
`user` varchar(200) NOT NULL default '',
`password` varchar(200) NOT NULL default '',
`db_name` varchar(200) NOT NULL default '',
`article_table` varchar(200) NOT NULL default '',
`field_list` tinytext NOT NULL,
`value_list` tinytext NOT NULL,
`recount_fields_list` tinytext NOT NULL,
`recount_fields_value_list` tinytext NOT NULL,
`recount_rules_list` tinytext NOT NULL,
`recount_rules_value_list` tinytext NOT NULL,
`date` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 表的结构 `NEAT_filter`
#
DROP TABLE IF EXISTS `NEAT_filter`;
CREATE TABLE `NEAT_filter` (
`id` int(10) unsigned NOT NULL auto_increment,
`rule_id` int(10) unsigned NOT NULL default '0',
`filter_name` varchar(50) NOT NULL default '',
`filter_rule` text NOT NULL,
`filter_multi` int(1) NOT NULL default '0',
`filter_enter` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 表的结构 `NEAT_links`
#
DROP TABLE IF EXISTS `NEAT_links`;
CREATE TABLE `NEAT_links` (
`id` int(8) unsigned NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`url` varchar(200) NOT NULL default '',
`rules` int(8) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`adopt` int(1) unsigned NOT NULL default '1',
`import` int(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `url` (`url`),
KEY `adopt` (`adopt`,`import`),
KEY `rules` (`rules`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 表的结构 `NEAT_rules`
#
DROP TABLE IF EXISTS `NEAT_rules`;
CREATE TABLE `NEAT_rules` (
`id` int(10) unsigned NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`index_type` int(1) NOT NULL default '1',
`url` text NOT NULL,
`method` int(1) NOT NULL default '0',
`posts` text NOT NULL,
`cookies` text NOT NULL,
`page_start` int(11) NOT NULL default '0',
`page_end` int(11) NOT NULL default '0',
`filter` text NOT NULL,
`area_link` text NOT NULL,
`area_title` text NOT NULL,
`area_body` text NOT NULL,
`area_body_page` text NOT NULL,
`area_body_page_link` text NOT NULL,
`area_author` text NOT NULL,
`area_from` text NOT NULL,
`area_intro` text NOT NULL,
`multi_link` int(1) unsigned NOT NULL default '1',
`multi_title` int(1) unsigned NOT NULL default '1',
`multi_body` int(1) unsigned NOT NULL default '1',
`multi_body_page` int(1) NOT NULL default '0',
`multi_body_page_link` int(1) NOT NULL default '0',
`multi_author` int(1) NOT NULL default '0',
`multi_from` int(1) NOT NULL default '0',
`multi_intro` int(1) NOT NULL default '0',
`enter_link` int(1) unsigned NOT NULL default '0',
`enter_title` int(1) unsigned NOT NULL default '0',
`enter_body` int(1) unsigned NOT NULL default '0',
`enter_body_page` int(1) NOT NULL default '0',
`enter_body_page_link` int(1) NOT NULL default '0',
`enter_author` int(1) NOT NULL default '0',
`enter_from` int(1) NOT NULL default '0',
`enter_intro` int(1) NOT NULL default '0',
`link_num` int(10) unsigned NOT NULL default '0',
`import_num` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`body_page_type` int(1) NOT NULL default '0',
`link_replace` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `cid` (`cid`)
) TYPE=MyISAM;
