CREATE TABLE `points` ( `id` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL, `description` text NOT NULL, `street` varchar(60) NOT NULL, `city` varchar(60) NOT NULL, `state` varchar(2) NOT NULL, `zip` varchar(5) NOT NULL, `latitude` float NOT NULL, `longitude` float NOT NULL, `zoom` int(11) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;