Revision 6907
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4864 | 4864 |
|
| 4865 | 4865 |
|
| 4866 | 4866 |
-- |
| 4867 |
-- Name: taxon_trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4868 |
-- |
|
| 4869 |
|
|
| 4870 |
ALTER TABLE taxon_trait |
|
| 4871 |
ADD CONSTRAINT taxon_trait_pkey PRIMARY KEY (`scientificName`, `measurementType`); |
|
| 4872 |
|
|
| 4873 |
|
|
| 4874 |
-- |
|
| 4875 | 4867 |
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4876 | 4868 |
-- |
| 4877 | 4869 |
|
| ... | ... | |
| 5416 | 5408 |
|
| 5417 | 5409 |
|
| 5418 | 5410 |
-- |
| 5411 |
-- Name: taxon_trait_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5412 |
-- |
|
| 5413 |
|
|
| 5414 |
CREATE INDEX `taxon_trait_scientificName_measurementType_idx` ON taxon_trait (`scientificName`, `measurementType`); |
|
| 5415 |
|
|
| 5416 |
|
|
| 5417 |
-- |
|
| 5419 | 5418 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5420 | 5419 |
-- |
| 5421 | 5420 |
|
Also available in: Unified diff
schemas/vegbien.sql: sync_taxon_trait_to_view(): Changed pkey to index because there can be multiple values of the same taxon's trait from different observations