alter-cm-table.sql

set client_encoding='LATIN1';
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.AG2';
ALTER TABLE CM DROP COLUMN AG2;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.RG4';
ALTER TABLE CM DROP COLUMN RG4;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.AG4';
ALTER TABLE CM DROP COLUMN AG4;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.AG5';
ALTER TABLE CM DROP COLUMN AG5;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.AG3';
ALTER TABLE CM DROP COLUMN AG3;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.RG3';
ALTER TABLE CM DROP COLUMN RG3;
COMMIT;
BEGIN;
DELETE FROM FIELDS WHERE NAME = 'CM.RG2';
ALTER TABLE CM DROP COLUMN RG2;
COMMIT;