In the QQ inside Loclist.xml extracted out of the foreign country city data

Project to use foreign national City data, everywhere find, and then search QQ inside accidentally found Loclist.xml this thing. So write a script to extract the SQL. Specific loclist.xml files everyone to search your QQ installation directory there is.

This provides the SQL I extracted

The first is the table structure design

Where the identity ID is not set to self-increment

PID is the direct ancestor ID

PIDs for all ancestor ID formats is a string with a comma delimiter (if no ancestor then the ID is its own ID)

Name CNAME alias for country or city is the country or city code

Does child have subordinate 1 for having 0 for no

Childids is a comma-delimited ID string for all subordinate (if no subordinate, the item is its own ID, if any, it has its own ID plus a subordinate ID)

Displayorder for display order

The extract script is written by Python, Python, a little rookie, a gun written out of the code is not put on the script is not intended to optimize if the format does not meet the requirements to write a script you do not have much time

SQL data files and passwords:

Links: Http://share.weiyun.com/aa1e2b9bf74f176dd88f740023e9cbc5 (password: 1123)

If there are errors, please remind them to change

In the QQ inside Loclist.xml extracted out of the foreign country city data