CREATE TABLE core_geoip_continent (
id INT(11) NOT NULL AUTO_INCREMENT ,
- code TEXT NOT NULL DEFAULT '',
- name TEXT NOT NULL DEFAULT '',
+ code VARCHAR(32) NOT NULL DEFAULT '',
+ name VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
-CREATE INDEX code_idx ON core_geoip_country (code) USING BTREE;
-CREATE INDEX name_idx ON core_geoip_country (name) USING BTREE;
+CREATE INDEX code_idx ON core_geoip_continent (code) USING BTREE;
+CREATE INDEX name_idx ON core_geoip_continent (name) USING BTREE;