kw_extractor/data/domains_tmp.sql

34 lines
894 B
SQL

/*
Navicat MySQL Data Transfer
Source Server : ossean
Source Server Version : 50535
Source Host : 127.0.0.1:3306
Source Database : sedb
Target Server Type : MYSQL
Target Server Version : 50535
File Encoding : 65001
Date: 2016-12-23 17:01:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for domains_tmp
-- ----------------------------
DROP TABLE IF EXISTS `domains_tmp`;
CREATE TABLE `domains_tmp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dm_id` bigint(20) DEFAULT NULL,
`dm_name` varchar(80) DEFAULT NULL,
`dm_keyword` varchar(100) DEFAULT NULL,
`iscrawl` tinyint(4) DEFAULT NULL,
`crawltime` datetime DEFAULT NULL,
`se_type` varchar(15) DEFAULT NULL,
`isproxy` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `dm_id` (`dm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;