From 1d3c7f3583cd5807f1c619fad1f379e895c4bdce Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Tue, 20 Dec 2022 01:43:49 +0300 Subject: Update social tokens field size in the database --- src/main/resources/db/specific/h2/V1.25__update_tokens_size.sql | 3 +++ src/main/resources/db/specific/mariadb/V1.25__update_tokens_size.sql | 3 +++ .../resources/db/specific/postgresql/V1.25__update_tokens_size.sql | 3 +++ 3 files changed, 9 insertions(+) create mode 100644 src/main/resources/db/specific/h2/V1.25__update_tokens_size.sql create mode 100644 src/main/resources/db/specific/mariadb/V1.25__update_tokens_size.sql create mode 100644 src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql (limited to 'src/main/resources') diff --git a/src/main/resources/db/specific/h2/V1.25__update_tokens_size.sql b/src/main/resources/db/specific/h2/V1.25__update_tokens_size.sql new file mode 100644 index 00000000..05eefe24 --- /dev/null +++ b/src/main/resources/db/specific/h2/V1.25__update_tokens_size.sql @@ -0,0 +1,3 @@ +ALTER TABLE vk MODIFY COLUMN access_token VARCHAR(255); +ALTER TABLE twitter MODIFY COLUMN access_token VARCHAR(255); +ALTER TABLE facebook MODIFY COLUMN access_token VARCHAR(255); \ No newline at end of file diff --git a/src/main/resources/db/specific/mariadb/V1.25__update_tokens_size.sql b/src/main/resources/db/specific/mariadb/V1.25__update_tokens_size.sql new file mode 100644 index 00000000..05eefe24 --- /dev/null +++ b/src/main/resources/db/specific/mariadb/V1.25__update_tokens_size.sql @@ -0,0 +1,3 @@ +ALTER TABLE vk MODIFY COLUMN access_token VARCHAR(255); +ALTER TABLE twitter MODIFY COLUMN access_token VARCHAR(255); +ALTER TABLE facebook MODIFY COLUMN access_token VARCHAR(255); \ No newline at end of file diff --git a/src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql b/src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql new file mode 100644 index 00000000..a1c7bbac --- /dev/null +++ b/src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql @@ -0,0 +1,3 @@ +ALTER TABLE vk ALTER COLUMN access_token TYPE character varying(255); +ALTER TABLE twitter ALTER COLUMN access_token TYPE character varying(255); +ALTER TABLE facebook ALTER COLUMN access_token TYPE character varying(255); \ No newline at end of file -- cgit v1.2.3