X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=0a3a1e7f16669a15f0051896ada7c9568d338ca4;hb=09d8a3b69f638575076f5dd5ddc40e7e7af2c6a3;hp=362935c38445b0e21a33c21541b2aa13625726c5;hpb=c90e6c6e0782e3e8ac9cf1be3acbc13f5448148d;p=friendica.git

diff --git a/update.php b/update.php
index 362935c384..0a3a1e7f16 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1103 );
+define( 'UPDATE_VERSION' , 1107 );
 
 /**
  *
@@ -884,6 +884,38 @@ function update_1102() {
 }
 
 
+function update_1103() {
+//	q("ALTER TABLE `item` ADD INDEX ( `wall` ) ");
+	q("ALTER TABLE `item` ADD FULLTEXT ( `tag` ) "); 
+	q("ALTER TABLE `contact` ADD INDEX ( `pending` ) ");
+	q("ALTER TABLE `user` ADD INDEX ( `hidewall` ) ");
+	q("ALTER TABLE `user` ADD INDEX ( `blockwall` ) ");
+	q("ALTER TABLE `user` ADD INDEX ( `blocked` ) ");
+	q("ALTER TABLE `user` ADD INDEX ( `verified` ) ");
 
+}
+
+function update_1104() {
+	q("ALTER TABLE `item` ADD `forum_mode` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `origin` , ADD INDEX ( `forum_mode` ) ");
+
+}
+
+function update_1105() {
+	q("ALTER TABLE `mail` ADD `convid` INT NOT NULL AFTER `contact-id` ");
+	q("ALTER TABLE `mail` ADD `guid` CHAR( 64 ) NOT NULL AFTER `uid` ");
+
+	q("CREATE TABLE IF NOT EXISTS `conv` (
+	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+	`guid` CHAR( 64 ) NOT NULL ,
+	`recips` MEDIUMTEXT NOT NULL ,
+	`uid` INT NOT NULL
+	) ENGINE = MYISAM ");
+}
+
+
+function update_1106() {
+	q("ALTER TABLE `item` ADD INDEX ( `author-link` ) ");
+
+}