Revision 7130
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4925 | 4925 |
|
| 4926 | 4926 |
|
| 4927 | 4927 |
-- |
| 4928 |
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4929 |
-- |
|
| 4930 |
|
|
| 4931 |
ALTER TABLE taxonverbatim |
|
| 4932 |
ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id); |
|
| 4933 |
|
|
| 4934 |
|
|
| 4935 |
-- |
|
| 4936 | 4928 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4937 | 4929 |
-- |
| 4938 | 4930 |
|
| ... | ... | |
| 6151 | 6143 |
|
| 6152 | 6144 |
|
| 6153 | 6145 |
-- |
| 6146 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6147 |
-- |
|
| 6148 |
|
|
| 6149 |
|
|
| 6150 |
|
|
| 6151 |
|
|
| 6152 |
-- |
|
| 6154 | 6153 |
-- Name: telephone_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6155 | 6154 |
-- |
| 6156 | 6155 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 6047 | 6047 |
|
| 6048 | 6048 |
|
| 6049 | 6049 |
-- |
| 6050 |
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 6051 |
-- |
|
| 6052 |
|
|
| 6053 |
ALTER TABLE ONLY taxonverbatim |
|
| 6054 |
ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id); |
|
| 6055 |
|
|
| 6056 |
|
|
| 6057 |
-- |
|
| 6058 | 6050 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 6059 | 6051 |
-- |
| 6060 | 6052 |
|
| ... | ... | |
| 7273 | 7265 |
|
| 7274 | 7266 |
|
| 7275 | 7267 |
-- |
| 7268 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7269 |
-- |
|
| 7270 |
|
|
| 7271 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree (taxonlabel_id, (COALESCE(morphospecies, '\N'::text))); |
|
| 7272 |
|
|
| 7273 |
|
|
| 7274 |
-- |
|
| 7276 | 7275 |
-- Name: telephone_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7277 | 7276 |
-- |
| 7278 | 7277 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: taxonverbatim_unique: Added morphospecies so that there can be multiple taxonverbatims for the same taxonlabel, each with different morphospecies suffixes