aboutsummaryrefslogtreecommitdiff
path: root/juick-server-jdbc/src/main/resources
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-05-03 15:57:47 +0300
committerGravatar Vitaly Takmazov2018-05-03 15:57:47 +0300
commitd29d010472c1f82e40d1afa227f651fd74575212 (patch)
treeff45107465713104f00f653a1bbee8fe097fecab /juick-server-jdbc/src/main/resources
parent71f9468b8bccf20206c33840fcbde8e384a69849 (diff)
jdbc: increase facebook link column size for new app scoped urls
Diffstat (limited to 'juick-server-jdbc/src/main/resources')
-rw-r--r--juick-server-jdbc/src/main/resources/juick.sql2
-rw-r--r--juick-server-jdbc/src/main/resources/pg_schema_wip2
-rw-r--r--juick-server-jdbc/src/main/resources/schema.sql2
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`)
);