From: Elena Mamontova Date: Fri, 1 Jul 2016 09:30:03 +0000 (+0300) Subject: Ticket 37. The 02-alter-03.sql new file added. X-Git-Tag: 2.409~150 X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/87307c2ee852831a11b4dae8432ecb08a488f956?ds=sidebyside Ticket 37. The 02-alter-03.sql new file added. --- diff --git a/projects/stargazer/inst/var/02-alter-03.sql b/projects/stargazer/inst/var/02-alter-03.sql new file mode 100644 index 00000000..a0199173 --- /dev/null +++ b/projects/stargazer/inst/var/02-alter-03.sql @@ -0,0 +1,10 @@ +/* + * DB migration from v02 to v03 (firebird) + */ + +CREATE DOMAIN DM_TARIFF_CHANGE_POLICY AS VARCHAR(32) NOT NULL + CHECK (VALUE IN ('allow', 'to_cheap', 'to_expensive', 'deny')); + +ALTER TABLE tb_tariffs ADD change_policy DM_TARIFF_CHANGE_POLICY DEFAULT 'allow'; + +UPDATE tb_info SET version = 2;