added auto_increment to appointmendID in appoint and roomID is now default null