diff options
author | Friendika <info@friendika.com> | 2011-06-26 17:57:23 -0700 |
---|---|---|
committer | Friendika <info@friendika.com> | 2011-06-26 17:57:23 -0700 |
commit | f7964efa52f7efa8159403568a59e320209cbffa (patch) | |
tree | fbd6553714aeef865e67e9ecee495510646ea435 /update.php | |
parent | 22e89220889759256b48323ee1a66257e2121ef7 (diff) | |
download | volse-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.php | 23 |
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"); + +} + + |