diff options
| author |  Vitaly Takmazov | 2023-01-27 17:50:14 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-01-27 19:05:25 +0300 |
| commit | 2db415ce42fb96059b6d7fce4cf4ce078a62680e (patch) | |
| tree | 06d21a8483e437ad4d62f337b70e7e93dba18cc6 /src/main/resources/db/specific/postgresql | |
| parent | b3a169844b43d64aba4c1f7c583073b5dc54cf49 (diff) | |
baseline non-production databases to 1.36
Diffstat (limited to 'src/main/resources/db/specific/postgresql')
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) |