From de13497333c9b68e3fa2d73c9a0284da7797f405 Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Sun, 28 Jun 2015 21:16:56 -0700
Subject: no this isn't it. well ok, it's part of it, but not the important
 part. it's still pretty cool.

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

(limited to 'install')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 8aca3dff4..4d0da366f 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -20,6 +20,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
   `abook_dob` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `abook_flags` int(11) NOT NULL DEFAULT '0',
   `abook_profile` char(64) NOT NULL DEFAULT '',
+  `abook_incl` TEXT NOT NULL DEFAULT '',
+  `abook_excl` TEXT NOT NULL DEFAULT '',
   PRIMARY KEY (`abook_id`),
   KEY `abook_account` (`abook_account`),
   KEY `abook_channel` (`abook_channel`),
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index a68c7d12b..a58e5a2ae 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -14,6 +14,8 @@ CREATE TABLE "abook" (
   "abook_dob" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "abook_flags" bigint NOT NULL DEFAULT '0',
   "abook_profile" char(64) NOT NULL DEFAULT '',
+  "abook_incl" TEXT NOT NULL DEFAULT '',
+  "abook_excl" TEXT NOT NULL DEFAULT '',
   PRIMARY KEY ("abook_id")
 );
   create index  "abook_account" on abook ("abook_account");
diff --git a/install/update.php b/install/update.php
index 62c976218..fb49e9a16 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1143 );
+define( 'UPDATE_VERSION' , 1144 );
 
 /**
  *
@@ -1656,4 +1656,14 @@ function update_r1142() {
 	return UPDATE_FAILED;
 
 
+}
+
+function update_r1143() {
+
+	$r1 = q("ALTER TABLE abook ADD abook_incl TEXT NOT NULL DEFAULT ''");
+	$r2 = q("ALTER TABLE abook ADD abook_excl TEXT NOT NULL DEFAULT '' ");
+	if($r1 && $r2)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+
 }
\ No newline at end of file
-- 
cgit v1.2.3