delete_data_in_the_database_directly_via_ssh
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next 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 [2018/05/07 21:58] – lucy | ||
|---|---|---|---|
| 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