Revision 3214
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/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 |
|
| schemas/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.)