19 lines
534 B
Markdown
19 lines
534 B
Markdown
Update Steps
|
|
|
|
Using Admin page - set local hasura secret first, and uncomment pages in sider.
|
|
|
|
1. Disable triggers.
|
|
```sql
|
|
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.
|
|
```sql
|
|
alter table jobs enable trigger set_public_jobs_updated_at;
|
|
``` |