From 0208c795499b808c762edbb3d61432410692dd6e Mon Sep 17 00:00:00 2001 From: chenhj <chenhj@lunor.cn> Date: 星期六, 24 五月 2025 14:50:15 +0800 Subject: [PATCH] Merge pull request 'chen' (#7) from chen into master --- sql/quartz.sql | 174 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 174 insertions(+), 0 deletions(-) diff --git a/sql/quartz.sql b/sql/quartz.sql new file mode 100644 index 0000000..cee613b --- /dev/null +++ b/sql/quartz.sql @@ -0,0 +1,174 @@ +DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS; +DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE; +DROP TABLE IF EXISTS QRTZ_LOCKS; +DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_TRIGGERS; +DROP TABLE IF EXISTS QRTZ_JOB_DETAILS; +DROP TABLE IF EXISTS QRTZ_CALENDARS; + +-- ---------------------------- +-- 1銆佸瓨鍌ㄦ瘡涓�涓凡閰嶇疆鐨� jobDetail 鐨勮缁嗕俊鎭� +-- ---------------------------- +create table QRTZ_JOB_DETAILS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + job_name varchar(200) not null comment '浠诲姟鍚嶇О', + job_group varchar(200) not null comment '浠诲姟缁勫悕', + description varchar(250) null comment '鐩稿叧浠嬬粛', + job_class_name varchar(250) not null comment '鎵ц浠诲姟绫诲悕绉�', + is_durable varchar(1) not null comment '鏄惁鎸佷箙鍖�', + is_nonconcurrent varchar(1) not null comment '鏄惁骞跺彂', + is_update_data varchar(1) not null comment '鏄惁鏇存柊鏁版嵁', + requests_recovery varchar(1) not null comment '鏄惁鎺ュ彈鎭㈠鎵ц', + job_data blob null comment '瀛樻斁鎸佷箙鍖杍ob瀵硅薄', + primary key (sched_name, job_name, job_group) +) engine=innodb comment = '浠诲姟璇︾粏淇℃伅琛�'; + +-- ---------------------------- +-- 2銆� 瀛樺偍宸查厤缃殑 Trigger 鐨勪俊鎭� +-- ---------------------------- +create table QRTZ_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_name varchar(200) not null comment '瑙﹀彂鍣ㄧ殑鍚嶅瓧', + trigger_group varchar(200) not null comment '瑙﹀彂鍣ㄦ墍灞炵粍鐨勫悕瀛�', + job_name varchar(200) not null comment 'qrtz_job_details琛╦ob_name鐨勫閿�', + job_group varchar(200) not null comment 'qrtz_job_details琛╦ob_group鐨勫閿�', + description varchar(250) null comment '鐩稿叧浠嬬粛', + next_fire_time bigint(13) null comment '涓婁竴娆¤Е鍙戞椂闂达紙姣锛�', + prev_fire_time bigint(13) null comment '涓嬩竴娆¤Е鍙戞椂闂达紙榛樿涓�-1琛ㄧず涓嶈Е鍙戯級', + priority integer null comment '浼樺厛绾�', + trigger_state varchar(16) not null comment '瑙﹀彂鍣ㄧ姸鎬�', + trigger_type varchar(8) not null comment '瑙﹀彂鍣ㄧ殑绫诲瀷', + start_time bigint(13) not null comment '寮�濮嬫椂闂�', + end_time bigint(13) null comment '缁撴潫鏃堕棿', + calendar_name varchar(200) null comment '鏃ョ▼琛ㄥ悕绉�', + misfire_instr smallint(2) null comment '琛ュ伩鎵ц鐨勭瓥鐣�', + job_data blob null comment '瀛樻斁鎸佷箙鍖杍ob瀵硅薄', + primary key (sched_name, trigger_name, trigger_group), + foreign key (sched_name, job_name, job_group) references QRTZ_JOB_DETAILS(sched_name, job_name, job_group) +) engine=innodb comment = '瑙﹀彂鍣ㄨ缁嗕俊鎭〃'; + +-- ---------------------------- +-- 3銆� 瀛樺偍绠�鍗曠殑 Trigger锛屽寘鎷噸澶嶆鏁帮紝闂撮殧锛屼互鍙婂凡瑙﹀彂鐨勬鏁� +-- ---------------------------- +create table QRTZ_SIMPLE_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + repeat_count bigint(7) not null comment '閲嶅鐨勬鏁扮粺璁�', + repeat_interval bigint(12) not null comment '閲嶅鐨勯棿闅旀椂闂�', + times_triggered bigint(10) not null comment '宸茬粡瑙﹀彂鐨勬鏁�', + primary key (sched_name, trigger_name, trigger_group), + foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) +) engine=innodb comment = '绠�鍗曡Е鍙戝櫒鐨勪俊鎭〃'; + +-- ---------------------------- +-- 4銆� 瀛樺偍 Cron Trigger锛屽寘鎷� Cron 琛ㄨ揪寮忓拰鏃跺尯淇℃伅 +-- ---------------------------- +create table QRTZ_CRON_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + cron_expression varchar(200) not null comment 'cron琛ㄨ揪寮�', + time_zone_id varchar(80) comment '鏃跺尯', + primary key (sched_name, trigger_name, trigger_group), + foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) +) engine=innodb comment = 'Cron绫诲瀷鐨勮Е鍙戝櫒琛�'; + +-- ---------------------------- +-- 5銆� Trigger 浣滀负 Blob 绫诲瀷瀛樺偍(鐢ㄤ簬 Quartz 鐢ㄦ埛鐢� JDBC 鍒涘缓浠栦滑鑷繁瀹氬埗鐨� Trigger 绫诲瀷锛孞obStore 骞朵笉鐭ラ亾濡備綍瀛樺偍瀹炰緥鐨勬椂鍊�) +-- ---------------------------- +create table QRTZ_BLOB_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + blob_data blob null comment '瀛樻斁鎸佷箙鍖朤rigger瀵硅薄', + primary key (sched_name, trigger_name, trigger_group), + foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) +) engine=innodb comment = 'Blob绫诲瀷鐨勮Е鍙戝櫒琛�'; + +-- ---------------------------- +-- 6銆� 浠� Blob 绫诲瀷瀛樺偍瀛樻斁鏃ュ巻淇℃伅锛� quartz鍙厤缃竴涓棩鍘嗘潵鎸囧畾涓�涓椂闂磋寖鍥� +-- ---------------------------- +create table QRTZ_CALENDARS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + calendar_name varchar(200) not null comment '鏃ュ巻鍚嶇О', + calendar blob not null comment '瀛樻斁鎸佷箙鍖朿alendar瀵硅薄', + primary key (sched_name, calendar_name) +) engine=innodb comment = '鏃ュ巻淇℃伅琛�'; + +-- ---------------------------- +-- 7銆� 瀛樺偍宸叉殏鍋滅殑 Trigger 缁勭殑淇℃伅 +-- ---------------------------- +create table QRTZ_PAUSED_TRIGGER_GRPS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + primary key (sched_name, trigger_group) +) engine=innodb comment = '鏆傚仠鐨勮Е鍙戝櫒琛�'; + +-- ---------------------------- +-- 8銆� 瀛樺偍涓庡凡瑙﹀彂鐨� Trigger 鐩稿叧鐨勭姸鎬佷俊鎭紝浠ュ強鐩歌仈 Job 鐨勬墽琛屼俊鎭� +-- ---------------------------- +create table QRTZ_FIRED_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + entry_id varchar(95) not null comment '璋冨害鍣ㄥ疄渚媔d', + trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + instance_name varchar(200) not null comment '璋冨害鍣ㄥ疄渚嬪悕', + fired_time bigint(13) not null comment '瑙﹀彂鐨勬椂闂�', + sched_time bigint(13) not null comment '瀹氭椂鍣ㄥ埗瀹氱殑鏃堕棿', + priority integer not null comment '浼樺厛绾�', + state varchar(16) not null comment '鐘舵��', + job_name varchar(200) null comment '浠诲姟鍚嶇О', + job_group varchar(200) null comment '浠诲姟缁勫悕', + is_nonconcurrent varchar(1) null comment '鏄惁骞跺彂', + requests_recovery varchar(1) null comment '鏄惁鎺ュ彈鎭㈠鎵ц', + primary key (sched_name, entry_id) +) engine=innodb comment = '宸茶Е鍙戠殑瑙﹀彂鍣ㄨ〃'; + +-- ---------------------------- +-- 9銆� 瀛樺偍灏戦噺鐨勬湁鍏� Scheduler 鐨勭姸鎬佷俊鎭紝鍋囧鏄敤浜庨泦缇や腑锛屽彲浠ョ湅鍒板叾浠栫殑 Scheduler 瀹炰緥 +-- ---------------------------- +create table QRTZ_SCHEDULER_STATE ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + instance_name varchar(200) not null comment '瀹炰緥鍚嶇О', + last_checkin_time bigint(13) not null comment '涓婃妫�鏌ユ椂闂�', + checkin_interval bigint(13) not null comment '妫�鏌ラ棿闅旀椂闂�', + primary key (sched_name, instance_name) +) engine=innodb comment = '璋冨害鍣ㄧ姸鎬佽〃'; + +-- ---------------------------- +-- 10銆� 瀛樺偍绋嬪簭鐨勬偛瑙傞攣鐨勪俊鎭�(鍋囧浣跨敤浜嗘偛瑙傞攣) +-- ---------------------------- +create table QRTZ_LOCKS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + lock_name varchar(40) not null comment '鎮茶閿佸悕绉�', + primary key (sched_name, lock_name) +) engine=innodb comment = '瀛樺偍鐨勬偛瑙傞攣淇℃伅琛�'; + +-- ---------------------------- +-- 11銆� Quartz闆嗙兢瀹炵幇鍚屾鏈哄埗鐨勮閿佽〃 +-- ---------------------------- +create table QRTZ_SIMPROP_TRIGGERS ( + sched_name varchar(120) not null comment '璋冨害鍚嶇О', + trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�', + trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�', + str_prop_1 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�', + str_prop_2 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟', + str_prop_3 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭涓変釜鍙傛暟', + int_prop_1 int null comment 'int绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�', + int_prop_2 int null comment 'int绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟', + long_prop_1 bigint null comment 'long绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�', + long_prop_2 bigint null comment 'long绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟', + dec_prop_1 numeric(13,4) null comment 'decimal绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�', + dec_prop_2 numeric(13,4) null comment 'decimal绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟', + bool_prop_1 varchar(1) null comment 'Boolean绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�', + bool_prop_2 varchar(1) null comment 'Boolean绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟', + primary key (sched_name, trigger_name, trigger_group), + foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) +) engine=innodb comment = '鍚屾鏈哄埗鐨勮閿佽〃'; + +commit; \ No newline at end of file -- Gitblit v1.9.3