update res_maininfo set resourcestatus = 0 where resourcestatus = 1;