From 9196c9eef091e7f4a41fbc9452521d6ca2de55a3 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Fri, 22 Aug 2014 21:37:08 -0700
Subject: We really can't do this without a hubloc. I was hoping we could, but
 notifier is setup to take hublocs, not xchans.

---
 install/database.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 2791f94be..104f145e5 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -442,6 +442,7 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
   `hubloc_guid_sig` text NOT NULL,
   `hubloc_hash` char(255) NOT NULL,
   `hubloc_addr` char(255) NOT NULL DEFAULT '',
+  `hubloc_network` char(32) NOT NULL DEFAULT '',
   `hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `hubloc_status` int(10) unsigned NOT NULL DEFAULT '0',
   `hubloc_url` char(255) NOT NULL DEFAULT '',
@@ -459,6 +460,7 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
   KEY `hubloc_connect` (`hubloc_connect`),
   KEY `hubloc_host` (`hubloc_host`),
   KEY `hubloc_addr` (`hubloc_addr`),
+  KEY `hubloc_network` (`hubloc_network`),
   KEY `hubloc_updated` (`hubloc_updated`),
   KEY `hubloc_connected` (`hubloc_connected`),
   KEY `hubloc_status` (`hubloc_status`)
-- 
cgit v1.2.3


From 8c6067b411ee7f69b3df1341a8696ec1e5811601 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Tue, 26 Aug 2014 20:51:59 -0700
Subject: more hard work

---
 install/database.sql | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 104f145e5..953f4aba1 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -311,6 +311,20 @@ CREATE TABLE IF NOT EXISTS `config` (
   UNIQUE KEY `access` (`cat`,`k`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `conv` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `guid` char(255) NOT NULL,
+  `recips` mediumtext NOT NULL,
+  `uid` int(11) NOT NULL,
+  `creator` char(255) NOT NULL,
+  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `subject` mediumtext NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `created` (`created`),
+  KEY `updated` (`updated`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
 CREATE TABLE IF NOT EXISTS `event` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `aid` int(10) unsigned NOT NULL DEFAULT '0',
@@ -936,6 +950,18 @@ CREATE TABLE IF NOT EXISTS `shares` (
   KEY `share_xchan` (`share_xchan`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `sign` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `iid` int(10) unsigned NOT NULL DEFAULT '0',
+  `retract_iid` int(10) unsigned NOT NULL DEFAULT '0',
+  `signed_text` mediumtext NOT NULL,
+  `signature` text NOT NULL,
+  `signer` char(255) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `iid` (`iid`),
+  KEY `retract_iid` (`retract_iid`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
 CREATE TABLE IF NOT EXISTS `site` (
   `site_url` char(255) NOT NULL,
   `site_access` int(11) NOT NULL DEFAULT '0',
-- 
cgit v1.2.3


From e179dca446b4e604b7486e79d694d39679d1209f Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Tue, 26 Aug 2014 22:37:04 -0700
Subject: place to store multiple choice and select items for extensible
 profiles

---
 install/database.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 953f4aba1..7f6a128c9 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -823,6 +823,7 @@ CREATE TABLE IF NOT EXISTS `profdef` (
   `field_type` char(16) NOT NULL DEFAULT '',
   `field_desc` char(255) NOT NULL DEFAULT '',
   `field_help` char(255) NOT NULL DEFAULT '',
+  `field_inputs` mediumtext NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `field_name` (`field_name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3


From eb27bea794d5aff547be9722f7c058678b8cbb1d Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 27 Aug 2014 19:15:34 -0700
Subject: mind numbing drudgery continued...

---
 install/database.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 7f6a128c9..acf59a36d 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -615,6 +615,7 @@ CREATE TABLE IF NOT EXISTS `likes` (
 
 CREATE TABLE IF NOT EXISTS `mail` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `convid` int(10) unsigned NOT NULL DEFAULT '0',
   `mail_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `from_xchan` char(255) NOT NULL DEFAULT '',
   `to_xchan` char(255) NOT NULL DEFAULT '',
@@ -628,6 +629,7 @@ CREATE TABLE IF NOT EXISTS `mail` (
   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY (`id`),
+  KEY `convid` (`convid`),
   KEY `created` (`created`),
   KEY `mail_flags` (`mail_flags`),
   KEY `account_id` (`account_id`),
-- 
cgit v1.2.3


From 53b5cf7f507df53d3e382b6714caacf9551ed6db Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 28 Aug 2014 16:56:13 -0700
Subject: Ability to close comments at a certain date/time - needed for loom.io
 emulation (and many other uses)

---
 install/database.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index acf59a36d..c773fab10 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -511,6 +511,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `comments_closed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `owner_xchan` char(255) NOT NULL DEFAULT '',
   `author_xchan` char(255) NOT NULL DEFAULT '',
   `source_xchan` char(255) NOT NULL DEFAULT '',
@@ -553,6 +554,8 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `received` (`received`),
   KEY `uid_commented` (`uid`,`commented`),
   KEY `uid_created` (`uid`,`created`),
+  KEY `changed` (`changed`),
+  KEY `comments_closed` (`comments_closed`),
   KEY `aid` (`aid`),
   KEY `owner_xchan` (`owner_xchan`),
   KEY `author_xchan` (`author_xchan`),
-- 
cgit v1.2.3

