impress/db/migrate
Emi Matchu 97ffffb67a Add configurable full name field to alt styles
Sigh, the "Valentine Plushie" series is messing with me again! It
doesn't follow the previously established pattern of the names being
"<series> <color> <species>", because in this case the base color is
considered "Valentine".

Okay, well! In this change we add `full_name` as an explicit database
field, and set the previous full name value as a fallback. (We also
extract the generic fallback logic into `ApplicationRecord`, to help us
express it more concisely.)

We also tweak `adjective_name` to be able to shorten custom `full_name`
values, too. That way, in the outfit editor, the Styles options show
correct values like "Cherub Plushie" for the "Cherub Plushie Acara".

I also make some changes in the outfit editor to better accommodate the
longer series names, to try to better handle long words but also to
just only use the first word of the series main name anyway. (Currently,
all series main names are one word, except "Valentine Plushie" becomes
"Valentine".)
2025-02-15 21:52:47 -08:00
..
20101109021049_create_outfits.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20101109021147_create_item_outfit_relationships.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20101110213044_add_name_and_starred_to_outfits.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20101125153424_treat_sold_in_mall_as_a_boolean.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110126180835_users_devise.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20110720183722_add_neopets_username_to_users.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120308205324_add_image_to_outfits.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120321214802_index_associations.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120321222001_index_closet_hanger_query.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120321231507_index_closet_hanger_query2.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20120725232903_add_image_enqueued_to_outfits.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130121193957_create_species.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130121205607_create_colors.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130121221226_create_zones.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20130128065543_remove_translated_fields_from_items.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140403034558_create_wardrobe_tips.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140910014231_create_donations.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20140910030549_create_donation_features.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
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 Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20230729181111_drop_news_posts.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20230802195548_drop_wardrobe_tips.rb Oops, should've used migration version 4.2 2023-10-23 19:05:08 -07:00
20231024221826_delete_orphaned_closet_hangers.rb Stop orphaning hangers when deleting lists 2023-10-24 15:35:21 -07:00
20231110043543_add_manifest_url_to_swf_assets.rb Move manifest backfill to swf_assets:manifests task 2023-11-10 16:52:50 -08:00
20231111232015_remove_image_mode_tester_from_users.rb Remove old Image Mode stuff 2023-11-11 15:21:49 -08:00
20231111234255_remove_mall_spider_fields_from_item.rb Remove unused NC Mall spider code & fields 2023-11-11 15:45:38 -08:00
20240119061745_add_last_trade_activity_at_to_users.rb Save last trade activity time onto User 2024-01-19 00:00:46 -08:00
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 Start migrating off globalize gem for zones 2024-01-23 05:43:00 -08:00
20240124102340_create_alt_styles.rb Add alt style support to modeling 2024-01-24 03:25:23 -08:00
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 Add Alt Style support to outfit saving 2024-02-01 05:55:19 -08:00
20240203161355_drop_translations_for_colors_and_species_and_zones.rb Migration to drop {color,species,zone}_translations 2024-02-03 08:20:18 -08:00
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 Drop item_translations table 2024-02-20 17:01:54 -08:00
20240225231346_add_manifest_loaded_at_and_manifest_status_code_to_swf_assets.rb Track when manifest was last loaded, and what status it returned 2024-02-25 15:35:04 -08:00
20240227231815_add_series_name_to_alt_styles.rb Add series_name database field to alt styles 2024-02-27 15:28:05 -08:00
20240227233743_change_default_for_alt_styles_series_name.rb Update series_name for alt styles to be null, with a fallback string 2024-02-27 15:48:28 -08:00
20240229015410_convert_all_tables_to_utf8mb4.rb Improve Unicode support, emojis don't crash us anymore lol! 2024-02-28 18:54:27 -08:00
20240323234243_increase_limit_for_item_outfit_relationships_id.rb Increase ID column limit for item_outfit_relationships 2024-03-24 11:09:40 +11:00
20240401124200_increase_username_length.rb Increase maximum username length to 30 2024-04-01 05:53:38 -07:00
20240421033509_add_shadowbanned_to_users.rb Add shadowban mechanism for closet lists 2024-04-20 20:57:15 -07:00
20240502195157_fix_default_value_for_items_description.rb Fix broken default value in schema for item description 2024-05-02 13:00:10 -07:00
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 Add index to items.name database field 2024-06-03 11:44:06 -07:00
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 Remove support for old "Nebula (fake)" April Fools color 2024-09-27 19:38:53 -07:00
20241001052510_add_cached_fields_to_items.rb Add cached fields to Item model for searching, but don't use them yet 2024-09-30 23:10:44 -07:00
20241003004726_allow_null_in_items_cached_fields.rb Use Rails serialize method to save/load cached fields in Item 2024-10-02 17:50:42 -07:00
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 Increase the maximum value for pet types' color ID and species ID 2024-11-15 19:29:13 -08:00
20241116041926_increase_id_limits.rb Remove some more incorrect limits on ID fields in the database 2024-11-15 20:39:38 -08:00
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