-- ABS Master Data: stoc confirmat si locatie editabile inline
-- Script idempotent pentru MySQL/MariaDB.

SET @db_name := DATABASE();

SET @sql := IF(
    EXISTS(
        SELECT 1 FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA=@db_name
          AND TABLE_NAME='md_products'
          AND COLUMN_NAME='confirmed_stock'
    ),
    'SELECT 1',
    'ALTER TABLE `md_products` ADD COLUMN `confirmed_stock` DECIMAL(15,3) NOT NULL DEFAULT 0.000 AFTER `stock_quantity`'
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF(
    EXISTS(
        SELECT 1 FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA=@db_name
          AND TABLE_NAME='md_products'
          AND COLUMN_NAME='stock_checked_at'
    ),
    'SELECT 1',
    'ALTER TABLE `md_products` ADD COLUMN `stock_checked_at` DATETIME NULL AFTER `confirmed_stock`'
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

-- location_code exista deja in instalatiile ABS actuale. Il cream doar daca lipseste.
SET @sql := IF(
    EXISTS(
        SELECT 1 FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA=@db_name
          AND TABLE_NAME='md_products'
          AND COLUMN_NAME='location_code'
    ),
    'SELECT 1',
    'ALTER TABLE `md_products` ADD COLUMN `location_code` VARCHAR(100) NULL AFTER `stock_checked_at`'
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;