Identity DB failing to create in MYSQL

[hwupathum]

Description

When trying to run IDENTITY_DB script to create database in MYSQL the script fails with following error.

ERROR 1075 (42000) at line 1676 in file: '/home/ubuntu/wso2is/dbscripts/identity/mysql.sql': Incorrect table definition; there can be only one auto column and it must be defined as a key

Steps to Reproduce

Run identity/mysql.sql file in a MYSQL 8 database

Version

IS 7.2.0-m2

Environment Details (with versions)

No response

[hwupathum]

Seems to have occurred after wso2/carbon-identity-framework#6641