Some testing stuff

[friendica.git] / update.php

diff --git a/update.php b/update.php
old mode 100644 (file)
new mode 100755 (executable)
index 6eade22..2413845
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1114 );
+define( 'UPDATE_VERSION' , 1122 );
 
 /**
  *
@@ -972,3 +972,96 @@ 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 ");
+
+}
+