CREATE TABLE Users (
Id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增Id',
Username varchar(64) NOT NULL DEFAULT 'default' COMMENT '用户登录账户',
Password varchar(64) NOT NULL DEFAULT 'default' COMMENT '密码',
UserDisplayName varchar(512) NOT NULL DEFAULT 'default' COMMENT '用户名称',
Email varchar(64) NOT NULL DEFAULT 'default' COMMENT '邮箱地址',
Enabled tinyint(4) DEFAULT NULL COMMENT '是否有效',
PRIMARY KEY (Id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

INSERT INTO Users (Username, Password, PreferredUsername, Email, Enabled)
VALUES
('apollo', '$2a$10$7r20uS.BQ9uBpf3Baj3uQOZvMVvB1RN3PYoKE94gtz2.WAOuiiwXS', 'apollo', 'apollo@acme.com', 1);

ERROR 1054 (42S22): Unknown column 'PreferredUsername' in 'field list'

https://github.com/ctripcorp/apollo/blob/master/scripts/docker-quick-start/sql/apolloportaldb.sql