Skip to content

Instantly share code, notes, and snippets.

@stefanbenten
Last active July 16, 2019 14:30
Show Gist options
  • Save stefanbenten/a6c2db0c8d4d2aed386b288d819fa7ac to your computer and use it in GitHub Desktop.
Save stefanbenten/a6c2db0c8d4d2aed386b288d819fa7ac to your computer and use it in GitHub Desktop.
Satellite-Wipe Script Pre Beta

DROP PointerDB from MasterDB

DROP FUNCTION list_directory_reverse(BYTEA, BYTEA, BYTEA, INTEGER);
DROP FUNCTION list_directory(BYTEA, BYTEA, BYTEA, INTEGER);
DROP TYPE path_and_meta;
DROP FUNCTION component_increment(BYTEA, INTEGER);
DROP FUNCTION bytea_increment(BYTEA);
DROP FUNCTION truncate_after(BYTEA, INTEGER, INTEGER);
DROP VIEW pathdata_pretty;
DROP TABLE pathdata;
DROP TABLE buckets;

MasterDB Cleaning

DELETE FROM api_keys;
DELETE FROM users;
DELETE FROM projects;
DELETE FROM project_members;
DELETE FROM project_payments;
DELETE FROM injuredsegments;
DELETE FROM irreparabledbs;
DELETE FROM pending_audits;
DELETE FROM bucket_bandwidth_rollups;
DELETE FROM bucket_metainfos;
DELETE FROM bucket_storage_tallies;
DELETE FROM bucket_usages;
DELETE FROM registration_tokens;

Deleting Serials, if not a problem to cheating

DELETE FROM used_serials;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment