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 revisionNext revisionBoth sides next revision | ||
delete_data_in_the_database_directly_via_ssh [2018/03/28 19:51] – lucy | delete_data_in_the_database_directly_via_ssh [2019/07/25 12:50] – external edit 127.0.0.1 | ||
---|---|---|---|
Line 6: | Line 6: | ||
===== Delete all scenario templates ===== | ===== Delete all scenario templates ===== | ||
- | sudo -u postgres psql phishing -c "DELETE FROM scenario_templates WHERE NOT is_deleted" | + | sudo -u postgres psql phishing -c 'DELETE FROM scenario_templates WHERE NOT is_deleted' |
===== Delete all Awareness template ===== | ===== Delete all Awareness template ===== | ||
- | sudo -u postgres psql phishing -c "DELETE FROM awareness_templates WHERE NOT is_deleted" | + | sudo -u postgres psql phishing -c 'DELETE FROM awareness_templates WHERE NOT is_deleted' |
===== Delete all file templates ===== | ===== Delete all file templates ===== | ||
Line 16: | Line 16: | ||
===== 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 users SET is_deleted=TRUE where role_id=3" | + | sudo -u postgres psql phishing -c 'UPDATE users SET is_deleted=TRUE where role_id=3' |
delete_data_in_the_database_directly_via_ssh.txt · Last modified: 2021/05/19 08:10 by lucy