Skip to content
Snippets Groups Projects

Sazba diplomů

Merged Sazba diplomů
diplomy into devel
Merged
Martin Marešrequested to merge
diplomy into devel
Compare
and
Show latest version
20 files
+ 906
− 181
Compare changes
  • Side-by-side
  • Inline

Files

db/db.ddl
+ 3
− 6
@@ -507,13 +507,8 @@ CREATE TABLE cert_sets (
contest_id int PRIMARY KEY REFERENCES contests(contest_id) ON DELETE CASCADE,
-- nastavení certifikátů
changed_at timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, -- kdy se naposledy změnilo
signer1_name text DEFAULT NULL,
signer1_title text DEFAULT NULL,
signer2_name text DEFAULT NULL,
signer2_title text DEFAULT NULL,
issue_place text DEFAULT NULL,
issue_date text DEFAULT NULL,
background_file text DEFAULT NULL, -- relativně vůči mo.util.data_dir('cert')
design_params jsonb NOT NULL DEFAULT '{}', -- viz mo.jobs.certs.DesignParams
tex_hacks text NOT NULL DEFAULT '',
-- vygenerované certifikáty
scoretable_id int DEFAULT NULL REFERENCES score_tables(scoretable_id), -- ze které výsledkovky
@@ -545,6 +540,8 @@ CREATE TABLE certificates (
UNIQUE (cert_set_id, user_id, type)
);
CREATE INDEX certificates_user_id_index ON certificates (user_id);
-- Odeslané mailové notifikace
CREATE TABLE sent_email (