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>
7 lines
322 B
SQL
7 lines
322 B
SQL
-- Add lead_time_weeks to qt_pricelist_items.
|
|
-- Nullable: 99 means no data available, NULL means not applicable.
|
|
-- Backward compatible: existing clients that don't know this column ignore it.
|
|
ALTER TABLE qt_pricelist_items
|
|
ADD COLUMN lead_time_weeks INT NULL
|
|
COMMENT '99 if no data, NULL if not applicable';
|