Skip to content

Instantly share code, notes, and snippets.

@trekdemo
Created February 27, 2013 13:57
Show Gist options
  • Save trekdemo/5048069 to your computer and use it in GitHub Desktop.
Save trekdemo/5048069 to your computer and use it in GitHub Desktop.
Jobsworth migrations sorted by git authored date
for file in db/migrate/*; do
echo "$(date -r $(git log --format=%at $file | tail -n1) +%Y%m%d%H%M%S) $file";
done;
20070401155320 db/migrate/004_add_timezone.rb
20070401155320 db/migrate/005_user_interface_type.rb
20070401155320 db/migrate/006_user_external_clients.rb
20070401155320 db/migrate/007_user_show_calendar.rb
20070401155320 db/migrate/008_client_css.rb
20070401155320 db/migrate/009_add_tasks_company_id.rb
20070401155320 db/migrate/010_add_company_logo.rb
20070401155320 db/migrate/011_add_work_log_type.rb
20070401155320 db/migrate/012_add_components_position.rb
20070401155320 db/migrate/013_add_sessions.rb
20070401155320 db/migrate/014_add_basic_indexes.rb
20070401155320 db/migrate/015_create_shouts.rb
20070401155320 db/migrate/016_option_hide_tooltips.rb
20070401155320 db/migrate/017_add_task_priority.rb
20070401155320 db/migrate/018_change_duration_to_minutes.rb
20070401155320 db/migrate/019_create_news_items.rb
20070401155320 db/migrate/020_add_user_seen_news_id.rb
20070401155320 db/migrate/021_create_project_permissions.rb
20070401155320 db/migrate/022_add_selected_project.rb
20070401155320 db/migrate/023_add_user_last_seen.rb
20070401155320 db/migrate/024_add_task_created_by.rb
20070401155320 db/migrate/025_add_user_ping.rb
20070401155320 db/migrate/026_add_company_subdomain.rb
20070401155320 db/migrate/027_add_last_milestone_and_view.rb
20070401155320 db/migrate/028_create_tags.rb
20070401155320 db/migrate/029_priority_fix.rb
20070401155320 db/migrate/030_add_severity_and_type.rb
20070401155320 db/migrate/031_update_log_types.rb
20070401155320 db/migrate/032_add_task_number.rb
20070401155320 db/migrate/033_create_views.rb
20070401155320 db/migrate/034_add_task_status.rb
20070401155320 db/migrate/035_update_task_status.rb
20070401155320 db/migrate/036_add_task_required_by.rb
20070401155320 db/migrate/037_add_tasks_created_by.rb
20070401155320 db/migrate/038_add_notifications.rb
20070401155320 db/migrate/039_add_external_watchers.rb
20070401155320 db/migrate/040_add_task_files.rb
20070401155320 db/migrate/041_add_project_fine_permissions.rb
20070401155320 db/migrate/042_add_date_format.rb
20070401155320 db/migrate/043_initial_scm_model.rb
20070401155320 db/migrate/044_scm_indexes.rb
20070401155320 db/migrate/045_add_worklog_changeset_id.rb
20070401155320 db/migrate/046_add_task_multiple_owners.rb
20070401155320 db/migrate/047_add_task_owner_indexes.rb
20070401155320 db/migrate/048_notification_prefs.rb
20070401155320 db/migrate/049_add_uuid.rb
20070401155320 db/migrate/050_add_welcome_splash.rb
20070401155320 db/migrate/051_add_task_tags_indexes.rb
20070401155320 db/migrate/052_add_project_permission_indexes.rb
20070401155320 db/migrate/053_add_pages_indexes.rb
20070401155320 db/migrate/054_add_views_indexes.rb
20070401155320 db/migrate/055_add_milestones_indexes.rb
20070401155320 db/migrate/056_add_work_logs_company_id_index.rb
20070401155320 db/migrate/057_add_tasks_project_id_index.rb
20070401155320 db/migrate/058_add_work_log_indexes.rb
20070401155320 db/migrate/059_add_project_files_company_id_index.rb
20070401155320 db/migrate/060_add_tasks_company_id_index.rb
20070401155320 db/migrate/061_add_shouts_company_id_index.rb
20070401155320 db/migrate/1_create_milestones.rb
20070401155320 db/migrate/2_task_description.rb
20070401155320 db/migrate/3_fix_non_null_body.rb
20070401211819 db/migrate/062_add_generated_reports.rb
20070401211819 db/migrate/063_remove_component_references.rb
20070401213055 db/migrate/064_add_generated_report_created_at.rb
20070402113016 db/migrate/065_drop_tasks_user_id.rb
20070403221454 db/migrate/066_add_project_and_milestone_completed_at.rb
20070407225702 db/migrate/067_add_user_locale.rb
20070410233014 db/migrate/068_create_wiki_pages.rb
20070412142030 db/migrate/069_create_wiki_references.rb
20070415140631 db/migrate/070_add_worked_nice_option.rb
20070422123846 db/migrate/071_add_workday_duration.rb
20070626214118 db/migrate/072_add_task_dependencies.rb
20070630230445 db/migrate/073_add_task_repeat.rb
20070709220750 db/migrate/074_move_files_out_of_db.rb
20070713121611 db/migrate/075_views_hide_dependencies.rb
20070716181229 db/migrate/076_create_project_folders.rb
20070716181352 db/migrate/077_add_project_file_mime_type.rb
20070716224429 db/migrate/078_change_folders_to_acts_as_tree.rb
20070718190405 db/migrate/079_create_ical_entries.rb
20070725104046 db/migrate/080_drop_binaries_and_thumbnails.rb
20070727142856 db/migrate/081_import_beast_schema.rb
20070727142856 db/migrate/082_initialize_forums.rb
20070728151048 db/migrate/083_add_views_sort_column.rb
20070728173042 db/migrate/084_add_newsletter_option.rb
20070728173042 db/migrate/085_add_avatars_option.rb
20071117131607 db/migrate/086_add_task_hide_until.rb
20071120171341 db/migrate/087_create_shout_channels.rb
20071121164804 db/migrate/088_add_channel_users.rb
20071127173300 db/migrate/089_add_worksheet_pause.rb
20071212161425 db/migrate/090_create_event_logs.rb
20071212161425 db/migrate/091_work_log_to_event_log.rb
20071212161425 db/migrate/092_add_upload_user_id.rb
20071212161425 db/migrate/093_import_old_events.rb
20071213114823 db/migrate/094_add_autologin_hash.rb
20071218170725 db/migrate/095_create_todos.rb
20071223141705 db/migrate/096_create_emails.rb
20080108221942 db/migrate/097_cache_milestone_project_stats.rb
20080412152826 db/migrate/098_add_forum_monitorships.rb
20080415195719 db/migrate/099_create_widgets.rb
20080426192208 db/migrate/100_add_project_description.rb
20080501212103 db/migrate/101_add_remember_me.rb
20080502162716 db/migrate/102_add_indexes.rb
20080519113438 db/migrate/103_add_tag_indexes.rb
20080522111420 db/migrate/104_add_company_settings.rb
20080522111627 db/migrate/105_remove_option_show_calendar.rb
20080526124810 db/migrate/106_add_wiki_change_summary.rb
20080526124937 db/migrate/107_fix_restore_from_archive_events.rb
20080530115237 db/migrate/108_create_chats.rb
20080530115237 db/migrate/109_create_chat_messages.rb
20080530115237 db/migrate/110_add_company_messaging_option.rb
20080531161822 db/migrate/111_add_user_floating_chat_option.rb
20080602155646 db/migrate/112_add_week_days_option.rb
20080603213733 db/migrate/113_add_work_log_comment_flag.rb
20080603213733 db/migrate/114_set_comment_flag_for_work_logs.rb
20080616101530 db/migrate/115_add_auto_create_forums_option.rb
20080617124928 db/migrate/116_convert_earlier_work_durations.rb
20080619132201 db/migrate/117_limit_online_users.rb
20080622130357 db/migrate/118_create_locales.rb
20080622130357 db/migrate/119_translate_widgets.rb
20080624114523 db/migrate/120_add_locale_same_as_english.rb
20080625110438 db/migrate/121_add_archive_messages.rb
20080701205538 db/migrate/122_add_enable_sounds_option.rb
20080703150917 db/migrate/123_add_google_gadgets.rb
20080704130252 db/migrate/124_add_public_flag_for_news.rb
20080707172301 db/migrate/125_add_temp_due_dates_for_scheduling.rb
20080725112247 db/migrate/126_convert_wiki_notes_to_html.rb
20080731154146 db/migrate/127_cache_worked_duration.rb
20080802184811 db/migrate/128_recache_worked_minutes.rb
20080805120432 db/migrate/129_add_user_can_create_projects.rb
20080828092937 db/migrate/130_add_task_type_icon_preference.rb
20081028202224 db/migrate/131_add_todo_completed_by.rb
20081121152049 db/migrate/20081121133029_cache_project_task_counts.rb
20081121152049 db/migrate/20081121140153_cache_project_milestone_counts.rb
20081123115418 db/migrate/20081123091936_add_filter_by_severity_priority.rb
20081209140751 db/migrate/20081207130300_copy_task_owner_to_watcher.rb
20081212041707 db/migrate/20081211234927_create_properties.rb
20081212041707 db/migrate/20081211235109_create_property_values.rb
20081212235546 db/migrate/20081212062227_create_task_properties_value_join_table.rb
20090103151447 db/migrate/20090103140701_hide_dependencies_and_deferred_fixup.rb
20090110044204 db/migrate/20090110031641_add_icon_url_to_property_values.rb
20090110053249 db/migrate/20090110041909_add_colors_and_icons_to_views.rb
20090110054500 db/migrate/20090110043543_create_property_indexes.rb
20090114060029 db/migrate/20090114040153_convert_type_priority_severity_to_properties.rb
20090212031647 db/migrate/20090212013208_add_receive_own_notifications_to_user.rb
20090222225743 db/migrate/20090222213047_add_unread_flag_to_owners_and_notifications.rb
20090308230304 db/migrate/20090308000802_create_resource_types.rb
20090308230304 db/migrate/20090308001221_create_resource_type_attributes.rb
20090308230304 db/migrate/20090308001406_create_resources.rb
20090308230304 db/migrate/20090308001428_create_resource_attributes.rb
20090312064210 db/migrate/20090312051643_add_task_resource_join_table.rb
20090318224245 db/migrate/20090318211346_add_use_resources_option_to_users.rb
20090319005308 db/migrate/20090318233156_add_customer_id_to_user.rb
20090402060617 db/migrate/20090402033758_create_custom_attributes.rb
20090402060617 db/migrate/20090402033916_create_custom_attribute_values.rb
20090406233800 db/migrate/20090406211451_add_orphaned_users_to_internal_client.rb
20090407031453 db/migrate/20090406223947_create_organizational_units.rb
20090423061746 db/migrate/20090423035825_change_view_columns_to_string.rb
20090424100714 db/migrate/20090424075511_add_columns_to_organizational_units.rb
20090425034914 db/migrate/20090425013258_add_show_all_unread_to_view.rb
20090425054821 db/migrate/20090425034010_add_active_to_users_resources_customers.rb
20090427092745 db/migrate/20090427062608_add_notified_last_change_for_task_users.rb
20090427100433 db/migrate/20090427074955_create_worklog_notification_user_join_table.rb
20090427102706 db/migrate/20090427082254_prompt_to_setup_env_local.rb
20090504080556 db/migrate/20090504060420_change_attribute_value_column_type.rb
20090511054850 db/migrate/20090511031856_add_mandatory_to_properties.rb
20090514001722 db/migrate/20090513215204_add_user_company_id_index.rb
20090514025154 db/migrate/20090513230458_add_client_access_rights_to_users.rb
20090528103214 db/migrate/20090528073958_add_foreign_keys_for_company.rb
20090601004220 db/migrate/20090531222029_add_work_log_approval_fields.rb
20090601032206 db/migrate/20090601005322_create_custom_attribute_choices.rb
20090601034751 db/migrate/20090601014309_add_choice_id_to_custom_attribute_value.rb
20090604051754 db/migrate/20090604031508_create_company_task_num_index.rb
20090615103911 db/migrate/20090517215106_change_group_column_to_string.rb
20090615103911 db/migrate/20090615082603_add_uuid_and_autologin_if_missing.rb
20090615121536 db/migrate/20090615091416_add_customers_foreign_key_to_user.rb
20090618232953 db/migrate/20090615102406_add_id_to_work_logs_notifications.rb
20090619000926 db/migrate/20090618215014_add_indexes_to_custom_attributes.rb
20090619005016 db/migrate/20090618224216_add_foreign_keys_for_customers.rb
20090619010118 db/migrate/20090618225835_make_uuid_and_autologin_not_null_in_db.rb
20090619010829 db/migrate/20090618230241_add_resource_indexes.rb
20090626032317 db/migrate/20090626005038_create_preferences.rb
20090701100249 db/migrate/20090630082324_create_task_customers.rb
20090824054806 db/migrate/20090824011735_create_task_filters.rb
20090824054806 db/migrate/20090824011923_create_task_filter_qualifiers.rb
20090826010654 db/migrate/20090825212110_create_keywords.rb
20090826023310 db/migrate/20090825235523_create_statuses.rb
20090826220841 db/migrate/20090826193412_add_system_column_to_task_filters.rb
20090918080023 db/migrate/20090918041604_create_time_ranges.rb
20090918080023 db/migrate/20090918041833_add_qualifiable_column_to_task_filter_qualifiers.rb
20090922013843 db/migrate/20090921225112_add_colour_to_custom_attibute_choices.rb
20090922033606 db/migrate/20090922012651_add_auto_add_option_to_user.rb
20090922071324 db/migrate/20090922035730_create_triggers.rb
20091008102838 db/migrate/20091008071357_add_notable_to_pages.rb
20091010091843 db/migrate/20091010063549_change_project_notes_to_use_notable.rb
20091013101526 db/migrate/20091013080727_add_date_format_time_format_not_null_on_users.rb
20091022030652 db/migrate/20091022005808_shorten_locales_column.rb
20091205061746 db/migrate/20091205034938_add_unread_to_task_filter.rb
20100119122439 db/migrate/20100119110826_widen_preferences_value.rb
20100217142528 db/migrate/20100217125410_add_task_template.rb
20100225115746 db/migrate/20100222141031_add_type_instead_template_to_task.rb
20100302121412 db/migrate/20100302103302_add_index_tasks_on_type_and_task_num_and_company_id.rb
20100311184934 db/migrate/20100311174232_remove_binary_id_from_customers_and_project_files.rb
20100322084052 db/migrate/20100322071846_fix_property_position.rb
20100323120536 db/migrate/20100322160212_delete_in_progress.rb
20100325094153 db/migrate/20100325072050_delete_in_progress_from_filters.rb
20100405031023 db/migrate/20100403235106_remove_chat.rb
20100406125002 db/migrate/20100406092841_create_task_users.rb
20100406152556 db/migrate/20100406105223_migrate_to_task_users.rb
20100410152817 db/migrate/20100410224800_index_task_property_values.rb
20100413144331 db/migrate/20100413120604_add_can_see_unwatched_to_project_permission.rb
20100414143600 db/migrate/20100414100608_create_access_levels.rb
20100414152553 db/migrate/20100414111220_add_access_level_for_user_and_work_log.rb
20100421111347 db/migrate/20100421075542_add_indexes_to_task_users.rb
20100421154955 db/migrate/20100421132755_change_access_level_names.rb
20100424175316 db/migrate/20100424151504_remove_view.rb
20100426184042 db/migrate/20100426162324_remove_notified_last_change.rb
20100504174942 db/migrate/20100504153034_remove_prioritize_permission.rb
20100507165448 db/migrate/20100507132634_change_scm_arch.rb
20100507174354 db/migrate/20100507151253_add_secret_key_to_scm_project.rb
20100511130603 db/migrate/20100511102106_move_scm_changeset_from_work_log_to_task.rb
20100513100736 db/migrate/20100513072519_add_paperclip.rb
20100515110543 db/migrate/20100515083501_move_old_files_to_paperclip.rb
20100608115940 db/migrate/20100608094224_drop_notifications.rb
20100621124829 db/migrate/20100621103330_change_scm_file_status.rb
20100622122115 db/migrate/20100622091814_add_snippet_flag_to_pages.rb
20100810235108 db/migrate/20100810023438_remove_recent_activities_from_widgets.rb
20100817124406 db/migrate/20100817101746_add_paperclip_avatar_to_user.rb
20100818143431 db/migrate/20100818110959_add_paperclip_logo_to_client.rb
20100818153358 db/migrate/20100818131406_copy_avatars_and_logos.rb
20100819120414 db/migrate/20100819092939_add_reversed_option_to_qualifier.rb
20100916022427 db/migrate/20100914011439_create_email_addresses.rb
20100920143951 db/migrate/20100920121117_add_recent_for_user_id_to_filter.rb
20101001065908 db/migrate/20101001043531_task_users_type_dafault_is_task_owner.rb
20101102131348 db/migrate/20101102104028_add_triggers_permission.rb
20101109041719 db/migrate/20101109014031_remove_unused_columns_from_project_files.rb
20101110133150 db/migrate/20101110121308_set_file_size_not_null_in_project_files.rb
20101126003901 db/migrate/20101123210702_add_md5_to_project_files.rb
20101126081001 db/migrate/20101126021650_rename_md5_and_remove_name_from_project_files.rb
20101126225138 db/migrate/20101126083740_populating_uri_in_project_files_table.rb
20101206160245 db/migrate/20101206145217_change_trigger_action_type.rb
20101207150534 db/migrate/20101207135130_create_trigger_actions.rb
20101207151534 db/migrate/20101207140802_trigger_has_many_actions.rb
20101207180244 db/migrate/20101207164950_trigger_rename_fire_on_to_event_id.rb
20101210011031 db/migrate/20101209215539_drop_emails.rb
20101215143358 db/migrate/20101215123339_create_email_deliveries.rb
20101215164013 db/migrate/20101215124006_create_email_address_tasks.rb
20101215172907 db/migrate/20101215161248_remove_task_notify_emails.rb
20101217021821 db/migrate/20101215071513_add_email_address_id_to_work_logs.rb
20101217021821 db/migrate/20101215224745_allow_null_for_user_id_in_work_logs_table.rb
20101220085534 db/migrate/20101220073904_add_weight_to_task.rb
20101229151841 db/migrate/20101229132848_add_work_log_id_to_project_files.rb
20110118150732 db/migrate/20110118133832_remove_tasks_repeat.rb
20110120172400 db/migrate/20110120150416_remove_user_external_clients.rb
20110125132034 db/migrate/20110125115820_remove_send_notifications.rb
20110125192512 db/migrate/20110125152312_add_companies_suppressed_email_addresses.rb
20110126135125 db/migrate/20110126113459_drop_work_log_notifications.rb
20110126145817 db/migrate/20110126131915_add_username_or_email_to_email_deliveries.rb
20110127154446 db/migrate/20110127125739_add_email_delivery_user_association.rb
20110127154446 db/migrate/20110127125848_remove_email_delivery_email_address_association.rb
20110203074335 db/migrate/20110203062806_change_due_tasklistcol_preference.rb
20110203122253 db/migrate/20110128170625_add_wait_for_customer_option_to_task.rb
20110211045334 db/migrate/20110208231351_create_task_filter_users.rb
20110216112802 db/migrate/20110216083130_change_work_log_approved_from_boolean_to_int.rb
20110221102913 db/migrate/20110221091019_add_timestamp_to_milestone.rb
20110408110927 db/migrate/20110408085342_fix_user_time_date.rb
20110411191016 db/migrate/20110411155411_devise_create_users.rb
20110413141815 db/migrate/20110413121531_removing_last_login_at.rb
20110414080642 db/migrate/20110411162011_migration_from_password_to_ecnryted_password.rb
20110418104454 db/migrate/20110418071351_triggers_dump.rb
20110418154720 db/migrate/20110418123354_remove_project_owner.rb
20110420172604 db/migrate/20110420140129_replace_old_file_name_to_md5.rb
20110507140007 db/migrate/20110506144503_remove_forums.rb
20110516202922 db/migrate/20110516181817_create_score_rules.rb
20110525040741 db/migrate/20110525020146_change_exponent_score_rules.rb
20110601232804 db/migrate/20110601203141_add_default_estimate_to_projects.rb
20110602025147 db/migrate/20110601234102_add_working_hours_to_users.rb
20111108083110 db/migrate/20111108045851_refactor_icon_url.rb
20111114043457 db/migrate/20111114032946_truncate_session_table.rb
20111214075653 db/migrate/20111214063943_remove_requested_by_in_task.rb
20120201075733 db/migrate/20120201064818_add_index_to_email_delivery.rb
20120209071142 db/migrate/20120209051848_add_reset_password_sent_at_to_users.rb
20120217075655 db/migrate/20120217063428_remove_projects_widget.rb
20120227091209 db/migrate/20120224081942_remove_logo_and_css_from_customer.rb
20120227091209 db/migrate/20120224082525_add_logo_to_company.rb
20120307082358 db/migrate/20120307060756_remove_contact_email_from_customer.rb
20120307083406 db/migrate/20120307070756_remove_option_tooltips_from_users.rb
20120312145112 db/migrate/20120312103046_remove_jq_grid_preference_records.rb
20120315085851 db/migrate/20120315074331_add_started_at_index_to_worklogs.rb
20120421111902 db/migrate/20120420063034_create_services.rb
20120421111902 db/migrate/20120420063738_create_service_level_agreements.rb
20120421111902 db/migrate/20120420064221_add_never_bill_to_project.rb
20120427110039 db/migrate/20120423075901_add_service_id_to_tasks.rb
20120529143049 db/migrate/20120524053756_remove_log_type_and_comment_from_work_logs.rb
20120531075056 db/migrate/20120531053901_add_suppress_billing_to_project.rb
20120531102104 db/migrate/20120531065441_add_is_quoted_to_tasks.rb
20120628080912 db/migrate/20120628060528_fix_invalid_email_address.rb
20120716085407 db/migrate/20120716051836_remove_project_folders.rb
20120716133547 db/migrate/20120716090751_create_snippets.rb
20120716133547 db/migrate/20120716091611_move_snippets_to_snippets_table.rb
20120801103427 db/migrate/20120801065309_remove_use_triggers_from_users.rb
20120801103427 db/migrate/20120801071148_add_company_id_to_news_items_table.rb
20120801124514 db/migrate/20120801101413_add_company_id_to_email_addresses.rb
20120802101449 db/migrate/20120802073814_drop_pages_table.rb
20120802103609 db/migrate/20120802083306_remove_logged_exceptions_table.rb
20120802111437 db/migrate/20120802091137_remove_page_related_event_logs.rb
20120803121200 db/migrate/20120803095020_change_supressed_email_addresses_to_text.rb
20120807075126 db/migrate/20120807051723_set_project_default_estimate.rb
20120807100708 db/migrate/20120807073934_remove_useless_scheduled_fields.rb
20120807104530 db/migrate/20120807081229_remove_estimate_from_tasks.rb
20120810090328 db/migrate/20120810061542_change_work_log_duration_unit_to_minute.rb
20120813090627 db/migrate/20120813064144_recaculate_worked_minutes_of_task.rb
20120820141536 db/migrate/20120820070553_create_work_plans.rb
20120821150615 db/migrate/20120821052043_remove_working_hours_from_user.rb
20120827095900 db/migrate/20120827060107_remove_work_day_duration_from_users.rb
20120829115334 db/migrate/20120829071238_update_work_log_orphaned_email_reference.rb
20120905161529 db/migrate/20120905114423_add_estimate_date_to_tasks.rb
20120905161529 db/migrate/20120905141101_schedule_tasks.rb
20120918141517 db/migrate/20120918081119_add_status_and_statrted_at_to_milestones.rb
20120918141517 db/migrate/20120918100141_set_status_for_existing_milestones.rb
20121002120307 db/migrate/20121002082358_create_delayed_jobs.rb
20121011143008 db/migrate/20121011102818_fix_user_email_nil.rb
20121030161859 db/migrate/20121030142431_rename_task_to_task_record.rb
20121107074746 db/migrate/20121107064504_remove_paused_duration_from_work_logs.rb
20121110114649 db/migrate/20121110100646_fix_duplicate_template_task_num.rb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment