From 27e784c7cc26e9506c1f02cddead2973a5d8f6a1 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sun, 15 Apr 2018 15:11:56 -0400 Subject: [PATCH] alternate values for desired_not_migrate Signed-off-by: Jason Etheridge --- sql/base/base.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index c192a3c..8dd7f36 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -2928,7 +2928,9 @@ CREATE OR REPLACE FUNCTION migration_tools.handle_not_migrate (TEXT,TEXT) RETURN EXECUTE 'UPDATE ' || quote_ident(table_name) || ' a' || ' SET x_migrate = CASE' || ' WHEN BTRIM(desired_not_migrate) = ''TRUE'' THEN FALSE' + || ' WHEN BTRIM(desired_not_migrate) = ''DNM'' THEN FALSE' || ' WHEN BTRIM(desired_not_migrate) = ''FALSE'' THEN TRUE' + || ' WHEN BTRIM(desired_not_migrate) = ''Migrate'' THEN TRUE' || ' WHEN BTRIM(desired_not_migrate) = '''' THEN TRUE' || ' END'; -- 1.7.2.5