-- Open Social Network schema specification 0_04_3 -- -- Copyright (c) 2006-2007, FindMeOn, Inc. -- 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__basic__gender ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__gender VALUES ( 10 , 'female' ); INSERT INTO _open_sn__basic__gender VALUES ( 11 , 'male' ); CREATE UNIQUE INDEX _open_sn__basic__gender_uidx ON _open_sn__basic__gender(lower(name)); CREATE TABLE _open_sn__basic__ethnicity ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 11 , 'African Descent' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 17 , 'Caucasian' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 10 , 'Asian' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 12 , 'East Indian' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 13 , 'Hispanic / Latino' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 14 , 'Middle Eastern' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 15 , 'Native American' ); INSERT INTO _open_sn__basic__ethnicity VALUES ( 16 , 'Pacific Islander' ); CREATE UNIQUE INDEX _open_sn__basic__ethnicity_uidx ON _open_sn__basic__ethnicity(lower(name)); CREATE TABLE _open_sn__basic__looking_to_meet ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 11 , 'Dating: Men' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 12 , 'Dating: Women' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 21 , 'Relationship: Men' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 22 , 'Relationship: Women' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 31 , 'Friends' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 32 , 'Activity Partners' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 41 , 'Just looking around' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 51 , 'Casual Encounters: Men' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 52 , 'Casual Encounters: Women' ); INSERT INTO _open_sn__basic__looking_to_meet VALUES ( 53 , 'Casual Encounters: Couples' ); CREATE UNIQUE INDEX _open_sn__basic__looking_to_meet_uidx ON _open_sn__basic__looking_to_meet(lower(name)); CREATE TABLE _open_sn__basic__pet ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(64) NOT NULL ); INSERT INTO _open_sn__basic__pet VALUES ( 11 , 'General' ); INSERT INTO _open_sn__basic__pet VALUES ( 12 , 'Dog' ); INSERT INTO _open_sn__basic__pet VALUES ( 13 , 'Cat' ); INSERT INTO _open_sn__basic__pet VALUES ( 14 , 'Bird' ); INSERT INTO _open_sn__basic__pet VALUES ( 15 , 'Fish' ); INSERT INTO _open_sn__basic__pet VALUES ( 16 , 'Gerbil/GuineaPig/Ferret/Rabit/Etc' ); INSERT INTO _open_sn__basic__pet VALUES ( 17 , 'Reptile' ); INSERT INTO _open_sn__basic__pet VALUES ( 18 , 'Exotic' ); INSERT INTO _open_sn__basic__pet VALUES ( 19 , 'Horse' ); CREATE UNIQUE INDEX _open_sn__basic__pet_uidx ON _open_sn__basic__pet(lower(name)); CREATE TABLE _open_sn__basic__living_situation ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__living_situation VALUES ( 11 , 'Alone' ); INSERT INTO _open_sn__basic__living_situation VALUES ( 12 , 'w/ Roommates' ); INSERT INTO _open_sn__basic__living_situation VALUES ( 13 , 'w/ Children' ); INSERT INTO _open_sn__basic__living_situation VALUES ( 14 , 'w/ Parents/Extended Family' ); CREATE UNIQUE INDEX _open_sn__basic__living_situation_uidx ON _open_sn__basic__living_situation(lower(name)); CREATE TABLE _open_sn__basic__body_art ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__body_art VALUES ( 11 , 'Tatoo: Always Visible' ); INSERT INTO _open_sn__basic__body_art VALUES ( 12 , 'Tatoo: Often Visible' ); INSERT INTO _open_sn__basic__body_art VALUES ( 13 , 'Tatoo: Strategic' ); INSERT INTO _open_sn__basic__body_art VALUES ( 14 , 'Tatoo: Lots' ); INSERT INTO _open_sn__basic__body_art VALUES ( 21 , 'Piercing: Ear' ); INSERT INTO _open_sn__basic__body_art VALUES ( 22 , 'Piercing: Nose' ); INSERT INTO _open_sn__basic__body_art VALUES ( 23 , 'Piercing: Navel' ); INSERT INTO _open_sn__basic__body_art VALUES ( 24 , 'Piercing: Other' ); INSERT INTO _open_sn__basic__body_art VALUES ( 25 , 'Piercing: Strategic' ); INSERT INTO _open_sn__basic__body_art VALUES ( 26 , 'Piercing: Lots' ); INSERT INTO _open_sn__basic__body_art VALUES ( 31 , 'Other: Always Visible' ); INSERT INTO _open_sn__basic__body_art VALUES ( 32 , 'Other: Often Visible' ); INSERT INTO _open_sn__basic__body_art VALUES ( 33 , 'Other: Strategic' ); INSERT INTO _open_sn__basic__body_art VALUES ( 34 , 'Other: Lots' ); INSERT INTO _open_sn__basic__body_art VALUES ( 41 , 'Branding' ); INSERT INTO _open_sn__basic__body_art VALUES ( 51 , 'Mutilation' ); CREATE UNIQUE INDEX _open_sn__basic__body_art_uidx ON _open_sn__basic__body_art(lower(name)); CREATE TABLE _open_sn__basic__hair ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__hair VALUES ( 11 , 'Brunette' ); INSERT INTO _open_sn__basic__hair VALUES ( 12 , 'Blonde' ); INSERT INTO _open_sn__basic__hair VALUES ( 13 , 'Red' ); INSERT INTO _open_sn__basic__hair VALUES ( 14 , 'Grey' ); CREATE UNIQUE INDEX _open_sn__basic__hair_uidx ON _open_sn__basic__hair(lower(name)); CREATE TABLE _open_sn__basic__eyes ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__eyes VALUES ( 11 , 'Brown' ); INSERT INTO _open_sn__basic__eyes VALUES ( 12 , 'Blue' ); INSERT INTO _open_sn__basic__eyes VALUES ( 13 , 'Green' ); CREATE UNIQUE INDEX _open_sn__basic__eyes_uidx ON _open_sn__basic__eyes(lower(name)); CREATE TABLE _open_sn__basic__eyecare ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__eyecare VALUES ( 10 , 'None' ); INSERT INTO _open_sn__basic__eyecare VALUES ( 11 , 'Glasses' ); INSERT INTO _open_sn__basic__eyecare VALUES ( 12 , 'Contacts' ); INSERT INTO _open_sn__basic__eyecare VALUES ( 13 , 'Either' ); CREATE UNIQUE INDEX _open_sn__basic__eyecare_uidx ON _open_sn__basic__eyecare(lower(name)); CREATE TABLE _open_sn__basic__height_units ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__height_units VALUES ( 11 , 'metric' ); INSERT INTO _open_sn__basic__height_units VALUES ( 12 , 'english traditional' ); CREATE UNIQUE INDEX _open_sn__basic__height_units_uidx ON _open_sn__basic__height_units(lower(name)); CREATE TABLE _open_sn__basic__weight_units ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__weight_units VALUES ( 11 , 'metric' ); INSERT INTO _open_sn__basic__weight_units VALUES ( 12 , 'english traditional' ); CREATE UNIQUE INDEX _open_sn__basic__weight_units_uidx ON _open_sn__basic__weight_units(lower(name)); CREATE TABLE _open_sn__basic__zodiac ( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__zodiac VALUES ( 11 , 'Aries' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 12 , 'Taurus' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 13 , 'Gemini' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 14 , 'Cancer' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 15 , 'Leo' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 16 , 'Virgo' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 17 , 'Libra' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 18 , 'Scorpio' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 19 , 'Saggitarius' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 20 , 'Capricorn' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 21 , 'Aquarius' ); INSERT INTO _open_sn__basic__zodiac VALUES ( 22 , 'Pisces' ); CREATE UNIQUE INDEX _open_sn__basic__zodiac_uidx ON _open_sn__basic__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' ); INSERT INTO _open_sn__relationship_status VALUES ( 16 , 'Open Relationship / Swinger' ); 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__basic__here_for( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__here_for VALUES ( 11 , 'Networking' ); INSERT INTO _open_sn__basic__here_for VALUES ( 12 , 'Friends' ); INSERT INTO _open_sn__basic__here_for VALUES ( 13 , 'PenPal' ); INSERT INTO _open_sn__basic__here_for VALUES ( 14 , 'Short-Term Dating' ); INSERT INTO _open_sn__basic__here_for VALUES ( 15 , 'Long-Term Dating' ); INSERT INTO _open_sn__basic__here_for VALUES ( 16 , 'Casual Relations' ); CREATE UNIQUE INDEX _open_sn__basic__here_for_uidx ON _open_sn__basic__here_for(lower(name)); CREATE TABLE _open_sn__basic__body_type( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(32) NOT NULL ); INSERT INTO _open_sn__basic__body_type VALUES ( 11 , 'Slim/Slender/Petite' ); INSERT INTO _open_sn__basic__body_type VALUES ( 12 , 'Athletic' ); INSERT INTO _open_sn__basic__body_type VALUES ( 13 , 'Body Builder' ); INSERT INTO _open_sn__basic__body_type VALUES ( 14 , 'Average' ); INSERT INTO _open_sn__basic__body_type VALUES ( 15 , 'A little more than average' ); INSERT INTO _open_sn__basic__body_type VALUES ( 16 , 'A lot more than average' ); INSERT INTO _open_sn__basic__body_type VALUES ( 17 , 'Obese' ); CREATE UNIQUE INDEX _open_sn__basic__body_type_uidx ON _open_sn__basic__body_type(lower(name)); CREATE TABLE _open_sn__basic__income_currency( id INTEGER NOT NULL PRIMARY KEY , name VARCHAR(3) NOT NULL ); INSERT INTO _open_sn__basic__income_currency VALUES ( 10 , 'USD' ); INSERT INTO _open_sn__basic__income_currency VALUES ( 11 , 'EUR' ); INSERT INTO _open_sn__basic__income_currency VALUES ( 12 , 'GBP' ); CREATE UNIQUE INDEX _open_sn__basic__income_currency_uidx ON _open_sn__basic__income_currency(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)); INSERT INTO open_sn__state_province VALUES ( 10 , 'us' , 'Alaska'); INSERT INTO open_sn__state_province VALUES ( 11 , 'us' , 'Alabama'); INSERT INTO open_sn__state_province VALUES ( 12 , 'us' , 'Arizona'); INSERT INTO open_sn__state_province VALUES ( 13 , 'us' , 'Arkansas'); INSERT INTO open_sn__state_province VALUES ( 14 , 'us' , 'California'); INSERT INTO open_sn__state_province VALUES ( 15 , 'us' , 'Colorado'); INSERT INTO open_sn__state_province VALUES ( 16 , 'us' , 'Connecticut'); INSERT INTO open_sn__state_province VALUES ( 17 , 'us' , 'Delaware'); INSERT INTO open_sn__state_province VALUES ( 18 , 'us' , 'District Of Columbia'); INSERT INTO open_sn__state_province VALUES ( 19 , 'us' , 'Florida'); INSERT INTO open_sn__state_province VALUES ( 20 , 'us' , 'Georgia'); INSERT INTO open_sn__state_province VALUES ( 21 , 'us' , 'Hawaii'); INSERT INTO open_sn__state_province VALUES ( 22 , 'us' , 'Idaho'); INSERT INTO open_sn__state_province VALUES ( 23 , 'us' , 'Illinois'); INSERT INTO open_sn__state_province VALUES ( 24 , 'us' , 'Indiana'); INSERT INTO open_sn__state_province VALUES ( 25 , 'us' , 'Iowa'); INSERT INTO open_sn__state_province VALUES ( 26 , 'us' , 'Kansas'); INSERT INTO open_sn__state_province VALUES ( 27 , 'us' , 'Kentucky'); INSERT INTO open_sn__state_province VALUES ( 28 , 'us' , 'Louisiana'); INSERT INTO open_sn__state_province VALUES ( 29 , 'us' , 'Maine'); INSERT INTO open_sn__state_province VALUES ( 30 , 'us' , 'Maryland'); INSERT INTO open_sn__state_province VALUES ( 31 , 'us' , 'Massachusetts'); INSERT INTO open_sn__state_province VALUES ( 32 , 'us' , 'Michigan'); INSERT INTO open_sn__state_province VALUES ( 33 , 'us' , 'Minnesota'); INSERT INTO open_sn__state_province VALUES ( 34 , 'us' , 'Mississippi'); INSERT INTO open_sn__state_province VALUES ( 35 , 'us' , 'Missouri'); INSERT INTO open_sn__state_province VALUES ( 36 , 'us' , 'Montana'); INSERT INTO open_sn__state_province VALUES ( 37 , 'us' , 'North Carolina'); INSERT INTO open_sn__state_province VALUES ( 38 , 'us' , 'North Dakota'); INSERT INTO open_sn__state_province VALUES ( 39 , 'us' , 'Nebraska'); INSERT INTO open_sn__state_province VALUES ( 40 , 'us' , 'New Hampshire'); INSERT INTO open_sn__state_province VALUES ( 41 , 'us' , 'New Jersey'); INSERT INTO open_sn__state_province VALUES ( 42 , 'us' , 'New Mexico'); INSERT INTO open_sn__state_province VALUES ( 43 , 'us' , 'New York'); INSERT INTO open_sn__state_province VALUES ( 44 , 'us' , 'Nevada'); INSERT INTO open_sn__state_province VALUES ( 45 , 'us' , 'Ohio'); INSERT INTO open_sn__state_province VALUES ( 46 , 'us' , 'Oklahoma'); INSERT INTO open_sn__state_province VALUES ( 47 , 'us' , 'Oregon'); INSERT INTO open_sn__state_province VALUES ( 48 , 'us' , 'Pennsylvania'); INSERT INTO open_sn__state_province VALUES ( 49 , 'us' , 'Rhode Island'); INSERT INTO open_sn__state_province VALUES ( 50 , 'us' , 'South Carolina'); INSERT INTO open_sn__state_province VALUES ( 51 , 'us' , 'South Dakota'); INSERT INTO open_sn__state_province VALUES ( 52 , 'us' , 'Tennessee'); INSERT INTO open_sn__state_province VALUES ( 53 , 'us' , 'Texas'); INSERT INTO open_sn__state_province VALUES ( 54 , 'us' , 'Utah'); INSERT INTO open_sn__state_province VALUES ( 55 , 'us' , 'Vermont'); INSERT INTO open_sn__state_province VALUES ( 56 , 'us' , 'Virginia'); INSERT INTO open_sn__state_province VALUES ( 57 , 'us' , 'Washington'); INSERT INTO open_sn__state_province VALUES ( 58 , 'us' , 'West Virginia'); INSERT INTO open_sn__state_province VALUES ( 59 , 'us' , 'Wisconsin'); INSERT INTO open_sn__state_province VALUES ( 60 , 'us' , 'Wyoming'); 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_institution ( 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_institution_uidx ON open_sn__education_institution(lower(name),city_id); CREATE TABLE open_sn__profile ( id BIGSERIAL PRIMARY KEY NOT NULL , basic_realname VARCHAR(64), basic_realname_first VARCHAR(64), basic_realname_last VARCHAR(64), basic_nickname VARCHAR(64), basic_displayname VARCHAR(64), basic_useraccount_photo VARCHAR(100), resource VARCHAR(64), resource__custom VARCHAR(64), basic_gender_id INTEGER REFERENCES _open_sn__basic__gender(id), basic_age INTEGER , basic_birthdate_year INTEGER , basic_birthdate_month INTEGER , basic_birthdate_day INTEGER , basic_zodiac_id INTEGER REFERENCES _open_sn__basic__zodiac(id), basic_ethnicity_id INTEGER REFERENCES _open_sn__basic__ethnicity(id), basic_living_situation_id INTEGER REFERENCES _open_sn__basic__living_situation(id), basic_hair_id INTEGER REFERENCES _open_sn__basic__hair(id), basic_eyes_id INTEGER REFERENCES _open_sn__basic__eyes(id), basic_eyecare_id INTEGER REFERENCES _open_sn__basic__eyecare(id), basic_height VARCHAR(5), basic_height_units_id INTEGER REFERENCES _open_sn__basic__height_units(id), basic_weight VARCHAR(5), basic_weight_units_id INTEGER REFERENCES _open_sn__basic__weight_units(id), basic_occupation_id INTEGER REFERENCES open_sn__occupation(id), basic_member_since TIMESTAMP, basic_last_updated TIMESTAMP, basic_last_login TIMESTAMP, basic_body_type_id INTEGER REFERENCES _open_sn__basic__body_type(id), basic_here_for_id INTEGER REFERENCES _open_sn__basic__here_for(id), basic_income_currency_id INTEGER REFERENCES _open_sn__basic__income_currency(id), basic_income_lo INTEGER , basic_income_hi INTEGER , beliefs_religion_id INTEGER REFERENCES _open_sn__religion(id), relationships_children_id INTEGER REFERENCES _open_sn__children(id), relationships_relationship_status_id INTEGER REFERENCES _open_sn__relationship_status(id), relationships_sexual_orientation_id INTEGER REFERENCES _open_sn__sexual_orientation(id), habits_alcohol_other_id INTEGER REFERENCES _open_sn__alcohol(id), habits_alcohol_self_id INTEGER REFERENCES _open_sn__alcohol(id), habits_tobacco_other_id INTEGER REFERENCES _open_sn__tobacco(id), habits_tobacco_self_id INTEGER REFERENCES _open_sn__tobacco(id), habits_diet_id INTEGER REFERENCES _open_sn__diet(id), habits_drugs_other_id INTEGER REFERENCES _open_sn__drugs(id), habits_drugs_self_id INTEGER REFERENCES _open_sn__drugs(id), education_education_level_id INTEGER REFERENCES _open_sn__education_level(id), location_current_city_name VARCHAR(32), location_current_country_iso CHAR(2) REFERENCES _open_sn__country_iso(iso_abbv), location_current_postal_code VARCHAR(11), location_current_state_province_id INTEGER REFERENCES open_sn__state_province(id), location_hometown_city_name VARCHAR(32), location_hometown_country_iso CHAR(2) REFERENCES _open_sn__country_iso(iso_abbv), location_hometown_postal_code VARCHAR(11), location_hometown_state_province_id INTEGER REFERENCES open_sn__state_province(id), preferences_preferred_language_id CHAR(2) REFERENCES _open_sn__preferred_language(id), preferences_timezone_id INTEGER REFERENCES _open_sn__timezone(id) ); CREATE TABLE open_sn__profile_text ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), basic_about_me TEXT , basic_headline TEXT , basic_who_i_want_to_meet TEXT , interests_affiliations TEXT , interests_books TEXT , interests_dislikes TEXT , interests_general TEXT , interests_heroes TEXT , interests_movies TEXT , interests_music TEXT , interests_television TEXT , misc_media_box TEXT ); CREATE TABLE open_sn__profile_education ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), institution INTEGER NOT NULL REFERENCES open_sn__education_institution(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__profile_basic_pets_like ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), open_sn__basic_pet_id INTEGER NOT NULL REFERENCES _open_sn__basic__pet(id) ); CREATE TABLE open_sn__profile_basic_pets_dislike ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), open_sn__basic_pet_id INTEGER NOT NULL REFERENCES _open_sn__basic__pet(id) ); CREATE TABLE open_sn__profile_basic_pets_own ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), open_sn__basic_pet_id INTEGER NOT NULL REFERENCES _open_sn__basic__pet(id) ); CREATE TABLE open_sn__profile_basic_body_art ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), open_sn__basic__body_art_id INTEGER NOT NULL REFERENCES _open_sn__basic__body_art(id) ); CREATE TABLE open_sn__profile_basic_looking_to_meet ( profile_id BIGINT NOT NULL PRIMARY KEY REFERENCES open_sn__profile(id), basic_looking_to_meet_id INTEGER NOT NULL REFERENCES _open_sn__basic__looking_to_meet(id) ); 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));