diff options
| author | friendica <info@friendica.com> | 2012-12-27 23:33:37 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-12-27 23:33:37 -0800 |
| commit | dda4d689bbdd871f5bd8809ce5381aaee5004d5b (patch) | |
| tree | b70722cf3b35db85aa30ce61e902c592583a7b08 /install/update.php | |
| parent | 55e77a57d0ea20844b481ff9b194bdf424857c5e (diff) | |
| download | volse-hubzilla-dda4d689bbdd871f5bd8809ce5381aaee5004d5b.tar.gz volse-hubzilla-dda4d689bbdd871f5bd8809ce5381aaee5004d5b.tar.bz2 volse-hubzilla-dda4d689bbdd871f5bd8809ce5381aaee5004d5b.zip | |
This was bloody hard to sort out.... but now it's sorted and we can move forward again. Put back xtag for efficient keyword searching, use it in conjunction with xprof['keywords'] to avoid a SQL triple join and group_concat (which simply won't scale on a directory server), figured out how best to work timezone corrected birthdays into the protocol. The directory can even provide an age if one was provided to it. Both of these things need some more work, but we have the mechanisms and a plan how to do it right instead of "how the !@#$ are we going to do pull this off?"
Diffstat (limited to 'install/update.php')
| -rw-r--r-- | install/update.php | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index 4c5e4d3a6..e8f52273e 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1010 ); +define( 'UPDATE_VERSION' , 1011 ); /** * @@ -169,3 +169,14 @@ function update_r1009() { } +function update_r1010() { + $r = q("ALTER TABLE `abook` ADD `abook_dob` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `abook_connnected` , +ADD INDEX ( `abook_dob` )"); + + $r2 = q("ALTER TABLE `profile` ADD `dob_tz` CHAR( 255 ) NOT NULL DEFAULT 'UTC' AFTER `dob`"); + + if($r && $r2) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} + |