bring back my counrty list

Hi,

I erased all the countries from my Predefined Values and now I want them back. How do I do this? Or does anyone have the list with the abbreviations? 

Thanks!

Hello!

Every Dolphin package has folder install/sql/v70.sql (or v71.sql) file. Enter to ur database via DB management tool like phpMyAdmin, choose ur actual Dolphin DB and then open this file via any text editor. Find there lines like:

INSERT INTO `sys_pre_values` VALUES
('Country', 'AF', 1, '__Afghanistan', '', '', '', '', ''),

and select all text below till then next lines completely:

('Country', 'ZM', 245, '__Zambia', '', '', '', '', ''),
('Country', 'ZW', 246, '__Zimbabwe', '', '', '', '', '');

copy and paste this text to "SQL" window of phpMyAdmin and press "Go" button.

Then enter as Dolphin admin and clear caches.

Regards