updated sql testcases to new table schema