 DROP TABLE IF EXISTS `cm_tmp_location`;
 
 
-CREATE TABLE IF NOT EXISTS `cm_tmp_location` (
+CREATE TABLE `cm_tmp_location` (
   `level` tinyint(4) NOT NULL,
   `id` int(10) unsigned NOT NULL,
   `1Id` int(10) unsigned DEFAULT NULL,


DROP TABLE IF EXISTS `cm_tmp_location_coordinates`;

CREATE TABLE IF NOT EXISTS `cm_tmp_location_coordinates` (
  `level` tinyint(4) NOT NULL,
  `id` int(10) unsigned NOT NULL,
  `coordinates` point NOT NULL,

  KEY `create_time` (`create_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `cm_emoticon`;


CREATE TABLE `cm_emoticon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `codeAdditional` varchar(50) DEFAULT NULL,
  `file` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `cm_ipBlocked`;


