#!/bin/sh

cd "$(dirname "$0")/../.."
mysql -uroot -e "DROP DATABASE IF EXISTS agent_tracker; CREATE DATABASE agent_tracker CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql -uroot agent_tracker < sql/schema.sql
rm -f storage/logs/.schema-20261014 storage/logs/mail.log
curl -s -c /tmp/cj -H 'Content-Type: application/json' -d '{"workspace_name":"summit financial group","full_name":"chris owner","email":"chris@example.com","password":"Sup3r-Secret-99"}' 127.0.0.1:8090/api/auth/register > /dev/null
php bin/seed-showcase-agents.php 1 > /dev/null 2>&1
mysql -uroot agent_tracker -e "UPDATE workspaces SET settings=JSON_REMOVE(settings,'$.sample') WHERE id=1; DELETE FROM login_attempts;" 2>/dev/null
mysql -uroot agent_tracker -N -e "select name from workspaces"