data_stream/double_publicity.md

@@ -915,10 +915,10 @@ CREATE TABLE `company_license_info_creditchina` (
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
   PRIMARY KEY (`id`),
   UNIQUE KEY `company_name_licence_number` (`company_name`,`licence_number`),
-  KEY `company_name` (`company_name`),
-  KEY `licence_number` (`licence_number`),
   KEY `idx_company_id` (`company_id`),
-  KEY `idx_company_id` (`audit_ype`)
+  KEY `idx_create_time` (`create_time`),
+  KEY `idx_update_time` (`update_time`),
+  KEY `idx_audit_ype` (`audit_ype`)
 ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='行政许可-信用中国';
 ```
 
@@ -955,8 +955,6 @@ CREATE TABLE `company_punishment_info_creditchina` (
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
   PRIMARY KEY (`id`),
   UNIQUE KEY `company_name_punish_number` (`company_name`,`punish_number`),
-  KEY `company_name` (`company_name`),
-  KEY `punish_number` (`punish_number`),
   KEY `idx_company_id` (`company_id`),
   KEY `idx_create_time` (`create_time`),
   KEY `idx_update_time` (`update_time`),