Revision 6867
Added by Aaron Marcuse-Kubitza almost 12 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 |
-- |
|
| 426 | 433 |
-- Name: sync_provider_count_to_view(); Type: FUNCTION; Schema: public; Owner: - |
| 427 | 434 |
-- |
| 428 | 435 |
|
| ... | ... | |
| 2401 | 2408 |
|
| 2402 | 2409 |
|
| 2403 | 2410 |
-- |
| 2411 |
-- Name: owner_count; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2412 |
-- |
|
| 2413 |
|
|
| 2414 |
CREATE TABLE owner_count ( |
|
| 2415 |
owner varchar(255) NOT NULL, |
|
| 2416 |
count varchar(255) |
|
| 2417 |
); |
|
| 2418 |
|
|
| 2419 |
|
|
| 2420 |
-- |
|
| 2421 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2422 |
-- |
|
| 2423 |
|
|
| 2424 |
CREATE TABLE sourcename ( |
|
| 2425 |
sourcelist_id int(11) NOT NULL, |
|
| 2426 |
name varchar(255) NOT NULL, |
|
| 2427 |
matched_source_id int(11) |
|
| 2428 |
); |
|
| 2429 |
|
|
| 2430 |
|
|
| 2431 |
-- |
|
| 2432 |
-- Name: owner_count_view; Type: VIEW; Schema: public; Owner: - |
|
| 2433 |
-- |
|
| 2434 |
|
|
| 2435 |
|
|
| 2436 |
|
|
| 2437 |
|
|
| 2438 |
-- |
|
| 2404 | 2439 |
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2405 | 2440 |
-- |
| 2406 | 2441 |
|
| ... | ... | |
| 2688 | 2723 |
|
| 2689 | 2724 |
|
| 2690 | 2725 |
-- |
| 2691 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2692 |
-- |
|
| 2693 |
|
|
| 2694 |
CREATE TABLE sourcename ( |
|
| 2695 |
sourcelist_id int(11) NOT NULL, |
|
| 2696 |
name varchar(255) NOT NULL, |
|
| 2697 |
matched_source_id int(11) |
|
| 2698 |
); |
|
| 2699 |
|
|
| 2700 |
|
|
| 2701 |
-- |
|
| 2702 | 2726 |
-- Name: provider_view; Type: VIEW; Schema: public; Owner: - |
| 2703 | 2727 |
-- |
| 2704 | 2728 |
|
| ... | ... | |
| 4107 | 4131 |
|
| 4108 | 4132 |
|
| 4109 | 4133 |
-- |
| 4134 |
-- Data for Name: owner_count; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4135 |
-- |
|
| 4136 |
|
|
| 4137 |
|
|
| 4138 |
|
|
| 4139 |
-- |
|
| 4110 | 4140 |
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: - |
| 4111 | 4141 |
-- |
| 4112 | 4142 |
|
| ... | ... | |
| 4601 | 4631 |
|
| 4602 | 4632 |
|
| 4603 | 4633 |
-- |
| 4634 |
-- Name: owner_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4635 |
-- |
|
| 4636 |
|
|
| 4637 |
ALTER TABLE owner_count |
|
| 4638 |
ADD CONSTRAINT owner_count_pkey PRIMARY KEY (owner); |
|
| 4639 |
|
|
| 4640 |
|
|
| 4641 |
-- |
|
| 4604 | 4642 |
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4605 | 4643 |
-- |
| 4606 | 4644 |
|
| ... | ... | |
| 7015 | 7053 |
|
| 7016 | 7054 |
|
| 7017 | 7055 |
-- |
| 7018 |
-- Name: partymember; Type: ACL; Schema: public; Owner: -
|
|
| 7056 |
-- Name: owner_count; Type: ACL; Schema: public; Owner: -
|
|
| 7019 | 7057 |
-- |
| 7020 | 7058 |
|
| 7021 | 7059 |
|
| ... | ... | |
| 7024 | 7062 |
|
| 7025 | 7063 |
|
| 7026 | 7064 |
|
| 7065 |
|
|
| 7027 | 7066 |
-- |
| 7028 |
-- Name: placecorrelation; Type: ACL; Schema: public; Owner: -
|
|
| 7067 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
|
|
| 7029 | 7068 |
-- |
| 7030 | 7069 |
|
| 7031 | 7070 |
|
| ... | ... | |
| 7034 | 7073 |
|
| 7035 | 7074 |
|
| 7036 | 7075 |
|
| 7076 |
|
|
| 7037 | 7077 |
-- |
| 7038 |
-- Name: placename; Type: ACL; Schema: public; Owner: -
|
|
| 7078 |
-- Name: owner_count_view; Type: ACL; Schema: public; Owner: -
|
|
| 7039 | 7079 |
-- |
| 7040 | 7080 |
|
| 7041 | 7081 |
|
| ... | ... | |
| 7044 | 7084 |
|
| 7045 | 7085 |
|
| 7046 | 7086 |
|
| 7087 |
|
|
| 7047 | 7088 |
-- |
| 7048 |
-- Name: placename_ancestor; Type: ACL; Schema: public; Owner: -
|
|
| 7089 |
-- Name: partymember; Type: ACL; Schema: public; Owner: -
|
|
| 7049 | 7090 |
-- |
| 7050 | 7091 |
|
| 7051 | 7092 |
|
| ... | ... | |
| 7055 | 7096 |
|
| 7056 | 7097 |
|
| 7057 | 7098 |
-- |
| 7058 |
-- Name: plant; Type: ACL; Schema: public; Owner: -
|
|
| 7099 |
-- Name: placecorrelation; Type: ACL; Schema: public; Owner: -
|
|
| 7059 | 7100 |
-- |
| 7060 | 7101 |
|
| 7061 | 7102 |
|
| ... | ... | |
| 7065 | 7106 |
|
| 7066 | 7107 |
|
| 7067 | 7108 |
-- |
| 7068 |
-- Name: projectcontributor; Type: ACL; Schema: public; Owner: -
|
|
| 7109 |
-- Name: placename; Type: ACL; Schema: public; Owner: -
|
|
| 7069 | 7110 |
-- |
| 7070 | 7111 |
|
| 7071 | 7112 |
|
| ... | ... | |
| 7075 | 7116 |
|
| 7076 | 7117 |
|
| 7077 | 7118 |
-- |
| 7078 |
-- Name: provider_count; Type: ACL; Schema: public; Owner: -
|
|
| 7119 |
-- Name: placename_ancestor; Type: ACL; Schema: public; Owner: -
|
|
| 7079 | 7120 |
-- |
| 7080 | 7121 |
|
| 7081 | 7122 |
|
| ... | ... | |
| 7084 | 7125 |
|
| 7085 | 7126 |
|
| 7086 | 7127 |
|
| 7128 |
-- |
|
| 7129 |
-- Name: plant; Type: ACL; Schema: public; Owner: - |
|
| 7130 |
-- |
|
| 7087 | 7131 |
|
| 7132 |
|
|
| 7133 |
|
|
| 7134 |
|
|
| 7135 |
|
|
| 7136 |
|
|
| 7137 |
|
|
| 7088 | 7138 |
-- |
| 7089 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: -
|
|
| 7139 |
-- Name: projectcontributor; Type: ACL; Schema: public; Owner: -
|
|
| 7090 | 7140 |
-- |
| 7091 | 7141 |
|
| 7092 | 7142 |
|
| ... | ... | |
| 7095 | 7145 |
|
| 7096 | 7146 |
|
| 7097 | 7147 |
|
| 7148 |
-- |
|
| 7149 |
-- Name: provider_count; Type: ACL; Schema: public; Owner: - |
|
| 7150 |
-- |
|
| 7098 | 7151 |
|
| 7152 |
|
|
| 7153 |
|
|
| 7154 |
|
|
| 7155 |
|
|
| 7156 |
|
|
| 7157 |
|
|
| 7158 |
|
|
| 7099 | 7159 |
-- |
| 7100 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
|
|
| 7160 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: -
|
|
| 7101 | 7161 |
-- |
| 7102 | 7162 |
|
| 7103 | 7163 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added materialized view owner_count, generated from owner_count_view