(Obsolete) Set category tracking level defaults historically

[tophee (Christoph)]

@sam

• Step 3, run a query to backfill changes

Say I want to set categories watching first post to on a certain category, I look up per step one and find it is 5.

INSERT INTO category_users(category_id, user_id, notification_level) 
SELECT  5, u.id, 4
FROM users u 
LEFT JOIN category_users cu ON cu.category_id = 5 AND cu.user_id = u.id 
WHERE cu.user_id IS NULL;

The above query sets it on all users that do not have an explicit default for the category already set, this means you can re-run it if needed.

Assuming that this still works, I’m wondering whether category permissions will be honoured here.

I have a number of restricted categories and whoever has access to any of those should be watching first post by default. So if I follow the above steps for each of those categories, will only only users who actually hsve access be watching them?