aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/migration/V1.26__case_insensitive_nick.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2023-01-27 17:50:14 +0300
committerGravatar Vitaly Takmazov2023-01-27 19:05:25 +0300
commit2db415ce42fb96059b6d7fce4cf4ce078a62680e (patch)
tree06d21a8483e437ad4d62f337b70e7e93dba18cc6 /src/main/resources/db/migration/V1.26__case_insensitive_nick.sql
parentb3a169844b43d64aba4c1f7c583073b5dc54cf49 (diff)
baseline non-production databases to 1.36
Diffstat (limited to 'src/main/resources/db/migration/V1.26__case_insensitive_nick.sql')
-rw-r--r--src/main/resources/db/migration/V1.26__case_insensitive_nick.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/V1.26__case_insensitive_nick.sql b/src/main/resources/db/migration/V1.26__case_insensitive_nick.sql
new file mode 100644
index 00000000..a68c15f3
--- /dev/null
+++ b/src/main/resources/db/migration/V1.26__case_insensitive_nick.sql
@@ -0,0 +1 @@
+ALTER TABLE users ALTER COLUMN nick TYPE character varying(64) COLLATE case_insensitive