Revision 3214
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 3506 | 3506 |
|
| 3507 | 3507 |
|
| 3508 | 3508 |
-- |
| 3509 |
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3510 |
-- |
|
| 3511 |
|
|
| 3512 |
ALTER TABLE ONLY commclass |
|
| 3513 |
ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes); |
|
| 3514 |
|
|
| 3515 |
|
|
| 3516 |
-- |
|
| 3517 | 3509 |
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3518 | 3510 |
-- |
| 3519 | 3511 |
|
| ... | ... | |
| 4225 | 4217 |
|
| 4226 | 4218 |
|
| 4227 | 4219 |
-- |
| 4220 |
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4221 |
-- |
|
| 4222 |
|
|
| 4223 |
CREATE INDEX commclass_unique ON commclass USING btree (locationevent_id, (COALESCE(classnotes, '\\N'::text))); |
|
| 4224 |
|
|
| 4225 |
|
|
| 4226 |
-- |
|
| 4228 | 4227 |
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4229 | 4228 |
-- |
| 4230 | 4229 |
|
Also available in: Unified diff
schemas/vegbien.sql: commclass: Changed commclass_unique to COALESCE classnotes so that there is only one commclass for a locationevent when the commclasses are not separately named. (Currently classnotes is used as the class name field, commname being the name of the community itself.)