From d29d010472c1f82e40d1afa227f651fd74575212 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Thu, 3 May 2018 15:57:47 +0300
Subject: jdbc: increase facebook link column size for new app scoped urls

---
 juick-server-jdbc/src/main/resources/juick.sql     | 2 +-
 juick-server-jdbc/src/main/resources/pg_schema_wip | 2 +-
 juick-server-jdbc/src/main/resources/schema.sql    | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/juick-server-jdbc/src/main/resources/juick.sql b/juick-server-jdbc/src/main/resources/juick.sql
index 4f15ba70..eb14a3e4 100644
--- a/juick-server-jdbc/src/main/resources/juick.sql
+++ b/juick-server-jdbc/src/main/resources/juick.sql
@@ -160,7 +160,7 @@ CREATE TABLE `facebook` (
   `access_token` char(255) DEFAULT NULL,
   `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `fb_name` char(64) NOT NULL,
-  `fb_link` char(64) NOT NULL,
+  `fb_link` char(255) NOT NULL,
   `crosspost` tinyint(1) unsigned NOT NULL DEFAULT '1',
   KEY `user_id` (`user_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/juick-server-jdbc/src/main/resources/pg_schema_wip b/juick-server-jdbc/src/main/resources/pg_schema_wip
index f9470678..61178495 100644
--- a/juick-server-jdbc/src/main/resources/pg_schema_wip
+++ b/juick-server-jdbc/src/main/resources/pg_schema_wip
@@ -235,7 +235,7 @@ CREATE TABLE facebook (
     access_token character varying(255),
     ts timestamp with time zone DEFAULT now() NOT NULL,
     fb_name character varying(64) NOT NULL,
-    fb_link character varying(64) NOT NULL,
+    fb_link character varying(255) NOT NULL,
     crosspost boolean DEFAULT true NOT NULL
 );
 
diff --git a/juick-server-jdbc/src/main/resources/schema.sql b/juick-server-jdbc/src/main/resources/schema.sql
index 59c979d5..13fe1413 100644
--- a/juick-server-jdbc/src/main/resources/schema.sql
+++ b/juick-server-jdbc/src/main/resources/schema.sql
@@ -35,7 +35,7 @@ CREATE TABLE IF NOT EXISTS `facebook` (
   `access_token` char(255) DEFAULT NULL,
   `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `fb_name` char(64) NOT NULL,
-  `fb_link` char(64) NOT NULL,
+  `fb_link` char(255) NOT NULL,
   `crosspost` tinyint(1) unsigned NOT NULL DEFAULT '1',
   KEY `user_id` (`user_id`)
 );
-- 
cgit v1.2.3