-- Initial database setup for Low Code Engine
-- This script runs when the MariaDB container starts for the first time

-- Ensure the database exists
CREATE DATABASE IF NOT EXISTS low_code_engine CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Grant privileges to the application user
GRANT ALL PRIVILEGES ON low_code_engine.* TO 'app_user'@'%';
FLUSH PRIVILEGES;

-- You can add initial data here if needed
-- INSERT INTO users (email, firstName, lastName) VALUES ('admin@example.com', 'Admin', 'User');