X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/4434bac3b484006d579b9229a5f69b182644eae7..a8d6714aebfacfc32808a5aca41f6dae785a14cf:/db/migrate.sql diff --git a/db/migrate.sql b/db/migrate.sql index 6073c96a7..dc81e5d0c 100644 --- a/db/migrate.sql +++ b/db/migrate.sql @@ -33,3 +33,11 @@ create index users_display_name_idx on users(display_name); 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; + + +