diff options
Diffstat (limited to 'admin/upgrades/5.0.1.php')
| -rw-r--r-- | admin/upgrades/5.0.1.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/admin/upgrades/5.0.1.php b/admin/upgrades/5.0.1.php index 538e498..b40ddc9 100644 --- a/admin/upgrades/5.0.1.php +++ b/admin/upgrades/5.0.1.php @@ -15,15 +15,15 @@ $gBitInstaller->registerPackageUpgrade( [ '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`) + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` + (`x_group`, `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`) + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` + (`item`, `content_type_guid`, `x_group`, `cross_ref_title`, `multiple`, `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 @@ -31,7 +31,7 @@ $gBitInstaller->registerPackageUpgrade( // 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`) + (`xref_id`, `content_id`, `item`, `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`", |