工作中一些sql汇总（自己使用）

- 服务市场服务险二期开发，新增2张表。20190910-xyd
-- ----------------------------
-- Table structure for service_insurance_sku_black
-- ----------------------------
DROP TABLE IF EXISTS `service_insurance_sku_black`;
CREATE TABLE `service_insurance_sku_black` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `insured_vender_pid` bigint(20) unsigned NOT NULL COMMENT '服务商家表service_insurance_vender 的主键',
  `vender_id` bigint(20) unsigned NOT NULL COMMENT '服务商家id',
  `sku_id` bigint(20) unsigned NOT NULL COMMENT 'sku',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(20) DEFAULT '' COMMENT '创建人',
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `modifier` varchar(20) DEFAULT '' COMMENT '更新人',
  `yn` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效（1有效 0无效）',
  PRIMARY KEY (`id`),
  KEY `idx_insured_vender_pid` (`insured_vender_pid`) USING BTREE,
  KEY `idx_vender_id` (`vender_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='服务险loc订单sku剔除表';

-- ----------------------------
-- Table structure for service_insurance_vender
-- ----------------------------
DROP TABLE IF EXISTS `service_insurance_vender`;
CREATE TABLE `service_insurance_vender` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `vender_pid` bigint(20) unsigned NOT NULL COMMENT '服务商家表 vender 的主键',
  `vender_id` bigint(20) unsigned NOT NULL COMMENT '服务商家id',
  `insured_start_time` date NOT NULL COMMENT '投保开始时间（时间到天）',
  `insured_end_time` date NOT NULL COMMENT '投保结束时间（时间到天）',
  `insured_type` tinyint(2) unsigned NOT NULL COMMENT '订单类型：1：服务市场订单，2：LOC订单，3：包含1,2订单',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(20) DEFAULT '' COMMENT '创建人',
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `modifier` varchar(20) DEFAULT '' COMMENT '更新人',
  `yn` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效（1有效 0无效）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_vender_pid` (`vender_pid`) USING BTREE,
  UNIQUE KEY `uniq_vender_id` (`vender_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='投保商家表';