X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/19b1d5971c25819b3ccfe48cac16ff4e2daa6ec4..3765465f3e8383a929a066a3f0d2fc5dd91fa64a:/projects/stargazer/inst/var/01-alter-02.mysql.sql?ds=inline diff --git a/projects/stargazer/inst/var/01-alter-02.mysql.sql b/projects/stargazer/inst/var/01-alter-02.mysql.sql index c5aea323..1f1b044b 100644 --- a/projects/stargazer/inst/var/01-alter-02.mysql.sql +++ b/projects/stargazer/inst/var/01-alter-02.mysql.sql @@ -2,4 +2,11 @@ * DB migration from v01 to v02 (mysql) */ -ALTER TABLE users ADD DisabledDetailStat INT(3) DEFAULT 0; +ALTER TABLE tariffs ADD period VARCHAR(32) NOT NULL DEFAULT 'month'; + +CREATE TABLE info +( + version INTEGER NOT NULL +); + +INSERT INTO info VALUES (1);