diff options
| -rw-r--r-- | boot.php | 2 | ||||
| -rw-r--r-- | update.php | 10 |
2 files changed, 10 insertions, 2 deletions
@@ -9,7 +9,7 @@ require_once("include/pgettext.php"); define ( 'FRIENDIKA_VERSION', '2.2.1084' ); define ( 'DFRN_PROTOCOL_VERSION', '2.21' ); -define ( 'DB_UPDATE_VERSION', 1082 ); +define ( 'DB_UPDATE_VERSION', 1083 ); define ( 'EOL', "<br />\r\n" ); define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' ); diff --git a/update.php b/update.php index d92b1dd91..c23ce95c6 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1082 ); +define( 'UPDATE_VERSION' , 1083 ); /** * @@ -676,8 +676,16 @@ function update_1080() { } function update_1081() { + // there was a typo in update 1081 so it was corrected and moved up to 1082 +} + +function update_1082() { q("ALTER TABLE `photo` ADD `guid` CHAR( 64 ) NOT NULL AFTER `contact-id`, ADD INDEX ( `guid` ) "); + // make certain the following code is only executed once + $r = q("select `id` from `photo` where `guid` != '' limit 1"); + if($r && count($r)) + return; $r = q("SELECT distinct(`resource-id`) FROM `photo` WHERE 1 group by `id`"); if(count($r)) { foreach($r as $rr) { |