atlas migration fails with long Identifier names.

[tomoyukikino]

Current Behavior 😯

when create migration sql file by atlas, this error occurd.

$ atlas migrate diff migration_name --dir "file://ent/migrate/migrations" --to "ent://ent/schema" --dev-url "docker://mysql/8/ent"
Error: create "organization_quotation_main_parts" table: Error 1059 (42000): Identifier name 'organization_quotation_main_parts_organization_quotation_categories_organization_quotation_category' is too long

I try StrageKey refer to this a8m comment.
but this error is not solved.

// Edges of the OrganizationQuotationCategory.
func (OrganizationQuotationCategory) Edges() []ent.Edge {
	return []ent.Edge{
		// M2M(many-to-many)
		// Intermediate table: organization_quotation_main_parts.
		edge.To("quotation_for_main_parts", Quotation.Type).
			StorageKey(edge.Table("hoge")).
			Through("organization_quotation_main_parts", OrganizationQuotationMainPart.Type).
			// StorageKey(
			// 	edge.Table("hoge"),
			// 	edge.Columns("o_id", "q_id"),
			// ).
			// Delete association M2M(many-to-many) table
			// Main parts is deleted when this table a category is deleted.
			Annotations(entsql.Annotation{
				OnDelete: entsql.Cascade,
			}),

		// M2M(many-to-many).
		// Intermediate table: this table.
		edge.To("organization", Organization.Type).
			Field("organization_id"). // Tell ent which field holds the reference to the organization.
			Unique().                 // FIXME: ユニーク制約いらないかも？
			Required(),               // This table entity cannot be created without its Organization.
		edge.To("quotation", Quotation.Type).
			Field("quotation_id"). // FIXME: ユニーク制約いらないかも？
			Unique().
			Required(),
	}
}


// Edges of the OrganizationQuotationMainPart.
func (OrganizationQuotationMainPart) Edges() []ent.Edge {
	return []ent.Edge{
		// M2M(many-to-many)
		// Intermediate table: organization_quotation_sub_parts.
		edge.To("quotation_for_sub_parts", Quotation.Type).
			StorageKey(edge.Table("hoge")).
			// StorageKey(
			// 	edge.Table("friends"),
			// 	edge.Columns("user_id", "friend_id"),
			// ).
			// StorageKey(edge.Table("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa")).
			Through("organization_quotation_sub_parts", OrganizationQuotationSubPart.Type).
			// Delete association M2M(many-to-many) table
			// Sub parts is deleted when this table a record(one main part) is deleted.
			Annotations(entsql.Annotation{
				OnDelete: entsql.Cascade,
			}),

		// M2M(many-to-many) intermediate table.
		edge.To("organization_quotation_category", OrganizationQuotationCategory.Type).
			Unique().
			Required().
			Field("organization_quotation_categories_id"), // Tell ent which field holds the reference to the OrganizationQuotationCategory.
		edge.To("quotation", Quotation.Type).
			Unique().
			Required().
			Field("quotation_id"),
	}
}