2019-05-17 07:30:27 -04:00
|
|
|
#!/bin/bash
|
|
|
|
|
|
|
|
|
|
set -e
|
|
|
|
|
set -o pipefail
|
|
|
|
|
|
|
|
|
|
cd "$(dirname "$0")"
|
|
|
|
|
|
|
|
|
|
BASEDIR=".."
|
|
|
|
|
|
|
|
|
|
test "$1" = '-f' || (
|
|
|
|
|
echo "Run '$0' -f to DROP ALL ICINGADB TABLES and re-create them using the current schema"
|
|
|
|
|
false
|
|
|
|
|
)
|
|
|
|
|
|
|
|
|
|
set -x
|
|
|
|
|
|
|
|
|
|
(
|
|
|
|
|
mysql -uroot -e 'SHOW TABLES\G' icingadb </dev/null |\
|
|
|
|
|
( grep -Ee '^Tables_in_icingadb: ' || true ) |\
|
|
|
|
|
cut -d ' ' -f 2 |\
|
|
|
|
|
perl -pe 's/^(.*?)$/DROP TABLE $1;/'
|
|
|
|
|
|
|
|
|
|
mysql -uroot -e 'SHOW PROCEDURE STATUS\G' icingadb </dev/null |\
|
|
|
|
|
( grep -Ee '^ *Name: ' || true ) |\
|
|
|
|
|
cut -d ':' -f 2 |\
|
|
|
|
|
perl -pe 's/^ *(.*?)$/DROP PROCEDURE IF EXISTS $1;/'
|
|
|
|
|
|
|
|
|
|
cat $BASEDIR/etc/schema/mysql/{,helper/}*.sql
|
|
|
|
|
|
2019-11-05 06:00:10 -05:00
|
|
|
echo "GRANT ALL ON icingadb.* TO 'icingadb'@'127.0.0.1' IDENTIFIED BY 'icingadb';"
|
2019-05-17 07:30:27 -04:00
|
|
|
) |mysql -uroot icingadb
|
