From ace1104d08715ffb4d7ada722adeb53206236a50 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Fri, 15 Feb 2013 19:05:00 -0800
Subject: contact rating field so it's here when we need it

---
 install/database.sql |  4 +++-
 install/update.php   | 10 +++++++++-
 2 files changed, 12 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index de1d096b2..03279d6aa 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -14,6 +14,7 @@ CREATE TABLE IF NOT EXISTS `abook` (
   `abook_my_perms` int(11) NOT NULL DEFAULT '0',
   `abook_their_perms` int(11) NOT NULL DEFAULT '0',
   `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '99',
+  `abook_rating` int(11) NOT NULL DEFAULT '0',
   `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_connected` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -32,7 +33,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
   KEY `abook_flags` (`abook_flags`),
   KEY `abook_profile` (`abook_profile`),
   KEY `abook_dob` (`abook_dob`),
-  KEY `abook_connected` (`abook_connected`)
+  KEY `abook_connected` (`abook_connected`),
+  KEY `abook_rating` (`abook_rating`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `account` (
diff --git a/install/update.php b/install/update.php
index d4d1bdf50..301d6e06f 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1027 );
+define( 'UPDATE_VERSION' , 1028 );
 
 /**
  *
@@ -342,3 +342,11 @@ ADD INDEX ( `mimetype` )");
 }
 
 
+function update_r1027() {
+	$r = q("ALTER TABLE `abook` ADD `abook_rating` INT NOT NULL DEFAULT '0' AFTER `abook_closeness` ,
+ADD INDEX ( `abook_rating` )");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+
-- 
cgit v1.2.3