SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS `OutboxEvent`; CREATE TABLE IF NOT EXISTS `OutboxEvent` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `body` MEDIUMTEXT NOT NULL, `headers` JSON NULL DEFAULT NULL, `topic` VARCHAR(255) NOT NULL, `key` VARCHAR(255) NULL DEFAULT NULL, `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `processed_at` TIMESTAMP NULL DEFAULT NULL, `processed_error` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (`id`), INDEX `idx_processedAt_id` ( `processed_at` ), CHECK (JSON_TYPE(`headers`) = 'OBJECT') ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1; INSERT INTO OutboxEvent (`body`, `headers`, `topic`, `key`) VALUES ('test', '"foobar"', 'topic', 'key');