Revision 12410
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2349 | 2349 |
$_$; |
| 2350 | 2350 |
|
| 2351 | 2351 |
|
| 2352 |
-- |
|
| 2353 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2354 |
-- |
|
| 2355 |
|
|
| 2356 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 2357 |
projects bigint |
|
| 2358 |
); |
|
| 2359 |
|
|
| 2360 |
|
|
| 2361 |
-- |
|
| 2362 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2363 |
-- |
|
| 2364 |
|
|
| 2365 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 2366 |
projectname text |
|
| 2367 |
); |
|
| 2368 |
|
|
| 2369 |
|
|
| 2370 |
-- |
|
| 2371 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2372 |
-- |
|
| 2373 |
|
|
| 2374 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 2375 |
plots bigint |
|
| 2376 |
); |
|
| 2377 |
|
|
| 2378 |
|
|
| 2352 | 2379 |
SET search_path = public, pg_catalog; |
| 2353 | 2380 |
|
| 2354 | 2381 |
-- |
| ... | ... | |
| 9139 | 9166 |
SET search_path = public_validations, pg_catalog; |
| 9140 | 9167 |
|
| 9141 | 9168 |
-- |
| 9169 |
-- Data for Name: ~type._plots_01_count_of_projects; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9170 |
-- |
|
| 9171 |
|
|
| 9172 |
|
|
| 9173 |
|
|
| 9174 |
-- |
|
| 9175 |
-- Data for Name: ~type._plots_02_list_of_project_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9176 |
-- |
|
| 9177 |
|
|
| 9178 |
|
|
| 9179 |
|
|
| 9180 |
-- |
|
| 9181 |
-- Data for Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9182 |
-- |
|
| 9183 |
|
|
| 9184 |
|
|
| 9185 |
|
|
| 9186 |
-- |
|
| 9142 | 9187 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 9143 | 9188 |
-- |
| 9144 | 9189 |
|
Also available in: Unified diff
schemas/vegbien.sql: added ~type tables for plots queries that are able to be run successfully