Revision 6792
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5225 | 5225 |
-- Name: sourcelist_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5226 | 5226 |
-- |
| 5227 | 5227 |
|
| 5228 |
CREATE UNIQUE INDEX sourcelist_unique ON sourcelist (source_id, name); |
|
| 5228 | 5229 |
|
| 5229 | 5230 |
|
| 5230 |
|
|
| 5231 | 5231 |
-- |
| 5232 | 5232 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5233 | 5233 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 6300 | 6300 |
-- Name: sourcelist_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6301 | 6301 |
-- |
| 6302 | 6302 |
|
| 6303 |
CREATE UNIQUE INDEX sourcelist_unique ON sourcelist USING btree (source_id, (COALESCE(name, '\N'::text)));
|
|
| 6303 |
CREATE UNIQUE INDEX sourcelist_unique ON sourcelist USING btree (source_id, name);
|
|
| 6304 | 6304 |
|
| 6305 | 6305 |
|
| 6306 | 6306 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: sourcelist_unique: Removed COALESCE around name because it's NOT NULL