From 7d7a1498118f0101f31b711b30d2e21533bb01fe Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sat, 1 Oct 2011 23:19:20 -0700
Subject: db updates for server batch key caching, group visibility

---
 database.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index f39728a33..15e2f2cca 100644
--- a/database.sql
+++ b/database.sql
@@ -114,6 +114,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
 CREATE TABLE IF NOT EXISTS `group` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `uid` int(10) unsigned NOT NULL,
+  `visible` tinyint(1) NOT NULL DEFAULT '0',
   `deleted` tinyint(1) NOT NULL DEFAULT '0',
   `name` char(255) NOT NULL,
   PRIMARY KEY (`id`)
@@ -632,3 +633,12 @@ CREATE TABLE IF NOT EXISTS `search` (
 INDEX ( `uid` ),
 INDEX ( `term` )
 ) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `fserver` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`server` CHAR( 255 ) NOT NULL ,
+`posturl` CHAR( 255 ) NOT NULL ,
+`key` TEXT NOT NULL,
+INDEX ( `server` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
-- 
cgit v1.2.3

