From 2db415ce42fb96059b6d7fce4cf4ce078a62680e Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 27 Jan 2023 17:50:14 +0300
Subject: baseline non-production databases to 1.36

---
 src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql  | 1 -
 .../resources/db/specific/postgresql/V1.25__update_tokens_size.sql    | 3 ---
 .../resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql | 1 -
 src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql | 4 ----
 .../db/specific/postgresql/V1.35__case_insensitive_email_jid.sql      | 2 --
 src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql       | 1 -
 6 files changed, 12 deletions(-)
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.35__case_insensitive_email_jid.sql
 delete mode 100644 src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql

(limited to 'src/main/resources/db/specific/postgresql')

diff --git a/src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql b/src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql
deleted file mode 100644
index ba3eee8c..00000000
--- a/src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE users ALTER COLUMN lastmessage TYPE timestamp with time zone
\ 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
deleted file mode 100644
index a1c7bbac..00000000
--- a/src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-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
diff --git a/src/main/resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql b/src/main/resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql
deleted file mode 100644
index a68c15f3..00000000
--- a/src/main/resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE users ALTER COLUMN nick TYPE character varying(64) COLLATE case_insensitive
diff --git a/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql b/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
deleted file mode 100644
index 5a15d9ae..00000000
--- a/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DELETE
-FROM followers A USING followers B
-WHERE A.user_id=B.user_id AND A.ts<=B.ts AND A.acct=B.acct AND A.ctid<B.ctid;
-ALTER TABLE followers ADD UNIQUE (user_id, acct)
\ No newline at end of file
diff --git a/src/main/resources/db/specific/postgresql/V1.35__case_insensitive_email_jid.sql b/src/main/resources/db/specific/postgresql/V1.35__case_insensitive_email_jid.sql
deleted file mode 100644
index 93a987b8..00000000
--- a/src/main/resources/db/specific/postgresql/V1.35__case_insensitive_email_jid.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE jids ALTER COLUMN jid TYPE character varying(255) COLLATE case_insensitive;
-ALTER TABLE emails ALTER COLUMN email TYPE character varying(255) COLLATE case_insensitive
diff --git a/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql b/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql
deleted file mode 100644
index ccdefad2..00000000
--- a/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE user_services ALTER COLUMN regid TYPE character varying(1024)
-- 
cgit v1.2.3