ensure nonuser admins are created with predetermined ids
Created by: deepakduggirala
Description
svc_tasks - is a system user / non-user admin account. The user creation scripts: seed.js and init_prod_users.js do not consistently assign the same ids to users they create. svc_tasks is a user that is created on all bioloop instances and for the sake of consistency it should get the same id everywhere. This change ensures that svc_tasks will be created with id of 1 anytime either of the scripts are run.
For instances that are already in production, if svc_tasks does not have id:1, swap with user account that has an id: 1, if the user account of id-1 does not have any associations.
-- assign new id to user account
UPDATE "user"
SET id = nextval('user_id_seq')
WHERE id = 1;
UPDATE "user"
SET id = 1
WHERE username = 'svc_tasks';