Revision 3214
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2972 | 2972 |
|
| 2973 | 2973 |
|
| 2974 | 2974 |
-- |
| 2975 |
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 2976 |
-- |
|
| 2977 |
|
|
| 2978 |
ALTER TABLE commclass |
|
| 2979 |
ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes); |
|
| 2980 |
|
|
| 2981 |
|
|
| 2982 |
-- |
|
| 2983 | 2975 |
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 2984 | 2976 |
-- |
| 2985 | 2977 |
|
| ... | ... | |
| 3694 | 3686 |
|
| 3695 | 3687 |
|
| 3696 | 3688 |
-- |
| 3689 |
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3690 |
-- |
|
| 3691 |
|
|
| 3692 |
|
|
| 3693 |
|
|
| 3694 |
|
|
| 3695 |
-- |
|
| 3697 | 3696 |
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3698 | 3697 |
-- |
| 3699 | 3698 |
|
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.)