set global innodb_large_prefix=1;
set global innodb_file_format=BARRACUDA;
-- auto-generated definition
create table xxx_term
(
id int auto_increment
primary key,
name varchar(255) default '' not null,
source_url varchar(500) default '' not null,
domain varchar(128) default '' not null,
default_url varchar(500) default '' not null,
description longtext null,
faq longtext null,
org_term_img varchar(500) default '' not null,
create_time int default 0 not null,
update_time int default 0 not null,
country varchar(32) default '' not null,
lang varchar(32) default '' not null,
first_letter varchar(8) default '' not null,
constraint term_url_uindex
unique (source_url)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;