Project

General

Profile

« Previous | Next » 

Revision 3668

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: *_unique_datasource UNIQUE INDEXes: Removed COALESCE from datasource_id and datasource_id IS NOT NULL filter, because datasource_id is now always NOT NULL

View differences:

vegbien.sql
4135 4135 
-- Name: aggregateoccurrence_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
4136 4136 
--
4137 4137 

  		




  4138
  
  
    
CREATE UNIQUE INDEX aggregateoccurrence_unique_datasource ON aggregateoccurrence USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4138
  
    
CREATE UNIQUE INDEX aggregateoccurrence_unique_datasource ON aggregateoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4139
  4139
  
    

  		




  4140
  4140
  
    

  		




  4141
  4141
  
    
--


  		




  ......




  4212
  4212
  
    
-- Name: locationevent_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4213
  4213
  
    
--


  		




  4214
  4214
  
    

  		




  4215
  
  
    
CREATE UNIQUE INDEX locationevent_unique_datasource ON locationevent USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4215
  
    
CREATE UNIQUE INDEX locationevent_unique_datasource ON locationevent USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4216
  4216
  
    

  		




  4217
  4217
  
    

  		




  4218
  4218
  
    
--


  		




  ......




  4317
  4317
  
    
-- Name: plantobservation_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4318
  4318
  
    
--


  		




  4319
  4319
  
    

  		




  4320
  
  
    
CREATE UNIQUE INDEX plantobservation_unique_datasource ON plantobservation USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4320
  
    
CREATE UNIQUE INDEX plantobservation_unique_datasource ON plantobservation USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4321
  4321
  
    

  		




  4322
  4322
  
    

  		




  4323
  4323
  
    
--


  		




  ......




  4338
  4338
  
    
-- Name: project_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4339
  4339
  
    
--


  		




  4340
  4340
  
    

  		




  4341
  
  
    
CREATE UNIQUE INDEX project_unique_datasource ON project USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4341
  
    
CREATE UNIQUE INDEX project_unique_datasource ON project USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4342
  4342
  
    

  		




  4343
  4343
  
    

  		




  4344
  4344
  
    
--


  		




  ......




  4394
  4394
  
    
-- Name: stemobservation_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4395
  4395
  
    
--


  		




  4396
  4396
  
    

  		




  4397
  
  
    
CREATE UNIQUE INDEX stemobservation_unique_datasource ON stemobservation USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4397
  
    
CREATE UNIQUE INDEX stemobservation_unique_datasource ON stemobservation USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4398
  4398
  
    

  		




  4399
  4399
  
    

  		




  4400
  4400
  
    
--


  		




  ......




  4422
  4422
  
    
-- Name: taxonoccurrence_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4423
  4423
  
    
--


  		




  4424
  4424
  
    

  		




  4425
  
  
    
CREATE UNIQUE INDEX taxonoccurrence_unique_datasource ON taxonoccurrence USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));


  		




  
  4425
  
    
CREATE UNIQUE INDEX taxonoccurrence_unique_datasource ON taxonoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);


  		




  4426
  4426
  
    

  		




  4427
  4427
  
    

  		




  4428
  4428
  
    
--


  		












Also available in:  Unified diff