-- =============================================================================
-- DWAPA POS — Platform Control-Plane Database Seed
-- Run in MySQL Workbench against the platform database (dwapaDB).
-- =============================================================================

CREATE DATABASE IF NOT EXISTS `dwapaDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `dwapaDB`;

-- Insert default Super Admin (Password: Admin1234!)
INSERT INTO `platform_users` (
  `id`,
  `name`,
  `email`,
  `password_hash`,
  `role`,
  `is_active`,
  `created_at`,
  `updated_at`
) VALUES (
  UUID(),
  'Super Admin',
  'admin@sleekteq.com',
  '$2a$10$UrqQPgrieXF5oq3Rc12l3..MEpThbKXJZnsMoidy1UfqigH6lXEM6',
  'super_admin',
  1,
  NOW(),
  NOW()
)
ON DUPLICATE KEY UPDATE
  `password_hash` = '$2a$10$UrqQPgrieXF5oq3Rc12l3..MEpThbKXJZnsMoidy1UfqigH6lXEM6',
  `is_active` = 1,
  `role` = 'super_admin',
  `updated_at` = NOW();