Liquibase example

gistfile1.groovy

databaseChangeLog() {
    changeSet(id: "my first changeset", author: "daniel") {
        comment('A comment')
        createTable(tableName: 'my_table') {
            column(name: 'id', type: 'uuid', defaultValue: 'uuid_generate_v4()') {
                constraints(primaryKey: true, nullable: false)
            }
            column(name: 'name', type: 'character varying(100)') {
                constraints(nullable: false)
            }
            column(name: 'active', type: 'boolean') {
                constraints(nullable: false)
            }
        }
        createIndex(indexName: 'idx_name', tableName: 'my_table') {
            column(name: 'name')
        }
        rollback() {
            dropTable(tableName: 'my_table')
        }
    }