CREATE TABLE IF NOT EXISTS `keitaro_campaigns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alias` varchar(50) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'position',
  `uniqueness_method` varchar(20) NOT NULL DEFAULT 'cookie',
  `cookies_ttl` int(11) NOT NULL DEFAULT '24',
  `action_type` varchar(20) DEFAULT NULL,
  `action_payload` text,
  `action_for_bots` varchar(50) NOT NULL DEFAULT '404',
  `bot_redirect_url` text,
  `bot_text` text,
  `action_tracking_disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `position` int(10) unsigned DEFAULT NULL,
  `state` varchar(50) NOT NULL DEFAULT 'active',
  `updated_at` datetime DEFAULT NULL,
  `mode` varchar(50) DEFAULT 'general',
  `cost_type` varchar(10) DEFAULT 'CPV',
  `cost_value` decimal(10,4) DEFAULT '0.0000',
  `cost_currency` varchar(3) DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `bind_visitors` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `alias` (`alias`),
  KEY `state` (`state`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;