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/05/07 21:57] – [Delete all endusers] 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 22: | Line 22: | ||
===== 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