CREATE TABLE QualifiedRecipientsDataType
(
    nodeId BIGINT UNSIGNED DEFAULT NULL,
    fieldName VARCHAR(75) DEFAULT NULL,
    node BIGINT UNSIGNED DEFAULT NULL,
    rule VARCHAR(10) DEFAULT NULL,
    related BIGINT UNSIGNED DEFAULT NULL,
    KEY ( node,fieldName ),
    KEY ( nodeId,fieldName )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="List of qualified recipients ( used in notifications)";
