-- ALTER TABLE mantis_bug_table DROP COLUMN date_submitted_redmine;  
-- ALTER TABLE mantis_bug_table DROP COLUMN last_updated_redmine;  
-- ALTER TABLE mantis_bugnote_table DROP COLUMN date_submitted_redmine;  
-- ALTER TABLE mantis_bug_file_table DROP COLUMN date_added_redmine;  
-- ALTER TABLE mantis_news_table DROP COLUMN date_posted_redmine;  
-- ALTER TABLE mantis_project_version_table DROP COLUMN date_order_redmine;  

ALTER TABLE mantis_bug_table ADD date_submitted_redmine timestamp;
ALTER TABLE mantis_bug_table ADD last_updated_redmine timestamp;
ALTER TABLE mantis_bugnote_table ADD date_submitted_redmine timestamp;
ALTER TABLE mantis_bug_file_table ADD date_added_redmine timestamp;
ALTER TABLE mantis_news_table ADD date_posted_redmine timestamp;
ALTER TABLE mantis_project_version_table ADD date_order_redmine timestamp;

UPDATE mantis_bug_table SET date_submitted_redmine = to_timestamp(date_submitted);
UPDATE mantis_bug_table SET last_updated_redmine = to_timestamp(last_updated);
UPDATE mantis_bugnote_table SET date_submitted_redmine = to_timestamp(date_submitted);
UPDATE mantis_bug_file_table SET date_added_redmine = to_timestamp(date_added);
UPDATE mantis_news_table SET date_posted_redmine = to_timestamp(date_posted);
UPDATE mantis_project_version_table SET date_order_redmine = to_timestamp(date_order);