Skip to content

Instantly share code, notes, and snippets.

@mlist

mlist/addNotNullConstraint.groovy

Created June 22, 2012 15:53
Show Gist options
  • Save mlist/2973647 to your computer and use it in GitHub Desktop.
Save mlist/2973647 to your computer and use it in GitHub Desktop.
Download ZIP
changeSet for adding a not null constraint with a default value for existing nulls
Raw
addNotNullConstraint.groovy
changeSet(author: "mlist (generated)", id: "1340373645634-47") {
addNotNullConstraint(columnDataType: "bigint", columnName: "createdBy", schemaName: "dbo", tableName: "slide_layout", defaultNullValue: 1)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment