Project

General

Profile

« Previous | Next » 

Revision 6656

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: analytical_*: Changed type of boolean columns to integer so that they will be exported as 1/0 instead of t/f by export_analytical_db. This will enable MySQL's LOAD DATA INFILE to import the values correctly.

View differences:

vegbien.my.sql
709 709 
    `decimalLatitude` double precision,
710 710 
    `decimalLongitude` double precision,
711 711 
    `coordinateUncertaintyInMeters` double precision,
712 
    geovalid int(1),
713 
    `isNewWorld` int(1),
712 
    geovalid int(11),
713 
    `isNewWorld` int(11),
714 714 
    `locationName` varchar(255) NOT NULL,
715 715 
    `elevationInMeters` double precision,
716 716 
    `plotArea_ha` double precision,
......
723 723 
    `scientificName` varchar(255),
724 724 
    `scientificNameAuthorship` varchar(255),
725 725 
    `scientificNameWithMorphospecies` varchar(255),
726 
    threatened int(1),
726 
    threatened int(11),
727 727 
    `identifiedBy` varchar(255),
728 728 
    `growthForm` varchar(255),
729 
    cultivated int(1),
729 
    cultivated int(11),
730 730 
    `cultivatedBasis` varchar(255),
731 731 
    `coverPercent` double precision,
732 732 
    `individualCount` varchar(255),
......
752 752 
    `decimalLatitude` double precision,
753 753 
    `decimalLongitude` double precision,
754 754 
    `coordinateUncertaintyInMeters` double precision,
755 
    geovalid int(1),
756 
    `isNewWorld` int(1),
755 
    geovalid int(11),
756 
    `isNewWorld` int(11),
757 757 
    `projectID` varchar(255),
758 758 
    `locationName` varchar(255) NOT NULL,
759 759 
    `elevationInMeters` double precision,
......
768 768 
    `scientificNameAuthorship` varchar(255),
769 769 
    `speciesBinomialWithMorphospecies` varchar(255),
770 770 
    `scientificNameWithMorphospecies` varchar(255),
771 
    threatened int(1),
771 
    threatened int(11),
772 772 
    `identifiedBy` varchar(255),
773 773 
    `growthForm` varchar(255),
774 
    cultivated int(1),
774 
    cultivated int(11),
775 775 
    `cultivatedBasis` varchar(255),
776 776 
    `recordedBy` varchar(255),
777 777 
    `recordNumber` varchar(255),

Also available in: Unified diff