CREATE TABLE share_audience_daily (
  day               date NOT NULL,
  device            text NOT NULL DEFAULT '',
  country           text NOT NULL DEFAULT '',
  clicks            integer NOT NULL DEFAULT 0,
  clicks_suspicious integer NOT NULL DEFAULT 0,
  PRIMARY KEY (day, device, country)
);
CREATE INDEX share_audience_daily_day_idx ON share_audience_daily (day);
