CREATE TABLE RepetitionDataType
(
    Node BIGINT UNSIGNED NOT NULL,
    FieldName VARCHAR(255) NOT NULL,
    Repeats ENUM("Annually", "Monthly", "Weekly", "Daily") DEFAULT "Weekly",
    RepeatEvery TINYINT NOT NULL DEFAULT 1,
    RepeatOn TINYINT UNSIGNED DEFAULT 62,
    StartsOn BIGINT UNSIGNED NOT NULL,
    StartsAt CHAR(4) NOT NULL,
    UNIQUE KEY ( Node,FieldName ),
    KEY ( Node,FieldName )

) ENGINE=INNODB CHARSET=UTF8;
