
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE TABLE `op_targets` (
  `id` int NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `ws_url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `op_targets` (`id`, `short_name`, `ws_url`, `created_at`) VALUES
(1, 'Wall-E Prod', 'ws://chargingatwalle.germanywestcentral.azurecontainer.io:7020/ocpp16', '2025-06-21 09:10:55'),
(2, 'Dekra Dev', 'ws://chargeAtDekraTest.westeurope.azurecontainer.io:7020/ocpp16', '2025-06-21 09:10:55'),
(3, 'Neleso Steve', 'ws://ocpp.neleso.com:8080/steve/websocket/CentralSystemService', '2025-06-21 09:13:09'),
(4, 'Dekra Prod', 'ws://chargingatdekra.germanywestcentral.azurecontainer.io:7020/ocpp16', '2025-06-21 09:13:09'),
(5, 'Monta Prod', 'wss://ocpp.monta.app', '2025-06-21 09:13:09');

ALTER TABLE `op_targets`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `op_targets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

