CREATE TABLE DirectoryListingDataType_History
(
    id BIGINT UNSIGNED DEFAULT NULL,
    Node BIGINT UNSIGNED NOT NULL,
    Listed ENUM("Unlisted", "Listed", "ListedNoAddress") DEFAULT NULL,
    Type ENUM("Residential", "Business") NOT NULL DEFAULT "Residential",
    LastName VARCHAR(50) DEFAULT NULL,
    FirstName VARCHAR(50) DEFAULT NULL,
    BusinessName VARCHAR(100) DEFAULT NULL,
    Building VARCHAR(50) DEFAULT NULL,
    Appartment VARCHAR(10) DEFAULT NULL,
    Floor VARCHAR(50) DEFAULT NULL,
    StreetNumber VARCHAR(6) DEFAULT NULL,
    StreetName VARCHAR(40) DEFAULT NULL,
    StreetType VARCHAR(6) DEFAULT NULL,
    StreetDirCode VARCHAR(2) DEFAULT NULL,
    City VARCHAR(45) DEFAULT NULL,
    Province VARCHAR(45) DEFAULT NULL,
    PostalCode CHAR(7) DEFAULT NULL,
    Legacy VARCHAR(255) DEFAULT NULL,
    ts BIGINT UNSIGNED NOT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT

) ENGINE=INNODB CHARSET=UTF8;
