Login   Register  
PHP Classes
elePHPant
Icontem

File: dados.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Gilberto Albino  >  PDO Pagination  >  dados.sql  >  Download  
File: dados.sql
Role: Auxiliary data
Content type: text/plain
Description: This file contains the data used in the test
Class: PDO Pagination
Display query results split in pages using PDO
Author: By
Last change: Changed the charset
Date: 5 years ago
Size: 10,037 bytes
 

Contents

Class file image Download
--
-- Crie o seu banco de dados, no exemplo foi usado "teste"
--

--
-- Estrutura da tabela `paises`
--

CREATE TABLE IF NOT EXISTS `paises` (
  `status` smallint(1) NOT NULL,
  `iso` char(2) collate utf8_swedish_ci NOT NULL,
  `iso3` char(3) collate utf8_swedish_ci NOT NULL,
  `numero` smallint(6) default NULL,
  `nome` varchar(255) collate utf8_swedish_ci NOT NULL,
  PRIMARY KEY  (`iso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;

--
-- Extraindo dados da tabela `paises`
--

INSERT INTO `paises` (`status`, `iso`, `iso3`, `numero`, `nome`) VALUES
(1, 'AF', 'AFG', 4, 'Afeganistão'),
(1, 'ZA', 'ZAF', 710, 'África do Sul'),
(1, 'AX', 'ALA', 248, 'Åland, Ilhas'),
(1, 'AL', 'ALB', 8, 'Albânia'),
(1, 'DE', 'DEU', 276, 'Alemanha'),
(1, 'AD', 'AND', 20, 'Andorra'),
(1, 'AO', 'AGO', 24, 'Angola'),
(1, 'AI', 'AIA', 660, 'Anguilla'),
(1, 'AQ', 'ATA', 10, 'Antárctida'),
(1, 'AG', 'ATG', 28, 'Antigua e Barbuda'),
(1, 'AN', 'ANT', 530, 'Antilhas Holandesas'),
(1, 'SA', 'SAU', 682, 'Arábia Saudita'),
(1, 'DZ', 'DZA', 12, 'Argélia'),
(1, 'AR', 'ARG', 32, 'Argentina'),
(1, 'AM', 'ARM', 51, 'Arménia'),
(1, 'AW', 'ABW', 533, 'Aruba'),
(1, 'AU', 'AUS', 36, 'Austrália'),
(1, 'AT', 'AUT', 40, 'Áustria'),
(1, 'AZ', 'AZE', 31, 'Azerbeijão'),
(1, 'BS', 'BHS', 44, 'Bahamas'),
(1, 'BH', 'BHR', 48, 'Bahrain'),
(1, 'BD', 'BGD', 50, 'Bangladesh'),
(1, 'BB', 'BRB', 52, 'Barbados'),
(1, 'BE', 'BEL', 56, 'Bélgica'),
(1, 'BZ', 'BLZ', 84, 'Belize'),
(1, 'BJ', 'BEN', 204, 'Benin'),
(1, 'BM', 'BMU', 60, 'Bermuda'),
(1, 'BY', 'BLR', 112, 'Bielo-Rússia'),
(1, 'BO', 'BOL', 68, 'Bolívia'),
(1, 'BA', 'BIH', 70, 'Bósnia-Herzegovina'),
(1, 'BW', 'BWA', 72, 'Botswana'),
(1, 'BV', 'BVT', 74, 'Bouvet, Ilha'),
(1, 'BR', 'BRA', 76, 'Brasil'),
(1, 'BN', 'BRN', 96, 'Brunei'),
(1, 'BG', 'BGR', 100, 'Bulgária'),
(1, 'BF', 'BFA', 854, 'Burkina Faso'),
(1, 'BI', 'BDI', 108, 'Burundi'),
(1, 'BT', 'BTN', 64, 'Butão'),
(1, 'CV', 'CPV', 132, 'Cabo Verde'),
(1, 'KH', 'KHM', 116, 'Cambodja'),
(1, 'CM', 'CMR', 120, 'Camarões'),
(1, 'CA', 'CAN', 124, 'Canadá'),
(1, 'KY', 'CYM', 136, 'Cayman, Ilhas'),
(1, 'KZ', 'KAZ', 398, 'Cazaquistão'),
(1, 'CF', 'CAF', 140, 'Centro-africana, República'),
(1, 'TD', 'TCD', 148, 'Chade'),
(1, 'CZ', 'CZE', 203, 'Checa, República'),
(1, 'CL', 'CHL', 152, 'Chile'),
(1, 'CN', 'CHN', 156, 'China'),
(1, 'CY', 'CYP', 196, 'Chipre'),
(1, 'CX', 'CXR', 162, 'Christmas, Ilha'),
(1, 'CC', 'CCK', 166, 'Cocos, Ilhas'),
(1, 'CO', 'COL', 170, 'Colômbia'),
(1, 'KM', 'COM', 174, 'Comores'),
(1, 'CG', 'COG', 178, 'Congo, República do'),
(1, 'CD', 'COD', 180, 'Congo, República Democrática do (antigo Zaire)'),
(1, 'CK', 'COK', 184, 'Cook, Ilhas'),
(1, 'KR', 'KOR', 410, 'Coreia do Sul'),
(1, 'KP', 'PRK', 408, 'Coreia, República Democrática da (Coreia do Norte)'),
(1, 'CI', 'CIV', 384, 'Costa do Marfim'),
(1, 'CR', 'CRI', 188, 'Costa Rica'),
(1, 'HR', 'HRV', 191, 'Croácia'),
(1, 'CU', 'CUB', 192, 'Cuba'),
(1, 'DK', 'DNK', 208, 'Dinamarca'),
(1, 'DJ', 'DJI', 262, 'Djibouti'),
(1, 'DM', 'DMA', 212, 'Dominica'),
(1, 'DO', 'DOM', 214, 'Dominicana, República'),
(1, 'EG', 'EGY', 818, 'Egipto'),
(1, 'SV', 'SLV', 222, 'El Salvador'),
(1, 'AE', 'ARE', 784, 'Emiratos Árabes Unidos'),
(1, 'EC', 'ECU', 218, 'Equador'),
(1, 'ER', 'ERI', 232, 'Eritreia'),
(1, 'SK', 'SVK', 703, 'Eslováquia'),
(1, 'SI', 'SVN', 705, 'Eslovénia'),
(1, 'ES', 'ESP', 724, 'Espanha'),
(1, 'US', 'USA', 840, 'Estados Unidos da América'),
(1, 'EE', 'EST', 233, 'Estónia'),
(1, 'ET', 'ETH', 231, 'Etiópia'),
(1, 'FO', 'FRO', 234, 'Faroe, Ilhas'),
(1, 'FJ', 'FJI', 242, 'Fiji'),
(1, 'PH', 'PHL', 608, 'Filipinas'),
(1, 'FI', 'FIN', 246, 'Finlândia'),
(1, 'FR', 'FRA', 250, 'França'),
(1, 'GA', 'GAB', 266, 'Gabão'),
(1, 'GM', 'GMB', 270, 'Gâmbia'),
(1, 'GH', 'GHA', 288, 'Gana'),
(1, 'GE', 'GEO', 268, 'Geórgia'),
(1, 'GS', 'SGS', 239, 'Geórgia do Sul e Sandwich do Sul, Ilhas'),
(1, 'GI', 'GIB', 292, 'Gibraltar'),
(1, 'GR', 'GRC', 300, 'Grécia'),
(1, 'GD', 'GRD', 308, 'Grenada'),
(1, 'GL', 'GRL', 304, 'Gronelândia'),
(1, 'GP', 'GLP', 312, 'Guadeloupe'),
(1, 'GU', 'GUM', 316, 'Guam'),
(1, 'GT', 'GTM', 320, 'Guatemala'),
(1, 'GG', 'GGY', 831, 'Guernsey'),
(1, 'GY', 'GUY', 328, 'Guiana'),
(1, 'GF', 'GUF', 254, 'Guiana Francesa'),
(1, 'GW', 'GNB', 624, 'Guiné-Bissau'),
(1, 'GN', 'GIN', 324, 'Guiné-Conacri'),
(1, 'GQ', 'GNQ', 226, 'Guiné Equatorial'),
(1, 'HT', 'HTI', 332, 'Haiti'),
(1, 'HM', 'HMD', 334, 'Heard e Ilhas McDonald, Ilha'),
(1, 'HN', 'HND', 340, 'Honduras'),
(1, 'HK', 'HKG', 344, 'Hong Kong'),
(1, 'HU', 'HUN', 348, 'Hungria'),
(1, 'YE', 'YEM', 887, 'Iémen'),
(1, 'IN', 'IND', 356, 'Índia'),
(1, 'ID', 'IDN', 360, 'Indonésia'),
(1, 'IQ', 'IRQ', 368, 'Iraque'),
(1, 'IR', 'IRN', 364, 'Irão'),
(1, 'IE', 'IRL', 372, 'Irlanda'),
(1, 'IS', 'ISL', 352, 'Islândia'),
(1, 'IL', 'ISR', 376, 'Israel'),
(1, 'IT', 'ITA', 380, 'Itália'),
(1, 'JM', 'JAM', 388, 'Jamaica'),
(1, 'JP', 'JPN', 392, 'Japão'),
(1, 'JE', 'JEY', 832, 'Jersey'),
(1, 'JO', 'JOR', 400, 'Jordânia'),
(1, 'KI', 'KIR', 296, 'Kiribati'),
(1, 'KW', 'KWT', 414, 'Kuwait'),
(1, 'LA', 'LAO', 418, 'Laos'),
(1, 'LS', 'LSO', 426, 'Lesoto'),
(1, 'LV', 'LVA', 428, 'Letónia'),
(1, 'LB', 'LBN', 422, 'Líbano'),
(1, 'LR', 'LBR', 430, 'Libéria'),
(1, 'LY', 'LBY', 434, 'Líbia'),
(1, 'LI', 'LIE', 438, 'Liechtenstein'),
(1, 'LT', 'LTU', 440, 'Lituânia'),
(1, 'LU', 'LUX', 442, 'Luxemburgo'),
(1, 'MO', 'MAC', 446, 'Macau'),
(1, 'MK', 'MKD', 807, 'Macedónia, República da'),
(1, 'MG', 'MDG', 450, 'Madagáscar'),
(1, 'MY', 'MYS', 458, 'Malásia'),
(1, 'MW', 'MWI', 454, 'Malawi'),
(1, 'MV', 'MDV', 462, 'Maldivas'),
(1, 'ML', 'MLI', 466, 'Mali'),
(1, 'MT', 'MLT', 470, 'Malta'),
(1, 'FK', 'FLK', 238, 'Malvinas, Ilhas (Falkland)'),
(1, 'IM', 'IMN', 833, 'Man, Ilha de'),
(1, 'MP', 'MNP', 580, 'Marianas Setentrionais'),
(1, 'MA', 'MAR', 504, 'Marrocos'),
(1, 'MH', 'MHL', 584, 'Marshall, Ilhas'),
(1, 'MQ', 'MTQ', 474, 'Martinica'),
(1, 'MU', 'MUS', 480, 'Maurícia'),
(1, 'MR', 'MRT', 478, 'Mauritânia'),
(1, 'YT', 'MYT', 175, 'Mayotte'),
(1, 'UM', 'UMI', 581, 'Menores Distantes dos Estados Unidos, Ilhas'),
(1, 'MX', 'MEX', 484, 'México'),
(1, 'MM', 'MMR', 104, 'Myanmar (antiga Birmânia)'),
(1, 'FM', 'FSM', 583, 'Micronésia, Estados Federados da'),
(1, 'MZ', 'MOZ', 508, 'Moçambique'),
(1, 'MD', 'MDA', 498, 'Moldávia'),
(1, 'MC', 'MCO', 492, 'Mónaco'),
(1, 'MN', 'MNG', 496, 'Mongólia'),
(1, 'ME', 'MNE', 499, 'Montenegro'),
(1, 'MS', 'MSR', 500, 'Montserrat'),
(1, 'NA', 'NAM', 516, 'Namíbia'),
(1, 'NR', 'NRU', 520, 'Nauru'),
(1, 'NP', 'NPL', 524, 'Nepal'),
(1, 'NI', 'NIC', 558, 'Nicarágua'),
(1, 'NE', 'NER', 562, 'Níger'),
(1, 'NG', 'NGA', 566, 'Nigéria'),
(1, 'NU', 'NIU', 570, 'Niue'),
(1, 'NF', 'NFK', 574, 'Norfolk, Ilha'),
(1, 'NO', 'NOR', 578, 'Noruega'),
(1, 'NC', 'NCL', 540, 'Nova Caledónia'),
(1, 'NZ', 'NZL', 554, 'Nova Zelândia (Aotearoa)'),
(1, 'OM', 'OMN', 512, 'Oman'),
(1, 'NL', 'NLD', 528, 'Países Baixos (Holanda)'),
(1, 'PW', 'PLW', 585, 'Palau'),
(1, 'PS', 'PSE', 275, 'Palestina'),
(1, 'PA', 'PAN', 591, 'Panamá'),
(1, 'PG', 'PNG', 598, 'Papua-Nova Guiné'),
(1, 'PK', 'PAK', 586, 'Paquistão'),
(1, 'PY', 'PRY', 600, 'Paraguai'),
(1, 'PE', 'PER', 604, 'Peru'),
(1, 'PN', 'PCN', 612, 'Pitcairn'),
(1, 'PF', 'PYF', 258, 'Polinésia Francesa'),
(1, 'PL', 'POL', 616, 'Polónia'),
(1, 'PR', 'PRI', 630, 'Porto Rico'),
(1, 'PT', 'PRT', 620, 'Portugal'),
(1, 'QA', 'QAT', 634, 'Qatar'),
(1, 'KE', 'KEN', 404, 'Quénia'),
(1, 'KG', 'KGZ', 417, 'Quirguistão'),
(1, 'GB', 'GBR', 826, 'Reino Unido da Grã-Bretanha e Irlanda do Norte'),
(1, 'RE', 'REU', 638, 'Reunião'),
(1, 'RO', 'ROU', 642, 'Roménia'),
(1, 'RW', 'RWA', 646, 'Ruanda'),
(1, 'RU', 'RUS', 643, 'Rússia'),
(1, 'EH', 'ESH', 732, 'Saara Ocidental'),
(1, 'AS', 'ASM', 16, 'Samoa Americana'),
(1, 'WS', 'WSM', 882, 'Samoa (Samoa Ocidental)'),
(1, 'PM', 'SPM', 666, 'Saint Pierre et Miquelon'),
(1, 'SB', 'SLB', 90, 'Salomão, Ilhas'),
(1, 'KN', 'KNA', 659, 'São Cristóvão e Névis (Saint Kitts e Nevis)'),
(1, 'SM', 'SMR', 674, 'San Marino'),
(1, 'ST', 'STP', 678, 'São Tomé e Príncipe'),
(1, 'VC', 'VCT', 670, 'São Vicente e Granadinas'),
(1, 'SH', 'SHN', 654, 'Santa Helena'),
(1, 'LC', 'LCA', 662, 'Santa Lúcia'),
(1, 'SN', 'SEN', 686, 'Senegal'),
(1, 'SL', 'SLE', 694, 'Serra Leoa'),
(1, 'RS', 'SRB', 688, 'Sérvia'),
(1, 'SC', 'SYC', 690, 'Seychelles'),
(1, 'SG', 'SGP', 702, 'Singapura'),
(1, 'SY', 'SYR', 760, 'Síria'),
(1, 'SO', 'SOM', 706, 'Somália'),
(1, 'LK', 'LKA', 144, 'Sri Lanka'),
(1, 'SZ', 'SWZ', 748, 'Suazilândia'),
(1, 'SD', 'SDN', 736, 'Sudão'),
(1, 'SE', 'SWE', 752, 'Suécia'),
(1, 'CH', 'CHE', 756, 'Suíça'),
(1, 'SR', 'SUR', 740, 'Suriname'),
(1, 'SJ', 'SJM', 744, 'Svalbard e Jan Mayen'),
(1, 'TH', 'THA', 764, 'Tailândia'),
(1, 'TW', 'TWN', 158, 'Taiwan'),
(1, 'TJ', 'TJK', 762, 'Tajiquistão'),
(1, 'TZ', 'TZA', 834, 'Tanzânia'),
(1, 'TF', 'ATF', 260, 'Terras Austrais e Antárticas Francesas (TAAF)'),
(1, 'IO', 'IOT', 86, 'Território Britânico do Oceano Índico'),
(1, 'TL', 'TLS', 626, 'Timor-Leste'),
(1, 'TG', 'TGO', 768, 'Togo'),
(1, 'TK', 'TKL', 772, 'Toquelau'),
(1, 'TO', 'TON', 776, 'Tonga'),
(1, 'TT', 'TTO', 780, 'Trindade e Tobago'),
(1, 'TN', 'TUN', 788, 'Tunísia'),
(1, 'TC', 'TCA', 796, 'Turks e Caicos'),
(1, 'TM', 'TKM', 795, 'Turquemenistão'),
(1, 'TR', 'TUR', 792, 'Turquia'),
(1, 'TV', 'TUV', 798, 'Tuvalu'),
(1, 'UA', 'UKR', 804, 'Ucrânia'),
(1, 'UG', 'UGA', 800, 'Uganda'),
(1, 'UY', 'URY', 858, 'Uruguai'),
(1, 'UZ', 'UZB', 860, 'Usbequistão'),
(1, 'VU', 'VUT', 548, 'Vanuatu'),
(1, 'VA', 'VAT', 336, 'Vaticano'),
(1, 'VE', 'VEN', 862, 'Venezuela'),
(1, 'VN', 'VNM', 704, 'Vietname'),
(1, 'VI', 'VIR', 850, 'Virgens Americanas, Ilhas'),
(1, 'VG', 'VGB', 92, 'Virgens Britânicas, Ilhas'),
(1, 'WF', 'WLF', 876, 'Wallis e Futuna'),
(1, 'ZM', 'ZMB', 894, 'Zâmbia'),
(1, 'ZW', 'ZWE', 716, 'Zimbabwe');