Skip to content

Instantly share code, notes, and snippets.

@gabidavila
Last active Feb 14, 2017
Embed
What would you like to do?
{
"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"
}
]
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment