Below is the DSL which can be used to create a table using GRAILS and liquibase. The preconditions can be used to check if the table already exists, if not then a new table is created.
databaseChangeLog = { changeSet(author: "myname", id: "123456-3") { preConditions(onFail: "MARK_RAN", onFailMessage: "table already exists") { not { tableExists(tableName: "TABLE_NAME") } } createTable(tableName: "TABLE_NAME") { column(name: "id", type: "number(19,0)") { constraints(nullable: "false", primaryKey: "true", primaryKeyName: "ABC_PK") } column(name: "COLUMN1", type: "varchar2(255)") { constraints(nullable: "true") } column(name: "COLUMN2", type: "number(19,0)") { constraints(nullable: "true") } column(name: "COLUMN3", type: "timestamp") { constraints(nullable: "false") } } } }
No comments:
Post a Comment