-- Venue Events Manager — Database update v1.000.003
-- Quotation/Invoice form UX: colored date pickers, package vs custom pricing, live totals.
-- No schema changes required. Version bump only.
-- Import via phpMyAdmin → Import.

SET NAMES utf8mb4;

INSERT INTO `settings` (`key`, `value`, `is_encrypted`, `created_at`, `updated_at`)
VALUES ('schema_version', '1.000.003', 0, NOW(), NOW())
ON DUPLICATE KEY UPDATE `value` = '1.000.003', `updated_at` = NOW();

INSERT INTO `settings` (`key`, `value`, `is_encrypted`, `created_at`, `updated_at`)
VALUES ('app_version', '1.000.003', 0, NOW(), NOW())
ON DUPLICATE KEY UPDATE `value` = '1.000.003', `updated_at` = NOW();

INSERT INTO `settings` (`key`, `value`, `is_encrypted`, `created_at`, `updated_at`)
VALUES (
  'release_notes',
  'v1.000.003: Quote/Invoice forms — remove availability calendar; Event Start/End show available (green) and unavailable (red) dates; Available packages vs Custom package; live Price Total.',
  0, NOW(), NOW()
)
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `updated_at` = NOW();

SELECT 'Update v1.000.003 applied successfully' AS result;
