-- Migration: Create hijriah_masehi table for PostgreSQL
-- Date: 2026-01-05
-- Usage: psql -h <host> -U <user> -d <db> -f 20260105_create_hijriah_masehi_pg.sql

BEGIN;

CREATE TABLE IF NOT EXISTS hijriah_masehi (
  "date" date NOT NULL PRIMARY KEY,
  hijriah_date varchar(32) NOT NULL,
  day_name varchar(32) NOT NULL,
  source varchar(100) NOT NULL DEFAULT 'muhammadiyah',
  created_at timestamp NOT NULL DEFAULT now(),
  updated_at timestamp NOT NULL DEFAULT now()
);

-- Functional indexes for year/month filtering
CREATE INDEX IF NOT EXISTS idx_hijmasehi_year ON hijriah_masehi ((EXTRACT(YEAR FROM "date")));
CREATE INDEX IF NOT EXISTS idx_hijmasehi_month ON hijriah_masehi ((EXTRACT(MONTH FROM "date")));

COMMIT;

-- Down:
-- DROP TABLE IF EXISTS hijriah_masehi;
