-- Open Social Network schema specification		0_03
-- 
-- Copyright (c) 2006, Jonathan Vanasco
-- All rights reserved.
-- Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
-- 	• Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
-- 	• Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
-- 	• Neither the name of the organization nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission
-- 
-- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


CREATE TABLE _open_sn__gender (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__gender VALUES ( 10 , 'female' );
INSERT INTO _open_sn__gender VALUES ( 11 , 'male' );
CREATE UNIQUE INDEX _open_sn__gender_uidx ON _open_sn__gender(lower(name));

CREATE TABLE _open_sn__ethnicity (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__ethnicity VALUES ( 11 , 'African Descent' );
INSERT INTO _open_sn__ethnicity VALUES ( 17 , 'Caucasian' );
INSERT INTO _open_sn__ethnicity VALUES ( 10 , 'Asian' );
INSERT INTO _open_sn__ethnicity VALUES ( 12 , 'East Indian' );
INSERT INTO _open_sn__ethnicity VALUES ( 13 , 'Hispanic / Latino' );
INSERT INTO _open_sn__ethnicity VALUES ( 14 , 'Middle Eastern' );
INSERT INTO _open_sn__ethnicity VALUES ( 15 , 'Native American' );
INSERT INTO _open_sn__ethnicity VALUES ( 16 , 'Pacific Islander' );
CREATE UNIQUE INDEX _open_sn__ethnicity_uidx ON _open_sn__ethnicity(lower(name));


CREATE TABLE _open_sn__hair (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL
);
INSERT INTO _open_sn__hair VALUES ( 11 , 'Brunette' );
INSERT INTO _open_sn__hair VALUES ( 12 , 'Blonde' );
INSERT INTO _open_sn__hair VALUES ( 13 , 'Red' );
INSERT INTO _open_sn__hair VALUES ( 14 , 'Grey' );
CREATE UNIQUE INDEX _open_sn__hair_uidx ON _open_sn__hair(lower(name));

CREATE TABLE _open_sn__eyes (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL
);
INSERT INTO _open_sn__eyes VALUES ( 11 , 'Brown' );
INSERT INTO _open_sn__eyes VALUES ( 12 , 'Blue' );
INSERT INTO _open_sn__eyes VALUES ( 13 , 'Green' );
CREATE UNIQUE INDEX _open_sn__eyes_uidx ON _open_sn__eyes(lower(name));

CREATE TABLE _open_sn__height_units (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL
);
INSERT INTO _open_sn__height_units VALUES ( 11 , 'metric' );
INSERT INTO _open_sn__height_units VALUES ( 12 , 'english traditional' );
CREATE UNIQUE INDEX _open_sn__height_units_uidx ON _open_sn__height_units(lower(name));

CREATE TABLE _open_sn__weight_units (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__weight_units VALUES ( 11 , 'metric' );
INSERT INTO _open_sn__weight_units VALUES ( 12 , 'english traditional' );
CREATE UNIQUE INDEX _open_sn__weight_units_uidx ON _open_sn__weight_units(lower(name));

CREATE TABLE _open_sn__zodiac (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__zodiac VALUES ( 11 , 'Aries' );
INSERT INTO _open_sn__zodiac VALUES ( 12 , 'Taurus' );
INSERT INTO _open_sn__zodiac VALUES ( 13 , 'Gemini' );
INSERT INTO _open_sn__zodiac VALUES ( 14 , 'Cancer' );
INSERT INTO _open_sn__zodiac VALUES ( 15 , 'Leo' );
INSERT INTO _open_sn__zodiac VALUES ( 16 , 'Virgo' );
INSERT INTO _open_sn__zodiac VALUES ( 17 , 'Libra' );
INSERT INTO _open_sn__zodiac VALUES ( 18 , 'Scorpio' );
INSERT INTO _open_sn__zodiac VALUES ( 19 , 'Saggitarius' );
INSERT INTO _open_sn__zodiac VALUES ( 20 , 'Capricorn' );
INSERT INTO _open_sn__zodiac VALUES ( 21 , 'Aquarius' );
INSERT INTO _open_sn__zodiac VALUES ( 22 , 'Pisces' );
CREATE UNIQUE INDEX _open_sn__zodiac_uidx ON _open_sn__zodiac(lower(name));

CREATE TABLE _open_sn__relationship_status (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__relationship_status VALUES ( 10 , 'Single' );
INSERT INTO _open_sn__relationship_status VALUES ( 11 , 'In a Relationship' );
INSERT INTO _open_sn__relationship_status VALUES ( 12 , 'In a Domestic Partnership' );
INSERT INTO _open_sn__relationship_status VALUES ( 13 , 'Married' );
INSERT INTO _open_sn__relationship_status VALUES ( 14 , 'Complicated' );
INSERT INTO _open_sn__relationship_status VALUES ( 15 , 'Divorced' );
CREATE UNIQUE INDEX _open_sn__relationship_status_uidx ON _open_sn__relationship_status(lower(name));

CREATE TABLE _open_sn__sexual_orientation (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__sexual_orientation VALUES ( 10 , 'heterosexual' );
INSERT INTO _open_sn__sexual_orientation VALUES ( 11 , 'homosexual' );
INSERT INTO _open_sn__sexual_orientation VALUES ( 12 , 'bisexual' );
CREATE UNIQUE INDEX _open_sn__sexual_orientation_uidx ON _open_sn__sexual_orientation(lower(name));

CREATE TABLE _open_sn__religion(
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__religion VALUES ( 10 , 'other' );
INSERT INTO _open_sn__religion VALUES ( 21 , 'None' );

INSERT INTO _open_sn__religion VALUES ( 11 , 'Agnostic' );
INSERT INTO _open_sn__religion VALUES ( 12 , 'Atheist' );
INSERT INTO _open_sn__religion VALUES ( 13 , 'Buddhist' );
INSERT INTO _open_sn__religion VALUES ( 14 , 'Catholic' );
INSERT INTO _open_sn__religion VALUES ( 15 , 'Christian' );
INSERT INTO _open_sn__religion VALUES ( 16 , 'Christian Scientist' );
INSERT INTO _open_sn__religion VALUES ( 17 , 'Hindu' );
INSERT INTO _open_sn__religion VALUES ( 18 , 'Jewish' );
INSERT INTO _open_sn__religion VALUES ( 19 , 'Mormon' );
INSERT INTO _open_sn__religion VALUES ( 20 , 'Muslim' );
INSERT INTO _open_sn__religion VALUES ( 22 , 'Pagan' );
INSERT INTO _open_sn__religion VALUES ( 23 , 'Protestant' );
INSERT INTO _open_sn__religion VALUES ( 24 , 'Scientologist' );
INSERT INTO _open_sn__religion VALUES ( 25 , 'Taoist' );
INSERT INTO _open_sn__religion VALUES ( 26 , 'Unitarian' );
INSERT INTO _open_sn__religion VALUES ( 27 , 'Quaker' );
INSERT INTO _open_sn__religion VALUES ( 28 , 'Wiccan' );
CREATE UNIQUE INDEX _open_sn__religion_uidx ON _open_sn__religion(lower(name));

CREATE TABLE _open_sn__alcohol (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__alcohol VALUES ( 10 , 'Never' );
INSERT INTO _open_sn__alcohol VALUES ( 11 , 'Sometimes' );
INSERT INTO _open_sn__alcohol VALUES ( 12 , 'Regularly' );
CREATE UNIQUE INDEX _open_sn__alcohol_uidx ON _open_sn__alcohol(lower(name));

CREATE TABLE _open_sn__tobacco (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__tobacco VALUES ( 10 , 'Never' );
INSERT INTO _open_sn__tobacco VALUES ( 11 , 'Sometimes' );
INSERT INTO _open_sn__tobacco VALUES ( 12 , 'Regularly' );
CREATE UNIQUE INDEX _open_sn__tobacco_uidx ON _open_sn__tobacco(lower(name));
	
CREATE TABLE _open_sn__drugs (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__drugs VALUES ( 10 , 'Never' );
INSERT INTO _open_sn__drugs VALUES ( 11 , 'Sometimes' );
INSERT INTO _open_sn__drugs VALUES ( 12 , 'Regularly' );
CREATE UNIQUE INDEX _open_sn__drugs_uidx ON _open_sn__drugs(lower(name));

CREATE TABLE _open_sn__diet(
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__diet VALUES ( 11 , 'Omnivore' );
INSERT INTO _open_sn__diet VALUES ( 12 , 'Carnivore' );
INSERT INTO _open_sn__diet VALUES ( 13 , 'Pesco/Pollo-Vegetarian' );
INSERT INTO _open_sn__diet VALUES ( 14 , 'Pescetarian' );
INSERT INTO _open_sn__diet VALUES ( 15 , 'Pollo-Vegetarian' );
INSERT INTO _open_sn__diet VALUES ( 16 , 'Vegetarian' );
INSERT INTO _open_sn__diet VALUES ( 17 , 'Vegan' );
INSERT INTO _open_sn__diet VALUES ( 18 , 'Kosher' );
CREATE UNIQUE INDEX _open_sn__diet_uidx ON _open_sn__diet(lower(name));

CREATE TABLE _open_sn__children (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__children VALUES ( 10 , 'Decided- None' );
INSERT INTO _open_sn__children VALUES ( 11 , 'Decided- Someday' );
INSERT INTO _open_sn__children VALUES ( 12 , 'Undecided' );
INSERT INTO _open_sn__children VALUES ( 14 , 'Proud parent' );
CREATE UNIQUE INDEX _open_sn__children_uidx ON _open_sn__children(lower(name));
	
	
CREATE TABLE _open_sn__country_iso (
	iso_abbv CHAR(2) NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL UNIQUE
);
INSERT INTO _open_sn__country_iso VALUES ('us','United States');
INSERT INTO _open_sn__country_iso VALUES ('ca','Canada');
INSERT INTO _open_sn__country_iso VALUES ('gb','United Kingdom');
INSERT INTO _open_sn__country_iso VALUES ('ie','Ireland');
INSERT INTO _open_sn__country_iso VALUES ('nl','Netherlands');
INSERT INTO _open_sn__country_iso VALUES ('fr','France');
INSERT INTO _open_sn__country_iso VALUES ('de','Germany');
INSERT INTO _open_sn__country_iso VALUES ('it','Italy');
INSERT INTO _open_sn__country_iso VALUES ('es','Spain');
INSERT INTO _open_sn__country_iso VALUES ('ch','Switzerland');
INSERT INTO _open_sn__country_iso VALUES ('at','Austria');
INSERT INTO _open_sn__country_iso VALUES ('no' , 'Norway');
INSERT INTO _open_sn__country_iso VALUES ('se' , 'Sweden');
INSERT INTO _open_sn__country_iso VALUES ('au','Australia');
INSERT INTO _open_sn__country_iso VALUES ('nz','New Zealand');
INSERT INTO _open_sn__country_iso VALUES ('jp','Japan');
INSERT INTO _open_sn__country_iso VALUES ('be','Belgium');
INSERT INTO _open_sn__country_iso VALUES ('dk','Denmark');
INSERT INTO _open_sn__country_iso VALUES ('hr' , 'Croatia');
INSERT INTO _open_sn__country_iso VALUES ('gr' , 'Greece');
INSERT INTO _open_sn__country_iso VALUES ('tw' , 'Taiwan');
INSERT INTO _open_sn__country_iso VALUES ('af','Afghanistan');
INSERT INTO _open_sn__country_iso VALUES ('ax','Aland Islands');
INSERT INTO _open_sn__country_iso VALUES ('al','Albania');
INSERT INTO _open_sn__country_iso VALUES ('dz','Algeria');
INSERT INTO _open_sn__country_iso VALUES ('as','American Samoa');
INSERT INTO _open_sn__country_iso VALUES ('ad','Andorra');
INSERT INTO _open_sn__country_iso VALUES ('ao','Angola');
INSERT INTO _open_sn__country_iso VALUES ('ai','Anguilla');
INSERT INTO _open_sn__country_iso VALUES ('aq','Antarctica');
INSERT INTO _open_sn__country_iso VALUES ('ag','Antigua and Barbuda');
INSERT INTO _open_sn__country_iso VALUES ('ar','Argentina');
INSERT INTO _open_sn__country_iso VALUES ('am','Armenia');
INSERT INTO _open_sn__country_iso VALUES ('aw','Aruba');
INSERT INTO _open_sn__country_iso VALUES ('az','Azerbaijan');
INSERT INTO _open_sn__country_iso VALUES ('bs','Bahamas');
INSERT INTO _open_sn__country_iso VALUES ('bh','Bahrain');
INSERT INTO _open_sn__country_iso VALUES ('bd','Bangladesh');
INSERT INTO _open_sn__country_iso VALUES ('bb','Barbados');
INSERT INTO _open_sn__country_iso VALUES ('by','Belarus');
INSERT INTO _open_sn__country_iso VALUES ('bz','Belize');
INSERT INTO _open_sn__country_iso VALUES ('bj','Benin');
INSERT INTO _open_sn__country_iso VALUES ('bm','Bermuda');
INSERT INTO _open_sn__country_iso VALUES ('bt','Bhutan');
INSERT INTO _open_sn__country_iso VALUES ('bo','Bolivia');
INSERT INTO _open_sn__country_iso VALUES ('ba','Bosnia and Herzegovina');
INSERT INTO _open_sn__country_iso VALUES ('bw','Botswana');
INSERT INTO _open_sn__country_iso VALUES ('bv','Bouvet Island');
INSERT INTO _open_sn__country_iso VALUES ('br','Brazil');
INSERT INTO _open_sn__country_iso VALUES ('io','British Indian Ocean Territory');
INSERT INTO _open_sn__country_iso VALUES ('bn','Brunei Darussalam');
INSERT INTO _open_sn__country_iso VALUES ('bg','Bulgaria');
INSERT INTO _open_sn__country_iso VALUES ('bf','Burkina Faso');
INSERT INTO _open_sn__country_iso VALUES ('bi','Burundi');
INSERT INTO _open_sn__country_iso VALUES ('kh','Cambodia');
INSERT INTO _open_sn__country_iso VALUES ('cm','Cameroon');
INSERT INTO _open_sn__country_iso VALUES ('cv','Cape Verde');
INSERT INTO _open_sn__country_iso VALUES ('ky','Cayman Islands');
INSERT INTO _open_sn__country_iso VALUES ('cf','Central African Republic');
INSERT INTO _open_sn__country_iso VALUES ('td','Chad');
INSERT INTO _open_sn__country_iso VALUES ('cl','Chile');
INSERT INTO _open_sn__country_iso VALUES ('cn','China');
INSERT INTO _open_sn__country_iso VALUES ('cx','Christmas Island');
INSERT INTO _open_sn__country_iso VALUES ('cc','Cocos (Keeling) Islands');
INSERT INTO _open_sn__country_iso VALUES ('co','Colombia');
INSERT INTO _open_sn__country_iso VALUES ('km','Comoros');
INSERT INTO _open_sn__country_iso VALUES ('cg','Congo');
INSERT INTO _open_sn__country_iso VALUES ('cd','Congo, The Democratic Republic Of The');
INSERT INTO _open_sn__country_iso VALUES ('ck','Cook Islands');
INSERT INTO _open_sn__country_iso VALUES ('cr','Costa Rica');
INSERT INTO _open_sn__country_iso VALUES ('ci','Cote D\'ivoire');
INSERT INTO _open_sn__country_iso VALUES ('cu','Cuba');
INSERT INTO _open_sn__country_iso VALUES ('cy','Cyprus');
INSERT INTO _open_sn__country_iso VALUES ('cz','Czech Republic');
INSERT INTO _open_sn__country_iso VALUES ('dj','Djibouti');
INSERT INTO _open_sn__country_iso VALUES ('dm','Dominica');
INSERT INTO _open_sn__country_iso VALUES ('do','Dominican Republic');
INSERT INTO _open_sn__country_iso VALUES ('ec','Ecuador');
INSERT INTO _open_sn__country_iso VALUES ('eg','Egypt');
INSERT INTO _open_sn__country_iso VALUES ('sv','El Salvador');
INSERT INTO _open_sn__country_iso VALUES ('gq','Equatorial Guinea');
INSERT INTO _open_sn__country_iso VALUES ('er','Eritrea');
INSERT INTO _open_sn__country_iso VALUES ('ee','Estonia');
INSERT INTO _open_sn__country_iso VALUES ('et','Ethiopia');
INSERT INTO _open_sn__country_iso VALUES ('fk','Falkland Islands (Malvinas)');
INSERT INTO _open_sn__country_iso VALUES ('fo','Faroe Islands');
INSERT INTO _open_sn__country_iso VALUES ('fj','Fiji');
INSERT INTO _open_sn__country_iso VALUES ('fi','Finland');
INSERT INTO _open_sn__country_iso VALUES ('gf','French Guiana');
INSERT INTO _open_sn__country_iso VALUES ('pf','French Polynesia');
INSERT INTO _open_sn__country_iso VALUES ('tf','French Southern Territories');
INSERT INTO _open_sn__country_iso VALUES ('ga','Gabon');
INSERT INTO _open_sn__country_iso VALUES ('gm','Gambia');
INSERT INTO _open_sn__country_iso VALUES ('ge','Georgia');
INSERT INTO _open_sn__country_iso VALUES ('gh','Ghana');
INSERT INTO _open_sn__country_iso VALUES ('gi','Gibraltar');
INSERT INTO _open_sn__country_iso VALUES ('gl','Greenland');
INSERT INTO _open_sn__country_iso VALUES ('gd','Grenada');
INSERT INTO _open_sn__country_iso VALUES ('gp','Guadeloupe');
INSERT INTO _open_sn__country_iso VALUES ('gu','Guam');
INSERT INTO _open_sn__country_iso VALUES ('gt','Guatemala');
INSERT INTO _open_sn__country_iso VALUES ('gn','Guinea');
INSERT INTO _open_sn__country_iso VALUES ('gw','Guinea-Bissau');
INSERT INTO _open_sn__country_iso VALUES ('gy','Guyana');
INSERT INTO _open_sn__country_iso VALUES ('ht','Haiti');
INSERT INTO _open_sn__country_iso VALUES ('hm','Heard Island and Mcdonald Islands');
INSERT INTO _open_sn__country_iso VALUES ('va','Holy See (Vatican City State)');
INSERT INTO _open_sn__country_iso VALUES ('hn','Honduras');
INSERT INTO _open_sn__country_iso VALUES ('hk','Hong Kong');
INSERT INTO _open_sn__country_iso VALUES ('hu','Hungary');
INSERT INTO _open_sn__country_iso VALUES ('is','Iceland');
INSERT INTO _open_sn__country_iso VALUES ('in','India');
INSERT INTO _open_sn__country_iso VALUES ('id','Indonesia');
INSERT INTO _open_sn__country_iso VALUES ('ir','Iran, Islamic Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('iq','Iraq');
INSERT INTO _open_sn__country_iso VALUES ('il','Israel');
INSERT INTO _open_sn__country_iso VALUES ('jm','Jamaica');
INSERT INTO _open_sn__country_iso VALUES ('jo','Jordan');
INSERT INTO _open_sn__country_iso VALUES ('kz','Kazakhstan');
INSERT INTO _open_sn__country_iso VALUES ('ke','Kenya');
INSERT INTO _open_sn__country_iso VALUES ('ki','Kiribati');
INSERT INTO _open_sn__country_iso VALUES ('kp','Korea, Democratic People\'s Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('kr','Korea, Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('kw','Kuwait');
INSERT INTO _open_sn__country_iso VALUES ('kg','Kyrgyzstan');
INSERT INTO _open_sn__country_iso VALUES ('la','Lao People\'s Democratic Republic');
INSERT INTO _open_sn__country_iso VALUES ('lv','Latvia');
INSERT INTO _open_sn__country_iso VALUES ('lb','Lebanon');
INSERT INTO _open_sn__country_iso VALUES ('ls','Lesotho');
INSERT INTO _open_sn__country_iso VALUES ('lr','Liberia');
INSERT INTO _open_sn__country_iso VALUES ('ly','Libyan Arab Jamahiriya');
INSERT INTO _open_sn__country_iso VALUES ('li','Liechtenstein');
INSERT INTO _open_sn__country_iso VALUES ('lt','Lithuania');
INSERT INTO _open_sn__country_iso VALUES ('lu','Luxembourg');
INSERT INTO _open_sn__country_iso VALUES ('mo','Macao');
INSERT INTO _open_sn__country_iso VALUES ('mk','Macedonia, The Former Yugoslav Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('mg','Madagascar');
INSERT INTO _open_sn__country_iso VALUES ('mw','Malawi');
INSERT INTO _open_sn__country_iso VALUES ('my','Malaysia');
INSERT INTO _open_sn__country_iso VALUES ('mv','Maldives');
INSERT INTO _open_sn__country_iso VALUES ('ml','Mali');
INSERT INTO _open_sn__country_iso VALUES ('mt','Malta');
INSERT INTO _open_sn__country_iso VALUES ('mh','Marshall Islands');
INSERT INTO _open_sn__country_iso VALUES ('mq','Martinique');
INSERT INTO _open_sn__country_iso VALUES ('mr','Mauritania');
INSERT INTO _open_sn__country_iso VALUES ('mu','Mauritius');
INSERT INTO _open_sn__country_iso VALUES ('yt','Mayotte');
INSERT INTO _open_sn__country_iso VALUES ('mx','Mexico');
INSERT INTO _open_sn__country_iso VALUES ('fm','Micronesia, Federated States Of');
INSERT INTO _open_sn__country_iso VALUES ('md','Moldova, Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('mc','Monaco');
INSERT INTO _open_sn__country_iso VALUES ('mn','Mongolia');
INSERT INTO _open_sn__country_iso VALUES ('ms','Montserrat');
INSERT INTO _open_sn__country_iso VALUES ('ma','Morocco');
INSERT INTO _open_sn__country_iso VALUES ('mz','Mozambique');
INSERT INTO _open_sn__country_iso VALUES ('mm','Myanmar');
INSERT INTO _open_sn__country_iso VALUES ('na','Namibia');
INSERT INTO _open_sn__country_iso VALUES ('nr','Nauru');
INSERT INTO _open_sn__country_iso VALUES ('np','Nepal');
INSERT INTO _open_sn__country_iso VALUES ('an','Netherlands Antilles');
INSERT INTO _open_sn__country_iso VALUES ('nc','New Caledonia');
INSERT INTO _open_sn__country_iso VALUES ('ni','Nicaragua');
INSERT INTO _open_sn__country_iso VALUES ('ne','Niger');
INSERT INTO _open_sn__country_iso VALUES ('ng','Nigeria');
INSERT INTO _open_sn__country_iso VALUES ('nu','Niue');
INSERT INTO _open_sn__country_iso VALUES ('nf','Norfolk Island');
INSERT INTO _open_sn__country_iso VALUES ('mp','Northern Mariana Islands');
INSERT INTO _open_sn__country_iso VALUES ('om','Oman');
INSERT INTO _open_sn__country_iso VALUES ('pk','Pakistan');
INSERT INTO _open_sn__country_iso VALUES ('pw','Palau');
INSERT INTO _open_sn__country_iso VALUES ('ps','Palestinian Territory, Occupied');
INSERT INTO _open_sn__country_iso VALUES ('pa','Panama');
INSERT INTO _open_sn__country_iso VALUES ('pg','Papua New Guinea');
INSERT INTO _open_sn__country_iso VALUES ('py','Paraguay');
INSERT INTO _open_sn__country_iso VALUES ('pe','Peru');
INSERT INTO _open_sn__country_iso VALUES ('ph','Philippines');
INSERT INTO _open_sn__country_iso VALUES ('pn','Pitcairn');
INSERT INTO _open_sn__country_iso VALUES ('pl','Poland');
INSERT INTO _open_sn__country_iso VALUES ('pt','Portugal');
INSERT INTO _open_sn__country_iso VALUES ('pr','Puerto Rico');
INSERT INTO _open_sn__country_iso VALUES ('qa','Qatar');
INSERT INTO _open_sn__country_iso VALUES ('re','Reunion');
INSERT INTO _open_sn__country_iso VALUES ('ro','Romania');
INSERT INTO _open_sn__country_iso VALUES ('ru','Russian Federation');
INSERT INTO _open_sn__country_iso VALUES ('rw','Rwanda');
INSERT INTO _open_sn__country_iso VALUES ('sh','Saint Helena');
INSERT INTO _open_sn__country_iso VALUES ('kn','Saint Kitts and Nevis');
INSERT INTO _open_sn__country_iso VALUES ('lc','Saint Lucia');
INSERT INTO _open_sn__country_iso VALUES ('pm','Saint Pierre and Miquelon');
INSERT INTO _open_sn__country_iso VALUES ('vc','Saint Vincent and The Grenadines');
INSERT INTO _open_sn__country_iso VALUES ('ws','Samoa');
INSERT INTO _open_sn__country_iso VALUES ('sm','San Marino');
INSERT INTO _open_sn__country_iso VALUES ('st','Sao Tome and Principe');
INSERT INTO _open_sn__country_iso VALUES ('sa','Saudi Arabia');
INSERT INTO _open_sn__country_iso VALUES ('sn','Senegal');
INSERT INTO _open_sn__country_iso VALUES ('cs','Serbia and Montenegro');
INSERT INTO _open_sn__country_iso VALUES ('sc','Seychelles');
INSERT INTO _open_sn__country_iso VALUES ('sl','Sierra Leone');
INSERT INTO _open_sn__country_iso VALUES ('sg','Singapore');
INSERT INTO _open_sn__country_iso VALUES ('sk','Slovakia');
INSERT INTO _open_sn__country_iso VALUES ('si','Slovenia');
INSERT INTO _open_sn__country_iso VALUES ('sb','Solomon Islands');
INSERT INTO _open_sn__country_iso VALUES ('so','Somalia');
INSERT INTO _open_sn__country_iso VALUES ('za','South Africa');
INSERT INTO _open_sn__country_iso VALUES ('gs','South Georgia and The South Sandwich Islands');
INSERT INTO _open_sn__country_iso VALUES ('lk','Sri Lanka');
INSERT INTO _open_sn__country_iso VALUES ('sd','Sudan');
INSERT INTO _open_sn__country_iso VALUES ('sr','Suriname');
INSERT INTO _open_sn__country_iso VALUES ('sj','Svalbard and Jan Mayen');
INSERT INTO _open_sn__country_iso VALUES ('sz','Swaziland');
INSERT INTO _open_sn__country_iso VALUES ('sy','Syrian Arab Republic');
INSERT INTO _open_sn__country_iso VALUES ('tj','Tajikistan');
INSERT INTO _open_sn__country_iso VALUES ('tz','Tanzania, United Republic Of');
INSERT INTO _open_sn__country_iso VALUES ('th','Thailand');
INSERT INTO _open_sn__country_iso VALUES ('tl','Timor-Leste');
INSERT INTO _open_sn__country_iso VALUES ('tg','Togo');
INSERT INTO _open_sn__country_iso VALUES ('tk','Tokelau');
INSERT INTO _open_sn__country_iso VALUES ('to','Tonga');
INSERT INTO _open_sn__country_iso VALUES ('tt','Trinidad and Tobago');
INSERT INTO _open_sn__country_iso VALUES ('tn','Tunisia');
INSERT INTO _open_sn__country_iso VALUES ('tr','Turkey');
INSERT INTO _open_sn__country_iso VALUES ('tm','Turkmenistan');
INSERT INTO _open_sn__country_iso VALUES ('tc','Turks and Caicos Islands');
INSERT INTO _open_sn__country_iso VALUES ('tv','Tuvalu');
INSERT INTO _open_sn__country_iso VALUES ('ug','Uganda');
INSERT INTO _open_sn__country_iso VALUES ('ua','Ukraine');
INSERT INTO _open_sn__country_iso VALUES ('ae','United Arab Emirates');
INSERT INTO _open_sn__country_iso VALUES ('um','United States Minor Outlying Islands');
INSERT INTO _open_sn__country_iso VALUES ('uy','Uruguay');
INSERT INTO _open_sn__country_iso VALUES ('uz','Uzbekistan');
INSERT INTO _open_sn__country_iso VALUES ('vu','Vanuatu');
INSERT INTO _open_sn__country_iso VALUES ('ve','Venezuela');
INSERT INTO _open_sn__country_iso VALUES ('vn','Viet Nam');
INSERT INTO _open_sn__country_iso VALUES ('vg','Virgin Islands, British');
INSERT INTO _open_sn__country_iso VALUES ('vi','Virgin Islands, U.S.');
INSERT INTO _open_sn__country_iso VALUES ('wf','Wallis and Futuna');
INSERT INTO _open_sn__country_iso VALUES ('eh','Western Sahara');
INSERT INTO _open_sn__country_iso VALUES ('ye','Yemen');
INSERT INTO _open_sn__country_iso VALUES ('zm','Zambia');
INSERT INTO _open_sn__country_iso VALUES ('zw','Zimbabwe');
CREATE UNIQUE INDEX _open_sn__country_iso_uidx ON _open_sn__country_iso(lower(name));


CREATE TABLE _open_sn__timezone (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL
);
INSERT INTO _open_sn__timezone VALUES ( 11 , 'Africa/Abidjan');
INSERT INTO _open_sn__timezone VALUES ( 12 , 'Africa/Accra');
INSERT INTO _open_sn__timezone VALUES ( 13 , 'Africa/Addis_Ababa');
INSERT INTO _open_sn__timezone VALUES ( 14 , 'Africa/Algiers');
INSERT INTO _open_sn__timezone VALUES ( 15 , 'Africa/Asmera');
INSERT INTO _open_sn__timezone VALUES ( 16 , 'Africa/Bamako');
INSERT INTO _open_sn__timezone VALUES ( 17 , 'Africa/Bangui');
INSERT INTO _open_sn__timezone VALUES ( 18 , 'Africa/Banjul');
INSERT INTO _open_sn__timezone VALUES ( 19 , 'Africa/Bissau');
INSERT INTO _open_sn__timezone VALUES ( 20 , 'Africa/Blantyre');
INSERT INTO _open_sn__timezone VALUES ( 21 , 'Africa/Brazzaville');
INSERT INTO _open_sn__timezone VALUES ( 22 , 'Africa/Bujumbura');
INSERT INTO _open_sn__timezone VALUES ( 23 , 'Africa/Cairo');
INSERT INTO _open_sn__timezone VALUES ( 24 , 'Africa/Casablanca');
INSERT INTO _open_sn__timezone VALUES ( 25 , 'Africa/Ceuta');
INSERT INTO _open_sn__timezone VALUES ( 26 , 'Africa/Conakry');
INSERT INTO _open_sn__timezone VALUES ( 27 , 'Africa/Dakar');
INSERT INTO _open_sn__timezone VALUES ( 28 , 'Africa/Dar_es_Salaam');
INSERT INTO _open_sn__timezone VALUES ( 29 , 'Africa/Djibouti');
INSERT INTO _open_sn__timezone VALUES ( 30 , 'Africa/Douala');
INSERT INTO _open_sn__timezone VALUES ( 31 , 'Africa/El_Aaiun');
INSERT INTO _open_sn__timezone VALUES ( 32 , 'Africa/Freetown');
INSERT INTO _open_sn__timezone VALUES ( 33 , 'Africa/Gaborone');
INSERT INTO _open_sn__timezone VALUES ( 34 , 'Africa/Harare');
INSERT INTO _open_sn__timezone VALUES ( 35 , 'Africa/Johannesburg');
INSERT INTO _open_sn__timezone VALUES ( 36 , 'Africa/Kampala');
INSERT INTO _open_sn__timezone VALUES ( 37 , 'Africa/Khartoum');
INSERT INTO _open_sn__timezone VALUES ( 38 , 'Africa/Kigali');
INSERT INTO _open_sn__timezone VALUES ( 39 , 'Africa/Kinshasa');
INSERT INTO _open_sn__timezone VALUES ( 40 , 'Africa/Lagos');
INSERT INTO _open_sn__timezone VALUES ( 41 , 'Africa/Libreville');
INSERT INTO _open_sn__timezone VALUES ( 42 , 'Africa/Lome');
INSERT INTO _open_sn__timezone VALUES ( 43 , 'Africa/Luanda');
INSERT INTO _open_sn__timezone VALUES ( 44 , 'Africa/Lubumbashi');
INSERT INTO _open_sn__timezone VALUES ( 45 , 'Africa/Lusaka');
INSERT INTO _open_sn__timezone VALUES ( 46 , 'Africa/Malabo');
INSERT INTO _open_sn__timezone VALUES ( 47 , 'Africa/Maputo');
INSERT INTO _open_sn__timezone VALUES ( 48 , 'Africa/Maseru');
INSERT INTO _open_sn__timezone VALUES ( 49 , 'Africa/Mbabane');
INSERT INTO _open_sn__timezone VALUES ( 50 , 'Africa/Mogadishu');
INSERT INTO _open_sn__timezone VALUES ( 51 , 'Africa/Monrovia');
INSERT INTO _open_sn__timezone VALUES ( 52 , 'Africa/Nairobi');
INSERT INTO _open_sn__timezone VALUES ( 53 , 'Africa/Ndjamena');
INSERT INTO _open_sn__timezone VALUES ( 54 , 'Africa/Niamey');
INSERT INTO _open_sn__timezone VALUES ( 55 , 'Africa/Nouakchott');
INSERT INTO _open_sn__timezone VALUES ( 56 , 'Africa/Ouagadougou');
INSERT INTO _open_sn__timezone VALUES ( 57 , 'Africa/Porto-Novo');
INSERT INTO _open_sn__timezone VALUES ( 58 , 'Africa/Sao_Tome');
INSERT INTO _open_sn__timezone VALUES ( 59 , 'Africa/Tripoli');
INSERT INTO _open_sn__timezone VALUES ( 60 , 'Africa/Tunis');
INSERT INTO _open_sn__timezone VALUES ( 61 , 'Africa/Windhoek');
INSERT INTO _open_sn__timezone VALUES ( 62 , 'America/Adak');
INSERT INTO _open_sn__timezone VALUES ( 63 , 'America/Anchorage');
INSERT INTO _open_sn__timezone VALUES ( 64 , 'America/Anguilla');
INSERT INTO _open_sn__timezone VALUES ( 65 , 'America/Antigua');
INSERT INTO _open_sn__timezone VALUES ( 66 , 'America/Araguaina');
INSERT INTO _open_sn__timezone VALUES ( 67 , 'America/Argentina/Buenos_Aires');
INSERT INTO _open_sn__timezone VALUES ( 68 , 'America/Argentina/Catamarca');
INSERT INTO _open_sn__timezone VALUES ( 69 , 'America/Argentina/Cordoba');
INSERT INTO _open_sn__timezone VALUES ( 70 , 'America/Argentina/Jujuy');
INSERT INTO _open_sn__timezone VALUES ( 71 , 'America/Argentina/La_Rioja');
INSERT INTO _open_sn__timezone VALUES ( 72 , 'America/Argentina/Mendoza');
INSERT INTO _open_sn__timezone VALUES ( 73 , 'America/Argentina/Rio_Gallegos');
INSERT INTO _open_sn__timezone VALUES ( 74 , 'America/Argentina/San_Juan');
INSERT INTO _open_sn__timezone VALUES ( 75 , 'America/Argentina/Tucuman');
INSERT INTO _open_sn__timezone VALUES ( 76 , 'America/Argentina/Ushuaia');
INSERT INTO _open_sn__timezone VALUES ( 77 , 'America/Aruba');
INSERT INTO _open_sn__timezone VALUES ( 78 , 'America/Asuncion');
INSERT INTO _open_sn__timezone VALUES ( 79 , 'America/Bahia');
INSERT INTO _open_sn__timezone VALUES ( 80 , 'America/Barbados');
INSERT INTO _open_sn__timezone VALUES ( 81 , 'America/Belem');
INSERT INTO _open_sn__timezone VALUES ( 82 , 'America/Belize');
INSERT INTO _open_sn__timezone VALUES ( 83 , 'America/Boa_Vista');
INSERT INTO _open_sn__timezone VALUES ( 84 , 'America/Bogota');
INSERT INTO _open_sn__timezone VALUES ( 85 , 'America/Boise');
INSERT INTO _open_sn__timezone VALUES ( 86 , 'America/Cambridge_Bay');
INSERT INTO _open_sn__timezone VALUES ( 87 , 'America/Campo_Grande');
INSERT INTO _open_sn__timezone VALUES ( 88 , 'America/Cancun');
INSERT INTO _open_sn__timezone VALUES ( 89 , 'America/Caracas');
INSERT INTO _open_sn__timezone VALUES ( 90 , 'America/Cayenne');
INSERT INTO _open_sn__timezone VALUES ( 91 , 'America/Cayman');
INSERT INTO _open_sn__timezone VALUES ( 92 , 'America/Chicago');
INSERT INTO _open_sn__timezone VALUES ( 93 , 'America/Chihuahua');
INSERT INTO _open_sn__timezone VALUES ( 94 , 'America/Coral_Harbour');
INSERT INTO _open_sn__timezone VALUES ( 95 , 'America/Costa_Rica');
INSERT INTO _open_sn__timezone VALUES ( 96 , 'America/Cuiaba');
INSERT INTO _open_sn__timezone VALUES ( 97 , 'America/Curacao');
INSERT INTO _open_sn__timezone VALUES ( 98 , 'America/Danmarkshavn');
INSERT INTO _open_sn__timezone VALUES ( 99 , 'America/Dawson');
INSERT INTO _open_sn__timezone VALUES ( 100 , 'America/Dawson_Creek');
INSERT INTO _open_sn__timezone VALUES ( 101 , 'America/Denver');
INSERT INTO _open_sn__timezone VALUES ( 102 , 'America/Detroit');
INSERT INTO _open_sn__timezone VALUES ( 103 , 'America/Dominica');
INSERT INTO _open_sn__timezone VALUES ( 104 , 'America/Edmonton');
INSERT INTO _open_sn__timezone VALUES ( 105 , 'America/Eirunepe');
INSERT INTO _open_sn__timezone VALUES ( 106 , 'America/El_Salvador');
INSERT INTO _open_sn__timezone VALUES ( 107 , 'America/Fortaleza');
INSERT INTO _open_sn__timezone VALUES ( 108 , 'America/Glace_Bay');
INSERT INTO _open_sn__timezone VALUES ( 109 , 'America/Godthab');
INSERT INTO _open_sn__timezone VALUES ( 110 , 'America/Goose_Bay');
INSERT INTO _open_sn__timezone VALUES ( 111 , 'America/Grand_Turk');
INSERT INTO _open_sn__timezone VALUES ( 112 , 'America/Grenada');
INSERT INTO _open_sn__timezone VALUES ( 113 , 'America/Guadeloupe');
INSERT INTO _open_sn__timezone VALUES ( 114 , 'America/Guatemala');
INSERT INTO _open_sn__timezone VALUES ( 115 , 'America/Guayaquil');
INSERT INTO _open_sn__timezone VALUES ( 116 , 'America/Guyana');
INSERT INTO _open_sn__timezone VALUES ( 117 , 'America/Halifax');
INSERT INTO _open_sn__timezone VALUES ( 118 , 'America/Havana');
INSERT INTO _open_sn__timezone VALUES ( 119 , 'America/Hermosillo');
INSERT INTO _open_sn__timezone VALUES ( 120 , 'America/Indiana/Indianapolis');
INSERT INTO _open_sn__timezone VALUES ( 121 , 'America/Indiana/Knox');
INSERT INTO _open_sn__timezone VALUES ( 122 , 'America/Indiana/Marengo');
INSERT INTO _open_sn__timezone VALUES ( 123 , 'America/Indiana/Petersburg');
INSERT INTO _open_sn__timezone VALUES ( 124 , 'America/Indiana/Vevay');
INSERT INTO _open_sn__timezone VALUES ( 125 , 'America/Indiana/Vincennes');
INSERT INTO _open_sn__timezone VALUES ( 126 , 'America/Inuvik');
INSERT INTO _open_sn__timezone VALUES ( 127 , 'America/Iqaluit');
INSERT INTO _open_sn__timezone VALUES ( 128 , 'America/Jamaica');
INSERT INTO _open_sn__timezone VALUES ( 129 , 'America/Juneau');
INSERT INTO _open_sn__timezone VALUES ( 130 , 'America/Kentucky/Louisville');
INSERT INTO _open_sn__timezone VALUES ( 131 , 'America/Kentucky/Monticello');
INSERT INTO _open_sn__timezone VALUES ( 132 , 'America/La_Paz');
INSERT INTO _open_sn__timezone VALUES ( 133 , 'America/Lima');
INSERT INTO _open_sn__timezone VALUES ( 134 , 'America/Los_Angeles');
INSERT INTO _open_sn__timezone VALUES ( 135 , 'America/Maceio');
INSERT INTO _open_sn__timezone VALUES ( 136 , 'America/Managua');
INSERT INTO _open_sn__timezone VALUES ( 137 , 'America/Manaus');
INSERT INTO _open_sn__timezone VALUES ( 138 , 'America/Martinique');
INSERT INTO _open_sn__timezone VALUES ( 139 , 'America/Mazatlan');
INSERT INTO _open_sn__timezone VALUES ( 140 , 'America/Menominee');
INSERT INTO _open_sn__timezone VALUES ( 141 , 'America/Merida');
INSERT INTO _open_sn__timezone VALUES ( 142 , 'America/Mexico_City');
INSERT INTO _open_sn__timezone VALUES ( 143 , 'America/Miquelon');
INSERT INTO _open_sn__timezone VALUES ( 144 , 'America/Moncton');
INSERT INTO _open_sn__timezone VALUES ( 145 , 'America/Monterrey');
INSERT INTO _open_sn__timezone VALUES ( 146 , 'America/Montevideo');
INSERT INTO _open_sn__timezone VALUES ( 147 , 'America/Montreal');
INSERT INTO _open_sn__timezone VALUES ( 148 , 'America/Montserrat');
INSERT INTO _open_sn__timezone VALUES ( 149 , 'America/Nassau');
INSERT INTO _open_sn__timezone VALUES ( 150 , 'America/New_York');
INSERT INTO _open_sn__timezone VALUES ( 151 , 'America/Nipigon');
INSERT INTO _open_sn__timezone VALUES ( 152 , 'America/Nome');
INSERT INTO _open_sn__timezone VALUES ( 153 , 'America/Noronha');
INSERT INTO _open_sn__timezone VALUES ( 154 , 'America/North_Dakota/Center');
INSERT INTO _open_sn__timezone VALUES ( 155 , 'America/Panama');
INSERT INTO _open_sn__timezone VALUES ( 156 , 'America/Pangnirtung');
INSERT INTO _open_sn__timezone VALUES ( 157 , 'America/Paramaribo');
INSERT INTO _open_sn__timezone VALUES ( 158 , 'America/Phoenix');
INSERT INTO _open_sn__timezone VALUES ( 159 , 'America/Port-au-Prince');
INSERT INTO _open_sn__timezone VALUES ( 160 , 'America/Port_of_Spain');
INSERT INTO _open_sn__timezone VALUES ( 161 , 'America/Porto_Velho');
INSERT INTO _open_sn__timezone VALUES ( 162 , 'America/Puerto_Rico');
INSERT INTO _open_sn__timezone VALUES ( 163 , 'America/Rainy_River');
INSERT INTO _open_sn__timezone VALUES ( 164 , 'America/Rankin_Inlet');
INSERT INTO _open_sn__timezone VALUES ( 165 , 'America/Recife');
INSERT INTO _open_sn__timezone VALUES ( 166 , 'America/Regina');
INSERT INTO _open_sn__timezone VALUES ( 167 , 'America/Rio_Branco');
INSERT INTO _open_sn__timezone VALUES ( 168 , 'America/Santiago');
INSERT INTO _open_sn__timezone VALUES ( 169 , 'America/Santo_Domingo');
INSERT INTO _open_sn__timezone VALUES ( 170 , 'America/Sao_Paulo');
INSERT INTO _open_sn__timezone VALUES ( 171 , 'America/Scoresbysund');
INSERT INTO _open_sn__timezone VALUES ( 172 , 'America/Shiprock');
INSERT INTO _open_sn__timezone VALUES ( 173 , 'America/St_Johns');
INSERT INTO _open_sn__timezone VALUES ( 174 , 'America/St_Kitts');
INSERT INTO _open_sn__timezone VALUES ( 175 , 'America/St_Lucia');
INSERT INTO _open_sn__timezone VALUES ( 176 , 'America/St_Thomas');
INSERT INTO _open_sn__timezone VALUES ( 177 , 'America/St_Vincent');
INSERT INTO _open_sn__timezone VALUES ( 178 , 'America/Swift_Current');
INSERT INTO _open_sn__timezone VALUES ( 179 , 'America/Tegucigalpa');
INSERT INTO _open_sn__timezone VALUES ( 180 , 'America/Thule');
INSERT INTO _open_sn__timezone VALUES ( 181 , 'America/Thunder_Bay');
INSERT INTO _open_sn__timezone VALUES ( 182 , 'America/Tijuana');
INSERT INTO _open_sn__timezone VALUES ( 183 , 'America/Toronto');
INSERT INTO _open_sn__timezone VALUES ( 184 , 'America/Tortola');
INSERT INTO _open_sn__timezone VALUES ( 185 , 'America/Vancouver');
INSERT INTO _open_sn__timezone VALUES ( 186 , 'America/Whitehorse');
INSERT INTO _open_sn__timezone VALUES ( 187 , 'America/Winnipeg');
INSERT INTO _open_sn__timezone VALUES ( 188 , 'America/Yakutat');
INSERT INTO _open_sn__timezone VALUES ( 189 , 'America/Yellowknife');
INSERT INTO _open_sn__timezone VALUES ( 190 , 'Antarctica/Casey');
INSERT INTO _open_sn__timezone VALUES ( 191 , 'Antarctica/Davis');
INSERT INTO _open_sn__timezone VALUES ( 192 , 'Antarctica/DumontDUrville');
INSERT INTO _open_sn__timezone VALUES ( 193 , 'Antarctica/Mawson');
INSERT INTO _open_sn__timezone VALUES ( 194 , 'Antarctica/McMurdo');
INSERT INTO _open_sn__timezone VALUES ( 195 , 'Antarctica/Palmer');
INSERT INTO _open_sn__timezone VALUES ( 196 , 'Antarctica/Rothera');
INSERT INTO _open_sn__timezone VALUES ( 197 , 'Antarctica/South_Pole');
INSERT INTO _open_sn__timezone VALUES ( 198 , 'Antarctica/Syowa');
INSERT INTO _open_sn__timezone VALUES ( 199 , 'Antarctica/Vostok');
INSERT INTO _open_sn__timezone VALUES ( 200 , 'Arctic/Longyearbyen');
INSERT INTO _open_sn__timezone VALUES ( 201 , 'Asia/Aden');
INSERT INTO _open_sn__timezone VALUES ( 202 , 'Asia/Almaty');
INSERT INTO _open_sn__timezone VALUES ( 203 , 'Asia/Amman');
INSERT INTO _open_sn__timezone VALUES ( 204 , 'Asia/Anadyr');
INSERT INTO _open_sn__timezone VALUES ( 205 , 'Asia/Aqtau');
INSERT INTO _open_sn__timezone VALUES ( 206 , 'Asia/Aqtobe');
INSERT INTO _open_sn__timezone VALUES ( 207 , 'Asia/Ashgabat');
INSERT INTO _open_sn__timezone VALUES ( 208 , 'Asia/Baghdad');
INSERT INTO _open_sn__timezone VALUES ( 209 , 'Asia/Bahrain');
INSERT INTO _open_sn__timezone VALUES ( 210 , 'Asia/Baku');
INSERT INTO _open_sn__timezone VALUES ( 211 , 'Asia/Bangkok');
INSERT INTO _open_sn__timezone VALUES ( 212 , 'Asia/Beirut');
INSERT INTO _open_sn__timezone VALUES ( 213 , 'Asia/Bishkek');
INSERT INTO _open_sn__timezone VALUES ( 214 , 'Asia/Brunei');
INSERT INTO _open_sn__timezone VALUES ( 215 , 'Asia/Calcutta');
INSERT INTO _open_sn__timezone VALUES ( 216 , 'Asia/Choibalsan');
INSERT INTO _open_sn__timezone VALUES ( 217 , 'Asia/Chongqing');
INSERT INTO _open_sn__timezone VALUES ( 218 , 'Asia/Colombo');
INSERT INTO _open_sn__timezone VALUES ( 219 , 'Asia/Damascus');
INSERT INTO _open_sn__timezone VALUES ( 220 , 'Asia/Dhaka');
INSERT INTO _open_sn__timezone VALUES ( 221 , 'Asia/Dili');
INSERT INTO _open_sn__timezone VALUES ( 222 , 'Asia/Dubai');
INSERT INTO _open_sn__timezone VALUES ( 223 , 'Asia/Dushanbe');
INSERT INTO _open_sn__timezone VALUES ( 224 , 'Asia/Gaza');
INSERT INTO _open_sn__timezone VALUES ( 225 , 'Asia/Harbin');
INSERT INTO _open_sn__timezone VALUES ( 226 , 'Asia/Hong_Kong');
INSERT INTO _open_sn__timezone VALUES ( 227 , 'Asia/Hovd');
INSERT INTO _open_sn__timezone VALUES ( 228 , 'Asia/Irkutsk');
INSERT INTO _open_sn__timezone VALUES ( 229 , 'Asia/Jakarta');
INSERT INTO _open_sn__timezone VALUES ( 230 , 'Asia/Jayapura');
INSERT INTO _open_sn__timezone VALUES ( 231 , 'Asia/Jerusalem');
INSERT INTO _open_sn__timezone VALUES ( 232 , 'Asia/Kabul');
INSERT INTO _open_sn__timezone VALUES ( 233 , 'Asia/Kamchatka');
INSERT INTO _open_sn__timezone VALUES ( 234 , 'Asia/Karachi');
INSERT INTO _open_sn__timezone VALUES ( 235 , 'Asia/Kashgar');
INSERT INTO _open_sn__timezone VALUES ( 236 , 'Asia/Katmandu');
INSERT INTO _open_sn__timezone VALUES ( 237 , 'Asia/Krasnoyarsk');
INSERT INTO _open_sn__timezone VALUES ( 238 , 'Asia/Kuala_Lumpur');
INSERT INTO _open_sn__timezone VALUES ( 239 , 'Asia/Kuching');
INSERT INTO _open_sn__timezone VALUES ( 240 , 'Asia/Kuwait');
INSERT INTO _open_sn__timezone VALUES ( 241 , 'Asia/Macau');
INSERT INTO _open_sn__timezone VALUES ( 242 , 'Asia/Magadan');
INSERT INTO _open_sn__timezone VALUES ( 243 , 'Asia/Makassar');
INSERT INTO _open_sn__timezone VALUES ( 244 , 'Asia/Manila');
INSERT INTO _open_sn__timezone VALUES ( 245 , 'Asia/Muscat');
INSERT INTO _open_sn__timezone VALUES ( 246 , 'Asia/Nicosia');
INSERT INTO _open_sn__timezone VALUES ( 247 , 'Asia/Novosibirsk');
INSERT INTO _open_sn__timezone VALUES ( 248 , 'Asia/Omsk');
INSERT INTO _open_sn__timezone VALUES ( 249 , 'Asia/Oral');
INSERT INTO _open_sn__timezone VALUES ( 250 , 'Asia/Phnom_Penh');
INSERT INTO _open_sn__timezone VALUES ( 251 , 'Asia/Pontianak');
INSERT INTO _open_sn__timezone VALUES ( 252 , 'Asia/Pyongyang');
INSERT INTO _open_sn__timezone VALUES ( 253 , 'Asia/Qatar');
INSERT INTO _open_sn__timezone VALUES ( 254 , 'Asia/Qyzylorda');
INSERT INTO _open_sn__timezone VALUES ( 255 , 'Asia/Rangoon');
INSERT INTO _open_sn__timezone VALUES ( 256 , 'Asia/Riyadh');
INSERT INTO _open_sn__timezone VALUES ( 257 , 'Asia/Saigon');
INSERT INTO _open_sn__timezone VALUES ( 258 , 'Asia/Sakhalin');
INSERT INTO _open_sn__timezone VALUES ( 259 , 'Asia/Samarkand');
INSERT INTO _open_sn__timezone VALUES ( 260 , 'Asia/Seoul');
INSERT INTO _open_sn__timezone VALUES ( 261 , 'Asia/Shanghai');
INSERT INTO _open_sn__timezone VALUES ( 262 , 'Asia/Singapore');
INSERT INTO _open_sn__timezone VALUES ( 263 , 'Asia/Taipei');
INSERT INTO _open_sn__timezone VALUES ( 264 , 'Asia/Tashkent');
INSERT INTO _open_sn__timezone VALUES ( 265 , 'Asia/Tbilisi');
INSERT INTO _open_sn__timezone VALUES ( 266 , 'Asia/Tehran');
INSERT INTO _open_sn__timezone VALUES ( 267 , 'Asia/Thimphu');
INSERT INTO _open_sn__timezone VALUES ( 268 , 'Asia/Tokyo');
INSERT INTO _open_sn__timezone VALUES ( 269 , 'Asia/Ulaanbaatar');
INSERT INTO _open_sn__timezone VALUES ( 270 , 'Asia/Urumqi');
INSERT INTO _open_sn__timezone VALUES ( 271 , 'Asia/Vientiane');
INSERT INTO _open_sn__timezone VALUES ( 272 , 'Asia/Vladivostok');
INSERT INTO _open_sn__timezone VALUES ( 273 , 'Asia/Yakutsk');
INSERT INTO _open_sn__timezone VALUES ( 274 , 'Asia/Yekaterinburg');
INSERT INTO _open_sn__timezone VALUES ( 275 , 'Asia/Yerevan');
INSERT INTO _open_sn__timezone VALUES ( 276 , 'Atlantic/Azores');
INSERT INTO _open_sn__timezone VALUES ( 277 , 'Atlantic/Bermuda');
INSERT INTO _open_sn__timezone VALUES ( 278 , 'Atlantic/Canary');
INSERT INTO _open_sn__timezone VALUES ( 279 , 'Atlantic/Cape_Verde');
INSERT INTO _open_sn__timezone VALUES ( 280 , 'Atlantic/Faeroe');
INSERT INTO _open_sn__timezone VALUES ( 281 , 'Atlantic/Jan_Mayen');
INSERT INTO _open_sn__timezone VALUES ( 282 , 'Atlantic/Madeira');
INSERT INTO _open_sn__timezone VALUES ( 283 , 'Atlantic/Reykjavik');
INSERT INTO _open_sn__timezone VALUES ( 284 , 'Atlantic/South_Georgia');
INSERT INTO _open_sn__timezone VALUES ( 285 , 'Atlantic/St_Helena');
INSERT INTO _open_sn__timezone VALUES ( 286 , 'Atlantic/Stanley');
INSERT INTO _open_sn__timezone VALUES ( 287 , 'Australia/Adelaide');
INSERT INTO _open_sn__timezone VALUES ( 288 , 'Australia/Brisbane');
INSERT INTO _open_sn__timezone VALUES ( 289 , 'Australia/Broken_Hill');
INSERT INTO _open_sn__timezone VALUES ( 290 , 'Australia/Currie');
INSERT INTO _open_sn__timezone VALUES ( 291 , 'Australia/Darwin');
INSERT INTO _open_sn__timezone VALUES ( 292 , 'Australia/Hobart');
INSERT INTO _open_sn__timezone VALUES ( 293 , 'Australia/Lindeman');
INSERT INTO _open_sn__timezone VALUES ( 294 , 'Australia/Lord_Howe');
INSERT INTO _open_sn__timezone VALUES ( 295 , 'Australia/Melbourne');
INSERT INTO _open_sn__timezone VALUES ( 296 , 'Australia/Perth');
INSERT INTO _open_sn__timezone VALUES ( 297 , 'Australia/Sydney');
INSERT INTO _open_sn__timezone VALUES ( 298 , 'Europe/Amsterdam');
INSERT INTO _open_sn__timezone VALUES ( 299 , 'Europe/Andorra');
INSERT INTO _open_sn__timezone VALUES ( 300 , 'Europe/Athens');
INSERT INTO _open_sn__timezone VALUES ( 301 , 'Europe/Belgrade');
INSERT INTO _open_sn__timezone VALUES ( 302 , 'Europe/Berlin');
INSERT INTO _open_sn__timezone VALUES ( 303 , 'Europe/Bratislava');
INSERT INTO _open_sn__timezone VALUES ( 304 , 'Europe/Brussels');
INSERT INTO _open_sn__timezone VALUES ( 305 , 'Europe/Bucharest');
INSERT INTO _open_sn__timezone VALUES ( 306 , 'Europe/Budapest');
INSERT INTO _open_sn__timezone VALUES ( 307 , 'Europe/Chisinau');
INSERT INTO _open_sn__timezone VALUES ( 308 , 'Europe/Copenhagen');
INSERT INTO _open_sn__timezone VALUES ( 309 , 'Europe/Dublin');
INSERT INTO _open_sn__timezone VALUES ( 310 , 'Europe/Gibraltar');
INSERT INTO _open_sn__timezone VALUES ( 311 , 'Europe/Helsinki');
INSERT INTO _open_sn__timezone VALUES ( 312 , 'Europe/Istanbul');
INSERT INTO _open_sn__timezone VALUES ( 313 , 'Europe/Kaliningrad');
INSERT INTO _open_sn__timezone VALUES ( 314 , 'Europe/Kiev');
INSERT INTO _open_sn__timezone VALUES ( 315 , 'Europe/Lisbon');
INSERT INTO _open_sn__timezone VALUES ( 316 , 'Europe/Ljubljana');
INSERT INTO _open_sn__timezone VALUES ( 317 , 'Europe/London');
INSERT INTO _open_sn__timezone VALUES ( 318 , 'Europe/Luxembourg');
INSERT INTO _open_sn__timezone VALUES ( 319 , 'Europe/Madrid');
INSERT INTO _open_sn__timezone VALUES ( 320 , 'Europe/Malta');
INSERT INTO _open_sn__timezone VALUES ( 321 , 'Europe/Mariehamn');
INSERT INTO _open_sn__timezone VALUES ( 322 , 'Europe/Minsk');
INSERT INTO _open_sn__timezone VALUES ( 323 , 'Europe/Monaco');
INSERT INTO _open_sn__timezone VALUES ( 324 , 'Europe/Moscow');
INSERT INTO _open_sn__timezone VALUES ( 325 , 'Europe/Oslo');
INSERT INTO _open_sn__timezone VALUES ( 326 , 'Europe/Paris');
INSERT INTO _open_sn__timezone VALUES ( 327 , 'Europe/Prague');
INSERT INTO _open_sn__timezone VALUES ( 328 , 'Europe/Riga');
INSERT INTO _open_sn__timezone VALUES ( 329 , 'Europe/Rome');
INSERT INTO _open_sn__timezone VALUES ( 330 , 'Europe/Samara');
INSERT INTO _open_sn__timezone VALUES ( 331 , 'Europe/San_Marino');
INSERT INTO _open_sn__timezone VALUES ( 332 , 'Europe/Sarajevo');
INSERT INTO _open_sn__timezone VALUES ( 333 , 'Europe/Simferopol');
INSERT INTO _open_sn__timezone VALUES ( 334 , 'Europe/Skopje');
INSERT INTO _open_sn__timezone VALUES ( 335 , 'Europe/Sofia');
INSERT INTO _open_sn__timezone VALUES ( 336 , 'Europe/Stockholm');
INSERT INTO _open_sn__timezone VALUES ( 337 , 'Europe/Tallinn');
INSERT INTO _open_sn__timezone VALUES ( 338 , 'Europe/Tirane');
INSERT INTO _open_sn__timezone VALUES ( 339 , 'Europe/Uzhgorod');
INSERT INTO _open_sn__timezone VALUES ( 340 , 'Europe/Vaduz');
INSERT INTO _open_sn__timezone VALUES ( 341 , 'Europe/Vatican');
INSERT INTO _open_sn__timezone VALUES ( 342 , 'Europe/Vienna');
INSERT INTO _open_sn__timezone VALUES ( 343 , 'Europe/Vilnius');
INSERT INTO _open_sn__timezone VALUES ( 344 , 'Europe/Warsaw');
INSERT INTO _open_sn__timezone VALUES ( 345 , 'Europe/Zagreb');
INSERT INTO _open_sn__timezone VALUES ( 346 , 'Europe/Zaporozhye');
INSERT INTO _open_sn__timezone VALUES ( 347 , 'Europe/Zurich');
INSERT INTO _open_sn__timezone VALUES ( 348 , 'Indian/Antananarivo');
INSERT INTO _open_sn__timezone VALUES ( 349 , 'Indian/Chagos');
INSERT INTO _open_sn__timezone VALUES ( 350 , 'Indian/Christmas');
INSERT INTO _open_sn__timezone VALUES ( 351 , 'Indian/Cocos');
INSERT INTO _open_sn__timezone VALUES ( 352 , 'Indian/Comoro');
INSERT INTO _open_sn__timezone VALUES ( 353 , 'Indian/Kerguelen');
INSERT INTO _open_sn__timezone VALUES ( 354 , 'Indian/Mahe');
INSERT INTO _open_sn__timezone VALUES ( 355 , 'Indian/Maldives');
INSERT INTO _open_sn__timezone VALUES ( 356 , 'Indian/Mauritius');
INSERT INTO _open_sn__timezone VALUES ( 357 , 'Indian/Mayotte');
INSERT INTO _open_sn__timezone VALUES ( 358 , 'Indian/Reunion');
INSERT INTO _open_sn__timezone VALUES ( 359 , 'Pacific/Apia');
INSERT INTO _open_sn__timezone VALUES ( 360 , 'Pacific/Auckland');
INSERT INTO _open_sn__timezone VALUES ( 361 , 'Pacific/Chatham');
INSERT INTO _open_sn__timezone VALUES ( 362 , 'Pacific/Easter');
INSERT INTO _open_sn__timezone VALUES ( 363 , 'Pacific/Efate');
INSERT INTO _open_sn__timezone VALUES ( 364 , 'Pacific/Enderbury');
INSERT INTO _open_sn__timezone VALUES ( 365 , 'Pacific/Fakaofo');
INSERT INTO _open_sn__timezone VALUES ( 366 , 'Pacific/Fiji');
INSERT INTO _open_sn__timezone VALUES ( 367 , 'Pacific/Funafuti');
INSERT INTO _open_sn__timezone VALUES ( 368 , 'Pacific/Galapagos');
INSERT INTO _open_sn__timezone VALUES ( 369 , 'Pacific/Gambier');
INSERT INTO _open_sn__timezone VALUES ( 370 , 'Pacific/Guadalcanal');
INSERT INTO _open_sn__timezone VALUES ( 371 , 'Pacific/Guam');
INSERT INTO _open_sn__timezone VALUES ( 372 , 'Pacific/Honolulu');
INSERT INTO _open_sn__timezone VALUES ( 373 , 'Pacific/Johnston');
INSERT INTO _open_sn__timezone VALUES ( 374 , 'Pacific/Kiritimati');
INSERT INTO _open_sn__timezone VALUES ( 375 , 'Pacific/Kosrae');
INSERT INTO _open_sn__timezone VALUES ( 376 , 'Pacific/Kwajalein');
INSERT INTO _open_sn__timezone VALUES ( 377 , 'Pacific/Majuro');
INSERT INTO _open_sn__timezone VALUES ( 378 , 'Pacific/Marquesas');
INSERT INTO _open_sn__timezone VALUES ( 379 , 'Pacific/Midway');
INSERT INTO _open_sn__timezone VALUES ( 380 , 'Pacific/Nauru');
INSERT INTO _open_sn__timezone VALUES ( 381 , 'Pacific/Niue');
INSERT INTO _open_sn__timezone VALUES ( 382 , 'Pacific/Norfolk');
INSERT INTO _open_sn__timezone VALUES ( 383 , 'Pacific/Noumea');
INSERT INTO _open_sn__timezone VALUES ( 384 , 'Pacific/Pago_Pago');
INSERT INTO _open_sn__timezone VALUES ( 385 , 'Pacific/Palau');
INSERT INTO _open_sn__timezone VALUES ( 386 , 'Pacific/Pitcairn');
INSERT INTO _open_sn__timezone VALUES ( 387 , 'Pacific/Ponape');
INSERT INTO _open_sn__timezone VALUES ( 388 , 'Pacific/Port_Moresby');
INSERT INTO _open_sn__timezone VALUES ( 389 , 'Pacific/Rarotonga');
INSERT INTO _open_sn__timezone VALUES ( 390 , 'Pacific/Saipan');
INSERT INTO _open_sn__timezone VALUES ( 391 , 'Pacific/Tahiti');
INSERT INTO _open_sn__timezone VALUES ( 392 , 'Pacific/Tarawa');
INSERT INTO _open_sn__timezone VALUES ( 393 , 'Pacific/Tongatapu');
INSERT INTO _open_sn__timezone VALUES ( 394 , 'Pacific/Truk');
INSERT INTO _open_sn__timezone VALUES ( 395 , 'Pacific/Wake');
INSERT INTO _open_sn__timezone VALUES ( 396 , 'Pacific/Wallis');
CREATE UNIQUE INDEX _open_sn__timezone_uidx ON _open_sn__timezone(lower(name));


CREATE TABLE _open_sn__preferred_language (
	id CHAR(2) NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL 
);
INSERT INTO _open_sn__preferred_language VALUES ('AA', 'Afar');
INSERT INTO _open_sn__preferred_language VALUES ('AB', 'Abkhazian');
INSERT INTO _open_sn__preferred_language VALUES ('AF', 'Afrikaans');
INSERT INTO _open_sn__preferred_language VALUES ('AM', 'Amharic');
INSERT INTO _open_sn__preferred_language VALUES ('AR', 'Arabic');
INSERT INTO _open_sn__preferred_language VALUES ('AS', 'Assamese');
INSERT INTO _open_sn__preferred_language VALUES ('AY', 'Aymara');
INSERT INTO _open_sn__preferred_language VALUES ('AZ', 'Azerbaijani');
INSERT INTO _open_sn__preferred_language VALUES ('BA', 'Bashkir');
INSERT INTO _open_sn__preferred_language VALUES ('BE', 'Byelorussian');
INSERT INTO _open_sn__preferred_language VALUES ('BG', 'Bulgarian');
INSERT INTO _open_sn__preferred_language VALUES ('BH', 'Bihari');
INSERT INTO _open_sn__preferred_language VALUES ('BI', 'Bislama');
INSERT INTO _open_sn__preferred_language VALUES ('BN', 'Bengali');
INSERT INTO _open_sn__preferred_language VALUES ('BO', 'Tibetan');
INSERT INTO _open_sn__preferred_language VALUES ('BR', 'Breton');
INSERT INTO _open_sn__preferred_language VALUES ('CA', 'Catalan');
INSERT INTO _open_sn__preferred_language VALUES ('CO', 'Corsican');
INSERT INTO _open_sn__preferred_language VALUES ('CS', 'Czech');
INSERT INTO _open_sn__preferred_language VALUES ('CY', 'Welsh');
INSERT INTO _open_sn__preferred_language VALUES ('DA', 'Danish');
INSERT INTO _open_sn__preferred_language VALUES ('DE', 'German');
INSERT INTO _open_sn__preferred_language VALUES ('DZ', 'Bhutani');
INSERT INTO _open_sn__preferred_language VALUES ('EL', 'Greek');
INSERT INTO _open_sn__preferred_language VALUES ('EN', 'English');
INSERT INTO _open_sn__preferred_language VALUES ('EO', 'Esperanto');
INSERT INTO _open_sn__preferred_language VALUES ('ES', 'Spanish');
INSERT INTO _open_sn__preferred_language VALUES ('ET', 'Estonian');
INSERT INTO _open_sn__preferred_language VALUES ('EU', 'Basque');
INSERT INTO _open_sn__preferred_language VALUES ('FA', 'Persian');
INSERT INTO _open_sn__preferred_language VALUES ('FI', 'Finnish');
INSERT INTO _open_sn__preferred_language VALUES ('FJ', 'Fiji');
INSERT INTO _open_sn__preferred_language VALUES ('FO', 'Faeroese');
INSERT INTO _open_sn__preferred_language VALUES ('FR', 'French');
INSERT INTO _open_sn__preferred_language VALUES ('FY', 'Frisian');
INSERT INTO _open_sn__preferred_language VALUES ('GA', 'Irish');
INSERT INTO _open_sn__preferred_language VALUES ('GD', 'Gaelic');
INSERT INTO _open_sn__preferred_language VALUES ('GL', 'Galician');
INSERT INTO _open_sn__preferred_language VALUES ('GN', 'Guarani');
INSERT INTO _open_sn__preferred_language VALUES ('GU', 'Gujarati');
INSERT INTO _open_sn__preferred_language VALUES ('HA', 'Hausa');
INSERT INTO _open_sn__preferred_language VALUES ('HI', 'Hindi');
INSERT INTO _open_sn__preferred_language VALUES ('HR', 'Croatian');
INSERT INTO _open_sn__preferred_language VALUES ('HU', 'Hungarian');
INSERT INTO _open_sn__preferred_language VALUES ('HY', 'Armenian');
INSERT INTO _open_sn__preferred_language VALUES ('IA', 'Interlingua');
INSERT INTO _open_sn__preferred_language VALUES ('IE', 'Interlingue');
INSERT INTO _open_sn__preferred_language VALUES ('IK', 'Inupiak');
INSERT INTO _open_sn__preferred_language VALUES ('IN', 'Indonesian');
INSERT INTO _open_sn__preferred_language VALUES ('IS', 'Icelandic');
INSERT INTO _open_sn__preferred_language VALUES ('IT', 'Italian');
INSERT INTO _open_sn__preferred_language VALUES ('IW', 'Hebrew');
INSERT INTO _open_sn__preferred_language VALUES ('JA', 'Japanese');
INSERT INTO _open_sn__preferred_language VALUES ('JI', 'Yiddish');
INSERT INTO _open_sn__preferred_language VALUES ('JW', 'Javanese');
INSERT INTO _open_sn__preferred_language VALUES ('KA', 'Georgian');
INSERT INTO _open_sn__preferred_language VALUES ('KK', 'Kazakh');
INSERT INTO _open_sn__preferred_language VALUES ('KL', 'Greenlandic');
INSERT INTO _open_sn__preferred_language VALUES ('KM', 'Cambodian');
INSERT INTO _open_sn__preferred_language VALUES ('KN', 'Kannada');
INSERT INTO _open_sn__preferred_language VALUES ('KO', 'Korean');
INSERT INTO _open_sn__preferred_language VALUES ('KS', 'Kashmiri');
INSERT INTO _open_sn__preferred_language VALUES ('KU', 'Kurdish');
INSERT INTO _open_sn__preferred_language VALUES ('KY', 'Kirghiz');
INSERT INTO _open_sn__preferred_language VALUES ('LA', 'Latin');
INSERT INTO _open_sn__preferred_language VALUES ('LN', 'Lingala');
INSERT INTO _open_sn__preferred_language VALUES ('LO', 'Laothian');
INSERT INTO _open_sn__preferred_language VALUES ('LT', 'Lithuanian');
INSERT INTO _open_sn__preferred_language VALUES ('LV', 'Latvian');
INSERT INTO _open_sn__preferred_language VALUES ('MG', 'Malagasy');
INSERT INTO _open_sn__preferred_language VALUES ('MI', 'Maori');
INSERT INTO _open_sn__preferred_language VALUES ('MK', 'Macedonian');
INSERT INTO _open_sn__preferred_language VALUES ('ML', 'Malayalam');
INSERT INTO _open_sn__preferred_language VALUES ('MN', 'Mongolian');
INSERT INTO _open_sn__preferred_language VALUES ('MO', 'Moldavian');
INSERT INTO _open_sn__preferred_language VALUES ('MR', 'Marathi');
INSERT INTO _open_sn__preferred_language VALUES ('MS', 'Malay');
INSERT INTO _open_sn__preferred_language VALUES ('MT', 'Maltese');
INSERT INTO _open_sn__preferred_language VALUES ('MY', 'Burmese');
INSERT INTO _open_sn__preferred_language VALUES ('NA', 'Nauru');
INSERT INTO _open_sn__preferred_language VALUES ('NE', 'Nepali');
INSERT INTO _open_sn__preferred_language VALUES ('NL', 'Dutch');
INSERT INTO _open_sn__preferred_language VALUES ('NO', 'Norwegian');
INSERT INTO _open_sn__preferred_language VALUES ('OC', 'Occitan');
INSERT INTO _open_sn__preferred_language VALUES ('OM', 'Oromo');
INSERT INTO _open_sn__preferred_language VALUES ('OR', 'Oriya');
INSERT INTO _open_sn__preferred_language VALUES ('PA', 'Punjabi');
INSERT INTO _open_sn__preferred_language VALUES ('PL', 'Polish');
INSERT INTO _open_sn__preferred_language VALUES ('PS', 'Pashto');
INSERT INTO _open_sn__preferred_language VALUES ('PT', 'Portuguese');
INSERT INTO _open_sn__preferred_language VALUES ('QU', 'Quechua');
INSERT INTO _open_sn__preferred_language VALUES ('RM', 'Rhaeto-Romance');
INSERT INTO _open_sn__preferred_language VALUES ('RN', 'Kirundi');
INSERT INTO _open_sn__preferred_language VALUES ('RO', 'Romanian');
INSERT INTO _open_sn__preferred_language VALUES ('RU', 'Russian');
INSERT INTO _open_sn__preferred_language VALUES ('RW', 'Kinyarwanda');
INSERT INTO _open_sn__preferred_language VALUES ('SA', 'Sanskrit');
INSERT INTO _open_sn__preferred_language VALUES ('SD', 'Sindhi');
INSERT INTO _open_sn__preferred_language VALUES ('SG', 'Sangro');
INSERT INTO _open_sn__preferred_language VALUES ('SH', 'Serbo-Croatian');
INSERT INTO _open_sn__preferred_language VALUES ('SI', 'Singhalese');
INSERT INTO _open_sn__preferred_language VALUES ('SK', 'Slovak');
INSERT INTO _open_sn__preferred_language VALUES ('SL', 'Slovenian');
INSERT INTO _open_sn__preferred_language VALUES ('SM', 'Samoan');
INSERT INTO _open_sn__preferred_language VALUES ('SN', 'Shona');
INSERT INTO _open_sn__preferred_language VALUES ('SO', 'Somali');
INSERT INTO _open_sn__preferred_language VALUES ('SQ', 'Albanian');
INSERT INTO _open_sn__preferred_language VALUES ('SR', 'Serbian');
INSERT INTO _open_sn__preferred_language VALUES ('SS', 'Siswati');
INSERT INTO _open_sn__preferred_language VALUES ('ST', 'Sesotho');
INSERT INTO _open_sn__preferred_language VALUES ('SU', 'Sudanese');
INSERT INTO _open_sn__preferred_language VALUES ('SV', 'Swedish');
INSERT INTO _open_sn__preferred_language VALUES ('SW', 'Swahili');
INSERT INTO _open_sn__preferred_language VALUES ('TA', 'Tamil');
INSERT INTO _open_sn__preferred_language VALUES ('TE', 'Tegulu');
INSERT INTO _open_sn__preferred_language VALUES ('TG', 'Tajik');
INSERT INTO _open_sn__preferred_language VALUES ('TH', 'Thai');
INSERT INTO _open_sn__preferred_language VALUES ('TI', 'Tigrinya');
INSERT INTO _open_sn__preferred_language VALUES ('TK', 'Turkmen');
INSERT INTO _open_sn__preferred_language VALUES ('TL', 'Tagalog');
INSERT INTO _open_sn__preferred_language VALUES ('TN', 'Setswana');
INSERT INTO _open_sn__preferred_language VALUES ('TO', 'Tonga');
INSERT INTO _open_sn__preferred_language VALUES ('TR', 'Turkish');
INSERT INTO _open_sn__preferred_language VALUES ('TS', 'Tsonga');
INSERT INTO _open_sn__preferred_language VALUES ('TT', 'Tatar');
INSERT INTO _open_sn__preferred_language VALUES ('TW', 'Twi');
INSERT INTO _open_sn__preferred_language VALUES ('UK', 'Ukrainian');
INSERT INTO _open_sn__preferred_language VALUES ('UR', 'Urdu');
INSERT INTO _open_sn__preferred_language VALUES ('UZ', 'Uzbek');
INSERT INTO _open_sn__preferred_language VALUES ('VI', 'Vietnamese');
INSERT INTO _open_sn__preferred_language VALUES ('VO', 'Volapuk');
INSERT INTO _open_sn__preferred_language VALUES ('WO', 'Wolof');
INSERT INTO _open_sn__preferred_language VALUES ('XH', 'Xhosa');
INSERT INTO _open_sn__preferred_language VALUES ('YO', 'Yoruba');
INSERT INTO _open_sn__preferred_language VALUES ('ZH', 'Chinese');
INSERT INTO _open_sn__preferred_language VALUES ('ZU', 'Zulu');
CREATE UNIQUE INDEX _open_sn__preferred_language_uidx ON _open_sn__preferred_language(lower(name));

CREATE TABLE open_sn__state_province (
	id INTEGER NOT NULL PRIMARY KEY ,
	iso_abbv CHAR(2) NOT NULL REFERENCES _open_sn__country_iso(iso_abbv) ,
	name VARCHAR(32) NOT NULL 
);
CREATE UNIQUE INDEX open_sn__state_province_uidx ON open_sn__state_province(iso_abbv,lower(name));

CREATE TABLE open_sn__city (
	id INTEGER NOT NULL PRIMARY KEY ,
	state_province_id INTEGER NOT NULL REFERENCES open_sn__state_province(id),
	name VARCHAR(32) NOT NULL UNIQUE
);
CREATE UNIQUE INDEX open_sn__city_uidx ON open_sn__city(state_province_id,(lower(name)));

CREATE TABLE _open_sn__education_level (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL 
);
INSERT INTO _open_sn__education_level VALUES ( 10 , 'High School' );
INSERT INTO _open_sn__education_level VALUES ( 11 , 'Some College' );
INSERT INTO _open_sn__education_level VALUES ( 12 , 'In College- BA' );
INSERT INTO _open_sn__education_level VALUES ( 13 , 'College Graduate- BA' );
INSERT INTO _open_sn__education_level VALUES ( 14 , 'In Graduate / Professional School' );
INSERT INTO _open_sn__education_level VALUES ( 15 , 'Graduate / Professional School- Completed' );
INSERT INTO _open_sn__education_level VALUES ( 16 , 'Post Graduate Work' );
CREATE UNIQUE INDEX _open_sn__education_level_uidx ON _open_sn__education_level(lower(name));


CREATE TABLE _open_sn__education_degree_type (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL 
);
INSERT INTO _open_sn__education_degree_type VALUES ( 10 , 'Diploma' );
INSERT INTO _open_sn__education_degree_type VALUES ( 11 , 'BA' );
INSERT INTO _open_sn__education_degree_type VALUES ( 12 , 'BS' );
INSERT INTO _open_sn__education_degree_type VALUES ( 13 , 'MFA' );
INSERT INTO _open_sn__education_degree_type VALUES ( 14 , 'MA' );
INSERT INTO _open_sn__education_degree_type VALUES ( 15 , 'MS' );
INSERT INTO _open_sn__education_degree_type VALUES ( 16 , 'PHD' );
INSERT INTO _open_sn__education_degree_type VALUES ( 17 , 'JD' );
INSERT INTO _open_sn__education_degree_type VALUES ( 18 , 'MD' );
INSERT INTO _open_sn__education_degree_type VALUES ( 19 , 'Certificate' );
INSERT INTO _open_sn__education_degree_type VALUES ( 20 , 'MBA' );
CREATE UNIQUE INDEX _open_sn__education_degree_type_uidx ON _open_sn__education_degree_type(lower(name));

CREATE TABLE _open_sn__education_attendance_status (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL UNIQUE
);
INSERT INTO _open_sn__education_attendance_status VALUES ( 10 , 'Attending' );
INSERT INTO _open_sn__education_attendance_status VALUES ( 11 , 'Attended' );
INSERT INTO _open_sn__education_attendance_status VALUES ( 12 , 'Attended+Graduated' );
CREATE UNIQUE INDEX _open_sn__education_attendance_status_uidx ON _open_sn__education_attendance_status(lower(name));

CREATE TABLE open_sn__occupation (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL
);
CREATE UNIQUE INDEX open_sn__occupation_uidx ON open_sn__occupation(lower(name));


CREATE TABLE open_sn__work_experience_company (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL,
	city_id INTEGER NOT NULL REFERENCES open_sn__city(id)
);
CREATE UNIQUE INDEX open_sn__work_experience_company_uidx ON open_sn__work_experience_company(lower(name),city_id);

CREATE TABLE open_sn__education_school (
	id INTEGER NOT NULL PRIMARY KEY ,
	name VARCHAR(32) NOT NULL,
	city_id INTEGER NOT NULL REFERENCES open_sn__city(id) 
);
CREATE UNIQUE INDEX open_sn__education_school_uidx ON open_sn__education_school(lower(name),city_id);



CREATE TABLE open_sn__profile (
	id BIGSERIAL PRIMARY KEY NOT NULL , 
	basic_gender_id INTEGER REFERENCES _open_sn__gender(id),
	basic_age INTEGER ,
	basic_birthdate_year INTEGER ,
	basic_birthdate_month INTEGER ,
	basic_birthdate_day INTEGER ,
	basic_ethnicity_id INTEGER REFERENCES _open_sn__ethnicity(id),
	basic_hair_id INTEGER REFERENCES _open_sn__hair(id),
	basic_eyes_id INTEGER REFERENCES _open_sn__eyes(id),
	basic_height VARCHAR(5),
	basic_height_units_id INTEGER REFERENCES _open_sn__height_units(id),
	basic_looking_to_meet_id INTEGER ,
	basic_weight VARCHAR(5),
	basic_weight_units_id INTEGER REFERENCES _open_sn__weight_units(id),
	basic_zodiac_id INTEGER REFERENCES _open_sn__zodiac(id),
	basic_occupation_id INTEGER REFERENCES open_sn__occupation(id),
	basic_last_login TIMESTAMP,
	basic_member_since TIMESTAMP,
	relationships_relationship_status_id INTEGER REFERENCES _open_sn__relationship_status(id),
	relationships_sexual_orientation_id INTEGER REFERENCES _open_sn__sexual_orientation(id),
	relationships_children_id INTEGER REFERENCES _open_sn__children(id),
	beliefs_religion_id INTEGER REFERENCES _open_sn__religion(id),
	habits_alcohol_self_id INTEGER REFERENCES _open_sn__alcohol(id),
	habits_alcohol_other_id INTEGER REFERENCES _open_sn__alcohol(id),
	habits_tobacco_self_id INTEGER REFERENCES _open_sn__tobacco(id),
	habits_tobacco_other_id INTEGER REFERENCES _open_sn__tobacco(id),
	habits_drugs_self_id INTEGER REFERENCES _open_sn__drugs(id),
	habits_drugs_other_id INTEGER REFERENCES _open_sn__drugs(id),
	habits_diet_id INTEGER REFERENCES _open_sn__diet(id),
	education_education_level_id INTEGER REFERENCES _open_sn__education_level(id),
	location_current_city_name VARCHAR(32),
	location_current_postal_code VARCHAR(11),
	location_current_country_iso CHAR(2) REFERENCES _open_sn__country_iso(iso_abbv),	
	location_current_state_province_id INTEGER REFERENCES open_sn__state_province(id),
	location_hometown_city_name VARCHAR(32),
	location_hometown_postal_code VARCHAR(11),
	location_hometown_country_iso CHAR(2) REFERENCES _open_sn__country_iso(iso_abbv),	
	location_hometown_state_province_id INTEGER REFERENCES open_sn__state_province(id),
	preferences_timezone_id INTEGER REFERENCES _open_sn__timezone(id),
	preferences_preferred_language_id CHAR(2) REFERENCES _open_sn__preferred_language(id)
);

CREATE TABLE open_sn__profile_text (
	profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id),
	interests_general TEXT ,
	interests_music TEXT ,
	interests_movies TEXT ,
	interests_television TEXT ,
	interests_books TEXT ,
	interests_heroes TEXT ,
	interests_affiliations TEXT ,
	interests_dislikes TEXT ,
	basic_about_me TEXT ,
	basic_who_i_want_to_meet TEXT ,
	media TEXT
);

CREATE TABLE open_sn__profile_education (
	profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id),
	school_id INTEGER NOT NULL REFERENCES open_sn__education_school(id),
	attendance_start DATE ,
	attendance_finish DATE ,
	attendance_status_id INTEGER NOT NULL REFERENCES _open_sn__education_attendance_status(id),
	degree_type_id INTEGER NOT NULL REFERENCES _open_sn__education_degree_type(id)
);

CREATE TABLE open_sn__profile_work_experience (
	profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id),
	company_id INTEGER NOT NULL REFERENCES open_sn__work_experience_company(id),
	employment_start DATE ,
	employment_finish DATE ,
	position VARCHAR(32)
);



CREATE TABLE _open_sn__us_state (
	us_state_abbv CHAR(2) NOT NULL PRIMARY KEY ,
	name VARCHAR(64) NOT NULL UNIQUE
);
INSERT INTO _open_sn__us_state VALUES ('ak' , 'Alaska'); 
INSERT INTO _open_sn__us_state VALUES ('al' , 'Alabama'); 
INSERT INTO _open_sn__us_state VALUES ('az' , 'Arizona'); 
INSERT INTO _open_sn__us_state VALUES ('ar' , 'Arkansas'); 
INSERT INTO _open_sn__us_state VALUES ('ca' , 'California'); 
INSERT INTO _open_sn__us_state VALUES ('co' , 'Colorado'); 
INSERT INTO _open_sn__us_state VALUES ('ct' , 'Connecticut'); 
INSERT INTO _open_sn__us_state VALUES ('de' , 'Delaware'); 
INSERT INTO _open_sn__us_state VALUES ('dc' , 'District Of Columbia'); 
INSERT INTO _open_sn__us_state VALUES ('fl' , 'Florida'); 
INSERT INTO _open_sn__us_state VALUES ('ga' , 'Georgia'); 
INSERT INTO _open_sn__us_state VALUES ('hi' , 'Hawaii'); 
INSERT INTO _open_sn__us_state VALUES ('id' , 'Idaho'); 
INSERT INTO _open_sn__us_state VALUES ('il' , 'Illinois'); 
INSERT INTO _open_sn__us_state VALUES ('in' , 'Indiana'); 
INSERT INTO _open_sn__us_state VALUES ('ia' , 'Iowa'); 
INSERT INTO _open_sn__us_state VALUES ('ks' , 'Kansas'); 
INSERT INTO _open_sn__us_state VALUES ('ky' , 'Kentucky'); 
INSERT INTO _open_sn__us_state VALUES ('la' , 'Louisiana'); 
INSERT INTO _open_sn__us_state VALUES ('me' , 'Maine'); 
INSERT INTO _open_sn__us_state VALUES ('md' , 'Maryland'); 
INSERT INTO _open_sn__us_state VALUES ('ma' , 'Massachusetts'); 
INSERT INTO _open_sn__us_state VALUES ('mi' , 'Michigan'); 
INSERT INTO _open_sn__us_state VALUES ('mn' , 'Minnesota'); 
INSERT INTO _open_sn__us_state VALUES ('ms' , 'Mississippi'); 
INSERT INTO _open_sn__us_state VALUES ('mo' , 'Missouri'); 
INSERT INTO _open_sn__us_state VALUES ('mt' , 'Montana'); 
INSERT INTO _open_sn__us_state VALUES ('nc' , 'North Carolina'); 
INSERT INTO _open_sn__us_state VALUES ('nd' , 'North Dakota'); 
INSERT INTO _open_sn__us_state VALUES ('ne' , 'Nebraska'); 
INSERT INTO _open_sn__us_state VALUES ('nh' , 'New Hampshire'); 
INSERT INTO _open_sn__us_state VALUES ('nj' , 'New Jersey'); 
INSERT INTO _open_sn__us_state VALUES ('nm' , 'New Mexico'); 
INSERT INTO _open_sn__us_state VALUES ('ny' , 'New York'); 
INSERT INTO _open_sn__us_state VALUES ('nv' , 'Nevada'); 
INSERT INTO _open_sn__us_state VALUES ('oh' , 'Ohio'); 
INSERT INTO _open_sn__us_state VALUES ('ok' , 'Oklahoma'); 
INSERT INTO _open_sn__us_state VALUES ('or' , 'Oregon'); 
INSERT INTO _open_sn__us_state VALUES ('pa' , 'Pennsylvania'); 
INSERT INTO _open_sn__us_state VALUES ('ri' , 'Rhode Island'); 
INSERT INTO _open_sn__us_state VALUES ('sc' , 'South Carolina'); 
INSERT INTO _open_sn__us_state VALUES ('sd' , 'South Dakota'); 
INSERT INTO _open_sn__us_state VALUES ('tn' , 'Tennessee'); 
INSERT INTO _open_sn__us_state VALUES ('tx' , 'Texas'); 
INSERT INTO _open_sn__us_state VALUES ('ut' , 'Utah'); 
INSERT INTO _open_sn__us_state VALUES ('vt' , 'Vermont'); 
INSERT INTO _open_sn__us_state VALUES ('va' , 'Virginia'); 
INSERT INTO _open_sn__us_state VALUES ('wa' , 'Washington'); 
INSERT INTO _open_sn__us_state VALUES ('wv' , 'West Virginia'); 
INSERT INTO _open_sn__us_state VALUES ('wi' , 'Wisconsin'); 
INSERT INTO _open_sn__us_state VALUES ('wy' , 'Wyoming'); 
CREATE UNIQUE INDEX _open_sn__us_state_uidx ON _open_sn__us_state(lower(us_state_abbv));