Improvments of the HTML to make a better bb2markdown conversion (nested lists, youtub...

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 9d534a127a8c8dc2d28e422b5385defc9bd8960d..b8e247f57ce99f885714ce1467da93979ea0eb19 100644 (file)
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1147 );
+define( 'UPDATE_VERSION' , 1151 );
 
 /**
  *
@@ -1274,15 +1274,36 @@ function update_1146() {
        return UPDATE_SUCCESS ;
 }
 
-/*
-function update_xxxx() {
-       $r1 = q("ALTER TABLE `sign` MODIFY `iid` SET DEFAULT '0'");
+function update_1147() {
+       $r1 = q("ALTER TABLE `sign` ALTER `iid` SET DEFAULT '0'");
        $r2 = q("ALTER TABLE `sign` ADD `retract_iid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `iid`");
        $r3 = q("ALTER TABLE `sign` ADD INDEX ( `retract_iid` )");  
        if((! $r1) || (! $r2) || (! $r3))
                return UPDATE_FAILED ;
        return UPDATE_SUCCESS ;
 }
-*/
-// dump DB schema: mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
+
+function update_1148() {
+       $r = q("ALTER TABLE photo ADD type CHAR(128) NOT NULL DEFAULT 'image/jpeg' AFTER filename");
+       if (!$r)
+               return UPDATE_FAILED;
+       return UPDATE_SUCCESS;
+}
+
+
+function update_1149() {
+       $r1 = q("ALTER TABLE profile ADD likes text NOT NULL after prv_keywords");
+       $r2 = q("ALTER TABLE profile ADD dislikes text NOT NULL after likes");
+       if (! ($r1 && $r2))
+               return UPDATE_FAILED;
+       return UPDATE_SUCCESS;
+}
+
+
+function update_1150() {
+       $r = q("ALTER TABLE event ADD summary text NOT NULL after finish, add index ( uid ), add index ( cid ), add index ( uri ), add index ( `start` ), add index ( finish ), add index ( `type` ), add index ( adjust ) ");
+       if(! $r)
+               return UPDATE_FAILED;
+       return UPDATE_SUCCESS;
+}