X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=8dd7f366849d6e97400adefddda687dcdfed3e2f;hp=c192a3c8c448927627c0545132698694b593fbad;hb=27e784c7cc26e9506c1f02cddead2973a5d8f6a1;hpb=9a3207573976451e12bce078decca416dc4b5c3c 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';