CREATE DATABASE /*!32312 IF NOT EXISTS*/ `bot_db` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `bot_db`;

CREATE TABLE /*!32312 IF NOT EXISTS*/ `plugin_localisation` (
  `id` int(11) unsigned NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `countrycode` char(2) NOT NULL default '',
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;