impress/db/migrate
Emi Matchu 9ba94f9f4b chore: document legacy openneo_id migrations and update references
This commit completes the database consolidation cleanup by documenting
the historical migrations and updating all references to reflect the
single-database architecture.

Changes:
- db/openneo_id_migrate/README.md: Created comprehensive documentation
  explaining the history of the separate database and why these migrations
  are preserved but no longer runnable
- db/openneo_id_schema.rb: Deleted (no longer needed)
- README.md: Updated to reflect single-database architecture
  - Removed mentions of "two databases"
  - Updated "OpenNeo ID Database" section to "Authentication Architecture"
  - Added reference to historical context in db/openneo_id_migrate/README.md
- deploy/setup.yml: Removed openneo_id database creation and privileges
  for future deployments
- db/migrate/20240401124200_increase_username_length.rb: Updated comment
  to note this was historically paired with an openneo_id migration

The codebase now fully reflects the consolidated single-database architecture.
The legacy migration files in db/openneo_id_migrate/ are preserved for
historical reference only.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-11-02 07:02:43 +00:00
..
20101109021049_create_outfits.rb
20101109021147_create_item_outfit_relationships.rb
20101110213044_add_name_and_starred_to_outfits.rb
20101125153424_treat_sold_in_mall_as_a_boolean.rb
20101125154435_allow_null_for_some_objects_fields.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20101125160843_add_swf_assets_type_and_id_index.rb
20110126180835_users_devise.rb
20110210222230_guest_outfits.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110514145602_add_has_image_to_swf_assets.rb
20110515134542_add_image_requested_to_swf_assets.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110626202605_add_image_mode_tester_to_users.rb
20110712232259_create_closet_hangers.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110713162012_set_closet_hangers_quantity_default_to_zero.rb
20110720183722_add_neopets_username_to_users.rb
20110722180616_add_owned_to_closet_hangers.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110726231143_create_closet_lists.rb
20110730174148_add_closet_hangers_visibility_to_users.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110731021808_add_visibility_to_closet_lists.rb
20110804134432_add_timestamps_to_items.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110807212936_add_conversion_timestamps_to_swf_assets.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120112204234_rename_swf_assets_id_to_remote_id.rb
20120308205324_add_image_to_outfits.rb
20120321214802_index_associations.rb
20120321222001_index_closet_hanger_query.rb
20120321231507_index_closet_hanger_query2.rb
20120521164652_add_female_and_mood_and_unconverted_and_labeled_to_pet_states.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120716193946_add_image_layers_hash_to_outfit.rb
20120725232903_add_image_enqueued_to_outfits.rb
20121006010446_add_explicitly_body_specific_to_objects.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130111213346_translate_items.rb
20130121193957_create_species.rb
20130121205607_create_colors.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130121221226_create_zones.rb
20130128065543_remove_translated_fields_from_items.rb
20130427151327_add_glitched_to_pet_states.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20131016203607_add_image_manual_to_swf_assets.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140117171729_create_neopets_connections.rb
20140119040646_add_contact_neopets_connection_id_to_users.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140125202515_add_prank_to_colors.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140331034031_add_artist_neopets_username_to_pet_state.rb
20140403034558_create_wardrobe_tips.rb
20140910014231_create_donations.rb
20140910030549_create_donation_features.rb
20140910181819_add_email_to_donations.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140910204019_create_campaigns.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140910204043_add_campaign_id_to_donation.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20150225194522_add_advertised_to_campaign.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20150728192329_add_description_to_campaigns.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20150728195029_add_name_to_campaigns.rb
20150802202909_add_theme_id_to_campaigns.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20150905181350_add_basic_image_hash_to_pet_types.rb
20150923052017_add_thanks_to_campaign.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20150927033046_create_news_posts.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20170105205222_add_purpose_to_campaigns.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20180509210338_add_manual_special_color_id_to_items.rb
20230729181111_drop_news_posts.rb
20230802195548_drop_wardrobe_tips.rb
20231024221826_delete_orphaned_closet_hangers.rb
20231110043543_add_manifest_url_to_swf_assets.rb
20231111232015_remove_image_mode_tester_from_users.rb
20231111234255_remove_mall_spider_fields_from_item.rb
20240119061745_add_last_trade_activity_at_to_users.rb
20240123125509_add_name_to_species_and_color.rb Improve species/color name migration performance & correctness 2024-01-23 05:30:42 -08:00
20240123133215_add_label_and_plain_label_to_zones.rb
20240124102340_create_alt_styles.rb
20240129114639_add_support_staff_to_users.rb Add support_staff flag to user record; they can use Support tools 2024-01-29 04:21:19 -08:00
20240201134440_add_alt_style_id_to_outfits.rb
20240203161355_drop_translations_for_colors_and_species_and_zones.rb
20240220230420_add_translated_fields_directly_to_items.rb Add translated item fields directly to the Item model 2024-02-20 15:25:03 -08:00
20240221004332_fix_default_value_for_modeling_logs_created_at.rb Fix default value for Impress 2020's modeling_logs.created_at 2024-02-20 16:46:19 -08:00
20240221005949_drop_item_translations.rb
20240225231346_add_manifest_loaded_at_and_manifest_status_code_to_swf_assets.rb
20240227231815_add_series_name_to_alt_styles.rb
20240227233743_change_default_for_alt_styles_series_name.rb
20240229015410_convert_all_tables_to_utf8mb4.rb
20240323234243_increase_limit_for_item_outfit_relationships_id.rb
20240401124200_increase_username_length.rb chore: document legacy openneo_id migrations and update references 2025-11-02 07:02:43 +00:00
20240421033509_add_shadowbanned_to_users.rb
20240502195157_fix_default_value_for_items_description.rb
20240507235742_create_nc_mall_records.rb Add bare-bones rails nc_mall:sync task, incl. NCMallRecord model 2024-05-07 17:40:14 -07:00
20240511003019_add_unique_index_on_item_id_to_nc_mall_records.rb Load *all* NC Mall pages in nc_mall:sync 2024-05-10 17:39:40 -07:00
20240522222040_add_pb_item_name_to_colors.rb Add more PB item info and links to Item Getting Guide 2024-05-22 16:09:49 -07:00
20240522233638_add_pb_item_thumbnail_url_to_colors.rb Add paint brush images to Item Getting Guide 2024-05-22 16:59:36 -07:00
20240603181855_add_index_on_name_to_items.rb
20240608022149_add_dyeworks_base_item_id_to_items.rb Add Item#dyeworks_base_item database field, and populate it 2024-06-07 20:10:06 -07:00
20240616001002_add_thumbnail_url_to_alt_styles.rb Make thumbnail_url a manually overridable field for Alt Styles 2024-06-15 17:35:12 -07:00
20240928022359_remove_prank_from_colors.rb
20241001052510_add_cached_fields_to_items.rb
20241003004726_allow_null_in_items_cached_fields.rb
20241008004715_add_timestamps_to_pet_states.rb Add created_at/updated_at to PetState 2024-10-07 17:54:54 -07:00
20241116031655_increase_pet_type_color_id_and_species_id_limit.rb
20241116041926_increase_id_limits.rb
20241119214543_add_cached_predicted_fully_modeled_to_items.rb Add Item.is{_not}_modeled scopes, for use in search later 2024-11-19 15:52:52 -08:00
20250216041650_add_full_name_to_alt_styles.rb Add configurable full name field to alt styles 2025-02-15 21:52:47 -08:00
20251102064247_copy_auth_users_table_to_main_database.rb feat: add write lock for AuthUser migration preparation 2025-11-02 06:50:55 +00:00