diff options
| author |  Vitaly Takmazov | 2023-01-28 19:58:01 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-01-29 00:33:11 +0300 |
| commit | 6cd35dbc723a64720c08a331ede9e605df11b8b4 (patch) | |
| tree | fb6f1fa5653faf4dc558fcd4403bf37553d80444 /src/main/resources/db/migration | |
| parent | 4b1ff0806def1d7e632852f209bfda9c29093524 (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.sql | 7 |
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 |