Project

General

Profile

« Previous | Next » 

Revision 6004

Added by Aaron Marcuse-Kubitza over 11 years ago

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

View differences:

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