artcraft/_sql/seed/bootstrap_inserts_roles_etc.sh

25 lines
429 B
Bash
Executable File

#!/bin/bash
# ONLY FOR LOCAL DEV
USERNAME='storyteller'
PASSWORD='password'
HOST='localhost'
# --default-character-set=UTF8mb4 \
echo 'Inserting System User Roles...'
mysql -u "${USERNAME}" \
-p${PASSWORD} \
-h $HOST \
-D storyteller \
-e "source ./seed/sql/system_roles.sql"
echo 'Inserting Badges...'
mysql -u $USERNAME \
-p${PASSWORD} \
-h $HOST \
-D storyteller \
-e "source ./seed/sql/user_badges.sql"