   KEY `expires` (`expires`)
 ) 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),
-  `file` varchar(50) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY (`code`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
 DROP TABLE IF EXISTS `cm_splitfeature`;
+
 
 CREATE TABLE `cm_splitfeature` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,


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,


CREATE TABLE `cm_splittestVariation_fixture` (
  `splittestId` int(10) unsigned NOT NULL,
  `clientId` int(10) unsigned DEFAULT NULL,
  `userId` int(10) unsigned DEFAULT NULL,
  `variationId` int(10) unsigned NOT NULL,
  `createStamp` int(10) unsigned NOT NULL,
  `conversionWeight` decimal(10,2) NOT NULL DEFAULT '1.00',
  `conversionStamp` int(11) DEFAULT NULL,
  UNIQUE KEY `user` (`userId`,`splittestId`),
  UNIQUE KEY `client` (`clientId`,`splittestId`),
  KEY `splittestId` (`splittestId`),
  KEY `conversionStamp` (`conversionStamp`),
  KEY `createStamp` (`createStamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `cm_streamChannel`;
