Started the french translation (up to the "TODO" comment in view/fr/strings.php)

[friendica.git] / update.php

diff --git a/update.php b/update.php
index d6fab4255a286e633b374ef4d2d1b027299469aa..0bd58d6d48251f080607c3f1491fc49bd744101d 100644 (file)
--- a/update.php
+++ b/update.php
@@ -274,3 +274,49 @@ function update_1028() {
        q("ALTER TABLE `user` ADD `openidserver` text NOT NULL AFTER `deny_gid` ");
 }
 
+function update_1029() {
+       q("ALTER TABLE `contact` ADD `info` MEDIUMTEXT NOT NULL AFTER `reason` ");
+}
+
+function update_1030() {
+       q("ALTER TABLE `contact` ADD `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag' AFTER `profile-id` ");
+
+       q("CREATE TABLE IF NOT EXISTS `event` (
+       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+       `uid` INT NOT NULL ,
+       `cid` INT NOT NULL ,
+       `created` DATETIME NOT NULL ,
+       `edited` DATETIME NOT NULL ,
+       `start` DATETIME NOT NULL ,
+       `finish` DATETIME NOT NULL ,
+       `desc` TEXT NOT NULL ,
+       `location` TEXT NOT NULL ,
+       `type` CHAR( 255 ) NOT NULL ,
+       `adjust` TINYINT( 1 ) NOT NULL DEFAULT '1',
+       `allow_cid` MEDIUMTEXT NOT NULL ,
+       `allow_gid` MEDIUMTEXT NOT NULL ,
+       `deny_cid` MEDIUMTEXT NOT NULL ,
+       `deny_gid` MEDIUMTEXT NOT NULL
+       ) ENGINE = MYISAM DEFAULT CHARSET=utf8 ");
+
+
+}
+
+function update_1031() {
+       // Repair any bad links that slipped into the item table
+       $r = q("SELECT `id`, `object` FROM `item` WHERE `object` != '' ");
+       if($r && count($r)) {
+               foreach($r as $rr) {
+                       if(strstr($rr['object'],'type="http')) {
+                               q("UPDATE `item` SET `object` = '%s' WHERE `id` = %d LIMIT 1",
+                                       dbesc(str_replace('type="http','href="http',$rr['object'])),
+                                       intval($rr['id'])
+                               );
+                       }
+               }
+       }
+}
+       
+function update_1032() {
+       q("ALTER TABLE `profile` ADD `pdesc` CHAR( 255 ) NOT NULL AFTER `name` ");
+}