-- Migration: Add services JSON column to posts table
-- Date: 2025-12-10
-- Description: Adds a JSON column to store services data directly in posts table

ALTER TABLE `posts` ADD COLUMN IF NOT EXISTS `services` LONGTEXT COMMENT 'Services as JSON array' AFTER `grand_total`;
ALTER TABLE `posts` ADD COLUMN IF NOT EXISTS `contract_date` DATE COMMENT 'Contract start date' AFTER `services`;
ALTER TABLE `posts` ADD COLUMN IF NOT EXISTS `contract_end` DATE COMMENT 'Contract end date' AFTER `contract_date`;
