For Time DATETIME NOT ALLOW NULL to set a default that is
the current timestamp or the current Date PLUS 1 week.
Have tried about 50 permutations of date_add Interval and TIMESTAMPADD with date seeds (all dynamic) including current_timestamp, date, now. All I get is syntax error in the GUI field on Save.
I suspect the syntax in this field is somehow slightly different then a mysql statement.