From b8e4094e7b475dd5ab980134ea463902c718a4aa Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Wed, 12 Apr 2017 23:09:22 +0200 Subject: [PATCH] Allow negative contact.contat-type https://github.com/friendica/friendica/issues/3328 --- database.sql | 2 +- include/dbstructure.php | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/database.sql b/database.sql index 7ed19f439c..9d56957100 100644 --- a/database.sql +++ b/database.sql @@ -159,7 +159,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `writable` tinyint(1) NOT NULL DEFAULT 0, `forum` tinyint(1) NOT NULL DEFAULT 0, `prv` tinyint(1) NOT NULL DEFAULT 0, - `contact-type` int(11) unsigned NOT NULL DEFAULT 0, + `contact-type` int(11) NOT NULL DEFAULT 0, `hidden` tinyint(1) NOT NULL DEFAULT 0, `archive` tinyint(1) NOT NULL DEFAULT 0, `pending` tinyint(1) NOT NULL DEFAULT 1, diff --git a/include/dbstructure.php b/include/dbstructure.php index 48cc02d2d1..9828230a12 100644 --- a/include/dbstructure.php +++ b/include/dbstructure.php @@ -5,7 +5,7 @@ use \Friendica\Core\Config; require_once("boot.php"); require_once("include/text.php"); -define('NEW_UPDATE_ROUTINE_VERSION', 1170); +define('NEW_UPDATE_ROUTINE_VERSION', 1171); /* * send the email and do what is needed to do on update fails @@ -671,7 +671,7 @@ function db_definition($charset) { "writable" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"), "forum" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"), "prv" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"), - "contact-type" => array("type" => "int(11) unsigned", "not null" => "1", "default" => "0"), + "contact-type" => array("type" => "int(11)", "not null" => "1", "default" => "0"), "hidden" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"), "archive" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"), "pending" => array("type" => "tinyint(1)", "not null" => "1", "default" => "1"), -- 2.39.5