CREATE TABLE `destination` (
  `destinationID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'lanNL=bestemming;',
  `name` varchar(255) DEFAULT NULL COMMENT 'col#=1;lanNL=bestemming;',
  `cluster` varchar(100) DEFAULT NULL COMMENT 'col#=2;lanNL=cluster;',
  `segment` varchar(100) DEFAULT NULL COMMENT 'col#=4;lanNL=segment;',
  `class` varchar(2) DEFAULT NULL COMMENT 'col#=5;lanNL=klasse;',
  `premium_building` varchar(5) DEFAULT NULL COMMENT 'col#=6;lanNL=premie gebouw;',
  `premium_inventory_goods` varchar(5) DEFAULT NULL COMMENT 'col#=7;lanNL=premie inventaris goederen;',
  `premium_company_risk` varchar(5) DEFAULT NULL COMMENT 'col#=8;lanNL=premie bedrijfsschade;',
  `checked` tinyint(4) DEFAULT NULL COMMENT 'col#=9;lanNL=gecontroleerd;enumNL=Nee;enumNL=Ja;',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'col#=10;lanNL=datum wijziging;',
  PRIMARY KEY (`destinationID`)
) ENGINE=InnoDB AUTO_INCREMENT=1384 DEFAULT CHARSET=utf8;
CREATE TABLE `destination_code` (
  `destination_codeID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'lanNL=bestemming code;',
  `destination_code` varchar(6) DEFAULT NULL,
  `updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`destination_codeID`)
) ENGINE=InnoDB AUTO_INCREMENT=4652 DEFAULT CHARSET=utf8;
CREATE TABLE `CEA_code` (
  `CEA_codeID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'lanNL=CEA code;',
  `CEA_code` varchar(4) DEFAULT NULL,
  `updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`CEA_codeID`)
) ENGINE=InnoDB AUTO_INCREMENT=1757 DEFAULT CHARSET=utf8;
CREATE TABLE `_Z_REL_CEA_code_destination` (
  `_Z_REL_CEA_code_destinationID` int(11) NOT NULL AUTO_INCREMENT,
  `CEA_codeID` int(11) NOT NULL,
  `destinationID` int(11) NOT NULL,
  `sequence1` int(4) DEFAULT NULL,
  `sequence2` int(4) DEFAULT NULL,
  PRIMARY KEY (`_Z_REL_CEA_code_destinationID`),
  UNIQUE KEY `destinationID_UNIQUE` (`destinationID`)
) ENGINE=InnoDB AUTO_INCREMENT=9649 DEFAULT CHARSET=utf8;
CREATE TABLE `_Z_REL_destination_code_destination` (
  `_Z_REL_destination_code_destinationID` int(11) NOT NULL AUTO_INCREMENT,
  `destination_codeID` int(11) DEFAULT '0',
  `destinationID` int(11) NOT NULL,
  `sequencce1` int(4) DEFAULT NULL,
  `sequence2` int(4) DEFAULT NULL,
  PRIMARY KEY (`_Z_REL_destination_code_destinationID`),
  UNIQUE KEY `destinationID_UNIQUE` (`destinationID`)
) ENGINE=InnoDB AUTO_INCREMENT=9646 DEFAULT CHARSET=utf8;