- Funding support;
- Personalised email templates with organisation branding;
DB Updates:
sql
ALTER TABLE organisation ADD can_use_api boolean NULL;
ALTER TABLE audit.organisation ADD can_use_api boolean NULL;
CREATE TABLE public.file
(
id integer NOT NULL DEFAULT nextval('file_id_seq'::regclass),
filename character varying(100) NOT NULL,
data bytea NOT NULL,
mime_type character varying(30) NOT NULL,
token character(8) NOT NULL,
CONSTRAINT file_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.file
OWNER TO orcidhub;
CREATE UNIQUE INDEX file_token
ON public.file
USING btree
(token COLLATE pg_catalog."default");
ALTER TABLE organisation ADD IF NOT EXISTS logo_id integer;
ALTER TABLE organisation ADD CONSTRAINT organisation_logo_id_fkey FOREIGN KEY (logo_id)
REFERENCES public.file (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
CREATE INDEX organisation_logo_id
ON public.organisation
USING btree
(logo_id);
ALTER TABLE organisation ADD IF NOT EXISTS email_template text null;
ALTER TABLE organisation ADD IF NOT EXISTS email_template_enabled boolean null default false;
ALTER TABLE audit.organisation ADD IF NOT EXISTS logo_id integer;
ALTER TABLE audit.organisation ADD IF NOT EXISTS email_template text null;
ALTER TABLE audit.organisation ADD IF NOT EXISTS email_template_enabled boolean null default false;
ALTER TABLE task ADD COLUMN IF NOT EXISTS expires_at timestamp without time zone;
ALTER TABLE task ADD COLUMN task_type smallint default 0;
ALTER TABLE affiliation_record DROP CONSTRAINT affiliation_record_task_id_fkey;
ALTER TABLE affiliation_record ADD CONSTRAINT affiliation_record_task_id_fkey
FOREIGN KEY (task_id)
REFERENCES public.task (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
ALTER TABLE funding_record DROP CONSTRAINT funding_record_task_id_fkey;
ALTER TABLE funding_record ADD
CONSTRAINT funding_record_task_id_fkey FOREIGN KEY (task_id)
REFERENCES public.task (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
ALTER TABLE funding_contributor DROP CONSTRAINT funding_contributor_funding_record_id_fkey;
ALTER TABLE funding_contributor ADD
CONSTRAINT funding_contributor_funding_record_id_fkey FOREIGN KEY (funding_record_id)
REFERENCES public.funding_record (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
ALTER TABLE external_id DROP CONSTRAINT external_id_funding_record_id_fkey;
ALTER TABLE external_id ADD
CONSTRAINT external_id_funding_record_id_fkey FOREIGN KEY (funding_record_id)
REFERENCES public.funding_record (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
ALTER TABLE funding_record ALTER COLUMN title TYPE character varying(255);
ALTER TABLE funding_record ALTER COLUMN translated_title TYPE character varying(255);
ALTER TABLE funding_record ALTER COLUMN type TYPE character varying(255);
ALTER TABLE funding_record ALTER COLUMN organization_defined_type TYPE character varying(255);
ALTER TABLE funding_record ALTER COLUMN amount TYPE character varying(255);
ALTER TABLE external_id ALTER COLUMN type TYPE character varying(255);
ALTER TABLE external_id ALTER COLUMN relationship TYPE character varying(255);
ALTER TABLE funding_record DROP COLUMN IF EXISTS created_at;
ALTER TABLE funding_record DROP COLUMN IF EXISTS updated_at;