5f8aec456b
- 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>
13 lines
570 B
SQL
13 lines
570 B
SQL
-- Migrate existing ignored entries from qt_vendor_partnumber_seen to qt_ignore_rules.
|
|
-- Rows with is_ignored=1 and is_pattern=0 become exact partnumber rules.
|
|
-- Rows with is_ignored=1 and is_pattern=1 become glob partnumber rules.
|
|
INSERT IGNORE INTO qt_ignore_rules (field, match_type, pattern, note, created_by)
|
|
SELECT
|
|
'partnumber',
|
|
CASE WHEN is_pattern = 1 THEN 'glob' ELSE 'exact' END,
|
|
partnumber,
|
|
CONCAT('Migrated from qt_vendor_partnumber_seen id=', id),
|
|
COALESCE(ignored_by, 'migration')
|
|
FROM qt_vendor_partnumber_seen
|
|
WHERE is_ignored = 1;
|