Revision 6792
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: sourcelist_unique: Removed COALESCE around name because it's NOT NULL