CREATE TABLE LDAPPhoneSync
(
    id BIGINT UNSIGNED DEFAULT NULL,
    Node BIGINT UNSIGNED DEFAULT NULL,
    Action ENUM("Create", "Change", "Remove") DEFAULT NULL,
    LockId CHAR(32) DEFAULT NULL,
    NeededInfo VARCHAR(255) DEFAULT NULL,
    NodeType ENUM("LDAPContact", "LDAPDirectory") DEFAULT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT,
    UNIQUE ( Node,Action ),
    
    KEY ( LockId )

) ENGINE=INNODB CHARSET=UTF8;
