text: CREATE DATABASE IF NOT EXISTS HAIBA;
  USE HAIBA;
  
  CREATE TABLE IF NOT EXISTS Class_SHAK (
  	OrganisationPID BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
  
  	Nummer VARCHAR(20) NOT NULL,
  	Navn VARCHAR(60),
  	Organisationstype VARCHAR(30) NOT NULL,
      Ejerforhold VARCHAR(20),
      Institutionsart VARCHAR(20),
      Regionskode VARCHAR(20),
  	CreatedDate DATETIME NOT NULL,
  	ValidFrom DATETIME NOT NULL,
  	ValidTo DATETIME NOT NULL,
  
  	INDEX (Nummer, ValidTo, ValidFrom)
  ) ENGINE=InnoDB COLLATE=utf8_bin;
  
  CREATE TABLE IF NOT EXISTS Class_SKS (
  	ID BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
  
  	Code VARCHAR(20) NOT NULL,
  	Text VARCHAR(60),
  	Type VARCHAR(30) NOT NULL,
  
  	Created DATETIME NOT NULL,
  	ValidFrom DATETIME NOT NULL,
  	ValidTo DATETIME NOT NULL
  ) ENGINE=InnoDB COLLATE=utf8_bin;
  
  CREATE TABLE IF NOT EXISTS FGRImporterStatus (
      Id BIGINT(15) AUTO_INCREMENT NOT NULL PRIMARY KEY,
      Type VARCHAR(20),
      StartTime DATETIME NOT NULL,
      EndTime DATETIME,
      Outcome VARCHAR(20),
      ErrorMessage VARCHAR(200),
  
      INDEX (StartTime)
  ) ENGINE=InnoDB COLLATE=utf8_bin;
  
  
  