X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/19b1d5971c25819b3ccfe48cac16ff4e2daa6ec4..9b3f8c7252b92a7b32996aa3c2b5e5c16361c82d:/projects/stargazer/inst/var/01-alter-02.mysql.sql?ds=sidebyside 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);