• Home
• io.gravitee.am.reporter
• gravitee-am-reporter-jdbc
• 3.10.0
• source code
• postgresql.schema

×

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.

database.postgresql.schema Maven / Gradle / Ivy

--
-- Script to create Postgresql schema
-- Table & index names are suffixed by 3 underscores to define a
-- pattern to replace with the reporter name
--
CREATE TABLE IF NOT EXISTS reporter_audits___ (id VARCHAR(64) NOT NULL, transaction_id VARCHAR(64), type VARCHAR(255), reference_type VARCHAR(64), reference_id VARCHAR(64), timestamp TIMESTAMP(6) WITHOUT TIME ZONE, PRIMARY KEY(id))
CREATE TABLE IF NOT EXISTS reporter_audits_outcomes___ (audit_id VARCHAR(64) NOT NULL, status VARCHAR(64), message TEXT)
CREATE TABLE IF NOT EXISTS reporter_audits_access_points___ (audit_id VARCHAR(64) NOT NULL, id VARCHAR(255), alternative_id VARCHAR(320), display_name VARCHAR(255), ip_address VARCHAR(255), user_agent VARCHAR(255))
CREATE TABLE IF NOT EXISTS reporter_audits_entities___ (audit_id VARCHAR(64) NOT NULL, audit_field VARCHAR(64) NOT NULL, id VARCHAR(64), alternative_id VARCHAR(320), display_name VARCHAR(256), type VARCHAR(64), display_ame VARCHAR(255), reference_type VARCHAR(64), reference_id VARCHAR(64), attributes TEXT)

CREATE INDEX IF NOT EXISTS idx_audits_ref___ ON reporter_audits___(reference_id, reference_type)
CREATE INDEX IF NOT EXISTS idx_audits_type___ ON reporter_audits___(type)
CREATE INDEX IF NOT EXISTS idx_audits_timestamp___ ON reporter_audits___(timestamp)
CREATE INDEX IF NOT EXISTS idx_audit_outcomes_id___ ON reporter_audits_outcomes___(audit_id)
CREATE INDEX IF NOT EXISTS idx_audit_outcomes_status___ ON reporter_audits_outcomes___(status)
CREATE INDEX IF NOT EXISTS idx_audit_access_points_id___ ON reporter_audits_access_points___(audit_id)
CREATE INDEX IF NOT EXISTS idx_audit_access_points_alternative_id___ ON reporter_audits_access_points___(alternative_id)
CREATE INDEX IF NOT EXISTS idx_audit_entities_id___ ON reporter_audits_entities___(audit_id)
CREATE INDEX IF NOT EXISTS idx_audit_entities_alternative_id___ ON reporter_audits_entities___(alternative_id)