Revision 12596
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 259 | 259 |
|
| 260 | 260 |
|
| 261 | 261 |
-- |
| 262 |
-- Name: keys_~type._plots_10a_aggregate_observation_individual_counts; Type: TYPE; Schema: public_validations; Owner: - |
|
| 263 |
-- |
|
| 264 |
|
|
| 265 |
|
|
| 266 |
|
|
| 267 |
|
|
| 268 |
-- |
|
| 262 | 269 |
-- Name: keys_~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: - |
| 263 | 270 |
-- |
| 264 | 271 |
|
| ... | ... | |
| 413 | 420 |
|
| 414 | 421 |
|
| 415 | 422 |
-- |
| 423 |
-- Name: values__~type._plots_10a_aggregate_observation_individual_count; Type: TYPE; Schema: public_validations; Owner: - |
|
| 424 |
-- |
|
| 425 |
|
|
| 426 |
|
|
| 427 |
|
|
| 428 |
|
|
| 429 |
-- |
|
| 416 | 430 |
-- Name: values__~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: - |
| 417 | 431 |
-- |
| 418 | 432 |
|
| ... | ... | |
| 1272 | 1286 |
|
| 1273 | 1287 |
|
| 1274 | 1288 |
-- |
| 1289 |
-- Name: ~type._plots_10a_aggregate_observation_individual_counts; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1290 |
-- |
|
| 1291 |
|
|
| 1292 |
CREATE TABLE `~type._plots_10a_aggregate_observation_individual_counts` ( |
|
| 1293 |
project_name varchar(255), |
|
| 1294 |
plot_code varchar(255), |
|
| 1295 |
individual_id varchar(255), |
|
| 1296 |
individuals int(11) |
|
| 1297 |
); |
|
| 1298 |
|
|
| 1299 |
|
|
| 1300 |
-- |
|
| 1301 |
-- Name: keys(`~type._plots_10a_aggregate_observation_individual_counts`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1302 |
-- |
|
| 1303 |
|
|
| 1304 |
|
|
| 1305 |
|
|
| 1306 |
|
|
| 1307 |
-- |
|
| 1275 | 1308 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1276 | 1309 |
-- |
| 1277 | 1310 |
|
| ... | ... | |
| 1727 | 1760 |
|
| 1728 | 1761 |
|
| 1729 | 1762 |
-- |
| 1763 |
-- Name: values_(`~type._plots_10a_aggregate_observation_individual_counts`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1764 |
-- |
|
| 1765 |
|
|
| 1766 |
|
|
| 1767 |
|
|
| 1768 |
|
|
| 1769 |
-- |
|
| 1730 | 1770 |
-- Name: values_(`~type._plots_11_count_of_stems_per_plot_in_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1731 | 1771 |
-- |
| 1732 | 1772 |
|
| ... | ... | |
| 4478 | 4518 |
|
| 4479 | 4519 |
|
| 4480 | 4520 |
-- |
| 4521 |
-- Name: _plots_10a_aggregate_observation_individual_counts; Type: VIEW; Schema: public_validations; Owner: - |
|
| 4522 |
-- |
|
| 4523 |
|
|
| 4524 |
|
|
| 4525 |
|
|
| 4526 |
|
|
| 4527 |
-- |
|
| 4528 |
-- Name: VIEW _plots_10a_aggregate_observation_individual_counts; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 4529 |
-- |
|
| 4530 |
|
|
| 4531 |
|
|
| 4532 |
|
|
| 4533 |
|
|
| 4534 |
-- |
|
| 4481 | 4535 |
-- Name: _plots_11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validations; Owner: - |
| 4482 | 4536 |
-- |
| 4483 | 4537 |
|
| ... | ... | |
| 7486 | 7540 |
|
| 7487 | 7541 |
|
| 7488 | 7542 |
-- |
| 7543 |
-- Data for Name: ~type._plots_10a_aggregate_observation_individual_counts; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 7544 |
-- |
|
| 7545 |
|
|
| 7546 |
|
|
| 7547 |
|
|
| 7548 |
-- |
|
| 7489 | 7549 |
-- Data for Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 7490 | 7550 |
-- |
| 7491 | 7551 |
|
Also available in: Unified diff
schemas/vegbien.sql, inputs/SALVIAS/validations.sql: added _plots_10a_aggregate_observation_individual_counts, for use in debugging diffs in _plots_10_count_of_individuals_per_plot_in_each_proj