From: Maxim Mamontov <faust.madf@gmail.com>
Date: Thu, 14 Nov 2013 19:54:17 +0000 (+0200)
Subject: Added migration scripts for new daily fee algo.
X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/19b1d5971c25819b3ccfe48cac16ff4e2daa6ec4

Added migration scripts for new daily fee algo.
---

diff --git a/projects/stargazer/inst/var/01-alter-02.mysql.sql b/projects/stargazer/inst/var/01-alter-02.mysql.sql
new file mode 100644
index 00000000..c5aea323
--- /dev/null
+++ b/projects/stargazer/inst/var/01-alter-02.mysql.sql
@@ -0,0 +1,5 @@
+/*
+ *  DB migration from v01 to v02 (mysql)
+ */
+
+ALTER TABLE users ADD DisabledDetailStat INT(3) DEFAULT 0;
diff --git a/projects/stargazer/inst/var/01-alter-02.postgresql.sql b/projects/stargazer/inst/var/01-alter-02.postgresql.sql
new file mode 100644
index 00000000..ef6a98c6
--- /dev/null
+++ b/projects/stargazer/inst/var/01-alter-02.postgresql.sql
@@ -0,0 +1,13 @@
+/*
+ *  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;
diff --git a/projects/stargazer/inst/var/01-alter-02.sql b/projects/stargazer/inst/var/01-alter-02.sql
new file mode 100644
index 00000000..065d1a79
--- /dev/null
+++ b/projects/stargazer/inst/var/01-alter-02.sql
@@ -0,0 +1,15 @@
+/*
+ *  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 (5);