summaryrefslogtreecommitdiff
path: root/sql/functions/general.insert_gallery.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/functions/general.insert_gallery.sql')
-rw-r--r--sql/functions/general.insert_gallery.sql4
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;