Issue #23507:drop column itemsite_nnqoh

diff --git a/foundation-database/public/tables/itemsite.sql b/foundation-database/public/tables/itemsite.sql
index 39c225d..6987426 100644 (file)
--- a/foundation-database/public/tables/itemsite.sql
+++ b/foundation-database/public/tables/itemsite.sql
@@ -3,7 +3,6 @@ do $$
 begin
 if fetchMetricText('ServerVersion') < '4.7.0' then
   update itemsite set itemsite_qtyonhand=(itemsite_qtyonhand + itemsite_nnqoh);
-  -- drop column itemsite_nnqoh ???
-  update itemsite set itemsite_nnqoh=0;
+  alter table itemsite drop column itemsite_nnqoh;
 end if;
 end$$;
\ No newline at end of file