CREATE TABLE `tb_user_business` (
  `busi_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `kind_expo_id` int(11) NOT NULL default '0',
  `sort` varchar(200) collate utf8_unicode_ci default NULL,
  `tag` varchar(200) collate utf8_unicode_ci default NULL,
  `username` varchar(200) collate utf8_unicode_ci default NULL,
  `pwd` varchar(200) collate utf8_unicode_ci default NULL,
  `company_name` varchar(200) collate utf8_unicode_ci default NULL,
  `company_name_short` varchar(50) collate utf8_unicode_ci default NULL,
  `company_name_en` varchar(200) collate utf8_unicode_ci default NULL,
  `company_logo` varchar(100) collate utf8_unicode_ci default NULL,
  `visualize` varchar(200) collate utf8_unicode_ci default NULL,
  `company_kind` varchar(200) collate utf8_unicode_ci default NULL,
  `register_money` varchar(200) collate utf8_unicode_ci default NULL,
  `register_place` varchar(200) collate utf8_unicode_ci default NULL,
  `employees` varchar(200) collate utf8_unicode_ci default NULL,
  `found_date` varchar(50) collate utf8_unicode_ci default NULL,
  `clase_date` varchar(50) collate utf8_unicode_ci default NULL,
  `corporation` varchar(200) collate utf8_unicode_ci default NULL,
  `scope` varchar(200) collate utf8_unicode_ci default NULL,
  `brand` varchar(200) collate utf8_unicode_ci default NULL,
  `product_value` varchar(200) collate utf8_unicode_ci default NULL,
  `owes` varchar(200) collate utf8_unicode_ci default NULL,
  `taking` varchar(200) collate utf8_unicode_ci default NULL,
  `export_value` varchar(200) collate utf8_unicode_ci default NULL,
  `asset` varchar(200) collate utf8_unicode_ci default NULL,
  `main_market` varchar(200) collate utf8_unicode_ci default NULL,
  `homepage` varchar(200) collate utf8_unicode_ci default NULL,
  `main_product` varchar(200) collate utf8_unicode_ci default NULL,
  `main_product_en` varchar(200) collate utf8_unicode_ci default NULL,
  `output` varchar(200) collate utf8_unicode_ci default NULL,
  `company_character` varchar(200) collate utf8_unicode_ci default NULL,
  `company_intro` text collate utf8_unicode_ci,
  `company_desc` text collate utf8_unicode_ci,
  `zone` varchar(200) collate utf8_unicode_ci default NULL,
  `big_district` varchar(200) collate utf8_unicode_ci default NULL,
  `small_district` varchar(200) collate utf8_unicode_ci default NULL,
  `address` varchar(200) collate utf8_unicode_ci default NULL,
  `postalcode` varchar(200) collate utf8_unicode_ci default NULL,
  `linkman` varchar(200) collate utf8_unicode_ci default NULL,
  `phone` varchar(200) collate utf8_unicode_ci default NULL,
  `mobile_phone` varchar(200) collate utf8_unicode_ci default NULL,
  `fax` varchar(200) collate utf8_unicode_ci default NULL,
  `email` varchar(200) collate utf8_unicode_ci default NULL,
  `msn` varchar(200) collate utf8_unicode_ci default NULL,
  `qq` varchar(200) collate utf8_unicode_ci default NULL,
  `main_custom` text collate utf8_unicode_ci,
  `company_group` varchar(200) collate utf8_unicode_ci default NULL,
  `export` varchar(200) collate utf8_unicode_ci default NULL,
  `core_technic` varchar(200) collate utf8_unicode_ci default NULL,
  `arts_technic` varchar(200) collate utf8_unicode_ci default NULL,
  `affiliation` varchar(200) collate utf8_unicode_ci default NULL,
  `station` varchar(200) collate utf8_unicode_ci default NULL,
  `in_market` smallint(6) NOT NULL default '0',
  `in_market_time` varchar(200) collate utf8_unicode_ci default NULL,
  `in_market_place` varchar(200) collate utf8_unicode_ci default NULL,
  `info_source` varchar(200) collate utf8_unicode_ci default NULL,
  `remark` text collate utf8_unicode_ci,
  `attentions` int(11) NOT NULL default '0',
  `is_abroad` smallint(6) NOT NULL default '0',
  `state` varchar(200) collate utf8_unicode_ci default NULL,
  `is_activity` smallint(6) NOT NULL default '0',
  `is_excellence` smallint(6) NOT NULL default '0',
  `self_ctrl` smallint(6) NOT NULL default '0',
  `sys_ctrl` smallint(6) NOT NULL default '0',
  `commend` smallint(6) NOT NULL default '0',
  `gotop` smallint(6) NOT NULL default '0',
  `edit_time` datetime default NULL,
  `member_level_id` int(11) NOT NULL default '0',
  `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `cr_time` datetime default NULL,
  PRIMARY KEY  (`busi_id`),
  KEY `sort` (`sort`),
  KEY `main_product` (`main_product`),
  KEY `tag` (`tag`),
  KEY `company_name` (`company_name`),
  KEY `modify_time` (`modify_time`),
  KEY `commend` (`commend`),
  KEY `gotop` (`gotop`),
  KEY `attentions` (`attentions`),
  KEY `member_level_id` (`member_level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2138600 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
viewtran  21232f297a57a5a743894a0e4a801fc3