From 8a8702c9cd5dde44356da11f5417db6af0597d4e Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 11 Apr 2012 16:13:57 -0700
Subject: extensible item_id table for managing all the different message-ids
 generated by multiple services

---
 update.php | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index 1a36c754d..5ab321b33 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1137 );
+define( 'UPDATE_VERSION' , 1138 );
 
 /**
  *
@@ -1205,4 +1205,11 @@ function update_1136() {
 	q("ALTER TABLE `config` ADD UNIQUE `access` ( `cat` , `k` ) "); 
 	q("ALTER TABLE `pconfig` ADD UNIQUE `access` ( `uid` , `cat` , `k` )"); 
 
-}
\ No newline at end of file
+}
+
+
+function update_1137() {
+	q("alter table item_id DROP `face` , DROP `dspr` , DROP `twit` , DROP `stat` ");
+	q("ALTER TABLE `item_id` ADD `sid` CHAR( 255 ) NOT NULL AFTER `uid` , ADD `service` CHAR( 255 ) NOT NULL AFTER `sid` , add index (`sid`), add index ( `service`) ");
+}
+
-- 
cgit v1.2.3