CREATE TABLE IF NOT EXISTS repair_jobs (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 company_id INT UNSIGNED NOT NULL, store_id INT UNSIGNED NOT NULL,
 repair_no VARCHAR(40) NOT NULL, customer_id INT UNSIGNED NULL,
 customer_name VARCHAR(200) NOT NULL, phone VARCHAR(50) NULL, address TEXT NULL,
 item_description VARCHAR(255) NOT NULL, notes TEXT NULL,
 labor_amount DECIMAL(14,2) NOT NULL DEFAULT 0,
 subtotal DECIMAL(14,2) NOT NULL DEFAULT 0, discount DECIMAL(14,2) NOT NULL DEFAULT 0,
 grand_total DECIMAL(14,2) NOT NULL DEFAULT 0, paid_amount DECIMAL(14,2) NOT NULL DEFAULT 0,
 balance DECIMAL(14,2) NOT NULL DEFAULT 0,
 status ENUM('RECEIVED','IN_PROGRESS','READY','DELIVERED','CANCELLED') NOT NULL DEFAULT 'RECEIVED',
 created_by INT UNSIGNED NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 UNIQUE KEY uq_repair_no(company_id,repair_no), KEY idx_repair_customer(company_id,customer_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS repair_items (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 repair_id BIGINT UNSIGNED NOT NULL, product_id INT UNSIGNED NULL,
 item_name VARCHAR(200) NOT NULL, quantity DECIMAL(14,3) NOT NULL DEFAULT 1,
 unit_price DECIMAL(14,2) NOT NULL DEFAULT 0, line_total DECIMAL(14,2) NOT NULL DEFAULT 0,
 item_type ENUM('STOCK','CUSTOM') NOT NULL DEFAULT 'STOCK',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY idx_repair_items(repair_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;