CREATE TABLE core_geoip_city (
id INT(11) NOT NULL AUTO_INCREMENT ,
- name TEXT NOT NULL DEFAULT '',
+ name VARCHAR(255) NOT NULL DEFAULT '',
country_id INT(11) NOT NULL DEFAULT 0,
division_id INT(11) NOT NULL DEFAULT 0,
- postal_code TEXT NOT NULL DEFAULT '',
- metro_code INT(11) NOT NULL DEFAULT 0,
- time_zone TEXT NOT NULL DEFAULT '',
+ postal_code VARCHAR(128) NOT NULL DEFAULT '',
+ metro_code VARCHAR(128) NOT NULL DEFAULT 0,
+ time_zone VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);