· 6 years ago · Mar 07, 2019, 03:48 AM
1--
2-- Table structure for table `provincias`
3--
4
5CREATE TABLE IF NOT EXISTS `provincias` (
6 `id` int(2) NOT NULL AUTO_INCREMENT,
7 `provincia` varchar(255) COLLATE latin1_spanish_ci NOT NULL,
8 KEY `id` (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=53 ;
10
11--
12-- Dumping data for table `provincias`
13--
14
15INSERT INTO `provincias` (`id`, `provincia`) VALUES
16(1, 'Ãlava'),
17(2, 'Albacete'),
18(3, 'Alicante'),
19(4, 'AlmerÃa'),
20(5, 'Ãvila'),
21(6, 'Badajoz'),
22(7, 'Baleares (Illes)'),
23(8, 'Barcelona'),
24(9, 'Burgos'),
25(10, 'Cáceres'),
26(11, 'Cádiz'),
27(12, 'Castellón'),
28(13, 'Ciudad Real'),
29(14, 'Córdoba'),
30(15, 'A Coruña'),
31(16, 'Cuenca'),
32(17, 'Girona'),
33(18, 'Granada'),
34(19, 'Guadalajara'),
35(20, 'Guipúzcoa'),
36(21, 'Huelva'),
37(22, 'Huesca'),
38(23, 'Jaén'),
39(24, 'León'),
40(25, 'Lleida'),
41(26, 'La Rioja'),
42(27, 'Lugo'),
43(28, 'Madrid'),
44(29, 'Málaga'),
45(30, 'Murcia'),
46(31, 'Navarra'),
47(32, 'Ourense'),
48(33, 'Asturias'),
49(34, 'Palencia'),
50(35, 'Las Palmas'),
51(36, 'Pontevedra'),
52(37, 'Salamanca'),
53(38, 'Santa Cruz de Tenerife'),
54(39, 'Cantabria'),
55(40, 'Segovia'),
56(41, 'Sevilla'),
57(42, 'Soria'),
58(43, 'Tarragona'),
59(44, 'Teruel'),
60(45, 'Toledo'),
61(46, 'Valencia'),
62(47, 'Valladolid'),
63(48, 'Vizcaya'),
64(49, 'Zamora'),
65(50, 'Zaragoza'),
66(51, 'Ceuta'),
67(52, 'Melilla');