From ebd383b0e0a6168f99857126897b07395e24b41c Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Mon, 27 May 2024 16:57:01 -0600 Subject: embed youtobe videos --- sql/functions/general.update_gallery.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sql/functions/general.update_gallery.sql') diff --git a/sql/functions/general.update_gallery.sql b/sql/functions/general.update_gallery.sql index e8532db..95296c3 100644 --- a/sql/functions/general.update_gallery.sql +++ b/sql/functions/general.update_gallery.sql @@ -3,6 +3,7 @@ drop function general.update_gallery ( p_description text, p_filename character varying, p_mime_type character varying, + p_video_embed_url character varying, p_hex text ); @@ -11,6 +12,7 @@ create or replace function general.update_gallery ( p_description text, p_filename character varying, p_mime_type character varying, + p_video_embed_url character varying, p_hex text ) returns bigint @@ -27,6 +29,7 @@ begin set description = p_description, filename = p_filename, mime_type = p_mime_type, + video_embed_url = p_video_embed_url, content = decode(p_hex, 'hex'), modified = now() where id = p_id; -- cgit v1.3