0_initial_qcrilnr.sql 61 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714
  1. /*
  2. Copyright (c) 2016 Qualcomm Technologies, Inc.
  3. All Rights Reserved.
  4. Confidential and Proprietary - Qualcomm Technologies, Inc.
  5. */
  6. -- VERSION: 5
  7. PRAGMA foreign_keys=OFF;
  8. CREATE TABLE qcril_emergency_source_mcc_table(MCC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER));
  9. INSERT INTO qcril_emergency_source_mcc_table VALUES('334','060','','');
  10. INSERT INTO qcril_emergency_source_mcc_table VALUES('730','133','','');
  11. INSERT INTO qcril_emergency_source_mcc_table VALUES('732','123','','');
  12. INSERT INTO qcril_emergency_source_mcc_table VALUES('901','999','','');
  13. INSERT INTO qcril_emergency_source_mcc_table VALUES('901','122','','');
  14. INSERT INTO qcril_emergency_source_mcc_table VALUES('520','191','','limited');
  15. INSERT INTO qcril_emergency_source_mcc_table VALUES('520','1669','','limited');
  16. INSERT INTO qcril_emergency_source_mcc_table VALUES('520','199','','limited');
  17. INSERT INTO qcril_emergency_source_mcc_table VALUES('520','112','','limited');
  18. INSERT INTO qcril_emergency_source_mcc_table VALUES('520','911','','limited');
  19. INSERT INTO qcril_emergency_source_mcc_table VALUES('414','191','','limited');
  20. INSERT INTO qcril_emergency_source_mcc_table VALUES('414','192','','limited');
  21. INSERT INTO qcril_emergency_source_mcc_table VALUES('414','199','','limited');
  22. INSERT INTO qcril_emergency_source_mcc_table VALUES('515','117','','limited');
  23. INSERT INTO qcril_emergency_source_mcc_table VALUES('515','112','','limited');
  24. INSERT INTO qcril_emergency_source_mcc_table VALUES('515','911','','limited');
  25. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','110','','');
  26. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','119','','');
  27. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','120','','');
  28. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','112','','');
  29. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','999','','');
  30. INSERT INTO qcril_emergency_source_mcc_table VALUES('460','122','','');
  31. INSERT INTO qcril_emergency_source_mcc_table VALUES('852','999','','');
  32. INSERT INTO qcril_emergency_source_mcc_table VALUES('510','110','','');
  33. INSERT INTO qcril_emergency_source_mcc_table VALUES('510','118','','');
  34. INSERT INTO qcril_emergency_source_mcc_table VALUES('510','199','','');
  35. INSERT INTO qcril_emergency_source_mcc_table VALUES('510','113','','');
  36. INSERT INTO qcril_emergency_source_mcc_table VALUES('510','112','','');
  37. INSERT INTO qcril_emergency_source_mcc_table VALUES('452','112','','');
  38. INSERT INTO qcril_emergency_source_mcc_table VALUES('452','113','','');
  39. INSERT INTO qcril_emergency_source_mcc_table VALUES('452','114','','');
  40. INSERT INTO qcril_emergency_source_mcc_table VALUES('452','115','','');
  41. INSERT INTO qcril_emergency_source_mcc_table VALUES('502','112','','');
  42. INSERT INTO qcril_emergency_source_mcc_table VALUES('502','911','','');
  43. INSERT INTO qcril_emergency_source_mcc_table VALUES('502','991','','');
  44. INSERT INTO qcril_emergency_source_mcc_table VALUES('502','994','','');
  45. INSERT INTO qcril_emergency_source_mcc_table VALUES('502','999','','');
  46. INSERT INTO qcril_emergency_source_mcc_table VALUES('310','112','','');
  47. INSERT INTO qcril_emergency_source_mcc_table VALUES('310','911','','');
  48. INSERT INTO qcril_emergency_source_mcc_table VALUES('302','112','','');
  49. INSERT INTO qcril_emergency_source_mcc_table VALUES('302','911','','');
  50. INSERT INTO qcril_emergency_source_mcc_table VALUES('456','191','','');
  51. INSERT INTO qcril_emergency_source_mcc_table VALUES('456','192','','');
  52. INSERT INTO qcril_emergency_source_mcc_table VALUES('456','199','','');
  53. INSERT INTO qcril_emergency_source_mcc_table VALUES('457','191','','');
  54. INSERT INTO qcril_emergency_source_mcc_table VALUES('457','192','','');
  55. INSERT INTO qcril_emergency_source_mcc_table VALUES('457','199','','');
  56. INSERT INTO qcril_emergency_source_mcc_table VALUES('706','122','','');
  57. INSERT INTO qcril_emergency_source_mcc_table VALUES('704','122','','');
  58. INSERT INTO qcril_emergency_source_mcc_table VALUES('334','066','','');
  59. INSERT INTO qcril_emergency_source_mcc_table VALUES('716','105','','');
  60. INSERT INTO qcril_emergency_source_mcc_table VALUES('429','100',NULL,NULL);
  61. INSERT INTO qcril_emergency_source_mcc_table VALUES('429','101',NULL,NULL);
  62. INSERT INTO qcril_emergency_source_mcc_table VALUES('429','102',NULL,NULL);
  63. INSERT INTO qcril_emergency_source_mcc_table VALUES('429','108',NULL,NULL);
  64. INSERT INTO qcril_emergency_source_mcc_table VALUES('429','112',NULL,NULL);
  65. INSERT INTO qcril_emergency_source_mcc_table VALUES('470','100',NULL,NULL);
  66. INSERT INTO qcril_emergency_source_mcc_table VALUES('470','101',NULL,NULL);
  67. INSERT INTO qcril_emergency_source_mcc_table VALUES('470','102',NULL,NULL);
  68. INSERT INTO qcril_emergency_source_mcc_table VALUES('470','108',NULL,NULL);
  69. INSERT INTO qcril_emergency_source_mcc_table VALUES('470','112',NULL,NULL);
  70. INSERT INTO qcril_emergency_source_mcc_table VALUES('234','999','','');
  71. INSERT INTO qcril_emergency_source_mcc_table VALUES('505','000','','');
  72. CREATE TABLE qcril_emergency_source_voice_table(MCC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER));
  73. INSERT INTO qcril_emergency_source_voice_table VALUES('460','110','','full');
  74. INSERT INTO qcril_emergency_source_voice_table VALUES('460','119','','full');
  75. INSERT INTO qcril_emergency_source_voice_table VALUES('460','120','','full');
  76. INSERT INTO qcril_emergency_source_voice_table VALUES('460','112','','full');
  77. INSERT INTO qcril_emergency_source_voice_table VALUES('460','999','','full');
  78. INSERT INTO qcril_emergency_source_voice_table VALUES('852','999','','full');
  79. INSERT INTO qcril_emergency_source_voice_table VALUES('460','122','','full');
  80. INSERT INTO qcril_emergency_source_voice_table VALUES('520','191','','full');
  81. INSERT INTO qcril_emergency_source_voice_table VALUES('520','1669','','full');
  82. INSERT INTO qcril_emergency_source_voice_table VALUES('520','199','','full');
  83. INSERT INTO qcril_emergency_source_voice_table VALUES('520','112','','full');
  84. INSERT INTO qcril_emergency_source_voice_table VALUES('520','911','','full');
  85. INSERT INTO qcril_emergency_source_voice_table VALUES('414','191','','full');
  86. INSERT INTO qcril_emergency_source_voice_table VALUES('414','192','','full');
  87. INSERT INTO qcril_emergency_source_voice_table VALUES('414','199','','full');
  88. INSERT INTO qcril_emergency_source_voice_table VALUES('515','117','','full');
  89. INSERT INTO qcril_emergency_source_voice_table VALUES('515','112','','full');
  90. INSERT INTO qcril_emergency_source_voice_table VALUES('515','911','','full');
  91. INSERT INTO qcril_emergency_source_voice_table VALUES('510','110','','full');
  92. INSERT INTO qcril_emergency_source_voice_table VALUES('510','118','','full');
  93. INSERT INTO qcril_emergency_source_voice_table VALUES('510','199','','full');
  94. INSERT INTO qcril_emergency_source_voice_table VALUES('510','113','','full');
  95. INSERT INTO qcril_emergency_source_voice_table VALUES('510','112','','full');
  96. INSERT INTO qcril_emergency_source_voice_table VALUES('452','112','','full');
  97. INSERT INTO qcril_emergency_source_voice_table VALUES('452','113','','full');
  98. INSERT INTO qcril_emergency_source_voice_table VALUES('452','114','','full');
  99. INSERT INTO qcril_emergency_source_voice_table VALUES('452','115','','full');
  100. INSERT INTO qcril_emergency_source_voice_table VALUES('502','112','','full');
  101. INSERT INTO qcril_emergency_source_voice_table VALUES('502','911','','full');
  102. INSERT INTO qcril_emergency_source_voice_table VALUES('502','991','','full');
  103. INSERT INTO qcril_emergency_source_voice_table VALUES('502','994','','full');
  104. INSERT INTO qcril_emergency_source_voice_table VALUES('502','999','','full');
  105. CREATE TABLE qcril_emergency_source_hard_mcc_table(MCC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER));
  106. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','110','','');
  107. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','119','','');
  108. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','120','','');
  109. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','112','','');
  110. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','999','','');
  111. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('852','999','','');
  112. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('460','122','','');
  113. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('520','191','','');
  114. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('520','1669','','');
  115. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('520','199','','');
  116. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('520','112','','');
  117. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('520','911','','');
  118. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('414','191','','');
  119. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('414','192','','');
  120. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('414','199','','');
  121. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('515','117','','');
  122. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('515','112','','');
  123. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('515','911','','');
  124. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('510','110','','');
  125. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('510','118','','');
  126. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('510','199','','');
  127. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('510','113','','');
  128. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('510','112','','');
  129. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('452','112','','');
  130. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('452','113','','');
  131. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('452','114','','');
  132. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('452','115','','');
  133. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('502','112','','');
  134. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('502','911','','');
  135. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('502','991','','');
  136. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('502','994','','');
  137. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('502','999','','');
  138. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('310','112','','');
  139. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('310','911','','');
  140. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('310','999','','');
  141. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('302','112','','');
  142. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('302','911','','');
  143. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('302','999','','');
  144. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('456','191','','');
  145. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('456','192','','');
  146. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('456','199','','');
  147. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('457','191','','');
  148. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('457','192','','');
  149. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('457','199','','');
  150. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('730','133','','');
  151. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('429','100',NULL,NULL);
  152. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('429','101',NULL,NULL);
  153. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('429','102',NULL,NULL);
  154. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('429','108',NULL,NULL);
  155. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('429','112',NULL,NULL);
  156. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('470','100',NULL,NULL);
  157. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('470','101',NULL,NULL);
  158. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('470','102',NULL,NULL);
  159. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('470','108',NULL,NULL);
  160. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('470','112',NULL,NULL);
  161. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','112','','');
  162. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('234','999','','');
  163. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('234','112','','');
  164. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('234','911','','');
  165. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','112','','');
  166. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','911','','');
  167. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','999','','');
  168. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','08','','');
  169. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','118','','');
  170. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('222','119','','');
  171. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('214','112','','');
  172. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('268','112','','');
  173. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('204','112','','');
  174. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('272','112','','');
  175. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('272','999','','');
  176. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('216','112','','');
  177. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('230','112','','');
  178. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('230','150','','');
  179. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('230','155','','');
  180. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('230','158','','');
  181. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('655','112','','');
  182. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('655','911','','');
  183. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('286','112','','');
  184. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('226','112','','');
  185. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('226','911','','');
  186. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('206','112','','');
  187. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('260','112','','');
  188. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('260','911','','');
  189. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('231','911','','');
  190. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('231','112','','');
  191. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('214','911','','');
  192. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('208','911','','');
  193. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('208','112','','');
  194. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('334','112','','');
  195. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('334','060','','');
  196. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('334','911','','');
  197. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('732','911','','');
  198. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('732','112','','');
  199. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('716','911','','');
  200. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('716','112','','');
  201. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('724','911','','');
  202. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('724','112','','');
  203. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('724','190','','');
  204. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('724','192','','');
  205. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('724','193','','');
  206. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('722','112','','');
  207. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('722','911','','');
  208. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('730','112','','');
  209. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('730','911','','');
  210. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('712','112','','');
  211. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('712','911','','');
  212. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('740','112','','');
  213. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('740','911','','');
  214. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('706','112','','');
  215. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('706','911','','');
  216. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('704','112','','');
  217. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('704','911','','');
  218. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('710','112','','');
  219. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('710','911','','');
  220. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('714','112','','');
  221. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('714','911','','');
  222. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('748','112','','');
  223. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('748','911','','');
  224. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('734','112','','');
  225. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('734','911','','');
  226. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','911','','');
  227. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','000','','');
  228. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','08','','');
  229. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','110','','');
  230. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','999','','');
  231. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','118','','');
  232. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','119','','');
  233. INSERT INTO qcril_emergency_source_hard_mcc_table VALUES('262','122','','');
  234. CREATE TABLE qcril_emergency_source_nw_table(MCC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER));
  235. CREATE TABLE qcril_emergency_source_escv_iin_table(IIN TEXT, NUMBER TEXT, ESCV INTEGER, ROAM TEXT, PRIMARY KEY(IIN,NUMBER,ROAM));
  236. CREATE TABLE qcril_emergency_source_escv_nw_table(MCC TEXT, MNC TEXT, NUMBER TEXT, ESCV INTEGER, PRIMARY KEY(MCC,NUMBER, ESCV));
  237. CREATE TABLE qcril_emergency_source_mcc_mnc_table(MCC TEXT, MNC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER,MNC));
  238. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('262','02','112','','');
  239. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','20','999','','');
  240. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','20','112','','');
  241. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','15','999','','');
  242. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','15','112','','');
  243. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','15','911','','');
  244. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','10','112','','');
  245. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','112','','');
  246. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','911','','');
  247. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','999','','');
  248. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','08','','');
  249. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','118','','');
  250. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('222','99','119','','');
  251. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('214','01','112','','');
  252. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('268','01','112','','');
  253. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('204','04','112','','');
  254. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('272','01','112','','');
  255. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('272','01','999','','');
  256. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('216','70','112','','');
  257. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('230','03','112','','');
  258. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('230','03','150','','');
  259. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('230','03','155','','');
  260. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('230','03','158','','');
  261. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('655','01','112','','');
  262. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('655','01','911','','');
  263. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('286','02','112','','');
  264. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('226','10','112','','');
  265. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('226','10','911','','');
  266. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('206','10','112','','');
  267. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('260','03','112','','');
  268. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('260','03','911','','');
  269. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('231','01','911','','');
  270. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('231','01','112','','');
  271. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('214','03','112','','');
  272. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('214','03','911','','');
  273. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('208','01','911','','');
  274. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('208','01','112','','');
  275. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','020','060','','');
  276. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','020','112','','');
  277. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','020','911','','');
  278. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','101','112','','');
  279. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','101','911','','');
  280. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('716','10','112','','');
  281. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('716','10','911','','');
  282. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','05','190','','');
  283. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','05','192','','');
  284. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','05','193','','');
  285. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','05','911','','');
  286. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','05','112','','');
  287. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','12','190','','');
  288. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','12','192','','');
  289. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','12','193','','');
  290. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','12','911','','');
  291. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','12','112','','');
  292. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','38','190','','');
  293. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','38','192','','');
  294. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','38','193','','');
  295. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','38','911','','');
  296. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('724','38','112','','');
  297. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','07','112','','');
  298. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','07','911','','');
  299. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','10','112','','');
  300. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','10','911','','');
  301. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','070','112','','');
  302. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('722','070','911','','');
  303. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('730','02','112','','');
  304. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('730','02','911','','');
  305. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('730','02','133','','');
  306. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','001','112','','');
  307. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','001','911','','');
  308. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','001','123','','');
  309. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','102','112','','');
  310. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','102','911','','');
  311. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','102','123','','');
  312. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','123','112','','');
  313. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','123','911','','');
  314. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('732','123','123','','');
  315. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('712','04','911','','');
  316. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('712','04','112','','');
  317. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('740','00','911','','');
  318. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('740','00','112','','');
  319. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('706','04','911','','');
  320. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('706','04','112','','');
  321. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('706','04','122','','');
  322. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('704','03','911','','');
  323. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('704','03','112','','');
  324. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('704','03','122','','');
  325. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','03','911','','');
  326. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','03','112','','');
  327. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','03','066','','');
  328. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','030','911','','');
  329. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','030','112','','');
  330. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('334','030','066','','');
  331. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('710','30','911','','');
  332. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('710','30','112','','');
  333. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('710','300','911','','');
  334. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('710','300','112','','');
  335. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('714','02','911','','');
  336. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('714','02','112','','');
  337. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('716','06','911','','');
  338. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('716','06','112','','');
  339. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('716','06','105','','');
  340. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('748','07','911','','');
  341. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('748','07','112','','');
  342. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('734','04','911','','');
  343. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('734','04','112','','');
  344. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('262','03','911','','');
  345. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('262','03','112','','');
  346. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','30','999','','');
  347. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','30','112','','');
  348. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','33','999','','');
  349. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('234','33','112','','');
  350. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','840','100','','');
  351. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','840','101','','');
  352. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','840','102','','');
  353. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','840','108','','');
  354. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','854','100','','');
  355. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','854','101','','');
  356. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','854','102','','');
  357. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','854','108','','');
  358. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','855','100','','');
  359. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','855','101','','');
  360. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','855','102','','');
  361. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','855','108','','');
  362. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','856','100','','');
  363. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','856','101','','');
  364. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','856','102','','');
  365. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','856','108','','');
  366. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','857','100','','');
  367. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','857','101','','');
  368. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','857','102','','');
  369. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','857','108','','');
  370. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','858','100','','');
  371. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','858','101','','');
  372. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','858','102','','');
  373. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','858','108','','');
  374. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','859','100','','');
  375. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','859','101','','');
  376. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','859','102','','');
  377. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','859','108','','');
  378. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','860','100','','');
  379. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','860','101','','');
  380. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','860','102','','');
  381. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','860','108','','');
  382. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','861','100','','');
  383. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','861','101','','');
  384. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','861','102','','');
  385. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','861','108','','');
  386. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','862','100','','');
  387. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','862','101','','');
  388. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','862','102','','');
  389. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','862','108','','');
  390. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','863','100','','');
  391. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','863','101','','');
  392. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','863','102','','');
  393. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','863','108','','');
  394. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','864','100','','');
  395. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','864','101','','');
  396. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','864','102','','');
  397. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','864','108','','');
  398. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','865','100','','');
  399. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','865','101','','');
  400. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','865','102','','');
  401. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','865','108','','');
  402. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','866','100','','');
  403. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','866','101','','');
  404. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','866','102','','');
  405. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','866','108','','');
  406. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','867','100','','');
  407. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','867','101','','');
  408. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','867','102','','');
  409. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','867','108','','');
  410. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','868','100','','');
  411. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','868','101','','');
  412. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','868','102','','');
  413. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','868','108','','');
  414. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','869','100','','');
  415. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','869','101','','');
  416. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','869','102','','');
  417. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','869','108','','');
  418. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','870','100','','');
  419. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','870','101','','');
  420. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','870','102','','');
  421. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','870','108','','');
  422. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','871','100','','');
  423. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','871','101','','');
  424. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','871','102','','');
  425. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','871','108','','');
  426. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','872','100','','');
  427. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','872','101','','');
  428. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','872','102','','');
  429. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','872','108','','');
  430. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','873','100','','');
  431. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','873','101','','');
  432. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','873','102','','');
  433. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','873','108','','');
  434. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','874','100','','');
  435. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','874','101','','');
  436. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','874','102','','');
  437. INSERT INTO qcril_emergency_source_mcc_mnc_table VALUES('405','874','108','','');
  438. CREATE TABLE qcril_emergency_source_voice_mcc_mnc_table(MCC TEXT, MNC TEXT, NUMBER TEXT, IMS_ADDRESS TEXT, SERVICE TEXT, PRIMARY KEY(MCC,NUMBER,MNC));
  439. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','840','100','','full');
  440. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','840','101','','full');
  441. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','840','102','','full');
  442. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','840','108','','full');
  443. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','854','100','','full');
  444. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','854','101','','full');
  445. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','854','102','','full');
  446. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','854','108','','full');
  447. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','855','100','','full');
  448. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','855','101','','full');
  449. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','855','102','','full');
  450. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','855','108','','full');
  451. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','856','100','','full');
  452. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','856','101','','full');
  453. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','856','102','','full');
  454. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','856','108','','full');
  455. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','857','100','','full');
  456. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','857','101','','full');
  457. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','857','102','','full');
  458. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','857','108','','full');
  459. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','858','100','','full');
  460. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','858','101','','full');
  461. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','858','102','','full');
  462. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','858','108','','full');
  463. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','859','100','','full');
  464. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','859','101','','full');
  465. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','859','102','','full');
  466. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','859','108','','full');
  467. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','860','100','','full');
  468. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','860','101','','full');
  469. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','860','102','','full');
  470. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','860','108','','full');
  471. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','861','100','','full');
  472. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','861','101','','full');
  473. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','861','102','','full');
  474. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','861','108','','full');
  475. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','862','100','','full');
  476. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','862','101','','full');
  477. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','862','102','','full');
  478. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','862','108','','full');
  479. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','863','100','','full');
  480. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','863','101','','full');
  481. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','863','102','','full');
  482. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','863','108','','full');
  483. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','864','100','','full');
  484. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','864','101','','full');
  485. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','864','102','','full');
  486. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','864','108','','full');
  487. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','865','100','','full');
  488. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','865','101','','full');
  489. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','865','102','','full');
  490. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','865','108','','full');
  491. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','866','100','','full');
  492. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','866','101','','full');
  493. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','866','102','','full');
  494. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','866','108','','full');
  495. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','867','100','','full');
  496. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','867','101','','full');
  497. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','867','102','','full');
  498. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','867','108','','full');
  499. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','868','100','','full');
  500. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','868','101','','full');
  501. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','868','102','','full');
  502. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','868','108','','full');
  503. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','869','100','','full');
  504. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','869','101','','full');
  505. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','869','102','','full');
  506. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','869','108','','full');
  507. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','870','100','','full');
  508. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','870','101','','full');
  509. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','870','102','','full');
  510. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','870','108','','full');
  511. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','871','100','','full');
  512. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','871','101','','full');
  513. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','871','102','','full');
  514. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','871','108','','full');
  515. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','872','100','','full');
  516. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','872','101','','full');
  517. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','872','102','','full');
  518. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','872','108','','full');
  519. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','873','100','','full');
  520. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','873','101','','full');
  521. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','873','102','','full');
  522. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','873','108','','full');
  523. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','874','100','','full');
  524. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','874','101','','full');
  525. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','874','102','','full');
  526. INSERT INTO qcril_emergency_source_voice_mcc_mnc_table VALUES('405','874','108','','full');
  527. CREATE TABLE qcril_properties_table (property TEXT,value TEXT, PRIMARY KEY(property));
  528. INSERT INTO qcril_properties_table VALUES('qcrildb_version','5');
  529. CREATE TABLE qcril_operator_specific_config(MCC TEXT, MNC TEXT, WPS_OVER_CS INTEGER, PRIMARY KEY(MCC, MNC));
  530. INSERT INTO qcril_operator_specific_config VALUES('310','410',1);
  531. DELETE FROM qcril_operator_specific_config where MCC = '310' AND MNC = '410';
  532. CREATE TABLE qcril_cdma_operator_specific_config(MCC TEXT, MNC TEXT, FORCE_ON_DC INTEGER, PRIMARY KEY(MCC, MNC));
  533. INSERT INTO qcril_cdma_operator_specific_config VALUES('460','03',1);
  534. INSERT INTO qcril_cdma_operator_specific_config VALUES('460','11',1);
  535. INSERT INTO qcril_cdma_operator_specific_config VALUES('454','03',1);
  536. INSERT INTO qcril_cdma_operator_specific_config VALUES('454','31',1);
  537. INSERT INTO qcril_cdma_operator_specific_config VALUES('204','04',1);
  538. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '100';
  539. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '100';
  540. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '100';
  541. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '100';
  542. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '100';
  543. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '100';
  544. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '100';
  545. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '100';
  546. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '100';
  547. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '100';
  548. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '100';
  549. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '100';
  550. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '100';
  551. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '100';
  552. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '100';
  553. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '100';
  554. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '100';
  555. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '100';
  556. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '100';
  557. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '100';
  558. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '100';
  559. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '100';
  560. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '100';
  561. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '100';
  562. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '100';
  563. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '100';
  564. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '100';
  565. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '100';
  566. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '100';
  567. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '100';
  568. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '100';
  569. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '100';
  570. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '100';
  571. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '100';
  572. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '100';
  573. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '100';
  574. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '100';
  575. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '100';
  576. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '100';
  577. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '100';
  578. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '100';
  579. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '100';
  580. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '100';
  581. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '100';
  582. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '101';
  583. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '102';
  584. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '108';
  585. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '101';
  586. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '102';
  587. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '108';
  588. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '101';
  589. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '102';
  590. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '108';
  591. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '101';
  592. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '102';
  593. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '108';
  594. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '101';
  595. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '102';
  596. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '108';
  597. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '101';
  598. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '102';
  599. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '108';
  600. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '101';
  601. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '102';
  602. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '108';
  603. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '101';
  604. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '102';
  605. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '108';
  606. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '101';
  607. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '102';
  608. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '108';
  609. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '101';
  610. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '102';
  611. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '108';
  612. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '101';
  613. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '102';
  614. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '108';
  615. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '101';
  616. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '102';
  617. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '108';
  618. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '101';
  619. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '102';
  620. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '108';
  621. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '101';
  622. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '102';
  623. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '108';
  624. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '101';
  625. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '102';
  626. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '108';
  627. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '101';
  628. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '102';
  629. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '108';
  630. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '101';
  631. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '102';
  632. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '108';
  633. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '101';
  634. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '102';
  635. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '108';
  636. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '101';
  637. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '102';
  638. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '108';
  639. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '101';
  640. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '102';
  641. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '108';
  642. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '101';
  643. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '102';
  644. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '108';
  645. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '101';
  646. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '102';
  647. DELETE FROM qcril_emergency_source_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '108';
  648. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '101';
  649. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '102';
  650. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '840' AND NUMBER = '108';
  651. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '101';
  652. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '102';
  653. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '854' AND NUMBER = '108';
  654. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '101';
  655. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '102';
  656. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '855' AND NUMBER = '108';
  657. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '101';
  658. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '102';
  659. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '856' AND NUMBER = '108';
  660. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '101';
  661. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '102';
  662. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '857' AND NUMBER = '108';
  663. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '101';
  664. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '102';
  665. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '858' AND NUMBER = '108';
  666. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '101';
  667. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '102';
  668. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '859' AND NUMBER = '108';
  669. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '101';
  670. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '102';
  671. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '860' AND NUMBER = '108';
  672. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '101';
  673. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '102';
  674. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '861' AND NUMBER = '108';
  675. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '101';
  676. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '102';
  677. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '862' AND NUMBER = '108';
  678. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '101';
  679. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '102';
  680. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '863' AND NUMBER = '108';
  681. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '101';
  682. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '102';
  683. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '864' AND NUMBER = '108';
  684. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '101';
  685. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '102';
  686. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '865' AND NUMBER = '108';
  687. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '101';
  688. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '102';
  689. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '866' AND NUMBER = '108';
  690. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '101';
  691. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '102';
  692. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '867' AND NUMBER = '108';
  693. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '101';
  694. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '102';
  695. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '868' AND NUMBER = '108';
  696. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '101';
  697. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '102';
  698. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '869' AND NUMBER = '108';
  699. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '101';
  700. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '102';
  701. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '870' AND NUMBER = '108';
  702. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '101';
  703. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '102';
  704. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '871' AND NUMBER = '108';
  705. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '101';
  706. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '102';
  707. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '872' AND NUMBER = '108';
  708. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '101';
  709. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '102';
  710. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '873' AND NUMBER = '108';
  711. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '101';
  712. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '102';
  713. DELETE FROM qcril_emergency_source_voice_mcc_mnc_table where MCC = '405' AND MNC = '874' AND NUMBER = '108';