

-- ----------------------------
-- Table structure for xy_timing
-- ----------------------------
DROP TABLE IF EXISTS `xy_timing`;
CREATE TABLE `xy_timing`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1,
  `time_type` tinyint(0) NULL DEFAULT 0,
  `day` int(0) NULL DEFAULT 1,
  `week` tinyint(1) NULL DEFAULT 1,
  `hour` tinyint(0) NULL DEFAULT 1,
  `minute` tinyint(0) NULL DEFAULT 30,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `last_time` int(0) NULL DEFAULT NULL,
  `next_time` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `type`(`type`) USING BTREE,
  INDEX `run`(`type`, `status`, `next_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '计划任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xy_timing
-- ----------------------------
INSERT INTO `xy_timing` VALUES (3, '每日后台统计', 'get_url', 1, 0, 5, 4, 4, 30, 'https://{$open_domain}.{$domain}/statistics/bsadmin/charts_statistics', 1618086600, 1618173000);
