INSERT INTO `cities` (`city_id`, `city`, `state_code`, `status`) VALUES
(28443, 'West Lebanon', 'NY', 1),
(28444, 'West Lebanon', 'PA', 1),
(28445, 'West Leisenring', 'PA', 1),
(28446, 'West Leyden', 'NY', 1),
(28447, 'West Liberty', 'IA', 1),
(28448, 'West Liberty', 'IL', 1),
(28449, 'West Liberty', 'KY', 1),
(28450, 'West Liberty', 'OH', 1),
(28451, 'West Liberty', 'WV', 1),
(28452, 'West Linn', 'OR', 1),
(28453, 'West Long Branch', 'NJ', 1),
(28454, 'West Louisville', 'KY', 1),
(28455, 'West Manchester', 'OH', 1),
(28456, 'West Mansfield', 'OH', 1),
(28457, 'West Mclean', 'VA', 1),
(28458, 'West Medford', 'MA', 1),
(28459, 'West Memphis', 'AR', 1),
(28460, 'West Middlesex', 'PA', 1),
(28461, 'West Middleton', 'IN', 1),
(28462, 'West Middletown', 'PA', 1),
(28463, 'West Mifflin', 'PA', 1),
(28464, 'West Milford', 'NJ', 1),
(28465, 'West Milford', 'WV', 1),
(28466, 'West Millbury', 'MA', 1),
(28467, 'West Millgrove', 'OH', 1),
(28468, 'West Milton', 'OH', 1),
(28469, 'West Milton', 'PA', 1),
(28470, 'West Mineral', 'KS', 1),
(28471, 'West Minot', 'ME', 1),
(28472, 'West Monroe', 'LA', 1),
(28473, 'West Monroe', 'NY', 1),
(28474, 'West Mystic', 'CT', 1),
(28475, 'West New York', 'NJ', 1),
(28476, 'West Newbury', 'MA', 1),
(28477, 'West Newbury', 'VT', 1),
(28478, 'West Newfield', 'ME', 1),
(28479, 'West Newton', 'IN', 1),
(28480, 'West Newton', 'MA', 1),
(28481, 'West Newton', 'PA', 1),
(28482, 'West Nottingham', 'NH', 1),
(28483, 'West Nyack', 'NY', 1),
(28484, 'West Olive', 'MI', 1),
(28485, 'West Oneonta', 'NY', 1),
(28486, 'West Orange', 'NJ', 1),
(28487, 'West Ossipee', 'NH', 1),
(28488, 'West Paducah', 'KY', 1),
(28489, 'West Palm Beach', 'FL', 1),
(28490, 'West Paris', 'ME', 1),
(28491, 'West Park', 'NY', 1),
(28492, 'West Pawlet', 'VT', 1),
(28493, 'West Peterborough', 'NH', 1),
(28494, 'West Pittsburg', 'PA', 1),
(28495, 'West Plains', 'MO', 1),
(28496, 'West Point', 'AR', 1),
(28497, 'West Point', 'CA', 1),
(28498, 'West Point', 'GA', 1),
(28499, 'West Point', 'IA', 1),
(28500, 'West Point', 'IL', 1),
(28501, 'West Point', 'KY', 1),
(28502, 'West Point', 'MS', 1),
(28503, 'West Point', 'NE', 1),
(28504, 'West Point', 'NY', 1),
(28505, 'West Point', 'OH', 1),
(28506, 'West Point', 'PA', 1),
(28507, 'West Point', 'TX', 1),
(28508, 'West Point', 'VA', 1),
(28509, 'West Poland', 'ME', 1),
(28510, 'West Portsmouth', 'OH', 1),
(28511, 'West Richland', 'WA', 1),
(28512, 'West Ridge', 'AR', 1),
(28513, 'West River', 'MD', 1),
(28514, 'West Rockport', 'ME', 1),
(28515, 'West Roxbury', 'MA', 1),
(28516, 'West Rupert', 'VT', 1),
(28517, 'West Rushville', 'OH', 1),
(28518, 'West Rutland', 'VT', 1),
(28519, 'West Sacramento', 'CA', 1),
(28520, 'West Salem', 'IL', 1),
(28521, 'West Salem', 'OH', 1),
(28522, 'West Salem', 'WI', 1),
(28523, 'West Salisbury', 'PA', 1),
(28524, 'West Sand Lake', 'NY', 1),
(28525, 'West Sayville', 'NY', 1),
(28526, 'West Shokan', 'NY', 1),
(28527, 'West Simsbury', 'CT', 1),
(28528, 'West Somerset', 'KY', 1),
(28529, 'West Springfield', 'MA', 1),
(28530, 'West Springfield', 'PA', 1),
(28531, 'West Stewartstown', 'NH', 1),
(28532, 'West Stockbridge', 'MA', 1),
(28533, 'West Stockholm', 'NY', 1),
(28534, 'West Suffield', 'CT', 1),
(28535, 'West Sunbury', 'PA', 1),
(28536, 'West Swanzey', 'NH', 1),
(28537, 'West Terre Haute', 'IN', 1),
(28538, 'West Tisbury', 'MA', 1),
(28539, 'West Topsham', 'VT', 1),
(28540, 'West Townsend', 'MA', 1),
(28541, 'West Townshend', 'VT', 1),
(28542, 'West Union', 'IA', 1),
(28543, 'West Union', 'IL', 1),
(28544, 'West Union', 'MN', 1),
(28545, 'West Union', 'OH', 1),
(28546, 'West Union', 'SC', 1),
(28547, 'West Union', 'WV', 1),
(28548, 'West Unity', 'OH', 1),
(28549, 'West Valley', 'NY', 1),
(28550, 'West Van Lear', 'KY', 1),
(28551, 'West Wardsboro', 'VT', 1),
(28552, 'West Wareham', 'MA', 1),
(28553, 'West Warren', 'MA', 1),
(28554, 'West Warwick', 'RI', 1),
(28555, 'West Wendover', 'NV', 1),
(28556, 'West Willow', 'PA', 1),
(28557, 'West Windsor', 'NJ', 1),
(28558, 'West Winfield', 'NY', 1),
(28559, 'West Yarmouth', 'MA', 1),
(28560, 'West Yellowstone', 'MT', 1),
(28561, 'West York', 'IL', 1),
(28562, 'Westboro', 'MO', 1),
(28563, 'Westboro', 'WI', 1),
(28564, 'Westborough', 'MA', 1),
(28565, 'Westbrook', 'CT', 1),
(28566, 'Westbrook', 'ME', 1),
(28567, 'Westbrook', 'MN', 1),
(28568, 'Westbrook', 'TX', 1),
(28569, 'Westbrookville', 'NY', 1),
(28570, 'Westbury', 'NY', 1),
(28571, 'Westby', 'MT', 1),
(28572, 'Westby', 'WI', 1),
(28573, 'Westchester', 'IL', 1),
(28574, 'Westcliffe', 'CO', 1),
(28575, 'Westdale', 'NY', 1),
(28576, 'Westerlo', 'NY', 1),
(28577, 'Westerly', 'RI', 1),
(28578, 'Western', 'NE', 1),
(28579, 'Western Grove', 'AR', 1),
(28580, 'Western Springs', 'IL', 1),
(28581, 'Westernport', 'MD', 1),
(28582, 'Westernville', 'NY', 1),
(28583, 'Westerville', 'NE', 1),
(28584, 'Westerville', 'OH', 1),
(28585, 'Westfall', 'OR', 1),
(28586, 'Westfield', 'IA', 1),
(28587, 'Westfield', 'IL', 1),
(28588, 'Westfield', 'IN', 1),
(28589, 'Westfield', 'MA', 1),
(28590, 'Westfield', 'ME', 1),
(28591, 'Westfield', 'NC', 1),
(28592, 'Westfield', 'NJ', 1),
(28593, 'Westfield', 'NY', 1),
(28594, 'Westfield', 'PA', 1),
(28595, 'Westfield', 'VT', 1),
(28596, 'Westfield', 'WI', 1),
(28597, 'Westfield Center', 'OH', 1),
(28598, 'Westfir', 'OR', 1),
(28599, 'Westford', 'MA', 1),
(28600, 'Westford', 'NY', 1),
(28601, 'Westford', 'VT', 1),
(28602, 'Westgate', 'IA', 1),
(28603, 'Westhampton', 'NY', 1),
(28604, 'Westhampton Beach', 'NY', 1),
(28605, 'Westhoff', 'TX', 1),
(28606, 'Westhope', 'ND', 1),
(28607, 'Westlake', 'LA', 1),
(28608, 'Westlake', 'OH', 1),
(28609, 'Westlake', 'OR', 1),
(28610, 'Westlake Village', 'CA', 1),
(28611, 'Westland', 'MI', 1),
(28612, 'Westland', 'PA', 1),
(28613, 'Westley', 'CA', 1),
(28614, 'Westminster', 'CA', 1),
(28615, 'Westminster', 'CO', 1),
(28616, 'Westminster', 'MA', 1),
(28617, 'Westminster', 'MD', 1),
(28618, 'Westminster', 'SC', 1),
(28619, 'Westminster', 'TX', 1),
(28620, 'Westminster', 'VT', 1),
(28621, 'Westminster Station', 'VT', 1),
(28622, 'Westmont', 'IL', 1),
(28623, 'Westmoreland', 'KS', 1),
(28624, 'Westmoreland', 'NH', 1),
(28625, 'Westmoreland', 'NY', 1),
(28626, 'Westmoreland', 'TN', 1),
(28627, 'Westmoreland City', 'PA', 1),
(28628, 'Westmorland', 'CA', 1),
(28629, 'Weston', 'CO', 1),
(28630, 'Weston', 'CT', 1),
(28631, 'Weston', 'GA', 1),
(28632, 'Weston', 'ID', 1),
(28633, 'Weston', 'MA', 1),
(28634, 'Weston', 'MI', 1),
(28635, 'Weston', 'MO', 1),
(28636, 'Weston', 'NE', 1),
(28637, 'Weston', 'OH', 1),
(28638, 'Weston', 'OR', 1),
(28639, 'Weston', 'PA', 1),
(28640, 'Weston', 'TX', 1),
(28641, 'Weston', 'VT', 1),
(28642, 'Weston', 'WV', 1),
(28643, 'Weston', 'WY', 1),
(28644, 'Westons Mills', 'NY', 1),
(28645, 'Westover', 'AL', 1),
(28646, 'Westover', 'MD', 1),
(28647, 'Westover', 'PA', 1),
(28648, 'Westphalia', 'IA', 1),
(28649, 'Westphalia', 'IN', 1),
(28650, 'Westphalia', 'KS', 1),
(28651, 'Westphalia', 'MI', 1),
(28652, 'Westphalia', 'MO', 1),
(28653, 'Westpoint', 'IN', 1),
(28654, 'Westpoint', 'TN', 1),
(28655, 'Westport', 'CA', 1),
(28656, 'Westport', 'CT', 1),
(28657, 'Westport', 'IN', 1),
(28658, 'Westport', 'KY', 1),
(28659, 'Westport', 'MA', 1),
(28660, 'Westport', 'NY', 1),
(28661, 'Westport', 'PA', 1),
(28662, 'Westport', 'SD', 1),
(28663, 'Westport', 'TN', 1),
(28664, 'Westport', 'WA', 1),
(28665, 'Westport Point', 'MA', 1),
(28666, 'Westside', 'IA', 1),
(28667, 'Westtown', 'NY', 1),
(28668, 'Westtown', 'PA', 1),
(28669, 'Westview', 'KY', 1),
(28670, 'Westville', 'FL', 1),
(28671, 'Westville', 'IL', 1),
(28672, 'Westville', 'IN', 1),
(28673, 'Westville', 'NJ', 1),
(28674, 'Westville', 'OH', 1),
(28675, 'Westville', 'OK', 1),
(28676, 'Westville', 'SC', 1),
(28677, 'Westwego', 'LA', 1),
(28678, 'Westwood', 'CA', 1),
(28679, 'Westwood', 'MA', 1),
(28680, 'Westwood', 'NJ', 1),
(28681, 'Wethersfield', 'CT', 1),
(28682, 'Wetmore', 'CO', 1),
(28683, 'Wetmore', 'KS', 1),
(28684, 'Wetmore', 'MI', 1),
(28685, 'Wetumka', 'OK', 1),
(28686, 'Wetumpka', 'AL', 1),
(28687, 'Wever', 'IA', 1),
(28688, 'Wevertown', 'NY', 1),
(28689, 'Wewahitchka', 'FL', 1),
(28690, 'Wewoka', 'OK', 1),
(28691, 'Wexford', 'PA', 1),
(28692, 'Weyanoke', 'LA', 1),
(28693, 'Weyauwega', 'WI', 1),
(28694, 'Weyerhaeuser', 'WI', 1),
(28695, 'Weyers Cave', 'VA', 1),
(28696, 'Weymouth', 'MA', 1),
(28697, 'Whaleyville', 'MD', 1),
(28698, 'Wharncliffe', 'WV', 1),
(28699, 'Wharton', 'NJ', 1),
(28700, 'Wharton', 'OH', 1),
(28701, 'Wharton', 'TX', 1),
(28702, 'Wharton', 'WV', 1),
(28703, 'What Cheer', 'IA', 1),
(28704, 'Whately', 'MA', 1),
(28705, 'Whatley', 'AL', 1),
(28706, 'Wheat Ridge', 'CO', 1),
(28707, 'Wheatcroft', 'KY', 1),
(28708, 'Wheatfield', 'IN', 1),
(28709, 'Wheatland', 'CA', 1),
(28710, 'Wheatland', 'IA', 1),
(28711, 'Wheatland', 'IN', 1),
(28712, 'Wheatland', 'MO', 1),
(28713, 'Wheatland', 'ND', 1),
(28714, 'Wheatland', 'OK', 1),
(28715, 'Wheatland', 'PA', 1),
(28716, 'Wheatland', 'WY', 1),
(28717, 'Wheatley', 'AR', 1),
(28718, 'Wheaton', 'IL', 1),
(28719, 'Wheaton', 'MN', 1),
(28720, 'Wheaton', 'MO', 1),
(28721, 'Wheeler', 'IL', 1),
(28722, 'Wheeler', 'IN', 1),
(28723, 'Wheeler', 'MI', 1),
(28724, 'Wheeler', 'MS', 1),
(28725, 'Wheeler', 'OR', 1),
(28726, 'Wheeler', 'TX', 1),
(28727, 'Wheeler', 'WI', 1),
(28728, 'Wheeler Army Airfield', 'HI', 1),
(28729, 'Wheelersburg', 'OH', 1),
(28730, 'Wheeling', 'IL', 1),
(28731, 'Wheeling', 'MO', 1),
(28732, 'Wheeling', 'WV', 1),
(28733, 'Wheelock', 'TX', 1),
(28734, 'Wheelwright', 'KY', 1),
(28735, 'Wheelwright', 'MA', 1),
(28736, 'Whelen Springs', 'AR', 1),
(28737, 'Whick', 'KY', 1),
(28738, 'Whigham', 'GA', 1),
(28739, 'Whippany', 'NJ', 1),
(28740, 'Whipple', 'OH', 1),
(28741, 'Whippleville', 'NY', 1),
(28742, 'Whiskeytown', 'CA', 1),
(28743, 'Whitakers', 'NC', 1),
(28744, 'White', 'GA', 1),
(28745, 'White', 'PA', 1),
(28746, 'White', 'SD', 1),
(28747, 'White Bird', 'ID', 1),
(28748, 'White Bluff', 'TN', 1),
(28749, 'White Castle', 'LA', 1),
(28750, 'White City', 'KS', 1),
(28751, 'White City', 'OR', 1),
(28752, 'White Cloud', 'KS', 1),
(28753, 'White Cloud', 'MI', 1),
(28754, 'White Cottage', 'OH', 1),
(28755, 'White Deer', 'PA', 1),
(28756, 'White Deer', 'TX', 1),
(28757, 'White Earth', 'MN', 1),
(28758, 'White Earth', 'ND', 1),
(28759, 'White Hall', 'AR', 1),
(28760, 'White Hall', 'IL', 1),
(28761, 'White Hall', 'MD', 1),
(28762, 'White Hall', 'VA', 1),
(28763, 'White Haven', 'PA', 1),
(28764, 'White Heath', 'IL', 1),
(28765, 'White Horse Beach', 'MA', 1),
(28766, 'White House', 'TN', 1),
(28767, 'White Lake', 'MI', 1),
(28768, 'White Lake', 'NY', 1),
(28769, 'White Lake', 'SD', 1),
(28770, 'White Lake', 'WI', 1),
(28771, 'White Marsh', 'MD', 1),
(28772, 'White Marsh', 'VA', 1),
(28773, 'White Mills', 'KY', 1),
(28774, 'White Mills', 'PA', 1),
(28775, 'White Mountain', 'AK', 1),
(28776, 'White Mountain Lake', 'AZ', 1),
(28777, 'White Oak', 'GA', 1),
(28778, 'White Oak', 'NC', 1),
(28779, 'White Oak', 'TX', 1),
(28780, 'White Oak', 'WV', 1),
(28781, 'White Owl', 'SD', 1),
(28782, 'White Pigeon', 'MI', 1),
(28783, 'White Pine', 'MI', 1),
(28784, 'White Pine', 'TN', 1),
(28785, 'White Plains', 'GA', 1),
(28786, 'White Plains', 'KY', 1),
(28787, 'White Plains', 'MD', 1),
(28788, 'White Plains', 'NC', 1),
(28789, 'White Plains', 'NY', 1),
(28790, 'White Plains', 'VA', 1),
(28791, 'White Post', 'VA', 1),
(28792, 'White River', 'SD', 1),
(28793, 'White River Junction', 'VT', 1),
(28794, 'White Rock', 'SC', 1),
(28795, 'White Salmon', 'WA', 1),
(28796, 'White Sands Missile Range', 'NM', 1),
(28797, 'White Springs', 'FL', 1),
(28798, 'White Stone', 'SC', 1),
(28799, 'White Stone', 'VA', 1),
(28800, 'White Sulphur Springs', 'MT', 1),
(28801, 'White Sulphur Springs', 'NY', 1),
(28802, 'White Sulphur Springs', 'WV', 1),
(28803, 'White Swan', 'WA', 1),
(28804, 'White Water', 'CA', 1),
(28805, 'Whiteclay', 'NE', 1),
(28806, 'Whiteface', 'TX', 1),
(28807, 'Whitefield', 'ME', 1),
(28808, 'Whitefield', 'NH', 1),
(28809, 'Whitefield', 'OK', 1),
(28810, 'Whitefish', 'MT', 1),
(28811, 'Whiteford', 'MD', 1),
(28812, 'Whitehall', 'MI', 1),
(28813, 'Whitehall', 'MT', 1),
(28814, 'Whitehall', 'NY', 1),
(28815, 'Whitehall', 'PA', 1),
(28816, 'Whitehall', 'WI', 1),
(28817, 'Whitehorse', 'SD', 1),
(28818, 'Whitehouse', 'NJ', 1),
(28819, 'Whitehouse', 'OH', 1),
(28820, 'Whitehouse', 'TX', 1),
(28821, 'Whitehouse Station', 'NJ', 1),
(28822, 'Whiteland', 'IN', 1),
(28823, 'Whitelaw', 'WI', 1),
(28824, 'Whiteman Air Force Base', 'MO', 1),
(28825, 'Whiteoak', 'MO', 1),
(28826, 'Whiteriver', 'AZ', 1),
(28827, 'Whiterocks', 'UT', 1),
(28828, 'Whites City', 'NM', 1),
(28829, 'Whites Creek', 'TN', 1),
(28830, 'Whitesboro', 'NJ', 1),
(28831, 'Whitesboro', 'NY', 1),
(28832, 'Whitesboro', 'OK', 1),
(28833, 'Whitesboro', 'TX', 1),
(28834, 'Whitesburg', 'GA', 1),
(28835, 'Whitesburg', 'KY', 1),
(28836, 'Whitesburg', 'TN', 1),
(28837, 'Whiteside', 'MO', 1),
(28838, 'Whiteside', 'TN', 1),
(28839, 'Whitestone', 'NY', 1),
(28840, 'Whitestown', 'IN', 1),
(28841, 'Whitesville', 'KY', 1),
(28842, 'Whitesville', 'NY', 1),
(28843, 'Whitesville', 'WV', 1),
(28844, 'Whitetail', 'MT', 1),
(28845, 'Whitethorn', 'CA', 1),
(28846, 'Whitetop', 'VA', 1),
(28847, 'Whiteville', 'NC', 1),
(28848, 'Whiteville', 'TN', 1),
(28849, 'Whitewater', 'CO', 1),
(28850, 'Whitewater', 'KS', 1),
(28851, 'Whitewater', 'MO', 1),
(28852, 'Whitewater', 'MT', 1),
(28853, 'Whitewater', 'WI', 1),
(28854, 'Whitewood', 'SD', 1),
(28855, 'Whitewood', 'VA', 1),
(28856, 'Whitewright', 'TX', 1),
(28857, 'Whitfield', 'MS', 1),
(28858, 'Whitharral', 'TX', 1),
(28859, 'Whiting', 'IA', 1),
(28860, 'Whiting', 'IN', 1),
(28861, 'Whiting', 'KS', 1),
(28862, 'Whiting', 'ME', 1),
(28863, 'Whiting', 'VT', 1),
(28864, 'Whitingham', 'VT', 1),
(28865, 'Whitinsville', 'MA', 1),
(28866, 'Whitlash', 'MT', 1),
(28867, 'Whitley City', 'KY', 1),
(28868, 'Whitleyville', 'TN', 1),
(28869, 'Whitman', 'MA', 1),
(28870, 'Whitman', 'NE', 1),
(28871, 'Whitman', 'WV', 1),
(28872, 'Whitmer', 'WV', 1),
(28873, 'Whitmire', 'SC', 1),
(28874, 'Whitmore', 'CA', 1),
(28875, 'Whitmore Lake', 'MI', 1),
(28876, 'Whitney', 'NE', 1),
(28877, 'Whitney', 'PA', 1),
(28878, 'Whitney', 'TX', 1),
(28879, 'Whitney Point', 'NY', 1),
(28880, 'Whitsett', 'NC', 1),
(28881, 'Whitsett', 'TX', 1),
(28882, 'Whitt', 'TX', 1),
(28883, 'Whittaker', 'MI', 1),
(28884, 'Whittemore', 'IA', 1),
(28885, 'Whittemore', 'MI', 1),
(28886, 'Whitten', 'IA', 1),
(28887, 'Whittier', 'AK', 1),
(28888, 'Whittier', 'CA', 1),
(28889, 'Whittier', 'NC', 1),
(28890, 'Whittington', 'IL', 1),
(28891, 'Whitwell', 'TN', 1),
(28892, 'Wibaux', 'MT', 1),
(28893, 'Wichita', 'KS', 1),
(28894, 'Wichita Falls', 'TX', 1),
(28895, 'Wickatunk', 'NJ', 1),
(28896, 'Wickenburg', 'AZ', 1),
(28897, 'Wickes', 'AR', 1),
(28898, 'Wickett', 'TX', 1),
(28899, 'Wickhaven', 'PA', 1),
(28900, 'Wickliffe', 'KY', 1),
(28901, 'Wickliffe', 'OH', 1),
(28902, 'Wicomico', 'VA', 1),
(28903, 'Wicomico Church', 'VA', 1),
(28904, 'Wiconisco', 'PA', 1),
(28905, 'Wideman', 'AR', 1),
(28906, 'Widen', 'WV', 1),
(28907, 'Widener', 'AR', 1),
(28908, 'Widnoon', 'PA', 1),
(28909, 'Wiergate', 'TX', 1),
(28910, 'Wiggins', 'CO', 1),
(28911, 'Wiggins', 'MS', 1),
(28912, 'Wikieup', 'AZ', 1),
(28913, 'Wilber', 'NE', 1),
(28914, 'Wilberforce', 'OH', 1),
(28915, 'Wilbraham', 'MA', 1),
(28916, 'Wilbur', 'OR', 1),
(28917, 'Wilbur', 'WA', 1),
(28918, 'Wilburn', 'AR', 1),
(28919, 'Wilburton', 'OK', 1),
(28920, 'Wilburton', 'PA', 1),
(28921, 'Wilcoe', 'WV', 1),
(28922, 'Wilcox', 'NE', 1),
(28923, 'Wilcox', 'PA', 1),
(28924, 'Wild Horse', 'CO', 1),
(28925, 'Wild Rose', 'WI', 1),
(28926, 'Wilder', 'ID', 1),
(28927, 'Wilder', 'TN', 1),
(28928, 'Wilder', 'VT', 1),
(28929, 'Wildersville', 'TN', 1),
(28930, 'Wilderville', 'OR', 1),
(28931, 'Wildie', 'KY', 1),
(28932, 'Wildomar', 'CA', 1),
(28933, 'Wildorado', 'TX', 1),
(28934, 'Wildrose', 'ND', 1),
(28935, 'Wildsville', 'LA', 1),
(28936, 'Wildwood', 'FL', 1),
(28937, 'Wildwood', 'GA', 1),
(28938, 'Wildwood', 'NJ', 1),
(28939, 'Wildwood', 'PA', 1),
(28940, 'Wiley', 'CO', 1),
(28941, 'Wiley', 'GA', 1),
(28942, 'Wiley Ford', 'WV', 1),
(28943, 'Wileyville', 'WV', 1),
(28944, 'Wilkes Barre', 'PA', 1),
(28945, 'Wilkesboro', 'NC', 1),
(28946, 'Wilkeson', 'WA', 1),
(28947, 'Wilkesville', 'OH', 1),
(28948, 'Wilkinson', 'IN', 1),
(28949, 'Wilkinson', 'WV', 1),
(28950, 'Willacoochee', 'GA', 1),
(28951, 'Willamina', 'OR', 1),
(28952, 'Willard', 'KY', 1),
(28953, 'Willard', 'MO', 1),
(28954, 'Willard', 'MT', 1),
(28955, 'Willard', 'NC', 1),
(28956, 'Willard', 'NM', 1),
(28957, 'Willard', 'NY', 1),
(28958, 'Willard', 'OH', 1),
(28959, 'Willard', 'UT', 1),
(28960, 'Willard', 'WI', 1),
(28961, 'Willards', 'MD', 1),
(28962, 'Willcox', 'AZ', 1),
(28963, 'Willernie', 'MN', 1),
(28964, 'Willet', 'NY', 1),
(28965, 'Williams', 'AZ', 1),
(28966, 'Williams', 'CA', 1),
(28967, 'Williams', 'IA', 1),
(28968, 'Williams', 'IN', 1),
(28969, 'Williams', 'MN', 1),
(28970, 'Williams', 'OR', 1),
(28971, 'Williams', 'SC', 1),
(28972, 'Williams Bay', 'WI', 1),
(28973, 'Williamsburg', 'IA', 1),
(28974, 'Williamsburg', 'IN', 1),
(28975, 'Williamsburg', 'KS', 1),
(28976, 'Williamsburg', 'KY', 1),
(28977, 'Williamsburg', 'MA', 1),
(28978, 'Williamsburg', 'MI', 1),
(28979, 'Williamsburg', 'MO', 1),
(28980, 'Williamsburg', 'NM', 1),
(28981, 'Williamsburg', 'OH', 1),
(28982, 'Williamsburg', 'PA', 1),
(28983, 'Williamsburg', 'VA', 1),
(28984, 'Williamsburg', 'WV', 1),
(28985, 'Williamsfield', 'IL', 1),
(28986, 'Williamsfield', 'OH', 1),
(28987, 'Williamson', 'GA', 1),
(28988, 'Williamson', 'IA', 1),
(28989, 'Williamson', 'NY', 1),
(28990, 'Williamson', 'PA', 1),
(28991, 'Williamson', 'WV', 1),
(28992, 'Williamsport', 'IN', 1),
(28993, 'Williamsport', 'KY', 1),
(28994, 'Williamsport', 'MD', 1),
(28995, 'Williamsport', 'OH', 1),
(28996, 'Williamsport', 'PA', 1),
(28997, 'Williamsport', 'TN', 1),
(28998, 'Williamston', 'MI', 1),
(28999, 'Williamston', 'NC', 1),
(29000, 'Williamston', 'SC', 1),
(29001, 'Williamstown', 'KY', 1),
(29002, 'Williamstown', 'MA', 1),
(29003, 'Williamstown', 'MO', 1),
(29004, 'Williamstown', 'NJ', 1),
(29005, 'Williamstown', 'NY', 1),
(29006, 'Williamstown', 'OH', 1),
(29007, 'Williamstown', 'PA', 1),
(29008, 'Williamstown', 'VT', 1),
(29009, 'Williamstown', 'WV', 1),
(29010, 'Williamsville', 'IL', 1),
(29011, 'Williamsville', 'MO', 1),
(29012, 'Williamsville', 'VA', 1),
(29013, 'Williamsville', 'VT', 1),
(29014, 'Williford', 'AR', 1),
(29015, 'Willimantic', 'CT', 1),
(29016, 'Willingboro', 'NJ', 1),
(29017, 'Willington', 'CT', 1),
(29018, 'Willis', 'MI', 1),
(29019, 'Willis', 'TX', 1),
(29020, 'Willis', 'VA', 1),
(29021, 'Willis Wharf', 'VA', 1),
(29022, 'Willisburg', 'KY', 1),
(29023, 'Williston', 'FL', 1),
(29024, 'Williston', 'NC', 1),
(29025, 'Williston', 'ND', 1),
(29026, 'Williston', 'OH', 1),
(29027, 'Williston', 'SC', 1),
(29028, 'Williston', 'TN', 1),
(29029, 'Williston', 'VT', 1),
(29030, 'Williston Park', 'NY', 1),
(29031, 'Willisville', 'AR', 1),
(29032, 'Willisville', 'IL', 1),
(29033, 'Willits', 'CA', 1),
(29034, 'Willmar', 'MN', 1),
(29035, 'Willoughby', 'OH', 1),
(29036, 'Willow', 'AK', 1),
(29037, 'Willow', 'NY', 1),
(29038, 'Willow', 'OK', 1),
(29039, 'Willow Beach', 'AZ', 1),
(29040, 'Willow City', 'ND', 1),
(29041, 'Willow City', 'TX', 1),
(29042, 'Willow Creek', 'CA', 1),
(29043, 'Willow Creek', 'MT', 1),
(29044, 'Willow Grove', 'PA', 1),
(29045, 'Willow Hill', 'IL', 1),
(29046, 'Willow Hill', 'PA', 1),
(29047, 'Willow Island', 'NE', 1),
(29048, 'Willow Lake', 'SD', 1),
(29049, 'Willow River', 'MN', 1),
(29050, 'Willow Spring', 'NC', 1),
(29051, 'Willow Springs', 'IL', 1),
(29052, 'Willow Springs', 'MO', 1),
(29053, 'Willow Street', 'PA', 1),
(29054, 'Willow Wood', 'OH', 1),
(29055, 'Willowbrook', 'IL', 1),
(29056, 'Willows', 'CA', 1),
(29057, 'Wills Point', 'TX', 1),
(29058, 'Willsboro', 'NY', 1),
(29059, 'Willseyville', 'NY', 1),
(29060, 'Willshire', 'OH', 1),
(29061, 'Wilmar', 'AR', 1),
(29062, 'Wilmer', 'AL', 1),
(29063, 'Wilmer', 'TX', 1),
(29064, 'Wilmerding', 'PA', 1),
(29065, 'Wilmette', 'IL', 1),
(29066, 'Wilmington', 'CA', 1),
(29067, 'Wilmington', 'DE', 1),
(29068, 'Wilmington', 'IL', 1),
(29069, 'Wilmington', 'MA', 1),
(29070, 'Wilmington', 'NC', 1),
(29071, 'Wilmington', 'NY', 1),
(29072, 'Wilmington', 'OH', 1),
(29073, 'Wilmington', 'VT', 1),
(29074, 'Wilmont', 'MN', 1),
(29075, 'Wilmore', 'KS', 1),
(29076, 'Wilmore', 'KY', 1),
(29077, 'Wilmore', 'PA', 1),
(29078, 'Wilmot', 'AR', 1),
(29079, 'Wilmot', 'NH', 1),
(29080, 'Wilmot', 'OH', 1),
(29081, 'Wilmot', 'SD', 1),
(29082, 'Wilmot', 'WI', 1),
(29083, 'Wilsall', 'MT', 1),
(29084, 'Wilsey', 'KS', 1),
(29085, 'Wilseyville', 'CA', 1),
(29086, 'Wilson', 'AR', 1),
(29087, 'Wilson', 'KS', 1),
(29088, 'Wilson', 'LA', 1),
(29089, 'Wilson', 'MI', 1),
(29090, 'Wilson', 'NC', 1),
(29091, 'Wilson', 'NY', 1),
(29092, 'Wilson', 'OK', 1),
(29093, 'Wilson', 'TX', 1),
(29094, 'Wilson', 'WI', 1),
(29095, 'Wilson', 'WY', 1),
(29096, 'Wilson Creek', 'WA', 1),
(29097, 'Wilsonburg', 'WV', 1),
(29098, 'Wilsondale', 'WV', 1),
(29099, 'Wilsons', 'VA', 1),
(29100, 'Wilsons Mills', 'NC', 1),
(29101, 'Wilsonville', 'AL', 1),
(29102, 'Wilsonville', 'IL', 1),
(29103, 'Wilsonville', 'NE', 1),
(29104, 'Wilsonville', 'OR', 1),
(29105, 'Wilton', 'AL', 1),
(29106, 'Wilton', 'AR', 1),
(29107, 'Wilton', 'CA', 1),
(29108, 'Wilton', 'CT', 1),
(29109, 'Wilton', 'IA', 1),
(29110, 'Wilton', 'ME', 1),
(29111, 'Wilton', 'MN', 1),
(29112, 'Wilton', 'ND', 1),
(29113, 'Wilton', 'NH', 1),
(29114, 'Wilton', 'WI', 1),
(29115, 'Wimauma', 'FL', 1),
(29116, 'Wimberley', 'TX', 1),
(29117, 'Wimbledon', 'ND', 1),
(29118, 'Winamac', 'IN', 1),
(29119, 'Winburne', 'PA', 1),
(29120, 'Winchendon', 'MA', 1),
(29121, 'Winchendon Springs', 'MA', 1),
(29122, 'Winchester', 'AR', 1),
(29123, 'Winchester', 'CA', 1),
(29124, 'Winchester', 'ID', 1),
(29125, 'Winchester', 'IL', 1),
(29126, 'Winchester', 'IN', 1),
(29127, 'Winchester', 'KS', 1),
(29128, 'Winchester', 'KY', 1),
(29129, 'Winchester', 'MA', 1),
(29130, 'Winchester', 'NH', 1),
(29131, 'Winchester', 'OH', 1),
(29132, 'Winchester', 'OR', 1),
(29133, 'Winchester', 'TN', 1),
(29134, 'Winchester', 'VA', 1),
(29135, 'Winchester Center', 'CT', 1),
(29136, 'Wind Gap', 'PA', 1),
(29137, 'Wind Ridge', 'PA', 1),
(29138, 'Windber', 'PA', 1),
(29139, 'Winder', 'GA', 1),
(29140, 'Windermere', 'FL', 1),
(29141, 'Windfall', 'IN', 1),
(29142, 'Windham', 'CT', 1),
(29143, 'Windham', 'ME', 1),
(29144, 'Windham', 'NH', 1),
(29145, 'Windham', 'NY', 1),
(29146, 'Windham', 'OH', 1),
(29147, 'Windom', 'KS', 1),
(29148, 'Windom', 'MN', 1),
(29149, 'Windom', 'TX', 1),
(29150, 'Window Rock', 'AZ', 1),
(29151, 'Windsor', 'CA', 1),
(29152, 'Windsor', 'CO', 1),
(29153, 'Windsor', 'CT', 1),
(29154, 'Windsor', 'IL', 1),
(29155, 'Windsor', 'KY', 1),
(29156, 'Windsor', 'MA', 1),
(29157, 'Windsor', 'ME', 1),
(29158, 'Windsor', 'MO', 1),
(29159, 'Windsor', 'NC', 1),
(29160, 'Windsor', 'NJ', 1),
(29161, 'Windsor', 'NY', 1),
(29162, 'Windsor', 'OH', 1),
(29163, 'Windsor', 'PA', 1),
(29164, 'Windsor', 'SC', 1),
(29165, 'Windsor', 'VA', 1),
(29166, 'Windsor', 'VT', 1),
(29167, 'Windsor', 'WI', 1),
(29168, 'Windsor Heights', 'WV', 1),
(29169, 'Windsor Locks', 'CT', 1),
(29170, 'Windsor Mill', 'MD', 1),
(29171, 'Windthorst', 'TX', 1),
(29172, 'Windyville', 'MO', 1),
(29173, 'Winesburg', 'OH', 1),
(29174, 'Winfall', 'NC', 1),
(29175, 'Winfield', 'AL', 1),
(29176, 'Winfield', 'IA', 1),
(29177, 'Winfield', 'IL', 1),
(29178, 'Winfield', 'KS', 1),
(29179, 'Winfield', 'MO', 1),
(29180, 'Winfield', 'PA', 1),
(29181, 'Winfield', 'TN', 1),
(29182, 'Winfield', 'TX', 1),
(29183, 'Winfield', 'WV', 1),
(29184, 'Winfred', 'SD', 1),
(29185, 'Wing', 'AL', 1),
(29186, 'Wing', 'ND', 1),
(29187, 'Wingate', 'IN', 1),
(29188, 'Wingate', 'MD', 1),
(29189, 'Wingate', 'NC', 1),
(29190, 'Wingate', 'TX', 1),
(29191, 'Wingdale', 'NY', 1),
(29192, 'Winger', 'MN', 1),
(29193, 'Wingett Run', 'OH', 1),
(29194, 'Wingina', 'VA', 1),
(29195, 'Wingo', 'KY', 1),
(29196, 'Winifred', 'MT', 1),
(29197, 'Winifrede', 'WV', 1),
(29198, 'Winigan', 'MO', 1),
(29199, 'Wink', 'TX', 1),
(29200, 'Winkelman', 'AZ', 1),
(29201, 'Winlock', 'WA', 1),
(29202, 'Winn', 'ME', 1),
(29203, 'Winn', 'MI', 1),
(29204, 'Winnabow', 'NC', 1),
(29205, 'Winnebago', 'IL', 1),
(29206, 'Winnebago', 'MN', 1),
(29207, 'Winnebago', 'NE', 1),
(29208, 'Winnebago', 'WI', 1),
(29209, 'Winneconne', 'WI', 1),
(29210, 'Winnemucca', 'NV', 1),
(29211, 'Winner', 'SD', 1),
(29212, 'Winnetka', 'CA', 1),
(29213, 'Winnetka', 'IL', 1),
(29214, 'Winnetoon', 'NE', 1),
(29215, 'Winnett', 'MT', 1),
(29216, 'Winnfield', 'LA', 1),
(29217, 'Winnie', 'TX', 1),
(29218, 'Winnisquam', 'NH', 1),
(29219, 'Winnsboro', 'LA', 1),
(29220, 'Winnsboro', 'SC', 1),
(29221, 'Winnsboro', 'TX', 1),
(29222, 'Winona', 'KS', 1),
(29223, 'Winona', 'MN', 1),
(29224, 'Winona', 'MO', 1),
(29225, 'Winona', 'MS', 1),
(29226, 'Winona', 'OH', 1),
(29227, 'Winona', 'TX', 1),
(29228, 'Winona', 'WV', 1),
(29229, 'Winona Lake', 'IN', 1),
(29230, 'Winooski', 'VT', 1),
(29231, 'Winside', 'NE', 1),
(29232, 'Winslow', 'AR', 1),
(29233, 'Winslow', 'AZ', 1),
(29234, 'Winslow', 'IL', 1),
(29235, 'Winslow', 'IN', 1),
(29236, 'Winslow', 'NE', 1),
(29237, 'Winslow', 'NJ', 1),
(29238, 'Winsted', 'CT', 1),
(29239, 'Winsted', 'MN', 1),
(29240, 'Winston', 'GA', 1),
(29241, 'Winston', 'KY', 1),
(29242, 'Winston', 'MO', 1),
(29243, 'Winston', 'MT', 1),
(29244, 'Winston', 'NM', 1),
(29245, 'Winston', 'OR', 1),
(29246, 'Winston Salem', 'NC', 1),
(29247, 'Winstonville', 'MS', 1),
(29248, 'Winter', 'WI', 1),
(29249, 'Winter Beach', 'FL', 1),
(29250, 'Winter Garden', 'FL', 1),
(29251, 'Winter Harbor', 'ME', 1),
(29252, 'Winter Haven', 'FL', 1),
(29253, 'Winter Park', 'CO', 1),
(29254, 'Winter Park', 'FL', 1),
(29255, 'Winter Springs', 'FL', 1),
(29256, 'Winterhaven', 'CA', 1),
(29257, 'Winterport', 'ME', 1),
(29258, 'Winters', 'CA', 1),
(29259, 'Winters', 'TX', 1),
(29260, 'Winterset', 'IA', 1),
(29261, 'Winterthur', 'DE', 1),
(29262, 'Winterville', 'GA', 1),
(29263, 'Winterville', 'MS', 1),
(29264, 'Winterville', 'NC', 1),
(29265, 'Winthrop', 'AR', 1),
(29266, 'Winthrop', 'IA', 1),
(29267, 'Winthrop', 'MA', 1),
(29268, 'Winthrop', 'ME', 1),
(29269, 'Winthrop', 'MN', 1),
(29270, 'Winthrop', 'NY', 1),
(29271, 'Winthrop', 'WA', 1),
(29272, 'Winthrop Harbor', 'IL', 1),
(29273, 'Winton', 'CA', 1),
(29274, 'Winton', 'MN', 1),
(29275, 'Winton', 'NC', 1),
(29276, 'Wiota', 'IA', 1),
(29277, 'Wirt', 'MN', 1),
(29278, 'Wirtz', 'VA', 1),
(29279, 'Wiscasset', 'ME', 1),
(29280, 'Wisconsin Dells', 'WI', 1),
(29281, 'Wisconsin Rapids', 'WI', 1),
(29282, 'Wisdom', 'MT', 1),
(29283, 'Wise', 'NC', 1),
(29284, 'Wise', 'VA', 1),
(29285, 'Wise River', 'MT', 1),
(29286, 'Wiseman', 'AR', 1),
(29287, 'Wishek', 'ND', 1),
(29288, 'Wishon', 'CA', 1),
(29289, 'Wishram', 'WA', 1),
(29290, 'Wisner', 'LA', 1),
(29291, 'Wisner', 'NE', 1),
(29292, 'Wister', 'OK', 1),
(29293, 'Withams', 'VA', 1),
(29294, 'Withee', 'WI', 1),
(29295, 'Witherbee', 'NY', 1),
(29296, 'Witmer', 'PA', 1),
(29297, 'Witt', 'IL', 1),
(29298, 'Witten', 'SD', 1),
(29299, 'Wittenberg', 'WI', 1),
(29300, 'Wittensville', 'KY', 1),
(29301, 'Witter', 'AR', 1),
(29302, 'Witter Springs', 'CA', 1),
(29303, 'Wittman', 'MD', 1),
(29304, 'Wittmann', 'AZ', 1),
(29305, 'Witts Springs', 'AR', 1),
(29306, 'Wixom', 'MI', 1),
(29307, 'Woburn', 'MA', 1),
(29308, 'Woden', 'IA', 1),
(29309, 'Woden', 'TX', 1),
(29310, 'Wofford Heights', 'CA', 1),
(29311, 'Wolbach', 'NE', 1),
(29312, 'Wolcott', 'CO', 1),
(29313, 'Wolcott', 'CT', 1),
(29314, 'Wolcott', 'IN', 1),
(29315, 'Wolcott', 'NY', 1),
(29316, 'Wolcott', 'VT', 1),
(29317, 'Wolcottville', 'IN', 1),
(29318, 'Wolf', 'WY', 1),
(29319, 'Wolf Creek', 'MT', 1),
(29320, 'Wolf Creek', 'OR', 1),
(29321, 'Wolf Island', 'MO', 1),
(29322, 'Wolf Lake', 'IL', 1),
(29323, 'Wolf Lake', 'MN', 1),
(29324, 'Wolf Point', 'MT', 1),
(29325, 'Wolf Run', 'OH', 1),
(29326, 'Wolfcreek', 'WV', 1),
(29327, 'Wolfe', 'WV', 1),
(29328, 'Wolfe City', 'TX', 1),
(29329, 'Wolfeboro', 'NH', 1),
(29330, 'Wolfeboro Falls', 'NH', 1),
(29331, 'Wolfforth', 'TX', 1),
(29332, 'Wolflake', 'IN', 1),
(29333, 'Wolford', 'ND', 1),
(29334, 'Wolford', 'VA', 1),
(29335, 'Wolftown', 'VA', 1),
(29336, 'Wolsey', 'SD', 1),
(29337, 'Wolverine', 'MI', 1),
(29338, 'Wolverton', 'MN', 1),
(29339, 'Womelsdorf', 'PA', 1),
(29340, 'Wonalancet', 'NH', 1),
(29341, 'Wonder Lake', 'IL', 1),
(29342, 'Wonewoc', 'WI', 1),
(29343, 'Wood', 'PA', 1),
(29344, 'Wood', 'SD', 1),
(29345, 'Wood Dale', 'IL', 1),
(29346, 'Wood Lake', 'MN', 1),
(29347, 'Wood Lake', 'NE', 1),
(29348, 'Wood Ridge', 'NJ', 1),
(29349, 'Wood River', 'IL', 1),
(29350, 'Wood River', 'NE', 1),
(29351, 'Wood River Junction', 'RI', 1),
(29352, 'Woodacre', 'CA', 1),
(29353, 'Woodberry Forest', 'VA', 1),
(29354, 'Woodbine', 'GA', 1),
(29355, 'Woodbine', 'IA', 1),
(29356, 'Woodbine', 'KS', 1),
(29357, 'Woodbine', 'KY', 1),
(29358, 'Woodbine', 'MD', 1),
(29359, 'Woodbine', 'NJ', 1),
(29360, 'Woodbourne', 'NY', 1),
(29361, 'Woodbridge', 'CA', 1),
(29362, 'Woodbridge', 'CT', 1),
(29363, 'Woodbridge', 'NJ', 1),
(29364, 'Woodbridge', 'VA', 1),
(29365, 'Woodburn', 'IA', 1),
(29366, 'Woodburn', 'IN', 1),
(29367, 'Woodburn', 'KY', 1),
(29368, 'Woodburn', 'OR', 1),
(29369, 'Woodbury', 'CT', 1),
(29370, 'Woodbury', 'GA', 1),
(29371, 'Woodbury', 'KY', 1),
(29372, 'Woodbury', 'NJ', 1),
(29373, 'Woodbury', 'NY', 1),
(29374, 'Woodbury', 'PA', 1),
(29375, 'Woodbury', 'TN', 1),
(29376, 'Woodbury', 'VT', 1),
(29377, 'Woodbury Heights', 'NJ', 1),
(29378, 'Woodcliff Lake', 'NJ', 1),
(29379, 'Woodford', 'VA', 1),
(29380, 'Woodford', 'WI', 1),
(29381, 'Woodgate', 'NY', 1),
(29382, 'Woodhaven', 'NY', 1),
(29383, 'Woodhull', 'IL', 1),
(29384, 'Woodhull', 'NY', 1),
(29385, 'Woodinville', 'WA', 1),
(29386, 'Woodlake', 'CA', 1),
(29387, 'Woodlake', 'TX', 1),
(29388, 'Woodland', 'AL', 1),
(29389, 'Woodland', 'CA', 1),
(29390, 'Woodland', 'GA', 1),
(29391, 'Woodland', 'IL', 1),
(29392, 'Woodland', 'MI', 1),
(29393, 'Woodland', 'MS', 1),
(29394, 'Woodland', 'NC', 1),
(29395, 'Woodland', 'PA', 1),
(29396, 'Woodland', 'WA', 1),
(29397, 'Woodland', 'WI', 1),
(29398, 'Woodland Hills', 'CA', 1),
(29399, 'Woodland Mills', 'TN', 1),
(29400, 'Woodland Park', 'CO', 1),
(29401, 'Woodlawn', 'IL', 1),
(29402, 'Woodlawn', 'TN', 1),
(29403, 'Woodlawn', 'TX', 1),
(29404, 'Woodlawn', 'VA', 1),
(29405, 'Woodleaf', 'NC', 1),
(29406, 'Woodlyn', 'PA', 1),
(29407, 'Woodman', 'WI', 1),
(29408, 'Woodmere', 'NY', 1),
(29409, 'Woodridge', 'IL', 1),
(29410, 'Woodridge', 'NY', 1),
(29411, 'Woodrow', 'CO', 1),
(29412, 'Woodruff', 'AZ', 1),
(29413, 'Woodruff', 'SC', 1),
(29414, 'Woodruff', 'UT', 1),
(29415, 'Woodruff', 'WI', 1),
(29416, 'Woods Cross', 'UT', 1),
(29417, 'Woods Cross Roads', 'VA', 1),
(29418, 'Woods Hole', 'MA', 1),
(29419, 'Woodsboro', 'MD', 1),
(29420, 'Woodsboro', 'TX', 1),
(29421, 'Woodsfield', 'OH', 1),
(29422, 'Woodside', 'DE', 1),
(29423, 'Woodside', 'NY', 1),
(29424, 'Woodson', 'AR', 1),
(29425, 'Woodson', 'IL', 1),
(29426, 'Woodson', 'TX', 1),
(29427, 'Woodstock', 'AL', 1),
(29428, 'Woodstock', 'CT', 1),
(29429, 'Woodstock', 'GA', 1),
(29430, 'Woodstock', 'IL', 1),
(29431, 'Woodstock', 'MD', 1),
(29432, 'Woodstock', 'MN', 1),
(29433, 'Woodstock', 'NH', 1),
(29434, 'Woodstock', 'NY', 1),
(29435, 'Woodstock', 'OH', 1),
(29436, 'Woodstock', 'VA', 1),
(29437, 'Woodstock', 'VT', 1),
(29438, 'Woodstock Valley', 'CT', 1),
(29439, 'Woodston', 'KS', 1),
(29440, 'Woodstown', 'NJ', 1),
(29441, 'Woodsville', 'NH', 1),
(29442, 'Woodville', 'AL', 1),
(29443, 'Woodville', 'FL', 1),
(29444, 'Woodville', 'MA', 1),
(29445, 'Woodville', 'MS', 1),
(29446, 'Woodville', 'OH', 1),
(29447, 'Woodville', 'TX', 1),
(29448, 'Woodville', 'VA', 1),
(29449, 'Woodville', 'WI', 1),
(29450, 'Woodville', 'WV', 1),
(29451, 'Woodward', 'IA', 1),
(29452, 'Woodward', 'OK', 1),
(29453, 'Woodward', 'PA', 1),
(29454, 'Woodway', 'TX', 1),
(29455, 'Woodworth', 'LA', 1),
(29456, 'Woodworth', 'ND', 1),
(29457, 'Woodworth', 'WI', 1),
(29458, 'Woody', 'CA', 1),
(29459, 'Woody Creek', 'CO', 1),
(29460, 'Wooldridge', 'MO', 1),
(29461, 'Woolford', 'MD', 1),
(29462, 'Woollum', 'KY', 1),
(29463, 'Woolrich', 'PA', 1),
(29464, 'Woolstock', 'IA', 1),
(29465, 'Woolwich', 'ME', 1),
(29466, 'Woolwine', 'VA', 1),
(29467, 'Woonsocket', 'RI', 1),
(29468, 'Woonsocket', 'SD', 1),
(29469, 'Wooster', 'AR', 1),
(29470, 'Wooster', 'OH', 1),
(29471, 'Woosung', 'IL', 1),
(29472, 'Wooton', 'KY', 1),
(29473, 'Worcester', 'MA', 1),
(29474, 'Worcester', 'NY', 1),
(29475, 'Worcester', 'PA', 1),
(29476, 'Worcester', 'VT', 1),
(29477, 'Worden', 'IL', 1),
(29478, 'Worden', 'MT', 1),
(29479, 'Worland', 'WY', 1),
(29480, 'Worley', 'ID', 1),
(29481, 'Woronoco', 'MA', 1),
(29482, 'Worth', 'IL', 1),
(29483, 'Worth', 'MO', 1),
(29484, 'Wortham', 'TX', 1),
(29485, 'Worthing', 'SD', 1),
(29486, 'Worthington', 'IA', 1),
(29487, 'Worthington', 'IN', 1),
(29488, 'Worthington', 'KY', 1),
(29489, 'Worthington', 'MA', 1),
(29490, 'Worthington', 'MN', 1),
(29491, 'Worthington', 'MO', 1),
(29492, 'Worthington', 'PA', 1),
(29493, 'Worthington', 'WV', 1),
(29494, 'Worthington Springs', 'FL', 1),
(29495, 'Worthville', 'KY', 1),
(29496, 'Worthville', 'PA', 1),
(29497, 'Worton', 'MD', 1),
(29498, 'Wounded Knee', 'SD', 1),
(29499, 'Woxall', 'PA', 1),
(29500, 'Wrangell', 'AK', 1),
(29501, 'Wray', 'CO', 1),
(29502, 'Wray', 'GA', 1),
(29503, 'Wren', 'OH', 1),
(29504, 'Wrens', 'GA', 1),
(29505, 'Wrenshall', 'MN', 1),
(29506, 'Wrentham', 'MA', 1),
(29507, 'Wright', 'AR', 1),
(29508, 'Wright', 'KS', 1),
(29509, 'Wright', 'MN', 1),
(29510, 'Wright', 'WY', 1),
(29511, 'Wright City', 'MO', 1),
(29512, 'Wright City', 'OK', 1),
(29513, 'Wrights', 'IL', 1),
(29514, 'Wrightsboro', 'TX', 1),
(29515, 'Wrightstown', 'NJ', 1),
(29516, 'Wrightstown', 'WI', 1),
(29517, 'Wrightsville', 'AR', 1),
(29518, 'Wrightsville', 'GA', 1),
(29519, 'Wrightsville', 'PA', 1),
(29520, 'Wrightsville Beach', 'NC', 1),
(29521, 'Wrightwood', 'CA', 1),
(29522, 'Wrigley', 'KY', 1),
(29523, 'Wurtsboro', 'NY', 1),
(29524, 'Wyaconda', 'MO', 1),
(29525, 'Wyalusing', 'PA', 1),
(29526, 'Wyandanch', 'NY', 1),
(29527, 'Wyandotte', 'MI', 1),
(29528, 'Wyandotte', 'OK', 1),
(29529, 'Wyanet', 'IL', 1),
(29530, 'Wyano', 'PA', 1),
(29531, 'Wyarno', 'WY', 1),
(29532, 'Wyatt', 'IN', 1),
(29533, 'Wyatt', 'MO', 1),
(29534, 'Wyatt', 'WV', 1),
(29535, 'Wyckoff', 'NJ', 1),
(29536, 'Wyco', 'WV', 1),
(29537, 'Wycombe', 'PA', 1),
(29538, 'Wye Mills', 'MD', 1),
(29539, 'Wykoff', 'MN', 1),
(29540, 'Wylie', 'TX', 1),
(29541, 'Wylliesburg', 'VA', 1),
(29542, 'Wymore', 'NE', 1),
(29543, 'Wynantskill', 'NY', 1),
(29544, 'Wyncote', 'PA', 1),
(29545, 'Wyndmere', 'ND', 1),
(29546, 'Wynnburg', 'TN', 1),
(29547, 'Wynne', 'AR', 1),
(29548, 'Wynnewood', 'OK', 1),
(29549, 'Wynnewood', 'PA', 1),
(29550, 'Wynona', 'OK', 1),
(29551, 'Wynot', 'NE', 1),
(29552, 'Wyocena', 'WI', 1),
(29553, 'Wyola', 'MT', 1),
(29554, 'Wyoming', 'IA', 1),
(29555, 'Wyoming', 'IL', 1),
(29556, 'Wyoming', 'MI', 1),
(29557, 'Wyoming', 'MN', 1),
(29558, 'Wyoming', 'NY', 1),
(29559, 'Wyoming', 'PA', 1),
(29560, 'Wyoming', 'RI', 1),
(29561, 'Wyoming', 'WV', 1),
(29562, 'Wysox', 'PA', 1),
(29563, 'Wytheville', 'VA', 1),
(29564, 'Wytopitlock', 'ME', 1),
(29565, 'Xenia', 'IL', 1),
(29566, 'Xenia', 'OH', 1),
(29567, 'Yabucoa', 'PR', 1),
(29568, 'Yachats', 'OR', 1),
(29569, 'Yacolt', 'WA', 1),
(29570, 'Yadkinville', 'NC', 1),
(29571, 'Yakima', 'WA', 1),
(29572, 'Yakutat', 'AK', 1),
(29573, 'Yalaha', 'FL', 1),
(29574, 'Yale', 'IA', 1),
(29575, 'Yale', 'IL', 1),
(29576, 'Yale', 'MI', 1),
(29577, 'Yale', 'OK', 1),
(29578, 'Yale', 'SD', 1),
(29579, 'Yale', 'VA', 1),
(29580, 'Yamhill', 'OR', 1),
(29581, 'Yampa', 'CO', 1),
(29582, 'Yancey', 'TX', 1),
(29583, 'Yanceyville', 'NC', 1),
(29584, 'Yankeetown', 'FL', 1),
(29585, 'Yankton', 'SD', 1),
(29586, 'Yantic', 'CT', 1),
(29587, 'Yantis', 'TX', 1),
(29588, 'Yaphank', 'NY', 1),
(29589, 'Yarmouth', 'IA', 1),
(29590, 'Yarmouth', 'ME', 1),
(29591, 'Yarmouth Port', 'MA', 1),
(29592, 'Yarnell', 'AZ', 1),
(29593, 'Yatahey', 'NM', 1),
(29594, 'Yates Center', 'KS', 1),
(29595, 'Yates City', 'IL', 1),
(29596, 'Yatesboro', 'PA', 1),
(29597, 'Yatesville', 'GA', 1),
(29598, 'Yauco', 'PR', 1),
(29599, 'Yawkey', 'WV', 1),
(29600, 'Yazoo City', 'MS', 1),
(29601, 'Yeaddiss', 'KY', 1),
(29602, 'Yeagertown', 'PA', 1),
(29603, 'Yellow Jacket', 'CO', 1),
(29604, 'Yellow Pine', 'ID', 1),
(29605, 'Yellow Spring', 'WV', 1),
(29606, 'Yellow Springs', 'OH', 1),
(29607, 'Yellowstone National Park', 'WY', 1),
(29608, 'Yellowtail', 'MT', 1),
(29609, 'Yellville', 'AR', 1),
(29610, 'Yelm', 'WA', 1),
(29611, 'Yemassee', 'SC', 1),
(29612, 'Yeoman', 'IN', 1),
(29613, 'Yerington', 'NV', 1),
(29614, 'Yerkes', 'KY', 1),
(29615, 'Yermo', 'CA', 1),
(29616, 'Yeso', 'NM', 1),
(29617, 'Yettem', 'CA', 1),
(29618, 'Yoakum', 'TX', 1),
(29619, 'Yoder', 'CO', 1),
(29620, 'Yoder', 'IN', 1),
(29621, 'Yoder', 'KS', 1),
(29622, 'Yoder', 'WY', 1),
(29623, 'Yolo', 'CA', 1),
(29624, 'Yolyn', 'WV', 1),
(29625, 'Yoncalla', 'OR', 1),
(29626, 'Yonkers', 'NY', 1),
(29627, 'Yorba Linda', 'CA', 1),
(29628, 'York', 'AL', 1),
(29629, 'York', 'ME', 1),
(29630, 'York', 'ND', 1),
(29631, 'York', 'NE', 1),
(29632, 'York', 'NY', 1),
(29633, 'York', 'PA', 1),
(29634, 'York', 'SC', 1),
(29635, 'York Beach', 'ME', 1),
(29636, 'York Harbor', 'ME', 1),
(29637, 'York Haven', 'PA', 1),
(29638, 'York New Salem', 'PA', 1),
(29639, 'York Springs', 'PA', 1),
(29640, 'Yorklyn', 'DE', 1),
(29641, 'Yorkshire', 'NY', 1),
(29642, 'Yorkshire', 'OH', 1),
(29643, 'Yorktown', 'AR', 1),
(29644, 'Yorktown', 'IA', 1),
(29645, 'Yorktown', 'IN', 1),
(29646, 'Yorktown', 'TX', 1),
(29647, 'Yorktown', 'VA', 1),
(29648, 'Yorktown Heights', 'NY', 1),
(29649, 'Yorkville', 'CA', 1),
(29650, 'Yorkville', 'IL', 1),
(29651, 'Yorkville', 'NY', 1),
(29652, 'Yorkville', 'OH', 1),
(29653, 'Yorkville', 'TN', 1),
(29654, 'Yosemite', 'KY', 1),
(29655, 'Yosemite National Park', 'CA', 1),
(29656, 'Young', 'AZ', 1),
(29657, 'Young America', 'IN', 1),
(29658, 'Young America', 'MN', 1),
(29659, 'Young Harris', 'GA', 1),
(29660, 'Youngstown', 'FL', 1),
(29661, 'Youngstown', 'NY', 1),
(29662, 'Youngstown', 'OH', 1),
(29663, 'Youngstown', 'PA', 1),
(29664, 'Youngsville', 'LA', 1),
(29665, 'Youngsville', 'NC', 1),
(29666, 'Youngsville', 'NM', 1),
(29667, 'Youngsville', 'NY', 1),
(29668, 'Youngsville', 'PA', 1),
(29669, 'Youngtown', 'AZ', 1),
(29670, 'Youngwood', 'PA', 1),
(29671, 'Yountville', 'CA', 1),
(29672, 'Ypsilanti', 'MI', 1),
(29673, 'Ypsilanti', 'ND', 1),
(29674, 'Yreka', 'CA', 1),
(29675, 'Yuba City', 'CA', 1),
(29676, 'Yucaipa', 'CA', 1),
(29677, 'Yucca', 'AZ', 1),
(29678, 'Yucca Valley', 'CA', 1),
(29679, 'Yukon', 'MO', 1),
(29680, 'Yukon', 'OK', 1),
(29681, 'Yukon', 'PA', 1),
(29682, 'Yulan', 'NY', 1),
(29683, 'Yulee', 'FL', 1),
(29684, 'Yuma', 'AZ', 1),
(29685, 'Yuma', 'CO', 1),
(29686, 'Yuma', 'TN', 1),
(29687, 'Yutan', 'NE', 1),
(29688, 'Zacata', 'VA', 1),
(29689, 'Zachary', 'LA', 1),
(29690, 'Zachow', 'WI', 1),
(29691, 'Zahl', 'ND', 1),
(29692, 'Zaleski', 'OH', 1),
(29693, 'Zalma', 'MO', 1),
(29694, 'Zamora', 'CA', 1),
(29695, 'Zanesfield', 'OH', 1),
(29696, 'Zanesville', 'IN', 1),
(29697, 'Zanesville', 'OH', 1),
(29698, 'Zanoni', 'MO', 1),
(29699, 'Zap', 'ND', 1),
(29700, 'Zapata', 'TX', 1),
(29701, 'Zarephath', 'NJ', 1),
(29702, 'Zavalla', 'TX', 1),
(29703, 'Zearing', 'IA', 1),
(29704, 'Zebulon', 'GA', 1),
(29705, 'Zebulon', 'NC', 1),
(29706, 'Zeeland', 'MI', 1),
(29707, 'Zeeland', 'ND', 1),
(29708, 'Zeigler', 'IL', 1),
(29709, 'Zelienople', 'PA', 1),
(29710, 'Zellwood', 'FL', 1),
(29711, 'Zenda', 'KS', 1),
(29712, 'Zenda', 'WI', 1),
(29713, 'Zenia', 'CA', 1),
(29714, 'Zephyr', 'TX', 1),
(29715, 'Zephyr Cove', 'NV', 1),
(29716, 'Zephyrhills', 'FL', 1),
(29717, 'Zieglerville', 'PA', 1),
(29718, 'Zillah', 'WA', 1),
(29719, 'Zimmerman', 'MN', 1),
(29720, 'Zion', 'IL', 1),
(29721, 'Zion Grove', 'PA', 1),
(29722, 'Zionhill', 'PA', 1),
(29723, 'Zionsville', 'IN', 1),
(29724, 'Zionsville', 'PA', 1),
(29725, 'Zionville', 'NC', 1),
(29726, 'Zirconia', 'NC', 1),
(29727, 'Zoar', 'OH', 1),
(29728, 'Zoe', 'KY', 1),
(29729, 'Zolfo Springs', 'FL', 1),
(29730, 'Zortman', 'MT', 1),
(29731, 'Zullinger', 'PA', 1),
(29732, 'Zumbro Falls', 'MN', 1),
(29733, 'Zumbrota', 'MN', 1),
(29734, 'Zuni', 'NM', 1),
(29735, 'Zuni', 'VA', 1),
(29736, 'Zurich', 'MT', 1),
(29737, 'Zwingle', 'IA', 1),
(29738, 'Zwolle', 'LA', 1);

-- --------------------------------------------------------

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `state_code` varchar(30) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `creditscore`
--

CREATE TABLE `creditscore` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `source_type` int(11) NOT NULL COMMENT '1=transunion,2=Equifax,3=Experian',
  `riskScore` int(11) NOT NULL,
  `scoreName` varchar(50) NOT NULL,
  `populationRank` varchar(50) NOT NULL,
  `inquiriesAffectedScore` varchar(50) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `creditscore`
--

INSERT INTO `creditscore` (`id`, `user_id`, `source_type`, `riskScore`, `scoreName`, `populationRank`, `inquiriesAffectedScore`, `created`, `modified`) VALUES
(1, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-02 17:53:38', '2020-09-02 12:23:39'),
(2, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(3, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(4, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(5, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(6, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(7, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-04 12:20:07', '2020-09-03 06:50:07'),
(8, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-04 12:20:07', '2020-09-03 06:50:07'),
(9, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-04 12:20:07', '2020-09-03 06:50:07'),
(10, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-05 12:26:25', '2020-09-03 06:56:25'),
(11, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-05 12:26:25', '2020-09-03 06:56:25'),
(12, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-05 12:26:25', '2020-09-03 06:56:25'),
(13, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-06 13:59:51', '2020-09-03 08:29:51'),
(14, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-06 13:59:51', '2020-09-03 08:29:51'),
(15, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-06 13:59:51', '2020-09-03 08:29:51'),
(16, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-07 12:00:37', '2020-09-04 06:30:37'),
(17, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-07 12:00:37', '2020-09-04 06:30:37'),
(18, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-07 12:00:37', '2020-09-04 06:30:37'),
(19, 1, 1, 528, 'VantageScore3', '16', 'true', '2020-09-08 14:40:43', '2020-09-04 09:10:43'),
(20, 1, 2, 515, 'VantageScore3', '8', 'true', '2020-09-08 14:40:43', '2020-09-04 09:10:43'),
(21, 1, 3, 514, 'VantageScore3', '8', '', '2020-09-08 14:40:44', '2020-09-04 09:10:44'),
(22, 1, 1, 755, 'VantageScore3', '74', '', '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(23, 1, 2, 755, 'VantageScore3', '74', '', '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(24, 1, 3, 751, 'VantageScore3', '72', '', '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(25, 1, 1, 755, 'VantageScore3', '74', '', '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(26, 1, 2, 755, 'VantageScore3', '74', '', '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(27, 1, 3, 751, 'VantageScore3', '72', '', '2020-10-05 14:06:06', '2020-10-05 08:36:06');

-- --------------------------------------------------------

--
-- Table structure for table `creditscorefactor`
--

CREATE TABLE `creditscorefactor` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `creditscore_id` int(11) NOT NULL,
  `bureauCode` varchar(10) NOT NULL,
  `FactorType` varchar(50) NOT NULL,
  `symbol` varchar(50) NOT NULL,
  `rank` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `creditscorefactor`
--

INSERT INTO `creditscorefactor` (`id`, `user_id`, `creditscore_id`, `bureauCode`, `FactorType`, `symbol`, `rank`, `status`, `created`, `modified`) VALUES
(1, 1, 1, '97', 'Negative', '97', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(2, 1, 1, '23', 'Negative', '23', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(3, 1, 1, '95', 'Negative', '95', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(4, 1, 1, '65', 'Negative', '65', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(5, 1, 1, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(6, 1, 1, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(7, 1, 1, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(8, 1, 1, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(9, 1, 2, '97', 'Negative', '97', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(10, 1, 2, '08', 'Negative', '08', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(11, 1, 2, '95', 'Negative', '95', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(12, 1, 2, '22', 'Negative', '22', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(13, 1, 2, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(14, 1, 2, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(15, 1, 2, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(16, 1, 2, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(17, 1, 3, '97', 'Negative', '97', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(18, 1, 3, '08', 'Negative', '08', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(19, 1, 3, '95', 'Negative', '95', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(20, 1, 3, '22', 'Negative', '22', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(21, 1, 3, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(22, 1, 3, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(23, 1, 3, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(24, 1, 3, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(25, 1, 4, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(26, 1, 4, '23', 'Negative', '23', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(27, 1, 4, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(28, 1, 4, '65', 'Negative', '65', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(29, 1, 4, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(30, 1, 4, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(31, 1, 4, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(32, 1, 4, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(33, 1, 5, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(34, 1, 5, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(35, 1, 5, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(36, 1, 5, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(37, 1, 5, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(38, 1, 5, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(39, 1, 5, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(40, 1, 5, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(41, 1, 6, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(42, 1, 6, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(43, 1, 6, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(44, 1, 6, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(45, 1, 6, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(46, 1, 6, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(47, 1, 6, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(48, 1, 6, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(49, 1, 7, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(50, 1, 7, '23', 'Negative', '23', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(51, 1, 7, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(52, 1, 7, '65', 'Negative', '65', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(53, 1, 7, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(54, 1, 7, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(55, 1, 7, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(56, 1, 7, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(57, 1, 8, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(58, 1, 8, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(59, 1, 8, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(60, 1, 8, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(61, 1, 8, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(62, 1, 8, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(63, 1, 8, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(64, 1, 8, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(65, 1, 9, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(66, 1, 9, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(67, 1, 9, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(68, 1, 9, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(69, 1, 9, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(70, 1, 9, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(71, 1, 9, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(72, 1, 9, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(73, 1, 10, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(74, 1, 10, '23', 'Negative', '23', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(75, 1, 10, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(76, 1, 10, '65', 'Negative', '65', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(77, 1, 10, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(78, 1, 10, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(79, 1, 10, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(80, 1, 10, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(81, 1, 11, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(82, 1, 11, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(83, 1, 11, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(84, 1, 11, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(85, 1, 11, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(86, 1, 11, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(87, 1, 11, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(88, 1, 11, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(89, 1, 12, '97', 'Negative', '97', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(90, 1, 12, '08', 'Negative', '08', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(91, 1, 12, '95', 'Negative', '95', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(92, 1, 12, '22', 'Negative', '22', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(93, 1, 12, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(94, 1, 12, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(95, 1, 12, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(96, 1, 12, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(97, 1, 13, '97', 'Negative', '97', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(98, 1, 13, '23', 'Negative', '23', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(99, 1, 13, '95', 'Negative', '95', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(100, 1, 13, '65', 'Negative', '65', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(101, 1, 13, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(102, 1, 13, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(103, 1, 13, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(104, 1, 13, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(105, 1, 14, '97', 'Negative', '97', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(106, 1, 14, '08', 'Negative', '08', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(107, 1, 14, '95', 'Negative', '95', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(108, 1, 14, '22', 'Negative', '22', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(109, 1, 14, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(110, 1, 14, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(111, 1, 14, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(112, 1, 14, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(113, 1, 15, '97', 'Negative', '97', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(114, 1, 15, '08', 'Negative', '08', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(115, 1, 15, '95', 'Negative', '95', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(116, 1, 15, '22', 'Negative', '22', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(117, 1, 15, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(118, 1, 15, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(119, 1, 15, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(120, 1, 15, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(121, 1, 16, '97', 'Negative', '97', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(122, 1, 16, '23', 'Negative', '23', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(123, 1, 16, '95', 'Negative', '95', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(124, 1, 16, '65', 'Negative', '65', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(125, 1, 16, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(126, 1, 16, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(127, 1, 16, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(128, 1, 16, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(129, 1, 17, '97', 'Negative', '97', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(130, 1, 17, '08', 'Negative', '08', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(131, 1, 17, '95', 'Negative', '95', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(132, 1, 17, '22', 'Negative', '22', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(133, 1, 17, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(134, 1, 17, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(135, 1, 17, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(136, 1, 17, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(137, 1, 18, '97', 'Negative', '97', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(138, 1, 18, '08', 'Negative', '08', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(139, 1, 18, '95', 'Negative', '95', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(140, 1, 18, '22', 'Negative', '22', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(141, 1, 18, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(142, 1, 18, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(143, 1, 18, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(144, 1, 18, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(145, 1, 19, '97', 'Negative', '97', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(146, 1, 19, '23', 'Negative', '23', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(147, 1, 19, '95', 'Negative', '95', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(148, 1, 19, '65', 'Negative', '65', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(149, 1, 19, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(150, 1, 19, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(151, 1, 19, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(152, 1, 19, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(153, 1, 20, '97', 'Negative', '97', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(154, 1, 20, '08', 'Negative', '08', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(155, 1, 20, '95', 'Negative', '95', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(156, 1, 20, '22', 'Negative', '22', '100000', 0, '2020-09-04 14:40:43', '2020-09-04 09:10:43'),
(157, 1, 20, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(158, 1, 20, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(159, 1, 20, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(160, 1, 20, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(161, 1, 21, '97', 'Negative', '97', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(162, 1, 21, '08', 'Negative', '08', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(163, 1, 21, '95', 'Negative', '95', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(164, 1, 21, '22', 'Negative', '22', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(165, 1, 21, 'P15', 'Positive', 'P15', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(166, 1, 21, 'P49', 'Positive', 'P49', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(167, 1, 21, 'P73', 'Positive', 'P73', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(168, 1, 21, 'P64', 'Positive', 'P64', '100000', 0, '2020-09-04 14:40:44', '2020-09-04 09:10:44'),
(169, 1, 22, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(170, 1, 22, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(171, 1, 22, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(172, 1, 22, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(173, 1, 22, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(174, 1, 22, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(175, 1, 22, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(176, 1, 22, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(177, 1, 23, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(178, 1, 23, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(179, 1, 23, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(180, 1, 23, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(181, 1, 23, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(182, 1, 23, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(183, 1, 23, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(184, 1, 23, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(185, 1, 24, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(186, 1, 24, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(187, 1, 24, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(188, 1, 24, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(189, 1, 24, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(190, 1, 24, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(191, 1, 24, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(192, 1, 24, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:04:26', '2020-10-05 08:34:26'),
(193, 1, 25, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(194, 1, 25, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(195, 1, 25, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(196, 1, 25, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(197, 1, 25, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(198, 1, 25, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(199, 1, 25, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(200, 1, 25, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(201, 1, 26, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(202, 1, 26, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(203, 1, 26, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(204, 1, 26, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(205, 1, 26, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(206, 1, 26, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(207, 1, 26, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(208, 1, 26, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(209, 1, 27, '12', 'Negative', '12', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(210, 1, 27, '14', 'Negative', '14', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(211, 1, 27, '63', 'Negative', '63', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(212, 1, 27, '16', 'Negative', '16', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(213, 1, 27, 'P34', 'Positive', 'P34', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(214, 1, 27, 'P04', 'Positive', 'P04', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(215, 1, 27, 'P40', 'Positive', 'P40', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06'),
(216, 1, 27, 'P05', 'Positive', 'P05', '100000', 0, '2020-10-05 14:06:06', '2020-10-05 08:36:06');

-- --------------------------------------------------------

--
-- Table structure for table `credit_offer`
--

CREATE TABLE `credit_offer` (
  `id` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `card_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `odds` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `annual_fee` int(11) NOT NULL,
  `security_deposit` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `credit_offer`
--

INSERT INTO `credit_offer` (`id`, `title`, `card_image`, `odds`, `annual_fee`, `security_deposit`, `url`, `status`, `created`, `updated`) VALUES
(2, 'Capital One® Platinum Credit Card', '1600859624_download (1).png', 'Very Good', 0, '$0', 'https://www.cardbenefit.com/capital-one-platinum-credit-card-review/', 1, '0000-00-00 00:00:00', '2020-09-23 11:19:40'),
(3, 'Capital One® Secured MasterCard®', '1600859955_download (2).png', 'Excellent', 0, '$49-$200', 'https://www.cardbenefit.com/clk.php?u=versio&o=CSM', 1, '0000-00-00 00:00:00', '2020-09-23 11:19:15'),
(4, 'OpenSky® Secured Visa® Credit Card', '1600860059_download (3).png', 'Excellent', 35, '$200', 'https://www.cardbenefit.com/opensky.html', 1, '0000-00-00 00:00:00', '2020-09-23 11:21:24');

-- --------------------------------------------------------

--
-- Table structure for table `credit_plan`
--

CREATE TABLE `credit_plan` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `description` text NOT NULL,
  `basic` tinyint(4) NOT NULL,
  `premium` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `credit_plan`
--

INSERT INTO `credit_plan` (`id`, `title`, `amount`, `content`, `description`, `basic`, `premium`, `status`, `created`, `updated`) VALUES
(2, 'smartcredit®', '19.95', '<ul class=\"content-list\">\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> 3Bureau Credit Reports &amp; Scores</li>\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Identity The Insurance ($1m)</li>\r\n									<li> <span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Credit Monitoring &amp; Alerts(TU)</li>\r\n								</ul>', 'Includes Smart Credit Money Manager with 2 monthly Smart Credit Reports and Scores and 2 monthly Action Buttons.', 1, 0, 1, '0000-00-00 00:00:00', '2020-08-31 13:07:03'),
(3, 'smartcredit®', '24.95', '<ul class=\"content-list\">\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> 3Bureau Credit Reports &amp; Scores</li>\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Identity The Insurance ($1m)</li>\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Credit Monitoring &amp; Alerts(TU)</li>\r\n								</ul>', 'Includes Smart Credit Money Manager with Unlimited Smart Credit Reports and Scores and Unlimited Action Buttons', 0, 1, 1, '0000-00-00 00:00:00', '2020-08-31 13:07:47'),
(4, 'IDENTITY', '29.99', '<ul class=\"content-list\">\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> 3Bureau Credit Reports &amp; Scores</li>\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Identity The Insurance ($1m)</li>\r\n									<li><span class=\"check_icon\"><i class=\"fa fa-check\"></i></span> Credit Monitoring &amp; Alerts(TU)</li>\r\n								</ul>', 'IdentityIQ includes a 7 day trial for $1.', 0, 0, 1, '0000-00-00 00:00:00', '2020-08-31 13:08:09');

-- --------------------------------------------------------

--
-- Table structure for table `dispute_letters`
--

CREATE TABLE `dispute_letters` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `round` int(11) NOT NULL,
  `bureau` int(11) NOT NULL,
  `acc_no` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `method` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sent_date` date NOT NULL,
  `confirm_doc` text COLLATE utf8_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dispute_letters`
--

INSERT INTO `dispute_letters` (`id`, `user_id`, `transaction_id`, `round`, `bureau`, `acc_no`, `method`, `sent_date`, `confirm_doc`, `status`, `created`, `modified`) VALUES
(1, 1, 6, 1, 1, '1237275', NULL, '0000-00-00', NULL, 1, '2020-09-24 11:03:00', '2020-09-24 05:33:00'),
(2, 1, 5, 1, 2, '372824672', NULL, '0000-00-00', NULL, 1, '2020-09-24 11:04:18', '2020-09-24 05:34:18'),
(3, 1, 6, 2, 1, '1237275', NULL, '0000-00-00', NULL, 1, '2020-09-25 14:16:14', '2020-09-25 08:46:14');

-- --------------------------------------------------------

--
-- Table structure for table `dispute_master_reasons`
--

CREATE TABLE `dispute_master_reasons` (
  `id` int(11) NOT NULL,
  `subject` text COLLATE utf8_unicode_ci NOT NULL,
  `reason` text COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dispute_master_reasons`
--

INSERT INTO `dispute_master_reasons` (`id`, `subject`, `reason`, `status`, `created`, `modified`) VALUES
(1, 'Incorrect Balance', 'This account is reporting the wrong balance owed.', 1, '0000-00-00 00:00:00', '2020-09-04 13:17:05'),
(2, 'Balance Was Paid', 'I paid off this account but it’s still showing that I owe a balance.', 1, '0000-00-00 00:00:00', '2020-09-04 13:20:41'),
(3, 'Charged Off Balance', 'This account was charged off and I no longer owe money to the creditor but it’s still showing a balance due.', 1, '0000-00-00 00:00:00', '2020-09-04 13:22:45'),
(4, 'Multiple Reporting', 'This debt is being reported multiple times on my credit report.', 1, '0000-00-00 00:00:00', '2020-09-04 13:23:17'),
(5, 'Victim of Identity Theft', 'I am a victim of identity theft and this debt is not mine.', 1, '0000-00-00 00:00:00', '2020-09-04 13:24:49'),
(6, 'I Previously Disputed This', 'I previously disputed this account and it was never verified by the debt collector but it’s still on my credit report.', 1, '0000-00-00 00:00:00', '2020-09-04 13:25:37'),
(7, 'Frivolous Letter', 'I previously disputed this account and don\'t agree with your claim that it\'s frivolous. I provided the reason for my dispute in simple language and you had 30 days to perform an investigation. Because this was not done, please delete this account.', 1, '0000-00-00 00:00:00', '2020-09-04 13:26:15'),
(8, 'Not Prepared By You', 'I previously disputed this account. Your claim that I didn\'t prepare the letter myself is untrue. I personally created and mailed the letter. You had 30 days to investigate my dispute and it wasn\'t done. Please delete this account.', 1, '0000-00-00 00:00:00', '2020-09-04 13:26:46'),
(9, 'No Contract', 'I never had a contract with this debt collector for any debt. Please provide proof from the original creditor that this debt collector owns this debt and has the legal authority to collect it.', 1, '0000-00-00 00:00:00', '2020-09-04 13:27:21'),
(10, 'Custom', '', 1, '0000-00-00 00:00:00', '2020-09-05 11:19:31');

-- --------------------------------------------------------

--
-- Table structure for table `dispute_reasons`
--

CREATE TABLE `dispute_reasons` (
  `id` int(11) NOT NULL,
  `dispute_id` int(11) NOT NULL,
  `dispute_reason_id` int(11) NOT NULL,
  `custom` text COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dispute_reasons`
--

INSERT INTO `dispute_reasons` (`id`, `dispute_id`, `dispute_reason_id`, `custom`, `status`, `created`, `modified`) VALUES
(1, 1, 1, 'This account is reporting the wrong balance owed.', 1, '2020-09-24 11:03:00', '2020-09-24 05:33:00'),
(2, 2, 3, 'This account was charged off and I no longer owe money to the creditor but it’s still showing a balance due.', 1, '2020-09-24 11:04:18', '2020-09-24 05:34:18'),
(3, 3, 7, 'I previously disputed this account and don\'t agree with your claim that it\'s frivolous. I provided the reason for my dispute in simple language and you had 30 days to perform an investigation. Because this was not done, please delete this account.', 1, '2020-09-25 14:16:14', '2020-09-25 08:46:14');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `model_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `model_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_id`, `model_type`) VALUES
(1, 1, 'App\\User'),
(1, 2, 'App\\User');

-- --------------------------------------------------------

--
-- Table structure for table `myfsn_refresh_report`
--

CREATE TABLE `myfsn_refresh_report` (
  `user_id` int(11) NOT NULL,
  `status` text COLLATE utf8_unicode_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `myfsn_refresh_report`
--

INSERT INTO `myfsn_refresh_report` (`user_id`, `status`, `created`) VALUES
(1, '{\"status\":\"FAILED\",\"message\":\"No Free Update Available.\"}', '2020-10-05 10:47:35'),
(1, '{\"status\":\"FAILED\",\"message\":\"No Free Update Available.\"}', '2020-10-05 11:46:53');

-- --------------------------------------------------------

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'users_manage', 'User Mange', '', 'web', '2018-11-05 01:05:55', '2018-11-05 01:05:55'),
(2, 'role-list', 'Role Listing', '', 'web', '2018-11-05 01:15:30', '2018-11-05 01:15:30'),
(3, 'role-create', 'Role Create', '', 'web', '2018-11-05 01:15:40', '2018-11-05 01:15:40'),
(4, 'role-edit', 'Role Edit', '', 'web', '2018-11-05 01:15:54', '2018-11-05 01:15:54'),
(5, 'role-delete', 'Role  Delete', '', 'web', '2018-11-05 01:16:07', '2018-11-05 01:16:07'),
(6, 'item-list', 'Show LIsting', '', 'web', '2018-11-05 01:16:17', '2018-11-05 01:16:17'),
(7, 'item-create', 'Create', '', 'web', '2018-11-05 01:17:15', '2018-11-05 01:17:50'),
(8, 'item-edit', 'Edit', '', 'web', '2018-11-05 01:18:01', '2018-11-05 01:18:01'),
(9, 'item-delete', 'Delete', '', 'web', '2018-11-05 01:18:13', '2018-11-05 01:18:13');

-- --------------------------------------------------------

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` int(11) UNSIGNED NOT NULL,
  `permission_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9);

-- --------------------------------------------------------

--
-- Table structure for table `personal_info`
--

CREATE TABLE `personal_info` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `account_no` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `birth` varchar(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'administrator', 'Admin', 'admin', 'web', '2018-11-05 06:35:55', '2020-02-26 03:01:05'),
(3, 'user', 'test', 'user', 'web', '2020-01-14 08:36:27', '2020-07-07 11:27:44');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(6, 3),
(7, 3),
(8, 3),
(9, 3);

-- --------------------------------------------------------

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1),
(9, 1),
(10, 1),
(3, 1);

-- --------------------------------------------------------

--
-- Table structure for table `security_questions`
--

CREATE TABLE `security_questions` (
  `id` int(11) NOT NULL,
  `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `security_questions`
--

INSERT INTO `security_questions` (`id`, `question`, `status`, `created`, `updated`) VALUES
(1, 'What was your high school mascot?', 1, '0000-00-00 00:00:00', '2020-09-01 11:01:51'),
(2, 'What was your first grade teacher\'s last name?', 1, '0000-00-00 00:00:00', '2020-09-01 11:02:11'),
(3, 'What was the make and model of your first car?', 1, '0000-00-00 00:00:00', '2020-09-01 11:02:35'),
(4, 'What is your mother\'s middle name?', 1, '0000-00-00 00:00:00', '2020-09-01 11:02:54'),
(5, 'What is your father\'s middle name?', 1, '0000-00-00 00:00:00', '2020-09-01 11:03:07'),
(6, 'What city were you born in?', 1, '0000-00-00 00:00:00', '2020-09-01 11:03:21'),
(7, 'What is your grandmother\'s first name (on your mother\'s side)?', 1, '0000-00-00 00:00:00', '2020-09-01 11:03:35'),
(8, 'What is your grandfather\'s first name (on your father\'s side)?', 1, '0000-00-00 00:00:00', '2020-09-01 11:03:47');

-- --------------------------------------------------------

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `state_id` int(11) NOT NULL,
  `state` varchar(22) COLLATE utf8_unicode_ci NOT NULL,
  `state_code` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`state_id`, `state`, `state_code`, `status`) VALUES
(1, 'Alaska', 'AK', 1),
(2, 'Alabama', 'AL', 1),
(3, 'Arkansas', 'AR', 1),
(4, 'Arizona', 'AZ', 1),
(5, 'California', 'CA', 1),
(6, 'Colorado', 'CO', 1),
(7, 'Connecticut', 'CT', 1),
(8, 'District of Columbia', 'DC', 1),
(9, 'Delaware', 'DE', 1),
(10, 'Florida', 'FL', 1),
(11, 'Georgia', 'GA', 1),
(12, 'Hawaii', 'HI', 1),
(13, 'Iowa', 'IA', 1),
(14, 'Idaho', 'ID', 1),
(15, 'Illinois', 'IL', 1),
(16, 'Indiana', 'IN', 1),
(17, 'Kansas', 'KS', 1),
(18, 'Kentucky', 'KY', 1),
(19, 'Louisiana', 'LA', 1),
(20, 'Massachusetts', 'MA', 1),
(21, 'Maryland', 'MD', 1),
(22, 'Maine', 'ME', 1),
(23, 'Michigan', 'MI', 1),
(24, 'Minnesota', 'MN', 1),
(25, 'Missouri', 'MO', 1),
(26, 'Mississippi', 'MS', 1),
(27, 'Montana', 'MT', 1),
(28, 'North Carolina', 'NC', 1),
(29, 'North Dakota', 'ND', 1),
(30, 'Nebraska', 'NE', 1),
(31, 'New Hampshire', 'NH', 1),
(32, 'New Jersey', 'NJ', 1),
(33, 'New Mexico', 'NM', 1),
(34, 'Nevada', 'NV', 1),
(35, 'New York', 'NY', 1),
(36, 'Ohio', 'OH', 1),
(37, 'Oklahoma', 'OK', 1),
(38, 'Oregon', 'OR', 1),
(39, 'Pennsylvania', 'PA', 1),
(40, 'Rhode Island', 'RI', 1),
(41, 'South Carolina', 'SC', 1),
(42, 'South Dakota', 'SD', 1),
(43, 'Tennessee', 'TN', 1),
(44, 'Texas', 'TX', 1),
(45, 'Utah', 'UT', 1),
(46, 'Virginia', 'VA', 1),
(47, 'Vermont', 'VT', 1),
(48, 'Washington', 'WA', 1),
(49, 'Wisconsin', 'WI', 1),
(50, 'West Virginia', 'WV', 1),
(51, 'Wyoming', 'WY', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tradelinesummary`
--

CREATE TABLE `tradelinesummary` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `source_type` int(11) NOT NULL,
  `TotalAccounts` int(11) NOT NULL,
  `OpenAccounts` int(11) NOT NULL,
  `CloseAccounts` int(11) NOT NULL,
  `DelinquentAccounts` int(11) NOT NULL,
  `DerogatoryAccounts` int(11) NOT NULL,
  `TotalBalances` int(11) NOT NULL,
  `TotalMonthlyPayments` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tradelinesummary`
--

INSERT INTO `tradelinesummary` (`id`, `user_id`, `source_type`, `TotalAccounts`, `OpenAccounts`, `CloseAccounts`, `DelinquentAccounts`, `DerogatoryAccounts`, `TotalBalances`, `TotalMonthlyPayments`, `status`, `created`, `modified`) VALUES
(1, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-08-28 17:48:47', '2020-08-28 12:18:47'),
(2, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-08-28 17:48:47', '2020-08-28 12:18:47'),
(3, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-08-28 17:48:47', '2020-08-28 12:18:47'),
(4, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-08-28 17:48:47', '2020-08-28 12:18:47'),
(5, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(6, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(7, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(8, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-02 17:53:39', '2020-09-02 12:23:39'),
(9, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(10, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(11, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(12, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-03 12:01:38', '2020-09-03 06:31:38'),
(13, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(14, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(15, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(16, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-03 12:20:07', '2020-09-03 06:50:07'),
(17, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(18, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(19, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(20, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-03 12:26:25', '2020-09-03 06:56:25'),
(21, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(22, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(23, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(24, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-03 13:59:51', '2020-09-03 08:29:51'),
(25, 1, 3, 11, 1, 10, 0, 10, 47651, 0, 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(26, 1, 2, 9, 2, 7, 0, 8, 42790, 0, 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(27, 1, 1, 9, 9, 0, 0, 8, 42556, 0, 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(28, 1, 0, 11, 9, 0, 0, 10, 47651, 0, 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37');

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `trans_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `subscriberCode` varchar(200) NOT NULL,
  `highBalance` varchar(200) NOT NULL,
  `dateVerified` varchar(255) NOT NULL,
  `dateReported` varchar(255) NOT NULL,
  `dateOpened` varchar(255) NOT NULL,
  `dateAccountStatus` varchar(255) NOT NULL,
  `accountNumber` varchar(255) NOT NULL,
  `currentBalance` varchar(50) NOT NULL,
  `creditorName` varchar(255) NOT NULL,
  `position` varchar(200) NOT NULL,
  `bureau` varchar(200) NOT NULL,
  `AccountCondition_abbreviation` tinytext NOT NULL,
  `AccountCondition_description` tinytext NOT NULL,
  `AccountCondition_symbol` varchar(200) NOT NULL,
  `AccountCondition_rank` varchar(200) NOT NULL,
  `AccountDesignator_abbreviation` tinytext NOT NULL,
  `AccountDesignator_description` tinytext NOT NULL,
  `AccountDesignator_symbol` varchar(200) NOT NULL,
  `AccountDesignator_rank` varchar(200) NOT NULL,
  `DisputeFlag_abbreviation` tinytext NOT NULL,
  `DisputeFlag_description` tinytext NOT NULL,
  `DisputeFlag_symbol` varchar(200) NOT NULL,
  `DisputeFlag_rank` varchar(200) NOT NULL,
  `IndustryCode_abbreviation` tinytext NOT NULL,
  `IndustryCode_description` tinytext NOT NULL,
  `IndustryCode_symbol` varchar(200) NOT NULL,
  `IndustryCode_rank` varchar(200) NOT NULL,
  `OpenClosed_abbreviation` tinytext NOT NULL,
  `OpenClosed_description` tinytext NOT NULL,
  `OpenClosed_symbol` varchar(200) NOT NULL,
  `OpenClosed_rank` varchar(200) NOT NULL,
  `PayStatus_abbreviation` tinytext NOT NULL,
  `PayStatus_description` tinytext NOT NULL,
  `PayStatus_symbol` varchar(200) NOT NULL,
  `PayStatus_rank` varchar(200) NOT NULL,
  `custom_remark` text NOT NULL,
  `remark_abbreviation` text NOT NULL,
  `remark_description` text NOT NULL,
  `remark_symbol` varchar(200) NOT NULL,
  `remark_rank` varchar(200) NOT NULL,
  `VerificationIndicator_abbreviation` tinytext NOT NULL,
  `VerificationIndicator_description` tinytext NOT NULL,
  `VerificationIndicator_symbol` varchar(200) NOT NULL,
  `VerificationIndicator_rank` varchar(200) NOT NULL,
  `GrantedTrade_monthsReviewed` varchar(200) NOT NULL,
  `GrantedTrade_monthlyPayment` varchar(200) NOT NULL,
  `GrantedTrade_late90Count` varchar(200) NOT NULL,
  `GrantedTrade_late60Count` varchar(200) NOT NULL,
  `GrantedTrade_late30Count` varchar(200) NOT NULL,
  `GrantedTrade_termMonths` varchar(200) NOT NULL,
  `GrantedTrade_collateral` varchar(200) NOT NULL,
  `GrantedTrade_amountPastDue` varchar(200) NOT NULL,
  `GrantedTrade_worstPatStatusCount` varchar(200) NOT NULL,
  `AccountType_abbreviation` tinytext NOT NULL,
  `AccountType_description` tinytext NOT NULL,
  `AccountType_symbol` varchar(200) NOT NULL,
  `AccountType_rank` varchar(200) NOT NULL,
  `CreditType_abbreviation` tinytext NOT NULL,
  `CreditType_description` tinytext NOT NULL,
  `CreditType_symbol` varchar(200) NOT NULL,
  `CreditType_rank` varchar(200) NOT NULL,
  `PaymentFrequency_abbreviation` tinytext NOT NULL,
  `PaymentFrequency_description` tinytext NOT NULL,
  `PaymentFrequency_symbol` varchar(200) NOT NULL,
  `PaymentFrequency_rank` varchar(200) NOT NULL,
  `TermType_abbreviation` tinytext NOT NULL,
  `TermType_description` tinytext NOT NULL,
  `TermType_symbol` varchar(200) NOT NULL,
  `TermType_rank` varchar(200) NOT NULL,
  `WorstPayStatus_abbreviation` tinytext NOT NULL,
  `WorstPayStatus_description` tinytext NOT NULL,
  `WorstPayStatus_symbol` varchar(200) NOT NULL,
  `WorstPayStatus_rank` varchar(200) NOT NULL,
  `PayStatusHistory_abbreviation` tinytext NOT NULL,
  `PayStatusHistory_description` tinytext NOT NULL,
  `PayStatusHistory_symbol` varchar(200) NOT NULL,
  `PayStatusHistory_rank` varchar(200) NOT NULL,
  `GrantedTrade_CreditLimit` varchar(200) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`trans_id`, `user_id`, `subscriberCode`, `highBalance`, `dateVerified`, `dateReported`, `dateOpened`, `dateAccountStatus`, `accountNumber`, `currentBalance`, `creditorName`, `position`, `bureau`, `AccountCondition_abbreviation`, `AccountCondition_description`, `AccountCondition_symbol`, `AccountCondition_rank`, `AccountDesignator_abbreviation`, `AccountDesignator_description`, `AccountDesignator_symbol`, `AccountDesignator_rank`, `DisputeFlag_abbreviation`, `DisputeFlag_description`, `DisputeFlag_symbol`, `DisputeFlag_rank`, `IndustryCode_abbreviation`, `IndustryCode_description`, `IndustryCode_symbol`, `IndustryCode_rank`, `OpenClosed_abbreviation`, `OpenClosed_description`, `OpenClosed_symbol`, `OpenClosed_rank`, `PayStatus_abbreviation`, `PayStatus_description`, `PayStatus_symbol`, `PayStatus_rank`, `custom_remark`, `remark_abbreviation`, `remark_description`, `remark_symbol`, `remark_rank`, `VerificationIndicator_abbreviation`, `VerificationIndicator_description`, `VerificationIndicator_symbol`, `VerificationIndicator_rank`, `GrantedTrade_monthsReviewed`, `GrantedTrade_monthlyPayment`, `GrantedTrade_late90Count`, `GrantedTrade_late60Count`, `GrantedTrade_late30Count`, `GrantedTrade_termMonths`, `GrantedTrade_collateral`, `GrantedTrade_amountPastDue`, `GrantedTrade_worstPatStatusCount`, `AccountType_abbreviation`, `AccountType_description`, `AccountType_symbol`, `AccountType_rank`, `CreditType_abbreviation`, `CreditType_description`, `CreditType_symbol`, `CreditType_rank`, `PaymentFrequency_abbreviation`, `PaymentFrequency_description`, `PaymentFrequency_symbol`, `PaymentFrequency_rank`, `TermType_abbreviation`, `TermType_description`, `TermType_symbol`, `TermType_rank`, `WorstPayStatus_abbreviation`, `WorstPayStatus_description`, `WorstPayStatus_symbol`, `WorstPayStatus_rank`, `PayStatusHistory_abbreviation`, `PayStatusHistory_description`, `PayStatusHistory_symbol`, `PayStatusHistory_rank`, `GrantedTrade_CreditLimit`, `status`, `created`, `modified`) VALUES
(1, 1, '0368N5AV', '37281', '2020-04-30', '2020-04-30', '2017-09-12', '2020-04-30', '7572798581', '40621', 'USDOE/GLELSI', '0', '1', 'Open', 'Open', 'O', '60', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Education/Employment', 'Education/Employment', 'E', '199', 'Open', 'Open', 'O', '199', 'Current', 'Current', 'C', '110', '', 'Payment deferred', 'Payment deferred', 'T00PDE', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '31', '0', '0', '0', '0', '0', 'DEFERRED TO 08152020', '0', '31', '31', 'Educational', 'Educational', '50', 'Installment', 'Installment Account', 'I', '20', '', '', '', '100000', 'Provided', 'Provided', 'P', '199', 'Current', 'Current', 'C', '110', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(2, 1, '1132610', '37281', '', '2020-04-30', '2017-09-01', '2020-04-01', '7572798581', '40621', 'US DEPT OF ED/GLELSI', '1', '3', 'Open', 'Open', 'O', '60', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Student Loans', 'Student Loans', 'EL', '199', 'Open', 'Open', 'O', '199', 'Current', 'Current', 'C', '110', '', 'Student loan - payment deferred.', 'Student loan - payment deferred.', 'E0029', '199', '', '', '', '100000', '2', '0', '0', '0', '0', '0', '', '0', '2', '2', 'Educational', 'Educational', '50', 'Installment', 'Installment Account', 'I', '20', '', '', '', '100000', '', '', '', '100000', 'Current', 'Current', 'C', '110', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(3, 1, '668FZ67126', '37281', '', '2020-04-01', '2017-09-01', '2020-04-01', '7572798581', '40621', 'USD/GLELSI', '2', '2', 'Open', 'Open', 'O', '60', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Miscellaneous Finance', 'Miscellaneous Finance', 'FZ', '199', 'Open', 'Open', 'O', '199', 'Current', 'Current', 'C', '110', '', 'Student loan - payment deferred', 'Student loan - payment deferred', 'Q00DQ', '199', '', '', '', '100000', '31', '0', '0', '0', '0', '0', '', '0', '31', '31', 'Educational', 'Educational', '50', 'Installment', 'Installment Account', 'I', '20', '', '', '', '100000', 'Provided', 'Provided', 'P', '199', 'Current', 'Current', 'C', '110', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(4, 1, '3940356', '336', '', '2019-03-30', '2015-01-01', '2016-11-01', '372824672', '336', 'SO CALIF EDISON COMPAN', '3', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Electric Light/Power Companies', 'Electric Light/Power Companies', 'UE', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Account seriously past due date/account assigned to attorney, collection agency, or credit grantor\'s internal collection department.', 'Account seriously past due date/account assigned to attorney, collection agency, or credit grantor\'s internal collection department.', 'XS093', '10000', '', '', '', '100000', '29', '0', '0', '0', '0', '1', '', '336', '29', '29', 'Unknown - credit extension, review, or collection', 'Unknown - credit extension, review, or collection', '100', 'Installment', 'Installment Account', 'I', '20', '', '', '', '100000', '', '', '', '100000', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(5, 1, '180UE00042', '345', '', '2016-11-01', '2015-01-01', '2016-09-01', '372824672', '345', 'SCE', '4', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Electric Light/Power Companies', 'Electric Light/Power Companies', 'UE', '199', 'Open', 'Open', 'O', '199', '120 Delinq', 'Late 120 Days', '4', '102', '', '', '', '', '', '', '', '', '100000', '0', '0', '0', '0', '0', '0', '', '345', '0', '0', 'Collection', 'Collection', '50', 'Open Account', 'Open Account', 'O', '30', '', '', '', '100000', 'Provided', 'Provided', 'P', '199', '120 Delinq', 'Late 120 Days', '4', '102', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(6, 1, '02713001', '134', '2020-05-30', '2020-05-30', '2016-08-16', '2020-05-30', '1237275', '190', 'SW COLL', '5', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(7, 1, '3980157', '134', '', '2020-05-30', '2016-08-01', '2016-08-01', '1237275', '190', 'SOUTHWEST COLLECTION S', '6', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(8, 1, '180YC05507', '134', '', '2020-05-01', '2016-08-01', '2020-05-01', '1237275', '190', '', '7', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Subject has not satisfied debt.', 'Subject has not satisfied debt.', 'QC0D', '10000', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(9, 1, '062LY001', '62', '2020-05-27', '2020-05-27', '2017-07-10', '2020-05-27', '1599499376', '75', 'AWA COLLECT', '8', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(10, 1, '3980885', '62', '', '2020-05-27', '2017-07-01', '2017-07-01', '1599499376', '75', 'AWA COLLECTIONS', '9', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(11, 1, '180YC00000', '62', '', '2020-05-01', '2017-07-01', '2020-05-01', '1599499376', '75', '', '10', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(12, 1, '062LY001', '82', '2020-05-27', '2020-05-27', '2018-01-12', '2020-05-27', '1599622770', '97', 'AWA COLLECT', '11', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(13, 1, '3980885', '82', '', '2020-05-27', '2018-01-01', '2018-01-01', '1599622770', '97', 'AWA COLLECTIONS', '12', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(14, 1, '180YC00000', '82', '', '2020-05-01', '2018-01-01', '2020-05-01', '1599622770', '97', '', '13', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(15, 1, '062LY001', '91', '2020-05-27', '2020-05-27', '2018-08-17', '2020-05-27', '1599737247', '104', 'AWA COLLECT', '14', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(16, 1, '3980885', '91', '', '2020-05-27', '2018-08-01', '2018-08-01', '1599737247', '104', 'AWA COLLECTIONS', '15', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(17, 1, '180YC00000', '91', '', '2020-05-01', '2018-08-01', '2020-05-01', '1599737247', '104', '', '16', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(18, 1, '01Z3L001', '111', '2020-05-25', '2020-05-25', '2017-07-10', '2020-05-25', '9854714', '111', 'TEK COLLECT', '17', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(19, 1, '1985168', '111', '', '2020-05-25', '2017-07-01', '2017-07-01', '9854714', '111', 'TEK-COLLECT INC', '18', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(20, 1, '057XU001', '882', '2020-05-23', '2020-05-23', '2017-05-23', '2020-05-23', '46211025', '882', 'CONVERGENT', '19', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(21, 1, '0980304', '882', '', '2020-05-23', '2017-05-01', '2017-05-01', '46211025', '882', 'CONVERGENT OUTSOURCING', '20', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(22, 1, '701YC00488', '882', '', '2020-05-01', '2017-05-01', '2020-05-01', '46211025', '882', '', '21', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Subject has not satisfied debt.', 'Subject has not satisfied debt.', 'QC0D', '10000', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(23, 1, '01QGH001', '276', '2020-05-05', '2020-05-05', '2018-12-14', '2020-05-05', '581033', '276', 'ALTERN RECOV', '22', '1', 'Derog', 'Derogatory', 'F', '20', 'Joint', 'Joint', 'J', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(24, 1, '3983096', '276', '', '2020-05-05', '2018-12-01', '2018-12-01', '581033', '276', 'ALTERNATIVE RECOVERY M', '23', '3', 'Derog', 'Derogatory', 'F', '20', 'Joint', 'Joint', 'J', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(25, 1, '181YC00000', '276', '', '2020-05-01', '2018-12-01', '2020-05-01', '581033', '276', '', '24', '2', 'Derog', 'Derogatory', 'F', '20', 'Joint', 'Joint', 'J', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(26, 1, '042DF003', '160', '2020-05-04', '2020-05-04', '2018-12-21', '2020-05-04', '1183740959', '200', 'WAKEFIELD', '25', '1', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Collection Services', 'Collection Services', 'Y', '199', 'Open', 'Open', 'O', '199', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', 'Placed for collection', 'Placed for collection', 'T00CLA', '199', 'Account not disputed', 'Account not disputed', 'F', '199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(27, 1, '1810212', '160', '', '2020-05-04', '2018-12-01', '2018-12-01', '1183740959', '200', 'WAKEFIELD & ASSOCIATES', '26', '3', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37'),
(28, 1, '768YC00000', '160', '', '2020-05-01', '2018-12-01', '2020-05-01', '1183740959', '200', '', '27', '2', 'Derog', 'Derogatory', 'F', '20', 'Individual', 'Individual', 'I', '199', 'Account not disputed', 'Account not disputed', 'F', '199', 'Other Collection Agencies', 'Other Collection Agencies', 'YC', '199', 'Closed', 'Closed', 'C', '198', 'Coll/Chargeoff', 'Collection/Chargeoff', '9', '2', '', '', '', '', '', '', '', '', '100000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 0, '2020-09-04 12:00:37', '2020-09-04 06:30:37');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`city_id`),
  ADD KEY `idx_state_code` (`state_code`);

--
-- Indexes for table `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `creditscore`
--
ALTER TABLE `creditscore`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `creditscorefactor`
--
ALTER TABLE `creditscorefactor`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `credit_offer`
--
ALTER TABLE `credit_offer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `credit_plan`
--
ALTER TABLE `credit_plan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dispute_letters`
--
ALTER TABLE `dispute_letters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dispute_master_reasons`
--
ALTER TABLE `dispute_master_reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dispute_reasons`
--
ALTER TABLE `dispute_reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `personal_info`
--
ALTER TABLE `personal_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `security_questions`
--
ALTER TABLE `security_questions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`state_code`),
  ADD UNIQUE KEY `state_id` (`state_id`);

--
-- Indexes for table `tradelinesummary`
--
ALTER TABLE `tradelinesummary`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`trans_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `city_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29739;

--
-- AUTO_INCREMENT for table `city`
--
ALTER TABLE `city`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creditscore`
--
ALTER TABLE `creditscore`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `creditscorefactor`
--
ALTER TABLE `creditscorefactor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217;

--
-- AUTO_INCREMENT for table `credit_offer`
--
ALTER TABLE `credit_offer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `credit_plan`
--
ALTER TABLE `credit_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `dispute_letters`
--
ALTER TABLE `dispute_letters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `dispute_master_reasons`
--
ALTER TABLE `dispute_master_reasons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `dispute_reasons`
--
ALTER TABLE `dispute_reasons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `personal_info`
--
ALTER TABLE `personal_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `security_questions`
--
ALTER TABLE `security_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `tradelinesummary`
--
ALTER TABLE `tradelinesummary`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

