Revision 1315
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 14 new rows into database |
|
| 1 |
Inserted 20 new rows into database |
|
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1143 | 1143 |
placedescription text, |
| 1144 | 1144 |
placecode text, |
| 1145 | 1145 |
accessioncode text, |
| 1146 |
parent_id int(11) |
|
| 1146 |
parent_id int(11), |
|
| 1147 |
rank text |
|
| 1147 | 1148 |
); |
| 1148 | 1149 |
|
| 1149 | 1150 |
|
| ... | ... | |
| 3191 | 3192 |
|
| 3192 | 3193 |
|
| 3193 | 3194 |
-- |
| 3194 |
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3195 |
-- |
|
| 3196 |
|
|
| 3197 |
ALTER TABLE namedplace |
|
| 3198 |
ADD CONSTRAINT namedplace_unique UNIQUE (placesystem, placename); |
|
| 3199 |
|
|
| 3200 |
|
|
| 3201 |
-- |
|
| 3202 | 3195 |
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3203 | 3196 |
-- |
| 3204 | 3197 |
|
| ... | ... | |
| 4192 | 4185 |
|
| 4193 | 4186 |
|
| 4194 | 4187 |
-- |
| 4188 |
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4189 |
-- |
|
| 4190 |
|
|
| 4191 |
|
|
| 4192 |
|
|
| 4193 |
|
|
| 4194 |
-- |
|
| 4195 | 4195 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4196 | 4196 |
-- |
| 4197 | 4197 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1364 | 1364 |
placedescription text, |
| 1365 | 1365 |
placecode text, |
| 1366 | 1366 |
accessioncode text, |
| 1367 |
parent_id integer |
|
| 1367 |
parent_id integer, |
|
| 1368 |
rank placerank |
|
| 1368 | 1369 |
); |
| 1369 | 1370 |
|
| 1370 | 1371 |
|
| ... | ... | |
| 3602 | 3603 |
|
| 3603 | 3604 |
|
| 3604 | 3605 |
-- |
| 3605 |
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3606 |
-- |
|
| 3607 |
|
|
| 3608 |
ALTER TABLE ONLY namedplace |
|
| 3609 |
ADD CONSTRAINT namedplace_unique UNIQUE (placesystem, placename); |
|
| 3610 |
|
|
| 3611 |
|
|
| 3612 |
-- |
|
| 3613 | 3606 |
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3614 | 3607 |
-- |
| 3615 | 3608 |
|
| ... | ... | |
| 4603 | 4596 |
|
| 4604 | 4597 |
|
| 4605 | 4598 |
-- |
| 4599 |
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4600 |
-- |
|
| 4601 |
|
|
| 4602 |
CREATE UNIQUE INDEX namedplace_unique ON namedplace USING btree ((COALESCE(parent_id, 0)), rank, placename); |
|
| 4603 |
|
|
| 4604 |
|
|
| 4605 |
-- |
|
| 4606 | 4606 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4607 | 4607 |
-- |
| 4608 | 4608 |
|
Also available in: Unified diff
vegbien.sql: namedplace: Added rank. Do duplicate elimination using rank and parent_id instead of placesystem