diff options
Diffstat (limited to 'salt')
| -rw-r--r-- | salt/openbook/database/files/update-openbook-schema.sh | 11 |
1 files changed, 0 insertions, 11 deletions
diff --git a/salt/openbook/database/files/update-openbook-schema.sh b/salt/openbook/database/files/update-openbook-schema.sh index 313d324..3f1a921 100644 --- a/salt/openbook/database/files/update-openbook-schema.sh +++ b/salt/openbook/database/files/update-openbook-schema.sh @@ -17,17 +17,6 @@ sed --posix -r 's|(^.*PARTITION BY RANGE.*\))|\1;|g' -i create_openbook_schemas. 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; -CALL p_preallocate_partitions('t_metric_values', 'metric_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_resource_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_tenant_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_customer_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_resource_daily', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_tenant_daily', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_customer_daily', 'aggregate_datetime', CURDATE(), 31); -EOF - git add -A git commit -a -m "update create_databases_schema.sql $(date)" git push |