• Home
• fr.maif
• izanami_2.13
• 2.4.3
• source code
• V5__create_configuration_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.V5__create_configuration_table.sql Maven / Gradle / Ivy

CREATE TABLE configuration (
    onerow_id bool PRIMARY KEY DEFAULT TRUE,
    mailer TEXT REFERENCES mailers(name) NOT NULL,
    invitation_mode TEXT NOT NULL,
    origin_email TEXT,
    izanami_id UUID NOT NULL DEFAULT gen_random_uuid(),
    anonymous_reporting BOOLEAN DEFAULT false,
    anonymous_reporting_date TIMESTAMP WITH TIME ZONE,
    CONSTRAINT onerow_uni CHECK (onerow_id)
);

INSERT INTO configuration(mailer, invitation_mode)
values ('CONSOLE', 'RESPONSE');