Changelogs » Orcid-hub

Orcid-hub

3.0

- 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;

2.0

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

Links

Releases