Containerization feature of SO

[so.git] / bpmn / MSOCommonBPMN / src / test / resources / __files / CamundaDBScripts / Archive / drop_mariadb_engine_7.5.6.sql

diff --git a/bpmn/MSOCommonBPMN/src/test/resources/__files/CamundaDBScripts/Archive/drop_mariadb_engine_7.5.6.sql b/bpmn/MSOCommonBPMN/src/test/resources/__files/CamundaDBScripts/Archive/drop_mariadb_engine_7.5.6.sql
index 6ebc6e2..027f2d9 100644 (file)
--- a/bpmn/MSOCommonBPMN/src/test/resources/__files/CamundaDBScripts/Archive/drop_mariadb_engine_7.5.6.sql
+++ b/bpmn/MSOCommonBPMN/src/test/resources/__files/CamundaDBScripts/Archive/drop_mariadb_engine_7.5.6.sql
@@ -1,75 +1,75 @@
-use camundabpmn;\r
-/* \r
-Drop a archive tables\r
-*/\r
-/*-- TMP_ARCHIVING_PROCINST */\r
-DROP TABLE IF EXISTS TMP_ARCHIVING_PROCINST;\r
-\r
-/*-- TMP_ARCHIVING_BYTEARRAY */\r
-DROP TABLE IF EXISTS TMP_ARCHIVING_BYTEARRAY;\r
-\r
-/*-- TMP LOG TABLE */\r
-DROP TABLE IF EXISTS TMPLOGTABLE;\r
-\r
-/* -- Camunda Hi Tables --*/\r
-DROP TABLE IF EXISTS Camunda_Hi_Tables;\r
-\r
-/* drop own extentions columns:\r
-alter table  ARCHIVE_ACT_HI_PROCINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_ACTINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_TASKINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_VARINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_DETAIL DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_COMMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_ATTACHMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_OP_LOG DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-alter table  ARCHIVE_ACT_HI_INCIDENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);\r
-*/\r
-\r
-/*--#1 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_PROCINST;\r
-/*--#2 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ACTINST;\r
-/*--#3 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_TASKINST;\r
-/*--#4 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_VARINST;\r
-/*--#5 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_DETAIL;\r
-/*--#6 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_COMMENT;\r
-/*--#7 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ATTACHMENT;\r
-/*--#8 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_OP_LOG;\r
-/*--#9 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_HI_INCIDENT;\r
-/*--#10 */\r
-DROP TABLE IF EXISTS ARCHIVE_ACT_GE_BYTEARRAY;\r
-\r
-/* drop PL SQL procedures: */\r
-DROP PROCEDURE IF EXISTS ARCHIVE_CAMUNDA_HISTORY;\r
-DROP PROCEDURE IF EXISTS ROLLB_ARCHIVE_CAMUNDA_HISTORY;\r
- \r
-/*-- Sequence */\r
--- as sequence drop doesn't work automatically in MariaDB, use this procedure to drop sequence\r
- DROP PROCEDURE IF EXISTS DropSequence;\r
- \r
-  DELIMITER //\r
- \r
-  CREATE PROCEDURE DropSequence (vname VARCHAR(30))\r
-  BEGIN\r
-     -- Drop the sequence\r
-     DELETE FROM _sequences WHERE name = vname;  \r
-  END\r
-  //\r
-  DELIMITER ;\r
-\r
--- use the above procedure to drop sequence \r
-CALL DropSequence('STAT_EXECUTION_SEQ');\r
-\r
-/*-- To Drop the MariaDB specific user defined procedures and functions */\r
-DROP FUNCTION IF EXISTS NextVal;\r
-DROP PROCEDURE IF EXISTS CreateSequence;\r
-DROP PROCEDURE IF EXISTS DropSequence;\r
+use camundabpmn;
+/* 
+Drop a archive tables
+*/
+/*-- TMP_ARCHIVING_PROCINST */
+DROP TABLE IF EXISTS TMP_ARCHIVING_PROCINST;
+
+/*-- TMP_ARCHIVING_BYTEARRAY */
+DROP TABLE IF EXISTS TMP_ARCHIVING_BYTEARRAY;
+
+/*-- TMP LOG TABLE */
+DROP TABLE IF EXISTS TMPLOGTABLE;
+
+/* -- Camunda Hi Tables --*/
+DROP TABLE IF EXISTS Camunda_Hi_Tables;
+
+/* drop own extentions columns:
+alter table  ARCHIVE_ACT_HI_PROCINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_ACTINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_TASKINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_VARINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_DETAIL DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_COMMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_ATTACHMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_OP_LOG DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+alter table  ARCHIVE_ACT_HI_INCIDENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
+*/
+
+/*--#1 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_PROCINST;
+/*--#2 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ACTINST;
+/*--#3 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_TASKINST;
+/*--#4 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_VARINST;
+/*--#5 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_DETAIL;
+/*--#6 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_COMMENT;
+/*--#7 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ATTACHMENT;
+/*--#8 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_OP_LOG;
+/*--#9 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_HI_INCIDENT;
+/*--#10 */
+DROP TABLE IF EXISTS ARCHIVE_ACT_GE_BYTEARRAY;
+
+/* drop PL SQL procedures: */
+DROP PROCEDURE IF EXISTS ARCHIVE_CAMUNDA_HISTORY;
+DROP PROCEDURE IF EXISTS ROLLB_ARCHIVE_CAMUNDA_HISTORY;
+ 
+/*-- Sequence */
+-- as sequence drop doesn't work automatically in MariaDB, use this procedure to drop sequence
+ DROP PROCEDURE IF EXISTS DropSequence;
+ 
+  DELIMITER //
+ 
+  CREATE PROCEDURE DropSequence (vname VARCHAR(30))
+  BEGIN
+     -- Drop the sequence
+     DELETE FROM _sequences WHERE name = vname;  
+  END
+  //
+  DELIMITER ;
+
+-- use the above procedure to drop sequence 
+CALL DropSequence('STAT_EXECUTION_SEQ');
+
+/*-- To Drop the MariaDB specific user defined procedures and functions */
+DROP FUNCTION IF EXISTS NextVal;
+DROP PROCEDURE IF EXISTS CreateSequence;
+DROP PROCEDURE IF EXISTS DropSequence;
 DROP TABLE IF EXISTS _sequences;
\ No newline at end of file