hensei-api/db/migrate
Justin Edmund 1f80e4189f
Add weapon stat modifiers for AX skills and befoulments (#202)
* add weapon_stat_modifiers table for ax skills and befoulments

* add fk columns for ax modifiers and befoulments, replace has_ax_skills with augment_type

* update models for weapon_stat_modifier fks and befoulments

* update blueprints for weapon_stat_modifier serialization

* update import service for weapon_stat_modifier fks and befoulments

* add weapon_stat_modifiers controller and update params for fks

* update tests and factories for weapon_stat_modifier fks

* fix remaining has_ax_skills and ax_modifier references

* add ax_modifier and befoulment_modifier to eager loading

* fix ax modifier column naming and migration approach

* add game_skill_ids for befoulment modifiers
2025-12-31 22:20:00 -08:00
..
20230618051638_init_schema.rb
20230619000621_squasher_clean.rb
20230619003446_add_awakenings_table.rb
20230619003480_create_weapon_awakenings_table.rb
20230619003502_add_max_awakening_level_to_weapons.rb
20230619005403_add_order_to_awakenings.rb
20230619013722_rename_type_to_object_type_in_awakenings.rb
20230619013850_remove_awakening_from_weapon.rb
20230619015030_add_new_awakening_type_to_grid_weapons.rb
20230619020744_remove_awakening_type_from_grid_weapon.rb
20230619043556_add_new_awakening_id_to_grid_characters.rb
20230619045651_remove_awakening_from_grid_characters.rb
20230621073125_re_add_quick_summon_and_auto_summon_to_grid_summons_and_parties.rb
20230702035508_add_remix_flag_to_parties.rb
20230705065015_create_pg_search_documents.rb
20230716132629_add_gbf_wiki_to_character.rb
20230717011150_add_columns_to_characters.rb
20230816015828_add_columns_to_weapons.rb
20230816015904_add_columns_to_summons.rb
20230820045019_add_xlb_date_to_summons.rb
20230820113800_add_nicknames_to_characters.rb
20230820113810_add_nicknames_to_summons.rb
20230820113900_add_nicknames_to_weapons.rb
20230824222028_add_role_to_users.rb
20230824222107_add_visibility_to_parties.rb
20231119051213_add_new_series_to_weapon_keys.rb
20231119051231_rename_new_series_and_delete_series.rb
20240113175218_add_transcendence_to_weapon.rb Add support for weapon transcendence (#142) 2024-01-15 14:05:17 -08:00
20240113175229_add_transcendence_level_to_grid_weapon.rb Add support for weapon transcendence (#142) 2024-01-15 14:05:17 -08:00
20240113180227_add_weapon_key_4_to_grid_weapon.rb Add support for weapon transcendence (#142) 2024-01-15 14:05:17 -08:00
20240113181526_rename_summon_xlb_to_transcendence.rb Add support for weapon transcendence (#142) 2024-01-15 14:05:17 -08:00
20240126032358_change_transcend_date_to_date.rb Fix transcendence date column type (#144) 2024-01-25 19:35:21 -08:00
20250110070255_create_data_versions.rb Create pipeline for importing data via PRs (#148) 2025-01-13 05:33:04 -08:00
20250115094528_add_recruits_to_weapons.rb Link Character and Weapon tables with granblue_id (#154) 2025-01-15 02:11:06 -08:00
20250115100327_remove_recruits_id_from_weapons.rb Link Character and Weapon tables with granblue_id (#154) 2025-01-15 02:11:06 -08:00
20250115100356_add_index_to_weapon_recruits.rb Link Character and Weapon tables with granblue_id (#154) 2025-01-15 02:11:06 -08:00
20250118135254_add_preview_columns_to_parties.rb Implement embed images (#173) 2025-01-18 09:08:15 -08:00
20250119062554_add_preview_s3_key_to_parties.rb More embed image bandaids (#175) 2025-01-18 22:32:13 -08:00
20250120214715_set_preview_state_default_to_pending.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250120224953_add_missing_indexes_to_parties.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250201030154_add_missing_indexes_to_grid_objects.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250201041406_create_pghero_query_stats.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250201120655_enable_pg_statements.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250201120842_remove_unused_index.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250201170037_add_optimized_indexes_to_parties.rb Jedmund/fix image embeds 4 (#177) 2025-02-09 22:50:18 -08:00
20250214074541_make_job_foreign_key_deferrable.rb Fix filters and add processors (#181) 2025-02-17 23:51:50 -08:00
20250214085036_remove_foreign_key_constraint_on_jobs_base_job_id.rb Fix filters and add processors (#181) 2025-02-17 23:51:50 -08:00
20250218013315_add_new_series_to_weapons.rb fix migrator (#183) 2025-02-18 01:47:23 -08:00
20250218025315_move_new_series_to_series.rb Fix filters and add processors (#181) 2025-02-17 23:51:50 -08:00
20250301143956_add_raw_data_columns.rb Update migration 2025-03-02 16:08:35 -08:00
20250307075433_convert_game_raw_columns_to_jsonb.rb Add custom page size support via X-Per-Page header 2025-09-17 05:44:14 -07:00
20250307080232_drop_game_raw_en_backup.rb Add custom page size support via X-Per-Page header 2025-09-17 05:44:14 -07:00
20250327044028_add_classic_ii_and_collab_to_gacha.rb Add columns for Classic II and Collab Gacha 2025-03-27 01:37:53 -04:00
20250928120000_add_collection_privacy_to_users.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20250928120001_create_collection_characters.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20250928120002_create_collection_weapons.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20250928120003_create_collection_summons.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20250928120004_create_collection_job_accessories.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20250928120005_remove_unique_constraint_from_weapons_and_summons.rb fix blueprints: use correct association names instead of 'object' 2025-11-29 17:41:29 -08:00
20251202120531_add_season_series_to_characters.rb add season, series, gacha_available to characters 2025-12-02 04:06:53 -08:00
20251202123526_add_promotions_to_weapons_and_summons.rb add promotions integer array to weapons and summons 2025-12-02 04:39:15 -08:00
20251203173627_create_weapon_series.rb add weapon_series and weapon_key_series tables and models 2025-12-03 10:45:25 -08:00
20251203173721_add_weapon_series_id_to_weapons.rb add weapon_series and weapon_key_series tables and models 2025-12-03 10:45:25 -08:00
20251203173746_create_weapon_key_series.rb add weapon_series and weapon_key_series tables and models 2025-12-03 10:45:25 -08:00
20251203184819_create_artifacts.rb add migrations for artifacts feature 2025-12-03 12:58:22 -08:00
20251203184919_create_collection_artifacts.rb add migrations for artifacts feature 2025-12-03 12:58:22 -08:00
20251203185443_create_grid_artifacts.rb add migrations for artifacts feature 2025-12-03 12:58:22 -08:00
20251203195857_create_artifact_skills.rb add migrations for artifacts feature 2025-12-03 12:58:22 -08:00
20251203211939_add_reroll_slot_to_artifacts.rb add reroll_slot to artifact models 2025-12-03 13:27:26 -08:00
20251203221115_add_game_id_to_collection_items.rb add artifact import from game data 2025-12-03 14:20:21 -08:00
20251203224022_add_collection_references_to_grid_items.rb add collection references to grid tables 2025-12-03 22:40:34 -08:00
20251204063628_create_crews.rb add crew and crew_membership models with migrations 2025-12-03 22:41:19 -08:00
20251204063649_create_crew_memberships.rb add crew and crew_membership models with migrations 2025-12-03 22:41:19 -08:00
20251204063711_add_show_gamertag_to_users.rb add crew and crew_membership models with migrations 2025-12-03 22:41:19 -08:00
20251204070124_create_crew_invitations.rb add crew invitations system 2025-12-03 23:06:07 -08:00
20251204070958_create_gw_events.rb add GW events and scoring system 2025-12-03 23:34:54 -08:00
20251204070959_create_crew_gw_participations.rb add GW events and scoring system 2025-12-03 23:34:54 -08:00
20251204071000_create_gw_crew_scores.rb add GW events and scoring system 2025-12-03 23:34:54 -08:00
20251204071001_create_gw_individual_scores.rb add GW events and scoring system 2025-12-03 23:34:54 -08:00
20251204074828_create_phantom_players.rb add phantom players for non-registered crew members 2025-12-03 23:55:15 -08:00
20251204075226_add_phantom_player_to_gw_individual_scores.rb add phantom players for non-registered crew members 2025-12-03 23:55:15 -08:00
20251204093029_change_gw_events_name_nullable.rb gw event improvements: status field, members_during_event endpoint 2025-12-04 03:02:35 -08:00
20251204100659_add_retired_to_phantom_players.rb add retired flag to phantom players 2025-12-04 03:02:46 -08:00
20251204102935_add_joined_at_to_crew_memberships_and_phantom_players.rb add joined_at to memberships and phantoms for historical data 2025-12-04 03:02:13 -08:00
20251214000505_add_show_granblue_id_to_users.rb add show_granblue_id to users 2025-12-14 01:23:33 -08:00
20251214091117_change_collection_privacy_to_one_based.rb use 1-based values for collection_privacy enum 2025-12-14 01:23:42 -08:00
20251214104716_create_character_series.rb add character series lookup table 2025-12-14 11:58:10 -08:00
20251214104717_create_character_series_memberships.rb add character series lookup table 2025-12-14 11:58:10 -08:00
20251214104720_create_summon_series.rb add summon series lookup table 2025-12-14 11:58:22 -08:00
20251214104721_add_summon_series_id_to_summons.rb add summon series lookup table 2025-12-14 11:58:22 -08:00
20251215122402_move_gacha_from_characters_to_weapons.rb move gacha from characters to weapons 2025-12-15 12:46:43 -08:00
20251215154313_add_fields_to_job_skills.rb add image_id and action_id fields to job_skills 2025-12-15 16:08:53 -08:00
20251215173625_remap_character_season_values.rb remove Standard season, remap values to start at 1 2025-12-15 09:51:19 -08:00
20251217195837_add_deleted_at_to_phantom_players.rb soft delete phantoms after claim confirmation 2025-12-17 20:08:28 -08:00
20251217200954_add_excused_to_gw_individual_scores.rb add excused field to gw individual scores 2025-12-18 23:15:27 -08:00
20251218100000_add_aux_weapon_to_jobs.rb add aux_weapon flag to jobs 2025-12-18 21:34:30 -08:00
20251219055153_add_game_skill_id_to_artifact_skills.rb remove game_skill_id from artifact_skills (not needed) 2025-12-18 22:30:59 -08:00
20251219062316_remove_game_skill_id_from_artifact_skills.rb remove game_skill_id from artifact_skills (not needed) 2025-12-18 22:30:59 -08:00
20251219064037_add_game_names_to_artifact_skills.rb add game_name columns for artifact skill matching 2025-12-18 22:48:08 -08:00
20251220014422_add_unlimited_to_raid_groups.rb add unlimited flag to raid groups 2025-12-20 01:58:23 -08:00
20251220100000_add_video_url_and_summon_count_to_parties.rb add video_url and summon_count to parties 2025-12-21 02:56:22 -08:00
20251221195800_add_extra_prerequisite_to_weapons.rb add extra_prerequisite to weapons for extra grid positions 2025-12-21 22:14:23 -08:00
20251221210000_add_forge_columns_to_weapons.rb add forge chain support to weapons 2025-12-21 22:14:32 -08:00
20251223000000_add_orphaned_to_grid_items.rb collection sync with orphan handling (#200) 2025-12-23 22:44:35 -08:00
20251230000001_create_weapon_stat_modifiers.rb Add weapon stat modifiers for AX skills and befoulments (#202) 2025-12-31 22:20:00 -08:00
20251230000002_add_weapon_stat_modifier_fks.rb Add weapon stat modifiers for AX skills and befoulments (#202) 2025-12-31 22:20:00 -08:00
20251230000003_finalize_ax_modifier_columns.rb Add weapon stat modifiers for AX skills and befoulments (#202) 2025-12-31 22:20:00 -08:00
20251230000004_add_augment_type_to_weapon_series.rb Add weapon stat modifiers for AX skills and befoulments (#202) 2025-12-31 22:20:00 -08:00