• Home
• fr.maif
• izanami_2.13
• 2.4.3
• source code
• V12__create_event_table.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.globals.V12__create_event_table.sql Maven / Gradle / Ivy

CREATE TYPE GLOBAL_EVENT_TYPES AS ENUM ('TENANT_CREATED', 'TENANT_DELETED');
CREATE TYPE LOCAL_EVENT_TYPES AS ENUM ('FEATURE_CREATED', 'FEATURE_UPDATED', 'FEATURE_DELETED');


CREATE TABLE global_events (
    id bigint PRIMARY KEY DEFAULT nextval('izanami.eventid'),
    event_type GLOBAL_EVENT_TYPES NOT NULL,
    entity_id TEXT NOT NULL,
    event JSONB NOT NULL
);