Revision 2869
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3247 | 3247 |
|
| 3248 | 3248 |
|
| 3249 | 3249 |
-- |
| 3250 |
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3251 |
-- |
|
| 3252 |
|
|
| 3253 |
ALTER TABLE namedplace |
|
| 3254 |
ADD CONSTRAINT namedplace_unique UNIQUE (rank, placename); |
|
| 3255 |
|
|
| 3256 |
|
|
| 3257 |
-- |
|
| 3258 | 3250 |
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3259 | 3251 |
-- |
| 3260 | 3252 |
|
| ... | ... | |
| 4283 | 4275 |
|
| 4284 | 4276 |
|
| 4285 | 4277 |
-- |
| 4278 |
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4279 |
-- |
|
| 4280 |
|
|
| 4281 |
|
|
| 4282 |
|
|
| 4283 |
|
|
| 4284 |
-- |
|
| 4286 | 4285 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4287 | 4286 |
-- |
| 4288 | 4287 |
|
Also available in: Unified diff
schemas/vegbien.sql: namedplace: Fixed bug where parent_id needed to be included in UNIQUE CONSTRAINT (now UNIQUE INDEX), since there can be more than one e.g. city of the same name if they are in different states