added state column to site table