Revision 12687
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1441 | 1441 |
|
| 1442 | 1442 |
CREATE TABLE `~type._plots_08_list_of_plots_which_use_percent_cover` ( |
| 1443 | 1443 |
project_name varchar(255), |
| 1444 |
plot_code varchar(255), |
|
| 1445 |
copies varchar(255) NOT NULL |
|
| 1444 |
plot_code varchar(255) |
|
| 1446 | 1445 |
); |
| 1447 | 1446 |
|
| 1448 | 1447 |
|
| ... | ... | |
| 1588 | 1587 |
project_name varchar(255), |
| 1589 | 1588 |
plot_code varchar(255), |
| 1590 | 1589 |
taxon varchar(255), |
| 1591 |
totalpercentcover double precision, |
|
| 1592 |
copies varchar(255) NOT NULL |
|
| 1590 |
totalpercentcover double precision |
|
| 1593 | 1591 |
); |
| 1594 | 1592 |
|
| 1595 | 1593 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2770 | 2770 |
|
| 2771 | 2771 |
CREATE TABLE "~type._plots_08_list_of_plots_which_use_percent_cover" ( |
| 2772 | 2772 |
project_name text, |
| 2773 |
plot_code text, |
|
| 2774 |
copies bigint NOT NULL |
|
| 2773 |
plot_code text |
|
| 2775 | 2774 |
); |
| 2776 | 2775 |
|
| 2777 | 2776 |
|
| ... | ... | |
| 2949 | 2948 |
project_name text, |
| 2950 | 2949 |
plot_code text, |
| 2951 | 2950 |
taxon text, |
| 2952 |
totalpercentcover double precision, |
|
| 2953 |
copies bigint NOT NULL |
|
| 2951 |
totalpercentcover double precision |
|
| 2954 | 2952 |
); |
| 2955 | 2953 |
|
| 2956 | 2954 |
|
Also available in: Unified diff
schemas/vegbien.sql: _plots_08_list_of_plots_which_use_percent_cover, _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro: reran with fixes, which removes the incorrectly auto-added copies columns. (they were only able to be auto-added because the tables had no rows.)