4 Summary: background image library
8 Source0: %{name}-%{version}.tar.gz
9 Source1: %{name}.manifest
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)
31 BuildRequires: pkgconfig(glesv2)
33 BuildRequires: pkgconfig(gles20)
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)
43 BuildRoot: %{_tmppath}/%{name}-%{version}-build
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"
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"
68 CXXFLAGS+=" -D_ARCH_ARM_ -mfpu=neon -mfloat-abi=softfp"
71 cmake . -DCMAKE_INSTALL_PREFIX=%{PREFIX}
74 # Call make instruction with smp support
80 mkdir -p %{buildroot}/usr/share/license
81 cp LICENSE %{buildroot}/usr/share/license/%{name}
89 CITY_TABLE_FILE="/opt/dbspace/.worldclock.db"
91 if [ ! -e "$CITY_TABLE_FILE" ]
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");'
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
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
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
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
426 %postun -p /sbin/ldconfig
429 %manifest %{name}.manifest
430 %defattr(-,root,root,-)
431 /usr/apps/org.tizen.clock/bin/clock
432 /usr/apps/org.tizen.clock/res/edje/*.edj
434 /usr/apps/org.tizen.clock/lib/libclock-alarm.so
435 /usr/apps/org.tizen.clock/lib/libclock-alarm.so.0
436 /usr/apps/org.tizen.clock/lib/libclock-alarm.so.0.1
437 /usr/apps/org.tizen.clock/lib/libclock-common.so
438 /usr/apps/org.tizen.clock/lib/libclock-common.so.0
439 /usr/apps/org.tizen.clock/lib/libclock-common.so.0.1
440 /usr/apps/org.tizen.clock/lib/libclock-stw.so
441 /usr/apps/org.tizen.clock/lib/libclock-stw.so.0
442 /usr/apps/org.tizen.clock/lib/libclock-stw.so.0.1
443 /usr/apps/org.tizen.clock/lib/libclock-tmr.so
444 /usr/apps/org.tizen.clock/lib/libclock-tmr.so.0
445 /usr/apps/org.tizen.clock/lib/libclock-tmr.so.0.1
446 /usr/apps/org.tizen.clock/lib/libclock-wcl.so
447 /usr/apps/org.tizen.clock/lib/libclock-wcl.so.0
448 /usr/apps/org.tizen.clock/lib/libclock-wcl.so.0.1
450 /usr/apps/org.tizen.clock/res/images/*
451 /usr/apps/org.tizen.clock/res/locale/*/*/*
454 /opt/share/applications/ring
455 /usr/apps/org.tizen.ring/res/edje/ring.edj
457 /usr/apps/org.tizen.ring/res/images/*
458 /usr/apps/org.tizen.ring/res/locale/*/*/*
460 /usr/share/packages/org.tizen.clock.xml
461 /usr/share/icons/default/small/org.tizen.clock.png
463 /usr/share/license/%{name}
465 /opt/data/setting/tzlist.ini