schema updated for newshifts