Revision 13438
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/Makefile | ||
|---|---|---|
| 108 | 108 |
|
| 109 | 109 |
vegbien.sql: public_.sql |
| 110 | 110 |
(cat public_.sql; schema=1 ../bin/pg_dump_vegbien all --schema='geoscrub' \ |
| 111 |
--schema='"TNRS"' --exclude-table='*."~"*' --exclude-table='*."Source"') >$@ |
|
| 111 |
--schema='"TNRS"' --exclude-table='*."~"*' --exclude-table='*.*\y"Source"\y*') \ |
|
| 112 |
>$@ |
|
| 112 | 113 |
# `all`: prevents auto-adding a --schema entry |
| 114 |
# exclude the same set of Source tables excluded by inputs/.TNRS/schema.sql, so |
|
| 115 |
# that reinstalling TNRS doesn't change the contents of this file |
|
| 113 | 116 |
|
| 114 | 117 |
py_util.sql: |
| 115 | 118 |
env owners=1 $(call pg_dump,py_util) |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13276 | 13276 |
|
| 13277 | 13277 |
|
| 13278 | 13278 |
-- |
| 13279 |
-- Name: Source.errors; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 13280 |
-- |
|
| 13281 |
|
|
| 13282 |
CREATE TABLE `Source.errors` ( |
|
| 13283 |
`column` varchar(255), |
|
| 13284 |
value varchar(255), |
|
| 13285 |
error_code varchar(255) varying(5) NOT NULL, |
|
| 13286 |
error varchar(255) NOT NULL |
|
| 13287 |
); |
|
| 13288 |
|
|
| 13289 |
|
|
| 13290 |
-- |
|
| 13291 | 13279 |
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: - |
| 13292 | 13280 |
-- |
| 13293 | 13281 |
|
| ... | ... | |
| 13413 | 13401 |
USE geoscrub; |
| 13414 | 13402 |
|
| 13415 | 13403 |
-- |
| 13416 |
-- Name: Source.errors; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13417 |
-- |
|
| 13418 |
|
|
| 13419 |
CREATE TABLE `Source.errors` ( |
|
| 13420 |
`column` varchar(255), |
|
| 13421 |
value varchar(255), |
|
| 13422 |
error_code varchar(255) varying(5) NOT NULL, |
|
| 13423 |
error varchar(255) NOT NULL |
|
| 13424 |
); |
|
| 13425 |
|
|
| 13426 |
|
|
| 13427 |
-- |
|
| 13428 | 13404 |
-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
| 13429 | 13405 |
-- |
| 13430 | 13406 |
|
| ... | ... | |
| 13535 | 13511 |
USE `TNRS`; |
| 13536 | 13512 |
|
| 13537 | 13513 |
-- |
| 13538 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13539 |
-- |
|
| 13540 |
|
|
| 13541 |
|
|
| 13542 |
|
|
| 13543 |
|
|
| 13544 |
-- |
|
| 13545 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13546 |
-- |
|
| 13547 |
|
|
| 13548 |
|
|
| 13549 |
|
|
| 13550 |
|
|
| 13551 |
-- |
|
| 13552 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13553 |
-- |
|
| 13554 |
|
|
| 13555 |
|
|
| 13556 |
|
|
| 13557 |
|
|
| 13558 |
-- |
|
| 13559 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13560 |
-- |
|
| 13561 |
|
|
| 13562 |
CREATE INDEX `Source.errors_error_code_idx` ON `Source.errors` (error_code); |
|
| 13563 |
|
|
| 13564 |
|
|
| 13565 |
-- |
|
| 13566 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13567 |
-- |
|
| 13568 |
|
|
| 13569 |
CREATE INDEX `Source.errors_error_idx` ON `Source.errors` (error); |
|
| 13570 |
|
|
| 13571 |
|
|
| 13572 |
-- |
|
| 13573 | 13514 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 13574 | 13515 |
-- |
| 13575 | 13516 |
|
| ... | ... | |
| 13586 | 13527 |
USE geoscrub; |
| 13587 | 13528 |
|
| 13588 | 13529 |
-- |
| 13589 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13590 |
-- |
|
| 13591 |
|
|
| 13592 |
|
|
| 13593 |
|
|
| 13594 |
|
|
| 13595 |
-- |
|
| 13596 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13597 |
-- |
|
| 13598 |
|
|
| 13599 |
|
|
| 13600 |
|
|
| 13601 |
|
|
| 13602 |
-- |
|
| 13603 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13604 |
-- |
|
| 13605 |
|
|
| 13606 |
|
|
| 13607 |
|
|
| 13608 |
|
|
| 13609 |
-- |
|
| 13610 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13611 |
-- |
|
| 13612 |
|
|
| 13613 |
CREATE INDEX `Source.errors_error_code_idx` ON `Source.errors` (error_code); |
|
| 13614 |
|
|
| 13615 |
|
|
| 13616 |
-- |
|
| 13617 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13618 |
-- |
|
| 13619 |
|
|
| 13620 |
CREATE INDEX `Source.errors_error_idx` ON `Source.errors` (error); |
|
| 13621 |
|
|
| 13622 |
|
|
| 13623 |
-- |
|
| 13624 | 13530 |
-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
| 13625 | 13531 |
-- |
| 13626 | 13532 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17064 | 17064 |
|
| 17065 | 17065 |
|
| 17066 | 17066 |
-- |
| 17067 |
-- Name: Source.errors; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 17068 |
-- |
|
| 17069 |
|
|
| 17070 |
CREATE TABLE "Source.errors" ( |
|
| 17071 |
"column" text, |
|
| 17072 |
value text, |
|
| 17073 |
error_code character varying(5) NOT NULL, |
|
| 17074 |
error text NOT NULL |
|
| 17075 |
); |
|
| 17076 |
|
|
| 17077 |
|
|
| 17078 |
-- |
|
| 17079 | 17067 |
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: - |
| 17080 | 17068 |
-- |
| 17081 | 17069 |
|
| ... | ... | |
| 17285 | 17273 |
SET search_path = geoscrub, pg_catalog; |
| 17286 | 17274 |
|
| 17287 | 17275 |
-- |
| 17288 |
-- Name: Source.errors; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17289 |
-- |
|
| 17290 |
|
|
| 17291 |
CREATE TABLE "Source.errors" ( |
|
| 17292 |
"column" text, |
|
| 17293 |
value text, |
|
| 17294 |
error_code character varying(5) NOT NULL, |
|
| 17295 |
error text NOT NULL |
|
| 17296 |
); |
|
| 17297 |
|
|
| 17298 |
|
|
| 17299 |
-- |
|
| 17300 | 17276 |
-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
| 17301 | 17277 |
-- |
| 17302 | 17278 |
|
| ... | ... | |
| 17409 | 17385 |
SET search_path = "TNRS", pg_catalog; |
| 17410 | 17386 |
|
| 17411 | 17387 |
-- |
| 17412 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17413 |
-- |
|
| 17414 |
|
|
| 17415 |
CREATE INDEX "Source.errors_coalesce_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)));
|
|
| 17416 |
|
|
| 17417 |
|
|
| 17418 |
-- |
|
| 17419 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17420 |
-- |
|
| 17421 |
|
|
| 17422 |
CREATE INDEX "Source.errors_coalesce_idx1" ON "Source.errors" USING btree ((COALESCE(value, '\N'::text))); |
|
| 17423 |
|
|
| 17424 |
|
|
| 17425 |
-- |
|
| 17426 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17427 |
-- |
|
| 17428 |
|
|
| 17429 |
CREATE UNIQUE INDEX "Source.errors_coalesce_md5_error_code_md51_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)), md5(value), error_code, md5(error));
|
|
| 17430 |
|
|
| 17431 |
|
|
| 17432 |
-- |
|
| 17433 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17434 |
-- |
|
| 17435 |
|
|
| 17436 |
CREATE INDEX "Source.errors_error_code_idx" ON "Source.errors" USING btree (error_code); |
|
| 17437 |
|
|
| 17438 |
|
|
| 17439 |
-- |
|
| 17440 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17441 |
-- |
|
| 17442 |
|
|
| 17443 |
CREATE INDEX "Source.errors_error_idx" ON "Source.errors" USING btree (error); |
|
| 17444 |
|
|
| 17445 |
|
|
| 17446 |
-- |
|
| 17447 | 17388 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 17448 | 17389 |
-- |
| 17449 | 17390 |
|
| ... | ... | |
| 17460 | 17401 |
SET search_path = geoscrub, pg_catalog; |
| 17461 | 17402 |
|
| 17462 | 17403 |
-- |
| 17463 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17464 |
-- |
|
| 17465 |
|
|
| 17466 |
CREATE INDEX "Source.errors_coalesce_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)));
|
|
| 17467 |
|
|
| 17468 |
|
|
| 17469 |
-- |
|
| 17470 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17471 |
-- |
|
| 17472 |
|
|
| 17473 |
CREATE INDEX "Source.errors_coalesce_idx1" ON "Source.errors" USING btree ((COALESCE(value, '\N'::text))); |
|
| 17474 |
|
|
| 17475 |
|
|
| 17476 |
-- |
|
| 17477 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17478 |
-- |
|
| 17479 |
|
|
| 17480 |
CREATE UNIQUE INDEX "Source.errors_coalesce_md5_error_code_md51_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)), md5(value), error_code, md5(error));
|
|
| 17481 |
|
|
| 17482 |
|
|
| 17483 |
-- |
|
| 17484 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17485 |
-- |
|
| 17486 |
|
|
| 17487 |
CREATE INDEX "Source.errors_error_code_idx" ON "Source.errors" USING btree (error_code); |
|
| 17488 |
|
|
| 17489 |
|
|
| 17490 |
-- |
|
| 17491 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17492 |
-- |
|
| 17493 |
|
|
| 17494 |
CREATE INDEX "Source.errors_error_idx" ON "Source.errors" USING btree (error); |
|
| 17495 |
|
|
| 17496 |
|
|
| 17497 |
-- |
|
| 17498 | 17404 |
-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
| 17499 | 17405 |
-- |
| 17500 | 17406 |
|
Also available in: Unified diff
schemas/Makefile: vegbien.sql: exclude the same set of Source tables excluded by inputs/.TNRS/schema.sql, so that reinstalling TNRS doesn't change the contents of this file