DB:Auth:1p2nationcountries 548

Back to auth database list of tables.

The `ip2nationcountries` table

These tables allow to see approximately which country a player might be from when doing .pinfo <player> command.

They are not mantained by the ProjectSkyfire development team and they require external data to perform their function, which can be found at http://www.ip2nation.com/ip2nation/Download

NOTE IF YOU EXPORT THIS DATABASE FROM WINDOWS ENVIROMENT AND IMPORT IT ON LINUX YOU WILL HAVE STARTUP ERROR BECAUSE ip2nationCountries WILL BE RENAMED TO ip2nationcountries IMPORT IT AGAIN FROM IP2NATION WEBPAGE TO FIX IT.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
code	int			NO	0
iso_code_2	char(2)			NO
iso_code_3	char(2)			NO
iso_country	char(2)			NO
country	char(2)			NO
lat	char(2)			NO
lon	char(2)			NO

DB Structure

CREATE TABLE `ip2nationcountries`  (
  `code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `iso_code_2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `iso_code_3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `iso_country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `lat` float NOT NULL DEFAULT 0,
  `lon` float NOT NULL DEFAULT 0,
  PRIMARY KEY (`code`) USING BTREE,
  INDEX `code`(`code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

Description of the fields

code

Please Define

so_code_2

Please Define

iso_code_3

Please Define

iso_country

Please Define

country

Please Define

lat

Please Define

lon

Please Define