Flea Flicker
3609087980
Adds 0033_add_services_default_buffer_minutes.sql with idempotent ALTER TABLE to ensure services.default_buffer_minutes exists. Also fixes _journal.json by adding missing 0031_buffer_rules entry (idx 31) and 0032_staff_read_at entry (idx 32) that were absent from the journal. Co-Authored-By: Paperclip <noreply@paperclip.ing>
7 lines
373 B
SQL
7 lines
373 B
SQL
-- Migration: 0033_add_services_default_buffer_minutes.sql
|
|
-- Adds missing default_buffer_minutes column to services table.
|
|
-- 0031_buffer_rules was applied to the DB but its journal entry was missing,
|
|
-- so this ensures idempotent column addition for fresh DB restores.
|
|
|
|
ALTER TABLE "services" ADD COLUMN IF NOT EXISTS "default_buffer_minutes" integer DEFAULT 0 NOT NULL;
|