This is just simple way to generate/create a mysql database (like migration at Laravel)

git clone https://github.com/haloriyan/db-generator.git

• First, star this repo, after that clone it
• After cloning, open the db.json file
• You can create or change database and table according to your needs in this file
• Run create.php with your browser

{
  "namaDb": "myDb"
  ...
}

I think there's no difficulty here

{
  ...
  "tabel": {
    "table1": [
      "id int(11)",
      "name varchar(20)",
      "dummy varchar(10) null"
    ],
    "table2":
    "table3":
    "etc"
  }
}

id, name, and dummy are names of your structures table. int and varchar are datatype of the structure. And null is optional. If you dont type it, that mean set to default which mean not null.

You can give extra attribute like primary key or unique key to your table structure like this

{
  "tabel": {
    "table1" : [ ... ]
  },
  "atribut": {
    "primary key": [
      "table1.id",
      "table2.username"
      "table3.etc"
    ],
    "unique key": [
      "table1.name",
      "table2.email",
      "table3.etc"
    ]
  }
}

I think you already understand with this. table1.id in primary key is structure where is set up to be primary. So also with the unique key. table1 is name of your table, and id is structur name of your table.