Skip to content

Cheat Sheet

Clean Up Database

DROP VIEW DIRIGIBLE_DISCUSSIONS_BOARD_RATING;
DROP VIEW DIRIGIBLE_DISCUSSIONS_BOARD_STATS;
DROP VIEW DIRIGIBLE_DISCUSSIONS_STATS;

DROP TABLE DIRIGIBLE_BPM;
DROP TABLE DIRIGIBLE_DATA_STRUCTURES;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD_TAG;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD_VOTE;
DROP TABLE DIRIGIBLE_DISCUSSIONS_TAGS;
DROP TABLE DIRIGIBLE_DISCUSSIONS_USERS;
DROP TABLE DIRIGIBLE_DISCUSSIONS_COMMENT;
DROP TABLE DIRIGIBLE_EXTENSIONS;
DROP TABLE DIRIGIBLE_EXTENSION_POINTS;
DROP TABLE DIRIGIBLE_IDENTITY;
DROP TABLE DIRIGIBLE_JOBS;
DROP TABLE DIRIGIBLE_LISTENERS;
DROP TABLE DIRIGIBLE_MIGRATIONS;
DROP TABLE DIRIGIBLE_ODATA;
DROP TABLE DIRIGIBLE_ODATA_CONTAINER;
DROP TABLE DIRIGIBLE_ODATA_MAPPING;
DROP TABLE DIRIGIBLE_ODATA_SCHEMA;
DROP TABLE DIRIGIBLE_PUBLISH_LOGS;
DROP TABLE DIRIGIBLE_PUBLISH_REQUESTS;
DROP TABLE DIRIGIBLE_SECURITY_ACCESS;
DROP TABLE DIRIGIBLE_SECURITY_ROLES;
DROP TABLE DIRIGIBLE_SYNCHRONIZER_STATE;
DROP TABLE DIRIGIBLE_SYNCHRONIZER_STATE_LOG;
DROP TABLE DIRIGIBLE_WEBSOCKETS;

DROP TABLE QUARTZ_BLOB_TRIGGERS;
DROP TABLE QUARTZ_CALENDARS;
DROP TABLE QUARTZ_CRON_TRIGGERS;
DROP TABLE QUARTZ_FIRED_TRIGGERS;
DROP TABLE QUARTZ_LOCKS;
DROP TABLE QUARTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE QUARTZ_SCHEDULER_STATE;
DROP TABLE QUARTZ_SIMPLE_TRIGGERS;
DROP TABLE QUARTZ_SIMPROP_TRIGGERS;
DROP TABLE QUARTZ_TRIGGERS;
DROP TABLE QUARTZ_JOB_DETAILS;