/ - Diff - D-Net - D-Net project tracking tool

« Previous | Next »

Revision 57435

some "not null"

     CREATE TABLE openaire_simrels (
     	local_id         text REFERENCES organizations(id) ON UPDATE CASCADE,
     	oa_id            text,
     	oa_original_id   text,
     	oa_name          text,
      	oa_id            text NOT NULL,
     	oa_original_id   text NOT NULL,
     	oa_name          text NOT NULL,
     	oa_acronym       text,
     	oa_country       text,
     	oa_url           text,
     	oa_collectedfrom text,
     	reltype          text  NOT NULL DEFAULT 'suggested',
     	reltype          text NOT NULL DEFAULT 'suggested',
     	PRIMARY KEY (local_id, oa_id)
     );
     CREATE INDEX openaire_simrels_local_id_idx ON openaire_simrels(local_id);

Also available in: Unified diff