-- Migration: Create kalender_jawa table for MySQL
-- Date: 2026-01-18

START TRANSACTION;

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),
  `year` SMALLINT GENERATED ALWAYS AS (YEAR(`date`)) STORED,
  `month` TINYINT GENERATED ALWAYS AS (MONTH(`date`)) STORED,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `idx_jawa_year_month` (`year`, `month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

COMMIT;
