- Code: Select all
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;