ALTER TABLE #__zhosmmaps_maps MODIFY `params` text;
ALTER TABLE #__zhosmmaps_markers MODIFY `params` text;
ALTER TABLE #__zhosmmaps_routers MODIFY `params` text;
ALTER TABLE #__zhosmmaps_paths MODIFY `params` text;
ALTER TABLE #__zhosmmaps_markergroups MODIFY `params` text;
ALTER TABLE #__zhosmmaps_maptypes MODIFY `params` text;
ALTER TABLE #__zhosmmaps_infobubbles MODIFY `params` text;
ALTER TABLE #__zhosmmaps_marker_rates MODIFY `params` text;
ALTER TABLE #__zhosmmaps_text_overrides MODIFY `params` text;
ALTER TABLE #__zhosmmaps_marker_content MODIFY `params` text;
ALTER TABLE #__zhosmmaps_log MODIFY `params` text;
ALTER TABLE #__zhosmmaps_marker_buffer MODIFY `params` text;
ALTER TABLE #__zhosmmaps_data_sqls MODIFY `params` text;
ALTER TABLE #__zhosmmaps_visual_structs MODIFY `params` text;
ALTER TABLE #__zhosmmaps_data_servers MODIFY `params` text;

ALTER TABLE #__zhosmmaps_markers MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_markers MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_routers MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_routers MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_paths MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_paths MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_markergroups MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_markergroups MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_maptypes MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_maptypes MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_infobubbles MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_infobubbles MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_text_overrides MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_text_overrides MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_marker_content MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_marker_content MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_log MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_log MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_marker_buffer MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_marker_buffer MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_data_sqls MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_data_sqls MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_visual_structs MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_visual_structs MODIFY `publish_down` DATETIME;
ALTER TABLE #__zhosmmaps_data_servers MODIFY `publish_up` DATETIME;
ALTER TABLE #__zhosmmaps_data_servers MODIFY `publish_down` DATETIME;

ALTER TABLE #__zhosmmaps_markers MODIFY `createddate` DATETIME;
ALTER TABLE #__zhosmmaps_marker_buffer MODIFY `createddate` DATETIME;

ALTER TABLE #__zhosmmaps_marker_rates MODIFY `rating_date` DATETIME;
