Obsolete Service/bugs: Difference between revisions
Sascha silbe (talk | contribs) create service page for bugs.sl.o |
Sascha silbe (talk | contribs) →Cleaning user database: include sqlite3 invocation |
||
| Line 35: | Line 35: | ||
To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers): | To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers): | ||
sqlite3 /srv/www-sugarlabs/bugs/db/trac.db | |||
DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid); | DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid); | ||