github.com/kyma-project/kyma-environment-broker@v0.0.1/migrations/202209211320_events.up.sql (about)

     1  BEGIN;
     2  
     3  DO $$ BEGIN
     4      CREATE TYPE event_level AS ENUM ('info', 'error');
     5  EXCEPTION
     6      WHEN duplicate_object THEN null;
     7  END $$;
     8  
     9  CREATE TABLE IF NOT EXISTS events (
    10      id             varchar(255) NOT NULL PRIMARY KEY,
    11      level          event_level NOT NULL,
    12      instance_id    varchar(255) references instances (instance_id),
    13      operation_id   varchar(255) references operations (id),
    14      message        text NOT NULL,
    15      created_at     timestamp with time zone NOT NULL
    16  );
    17  
    18  CREATE INDEX IF NOT EXISTS events_id ON events USING HASH (id);
    19  CREATE INDEX IF NOT EXISTS events_operation_id ON events USING HASH (operation_id);
    20  
    21  COMMIT;