CREATE TABLE IF NOT EXISTS `users_test` (
  `division` enum('District of Alaska - Ketchikan','District of Alaska - Nome','District of Alaska - Fairbanks','District of Alaska - Juneau','District of Alaska - Anchorage','District of Arizona - Tucson','District of Arizona - Phoenix','District of Arizona - Yuma','Eastern District of Arkansas - Batesville','Eastern District of Arkansas - Helena','Eastern District of Arkansas - Pine Bluff','Eastern District of Arkansas - Little Rock','Eastern District of Arkansas - Jonesboro','Western District of Arkansas - Texarkana','Western District of Arkansas - Harrison','Western District of Arkansas - Ft. Smith','Western District of Arkansas - Eldorado','Western District of Arkansas - Hot Springs','Western District of Arkansas - Fayetteville','Central District of California - San Fernando Valley','Central District of California - Los Angeles','Central District of California - Riverside','Central District of California - Santa Ana','Central District of California - Northern Division','Eastern District of California - Sacramento','Eastern District of California - Fresno','Eastern District of California - Modesto','Northern District of California - San Jose','Northern District of California - San Francisco','Northern District of California - Oakland','Northern District of California - Santa Rosa','Southern District of California - San Diego','District of Colorado - Denver','District of Connecticut - Hartford','District of Connecticut - New Haven','District of Connecticut - Bridgeport','District of Columbia - Washington, DC','District of Delaware - Wilmington','Middle District of Florida - Fort Myers','Middle District of Florida - Orlando','Middle District of Florida - Jacksonville','Middle District of Florida - Tampa','Northern District of Florida - Gainesville','Northern District of Florida - Tallahassee','Northern District of Florida - Pensacola','Northern District of Florida - Panama City','Southern District of Florida - West Palm Beach','Southern District of Florida - Fort Lauderdale','Southern District of Florida - Miami','Middle District of Georgia - Macon','Middle District of Georgia - Thomasville','Middle District of Georgia - Valdosta','Middle District of Georgia - Albany','Middle District of Georgia - Americus','Middle District of Georgia - Athens','Middle District of Georgia - Columbus','Northern District of Georgia - Gainesville','Northern District of Georgia - Atlanta','Northern District of Georgia - Rome','Northern District of Georgia - Newnan','Southern District of Georgia - Dublin','Southern District of Georgia - Savannah','Southern District of Georgia - Waycross','Southern District of Georgia - Statesboro','Southern District of Georgia - Augusta','Southern District of Georgia - Brunswick','District of Guam - Guam','District of Hawaii - Honolulu','District of Idaho - Moscow','District of Idaho - Pocatello','District of Idaho - Twin Falls','District of Idaho - Coeur D`Alene','District of Idaho - Boise','Central District of Illinois - Springfield','Central District of Illinois - Peoria','Central District of Illinois - Danville','Northern District of Illinois - Rockford/Sterling','Northern District of Illinois - Chicago','Southern District of Illinois - Effingham','Southern District of Illinois - Alton','Southern District of Illinois - Benton','Southern District of Illinois - East St. Louis','Northern District of Indiana - Hammond at Lafayette','Northern District of Indiana - South Bend','Northern District of Indiana - Ft. Wayne','Northern District of Indiana - Hammond','Southern District of Indiana - Evansville','Southern District of Indiana - New Albany','Southern District of Indiana - Indianapolis','Southern District of Indiana - Terre Haute','Northern District of Iowa - Cedar Rapids','Northern District of Iowa - Dubuque','Northern District of Iowa - Fort Dodge','Northern District of Iowa - Mason City','Northern District of Iowa - Sioux City','Northern District of Iowa - Waterloo','Southern District of Iowa - Council Bluffs','Southern District of Iowa - Davenport','Southern District of Iowa - Des Moines','District of Kansas - Wichita','District of Kansas - Topeka','District of Kansas - Kansas City','Eastern District of Kentucky - Covington','Eastern District of Kentucky - Ashland','Eastern District of Kentucky - Frankfort','Eastern District of Kentucky - London','Eastern District of Kentucky - Lexington','Eastern District of Kentucky - Pikeville','Western District of Kentucky - Louisville','Western District of Kentucky - Owensboro','Western District of Kentucky - Paducah','Western District of Kentucky - Bowling Green','Western District of Louisiana - Shreveport','Western District of Louisiana - Monroe','Western District of Louisiana - Lafayette','Western District of Louisiana - Lake Charles','Western District of Louisiana - Alexandria','Eastern District of Louisiana - New Orleans','Middle District of Louisiana - Baton Rouge','District of Maine - Bangor','District of Maine - Portland','District of Maryland - Greenbelt','District of Maryland - Baltimore','District of Massachusetts - Worcester','District of Massachusetts - Boston','Eastern District of Michigan - Bay City','Eastern District of Michigan - Detroit','Eastern District of Michigan - Flint','Western District of Michigan - Marquette','Western District of Michigan - Grand Rapids','District of Minnesota - St. Paul','District of Minnesota - Minneapolis','District of Minnesota - Fergus Falls','District of Minnesota - Duluth','Northern District of Mississippi - Aberdeen','Southern District of Mississippi - Jackson','Southern District of Mississippi - Gulfport','Eastern District of Missouri - Hannibal','Eastern District of Missouri - Cape Girardeau','Eastern District of Missouri - St. Louis','Western District of Missouri - Kansas City','Western District of Missouri - Joplin','Western District of Missouri - Springfield','Western District of Missouri - St. Joseph','Western District of Missouri - Jefferson City','District of Montana - Great Falls','District of Montana - Billings','District of Montana - Butte','District of Nebraska - Lincoln','District of Nebraska - Omaha','District of Nevada - Reno','District of Nevada - Las Vegas','District of New Hampshire - Manchester','District of New Jersey - Atlantic City','District of New Jersey - Trenton','District of New Jersey - Camden','District of New Jersey - Newark','District of New Mexico - Albuquerque','Eastern District of New York - Central Islip','Eastern District of New York - Brooklyn','Northern District of New York - Albany','Northern District of New York - Utica','Northern District of New York - Syracuse','Southern District of New York - Manhattan','Southern District of New York - White Plains','Southern District of New York - Poughkeepsie','Western District of New York - Rochester','Western District of New York - Buffalo','District of North Dakota - North Dakota','District of Northern Mariana Islands - Saipan','Northern District of Ohio - Akron','Northern District of Ohio - Canton','Northern District of Ohio - Youngstown','Northern District of Ohio - Toledo','Northern District of Ohio - Cleveland','Southern District of Ohio - Cincinnati','Southern District of Ohio - Columbus','Southern District of Ohio - Dayton','Eastern District of Oklahoma - Okmulgee','Northern District of Oklahoma - Tulsa','Western District of Oklahoma - Oklahoma City','District of Oregon - Portland','District of Oregon - Eugene','Eastern District of Pennsylvania - Philadelphia','Eastern District of Pennsylvania - Reading','Middle District of Pennsylvania - Harrisburg','Middle District of Pennsylvania - Wilkes-Barre','Western District of Pennsylvania - Pittsburgh','Western District of Pennsylvania - Erie','Western District of Pennsylvania - Johnston','District of Puerto Rico - Hato Rey','District of Rhode Island - Providence','District of South Carolina - Columbia','District of South Dakota - Rapid City','District of South Dakota - Sioux Falls','District of South Dakota - Pierre','District of South Dakota - Aberdeen','Eastern District of Tennessee - Greenville','Eastern District of Tennessee - Chattanooga','Eastern District of Tennessee - Knoxville','Middle District of Tennessee - Cookville','Middle District of Tennessee - Columbia','Middle District of Tennessee - Nashville','Western District of Tennessee - Jackson','Western District of Tennessee - Memphis','Eastern District of Texas - Marshall','Eastern District of Texas - Beaumont','Eastern District of Texas - Lufkin','Eastern District of Texas - Tyler','Eastern District of Texas - Texarkana','Eastern District of Texas - Sherman','Eastern District of Texas - Paris','Northern District of Texas - Wichita Falls','Northern District of Texas - San Angelo','Northern District of Texas - Lubbock','Northern District of Texas - Ft. Worth','Northern District of Texas - Dallas','Northern District of Texas - Amarillo','Northern District of Texas - Abilene','Southern District of Texas - McAllen','Southern District of Texas - Laredo','Southern District of Texas - Victoria','Southern District of Texas - Galveston','Southern District of Texas - Houston','Southern District of Texas - Brownsville','Southern District of Texas - Corpus Christi','Western District of Texas - Midland - Odessa','Western District of Texas - San Antonio','Western District of Texas - Waco','Western District of Texas - El Paso','Western District of Texas - Austin','District of Utah - Salt Lake City','District of Vermont - Rutland','Eastern District of Virginia - Richmond','Eastern District of Virginia - Newport News','Eastern District of Virginia - Alexandria','Eastern District of Virginia - Norfolk','Western District of Virginia - Roanoke','Western District of Virginia - Lynchburg','Western District of Virginia - Harrisonburg','District of Virgin Islands - St. Thomas','District of Virgin Islands - St. Croix','Eastern District of Washington - Spokane','Eastern District of Washington - Yakima','Western District of Washington - Tacoma','Western District of Washington - Seattle','Northern District of West Virginia - Wheeling','Northern District of West Virginia - Martinsburg','Northern District of West Virginia - Elkins','Northern District of West Virginia - Clarksburg','Southern District of West Virginia - Parkersburg','Southern District of West Virginia - Beckley','Southern District of West Virginia - Huntington','Southern District of West Virginia - Bluefield','Southern District of West Virginia - Charleston','Eastern District of Wisconsin - Milwaukee','Western District of Wisconsin - Madison','Western District of Wisconsin - Rothschild','Western District of Wisconsin - Lacrosse','Western District of Wisconsin - Eau Claire/Superior','District of Wyoming - Cheyenne','District of Wyoming - Casper') DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;