| 2257 |
同步Sql到IT1:
[SQL:# 表结构有缺失 - 建议SQL:
#job_framework.qrtz_blob_triggers
USE job_framework;
CREATE TABLE `qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `QRTZ_BLOB_TRIGGERS_IBFK_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_calendars
USE job_framework;
CREATE TABLE `qrtz_calendars` (
`SCHED_NAME` varchar(120) NOT NULL,
`CALENDAR_NAME` varchar(200) NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_cron_triggers
USE job_framework;
CREATE TABLE `qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`CRON_EXPRESSION` varchar(120) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `QRTZ_CRON_TRIGGERS_IBFK_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_fired_triggers
USE job_framework;
CREATE TABLE `qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`FIRED_TIME` bigint NOT NULL,
`SCHED_TIME` bigint NOT NULL,
`PRIORITY` int NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(200) DEFAULT NULL,
`JOB_GROUP` varchar(200) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_job_details
USE job_framework;
CREATE TABLE `qrtz_job_details` (
`SCHED_NAME` varchar(120) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) NOT NULL,
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_locks
USE job_framework;
CREATE TABLE `qrtz_locks` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_paused_trigger_grps
USE job_framework;
CREATE TABLE `qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_scheduler_state
USE job_framework;
CREATE TABLE `qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`LAST_CHECKIN_TIME` bigint NOT NULL,
`CHECKIN_INTERVAL` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_simple_triggers
USE job_framework;
CREATE TABLE `qrtz_simple_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`REPEAT_COUNT` bigint NOT NULL,
`REPEAT_INTERVAL` bigint NOT NULL,
`TIMES_TRIGGERED` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_IBFK_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_simprop_triggers
USE job_framework;
CREATE TABLE `qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`STR_PROP_1` varchar(512) DEFAULT NULL,
`STR_PROP_2` varchar(512) DEFAULT NULL,
`STR_PROP_3` varchar(512) DEFAULT NULL,
`INT_PROP_1` int DEFAULT NULL,
`INT_PROP_2` int DEFAULT NULL,
`LONG_PROP_1` bigint DEFAULT NULL,
`LONG_PROP_2` bigint DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_IBFK_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.qrtz_triggers
USE job_framework;
CREATE TABLE `qrtz_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`NEXT_FIRE_TIME` bigint DEFAULT NULL,
`PREV_FIRE_TIME` bigint DEFAULT NULL,
`PRIORITY` int DEFAULT NULL,
`TRIGGER_STATE` varchar(16) NOT NULL,
`TRIGGER_TYPE` varchar(8) NOT NULL,
`START_TIME` bigint NOT NULL,
`END_TIME` bigint DEFAULT NULL,
`CALENDAR_NAME` varchar(200) DEFAULT NULL,
`MISFIRE_INSTR` smallint DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
CONSTRAINT `QRTZ_TRIGGERS_IBFK_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#job_framework.scheduled_task
USE job_framework;
CREATE TABLE `scheduled_task` (
`id` int NOT NULL AUTO_INCREMENT,
`group` varchar(20) NOT NULL COMMENT '分组',
`key` varchar(36) NOT NULL DEFAULT '' COMMENT '标识',
`payload` text,
`schedule_time` bigint unsigned NOT NULL COMMENT '执行时间',
`create_time` bigint unsigned NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `u_key` (`group`,`key`) USING BTREE,
KEY `key_time` (`schedule_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='任务调度表';
#job_framework.scheduled_task_archive
USE job_framework;
CREATE TABLE `scheduled_task_archive` (
`id` int NOT NULL,
`group` varchar(20) NOT NULL COMMENT '分组',
`key` varchar(36) NOT NULL DEFAULT '' COMMENT '标识',
`payload` text,
`schedule_time` bigint unsigned NOT NULL COMMENT '执行时间',
`create_time` bigint unsigned NOT NULL COMMENT '创建时间',
`status` enum('CREATED','FINISHED','CANCELLED') NOT NULL DEFAULT 'FINISHED' COMMENT '状态',
PRIMARY KEY (`id`),
KEY `i_key` (`group`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='任务调度表归档';
#xxl_job.xxl_job_qrtz_blob_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `xxl_job_qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxl_job_qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_calendars
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_calendars` (
`SCHED_NAME` varchar(120) NOT NULL,
`CALENDAR_NAME` varchar(200) NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_cron_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`CRON_EXPRESSION` varchar(200) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `xxl_job_qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxl_job_qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_fired_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`FIRED_TIME` bigint NOT NULL,
`SCHED_TIME` bigint NOT NULL,
`PRIORITY` int NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(200) DEFAULT NULL,
`JOB_GROUP` varchar(200) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_job_details
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_job_details` (
`SCHED_NAME` varchar(120) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) NOT NULL,
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_locks
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_locks` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_paused_trigger_grps
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_scheduler_state
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`LAST_CHECKIN_TIME` bigint NOT NULL,
`CHECKIN_INTERVAL` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_simple_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_simple_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`REPEAT_COUNT` bigint NOT NULL,
`REPEAT_INTERVAL` bigint NOT NULL,
`TIMES_TRIGGERED` bigint NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `xxl_job_qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxl_job_qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_simprop_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`STR_PROP_1` varchar(512) DEFAULT NULL,
`STR_PROP_2` varchar(512) DEFAULT NULL,
`STR_PROP_3` varchar(512) DEFAULT NULL,
`INT_PROP_1` int DEFAULT NULL,
`INT_PROP_2` int DEFAULT NULL,
`LONG_PROP_1` bigint DEFAULT NULL,
`LONG_PROP_2` bigint DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `xxl_job_qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxl_job_qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_trigger_group
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_trigger_group` (
`id` int NOT NULL AUTO_INCREMENT,
`app_name` varchar(64) NOT NULL COMMENT '执行器AppName',
`title` varchar(12) NOT NULL COMMENT '执行器名称',
`order` tinyint NOT NULL DEFAULT '0' COMMENT '排序',
`address_type` tinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
`address_list` varchar(512) DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_trigger_info
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_trigger_info` (
`id` int NOT NULL AUTO_INCREMENT,
`job_group` int NOT NULL COMMENT '执行器主键ID',
`job_cron` varchar(128) NOT NULL COMMENT '任务执行CRON',
`job_desc` varchar(255) NOT NULL,
`add_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`author` varchar(64) DEFAULT NULL COMMENT '作者',
`alarm_email` varchar(255) DEFAULT NULL COMMENT '报警邮件',
`executor_route_strategy` varchar(50) DEFAULT NULL COMMENT '执行器路由策略',
`executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
`executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
`executor_block_strategy` varchar(50) DEFAULT NULL COMMENT '阻塞处理策略',
`executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
`executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
`glue_type` varchar(50) NOT NULL COMMENT 'GLUE类型',
`glue_source` mediumtext COMMENT 'GLUE源代码',
`glue_remark` varchar(128) DEFAULT NULL COMMENT 'GLUE备注',
`glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
`child_jobid` varchar(255) DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_trigger_log
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_trigger_log` (
`id` int NOT NULL AUTO_INCREMENT,
`job_group` int NOT NULL COMMENT '执行器主键ID',
`job_id` int NOT NULL COMMENT '任务，主键ID',
`executor_address` varchar(255) DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
`executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
`executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
`executor_sharding_param` varchar(20) DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
`executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
`trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
`trigger_code` int NOT NULL COMMENT '调度-结果',
`trigger_msg` text COMMENT '调度-日志',
`handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
`handle_code` int NOT NULL COMMENT '执行-状态',
`handle_msg` text COMMENT '执行-日志',
PRIMARY KEY (`id`),
KEY `I_trigger_time` (`trigger_time`),
KEY `idx_handle_code` (`handle_code`) USING BTREE,
KEY `idx_job_group` (`job_group`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34151194 DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_trigger_logglue
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_trigger_logglue` (
`id` int NOT NULL AUTO_INCREMENT,
`job_id` int NOT NULL COMMENT '任务，主键ID',
`glue_type` varchar(50) DEFAULT NULL COMMENT 'GLUE类型',
`glue_source` mediumtext COMMENT 'GLUE源代码',
`glue_remark` varchar(128) NOT NULL COMMENT 'GLUE备注',
`add_time` timestamp NULL DEFAULT NULL,
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_trigger_registry
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_trigger_registry` (
`id` int NOT NULL AUTO_INCREMENT,
`registry_group` varchar(255) NOT NULL,
`registry_key` varchar(255) NOT NULL,
`registry_value` varchar(255) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10323 DEFAULT CHARSET=utf8mb3;
#xxl_job.xxl_job_qrtz_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`NEXT_FIRE_TIME` bigint DEFAULT NULL,
`PREV_FIRE_TIME` bigint DEFAULT NULL,
`PRIORITY` int DEFAULT NULL,
`TRIGGER_STATE` varchar(16) NOT NULL,
`TRIGGER_TYPE` varchar(8) NOT NULL,
`START_TIME` bigint NOT NULL,
`END_TIME` bigint DEFAULT NULL,
`CALENDAR_NAME` varchar(200) DEFAULT NULL,
`MISFIRE_INSTR` smallint DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
CONSTRAINT `xxl_job_qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `xxl_job_qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
]{"stdin":"","stdout":"","error":"mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1824 (HY000) at line 5: Failed to open the referenced table 'qrtz_triggers'\n","status":1} |
2024-09-22 11:13:16 |
| 2239 |
同步Sql到IT2:
[SQL:# 表结构有缺失 - 建议SQL:
#apolloconfigdb.app
USE apolloconfigdb;
CREATE TABLE `app` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`Name` varchar(500) NOT NULL DEFAULT 'default' COMMENT '应用名',
`OrgId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '部门Id',
`OrgName` varchar(64) NOT NULL DEFAULT 'default' COMMENT '部门名字',
`OwnerName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerName',
`OwnerEmail` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerEmail',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId` (`AppId`(191)),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_Name` (`Name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='应用表';
#apolloconfigdb.appnamespace
USE apolloconfigdb;
CREATE TABLE `appnamespace` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`Name` varchar(32) NOT NULL DEFAULT '' COMMENT 'namespace名字，注意，需要全局唯一',
`AppId` varchar(32) NOT NULL DEFAULT '' COMMENT 'app id',
`Format` varchar(32) NOT NULL DEFAULT 'properties' COMMENT 'namespace的format类型',
`IsPublic` bit(1) NOT NULL DEFAULT b'0' COMMENT 'namespace是否为公共',
`Comment` varchar(64) NOT NULL DEFAULT '' COMMENT '注释',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_AppId` (`AppId`),
KEY `Name_AppId` (`Name`,`AppId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='应用namespace定义';
#apolloconfigdb.audit
USE apolloconfigdb;
CREATE TABLE `audit` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`EntityName` varchar(50) NOT NULL DEFAULT 'default' COMMENT '表名',
`EntityId` int(10) unsigned DEFAULT NULL COMMENT '记录ID',
`OpName` varchar(50) NOT NULL DEFAULT 'default' COMMENT '操作类型',
`Comment` varchar(500) DEFAULT NULL COMMENT '备注',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=14150 DEFAULT CHARSET=utf8mb4 COMMENT='日志审计表';
#apolloconfigdb.cluster
USE apolloconfigdb;
CREATE TABLE `cluster` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`Name` varchar(32) NOT NULL DEFAULT '' COMMENT '集群名字',
`AppId` varchar(32) NOT NULL DEFAULT '' COMMENT 'App id',
`ParentClusterId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父cluster',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_AppId_Name` (`AppId`,`Name`),
KEY `IX_ParentClusterId` (`ParentClusterId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COMMENT='集群';
#apolloconfigdb.commit
USE apolloconfigdb;
CREATE TABLE `commit` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`ChangeSets` longtext NOT NULL COMMENT '修改变更集',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ClusterName',
`NamespaceName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'namespaceName',
`Comment` varchar(500) DEFAULT NULL COMMENT '备注',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `AppId` (`AppId`(191)),
KEY `ClusterName` (`ClusterName`(191)),
KEY `NamespaceName` (`NamespaceName`(191))
) ENGINE=InnoDB AUTO_INCREMENT=2101 DEFAULT CHARSET=utf8mb4 COMMENT='commit 历史表';
#apolloconfigdb.grayreleaserule
USE apolloconfigdb;
CREATE TABLE `grayreleaserule` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`AppId` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Cluster Name',
`NamespaceName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Namespace Name',
`BranchName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'branch name',
`Rules` varchar(16000) DEFAULT '[]' COMMENT '灰度规则',
`ReleaseId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '灰度对应的release',
`BranchStatus` tinyint(2) DEFAULT '1' COMMENT '灰度分支状态: 0:删除分支,1:正在使用的规则 2：全量发布',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_Namespace` (`AppId`,`ClusterName`,`NamespaceName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='灰度规则表';
#apolloconfigdb.instance
USE apolloconfigdb;
CREATE TABLE `instance` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`AppId` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'ClusterName',
`DataCenter` varchar(64) NOT NULL DEFAULT 'default' COMMENT 'Data Center Name',
`Ip` varchar(32) NOT NULL DEFAULT '' COMMENT 'instance ip',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
UNIQUE KEY `IX_UNIQUE_KEY` (`AppId`,`ClusterName`,`Ip`,`DataCenter`),
KEY `IX_IP` (`Ip`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=3366 DEFAULT CHARSET=utf8mb4 COMMENT='使用配置的应用实例';
#apolloconfigdb.instanceconfig
USE apolloconfigdb;
CREATE TABLE `instanceconfig` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`InstanceId` int(11) unsigned DEFAULT NULL COMMENT 'Instance Id',
`ConfigAppId` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Config App Id',
`ConfigClusterName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Config Cluster Name',
`ConfigNamespaceName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Config Namespace Name',
`ReleaseKey` varchar(64) NOT NULL DEFAULT '' COMMENT '发布的Key',
`ReleaseDeliveryTime` timestamp NULL DEFAULT NULL COMMENT '配置获取时间',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
UNIQUE KEY `IX_UNIQUE_KEY` (`InstanceId`,`ConfigAppId`,`ConfigNamespaceName`),
KEY `IX_ReleaseKey` (`ReleaseKey`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_Valid_Namespace` (`ConfigAppId`,`ConfigClusterName`,`ConfigNamespaceName`,`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=8104 DEFAULT CHARSET=utf8mb4 COMMENT='应用实例的配置信息';
#apolloconfigdb.item
USE apolloconfigdb;
CREATE TABLE `item` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`NamespaceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '集群NamespaceId',
`Key` varchar(128) NOT NULL DEFAULT 'default' COMMENT '配置项Key',
`Value` longtext NOT NULL COMMENT '配置项值',
`Comment` varchar(1024) DEFAULT '' COMMENT '注释',
`LineNum` int(10) unsigned DEFAULT '0' COMMENT '行号',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_GroupId` (`NamespaceId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=6681 DEFAULT CHARSET=utf8mb4 COMMENT='配置项目';
#apolloconfigdb.namespace
USE apolloconfigdb;
CREATE TABLE `namespace` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'Cluster Name',
`NamespaceName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'Namespace Name',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId_ClusterName_NamespaceName` (`AppId`(191),`ClusterName`(191),`NamespaceName`(191)),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_NamespaceName` (`NamespaceName`(191))
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COMMENT='命名空间';
#apolloconfigdb.namespacelock
USE apolloconfigdb;
CREATE TABLE `namespacelock` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`NamespaceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '集群NamespaceId',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT 'default' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
`IsDeleted` bit(1) DEFAULT b'0' COMMENT '软删除',
PRIMARY KEY (`Id`),
UNIQUE KEY `IX_NamespaceId` (`NamespaceId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='namespace的编辑锁';
#apolloconfigdb.release
USE apolloconfigdb;
CREATE TABLE `release` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`ReleaseKey` varchar(64) NOT NULL DEFAULT '' COMMENT '发布的Key',
`Name` varchar(64) NOT NULL DEFAULT 'default' COMMENT '发布名字',
`Comment` varchar(256) DEFAULT NULL COMMENT '发布说明',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ClusterName',
`NamespaceName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'namespaceName',
`Configurations` longtext NOT NULL COMMENT '发布配置',
`IsAbandoned` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否废弃',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId_ClusterName_GroupName` (`AppId`(191),`ClusterName`(191),`NamespaceName`(191)),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_ReleaseKey` (`ReleaseKey`)
) ENGINE=InnoDB AUTO_INCREMENT=1324 DEFAULT CHARSET=utf8mb4 COMMENT='发布';
#apolloconfigdb.releasehistory
USE apolloconfigdb;
CREATE TABLE `releasehistory` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`AppId` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`ClusterName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'ClusterName',
`NamespaceName` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'namespaceName',
`BranchName` varchar(32) NOT NULL DEFAULT 'default' COMMENT '发布分支名',
`ReleaseId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '关联的Release Id',
`PreviousReleaseId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '前一次发布的ReleaseId',
`Operation` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发布类型，0: 普通发布，1: 回滚，2: 灰度发布，3: 灰度规则更新，4: 灰度合并回主分支发布，5: 主分支发布灰度自动发布，6: 主分支回滚灰度自动发布，7: 放弃灰度',
`OperationContext` longtext NOT NULL COMMENT '发布上下文信息',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_Namespace` (`AppId`,`ClusterName`,`NamespaceName`,`BranchName`),
KEY `IX_ReleaseId` (`ReleaseId`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=1325 DEFAULT CHARSET=utf8mb4 COMMENT='发布历史';
#apolloconfigdb.releasemessage
USE apolloconfigdb;
CREATE TABLE `releasemessage` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`Message` varchar(1024) NOT NULL DEFAULT '' COMMENT '发布的消息内容',
`DataChange_LastTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_Message` (`Message`(191))
) ENGINE=InnoDB AUTO_INCREMENT=1327 DEFAULT CHARSET=utf8mb4 COMMENT='发布消息';
#apolloconfigdb.serverconfig
USE apolloconfigdb;
CREATE TABLE `serverconfig` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`Key` varchar(64) NOT NULL DEFAULT 'default' COMMENT '配置项Key',
`Cluster` varchar(32) NOT NULL DEFAULT 'default' COMMENT '配置对应的集群，default为不针对特定的集群',
`Value` varchar(2048) NOT NULL DEFAULT 'default' COMMENT '配置项值',
`Comment` varchar(1024) DEFAULT '' COMMENT '注释',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_Key` (`Key`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='配置服务自身配置';
#apolloportaldb.app
USE apolloportaldb;
CREATE TABLE `app` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`Name` varchar(500) NOT NULL DEFAULT 'default' COMMENT '应用名',
`OrgId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '部门Id',
`OrgName` varchar(64) NOT NULL DEFAULT 'default' COMMENT '部门名字',
`OwnerName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerName',
`OwnerEmail` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerEmail',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId` (`AppId`(191)),
KEY `DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_Name` (`Name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='应用表';
#apolloportaldb.appnamespace
USE apolloportaldb;
CREATE TABLE `appnamespace` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`Name` varchar(32) NOT NULL DEFAULT '' COMMENT 'namespace名字，注意，需要全局唯一',
`AppId` varchar(32) NOT NULL DEFAULT '' COMMENT 'app id',
`Format` varchar(32) NOT NULL DEFAULT 'properties' COMMENT 'namespace的format类型',
`IsPublic` bit(1) NOT NULL DEFAULT b'0' COMMENT 'namespace是否为公共',
`Comment` varchar(64) NOT NULL DEFAULT '' COMMENT '注释',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_AppId` (`AppId`),
KEY `Name_AppId` (`Name`,`AppId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='应用namespace定义';
#apolloportaldb.authorities
USE apolloportaldb;
CREATE TABLE `authorities` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`Username` varchar(50) NOT NULL,
`Authority` varchar(50) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;
#apolloportaldb.consumer
USE apolloportaldb;
CREATE TABLE `consumer` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`Name` varchar(500) NOT NULL DEFAULT 'default' COMMENT '应用名',
`OrgId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '部门Id',
`OrgName` varchar(64) NOT NULL DEFAULT 'default' COMMENT '部门名字',
`OwnerName` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerName',
`OwnerEmail` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'ownerEmail',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId` (`AppId`(191)),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='开放API消费者';
#apolloportaldb.consumeraudit
USE apolloportaldb;
CREATE TABLE `consumeraudit` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'Consumer Id',
`Uri` varchar(1024) NOT NULL DEFAULT '' COMMENT '访问的Uri',
`Method` varchar(16) NOT NULL DEFAULT '' COMMENT '访问的Method',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_ConsumerId` (`ConsumerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer审计表';
#apolloportaldb.consumerrole
USE apolloportaldb;
CREATE TABLE `consumerrole` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'Consumer Id',
`RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_RoleId` (`RoleId`),
KEY `IX_ConsumerId_RoleId` (`ConsumerId`,`RoleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer和role的绑定表';
#apolloportaldb.consumertoken
USE apolloportaldb;
CREATE TABLE `consumertoken` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`ConsumerId` int(11) unsigned DEFAULT NULL COMMENT 'ConsumerId',
`Token` varchar(128) NOT NULL DEFAULT '' COMMENT 'token',
`Expires` datetime NOT NULL DEFAULT '2099-01-01 00:00:00' COMMENT 'token失效时间',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
UNIQUE KEY `IX_Token` (`Token`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='consumer token表';
#apolloportaldb.favorite
USE apolloportaldb;
CREATE TABLE `favorite` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`UserId` varchar(32) NOT NULL DEFAULT 'default' COMMENT '收藏的用户',
`AppId` varchar(500) NOT NULL DEFAULT 'default' COMMENT 'AppID',
`Position` int(32) NOT NULL DEFAULT '10000' COMMENT '收藏顺序',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `AppId` (`AppId`(191)),
KEY `IX_UserId` (`UserId`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COMMENT='应用收藏表';
#apolloportaldb.permission
USE apolloportaldb;
CREATE TABLE `permission` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`PermissionType` varchar(32) NOT NULL DEFAULT '' COMMENT '权限类型',
`TargetId` varchar(256) NOT NULL DEFAULT '' COMMENT '权限对象类型',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_TargetId_PermissionType` (`TargetId`(191),`PermissionType`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=utf8mb4 COMMENT='permission表';
#apolloportaldb.role
USE apolloportaldb;
CREATE TABLE `role` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`RoleName` varchar(256) NOT NULL DEFAULT '' COMMENT 'Role name',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_RoleName` (`RoleName`(191)),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
#apolloportaldb.rolepermission
USE apolloportaldb;
CREATE TABLE `rolepermission` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id',
`PermissionId` int(10) unsigned DEFAULT NULL COMMENT 'Permission Id',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_RoleId` (`RoleId`),
KEY `IX_PermissionId` (`PermissionId`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=utf8mb4 COMMENT='角色和权限的绑定表';
#apolloportaldb.serverconfig
USE apolloportaldb;
CREATE TABLE `serverconfig` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`Key` varchar(64) NOT NULL DEFAULT 'default' COMMENT '配置项Key',
`Value` varchar(2048) NOT NULL DEFAULT 'default' COMMENT '配置项值',
`Comment` varchar(1024) DEFAULT '' COMMENT '注释',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) NOT NULL DEFAULT 'default' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_Key` (`Key`),
KEY `DataChange_LastTime` (`DataChange_LastTime`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='配置服务自身配置';
#apolloportaldb.userrole
USE apolloportaldb;
CREATE TABLE `userrole` (
`Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`UserId` varchar(128) DEFAULT '' COMMENT '用户身份标识',
`RoleId` int(10) unsigned DEFAULT NULL COMMENT 'Role Id',
`IsDeleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
`DataChange_CreatedBy` varchar(32) DEFAULT '' COMMENT '创建人邮箱前缀',
`DataChange_CreatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`DataChange_LastModifiedBy` varchar(32) DEFAULT '' COMMENT '最后修改人邮箱前缀',
`DataChange_LastTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`Id`),
KEY `IX_DataChange_LastTime` (`DataChange_LastTime`),
KEY `IX_RoleId` (`RoleId`),
KEY `IX_UserId_RoleId` (`UserId`,`RoleId`)
) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=utf8mb4 COMMENT='用户和role的绑定表';
#apolloportaldb.users
USE apolloportaldb;
CREATE TABLE `users` (
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
`Username` varchar(64) NOT NULL DEFAULT 'default' COMMENT '用户名',
`Password` varchar(64) NOT NULL DEFAULT 'default' COMMENT '密码',
`Email` varchar(64) NOT NULL DEFAULT 'default' COMMENT '邮箱地址',
`Enabled` tinyint(4) DEFAULT NULL COMMENT '是否有效',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
#dealmoon.deal_coupon_thirdparty
USE dealmoon;
CREATE TABLE `deal_coupon_thirdparty` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`store_id` int(32) NOT NULL COMMENT '商家ID',
`coupon` varchar(64) NOT NULL COMMENT '折扣码',
`start_time` bigint(20) NOT NULL COMMENT '生效时间',
`end_time` bigint(20) NOT NULL COMMENT '结束时间',
`url` varchar(1000) NOT NULL COMMENT '折扣码链接',
`img_url` varchar(255) NOT NULL COMMENT '图片地址',
`create_time` bigint(20) NOT NULL,
`update_time` bigint(20) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `storeid_copon` (`store_id`,`coupon`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='折扣绑定的折扣码';
#dealmoon.dis_re
USE dealmoon;
CREATE TABLE `dis_re` (
`user_id` int(11) DEFAULT NULL,
`gold` int(11) DEFAULT NULL,
`card` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#dealmoon.single_product_tag_back
USE dealmoon;
CREATE TABLE `single_product_tag_back` (
`id` int(11) NOT NULL DEFAULT '0' COMMENT 'id',
`title_cn` varchar(50) NOT NULL DEFAULT '' COMMENT 'titleCn',
`level` int(11) NOT NULL DEFAULT '-1' COMMENT 'level',
`create_editor_id` int(11) NOT NULL DEFAULT '-1' COMMENT 'createEditorId',
`create_time` bigint(15) NOT NULL DEFAULT '-1' COMMENT 'createTime',
`update_editor_id` int(11) NOT NULL DEFAULT '-1' COMMENT 'updateEditorId',
`update_time` bigint(15) NOT NULL DEFAULT '-1' COMMENT 'updateTime',
`level1_status` varchar(16) NOT NULL DEFAULT 'hidden',
`img_url` varchar(512) NOT NULL DEFAULT '',
`type` varchar(32) NOT NULL DEFAULT 'deal',
`level1_sort_num` int(11) NOT NULL DEFAULT '1',
`is_dummy_level2` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是用于绑定1-3级的特殊二级',
`title_en` varchar(50) NOT NULL DEFAULT '' COMMENT '分类英文名',
`tag_content` varchar(500) DEFAULT NULL COMMENT '标签描述信息'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_blob_triggers
USE job_framework;
CREATE TABLE `qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_calendars
USE job_framework;
CREATE TABLE `qrtz_calendars` (
`SCHED_NAME` varchar(120) NOT NULL,
`CALENDAR_NAME` varchar(200) NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_cron_triggers
USE job_framework;
CREATE TABLE `qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`CRON_EXPRESSION` varchar(120) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_fired_triggers
USE job_framework;
CREATE TABLE `qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`FIRED_TIME` bigint(13) NOT NULL,
`SCHED_TIME` bigint(13) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(200) DEFAULT NULL,
`JOB_GROUP` varchar(200) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_job_details
USE job_framework;
CREATE TABLE `qrtz_job_details` (
`SCHED_NAME` varchar(120) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) NOT NULL,
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_locks
USE job_framework;
CREATE TABLE `qrtz_locks` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_paused_trigger_grps
USE job_framework;
CREATE TABLE `qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_scheduler_state
USE job_framework;
CREATE TABLE `qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`LAST_CHECKIN_TIME` bigint(13) NOT NULL,
`CHECKIN_INTERVAL` bigint(13) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_simple_triggers
USE job_framework;
CREATE TABLE `qrtz_simple_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`REPEAT_COUNT` bigint(7) NOT NULL,
`REPEAT_INTERVAL` bigint(12) NOT NULL,
`TIMES_TRIGGERED` bigint(10) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_simprop_triggers
USE job_framework;
CREATE TABLE `qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`STR_PROP_1` varchar(512) DEFAULT NULL,
`STR_PROP_2` varchar(512) DEFAULT NULL,
`STR_PROP_3` varchar(512) DEFAULT NULL,
`INT_PROP_1` int(11) DEFAULT NULL,
`INT_PROP_2` int(11) DEFAULT NULL,
`LONG_PROP_1` bigint(20) DEFAULT NULL,
`LONG_PROP_2` bigint(20) DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#job_framework.qrtz_triggers
USE job_framework;
CREATE TABLE `qrtz_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
`PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
`PRIORITY` int(11) DEFAULT NULL,
`TRIGGER_STATE` varchar(16) NOT NULL,
`TRIGGER_TYPE` varchar(8) NOT NULL,
`START_TIME` bigint(13) NOT NULL,
`END_TIME` bigint(13) DEFAULT NULL,
`CALENDAR_NAME` varchar(200) DEFAULT NULL,
`MISFIRE_INSTR` smallint(2) DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#mailchimp.email_addr_list_prod_copy
USE mailchimp;
CREATE TABLE `email_addr_list_prod_copy` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`email_addr` varchar(64) NOT NULL,
`euid` varchar(16) NOT NULL DEFAULT '',
`f_name` varchar(32) NOT NULL DEFAULT '',
`l_name` varchar(32) NOT NULL DEFAULT '',
`sub_source` varchar(64) NOT NULL DEFAULT '' COMMENT 'subscriber source, currently dmweb, dmbf, dmbbs',
`ip` varchar(16) NOT NULL DEFAULT '',
`rating` tinyint(1) NOT NULL DEFAULT '2' COMMENT 'subscriber quality, 0 - 5',
`location` varchar(64) NOT NULL DEFAULT '',
`preference` varchar(64) NOT NULL DEFAULT '',
`tags` text NOT NULL,
`feedback` text NOT NULL,
`lang` varchar(6) NOT NULL DEFAULT 'zh',
`lang_update_src` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 for preset, 2 for update by user',
`date_create` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_subscribed` tinyint(1) NOT NULL DEFAULT '1',
`is_valid` tinyint(1) NOT NULL DEFAULT '1',
`sub_platform` tinyint(2) unsigned DEFAULT '1' COMMENT '订阅的平台',
`policy` tinyint(1) DEFAULT '1' COMMENT '订阅服务 1,mc中文|2,mc英文|3,sendcloud',
`last_sub_time` datetime DEFAULT NULL COMMENT '最后一次订阅时间',
`last_unsub_time` datetime DEFAULT NULL COMMENT '最后一次取消时间',
`unsub_policy` tinyint(1) DEFAULT '0' COMMENT '取消订阅的服务 1,mc中文|2,mc英文|3,sendcloud',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email_addr`),
KEY `lang` (`lang`),
KEY `date_create` (`date_create`)
) ENGINE=MyISAM AUTO_INCREMENT=1324556 DEFAULT CHARSET=utf8;
#public_test.public_test_sensitive_word
USE public_test;
CREATE TABLE `public_test_sensitive_word` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`public_test_id` int(11) NOT NULL COMMENT '众测id',
`source` enum('aliyun','deal') NOT NULL COMMENT '来源 aliyun-阿里云 deal-折扣敏感词 oc-oc敏感词',
`sensitive_key` varchar(255) NOT NULL COMMENT '敏感内容',
`weight` tinyint(1) DEFAULT '0' COMMENT '敏感程度 0-敏感 1-违规',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` bigint(13) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='众测敏感词';
#recdb.ad_rec_impression_record
USE recdb;
CREATE TABLE `ad_rec_impression_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`udid` varchar(40) NOT NULL COMMENT '设备ID',
`deal_id` int(11) NOT NULL COMMENT '折扣ID',
`ts` bigint(20) NOT NULL COMMENT '曝光时间',
PRIMARY KEY (`id`),
KEY `u_key` (`udid`,`ts`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='运营位推荐曝光记录表';
#recdb.ad_rec_oc_candidate
USE recdb;
CREATE TABLE `ad_rec_oc_candidate` (
`type` enum('post','guide') NOT NULL COMMENT '类型',
`id` int(10) unsigned NOT NULL COMMENT '折扣ID',
`lon` double DEFAULT NULL,
`lat` double DEFAULT NULL,
`distance_limit` int(11) NOT NULL DEFAULT '0' COMMENT '展示距离限制',
`impression` int(11) NOT NULL DEFAULT '0' COMMENT '曝光',
`clicks` int(11) NOT NULL DEFAULT '0' COMMENT '点击',
`ctr2` float NOT NULL DEFAULT '0' COMMENT 'ctr2',
`store_cpc` float NOT NULL DEFAULT '0',
`ecpm` float NOT NULL DEFAULT '0',
`ecpm1` float NOT NULL DEFAULT '0' COMMENT 'ECPM计算值',
`status` enum('normal','prior') NOT NULL DEFAULT 'normal' COMMENT '推荐状态',
`create_time` bigint(20) NOT NULL COMMENT '添加时间',
`editor_id` int(11) NOT NULL DEFAULT '0' COMMENT '添加编辑',
`editor_name` varchar(60) NOT NULL DEFAULT '' COMMENT '添加编辑',
PRIMARY KEY (`type`,`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OC候选池';
#recdb.ad_rec_oc_op_log
USE recdb;
CREATE TABLE `ad_rec_oc_op_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`res_type` enum('post','guide') NOT NULL,
`res_id` int(10) unsigned NOT NULL,
`ecpm` float NOT NULL DEFAULT '0',
`ctr1` float NOT NULL DEFAULT '0',
`ctr2` float NOT NULL DEFAULT '0',
`store_cpc` float NOT NULL DEFAULT '0',
`editor_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
`editor_name` varchar(60) NOT NULL DEFAULT '系统自动' COMMENT '操作人名称',
`op_type` enum('robot_remove','manual_add','manual_remove','manual_normal','manual_prior','robot_update') NOT NULL COMMENT '操作',
`op_desc` varchar(60) DEFAULT NULL,
`marks` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '一些标记信息',
`reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因',
`create_time` bigint(20) unsigned NOT NULL COMMENT '操作时间',
PRIMARY KEY (`id`),
KEY `key_res` (`res_type`,`res_id`,`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=utf8 COMMENT='运营位OC候选池操作日志';
#recdb.entropy_model_embedding_deal2
USE recdb;
CREATE TABLE `entropy_model_embedding_deal2` (
`docid` int(11) NOT NULL,
`update_time` datetime DEFAULT NULL,
`embedding` text,
UNIQUE KEY `docid` (`docid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
#recdb.front_search_statistical_info
USE recdb;
CREATE TABLE `front_search_statistical_info` (
`id` bigint(20) NOT NULL COMMENT 'id',
`keyword` varchar(2550) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关键字',
`keyword_cnt` bigint(20) DEFAULT NULL COMMENT '关键字次数',
`category_value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务名',
`totalhit_avg` bigint(20) DEFAULT NULL COMMENT '点击数平均值',
`site` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '站点',
PRIMARY KEY (`id`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
#recdb.recommend_word_tag_show
USE recdb;
CREATE TABLE `recommend_word_tag_show` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL COMMENT 'tag名',
`name_show` varchar(100) NOT NULL COMMENT '用于展示的tag名',
`create_time` bigint(13) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `u_key` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=79385 DEFAULT CHARSET=utf8mb4 COMMENT='推荐标签转换映射表';
#recdb.recommend_word_type
USE recdb;
CREATE TABLE `recommend_word_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL COMMENT 'tag名',
`tag_type` int(5) DEFAULT '0' COMMENT '有效状态 0:黑名单 待扩展',
`create_time` bigint(13) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `u_key` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='推荐标签表名单类型表';
#recdb.related_bigram_tag_mapping_bak
USE recdb;
CREATE TABLE `related_bigram_tag_mapping_bak` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`tag` varchar(50) NOT NULL COMMENT 'text tag',
`tag_type` varchar(32) DEFAULT NULL COMMENT 'tag类型：product-产品,brand-品牌',
`related_tag` varchar(2000) DEFAULT NULL COMMENT 'related tag',
`create_time` bigint(13) DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(13) DEFAULT NULL COMMENT '更新时间',
`tag_en` varchar(50) DEFAULT NULL COMMENT 'text tag en',
`related_tag_en` varchar(2000) DEFAULT NULL COMMENT 'related tag en',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tag_mapping` (`tag`)
) ENGINE=InnoDB AUTO_INCREMENT=6638 DEFAULT CHARSET=utf8mb4;
#recdb.single_impression_record_you_may_like
USE recdb;
CREATE TABLE `single_impression_record_you_may_like` (
`udid` varchar(100) NOT NULL,
`times_spId` mediumtext,
`updateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`udid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
#recdb.stats_daily_active_user
USE recdb;
CREATE TABLE `stats_daily_active_user` (
`day` int(10) NOT NULL COMMENT '月份(yyyyMMdd)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone_udids` longtext COMMENT 'iphone设备ID',
`iphone_user_ids` longtext COMMENT 'iphone用户ID',
`android_udids` longtext COMMENT 'android设备ID',
`android_user_ids` longtext COMMENT 'android用户ID',
`wap_udids` longtext COMMENT 'wap设备ID',
`wap_user_ids` longtext COMMENT 'wap用户ID',
`pc_udids` longtext COMMENT 'pc设备ID',
`pc_user_ids` longtext COMMENT 'pc用户ID',
PRIMARY KEY (`day`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日活跃用户记录表';
#recdb.stats_daily_user_active
USE recdb;
CREATE TABLE `stats_daily_user_active` (
`day` int(10) NOT NULL COMMENT '月份(yyyyMMdd)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone活跃用户总数',
`iphone_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone登陆活跃用户总数',
`android_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android活跃用户总数',
`android_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android登陆活跃用户总数',
`pc_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc活跃用户总数',
`pc_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc登陆活跃用户总数',
`wap_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap活跃用户总数',
`wap_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap登陆活跃用户总数',
PRIMARY KEY (`day`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户日活统计表';
#recdb.stats_monthly_buy
USE recdb;
CREATE TABLE `stats_monthly_buy` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone商家点击总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android商家点击总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc商家点击总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap商家点击总数',
`deal` int(10) NOT NULL DEFAULT '0' COMMENT '折扣商家点击总数',
`product` int(10) NOT NULL DEFAULT '0' COMMENT '单品商家点击总数',
`post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货商家点击总数',
`ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC商家点击总数',
`pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC商家点击总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站商家点击月度统计表';
#recdb.stats_monthly_comment
USE recdb;
CREATE TABLE `stats_monthly_comment` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone评论总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android评论总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc评论总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap评论总数',
`deal` int(10) NOT NULL DEFAULT '0' COMMENT '折扣评论总数',
`product` int(10) NOT NULL DEFAULT '0' COMMENT '单品评论总数',
`post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货评论总数',
`ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC评论总数',
`pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC评论总数',
`passed_iphone` int(10) NOT NULL DEFAULT '0' COMMENT '折扣审核通过评论总数',
`passed_android` int(10) NOT NULL DEFAULT '0' COMMENT '折扣审核通过评论总数',
`passed_pc` int(10) NOT NULL DEFAULT '0' COMMENT '折扣审核通过评论总数',
`passed_wap` int(10) NOT NULL DEFAULT '0' COMMENT '折扣审核通过评论总数',
`passed_deal` int(10) NOT NULL DEFAULT '0' COMMENT '折扣审核通过评论总数',
`passed_product` int(10) NOT NULL DEFAULT '0' COMMENT '单品审核通过评论总数',
`passed_post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货审核通过评论总数',
`passed_pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC审核通过评论总数',
`passed_ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC审核通过评论总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站评论月度统计表';
#recdb.stats_monthly_fav
USE recdb;
CREATE TABLE `stats_monthly_fav` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone收藏总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android收藏总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc收藏总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap收藏总数',
`deal` int(10) NOT NULL DEFAULT '0' COMMENT '折扣收藏总数',
`product` int(10) NOT NULL DEFAULT '0' COMMENT '单品收藏总数',
`post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货收藏总数',
`ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC收藏总数',
`pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC收藏总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站收藏月度统计表';
#recdb.stats_monthly_like
USE recdb;
CREATE TABLE `stats_monthly_like` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone点赞总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android点赞总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc点赞总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap点赞总数',
`post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货点赞总数',
`ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC点赞总数',
`pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC点赞总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站点赞月度统计表';
#recdb.stats_monthly_newsletter_subscribe
USE recdb;
CREATE TABLE `stats_monthly_newsletter_subscribe` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone注册页',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android注册页',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc注册页',
`pc_home` int(10) NOT NULL DEFAULT '0' COMMENT 'pc主站首页入口',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap注册页',
`ipad` int(10) NOT NULL DEFAULT '0' COMMENT 'ipad注册页',
`bbs_pc` int(10) NOT NULL DEFAULT '0' COMMENT 'bbs pc端',
`bbs_wap` int(10) NOT NULL DEFAULT '0' COMMENT 'bbs wap端',
`bbs_iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'bbs iphone端',
`bbs_ipad` int(10) NOT NULL DEFAULT '0' COMMENT 'bbs ipad端',
`bbs_android` int(10) NOT NULL DEFAULT '0' COMMENT 'bbs android端',
`mini_program` int(10) NOT NULL DEFAULT '0' COMMENT '微信小程序新',
`newsletter` int(10) NOT NULL DEFAULT '0' COMMENT '订阅邮件',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='newsletter订阅用户月度统计表';
#recdb.stats_monthly_share
USE recdb;
CREATE TABLE `stats_monthly_share` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone分享总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android分享总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc分享总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap分享总数',
`deal` int(10) NOT NULL DEFAULT '0' COMMENT '折扣分享总数',
`product` int(10) NOT NULL DEFAULT '0' COMMENT '单品分享总数',
`post` int(10) NOT NULL DEFAULT '0' COMMENT '晒货分享总数',
`ugc` int(10) NOT NULL DEFAULT '0' COMMENT '文章UGC分享总数',
`pgc` int(10) NOT NULL DEFAULT '0' COMMENT '文章PGC分享总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站分享月度统计表';
#recdb.stats_monthly_user_active
USE recdb;
CREATE TABLE `stats_monthly_user_active` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone_avg_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone日均活跃用户总数',
`iphone_avg_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone日均登陆活跃用户总数',
`android_avg_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android日均活跃用户总数',
`android_avg_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android日均登陆活跃用户总数',
`pc_avg_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc日均活跃用户总数',
`pc_avg_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc日均登陆活跃用户总数',
`wap_avg_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap日均活跃用户总数',
`wap_avg_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap日均登陆活跃用户总数',
`iphone_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone活跃用户总数',
`iphone_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone登陆活跃用户总数',
`android_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android活跃用户总数',
`android_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'android登陆活跃用户总数',
`pc_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc活跃用户总数',
`pc_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'pc登陆活跃用户总数',
`wap_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap活跃用户总数',
`wap_logged_in_active` int(10) NOT NULL DEFAULT '0' COMMENT 'wap登陆活跃用户总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户月活统计表';
#recdb.stats_monthly_user_register
USE recdb;
CREATE TABLE `stats_monthly_user_register` (
`month` int(10) NOT NULL COMMENT '月份(yyyyMM)',
`site` enum('US','CA','UK','DE','FR','AU') NOT NULL,
`iphone` int(10) NOT NULL DEFAULT '0' COMMENT 'iphone用户注册总数',
`android` int(10) NOT NULL DEFAULT '0' COMMENT 'android用户注册总数',
`pc` int(10) NOT NULL DEFAULT '0' COMMENT 'pc用户注册总数',
`wap` int(10) NOT NULL DEFAULT '0' COMMENT 'wap用户注册总数',
PRIMARY KEY (`month`,`site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全站用户注册月度统计表';
#recdb.tag_impression_record
USE recdb;
CREATE TABLE `tag_impression_record` (
`udid` varchar(100) NOT NULL,
`times_tagId` mediumtext,
`updateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`udid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='推荐Tag曝光记录表';
#recdb.tag_rec_related_tag
USE recdb;
CREATE TABLE `tag_rec_related_tag` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`tag` varchar(50) NOT NULL COMMENT 'text tag',
`related_tag` varchar(500) NOT NULL COMMENT 'related tag',
`create_time` bigint(13) DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(13) DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tag_related` (`tag`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=54563 DEFAULT CHARSET=utf8mb4;
#recdb.tmp_entropy_model_embedding_sp_tmp
USE recdb;
CREATE TABLE `tmp_entropy_model_embedding_sp_tmp` (
`docid` int(11) NOT NULL,
`update_time` datetime DEFAULT NULL,
`embedding` text,
UNIQUE KEY `docid` (`docid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
#recdb.tmp_user_hist_info_sp_tmp
USE recdb;
CREATE TABLE `tmp_user_hist_info_sp_tmp` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`updatetime` datetime DEFAULT NULL,
`udid` char(100) DEFAULT NULL,
`status` int(11) DEFAULT '1',
`info` text,
PRIMARY KEY (`id`),
KEY `udid` (`udid`)
) ENGINE=InnoDB AUTO_INCREMENT=285001 DEFAULT CHARSET=utf8mb4;
#recdb.ugc_bigram_tags
USE recdb;
CREATE TABLE `ugc_bigram_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL COMMENT '标签名',
`wd_freq` int(10) DEFAULT NULL COMMENT '词频',
`wd_type` int(10) DEFAULT NULL COMMENT '标签类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ugc二元词';
#recdb.ugc_gpt_tags
USE recdb;
CREATE TABLE `ugc_gpt_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(256) DEFAULT NULL COMMENT '标签名',
`wd_freq` int(10) DEFAULT NULL COMMENT '词频',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2308 DEFAULT CHARSET=utf8mb4 COMMENT='ugc gpt 提取词表';
#recdb.ugc_unigram_tags
USE recdb;
CREATE TABLE `ugc_unigram_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL COMMENT '标签名',
`wd_freq` int(10) DEFAULT NULL COMMENT '词频',
`wd_type` int(10) DEFAULT NULL COMMENT '标签类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='ugc一元词';
#recdb.user_impression_record
USE recdb;
CREATE TABLE `user_impression_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`udid` varchar(40) NOT NULL COMMENT '设备ID',
`category` varchar(40) NOT NULL COMMENT '分类',
`times_dealId` text COMMENT '记录',
PRIMARY KEY (`id`),
UNIQUE KEY `u_key` (`udid`,`category`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COMMENT='运营位推荐曝光记录表';
#service_tags.tags
USE service_tags;
CREATE TABLE `tags` (
`service` varchar(255) NOT NULL,
`tag` varchar(255) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
#sso.user1
USE sso;
CREATE TABLE `user1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL COMMENT '???????§?§?°',
`email` varchar(50) NOT NULL COMMENT '用户email',
`password` char(32) NOT NULL COMMENT 'md5(密码+hash)',
`status` enum('active','N-active','delete','cancellation','N-bind') NOT NULL DEFAULT 'N-active' COMMENT '用户状态 ',
`ip` varchar(255) NOT NULL DEFAULT '' COMMENT '?????¨??????’IP',
`create_time` int(11) NOT NULL DEFAULT '0',
`img_url` varchar(255) NOT NULL DEFAULT '' COMMENT '?¤????°????“?????¤?????’???¨???????????',
`sex` enum('men','secret','women') NOT NULL DEFAULT 'secret' COMMENT '??????§??????',
`birthday` char(10) NOT NULL DEFAULT '' COMMENT '生日',
`mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '????°??????“????????',
`introduce` varchar(100) NOT NULL DEFAULT '' COMMENT '?§??????¤?????',
`address` varchar(100) NOT NULL DEFAULT '' COMMENT '???±????¤???????“?°???’??',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '?§????¨?????????¤?????’??',
`repeatname` varchar(255) NOT NULL DEFAULT '' COMMENT '??????????¤?????????§?§?°',
`terms_agree` enum('disagree','agree') DEFAULT 'disagree' COMMENT '条款是否同意',
`disallowed_actions` varchar(50) DEFAULT NULL,
`disallowed_expires` int(11) NOT NULL,
`disallowed_begin_expires` int(11) DEFAULT NULL,
`three_register` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否第三方注册',
`auto_update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`dm_from` varchar(5) DEFAULT 'us',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `index_auto_update` (`auto_update_time`),
KEY `idx_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=1730280 DEFAULT CHARSET=utf8;
#sso.user_copy1
USE sso;
CREATE TABLE `user_copy1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL COMMENT '???????§?§?°',
`email` varchar(50) NOT NULL COMMENT '用户email',
`password` char(32) NOT NULL COMMENT 'md5(密码+hash)',
`status` enum('active','N-active','delete','cancellation','N-bind') NOT NULL DEFAULT 'N-active' COMMENT '用户状态 ',
`ip` varchar(255) NOT NULL DEFAULT '' COMMENT '?????¨??????’IP',
`create_time` int(11) NOT NULL DEFAULT '0',
`img_url` varchar(255) NOT NULL DEFAULT '' COMMENT '?¤????°????“?????¤?????’???¨???????????',
`sex` enum('men','secret','women') NOT NULL DEFAULT 'secret' COMMENT '??????§??????',
`birthday` char(10) NOT NULL DEFAULT '' COMMENT '生日',
`mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '????°??????“????????',
`introduce` varchar(100) NOT NULL DEFAULT '' COMMENT '?§??????¤?????',
`address` varchar(100) NOT NULL DEFAULT '' COMMENT '???±????¤???????“?°???’??',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '?§????¨?????????¤?????’??',
`repeatname` varchar(255) NOT NULL DEFAULT '' COMMENT '??????????¤?????????§?§?°',
`terms_agree` enum('disagree','agree') DEFAULT 'disagree' COMMENT '条款是否同意',
`disallowed_actions` varchar(50) DEFAULT NULL,
`disallowed_expires` int(11) NOT NULL,
`disallowed_begin_expires` int(11) DEFAULT NULL,
`three_register` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否第三方注册',
`auto_update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`dm_from` varchar(5) DEFAULT 'us',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `index_auto_update` (`auto_update_time`),
KEY `idx_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=1777729 DEFAULT CHARSET=utf8;
#ugc.vote_copy1
USE ugc;
CREATE TABLE `vote_copy1` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title_cn` varchar(255) DEFAULT NULL COMMENT '标题',
`desc_cn` varchar(255) DEFAULT NULL COMMENT '描述',
`select_num` tinyint(4) DEFAULT '1' COMMENT '每人可选项目数，1：表示单选，其余表示多选',
`start_time` int(11) DEFAULT NULL COMMENT '开始时间',
`end_time` int(11) DEFAULT NULL COMMENT '结束时间',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`need_login` tinyint(1) DEFAULT '0' COMMENT '是否需要登录才能投票',
`status` tinyint(4) DEFAULT NULL COMMENT '状态(0:未开始,1:进行中,2:已结束)',
`editor_id` int(10) DEFAULT NULL COMMENT '编辑人ID',
`img_url` varchar(255) DEFAULT NULL COMMENT '投票显示的图片',
`allow_custom` tinyint(1) DEFAULT '0' COMMENT '是否允许用户自定义投票项',
`user_total` int(11) DEFAULT '0' COMMENT '投票总人数',
`create_editor_id` int(10) DEFAULT NULL COMMENT '投票创建人',
PRIMARY KEY (`id`),
KEY `IDX_DATE_TIME` (`start_time`,`end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='记录投票定义';
#xxl_job.xxl_job_qrtz_blob_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#xxl_job.xxl_job_qrtz_calendars
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_calendars` (
`SCHED_NAME` varchar(120) NOT NULL,
`CALENDAR_NAME` varchar(200) NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#xxl_job.xxl_job_qrtz_cron_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`CRON_EXPRESSION` varchar(200) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#xxl_job.xxl_job_qrtz_fired_triggers
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`FIRED_TIME` bigint(13) NOT NULL,
`SCHED_TIME` bigint(13) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(200) DEFAULT NULL,
`JOB_GROUP` varchar(200) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#xxl_job.xxl_job_qrtz_job_details
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_job_details` (
`SCHED_NAME` varchar(120) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) NOT NULL,
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#xxl_job.xxl_job_qrtz_locks
USE xxl_job;
CREATE TABLE `xxl_job_qrtz_locks` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME |
2023-12-26 00:59:05 |