Project

General

Profile

« Previous | Next » 

Revision 1210

vegbien.sql: stemobservation: Added diameteraccuracy. Reordered fields.

View differences:

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