aboutsummaryrefslogtreecommitdiffstats
path: root/update.php
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-06-26 17:57:23 -0700
committerFriendika <info@friendika.com>2011-06-26 17:57:23 -0700
commitf7964efa52f7efa8159403568a59e320209cbffa (patch)
treefbd6553714aeef865e67e9ecee495510646ea435 /update.php
parent22e89220889759256b48323ee1a66257e2121ef7 (diff)
downloadvolse-hubzilla-f7964efa52f7efa8159403568a59e320209cbffa.tar.gz
volse-hubzilla-f7964efa52f7efa8159403568a59e320209cbffa.tar.bz2
volse-hubzilla-f7964efa52f7efa8159403568a59e320209cbffa.zip
revisit friend suggestion structures
Diffstat (limited to 'update.php')
-rw-r--r--update.php23
1 files changed, 22 insertions, 1 deletions
diff --git a/update.php b/update.php
index 409e5d48e..2e22b9d1c 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1068 );
+define( 'UPDATE_VERSION' , 1069 );
/**
*
@@ -541,3 +541,24 @@ function update_1067() {
q("ALTER TABLE `ffinder` ADD `type` CHAR( 16 ) NOT NULL AFTER `id` ,
ADD `note` TEXT NOT NULL AFTER `type` ");
}
+
+function update_1068() {
+ // 1067 was short-sighted. Undo it.
+ q("ALTER TABLE `ffinder` DROP `type` , DROP `note` ");
+
+ // and do this instead.
+
+ q("CREATE TABLE IF NOT EXISTS `fsuggest` (
+ `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `uid` INT NOT NULL ,
+ `cid` INT NOT NULL ,
+ `name` CHAR( 255 ) NOT NULL ,
+ `url` CHAR( 255 ) NOT NULL ,
+ `photo` CHAR( 255 ) NOT NULL ,
+ `note` TEXT NOT NULL ,
+ `created` DATETIME NOT NULL
+ ) ENGINE = MYISAM DEFAULT CHARSET=utf8");
+
+}
+
+