diff options
Diffstat (limited to 'src/main/resources/db')
| -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 |