X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/3aabf07e1038abf8cf471e463e00309df77df603..61ae5e7af0dd759ddb1acfcea10adcbede9da58c:/db/migrate.sql?ds=sidebyside diff --git a/db/migrate.sql b/db/migrate.sql index f6d2fc408..0f78b9dd3 100644 --- a/db/migrate.sql +++ b/db/migrate.sql @@ -35,3 +35,9 @@ alter table users add data_public boolean default false; alter table gpx_files drop column tmpname; alter table users add column description text not null; +create table diary_entries(id bigint not null auto_increment, user_id bigint not null, title varchar(255), body text, primary key(id)); +alter table diary_entries add created_at datetime; +alter table diary_entries add updated_at datetime; + +alter table users add column (home_node_id bigint(64) default NULL); +