Joomla Sample Data - Converting column data from MySQL to SQL Server

queries.sql

UPDATE `jos_banner_clients` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_banners` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_banners` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_banners` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_banners` SET `reset` = '1900-01-01 00:00:00';
UPDATE `jos_banners` SET `modified` = '1900-01-01 00:00:00';
UPDATE `jos_categories` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_categories` SET `modified_time` = '1900-01-01 00:00:00';
UPDATE `jos_contact_details` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_contact_details` SET `modified` = '1900-01-01 00:00:00';
UPDATE `jos_contact_details` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_contact_details` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_content` SET `modified` = '1900-01-01 00:00:00';
UPDATE `jos_content` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_content` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_extensions` SET `checked_out_time` = '1900-01-01 00:00:00';
ALTER TABLE `jos_menu` CHANGE `checked_out_time` `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.';
UPDATE `jos_menu` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_modules` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_modules` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_modules` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_newsfeeds` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_newsfeeds` SET `modified` = '1900-01-01 00:00:00';
UPDATE `jos_newsfeeds` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_newsfeeds` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_tags` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_tags` SET `modified_time` = '1900-01-01 00:00:00';
UPDATE `jos_tags` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_tags` SET `publish_down` = '1900-01-01 00:00:00';
UPDATE `jos_weblinks` SET `checked_out_time` = '1900-01-01 00:00:00';
UPDATE `jos_weblinks` SET `modified` = '1900-01-01 00:00:00';
UPDATE `jos_weblinks` SET `publish_up` = '1900-01-01 00:00:00';
UPDATE `jos_weblinks` SET `publish_down` = '1900-01-01 00:00:00';