/*
	### Required server parameters for RDS instance of MySQL 8.0.x ###
	log_bin_trust_function_creators		1
	sql_mode							NO_ENGINE_SUBSTITUTION
	group_concat_max_len				20480
	character_set_server				utf8
	collation_server					utf8_unicode_ci
*/

/* 2023-10-24 MySQL post-upgrade to 8.0.x */

ALTER TABLE manual_transactions 
	CHANGE transaction_date transaction_date DATE DEFAULT NULL,
	CHANGE issue_date issue_date DATE DEFAULT NULL;

UPDATE manual_transactions SET 
	transaction_date = NULL 
WHERE transaction_date = '0000-00-00';

UPDATE manual_transactions SET 
	issue_date = NULL 
WHERE issue_date = '0000-00-00';

ALTER TABLE invoice_master 
	CHANGE actual_date actual_date DATE DEFAULT NULL,
	CHANGE approved_date approved_date DATE DEFAULT NULL,
	CHANGE expected_date expected_date DATE DEFAULT NULL;
	
UPDATE invoice_master SET 
	actual_date = NULL 
WHERE actual_date = '0000-00-00';

UPDATE invoice_master SET 
	approved_date = NULL 
WHERE approved_date = '0000-00-00';

UPDATE invoice_master SET 
	expected_date = NULL 
WHERE expected_date = '0000-00-00';