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);
\ No newline at end of file