Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » Change to 2000-01-01 00:00:00 everywhere
Re: Change to 2000-01-01 00:00:00 everywhere [message #6315 is a reply to message #6312] Sun, 16 April 2017 06:16 Go to previous messageGo to previous message
apmuthu
Messages: 30
Registered: April 2017
Location: Chennai Singapore
Member
For those who want to do in for an existing installation here goes:
ALTER TABLE `survey`.`answer_option` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`asset_type` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`default_prompt` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`location_address` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`location_type` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`number_option` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`org_type` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`question_prompt` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`risk_status` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`risk_weighting` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_answer_dtl` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_answer_hdr` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_hdr` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_question` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_section` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`survey_type` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;
ALTER TABLE `survey`.`tree_node` CHANGE `created_date` `created_date` DATETIME DEFAULT '2000-01-01 00:00:00' NOT NULL;

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Performance Issues v1.97 - 2.0 with list screens
Next Topic: Legacy file carryover
Goto Forum:
  


Current Time: Wed May 15 07:07:23 EDT 2024

Total time taken to generate the page: 0.01379 seconds