2016-12-07 22:51:57 +01:00
|
|
|
-- Clear tables that should be empty
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `attachment_scans`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `attributes`;
|
2018-02-01 20:21:06 +01:00
|
|
|
TRUNCATE `attribute_tags`;
|
|
|
|
TRUNCATE `cake_sessions`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `cerebrates`;
|
|
|
|
TRUNCATE `correlation_exclusions`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `correlations`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `dashboards`;
|
|
|
|
TRUNCATE `decaying_model_mappings`;
|
|
|
|
TRUNCATE `decaying_models`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `events`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `event_blocklists`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `event_delegations`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `event_graph`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `event_locks`;
|
|
|
|
TRUNCATE `event_reports`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `event_tags`;
|
|
|
|
TRUNCATE `favourite_tags`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `inbox`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `jobs`;
|
|
|
|
TRUNCATE `logs`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `notification_logs`;
|
2018-02-01 20:21:06 +01:00
|
|
|
TRUNCATE `objects`;
|
|
|
|
TRUNCATE `object_references`;
|
|
|
|
TRUNCATE `object_relationships`;
|
|
|
|
TRUNCATE `object_templates`;
|
|
|
|
TRUNCATE `object_template_elements`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `org_blocklists`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `posts`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `rest_client_histories`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `servers`;
|
|
|
|
TRUNCATE `shadow_attributes`;
|
|
|
|
TRUNCATE `shadow_attribute_correlations`;
|
|
|
|
TRUNCATE `sharing_groups`;
|
|
|
|
TRUNCATE `sharing_group_orgs`;
|
|
|
|
TRUNCATE `sharing_group_servers`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `sightingdb_orgs`;
|
|
|
|
TRUNCATE `sightingdbs`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `sightings`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `tag_collections`;
|
|
|
|
TRUNCATE `tag_collection_tags`;
|
2018-02-01 20:21:06 +01:00
|
|
|
TRUNCATE `tags`;
|
2016-12-07 22:51:57 +01:00
|
|
|
TRUNCATE `threads`;
|
2016-12-27 16:44:10 +01:00
|
|
|
TRUNCATE `bruteforces`;
|
|
|
|
TRUNCATE `news`;
|
|
|
|
TRUNCATE `template_tags`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `allowedlist`;
|
2019-04-04 11:40:40 +02:00
|
|
|
TRUNCATE `event_locks`;
|
|
|
|
TRUNCATE `fuzzy_correlate_ssdeep`;
|
|
|
|
TRUNCATE `tasks`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `user_settings`;
|
2016-12-07 22:51:57 +01:00
|
|
|
|
2017-02-24 12:12:03 +01:00
|
|
|
-- Clear tables that can be re-populated
|
|
|
|
TRUNCATE `taxonomies`;
|
|
|
|
TRUNCATE `taxonomy_entries`;
|
|
|
|
TRUNCATE `taxonomy_predicates`;
|
|
|
|
TRUNCATE `warninglists`;
|
|
|
|
TRUNCATE `warninglist_entries`;
|
|
|
|
TRUNCATE `warninglist_types`;
|
|
|
|
TRUNCATE `galaxies`;
|
2021-02-18 10:32:40 +01:00
|
|
|
TRUNCATE `galaxy_cluster_blocklists`;
|
|
|
|
TRUNCATE `galaxy_cluster_relation_tags`;
|
|
|
|
TRUNCATE `galaxy_cluster_relations`;
|
2017-02-24 12:12:03 +01:00
|
|
|
TRUNCATE `galaxy_clusters`;
|
|
|
|
TRUNCATE `galaxy_elements`;
|
2019-04-04 11:40:40 +02:00
|
|
|
TRUNCATE `noticelists`;
|
|
|
|
TRUNCATE `noticelist_entries`;
|
2020-04-23 18:30:13 +02:00
|
|
|
TRUNCATE `decaying_models`;
|
|
|
|
TRUNCATE `decaying_model_mappings`;
|
2017-02-24 12:12:03 +01:00
|
|
|
|
2016-12-07 22:51:57 +01:00
|
|
|
-- Clear tables that have defaults
|
|
|
|
TRUNCATE `feeds`;
|
|
|
|
TRUNCATE `regexp`;
|
|
|
|
TRUNCATE `roles`;
|
|
|
|
TRUNCATE `threat_levels`;
|
|
|
|
TRUNCATE `templates`;
|
|
|
|
TRUNCATE `template_elements`;
|
|
|
|
TRUNCATE `template_element_attributes`;
|
|
|
|
TRUNCATE `template_element_files`;
|
|
|
|
TRUNCATE `template_element_texts`;
|
|
|
|
|
|
|
|
-- Remove entries from tables and reset index
|
2019-05-17 17:54:12 +02:00
|
|
|
DELETE FROM `users` WHERE id > 1;
|
|
|
|
ALTER TABLE `users` AUTO_INCREMENT = 2;
|
2021-09-02 14:30:54 +02:00
|
|
|
DELETE FROM `auth_keys` WHERE id > 1;
|
|
|
|
ALTER TABLE `auth_keys` AUTO_INCREMENT = 2;
|
2019-05-17 17:54:12 +02:00
|
|
|
DELETE FROM `organisations` WHERE id > 1;
|
|
|
|
ALTER TABLE `organisations` AUTO_INCREMENT = 2;
|