7UWvzDfM

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