Commit574f52d

committed

Add migration script

1 parent03652a7 commit574f52dCopy full SHA for 574f52d

File tree

+606

-5

lines changed

+606

-5

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -41,12 +41,12 @@ CREATE TABLE IF NOT EXISTS @extschema@.pathman_config (`
`41`	`41`	`upd_exprBOOL DEFAULT FALSE,/* update expression on next refresh?*/`
`42`	`42`
`43`	`43`	`/* check for allowed part types*/`
`44`		`-CHECK (parttypeIN (1,2)),`
	`44`	`+CONSTRAINT pathman_config_parttype_checkCHECK (parttypeIN (1,2)),`
`45`	`45`
`46`	`46`	`/* check for correct interval*/`
`47`		`-CHECK (@extschema@.validate_interval_value(atttype,`
`48`		`-parttype,`
`49`		`-range_interval))`
	`47`	`+CONSTRAINT pathman_config_interval_checkCHECK (@extschema@.validate_interval_value(atttype,`
	`48`	`+parttype,`
	`49`	`+range_interval))`
`50`	`50`	`);`
`51`	`51`
`52`	`52`

Comments

(0)