delete_data_in_the_database_directly_via_ssh
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
delete_data_in_the_database_directly_via_ssh [2018/05/07 21:58] – lucy | delete_data_in_the_database_directly_via_ssh [2021/05/19 08:09] – lucy | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Delete all " | ||
- | sudo -u postgres psql phishing | ||
- | delete from exports where campaign_id in (select id from campaigns where is_deleted=true); | ||
- | delete from campaigns where is_deleted=true; | ||
- | |||
- | |||
===== Delete all scenario templates ===== | ===== Delete all scenario templates ===== | ||
- | sudo -u postgres psql phishing -c ' | + | sudo -u postgres psql phishing -c ' |
===== Delete all Awareness template ===== | ===== Delete all Awareness template ===== | ||
- | sudo -u postgres psql phishing -c ' | + | sudo -u postgres psql phishing -c ' |
- | ===== Delete all file templates ===== | + | ===== Delete all templates |
sudo rm -rf / | sudo rm -rf / | ||
sudo rm -rf / | sudo rm -rf / | ||
===== Delete all endusers ===== | ===== Delete all endusers ===== | ||
- | sudo -u postgres psql phishing | + | sudo -u postgres psql phishing |
- | UPDATE | + | |
- | \q | + | |
===== Delete all LUCY users (not admin) ===== | ===== Delete all LUCY users (not admin) ===== | ||
- | sudo -u postgres psql phishing -c 'UPDATE | + | sudo -u postgres psql phishing -c 'DELETE FROM users WHERE role_id=3' |
delete_data_in_the_database_directly_via_ssh.txt · Last modified: 2021/05/19 08:10 by lucy