-- Postgres Create Database

-- The tables below could be created using the default nextval('Category_categoryId')  data type.  However, 
-- because reactorblog is supposed to work across multiple systems I run into
-- a problem with Oracle support.  Specifically, oracle's sequences are limited to 
-- shorter names than postgres'.  So, I've decided to just go ahead and specify my
-- sequence names and use those as the defaults for the columns that would otherwise
-- typically be default nextval('Category_categoryId') .

-- Sequences 
create sequence "contact_contactid";
create sequence "country_countryid";
create sequence "state_stateid";
create sequence "address_addressid";
create sequence "emailaddress_emailaddressid";
create sequence "phonenumber_phonenumberid";


-- -------------------------------------
-- Tables


CREATE TABLE "Contact" (
	"contactId" integer DEFAULT nextval('contact_contactid')  NOT NULL  ,
	"firstName" varchar(50) NOT NULL ,
	"lastName" varchar(50) NOT NULL ,
	PRIMARY KEY  ("contactId")
);


CREATE TABLE "Country" (
	"countryId" integer DEFAULT nextval('country_countryid')  NOT NULL  ,
	"abbreviation" varchar(10) NOT NULL ,
	"name" varchar(50) NOT NULL ,
	"sortOrder" integer NOT NULL ,
	PRIMARY KEY  ("countryId")
);

CREATE TABLE "State" (
	"stateId" integer DEFAULT nextval('state_stateid')  NOT NULL  ,
	"abbreviation" varchar(5) NOT NULL ,
	"name" varchar(50) NOT NULL ,
	PRIMARY KEY  ("stateId")
);


CREATE TABLE "Address" (
	"addressId" integer DEFAULT nextval('address_addressid') NOT NULL,
	"contactId" integer NOT NULL ,
	"line1" varchar(50) NOT NULL ,
	"line2" varchar(50) NULL ,
	"city" varchar(50) NOT NULL ,
	"stateId" smallint NULL ,
	"postalCode" varchar(20) NOT NULL ,
	"countryId" smallint NOT NULL ,
	PRIMARY KEY  ("addressId"),
	CONSTRAINT "FK_address_1" FOREIGN KEY ("stateId") REFERENCES "State" ("stateId"),
	CONSTRAINT "FK_address_2" FOREIGN KEY ("countryId") REFERENCES "Country" ("countryId"),
	CONSTRAINT "FK_address_3" FOREIGN KEY ("contactId") REFERENCES "Contact" ("contactId")
);

CREATE TABLE "EmailAddress" (
	"emailAddressId" integer DEFAULT nextval('emailaddress_emailaddressid')  NOT NULL  ,
	"contactId" int NOT NULL ,
	"emailAddress" varchar(100) NOT NULL ,
	PRIMARY KEY  ("emailAddressId"),
	CONSTRAINT "FK_EmailAddress_1" FOREIGN KEY ("contactId") REFERENCES "Contact" ("contactId")
);

CREATE TABLE "PhoneNumber" (
	"phoneNumberId" integer DEFAULT nextval('phonenumber_phonenumberid')  NOT NULL  ,
	"contactId" int NOT NULL ,
	"phoneNumber" varchar(50) NOT NULL ,
	PRIMARY KEY  ("phoneNumberId"),
	CONSTRAINT "FK_PhoneNumber_1" FOREIGN KEY ("contactId") REFERENCES "Contact" ("contactId")
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'AB',
  'Alberta'
);

INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'AK',
  'Alaska'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'AL',
  'Alabama'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'AR',
  'Arkansas'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'AZ',
  'Arizona'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'BC',
  'British Columbia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'CA',
  'California'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'CO',
  'Colorado'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'CT',
  'Connecticut'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'DC',
  'District Of Columbia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'DE',
  'Delaware'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'FL',
  'Florida'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'GA',
  'Georgia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'GU',
  'Guam'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'HI',
  'Hawaii'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'IA',
  'Iowa'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'ID',
  'Idaho'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'IL',
  'Illinois'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'IN',
  'Indiana'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'KS',
  'Kansas'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'KY',
  'Kentucky'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'LA',
  'Louisiana'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MA',
  'Massachusetts'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MB',
  'Manitoba'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MD',
  'Maryland'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'ME',
  'Maine'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MI',
  'Michigan'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MN',
  'Minnesota'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MO',
  'Missouri'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MP',
  'Northern Mariana Islands'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MS',
  'Mississippi'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'MT',
  'Montana'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NB',
  'New Brunswick'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NC',
  'North Carolina'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'ND',
  'North Dakota'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NE',
  'Nebraska'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NF',
  'Newfoundland and Labrador'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NH',
  'New Hampshire'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NJ',
  'New Jersey'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NM',
  'New Mexico'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NS',
  'Nova Scotia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NT',
  'Northwest Territories'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NU',
  'Nunavut'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NV',
  'Nevada'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'NY',
  'New York'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'OH',
  'Ohio'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'OK',
  'Oklahoma'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'ON',
  'Ontario'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'OR',
  'Oregon'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'PA',
  'Pennsylvania'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'PE',
  'Prince Edward Island'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'PR',
  'Puerto Rico'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'QC',
  'Quebec'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'RI',
  'Rhode Island'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'SC',
  'South Carolina'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'SD',
  'South Dakota'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'SK',
  'Saskatchewan'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'TN',
  'Tennessee'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'TX',
  'Texas'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'UT',
  'Utah'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'VA',
  'Virginia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'VI',
  'Virgin Islands'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'VT',
  'Vermont'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'WA',
  'Washington'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'WI',
  'Wisconsin'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'WV',
  'West Virginia'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'WY',
  'Wyoming'
);


INSERT INTO "State"
(
  abbreviation,
  name
) VALUES (
  'YT',
  'Yukon Territory'
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ABW',
	'Aruba',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AFG',
	'Afghanistan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AGO',
	'Angola',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AIA',
	'Anguilla',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ALB',
	'Albania',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AND',
	'Andorra',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ANT',
	'Netherlands Antilles',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ARE',
	'United Arab Emirates',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ARG',
	'Argentina',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ARM',
	'Armenia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ASM',
	'American Samoa',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ATA',
	'Antarctica',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ATF',
	'French Southern Territories',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ATG',
	'Antigua and Barbuda',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AUS',
	'Australia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AUT',
	'Austria',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'AZE',
	'Azerbaijan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BDI',
	'Burundi',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BEL',
	'Belgium',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BEN',
	'Benin',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BFA',
	'Burkina Faso',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BGD',
	'Bangladesh',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BGR',
	'Bulgaria',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BHR',
	'Bahrain',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BHS',
	'Bahamas',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BIH',
	'Bosnia and Herzegowina',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BLR',
	'Belarus',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BLZ',
	'Belize',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BMU',
	'Bermuda',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BOL',
	'Bolivia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BRA',
	'Brazil',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BRB',
	'Barbados',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BRN',
	'Brunei Darussalam',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BTN',
	'Bhutan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BVT',
	'Bouvet Island',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'BWA',
	'Botswana',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CAF',
	'Central African Republic',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CAN',
	'Canada',
	'4'
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CCK',
	'Cocos (Keeling) Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CHE',
	'Switzerland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CHL',
	'Chile',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CHN',
	'China',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CIV',
	'Cote D''Ivoire',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CMR',
	'Cameroon',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'COG',
	'Congo',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'COK',
	'Cook Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'COL',
	'Colombia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'COM',
	'Comoros',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CPV',
	'Cape Verde',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CRI',
	'Costa Rica',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CUB',
	'Cuba',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CXR',
	'Christmas Island',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CYM',
	'Cayman Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CYP',
	'Cyprus',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'CZE',
	'Czech Republic',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DEU',
	'Germany',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DJI',
	'Djibouti',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DMA',
	'Dominica',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DNK',
	'Denmark',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DOM',
	'Dominican Republic',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'DZA',
	'Algeria',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ECU',
	'Ecuador',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'EGY',
	'Egypt',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ERI',
	'Eritrea',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ESH',
	'Western Sahara',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ESP',
	'Spain',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'EST',
	'Estonia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ETH',
	'Ethiopia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FIN',
	'Finland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FJI',
	'Fiji',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FLK',
	'Falkland Islands (Malvinas)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FRA',
	'France',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FRO',
	'Faroe Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FSM',
	'Micronesia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'FXX',
	'France, Metropolitan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GAB',
	'Gabon',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GBR',
	'United Kingdom',
	'3'
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GEO',
	'Georgia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GHA',
	'Ghana',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GIB',
	'Gibraltar',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GIN',
	'Guinea',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GLP',
	'Guadeloupe',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GMB',
	'Gambia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GNB',
	'Guinea-Bissau',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GNQ',
	'Equatorial Guinea',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GRC',
	'Greece',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GRD',
	'Grenada',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GRL',
	'Greenland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GTM',
	'Guatemala',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GUF',
	'French Guiana',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GUM',
	'Guam',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'GUY',
	'Guyana',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HKG',
	'Hong Kong',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HMD',
	'Heard/McDonald Isls.',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HND',
	'Honduras',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HRV',
	'Croatia (Hrvatska)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HTI',

	'Haiti',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'HUN',
	'Hungary',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IDN',
	'Indonesia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IND',
	'India',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IOT',
	'British Indian Ocean Terr.',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IRL',
	'Ireland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IRN',
	'Iran',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'IRQ',
	'Iraq',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ISL',
	'Iceland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ISR',
	'Israel',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ITA',
	'Italy',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'JAM',
	'Jamaica',
	0
);



INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'JOR',
	'Jordan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'JPN',
	'Japan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KAZ',
	'Kazakhstan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KEN',
	'Kenya',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KGZ',
	'Kyrgyzstan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KHM',
	'Cambodia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KIR',
	'Kiribati',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KNA',
	'Saint Kitts and Nevis',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KOR',
	'Korea (South)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'KWT',
	'Kuwait',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LAO',
	'Lao',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LBN',
	'Lebanon',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LBR',
	'Liberia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LBY',
	'Libyan Arab Jamahiriya',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LCA',
	'Saint Lucia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LIE',
	'Liechtenstein',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LKA',
	'Sri Lanka',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LSO',
	'Lesotho',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LTU',
	'Lithuania',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LUX',
	'Luxembourg',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'LVA',
	'Latvia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MAC',
	'Macau',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MAR',
	'Morocco',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MCO',
	'Monaco',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MDA',
	'Moldova',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MDG',
	'Madagascar',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MDV',
	'Maldives',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MEX',
	'Mexico',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MHL',
	'Marshall Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MKD',
	'Macedonia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MLI',
	'Mali',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MLT',
	'Malta',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MMR',
	'Myanmar',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MNG',
	'Mongolia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MNP',
	'Northern Mariana Isls.',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MOZ',
	'Mozambique',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MRT',
	'Mauritania',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MSR',
	'Montserrat',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MTQ',
	'Martinique',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MUS',
	'Mauritius',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MWI',
	'Malawi',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MYS',
	'Malaysia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'MYT',
	'Mayotte',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NAM',
	'Namibia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NCL',
	'New Caledonia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NER',
	'Niger',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NFK',
	'Norfolk Island',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NGA',
	'Nigeria',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NIC',
	'Nicaragua',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NIU',
	'Niue',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NLD',
	'Netherlands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NOR',
	'Norway',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NPL',
	'Nepal',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NRU',
	'Nauru',
	0
);



INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'NZL',
	'New Zealand',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'OMN',
	'Oman',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PAK',
	'Pakistan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PAN',
	'Panama',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PCN',
	'Pitcairn',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PER',
	'Peru',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PHL',
	'Philippines',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PLW',
	'Palau',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PNG',
	'Papua New Guinea',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'POL',
	'Poland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PRI',
	'Puerto Rico',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PRK',
	'Korea (North)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PRT',
	'Portugal',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PRY',
	'Paraguay',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'PYF',
	'French Polynesia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'QAT',
	'Qatar',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'REU',
	'Reunion',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ROM',
	'Romania',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'RUS',
	'Russian Federation',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'RWA',
	'Rwanda',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SAU',
	'Saudi Arabia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SDN',
	'Sudan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SEN',
	'Senegal',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SGP',
	'Singapore',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SGS',
	'S Georgia/S Sandwich Isls.',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SHN',
	'St. Helena',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SJM',
	'Svalbard/Jan Mayen Isls.',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SLB',
	'Solomon Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SLE',
	'Sierra Leone',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SLV',
	'El Salvador',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SMR',
	'San Marino',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SOM',
	'Somalia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SPM',
	'St. Pierre and Miquelon',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'STP',
	'Sao Tome and Principe',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SUR',
	'Suri"Name"',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SVK',
	'Slovak Republic',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SVN',
	'Slovenia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SWE',
	'Sweden',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SWZ',
	'Swaziland',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SYC',
	'Seychelles',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'SYR',
	'Syrian Arab Republic',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TCA',
	'Turks and Caicos Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TCD',
	'Chad',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TGO',
	'Togo',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'THA',
	'Thailand',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TJK',
	'Tajikistan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TKL',
	'Tokelau',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TKM',
	'Turkmenistan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TMP',
	'East Timor',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TON',
	'Tonga',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TTO',
	'Trinidad and Tobago',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TUN',
	'Tunisia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TUR',
	'Turkey',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TUV',
	'Tuvalu',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TWN',
	'Taiwan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'TZA',
	'Tanzania',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'UGA',
	'Uganda',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'UKR',
	'Ukraine',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'UMI',
	'US Minor Outlying Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'URY',
	'Uruguay',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'USA',
	'United States of America',
	'5'
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'UZB',
	'Uzbekistan',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VAT',
	'Vatican City State',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VCT',
	'Saint Vincent/Grenadines',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VEN',
	'Venezuela',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VGB',
	'Virgin Islands (British)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VIR',
	'Virgin Islands (U.S.)',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VNM',
	'Viet Nam',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'VUT',
	'Vanuatu',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'WLF',
	'Wallis and Futuna Islands',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'WSM',
	'Samoa',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'YEM',
	'Yemen',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'YUG',
	'Yugoslavia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ZAF',
	'South Africa',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ZAR',
	'Zaire',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ZMB',
	'Zambia',
	0
);


INSERT INTO "Country"
(
	abbreviation,
	name,
	"sortOrder"
)
VALUES
(
	'ZWE',
	'Zimbabwe',
	0
);