mchus/PriceForge
1
0
Fork 0
Code Issues 4 Pull Requests Actions Packages Releases 2 Activity
Files
main
PriceForge/migrations
History
Mikhail Chusavitin 5f8aec456b Unified Quote Journal (parts_log) v3 
- New unified append-only quote log table parts_log replaces three
  separate log tables (stock_log, partnumber_log_competitors, lot_log)
- Migrations 042-049: extend supplier, create parts_log/import_formats/
  ignore_rules, rework qt_lot_metadata composite PK, add lead_time_weeks
  to pricelist_items, backfill data, migrate ignore rules
- New services: PartsLogBackfillService, ImportFormatService,
  UnifiedImportService; new world pricelist type (all supplier types)
- qt_lot_metadata PK changed to (lot_name, pricelist_type); all queries
  now filter WHERE pricelist_type='estimate'
- Fix pre-existing bug: qt_component_usage_stats column names
  quotes_last30d/quotes_last7d (no underscore) — added explicit gorm tags
- Bible: full table inventory, baseline schema snapshot, updated pricelist/
  data-rules/api/history/architecture docs

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-21 17:25:54 +03:00
..
001_add_lot_category.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
002_add_custom_price.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
003_add_is_hidden.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
004_add_price_updated_at.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
005_add_owner_username.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
006_add_local_configuration_versions.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
007_detach_configurations_from_qt_users.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
008_add_app_version_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
009_add_projects.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
010_add_pricelist_sync_status.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
010_add_pricelist_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
011_add_app_version_to_pricelist_sync_status.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
012_add_project_tracker_url.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
013_add_pricelist_source.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
014_add_stock_log.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
015_add_lot_partnumbers.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
016_add_price_level_pricelist_bindings.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
017_update_lot_partnumbers_for_placeholders.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
018_add_stock_ignore_rules.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
019_rename_stock_log_lot_to_partnumber.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
020_add_only_in_stock_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
021_add_pricelist_items_pricelist_lot_index.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
022_add_lot_category_to_pricelist_items.sql
fix: потоковая отправка прогресса создания прайслиста и исправление маппинга колонки категории
2026-02-10 15:17:16 +03:00
023_vendor_partnumber_global_mapping.sql
Implement global vendor mappings with bundle support and seen-based ignore
2026-02-18 19:54:07 +03:00
024_backfill_vendor_seen_from_stock_and_ignore.sql
Implement global vendor mappings with bundle support and seen-based ignore
2026-02-18 19:54:07 +03:00
025_dedup_vendor_seen_by_partnumber.sql
Deduplicate vendor seen by partnumber and fix vendor mappings list
2026-02-20 15:37:41 +03:00
026_add_partnumber_books.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
027_fix_partnumber_books_version_length.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
028_add_description_to_partnumber_book_items.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
029_drop_unused_qt_bom.sql
Refactor scheduler and settings UI
2026-03-07 21:10:20 +03:00
030_add_scheduler_runs.sql
Refactor scheduler and settings UI
2026-03-07 21:10:20 +03:00
031_drop_is_primary_pn.sql
Refactor vendor mappings to canonical PN catalog
2026-03-07 23:11:42 +03:00
032_drop_legacy_vendor_mapping_tables.sql
Refactor vendor mappings to canonical PN catalog
2026-03-07 23:11:42 +03:00
033_add_competitors.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
034_add_qty_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
035_competitor_quotes_lot_nullable.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
036_competitor_quotes_align_columns.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
037_add_currency_to_competitors.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
038_add_description_vendor_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
039_add_price_loccur_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
040_competitor_uplift.sql
Replace competitor discount with price_uplift; stock pricelist detail UI
2026-03-13 12:58:41 +03:00
041_add_is_pattern_to_seen.sql
Vendor mapping: wildcard ignore patterns, bulk CSV import, multi-lot qty
2026-03-19 09:41:48 +03:00
042_extend_supplier.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
043_create_parts_log.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
044_create_import_formats.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
045_create_ignore_rules.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
046_rework_lot_metadata.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
047_pricelist_items_lead_time.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
048_backfill_parts_log.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00
049_migrate_ignore_rules.sql
Unified Quote Journal (parts_log) v3
2026-03-21 17:25:54 +03:00