-- ----------------------------
-- Table structure for account_status
-- 账号状态上报表
-- ----------------------------
DROP TABLE IF EXISTS `account_status`;
CREATE TABLE `account_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `account` varchar(50) NOT NULL COMMENT '账号',
  `channel_id` int(11) NOT NULL COMMENT '渠道ID',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '上报状态',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `account_channel_unique` (`account`, `channel_id`) USING BTREE COMMENT '账号和渠道ID唯一索引',
  KEY `account_index` (`account`) USING BTREE,
  KEY `channel_id_index` (`channel_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='账号状态上报表';

