DROP TABLE IF EXISTS `hms_mq`;
CREATE TABLE `hms_mq` (
  `id` bigint(20) NOT NULL,
  `mq_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `namesrv_addr` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;


DROP TABLE IF EXISTS `hms_shard`;
CREATE TABLE `hms_shard` (
  `id` bigint(20) NOT NULL,
  `shard` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;


DROP TABLE IF EXISTS `hms_topic`;
CREATE TABLE `hms_topic` (
  `id` bigint(20) NOT NULL,
  `mq_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `target_topic` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `msg` text COLLATE utf8mb4_bin,
  `msg_key` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `tags` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `delay` bigint(20) DEFAULT NULL,
  `delay_time` datetime DEFAULT NULL,
  `status` int(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_topic` (`target_topic`,`msg_key`,`delay`),
  KEY `idx_hms_topic` (`status`,`target_topic`,`delay`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;