+/* this script when run on the current db migrates it to rails */
+
drop table meta_nodes;
alter table current_nodes modify tags text not null;
alter table current_nodes modify id bigint(64) not null auto_increment;
alter table gpx_files change private public boolean default 1 not null;
update gpx_files set public = !public;
+create index gpx_files_visible_public_idx on gpx_files(visible, public);
alter table gpx_file_tags change sequence_id sequence_id int(11);
alter table gpx_file_tags drop primary key;
alter table gpx_file_tags add id int(20) auto_increment not null, add primary key(id);
alter table users add preferences text;
+create index users_display_name_idx on users(display_name);
+
+alter table users add data_public boolean default false;
+