Revision 12666
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1413 | 1413 |
|
| 1414 | 1414 |
CREATE TABLE `~type._plots_08_list_of_plots_which_use_percent_cover` ( |
| 1415 | 1415 |
project_name varchar(255), |
| 1416 |
plot_code varchar(255) |
|
| 1416 |
plot_code varchar(255), |
|
| 1417 |
copies varchar(255) NOT NULL |
|
| 1417 | 1418 |
); |
| 1418 | 1419 |
|
| 1419 | 1420 |
|
| ... | ... | |
| 1559 | 1560 |
project_name varchar(255), |
| 1560 | 1561 |
plot_code varchar(255), |
| 1561 | 1562 |
taxon varchar(255), |
| 1562 |
totalpercentcover double precision |
|
| 1563 |
totalpercentcover double precision, |
|
| 1564 |
copies varchar(255) NOT NULL |
|
| 1563 | 1565 |
); |
| 1564 | 1566 |
|
| 1565 | 1567 |
|
| ... | ... | |
| 1729 | 1731 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
| 1730 | 1732 |
trait varchar(255), |
| 1731 | 1733 |
value varchar(255), |
| 1732 |
units varchar(255) |
|
| 1734 |
units varchar(255), |
|
| 1735 |
copies varchar(255) NOT NULL |
|
| 1733 | 1736 |
); |
| 1734 | 1737 |
|
| 1735 | 1738 |
|
| ... | ... | |
| 1747 | 1750 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
| 1748 | 1751 |
taxonwithauthor varchar(255), |
| 1749 | 1752 |
trait varchar(255), |
| 1750 |
value varchar(255) |
|
| 1753 |
value varchar(255), |
|
| 1754 |
copies varchar(255) NOT NULL |
|
| 1751 | 1755 |
); |
| 1752 | 1756 |
|
| 1753 | 1757 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validations: regenerated ~type tables, which adds `copies` columns for queries with a mismatch in the # of occurrences of each row