X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/4271ab433cd55bbd2612292bcf39e4dc3d7274f1..0907aa4037b12b6b88ee24495d4577a064d4f8db:/stargazer/inst/var/01-alter-02.sql diff --git a/stargazer/inst/var/01-alter-02.sql b/stargazer/inst/var/01-alter-02.sql deleted file mode 100644 index 628a016a..00000000 --- a/stargazer/inst/var/01-alter-02.sql +++ /dev/null @@ -1,15 +0,0 @@ -/* - * DB migration from v01 to v02 (firebird) - */ - -CREATE DOMAIN DM_TARIFF_PERIOD AS VARCHAR(32) NOT NULL - CHECK (VALUE = 'month' OR VALUE = 'day'); - -ALTER TABLE tb_tariffs ADD period DM_TARIFF_PERIOD DEFAULT 'month'; - -CREATE TABLE tb_info -( - version INTEGER NOT NULL -); - -INSERT INTO tb_info VALUES (1);