Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement