Visitenbuch/prisma/migrations/20240227233517_natural_collation/migration.sql

5 lines
278 B
SQL

CREATE COLLATION NATURAL_CI (provider = icu, locale = 'en-u-kn-true');
ALTER TABLE stations ALTER COLUMN NAME TYPE TEXT COLLATE NATURAL_CI;
ALTER TABLE rooms ALTER COLUMN NAME TYPE TEXT COLLATE NATURAL_CI;
ALTER TABLE categories ALTER COLUMN NAME TYPE TEXT COLLATE NATURAL_CI;