Removed the export of markdown articles. That was for testing purposes only.

[friendica.git] / update.php

diff --git a/update.php b/update.php
old mode 100644 (file)
new mode 100755 (executable)
index ca8874e..16c1d78
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1110 );
+define( 'UPDATE_VERSION' , 1123 );
 
 /**
  *
@@ -937,3 +937,135 @@ function update_1109() {
                ADD INDEX ( `created` ), ADD INDEX ( `updated` ) ");
 }
 
+function update_1110() {
+       q("ALTER TABLE `mail` ADD `reply` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `seen`,
+               ADD INDEX ( `reply` ), ADD INDEX ( `uid` ), ADD INDEX ( `guid` ), ADD INDEX ( `seen` ),
+               ADD INDEX ( `uri` ), ADD INDEX ( `parent-uri`), ADD INDEX ( `created` ), ADD INDEX ( `convid` ) ");
+
+}
+
+function update_1111() {
+       q("ALTER TABLE `gcontact` ADD `connect` CHAR( 255 ) NOT NULL ");
+}
+
+
+function update_1112() {
+
+       q("CREATE TABLE IF NOT EXISTS `notify` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`type` INT( 11 ) NOT NULL ,
+`name` CHAR( 255 ) NOT NULL ,
+`url` CHAR( 255 ) NOT NULL ,
+`photo` CHAR( 255 ) NOT NULL ,
+`date` DATETIME NOT NULL ,
+`msg` MEDIUMTEXT NOT NULL ,
+`uid` INT NOT NULL ,
+`link` CHAR( 255 ) NOT NULL ,
+`seen` TINYINT( 1 ) NOT NULL DEFAULT '0'
+) ENGINE = MYISAM ");
+
+       q("ALTER TABLE `notify` ADD INDEX ( `type` ), ADD INDEX ( `uid`), ADD INDEX (`seen`), ADD INDEX (`date`) ");
+
+}
+
+function update_1113() {
+       q("ALTER TABLE `notify` ADD `verb` CHAR( 255 ) NOT NULL ,
+ADD `otype` CHAR( 16 ) NOT NULL");
+}
+
+function update_1114() {
+       q("CREATE TABLE IF NOT EXISTS `item_id` (
+`iid` INT NOT NULL ,
+`uid` INT NOT NULL ,
+`face` CHAR( 255 ) NOT NULL ,
+`dspr` CHAR( 255 ) NOT NULL ,
+`twit` CHAR( 255 ) NOT NULL ,
+`stat` CHAR( 255 ) NOT NULL ,
+PRIMARY KEY ( `iid` ),
+INDEX ( `uid` ),
+INDEX ( `face` ),
+INDEX ( `dspr` ),
+INDEX ( `twit` ),
+INDEX ( `stat` )
+) ENGINE = MYISAM ");
+
+}
+
+function update_1115() {
+       q("ALTER TABLE `item` ADD `moderated` 
+               TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `pubmail`, 
+               ADD INDEX (`moderated`) ");
+}
+
+function update_1116() {
+       //typo! corrected update was rolled forward
+}
+
+function update_1117() {
+q("create table if not exists `manage` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL ,
+`mid` INT NOT NULL,
+INDEX ( `uid` ),
+INDEX ( `mid` )
+) ENGINE = MYISAM ");
+
+}
+
+function update_1118() {
+       // rolled forward
+}
+
+function update_1119() {
+q("ALTER TABLE `contact` ADD `closeness` TINYINT( 2 ) NOT NULL DEFAULT '99' AFTER `reason` , ADD INDEX (`closeness`) ");
+q("update contact set closeness = 0 where self = 1");
+q("ALTER TABLE `item` ADD `spam` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `visible` , ADD INDEX (`spam`) ");
+}
+
+
+function update_1120() {
+
+       // item table update from 1119 did not get into database.sql file.
+       // might be missing on new installs. We'll check.
+
+       $r = q("describe item");
+       if($r && count($r)) {
+               foreach($r as $rr)
+                       if($rr['Field'] == 'spam')
+                               return;
+       }
+       q("ALTER TABLE `item` ADD `spam` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `visible` , ADD INDEX (`spam`) ");
+
+}
+
+function update_1121() {
+       q("CREATE TABLE IF NOT EXISTS `poll_result` (
+       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+       `poll_id` INT NOT NULL ,
+       `choice` INT NOT NULL ,
+       INDEX ( `poll_id` ),
+       INDEX ( `choice` )
+       ) ENGINE = MYISAM ");
+
+       q("CREATE TABLE IF NOT EXISTS `poll` (
+       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+       `uid` INT NOT NULL ,
+       `q0` MEDIUMTEXT NOT NULL ,
+       `q1` MEDIUMTEXT NOT NULL ,
+       `q2` MEDIUMTEXT NOT NULL ,
+       `q3` MEDIUMTEXT NOT NULL ,
+       `q4` MEDIUMTEXT NOT NULL ,
+       `q5` MEDIUMTEXT NOT NULL ,
+       `q6` MEDIUMTEXT NOT NULL ,
+       `q7` MEDIUMTEXT NOT NULL ,
+       `q8` MEDIUMTEXT NOT NULL ,
+       `q9` MEDIUMTEXT NOT NULL ,
+       INDEX ( `uid` )
+       ) ENGINE = MYISAM ");
+
+}
+
+function update_1122() {
+q("ALTER TABLE `notify` ADD `hash` CHAR( 64 ) NOT NULL AFTER `id` ,
+ADD INDEX ( `hash` ) ");
+}
\ No newline at end of file