mysql创建一个表一直错_mysql-表创建错误

在MySQL终端上粘贴以下MySQL命令后出现以下错误,此代码是从项目的生产环境中获取的,我想根据生产环境的数据库更新本地数据库.

mysql> CREATE TABLE `cityguide_pointofinterest` (

-> `id` int(11) NOT NULL AUTO_INCREMENT,

-> `name` varchar(30) COLLATE utf8_danish_ci NOT NULL,

-> `vip` tinyint(1) NOT NULL,

-> `description` longtext COLLATE utf8_danish_ci NOT NULL,

-> `category_id` int(11) NOT NULL,

-> `email` varchar(254) COLLATE utf8_danish_ci,

-> `latitude` double NOT NULL,

-> `longitude` double NOT NULL,

-> `phone` varchar(15) COLLATE utf8_danish_ci,

-> `place` varchar(250) COLLATE utf8_danish_ci DEFAULT NULL,

-> `website` varchar(200) COLLATE utf8_danish_ci,

-> `date_created` datetime(6) NOT NULL,

-> `date_modified` datetime(6) NOT NULL,

-> `views` int(11) NOT NULL,

-> `picture_1` varchar(100) COLLATE utf8_danish_ci,

-> `picture_2` varchar(100) COLLATE utf8_danish_ci,

-> `picture_3` varchar(100) COLLATE utf8_danish_ci,

-> `order_id` varchar(20) COLLATE utf8_danish_ci DEFAULT NULL,

-> PRIMARY KEY (`id`),

-> KEY `cityguide_pointofi_category_id_8ab78aba_fk_cityguide_category_id` (`category_id`),

-> CONSTRAINT `cityguide_pointofi_category_id_8ab78aba_fk_cityguide_category_id` FOREIGN KEY (`category_id`) REFERENCES `cityguide_category` (`id`)

-> ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

错误1064(42000)：您的SQL语法有错误；查看与您的MySQL服务器版本相对应的手册,以获取正确的语法,以在'(6)NOT NULL附近使用,

??????date_modified datetime(6)非空,

??????在第13行查看int(11)NOT NULL’

????MySQL的> / *！40101 SET character_set_client = @saved_cs_client * /;

????查询正常,受影响的0行(0.00秒)