| 4 |
4 |
|
| 5 |
5 |
SET statement_timeout = 0;
|
| 6 |
6 |
SET client_encoding = 'UTF8';
|
| 7 |
|
SET standard_conforming_strings = off;
|
|
7 |
SET standard_conforming_strings = on;
|
| 8 |
8 |
SET check_function_bodies = false;
|
| 9 |
9 |
SET client_min_messages = warning;
|
| 10 |
|
SET escape_string_warning = off;
|
| 11 |
10 |
|
| 12 |
11 |
SET search_path = public, pg_catalog;
|
| 13 |
12 |
|
| ... | ... | |
| 4359 |
4358 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4360 |
4359 |
--
|
| 4361 |
4360 |
|
| 4362 |
|
ALTER TABLE address ALTER COLUMN address_id SET DEFAULT nextval('address_address_id_seq'::regclass);
|
|
4361 |
ALTER TABLE ONLY address ALTER COLUMN address_id SET DEFAULT nextval('address_address_id_seq'::regclass);
|
| 4363 |
4362 |
|
| 4364 |
4363 |
|
| 4365 |
4364 |
--
|
| 4366 |
4365 |
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4367 |
4366 |
--
|
| 4368 |
4367 |
|
| 4369 |
|
ALTER TABLE aggregateoccurrence ALTER COLUMN aggregateoccurrence_id SET DEFAULT nextval('aggregateoccurrence_aggregateoccurrence_id_seq'::regclass);
|
|
4368 |
ALTER TABLE ONLY aggregateoccurrence ALTER COLUMN aggregateoccurrence_id SET DEFAULT nextval('aggregateoccurrence_aggregateoccurrence_id_seq'::regclass);
|
| 4370 |
4369 |
|
| 4371 |
4370 |
|
| 4372 |
4371 |
--
|
| 4373 |
4372 |
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4374 |
4373 |
--
|
| 4375 |
4374 |
|
| 4376 |
|
ALTER TABLE classcontributor ALTER COLUMN classcontributor_id SET DEFAULT nextval('classcontributor_classcontributor_id_seq'::regclass);
|
|
4375 |
ALTER TABLE ONLY classcontributor ALTER COLUMN classcontributor_id SET DEFAULT nextval('classcontributor_classcontributor_id_seq'::regclass);
|
| 4377 |
4376 |
|
| 4378 |
4377 |
|
| 4379 |
4378 |
--
|
| 4380 |
4379 |
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4381 |
4380 |
--
|
| 4382 |
4381 |
|
| 4383 |
|
ALTER TABLE commclass ALTER COLUMN commclass_id SET DEFAULT nextval('commclass_commclass_id_seq'::regclass);
|
|
4382 |
ALTER TABLE ONLY commclass ALTER COLUMN commclass_id SET DEFAULT nextval('commclass_commclass_id_seq'::regclass);
|
| 4384 |
4383 |
|
| 4385 |
4384 |
|
| 4386 |
4385 |
--
|
| 4387 |
4386 |
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4388 |
4387 |
--
|
| 4389 |
4388 |
|
| 4390 |
|
ALTER TABLE commconcept ALTER COLUMN commconcept_id SET DEFAULT nextval('commconcept_commconcept_id_seq'::regclass);
|
|
4389 |
ALTER TABLE ONLY commconcept ALTER COLUMN commconcept_id SET DEFAULT nextval('commconcept_commconcept_id_seq'::regclass);
|
| 4391 |
4390 |
|
| 4392 |
4391 |
|
| 4393 |
4392 |
--
|
| 4394 |
4393 |
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4395 |
4394 |
--
|
| 4396 |
4395 |
|
| 4397 |
|
ALTER TABLE commcorrelation ALTER COLUMN commcorrelation_id SET DEFAULT nextval('commcorrelation_commcorrelation_id_seq'::regclass);
|
|
4396 |
ALTER TABLE ONLY commcorrelation ALTER COLUMN commcorrelation_id SET DEFAULT nextval('commcorrelation_commcorrelation_id_seq'::regclass);
|
| 4398 |
4397 |
|
| 4399 |
4398 |
|
| 4400 |
4399 |
--
|
| 4401 |
4400 |
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4402 |
4401 |
--
|
| 4403 |
4402 |
|
| 4404 |
|
ALTER TABLE commdetermination ALTER COLUMN commdetermination_id SET DEFAULT nextval('commdetermination_commdetermination_id_seq'::regclass);
|
|
4403 |
ALTER TABLE ONLY commdetermination ALTER COLUMN commdetermination_id SET DEFAULT nextval('commdetermination_commdetermination_id_seq'::regclass);
|
| 4405 |
4404 |
|
| 4406 |
4405 |
|
| 4407 |
4406 |
--
|
| 4408 |
4407 |
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4409 |
4408 |
--
|
| 4410 |
4409 |
|
| 4411 |
|
ALTER TABLE commlineage ALTER COLUMN commlineage_id SET DEFAULT nextval('commlineage_commlineage_id_seq'::regclass);
|
|
4410 |
ALTER TABLE ONLY commlineage ALTER COLUMN commlineage_id SET DEFAULT nextval('commlineage_commlineage_id_seq'::regclass);
|
| 4412 |
4411 |
|
| 4413 |
4412 |
|
| 4414 |
4413 |
--
|
| 4415 |
4414 |
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4416 |
4415 |
--
|
| 4417 |
4416 |
|
| 4418 |
|
ALTER TABLE commname ALTER COLUMN commname_id SET DEFAULT nextval('commname_commname_id_seq'::regclass);
|
|
4417 |
ALTER TABLE ONLY commname ALTER COLUMN commname_id SET DEFAULT nextval('commname_commname_id_seq'::regclass);
|
| 4419 |
4418 |
|
| 4420 |
4419 |
|
| 4421 |
4420 |
--
|
| 4422 |
4421 |
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4423 |
4422 |
--
|
| 4424 |
4423 |
|
| 4425 |
|
ALTER TABLE commstatus ALTER COLUMN commstatus_id SET DEFAULT nextval('commstatus_commstatus_id_seq'::regclass);
|
|
4424 |
ALTER TABLE ONLY commstatus ALTER COLUMN commstatus_id SET DEFAULT nextval('commstatus_commstatus_id_seq'::regclass);
|
| 4426 |
4425 |
|
| 4427 |
4426 |
|
| 4428 |
4427 |
--
|
| 4429 |
4428 |
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4430 |
4429 |
--
|
| 4431 |
4430 |
|
| 4432 |
|
ALTER TABLE commusage ALTER COLUMN commusage_id SET DEFAULT nextval('commusage_commusage_id_seq'::regclass);
|
|
4431 |
ALTER TABLE ONLY commusage ALTER COLUMN commusage_id SET DEFAULT nextval('commusage_commusage_id_seq'::regclass);
|
| 4433 |
4432 |
|
| 4434 |
4433 |
|
| 4435 |
4434 |
--
|
| 4436 |
4435 |
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4437 |
4436 |
--
|
| 4438 |
4437 |
|
| 4439 |
|
ALTER TABLE coordinates ALTER COLUMN coordinates_id SET DEFAULT nextval('coordinates_coordinates_id_seq'::regclass);
|
|
4438 |
ALTER TABLE ONLY coordinates ALTER COLUMN coordinates_id SET DEFAULT nextval('coordinates_coordinates_id_seq'::regclass);
|
| 4440 |
4439 |
|
| 4441 |
4440 |
|
| 4442 |
4441 |
--
|
| 4443 |
4442 |
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4444 |
4443 |
--
|
| 4445 |
4444 |
|
| 4446 |
|
ALTER TABLE coverindex ALTER COLUMN coverindex_id SET DEFAULT nextval('coverindex_coverindex_id_seq'::regclass);
|
|
4445 |
ALTER TABLE ONLY coverindex ALTER COLUMN coverindex_id SET DEFAULT nextval('coverindex_coverindex_id_seq'::regclass);
|
| 4447 |
4446 |
|
| 4448 |
4447 |
|
| 4449 |
4448 |
--
|
| 4450 |
4449 |
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4451 |
4450 |
--
|
| 4452 |
4451 |
|
| 4453 |
|
ALTER TABLE covermethod ALTER COLUMN covermethod_id SET DEFAULT nextval('covermethod_covermethod_id_seq'::regclass);
|
|
4452 |
ALTER TABLE ONLY covermethod ALTER COLUMN covermethod_id SET DEFAULT nextval('covermethod_covermethod_id_seq'::regclass);
|
| 4454 |
4453 |
|
| 4455 |
4454 |
|
| 4456 |
4455 |
--
|
| 4457 |
4456 |
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4458 |
4457 |
--
|
| 4459 |
4458 |
|
| 4460 |
|
ALTER TABLE definedvalue ALTER COLUMN definedvalue_id SET DEFAULT nextval('definedvalue_definedvalue_id_seq'::regclass);
|
|
4459 |
ALTER TABLE ONLY definedvalue ALTER COLUMN definedvalue_id SET DEFAULT nextval('definedvalue_definedvalue_id_seq'::regclass);
|
| 4461 |
4460 |
|
| 4462 |
4461 |
|
| 4463 |
4462 |
--
|
| 4464 |
4463 |
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4465 |
4464 |
--
|
| 4466 |
4465 |
|
| 4467 |
|
ALTER TABLE disturbanceobs ALTER COLUMN disturbanceobs_id SET DEFAULT nextval('disturbanceobs_disturbanceobs_id_seq'::regclass);
|
|
4466 |
ALTER TABLE ONLY disturbanceobs ALTER COLUMN disturbanceobs_id SET DEFAULT nextval('disturbanceobs_disturbanceobs_id_seq'::regclass);
|
| 4468 |
4467 |
|
| 4469 |
4468 |
|
| 4470 |
4469 |
--
|
| 4471 |
4470 |
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4472 |
4471 |
--
|
| 4473 |
4472 |
|
| 4474 |
|
ALTER TABLE graphic ALTER COLUMN graphic_id SET DEFAULT nextval('graphic_graphic_id_seq'::regclass);
|
|
4473 |
ALTER TABLE ONLY graphic ALTER COLUMN graphic_id SET DEFAULT nextval('graphic_graphic_id_seq'::regclass);
|
| 4475 |
4474 |
|
| 4476 |
4475 |
|
| 4477 |
4476 |
--
|
| 4478 |
4477 |
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4479 |
4478 |
--
|
| 4480 |
4479 |
|
| 4481 |
|
ALTER TABLE location ALTER COLUMN location_id SET DEFAULT nextval('location_location_id_seq'::regclass);
|
|
4480 |
ALTER TABLE ONLY location ALTER COLUMN location_id SET DEFAULT nextval('location_location_id_seq'::regclass);
|
| 4482 |
4481 |
|
| 4483 |
4482 |
|
| 4484 |
4483 |
--
|
| 4485 |
4484 |
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4486 |
4485 |
--
|
| 4487 |
4486 |
|
| 4488 |
|
ALTER TABLE locationevent ALTER COLUMN locationevent_id SET DEFAULT nextval('locationevent_locationevent_id_seq'::regclass);
|
|
4487 |
ALTER TABLE ONLY locationevent ALTER COLUMN locationevent_id SET DEFAULT nextval('locationevent_locationevent_id_seq'::regclass);
|
| 4489 |
4488 |
|
| 4490 |
4489 |
|
| 4491 |
4490 |
--
|
| 4492 |
4491 |
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4493 |
4492 |
--
|
| 4494 |
4493 |
|
| 4495 |
|
ALTER TABLE locationeventcontributor ALTER COLUMN locationeventcontributor_id SET DEFAULT nextval('locationeventcontributor_locationeventcontributor_id_seq'::regclass);
|
|
4494 |
ALTER TABLE ONLY locationeventcontributor ALTER COLUMN locationeventcontributor_id SET DEFAULT nextval('locationeventcontributor_locationeventcontributor_id_seq'::regclass);
|
| 4496 |
4495 |
|
| 4497 |
4496 |
|
| 4498 |
4497 |
--
|
| 4499 |
4498 |
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4500 |
4499 |
--
|
| 4501 |
4500 |
|
| 4502 |
|
ALTER TABLE locationeventsynonym ALTER COLUMN locationeventsynonym_id SET DEFAULT nextval('locationeventsynonym_locationeventsynonym_id_seq'::regclass);
|
|
4501 |
ALTER TABLE ONLY locationeventsynonym ALTER COLUMN locationeventsynonym_id SET DEFAULT nextval('locationeventsynonym_locationeventsynonym_id_seq'::regclass);
|
| 4503 |
4502 |
|
| 4504 |
4503 |
|
| 4505 |
4504 |
--
|
| 4506 |
4505 |
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4507 |
4506 |
--
|
| 4508 |
4507 |
|
| 4509 |
|
ALTER TABLE locationplace ALTER COLUMN locationplace_id SET DEFAULT nextval('locationplace_locationplace_id_seq'::regclass);
|
|
4508 |
ALTER TABLE ONLY locationplace ALTER COLUMN locationplace_id SET DEFAULT nextval('locationplace_locationplace_id_seq'::regclass);
|
| 4510 |
4509 |
|
| 4511 |
4510 |
|
| 4512 |
4511 |
--
|
| 4513 |
4512 |
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4514 |
4513 |
--
|
| 4515 |
4514 |
|
| 4516 |
|
ALTER TABLE method ALTER COLUMN method_id SET DEFAULT nextval('method_method_id_seq'::regclass);
|
|
4515 |
ALTER TABLE ONLY method ALTER COLUMN method_id SET DEFAULT nextval('method_method_id_seq'::regclass);
|
| 4517 |
4516 |
|
| 4518 |
4517 |
|
| 4519 |
4518 |
--
|
| 4520 |
4519 |
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4521 |
4520 |
--
|
| 4522 |
4521 |
|
| 4523 |
|
ALTER TABLE methodtaxonclass ALTER COLUMN methodtaxonclass_id SET DEFAULT nextval('methodtaxonclass_methodtaxonclass_id_seq'::regclass);
|
|
4522 |
ALTER TABLE ONLY methodtaxonclass ALTER COLUMN methodtaxonclass_id SET DEFAULT nextval('methodtaxonclass_methodtaxonclass_id_seq'::regclass);
|
| 4524 |
4523 |
|
| 4525 |
4524 |
|
| 4526 |
4525 |
--
|
| 4527 |
4526 |
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4528 |
4527 |
--
|
| 4529 |
4528 |
|
| 4530 |
|
ALTER TABLE note ALTER COLUMN note_id SET DEFAULT nextval('note_note_id_seq'::regclass);
|
|
4529 |
ALTER TABLE ONLY note ALTER COLUMN note_id SET DEFAULT nextval('note_note_id_seq'::regclass);
|
| 4531 |
4530 |
|
| 4532 |
4531 |
|
| 4533 |
4532 |
--
|
| 4534 |
4533 |
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4535 |
4534 |
--
|
| 4536 |
4535 |
|
| 4537 |
|
ALTER TABLE notelink ALTER COLUMN notelink_id SET DEFAULT nextval('notelink_notelink_id_seq'::regclass);
|
|
4536 |
ALTER TABLE ONLY notelink ALTER COLUMN notelink_id SET DEFAULT nextval('notelink_notelink_id_seq'::regclass);
|
| 4538 |
4537 |
|
| 4539 |
4538 |
|
| 4540 |
4539 |
--
|
| 4541 |
4540 |
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4542 |
4541 |
--
|
| 4543 |
4542 |
|
| 4544 |
|
ALTER TABLE party ALTER COLUMN party_id SET DEFAULT nextval('party_party_id_seq'::regclass);
|
|
4543 |
ALTER TABLE ONLY party ALTER COLUMN party_id SET DEFAULT nextval('party_party_id_seq'::regclass);
|
| 4545 |
4544 |
|
| 4546 |
4545 |
|
| 4547 |
4546 |
--
|
| 4548 |
4547 |
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4549 |
4548 |
--
|
| 4550 |
4549 |
|
| 4551 |
|
ALTER TABLE partymember ALTER COLUMN partymember_id SET DEFAULT nextval('partymember_partymember_id_seq'::regclass);
|
|
4550 |
ALTER TABLE ONLY partymember ALTER COLUMN partymember_id SET DEFAULT nextval('partymember_partymember_id_seq'::regclass);
|
| 4552 |
4551 |
|
| 4553 |
4552 |
|
| 4554 |
4553 |
--
|
| 4555 |
4554 |
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4556 |
4555 |
--
|
| 4557 |
4556 |
|
| 4558 |
|
ALTER TABLE place ALTER COLUMN place_id SET DEFAULT nextval('place_place_id_seq'::regclass);
|
|
4557 |
ALTER TABLE ONLY place ALTER COLUMN place_id SET DEFAULT nextval('place_place_id_seq'::regclass);
|
| 4559 |
4558 |
|
| 4560 |
4559 |
|
| 4561 |
4560 |
--
|
| 4562 |
4561 |
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4563 |
4562 |
--
|
| 4564 |
4563 |
|
| 4565 |
|
ALTER TABLE placecorrelation ALTER COLUMN placecorrelation_id SET DEFAULT nextval('placecorrelation_placecorrelation_id_seq'::regclass);
|
|
4564 |
ALTER TABLE ONLY placecorrelation ALTER COLUMN placecorrelation_id SET DEFAULT nextval('placecorrelation_placecorrelation_id_seq'::regclass);
|
| 4566 |
4565 |
|
| 4567 |
4566 |
|
| 4568 |
4567 |
--
|
| 4569 |
4568 |
-- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4570 |
4569 |
--
|
| 4571 |
4570 |
|
| 4572 |
|
ALTER TABLE placename ALTER COLUMN placename_id SET DEFAULT nextval('placename_placename_id_seq'::regclass);
|
|
4571 |
ALTER TABLE ONLY placename ALTER COLUMN placename_id SET DEFAULT nextval('placename_placename_id_seq'::regclass);
|
| 4573 |
4572 |
|
| 4574 |
4573 |
|
| 4575 |
4574 |
--
|
| 4576 |
4575 |
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4577 |
4576 |
--
|
| 4578 |
4577 |
|
| 4579 |
|
ALTER TABLE plant ALTER COLUMN plant_id SET DEFAULT nextval('plant_plant_id_seq'::regclass);
|
|
4578 |
ALTER TABLE ONLY plant ALTER COLUMN plant_id SET DEFAULT nextval('plant_plant_id_seq'::regclass);
|
| 4580 |
4579 |
|
| 4581 |
4580 |
|
| 4582 |
4581 |
--
|
| 4583 |
4582 |
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4584 |
4583 |
--
|
| 4585 |
4584 |
|
| 4586 |
|
ALTER TABLE plantobservation ALTER COLUMN plantobservation_id SET DEFAULT nextval('plantobservation_plantobservation_id_seq'::regclass);
|
|
4585 |
ALTER TABLE ONLY plantobservation ALTER COLUMN plantobservation_id SET DEFAULT nextval('plantobservation_plantobservation_id_seq'::regclass);
|
| 4587 |
4586 |
|
| 4588 |
4587 |
|
| 4589 |
4588 |
--
|
| 4590 |
4589 |
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4591 |
4590 |
--
|
| 4592 |
4591 |
|
| 4593 |
|
ALTER TABLE project ALTER COLUMN project_id SET DEFAULT nextval('project_project_id_seq'::regclass);
|
|
4592 |
ALTER TABLE ONLY project ALTER COLUMN project_id SET DEFAULT nextval('project_project_id_seq'::regclass);
|
| 4594 |
4593 |
|
| 4595 |
4594 |
|
| 4596 |
4595 |
--
|
| 4597 |
4596 |
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4598 |
4597 |
--
|
| 4599 |
4598 |
|
| 4600 |
|
ALTER TABLE projectcontributor ALTER COLUMN projectcontributor_id SET DEFAULT nextval('projectcontributor_projectcontributor_id_seq'::regclass);
|
|
4599 |
ALTER TABLE ONLY projectcontributor ALTER COLUMN projectcontributor_id SET DEFAULT nextval('projectcontributor_projectcontributor_id_seq'::regclass);
|
| 4601 |
4600 |
|
| 4602 |
4601 |
|
| 4603 |
4602 |
--
|
| 4604 |
4603 |
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4605 |
4604 |
--
|
| 4606 |
4605 |
|
| 4607 |
|
ALTER TABLE revision ALTER COLUMN revision_id SET DEFAULT nextval('revision_revision_id_seq'::regclass);
|
|
4606 |
ALTER TABLE ONLY revision ALTER COLUMN revision_id SET DEFAULT nextval('revision_revision_id_seq'::regclass);
|
| 4608 |
4607 |
|
| 4609 |
4608 |
|
| 4610 |
4609 |
--
|
| 4611 |
4610 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4612 |
4611 |
--
|
| 4613 |
4612 |
|
| 4614 |
|
ALTER TABLE soilobs ALTER COLUMN soilobs_id SET DEFAULT nextval('soilobs_soilobs_id_seq'::regclass);
|
|
4613 |
ALTER TABLE ONLY soilobs ALTER COLUMN soilobs_id SET DEFAULT nextval('soilobs_soilobs_id_seq'::regclass);
|
| 4615 |
4614 |
|
| 4616 |
4615 |
|
| 4617 |
4616 |
--
|
| 4618 |
4617 |
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4619 |
4618 |
--
|
| 4620 |
4619 |
|
| 4621 |
|
ALTER TABLE soiltaxon ALTER COLUMN soiltaxon_id SET DEFAULT nextval('soiltaxon_soiltaxon_id_seq'::regclass);
|
|
4620 |
ALTER TABLE ONLY soiltaxon ALTER COLUMN soiltaxon_id SET DEFAULT nextval('soiltaxon_soiltaxon_id_seq'::regclass);
|
| 4622 |
4621 |
|
| 4623 |
4622 |
|
| 4624 |
4623 |
--
|
| 4625 |
4624 |
-- Name: source_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4626 |
4625 |
--
|
| 4627 |
4626 |
|
| 4628 |
|
ALTER TABLE source ALTER COLUMN source_id SET DEFAULT nextval('source_source_id_seq'::regclass);
|
|
4627 |
ALTER TABLE ONLY source ALTER COLUMN source_id SET DEFAULT nextval('source_source_id_seq'::regclass);
|
| 4629 |
4628 |
|
| 4630 |
4629 |
|
| 4631 |
4630 |
--
|
| 4632 |
4631 |
-- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4633 |
4632 |
--
|
| 4634 |
4633 |
|
| 4635 |
|
ALTER TABLE sourcecontributor ALTER COLUMN sourcecontributor_id SET DEFAULT nextval('sourcecontributor_sourcecontributor_id_seq'::regclass);
|
|
4634 |
ALTER TABLE ONLY sourcecontributor ALTER COLUMN sourcecontributor_id SET DEFAULT nextval('sourcecontributor_sourcecontributor_id_seq'::regclass);
|
| 4636 |
4635 |
|
| 4637 |
4636 |
|
| 4638 |
4637 |
--
|
| 4639 |
4638 |
-- Name: sourcejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4640 |
4639 |
--
|
| 4641 |
4640 |
|
| 4642 |
|
ALTER TABLE sourcejournal ALTER COLUMN sourcejournal_id SET DEFAULT nextval('sourcejournal_sourcejournal_id_seq'::regclass);
|
|
4641 |
ALTER TABLE ONLY sourcejournal ALTER COLUMN sourcejournal_id SET DEFAULT nextval('sourcejournal_sourcejournal_id_seq'::regclass);
|
| 4643 |
4642 |
|
| 4644 |
4643 |
|
| 4645 |
4644 |
--
|
| 4646 |
4645 |
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4647 |
4646 |
--
|
| 4648 |
4647 |
|
| 4649 |
|
ALTER TABLE sourcename ALTER COLUMN sourcename_id SET DEFAULT nextval('sourcename_sourcename_id_seq'::regclass);
|
|
4648 |
ALTER TABLE ONLY sourcename ALTER COLUMN sourcename_id SET DEFAULT nextval('sourcename_sourcename_id_seq'::regclass);
|
| 4650 |
4649 |
|
| 4651 |
4650 |
|
| 4652 |
4651 |
--
|
| 4653 |
4652 |
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4654 |
4653 |
--
|
| 4655 |
4654 |
|
| 4656 |
|
ALTER TABLE specimen ALTER COLUMN specimen_id SET DEFAULT nextval('specimen_specimen_id_seq'::regclass);
|
|
4655 |
ALTER TABLE ONLY specimen ALTER COLUMN specimen_id SET DEFAULT nextval('specimen_specimen_id_seq'::regclass);
|
| 4657 |
4656 |
|
| 4658 |
4657 |
|
| 4659 |
4658 |
--
|
| 4660 |
4659 |
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4661 |
4660 |
--
|
| 4662 |
4661 |
|
| 4663 |
|
ALTER TABLE specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass);
|
|
4662 |
ALTER TABLE ONLY specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass);
|
| 4664 |
4663 |
|
| 4665 |
4664 |
|
| 4666 |
4665 |
--
|
| 4667 |
4666 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4668 |
4667 |
--
|
| 4669 |
4668 |
|
| 4670 |
|
ALTER TABLE stemobservation ALTER COLUMN stemobservation_id SET DEFAULT nextval('stemobservation_stemobservation_id_seq'::regclass);
|
|
4669 |
ALTER TABLE ONLY stemobservation ALTER COLUMN stemobservation_id SET DEFAULT nextval('stemobservation_stemobservation_id_seq'::regclass);
|
| 4671 |
4670 |
|
| 4672 |
4671 |
|
| 4673 |
4672 |
--
|
| 4674 |
4673 |
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4675 |
4674 |
--
|
| 4676 |
4675 |
|
| 4677 |
|
ALTER TABLE stratum ALTER COLUMN stratum_id SET DEFAULT nextval('stratum_stratum_id_seq'::regclass);
|
|
4676 |
ALTER TABLE ONLY stratum ALTER COLUMN stratum_id SET DEFAULT nextval('stratum_stratum_id_seq'::regclass);
|
| 4678 |
4677 |
|
| 4679 |
4678 |
|
| 4680 |
4679 |
--
|
| 4681 |
4680 |
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4682 |
4681 |
--
|
| 4683 |
4682 |
|
| 4684 |
|
ALTER TABLE taxonalt ALTER COLUMN taxonalt_id SET DEFAULT nextval('taxonalt_taxonalt_id_seq'::regclass);
|
|
4683 |
ALTER TABLE ONLY taxonalt ALTER COLUMN taxonalt_id SET DEFAULT nextval('taxonalt_taxonalt_id_seq'::regclass);
|
| 4685 |
4684 |
|
| 4686 |
4685 |
|
| 4687 |
4686 |
--
|
| 4688 |
4687 |
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4689 |
4688 |
--
|
| 4690 |
4689 |
|
| 4691 |
|
ALTER TABLE taxoncorrelation ALTER COLUMN taxoncorrelation_id SET DEFAULT nextval('taxoncorrelation_taxoncorrelation_id_seq'::regclass);
|
|
4690 |
ALTER TABLE ONLY taxoncorrelation ALTER COLUMN taxoncorrelation_id SET DEFAULT nextval('taxoncorrelation_taxoncorrelation_id_seq'::regclass);
|
| 4692 |
4691 |
|
| 4693 |
4692 |
|
| 4694 |
4693 |
--
|
| 4695 |
4694 |
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4696 |
4695 |
--
|
| 4697 |
4696 |
|
| 4698 |
|
ALTER TABLE taxondetermination ALTER COLUMN taxondetermination_id SET DEFAULT nextval('taxondetermination_taxondetermination_id_seq'::regclass);
|
|
4697 |
ALTER TABLE ONLY taxondetermination ALTER COLUMN taxondetermination_id SET DEFAULT nextval('taxondetermination_taxondetermination_id_seq'::regclass);
|
| 4699 |
4698 |
|
| 4700 |
4699 |
|
| 4701 |
4700 |
--
|
| 4702 |
4701 |
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4703 |
4702 |
--
|
| 4704 |
4703 |
|
| 4705 |
|
ALTER TABLE taxonlabel ALTER COLUMN taxonlabel_id SET DEFAULT nextval('taxonlabel_taxonlabel_id_seq'::regclass);
|
|
4704 |
ALTER TABLE ONLY taxonlabel ALTER COLUMN taxonlabel_id SET DEFAULT nextval('taxonlabel_taxonlabel_id_seq'::regclass);
|
| 4706 |
4705 |
|
| 4707 |
4706 |
|
| 4708 |
4707 |
--
|
| 4709 |
4708 |
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4710 |
4709 |
--
|
| 4711 |
4710 |
|
| 4712 |
|
ALTER TABLE taxonlineage ALTER COLUMN taxonlineage_id SET DEFAULT nextval('taxonlineage_taxonlineage_id_seq'::regclass);
|
|
4711 |
ALTER TABLE ONLY taxonlineage ALTER COLUMN taxonlineage_id SET DEFAULT nextval('taxonlineage_taxonlineage_id_seq'::regclass);
|
| 4713 |
4712 |
|
| 4714 |
4713 |
|
| 4715 |
4714 |
--
|
| 4716 |
4715 |
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4717 |
4716 |
--
|
| 4718 |
4717 |
|
| 4719 |
|
ALTER TABLE taxonoccurrence ALTER COLUMN taxonoccurrence_id SET DEFAULT nextval('taxonoccurrence_taxonoccurrence_id_seq'::regclass);
|
|
4718 |
ALTER TABLE ONLY taxonoccurrence ALTER COLUMN taxonoccurrence_id SET DEFAULT nextval('taxonoccurrence_taxonoccurrence_id_seq'::regclass);
|
| 4720 |
4719 |
|
| 4721 |
4720 |
|
| 4722 |
4721 |
--
|
| 4723 |
4722 |
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4724 |
4723 |
--
|
| 4725 |
4724 |
|
| 4726 |
|
ALTER TABLE taxonstatus ALTER COLUMN taxonstatus_id SET DEFAULT nextval('taxonstatus_taxonstatus_id_seq'::regclass);
|
|
4725 |
ALTER TABLE ONLY taxonstatus ALTER COLUMN taxonstatus_id SET DEFAULT nextval('taxonstatus_taxonstatus_id_seq'::regclass);
|
| 4727 |
4726 |
|
| 4728 |
4727 |
|
| 4729 |
4728 |
--
|
| 4730 |
4729 |
-- Name: taxonverbatim_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4731 |
4730 |
--
|
| 4732 |
4731 |
|
| 4733 |
|
ALTER TABLE taxonverbatim ALTER COLUMN taxonverbatim_id SET DEFAULT nextval('taxonverbatim_taxonverbatim_id_seq'::regclass);
|
|
4732 |
ALTER TABLE ONLY taxonverbatim ALTER COLUMN taxonverbatim_id SET DEFAULT nextval('taxonverbatim_taxonverbatim_id_seq'::regclass);
|
| 4734 |
4733 |
|
| 4735 |
4734 |
|
| 4736 |
4735 |
--
|
| 4737 |
4736 |
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4738 |
4737 |
--
|
| 4739 |
4738 |
|
| 4740 |
|
ALTER TABLE telephone ALTER COLUMN telephone_id SET DEFAULT nextval('telephone_telephone_id_seq'::regclass);
|
|
4739 |
ALTER TABLE ONLY telephone ALTER COLUMN telephone_id SET DEFAULT nextval('telephone_telephone_id_seq'::regclass);
|
| 4741 |
4740 |
|
| 4742 |
4741 |
|
| 4743 |
4742 |
--
|
| 4744 |
4743 |
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4745 |
4744 |
--
|
| 4746 |
4745 |
|
| 4747 |
|
ALTER TABLE trait ALTER COLUMN trait_id SET DEFAULT nextval('trait_trait_id_seq'::regclass);
|
|
4746 |
ALTER TABLE ONLY trait ALTER COLUMN trait_id SET DEFAULT nextval('trait_trait_id_seq'::regclass);
|
| 4748 |
4747 |
|
| 4749 |
4748 |
|
| 4750 |
4749 |
--
|
| 4751 |
4750 |
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4752 |
4751 |
--
|
| 4753 |
4752 |
|
| 4754 |
|
ALTER TABLE userdefined ALTER COLUMN userdefined_id SET DEFAULT nextval('userdefined_userdefined_id_seq'::regclass);
|
|
4753 |
ALTER TABLE ONLY userdefined ALTER COLUMN userdefined_id SET DEFAULT nextval('userdefined_userdefined_id_seq'::regclass);
|
| 4755 |
4754 |
|
| 4756 |
4755 |
|
| 4757 |
4756 |
--
|
| 4758 |
4757 |
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
|
| 4759 |
4758 |
--
|
| 4760 |
4759 |
|
| 4761 |
|
ALTER TABLE voucher ALTER COLUMN voucher_id SET DEFAULT nextval('voucher_voucher_id_seq'::regclass);
|
|
4760 |
ALTER TABLE ONLY voucher ALTER COLUMN voucher_id SET DEFAULT nextval('voucher_voucher_id_seq'::regclass);
|
| 4762 |
4761 |
|
| 4763 |
4762 |
|
| 4764 |
4763 |
--
|
| ... | ... | |
| 5801 |
5800 |
-- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5802 |
5801 |
--
|
| 5803 |
5802 |
|
| 5804 |
|
CREATE UNIQUE INDEX aggregateoccurrence_unique_within_creator ON aggregateoccurrence USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
5803 |
CREATE UNIQUE INDEX aggregateoccurrence_unique_within_creator ON aggregateoccurrence USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 5805 |
5804 |
|
| 5806 |
5805 |
|
| 5807 |
5806 |
--
|
| ... | ... | |
| 5815 |
5814 |
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5816 |
5815 |
--
|
| 5817 |
5816 |
|
| 5818 |
|
CREATE UNIQUE INDEX commclass_unique ON commclass USING btree (locationevent_id, (COALESCE(classnotes, '\\N'::text)));
|
|
5817 |
CREATE UNIQUE INDEX commclass_unique ON commclass USING btree (locationevent_id, (COALESCE(classnotes, '\N'::text)));
|
| 5819 |
5818 |
|
| 5820 |
5819 |
|
| 5821 |
5820 |
--
|
| ... | ... | |
| 5836 |
5835 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5837 |
5836 |
--
|
| 5838 |
5837 |
|
| 5839 |
|
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\\N'::text)), (COALESCE(verbatimlongitude, '\\N'::text)), (COALESCE(verbatimcoordinates, '\\N'::text)), (COALESCE(footprintgeometry_dwc, '\\N'::text)));
|
|
5838 |
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\N'::text)), (COALESCE(verbatimlongitude, '\N'::text)), (COALESCE(verbatimcoordinates, '\N'::text)), (COALESCE(footprintgeometry_dwc, '\N'::text)));
|
| 5840 |
5839 |
|
| 5841 |
5840 |
|
| 5842 |
5841 |
--
|
| ... | ... | |
| 5878 |
5877 |
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5879 |
5878 |
--
|
| 5880 |
5879 |
|
| 5881 |
|
CREATE UNIQUE INDEX location_unique_within_creator_by_authorlocationcode ON location USING btree (source_id, (COALESCE(authorlocationcode, '\\N'::text))) WHERE (((authorlocationcode IS NOT NULL) AND (parent_id IS NULL)) AND (sourceaccessioncode IS NULL));
|
|
5880 |
CREATE UNIQUE INDEX location_unique_within_creator_by_authorlocationcode ON location USING btree (source_id, (COALESCE(authorlocationcode, '\N'::text))) WHERE (((authorlocationcode IS NOT NULL) AND (parent_id IS NULL)) AND (sourceaccessioncode IS NULL));
|
| 5882 |
5881 |
|
| 5883 |
5882 |
|
| 5884 |
5883 |
--
|
| 5885 |
5884 |
-- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5886 |
5885 |
--
|
| 5887 |
5886 |
|
| 5888 |
|
CREATE UNIQUE INDEX location_unique_within_creator_by_sourceaccessioncode ON location USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
5887 |
CREATE UNIQUE INDEX location_unique_within_creator_by_sourceaccessioncode ON location USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 5889 |
5888 |
|
| 5890 |
5889 |
|
| 5891 |
5890 |
--
|
| 5892 |
5891 |
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5893 |
5892 |
--
|
| 5894 |
5893 |
|
| 5895 |
|
CREATE UNIQUE INDEX location_unique_within_parent ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authorlocationcode, '\\N'::text)), (COALESCE(sublocationxposition_m, 'NaN'::double precision)), (COALESCE(sublocationyposition_m, 'NaN'::double precision))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
5894 |
CREATE UNIQUE INDEX location_unique_within_parent ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authorlocationcode, '\N'::text)), (COALESCE(sublocationxposition_m, 'NaN'::double precision)), (COALESCE(sublocationyposition_m, 'NaN'::double precision))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
| 5896 |
5895 |
|
| 5897 |
5896 |
|
| 5898 |
5897 |
--
|
| ... | ... | |
| 5913 |
5912 |
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5914 |
5913 |
--
|
| 5915 |
5914 |
|
| 5916 |
|
CREATE UNIQUE INDEX locationevent_unique_within_creator ON locationevent USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
5915 |
CREATE UNIQUE INDEX locationevent_unique_within_creator ON locationevent USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 5917 |
5916 |
|
| 5918 |
5917 |
|
| 5919 |
5918 |
--
|
| 5920 |
5919 |
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5921 |
5920 |
--
|
| 5922 |
5921 |
|
| 5923 |
|
CREATE UNIQUE INDEX locationevent_unique_within_location ON locationevent USING btree (location_id, (COALESCE(authoreventcode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((parent_id IS NULL) AND (sourceaccessioncode IS NULL));
|
|
5922 |
CREATE UNIQUE INDEX locationevent_unique_within_location ON locationevent USING btree (location_id, (COALESCE(authoreventcode, '\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((parent_id IS NULL) AND (sourceaccessioncode IS NULL));
|
| 5924 |
5923 |
|
| 5925 |
5924 |
|
| 5926 |
5925 |
--
|
| 5927 |
5926 |
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5928 |
5927 |
--
|
| 5929 |
5928 |
|
| 5930 |
|
CREATE UNIQUE INDEX locationevent_unique_within_parent_by_authoreventcode ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authoreventcode, '\\N'::text))) WHERE ((parent_id IS NOT NULL) AND (authoreventcode IS NOT NULL));
|
|
5929 |
CREATE UNIQUE INDEX locationevent_unique_within_parent_by_authoreventcode ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authoreventcode, '\N'::text))) WHERE ((parent_id IS NOT NULL) AND (authoreventcode IS NOT NULL));
|
| 5931 |
5930 |
|
| 5932 |
5931 |
|
| 5933 |
5932 |
--
|
| ... | ... | |
| 5941 |
5940 |
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5942 |
5941 |
--
|
| 5943 |
5942 |
|
| 5944 |
|
CREATE UNIQUE INDEX locationevent_unique_within_project ON locationevent USING btree ((COALESCE(project_id, 2147483647)), (COALESCE(authoreventcode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((((parent_id IS NULL) AND (project_id IS NOT NULL)) AND (authoreventcode IS NOT NULL)) AND (obsstartdate IS NOT NULL));
|
|
5943 |
CREATE UNIQUE INDEX locationevent_unique_within_project ON locationevent USING btree ((COALESCE(project_id, 2147483647)), (COALESCE(authoreventcode, '\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((((parent_id IS NULL) AND (project_id IS NOT NULL)) AND (authoreventcode IS NOT NULL)) AND (obsstartdate IS NOT NULL));
|
| 5945 |
5944 |
|
| 5946 |
5945 |
|
| 5947 |
5946 |
--
|
| ... | ... | |
| 5969 |
5968 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5970 |
5969 |
--
|
| 5971 |
5970 |
|
| 5972 |
|
CREATE UNIQUE INDEX method_unique ON method USING btree (source_id, (COALESCE(name, '\\N'::text)), (COALESCE(description, '\\N'::text)), (COALESCE(observationmeasure, '\\N'::text)));
|
|
5971 |
CREATE UNIQUE INDEX method_unique ON method USING btree (source_id, (COALESCE(name, '\N'::text)), (COALESCE(description, '\N'::text)), (COALESCE(observationmeasure, '\N'::text)));
|
| 5973 |
5972 |
|
| 5974 |
5973 |
|
| 5975 |
5974 |
--
|
| ... | ... | |
| 5990 |
5989 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 5991 |
5990 |
--
|
| 5992 |
5991 |
|
| 5993 |
|
CREATE UNIQUE INDEX party_unique ON party USING btree (source_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(fullname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text)), (COALESCE(suffix, '\\N'::text)));
|
|
5992 |
CREATE UNIQUE INDEX party_unique ON party USING btree (source_id, (COALESCE(organizationname, '\N'::text)), (COALESCE(fullname, '\N'::text)), (COALESCE(surname, '\N'::text)), (COALESCE(givenname, '\N'::text)), (COALESCE(middlename, '\N'::text)), (COALESCE(suffix, '\N'::text)));
|
| 5994 |
5993 |
|
| 5995 |
5994 |
|
| 5996 |
5995 |
--
|
| ... | ... | |
| 6004 |
6003 |
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6005 |
6004 |
--
|
| 6006 |
6005 |
|
| 6007 |
|
CREATE UNIQUE INDEX place_unique_within_creator_by_code ON place USING btree (source_id, (COALESCE(placecode, '\\N'::text))) WHERE (placecode IS NOT NULL);
|
|
6006 |
CREATE UNIQUE INDEX place_unique_within_creator_by_code ON place USING btree (source_id, (COALESCE(placecode, '\N'::text))) WHERE (placecode IS NOT NULL);
|
| 6008 |
6007 |
|
| 6009 |
6008 |
|
| 6010 |
6009 |
--
|
| 6011 |
6010 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6012 |
6011 |
--
|
| 6013 |
6012 |
|
| 6014 |
|
CREATE UNIQUE INDEX place_unique_within_creator_by_name ON place USING btree (source_id, (COALESCE(continent, '\\N'::text)), (COALESCE(country, '\\N'::text)), (COALESCE(stateprovince, '\\N'::text)), (COALESCE(county, '\\N'::text)), (COALESCE(coordinates_id, 2147483647))) WHERE (placecode IS NULL);
|
|
6013 |
CREATE UNIQUE INDEX place_unique_within_creator_by_name ON place USING btree (source_id, (COALESCE(continent, '\N'::text)), (COALESCE(country, '\N'::text)), (COALESCE(stateprovince, '\N'::text)), (COALESCE(county, '\N'::text)), (COALESCE(coordinates_id, 2147483647))) WHERE (placecode IS NULL);
|
| 6015 |
6014 |
|
| 6016 |
6015 |
|
| 6017 |
6016 |
--
|
| ... | ... | |
| 6032 |
6031 |
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6033 |
6032 |
--
|
| 6034 |
6033 |
|
| 6035 |
|
CREATE UNIQUE INDEX plantobservation_unique_within_creator ON plantobservation USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6034 |
CREATE UNIQUE INDEX plantobservation_unique_within_creator ON plantobservation USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6036 |
6035 |
|
| 6037 |
6036 |
|
| 6038 |
6037 |
--
|
| ... | ... | |
| 6046 |
6045 |
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6047 |
6046 |
--
|
| 6048 |
6047 |
|
| 6049 |
|
CREATE UNIQUE INDEX project_unique_name_date ON project USING btree (source_id, (COALESCE(projectname, '\\N'::text)), (COALESCE(startdate, 'infinity'::date))) WHERE (sourceaccessioncode IS NULL);
|
|
6048 |
CREATE UNIQUE INDEX project_unique_name_date ON project USING btree (source_id, (COALESCE(projectname, '\N'::text)), (COALESCE(startdate, 'infinity'::date))) WHERE (sourceaccessioncode IS NULL);
|
| 6050 |
6049 |
|
| 6051 |
6050 |
|
| 6052 |
6051 |
--
|
| 6053 |
6052 |
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6054 |
6053 |
--
|
| 6055 |
6054 |
|
| 6056 |
|
CREATE UNIQUE INDEX project_unique_within_creator ON project USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6055 |
CREATE UNIQUE INDEX project_unique_within_creator ON project USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6057 |
6056 |
|
| 6058 |
6057 |
|
| 6059 |
6058 |
--
|
| ... | ... | |
| 6074 |
6073 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6075 |
6074 |
--
|
| 6076 |
6075 |
|
| 6077 |
|
CREATE UNIQUE INDEX source_unique ON source USING btree ((COALESCE(shortname, '\\N'::text)));
|
|
6076 |
CREATE UNIQUE INDEX source_unique ON source USING btree ((COALESCE(shortname, '\N'::text)));
|
| 6078 |
6077 |
|
| 6079 |
6078 |
|
| 6080 |
6079 |
--
|
| ... | ... | |
| 6088 |
6087 |
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6089 |
6088 |
--
|
| 6090 |
6089 |
|
| 6091 |
|
CREATE UNIQUE INDEX sourcename_unique ON sourcename USING btree (source_id, (COALESCE(name, '\\N'::text)));
|
|
6090 |
CREATE UNIQUE INDEX sourcename_unique ON sourcename USING btree (source_id, (COALESCE(name, '\N'::text)));
|
| 6092 |
6091 |
|
| 6093 |
6092 |
|
| 6094 |
6093 |
--
|
| ... | ... | |
| 6109 |
6108 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6110 |
6109 |
--
|
| 6111 |
6110 |
|
| 6112 |
|
CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (source_id, (COALESCE(institution_id, 2147483647)), (COALESCE(collectioncode_dwc, '\\N'::text)), (COALESCE(catalognumber_dwc, '\\N'::text)), (COALESCE(plantobservation_id, 2147483647))) WHERE ((catalognumber_dwc IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
6111 |
CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (source_id, (COALESCE(institution_id, 2147483647)), (COALESCE(collectioncode_dwc, '\N'::text)), (COALESCE(catalognumber_dwc, '\N'::text)), (COALESCE(plantobservation_id, 2147483647))) WHERE ((catalognumber_dwc IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
| 6113 |
6112 |
|
| 6114 |
6113 |
|
| 6115 |
6114 |
--
|
| 6116 |
6115 |
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6117 |
6116 |
--
|
| 6118 |
6117 |
|
| 6119 |
|
CREATE UNIQUE INDEX specimenreplicate_unique_within_creator ON specimenreplicate USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6118 |
CREATE UNIQUE INDEX specimenreplicate_unique_within_creator ON specimenreplicate USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6120 |
6119 |
|
| 6121 |
6120 |
|
| 6122 |
6121 |
--
|
| ... | ... | |
| 6137 |
6136 |
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6138 |
6137 |
--
|
| 6139 |
6138 |
|
| 6140 |
|
CREATE UNIQUE INDEX stemobservation_unique_within_creator ON stemobservation USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6139 |
CREATE UNIQUE INDEX stemobservation_unique_within_creator ON stemobservation USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6141 |
6140 |
|
| 6142 |
6141 |
|
| 6143 |
6142 |
--
|
| 6144 |
6143 |
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6145 |
6144 |
--
|
| 6146 |
6145 |
|
| 6147 |
|
CREATE UNIQUE INDEX stemobservation_unique_within_plantobservation ON stemobservation USING btree (plantobservation_id, (COALESCE(authorstemcode, '\\N'::text)), (COALESCE(tag, '\\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
|
6146 |
CREATE UNIQUE INDEX stemobservation_unique_within_plantobservation ON stemobservation USING btree (plantobservation_id, (COALESCE(authorstemcode, '\N'::text)), (COALESCE(tag, '\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
| 6148 |
6147 |
|
| 6149 |
6148 |
|
| 6150 |
6149 |
--
|
| ... | ... | |
| 6165 |
6164 |
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6166 |
6165 |
--
|
| 6167 |
6166 |
|
| 6168 |
|
CREATE UNIQUE INDEX taxonlabel_0_unique_identifying_name ON taxonlabel USING btree (source_id, (COALESCE(taxonomicname, '\\N'::text))) WHERE (taxonomicname IS NOT NULL);
|
|
6167 |
CREATE UNIQUE INDEX taxonlabel_0_unique_identifying_name ON taxonlabel USING btree (source_id, (COALESCE(taxonomicname, '\N'::text))) WHERE (taxonomicname IS NOT NULL);
|
| 6169 |
6168 |
|
| 6170 |
6169 |
|
| 6171 |
6170 |
--
|
| 6172 |
6171 |
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6173 |
6172 |
--
|
| 6174 |
6173 |
|
| 6175 |
|
CREATE UNIQUE INDEX taxonlabel_1_unique_sourceaccessioncode ON taxonlabel USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6174 |
CREATE UNIQUE INDEX taxonlabel_1_unique_sourceaccessioncode ON taxonlabel USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6176 |
6175 |
|
| 6177 |
6176 |
|
| 6178 |
6177 |
--
|
| ... | ... | |
| 6200 |
6199 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6201 |
6200 |
--
|
| 6202 |
6201 |
|
| 6203 |
|
CREATE UNIQUE INDEX taxonlabel_unique ON taxonlabel USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonepithet, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), source_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)));
|
|
6202 |
CREATE UNIQUE INDEX taxonlabel_unique ON taxonlabel USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonepithet, '\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), source_id, (COALESCE(sourceaccessioncode, '\N'::text)), (COALESCE(taxonomicname, '\N'::text)));
|
| 6204 |
6203 |
|
| 6205 |
6204 |
|
| 6206 |
6205 |
--
|
| ... | ... | |
| 6221 |
6220 |
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6222 |
6221 |
--
|
| 6223 |
6222 |
|
| 6224 |
|
CREATE UNIQUE INDEX taxonoccurrence_unique_within_creator ON taxonoccurrence USING btree (source_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
6223 |
CREATE UNIQUE INDEX taxonoccurrence_unique_within_creator ON taxonoccurrence USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
| 6225 |
6224 |
|
| 6226 |
6225 |
|
| 6227 |
6226 |
--
|
| 6228 |
6227 |
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 6229 |
6228 |
--
|
| 6230 |
6229 |
|
| 6231 |
|
CREATE UNIQUE INDEX taxonoccurrence_unique_within_locationevent ON taxonoccurrence USING btree ((COALESCE(locationevent_id, 2147483647)), (COALESCE(authortaxoncode, '\\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
|
6230 |
CREATE UNIQUE INDEX taxonoccurrence_unique_within_locationevent ON taxonoccurrence USING btree ((COALESCE(locationevent_id, 2147483647)), (COALESCE(authortaxoncode, '\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
| 6232 |
6231 |
|
| 6233 |
6232 |
|
| 6234 |
6233 |
--
|
schemas/*.sql: Updated for PostgreSQL 9.1.6, which has standard_conforming_strings = on (which affects \-escapes in string literals), escape_string_warning not explicitly set, and uses ALTER TABLE ONLY instead of ALTER TABLE