From 6e016c439caa444c4b3aca55e39a5dfa7294c684 Mon Sep 17 00:00:00 2001
From: zotlabs <mike@macgirvin.com>
Date: Tue, 22 Nov 2016 14:15:33 -0800
Subject: db update required for Zot2

---
 install/schema_mysql.sql    |  1 +
 install/schema_postgres.sql |  1 +
 install/update.php          | 11 ++++++++++-
 3 files changed, 12 insertions(+), 1 deletion(-)

(limited to 'install')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 4cbcfc64d..e143e252a 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1153,6 +1153,7 @@ CREATE TABLE IF NOT EXISTS `site` (
   `site_type` smallint NOT NULL DEFAULT '0',
   `site_project` char(255) NOT NULL DEFAULT '',
   `site_version` varchar(32) NOT NULL DEFAULT '',
+  `site_crypto` text NOT NULL DEFAULT '',
   PRIMARY KEY (`site_url`),
   KEY `site_flags` (`site_flags`),
   KEY `site_update` (`site_update`),
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index a682aa49d..b1b1c8474 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1134,6 +1134,7 @@ CREATE TABLE "site" (
   "site_type" smallint NOT NULL DEFAULT '0',
   "site_project" text NOT NULL DEFAULT '',
   "site_version" text NOT NULL DEFAULT '',
+  "site_crypto" text NOT NULL DEFAULT '',
   PRIMARY KEY ("site_url")
 );
 create index "site_flags" on site ("site_flags");
diff --git a/install/update.php b/install/update.php
index 7e7104b74..dbf3a08ca 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1184 );
+define( 'UPDATE_VERSION' , 1185 );
 
 /**
  *
@@ -2463,3 +2463,12 @@ function update_r1183() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1184() {
+
+	$r1 = q("alter table site add site_crypto text not null default '' ");
+
+	if($r1)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3