v3.0

• Funding support;
• Personalised email templates with organisation branding;

DB Updates:

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;

Second Stage

• Authentication via ORCID;
• Affiliation record enrichment;
• New feel and look.