diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /storage/mroonga/data | |
parent | Initial commit. (diff) | |
download | mariadb-upstream.tar.xz mariadb-upstream.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r-- | storage/mroonga/data/Makefile.am | 4 | ||||
-rw-r--r-- | storage/mroonga/data/install.sql.in | 35 | ||||
-rw-r--r-- | storage/mroonga/data/uninstall.sql | 12 |
3 files changed, 51 insertions, 0 deletions
diff --git a/storage/mroonga/data/Makefile.am b/storage/mroonga/data/Makefile.am new file mode 100644 index 00000000..c088c78c --- /dev/null +++ b/storage/mroonga/data/Makefile.am @@ -0,0 +1,4 @@ +sqldir = $(pkgdatadir) +dist_sql_DATA = \ + install.sql \ + uninstall.sql diff --git a/storage/mroonga/data/install.sql.in b/storage/mroonga/data/install.sql.in new file mode 100644 index 00000000..0a2f308a --- /dev/null +++ b/storage/mroonga/data/install.sql.in @@ -0,0 +1,35 @@ +SET @inst=IF(EXISTS(SELECT * FROM mysql.plugin WHERE NAME='mroonga'),'DO 1', "INSTALL PLUGIN mroonga SONAME 'ha_mroonga'"); +PREPARE s FROM @inst; +EXECUTE s; + +DROP FUNCTION IF EXISTS last_insert_grn_id; +CREATE FUNCTION last_insert_grn_id RETURNS INTEGER + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_snippet; +CREATE FUNCTION mroonga_snippet RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_command; +CREATE FUNCTION mroonga_command RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_escape; +CREATE FUNCTION mroonga_escape RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_snippet_html; +CREATE FUNCTION mroonga_snippet_html RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_normalize; +CREATE FUNCTION mroonga_normalize RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_highlight_html; +CREATE FUNCTION mroonga_highlight_html RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; + +DROP FUNCTION IF EXISTS mroonga_query_expand; +CREATE FUNCTION mroonga_query_expand RETURNS STRING + SONAME 'ha_mroonga@MRN_PLUGIN_SUFFIX@'; diff --git a/storage/mroonga/data/uninstall.sql b/storage/mroonga/data/uninstall.sql new file mode 100644 index 00000000..5713e074 --- /dev/null +++ b/storage/mroonga/data/uninstall.sql @@ -0,0 +1,12 @@ +DROP FUNCTION IF EXISTS last_insert_grn_id; +DROP FUNCTION IF EXISTS mroonga_snippet; +DROP FUNCTION IF EXISTS mroonga_command; +DROP FUNCTION IF EXISTS mroonga_escape; +DROP FUNCTION IF EXISTS mroonga_snippet_html; +DROP FUNCTION IF EXISTS mroonga_normalize; +DROP FUNCTION IF EXISTS mroonga_highlight_html; +DROP FUNCTION IF EXISTS mroonga_query_expand; + +UNINSTALL PLUGIN Mroonga; + +FLUSH TABLES; |