-- ============================================================
-- TARA Finserv — MySQL Schema (for cPanel phpMyAdmin import)
-- ============================================================
--
-- WHEN TO USE THIS FILE:
--   • In cPanel → phpMyAdmin → select your TARA Finserv database
--     → "Import" tab → upload this file → click "Go".
--
-- WHAT IT DOES:
--   Creates the 12 empty tables the backend uses.
--   The backend ALSO auto-creates tables on first boot, so importing
--   this file is OPTIONAL but recommended (faster first boot, lets
--   you eyeball the schema in phpMyAdmin before starting the app).
--
-- WHAT IT DOES NOT DO:
--   • No seed data — the Node.js backend seeds default content
--     (admin user, menu, partners, pages, site_content) on first boot.
--   • No DROP TABLE — safe to run multiple times.
--
-- ============================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE IF NOT EXISTS `users` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `agents` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `leads` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `menu_items` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pages` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `partners` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `site_content` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `settings` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `counters` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `payouts` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `assets` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `contact_messages` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `otp_codes` (
  `doc_id` VARCHAR(128) NOT NULL,
  `doc`    JSON NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;