CREATE TABLE IF NOT EXISTS `plants` (
  `id` int(10) NOT NULL default '0',
  `symbol` varchar(255) NOT NULL default '',
  `scientific` varchar(255) NOT NULL default '',
  `common` varchar(255) NOT NULL default '',
  `family` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `plants`
-- 

INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae');
INSERT INTO `plants` VALUES (2, 'ABGR4', 'Abelia ?grandiflora (Rovelli ex Andr?) Rehd. [chinensis ? uniflora]', 'glossy abelia', 'Caprifoliaceae');
INSERT INTO `plants` VALUES (3, 'ABELM', 'Abelmoschus Medik.', 'okra', 'Malvaceae');
INSERT INTO `plants` VALUES (4, 'ABES', 'Abelmoschus esculentus (L.) Moench', 'okra', 'Malvaceae');