CREATE TABLE `school` (
`id` int(11) NOT NULL auto_increment,
`state` int(11) NOT NULL,
`name` varchar(255) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7263 ;
INSERT INTO `school` (`id`, `state`, `name`) VALUES
(1, 1, 'Alabama Agricultural and Mechanical University'),
(2, 1, 'Alabama Southern Community College'),
(3, 1, 'Alabama State College of Barber Styling'),
(4, 1, 'Alabama State University'),
(5, 1, 'American College of Computer and Information Sciences'),
(6, 1, 'American Sentinel University'),
(7, 1, 'Andrew Jackson University'),
(8, 1, 'Athens State University'),
(9, 1, 'Auburn University'),
(10, 1, 'Auburn University Main'),
(11, 1, 'Auburn University at Montgomery'),
(12, 1, 'Bessemer State Technical College'),
(13, 1, 'Bevill State Community College'),
(14, 1, 'Birmingham-Southern College'),
(15, 1, 'Bishop State Community College'),
(16, 1, 'Blue Cliff Career College'),
(17, 1, 'Calhoun Community College'),
(18, 1, 'Capps College'),
(19, 1, 'Capps College: Foley'),
(20, 1, 'Central Alabama Community College'),
(21, 1, 'Chattahoochee Valley Community College'),
...
(84, 1, 'University of Alabama System Office'),
(85, 1, 'University of Alabama at Birmingham'),
(86, 1, 'University of Alabama in Huntsville'),
(87, 1, 'University of Mobile'),
(88, 1, 'University of Montevallo'),
(89, 1, 'University of North Alabama'),
(90, 1, 'University of South Alabama'),
(91, 1, 'University of West Alabama'),
(92, 1, 'Virginia College'),
(93, 1, 'Virginia College Technical'),
(94, 1, 'Virginia College at Huntsville'),
(95, 1, 'Virginia College at Mobile'),
(96, 1, 'Virginia College: Huntsville'),
(97, 1, 'Wallace State Community College at Hanceville'),
(98, 2, 'Alaska Bible College'),
(99, 2, 'Alaska Pacific University'),
(100, 2, 'Alaska Vocational Technical Center');
CREATE TABLE `state` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(32) collate latin1_general_ci NOT NULL,
`short` varchar(8) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=52 ;
INSERT INTO `state` (`id`, `name`, `short`) VALUES
(1, 'Alabama', 'AL'),
(2, 'Alaska', 'AK'),
(3, 'Arizona', 'AZ'),
(4, 'Arkansas', 'AR'),
(5, 'California', 'CA'),
(6, 'Colorado', 'CO'),
(7, 'Connecticut', 'CT'),
...
(48, 'Washington', 'WA'),
(49, 'West Virginia', 'WV'),
(50, 'Wisconsin', 'WI'),
(51, 'Wyoming', 'WY');
].
