aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/migration
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2023-01-28 19:58:01 +0300
committerGravatar Vitaly Takmazov2023-01-29 00:33:11 +0300
commit6cd35dbc723a64720c08a331ede9e605df11b8b4 (patch)
treefb6f1fa5653faf4dc558fcd4403bf37553d80444 /src/main/resources/db/migration
parent4b1ff0806def1d7e632852f209bfda9c29093524 (diff)
CI: enable sqlserver job
Diffstat (limited to 'src/main/resources/db/migration')
-rw-r--r--src/main/resources/db/migration/V1.39__tags_noindex.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/V1.39__tags_noindex.sql b/src/main/resources/db/migration/V1.39__tags_noindex.sql
new file mode 100644
index 00000000..af37bc66
--- /dev/null
+++ b/src/main/resources/db/migration/V1.39__tags_noindex.sql
@@ -0,0 +1,7 @@
+alter table tags alter noindex set default null;
+alter table tags alter noindex type INTEGER USING CASE WHEN noindex THEN 1 ELSE 0 END;
+alter table tags alter noindex set default 0;
+alter table tags alter top set default null;
+alter table tags alter top type INTEGER USING CASE WHEN top THEN 1 ELSE 0 END;
+alter table tags alter top set default 0;
+alter table tags rename top to notop \ No newline at end of file