35 lines
1020 B
SQL
35 lines
1020 B
SQL
-- Production sync for 2026-05-01 changes.
|
|
-- Safe to import on an existing production database.
|
|
-- Includes all schema migrations introduced on 2026-05-01.
|
|
-- Current scope:
|
|
-- 1) items.notes for internal product remarks in stock management.
|
|
|
|
SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
DROP PROCEDURE IF EXISTS apply_production_updates_20260501;
|
|
DELIMITER $$
|
|
CREATE PROCEDURE apply_production_updates_20260501()
|
|
BEGIN
|
|
-- items.notes
|
|
IF NOT EXISTS (
|
|
SELECT 1
|
|
FROM INFORMATION_SCHEMA.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE()
|
|
AND TABLE_NAME = 'items'
|
|
AND COLUMN_NAME = 'notes'
|
|
) THEN
|
|
ALTER TABLE items
|
|
ADD COLUMN notes TEXT DEFAULT NULL AFTER image_url;
|
|
END IF;
|
|
END $$
|
|
DELIMITER ;
|
|
|
|
CALL apply_production_updates_20260501();
|
|
DROP PROCEDURE IF EXISTS apply_production_updates_20260501;
|
|
|
|
SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS;
|
|
|
|
-- Optional verification after import:
|
|
-- SHOW COLUMNS FROM items;
|