Project

General

Profile

« Previous | Next » 

Revision 5506

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: locationevent: Moved obsstartdate, obsenddate to top of table so they would be visible in the ERD

View differences:

schemas/vegbien.my.sql
391 391 
    project_id int(11),
392 392 
    authoreventcode text,
393 393 
    previous_id int(11),
394 
    obsstartdate date,
395 
    obsenddate date,
394 396 
    dateaccuracy text,
395 397 
    method_id int(11),
396 398 
    temperature_c double precision,
......
449 451 
    notespublic int(1),
450 452 
    notesmgt int(1),
451 453 
    revisions int(1),
452 
    obsstartdate date,
453 
    obsenddate date,
454 454 
    dateentered date ,
455 455 
    toptaxon1name text,
456 456 
    toptaxon2name text,
schemas/vegbien.sql
729 729 
    project_id integer,
730 730 
    authoreventcode text,
731 731 
    previous_id integer,
732 
    obsstartdate date,
733 
    obsenddate date,
732 734 
    dateaccuracy text,
733 735 
    method_id integer,
734 736 
    temperature_c double precision,
......
787 789 
    notespublic boolean,
788 790 
    notesmgt boolean,
789 791 
    revisions boolean,
790 
    obsstartdate date,
791 
    obsenddate date,
792 792 
    dateentered date DEFAULT now(),
793 793 
    toptaxon1name text,
794 794 
    toptaxon2name text,

Also available in: Unified diff