--
-- 表的结构 `pb_trades` -----产品供求表
--
CREATE TABLE IF NOT EXISTS `pb_trades` (
`id` int(10) NOT NULL auto_increment,
`type_id` enum('8','7','6','5','4','3','2','1') NOT NULL default '1',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`member_id` int(10) NOT NULL default '0',
`company_id` int(5) NOT NULL default '0',
`cache_username` varchar(25) NOT NULL default '',
`cache_companyname` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`content` text,
`price` float(8,2) NOT NULL default '0.00',
`measuring_unit` varchar(15) NOT NULL default '0',
`monetary_unit` varchar(15) NOT NULL default '0',
`packing` varchar(150) NOT NULL default '',
`quantity` varchar(25) NOT NULL default '',
`offer_expire` int(10) NOT NULL default '0',
`spec` varchar(200) NOT NULL default '',
`sn` varchar(25) NOT NULL default '',
`picture` varchar(50) NOT NULL default '',
`picture_remote` varchar(50) NOT NULL default '',
`status` tinyint(2) NOT NULL default '0',
`submit_time` int(10) NOT NULL default '0',
`expire_time` int(10) NOT NULL default '0',
`expire_days` int(3) NOT NULL default '0',
`if_commend` tinyint(1) NOT NULL default '0',
`if_urgent` enum('0','1') NOT NULL default '0',
`if_locked` enum('0','1') NOT NULL default '0',
`require_point` smallint(6) NOT NULL default '0',
`require_membertype` smallint(6) NOT NULL default '0',
`require_freedate` int(10) NOT NULL default '0',
`ip_addr` varchar(15) NOT NULL default '',
`clicked` int(10) NOT NULL default '1',
`tag_ids` varchar(255) default '',
`formattribute_ids` text,
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
-- --------------------------------------------------------
--
-- 表的结构 `pb_companies` -----公司库
--
CREATE TABLE IF NOT EXISTS `pb_companies` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL,
`cache_spacename` varchar(255) NOT NULL default '',
`cache_membergroupid` smallint(3) NOT NULL default '0',
`cache_credits` smallint(6) NOT NULL default '0',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` char(6) NOT NULL default '0',
`area_id2` char(6) NOT NULL default '0',
`area_id3` char(6) NOT NULL default '0',
`type_id` tinyint(2) NOT NULL default '0',
`name` char(255) NOT NULL default '',
`description` text,
`english_name` char(100) NOT NULL default '',
`keywords` varchar(50) NOT NULL default '',
`boss_name` varchar(25) NOT NULL default '',
`manage_type` varchar(25) NOT NULL default '',
`year_annual` tinyint(2) NOT NULL default '0',
`property` tinyint(1) NOT NULL default '0',
`configs` text,
`bank_from` varchar(50) NOT NULL default '',
`bank_account` varchar(50) NOT NULL default '',
`main_prod` varchar(100) NOT NULL default '',
`employee_amount` varchar(25) NOT NULL default '',
`found_date` char(10) NOT NULL default '0',
`reg_fund` tinyint(2) NOT NULL default '0',
`reg_address` varchar(200) NOT NULL default '',
`address` varchar(200) NOT NULL default '',
`zipcode` varchar(15) NOT NULL default '',
`main_brand` varchar(100) NOT NULL default '',
`main_market` varchar(200) NOT NULL default '',
`main_biz_place` varchar(50) NOT NULL default '',
`main_customer` varchar(200) NOT NULL default '',
`link_man` varchar(25) NOT NULL default '',
`link_man_gender` tinyint(1) NOT NULL default '0',
`position` tinyint(1) NOT NULL default '0',
`telcode` varchar(8) NOT NULL default '',
`telzone` varchar(8) NOT NULL default '',
`tel` varchar(25) NOT NULL default '',
`faxcode` varchar(8) NOT NULL default '',
`faxzone` varchar(8) NOT NULL default '',
`fax` varchar(25) NOT NULL default '',
`mobile` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`site_url` varchar(100) NOT NULL default '',
`picture` varchar(50) NOT NULL default '',
`status` tinyint(1) NOT NULL default '0',
`first_letter` char(2) NOT NULL default '',
`if_commend` tinyint(1) NOT NULL default '0',
`clicked` int(5) NOT NULL default '1',
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- 表的结构 `pb_products` -----
--产品库表
CREATE TABLE IF NOT EXISTS `pb_products` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL,
`company_id` int(10) NOT NULL default '0',
`cache_companyname` varchar(100) NOT NULL default '',
`sort_id` tinyint(1) NOT NULL default '1',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`price` varchar(15) NOT NULL default '0',
`sn` varchar(20) NOT NULL default '',
`spec` varchar(20) NOT NULL default '',
`produce_area` varchar(50) NOT NULL default '',
`packing_content` varchar(100) NOT NULL default '',
`picture` varchar(50) NOT NULL default '',
`content` text,
`producttype_id` smallint(6) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`state` tinyint(1) NOT NULL default '1',
`ifnew` tinyint(1) NOT NULL default '0',
`ifcommend` tinyint(1) NOT NULL default '0',
`priority` tinyint(1) NOT NULL default '0',
`tag_ids` varchar(255) default '',
`clicked` smallint(6) NOT NULL default '1',
`formattribute_ids` text,
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- 表的结构 `pb_markets` ----市场表
--
CREATE TABLE IF NOT EXISTS `pb_markets` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`content` text,
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`picture` varchar(50) NOT NULL default '',
`ip_address` int(10) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`clicked` smallint(6) NOT NULL default '1',
`if_commend` tinyint(1) NOT NULL default '0',
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- 表的结构 `pb_jobs` -----职位信息表
--
CREATE TABLE IF NOT EXISTS `pb_jobs` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL default '-1',
`company_id` int(10) NOT NULL default '-1',
`cache_spacename` varchar(25) NOT NULL default '',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`name` varchar(150) NOT NULL default '',
`work_station` varchar(50) NOT NULL default '',
`content` text,
`require_gender_id` tinyint(1) NOT NULL,
`peoples` varchar(5) NOT NULL default '',
`require_education_id` tinyint(1) NOT NULL,
`require_age` varchar(10) NOT NULL default '',
`salary_id` tinyint(1) NOT NULL,
`worktype_id` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL default '0',
`clicked` int(5) NOT NULL default '0',
`expire_time` int(10) NOT NULL default '0',
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- 表的结构 `pb_expoes` -----展会表
--
CREATE TABLE IF NOT EXISTS `pb_expoes` (
`id` int(10) NOT NULL auto_increment,
`expotype_id` smallint(3) NOT NULL,
`name` varchar(100) NOT NULL default '',
`description` text,
`begin_time` int(10) NOT NULL default '0',
`end_time` int(10) NOT NULL default '0',
`industry_ids` varchar(100) NOT NULL default '0',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`address` varchar(100) NOT NULL default '',
`stadium_name` varchar(100) NOT NULL default '',
`refresh_method` varchar(100) NOT NULL default '',
`scope` varchar(100) NOT NULL default '',
`hosts` varchar(255) NOT NULL default '',
`organisers` varchar(255) NOT NULL default '',
`co_organisers` varchar(255) NOT NULL default '',
`sponsors` varchar(255) NOT NULL default '',
`contacts` text,
`important_notice` text,
`picture` varchar(100) NOT NULL default '',
`if_commend` tinyint(1) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`hits` smallint(6) NOT NULL default '1',
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- 表的结构 `pb_topics` ---专题
--
CREATE TABLE IF NOT EXISTS `pb_topics` (
`id` smallint(6) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`picture` varchar(255) NOT NULL default '',
`description` text,
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- 表的结构 `pb_topicnews`
--
CREATE TABLE IF NOT EXISTS `pb_topicnews` (
`topic_id` smallint(6) NOT NULL default '0',
`news_id` smallint(6) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 表的结构 `pb_newses` -----资讯表
--
CREATE TABLE IF NOT EXISTS `pb_newses` (
`id` smallint(6) NOT NULL auto_increment,
`type_id` int(5) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`content` text,
`source` varchar(25) NOT NULL default '',
`picture` varchar(50) NOT NULL default '',
`if_focus` tinyint(1) NOT NULL default '0',
`if_commend` tinyint(1) NOT NULL default '0',
`highlight` tinyint(1) NOT NULL default '0',
`clicked` int(10) NOT NULL default '1',
`status` tinyint(1) NOT NULL default '1',
`require_membertype` varchar(15) NOT NULL default '0',
`tag_ids` varchar(255) default '',
`created` int(10) NOT NULL default '0',
`create_time` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- 表的结构 `pb_ordergoods` ----资讯类型表
--
CREATE TABLE IF NOT EXISTS `pb_ordergoods` (
`goods_id` smallint(6) NOT NULL,
`order_id` smallint(6) unsigned zerofill NOT NULL,
`amount` smallint(3) NOT NULL default '1',
PRIMARY KEY (`goods_id`,`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 表的结构 `pb_tags` ----标签库
--
CREATE TABLE IF NOT EXISTS `pb_tags` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL,
`name` varchar(255) NOT NULL default '',
`numbers` smallint(6) NOT NULL default '0',
`closed` tinyint(1) NOT NULL default '0',
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `title` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- 表的结构 `pb_companynewses` ----企业新闻
--
CREATE TABLE IF NOT EXISTS `pb_companynewses` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL,
`company_id` int(10) NOT NULL,
`title` varchar(100) NOT NULL default '',
`content` text,
`picture` varchar(100) NOT NULL default '',
`status` tinyint(1) NOT NULL default '0',
`clicked` int(5) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`modified` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;正文完
