#!/bin/bash
# Run this script once to set up the MySQL database
# Usage: sudo bash setup-db.sh

set -e

echo "Setting up ecommerce database..."

mysql << 'SQL'
CREATE DATABASE IF NOT EXISTS ecommerce_db
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

CREATE USER IF NOT EXISTS 'ecommerce'@'localhost'
    IDENTIFIED BY 'ecommerce_pass';

GRANT ALL PRIVILEGES ON ecommerce_db.*
    TO 'ecommerce'@'localhost';

FLUSH PRIVILEGES;

SELECT 'Database setup complete!' as status;
SQL

echo "Done! Now run: php artisan migrate --seed"