Files

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

3 lines
282 B
SQL
Raw Permalink Normal View History

2019-01-01 07:03:28 -06:00
DELETE FROM dashboards WHERE user_id NOT IN (SELECT user_id FROM users) AND dashboard_id NOT IN (SELECT DISTINCT dashboard_id FROM users_widgets);
UPDATE dashboards SET user_id = (SELECT user_id FROM users WHERE level = 10 LIMIT 1) WHERE user_id NOT IN (SELECT user_id FROM users);