[griffin] branch master updated: [GRIFFIN-231] fix

[gu...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

guoyp pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/griffin.git


The following commit(s) were added to refs/heads/master by this push:
     new 7508540  [GRIFFIN-231] fix
7508540 is described below

commit 7508540888f5e794449a80d4e94642986835efa5
Author: dstafy <di...@nike.com>
AuthorDate: Mon Mar 4 09:54:49 2019 +0800

    [GRIFFIN-231] fix
    
    use DROP TABLE IF EXISTS statements for the Quartz initialization script on Postgresql
    
    Author: dstafy <di...@nike.com>
    
    Closes #481 from xaniasd/master.
---
 .../src/main/resources/Init_quartz_postgres.sql    | 22 +++++++++++-----------
 1 file changed, 11 insertions(+), 11 deletions(-)

diff --git a/service/src/main/resources/Init_quartz_postgres.sql b/service/src/main/resources/Init_quartz_postgres.sql
index fb6e813..b5a930c 100644
--- a/service/src/main/resources/Init_quartz_postgres.sql
+++ b/service/src/main/resources/Init_quartz_postgres.sql
@@ -19,17 +19,17 @@
 -- In your Quartz properties file, you'll need to set
 -- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
 
-drop table qrtz_fired_triggers;
-DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
-DROP TABLE QRTZ_SCHEDULER_STATE;
-DROP TABLE QRTZ_LOCKS;
-drop table qrtz_simple_triggers;
-drop table qrtz_cron_triggers;
-drop table qrtz_simprop_triggers;
-DROP TABLE QRTZ_BLOB_TRIGGERS;
-drop table qrtz_triggers;
-drop table qrtz_job_details;
-drop table qrtz_calendars;
+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_cron_triggers;
+DROP TABLE IF EXISTS qrtz_simprop_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;
 
 CREATE TABLE qrtz_job_details
   (