Greetings
I understand that in the case of the regions depends on having accurate information from each country, but nowhere I can't enter the regions, I suppose it should bring information in Liferay.
In my case I give my grain of sand and make a list of all regions of the country I live in Venezuela.
Image:
List of Regions (in Venezuela are states):
UPDATE - SQL Statements for Venezuela (region code - ISO 3166-2
E)
I understand that in the case of the regions depends on having accurate information from each country, but nowhere I can't enter the regions, I suppose it should bring information in Liferay.
In my case I give my grain of sand and make a list of all regions of the country I live in Venezuela.
Image:
List of Regions (in Venezuela are states):
- Amazonas
- Anzoátegui
- Apure
- Aragua
- Barinas
- Bolívar
- Carabobo
- Cojedes
- Delta Amacuro
- Distrito Capital
- Falcón
- Guárico
- Lara
- Mérida
- Miranda
- Monagas
- Nueva Esparta
- Portuguesa
- Sucre
- Táchira
- Trujillo
- Vargas
- Yaracuy
- Zulia
UPDATE - SQL Statements for Venezuela (region code - ISO 3166-2
E)insert into Region (regionId, countryId, regionCode, name, active_) values (222001, 222, 'VE-X', 'Amazonas', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222002, 222, 'VE-B', 'Anzoátegui', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222003, 222, 'VE-C', 'Apure', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222004, 222, 'VE-D', 'Aragua', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222005, 222, 'VE-E', 'Barinas', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222006, 222, 'VE-F', 'Bolívar', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222007, 222, 'VE-G', 'Carabobo', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222008, 222, 'VE-H', 'Cojedes', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222009, 222, 'VE-Y', 'Delta Amacuro', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222010, 222, 'VE-Z', 'Dependencias Federales', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222011, 222, 'VE-A', 'Distrito Capital', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222012, 222, 'VE-I', 'Falcón', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222013, 222, 'VE-J', 'Guárico', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222014, 222, 'VE-K', 'Lara', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222015, 222, 'VE-L', 'Mérida', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222016, 222, 'VE-M', 'Miranda', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222017, 222, 'VE-N', 'Monagas', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222018, 222, 'VE-O', 'Nueva Esparta', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222019, 222, 'VE-P', 'Portuguesa', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222020, 222, 'VE-R', 'Sucre', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222021, 222, 'VE-S', 'Táchira', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222022, 222, 'VE-T', 'Trujillo', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222023, 222, 'VE-W', 'Vargas', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222024, 222, 'VE-U', 'Yaracuy', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (222025, 222, 'VE-V', 'Zulia', 1);