/* 完善通用角色的一些信息 */
UPDATE T_PERM_ROLE SET FCREATORID = 1 WHERE FCREATORID = 0;

UPDATE T_PERM_ROLE SET FCREATETIME = {ts'2018-08-08 18:08:08'} WHERE FCREATETIME IS NULL;

UPDATE T_PERM_ROLE SET FMASTERID = FID WHERE FMASTERID = ' ';

UPDATE T_PERM_ROLE SET FSTATUS = 'C' WHERE FSTATUS <> 'C';