X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/19b1d5971c25819b3ccfe48cac16ff4e2daa6ec4..5dfab5bea026e33031d041b233c73e196469b4ac:/projects/stargazer/inst/var/01-alter-02.mysql.sql

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);