From 76bf892f9f52c0deee313a89929185e332877f85 Mon Sep 17 00:00:00 2001
From: redmatrix <git@macgirvin.com>
Date: Thu, 18 Feb 2016 00:20:08 -0800
Subject: iconfig - add sharing variable

---
 install/schema_mysql.sql    |  4 +++-
 install/schema_postgres.sql |  2 ++
 install/update.php          | 14 ++++++++++++--
 3 files changed, 17 insertions(+), 3 deletions(-)

(limited to 'install')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index bb6ad24a2..693cad1a8 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -550,10 +550,12 @@ CREATE TABLE IF NOT EXISTS `iconfig` (
   `cat` char(255) NOT NULL DEFAULT '',
   `k` char(255) NOT NULL DEFAULT '',
   `v` mediumtext NOT NULL,
+  `sharing` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `iid` (`iid`),
   KEY `cat` (`cat`),
-  KEY `k` (`k`)
+  KEY `k` (`k`),
+  KEY `sharing` (`sharing`),
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `issue` (
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 2d9bffdec..964ca5966 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -544,11 +544,13 @@ CREATE TABLE "iconfig" (
   "cat" text NOT NULL DEFAULT '',
   "k" text NOT NULL DEFAULT '',
   "v" text NOT NULL DEFAULT '',
+  "sharing" int NOT NULL DEFAULT '0',
   PRIMARY_KEY("id")
 );
 create index "iconfig_iid" on iconfig ("iid");
 create index "iconfig_cat" on iconfig ("cat");
 create index "iconfig_k" on iconfig ("k");
+create index "iconfig_sharing" on iconfig ("sharing");
 CREATE TABLE "issue" (
   "issue_id" serial  NOT NULL,
   "issue_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
diff --git a/install/update.php b/install/update.php
index e96bda03c..d21295be7 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1162 );
+define( 'UPDATE_VERSION' , 1163 );
 
 /**
  *
@@ -1971,7 +1971,6 @@ function update_r1161() {
 $r2 = q("create index \"iconfig_iid\" on iconfig (\"iid\") ");;
 $r3 = q("create index \"iconfig_cat\" on iconfig (\"cat\") ");
 $r4 = q("create index \"iconfig_k\" on iconfig (\"k\") ");
-
 	$r = $r1 && $r2 && $r3 && $r4;
 	}
 	else {
@@ -1994,3 +1993,14 @@ $r4 = q("create index \"iconfig_k\" on iconfig (\"k\") ");
     return UPDATE_FAILED;
 }
 
+function update_r1162() {
+	$r1 = q("alter table iconfig add sharing int not null default '0' ");
+
+	if(ACTIVE_DBTYPE == DBTYPE_POSTGRES)
+		$r2 = q("create index \"iconfig_sharing\" on iconfig (\"sharing\") "); 
+	else 
+		$r2 = q("alter table iconfig add index ( sharing ) ");
+    if($r1 && $r2)
+        return UPDATE_SUCCESS;
+    return UPDATE_FAILED;
+}
\ No newline at end of file
-- 
cgit v1.2.3