DROP TABLE 'meta';
DROP TABLE 'data';
DROP TABLE 'normals';
DROP TABLE 'stdevs';

CREATE TABLE 'meta' (
    Station_Number          varchar(8),
    Station_Name            varchar(100),
    Station_Country         varchar(100),
    Station_Lat             number,
    Station_Long            number,
    Station_Height          number,
    Station_Start_Year      char(4),
    Station_End_Year        char(4),
    Station_First_Good_Year char(4),
    Station_Source_ID       char(8),
    Station_Source_File     varchar(100),
    Station_Jones_Data_To   char(4),
    Station_Normals_Source  varchar(40),
    Station_Normals_Source_Percent_Availability number,
    Station_Normals_Source_Variable_Code char(8),
    Station_Normals_Source_Start_Year char(4),
    Station_Normals_Source_End_Year   char(4),
    Station_Standard_Deviations_Source varchar(40),
    Station_Standard_Deviations_Source_Start_Year char(4),
    Station_Standard_Deviations_Source_End_Year char(4),
    PRIMARY KEY (Station_Number)
);

CREATE TABLE 'data' (
    Station_Number  varchar(8),
    Year            char(4),
    Month           char(2),
    Obs             number,
    PRIMARY KEY (Station_Number, Year, Month)
);

CREATE TABLE 'normals' (
    Station_Number  varchar(8),
    Month           char(2),
    Normal          number,
    PRIMARY KEY (Station_Number, Month)
);

CREATE TABLE 'stdevs' (
    Station_Number     varchar(8),
    Month              char(2),
    Standard_Deviation number,
    PRIMARY KEY (Station_Number, Month)
);