-- Upgrade 1.2.0 -> 1.3.0
-- Instalador/atualizador com controle de versao do banco.

CREATE TABLE IF NOT EXISTS app_settings (
  setting_key VARCHAR(100) PRIMARY KEY,
  setting_value TEXT NULL,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS schema_migrations (
  version VARCHAR(50) PRIMARY KEY,
  description VARCHAR(255) NULL,
  applied_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT IGNORE INTO schema_migrations (version, description) VALUES
('1.0.0', 'Baseline inicial'),
('1.2.0', 'Clientes, recebimento cripto e envios cripto'),
('1.3.0', 'Instalador e atualizador automatico');

INSERT INTO app_settings (setting_key, setting_value) VALUES ('app_version', '1.3.0')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);