packaging/org.tizen.clock.spec

   1 %bcond_with mesa
   2
   3 Name:      org.tizen.clock
   4 Summary:    background image library
   5 Version:    0.2.57
   6 Release:    1
   7 License:    TBD
   8 Source0:    %{name}-%{version}.tar.gz
   9 Source1:        %{name}.manifest
  10 BuildRequires:  cmake
  11 BuildRequires:  edje-bin
  12 BuildRequires:  embryo-bin
  13 BuildRequires:  pkgconfig(vconf)
  14 BuildRequires:  pkgconfig(dlog)
  15 BuildRequires:  pkgconfig(appcore-efl)
  16 BuildRequires:  pkgconfig(elementary)
  17 BuildRequires:  pkgconfig(aul)
  18 BuildRequires:  pkgconfig(glib-2.0)
  19 BuildRequires:  pkgconfig(utilX)
  20 BuildRequires:  pkgconfig(db-util)
  21 BuildRequires:  pkgconfig(bundle)
  22 BuildRequires:  pkgconfig(ui-gadget-1)
  23 BuildRequires:  pkgconfig(alarm-service)
  24 BuildRequires:  pkgconfig(pmapi)
  25 BuildRequires:  pkgconfig(alarm-engine)
  26 BuildRequires:  pkgconfig(xext)
  27 BuildRequires:  pkgconfig(xcomposite)
  28 BuildRequires:  pkgconfig(icu-i18n)
  29 BuildRequires:  pkgconfig(devman)
  30 %if %{with mesa}
  31 BuildRequires:  pkgconfig(glesv2)
  32 %else
  33 BuildRequires: pkgconfig(gles20)
  34 %endif
  35 BuildRequires:  pkgconfig(capi-appfw-application)
  36 BuildRequires:  gettext-tools
  37 BuildRequires:  pkgconfig(feedback)
  38 BuildRequires:  pkgconfig(capi-system-sensor)
  39 BuildRequires:  pkgconfig(capi-media-tone-player)
  40 BuildRequires: pkgconfig(capi-media-player)
  41 BuildRequires: pkgconfig(capi-media-sound-manager)
  42
  43 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
  44
  45 %description
  46 clock application
  47
  48 %prep
  49 %setup -q
  50
  51 %define PREFIX    "/usr/apps/org.tizen.clock"
  52 %define RESDIR    "/usr/apps/org.tizen.clock/res"
  53 %define SHAREDIR  "/usr/share"
  54 %define UGPREFIX  "/usr/ug"
  55 %define UGDATADIR "/usr/ug/res"
  56 %define UGLIBDIR  "/usr/ug/lib"
  57 %define RING_PREFIX "/usr/apps/org.tizen.ring"
  58
  59 %build
  60
  61 cp %{SOURCE1} .
  62
  63 export LDFLAGS="${LDFLAGS} -Wl,--rpath,/usr/lib -Wl,--rpath,%{PREFIX}/lib -Wl,--hash-style=both -Wl,--as-needed"
  64 export CFLAGS="${CFLAGS} -fPIC"
  65 export CXXFLAGS="${CXXFLAGS} -fPIC"
  66
  67 %ifarch %{arm}
  68 CXXFLAGS+=" -D_ARCH_ARM_ -mfpu=neon -mfloat-abi=softfp"
  69 %endif
  70
  71 cmake . -DCMAKE_INSTALL_PREFIX=%{PREFIX}
  72
  73
  74 # Call make instruction with smp support
  75 make %{?jobs:-j%jobs}
  76
  77 %install
  78 rm -rf %{buildroot}
  79 %make_install
  80 mkdir -p %{buildroot}/usr/share/license
  81 cp LICENSE %{buildroot}/usr/share/license/%{name}
  82
  83 %clean
  84 rm -rf %{buildroot}
  85
  86 %post
  87 /sbin/ldconfig
  88
  89 CITY_TABLE_FILE="/opt/dbspace/.worldclock.db"
  90
  91 if [ ! -e "$CITY_TABLE_FILE" ]
  92 then
  93
  94 # create db
  95 mkdir -p /opt/dbspace
  96 sqlite3 /opt/dbspace/.worldclock.db 'PRAGMA journal_mode = PERSIST;
  97                 CREATE TABLE city_table (idex int primary key, city varchar(128), country varchar(128), timezone varchar(20), dst_type int, dst_enabled int, selected int, sequence int, tz_path varchar(128));
  98                 INSERT INTO "city_table" VALUES(0,"IDS_WCL_BODY_CITYNAME_ABIDJAN","IDS_WCL_BODY_COTE_DIVOIRE","GMT+0",0,1,0,0,"Africa/Abidjan");
  99                 INSERT INTO "city_table" VALUES(1,"IDS_WCL_BODY_CITYNAME_ABUDHABI","IDS_WCL_BODY_UNITED_ARAB_EMIRATES","GMT+4",0,1,0,0,"Asia/Dubai");
 100                 INSERT INTO "city_table" VALUES(2,"IDS_WCL_BODY_CITYNAME_ACCRA","IDS_WCL_BODY_GHANA","GMT-10",0,1,0,0,"Africa/Accra");
 101                 INSERT INTO "city_table" VALUES(3,"IDS_WCL_BODY_CITYNAME_ADDIS_ABABA","IDS_WCL_BODY_ETHIOPIA","GMT+3",0,1,0,0,"Africa/Addis_Ababa");
 102                 INSERT INTO "city_table" VALUES(4,"IDS_WCL_BODY_CITYNAME_ADELAIDE","IDS_WCL_BODY_AUSTRALIA","GMT+9:30",0,1,0,0,"Australia/Adelaide");
 103                 INSERT INTO "city_table" VALUES(5,"IDS_WCL_BODY_CITYNAME_ALASKA","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-9",0,1,0,0,"America/Nome");
 104                 INSERT INTO "city_table" VALUES(6,"IDS_WCL_BODY_CITYNAME_ALGIERS","IDS_WCL_BODY_ALGERIA","GMT+1",0,1,0,0,"Africa/Algiers");
 105                 INSERT INTO "city_table" VALUES(7,"IDS_WCL_BODY_CITYNAME_ALMATY","IDS_WCL_BODY_KAZAKHSTAN","GMT+6",0,1,0,0,"Asia/Almaty");
 106                 INSERT INTO "city_table" VALUES(8,"IDS_WCL_BODY_CITYNAME_AMBON","IDS_WCL_BODY_INDONESIA","GMT+1",0,1,0,0,"Asia/Jayapura");
 107                 INSERT INTO "city_table" VALUES(9,"IDS_WCL_BODY_CITYNAME_AMMAN","IDS_WCL_BODY_JORDAN","GMT+2",0,1,0,0,"Asia/Amman");
 108                 INSERT INTO "city_table" VALUES(10,"IDS_WCL_BODY_CITYNAME_AMSTERDAME","IDS_WCL_BODY_NETHERLANDS","GMT+1",0,1,0,0,"Europe/Amsterdam");
 109                 INSERT INTO "city_table" VALUES(11,"IDS_WCL_BODY_CITYNAME_ANADYR","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Anadyr");
 110                 INSERT INTO "city_table" VALUES(12,"IDS_WCL_BODY_CITYNAME_ANCHORAGE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-9",0,1,0,0,"America/Anchorage");
 111                 INSERT INTO "city_table" VALUES(13,"IDS_WCL_BODY_CITYNAME_ANKARA","IDS_WCL_BODY_TURKEY","GMT+2",0,1,0,0,"Asia/Istanbul");
 112                 INSERT INTO "city_table" VALUES(14,"IDS_WCL_BODY_CITYNAME_ANTANANARIVO","IDS_WCL_BODY_MADAGASCAR","GMT+3",0,1,0,0,"Indian/Antananarivo");
 113                 INSERT INTO "city_table" VALUES(15,"IDS_WCL_BODY_CITYNAME_ASHGABAT","IDS_WCL_BODY_TURKMENISTAN","GMT+5",0,1,0,0,"Asia/Ashgabat");
 114                 INSERT INTO "city_table" VALUES(16,"IDS_WCL_BODY_CITYNAME_ASMARA","IDS_WCL_BODY_ERITREA","GMT+3",0,1,0,0,"Africa/Asmara");
 115                 INSERT INTO "city_table" VALUES(17,"IDS_WCL_BODY_CITYNAME_ASTANA","IDS_WCL_BODY_KAZAKHSTAN","GMT+6",0,1,0,0,"Asia/Almaty");
 116                 INSERT INTO "city_table" VALUES(18,"IDS_WCL_BODY_CITYNAME_ASUNCION","IDS_WCL_BODY_PARAGUAY","GMT-4",0,1,0,0,"America/Asuncion");
 117                 INSERT INTO "city_table" VALUES(19,"IDS_WCL_BODY_CITYNAME_ATHENS","IDS_WCL_BODY_GREECE","GMT+2",0,1,0,0,"Europe/Athens");
 118                 INSERT INTO "city_table" VALUES(20,"IDS_WCL_BODY_CITYNAME_AUCKLAND","IDS_WCL_BODY_NEW_ZEALAND","GMT+12",0,1,0,0,"Pacific/Auckland");
 119                 INSERT INTO "city_table" VALUES(21,"IDS_WCL_BODY_CITYNAME_AUSTIN","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 120                 INSERT INTO "city_table" VALUES(22,"IDS_WCL_BODY_CITYNAME_AZORES","IDS_WCL_BODY_PORTUGAL","GMT-1",0,1,0,0,"Atlantic/Azores");
 121                 INSERT INTO "city_table" VALUES(23,"IDS_WCL_BODY_CITYNAME_BAGHDAD","IDS_WCL_BODY_IRAQ","GMT+3",0,1,0,0,"Asia/Baghdad");
 122                 INSERT INTO "city_table" VALUES(24,"IDS_WCL_BODY_CITYNAME_BAKU","IDS_WCL_BODY_AZERBAIJAN","GMT+4",0,1,0,0,"Asia/Baku");
 123                 INSERT INTO "city_table" VALUES(25,"IDS_WCL_BODY_CITYNAME_BALTIMORE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 124                 INSERT INTO "city_table" VALUES(26,"IDS_WCL_BODY_CITYNAME_BAMAKO","IDS_WCL_BODY_MALI","GMT+0",0,1,0,0,"Africa/Bamako");
 125                 INSERT INTO "city_table" VALUES(27,"IDS_WCL_BODY_CITYNAME_BANGKOK","IDS_WCL_BODY_THAILAND","GMT+7",0,1,0,0,"Asia/Bangkok");
 126                 INSERT INTO "city_table" VALUES(28,"IDS_WCL_BODY_CITYNAME_BANGUI","IDS_WCL_BODY_CENTRAL_AFRICAN_REPUBLIC","GMT+1",0,1,0,0,"Africa/Bangui");
 127                 INSERT INTO "city_table" VALUES(29,"IDS_WCL_BODY_CITYNAME_BARCELONA","IDS_WCL_BODY_SPAIN","GMT+2",0,1,0,0,"Europe/Madrid");
 128                 INSERT INTO "city_table" VALUES(30,"IDS_WCL_BODY_CITYNAME_BARI","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 129                 INSERT INTO "city_table" VALUES(31,"IDS_WCL_BODY_CITYNAME_BASSE_TERRE","IDS_WCL_BODY_GUADELOUPE","GMT-4",0,1,0,0,"America/Guadeloupe");
 130                 INSERT INTO "city_table" VALUES(32,"IDS_WCL_BODY_CITYNAME_BEIJING","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 131                 INSERT INTO "city_table" VALUES(33,"IDS_WCL_BODY_CITYNAME_BEIRUT","IDS_WCL_BODY_LEBANON","GMT+2",0,1,0,0,"Asia/Beirut");
 132                 INSERT INTO "city_table" VALUES(34,"IDS_WCL_BODY_CITYNAME_BELGRADE","IDS_WCL_BODY_SERBIA","GMT+1",0,1,0,0,"Europe/Belgrade");
 133                 INSERT INTO "city_table" VALUES(35,"IDS_WCL_BODY_CITYNAME_BELIZE_CITY","IDS_WCL_BODY_BELIZE","GMT-6",0,1,0,0,"America/Belize");
 134                 INSERT INTO "city_table" VALUES(36,"IDS_WCL_BODY_CITYNAME_BERLIN","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
 135                 INSERT INTO "city_table" VALUES(37,"IDS_WCL_BODY_CITYNAME_BERN","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");
 136                 INSERT INTO "city_table" VALUES(38,"IDS_WCL_BODY_CITYNAME_BISHKEK","IDS_WCL_BODY_KYRGYZSTAN","GMT+6",0,1,0,0,"Asia/Bishkek");
 137                 INSERT INTO "city_table" VALUES(39,"IDS_WCL_BODY_CITYNAME_GUINEA_BISSAU","IDS_WCL_BODY_CITYNAME_GUINEA_BISSAU","GMT+0",0,1,0,0,"Africa/Bissau");
 138                 INSERT INTO "city_table" VALUES(40,"IDS_WCL_BODY_CITYNAME_BOGOTA","IDS_WCL_BODY_COLOMBIA","GMT-5",0,1,0,0,"America/Bogota");
 139                 INSERT INTO "city_table" VALUES(41,"IDS_WCL_BODY_CITYNAME_BOLOGNA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 140                 INSERT INTO "city_table" VALUES(42,"IDS_WCL_BODY_BOSTON","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 141                 INSERT INTO "city_table" VALUES(43,"IDS_WCL_BODY_CITYNAME_BRASILIA","IDS_WCL_BODY_BRAZIL","GMT-3",0,1,0,0,"America/Sao_Paulo");
 142                 INSERT INTO "city_table" VALUES(44,"IDS_WCL_BODY_CITYNAME_BRATISLAVA","IDS_WCL_BODY_SLOVAKIA","GMT+2",0,1,0,0,"Europe/Bratislava");
 143                 INSERT INTO "city_table" VALUES(45,"IDS_WCL_BODY_CITYNAME_BRIDGETOWN","IDS_WCL_BODY_BARBADOS","GMT-4",0,1,0,0,"America/Barbados");
 144                 INSERT INTO "city_table" VALUES(46,"IDS_WCL_BODY_CITYNAME_BRISBANE","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Brisbane");
 145                 INSERT INTO "city_table" VALUES(47,"IDS_WCL_BODY_CITYNAME_BRUSSELS","IDS_WCL_BODY_BELGIUM","GMT+1",0,1,0,0,"Europe/Brussels");
 146                 INSERT INTO "city_table" VALUES(48,"IDS_WCL_BODY_CITYNAME_BUCHAREST","IDS_WCL_BODY_ROMANIA","GMT+3",0,1,0,0,"Europe/Bucharest");
 147                 INSERT INTO "city_table" VALUES(49,"IDS_WCL_BODY_CITYNAME_BUDAPEST","IDS_WCL_BODY_HUNGARY_M_COUNTRY","GMT+1",0,1,0,0,"Europe/Budapest");
 148                 INSERT INTO "city_table" VALUES(50,"IDS_WCL_BODY_CITYNAME_BUENOSAIRES","IDS_WCL_BODY_ARGENTINA","GMT-3",0,1,0,0,"America/Argentina/Buenos_Aires");
 149                 INSERT INTO "city_table" VALUES(51,"IDS_WCL_BODY_CITYNAME_CAIRO","IDS_WCL_BODY_EGYPT","GMT+2",0,1,0,0,"Africa/Cairo");
 150                 INSERT INTO "city_table" VALUES(52,"IDS_WCL_BODY_CITYNAME_CALGARY","IDS_WCL_BODY_CANADA","GMT-7",0,1,0,0,"MST7MDT");
 151                 INSERT INTO "city_table" VALUES(53,"IDS_WCL_BODY_CITYNAME_CANARY_ISLANDS","IDS_WCL_BODY_SPAIN","GMT+0",0,1,0,0,"Atlantic/Canary");
 152                 INSERT INTO "city_table" VALUES(54,"IDS_WCL_BODY_CITYNAME_CANBERRA","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Canberra");
 153                 INSERT INTO "city_table" VALUES(55,"IDS_WCL_BODY_CITYNAME_CANTON","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 154                 INSERT INTO "city_table" VALUES(56,"IDS_WCL_BODY_CITYNAME_CAPE_TOWN","IDS_WCL_BODY_REPUBLIC_OF_SOUTH_AFRICA","GMT+2",0,1,0,0,"Africa/Johannesburg");
 155                 INSERT INTO "city_table" VALUES(57,"IDS_WCL_BODY_CITYNAME_CARACAS","IDS_WCL_BODY_VENEZUELA","GMT-4:30",0,1,0,0,"America/Caracas");
 156                 INSERT INTO "city_table" VALUES(58,"IDS_WCL_BODY_CITYNAME_CARDIFF","IDS_WCL_BODY_WALES_M_COUNTRYNAME","GMT+0",0,1,0,0,"Europe/London");
 157                 INSERT INTO "city_table" VALUES(59,"IDS_WCL_BODY_CITYNAME_CASABLANCA","IDS_WCL_BODY_MOROCCO","GMT+0",0,1,0,0,"Africa/Casablanca");
 158                 INSERT INTO "city_table" VALUES(60,"IDS_WCL_BODY_CITYNAME_CATANZARO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 159                 INSERT INTO "city_table" VALUES(61,"IDS_WCL_BODY_CITYNAME_CAYENNE","IDS_WCL_BODY_FRENCH_GUIANA","GMT-3",0,1,0,0,"America/Cayenne");
 160                 INSERT INTO "city_table" VALUES(62,"IDS_WCL_BODY_CITYNAME_CHARLOTTE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 161                 INSERT INTO "city_table" VALUES(63,"IDS_WCL_BODY_CITYNAME_CHARLOTTE_AMALIE","IDS_WCL_BODY_UNITED_STATES_VIRGIN_ISLANDS_M_COUNTRYNAME","GMT-5:30",0,1,0,0,"America/St_Thomas");
 162                 INSERT INTO "city_table" VALUES(64,"IDS_WCL_BODY_CITYNAME_CHELYABINSK","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
 163                 INSERT INTO "city_table" VALUES(65,"IDS_WCL_BODY_CITYNAME_CHENNAI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
 164                 INSERT INTO "city_table" VALUES(66,"IDS_WCL_BODY_CITYNAME_CHICAGO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"America/Chicago");
 165                 INSERT INTO "city_table" VALUES(67,"IDS_WCL_BODY_CITYNAME_CHISINAU","IDS_WCL_BODY_MOLDOVA","GMT+2",0,1,0,0,"Europe/Chisinau");
 166                 INSERT INTO "city_table" VALUES(68,"IDS_WCL_BODY_CITYNAME_CHITA","IDS_WCL_BODY_RUSSIA","GMT+10",0,1,0,0,"Asia/Yakutsk");
 167                 INSERT INTO "city_table" VALUES(69,"IDS_WCL_BODY_CITYNAME_CLEVELAND","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 168                 INSERT INTO "city_table" VALUES(70,"IDS_WCL_BODY_CITYNAME_COLOMBO","IDS_WCL_BODY_SRI_LANKA","GMT+5:30",0,1,0,0,"Asia/Colombo");
 169                 INSERT INTO "city_table" VALUES(71,"IDS_WCL_BODY_CITYNAME_COLUMBUS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 170                 INSERT INTO "city_table" VALUES(72,"IDS_WCL_BODY_CITYNAME_CONAKRY","IDS_WCL_BODY_GUINEA","GMT+1",0,1,0,0,"Africa/Conakry");
 171                 INSERT INTO "city_table" VALUES(73,"IDS_WCL_BODY_CITYNAME_COPENHAGEN","IDS_WCL_BODY_DENMARK","GMT+1",0,1,0,0,"Europe/Copenhagen");
 172                 INSERT INTO "city_table" VALUES(74,"IDS_WCL_BODY_CITYNAME_CORK","IDS_WCL_BODY_IRELAND","GMT+0",0,1,0,0,"Europe/Dublin");
 173                 INSERT INTO "city_table" VALUES(75,"IDS_WCL_BODY_CITYNAME_CROTONE","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 174                 INSERT INTO "city_table" VALUES(76,"IDS_WCL_BODY_CITYNAME_DAKAR","IDS_WCL_BODY_SENEGAL","GMT+0",0,1,0,0,"Africa/Dakar");
 175                 INSERT INTO "city_table" VALUES(77,"IDS_WCL_BODY_CITYNAME_DALLAS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 176                 INSERT INTO "city_table" VALUES(78,"IDS_WCL_BODY_CITYNAME_DAMASCUS","IDS_WCL_BODY_SYRIA","GMT+2",0,1,0,0,"Asia/Damascus");
 177                 INSERT INTO "city_table" VALUES(79,"IDS_WCL_BODY_CITYNAME_DAR_ES_SALAAM","IDS_WCL_BODY_TANZANIA","GMT+3",0,1,0,0,"Africa/Dar_es_Salaam");
 178                 INSERT INTO "city_table" VALUES(80,"IDS_WCL_BODY_CITYNAME_DARWIN","IDS_WCL_BODY_AUSTRALIA","GMT+9:30",0,1,0,0,"Australia/Darwin");
 179                 INSERT INTO "city_table" VALUES(81,"IDS_WCL_BODY_CITYNAME_DELHI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
 180                 INSERT INTO "city_table" VALUES(82,"IDS_WCL_BODY_CITYNAME_DENPASAR","IDS_WCL_BODY_INDONESIA","GMT+8",0,1,0,0,"Asia/Makassar");
 181                 INSERT INTO "city_table" VALUES(83,"IDS_WCL_BODY_CITYNAME_DENVER","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Denver");
 182                 INSERT INTO "city_table" VALUES(84,"IDS_WCL_BODY_CITYNAME_DETROIT","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Detroit");
 183                 INSERT INTO "city_table" VALUES(85,"IDS_WCL_BODY_CITYNAME_DHAKA","IDS_WCL_BODY_BANGLADESH","GMT+6",0,1,0,0,"Asia/Dhaka");
 184                 INSERT INTO "city_table" VALUES(86,"IDS_WCL_BODY_CITYNAME_DIEGO_GARCIA","IDS_WCL_BODY_UNITED_KINGDOM","GMT+5",0,1,0,0,"Indian/Chagos");
 185                 INSERT INTO "city_table" VALUES(87,"IDS_WCL_BODY_CITYNAME_DJIBOUTI","IDS_WCL_BODY_DJIBOUTI","GMT+3",0,1,0,0,"Africa/Djibouti");
 186                 INSERT INTO "city_table" VALUES(88,"IDS_WCL_BODY_CITYNAME_DOHA","IDS_WCL_BODY_QATAR","GMT+3",0,1,0,0,"Asia/Qatar");
 187                 INSERT INTO "city_table" VALUES(89,"IDS_WCL_BODY_CITYNAME_DOUALA","IDS_WCL_BODY_CAMEROON","GMT+1",0,1,0,0,"Africa/Douala");
 188                 INSERT INTO "city_table" VALUES(90,"IDS_WCL_BODY_CITYNAME_DUBAI","IDS_WCL_BODY_UNITED_ARAB_EMIRATES","GMT+4",0,1,0,0,"Asia/Dubai");
 189                 INSERT INTO "city_table" VALUES(91,"IDS_WCL_BODY_CITYNAME_DUBLIN","IDS_WCL_BODY_IRELAND","GMT+0",0,1,0,0,"Europe/Dublin");
 190                 INSERT INTO "city_table" VALUES(92,"IDS_WCL_BODY_CITYNAME_DUSHANBE","IDS_WCL_BODY_TAJIKISTAN","GMT+5",0,1,0,0,"Asia/Dushanbe");
 191                 INSERT INTO "city_table" VALUES(93,"IDS_WCL_BODY_CITYNAME_EASTER_ISLAND","IDS_WCL_BODY_CHILE","GMT-6",0,1,0,0,"Pacific/Easter");
 192                 INSERT INTO "city_table" VALUES(94,"IDS_WCL_BODY_CITYNAME_EDINBURGH","IDS_WCL_BODY_SCOTLAND_M_COUNTRYNAME","GMT+0",0,1,0,0,"Europe/London");
 193                 INSERT INTO "city_table" VALUES(95,"IDS_WCL_BODY_CITYNAME_EL_PASO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"MST7MDT");
 194                 INSERT INTO "city_table" VALUES(96,"IDS_WCL_BODY_CITYNAME_FLORENCE","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 195                 INSERT INTO "city_table" VALUES(97,"IDS_WCL_BODY_CITYNAME_FORT_DE_FRANCE","IDS_WCL_BODY_MARTINIQUE","GMT-4",0,1,0,0,"America/Martinique");
 196                 INSERT INTO "city_table" VALUES(98,"IDS_WCL_BODY_CITYNAME_FREETOWN","IDS_WCL_BODY_SIERRA_LEONE","GMT+0",0,1,0,0,"Africa/Freetown");
 197                 INSERT INTO "city_table" VALUES(99,"IDS_WCL_BODY_CITYNAME_GABORONE","IDS_WCL_BODY_BOTSWANA","GMT+2",0,1,0,0,"Africa/Gaborone");
 198                 INSERT INTO "city_table" VALUES(100,"IDS_WCL_BODY_CITYNAME_GALAPAGOS_ISLANDS","IDS_WCL_BODY_ECUADOR","GMT-7",0,1,0,0,"Pacific/Galapagos");
 199                 INSERT INTO "city_table" VALUES(101,"IDS_WCL_BODY_CITYNAME_GENEVA","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Paris");
 200                 INSERT INTO "city_table" VALUES(102,"IDS_WCL_BODY_CITYNAME_GENOA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 201                 INSERT INTO "city_table" VALUES(103,"IDS_WCL_BODY_CITYNAME_GEORGETOWN","IDS_WCL_BODY_GUYANA","GMT-4",0,1,0,0,"America/Guyana");
 202                 INSERT INTO "city_table" VALUES(104,"IDS_WCL_BODY_CITYNAME_GRYTVIKEN","IDS_WCL_BODY_CITYNAME_SOUTH_GEORGIA","GMT-2",0,1,0,0,"Atlantic/South_Georgia");
 203                 INSERT INTO "city_table" VALUES(105,"IDS_WCL_BODY_CITYNAME_GUAM","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT+10",0,1,0,0,"Pacific/Guam");
 204                 INSERT INTO "city_table" VALUES(106,"IDS_WCL_BODY_GUATEMALA_CITY","IDS_WCL_BODY_GUATEMALA","GMT-6",0,1,0,0,"America/Guatemala");
 205                 INSERT INTO "city_table" VALUES(107,"IDS_WCL_BODY_CITYNAME_GUSTAVIA","IDS_WCL_BODY_CITYNAME_SAINT_BARTHELEMY","GMT-4",0,1,0,0,"America/Antigua");
 206                 INSERT INTO "city_table" VALUES(108,"IDS_WCL_BODY_CITYNAME_HALIFAX","IDS_WCL_BODY_CANADA","GMT-4",0,1,0,0,"America/Halifax");
 207                 INSERT INTO "city_table" VALUES(109,"IDS_WCL_BODY_CITYNAME_HAMBURG","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
 208                 INSERT INTO "city_table" VALUES(110,"IDS_WCL_BODY_CITYNAME_HANOI","IDS_WCL_BODY_VIETNAM","GMT+7",0,1,0,0,"Asia/Ho_Chi_Minh");
 209                 INSERT INTO "city_table" VALUES(111,"IDS_WCL_BODY_CITYNAME_HARARE","IDS_WCL_BODY_ZIMBABWE","GMT+2",0,1,0,0,"Africa/Harare");
 210                 INSERT INTO "city_table" VALUES(112,"IDS_WCL_BODY_CITYNAME_HAVANA","IDS_WCL_BODY_CUBA","GMT-5",0,1,0,0,"America/Havana");
 211                 INSERT INTO "city_table" VALUES(113,"IDS_WCL_BODY_CITYNAME_HAWAII","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-10",0,1,0,0,"Pacific/Honolulu");
 212                 INSERT INTO "city_table" VALUES(114,"IDS_WCL_BODY_CITYNAME_HELSINKI","IDS_WCL_BODY_FINLAND","GMT+2",0,1,0,0,"Europe/Helsinki");
 213                 INSERT INTO "city_table" VALUES(115,"IDS_WCL_BODY_CITYNAME_HOBART","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Hobart");
 214                 INSERT INTO "city_table" VALUES(116,"IDS_WCL_BODY_CITYNAME_HONGKONG","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Hong_Kong");
 215                 INSERT INTO "city_table" VALUES(117,"IDS_WCL_BODY_CITYNAME_HONOLULU","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-10",0,1,0,0,"Pacific/Honolulu");
 216                 INSERT INTO "city_table" VALUES(118,"IDS_WCL_BODY_CITYNAME_HOUSTON","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 217                 INSERT INTO "city_table" VALUES(119,"IDS_WCL_BODY_CITYNAME_HOVD","IDS_WCL_BODY_MONGOLIA","GMT+8",0,1,0,0,"Asia/Hovd");
 218                 INSERT INTO "city_table" VALUES(120,"IDS_WCL_BODY_CITYNAME_INDIANAPOLIS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Indiana/Indianapolis");
 219                 INSERT INTO "city_table" VALUES(121,"IDS_WCL_BODY_CITYNAME_IRKUTSK","IDS_WCL_BODY_RUSSIA","GMT+9",0,1,0,0,"Asia/Irkutsk");
 220                 INSERT INTO "city_table" VALUES(122,"IDS_WCL_BODY_CITYNAME_ISLAMABAD","IDS_WCL_BODY_PAKISTAN","GMT+5",0,1,0,0,"Asia/Karachi");
 221                 INSERT INTO "city_table" VALUES(123,"IDS_WCL_BODY_CITYNAME_ISTANBUL","IDS_WCL_BODY_TURKEY","GMT+2",0,1,0,0,"Europe/Istanbul");
 222                 INSERT INTO "city_table" VALUES(124,"IDS_WCL_BODY_CITYNAME_IZHEVSK","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
 223                 INSERT INTO "city_table" VALUES(125,"IDS_WCL_BODY_CITYNAME_JAKARTA","IDS_WCL_BODY_INDONESIA","GMT+7",0,1,0,0,"Asia/Jakarta");
 224                 INSERT INTO "city_table" VALUES(126,"IDS_WCL_BODY_CITYNAME_JEDDAH","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
 225                 INSERT INTO "city_table" VALUES(127,"IDS_WCL_BODY_CITYNAME_JERUSALEM","IDS_WCL_BODY_ISRAEL","GMT+2",0,1,0,0,"Asia/Jerusalem");
 226                 INSERT INTO "city_table" VALUES(128,"IDS_WCL_BODY_CITYNAME_JOHANNESBURG","IDS_WCL_BODY_REPUBLIC_OF_SOUTH_AFRICA","GMT+2",0,1,0,0,"Africa/Johannesburg");
 227                 INSERT INTO "city_table" VALUES(129,"IDS_WCL_BODY_CITYNAME_KABUL","IDS_WCL_BODY_AFGHANISTAN","GMT+4:30",0,1,0,0,"Asia/Kabul");
 228                 INSERT INTO "city_table" VALUES(130,"IDS_WCL_BODY_CITYNAME_KALININGRAD","IDS_WCL_BODY_RUSSIA","GMT+3",0,1,0,0,"Europe/Kaliningrad");
 229                 INSERT INTO "city_table" VALUES(131,"IDS_WCL_BODY_CITYNAME_KAMCHATKA","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Kamchatka");
 230                 INSERT INTO "city_table" VALUES(132,"IDS_WCL_BODY_CITYNAME_KAMPALA","IDS_WCL_BODY_UGANDA","GMT+3",0,1,0,0,"Africa/Kampala");
 231                 INSERT INTO "city_table" VALUES(133,"IDS_WCL_BODY_CITYNAME_KARACHI","IDS_WCL_BODY_PAKISTAN","GMT+5",0,1,0,0,"Asia/Karachi");
 232                 INSERT INTO "city_table" VALUES(134,"IDS_WCL_BODY_CITYNAME_KATHMANDU","IDS_WCL_BODY_NEPAL","GMT+5:45",0,1,0,0,"Asia/Kathmandu");
 233                 INSERT INTO "city_table" VALUES(135,"IDS_WCL_BODY_CITYNAME_KHABAROVSK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Vladivostok");
 234                 INSERT INTO "city_table" VALUES(136,"IDS_WCL_BODY_CITYNAME_KHARKIV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
 235                 INSERT INTO "city_table" VALUES(137,"IDS_WCL_BODY_CITYNAME_KHARTOUM","IDS_WCL_BODY_SUDAN","GMT+3",0,1,0,0,"Africa/Khartoum");
 236                 INSERT INTO "city_table" VALUES(138,"IDS_WCL_BODY_CITYNAME_KIEV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
 237                 INSERT INTO "city_table" VALUES(139,"IDS_WCL_BODY_CITYNAME_KINGSTON","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Toronto");
 238                 INSERT INTO "city_table" VALUES(140,"IDS_WCL_BODY_CITYNAME_KINGSTON","IDS_WCL_BODY_JAMAICA","GMT-5",0,1,0,0,"America/Jamaica");
 239                 INSERT INTO "city_table" VALUES(141,"IDS_WCL_BODY_CITYNAME_KINSHASA","IDS_WCL_BODY_DEMOCRATIC_REPUBLIC_OF_THE_CONGO","GMT+1",0,1,0,0,"Africa/Kinshasa");
 240                 INSERT INTO "city_table" VALUES(142,"IDS_WCL_BODY_CITYNAME_KOLKATA","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
 241                 INSERT INTO "city_table" VALUES(143,"IDS_WCL_BODY_CITYNAME_KRASNOYARSK","IDS_WCL_BODY_RUSSIA","GMT+8",0,1,0,0,"Asia/Krasnoyarsk");
 242                 INSERT INTO "city_table" VALUES(144,"IDS_WCL_BODY_CITYNAME_KUALA_LUMPUR","IDS_WCL_BODY_MALAYSIA","GMT+8",0,1,0,0,"Asia/Kuala_Lumpur");
 243                 INSERT INTO "city_table" VALUES(145,"IDS_WCL_BODY_KUWAIT","IDS_WCL_BODY_KUWAIT","GMT+3",0,1,0,0,"Asia/Kuwait");
 244                 INSERT INTO "city_table" VALUES(146,"IDS_WCL_BODY_CITYNAME_KIEV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
 245                 INSERT INTO "city_table" VALUES(147,"IDS_WCL_BODY_CITYNAME_LOS_ANGELES","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Los_Angeles");
 246                 INSERT INTO "city_table" VALUES(148,"IDS_WCL_BODY_CITYNAME_LA_PAZ","IDS_WCL_BODY_BOLIVIA","GMT-4",0,1,0,0,"America/La_Paz");
 247                 INSERT INTO "city_table" VALUES(149,"IDS_WCL_BODY_CITYNAME_LAGOS","IDS_WCL_BODY_NIGERIA","GMT+1",0,1,0,0,"Africa/Lagos");
 248                 INSERT INTO "city_table" VALUES(150,"IDS_WCL_BODY_CITYNAME_LAS_VEGAS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
 249                 INSERT INTO "city_table" VALUES(151,"IDS_WCL_BODY_CITYNAME_LIMA","IDS_WCL_BODY_PERU","GMT-5",0,1,0,0,"America/Lima");
 250                 INSERT INTO "city_table" VALUES(152,"IDS_WCL_BODY_CITYNAME_LISBON","IDS_WCL_BODY_PORTUGAL","GMT+0",0,1,0,0,"Europe/Lisbon");
 251                 INSERT INTO "city_table" VALUES(153,"IDS_WCL_BODY_CITYNAME_LJUBLJANA","IDS_WCL_BODY_SLOVAKIA","GMT+1",0,1,0,0,"Europe/Ljubljana");
 252                 INSERT INTO "city_table" VALUES(154,"IDS_WCL_BODY_CITYNAME_LONDON","IDS_WCL_BODY_UNITED_KINGDOM","GMT+0",0,1,0,0,"Europe/London");
 253                 INSERT INTO "city_table" VALUES(155,"IDS_WCL_BODY_CITYNAME_LONGHUA","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 254                 INSERT INTO "city_table" VALUES(156,"IDS_WCL_BODY_CITYNAME_LOUISVILLE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Kentucky/Louisville");
 255                 INSERT INTO "city_table" VALUES(157,"IDS_WCL_BODY_CITYNAME_LUANDA","IDS_WCL_BODY_ANGOLA","GMT+1",0,1,0,0,"Africa/Luanda");
 256                 INSERT INTO "city_table" VALUES(158,"IDS_WCL_BODY_CITYNAME_LUBUMBASHI","IDS_WCL_BODY_DEMOCRATIC_REPUBLIC_OF_THE_CONGO","GMT+2",0,1,0,0,"Africa/Lubumbashi");
 257                 INSERT INTO "city_table" VALUES(159,"IDS_WCL_BODY_CITYNAME_LUSAKA","IDS_WCL_BODY_ZAMBIA","GMT+2",0,1,0,0,"Africa/Lusaka");
 258                 INSERT INTO "city_table" VALUES(160,"IDS_WCL_BODY_LUXEMBOURG","IDS_WCL_BODY_LUXEMBOURG","GMT+1",0,1,0,0,"Europe/Luxembourg");
 259                 INSERT INTO "city_table" VALUES(161,"IDS_WCL_BODY_CITYNAME_LVIV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
 260                 INSERT INTO "city_table" VALUES(162,"IDS_WCL_BODY_CITYNAME_MACAU","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Macau");
 261                 INSERT INTO "city_table" VALUES(163,"IDS_WCL_BODY_CITYNAME_MADRID","IDS_WCL_BODY_SPAIN","GMT+2",0,1,0,0,"Europe/Madrid");
 262                 INSERT INTO "city_table" VALUES(164,"IDS_WCL_BODY_CITYNAME_MAGADAN","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Magadan");
 263                 INSERT INTO "city_table" VALUES(165,"IDS_WCL_BODY_CITYNAME_MALABO","IDS_WCL_BODY_CITYNAME_EQUAORIAL_GUINEA","GMT+1",0,1,0,0,"Africa/Malabo");
 264                 INSERT INTO "city_table" VALUES(166,"IDS_WCL_BODY_CITYNAME_MALE","IDS_WCL_BODY_MALDIVES","GMT+5",0,1,0,0,"Indian/Maldives");
 265                 INSERT INTO "city_table" VALUES(167,"IDS_WCL_BODY_CITYNAME_MANAGUA","IDS_WCL_BODY_NICARAGUA","GMT-6",0,1,0,0,"America/Managua");
 266                 INSERT INTO "city_table" VALUES(168,"IDS_WCL_BODY_CITYNAME_MANAMA","IDS_WCL_BODY_BAHRAIN","GMT+3",0,1,0,0,"Asia/Bahrain");
 267                 INSERT INTO "city_table" VALUES(169,"IDS_WCL_BODY_CITYNAME_MANILA","IDS_WCL_BODY_PHILIPPINES","GMT+8",0,1,0,0,"Asia/Manila");
 268                 INSERT INTO "city_table" VALUES(170,"IDS_WCL_BODY_CITYNAME_MAPUTO","IDS_WCL_BODY_MOZAMBIQUE","GMT+2",0,1,0,0,"Africa/Maputo");
 269                 INSERT INTO "city_table" VALUES(171,"IDS_WCL_BODY_CITYNAME_MARIGOT","IDS_WCL_BODY_CITYNAME_SAINT_MARTIN","GMT-4",0,1,0,0,"America/Marigot");
 270                 INSERT INTO "city_table" VALUES(172,"IDS_WCL_BODY_CITYNAME_MAZATLAN","IDS_WCL_BODY_MEXICO","GMT-7",0,1,0,0,"America/Mazatlan");
 271                 INSERT INTO "city_table" VALUES(173,"IDS_WCL_BODY_MECCA","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
 272                 INSERT INTO "city_table" VALUES(174,"IDS_WCL_BODY_CITYNAME_MELBOURNE","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Melbourne");
 273                 INSERT INTO "city_table" VALUES(175,"IDS_WCL_BODY_CITYNAME_MEMPHIS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 274                 INSERT INTO "city_table" VALUES(176,"IDS_WCL_BODY_CITYNAME_MESSINA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 275                 INSERT INTO "city_table" VALUES(177,"IDS_WCL_BODY_CITYNAME_MEXICO_CITY","IDS_WCL_BODY_MEXICO","GMT-6",0,1,0,0,"America/Mexico_City");
 276                 INSERT INTO "city_table" VALUES(178,"IDS_WCL_BODY_CITYNAME_MIAMI","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 277                 INSERT INTO "city_table" VALUES(179,"IDS_WCL_BODY_CITYNAME_MID_ATLANTIC","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-2",0,1,0,0,"America/New_York");
 278                 INSERT INTO "city_table" VALUES(180,"IDS_WCL_BODY_CITYNAME_MIDWAY_ATOLL","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-11",0,1,0,0,"Pacific/Midway");
 279                 INSERT INTO "city_table" VALUES(181,"IDS_WCL_BODY_CITYNAME_MILAN","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 280                 INSERT INTO "city_table" VALUES(182,"IDS_WCL_BODY_CITYNAME_MILWAUKEE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 281                 INSERT INTO "city_table" VALUES(183,"IDS_WCL_BODY_CITYNAME_MINSK","IDS_WCL_BODY_BELARUS","GMT+2",0,1,0,0,"Europe/Minsk");
 282                 INSERT INTO "city_table" VALUES(184,"IDS_WCL_BODY_CITYNAME_MOGADISHU","IDS_WCL_BODY_SOMALIA","GMT+2",0,1,0,0,"Africa/Mogadishu");
 283                 INSERT INTO "city_table" VALUES(185,"IDS_WCL_BODY_CITYNAME_MONROVIA","IDS_WCL_BODY_LIBERIA","GMT+0",0,1,0,0,"Africa/Monrovia");
 284                 INSERT INTO "city_table" VALUES(186,"IDS_WCL_BODY_CITYNAME_MONTEVIDEO","IDS_WCL_BODY_URUGUAY","GMT-3",0,1,0,0,"America/Montevideo");
 285                 INSERT INTO "city_table" VALUES(187,"IDS_WCL_BODY_CITYNAME_MONTREAL","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Montreal");
 286                 INSERT INTO "city_table" VALUES(188,"IDS_WCL_BODY_CITYNAME_MOSCOW","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
 287                 INSERT INTO "city_table" VALUES(189,"IDS_WCL_BODY_CITYNAME_MUMBAI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
 288                 INSERT INTO "city_table" VALUES(190,"IDS_WCL_BODY_CITYNAME_MUNICH","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
 289                 INSERT INTO "city_table" VALUES(191,"IDS_WCL_BODY_CITYNAME_MUSCAT","IDS_WCL_BODY_OMAN","GMT+4",0,1,0,0,"Asia/Muscat");
 290                 INSERT INTO "city_table" VALUES(192,"IDS_WCL_BODY_CITYNAME_NAIROBI","IDS_WCL_BODY_KENYA","GMT+3",0,1,0,0,"Africa/Nairobi");
 291                 INSERT INTO "city_table" VALUES(193,"IDS_WCL_BODY_CITYNAME_NAPLES","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 292                 INSERT INTO "city_table" VALUES(194,"IDS_WCL_BODY_CITYNAME_NATERS","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");
 293                 INSERT INTO "city_table" VALUES(195,"IDS_WCL_BODY_CITYNAME_NDJAMENA","IDS_WCL_BODY_CHAD","GMT+1",0,1,0,0,"Africa/Ndjamena");
 294                 INSERT INTO "city_table" VALUES(196,"IDS_WCL_BODY_CITYNAME_NEWDELHI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
 295                 INSERT INTO "city_table" VALUES(197,"IDS_WCL_BODY_CITYNAME_NEWYORK","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-4",0,1,0,0,"America/New_York");
 296                 INSERT INTO "city_table" VALUES(198,"IDS_WCL_BODY_CITYNAME_NEWFOUNDLAND","IDS_WCL_BODY_CANADA","GMT-3:30",0,1,0,0,"America/St_Johns");
 297                 INSERT INTO "city_table" VALUES(199,"IDS_WCL_BODY_CITYNAME_NIAMEY","IDS_WCL_BODY_NIGER","GMT+1",0,1,0,0,"Africa/Niamey");
 298                 INSERT INTO "city_table" VALUES(200,"IDS_WCL_BODY_CITYNAME_NOUAKCHOTT","IDS_WCL_BODY_MAURITANIA","GMT+1",0,1,0,0,"Africa/Nouakchott");
 299                 INSERT INTO "city_table" VALUES(201,"IDS_WCL_BODY_CITYNAME_NOUMEA","IDS_WCL_BODY_NEW_CALEDONIA","GMT+11",0,1,0,0,"Pacific/Noumea");
 300                 INSERT INTO "city_table" VALUES(202,"IDS_WCL_BODY_CITYNAME_NOVOKUZNETSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Novokuznetsk");
 301                 INSERT INTO "city_table" VALUES(203,"IDS_WCL_BODY_CITYNAME_NOVOSIBIRSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Novosibirsk");
 302                 INSERT INTO "city_table" VALUES(204,"IDS_WCL_BODY_CITYNAME_NUKUALOFA","IDS_WCL_BODY_TONGA","GMT+13",0,1,0,0,"Pacific/Tongatapu");
 303                 INSERT INTO "city_table" VALUES(205,"IDS_WCL_BODY_CITYNAME_NUUK","IDS_WCL_BODY_GREENLAND_M_COUNTRYNAME","GMT-3",0,1,0,0,"America/Godthab");
 304                 INSERT INTO "city_table" VALUES(206,"IDS_WCL_BODY_CITYNAME_OMSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Omsk");
 305                 INSERT INTO "city_table" VALUES(207,"IDS_WCL_BODY_CITYNAME_OSAKA","IDS_WCL_BODY_JAPAN","GMT+9",0,1,0,0,"Asia/Tokyo");
 306                 INSERT INTO "city_table" VALUES(208,"IDS_WCL_BODY_CITYNAME_OTTAWA","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"EST5EDT");
 307                 INSERT INTO "city_table" VALUES(209,"IDS_WCL_BODY_CITYNAME_OUAGADOUGOU","IDS_WCL_BODY_BURKINA_FASO","GMT+0",0,1,0,0,"Africa/Ouagadougou");
 308                 INSERT INTO "city_table" VALUES(210,"IDS_WCL_BODY_CITYNAME_PAGO_PAGO","IDS_WCL_BODY_INDEPENDENT_STATE_OF_SAMOA","GMT-11",0,1,0,0,"Pacific/Pago_Pago");
 309                 INSERT INTO "city_table" VALUES(211,"IDS_WCL_BODY_CITYNAME_PALERMO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 310                 INSERT INTO "city_table" VALUES(212,"IDS_WCL_BODY_PANAMA_CITY","IDS_WCL_BODY_PANAMA","GMT-6",0,1,0,0,"America/Panama");
 311                 INSERT INTO "city_table" VALUES(213,"IDS_WCL_BODY_CITYNAME_PARAMARIBO","IDS_WCL_BODY_SURINAME","GMT-3",0,1,0,0,"America/Paramaribo");
 312                 INSERT INTO "city_table" VALUES(214,"IDS_WCL_BODY_CITYNAME_PARIS","IDS_WCL_BODY_FRANCE","GMT+1",0,1,0,0,"Europe/Paris");
 313                 INSERT INTO "city_table" VALUES(215,"IDS_WCL_BODY_CITYNAME_PERM","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
 314                 INSERT INTO "city_table" VALUES(216,"IDS_WCL_BODY_CITYNAME_PERTH","IDS_WCL_BODY_AUSTRALIA","GMT+8",0,1,0,0,"Australia/Perth");
 315                 INSERT INTO "city_table" VALUES(217,"IDS_WCL_BODY_CITYNAME_PETROPAVLOVSK_KAMCHATSKIY","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Kamchatka");
 316                 INSERT INTO "city_table" VALUES(218,"IDS_WCL_BODY_CITYNAME_PHILADELPHIA","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 317                 INSERT INTO "city_table" VALUES(219,"IDS_WCL_BODY_CITYNAME_PHNOM_PENH","IDS_WCL_BODY_CAMBODIA","GMT-5",0,1,0,0,"Asia/Phnom_Penh");
 318                 INSERT INTO "city_table" VALUES(220,"IDS_WCL_BODY_CITYNAME_PHOENIX","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Phoenix");
 319                 INSERT INTO "city_table" VALUES(221,"IDS_WCL_BODY_CITYNAME_PODGORICA","IDS_WCL_BODY_MONTENEGRO","GMT+1",0,1,0,0,"Europe/Podgorica");
 320                 INSERT INTO "city_table" VALUES(222,"IDS_WCL_BODY_CITYNAME_PONTA_DELGADA","IDS_WCL_BODY_PORTUGAL","GMT-1",0,1,0,0,"Atlantic/Azores");
 321                 INSERT INTO "city_table" VALUES(223,"IDS_WCL_BODY_CITYNAME_PORT_LOUIS","IDS_WCL_BODY_MAURITIUS","GMT+4",0,1,0,0,"Indian/Mauritius");
 322                 INSERT INTO "city_table" VALUES(224,"IDS_WCL_BODY_CITYNAME_PORT_AU_PRINCE","IDS_WCL_BODY_HAITI","GMT-5",0,1,0,0,"America/Port-au-Prince");
 323                 INSERT INTO "city_table" VALUES(225,"IDS_WCL_BODY_CITYNAME_PORTLAND","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
 324                 INSERT INTO "city_table" VALUES(226,"IDS_WCL_BODY_CITYNAME_PRAGUE","IDS_WCL_BODY_CZECH_REPUBLIC","GMT+1",0,1,0,0,"Europe/Prague");
 325                 INSERT INTO "city_table" VALUES(227,"IDS_WCL_BODY_CITYNAME_PYONGYANG","IDS_WCL_BODY_NORTH_KOREA","GMT+9",0,1,0,0,"Asia/Pyongyang");
 326                 INSERT INTO "city_table" VALUES(228,"IDS_WCL_BODY_CITYNAME_QUITO","IDS_WCL_BODY_ECUADOR","GMT-5",0,1,0,0,"America/Guayaquil");
 327                 INSERT INTO "city_table" VALUES(229,"IDS_WCL_BODY_CITYNAME_RABAT","IDS_WCL_BODY_MOROCCO","GMT+0",0,1,0,0,"Africa/Casablanca");
 328                 INSERT INTO "city_table" VALUES(230,"IDS_WCL_BODY_CITYNAME_YANGON","IDS_WCL_BODY_BURMA","GMT+6:30",0,1,0,0,"Asia/Rangoon");
 329                 INSERT INTO "city_table" VALUES(231,"IDS_WCL_BODY_CITYNAME_RECIFE","IDS_WCL_BODY_BRAZIL","GMT-3",0,1,0,0,"America/Recife");
 330                 INSERT INTO "city_table" VALUES(232,"IDS_WCL_BODY_CITYNAME_REGINA","IDS_WCL_BODY_CANADA","GMT-6",0,1,0,0,"America/Regina");
 331                 INSERT INTO "city_table" VALUES(233,"IDS_WCL_BODY_CITYNAME_REYKJAVIK","IDS_WCL_BODY_ICELAND","GMT+0",0,1,0,0,"Atlantic/Reykjavik");
 332                 INSERT INTO "city_table" VALUES(234,"IDS_WCL_BODY_CITYNAME_RIGA","IDS_WCL_BODY_LATVIA","GMT+2",0,1,0,0,"Europe/Riga");
 333                 INSERT INTO "city_table" VALUES(235,"IDS_WCL_BODY_CITYNAME_RIO_DE_JANEIRO","IDS_WCL_BODY_BRAZIL","GMT-2",0,1,0,0,"America/Sao_Paulo");
 334                 INSERT INTO "city_table" VALUES(236,"IDS_WCL_BODY_CITYNAME_RIYADH","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
 335                 INSERT INTO "city_table" VALUES(237,"IDS_WCL_BODY_CITYNAME_ROME","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 336                 INSERT INTO "city_table" VALUES(238,"IDS_WCL_BODY_CITYNAME_SAINT_DENIS","IDS_WCL_BODY_REUNION_ISLAND_M_COUNTRYNAME","GMT+4",0,1,0,0,"Indian/Reunion");
 337                 INSERT INTO "city_table" VALUES(239,"IDS_WCL_BODY_CITYNAME_SAMARA","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Samara");
 338                 INSERT INTO "city_table" VALUES(240,"IDS_WCL_BODY_CITYNAME_SAN_ANTONIO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
 339                 INSERT INTO "city_table" VALUES(241,"IDS_WCL_BODY_CITYNAME_SAN_DIEGO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
 340                 INSERT INTO "city_table" VALUES(242,"IDS_WCL_BODY_CITYNAME_SAN_FRANCISCO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"America/Los_Angeles");
 341                 INSERT INTO "city_table" VALUES(243,"IDS_WCL_BODY_SAN_JOSE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
 342                 INSERT INTO "city_table" VALUES(244,"IDS_WCL_BODY_SAN_JOSE","IDS_WCL_BODY_COSTA_RICA","GMT-6",0,1,0,0,"America/Costa_Rica");
 343                 INSERT INTO "city_table" VALUES(245,"IDS_WCL_BODY_CITYNAME_SAN_JUAN","IDS_WCL_BODY_PUERTO_RICO","GMT-4",0,1,0,0,"America/Puerto_Rico");
 344                 INSERT INTO "city_table" VALUES(246,"IDS_WCL_BODY_CITYNAME_SAN_MARINO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/San_Marino");
 345                 INSERT INTO "city_table" VALUES(247,"IDS_WCL_BODY_CITYNAME_SAN_SALVADOR","IDS_WCL_BODY_EL_SALVADOR","GMT-6",0,1,0,0,"America/El_Salvador");
 346                 INSERT INTO "city_table" VALUES(248,"IDS_WCL_BODY_CITYNAME_SANAA","IDS_WCL_BODY_YEMEN","GMT+3",0,1,0,0,"Asia/Aden");
 347                 INSERT INTO "city_table" VALUES(249,"IDS_WCL_BODY_CITYNAME_SANTIAGO","IDS_WCL_BODY_CHILE","GMT-4",0,1,0,0,"America/Santiago");
 348                 INSERT INTO "city_table" VALUES(250,"IDS_WCL_BODY_CITYNAME_SANTO_DOMINGO","IDS_WCL_BODY_DOMINICAN_REPUBLIC","GMT-4",0,1,0,0,"America/Santo_Domingo");
 349                 INSERT INTO "city_table" VALUES(251,"IDS_WCL_BODY_CITYNAME_SAO_PAULO","IDS_WCL_BODY_BRAZIL","GMT-2",0,1,0,0,"America/Sao_Paulo");
 350                 INSERT INTO "city_table" VALUES(252,"IDS_WCL_BODY_CITYNAME_SEATTLE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
 351                 INSERT INTO "city_table" VALUES(253,"IDS_WCL_BODY_CITYNAME_SEOUL","IDS_WCL_BODY_REPUBLIC_OF_KOREA","GMT+9",0,1,1,0,"Asia/Seoul");
 352                 INSERT INTO "city_table" VALUES(254,"IDS_WCL_BODY_CITYNAME_SHANGHAI","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 353                 INSERT INTO "city_table" VALUES(255,"IDS_WCL_BODY_SHENZHEN","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 354                 INSERT INTO "city_table" VALUES(256,"IDS_WCL_BODY_CITYNAME_SINGAPORE","IDS_WCL_BODY_REPUBLIC_OF_SINGAPORE_M_COUNTRY","GMT+8",0,1,0,0,"Asia/Singapore");
 355                 INSERT INTO "city_table" VALUES(257,"IDS_WCL_BODY_CITYNAME_SKOPJE","IDS_WCL_BODY_MACEDONIA","GMT+1",0,1,0,0,"Europe/Skopje");
 356                 INSERT INTO "city_table" VALUES(258,"IDS_WCL_BODY_CITYNAME_SOFIA","IDS_WCL_BODY_BULGARIA","GMT+3",0,1,0,0,"Europe/Sofia");
 357                 INSERT INTO "city_table" VALUES(259,"IDS_WCL_BODY_CITYNAME_ST_JOHNS","IDS_WCL_BODY_ANTIGUA_AND_BARBUDA","GMT-4",0,1,0,0,"America/Antigua");
 358                 INSERT INTO "city_table" VALUES(260,"IDS_WCL_BODY_CITYNAME_ST_JOHNS","IDS_WCL_BODY_CANADA","GMT-3:30",0,1,0,0,"America/St_Johns");
 359                 INSERT INTO "city_table" VALUES(261,"IDS_WCL_BODY_CITYNAME_ST_PETERSBURG","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
 360                 INSERT INTO "city_table" VALUES(262,"IDS_WCL_BODY_CITYNAME_STOCKHOLM","IDS_WCL_BODY_SWEDEN","GMT+2",0,1,0,0,"Europe/Stockholm");
 361                 INSERT INTO "city_table" VALUES(263,"IDS_WCL_BODY_CITYNAME_SUVA","IDS_WCL_BODY_FIJI_M_COUNTRYNAME","GMT+12",0,1,0,0,"Pacific/Fiji");
 362                 INSERT INTO "city_table" VALUES(264,"IDS_WCL_BODY_CITYNAME_SYDNEY","IDS_WCL_BODY_AUSTRALIA","GMT+11",0,1,0,0,"Australia/Sydney");
 363                 INSERT INTO "city_table" VALUES(265,"IDS_WCL_BODY_CITYNAME_TAHITI","IDS_WCL_BODY_FRENCH_POLYNESIA","GMT-10",0,1,0,0,"Pacific/Tahiti");
 364                 INSERT INTO "city_table" VALUES(266,"IDS_WCL_BODY_CITYNAME_TAIPEI","IDS_WCL_BODY_TAIWAN","GMT+8",0,1,0,0,"Asia/Taipei");
 365                 INSERT INTO "city_table" VALUES(267,"IDS_WCL_BODY_CITYNAME_TALLINN","IDS_WCL_BODY_ESTONIA","GMT+2",0,1,0,0,"Europe/Tallinn");
 366                 INSERT INTO "city_table" VALUES(268,"IDS_WCL_BODY_CITYNAME_TARAWA","IDS_WCL_BODY_KIRIBATI","GMT+12",0,1,0,0,"Pacific/Tarawa");
 367                 INSERT INTO "city_table" VALUES(269,"IDS_WCL_BODY_CITYNAME_TASHKENT","IDS_WCL_BODY_UZBEKISTAN","GMT+5",0,1,0,0,"Asia/Tashkent");
 368                 INSERT INTO "city_table" VALUES(270,"IDS_WCL_BODY_CITYNAME_TBILISI","IDS_WCL_BODY_GEORGIA","GMT+4",0,1,0,0,"Asia/Tbilisi");
 369                 INSERT INTO "city_table" VALUES(271,"IDS_WCL_BODY_CITYNAME_TEGUCIGALPA","IDS_WCL_BODY_HONDURAS","GMT-6",0,1,0,0,"America/Tegucigalpa");
 370                 INSERT INTO "city_table" VALUES(272,"IDS_WCL_BODY_CITYNAME_TEHRAN","IDS_WCL_BODY_IRAN_M_COUNTRYNAME","GMT+3:30",0,1,0,0,"Asia/Tehran");
 371                 INSERT INTO "city_table" VALUES(273,"IDS_WCL_BODY_CITYNAME_HO_CHI_MINH_CITY","IDS_WCL_BODY_VIETNAM","GMT+7",0,1,0,0,"Asia/Ho_Chi_Minh");
 372                 INSERT INTO "city_table" VALUES(274,"IDS_WCL_BODY_CITYNAME_THE_SETTLEMENT","IDS_WCL_BODY_BRITISH_VIRGIN_ISLANDS","GMT-4",0,1,0,0,"America/Tortola");
 373                 INSERT INTO "city_table" VALUES(275,"IDS_WCL_BODY_CITYNAME_TIANJIN","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
 374                 INSERT INTO "city_table" VALUES(276,"IDS_WCL_BODY_CITYNAME_TIJUANA","IDS_WCL_BODY_MEXICO","GMT-5",0,1,0,0,"America/Tijuana");
 375                 INSERT INTO "city_table" VALUES(277,"IDS_WCL_BODY_CITYNAME_TOKYO","IDS_WCL_BODY_JAPAN","GMT+9",0,1,0,0,"Asia/Tokyo");
 376                 INSERT INTO "city_table" VALUES(278,"IDS_WCL_BODY_CITYNAME_TORONTO","IDS_WCL_BODY_CANADA","GMT-4",0,1,0,0,"America/Toronto");
 377                 INSERT INTO "city_table" VALUES(279,"IDS_WCL_BODY_CITYNAME_TREHET","IDS_WCL_BODY_FRANCE","GMT+1",0,1,0,0,"Europe/Paris");
 378                 INSERT INTO "city_table" VALUES(280,"IDS_WCL_BODY_CITYNAME_TRIPOLI","IDS_WCL_BODY_LIBYA","GMT+2",0,1,0,0,"Africa/Tripoli");
 379                 INSERT INTO "city_table" VALUES(281,"IDS_WCL_BODY_CITYNAME_TUNIS","IDS_WCL_BODY_TUNISIA","GMT+2",0,1,0,0,"Africa/Tunis");
 380                 INSERT INTO "city_table" VALUES(282,"IDS_WCL_BODY_CITYNAME_TURIN","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 381                 INSERT INTO "city_table" VALUES(283,"IDS_WCL_BODY_CITYNAME_UFA","IDS_WCL_BODY_BASHKIRIYA_M_COUNTRYNAME","GMT+5",0,1,0,0,"Asia/Yekaterinburg");
 382                 INSERT INTO "city_table" VALUES(284,"IDS_WCL_BODY_CITYNAME_ULAN_BATOR","IDS_WCL_BODY_MONGOLIA","GMT+8",0,1,0,0,"Asia/Ulan_Bator");
 383                 INSERT INTO "city_table" VALUES(285,"IDS_WCL_BODY_CITYNAME_VADUZ","IDS_WCL_BODY_LIECHTENSTEIN","GMT+1",0,1,0,0,"Europe/Vaduz");
 384                 INSERT INTO "city_table" VALUES(286,"IDS_WCL_BODY_CITYNAME_VALLETTA","IDS_WCL_BODY_MALTA","GMT+1",0,1,0,0,"Europe/Malta");
 385                 INSERT INTO "city_table" VALUES(287,"IDS_WCL_BODY_CITYNAME_VANCOUVER","IDS_WCL_BODY_CANADA","GMT-8",0,1,0,0,"America/Vancouver");
 386                 INSERT INTO "city_table" VALUES(288,"IDS_WCL_BODY_CITYNAME_VERONA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
 387                 INSERT INTO "city_table" VALUES(289,"IDS_WCL_BODY_CITYNAME_VICTORIA","IDS_WCL_BODY_SEYCHELLES","GMT+4",0,1,0,0,"Australia/Melbourne");
 388                 INSERT INTO "city_table" VALUES(290,"IDS_WCL_BODY_CITYNAME_VIENNA","IDS_WCL_BODY_AUSTRIA","GMT+1",0,1,0,0,"Europe/Vienna");
 389                 INSERT INTO "city_table" VALUES(291,"IDS_WCL_BODY_CITYNAME_VILNIUS","IDS_WCL_BODY_LITHUANIA","GMT+3",0,1,0,0,"Europe/Vilnius");
 390                 INSERT INTO "city_table" VALUES(292,"IDS_WCL_BODY_CITYNAME_VLADIVOSTOK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Vladivostok");
 391                 INSERT INTO "city_table" VALUES(293,"IDS_WCL_BODY_CITYNAME_VOLGOGRAD","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Volgograd");
 392                 INSERT INTO "city_table" VALUES(294,"IDS_WCL_BODY_CITYNAME_WARSAW","IDS_WCL_BODY_POLAND","GMT+1",0,1,0,0,"Europe/Warszawa");
 393                 INSERT INTO "city_table" VALUES(295,"IDS_WCL_BODY_CITYNAME_WASHINGTON_DC","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
 394                 INSERT INTO "city_table" VALUES(296,"IDS_WCL_BODY_CITYNAME_WELLINGTON","IDS_WCL_BODY_NEW_ZEALAND","GMT+12",0,1,0,0,"Pacific/Auckland");
 395                 INSERT INTO "city_table" VALUES(297,"IDS_WCL_BODY_CITYNAME_WINNIPEG","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Winnipeg");
 396                 INSERT INTO "city_table" VALUES(298,"IDS_WCL_BODY_CITYNAME_YAKUTSK","IDS_WCL_BODY_RUSSIA","GMT+10",0,1,0,0,"Asia/Yakutsk");
 397                 INSERT INTO "city_table" VALUES(299,"IDS_WCL_BODY_CITYNAME_YAMOUSSOUKRO","IDS_WCL_BODY_COTE_DIVOIRE","GMT+0",0,1,0,0,"Africa/Abidjan");
 398                 INSERT INTO "city_table" VALUES(300,"IDS_WCL_BODY_YAOUNDE","IDS_WCL_BODY_CAMEROON","GMT+1",0,1,0,0,"Africa/Douala");
 399                 INSERT INTO "city_table" VALUES(301,"IDS_WCL_BODY_CITYNAME_YEKATERINBURG","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
 400                 INSERT INTO "city_table" VALUES(302,"IDS_WCL_BODY_CITYNAME_YEREVAN","IDS_WCL_BODY_ARMENIA","GMT+5",0,1,0,0,"Asia/Yerevan");
 401                 INSERT INTO "city_table" VALUES(303,"IDS_WCL_BODY_CITYNAME_YUZHNO_SAKHALINSK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Sakhalin");
 402                 INSERT INTO "city_table" VALUES(304,"IDS_WCL_BODY_CITYNAME_ZAGREB","IDS_WCL_BODY_CROATIA","GMT+1",0,1,0,0,"Europe/Zagreb");
 403                 INSERT INTO "city_table" VALUES(305,"IDS_WCL_BODY_CITYNAME_ZURICH","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");'
 404 fi
 405
 406 #set clock
 407 chown -R 5000:5000 /opt/usr/apps/org.tizen.clock/data
 408 vconftool set -t int db/private/org.tizen.clock/clock/clock_application_id 1 -g -f 5000
 409 #set alarm
 410 vconftool set -t string db/private/org.tizen.clock/alarm_app/default_alarm_tone "/opt/share/settings/Alarms/Walk in the forest.mp3" -g -f 5000
 411 vconftool set -t int db/private/org.tizen.clock/alarm_app/default_snooze_minutes 5 -f -g 5000
 412 vconftool set -t int db/alarm/state 0 -g 5000 -f
 413 vconftool set -t bool memory/alarm/ringing 0 -i -g 5000 -f
 414 vconftool set -t int db/private/org.tizen.clock/alarm/update 0 -f -g 5000
 415 vconftool set -t int db/private/org.tizen.clock/alarm/delete 0 -f -g 5000
 416 #set timer
 417 vconftool set -t int db/private/org.tizen.clock/timer/start_time 100 -f -g 5000
 418 vconftool set -t int db/private/org.tizen.clock/timer/focus_id 1 -f -g 5000
 419 # worldclock db file
 420 chown :6015 /opt/dbspace/.worldclock.db
 421 chown :6015 /opt/dbspace/.worldclock.db-journal
 422 ## Change worldclock db file permissions
 423 chmod 660 /opt/dbspace/.worldclock.db
 424 chmod 660 /opt/dbspace/.worldclock.db-journal
 425
 426 %postun -p /sbin/ldconfig
 427
 428 %files
 429 %manifest %{name}.manifest
 430 /opt/etc/smack/accesses.d/org.tizen.clock.rule
 431 %defattr(-,root,root,-)
 432 /usr/apps/org.tizen.clock/bin/clock
 433 /usr/apps/org.tizen.clock/res/edje/*.edj
 434
 435 /usr/apps/org.tizen.clock/lib/libclock-alarm.so
 436 /usr/apps/org.tizen.clock/lib/libclock-alarm.so.0
 437 /usr/apps/org.tizen.clock/lib/libclock-alarm.so.0.1
 438 /usr/apps/org.tizen.clock/lib/libclock-common.so
 439 /usr/apps/org.tizen.clock/lib/libclock-common.so.0
 440 /usr/apps/org.tizen.clock/lib/libclock-common.so.0.1
 441 /usr/apps/org.tizen.clock/lib/libclock-stw.so
 442 /usr/apps/org.tizen.clock/lib/libclock-stw.so.0
 443 /usr/apps/org.tizen.clock/lib/libclock-stw.so.0.1
 444 /usr/apps/org.tizen.clock/lib/libclock-tmr.so
 445 /usr/apps/org.tizen.clock/lib/libclock-tmr.so.0
 446 /usr/apps/org.tizen.clock/lib/libclock-tmr.so.0.1
 447 /usr/apps/org.tizen.clock/lib/libclock-wcl.so
 448 /usr/apps/org.tizen.clock/lib/libclock-wcl.so.0
 449 /usr/apps/org.tizen.clock/lib/libclock-wcl.so.0.1
 450
 451 /usr/apps/org.tizen.clock/res/images/*
 452 /usr/apps/org.tizen.clock/res/locale/*/*/*
 453
 454
 455 /opt/share/applications/ring
 456 /usr/apps/org.tizen.ring/res/edje/ring.edj
 457
 458 /usr/apps/org.tizen.ring/res/images/*
 459 /usr/apps/org.tizen.ring/res/locale/*/*/*
 460
 461 /usr/share/packages/org.tizen.clock.xml
 462 /usr/share/icons/default/small/org.tizen.clock.png
 463
 464 /usr/share/license/%{name}
 465
 466 /opt/data/setting/tzlist.ini
 467