database info:
RES_SM_R0402 package, pad-stack (20mil X 24mil ---0.51mm X 0.61mm), pitch 40mil (1.02mm);
RES_SM_R0603 package, pad-stack (40mil X 50mil ---1.02mm X1.27mm), pitch 72mil (1.83mm);
suggestion:
Package 0402: 0.5mm X 0.6mm, Pitch 0.9mm;
Package 0603: 0.9mm X 0.9mm, Pitch 1.5mm;
Fyi.