PHP Classes

File: countries_table.sql

Recommend this page to a friend!
  Classes of Olaf Lederer   Access user Class   countries_table.sql   Download  
File: countries_table.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL statement and country list
Class: Access user Class
Site user registration and page access restriction
Author: By
Last change: wrong role...
Date: 19 years ago
Size: 3,602 bytes
 

Contents

Class file image Download
CREATE TABLE `countries` ( `id` int(11) NOT NULL auto_increment, `iso` char(2) NOT NULL default '', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `countries` VALUES (NULL, 'AR', 'Argentina'); INSERT INTO `countries` VALUES (NULL, 'AU', 'Australia'); INSERT INTO `countries` VALUES (NULL, 'AT', 'Austria'); INSERT INTO `countries` VALUES (NULL, 'BS', 'Bahamas'); INSERT INTO `countries` VALUES (NULL, 'BE', 'Belgium'); INSERT INTO `countries` VALUES (NULL, 'BO', 'Bolivia'); INSERT INTO `countries` VALUES (NULL, 'BR', 'Brazil'); INSERT INTO `countries` VALUES (NULL, 'CA', 'Canada'); INSERT INTO `countries` VALUES (NULL, 'CL', 'Chile'); INSERT INTO `countries` VALUES (NULL, 'CN', 'China'); INSERT INTO `countries` VALUES (NULL, 'CO', 'Colombia'); INSERT INTO `countries` VALUES (NULL, 'CR', 'Costa Rica'); INSERT INTO `countries` VALUES (NULL, 'HR', 'Croatia'); INSERT INTO `countries` VALUES (NULL, 'CU', 'Cuba'); INSERT INTO `countries` VALUES (NULL, 'CZ', 'Czech, Rep.'); INSERT INTO `countries` VALUES (NULL, 'DK', 'Denmark'); INSERT INTO `countries` VALUES (NULL, 'DO', 'Dominican, Rep.'); INSERT INTO `countries` VALUES (NULL, 'EC', 'Ecuador'); INSERT INTO `countries` VALUES (NULL, 'EG', 'Egypt'); INSERT INTO `countries` VALUES (NULL, 'SV', 'El Salvador'); INSERT INTO `countries` VALUES (NULL, 'FI', 'Finland'); INSERT INTO `countries` VALUES (NULL, 'FR', 'France'); INSERT INTO `countries` VALUES (NULL, 'DE', 'Germany'); INSERT INTO `countries` VALUES (NULL, 'GB', 'Great Britain'); INSERT INTO `countries` VALUES (NULL, 'GR', 'Greece'); INSERT INTO `countries` VALUES (NULL, 'GT', 'Guatemala'); INSERT INTO `countries` VALUES (NULL, 'HN', 'Honduras'); INSERT INTO `countries` VALUES (NULL, 'HK', 'Hong Kong'); INSERT INTO `countries` VALUES (NULL, 'IN', 'India'); INSERT INTO `countries` VALUES (NULL, 'IE', 'Ireland'); INSERT INTO `countries` VALUES (NULL, 'IL', 'Israel'); INSERT INTO `countries` VALUES (NULL, 'IT', 'Italy'); INSERT INTO `countries` VALUES (NULL, 'JM', 'Jamaica'); INSERT INTO `countries` VALUES (NULL, 'JP', 'Japan'); INSERT INTO `countries` VALUES (NULL, 'LU', 'Luxembourg'); INSERT INTO `countries` VALUES (NULL, 'MX', 'Mexico'); INSERT INTO `countries` VALUES (NULL, 'MA', 'Morocco'); INSERT INTO `countries` VALUES (NULL, 'NL', 'Netherlands'); INSERT INTO `countries` VALUES (NULL, 'NZ', 'New Zealand'); INSERT INTO `countries` VALUES (NULL, 'NI', 'Nicaragua'); INSERT INTO `countries` VALUES (NULL, 'NG', 'Nigeria'); INSERT INTO `countries` VALUES (NULL, 'NO', 'Norway'); INSERT INTO `countries` VALUES (NULL, 'PY', 'Paraguay'); INSERT INTO `countries` VALUES (NULL, 'PE', 'Peru'); INSERT INTO `countries` VALUES (NULL, 'PL', 'Poland'); INSERT INTO `countries` VALUES (NULL, 'PT', 'Portugal'); INSERT INTO `countries` VALUES (NULL, 'PR', 'Puerto Rico'); INSERT INTO `countries` VALUES (NULL, 'RU', 'Russia'); INSERT INTO `countries` VALUES (NULL, 'SA', 'Saudi Arabia'); INSERT INTO `countries` VALUES (NULL, 'ZA', 'South Africa'); INSERT INTO `countries` VALUES (NULL, 'ES', 'Spain'); INSERT INTO `countries` VALUES (NULL, 'SE', 'Sweden'); INSERT INTO `countries` VALUES (NULL, 'CH', 'Switzerland'); INSERT INTO `countries` VALUES (NULL, 'TW', 'Taiwan'); INSERT INTO `countries` VALUES (NULL, 'TR', 'Turkey'); INSERT INTO `countries` VALUES (NULL, 'US', 'United States'); INSERT INTO `countries` VALUES (NULL, 'UY', 'Uruguay'); INSERT INTO `countries` VALUES (NULL, 'VE', 'Venezuela'); INSERT INTO `countries` VALUES (999999, '', 'Other...');