mir/moebooru
2
0
Fork 0
mirror of https://github.com/moebooru/moebooru synced 2025-08-22 01:47:48 +00:00
Code Issues Releases Wiki Activity
moebooru/db/migrate
History
nanaya 5593a81f1b Support searching by aspect ratio
2025-03-30 01:04:00 +09:00
..
001_add_post_links.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
002_create_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
003_extend_post_tag_histories.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
004_post_tag_history_constraints.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
005_create_forum_post.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
006_create_forum_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
007_add_spam_field_to_comments.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
008_upgrade_forums.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
009_add_last_seen_forum_post_date.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
010_add_user_fields.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
011_add_invites.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
012_rename_invite_email_field.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
013_drop_is_ambiguous_field_from_tags.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
014_add_pending_to_aliases_and_implications.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
015_rename_implication_fields.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
016_add_forum_posts_user_views.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
017_drop_last_seen_forum_post_date_from_users.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
018_add_constraints_to_forum_posts_user_views.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
019_add_id_to_forum_posts_user_views.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
020_change_artists_a.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
021_change_artists_b.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
022_add_notes_to_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
023_add_updated_at_to_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
024_drop_extra_indexes_on_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
025_add_updater_id_to_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
026_add_ambiguous_field_to_tags.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
027_add_response_count_to_forum.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
028_add_image_resize_user_setting.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
029_add_safe_post_count_to_tags.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
030_add_invited_by_to_users.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
031_create_news_updates.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
032_forum_posts_fix_creator_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
033_posts_add_is_flagged.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
034_pools_create.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
035_users_rename_password.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
036_users_update_level.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
037_users_add_created_at.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
038_favorites_add_created_at.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
039_posts_add_is_pending.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
040_cleanup.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
041_users_add_ip_addr.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
042_note_versions_add_index_on_user_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
043_flagged_posts_create.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
044_forum_add_is_locked.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
045_user_records_create.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
046_posts_tags_add_foreign_keys.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
047_posts_add_parent_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
048_posts_add_has_children.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
049_flagged_posts_drop_foreign_key.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
051_posts_drop_has_children.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
052_flagged_posts_add_user_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
053_convert_ip_text_to_inet.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
054_posts_add_status.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
055_add_full_text_search.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
056_add_text_search_to_versions.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
057_drop_post_count_triggers.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
058_remove_notes_from_artists.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
059_create_dmails.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
060_add_receive_mails_to_users.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
061_enhance_dmails.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
062_create_bans.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
063_add_blacklisted_tags_to_users.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
064_remove_neighbor_constraints.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
065_remove_yaml.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
066_fix_user_levels.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
067_create_artist_urls.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
068_add_pixiv_to_artists.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
069_clean_up_users.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
070_add_approved_by_to_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
071_create_flagged_post_details.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
072_add_reason_to_aliases_and_implications.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
073_fix_flagged_post_details_foreign_keys.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
074_remove_pixiv_field.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
075_add_sample_columns.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
076_create_user_blacklisted_tags.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
077_create_server_keys.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
078_add_neighbors_to_pools.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
079_create_post_change_seq.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
080_remove_neighbor_fields_from_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
081_disable_change_seq_cache.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
082_add_post_votes.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
083_add_user_id_to_aliases_and_implicatons.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
084_add_user_id_index_on_post_tag_histories.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
085_revert_post_votes.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
086_add_is_active_field_to_pools.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
087_add_dimensions_index_on_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
088_add_approver_id_to_posts.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
089_add_index_on_post_source.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
090_add_rating_to_tag_history.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
091_migrate_users_to_contributor.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
092_create_job_tasks.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
093_change_type_of_data_in_job_tasks.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
094_favorite_tags.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
095_add_repeat_count_to_job_tasks.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
096_create_advertisements.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
09142010220946_add_fts_to_pools.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20080901000000_no_really_add_post_votes.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20080927145957_make_wiki_titles_unique.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015004825_create_user_log.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015004855_add_random_to_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015004938_convert_favorites_to_votes.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015005018_create_ip_bans.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081015005051_add_avatar_to_user.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081015005124_add_last_comment_read_at_to_user.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015005201_add_history_table.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081015005919_import_post_tag_histories.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081015010657_update_histories.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081016002814_post_source_not_null.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081018175545_post_source_default.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081023224739_add_mirror_posts_to_job_tasks.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081024083115_pools_default_to_public.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081024223856_add_old_level_to_bans.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081025222424_add_fts_to_comments.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081105030832_add_periodic_maintenance_to_job_tasks.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081122055610_add_last_deleted_post_seen_at.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081130190723_add_file_size_to_posts.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081130191226_add_crc32_to_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081203035506_add_is_held_to_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081204062728_add_shown_to_posts.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20081205061033_add_natural_sort_to_pools.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081205072029_add_index_timestamp_index.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081208220020_pool_sequence_as_string.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081209221550_add_slave_pool_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20081210193125_add_index_history_changes_previous_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20090115234541_add_name_to_favorite_tags.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20090123212834_add_visible_on_profile_to_tag_subscriptions.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20090208201752_add_full_text_index_on_post_tags.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20090215000207_add_inline_images.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20090903232732_update_post_text.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20091228170149_add_jpeg_columns.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20100101225942_constrain_user_logs.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20100827031936_add_show_advanced_editing.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20100831065951_add_batch_uploads.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20100903220234_remove_slave_pool_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20100906054326_add_fts_to_history.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20100907042612_rename_favorites_job_task.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20100907210915_include_note_body_in_history_fts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20100907215811_add_aux_to_history.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20101011000658_add_comment_fragments.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20101027013550_fix_fts_underscores.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20101116221443_add_pools_default_to_user.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20101212021821_add_post_frames.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20101218070942_add_browser_preference.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20110116202516_update_pool_count_triggers.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20110228010717_flag_detail_optional_user_id.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120331040429_fix_users_name_index.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120505130017_add_unique_index_to_posts_tag.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20120624121058_add_index_to_post_votes_updated_at.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120723155345_fix_histories_column_name.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120723161914_update_histories_trigger.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120804130515_drop_server_key.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120813155642_change_batch_upload_url_to_text.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120830051636_add_updated_at_to_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120920171733_remove_fav_count_from_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120920172947_set_default_for_users_show_samples.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20120920173324_disallow_anonymous_forum_posts.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20120920173803_remove_anonymous_votes_from_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120920174218_remove_last_voter_ip_from_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20120921040720_remove_last_vote_from_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20130326154700_add_api_key_to_user.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20130326161630_add_index_to_api_key.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20140309152432_fix_sequence_name.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20140427041839_remove_non_votes.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20140429125422_fix_post_votes_updated_at.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20140905023318_add_post_foreign_key_to_posts_tags.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20151207113346_convert_job_tasks_data_data_type_to_jsonb.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20160113112901_fix_batch_uploads_created_at_default.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20160329065325_add_tags_array_to_posts.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20160329065802_add_trigger_for_posts_tags_array.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20160329154133_remove_tags_index_on_posts.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20160329160235_remove_posts_tags_index_trigger.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20160329161636_replace_history_changes_value_index.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20160330063707_drop_danbooru_text_search_configuration.rb
Fix migration issues in Rails 5.1 (#97)
2018-03-10 18:15:56 +09:00
20180624074601_convert_timestamps_to_with_time_zone.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20190518111956_add_index_to_post_votes.rb
Add rails version of rubocop
2024-01-08 19:39:01 +09:00
20190817070727_add_foreign_key_constraint_to_active_storage_attachments_for_blob_id.active_storage.rb
Update to rails 6
2019-08-17 17:03:23 +09:00
20191110172526_fix_nat_sort_function.rb
Fix nat_sort not referring explicit schema
2019-11-11 02:30:13 +09:00
20200908180652_add_name_normalized_to_users.rb
Lowercase usernames app-side
2020-09-12 19:33:54 +09:00
20201103140508_add_post_warehouse_index.rb
Add index for post warehousing tasks
2020-11-03 23:11:35 +09:00
20210211213304_drop_extra_sequence.rb
Remove unused sequence
2021-02-12 06:34:06 +09:00
20250329151230_add_ratio_to_posts.rb
Support searching by aspect ratio
2025-03-30 01:04:00 +09:00