Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

docker部署sql错误 #3714

Closed
studyzhanglei opened this issue May 27, 2021 · 1 comment · Fixed by #3720
Closed

docker部署sql错误 #3714

studyzhanglei opened this issue May 27, 2021 · 1 comment · Fixed by #3720

Comments

@studyzhanglei
Copy link

studyzhanglei commented May 27, 2021

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', '[email protected]', 1);

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

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

@nobodyiam
Copy link
Member

Thanks for the feedback, this is a bug introduced in #3629.
@vdisk-group would you please take a look and fix it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants