salix/db/versions/10893-limeFern/00-sage.sql

--  Auto-generated SQL script #202403061303
UPDATE vn.company
	SET companyCode=0
	WHERE id=69;
UPDATE vn.company
	SET companyCode=1
	WHERE id=442;
UPDATE vn.company
	SET companyCode=4
	WHERE id=567;
UPDATE vn.company
	SET companyCode=2
	WHERE id=791;
UPDATE vn.company
	SET companyCode=3
	WHERE id=792;
UPDATE vn.company
	SET companyCode=5
	WHERE id=965;
UPDATE vn.company
	SET companyCode=7
	WHERE id=1381;
UPDATE vn.company
	SET companyCode=3
	WHERE id=1463;
UPDATE vn.company
	SET companyCode=8
	WHERE id=2142;
UPDATE vn.company
	SET companyCode=6
	WHERE id=2393;
UPDATE vn.company
	SET companyCode=9
	WHERE id=3869;

--  Auto-generated SQL script #202403061311
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=69;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=442;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=567;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=791;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=792;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=965;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=1381;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=1463;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=2142;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=2393;
UPDATE vn.company
	SET sage200Company=NULL
	WHERE id=3869;


ALTER TABLE vn.company CHANGE sage200Company sage200Company__ int(2) DEFAULT NULL NULL COMMENT '@deprecated 06/03/2024';
ALTER TABLE vn.company MODIFY COLUMN sage200Company__ int(2) DEFAULT NULL NULL COMMENT '@deprecated 06/03/2024';