more d* infrastructure for relaying signed messages and storing non-connected people...

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 2e22b9d1cc85858b74a7e920acad9588574a183e..3586aa5fd2c46a6a42e7ae8783998998c780cdb2 100644 (file)
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1069 );
+define( 'UPDATE_VERSION' , 1080 );
 
 /**
  *
@@ -15,7 +15,7 @@ define( 'UPDATE_VERSION' , 1069 );
  * 
  * At the top of the file "boot.php" is a define for DB_UPDATE_VERSION. Any time there is a change
  * to the database schema or one which requires an upgrade path from the existing application,
- * the DB_UPDATE_VERSION is incremented.
+ * the DB_UPDATE_VERSION and the UPDATE_VERSION at the top of this file are incremented.
  *
  * The current DB_UPDATE_VERSION is stored in the config area of the database. If the application starts up
  * and DB_UPDATE_VERSION is greater than the last stored build number, we will process every update function 
@@ -561,4 +561,113 @@ function update_1068() {
 
 }
 
+function update_1069() {
+       q("ALTER TABLE `fsuggest` ADD `request` CHAR( 255 ) NOT NULL AFTER `url` ");
+       q("ALTER TABLE `fcontact` ADD `request` CHAR( 255 ) NOT NULL AFTER `photo` ");
+}
+
+// mail body needs to accomodate private photos
+
+function update_1070() {
+       q("ALTER TABLE `mail` CHANGE `body` `body` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ");
+}
+
+function update_1071() {
+       q("ALTER TABLE `photo` ADD INDEX ( `uid` ) ");
+       q("ALTER TABLE `photo` ADD INDEX ( `resource-id` ) ");
+       q("ALTER TABLE `photo` ADD INDEX ( `album` ) ");
+       q("ALTER TABLE `photo` ADD INDEX ( `scale` ) ");
+       q("ALTER TABLE `photo` ADD INDEX ( `profile` ) ");
+
+}
+
+function update_1072() {
+       q("ALTER TABLE `item` ADD `starred` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `visible` ");
+       q("ALTER TABLE `item` ADD INDEX ( `starred` ) ");
+}
+
+function update_1073() {
+       q("ALTER TABLE `contact` ADD `remote_self` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `self` ");
+}
+
+function update_1074() {
+       q("ALTER TABLE `user` ADD `hidewall` TINYINT( 1) NOT NULL DEFAULT '0' AFTER `blockwall` ");
+       $r = q("SELECT `uid` FROM `profile` WHERE `is-default` = 1 AND `hidewall` = 1");
+       if(count($r)) {
+               foreach($r as $rr)
+                       q("UPDATE `user` SET `hidewall` = 1 WHERE `uid` = %d LIMIT 1",
+                               intval($rr['uid'])
+                       );
+       }
+       q("ALTER TABLE `profile` DROP `hidewall`");
+}
+
+function update_1075() {
+       q("ALTER TABLE `user` ADD `guid` CHAR( 16 ) NOT NULL AFTER `uid` ");
+       $r = q("SELECT `uid` FROM `user` WHERE 1");
+       if(count($r)) {
+               foreach($r as $rr) {
+                       $found = true;
+                       do {
+                               $guid = substr(random_string(),0,16);
+                               $x = q("SELECT `uid` FROM `user` WHERE `guid` = '%s' LIMIT 1",
+                                       dbesc($guid)
+                               );
+                               if(! count($x))
+                                       $found = false;
+                       } while ($found == true );
+
+                       q("UPDATE `user` SET `guid` = '%s' WHERE `uid` = %d LIMIT 1",
+                               dbesc($guid),
+                               intval($rr['uid'])
+                       );
+               }
+       }
+}
+
+function update_1076() {
+       q("CREATE TABLE `guid` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+               `guid` CHAR( 16 ) NOT NULL , INDEX ( `guid` ) ) ENGINE = MYISAM ");
+
+}
+
+// There was a typo in 1076 so we'll try again in 1077 to make sure
+// We'll also make it big enough to allow for future growth, I seriously 
+// doubt Diaspora will be able to leave guids at 16 bytes,
+// and we can also use the same structure for our own larger guids
+
+function update_1077() {
+       q("CREATE TABLE IF NOT EXISTS `guid` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+               `guid` CHAR( 16 ) NOT NULL , INDEX ( `guid` ) ) ENGINE = MYISAM ");
+
+       q("ALTER TABLE `guid` CHANGE `guid` `guid` CHAR( 64 ) NOT NULL"); 
+}
+
+function update_1078() {
+       q("ALTER TABLE `item` ADD `guid` CHAR( 64 ) NOT NULL AFTER `id` , ADD INDEX ( `guid` ) ");
+}
+
+function update_1079() {
+       q("CREATE TABLE IF NOT EXISTS `sign` (
+       `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+       `iid` INT UNSIGNED NOT NULL ,
+       `signed_text` MEDIUMTEXT NOT NULL ,
+       `signature` TEXT NOT NULL ,
+       `signer` CHAR( 255 ) NOT NULL ,
+       INDEX ( `iid` )
+       ) ENGINE = MYISAM ");
+
+       q("ALTER TABLE `fcontact` ADD `nick` CHAR( 255 ) NOT NULL ,
+       ADD `addr` CHAR( 255 ) NOT NULL ,
+       ADD `notify` CHAR( 255 ) NOT NULL ,
+       ADD `poll` CHAR( 255 ) NOT NULL ,
+       ADD `confirm` CHAR( 255 ) NOT NULL ,
+       ADD `priority` TINYINT( 1 ) NOT NULL ,
+       ADD `network` CHAR( 32 ) NOT NULL ,
+       ADD `alias` CHAR( 255 ) NOT NULL ,
+       ADD `pubkey` TEXT NOT NULL ,
+       ADD INDEX ( `addr` ) , 
+       ADD INDEX ( `network` ) ");
+
+}