Revision 6908
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 423 | 423 |
|
| 424 | 424 |
|
| 425 | 425 |
-- |
| 426 |
-- Name: sync_owner_count_to_view(); Type: FUNCTION; Schema: public; Owner: - |
|
| 427 |
-- |
|
| 428 |
|
|
| 429 |
|
|
| 430 |
|
|
| 431 |
|
|
| 432 |
-- |
|
| 433 | 426 |
-- Name: sync_provider_count_to_view(); Type: FUNCTION; Schema: public; Owner: - |
| 434 | 427 |
-- |
| 435 | 428 |
|
| ... | ... | |
| 2415 | 2408 |
|
| 2416 | 2409 |
|
| 2417 | 2410 |
-- |
| 2418 |
-- Name: owner_count; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2419 |
-- |
|
| 2420 |
|
|
| 2421 |
CREATE TABLE owner_count ( |
|
| 2422 |
owner varchar(255) NOT NULL, |
|
| 2423 |
count varchar(255) |
|
| 2424 |
); |
|
| 2425 |
|
|
| 2426 |
|
|
| 2427 |
-- |
|
| 2428 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2429 |
-- |
|
| 2430 |
|
|
| 2431 |
CREATE TABLE sourcename ( |
|
| 2432 |
sourcelist_id int(11) NOT NULL, |
|
| 2433 |
name varchar(255) NOT NULL, |
|
| 2434 |
matched_source_id int(11) |
|
| 2435 |
); |
|
| 2436 |
|
|
| 2437 |
|
|
| 2438 |
-- |
|
| 2439 |
-- Name: owner_count_view; Type: VIEW; Schema: public; Owner: - |
|
| 2440 |
-- |
|
| 2441 |
|
|
| 2442 |
|
|
| 2443 |
|
|
| 2444 |
|
|
| 2445 |
-- |
|
| 2446 | 2411 |
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2447 | 2412 |
-- |
| 2448 | 2413 |
|
| ... | ... | |
| 2717 | 2682 |
-- |
| 2718 | 2683 |
|
| 2719 | 2684 |
CREATE TABLE provider_count ( |
| 2685 |
level varchar(255) NOT NULL, |
|
| 2720 | 2686 |
provider varchar(255) NOT NULL, |
| 2721 |
count varchar(255) |
|
| 2687 |
count varchar(255), |
|
| 2688 |
sourcetype varchar(255), |
|
| 2689 |
observationtype varchar(255) |
|
| 2722 | 2690 |
); |
| 2723 | 2691 |
|
| 2724 | 2692 |
|
| 2725 | 2693 |
-- |
| 2726 |
-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: -
|
|
| 2694 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2727 | 2695 |
-- |
| 2728 | 2696 |
|
| 2697 |
CREATE TABLE sourcename ( |
|
| 2698 |
sourcelist_id int(11) NOT NULL, |
|
| 2699 |
name varchar(255) NOT NULL, |
|
| 2700 |
matched_source_id int(11) |
|
| 2701 |
); |
|
| 2729 | 2702 |
|
| 2730 | 2703 |
|
| 2731 |
|
|
| 2732 | 2704 |
-- |
| 2733 |
-- Name: provider_view; Type: VIEW; Schema: public; Owner: - |
|
| 2705 |
-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: -
|
|
| 2734 | 2706 |
-- |
| 2735 | 2707 |
|
| 2736 | 2708 |
|
| ... | ... | |
| 4158 | 4130 |
|
| 4159 | 4131 |
|
| 4160 | 4132 |
-- |
| 4161 |
-- Data for Name: owner_count; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4162 |
-- |
|
| 4163 |
|
|
| 4164 |
|
|
| 4165 |
|
|
| 4166 |
-- |
|
| 4167 | 4133 |
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: - |
| 4168 | 4134 |
-- |
| 4169 | 4135 |
|
| ... | ... | |
| 4664 | 4630 |
|
| 4665 | 4631 |
|
| 4666 | 4632 |
-- |
| 4667 |
-- Name: owner_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4668 |
-- |
|
| 4669 |
|
|
| 4670 |
ALTER TABLE owner_count |
|
| 4671 |
ADD CONSTRAINT owner_count_pkey PRIMARY KEY (owner); |
|
| 4672 |
|
|
| 4673 |
|
|
| 4674 |
-- |
|
| 4675 | 4633 |
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4676 | 4634 |
-- |
| 4677 | 4635 |
|
| ... | ... | |
| 4764 | 4722 |
-- |
| 4765 | 4723 |
|
| 4766 | 4724 |
ALTER TABLE provider_count |
| 4767 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (provider); |
|
| 4725 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (level, provider);
|
|
| 4768 | 4726 |
|
| 4769 | 4727 |
|
| 4770 | 4728 |
-- |
| ... | ... | |
| 7100 | 7058 |
|
| 7101 | 7059 |
|
| 7102 | 7060 |
-- |
| 7103 |
-- Name: owner_count; Type: ACL; Schema: public; Owner: - |
|
| 7104 |
-- |
|
| 7105 |
|
|
| 7106 |
|
|
| 7107 |
|
|
| 7108 |
|
|
| 7109 |
|
|
| 7110 |
|
|
| 7111 |
|
|
| 7112 |
|
|
| 7113 |
-- |
|
| 7114 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: - |
|
| 7115 |
-- |
|
| 7116 |
|
|
| 7117 |
|
|
| 7118 |
|
|
| 7119 |
|
|
| 7120 |
|
|
| 7121 |
|
|
| 7122 |
|
|
| 7123 |
|
|
| 7124 |
-- |
|
| 7125 |
-- Name: owner_count_view; Type: ACL; Schema: public; Owner: - |
|
| 7126 |
-- |
|
| 7127 |
|
|
| 7128 |
|
|
| 7129 |
|
|
| 7130 |
|
|
| 7131 |
|
|
| 7132 |
|
|
| 7133 |
|
|
| 7134 |
|
|
| 7135 |
-- |
|
| 7136 | 7061 |
-- Name: partymember; Type: ACL; Schema: public; Owner: - |
| 7137 | 7062 |
-- |
| 7138 | 7063 |
|
| ... | ... | |
| 7204 | 7129 |
|
| 7205 | 7130 |
|
| 7206 | 7131 |
-- |
| 7207 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: -
|
|
| 7132 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
|
|
| 7208 | 7133 |
-- |
| 7209 | 7134 |
|
| 7210 | 7135 |
|
| ... | ... | |
| 7215 | 7140 |
|
| 7216 | 7141 |
|
| 7217 | 7142 |
-- |
| 7218 |
-- Name: provider_view; Type: ACL; Schema: public; Owner: - |
|
| 7143 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: -
|
|
| 7219 | 7144 |
-- |
| 7220 | 7145 |
|
| 7221 | 7146 |
|
Also available in: Unified diff
schemas/vegbien.sql: Merged provider_view, provider_count, and owner_count into provider_count, using the combining query for Brad's data providers page at <http://bien.nceas.ucsb.edu/bien/people/data-providers/>