imexrps/_reference/2024-10-17 Update/2024-10-17 Update Steps.md

Update Steps

Using Admin page - set local hasura secret first, and uncomment pages in sider.

1. Disable triggers.

alter table jobs disable trigger set_public_jobs_updated_at;

2. Set the hasura admin key in the admin page. Change the client to be the newly created global client, NOT the shop client.

3. Run the script from 2024-01-01 - MAKE SURE TO CHECK - , 15 days at a time, and run the query to update the database.

X. Re-enable triggers.

alter table jobs enable trigger set_public_jobs_updated_at;