From 52c3b96a83ec956be8f39b25852ae2f781875e0a Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Fri, 13 Oct 2017 12:51:01 -0600 Subject: refinements to update database script --- salt/openbook/database/files/update-openbook-schema.sh | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/salt/openbook/database/files/update-openbook-schema.sh b/salt/openbook/database/files/update-openbook-schema.sh index d5c5ed9..93e3959 100644 --- a/salt/openbook/database/files/update-openbook-schema.sh +++ b/salt/openbook/database/files/update-openbook-schema.sh @@ -14,7 +14,8 @@ for db in openbook openbook_jobs openbook_workflow; do done sed --posix -r 's|(^.*PARTITION BY RANGE.*\))|\1;|g' -i create_openbook_schemas.sql -sed -e 's|^.*PARTITION.*VALUES.*ENGINE = InnoDB.*$||g' -i create_openbook_schemas.sql +sed --posix -r 's|^.*PARTITION.*VALUES.*ENGINE = InnoDB.*$||g' -i create_openbook_schemas.sql +sed '/^$/d' -i create_openbook_schemas.sql cat <>create_openbook_schemas.sql use openbook; -- cgit v1.3