From 5094c0fef0c6bbc1df7684aba8b17ba4f3de697f Mon Sep 17 00:00:00 2001 From: wbudic Date: Sat, 13 Feb 2021 17:19:15 +1100 Subject: [PATCH] alter for pg is not workin. --- htdocs/cgi-bin/login_ctr.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi index e42d45c..2859e33 100755 --- a/htdocs/cgi-bin/login_ctr.cgi +++ b/htdocs/cgi-bin/login_ctr.cgi @@ -392,7 +392,7 @@ try{ } elsif($hasLogTbl && $SCRIPT_RELEASE > $DB_VERSION && $DB_VERSION < 2.2){ my $t ="BYTE"; $t = "SMALLINT" if Settings::isProgressDB(); - $db->do('ALTER TABLE LOG ADD COLUMN "RTF" BYTE default 0');$changed = 1; + $db->do("ALTER TABLE LOG ADD COLUMN \"RTF\" $t default 0");$changed = 1; } elsif($SCRIPT_RELEASE > $DB_VERSION){$changed = 1;} -- 2.34.1