CREATE TABLE news_log (
	news_id INT NOT NULL,
	edit_date TIMESTAMP,
	old_release_date date DEFAULT NULL,
	new_release_date date DEFAULT NULL,
	old_exp_date date DEFAULT NULL,
	new_exp_date date DEFAULT NULL,
	old_heading varchar(255) DEFAULT NULL,
	new_heading varchar(255) DEFAULT NULL,
	old_content varchar(255) DEFAULT NULL,
	new_content varchar(255) DEFAULT NULL,
	old_footer varchar(255) DEFAULT NULL,
	new_footer varchar(255) DEFAULT NULL,
	old_status_id tinyint,
	new_status_id tinyint,
	old_news_category_id tinyint NOT NULL,
	new_news_category_id tinyint NOT NULL,
	old_news_type_id tinyint,
	new_news_type_id tinyint,
	FOREIGN KEY (old_status_id) REFERENCES statuses (id),
	FOREIGN KEY (new_status_id) REFERENCES statuses (id),
	FOREIGN KEY (news_id) REFERENCES news (id)
) ENGINE=InnoDB;
