From d54535bafd23f837235b8e1a2fa2c13b29d8c3db Mon Sep 17 00:00:00 2001
From: Brady Miller <brady.g.miller@gmail.com>
Date: Tue, 1 Jan 2019 01:00:33 -0800
Subject: [PATCH] pnotes portal fix (#2087)

---
 sql/5_0_1-to-5_0_2_upgrade.sql | 2 +-
 sql/database.sql               | 2 +-
 version.php                    | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/sql/5_0_1-to-5_0_2_upgrade.sql b/sql/5_0_1-to-5_0_2_upgrade.sql
index 0a23bc519..c0b4f59a8 100644
--- a/sql/5_0_1-to-5_0_2_upgrade.sql
+++ b/sql/5_0_1-to-5_0_2_upgrade.sql
@@ -670,7 +670,7 @@ CREATE TABLE `api_token` (
 #EndIf
 
 #IfMissingColumn pnotes update_by
-ALTER TABLE `pnotes` ADD `update_by` INT NOT NULL;
+ALTER TABLE `pnotes` ADD `update_by` bigint(20) default NULL;
 #EndIf
 
 #IfMissingColumn pnotes update_date
diff --git a/sql/database.sql b/sql/database.sql
index 277046702..ee75d9b76 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -6202,7 +6202,7 @@ CREATE TABLE `pnotes` (
   `message_status` VARCHAR(20) NOT NULL DEFAULT 'New',
   `portal_relation` VARCHAR(100) NULL,
   `is_msg_encrypted` TINYINT(2) DEFAULT '0' COMMENT 'Whether messsage encrypted 0-Not encrypted, 1-Encrypted',
-  `update_by` INT NOT NULL,
+  `update_by` bigint(20) default NULL,
   `update_date` DATETIME DEFAULT NULL,
   PRIMARY KEY  (`id`),
   KEY `pid` (`pid`)
diff --git a/version.php b/version.php
index bcc04ef21..82ef54a9e 100644
--- a/version.php
+++ b/version.php
@@ -25,7 +25,7 @@ $v_realpatch = '0';
 // is a database change in the course of development.  It is used
 // internally to determine when a database upgrade is needed.
 //
-$v_database = 275;
+$v_database = 276;
 
 // Access control version identifier, this is to be incremented whenever there
 // is a access control change in the course of development.  It is used
-- 
2.11.4.GIT