Revision 12006
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/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 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 7772 | 7772 |
|
| 7773 | 7773 |
|
| 7774 | 7774 |
-- |
| 7775 |
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 7775 |
-- Name: commconcept_unique_commdescription; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 7776 | 7776 |
-- |
| 7777 | 7777 |
|
| 7778 | 7778 |
ALTER TABLE ONLY commconcept |
| 7779 |
ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
|
|
| 7779 |
ADD CONSTRAINT commconcept_unique_commdescription UNIQUE (commdescription);
|
|
| 7780 | 7780 |
|
| 7781 | 7781 |
|
| 7782 | 7782 |
-- |
| 7783 |
-- Name: commconcept_unique_commname; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 7784 |
-- |
|
| 7785 |
|
|
| 7786 |
ALTER TABLE ONLY commconcept |
|
| 7787 |
ADD CONSTRAINT commconcept_unique_commname UNIQUE (commname_id); |
|
| 7788 |
|
|
| 7789 |
|
|
| 7790 |
-- |
|
| 7783 | 7791 |
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 7784 | 7792 |
-- |
| 7785 | 7793 |
|
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)