-- LP System V2 migration 0005_m5_realtime: M5: live update events (B14, J-07).
-- GENERATED by scripts/generate-migration.ts from prisma schema snapshots. Do not edit by hand.
-- Every table states ENGINE, charset and collation explicitly; nothing relies on server or database defaults.
-- Every statement can be re-run safely (IF NOT EXISTS / INSERT IGNORE) so an interrupted migration always resumes.
-- CreateTable
CREATE TABLE IF NOT EXISTS `RealtimeEvent` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `userId` VARCHAR(191) NULL,
    `audience` VARCHAR(16) NULL,
    `kind` VARCHAR(32) NOT NULL,
    `payload` JSON NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),

    INDEX `RealtimeEvent_userId_id_idx`(`userId`, `id`),
    INDEX `RealtimeEvent_audience_id_idx`(`audience`, `id`),
    INDEX `RealtimeEvent_createdAt_idx`(`createdAt`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_nopad_bin;

INSERT INTO `SystemMeta` (`key`, `value`, `updatedAt`) VALUES ('schema_version', '5', CURRENT_TIMESTAMP(3)) ON DUPLICATE KEY UPDATE `value` = '5', `updatedAt` = CURRENT_TIMESTAMP(3);