-- generator on mysql

select 
    concat('update ', 
        c.TABLE_NAME, 
        ' t set t.',
        c.COLUMN_NAME,
        ' = \'1990-01-01 01:02:03\' where year(t.',
        c.COLUMN_NAME,
        ') = 0;')
from INFORMATION_SCHEMA.COLUMNS c
where c.TABLE_SCHEMA = database() 
    and c.COLUMN_NAME = 'added';

-- generated on mysql
/*
update cf_AclResource t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
update cf_AclRole t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                 
update cf_AclRule t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                 
update cf_Client t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                  
update cf_Department t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;              
update cf_Form t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                    
update cf_FormElement t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
update cf_FormSubmission t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;          
update cf_Media t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                   
update cf_Part t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                    
update cf_Part2PartData t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;           
update cf_Part2ProcessData t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;        
update cf_PartVersion t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
update cf_Process t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                 
update cf_User t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                    
update cf_zz_Admin t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                
update cf_zz_DraftHtmlBlock t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;       
update cf_zz_DraftHtmlBlockContent t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;
update cf_zz_DraftPage t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;            
update cf_zz_DraftPageItem t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;        
update cf_zz_File t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                 
update cf_zz_HtmlBlock t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;            
update cf_zz_HtmlBlockContent t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;     
update cf_zz_Log t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                  
update cf_zz_NotFound t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
update cf_zz_Page t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;                 
update cf_zz_PageIndex t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;            
update cf_zz_PageItem t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
update cf_zz_Redirection t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;          
update cf_zz_Settings t set t.added = '1990-01-01 01:02:03' where year(t.added) = 0;             
*/

-- generator on mysql

select 
    concat('update ', 
        c.TABLE_NAME, 
        ' t set t.',
        c.COLUMN_NAME,
        ' = \'1990-01-01 01:02:03\' where year(t.',
        c.COLUMN_NAME,
        ') = 0;')
from INFORMATION_SCHEMA.COLUMNS c
where c.TABLE_SCHEMA = database() 
    and c.COLUMN_NAME = 'changed';

-- generated on mysql
/*
update cf_AclResource t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;             
update cf_AclRole t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                 
update cf_AclRule t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                 
update cf_Client t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                  
update cf_Department t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;              
update cf_Form t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                    
update cf_FormElement t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;             
update cf_FormSubmission t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;          
update cf_Media t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                   
update cf_Part t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                    
update cf_Part2PartData t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;           
update cf_Part2ProcessData t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;        
update cf_PartVersion t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;             
update cf_Process t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                 
update cf_User t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                    
update cf_zz_Admin t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                
update cf_zz_DraftHtmlBlockContent t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;
update cf_zz_DraftPage t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;            
update cf_zz_DraftPageItem t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;        
update cf_zz_HtmlBlockContent t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;     
update cf_zz_Page t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;                 
update cf_zz_PageIndex t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;            
update cf_zz_PageItem t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;             
update cf_zz_Redirection t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;          
update cf_zz_Settings t set t.changed = '1990-01-01 01:02:03' where year(t.changed) = 0;             
*/
