for convenience, add some other values to handle_not_migrate
authorJason Etheridge <jason@equinoxinitiative.org>
Mon, 23 Mar 2020 16:52:12 +0000 (12:52 -0400)
committerJason Etheridge <jason@equinoxinitiative.org>
Mon, 23 Mar 2020 16:52:12 +0000 (12:52 -0400)
Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

sql/base/07-eg-specific.sql

index 57e091f..c235d77 100644 (file)
@@ -1105,9 +1105,11 @@ CREATE OR REPLACE FUNCTION migration_tools.handle_not_migrate (TEXT,TEXT) RETURN
             || ' 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) = ''Delete'' THEN FALSE'
             || ' WHEN BTRIM(desired_not_migrate) = ''Do Not Migrate'' THEN FALSE'
             || ' WHEN BTRIM(desired_not_migrate) = ''FALSE'' THEN TRUE'
             || ' WHEN BTRIM(desired_not_migrate) = ''Migrate'' THEN TRUE'
+            || ' WHEN BTRIM(desired_not_migrate) = ''Keep'' THEN TRUE'
             || ' WHEN BTRIM(desired_not_migrate) = '''' THEN TRUE'
             || ' END';