mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-08-17 02:23:12 +00:00
viettranx
24717b0f51
Extract wake_heartbeat and stateless from JSON payload into first-class columns on cron_jobs. Adds migration 000033 with backfill from existing payload data. Updates PG + SQLite stores, RPC handlers, and UI i18n.
17 lines
504 B
SQL
17 lines
504 B
SQL
UPDATE cron_jobs SET payload = jsonb_set(
|
|
jsonb_set(
|
|
jsonb_set(
|
|
jsonb_set(payload, '{deliver}', to_jsonb(deliver)),
|
|
'{channel}', to_jsonb(deliver_channel)
|
|
),
|
|
'{to}', to_jsonb(deliver_to)
|
|
),
|
|
'{wake_heartbeat}', to_jsonb(wake_heartbeat)
|
|
);
|
|
|
|
ALTER TABLE cron_jobs DROP COLUMN stateless;
|
|
ALTER TABLE cron_jobs DROP COLUMN deliver;
|
|
ALTER TABLE cron_jobs DROP COLUMN deliver_channel;
|
|
ALTER TABLE cron_jobs DROP COLUMN deliver_to;
|
|
ALTER TABLE cron_jobs DROP COLUMN wake_heartbeat;
|