template proc: fix variables regexp

[friendica.git] / update.php

diff --git a/update.php b/update.php
index dc3cc0e562ddb93865a2b3b1ae2e0209a31a018c..c29394b480968d4e161fb4cb8114a9f20f5261d0 100755 (executable)
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1120 );
+define( 'UPDATE_VERSION' , 1131 );
 
 /**
  *
@@ -1021,3 +1021,104 @@ q("ALTER TABLE `contact` ADD `closeness` TINYINT( 2 ) NOT NULL DEFAULT '99' AFTE
 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` ) ");
+}
+
+function update_1123() {
+set_config('system','allowed_themes','dispy,quattro,testbubble,vier,darkbubble,darkzero,duepuntozero,greenzero,purplezero,quattro-green,slackr');
+}
+
+function update_1124() {
+q("alter table item add index (`author-name`) ");
+}
+
+function update_1125() {
+  q("CREATE TABLE IF NOT EXISTS `notify-threads` (
+  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+  `notify-id` INT NOT NULL,
+  `master-parent-item` INT( 10 ) unsigned NOT NULL DEFAULT '0',
+  `parent-item` INT( 10 ) unsigned NOT NULL DEFAULT '0',
+  `receiver-uid` INT NOT NULL,
+  INDEX ( `master-parent-item` ),
+  INDEX ( `receiver-uid` )
+  ) ENGINE = MyISAM DEFAULT CHARSET=utf8");
+}
+
+function update_1126() {
+       q("ALTER TABLE `mailacct` ADD `action` INT NOT NULL AFTER `pass`,
+               ADD `movetofolder` CHAR(255) NOT NULL AFTER `action`");
+}
+
+function update_1127() {
+       q("CREATE TABLE IF NOT EXISTS `spam` (
+  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+  `uid` INT NOT NULL,
+  `spam` INT NOT NULL DEFAULT '0',
+  `ham` INT NOT NULL DEFAULT '0',
+  `term` CHAR(255) NOT NULL,
+  INDEX ( `uid` ),
+  INDEX ( `spam` ),
+  INDEX ( `ham` ),
+  INDEX ( `term` )
+  ) ENGINE = MyISAM DEFAULT CHARSET=utf8");
+}
+
+
+function update_1128() {
+       q("alter table spam add `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `term` ");
+}
+
+function update_1129() {
+       q("ALTER TABLE `notify` ADD `parent` INT NOT NULL AFTER `link` , ADD INDEX ( `parent` ), ADD INDEX ( `link` ), ADD INDEX ( `otype` ) ");
+}
+
+function update_1130() {
+       q("ALTER TABLE `item` ADD `file` MEDIUMTEXT NOT NULL AFTER `inform`, ADD FULLTEXT KEY (`file`) ");
+}
+