diff --git a/db-migrate.sql b/db-migrate.sql index 54a31a0..79d2230 100644 --- a/db-migrate.sql +++ b/db-migrate.sql @@ -1,6 +1,7 @@ -- Migration from v1 to v2 alter table users add column email_inter INT DEFAULT 30; alter table users add column email_range VARCHAR(30) DEFAULT ''; +alter table users add column ts_email TIMESTAMP DEFAULT '2000-01-01 00:00:00'; alter table notifs add column subspace INT; alter table notifs add column is_hidden BOOLEAN DEFAULT FALSE; alter table notifs add index (dst,post);