| id |
int(11)
|
|
|
|
| cid |
int(11)
|
|
|
|
| type |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| alias |
varchar(400)
|
utf8mb4_bin
|
|
|
| imptotal |
int(11)
|
|
|
|
| impmade |
int(11)
|
|
|
|
| clicks |
int(11)
|
|
|
|
| clickurl |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| state |
tinyint(4)
|
|
|
|
| catid |
int(10)
|
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| custombannercode |
varchar(2048)
|
utf8mb4_unicode_ci
|
|
|
| sticky |
tinyint(3)
|
|
|
|
| ordering |
int(11)
|
|
|
|
| metakey |
text
|
utf8mb4_unicode_ci
|
|
|
| params |
text
|
utf8mb4_unicode_ci
|
|
|
| own_prefix |
tinyint(4)
|
|
|
|
| metakey_prefix |
varchar(400)
|
utf8mb4_unicode_ci
|
|
|
| purchase_type |
tinyint(4)
|
|
|
|
| track_clicks |
tinyint(4)
|
|
|
|
| track_impressions |
tinyint(4)
|
|
|
|
| checked_out |
int(10)
|
|
|
|
| checked_out_time |
datetime
|
|
|
|
| publish_up |
datetime
|
|
|
|
| publish_down |
datetime
|
|
|
|
| reset |
datetime
|
|
|
|
| created |
datetime
|
|
|
|
| language |
char(7)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(10)
|
|
|
|
| created_by_alias |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| modified |
datetime
|
|
|
|
| modified_by |
int(10)
|
|
|
|
| version |
int(10)
|
|
|
|