{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf350
{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww13360\viewh13400\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\ql\qnatural\pardirnatural

\f0\fs24 \cf0  CREATE TABLE `dim_ad` (\
  `ad_key` int(11) NOT NULL AUTO_INCREMENT,\
  `ad_id` varchar(20) DEFAULT NULL,\
  `ad_name` varchar(255) DEFAULT NULL,\
  `ad_text` text,\
  `ad_unit` varchar(10) DEFAULT NULL,\
  `ad_media` varchar(20) DEFAULT NULL,\
  `ad_type` varchar(20) DEFAULT NULL,\
  `ad_url` text,\
  `ad_created` date DEFAULT NULL,\
  `ad_status_id` int(11) DEFAULT NULL,\
  `ad_status_description` varchar(50) DEFAULT NULL,\
  `ad_rss_url` varchar(250) DEFAULT NULL,\
  `ad_rss_status_id` int(11) DEFAULT NULL,\
  `ad_rss_status_description` varchar(50) DEFAULT NULL,\
  `ad_rating` varchar(20) DEFAULT NULL,\
  `ad_campaign_agency_id` int(11) DEFAULT NULL,\
  `ad_campaign_agency_name` varchar(255) DEFAULT NULL,\
  `ad_campaign_id` int(11) DEFAULT NULL,\
  `ad_campaign_name` varchar(255) DEFAULT NULL,\
  `ad_campaign_io_number` varchar(255) DEFAULT NULL,\
  `ad_campaign_created` datetime DEFAULT NULL,\
  `ad_campaign_io_comitted_on` datetime DEFAULT NULL,\
  `ad_campaign_line_id` int(11) DEFAULT NULL,\
  `ad_campaign_line_name` varchar(255) DEFAULT NULL,\
  `ad_campaign_line_created` datetime DEFAULT NULL,\
  `ad_campaign_line_budget` decimal(20,4) DEFAULT NULL,\
  `ad_campaign_line_cpm` decimal(20,4) DEFAULT NULL,\
  `ad_campaign_line_start_time` datetime DEFAULT NULL,\
  `ad_campaign_line_end_time` datetime DEFAULT NULL,\
  `ad_campaign_line_status_id` int(11) DEFAULT NULL,\
  `ad_campaign_line_status_description` varchar(20) DEFAULT NULL,\
  `ad_campaign_line_impressions` int(11) DEFAULT NULL,\
  `ad_campaign_unique_user_cap` int(11) DEFAULT NULL,\
  `use_mob_page` tinyint(4) DEFAULT NULL,\
  `mob_page_id` varchar(20) DEFAULT NULL,\
  `mob_page_title` varchar(64) DEFAULT NULL,\
  `mob_page_name` varchar(64) DEFAULT NULL,\
  `mob_page_text` text,\
  `use_landing_page` tinyint(4) DEFAULT NULL,\
  `landing_page_id` int(11) DEFAULT NULL,\
  `landing_page_title` varchar(50) DEFAULT NULL,\
  `landing_page_name` varchar(255) DEFAULT NULL,\
  `advertiser_id` varchar(20) DEFAULT NULL,\
  `advertiser_email` varchar(250) DEFAULT NULL,\
  `advertiser_owner` varchar(96) DEFAULT NULL,\
  `advertiser_address` varchar(250) DEFAULT NULL,\
  `advertiser_city` varchar(120) DEFAULT NULL,\
  `advertiser_state` varchar(120) DEFAULT NULL,\
  `advertiser_zipcode` varchar(60) DEFAULT NULL,\
  `advertiser_country` varchar(60) DEFAULT NULL,\
  `advertiser_created` date DEFAULT NULL,\
  `advertiser_status_id` int(11) DEFAULT NULL,\
  `advertiser_status_description` varchar(30) DEFAULT NULL,\
  `advertiser_trusted` tinyint(4) DEFAULT NULL,\
  `advertiser_full_serve` tinyint(4) DEFAULT NULL,\
  `advertiser_opt_in` tinyint(4) DEFAULT NULL,\
  `affiliate_id` int(11) DEFAULT NULL,\
  `affiliate_name` varchar(60) DEFAULT NULL,\
  `redirect_affiliate_id` int(11) DEFAULT NULL,\
  `redirect_affiliate_name` varchar(60) DEFAULT NULL,\
  `chnl_download` tinyint(4) DEFAULT NULL,\
  `chnl_community` tinyint(4) DEFAULT NULL,\
  `chnl_entertainment` tinyint(4) DEFAULT NULL,\
  `chnl_news_information` tinyint(4) DEFAULT NULL,\
  `chnl_portals` tinyint(4) DEFAULT NULL,\
  `chnl_mature` tinyint(4) DEFAULT NULL,\
  `chnl_context_search` tinyint(4) DEFAULT NULL,\
  `cat_ringtone` smallint(6) DEFAULT NULL,\
  `cat_news_sports` smallint(6) DEFAULT NULL,\
  `cat_photos_videos` smallint(6) DEFAULT NULL,\
  `cat_chat_community` smallint(6) DEFAULT NULL,\
  `cat_games` smallint(6) DEFAULT NULL,\
  `cat_movie_tv` smallint(6) DEFAULT NULL,\
  `cat_portal_dir` smallint(6) DEFAULT NULL,\
  `cat_communication` smallint(6) DEFAULT NULL,\
  `cat_personals` smallint(6) DEFAULT NULL,\
  `cat_gambling` smallint(6) DEFAULT NULL,\
  `cat_contest` smallint(6) DEFAULT NULL,\
  `parent_ad_id` varchar(20) DEFAULT NULL,\
  `child_ad_id` varchar(20) DEFAULT NULL,\
  `banner_small` tinyint(4) DEFAULT NULL,\
  `banner_medium` tinyint(4) DEFAULT NULL,\
  `banner_large` tinyint(4) DEFAULT NULL,\
  `banner_extra_large` tinyint(4) DEFAULT NULL,\
  `targeting_fee` decimal(10,4) DEFAULT NULL,\
  `targeting_percentage` decimal(5,2) DEFAULT NULL,\
  `targeting_country` varchar(2) DEFAULT NULL,\
  `targeting_region` varchar(3) DEFAULT NULL,\
  `ad_language` varchar(2) DEFAULT NULL,\
  `locale_language` varchar(2) DEFAULT NULL,\
  `locale_country` varchar(2) DEFAULT NULL,\
  `ad_content` text,\
  `ad_hash` varchar(32) DEFAULT NULL,\
  `proc_date` datetime DEFAULT '2000-01-01 00:00:00',\
  `is_current` tinyint(4) DEFAULT '1',\
  `created` datetime DEFAULT NULL,\
  `updated` datetime DEFAULT NULL,\
  PRIMARY KEY (`ad_key`),\
  UNIQUE KEY `dim_ad_uix1` (`ad_id`,`proc_date`),\
  KEY `dim_ad_idx1` (`ad_id`,`ad_key`,`is_current`)\
) ENGINE=InnoDB AUTO_INCREMENT=63872 DEFAULT CHARSET=utf8 \
\
\
CREATE TABLE `dim_handset` (\
  `handset_key` int(11) NOT NULL AUTO_INCREMENT,\
  `brand_name` varchar(128) DEFAULT NULL,\
  `model` varchar(128) DEFAULT NULL,\
  `midp1` tinyint(4) DEFAULT '0',\
  `midp2` tinyint(4) DEFAULT '0',\
  `symbian` tinyint(4) DEFAULT '0',\
  `poly` tinyint(4) DEFAULT '0',\
  `video` tinyint(4) DEFAULT '0',\
  `streaming_vid` tinyint(4) DEFAULT '0',\
  `wap_push` tinyint(4) DEFAULT '0',\
  `mp3` tinyint(4) DEFAULT '0',\
  `wifi` tinyint(4) DEFAULT '0',\
  `is_wireless_device` tinyint(4) DEFAULT NULL,\
  `is_gif_animated` tinyint(4) DEFAULT '0',\
  `is_smartphone` tinyint(4) DEFAULT '0',\
  `user_agent` varchar(255) DEFAULT NULL,\
  `mobile_browser` varchar(255) DEFAULT NULL,\
  `mobile_browser_version` varchar(50) DEFAULT NULL,\
  `xml_id` varchar(128) DEFAULT NULL,\
  `wurfl_id` varchar(50) DEFAULT NULL,\
  `markup_language` varchar(100) DEFAULT NULL,\
  `device_os` varchar(100) DEFAULT NULL,\
  `device_os_version` varchar(50) DEFAULT NULL,\
  `resolution_width` varchar(10) DEFAULT NULL,\
  `resolution_height` varchar(10) DEFAULT NULL,\
  `fallback` varchar(128) DEFAULT NULL,\
  `brand_name_display` varchar(128) DEFAULT NULL,\
  `model_display` varchar(128) DEFAULT NULL,\
  `device_os_display` varchar(128) DEFAULT NULL,\
  `marketing_name` varchar(100) DEFAULT NULL,\
  `model_extra_info` varchar(100) DEFAULT NULL,\
  `load_source` tinyint(4) DEFAULT '0',\
  `is_current` tinyint(4) DEFAULT '1',\
  `is_processed` tinyint(4) DEFAULT '0',\
  `proc_date` datetime DEFAULT '2000-01-01 00:00:00',\
  `created` datetime DEFAULT NULL,\
  `updated` datetime DEFAULT NULL,\
  PRIMARY KEY (`handset_key`),\
  UNIQUE KEY `dim_handset_idx4` (`wurfl_id`,`is_current`),\
  KEY `dim_handset_idx1` (`user_agent`,`handset_key`,`is_current`),\
  KEY `dim_handset_idx2` (`is_processed`,`user_agent`),\
  KEY `dim_handset_idx3` (`brand_name`,`model`,`wurfl_id`,`is_current`,`handset_key`),\
  KEY `dim_handset_idx5` (`model`,`handset_key`)\
) ENGINE=InnoDB AUTO_INCREMENT=3270008 DEFAULT CHARSET=utf8 }