<?php

/**
 * Migration 0056 — per-service work photos
 *
 * A trade's portfolio is not one pile of pictures, it is "here are the TV mounts,
 * here are the outdoor builds". Philly Assembly proved the section works; what it
 * cannot do today is say which service each photo belongs to, so the strip is one
 * undifferentiated wall (Sergei 2026-07-28).
 *
 * Photos hang off the SERVICE rather than the page, because that is what they are
 * about: rename the service and its pictures follow, delete it and they go with it.
 * A JSON array of storage URLs, capped in the renderer and at upload rather than in
 * the schema, since the ceiling is a product decision and will move.
 *
 * NULL rather than '' for "no photos", so a service that has never been touched is
 * distinguishable from one an owner deliberately emptied.
 *
 * @since 2.1.2676
 */

if (!defined('ABSPATH')) exit;

return [
    'description' => 'instinctor_services.photos (JSON array of work photos per service)',

    'up' => [
        "ALTER TABLE {prefix}instinctor_services
            ADD COLUMN photos text NULL DEFAULT NULL AFTER description",
    ],
];
