-- fixing mysql database due to incorrect timestamp handling (bug#289)
ALTER TABLE componentbean           CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE configurationbean       CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;     
ALTER TABLE customfieldbean         CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;       
ALTER TABLE customfieldvaluebean    CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;  
ALTER TABLE issueactivitybean       CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;     
ALTER TABLE issueattachmentbean     CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;   
ALTER TABLE issuebean               CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;             
ALTER TABLE issuehistorybean        CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;      
ALTER TABLE issuerelationbean       CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;     
ALTER TABLE languagebean            CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;          
ALTER TABLE notificationbean        CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;      
ALTER TABLE permissionbean          CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;        
ALTER TABLE projectbean             CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;           
ALTER TABLE projectscriptbean       CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;     
ALTER TABLE reportbean              CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;            
ALTER TABLE userbean                CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;              
ALTER TABLE userpreferencesbean     CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;   
ALTER TABLE versionbean             CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;           
ALTER TABLE workflowscriptbean      CHANGE COLUMN create_date create_date TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'  , CHANGE COLUMN last_modified last_modified TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;    