ubuntu10.04中的mysql数据库不能被远程sql server 2005访问，请高手指点迷津！

我执行建表命令，系统提示ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(CURRENT_DATE() + INTERVAL 1 DAY), PRIMARY KEY (`username`)) DEFAULT CHARACTER' at line 5

我的建表命令如下：

CREATE TABLE `log` (
`username` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL,
`password` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`active` TINYINT DEFAULT '1',
`creation` DATE DEFAULT (CURRENT_DATE() + INTERVAL 1 DAY),
PRIMARY KEY (`username`))
DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

请问如何处理？谢谢！

我已经知道是跟“(CURRENT_DATE() + INTERVAL 1 DAY)”有关，但是不知道究竟是什么问题，有人可以帮助我吗？