Merge pull request #12 from zzottel/master

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 362935c38445b0e21a33c21541b2aa13625726c5..0a3a1e7f16669a15f0051896ada7c9568d338ca4 100644 (file)
--- 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` ) ");
+
+}