Project

General

Profile

« Previous | Next » 

Revision 6004

schemas/vegbien.sql: method: method_unique: Added reference_id to make method unique within the datasource instead of globally unique within VegBIEN

View differences:

schemas/vegbien.sql
5060 5060
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5061 5061
--
5062 5062

  
5063
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, '\\N'::text)));
5063
CREATE UNIQUE INDEX method_unique ON method USING btree (reference_id, name, (COALESCE(description, '\\N'::text)));
5064 5064

  
5065 5065

  
5066 5066
--

Also available in: Unified diff