Revision 13430
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13290 | 13290 |
|
| 13291 | 13291 |
|
| 13292 | 13292 |
-- |
| 13293 |
-- Name: Source.errors; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 13294 |
-- |
|
| 13295 |
|
|
| 13296 |
CREATE TABLE `Source.errors` ( |
|
| 13297 |
`column` varchar(255), |
|
| 13298 |
value varchar(255), |
|
| 13299 |
error_code varchar(255) varying(5) NOT NULL, |
|
| 13300 |
error varchar(255) NOT NULL |
|
| 13301 |
); |
|
| 13302 |
|
|
| 13303 |
|
|
| 13304 |
-- |
|
| 13293 | 13305 |
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: - |
| 13294 | 13306 |
-- |
| 13295 | 13307 |
|
| ... | ... | |
| 13415 | 13427 |
USE geoscrub; |
| 13416 | 13428 |
|
| 13417 | 13429 |
-- |
| 13430 |
-- Name: Source.errors; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13431 |
-- |
|
| 13432 |
|
|
| 13433 |
CREATE TABLE `Source.errors` ( |
|
| 13434 |
`column` varchar(255), |
|
| 13435 |
value varchar(255), |
|
| 13436 |
error_code varchar(255) varying(5) NOT NULL, |
|
| 13437 |
error varchar(255) NOT NULL |
|
| 13438 |
); |
|
| 13439 |
|
|
| 13440 |
|
|
| 13441 |
-- |
|
| 13418 | 13442 |
-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
| 13419 | 13443 |
-- |
| 13420 | 13444 |
|
| ... | ... | |
| 13525 | 13549 |
USE `TNRS`; |
| 13526 | 13550 |
|
| 13527 | 13551 |
-- |
| 13552 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13553 |
-- |
|
| 13554 |
|
|
| 13555 |
|
|
| 13556 |
|
|
| 13557 |
|
|
| 13558 |
-- |
|
| 13559 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13560 |
-- |
|
| 13561 |
|
|
| 13562 |
|
|
| 13563 |
|
|
| 13564 |
|
|
| 13565 |
-- |
|
| 13566 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13567 |
-- |
|
| 13568 |
|
|
| 13569 |
|
|
| 13570 |
|
|
| 13571 |
|
|
| 13572 |
-- |
|
| 13573 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13574 |
-- |
|
| 13575 |
|
|
| 13576 |
CREATE INDEX `Source.errors_error_code_idx` ON `Source.errors` (error_code); |
|
| 13577 |
|
|
| 13578 |
|
|
| 13579 |
-- |
|
| 13580 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13581 |
-- |
|
| 13582 |
|
|
| 13583 |
CREATE INDEX `Source.errors_error_idx` ON `Source.errors` (error); |
|
| 13584 |
|
|
| 13585 |
|
|
| 13586 |
-- |
|
| 13528 | 13587 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 13529 | 13588 |
-- |
| 13530 | 13589 |
|
| ... | ... | |
| 13541 | 13600 |
USE geoscrub; |
| 13542 | 13601 |
|
| 13543 | 13602 |
-- |
| 13603 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13604 |
-- |
|
| 13605 |
|
|
| 13606 |
|
|
| 13607 |
|
|
| 13608 |
|
|
| 13609 |
-- |
|
| 13610 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13611 |
-- |
|
| 13612 |
|
|
| 13613 |
|
|
| 13614 |
|
|
| 13615 |
|
|
| 13616 |
-- |
|
| 13617 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13618 |
-- |
|
| 13619 |
|
|
| 13620 |
|
|
| 13621 |
|
|
| 13622 |
|
|
| 13623 |
-- |
|
| 13624 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13625 |
-- |
|
| 13626 |
|
|
| 13627 |
CREATE INDEX `Source.errors_error_code_idx` ON `Source.errors` (error_code); |
|
| 13628 |
|
|
| 13629 |
|
|
| 13630 |
-- |
|
| 13631 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 13632 |
-- |
|
| 13633 |
|
|
| 13634 |
CREATE INDEX `Source.errors_error_idx` ON `Source.errors` (error); |
|
| 13635 |
|
|
| 13636 |
|
|
| 13637 |
-- |
|
| 13544 | 13638 |
-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
| 13545 | 13639 |
-- |
| 13546 | 13640 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17074 | 17074 |
|
| 17075 | 17075 |
|
| 17076 | 17076 |
-- |
| 17077 |
-- Name: Source.errors; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 17078 |
-- |
|
| 17079 |
|
|
| 17080 |
CREATE TABLE "Source.errors" ( |
|
| 17081 |
"column" text, |
|
| 17082 |
value text, |
|
| 17083 |
error_code character varying(5) NOT NULL, |
|
| 17084 |
error text NOT NULL |
|
| 17085 |
); |
|
| 17086 |
|
|
| 17087 |
|
|
| 17088 |
-- |
|
| 17077 | 17089 |
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: - |
| 17078 | 17090 |
-- |
| 17079 | 17091 |
|
| ... | ... | |
| 17283 | 17295 |
SET search_path = geoscrub, pg_catalog; |
| 17284 | 17296 |
|
| 17285 | 17297 |
-- |
| 17298 |
-- Name: Source.errors; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17299 |
-- |
|
| 17300 |
|
|
| 17301 |
CREATE TABLE "Source.errors" ( |
|
| 17302 |
"column" text, |
|
| 17303 |
value text, |
|
| 17304 |
error_code character varying(5) NOT NULL, |
|
| 17305 |
error text NOT NULL |
|
| 17306 |
); |
|
| 17307 |
|
|
| 17308 |
|
|
| 17309 |
-- |
|
| 17286 | 17310 |
-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
| 17287 | 17311 |
-- |
| 17288 | 17312 |
|
| ... | ... | |
| 17395 | 17419 |
SET search_path = "TNRS", pg_catalog; |
| 17396 | 17420 |
|
| 17397 | 17421 |
-- |
| 17422 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17423 |
-- |
|
| 17424 |
|
|
| 17425 |
CREATE INDEX "Source.errors_coalesce_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)));
|
|
| 17426 |
|
|
| 17427 |
|
|
| 17428 |
-- |
|
| 17429 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17430 |
-- |
|
| 17431 |
|
|
| 17432 |
CREATE INDEX "Source.errors_coalesce_idx1" ON "Source.errors" USING btree ((COALESCE(value, '\N'::text))); |
|
| 17433 |
|
|
| 17434 |
|
|
| 17435 |
-- |
|
| 17436 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17437 |
-- |
|
| 17438 |
|
|
| 17439 |
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));
|
|
| 17440 |
|
|
| 17441 |
|
|
| 17442 |
-- |
|
| 17443 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17444 |
-- |
|
| 17445 |
|
|
| 17446 |
CREATE INDEX "Source.errors_error_code_idx" ON "Source.errors" USING btree (error_code); |
|
| 17447 |
|
|
| 17448 |
|
|
| 17449 |
-- |
|
| 17450 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17451 |
-- |
|
| 17452 |
|
|
| 17453 |
CREATE INDEX "Source.errors_error_idx" ON "Source.errors" USING btree (error); |
|
| 17454 |
|
|
| 17455 |
|
|
| 17456 |
-- |
|
| 17398 | 17457 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 17399 | 17458 |
-- |
| 17400 | 17459 |
|
| ... | ... | |
| 17411 | 17470 |
SET search_path = geoscrub, pg_catalog; |
| 17412 | 17471 |
|
| 17413 | 17472 |
-- |
| 17473 |
-- Name: Source.errors_coalesce_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17474 |
-- |
|
| 17475 |
|
|
| 17476 |
CREATE INDEX "Source.errors_coalesce_idx" ON "Source.errors" USING btree ((COALESCE("column", '\N'::text)));
|
|
| 17477 |
|
|
| 17478 |
|
|
| 17479 |
-- |
|
| 17480 |
-- Name: Source.errors_coalesce_idx1; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17481 |
-- |
|
| 17482 |
|
|
| 17483 |
CREATE INDEX "Source.errors_coalesce_idx1" ON "Source.errors" USING btree ((COALESCE(value, '\N'::text))); |
|
| 17484 |
|
|
| 17485 |
|
|
| 17486 |
-- |
|
| 17487 |
-- Name: Source.errors_coalesce_md5_error_code_md51_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17488 |
-- |
|
| 17489 |
|
|
| 17490 |
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));
|
|
| 17491 |
|
|
| 17492 |
|
|
| 17493 |
-- |
|
| 17494 |
-- Name: Source.errors_error_code_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17495 |
-- |
|
| 17496 |
|
|
| 17497 |
CREATE INDEX "Source.errors_error_code_idx" ON "Source.errors" USING btree (error_code); |
|
| 17498 |
|
|
| 17499 |
|
|
| 17500 |
-- |
|
| 17501 |
-- Name: Source.errors_error_idx; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
|
| 17502 |
-- |
|
| 17503 |
|
|
| 17504 |
CREATE INDEX "Source.errors_error_idx" ON "Source.errors" USING btree (error); |
|
| 17505 |
|
|
| 17506 |
|
|
| 17507 |
-- |
|
| 17414 | 17508 |
-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
| 17415 | 17509 |
-- |
| 17416 | 17510 |
|
Also available in: Unified diff
schemas/vegbien.sql: synced to DB, which adds Source.errors table indexes added in the import