liquibase_migration.json

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create_mydb_users",
        "author": "gabidavila",
        "changes": [
          {
            "createTable": {
              "tableName": "mydb_users",
              "columns": [
                {
                  "column": {
                    "name": "id",
                    "type": "int unsigned",
                    "autoIncrement": true,
                    "constraints": {
                      "primaryKey": true,
                      "nullable": false
                    }
                  }
                },
                {
                  "column": {
                    "name": "username",
                    "type": "varchar(25)",
                    "encoding": "utf8",
                    "constraints": {
                      "nullable": true
                    }
                  }
                },
                {
                  "column": {
                    "name": "password",
                    "type": "varchar(255)",
                    "encoding": "utf8",
                    "constraints": {
                      "nullable": true
                    }
                  }
                },
                {
                  "column": {
                    "name": "activated",
                    "type": "tinyint",
                    "defaultValueNumeric": 0,
                    "constraints": {
                      "nullable": false
                    }
                  }
                }
              ]
            }
          }
        ]
      },
      "modifySql": {
        "dbms": "mysql",
        "append": [
          {
            "value": " ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"
          }
        ]
      }
    }
  ]
}