Revision 1210
Added by Aaron Marcuse-Kubitza almost 13 years ago
inputs/NYBG/test/import.specimens.out.ref | ||
---|---|---|
1 |
Inserted 60 new rows into database |
|
1 |
Inserted 61 new rows into database |
inputs/SALVIAS/test/import.plots.out.ref | ||
---|---|---|
1 |
Inserted 12 new rows into database |
|
1 |
Inserted 31 new rows into database |
inputs/SALVIAS/test/import.organisms.out.ref | ||
---|---|---|
1 |
Inserted 48 new rows into database |
|
1 |
Inserted 71 new rows into database |
inputs/NYBG-CSV/test/import.specimens.out.ref | ||
---|---|---|
1 |
Inserted 60 new rows into database |
|
1 |
Inserted 61 new rows into database |
inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
---|---|---|
1 |
Inserted 12 new rows into database |
|
1 |
Inserted 14 new rows into database |
schemas/vegbien.my.sql | ||
---|---|---|
2050 | 2050 |
CREATE TABLE stemobservation ( |
2051 | 2051 |
stemobservation_id int(11) NOT NULL, |
2052 | 2052 |
plantobservation_id int(11) NOT NULL, |
2053 |
sourceaccessioncode text, |
|
2053 | 2054 |
authorstemcode text, |
2054 | 2055 |
xposition double precision, |
2055 | 2056 |
yposition double precision, |
2056 |
health text, |
|
2057 |
emb_stemobservation int(11), |
|
2058 | 2057 |
diameterbreastheight double precision, |
2058 |
basaldiameter double precision, |
|
2059 |
diameteraccuracy double precision, |
|
2059 | 2060 |
height double precision, |
2060 | 2061 |
heightaccuracy double precision, |
2062 |
health text, |
|
2061 | 2063 |
age double precision, |
2062 | 2064 |
accessioncode text, |
2063 |
diameteraccuracy double precision, |
|
2064 |
sourceaccessioncode text |
|
2065 |
emb_stemobservation int(11) |
|
2065 | 2066 |
); |
2066 | 2067 |
|
2067 | 2068 |
|
schemas/vegbien.sql | ||
---|---|---|
2402 | 2402 |
CREATE TABLE stemobservation ( |
2403 | 2403 |
stemobservation_id integer NOT NULL, |
2404 | 2404 |
plantobservation_id integer NOT NULL, |
2405 |
sourceaccessioncode text, |
|
2405 | 2406 |
authorstemcode text, |
2406 | 2407 |
xposition double precision, |
2407 | 2408 |
yposition double precision, |
2408 |
health text, |
|
2409 |
emb_stemobservation integer, |
|
2410 | 2409 |
diameterbreastheight double precision, |
2410 |
basaldiameter double precision, |
|
2411 |
diameteraccuracy double precision, |
|
2411 | 2412 |
height double precision, |
2412 | 2413 |
heightaccuracy double precision, |
2414 |
health text, |
|
2413 | 2415 |
age double precision, |
2414 | 2416 |
accessioncode text, |
2415 |
diameteraccuracy double precision, |
|
2416 |
sourceaccessioncode text |
|
2417 |
emb_stemobservation integer |
|
2417 | 2418 |
); |
2418 | 2419 |
|
2419 | 2420 |
|
Also available in: Unified diff
vegbien.sql: stemobservation: Added diameteraccuracy. Reordered fields.