X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=update.php;h=6a0ed1af205af8312297bc9f0c2ed06495f143e7;hb=9f152e1b4369f2cbbe1cf9b4d05eb02047e6503c;hp=56f285f2df9037f8f2dc405258f7bd51f495554b;hpb=71ec84f6dc83f753fe80170cfdfd32d202850d90;p=friendica.git diff --git a/update.php b/update.php index 56f285f2df..6a0ed1af20 100644 --- a/update.php +++ b/update.php @@ -20,7 +20,7 @@ require_once 'include/dba.php'; * This function is responsible for doing post update changes to the data * (not the structure) in the database. * - * Database structure changes are done in src/Database/DBStructure.php + * Database structure changes are done in config/dbstructure.php * * If there is a need for a post process to a structure change, update this file * by adding a new function at the end with the number of the new DB_UPDATE_VERSION. @@ -31,8 +31,8 @@ require_once 'include/dba.php'; * You are currently on version 4711 and you are preparing changes that demand an update script. * * 1. Create a function "update_4712()" here in the update.php - * 2. Apply the needed structural changes in src/Database/DBStructure.php - * 3. Set DB_UPDATE_VERSION in boot.php to 4712. + * 2. Apply the needed structural changes in config/dbStructure.php + * 3. Set DB_UPDATE_VERSION in config/dbstructure.php to 4712. * * If you need to run a script before the database update, name the function "pre_update_4712()" */ @@ -246,3 +246,12 @@ function update_1278() { return UPDATE_SUCCESS; } + +function update_1288() { + // Updates missing `uri-id` values + + DBA::e("UPDATE `item-activity` INNER JOIN `item` ON `item`.`iaid` = `item-activity`.`id` SET `item-activity`.`uri-id` = `item`.`uri-id` WHERE `item-activity`.`uri-id` IS NULL OR `item-activity`.`uri-id` = 0"); + DBA::e("UPDATE `item-content` INNER JOIN `item` ON `item`.`icid` = `item-content`.`id` SET `item-content`.`uri-id` = `item`.`uri-id` WHERE `item-content`.`uri-id` IS NULL OR `item-content`.`uri-id` = 0"); + + return UPDATE_SUCCESS; +}