CREATE TABLE ceulocker.email_template  (
		email_template_id INT auto_increment PRIMARY KEY,
		email_template_content Text,
		active bit,
		date_created timestamp default CURRENT_TIMESTAMP,
		created_by INT,
		created_on timestamp default CURRENT_TIMESTAMP,
		updated_by INT,
		updated_on timestamp default CURRENT_TIMESTAMP,
	)
	ENGINE=InnoDB
	DEFAULT CHARSET=utf8mb4
	COLLATE=utf8mb4_general_ci;

CREATE TABLE EmailTransactional.EmailLogs  (
		log_id INT auto_increment PRIMARY KEY,
		email_subject varchar(200),
		email_address varchar(150),
		entity_id int,
		message_type varchar(200),
		email_address_from varchar(150),
		action_type varchar(200),
		messageHtml text,
		active bit,
		invite_id varchar(100),
		date_created timestamp default CURRENT_TIMESTAMP,
		template_id int
	)
	ENGINE=InnoDB
	DEFAULT CHARSET=utf8mb4
	COLLATE=utf8mb4_general_ci;