Bug 14168: (followup) atomic update for syspref

Signed-off-by: Jesse Weaver <jweaver@bywatersolutions.com>
Fixed small typo (extra ').

Signed-off-by: Brendan A Gallagher <brendan@bywatersolutions.com>

diff --git a/installer/data/mysql/atomicupdate/bug_14168-add_html5mediayoutube_syspref.sql b/installer/data/mysql/atomicupdate/bug_14168-add_html5mediayoutube_syspref.sql
new file mode 100644 (file)
index 0000000..d45328f
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_14168-add_html5mediayoutube_syspref.sql
@@ -0,0 +1,2 @@
+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
+('HTML5MediaYouTube',0,'Embed|Don\'t embed','YouTube links as videos','YesNo');

diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
index 72138f7..69fb230 100644 (file)
--- a/installer/data/mysql/sysprefs.sql
+++ b/installer/data/mysql/sysprefs.sql
@@ -163,7 +163,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
 ('HomeOrHoldingBranch','holdingbranch','holdingbranch|homebranch','Used by Circulation to determine which branch of an item to check with independent branches on, and by search to determine which branch to choose for availability ','Choice'),
 ('HTML5MediaEnabled','not','not|opac|staff|both','Show a tab with a HTML5 media player for files catalogued in field 856','Choice'),
 ('HTML5MediaExtensions','webm|ogg|ogv|oga|vtt','','Media file extensions','free'),
-('HTML5MediaYouTube',0','Embed|Don\'t embed','YouTube links as videos','YesNo'),
+('HTML5MediaYouTube',0,'Embed|Don\'t embed','YouTube links as videos','YesNo'),
 ('IDreamBooksReadometer','0','','Display Readometer from IDreamBooks.com','YesNo'),
 ('IDreamBooksResults','0','','Display IDreamBooks.com rating in search results','YesNo'),
 ('IDreamBooksReviews','0','','Display book review snippets from IDreamBooks.com','YesNo'),