clns-acuity-docker/images/postgres/data/clear_data_tables.sql

DELETE FROM group_members;
DELETE FROM group_authorities;
DELETE FROM groups;
DELETE FROM authorities;
DELETE FROM users;
DELETE FROM map_project_rule;
DELETE FROM map_clinical_study;
DELETE FROM map_study_rule;
DELETE FROM map_study_baseline_drug;
DELETE FROM map_study_ae_group;
DELETE FROM map_study_lab_group;
DELETE FROM map_lab_group_rule;
DELETE FROM map_ae_group_rule;
DELETE FROM map_subject_group_rule;
DELETE FROM map_lab_group_value_rule;
DELETE FROM map_ae_group_value_rule;
DELETE FROM map_subject_group_value_rule;
DELETE FROM map_subject_grouping;
DELETE FROM map_subject_group_annotation;
DELETE FROM map_subject_group_dosing;
DELETE FROM map_subject_group_dosing_sched;
DELETE FROM map_custom_labcode_lookup;
DELETE FROM map_file_rule;
DELETE FROM map_mapping_rule;
DELETE FROM map_mapping_rule_field;
DELETE FROM map_column_rule;
DELETE FROM map_description_file;
DELETE FROM map_dynamic_field;
DELETE FROM map_excluding_values;
DELETE FROM saved_filter_dataset;
DELETE FROM saved_filter_instance;
DELETE FROM saved_filter_permission;
DELETE FROM saved_filter;
DELETE FROM acl_entry;
DELETE FROM acl_object;
DELETE FROM acl_object_identity;
DELETE FROM acl_sid;