Revision 12006
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 6155 | 6155 |
|
| 6156 | 6156 |
|
| 6157 | 6157 |
-- |
| 6158 |
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 6158 |
-- Name: commconcept_unique_commdescription; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 6159 | 6159 |
-- |
| 6160 | 6160 |
|
| 6161 | 6161 |
ALTER TABLE commconcept |
| 6162 |
ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
|
|
| 6162 |
ADD CONSTRAINT commconcept_unique_commdescription UNIQUE (commdescription);
|
|
| 6163 | 6163 |
|
| 6164 | 6164 |
|
| 6165 | 6165 |
-- |
| 6166 |
-- Name: commconcept_unique_commname; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 6167 |
-- |
|
| 6168 |
|
|
| 6169 |
ALTER TABLE commconcept |
|
| 6170 |
ADD CONSTRAINT commconcept_unique_commname UNIQUE (commname_id); |
|
| 6171 |
|
|
| 6172 |
|
|
| 6173 |
-- |
|
| 6166 | 6174 |
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 6167 | 6175 |
-- |
| 6168 | 6176 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: commconcept: added missing unique constraint on commdescription, which is also an identifying field in addition to the ID (which is in commname.commname)