/* 修复组织维护信息  */
UPDATE t_org_org set FMODIFYTIME = NOW() WHERE FMODIFYTIME IS NULL;
UPDATE t_org_org set FMODIFIERID = 1 WHERE FMODIFIERID = 0;
UPDATE t_org_org set FCREATETIME = FMODIFYTIME WHERE FCREATETIME IS NULL;
UPDATE t_org_org set FCREATORID = 1 WHERE FCREATORID = 0; 

UPDATE t_org_structure set FMODIFIERID = 1 WHERE FMODIFIERID = 0;
UPDATE t_org_structure set FMODIFYTIME = (SELECT t.FMODIFYTIME FROM t_org_org t WHERE t_org_structure.FORGID = t.FID) WHERE FMODIFYTIME IS NULL;
UPDATE t_org_structure set FCREATORID = 1 WHERE FCREATORID = 0; 
UPDATE t_org_structure set FCREATETIME = (SELECT t.FCREATETIME FROM t_org_org t WHERE t_org_structure.FORGID = t.FID) WHERE FCREATETIME IS NULL;

UPDATE t_org_structure set FMODIFYTIME = NOW() WHERE FMODIFYTIME IS NULL;
UPDATE t_org_structure set FCREATETIME = FMODIFYTIME WHERE FCREATETIME IS NULL;

/* 修复人员维护信息  */
UPDATE t_sec_user set FMODIFYTIME = NOW() WHERE FMODIFYTIME IS NULL;
UPDATE t_sec_user set FMODIFIERID = 1 WHERE FMODIFIERID = 0;
UPDATE t_sec_user set FCREATETIME = FMODIFYTIME WHERE FCREATETIME IS NULL;
UPDATE t_sec_user set FCREATORID = 1 WHERE FCREATORID = 0; 