· 8 years ago · Jul 11, 2018, 03:04 PM
1drop table if exists city;
2
3create table city
4(
5 city_id mediumint unsigned not null primary key,
6 state_id tinyint(2) unsigned null,
7 name varchar(64) not null
8) engine=InnoDB;
9
10
11drop table if exists city_ft;
12
13create table city_ft
14(
15 city_id mediumint unsigned not null primary key,
16 name varchar(64) not null,
17 fulltext (name)
18) engine=MyIsam;