tVcZqXAd

1-- real city table
2drop table if exists city;
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
11-- full text city table which id do fulltext searches on then use the city_id to link back into my innodb tables
12drop table if exists city_ft;
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;