inline salmon magic keys

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 1fe58486b9babd5f3b36d2d0da184584c76929c7..2ce83d5ce277751d70e1c57c4eab357d65c83e4f 100644 (file)
--- a/update.php
+++ b/update.php
@@ -22,3 +22,44 @@ function update_1001() {
 function update_1002() {
        q("ALTER TABLE `item` ADD `gravity` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `wall` ");
 }
+
+function update_1003() {
+       q("ALTER TABLE `contact` DROP `issued-pubkey` , DROP `ret-id` , DROP `ret-pubkey` ");
+       q("ALTER TABLE `contact` ADD `usehub` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `ret-aes`");
+       q("ALTER TABLE `contact` ADD `hub-verify` CHAR( 255 ) NOT NULL AFTER `usehub`");
+       q("ALTER TABLE `contact` ADD INDEX ( `uid` ) ,  ADD INDEX ( `self` ),  ADD INDEX ( `issued-id` ),  ADD INDEX ( `dfrn-id` )"); 
+       q("ALTER TABLE `contact` ADD INDEX ( `blocked` ),   ADD INDEX ( `readonly` )");
+}
+
+function update_1004() {
+       q("ALTER TABLE `contact` ADD `subhub` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `usehub`");
+}
+
+function update_1005() {
+
+       q("ALTER TABLE `user` ADD `spubkey` TEXT NOT NULL AFTER `prvkey` ,
+               ADD `sprvkey` TEXT NOT NULL AFTER `spubkey`");
+
+}
+
+function update_1006() {
+
+       // create 's' keys for everybody that does not have one
+
+       $r = q("SELECT * FROM `user` WHERE `spubkey` = '' ");
+       if(count($r)) {
+               foreach($r as $rr) {
+                       $sres=openssl_pkey_new(array('encrypt_key' => false ));
+                       $sprvkey = '';
+                       openssl_pkey_export($sres, $sprvkey);
+                       $spkey = openssl_pkey_get_details($sres);
+                       $spubkey = $spkey["key"];
+                       $r = q("UPDATE `user` SET `spubkey` = '%s', `sprvkey` = '%s'
+                               WHERE `uid` = %d LIMIT 1",
+                               dbesc($spubkey),
+                               dbesc($sprvkey),
+                               intval($rr['uid'])
+                       );
+               }
+       }
+}