_EL_INFORME_DE_LA_MUERTE.sql

CREATE TABLE IF NOT EXISTS _EL_INFORME_DE_LA_MUERTE (
	CAMPAIGNID    INT UNSIGNED  NOT NULL,
	ADASSETID     INT UNSIGNED  NOT NULL,
	COUNTRY_CODE  CHAR(2)       NOT NULL DEFAULT '',
	CITY_CODE     VARCHAR(50)   NOT NULL DEFAULT '',
	TYPE          ENUM('DISPLAY','CLICK','SALE','POST_VIEW','POST_CLICK'),
	AMOUNT        INT UNSIGNED  NOT NULL DEFAULT 0,
	DATE_SAVE     DATE,
	PRIMARY KEY (CAMPAIGNID, ADASSETID, TYPE, DATE_SAVE)
) ENGINE=MyISAM;