Revision 12410
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1021 | 1021 |
|
| 1022 | 1022 |
|
| 1023 | 1023 |
|
| 1024 |
-- |
|
| 1025 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1026 |
-- |
|
| 1024 | 1027 |
|
| 1028 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1029 |
projects varchar(255) |
|
| 1030 |
); |
|
| 1025 | 1031 |
|
| 1032 |
|
|
| 1026 | 1033 |
-- |
| 1034 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1035 |
-- |
|
| 1036 |
|
|
| 1037 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1038 |
projectname varchar(255) |
|
| 1039 |
); |
|
| 1040 |
|
|
| 1041 |
|
|
| 1042 |
-- |
|
| 1043 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1044 |
-- |
|
| 1045 |
|
|
| 1046 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 1047 |
plots varchar(255) |
|
| 1048 |
); |
|
| 1049 |
|
|
| 1050 |
|
|
| 1051 |
|
|
| 1052 |
|
|
| 1053 |
-- |
|
| 1027 | 1054 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1028 | 1055 |
-- |
| 1029 | 1056 |
|
| ... | ... | |
| 6710 | 6737 |
|
| 6711 | 6738 |
|
| 6712 | 6739 |
-- |
| 6740 |
-- Data for Name: ~type._plots_01_count_of_projects; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6741 |
-- |
|
| 6742 |
|
|
| 6743 |
|
|
| 6744 |
|
|
| 6745 |
-- |
|
| 6746 |
-- Data for Name: ~type._plots_02_list_of_project_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6747 |
-- |
|
| 6748 |
|
|
| 6749 |
|
|
| 6750 |
|
|
| 6751 |
-- |
|
| 6752 |
-- Data for Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6753 |
-- |
|
| 6754 |
|
|
| 6755 |
|
|
| 6756 |
|
|
| 6757 |
-- |
|
| 6713 | 6758 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 6714 | 6759 |
-- |
| 6715 | 6760 |
|
| trunk/schemas/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