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

CREATE TABLE `op_broker_workflows` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `definition` json NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

ALTER TABLE `op_broker_workflows`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;
