mysql5.5运行sql文件由于版本太低,timestamp(0)语法错误

• sql文件内容

CREATE TABLE `orders`  (
  `oid` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单主键',
  `uid` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户openid',
  `oprice` int(11) NULL DEFAULT NULL COMMENT '订单支付价格',
  `otime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '订单创建时间',
  `bkid` int(11) NULL DEFAULT NULL COMMENT '书籍id',
  PRIMARY KEY (`oid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

• 错误信息
  [Err] 1064 - 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 ‘(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT’ at line 5
• 原因
  我的数据库版本太低了，使用的是5.5版本的，把timestamp(0)中的(0)去掉,
  另外在mysql5.5中如果sql文件中有datetime(0)也一样要去掉(0)