diff options
| author | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2017-10-13 12:51:01 -0600 |
|---|---|---|
| committer | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2017-10-13 12:51:01 -0600 |
| commit | 52c3b96a83ec956be8f39b25852ae2f781875e0a (patch) | |
| tree | b2b1be340c1b2fc011c8ef7344c3d9becd7a95a2 /salt/openbook/database/files | |
| parent | e2fa1829c0d92f6fadfb8a84b14f79835f964216 (diff) | |
refinements to update database script
Diffstat (limited to 'salt/openbook/database/files')
| -rw-r--r-- | salt/openbook/database/files/update-openbook-schema.sh | 3 |
1 files changed, 2 insertions, 1 deletions
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 <<EOF >>create_openbook_schemas.sql use openbook; |