-- Hello World plugin schema.
-- All tables MUST be prefixed with "helloworld_" (slug with hyphens
-- removed + underscore). The loader enforces this at upload.

CREATE TABLE IF NOT EXISTS `helloworld_messages` (
    `id`         INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `tenant_id`  INT UNSIGNED NOT NULL DEFAULT 1,
    `message`    VARCHAR(255) NOT NULL,
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
