# 1.3.2

ALTER TABLE `#__docman_categories` CHANGE `locked_on` `locked_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_categories` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_categories` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;

UPDATE `#__docman_categories` SET `locked_on` = NULL WHERE `locked_on` = 0000-00-00;
UPDATE `#__docman_categories` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_categories` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;

ALTER TABLE `#__docman_documents` CHANGE `publish_on` `publish_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_documents` CHANGE `unpublish_on` `unpublish_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_documents` CHANGE `locked_on` `locked_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_documents` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_documents` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;

UPDATE `#__docman_documents` SET `publish_on` = NULL WHERE `publish_on` = 0000-00-00;
UPDATE `#__docman_documents` SET `unpublish_on` = NULL WHERE `unpublish_on` = 0000-00-00;
UPDATE `#__docman_documents` SET `locked_on` = NULL WHERE `locked_on` = 0000-00-00;
UPDATE `#__docman_documents` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_documents` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;

ALTER TABLE `#__docman_files` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_files` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;

UPDATE `#__docman_files` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_files` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;

ALTER TABLE `#__docman_folders` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_folders` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;

UPDATE `#__docman_folders` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_folders` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;

ALTER TABLE `#__docman_scans` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_scans` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_scans` CHANGE `sent_on` `sent_on` datetime DEFAULT NULL;

UPDATE `#__docman_scans` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_scans` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;
UPDATE `#__docman_scans` SET `sent_on` = NULL WHERE `sent_on` = 0000-00-00;

ALTER TABLE `#__docman_usergroups` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_usergroups` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;

UPDATE `#__docman_usergroups` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_usergroups` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;

ALTER TABLE `#__docman_tags` CHANGE `created_on` `created_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_tags` CHANGE `modified_on` `modified_on` datetime DEFAULT NULL;
ALTER TABLE `#__docman_tags` CHANGE `locked_on` `locked_on` datetime DEFAULT NULL;


UPDATE `#__docman_tags` SET `created_on` = NULL WHERE `created_on` = 0000-00-00;
UPDATE `#__docman_tags` SET `modified_on` = NULL WHERE `modified_on` = 0000-00-00;
UPDATE `#__docman_tags` SET `locked_on` = NULL WHERE `locked_on` = 0000-00-00;

