aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/postgresql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/db/specific/postgresql')
-rw-r--r--src/main/resources/db/specific/postgresql/V1.24__fix_lastmessage.sql1
-rw-r--r--src/main/resources/db/specific/postgresql/V1.25__update_tokens_size.sql3
-rw-r--r--src/main/resources/db/specific/postgresql/V1.26__case_insensitive_nick.sql1
-rw-r--r--src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql4
-rw-r--r--src/main/resources/db/specific/postgresql/V1.35__case_insensitive_email_jid.sql2
-rw-r--r--src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql1
6 files changed, 0 insertions, 12 deletions
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)