Revision 3192
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 5028 | 5028 |
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5029 | 5029 |
-- |
| 5030 | 5030 |
|
| 5031 |
CREATE UNIQUE INDEX plantnamescope_unique ON plantnamescope USING btree ((COALESCE(locationevent_id, 0)), (COALESCE(project_id, 0)), (COALESCE(namedplace_id, 0)));
|
|
| 5031 |
CREATE UNIQUE INDEX plantnamescope_unique ON plantnamescope USING btree ((COALESCE(locationevent_id, 2147483647)), (COALESCE(project_id, 2147483647)), (COALESCE(namedplace_id, 2147483647)));
|
|
| 5032 | 5032 |
|
| 5033 | 5033 |
|
| 5034 | 5034 |
-- |
| ... | ... | |
| 5308 | 5308 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5309 | 5309 |
-- |
| 5310 | 5310 |
|
| 5311 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, role, (COALESCE(party_id, 0)), plantconcept_id);
|
|
| 5311 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, role, (COALESCE(party_id, 2147483647)), plantconcept_id);
|
|
| 5312 | 5312 |
|
| 5313 | 5313 |
|
| 5314 | 5314 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Fixed UNIQUE INDEXes that were still using COALESCE to use COALESCE in order to match what sql_gen.EnsureNotNull uses