-- Copy from CSV files (note that there should NOT be a semicolon at the end of each line)

\copy datastaging.BarrierComputation(BarrierComputationID, BarrierComputationName, BarrierComputationRelease, BarrierComputationProducer, Iterator, WCAGMinorID, TechniqueID, TestModeID) from 'prefilldata/BarrierComputation.csv' with csv header
\copy datastaging.Nace(NaceID, NaceCode, NaceDescription) from 'prefilldata/Nace.csv' with csv header
\copy datastaging.Country(CountryID, Country, CountryAbbreviation, EUmember) from 'prefilldata/Country.csv' with csv header
\copy datastaging.DisabilityGroup(DisabilityGroupID, DisabilityGroup) from 'prefilldata/DisabilityGroup.csv' with csv header
\copy datastaging.Hour(HourID, Hour) from 'prefilldata/Hour.csv' with csv header
\copy datastaging.Minute(MinuteID, Minute, HourID) from 'prefilldata/Minute.csv' with csv header
\copy datastaging.NutsLevel1(NutsLevel1ID, Nuts1Code, Nuts1Name, CountryID) from 'prefilldata/NutsLevel1.csv' with null as 'NULL' csv header
\copy datastaging.NutsLevel2(NutsLevel2ID, Nuts2Code, Nuts2Name, NutsLevel1ID) from 'prefilldata/NutsLevel2.csv' with null as 'NULL' csv header
\copy datastaging.NutsLevel3(NutsLevel3ID, Nuts3Code, Nuts3Name, NutsLevel2ID) from 'prefilldata/NutsLevel3.csv' with null as 'NULL' csv header
\copy datastaging.OperatingSystemFamily(OperatingSystemFamilyID, OperatingSystemFamily) from 'prefilldata/OperatingSystemFamily.csv' with csv header
\copy datastaging.Result(ResultID, TextualDescription, ShortDescription, ResultTypeID) from 'prefilldata/Result.csv' with csv header
\copy datastaging.ResultType(ResultTypeID, ResultType) from 'prefilldata/ResultType.csv' with csv header
\copy datastaging.UWEMTest(UWEMTestID, UWEMTestName, UWEMTestTypeID,BarrierComputationID) FROM 'prefilldata/UWEMTest.csv' with csv header
\copy datastaging.UWEMTestType(UWEMTestTypeID, UWEMTestType) from 'prefilldata/UWEMTestType.csv' with csv header
\copy datastaging.WCAGMajor(WCAGMajorID, WCAGMajor, GuideLine, GuidelineURL, WCAGTypeID) from 'prefilldata/WCAGMajor.csv' with csv header
\copy datastaging.WCAGMinor(WCAGMinorID, WCAGMinor, Priority, Checkpoint, CheckpointURL, WCAGMajorID) from 'prefilldata/WCAGMinor.csv' with csv header
\copy datastaging.WCAGType(WCAGTypeID, WCAGType) from 'prefilldata/WCAGType.csv' with csv header
\copy datastaging.InclusionType(InclusionTypeID,InclusionType) from 'prefilldata/InclusionType.csv' with csv header
\copy datastaging.Technique(TechniqueID, Technique) from 'prefilldata/Technique.csv' with csv header
\copy datastaging.TestMode(TestModeID, TestMode) from 'prefilldata/TestMode.csv' with csv header

-- Insert Unknown values.
-- (Category, OperatingSystemFamily, Result, ResultType, Sector are already dealt with in CSV-files)

INSERT INTO datastaging.BarrierComputation(BarrierComputationID, BarrierComputationName, BarrierComputationRelease, BarrierComputationProducer, Iterator, WCAGMinorID, TechniqueID, TestModeID) VALUES(-1, 'Unknown', NULL, NULL, NULL, -1, -1, -1);
INSERT INTO datastaging.Nace(NaceID, NaceCode, NaceDescription) VALUES(-1, 'Unknown', 'Unknown');
INSERT INTO datastaging.Country(CountryID, Country, CountryAbbreviation, EUMember) VALUES(-1, 'Unknown', NULL, 'Unknown');
INSERT INTO datastaging.Month(MonthID, MonthNumberInYear, MonthName, DaysInMonth, MonthNumberAfterEIAOStart, QuarterID) VALUES(-1, NULL, 'Unknown', NULL, NULL, -1);
INSERT INTO datastaging.Date(DateID, DayNumberInMonth, DayNumberInWeek, DayName, Date, MonthID, WeekID) VALUES(-1, NULL, NULL, 'Unknown', NULL, -1, -1);
INSERT INTO datastaging.Hour(HourID, Hour) VALUES(-1, NULL);
INSERT INTO datastaging.Language(LanguageID, Language, LanguageAbbreviation, LanguageFamilyID) VALUES(-1, 'Unknown', NULL, -1);
INSERT INTO datastaging.Language(LanguageID, Language, LanguageAbbreviation, LanguageFamilyID) VALUES(-2, 'No languages listed', NULL, -1);
INSERT INTO datastaging.LanguageFamily(LanguageFamilyID, LanguageFamily, LanguageFamilyAbbreviation) VALUES(-1,'Unknown', NULL);
INSERT INTO datastaging.Minute(MinuteID, Minute, HourID) VALUES(-1, NULL, -1);
INSERT INTO datastaging.NutsLevel1(NutsLevel1ID, Nuts1Code, Nuts1Name, CountryID) VALUES(-1, NULL, 'Unknown', -1);
INSERT INTO datastaging.NutsLevel2(NutsLevel2ID, Nuts2Code, Nuts2Name, NutsLevel1ID) VALUES(-1, NULL, 'Unknown', -1);
INSERT INTO datastaging.NutsLevel3(NutsLevel3ID, Nuts3Code, Nuts3Name, NutsLevel2ID) VALUES(-1, NULL, 'Unknown', -1);
INSERT INTO datastaging.Quarter(QuarterID, QuarterName, QuarterNumberInYear, YearID) VALUES(-1, 'Unknown', NULL, -1);
INSERT INTO datastaging.Week(WeekID, WeekNumberInYear, YearID) VALUES(-1, NULL, -1);
INSERT INTO datastaging.Year(YearID, Year) VALUES(-1, NULL);
INSERT INTO datastaging.Server(ServerID, Server, ServerVersion, CompleteServerName, OperatingSystemFamilyID) VALUES(-1, 'Unknown', 'Unknown', 'Unknown', -1);
INSERT INTO datastaging.UWEMTest(UWEMTestID, UWEMTestName, UWEMTestTypeID) VALUES(-1, 'Unknown', -1);
INSERT INTO datastaging.UWEMTest(UWEMTestID, UWEMTestName, UWEMTestTypeID) VALUES(-2, 'None', -2);
INSERT INTO datastaging.UWEMTestType(UWEMTestTypeID, UWEMTestType) VALUES(-1, 'Unknown');
INSERT INTO datastaging.UWEMTestType(UWEMTestTypeID, UWEMTestType) VALUES(-2, 'None');
INSERT INTO datastaging.MediaType(MediaTypeID, MediaType) VALUES(-1, 'Unknown');
INSERT INTO datastaging.MediaType(MediaTypeID, MediaType) VALUES(-2, 'No media types listed');
INSERT INTO datastaging.WCAGMajor(WCAGMajorID, WCAGMajor, Guideline, GuidelineURL, WCAGTypeID) VALUES(-1, NULL, 'Unknown', 'Unknown', -1);
INSERT INTO datastaging.WCAGMinor(WCAGMinorID, WCAGMinor, Priority, Checkpoint, CheckpointURL, WCAGMajorID) VALUES(-1, NULL, NULL, 'Unknown', 'Unknown', -1);
INSERT INTO datastaging.WCAGType(WCAGTypeID, WCAGType) VALUES(-1, NULL);
INSERT INTO datastaging.InclusionType(InclusionTypeID,InclusionType) VALUES(-1, 'Unknown');
INSERT INTO datastaging.MimeType(MimeTypeID, MimeType, MimeSubtype) VALUES(-1, 'Unknown', 'Unknown');
INSERT INTO datastaging.Technique(TechniqueID, Technique) VALUES(-1, 'Unknown');
INSERT INTO datastaging.TestMode(TestModeID, TestMode) VALUES(-1, 'Unknown');
INSERT INTO datastaging.DisabilityGroupRelevance_Fcui(DisabilityGroupID, BarrierComputationID, BarrierProbability) SELECT DisabilityGroupID, BarrierComputationID, 0.05 from datastaging.BarrierComputation, datastaging.DisabilityGroup