From dda4d689bbdd871f5bd8809ce5381aaee5004d5b Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 27 Dec 2012 23:33:37 -0800
Subject: 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?"

---
 install/database.sql |  5 ++++-
 install/update.php   | 13 ++++++++++++-
 2 files changed, 16 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 817091df5..02bbb5f0f 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -17,6 +17,7 @@ CREATE TABLE IF NOT EXISTS `abook` (
   `abook_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `abook_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `abook_connnected` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `abook_dob` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `abook_flags` int(11) NOT NULL DEFAULT '0',
   `abook_profile` char(64) NOT NULL DEFAULT '',
   PRIMARY KEY (`abook_id`),
@@ -30,7 +31,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
   KEY `abook_updated` (`abook_updated`),
   KEY `abook_connnected` (`abook_connnected`),
   KEY `abook_flags` (`abook_flags`),
-  KEY `abook_profile` (`abook_profile`)
+  KEY `abook_profile` (`abook_profile`),
+  KEY `abook_dob` (`abook_dob`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `account` (
@@ -641,6 +643,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `name` char(255) NOT NULL,
   `pdesc` char(255) NOT NULL,
   `dob` char(32) NOT NULL DEFAULT '0000-00-00',
+  `dob_tz` char(255) NOT NULL DEFAULT 'UTC',
   `address` char(255) NOT NULL,
   `locality` char(255) NOT NULL,
   `region` char(255) NOT NULL,
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;
+}
+
-- 
cgit v1.2.3