· 8 years ago · Dec 10, 2017, 08:20 AM
1CREATE TABLE IF NOT EXISTS `states` (
2 `name` varchar(20) DEFAULT NULL,
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `visual_basic` varchar(30) DEFAULT NULL,
5 `state_name` int(20) DEFAULT NULL,
6 PRIMARY KEY (`id`),
7 UNIQUE KEY `name` (`name`),
8 UNIQUE KEY `state_name` (`state_name`),
9 UNIQUE KEY `visual_basic` (`visual_basic`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
11
12--
13-- Dumping data for table `states`
14--