embed youtobe videos

1 files changed, 4 insertions, 0 deletions

diff --git a/sql/functions/general.insert_gallery.sql b/sql/functions/general.insert_gallery.sql
index 0582c6b..26260fb 100644
--- a/sql/functions/general.insert_gallery.sql
+++ b/sql/functions/general.insert_gallery.sql
@@ -2,6 +2,7 @@ drop function general.insert_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 );
 
@@ -9,6 +10,7 @@ create or replace function general.insert_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 )
 returns bigint
@@ -20,11 +22,13 @@ begin
         description,
         filename,
         mime_type,
+        video_embed_url,
         content
     ) values (
         p_description,
         p_filename,
         p_mime_type,
+        p_video_embed_url,
         decode(p_hex, 'hex')
     ) returning id into l_id;