| commit | c8a17be0d1acb24cea38c14727bcb150349367fe | [log] [tgz] |
|---|---|---|
| author | dietricf <frank.dietrich@pta.de> | Wed Nov 04 05:15:58 2020 +0100 |
| committer | dietricf <frank.dietrich@pta.de> | Wed Nov 04 05:15:58 2020 +0100 |
| tree | b69ccec58006ce635d634b39b686786041914c19 | |
| parent | a8cc1fb22c44769e122c2730e30d7eeda8779ab8 [diff] |
added script #61 (3)
diff --git a/gfsBackendService/src/main/resources/db/migration/V0_61__CREATE_GFI_DB_Complete_V_1.0.0.sql b/gfsBackendService/src/main/resources/db/migration/V0_61__CREATE_GFI_DB_Complete_V_1.0.0.sql index 0d57452..4877466 100644 --- a/gfsBackendService/src/main/resources/db/migration/V0_61__CREATE_GFI_DB_Complete_V_1.0.0.sql +++ b/gfsBackendService/src/main/resources/db/migration/V0_61__CREATE_GFI_DB_Complete_V_1.0.0.sql
@@ -602,8 +602,8 @@ -- HTBL_FAILURE_INFORMATION_STATION -- ---------------------------------------------------------------------------- -DROP TABLE HTBL_FAILINFO_STATION; -DROP SEQUENCE HTBL_FAILINFO_STATION_ID_SEQ; +DROP TABLE IF EXISTS HTBL_FAILINFO_STATION CASCADE; +DROP SEQUENCE IF EXISTS HTBL_FAILINFO_STATION_ID_SEQ CASCADE; CREATE SEQUENCE PUBLIC.HTBL_FAILINFO_STATION_ID_SEQ INCREMENT BY 1;