-- Run this once in MySQL to create the database.
-- Tables themselves are created automatically by the Flask app on first run
-- (db.create_all() in app/__init__.py), so you only need this file to
-- create the empty database and, optionally, the app's MySQL user.

CREATE DATABASE IF NOT EXISTS pashupati_legal
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

-- Optional: dedicated MySQL user for the app (recommended over using root)
-- CREATE USER IF NOT EXISTS 'pashupati_user'@'localhost' IDENTIFIED BY 'strong-password-here';
-- GRANT ALL PRIVILEGES ON pashupati_legal.* TO 'pashupati_user'@'localhost';
-- FLUSH PRIVILEGES;