klevze/SkinbaseNova
1
0
Fork 0
Code Issues 2 Pull Requests Actions Packages Projects Releases Wiki Activity
Files
develop
SkinbaseNova/database/migrations
T
History
klevze 02861b5a2f Expand profile gender options and cover country plus activity persistence. 
Allow the broader gender enum and add tests for country saves and discovery event recording.
2026-09-20 14:50:59 +02:00
..
0001_01_01_000000_create_users_table.php
Current state
2026-02-07 08:23:18 +01:00
0001_01_01_000001_create_cache_table.php
Current state
2026-02-07 08:23:18 +01:00
0001_01_01_000002_create_jobs_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_01_31_000001_create_content_types_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_01_31_000002_create_categories_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_01_31_000003_create_artwork_category_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_01_31_000004_create_category_seo_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_01_31_000005_create_category_translations_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000001_create_artworks_table.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_02_01_000002_create_artwork_translations_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000003_create_artwork_stats_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000004_create_artwork_comments_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000005_create_artwork_downloads_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_02_01_000006_add_artwork_fk_to_artwork_category_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000007_add_soft_deletes_to_categories_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000008_add_soft_deletes_to_category_translations_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000009_add_slug_index_to_categories_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000010_update_users_table_for_skinbase.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000020_create_user_profiles_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000030_create_user_social_links_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000040_create_user_statistics_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_01_000050_add_deleted_at_to_users.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_05_160000_create_artwork_features_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_06_000001_add_hash_and_exts_to_artworks_table.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_06_000002_remove_unique_from_hash.php
Current state
2026-02-07 08:23:18 +01:00
2026_02_07_000001_create_user_favorites_table.php
current state
2026-02-08 10:42:01 +01:00
2026_02_08_000000_update_user_profiles_avatars.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_08_000001_update_user_profiles_about_signature_description.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_08_000002_enhance_user_profiles_metadata.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_11_000001_create_uploads_sessions_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_11_000002_create_audit_logs_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_11_000003_create_artwork_files_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_11_000004_add_progress_and_failure_to_uploads_sessions_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000001_create_tags_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000002_create_artwork_tag_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000003_create_tag_synonyms_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000004_create_uploads_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000005_create_upload_files_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_12_000006_create_upload_tags_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_13_000007_add_processing_state_to_uploads_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_13_000008_add_moderation_fields_to_uploads_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_13_000009_create_artwork_embeddings_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_13_000010_create_artwork_similarities_table.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_14_000011_create_similar_artwork_analytics_tables.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_14_000012_create_discovery_foundation_tables.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_14_000013_create_feed_analytics_tables.php
Upload beautify
2026-02-14 15:14:12 +01:00
2026_02_15_000100_finalize_avatar_schema_for_cdn.php
Upload beautify
2026-02-17 17:14:43 +01:00
2026_02_15_120500_finalize_avatar_metadata_schema.php
Upload beautify
2026-02-17 17:14:43 +01:00
2026_02_17_161455_create_forum_categories_table.php
feat(forum): add forum schema
2026-02-17 17:19:01 +01:00
2026_02_17_161456_create_forum_posts_table.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_02_17_161456_create_forum_threads_table.php
feat(forum): add forum schema
2026-02-17 17:19:01 +01:00
2026_02_17_161457_add_forum_posts_thread_foreign_key.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_02_17_161458_create_forum_attachments_table.php
feat(forum): add forum schema
2026-02-17 17:19:01 +01:00
2026_02_17_163000_fix_forum_threads_category_fk.php
prepared and gallery fixes
2026-02-19 08:36:32 +01:00
2026_02_19_220000_create_forum_post_reports_table.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_173242_enforce_username_policy_on_users_table.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_180000_enforce_username_policy_on_users_table.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_180100_create_username_history_and_redirects_tables.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_181000_create_username_approval_requests_table.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_191000_add_registration_phase1_schema.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_20_191100_enforce_username_lowercase_check_constraint.php
Auth: convert auth views and verification email to Nova layout
2026-02-21 07:37:08 +01:00
2026_02_21_000001_add_registration_antispam_fields_to_users_table.php
feat(auth): complete registration anti-spam and quota hardening
2026-02-21 12:13:01 +01:00
2026_02_21_000002_create_email_send_events_table.php
feat(auth): complete registration anti-spam and quota hardening
2026-02-21 12:13:01 +01:00
2026_02_21_000003_create_system_email_quota_table.php
feat(auth): complete registration anti-spam and quota hardening
2026-02-21 12:13:01 +01:00
2026_02_21_000004_rename_token_to_token_hash_in_user_verification_tokens.php
feat(auth): complete registration anti-spam and quota hardening
2026-02-21 12:13:01 +01:00
2026_02_21_000005_ensure_user_verification_tokens_table_exists.php
feat(auth): complete registration anti-spam and quota hardening
2026-02-21 12:13:01 +01:00
2026_02_22_120000_create_artwork_likes_table.php
fixed gallery
2026-02-22 17:09:34 +01:00
2026_02_22_120100_create_artwork_reports_table.php
fixed gallery
2026-02-22 17:09:34 +01:00
2026_02_23_000001_create_artwork_awards_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_23_000001_create_user_followers_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_23_000002_create_artwork_award_stats_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_23_000002_create_profile_comments_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_23_000003_add_legacy_id_to_artwork_comments_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_23_000003_add_profile_views_to_user_statistics_table.php
feat: increase gallery grid from 4 to 5 columns per row on desktopfeat: increase gallery grid from 4 to 5 columns per row on desktop
2026-02-25 19:11:23 +01:00
2026_02_26_000001_add_content_columns_to_artwork_comments_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_000002_create_reactions_tables.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_000003_widen_content_columns_to_mediumtext.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_000004_create_artwork_favourites_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_000005_merge_user_favorites_into_artwork_favourites.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_100000_add_follow_counters_to_user_statistics.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_200000_upgrade_user_statistics_v2.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300000_create_conversations_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300001_create_conversation_participants_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300002_create_messages_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300003_create_message_reactions_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300004_add_allow_messages_from_to_users.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300005_create_notifications_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300006_add_pin_columns_to_conversation_participants.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300007_create_message_attachments_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300008_create_reports_table.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_26_300009_add_message_reaction_user_index.php
messages implemented
2026-02-26 21:12:32 +01:00
2026_02_27_000001_add_trending_scores_to_artworks_table.php
storing analytics data
2026-02-27 09:46:51 +01:00
2026_02_27_000002_add_windowed_stats_to_artwork_stats.php
storing analytics data
2026-02-27 09:46:51 +01:00
2026_02_27_000002_create_activity_events_table.php
storing analytics data
2026-02-27 09:46:51 +01:00
2026_02_27_000003_create_artwork_view_events_table.php
storing analytics data
2026-02-27 09:46:51 +01:00
2026_02_27_103655_create_user_reco_profiles_table.php
fix(gallery): fill tall portrait cards to full block width with object-cover crop
2026-02-27 13:34:08 +01:00
2026_02_27_500000_create_rank_artwork_scores_table.php
feat: add reusable gallery carousel and ranking feed infrastructure
2026-02-28 07:56:25 +01:00
2026_02_27_500001_create_rank_lists_table.php
feat: add reusable gallery carousel and ranking feed infrastructure
2026-02-28 07:56:25 +01:00
2026_02_28_000001_add_parent_id_to_artwork_comments_table.php
feat: artwork page carousels, recommendations, avatars & fixes
2026-02-28 14:05:39 +01:00
2026_02_28_000002_create_artwork_shares_table.php
feat: artwork share system with modal, native Web Share API, and tracking
2026-02-28 15:29:45 +01:00
2026_02_28_100000_add_ranking_v2_columns_to_artwork_stats.php
feat: Ranking Engine V2 — intelligent scoring with shares, authority, decay & velocity\n\n- Add ArtworkRankingService with V2 formula:\n ranking_score = (base × authority × decay) + velocity_boost\n Base: views×0.2 + downloads×1.5 + favourites×2.5 + comments×3.0 + shares×4.0\n Authority: 1 + (log10(1+followers) + fav_received/1000) × 0.05\n Decay: 1 / (1 + hours/48)\n Velocity: 24h signals × velocity_weights × 0.5\n\n- Add nova:recalculate-rankings command (--chunk, --sync-rank-scores, --skip-index)\n- Add migration: ranking_score, engagement_velocity, shares/comments counts to artwork_stats\n- Upgrade RankingService.computeScores() with shares + comments + velocity\n- Update Meilisearch sortableAttributes: ranking_score, shares_count, engagement_velocity, comments_count\n- Update toSearchableArray() to expose V2 fields\n- Schedule every 30 min with overlap protection\n- Verified: 49733 artworks scored successfully"
2026-02-28 16:41:15 +01:00
2026_02_28_200000_create_artwork_metric_snapshots_hourly_table.php
Studio: make grid checkbox rectangular and commit table changes
2026-03-01 08:43:48 +01:00
2026_02_28_200001_add_heat_score_columns_to_artwork_stats.php
Studio: make grid checkbox rectangular and commit table changes
2026-03-01 08:43:48 +01:00
2026_02_28_300000_create_rec_artwork_recs_table.php
Studio: make grid checkbox rectangular and commit table changes
2026-03-01 08:43:48 +01:00
2026_02_28_300001_create_rec_item_pairs_table.php
Studio: make grid checkbox rectangular and commit table changes
2026-03-01 08:43:48 +01:00
2026_02_28_300002_create_rec_events_table.php
Studio: make grid checkbox rectangular and commit table changes
2026-03-01 08:43:48 +01:00
2026_03_01_000001_create_artwork_versions_table.php
feat: upload wizard refactor + vision AI tags + artwork versioning
2026-03-01 14:56:46 +01:00
2026_03_01_000002_add_versioning_columns_to_artworks_table.php
feat: upload wizard refactor + vision AI tags + artwork versioning
2026-03-01 14:56:46 +01:00
2026_03_01_000003_create_artwork_version_events_table.php
feat: upload wizard refactor + vision AI tags + artwork versioning
2026-03-01 14:56:46 +01:00
2026_03_01_100001_add_scheduled_publish_to_artworks_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000001_create_posts_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000002_create_post_targets_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000003_create_post_reactions_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000004_create_post_comments_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000005_create_post_saves_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_000006_create_post_reports_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_100001_add_feed_v2_columns_to_posts_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_100002_create_post_hashtags_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_100003_add_is_highlighted_to_post_comments_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_02_100004_add_auto_post_upload_to_user_profiles_table.php
feat: forum rich-text editor, emoji picker, mentions, discover nav, feed, uploads, profile
2026-03-03 09:48:31 +01:00
2026_03_03_000000_create_staff_applications_table.php
feat: Inertia profile settings page, Studio edit redesign, EGS, Nova UI components\n\n- Redesign /dashboard/profile as Inertia React page (Settings/ProfileEdit)\n with SettingsLayout sidebar, Nova UI components (TextInput, Textarea,\n Toggle, Select, RadioGroup, Modal, Button), avatar drag-and-drop,\n password change, and account deletion sections\n- Redesign Studio artwork edit page with two-column layout, Nova components,\n integrated TagPicker, and version history modal\n- Add shared MarkdownEditor component\n- Add Early-Stage Growth System (EGS): SpotlightEngine, FeedBlender,\n GridFiller, AdaptiveTimeWindow, ActivityLayer, admin panel\n- Fix upload category/tag persistence (V1+V2 paths)\n- Fix tag source enum, category tree display, binding resolution\n- Add settings.jsx Vite entry, settings.blade.php wrapper\n- Update ProfileController with JSON response support for API calls\n- Various route fixes (profile.edit, toolbar settings link)"
2026-03-03 20:57:43 +01:00
2026_03_03_000001_create_pages_table.php
feat: Inertia profile settings page, Studio edit redesign, EGS, Nova UI components\n\n- Redesign /dashboard/profile as Inertia React page (Settings/ProfileEdit)\n with SettingsLayout sidebar, Nova UI components (TextInput, Textarea,\n Toggle, Select, RadioGroup, Modal, Button), avatar drag-and-drop,\n password change, and account deletion sections\n- Redesign Studio artwork edit page with two-column layout, Nova components,\n integrated TagPicker, and version history modal\n- Add shared MarkdownEditor component\n- Add Early-Stage Growth System (EGS): SpotlightEngine, FeedBlender,\n GridFiller, AdaptiveTimeWindow, ActivityLayer, admin panel\n- Fix upload category/tag persistence (V1+V2 paths)\n- Fix tag source enum, category tree display, binding resolution\n- Add settings.jsx Vite entry, settings.blade.php wrapper\n- Update ProfileController with JSON response support for API calls\n- Various route fixes (profile.edit, toolbar settings link)"
2026-03-03 20:57:43 +01:00
2026_03_03_000002_create_blog_posts_table.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_03_03_000003_create_bug_reports_table.php
feat: Inertia profile settings page, Studio edit redesign, EGS, Nova UI components\n\n- Redesign /dashboard/profile as Inertia React page (Settings/ProfileEdit)\n with SettingsLayout sidebar, Nova UI components (TextInput, Textarea,\n Toggle, Select, RadioGroup, Modal, Button), avatar drag-and-drop,\n password change, and account deletion sections\n- Redesign Studio artwork edit page with two-column layout, Nova components,\n integrated TagPicker, and version history modal\n- Add shared MarkdownEditor component\n- Add Early-Stage Growth System (EGS): SpotlightEngine, FeedBlender,\n GridFiller, AdaptiveTimeWindow, ActivityLayer, admin panel\n- Fix upload category/tag persistence (V1+V2 paths)\n- Fix tag source enum, category tree display, binding resolution\n- Add settings.jsx Vite entry, settings.blade.php wrapper\n- Update ProfileController with JSON response support for API calls\n- Various route fixes (profile.edit, toolbar settings link)"
2026-03-03 20:57:43 +01:00
2026_03_04_000001_create_stories_authors_table.php
login update
2026-03-05 11:24:37 +01:00
2026_03_04_000002_create_stories_table.php
login update
2026-03-05 11:24:37 +01:00
2026_03_04_000003_create_stories_tags_table.php
login update
2026-03-05 11:24:37 +01:00
2026_03_04_000004_create_stories_tag_relation_table.php
login update
2026-03-05 11:24:37 +01:00
2026_03_04_100001_create_social_accounts_table.php
login update
2026-03-05 11:24:37 +01:00
2026_03_06_180151_add_grid_data_to_contents_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_07_000001_add_analytics_fields_to_artwork_downloads_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_07_120000_add_cover_fields_to_users_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_07_130000_add_settings_notification_columns_to_user_profiles_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_07_140000_add_last_username_change_at_to_users_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_07_140100_create_email_changes_table.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_09_000005_upgrade_stories_for_creator_module.php
update
2026-03-20 21:17:26 +01:00
2026_03_09_000006_create_creator_story_tag_tables.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_09_000007_expand_story_status_enum.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_09_000008_add_story_target_type_to_reports.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_09_000009_extend_stories_for_editor_workflow.php
more fixes
2026-03-12 07:22:38 +01:00
2026_03_16_000001_create_tag_interaction_events_table.php
feat: add tag discovery analytics and reporting
2026-03-17 18:23:38 +01:00
2026_03_16_180000_create_user_mentions_table.php
feat: add community activity feed and mentions
2026-03-17 18:26:57 +01:00
2026_03_17_000001_create_tag_interaction_daily_metrics_table.php
feat: add tag discovery analytics and reporting
2026-03-17 18:23:38 +01:00
2026_03_17_090000_add_xp_fields_to_users_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_17_090100_create_user_xp_logs_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_17_100000_create_achievements_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_17_100100_create_user_achievements_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_18_120000_create_leaderboards_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_18_150000_create_story_comments_and_bookmarks_tables.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_000000_create_artwork_bookmarks_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_120000_create_countries_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_120100_add_country_id_to_users_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_130000_add_last_received_comment_read_at_to_users_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_130100_create_user_received_comment_reads_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_130200_drop_last_received_comment_read_at_from_users_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_19_180000_create_dashboard_preferences_table.php
update
2026-03-20 21:17:26 +01:00
2026_03_21_000100_add_realtime_fields_to_messaging_tables.php
Repair: copy legacy joinDate into new user's created_at when creating users from legacy wallz
2026-03-22 09:13:39 +01:00
2026_03_21_120000_recreate_missing_forum_spam_tables.php
Refactor dashboard and upload flows
2026-03-21 11:02:22 +01:00
2026_03_21_121000_recreate_missing_forum_learning_tables.php
Refactor dashboard and upload flows
2026-03-21 11:02:22 +01:00
2026_03_21_121100_force_recreate_missing_forum_learning_tables.php
Refactor dashboard and upload flows
2026-03-21 11:02:22 +01:00
2026_03_21_121200_force_recreate_missing_forum_tag_tables.php
Refactor dashboard and upload flows
2026-03-21 11:02:22 +01:00
2026_03_21_122000_repair_missing_upload_and_forum_ai_columns.php
Refactor dashboard and upload flows
2026-03-21 11:02:22 +01:00
2026_03_22_120000_create_user_activities_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_140000_add_moderation_fields_to_user_activities_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_150000_create_user_follow_analytics_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_160000_create_discovery_feedback_daily_metrics_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_170000_add_v2_recommendation_columns_and_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_210000_add_negative_feedback_columns_to_discovery_feedback_daily_metrics_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_230000_add_ai_metadata_columns_to_artworks_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_22_235500_add_last_vector_indexed_at_to_artworks_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_23_000200_add_unique_message_client_temp_constraint.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_23_001000_create_collections_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_23_110000_extend_collections_v2_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_080000_add_is_mature_to_artworks_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_101600_expand_reports_target_types_for_collections.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_120000_extend_collections_v3_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_140000_expand_collection_moderation_states.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_160000_add_collection_layout_and_editorial_ownership.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_170000_add_collection_member_expiry.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_180000_add_campaign_banner_metadata_to_collections.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_190000_add_collections_v4_platform_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_210000_expand_collection_surface_definitions_with_schedule_and_fallback.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_220000_add_collection_related_links_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_230000_add_collection_series_metadata.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_24_235000_add_collection_editorial_notes.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_25_000000_add_collections_v5_platform_fields.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_000001_add_collection_experiment_metadata_fields.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_000002_add_collection_partner_governance_fields.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_000003_add_saved_library_context_to_collection_saves.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_200000_create_nova_card_categories_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_200100_create_nova_card_templates_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_200200_create_nova_card_tags_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_200300_create_nova_card_backgrounds_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_26_200400_create_nova_cards_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000000_add_nova_cards_v2_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000100_expand_reports_target_types_for_nova_cards.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000200_add_report_history_and_notes.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000300_add_trending_score_to_nova_cards.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000400_create_nova_card_comments_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_000500_add_nova_card_gap_fields.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_27_010000_add_nova_cards_v3_tables.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_28_000100_add_nova_featured_creator_to_users_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_28_120000_create_artwork_ai_assists_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_28_180000_add_visibility_to_artworks_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_28_190000_create_artwork_ai_assist_events_table.php
optimizations
2026-03-28 19:15:39 +01:00
2026_03_28_200000_add_order_to_content_types_table.php
Profile: store covers in object storage (WebP); add covers config; remember artworks categories content-type preference
2026-03-29 09:22:36 +02:00
2026_03_29_000100_add_scheduling_to_nova_cards.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_03_29_120000_add_studio_preferences_to_dashboard_preferences.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_04_01_100000_create_content_moderation_findings_table.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_04_02_090000_extend_content_moderation_for_v2.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_04_02_120000_drop_unique_index_from_artworks_slug.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_04_02_140000_extend_content_moderation_for_v3.php
Implement creator studio and upload updates
2026-04-04 10:12:02 +02:00
2026_04_04_000001_create_groups_tables.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000002_add_group_fields_to_artworks_and_collections.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000003_expand_groups_v1_schema.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000004_create_group_invitations_table.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000005_add_published_as_fields_to_artworks.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000006_add_credit_metadata_to_artwork_contributors_table.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000007_add_groups_v2_schema.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_04_000008_add_groups_v3_schema.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_05_000000_add_groups_v4_schema.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_05_000001_enhance_news_module_for_nova.php
Commit workspace changes
2026-04-05 19:42:33 +02:00
2026_04_09_000001_add_thumbnail_audit_columns_to_artworks_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_10_000002_upgrade_artwork_awards_to_medal_stats_v1.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_10_000003_create_artwork_medals_tables_v1.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_10_210000_add_force_hero_to_artwork_features_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_000100_add_maturity_workflow_fields_to_artworks_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_000110_add_maturity_preferences_to_user_profiles_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_000200_add_maturity_ai_contract_fields_to_artworks_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_090000_add_assets_to_content_types_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_180000_create_content_type_slug_histories_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_200000_create_artwork_maturity_audit_findings_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_220000_add_hide_from_menu_to_content_types_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_11_230000_create_artwork_relations_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_12_120000_create_creator_milestones_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_12_130000_create_creator_eras_table.php
feat: ship creator journey v2 and profile updates
2026-04-12 21:42:07 +02:00
2026_04_14_000100_create_creator_ai_biographies_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_14_000200_add_v11_columns_to_creator_ai_biographies_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_16_180000_add_snapshot_json_to_artwork_versions_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_17_120000_create_worlds_tables.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_17_191000_add_section_visibility_json_to_worlds_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_18_090000_add_submission_settings_to_worlds_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_18_091000_create_world_submissions_table.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_18_120000_upgrade_world_submissions_to_v11.php
Save workspace changes
2026-04-18 17:02:56 +02:00
2026_04_18_130000_add_activation_fields_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_18_220000_create_upload_batch_tables.php
Wire admin studio SSR and search infrastructure
2026-05-01 11:46:06 +02:00
2026_04_19_120000_create_world_reward_grants_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_19_130000_add_unique_recurrence_year_constraint_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_19_220000_add_hidden_linked_challenge_artwork_ids_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_19_220000_add_recap_metadata_fields_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_19_230000_create_world_editorial_suggestion_states_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_20_090000_add_linked_challenge_fields_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_20_120000_create_group_challenge_outcomes_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_20_130000_create_world_analytics_events_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_20_180000_add_recap_fields_to_worlds_table.php
Build world campaigns rewards and recaps
2026-05-01 11:44:41 +02:00
2026_04_26_082019_add_performance_indexes_batch1.php
chore: commit current workspace changes
2026-05-02 09:37:14 +02:00
2026_04_26_114137_add_fulltext_index_to_artworks_title_description.php
chore: commit current workspace changes
2026-05-02 09:37:14 +02:00
2026_04_30_100000_ensure_news_articles_soft_deletes.php
Add news article comments and reactions
2026-05-01 11:43:49 +02:00
2026_05_01_120000_create_auth_audit_logs_table.php
chore: commit current workspace changes
2026-05-02 09:37:14 +02:00
2026_05_01_120000_create_homepage_announcements_table.php
Add homepage announcement module
2026-05-01 11:43:08 +02:00
2026_05_01_150000_add_news_comments_support.php
Add news article comments and reactions
2026-05-01 11:43:49 +02:00
2026_05_01_230000_create_news_article_comment_reactions_table.php
Add news article comments and reactions
2026-05-01 11:43:49 +02:00
2026_05_03_000001_create_academy_categories_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000002_create_academy_lessons_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000003_create_academy_prompt_templates_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000004_create_academy_prompt_packs_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000005_create_academy_prompt_pack_items_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000006_create_academy_challenges_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000007_create_academy_challenge_submissions_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000008_create_academy_lesson_progress_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000009_create_academy_saved_prompts_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000010_create_academy_badges_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_000011_create_academy_user_badges_table.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_03_120000_decode_news_categories_html_entities.php
feat(academy): prepare AI Academy v1 for production enablement
2026-05-03 19:59:27 +02:00
2026_05_05_000001_create_academy_lesson_blocks_table.php
Featured artworks thumbnails
2026-05-06 19:11:31 +02:00
2026_05_05_000002_create_academy_ai_comparison_results_table.php
Featured artworks thumbnails
2026-05-06 19:11:31 +02:00
2026_05_05_000003_add_created_at_index_to_artwork_comments_table.php
Featured artworks thumbnails
2026-05-06 19:11:31 +02:00
2026_05_07_000001_add_content_markdown_to_academy_lessons_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000002_add_course_fields_to_academy_lessons_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000003_add_article_cover_image_to_academy_lessons_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000004_add_tags_to_academy_lessons_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000005_create_academy_courses_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000006_create_academy_course_sections_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000007_create_academy_course_lessons_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_000008_create_academy_course_enrollments_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_07_180000_create_academy_lesson_revisions_table.php
chore: commit remaining workspace changes
2026-05-08 21:51:29 +02:00
2026_05_08_120000_create_world_web_stories_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_08_120100_create_world_web_story_pages_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000001_create_academy_events_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000002_create_academy_content_metrics_daily_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000003_create_academy_likes_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000004_create_academy_saves_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000005_create_academy_user_progress_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_11_000006_create_academy_search_logs_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_14_000001_add_advanced_fields_to_academy_prompt_templates_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_14_000001_add_created_at_indexes_to_activity_feed_tables.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_104802_create_customer_columns.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_104803_create_subscriptions_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_104804_create_subscription_items_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_104805_add_meter_id_to_subscription_items_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_104806_add_meter_event_name_to_subscription_items_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_19_120000_create_academy_billing_events_table.php
Implement academy analytics, billing, and web stories updates
2026-05-26 07:27:29 +02:00
2026_05_26_120000_create_enhance_jobs_table.php
Allow heading tags (h1-h6) in ContentSanitizer so news editor headings render
2026-06-04 07:52:57 +02:00
2026_05_30_000001_add_unique_index_to_news_views_table.php
Allow heading tags (h1-h6) in ContentSanitizer so news editor headings render
2026-06-04 07:52:57 +02:00
2026_05_30_000002_add_external_url_to_news_article_relations_table.php
Allow heading tags (h1-h6) in ContentSanitizer so news editor headings render
2026-06-04 07:52:57 +02:00
2026_06_06_120000_add_filled_examples_to_academy_prompt_templates_table.php
Optimize academy
2026-06-09 13:16:01 +02:00
2026_06_09_120000_create_security_reports_table.php
Current state with latest updates
2026-08-23 13:28:34 +02:00
2026_08_01_000001_add_featured_thumbnail_audit_columns_to_artworks_table.php
Current state with latest updates
2026-08-23 13:28:34 +02:00
2026_08_23_120000_drop_duplicate_artwork_metric_snapshot_index.php
Ship production optimization M1-M12.5A: queues, metrics, HTTP observability, and vector search reliability.
2026-08-25 07:58:47 +02:00
2026_09_05_000001_add_download_availability_to_artworks_table.php
Track original artwork file availability more accurately.
2026-09-20 14:49:19 +02:00
2026_09_10_000001_add_artwork_moderation_audit_fields.php
Send new artwork uploads through a trust-based review policy.
2026-09-20 14:49:06 +02:00
2026_09_10_000010_add_comment_spam_metadata.php
Add comment spam classification and captcha checks.
2026-09-20 14:48:50 +02:00
2026_09_17_120000_expand_user_profiles_gender_enum.php
Expand profile gender options and cover country plus activity persistence.
2026-09-20 14:50:59 +02:00
2026_09_17_130000_add_hit_count_to_comment_spam_signatures_table.php
Add comment spam classification and captcha checks.
2026-09-20 14:48:50 +02:00
2026_09_20_120000_create_adsense_analytics_tables.php
Add a read-only Google AdSense analytics module for admins.
2026-09-20 14:49:48 +02:00
2026_09_20_140000_add_primary_category_support_to_artworks.php
Allow artworks to have one primary category and extra secondaries.
2026-09-20 14:50:12 +02:00