sequelize.sync() does not create schemas

[CoryGH]

Feature Description

Describe the feature you'd like to see implemented

I'd like to see sequalize.sync() and model.create() be extended to be able to create schemas within the database if the schema called for does not currently exist to allow for fully-sequalized initialization of databases without the need to call upon postgresql/mysql/etc specific libraries as necessary.

As a separate item, it would also be nice if there were a way to tell the initial Sequelize().constructor(database, username, password, options) call to create the database if it does not already exist, assuming the user+pass combination for the server allows that level of access.

Describe why you would like this feature to be added to Sequelize

It seems odd sequelize does not already have it and would reduce the complexity of downstream code.

Is this feature dialect-specific?

• No. This feature is relevant to Sequelize as a whole.
• Yes. This feature only applies to the following dialect(s): different adapters would be needed for different dialects.

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I will need guidance.
• No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
• No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in implementing my feature.

---

Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.

[daifuyang]

same as i

[yumin2002]

Can I work on this issue?

[ephys]

Sure!