1 -- Fix for https://itrack.web.att.com/browse/AJSCCMDA-90 --
6 /*-- TMP_ARCHIVING_PROCINST */
7 DROP TABLE IF EXISTS TMP_ARCHIVING_PROCINST;
9 /*-- TMP_ARCHIVING_BYTEARRAY */
10 DROP TABLE IF EXISTS TMP_ARCHIVING_BYTEARRAY;
13 DROP TABLE IF EXISTS TMPLOGTABLE;
15 /* -- Camunda Hi Tables --*/
16 DROP TABLE IF EXISTS Camunda_Hi_Tables;
18 /* drop own extentions columns:
19 alter table ARCHIVE_ACT_HI_PROCINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
20 alter table ARCHIVE_ACT_HI_ACTINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
21 alter table ARCHIVE_ACT_HI_TASKINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
22 alter table ARCHIVE_ACT_HI_VARINST DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
23 alter table ARCHIVE_ACT_HI_DETAIL DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
24 alter table ARCHIVE_ACT_HI_COMMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
25 alter table ARCHIVE_ACT_HI_ATTACHMENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
26 alter table ARCHIVE_ACT_HI_OP_LOG DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
27 alter table ARCHIVE_ACT_HI_INCIDENT DROP (STAT_EXECUTION_ID, STAT_EXECUTION_TS);
31 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_PROCINST;
33 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ACTINST;
35 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_TASKINST;
37 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_VARINST;
39 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_DETAIL;
41 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_COMMENT;
43 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_ATTACHMENT;
45 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_OP_LOG;
47 DROP TABLE IF EXISTS ARCHIVE_ACT_HI_INCIDENT;
49 DROP TABLE IF EXISTS ARCHIVE_ACT_GE_BYTEARRAY;
51 /* drop PL SQL procedures: */
52 DROP PROCEDURE IF EXISTS ARCHIVE_CAMUNDA_HISTORY;
53 DROP PROCEDURE IF EXISTS ROLLB_ARCHIVE_CAMUNDA_HISTORY;
56 -- as sequence drop doesn't work automatically in MariaDB, use this procedure to drop sequence
57 DROP PROCEDURE IF EXISTS DropSequence;
61 CREATE PROCEDURE DropSequence (vname VARCHAR(30))
64 DELETE FROM _sequences WHERE name = vname;
69 -- use the above procedure to drop sequence
70 CALL DropSequence('STAT_EXECUTION_SEQ');
72 /*-- To Drop the MariaDB specific user defined procedures and functions */
73 DROP FUNCTION IF EXISTS NextVal;
74 DROP PROCEDURE IF EXISTS CreateSequence;
75 DROP PROCEDURE IF EXISTS DropSequence;
76 DROP TABLE IF EXISTS _sequences;