Changeset 3755014 for paintops/trunk/includes/schema.php

Timestamp:

10/19/2026 02:48:37 PM (3 weeks ago)

Author:

paintops

Message:

1.2.081

File:

• paintops/trunk/includes/schema.php (modified) (2 diffs)

paintops/trunk/includes/schema.php

@@ -476 +476 @@
 
     // Job photos and expense receipts, both are just images attached to
-    // a job, stored as real WordPress media attachments (so they show up
-    // in the Media Library, survive backups, and work with any offload-
-    // to-S3 plugin) with this table only tracking which job/expense each
+    // a job. Since 1.2.058 (receipts) and 1.2.081 (photos) the file is in
+    // the plugin's private folder under the generated name in
+    // private_file, served through a permission-checked route; rows from
+    // before are media-library attachments (attachment_id) until the
+    // Checkup card moves them. This table tracks which job/expense each
     // one belongs to and which of the two buckets it's in. "context"
     // separates general job photos (before/after, progress shots, an
@@ -1575 +1577 @@
         'photo_role'      => $wpdb->prepare("ALTER TABLE %i ADD COLUMN photo_role VARCHAR(10) NULL", $photos),
         'paired_photo_id' => $wpdb->prepare("ALTER TABLE %i ADD COLUMN paired_photo_id BIGINT UNSIGNED NULL", $photos),
-        // PRIVATE RECEIPT STORAGE (2026-09-24). A receipt row carries
-        // either this file name or the old attachment_id, never both
-        // once it has been moved. See includes/receipt-storage.php and
-        // the batched migration on the Checkup screen. Job PHOTOS are
-        // untouched and keep using attachment_id.
+        // PRIVATE STORAGE (receipts 2026-09-24, job photos 1.2.081). A
+        // row carries either this file name or the old attachment_id,
+        // never both once it has been moved. See includes/receipt-storage.php,
+        // includes/photo-storage.php and the batched migration on the
+        // Checkup screen.
         'private_file'    => $wpdb->prepare("ALTER TABLE %i ADD COLUMN private_file VARCHAR(190) NULL", $photos),
     ];