Below code shows how to add a new column in an already existing table using GRAILS and liquibase
databaseChangeLog = {
changeSet(author: "myname", id: "123456-1") {
addColumn(tableName: "TABLE_NAME") {
column(name: "NEW_DATE_COLUMN", type: "TIMESTAMP(6)",defaultValueDate: "2013-01-01") {
constraints(nullable: "false")
}
}
}
changeSet(author: "myname", id: "123456-2") {
addColumn(tableName: "TABLE_NAME") {
column(name: "COLUMN_NAME", type: "VARCHAR2(1020 BYTE)")
}
}
}
No comments:
Post a Comment