-- Migration: Create kalender_jawa table for PostgreSQL
-- Date: 2026-01-18

BEGIN;

CREATE TABLE IF NOT EXISTS kalender_jawa (
  "date" date NOT NULL PRIMARY KEY,
  jawa_date varchar(64) NOT NULL,
  hari varchar(32) NOT NULL,
  pasaran varchar(32) NOT NULL,
  wuku varchar(32),
  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_jawa_year ON kalender_jawa ((EXTRACT(YEAR FROM "date")));
CREATE INDEX IF NOT EXISTS idx_jawa_month ON kalender_jawa ((EXTRACT(MONTH FROM "date")));

COMMIT;
