#!/bin/sh

# Data setup

echo "Creating Databases…\n"

mysql < create_databases.sql


echo "Creating Tables\n"

echo "  For Database ‘AWS Logs’…"
echo "    location_data…"
mysql < aws_logs/location_data.sql
echo "    log_data…"
mysql < aws_logs/log_data.sql
echo "    logged_files…"
mysql < aws_logs/logged_files.sql
echo "    summary_log_data…"
mysql < aws_logs/summary_log_data.sql


echo "  For Database ‘Registration’…"
echo "    activation…"
mysql < registration/activation.sql
echo "    blocklist…"
mysql < registration/blocklist.sql
echo "    coupons…"
mysql < registration/coupons.sql
echo "    fs_event…\n"
mysql < registration/fs_event.sql
echo "    license_sub_link…\n"
mysql < registration/license_sub_link.sql
echo "    license…\n"
mysql < registration/license.sql
echo "    order…\n"
mysql < registration/order.sql
echo "    subscription_activation…\n"
mysql < registration/subscription_activation.sql
echo "    subscription_order_link…\n"
mysql < registration/subscription_order_link.sql
echo "    subscription…\n"
mysql < registration/subscription.sql


echo "  For Database ‘Release’…\n"
mysql < release/release_information.sql


echo "  For Database ‘Utilities’…\n"
echo "    detail_usage…\n"
mysql < utilities/detail_usage.sql
echo "    log_messages…\n"
mysql < utilities/log_messages.sql
echo "    message_shown…\n"
mysql < utilities/message_shown.sql
echo "    message…\n"
mysql < utilities/message.sql
echo "    session…\n"
mysql < utilities/session.sql
echo "    usage…\n"
mysql < utilities/usage.sql
echo "    user…\n"
mysql < utilities/user.sql


echo "Creating the Users…\n"
mysql < create_users.sql