CREATE TABLE IF NOT EXISTS `op_config` (
  `config_key` varchar(50) NOT NULL,
  `config_value` varchar(255) NOT NULL,
  `config_hint` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`config_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `op_config` (`config_key`, `config_value`, `config_hint`) VALUES
  ('mqtt_broker', '217.154.74.195', 'MQTT broker address'),
  ('mqtt_port', '1883', 'MQTT broker port'),
  ('mqtt_user', 'hitesh', 'MQTT username'),
  ('mqtt_password', 'zm0dem123', 'MQTT password'),
  ('mqtt_topic_prefix', '', 'Prefix for published MQTT topics'),
  ('ocpp_proxy_ip', '217.154.74.195', 'IP address of the OCPP proxy'),
  ('ocpp_proxy_port', '7020', 'Port of the OCPP proxy'),
  ('ocpp_server_port', '8080', 'Port of the simple OCPP server'),
  ('ocpp_api_port', '9751', 'Port of the OCPP HTTP API server'),
  ('ocpp_server_fw_url_prefix', '', 'Absolute base URL used to serve firmware files'),
  ('dashboard_port', '5000', 'Port of this dashboard'),
  ('diag_ftp_host', '217.160.79.201', 'Hostname or IP address of the diagnostics FTP server');
