From 0de84de2e9d7a03077c8e8e1065abf13432c23c9 Mon Sep 17 00:00:00 2001 From: Lester Caine Date: Fri, 22 May 2026 14:21:13 +0100 Subject: Migrate contact xref to liberty_xref tables; add package-owned gallery view ContactXref and ContactXrefType become thin subclasses of their liberty counterparts, scoped to content_type_guid='contact'. load_emails.php updated to query liberty_xref. Gallery view template moved into contact package as fisheye_fixed_grid_contact.tpl (keeps fisheye clean; same pattern for future assembly/component packages). contact/admin/upgrades/5.0.1.php migrates existing contact_xref_* data into liberty_xref_* tables. Co-Authored-By: Claude Sonnet 4.6 --- admin/upgrades/5.0.1.php | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 admin/upgrades/5.0.1.php (limited to 'admin/upgrades/5.0.1.php') diff --git a/admin/upgrades/5.0.1.php b/admin/upgrades/5.0.1.php new file mode 100644 index 0000000..538e498 --- /dev/null +++ b/admin/upgrades/5.0.1.php @@ -0,0 +1,41 @@ +registerPackageUpgrade( + [ + 'package' => 'contact', + 'version' => '5.0.1', + 'description' => 'Migrate contact_xref_type, contact_xref_source and contact_xref data into liberty_xref tables with content_type_guid=\'contact\'.', + ], + [ + [ 'QUERY' => [ + 'SQL92' => [ + // contact_xref_type: integer xref_type becomes sort_order; text source becomes the xref_type key + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_type` + (`xref_type`, `content_type_guid`, `title`, `sort_order`, `role_id`, `type_href`) + SELECT + `source`, 'contact', `title`, `xref_type`, `role_id`, `type_href` + FROM `" . BIT_DB_PREFIX . "contact_xref_type`", + + // contact_xref_source: integer xref_type joined to get the text key + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_source` + (`source`, `content_type_guid`, `xref_type`, `cross_ref_title`, `multi`, `role_id`, `cross_ref_href`, `template`, `data`) + SELECT + cs.`source`, 'contact', ct.`source`, cs.`cross_ref_title`, cs.`multi`, cs.`role_id`, cs.`cross_ref_href`, cs.`template`, cs.`data` + FROM `" . BIT_DB_PREFIX . "contact_xref_source` cs + JOIN `" . BIT_DB_PREFIX . "contact_xref_type` ct ON cs.`xref_type` = ct.`xref_type`", + + // contact_xref: direct column mapping, xref_id preserved + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref` + (`xref_id`, `content_id`, `source`, `xorder`, `xref`, `xkey`, `xkey_ext`, `data`, `start_date`, `last_update_date`, `entry_date`, `end_date`) + SELECT + `xref_id`, `content_id`, `source`, `xorder`, `xref`, `xkey`, `xkey_ext`, `data`, `start_date`, `last_update_date`, `entry_date`, `end_date` + FROM `" . BIT_DB_PREFIX . "contact_xref`", + ], + ]], + ] +); -- cgit v1.3