OpenProject is the leading open source project management software.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
openproject/db/migrate
Oliver Günther e949340f85
Merge remote-tracking branch 'origin/release/12.4' into dev
2 years ago
..
aggregated Update copyright information for 2023 2 years ago
migration_utils Update copyright information for 2023 2 years ago
tables Update copyright information for 2023 2 years ago
10000000000000_to_v710_aggregated_migrations.rb Update copyright information for 2023 2 years ago
20100528100562_aggregated_global_roles_migrations.rb Update copyright information for 2023 2 years ago
20170703075208_add_attribute_help_texts.rb use integer for primary key columns (#6217) 7 years ago
20170705134348_remove_attribute_visibility.rb [25374] Remove attribute visibility 8 years ago
20170818063404_add_timeline_labels_to_query.rb [25999] Make timeline labels configurable 7 years ago
20170829095701_generate_wp_closure.rb Update copyright information for 2023 2 years ago
20171106074835_move_hashed_token_to_core.rb rename and inflect according to zeitwerk 5 years ago
20171129145631_add_fulltext_to_attachments.rb Update copyright information for 2023 2 years ago
20180105130053_rebuild_dag.rb Update copyright information for 2023 2 years ago
20180108132929_vacuum_relations.rb Update copyright information for 2023 2 years ago
20180116065518_add_hierarchy_paths.rb Update copyright information for 2023 2 years ago
20180117065255_remove_timelines_and_reportings.rb Update copyright information for 2023 2 years ago
20180122135443_add_tsv_columns_to_attachments.rb Update copyright information for 2023 2 years ago
20180123092002_add_custom_actions.rb use integer for primary key columns (#6217) 7 years ago
20180213155320_add_description_to_custom_actions.rb add description on custom action 7 years ago
20180221151038_add_position_to_custom_action.rb allow sorting custom actions 7 years ago
20180305130811_remove_wiki_content_versions.rb Update copyright information for 2023 2 years ago
20180419061910_timestamp_for_caching.rb Update copyright information for 2023 2 years ago
20180504144320_add_color_to_statuses_and_enumerations.rb Add color to priority 7 years ago
20180510184732_rename_planning_elemnt_type_colors_to_colors.rb Fix more mysql migration issues 6 years ago
20180518130559_add_timestamps_to_wiki.rb cache wiki page hierarchy 7 years ago
20180524084654_remove_non_null_container_on_attachments.rb Update copyright information for 2023 2 years ago
20180524113516_add_consent_timestamp_to_user.rb user consent WIP 7 years ago
20180706150714_convert_to_markdown.rb Update copyright information for 2023 2 years ago
20180717102331_remove_in_aggregation_from_type.rb remove in_aggregation from type 6 years ago
20180801072018_remove_responsible_and_type_from_project.rb Remove project responsible and type 6 years ago
20180830120550_migrate_light_background_themes.rb rename according to zeitwerk 5 years ago
20180903110212_add_highlighting_to_query.rb Move adding "highlighted_attributes" to a separate migration as some people might have run the first migration already. 6 years ago
20180924141838_add_highlighted_attributes_to_query.rb Move adding "highlighted_attributes" to a separate migration as some people might have run the first migration already. 6 years ago
20181101132712_add_read_only_to_statuses.rb Implement read-only work package attributes based on status 6 years ago
20181112125034_create_doorkeeper_tables.rb safe automatic fixes by rubocop (#8994) 4 years ago
20181118193730_create_grid.rb implement filter on grids 6 years ago
20181121174153_create_ordered_work_packages.rb safe automatic fixes by rubocop (#8994) 4 years ago
20190124081710_remove_accessibility_mode.rb Add migration to remove impaired column from database 6 years ago
20190129083842_add_project_to_grid.rb Boards module (#7008) 6 years ago
20190205090102_add_options_to_grid.rb Boards module (#7008) 6 years ago
20190207155607_add_hidden_to_queries.rb Add hidden flag for project-context queries 6 years ago
20190220080647_migrate_my_page_layout.rb safe automatic fixes by rubocop (#8994) 4 years ago
20190227163226_add_tls_mode_to_auth_sources.rb [29622] Implement start_tls for ldap_auth_source 6 years ago
20190301122554_remove_hierarchy_paths.rb Remove hierarchy paths and migrate away from parent column 6 years ago
20190312083304_rename_boards_to_forums.rb safe automatic fixes by rubocop (#8994) 4 years ago
20190411122815_set_timeline_auto_zoom.rb Make autozoom a regular zoom level option 6 years ago
20190502102512_ensure_postgres_index_names.rb remove mysql specific code throughout the application 6 years ago
20190507132517_add_board_view_to_roles.rb default permission for existing roles 6 years ago
20190509071101_add_default_description_to_types.rb Add description to type defaults 6 years ago
20190527095959_set_manage_board_permission.rb default permission for existing roles 6 years ago
20190603060951_set_assign_versions_permission.rb default permission for existing roles 6 years ago
20190618115620_fix_available_languages.rb avoid overwriting default setting value 3 years ago
20190619143049_add_timestamps_to_query.rb add updated_at/created_at to query 6 years ago
20190710132957_rename_my_page_widgets.rb safe automatic fixes by rubocop (#8994) 4 years ago
20190716071941_add_display_representation_to_query.rb Add display representation to query 5 years ago
20190722082648_add_derived_estimated_hours_to_work_packages.rb safe automatic fixes by rubocop (#8994) 4 years ago
20190724093332_add_journal_versions_table.rb Implement separate version table for journals 5 years ago
20190920102446_clean_custom_values.rb use appropriate update method for relation 5 years ago
20190923111902_add_project_status_reporting.rb remove default code for existing projects 5 years ago
20190923123858_simplify_project_active_and_timestamp.rb rename project attributes 5 years ago
20191106132533_make_system_user_active.rb Placeholder user project members (#8961) 4 years ago
20191112111040_fix_system_user_status.rb Placeholder user project members (#8961) 4 years ago
20191115141154_add_content_orientation_to_custom_fields.rb Add DB field and checkbox for long text field CFs to save text orientation 5 years ago
20191216135213_join_table_for_active_activities.rb script and description for restoring data 5 years ago
20200114091135_add_theme_name_to_custom_styles.rb Fix #35131: Cleanup migration for BIM themes (#8834) 4 years ago
20200115090742_fix_parent_id_for_wiki_pages.rb Show only one possible option as parent wiki page && correct those entries that have an "0" instead of "nil" as parent_id 5 years ago
20200206101135_add_theme_logo_to_custom_style.rb Allow themes to define a logo (dark vs. light) when there is no custom logo defined 5 years ago
20200217061622_add_timestamp_to_news.rb rename news created_on column to created_at 5 years ago
20200217155632_rename_tokens.rb rename tokens in db 5 years ago
20200220171133_rename_bim_module.rb Fix bim module migration 5 years ago
20200302100431_fix_attachable_journals.rb fix corrupted attachable_journals 5 years ago
20200310092237_add_timestamps_to_bcf.rb Add timestamps to properly cache invalidate and add spec 5 years ago
20200325101528_strip_whitespace_from_user_attributes.rb [32748] Remove whitespace from login and mail 5 years ago
20200326102408_rename_fixed_version.rb properly escape replacement in sql 5 years ago
20200403105252_add_cron_to_delayed_jobs.rb Add cron job functionality to delayed_job 5 years ago
20200415131633_add_work_package_exports.rb Feature/delayed bcf export (#8275) 5 years ago
20200427121606_add_filter_to_ldap.rb Add LDAP auth source filter functionality 5 years ago
20200428105404_unique_member_role.rb Handle add_users with a separate service with CTE 5 years ago
20200504085933_add_schedule_manually_to_work_packages.rb added :schedule_manually attribute to work package 5 years ago
20200522131255_splash_multi_list_customizable_journals.rb rewrite acts as journalized to create journals in sql 5 years ago
20200522140244_remove_journal_versions_table.rb rewrite acts as journalized to create journals in sql 5 years ago
20200527130633_add_templated_to_project.rb Add templated property to projects 5 years ago
20200625133727_fix_inherited_group_member_roles.rb Feature/member notifications (#8958) 4 years ago
20200708065116_fix_members_inconsistencies.rb Add link to the project in group membership tab 4 years ago
20200803081038_journalize_scheduling_mode.rb journalize changes to the scheduling mode 4 years ago
20200820140526_remove_summable_setting.rb add migration that should have been part of 38d2707946 4 years ago
20200903064009_enable_current_project_custom_fields_columns.rb avoid overwriting default setting value 3 years ago
20200907090753_change_attachment_filesize_to_big_int.rb increase filesize column size to allow for large (>1gb) attachments 4 years ago
20200914092212_set_current_timestamp_defaults_for_bcf_viewpoints_and_issues.rb Fix: Set current timestamps as default values for BCF timestamps. 4 years ago
20200924085508_cleanup_orphaned_journal_data.rb [22048] Destroy journals after destroying journalized 4 years ago
20200925084550_members_allow_null_on_project.rb safe automatic fixes by rubocop (#8994) 4 years ago
20201001184404_rename_timestamp_on_time_and_cost_entry.rb Chore/rename timestamp on time entry (#8754) 4 years ago
20201005120137_ensure_integer_for_relations_foreign_keys.rb Update copyright information for 2023 2 years ago
20201005184411_rename_timestamps.rb Ensure we reset column names when renaming timestamps 3 years ago
20201125121949_remove_renamed_cron_job.rb Update copyright information for 2023 2 years ago
20210126112238_add_uniqueness_constrain_on_lastname_for_groups_and_placeholder_users.rb Placeholder user backend (#8935) 4 years ago
20210127134438_alter_user_attributes_max_length.rb [36081] Increase max lengths of user/group names (#8948) 4 years ago
20210214205545_replace_invalid_principal_references.rb [36238] Extract and fix user references in other objects (#9007) 4 years ago
20210221230446_add_group_user_primary_key.rb Group API (#9034) 4 years ago
20210310101840_generalize_exports.rb create backups via UI (#9136) 4 years ago
20210331085058_migrate_sessions_unlogged.rb User SqlBypass sessions to avoid ActiveRecord for session storage (#9142) 4 years ago
20210427065703_make_system_user_admin.rb Use update_column to avoid cached column lookup 3 years ago
20210510193438_remove_project_setting.rb [37140] Use acts_as_url to generate unique slug for identifier (#9250) 4 years ago
20210512121322_make_project_identifier_unique.rb Extend error message when migration fails due to two schemas 3 years ago
20210519141244_remove_reply_from_message_journalizing.rb remove reply from message journaling (#9293) 4 years ago
20210615150558_aggregate_journals.rb Migrate UserPreference to JSON storage 3 years ago
20210616145324_polymorphic_journal_data.rb improve performance of polymporphic journal data migration 3 years ago
20210616191052_create_notifications.rb [26688] In-app notifications (#9399) 3 years ago
20210618125430_authors_as_watchers.rb increase author as watchers migration performance 3 years ago
20210618132206_add_notification_settings.rb Remove mail_notification column 3 years ago
20210628185054_extend_custom_field_name_length.rb Remove length restriction on CustomField#name 3 years ago
20210701073944_add_digest_setting.rb Remove more notification migrations 3 years ago
20210701082511_add_digest_to_notification.rb Feature/1899 send daily email summaries (#9430) 3 years ago
20210713081724_flip_bcf_viewpoint_clipping_direction_selectively.rb WIP Add migration for flipping clipping planes that were created in OP (#9682) 3 years ago
20210726070813_remove_journal_versions.rb Fix executing the removal of journal_versions 3 years ago
20210802114054_add_notification_setting_options.rb Remove notified_events usage in settings 3 years ago
20210825183540_make_user_preferences_json.rb have boolean values for warn_on_leaving_unsaved 3 years ago
20210902201126_cleanup_user_preferences.rb [38712] Immediate reminder options 3 years ago
20210910092414_add_bcf_comment_hierarchy.rb [#38833] BCF API Comments Service 3 years ago
20210914065555_cleanup_notifications.rb Remove more notification migrations 3 years ago
20210915154656_add_user_preference_settings_indices.rb add indices to support finding notification recipients 3 years ago
20210917190141_non_work_package_notification_settings.rb Add new notification settings for non-wp settings 3 years ago
20210922123908_notification_foreign_key_constraint.rb remove invalid notifications before setting constraint 3 years ago
20210928133538_add_reminder_workdays.rb Linting 3 years ago
20211005080304_tzinfo_time_zones.rb Update copyright information for 2023 2 years ago
20211005135637_remove_invalid_group_users.rb handle invalid group_users entries, prevent new ones 3 years ago
20211022143726_remove_snapshot_data.rb [39451] remove base64 snapshot data from bcf vp 3 years ago
20211026061420_add_indexes_for_email_reminder_pause.rb Add index on enabled boolean 3 years ago
20211101152840_redistribute_edit_project_permission.rb migrate existing permissions 3 years ago
20211102161932_remove_custom_field_types.rb remove acts_as_customizable from enumerable 3 years ago
20211103120946_clean_emails_footer.rb harmonize settings & configuration 3 years ago
20211104151329_default_notification_setting.rb Fix query in default notification setup 3 years ago
20211105142202_queue_notification_update_mail.rb Update db/migrate/20211105142202_queue_notification_update_mail.rb 3 years ago
20211117195121_remove_destroyed_help_texts.rb [40027] Delete attribute help text when custom field destroyed 3 years ago
20211118203332_clean_hide_mail.rb Add migration to fix hide_mail attribute again 3 years ago
20211130161501_add_views.rb only one view per query for now 3 years ago
20211209092519_query_views.rb down migration independent of removed menu type 3 years ago
20220106145037_fix_missing_notification_settings.rb [40433] Create users through create service in ldap group sync 3 years ago
20220121090847_create_projects_storages.rb Fixed unit tests for storages plugin (#10133) 3 years ago
20220202140507_reorder_project_children.rb Also reorder project roots and sort by lft only 3 years ago
20220223095355_projects_lft_rgt_index.rb display empty array when not having ancestors 3 years ago
20220302123642_assignable_to_permission.rb replace assignable column on role 3 years ago
20220319211253_add_parent_id_to_wp.rb Update copyright information for 2023 2 years ago
20220323083000_add_include_subprojects_to_query.rb Add new query attribute include_subprojects 3 years ago
20220408080838_bigint_primary_key_on_relations.rb Update copyright information for 2023 2 years ago
20220414085531_migrate_team_planner_permissions.rb Migrate team planner permissions 3 years ago
20220426132637_refix_inherited_group_member_roles.rb keep roles inherited from different group on role adding 3 years ago
20220428071221_restore_defaults_on_empty_settings.rb circumvent formatting issue 3 years ago
20220503093844_create_oauth_client.rb Update copyright information for 2023 2 years ago
20220511124930_create_week_days.rb implement GET /api/v3/days/week 3 years ago
20220517113828_create_non_working_days.rb Add non-working day show api endpoint 3 years ago
20220518154147_create_oauth_client_tokens.rb Adding ::OAuthClients::ConnectionManager and callback endpoint 3 years ago
20220525154549_add_duration_to_work_packages.rb calculate duration for existing work packages 3 years ago
20220608213712_add_logged_by_id_to_time_entries.rb [#21754] Log time for other users 2 years ago
20220614132200_add_ignore_non_working_days_to_work_packages.rb add ignore flag to work packages 3 years ago
20220615213015_migrate_log_time_to_log_own_time_in_role_permissions.rb [#21754] Log time for other users 2 years ago
20220620132922_change_duration_default_value.rb Reset the default values of work package and work package journal duration 2 years ago
20220622151721_drop_project_associations.rb drop project_associations table no longer in use 2 years ago
20220629061540_add_paper_trail.rb Add on_destroy paper_trail audits (#10876) 2 years ago
20220629073727_add_polymorphic_integration_to_oauth_application.rb Automatically add OAuth application with storages 2 years ago
20220707192304_backfill_time_entries_with_logged_by_id.rb Remove invalid time entry references before adding logged_by 2 years ago
20220712132505_add_foreign_key_constraint_for_type_color_id.rb [#40961] Ensure types reference existing colors 2 years ago
20220714145356_migrate_work_package_export_settings.rb [#43202] Project export confusingly uses "Work packages export limit" setting 2 years ago
20220804112533_remove_notification_cleanup_job.rb Update copyright information for 2023 2 years ago
20220811061024_rename_work_package_export_limit.rb Add migration from work_packages_export_limit to new setting 2 years ago
20220815072420_add_logged_by_to_time_entries_journals.rb Remove invalid time entry references before adding logged_by 2 years ago
20220817154403_remove_work_packages_duration_field_active_setting.rb Remove work_packages_duration_field_active feature flag from Settings 2 years ago
20220818074150_fix_invalid_journals.rb Destroy invalid journals 2 years ago
20220818074159_fix_deleted_data_journals.rb simplify migration code 2 years ago
20220830074821_add_ignore_non_working_days_to_work_package_journals.rb [#43883] add column ignore-non-working-days 2 years ago
20220830092057_change_default_for_non_working_days.rb Change default for ignore_non_working_days on work packages 2 years ago
20220831073113_work_package_project_foreign_key.rb Remove ShardState#rollback as its unused 2 years ago
20220831081937_migrate_timestamps_to_with_timezone.rb Migrate all datetime columns to timestampz 2 years ago
20220909153412_drop_week_days.rb [#43819] Basic administration for non working days (excluding danger zone) 2 years ago
20220911182835_create_default_working_days_setting_entry.rb Add working_days setting entry to the database if not exists 2 years ago
20220918165443_add_start_date_due_date_and_overdue_to_notification_settings.rb [#43673] Include date alert into NotificationSetting Representer & Database 2 years ago
20220922200908_split_involved_notification_setting.rb [#43675] fig regarding comments 2 years ago
20220926124435_constrain_work_package_dates.rb add constraint to work package start/due date 2 years ago
20220929114423_add_unique_index_to_ldap_groups_membership.rb Remove duplicates on migration 2 years ago
20220930133418_set_duration_for_milestone_work_packages.rb [#44347] Milestones existing before 12.3 will have nil for duration 2 years ago
20221017073431_remove_orphaned_tokens.rb Merge branch 'release/12.3' into dev 2 years ago
20221017184204_change_defaults_for_notification_settings.rb [#43676] Move all notification settings defaults to the database layer 2 years ago
20221018160449_add_logged_by_to_cost_entries.rb Add CostEntry#logged_by in fashion of time entries 2 years ago
20221026132134_bigint_primary_and_foreign_keys.rb use bigint for primary and foreign keys 2 years ago
20221027151959_remove_plaintext_tokens.rb remove plaintext_tokens left over from 1f2492bb 2 years ago
20221028070534_change_notification_settings_start_date_due_date_and_overdue_duration_unit_to_days.rb Change NotificationSettings duration units to days 2 years ago
20221115082403_add_ldap_tls_options.rb Add new LDAP option for certificate verification 2 years ago
20221129074635_remove_activity_type_from_journals_table.rb Remove journals.activity_type column from db 2 years ago
20221130150352_create_project_journals.rb Make projects identifier non nullable 2 years ago
20221201140825_add_non_null_constraint_on_projects_identifier.rb Make projects identifier non nullable 2 years ago
20221202130039_fill_project_journals_with_existing_data.rb Fill project journals with existing projects data 2 years ago
20221213092910_remove_default_values_from_journal_tables_definition.rb [#45234] Remove default values from journal tables definition 2 years ago
20230105073117_remove_renamed_date_alert_job.rb separate date alert creation for individual users 2 years ago
20230105134940_work_package_date_indices.rb speedup sql for alertable work packages 2 years ago