event_streams_add_channel_id (#7)

NixFey · web-flow · commit 7836636463ae · 2025-12-12T22:10:56.000-05:00
* event_streams_add_channel_id

* Delete db-2025-11-09.bak.sql
diff --git a/supabase/migrations/20251212175908_event_streams_add_channel_id.sql b/supabase/migrations/20251212175908_event_streams_add_channel_id.sql
@@ -0,0 +1,3 @@
+alter table "public"."event_streams" add column if not exists "channel_id" character varying(255) null;
+
+update "public"."event_streams" es set "channel_id" = (select tr.streaming_config ->> 'Channel_Id' from events e join truck_routes tr on e.truck_route_id = tr.id where e.id = es.event_id) where es."channel_id" is null;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+alter table "public"."event_streams" add column if not exists "channel_id" character varying(255) null;`
	`2`	`+`
	`3`	`+update "public"."event_streams" es set "channel_id" = (select tr.streaming_config ->> 'Channel_Id' from events e join truck_routes tr on e.truck_route_id = tr.id where e.id = es.event_id) where es."channel_id" is null;`