7m0L3hAv

1create table if not exists `db_tpartner`.`external_ads` (
2     `dspID` int,
3     `adID` int,
4     `hash` int not null,
5     `title` varchar(127),
6     `description` varchar(127),
7     `image` varchar(500),
8     `link` varchar(500),
9     `adm` text,
10     `catID` int,
11     `pageCatID` int,
12     `languageID` int,
13     `type` int,
14     `isMT` tinyint,
15     `isUnsafe` tinyint,
16     `isLayer` tinyint,
17     `isPremium` tinyint,
18     `status` tinyint,
19     `createTime` timestamp,
20     `updateTime` timestamp
21     primary key (`dspID`, `adID`)
22  ) default charset=utf8;
23
24  create index `ext_ads_status_idx`
25    on `db_tpartner`.`external_ads`(`status`)