-- @creation-date 2001-08-27
-- @cvs-id $Id: ref-countries-create.sql,v 1.2 2001/09/02 17:06:29 donb Exp $
-- country is taken from ISO 3166
-- probably ought to add a note about analyze for efficiency on non-integer primary keys
create table countries (

-- @creation-date 2001-08-27
-- @cvs-id $Id: ref-countries-create.sql,v 1.1 2001/09/15 00:49:28 donb Exp $
-- country is taken from ISO 3166
-- probably ought to add a note about analyze for efficiency on non-integer primary keys
create table countries (

-- @creation-date 2001-08-27
-- @cvs-id $Id: ref-countries-create.sql,v 1.1.1.1 2005/12/03 18:31:20 cvs Exp $
-- country is taken from ISO 3166
-- probably ought to add a note about analyze for efficiency on non-integer primary keys
create table countries (

-- @creation-date 2001-08-27
-- @cvs-id $Id: ref-countries-create.sql,v 1.1.1.1 2005/12/03 18:31:20 cvs Exp $
-- country is taken from ISO 3166
-- probably ought to add a note about analyze for efficiency on non-integer primary keys
create table countries (

-- @creation-date 2001-08-27
-- @cvs-id $Id: ref-country-data.sql,v 1.1 2001/08/27 22:14:43 jong Exp $
-- country is taken from ISO 3166
-- I need to know the easy way to add extended chars in sqlplus then I can add french and spanish
-- ISO country codes

-- ORIGINAL AUTHOR:  Paul Ritchey
--
-- DESCRIPTION:  This table contains the ISO country names and two letter
-- abbreviations as stated in ISO-3166.
--

-- ORIGINAL AUTHOR:  Paul Ritchey
--
-- DESCRIPTION:  This table contains the ISO country names and two letter
-- abbreviations as stated in ISO-3166.
--

-- ORIGINAL AUTHOR:  Paul Ritchey
--
-- DESCRIPTION:  This table contains the ISO country names and two letter
-- abbreviations as stated in ISO-3166.
--

-- ORIGINAL AUTHOR:  Paul Ritchey
--
-- DESCRIPTION:  This table contains the ISO country names and two letter
-- abbreviations as stated in ISO-3166.
--

   fav_book VARCHAR(32),
   occupation VARCHAR(32),
   country_iso char(2),
   birthdate DATETIME,
   opt_in INTEGER,

# iso_countries_list.sql
#
# This will create and then populate a MySQL table with a list of the names and

     ponerlo en otro orden ...? Quizs en orden de cdigo telefnico
     internacional ..?
     Los datos han sido obtenidos del ISO 3166-1  (Observar nuevas
     actualizaciones...)
                    Luis Cabrera Sauco <lcabrera@idecnet.com>

  territories and character sets when not defined).  The formats
  for numbers, currency, dates, etc. are determined by the territory.
  language is two letter abbrev is ISO 639 language code
  country is two letter abbrev is ISO 3166 country code
  mime_charset is IANA charset name

  territories and character sets when not defined).  The formats
  for numbers, currency, dates, etc. are determined by the territory.
  language is two letter abbrev is ISO 639 language code
  country is two letter abbrev is ISO 3166 country code
  mime_charset is IANA charset name

  DECLARE  answer INTEGER DEFAULT 0;
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

BEGIN
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

  DECLARE  answer INTEGER DEFAULT 0;
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

BEGIN
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

  DECLARE  answer INTEGER DEFAULT 0;
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

BEGIN
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

  DECLARE  answer INTEGER DEFAULT 0;
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

BEGIN
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

  DECLARE  answer INTEGER DEFAULT 0;
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

BEGIN
  -- locale should be "default", "xx", "xx-YY", or "xx-YY-variant",
  -- where "xx" is a lower-case ISO 639 language code,
  -- "YY" is an upper-case ISO 3166 country code,
  -- and "variant" is a specific variant specification for a given

INSERT INTO code_param (type, code, name) VALUES ('displaycodes',1,'Only Display Within Section');
INSERT INTO code_param (type, code, name) VALUES ('displaycodes',-1,'Never Display');
INSERT INTO code_param (type, code, name) VALUES ('isolatemodes',0,'Part of Site');
INSERT INTO code_param (type, code, name) VALUES ('isolatemodes',1,'Standalone');
INSERT INTO code_param (type, code, name) VALUES ('issuemodes',0,'Neither');