X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/8c6fa3fbaccc22127280bf77a48fab5a3ee0716e..46b0747592074017ff0ea4b33d4a7194235886e5:/projects/stargazer/inst/var/01-alter-02.postgresql.sql diff --git a/projects/stargazer/inst/var/01-alter-02.postgresql.sql b/projects/stargazer/inst/var/01-alter-02.postgresql.sql deleted file mode 100644 index ef6a98c6..00000000 --- a/projects/stargazer/inst/var/01-alter-02.postgresql.sql +++ /dev/null @@ -1,13 +0,0 @@ -/* - * DB migration from v01 to v02 (postgres) - */ -BEGIN; - -CREATE DOMAIN DM_TARIFF_PERIOD AS TEXT NOT NULL - CONSTRAINT valid_value CHECK (VALUE = 'month' OR VALUE = 'day'); - -ALTER TABLE tb_tariffs ADD period DM_TARIFF_PERIOD DEFAULT 'month'; - -UPDATE tb_info SET version = 7; - -COMMIT;