--
-- Table structure for table `state`
--

CREATE TABLE `state` (
`state_id` int(11) NOT NULL auto_increment,
`state_name` varchar(50) NOT NULL,
`state_ab` varchar(50) NOT NULL,
PRIMARY KEY (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

--
-- Dumping data for table `state`
--

INSERT INTO `state` VALUES(1, 'Alabama', 'al');
INSERT INTO `state` VALUES(2, 'Alaska', 'ak');
INSERT INTO `state` VALUES(3, 'Arizona', 'az');
INSERT INTO `state` VALUES(4, 'Arkansas', 'ar');
INSERT INTO `state` VALUES(5, 'California', 'ca');
INSERT INTO `state` VALUES(6, 'Colorado', 'co');
INSERT INTO `state` VALUES(7, 'Connecticut', 'ct');
INSERT INTO `state` VALUES(8, 'Delaware', 'de');
INSERT INTO `state` VALUES(9, 'Florida', 'fl');
INSERT INTO `state` VALUES(10, 'Georgia', 'ga');
INSERT INTO `state` VALUES(11, 'Hawaii', 'hi');
INSERT INTO `state` VALUES(12, 'Idaho', 'id');
INSERT INTO `state` VALUES(13, 'llinois', 'il');
INSERT INTO `state` VALUES(14, 'Indiana', 'in');
INSERT INTO `state` VALUES(15, 'Iowa', 'ia');
INSERT INTO `state` VALUES(16, 'Kansas', 'ks');
INSERT INTO `state` VALUES(17, 'Kentucky', 'ky');
INSERT INTO `state` VALUES(18, 'Louisiana', 'la');
INSERT INTO `state` VALUES(19, 'Maine', 'me');
INSERT INTO `state` VALUES(20, 'Maryland', 'md');
INSERT INTO `state` VALUES(21, 'Massachusetts', 'ma');
INSERT INTO `state` VALUES(22, 'Michigan', 'mi');
INSERT INTO `state` VALUES(23, 'Minnesota', 'mn');
INSERT INTO `state` VALUES(24, 'Mississippi', 'ms');
INSERT INTO `state` VALUES(25, 'Missouri', 'mo');
INSERT INTO `state` VALUES(26, 'Montana', 'mt');
INSERT INTO `state` VALUES(27, 'Nebraska', 'ne');
INSERT INTO `state` VALUES(28, 'Nevada', 'nv');
INSERT INTO `state` VALUES(29, 'New Hampshire', 'nh');
INSERT INTO `state` VALUES(30, 'New Jersey', 'nj');
INSERT INTO `state` VALUES(31, 'New Mexico', 'nm');
INSERT INTO `state` VALUES(32, 'New York', 'ny');
INSERT INTO `state` VALUES(33, 'North Carolina', 'nc');
INSERT INTO `state` VALUES(34, 'North Dakota', 'nd');
INSERT INTO `state` VALUES(35, 'Ohio', 'oh');
INSERT INTO `state` VALUES(36, 'Oklahoma', 'ok');
INSERT INTO `state` VALUES(37, 'Oregon', 'or');
INSERT INTO `state` VALUES(38, 'Pennsylvania', 'pa');
INSERT INTO `state` VALUES(39, 'Rhode Island', 'ri');
INSERT INTO `state` VALUES(40, 'South Carolina', 'sc');
INSERT INTO `state` VALUES(41, 'South Dakota', 'sd');
INSERT INTO `state` VALUES(42, 'Tennessee', 'tn');
INSERT INTO `state` VALUES(43, 'Texas', 'tx');
INSERT INTO `state` VALUES(44, 'Utah', 'ut');
INSERT INTO `state` VALUES(45, 'Vermont', 'vt');
INSERT INTO `state` VALUES(46, 'Virginia', 'va');
INSERT INTO `state` VALUES(47, 'Washington', 'wa');
INSERT INTO `state` VALUES(48, 'West Virginia', 'wv');
INSERT INTO `state` VALUES(49, 'Wisconsin', 'wi');
INSERT INTO `state` VALUES(50, 'Wyoming', 'wy');

Advertisements