Project

General

Profile

« Previous | Next » 

Revision 6148

schemas/vegbien.sql: referencename: Added referencename_unique unique index on name

View differences:

schemas/vegbien.my.sql
5066 5066

  
5067 5067

  
5068 5068
--
5069
-- Name: referencename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5070
--
5071

  
5072

  
5073

  
5074

  
5075
--
5069 5076
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5070 5077
--
5071 5078

  
schemas/vegbien.sql
6033 6033

  
6034 6034

  
6035 6035
--
6036
-- Name: referencename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
6037
--
6038

  
6039
CREATE UNIQUE INDEX referencename_unique ON referencename USING btree ((COALESCE(name, '\\N'::text)));
6040

  
6041

  
6042
--
6036 6043
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
6037 6044
--
6038 6045

  

Also available in: Unified diff