差别

这里会显示出您选择的修订版和当前版本之间的差别。

--- razor:upgrade-instruction-v0-6-to-v0-7 [2015/09/15 15:40]
cobub v0.7.2
+++ razor:upgrade-instruction-v0-6-to-v0-7 [2017/07/14 11:18]
@@ 行 1: / 行 1: @@
-~~Title:Cobub Razor V6-v7升级手册 - 开源移动应用运营平台 - 移动统计、移动推送解决方案 - Cobub 移动开发者中心~~
-{{description>Cobub Razor V6-v7升级手册}}
-{{keywords>Cobub Razor,开源移动应用分析,移动分析,移动应用分析,升级手册}}
-====== V6-v7升级手册 ======
-Cobub Razor从版本0.6升级到版本0.7，具体需要如下步骤：
-===== 步骤一: 下载V0.7版本最新代码 =====
-、从 [[https://github.com/cobub/razor|https://github.com/cobub/razor]] 下载0.7版本的代码，得到razor-0.7.zip压缩包，将其解压得到razor-0.7文件夹，里面包含sdk和web文件夹等。
-、将上面的 web 文件夹复制你准备升级部署网站的web目录下（注意复制前 web 名称不能与前几个版本的名称相同）。为了方便调试，你可以将”web”修改成”razor_v7″，并将里面的application文件夹下的config.php文件中的$config['base_url']= ‘http://yoururl/razor_v7′。
-、将0.6版本的application\config\目录下的文件autoload.php、database.php复制到0.7版本的application\config\目录下,覆盖0.7版本的这两个文件，并把0.7版本里的routes.php文件中的$route['default_controller'] = “install/installation” 修改成 $route['default_controller'] = “report/home”。
-===== 步骤二: 准备修改数据库和数据仓库的脚本文件 =====
-这里假设你的数据库为 razor ,数据仓库为 razordw ,数据库和数据仓库中的表前缀均为 **umsinstall_** 。
-====== 1、修改数据库 ======
-===== 1.1、增加表 =====
-)新增表 **umsinstall_device_tag**
-^属性名称	^属性值	^索引 ^
-|id	|int(11) NOT NULL AUTO_INCREMENT|	PRIMARY KEY|
-|device_id	|int(11) Not NULL|	|
-|tags	|varchar(1024) default NULL|	|
-|productkey	|varchar(64) Not NULL|	|
-**sql语句(注意修改表前缀umsinstall_，下同)：**
-<code>
-CREATE TABLE IF NOT EXISTS `umsinstall_device_tag` (
-    `id` int(11) NOT NULL AUTO_INCREMENT,
-    `deviceid` varchar(256) NOT NULL,
-    `tags` varchar(1024) default NULL,
-    `productkey` varchar(64) NOT NULL,
-    PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-</code>
-===== 1.2、删除表 =====
-)删除表 **umsinstall_mccmnc**
-^属性名称	^属性值	^索引 ^
-|id	|int(50) NOT NULL |	UNIQUE|
-|value	|varchar(50) Not NULL|	|
-|name	|varchar(100) default NULL|	|
-|productkey	|varchar(64) Not NULL|	|
-**sql语句(注意修改表前缀umsinstall_，下同)：**
-<code>
-CREATE TABLE IF NOT EXISTS `umsinstall_mccmnc` (
-  `id` int(50) NOT NULL,
-  `value` varchar(50) NOT NULL,
-  `name` varchar(100) NOT NULL,
-  UNIQUE KEY `id` (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-</code>
-===== 1.3、修改表 =====
-)修改表 **umsinstall_clientdata**
-^属性名称	^属性值	^变化^
-|country	|varchar(50)	|DEFAULT NULL -> DEFAULT 'unknown'|
-|region	|varchar(50)	|DEFAULT NULL -> DEFAULT 'unknown'|
-|city	|varchar(50)	|DEFAULT NULL -> DEFAULT 'unknown'|
-**sql语句：**
-<code>
-UPDATE `razor_umsinstall_clientdata` SET `country`='unknown',`region`='unknown',`city`='unknown'
-</code>
-)修改表 **umsinstall_product_category**
-**sql语句：**
-<code>
-INSERT INTO `umsinstall_product_category` (`id`, `name`, `level`, `parentid`) VALUES
-(1, "UMSINSTALL_NEWSPAPER", 1, 0),
-(2, "UMSINSTALL_SOCIAL", 1, 0),
-(3, "UMSINSTALL_BUSINESS", 1, 0),
-(4, "UMSINSTALL_FINANCIALBUSINESS", 1, 0),
-(5, "UMSINSTALL_REFERENCE", 1, 0),
-(6, "UMSINSTALL_NAVIGATION", 1, 0),
-(7, "UMSINSTALL_INSTRUMENT", 1, 0),
-(8, "UMSINSTALL_HEALTHFITNESS", 1, 0),
-(9, "UMSINSTALL_EDUCATION", 1, 0),
-(10, "UMSINSTALL_TRAVEL", 1, 0),
-(11, "UMSINSTALL_PHOTOVIDEO", 1, 0),
-(12, "UMSINSTALL_LIFE", 1, 0),
-(13, "UMSINSTALL_SPORTS", 1, 0),
-(14, "UMSINSTALL_WEATHER", 1, 0),
-(15, "UMSINSTALL_BOOKS", 1, 0),
-(16, "UMSINSTALL_EFFICIENCY", 1, 0),
-(17, "UMSINSTALL_NEWS", 1, 0),
-(18, "UMSINSTALL_MUSIC", 1, 0),
-(19, "UMSINSTALL_MEDICAL", 1, 0),
-(32, "UMSINSTALL_ENTERTAINMENT", 1, 0),
-(33, "UMSINSTALL_GAME", 1, 0);
-</code>
-)修改表 **umsinstall_user_resources**
-**sql语句：**
-<code>
-INSERT INTO `umsinstall_user_resources` (`id`, `name`, `description`, `parentId`) VALUES
-(1, "test", "Acl Test Controller", NULL),
-(2, "User", "UMSINSTALLC_SYSMANAGER", NULL),
-(3, "Product", "UMSINSTALLC_MYAPPS", NULL),
-(4, "errorlogondevice", "UMSINSTALLC_ERRORDEVICE", NULL),
-(5, "productbasic", "UMSINSTALLC_DASHBOARD", NULL),
-(6, "Auth", "UMSINSTALLC_USERS", NULL),
-(7, "Autoupdate", "UMSINSTALLC_AUTOUPDATE", NULL),
-(8, "Channel", "UMSINSTALLC_CHANNEL", NULL),
-(9, "Device", "UMSINSTALLC_DEVICE", NULL),
-(10, "Event", "UMSINSTALLC_EVENTMANAGEMENT", NULL),
-(11, "Onlineconfig", "UMSINSTALLC_SENDPOLICY", NULL),
-(12, "Operator", "UMSINSTALLC_OPERATORSTATISTICS", NULL),
-(13, "Os", "UMSINSTALLC_OSSTATISTICS", NULL),
-(14, "Profile", "UMSINSTALLC_PROFILE", NULL),
-(15, "Resolution", "UMSINSTALLC_RESOLUTIONSTATISTICS", NULL),
-(16, "Usefrequency", "UMSINSTALLC_REEQUENCYSTATISTICS", NULL),
-(17, "Usetime", "UMSINSTALLC_USAGEDURATION", NULL),
-(18, "errorlog", "UMSINSTALLC_ERRORLOG", NULL),
-(19, "Eventlist", "UMSINSTALLC_EVENTLIST", NULL),
-(20, "market", "UMSINSTALLC_CHANNELSTATISTICS", NULL),
-(21, "region", "UMSINSTALLC_GEOGRAPHYSTATICS", NULL),
-(22, "errorlogonos", "UMSINSTALLC_ERRORONOS", NULL),
-(23, "version", "UMSINSTALLC_VERSIONSTATISTICS", NULL),
-(24, "console", "UMSINSTALLC_APPS", NULL),
-(25, "Userremain", "UMSINSTALLC_RETENTION", NULL),
-(26, "Pagevisit", "UMSINSTALLC_PAGEVIEWSANALY", NULL),
-(27, "Network", "UMSINSTALLC_NETWORKINGSTATISTIC", NULL),
-(28, "funnels", "UMSINSTALLC_FUNNELMODEL", NULL);
-</code>
-====== 2、修改数据仓库 ======
-===== 2.1、修改表 =====
-)修改表 **umsinstall_dim_devicesupplier**
-^属性名称	^属性值	^变化^
-|devicesupplier_name	|varchar(60)	|NOT NULL ->NOT NULL DEFAULT 'unknown'|
-|mccmnc	|varchar(16) NOT NULL |	     新增|
-|countrycode	|varchar(8) DEFAULT NULL |	     新增|
-|countrycode	|varchar(128) DEFAULT NULL |	     新增|
-**sql语句：**
-<code>
-ALTER TABLE `razordw.umsinstall_log` ADD COLUMN `mccmnc` varchar(16) NOT NULL,`countrycode` varchar(8) DEFAULT NULL,`countryname` varchar(128) DEFAULT NULL,ALTER TABLE `umsinstall_dim_devicesupplier` ADD INDEX(`devicesupplier_name`,`mccmnc`);
-</code>
-)修改表 **umsinstall_dim_devicesupplier**
-**sql语句：**
-<code>
-INSERT INTO `umsinstall_dim_devicesupplier` (`mccmnc`, `devicesupplier_name`,`countrycode`,`countryname`) VALUES
-('20201', 'Cosmote Greece', '202', 'GR'),
-('20205', 'Vodafone - Panafon Greece', '202', 'GR'),
-('20209', 'Info Quest S.A. Greece', '202', 'GR'),
-('20210', 'Telestet Greece', '202', 'GR'),
-('20402', 'Tele2 (Netherlands) B.V.', '204', 'NL'),
-('20404', 'Vodafone Libertel N.V. Netherlands', '204', 'NL'),
-('20408', 'KPN Telecom B.V. Netherlands', '204', 'NL'),
-('20412', 'BT Ignite Nederland B.V.', '204', 'NL'),
-('20416', 'BEN Nederland B.V.', '204', 'NL'),
-('20420', 'Dutchtone N.V. Netherlands', '204', 'NL'),
-('20421', 'NS Railinfrabeheer B.V. Netherlands', '204', 'NL'),
-('20601', 'Proximus Belgium', '206', 'BE'),
-('20610', 'Mobistar Belgium', '206', 'BE'),
-('20620', 'Base Belgium', '206', 'BE'),
-('20801', 'Orange', '208', 'FR'),
-('20802', 'Orange', '208', 'FR'),
-('20805', 'Globalstar Europe France', '208', 'FR'),
-('20806', 'Globalstar Europe France', '208', 'FR'),
-('20807', 'Globalstar Europe France', '208', 'FR'),
-('20810', 'SFR', '208', 'FR'),
-('20811', 'SFR', '208', 'FR'),
-('20813', 'SFR', '208', 'FR'),
-('20815', 'Free Mobile', '208', 'FR'),
-('20816', 'Free Mobile', '208', 'FR'),
-('20820', 'Bouygues Telecom', '208', 'FR'),
-('20821', 'Bouygues Telecom', '208', 'FR'),
-('20823', 'Virgin Mobile', '208', 'FR'),
-('20825', 'Lycamobile', '208', 'FR'),
-('20826', 'NRJ Mobile', '208', 'FR'),
-('20827', 'Afone Mobile', '208', 'FR'),
-('20830', 'Symacom', '208', 'FR'),
-('20888', 'Bouygues Telecom', '208', 'FR'),
-('21303', 'MobilandAndorra', '213', 'AD'),
-('21401', 'Vodafone Spain', '214', 'ES'),
-('21403', 'Amena Spain', '214', 'ES'),
-('21404', 'Xfera Spain', '214', 'ES'),
-('21407', 'Movistar Spain', '214', 'ES'),
-('21601', 'Pannon GSM Hungary', '216', 'HU'),
-('21630', 'T-Mobile Hungary', '216', 'HU'),
-('21670', 'Vodafone Hungary', '216', 'HU'),
-('21803', 'Eronet Mobile Communications Ltd. Bosnia and Herzegovina', '218', 'BA'),
-('21805', 'MOBIS (Mobilina Srpske) Bosnia and Herzegovina', '218', 'BA'),
-('21890', 'GSMBIH Bosnia and Herzegovina', '218', 'BA'),
-('21901', 'Cronet Croatia', '219', 'HR'),
-('21910', 'VIPnet Croatia', '219', 'HR'),
-('22001', 'Mobtel Serbia', '220', 'YU'),
-('22002', 'Promonte GSM Serbia', '220', 'YU'),
-('22003', 'Telekom Srbija', '220', 'YU'),
-('22004', 'Monet Serbia', '220', 'YU'),
-('22201', 'Telecom Italia Mobile (TIM)', '222', 'IT'),
-('22202', 'Elsacom Italy', '222', 'IT'),
-('22210', 'Omnitel Pronto Italia (OPI)', '222', 'IT'),
-('22277', 'IPSE 2000 Italy', '222', 'IT'),
-('22288', 'Wind Italy', '222', 'IT'),
-('22298', 'Blu Italy', '222', 'IT'),
-('22299', 'H3G Italy', '222', 'IT'),
-('22601', 'Vodafone Romania SA', '226', 'RO'),
-('22603', 'Cosmorom Romania', '226', 'RO'),
-('22610', 'Orange Romania', '226', 'RO'),
-('22801', 'Swisscom GSM', '228', 'CH'),
-('22802', 'Sunrise GSM Switzerland', '228', 'CH'),
-('22803', 'Orange Switzerland', '228', 'CH'),
-('22805', 'Togewanet AG Switzerland', '228', 'CH'),
-('22806', 'SBB AG Switzerland', '228', 'CH'),
-('22807', 'IN&Phone SA Switzerland', '228', 'CH'),
-('22808', 'Tele2 Telecommunications AG Switzerland', '228', 'CH'),
-('22812', 'Sunrise UMTS Switzerland', '228', 'CH'),
-('22850', '3G Mabile AG Switzerland', '228', 'CH'),
-('22851', 'Global Networks Schweiz AG', '228', 'CH'),
-('23001', 'RadioMobil a.s., T-Mobile Czech Rep.', '230', 'CZ'),
-('23002', 'Eurotel Praha, spol. Sro., Eurotel Czech Rep.', '230', 'CZ'),
-('23003', 'Cesky Mobil a.s., Oskar', '230', 'CZ'),
-('23099', 'Cesky Mobil a.s., R&D Centre', '230', 'CZ'),
-('23101', 'Orange, GSM Slovakia', '231', 'SK'),
-('23102', 'Eurotel, GSM & NMT Slovakia', '231', 'SK'),
-('23104', 'Eurotel, UMTS Slovakia', '231', 'SK'),
-('23105', 'Orange, UMTS Slovakia', '231', 'SK'),
-('23201', 'A1 Austria', '232', 'AT'),
-('23203', 'T-Mobile Austria', '232', 'AT'),
-('23205', 'One Austria', '232', 'AT'),
-('23207', 'tele.ring Austria', '232', 'AT'),
-('23208', 'Telefonica Austria', '232', 'AT'),
-('23209', 'One Austria', '232', 'AT'),
-('23210', 'Hutchison 3G Austria', '232', 'AT'),
-('23402', 'O2 UK Ltd.', '234', 'GB'),
-('23410', 'O2 UK Ltd.', '234', 'GB'),
-('23411', 'O2 UK Ltd.', '234', 'GB'),
-('23412', 'Railtrack Plc UK', '234', 'GB'),
-('23415', 'Vodafone', '234', 'GB'),
-('23420', 'Hutchison 3G UK Ltd.', '234', 'GB'),
-('23430', 'T-Mobile UK', '234', 'GB'),
-('23431', 'T-Mobile UK', '234', 'GB'),
-('23432', 'T-Mobile UK', '234', 'GB'),
-('23433', 'Orange UK', '234', 'GB'),
-('23434', 'Orange UK', '234', 'GB'),
-('23450', 'Jersey Telecom UK', '234', 'GB'),
-('23455', 'Guensey Telecom UK', '234', 'GB'),
-('23458', 'Manx Telecom UK', '234', 'GB'),
-('23475', 'Inquam Telecom (Holdings) Ltd. UK', '234', 'GB'),
-('23801', 'TDC Mobil Denmark', '238', 'DK'),
-('23802', 'Sonofon Denmark', '238', 'DK'),
-('23803', 'MIGway A/S Denmark', '238', 'DK'),
-('23806', 'Hi3G Denmark', '238', 'DK'),
-('23807', 'Barablu Mobile Ltd. Denmark', '238', 'DK'),
-('23810', 'TDC Mobil Denmark', '238', 'DK'),
-('23820', 'Telia Denmark', '238', 'DK'),
-('23830', 'Telia Mobile Denmark', '238', 'DK'),
-('23877', 'Tele2 Denmark', '238', 'DK'),
-('24001', 'Telia Sonera AB Sweden', '240', 'SE'),
-('24002', 'H3G Access AB Sweden', '240', 'SE'),
-('24003', 'Nordisk Mobiltelefon AS Sweden', '240', 'SE'),
-('24004', '3G Infrastructure Services AB Sweden', '240', 'SE'),
-('24005', 'Svenska UMTS-Nat AB', '240', 'SE'),
-('24006', 'Telenor Sverige AB', '240', 'SE'),
-('24007', 'Tele2 Sverige AB', '240', 'SE'),
-('24008', 'Telenor Sverige AB', '240', 'SE'),
-('24009', 'Telenor Mobile Sverige', '240', 'SE'),
-('24010', 'Swefour AB Sweden', '240', 'SE'),
-('24011', 'Linholmen Science Park AB Sweden', '240', 'SE'),
-('24020', 'Wireless Maingate Message Services AB Sweden', '240', 'SE'),
-('24021', 'Banverket Sweden', '240', 'SE'),
-('24201', 'Telenor Mobil AS Norway', '242', 'NO'),
-('24202', 'Netcom GSM AS Norway', '242', 'NO'),
-('24203', 'Teletopia Mobile Communications AS Norway', '242', 'NO'),
-('24204', 'Tele2 Norge AS', '242', 'NO'),
-('24404', 'Finnet Networks Ltd.', '244', 'FI'),
-('24405', 'Elisa Matkapuhelinpalvelut Ltd. Finland', '244', 'FI'),
-('24409', 'Finnet Group', '244', 'FI'),
-('24412', 'Finnet Networks Ltd.', '244', 'FI'),
-('24414', 'Alands Mobiltelefon AB Finland', '244', 'FI'),
-('24416', 'Oy Finland Tele2 AB', '244', 'FI'),
-('24421', 'Saunalahti Group Ltd. Finland', '244', 'FI'),
-('24491', 'Sonera Carrier Networks Oy Finland', '244', 'FI'),
-('24601', 'Omnitel Lithuania', '246', 'LT'),
-('24602', 'Bit GSM Lithuania', '246', 'LT'),
-('24603', 'Tele2 Lithuania', '246', 'LT'),
-('24701', 'Latvian Mobile Phone', '247', 'LV'),
-('24702', 'Tele2 Latvia', '247', 'LV'),
-('24703', 'Telekom Baltija Latvia', '247', 'LV'),
-('24704', 'Beta Telecom Latvia', '247', 'LV'),
-('24801', 'EMT GSM Estonia', '248', 'EE'),
-('24802', 'RLE Estonia', '248', 'EE'),
-('24803', 'Tele2 Estonia', '248', 'EE'),
-('24804', 'OY Top Connect Estonia', '248', 'EE'),
-('24805', 'AS Bravocom Mobiil Estonia', '248', 'EE'),
-('24806', 'OY ViaTel Estonia', '248', 'EE'),
-('25001', 'Mobile Telesystems Russia', '250', 'RU'),
-('25002', 'Megafon Russia', '250', 'RU'),
-('25003', 'Nizhegorodskaya Cellular Communications Russia', '250', 'RU'),
-('25004', 'Sibchallenge Russia', '250', 'RU'),
-('25005', 'Mobile Comms System Russia', '250', 'RU'),
-('25007', 'BM Telecom Russia', '250', 'RU'),
-('25010', 'Don Telecom Russia', '250', 'RU'),
-('25011', 'Orensot Russia', '250', 'RU'),
-('25012', 'Baykal Westcom Russia', '250', 'RU'),
-('25013', 'Kuban GSM Russia', '250', 'RU'),
-('25016', 'New Telephone Company Russia', '250', 'RU'),
-('25017', 'Ermak RMS Russia', '250', 'RU'),
-('25019', 'Volgograd Mobile Russia', '250', 'RU'),
-('25020', 'ECC Russia', '250', 'RU'),
-('25028', 'Extel Russia', '250', 'RU'),
-('25039', 'Uralsvyazinform Russia', '250', 'RU'),
-('25044', 'Stuvtelesot Russia', '250', 'RU'),
-('25092', 'Printelefone Russia', '250', 'RU'),
-('25093', 'Telecom XXI Russia', '250', 'RU'),
-('25099', 'Bec Line GSM Russia', '250', 'RU'),
-('25501', 'Ukrainian Mobile Communication, UMC', '255', 'UA'),
-('25502', 'Ukranian Radio Systems, URS', '255', 'UA'),
-('25503', 'Kyivstar Ukraine', '255', 'UA'),
-('25504', 'Golden Telecom, GT Ukraine', '255', 'UA'),
-('25506', 'Astelit Ukraine', '255', 'UA'),
-('25507', 'Ukrtelecom Ukraine', '255', 'UA'),
-('25701', 'MDC Velcom Belarus', '257', 'BY'),
-('25702', 'MTS Belarus', '257', 'BY'),
-('25901', 'Voxtel Moldova', '259', 'MD'),
-('25902', 'Moldcell Moldova', '259', 'MD'),
-('26001', 'Plus GSM (Polkomtel S.A.) Poland', '260', 'PL'),
-('26002', 'ERA GSM (Polska Telefonia Cyfrowa Sp. Z.o.o.)', '260', 'PL'),
-('26003', 'Idea (Polska Telefonia Komorkowa Centertel Sp. Z.o.o)', '260', 'PL'),
-('26004', 'Tele2 Polska (Tele2 Polska Sp. Z.o.o.)', '260', 'PL'),
-('26005', 'IDEA (UMTS)/PTK Centertel sp. Z.o.o. Poland', '260', 'PL'),
-('26006', 'Netia Mobile Poland', '260', 'PL'),
-('26007', 'Premium internet Poland', '260', 'PL'),
-('26008', 'E-Telko Poland', '260', 'PL'),
-('26009', 'Telekomunikacja Kolejowa (GSM-R) Poland', '260', 'PL'),
-('26010', 'Telefony Opalenickie Poland', '260', 'PL'),
-('26201', 'T-Mobile Deutschland GmbH', '262', 'DE'),
-('26202', 'Vodafone D2 GmbH Germany', '262', 'DE'),
-('26203', 'E-Plus Mobilfunk GmbH & Co. KG Germany', '262', 'DE'),
-('26204', 'Vodafone D2 GmbH Germany', '262', 'DE'),
-('26205', 'E-Plus Mobilfunk GmbH & Co. KG Germany', '262', 'DE'),
-('26206', 'T-Mobile Deutschland GmbH', '262', 'DE'),
-('26207', 'O2 (Germany) GmbH & Co. OHG', '262', 'DE'),
-('26208', 'O2 (Germany) GmbH & Co. OHG', '262', 'DE'),
-('26209', 'Vodafone D2 GmbH Germany', '262', 'DE'),
-('26210', 'Arcor AG & Co. Germany', '262', 'DE'),
-('26211', 'O2 (Germany) GmbH & Co. OHG', '262', 'DE'),
-('26212', 'Dolphin Telecom (Deutschland) GmbH', '262', 'DE'),
-('26213', 'Mobilcom Multimedia GmbH Germany', '262', 'DE'),
-('26214', 'Group 3G UMTS GmbH (Quam) Germany', '262', 'DE'),
-('26215', 'Airdata AG Germany', '262', 'DE'),
-('26276', 'Siemens AG, ICMNPGUSTA Germany', '262', 'DE'),
-('26277', 'E-Plus Mobilfunk GmbH & Co. KG Germany', '262', 'DE'),
-('26601', 'Gibtel GSM Gibraltar', '266', 'GI'),
-('26801', 'Vodafone Telecel - Comunicacoes Pessoais, S.A. Portugal', '268', 'PT'),
-('26803', 'Optimus - Telecomunicacoes, S.A. Portugal', '268', 'PT'),
-('26805', 'Oniway - Inforcomunicacoes, S.A. Portugal', '268', 'PT'),
-('26806', 'TMN - Telecomunicacoes Moveis Nacionais, S.A. Portugal', '268', 'PT'),
-('27001', 'P&T Luxembourg', '270', 'LU'),
-('27077', 'Tango Luxembourg', '270', 'LU'),
-('27099', 'Voxmobile S.A. Luxembourg', '270', 'LU'),
-('27201', 'Vodafone Ireland Plc', '272', 'IE'),
-('27202', 'Digifone mm02 Ltd. Ireland', '272', 'IE'),
-('27203', 'Meteor Mobile Communications Ltd. Ireland', '272', 'IE'),
-('27207', 'Eircom Ireland', '272', 'IE'),
-('27209', 'Clever Communications Ltd. Ireland', '272', 'IE'),
-('27401', 'Iceland Telecom Ltd.', '274', 'IS'),
-('27402', 'Tal hf Iceland', '274', 'IS'),
-('27403', 'Islandssimi GSM ehf Iceland', '274', 'IS'),
-('27404', 'IMC Islande ehf', '274', 'IS'),
-('27601', 'AMC Albania', '276', 'AL'),
-('27602', 'Vodafone Albania', '276', 'AL'),
-('27801', 'Vodafone Malta', '278', 'MT'),
-('27821', 'go mobile Malta', '278', 'MT'),
-('28001', 'CYTA Cyprus', '280', 'CY'),
-('28010', 'Scancom (Cyprus) Ltd.', '280', 'CY'),
-('28201', 'Geocell Ltd. Georgia', '282', 'GE'),
-('28202', 'Magti GSM Ltd. Georgia', '282', 'GE'),
-('28203', 'Iberiatel Ltd. Georgia', '282', 'GE'),
-('28204', 'Mobitel Ltd. Georgia', '282', 'GE'),
-('28301', 'ARMGSM', '283', 'AM'),
-('28401', 'M-Tel GSM BG Bulgaria', '284', 'BG'),
-('28405', 'Globul Bulgaria', '284', 'BG'),
-('28601', 'Turkcell Turkey', '286', 'TR'),
-('28602', 'Telsim GSM Turkey', '286', 'TR'),
-('28603', 'Aria Turkey', '286', 'TR'),
-('28604', 'Aycell Turkey', '286', 'TR'),
-('28801', 'Faroese Telecom - GSM', '288', 'FO'),
-('28802', 'Kall GSM Faroe Islands', '288', 'FO'),
-('29001', 'Tele Greenland', '290', 'GR'),
-('29201', 'SMT - San Marino Telecom', '292', 'SM'),
-('29340', 'SI Mobil Slovenia', '293', 'SI'),
-('29341', 'Mobitel Slovenia', '293', 'SI'),
-('29369', 'Akton d.o.o. Slovenia', '293', 'SI'),
-('29370', 'Tusmobil d.o.o. Slovenia', '293', 'SI'),
-('29401', 'Mobimak Macedonia', '294', 'MK'),
-('29402', 'MTS Macedonia', '294', 'MK'),
-('29501', 'Telecom FL AG Liechtenstein', '295', 'LI'),
-('29502', 'Viag Europlatform AG Liechtenstein', '295', 'LI'),
-('29505', 'Mobilkom (Liechstein) AG', '295', 'LI'),
-('29577', 'Tele2 AG Liechtenstein', '295', 'LI'),
-('30236', 'Clearnet Canada', '302', 'CA'),
-('30237', 'Microcell Canada', '302', 'CA'),
-('30262', 'Ice Wireless Canada', '302', 'CA'),
-('30263', 'Aliant Mobility Canada', '302', 'CA'),
-('30264', 'Bell Mobility Canada', '302', 'CA'),
-('302656', 'Tbay Mobility Canada', '302', 'CA'),
-('30266', 'MTS Mobility Canada', '302', 'CA'),
-('30267', 'CityTel Mobility Canada', '302', 'CA'),
-('30268', 'Sask Tel Mobility Canada', '302', 'CA'),
-('30271', 'Globalstar Canada', '302', 'CA'),
-('30272', 'Rogers Wireless Canada', '302', 'CA'),
-('30286', 'Telus Mobility Canada', '302', 'CA'),
-('30801', 'St. Pierre-et-Miquelon Telecom', '308', 'CA'),
-('310010', 'MCI USA', '310', 'US'),
-('310012', 'Verizon Wireless USA', '310', 'US'),
-('310013', 'Mobile Tel Inc. USA', '310', 'US'),
-('310014', 'Testing USA', '310', 'US'),
-('310016', 'Cricket Communications USA', '310', 'US'),
-('310017', 'North Sight Communications Inc. USA', '310', 'US'),
-('310020', 'Union Telephone Company USA', '310', 'US'),
-('310030', 'Centennial Communications USA', '310', 'US'),
-('310034', 'Nevada Wireless LLC USA', '310', 'US'),
-('310040', 'Concho Cellular Telephone Co., Inc. USA', '310', 'US'),
-('310050', 'ACS Wireless Inc. USA', '310', 'US'),
-('310060', 'Consolidated Telcom USA', '310', 'US'),
-('310070', 'Highland Cellular, Inc. USA', '310', 'US'),
-('310080', 'Corr Wireless Communications LLC USA', '310', 'US'),
-('310090', 'Edge Wireless LLC USA', '310', 'US'),
-('310100', 'New Mexico RSA 4 East Ltd. Partnership USA', '310', 'US'),
-('310120', 'Sprint USA', '310', 'US'),
-('310130', 'Carolina West Wireless USA', '310', 'US'),
-('310140', 'GTA Wireless LLC USA', '310', 'US'),
-('310150', 'Cingular Wireless USA', '310', 'US'),
-('310160', 'T-Mobile USA', '310', 'US'),
-('310170', 'Cingular Wireless USA', '310', 'US'),
-('310180', 'West Central Wireless USA', '310', 'US'),
-('310190', 'Alaska Wireless Communications LLC USA', '310', 'US'),
-('310200', 'T-Mobile USA', '310', 'US'),
-('310210', 'T-Mobile USA', '310', 'US'),
-('310220', 'T-Mobile USA', '310', 'US'),
-('310230', 'T-Mobile USA', '310', 'US'),
-('310240', 'T-Mobile USA', '310', 'US'),
-('310250', 'T-Mobile USA', '310', 'US'),
-('310260', 'T-Mobile USA', '310', 'US'),
-('310270', 'T-Mobile USA', '310', 'US'),
-('310280', 'Contennial Puerto Rio License Corp. USA', '310', 'US'),
-('310290', 'Nep Cellcorp Inc. USA', '310', 'US'),
-('310300', 'Get Mobile Inc. USA', '310', 'US');
-</code>
-)修改表 **umsinstall_dim_devicesupplier**
-**sql语句：**
-<code>
-INSERT INTO `umsinstall_dim_devicesupplier` (`mccmnc`, `devicesupplier_name`,`countrycode`,`countryname`) VALUES
-('310300', 'Get Mobile Inc. USA', '310', 'US'),
-('310310', 'T-Mobile USA', '310', 'US'),
-('310320', 'Bug Tussel Wireless LLC USA', '310', 'US'),
-('310330', 'AN Subsidiary LLC USA', '310', 'US'),
-('310340', 'High Plains Midwest LLC, dba Wetlink Communications USA', '310', 'US'),
-('310350', 'Mohave Cellular L.P. USA', '310', 'US'),
-('310360', 'Cellular Network Partnership dba Pioneer Cellular USA', '310', 'US'),
-('310370', 'Guamcell Cellular and Paging USA', '310', 'US'),
-('310380', 'AT&T Wireless Services Inc. USA', '310', 'US'),
-('310390', 'TX-11 Acquistion LLC USA', '310', 'US'),
-('310400', 'Wave Runner LLC USA', '310', 'US'),
-('310410', 'Cingular Wireless USA', '310', 'US'),
-('310420', 'Cincinnati Bell Wireless LLC USA', '310', 'US'),
-('310430', 'Alaska Digitel LLC USA', '310', 'US'),
-('310440', 'Numerex Corp. USA', '310', 'US'),
-('310450', 'North East Cellular Inc. USA', '310', 'US'),
-('310460', 'TMP Corporation USA', '310', 'US'),
-('310470', 'Guam Wireless Telephone Company USA', '310', 'US'),
-('310480', 'Choice Phone LLC USA', '310', 'US'),
-('310490', 'Triton PCS USA', '310', 'US'),
-('310500', 'Public Service Cellular, Inc. USA', '310', 'US'),
-('310510', 'Airtel Wireless LLC USA', '310', 'US'),
-('310520', 'VeriSign USA', '310', 'US'),
-('310530', 'West Virginia Wireless USA', '310', 'US'),
-('310540', 'Oklahoma Western Telephone Company USA', '310', 'US'),
-('310560', 'American Cellular Corporation USA', '310', 'US'),
-('310570', 'MTPCS LLC USA', '310', 'US'),
-('310580', 'PCS ONE USA', '310', 'US'),
-('310590', 'Western Wireless Corporation USA', '310', 'US'),
-('310600', 'New Cell Inc. dba Cellcom USA', '310', 'US'),
-('310610', 'Elkhart Telephone Co. Inc. dba Epic Touch Co. USA', '310', 'US'),
-('310620', 'Coleman County Telecommunications Inc. (Trans Texas PCS) USA', '310', 'US'),
-('310630', 'Comtel PCS Mainstreet LP USA', '310', 'US'),
-('310640', 'Airadigm Communications USA', '310', 'US'),
-('310650', 'Jasper Wireless Inc. USA', '310', 'US'),
-('310660', 'T-Mobile USA', '310', 'US'),
-('310670', 'Northstar USA', '310', 'US'),
-('310680', 'Noverr Publishing, Inc. dba NPI Wireless USA', '310', 'US'),
-('310690', 'Conestoga Wireless Company USA', '310', 'US'),
-('310700', 'Cross Valiant Cellular Partnership USA', '310', 'US'),
-('310710', 'Arctic Slopo Telephone Association Cooperative USA', '310', 'US'),
-('310720', 'Wireless Solutions International Inc. USA', '310', 'US'),
-('310730', 'Sea Mobile USA', '310', 'US'),
-('310740', 'Telemetrix Technologies USA', '310', 'US'),
-('310750', 'East Kentucky Network LLC dba Appalachian Wireless USA', '310', 'US'),
-('310760', 'Panhandle Telecommunications Systems Inc. USA', '310', 'US'),
-('310770', 'Iowa Wireless Services LP USA', '310', 'US'),
-('310790', 'PinPoint Communications Inc. USA', '310', 'US'),
-('310800', 'T-Mobile USA', '310', 'US'),
-('310810', 'Brazos Cellular Communications Ltd. USA', '310', 'US'),
-('310820', 'Triton PCS License Company LLC USA', '310', 'US'),
-('310830', 'Caprock Cellular Ltd. Partnership USA', '310', 'US'),
-('310840', 'Edge Mobile LLC USA', '310', 'US'),
-('310850', 'Aeris Communications, Inc. USA', '310', 'US'),
-('310870', 'Kaplan Telephone Company Inc. USA', '310', 'US'),
-('310880', 'Advantage Cellular Systems, Inc. USA', '310', 'US'),
-('310890', 'Rural Cellular Corporation USA', '310', 'US'),
-('310900', 'Taylor Telecommunications Ltd. USA', '310', 'US'),
-('310910', 'Southern IL RSA Partnership dba First Cellular of Southern USA', '310', 'US'),
-('310940', 'Poka Lambro Telecommunications Ltd. USA', '310', 'US'),
-('310950', 'Texas RSA 1 dba XIT Cellular USA', '310', 'US'),
-('310970', 'Globalstar USA', '310', 'US'),
-('310980', 'AT&T Wireless Services Inc. USA', '310', 'US'),
-('310990', 'Alaska Digitel USA', '310', 'US'),
-('311000', 'Mid-Tex Cellular Ltd. USA', '311', 'US'),
-('311010', 'Chariton Valley Communications Corp., Inc. USA', '311', 'US'),
-('311020', 'Missouri RSA No. 5 Partnership USA', '311', 'US'),
-('311030', 'Indigo Wireless, Inc. USA', '311', 'US'),
-('311040', 'Commet Wireless, LLC USA', '311', 'US'),
-('311070', 'Easterbrooke Cellular Corporation USA', '311', 'US'),
-('311080', 'Pine Telephone Company dba Pine Cellular USA', '311', 'US'),
-('311090', 'Siouxland PCS USA', '311', 'US'),
-('311100', 'High Plains Wireless L.P. USA', '311', 'US'),
-('311110', 'High Plains Wireless L.P. USA', '311', 'US'),
-('311120', 'Choice Phone LLC USA', '311', 'US'),
-('311130', 'Amarillo License L.P. USA', '311', 'US'),
-('311140', 'MBO Wireless Inc./Cross Telephone Company USA', '311', 'US'),
-('311150', 'Wilkes Cellular Inc. USA', '311', 'US'),
-('311160', 'Endless Mountains Wireless, LLC USA', '311', 'US'),
-('311180', 'Cingular Wireless, Licensee Pacific Telesis Mobile Services, LLC USA', '311', 'US'),
-('311190', 'Cellular Properties Inc. USA', '311', 'US'),
-('311200', 'ARINC USA', '311', 'US'),
-('311210', 'Farmers Cellular Telephone USA', '311', 'US'),
-('311230', 'Cellular South Inc. USA', '311', 'US'),
-('311250', 'Wave Runner LLC USA', '311', 'US'),
-('311260', 'SLO Cellular Inc. dba CellularOne of San Luis Obispo USA', '311', 'US'),
-('311270', 'Alltel Communications Inc. USA', '311', 'US'),
-('311271', 'Alltel Communications Inc. USA', '311', 'US'),
-('311272', 'Alltel Communications Inc. USA', '311', 'US'),
-('311273', 'Alltel Communications Inc. USA', '311', 'US'),
-('311274', 'Alltel Communications Inc. USA', '311', 'US'),
-('311275', 'Alltel Communications Inc. USA', '311', 'US'),
-('311276', 'Alltel Communications Inc. USA', '311', 'US'),
-('311277', 'Alltel Communications Inc. USA', '311', 'US'),
-('311278', 'Alltel Communications Inc. USA', '311', 'US'),
-('311279', 'Alltel Communications Inc. USA', '311', 'US'),
-('311280', 'Verizon Wireless USA', '311', 'US'),
-('311281', 'Verizon Wireless USA', '311', 'US'),
-('311282', 'Verizon Wireless USA', '311', 'US'),
-('311283', 'Verizon Wireless USA', '311', 'US'),
-('311284', 'Verizon Wireless USA', '311', 'US'),
-('311285', 'Verizon Wireless USA', '311', 'US'),
-('311286', 'Verizon Wireless USA', '311', 'US'),
-('311287', 'Verizon Wireless USA', '311', 'US'),
-('311288', 'Verizon Wireless USA', '311', 'US'),
-('311289', 'Verizon Wireless USA', '311', 'US'),
-('311290', 'Pinpoint Wireless Inc. USA', '311', 'US'),
-('311320', 'Commnet Wireless LLC USA', '311', 'US'),
-('311340', 'Illinois Valley Cellular USA', '311', 'US'),
-('311380', 'New Dimension Wireless Ltd. USA', '311', 'US'),
-('311390', 'Midwest Wireless Holdings LLC USA', '311', 'US'),
-('311400', 'Salmon PCS LLC USA', '311', 'US'),
-('311410', 'Iowa RSA No.2 Ltd Partnership USA', '311', 'US'),
-('311420', 'Northwest Missouri Cellular Limited Partnership USA', '311', 'US'),
-('311430', 'RSA 1 Limited Partnership dba Cellular 29 Plus USA', '311', 'US'),
-('311440', 'Bluegrass Cellular LLC USA', '311', 'US'),
-('311450', 'Panhandle Telecommunication Systems Inc. USA', '311', 'US'),
-('316010', 'Nextel Communications Inc. USA', '316', 'US'),
-('316011', 'Southern Communications Services Inc. USA', '316', 'US'),
-('334020', 'Telcel Mexico', '334', 'MX'),
-('338020', 'Cable & Wireless Jamaica Ltd.', '338', 'JM'),
-('338050', 'Mossel (Jamaica) Ltd.', '338', 'JM'),
-('34001', 'Orange Carabe Mobiles Guadeloupe', '340', 'FW'),
-('34002', 'Outremer Telecom Guadeloupe', '340', 'FW'),
-('34003', 'Saint Martin et Saint Barthelemy Telcell Sarl Guadeloupe', '340', 'FW'),
-('34020', 'Bouygues Telecom Caraibe Guadeloupe', '340', 'FW'),
-('342600', 'Cable & Wireless (Barbados) Ltd.', '342', 'BB '),
-('342820', 'Sunbeach Communications Barbados', '342', 'BB '),
-('344030', 'APUA PCS Antigua ', '344', 'AG'),
-('344920', 'Cable & Wireless (Antigua)', '344', 'AG'),
-('344930', 'AT&T Wireless (Antigua)', '344', 'AG'),
-('346140', 'Cable & Wireless (Cayman)', '346', 'KY'),
-('348570', 'Caribbean Cellular Telephone, Boatphone Ltd.', '348', 'BVI'),
-('35001', 'Telecom', '350', 'BM'),
-('36251', 'TELCELL GSM Netherlands Antilles', '362', 'AN'),
-('36269', 'CT GSM Netherlands Antilles', '362', 'AN'),
-('36291', 'SETEL GSM Netherlands Antilles', '362', 'AN'),
-('36301', 'Setar GSM Aruba', '363', 'AW'),
-('365010', 'Weblinks Limited Anguilla', '365', 'AI'),
-('36801', 'ETECSA Cuba', '368', 'CU'),
-('37001', 'Orange Dominicana, S.A.', '370', 'DO'),
-('37002', 'Verizon Dominicana S.A.', '370', 'DO'),
-('37003', 'Tricom S.A. Dominican Rep.', '370', 'DO'),
-('37004', 'CentennialDominicana', '370', 'DO'),
-('37201', 'Comcel Haiti', '372', 'HT'),
-('37202', 'Digicel Haiti', '372', 'HT'),
-('37203', 'Rectel Haiti', '372', 'HT'),
-('37412', 'TSTT Mobile Trinidad and Tobago', '374', 'TT'),
-('374130', 'Digicel Trinidad and Tobago Ltd.', '374', 'TT'),
-('374140', 'LaqTel Ltd. Trinidad and Tobago', '374', 'TT'),
-('40001', 'Azercell Limited Liability Joint Venture', '400', 'AZ'),
-('40002', 'Bakcell Limited Liability Company Azerbaijan', '400', 'AZ'),
-('40003', 'Catel JV Azerbaijan', '400', 'AZ'),
-('40004', 'Azerphone LLC', '400', 'AZ'),
-('40101', 'Kar-Tel llc Kazakhstan', '401', 'KZ'),
-('40102', 'TSC Kazak Telecom Kazakhstan', '401', 'KZ'),
-('40211', 'Bhutan Telecom Ltd', '402', 'BT '),
-('40217', 'B-Mobile of Bhutan Telecom', '402', 'BT '),
-('40401', 'Aircell Digilink India Ltd.,', '404', 'IN'),
-('40402', 'Bharti Mobile Ltd. India', '404', 'IN'),
-('40403', 'Bharti Telenet Ltd. India', '404', 'IN'),
-('40404', 'Idea Cellular Ltd. India', '404', 'IN'),
-('40405', 'Fascel Ltd. India', '404', 'IN'),
-('40406', 'Bharti Mobile Ltd. India', '404', 'IN'),
-('40407', 'Idea Cellular Ltd. India', '404', 'IN'),
-('40409', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40410', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40411', 'Sterling Cellular Ltd. India', '404', 'IN'),
-('40412', 'Escotel Mobile Communications Pvt Ltd. India', '404', 'IN'),
-('40413', 'Hutchinson Essar South Ltd. India', '404', 'IN'),
-('40414', 'Spice Communications Ltd. India', '404', 'IN'),
-('40415', 'Aircell Digilink India Ltd.', '404', 'IN'),
-('40416', 'Hexcom India', '404', 'IN'),
-('40418', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40419', 'Escotel Mobile Communications Pvt Ltd. India', '404', 'IN'),
-('40420', 'Hutchinson Max Telecom India', '404', 'IN'),
-('40421', 'BPL Mobile Communications Ltd. India', '404', 'IN'),
-('40422', 'Idea Cellular Ltd. India', '404', 'IN'),
-('40424', 'Idea Cellular Ltd. India', '404', 'IN'),
-('40427', 'BPL Cellular Ltd. India', '404', 'IN'),
-('40430', 'Usha Martin Telecom Ltd. India', '404', 'IN'),
-('40431', 'Bharti Mobinet Ltd. India', '404', 'IN'),
-('40434', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40436', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40438', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40440', 'Bharti Mobinet Ltd. India', '404', 'IN'),
-('40441', 'RPG Cellular India', '404', 'IN'),
-('40442', 'Aircel Ltd. India', '404', 'IN'),
-('40443', 'BPL Mobile Cellular Ltd. India', '404', 'IN'),
-('40444', 'Spice Communications Ltd. India', '404', 'IN'),
-('40446', 'BPL Cellular Ltd. India', '404', 'IN'),
-('40449', 'Bharti Mobile Ltd. India', '404', 'IN'),
-('40450', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40451', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40452', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40453', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40454', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40455', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40456', 'Escotel Mobile Communications Pvt Ltd. India', '404', 'IN'),
-('40457', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40458', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40459', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40460', 'Aircell Digilink India Ltd.', '404', 'IN'),
-('40462', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40464', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40466', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40467', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40468', 'Mahanagar Telephone Nigam Ltd. India', '404', 'IN'),
-('40469', 'Mahanagar Telephone Nigam Ltd. India', '404', 'IN'),
-('40470', 'Hexicom India', '404', 'IN'),
-('40471', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40472', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40473', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40474', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40475', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40476', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40477', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40478', 'BTA Cellcom Ltd. India', '404', 'IN'),
-('40480', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40481', 'Bharat Sanchar Nigam Ltd. (BSNL) India', '404', 'IN'),
-('40482', 'Escorts Telecom Ltd. India', '404', 'IN'),
-('40483', 'Reliable Internet Services Ltd. India', '404', 'IN'),
-('40484', 'Hutchinson Essar South Ltd. India', '404', 'IN'),
-('40485', 'Reliance Telecom Private Ltd. India', '404', 'IN'),
-('40486', 'Hutchinson Essar South Ltd. India', '404', 'IN'),
-('40487', 'Escorts Telecom Ltd. India', '404', 'IN'),
-('40488', 'Escorts Telecom Ltd. India', '404', 'IN'),
-('40489', 'Escorts Telecom Ltd. India', '404', 'IN'),
-('40490', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40492', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40493', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40494', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40495', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40496', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40497', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('40498', 'Bharti Cellular Ltd. India', '404', 'IN'),
-('41001', 'Mobilink Pakistan', '410', 'PK'),
-('41003', 'PAK Telecom Mobile Ltd. (UFONE) Pakistan', '410', 'PK'),
-('41201', 'AWCC Afghanistan', '412', 'AF'),
-('41220', 'Roshan Afghanistan', '412', 'AF'),
-('41230', 'New1 Afghanistan', '412', 'AF'),
-('41240', 'Areeba Afghanistan', '412', 'AF'),
-('41288', 'Afghan Telecom', '412', 'AF'),
-('41302', 'MTN Network Ltd. Sri Lanka', '413', 'LK'),
-('41303', 'Celtel Lanka Ltd. Sri Lanka', '413', 'LK'),
-('41401', 'Myanmar Post and Telecommunication', '414', 'MM'),
-('41532', 'Cellis Lebanon', '415', 'LB'),
-('41533', 'Cellis Lebanon', '415', 'LB'),
-('41534', 'Cellis Lebanon', '415', 'LB'),
-('41535', 'Cellis Lebanon', '415', 'LB'),
-('41536', 'Libancell', '415', 'LB'),
-('41537', 'Libancell', '415', 'LB'),
-('41538', 'Libancell', '415', 'LB'),
-('41539', 'Libancell', '415', 'LB'),
-('41601', 'Fastlink Jordan', '416', 'JO'),
-('41602', 'Xpress Jordan', '416', 'JO'),
-('41603', 'Umniah Jordan', '416', 'JO'),
-('41677', 'Mobilecom Jordan', '416', 'JO'),
-('41701', 'Syriatel', '417', 'SY'),
-('41702', 'Spacetel Syria', '417', 'SY'),
-('41709', 'Syrian Telecom', '417', 'SY'),
-('41902', 'Mobile Telecommunications Company Kuwait', '419', 'KW'),
-('41903', 'Wataniya Telecom Kuwait', '419', 'KW'),
-('42001', 'Saudi Telecom', '420', 'SA'),
-('42101', 'Yemen Mobile Phone Company', '421', 'YE'),
-('42102', 'Spacetel Yemen', '421', 'YE'),
-('42202', 'Oman Mobile Telecommunications Company (Oman Mobile)', '422', 'OM'),
-('42203', 'Oman Qatari Telecommunications Company (Nawras)', '422', 'OM'),
-('42204', 'Oman Telecommunications Company (Omantel)', '422', 'OM'),
-('42402', 'Etisalat United Arab Emirates', '424', 'AE'),
-('42501', 'Partner Communications Co. Ltd. Israel', '425', 'IL'),
-('42502', 'Cellcom Israel Ltd.', '425', 'IL'),
-('42503', 'Pelephone Communications Ltd. Israel', '425', 'IL'),
-('42601', 'BHR Mobile Plus Bahrain', '426', 'BH'),
-('42701', 'QATARNET', '427', 'QA'),
-('42899', 'Mobicom Mongolia', '428', 'MN'),
-('42901', 'Nepal Telecommunications', '429', 'NP'),
-('43211', 'Telecommunication Company of Iran (TCI)', '432', 'IR'),
-('43214', 'Telecommunication Kish Co. (KIFZO) Iran', '432', 'IR'),
-('43219', 'Telecommunication Company of Iran (TCI) Isfahan Celcom', '432', 'IR'),
-('43401', 'Buztel Uzbekistan', '434', 'UZ'),
-('43402', 'Uzmacom Uzbekistan', '434', 'UZ'),
-('43404', 'Daewoo Unitel Uzbekistan', '434', 'UZ'),
-('43405', 'Coscom Uzbekistan', '434', 'UZ'),
-('43407', 'Uzdunrobita Uzbekistan', '434', 'UZ'),
-('43601', 'JC Somoncom Tajikistan', '436', 'TJ'),
-('43602', 'CJSC Indigo Tajikistan', '436', 'TJ'),
-('43603', 'TT mobile Tajikistan', '436', 'TJ'),
-('43604', 'Josa Babilon-T Tajikistan', '436', 'TJ'),
-('43605', 'CTJTHSC Tajik-tel', '436', 'TJ'),
-('43701', 'Bitel GSM Kyrgyzstan', '437', 'KG'),
-('43801', 'Barash Communication Technologies (BCTI) Turkmenistan', '438', 'TM'),
-('43802', 'TM-Cell Turkmenistan', '438', 'TM'),
-('44001', 'NTT DoCoMo, Inc. Japan', '440', 'JP'),
-('44002', 'NTT DoCoMo Kansai, Inc.  Japan', '440', 'JP'),
-('44003', 'NTT DoCoMo Hokuriku, Inc. Japan', '440', 'JP'),
-('44004', 'Vodafone Japan', '440', 'JP'),
-('44006', 'Vodafone Japan', '440', 'JP');
-</code>
-)修改表 **umsinstall_dim_devicesupplier**
-**sql语句：**
-<code>
-('44007', 'KDDI Corporation Japan', '440', 'JP'),
-('44008', 'KDDI Corporation Japan', '440', 'JP'),
-('44009', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44010', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44011', 'NTT DoCoMo Tokai Inc. Japan', '440', 'JP'),
-('44012', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44013', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44014', 'NTT DoCoMo Tohoku Inc. Japan', '440', 'JP'),
-('44015', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44016', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44017', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44018', 'NTT DoCoMo Tokai Inc. Japan', '440', 'JP'),
-('44019', 'NTT DoCoMo Hokkaido Japan', '440', 'JP'),
-('44020', 'NTT DoCoMo Hokuriku Inc. Japan', '440', 'JP'),
-('44021', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44022', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44023', 'NTT DoCoMo Tokai Inc. Japan', '440', 'JP'),
-('44024', 'NTT DoCoMo Chugoku Inc. Japan', '440', 'JP'),
-('44025', 'NTT DoCoMo Hokkaido Inc. Japan', '440', 'JP'),
-('44026', 'NTT DoCoMo Kyushu Inc. Japan', '440', 'JP'),
-('44027', 'NTT DoCoMo Tohoku Inc. Japan', '440', 'JP'),
-('44028', 'NTT DoCoMo Shikoku Inc. Japan', '440', 'JP'),
-('44029', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44030', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44031', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44032', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44033', 'NTT DoCoMo Tokai Inc. Japan', '440', 'JP'),
-('44034', 'NTT DoCoMo Kyushu Inc. Japan', '440', 'JP'),
-('44035', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44036', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44037', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44038', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44039', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44040', 'Vodafone Japan', '440', 'JP'),
-('44041', 'Vodafone Japan', '440', 'JP'),
-('44042', 'Vodafone Japan', '440', 'JP'),
-('44043', 'Vodafone Japan', '440', 'JP'),
-('44044', 'Vodafone Japan', '440', 'JP'),
-('44045', 'Vodafone Japan', '440', 'JP'),
-('44046', 'Vodafone Japan', '440', 'JP'),
-('44047', 'Vodafone Japan', '440', 'JP'),
-('44048', 'Vodafone Japan', '440', 'JP'),
-('44049', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44050', 'KDDI Corporation Japan', '440', 'JP'),
-('44051', 'KDDI Corporation Japan', '440', 'JP'),
-('44052', 'KDDI Corporation Japan', '440', 'JP'),
-('44053', 'KDDI Corporation Japan', '440', 'JP'),
-('44054', 'KDDI Corporation Japan', '440', 'JP'),
-('44055', 'KDDI Corporation Japan', '440', 'JP'),
-('44056', 'KDDI Corporation Japan', '440', 'JP'),
-('44058', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44060', 'NTT DoCoMo Kansai Inc. Japan', '440', 'JP'),
-('44061', 'NTT DoCoMo Chugoku Inc. Japan', '440', 'JP'),
-('44062', 'NTT DoCoMo Kyushu Inc. Japan', '440', 'JP'),
-('44063', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44064', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44065', 'NTT DoCoMo Shikoku Inc. Japan', '440', 'JP'),
-('44066', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44067', 'NTT DoCoMo Tohoku Inc. Japan', '440', 'JP'),
-('44068', 'NTT DoCoMo Kyushu Inc. Japan', '440', 'JP'),
-('44069', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44070', 'KDDI Corporation Japan', '440', 'JP'),
-('44071', 'KDDI Corporation Japan', '440', 'JP'),
-('44072', 'KDDI Corporation Japan', '440', 'JP'),
-('44073', 'KDDI Corporation Japan', '440', 'JP'),
-('44074', 'KDDI Corporation Japan', '440', 'JP'),
-('44075', 'KDDI Corporation Japan', '440', 'JP'),
-('44076', 'KDDI Corporation Japan', '440', 'JP'),
-('44077', 'KDDI Corporation Japan', '440', 'JP'),
-('44078', 'Okinawa Cellular Telephone Japan', '440', 'JP'),
-('44079', 'KDDI Corporation Japan', '440', 'JP'),
-('44080', 'TU-KA Cellular Tokyo Inc. Japan', '440', 'JP'),
-('44081', 'TU-KA Cellular Tokyo Inc. Japan', '440', 'JP'),
-('44082', 'TU-KA Phone Kansai Inc. Japan', '440', 'JP'),
-('44083', 'TU-KA Cellular Tokai Inc. Japan', '440', 'JP'),
-('44084', 'TU-KA Phone Kansai Inc. Japan', '440', 'JP'),
-('44085', 'TU-KA Cellular Tokai Inc. Japan', '440', 'JP'),
-('44086', 'TU-KA Cellular Tokyo Inc. Japan', '440', 'JP'),
-('44087', 'NTT DoCoMo Chugoku Inc. Japan', '440', 'JP'),
-('44088', 'KDDI Corporation Japan', '440', 'JP'),
-('44089', 'KDDI Corporation Japan', '440', 'JP'),
-('44090', 'Vodafone Japan', '440', 'JP'),
-('44092', 'Vodafone Japan', '440', 'JP'),
-('44093', 'Vodafone Japan', '440', 'JP'),
-('44094', 'Vodafone Japan', '440', 'JP'),
-('44095', 'Vodafone Japan', '440', 'JP'),
-('44096', 'Vodafone Japan', '440', 'JP'),
-('44097', 'Vodafone Japan', '440', 'JP'),
-('44098', 'Vodafone Japan', '440', 'JP'),
-('44099', 'NTT DoCoMo Inc. Japan', '440', 'JP'),
-('44140', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44141', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44142', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44143', 'NTT DoCoMo Kansai Inc. Japan', '441', 'JP'),
-('44144', 'NTT DoCoMo Chugoku Inc. Japan', '441', 'JP'),
-('44145', 'NTT DoCoMo Shikoku Inc. Japan', '441', 'JP'),
-('44150', 'TU-KA Cellular Tokyo Inc. Japan', '441', 'JP'),
-('44151', 'TU-KA Phone Kansai Inc. Japan', '441', 'JP'),
-('44161', 'Vodafone Japan', '441', 'JP'),
-('44162', 'Vodafone Japan', '441', 'JP'),
-('44163', 'Vodafone Japan', '441', 'JP'),
-('44164', 'Vodafone Japan', '441', 'JP'),
-('44165', 'Vodafone Japan', '441', 'JP'),
-('44170', 'KDDI Corporation Japan', '441', 'JP'),
-('44190', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44191', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44192', 'NTT DoCoMo Inc. Japan', '441', 'JP'),
-('44193', 'NTT DoCoMo Hokkaido Inc. Japan', '441', 'JP'),
-('44194', 'NTT DoCoMo Tohoku Inc. Japan', '441', 'JP'),
-('44198', 'NTT DoCoMo Kyushu Inc. Japan', '441', 'JP'),
-('44199', 'NTT DoCoMo Kyushu Inc. Japan', '441', 'JP'),
-('45201', 'Mobifone Vietnam', '452', 'VN'),
-('45202', 'Vinaphone Vietnam', '452', 'VN'),
-('45400', 'CSL', '454', 'HK'),
-('45401', 'MVNO/CITIC Hong Kong', '454', 'HK'),
-('45402', '3G Radio System/HKCSL3G Hong Kong', '454', 'HK'),
-('45403', 'Hutchison 3G', '454', 'HK'),
-('45404', 'GSM900/GSM1800/Hutchison Hong Kong', '454', 'HK'),
-('45405', 'CDMA/Hutchison Hong Kong', '454', 'HK'),
-('45406', 'SMC', '454', 'HK'),
-('45407', 'MVNO/China Unicom International Ltd. Hong Kong', '454', 'HK'),
-('45408', 'MVNO/Trident Hong Kong', '454', 'HK'),
-('45409', 'MVNO/China Motion Telecom (HK) Ltd. Hong Kong', '454', 'HK'),
-('45410', 'GSM1800New World PCS Ltd. Hong Kong', '454', 'HK'),
-('45411', 'MVNO/CHKTL Hong Kong', '454', 'HK'),
-('45412', 'PEOPLES', '454', 'HK'),
-('45415', '3G Radio System/SMT3G Hong Kong', '454', 'HK'),
-('45416', 'GSM1800/Mandarin Communications Ltd. Hong Kong', '454', 'HK'),
-('45418', 'GSM7800/Hong Kong CSL Ltd.', '454', 'HK'),
-('45419', 'Sunday3G', '454', 'HK'),
-('45500', 'Smartone Mobile Communications (Macao) Ltd.', '455', 'MO'),
-('45501', 'CTM GSM Macao', '455', 'MO'),
-('45503', 'Hutchison Telecom Macao', '455', 'MO'),
-('45601', 'Mobitel (Cam GSM) Cambodia', '456', 'KH'),
-('45602', 'Samart (Casacom) Cambodia', '456', 'KH'),
-('45603', 'S Telecom (CDMA) (reserved) Cambodia', '456', 'KH'),
-('45618', 'Camshin (Shinawatra) Cambodia', '456', 'KH'),
-('45701', 'Lao Telecommunications', '457', 'LA'),
-('45702', 'ETL Mobile Lao', '457', 'LA'),
-('45708', 'Millicom Lao', '457', 'LA'),
-('46000', 'China Mobile', '460', 'CN'),
-('46001', 'China Unicom', '460', 'CN'),
-('46002', 'China Mobile', '460', 'CN'),
-('46003', 'China Telecom', '460', 'CN'),
-('46004', 'China Satellite Global Star Network', '460', 'CN'),
-('46601', 'Far EasTone', '466', 'TW'),
-('46606', 'TUNTEX', '466', 'TW'),
-('46668', 'ACeS', '466', 'TW'),
-('46688', 'KGT', '466', 'TW'),
-('46689', 'KGT', '466', 'TW'),
-('46692', 'Chunghwa', '466', 'TW'),
-('46693', 'MobiTai', '466', 'TW'),
-('46697', 'TWN GSM', '466', 'TW'),
-('46699', 'TransAsia', '466', 'TW'),
-('47001', 'GramenPhone Bangladesh', '470', 'BD'),
-('47002', 'Aktel Bangladesh', '470', 'BD'),
-('47003', 'Mobile 2000 Bangladesh', '470', 'BD'),
-('47201', 'DhiMobile Maldives', '472', 'MV'),
-('50200', 'Art900 Malaysia', '502', 'MY'),
-('50212', 'Maxis Malaysia', '502', 'MY'),
-('50213', 'TM Touch Malaysia', '502', 'MY'),
-('50216', 'DiGi', '502', 'MY'),
-('50217', 'TimeCel Malaysia', '502', 'MY'),
-('50219', 'CelCom Malaysia', '502', 'MY'),
-('50501', 'Telstra Corporation Ltd. Australia', '505', 'AU'),
-('50502', 'Optus Mobile Pty. Ltd. Australia', '505', 'AU'),
-('50503', 'Vodafone Network Pty. Ltd. Australia', '505', 'AU'),
-('50504', 'Department of Defence Australia', '505', 'AU'),
-('50505', 'The Ozitel Network Pty. Ltd. Australia', '505', 'AU'),
-('50506', 'Hutchison 3G Australia Pty. Ltd.', '505', 'AU'),
-('50507', 'Vodafone Network Pty. Ltd. Australia', '505', 'AU'),
-('50508', 'One.Tel GSM 1800 Pty. Ltd. Australia', '505', 'AU'),
-('50509', 'Airnet Commercial Australia Ltd.', '505', 'AU'),
-('50511', 'Telstra Corporation Ltd. Australia', '505', 'AU'),
-('50512', 'Hutchison Telecommunications (Australia) Pty. Ltd.', '505', 'AU'),
-('50514', 'AAPT Ltd. Australia', '505', 'AU'),
-('50515', '3GIS Pty Ltd. (Telstra & Hutchison 3G) Australia', '505', 'AU'),
-('50524', 'Advanced Communications Technologies Pty. Ltd. Australia', '505', 'AU'),
-('50571', 'Telstra Corporation Ltd. Australia', '505', 'AU'),
-('50572', 'Telstra Corporation Ltd. Australia', '505', 'AU'),
-('50588', 'Localstar Holding Pty. Ltd. Australia', '505', 'AU'),
-('50590', 'Optus Ltd. Australia', '505', 'AU'),
-('50599', 'One.Tel GSM 1800 Pty. Ltd. Australia', '505', 'AU'),
-('51000', 'PSN Indonesia', '510', 'ID'),
-('51001', 'Satelindo Indonesia', '510', 'ID'),
-('51008', 'Natrindo (Lippo Telecom) Indonesia', '510', 'ID'),
-('51010', 'Telkomsel Indonesia', '510', 'ID'),
-('51011', 'Excelcomindo Indonesia', '510', 'ID'),
-('51021', 'Indosat - M3 Indonesia', '510', 'ID'),
-('51028', 'Komselindo Indonesia', '510', 'ID'),
-('51501', 'Islacom Philippines', '515', 'PH'),
-('51502', 'Globe Telecom Philippines', '515', 'PH'),
-('51503', 'Smart Communications Philippines', '515', 'PH'),
-('51505', 'Digitel Philippines', '515', 'PH'),
-('52000', 'CAT CDMA Thailand', '520', 'TH'),
-('52001', 'AIS GSM Thailand', '520', 'TH'),
-('52015', 'ACT Mobile Thailand', '520', 'TH'),
-('52501', 'SingTel ST GSM900 Singapore', '525', 'SG'),
-('52502', 'SingTel ST GSM1800 Singapore', '525', 'SG'),
-('52503', 'MobileOne Singapore', '525', 'SG'),
-('52505', 'STARHUB-SGP', '525', 'SG'),
-('52512', 'Digital Trunked Radio Network Singapore', '525', 'SG'),
-('52811', 'DST Com Brunei ', '528', 'BN'),
-('53000', 'Reserved for AMPS MIN based IMSIs New Zealand', '530', 'NZ'),
-('53001', 'Vodafone New Zealand GSM Mobile Network', '530', 'NZ'),
-('53002', 'Teleom New Zealand CDMA Mobile Network', '530', 'NZ'),
-('53003', 'Walker Wireless Ltd. New Zealand', '530', 'NZ'),
-('53028', 'Econet Wireless New Zealand GSM Mobile Network', '530', 'NZ'),
-('53701', 'Pacific Mobile Communications Papua New Guinea', '537', 'PG'),
-('53702', 'Dawamiba PNG Ltd Papua New Guinea', '537', 'PG'),
-('53703', 'Digicel Ltd Papua New Guinea', '537', 'PG'),
-('53901', 'Tonga Communications Corporation', '539', 'TO'),
-('53943', 'Shoreline Communication Tonga', '539', 'TO'),
-('54101', 'SMILE Vanuatu', '541', 'VU'),
-('54201', 'Vodafone Fiji', '542', 'FJ'),
-('54411', 'Blue Sky', '544', 'AS'),
-('54601', 'OPT Mobilis New Caledonia', '546', 'NC'),
-('54720', 'Tikiphone French Polynesia', '547', 'PF'),
-('54801', 'Telecom Cook', '548', 'CK'),
-('54901', 'Telecom Samoa Cellular Ltd.', '549', 'WS'),
-('54927', 'GoMobile SamoaTel Ltd', '549', 'WS'),
-('55001', 'FSM Telecom Micronesia', '550', 'FM'),
-('55201', 'Palau National Communications Corp. (a.k.a. PNCC)', '552', 'PW'),
-('60201', 'EMS - Mobinil Egypt', '602', 'EG'),
-('60202', 'Vodafone Egypt', '602', 'EG'),
-('60301', 'Algrie Telecom', '603', 'DZ'),
-('60302', 'Orascom Telecom Algrie', '603', 'DZ'),
-('60400', 'Meditelecom (GSM) Morocco', '604', 'MA'),
-('60401', 'Ittissalat Al Maghrid Morocco', '604', 'MA'),
-('60502', 'Tunisie Telecom', '605', 'TN'),
-('60503', 'Orascom Telecom Tunisia', '605', 'TN'),
-('60701', 'Gamcel Gambia', '607', 'GM'),
-('60702', 'Africell Gambia', '607', 'GM'),
-('60703', 'Comium Services Ltd Gambia', '607', 'GM'),
-('60801', 'Sonatel Senegal', '608', 'SN'),
-('60802', 'Sentel GSM Senegal', '608', 'SN'),
-('60901', 'Mattel S.A.', '609', 'MR'),
-('60902', 'Chinguitel S.A. ', '609', 'MR'),
-('60910', 'Mauritel Mobiles  ', '609', 'MR'),
-('61001', 'Malitel', '610', 'ML'),
-('61101', 'Spacetel Guinea', '611', 'GN'),
-('61102', 'Sotelgui Guinea', '611', 'GN'),
-('61202', 'Atlantique Cellulaire Cote d Ivoire', '612', 'CI'),
-('61203', 'Orange Cote dIvoire', '612', 'CI'),
-('61204', 'Comium Cote d Ivoire', '612', 'CI'),
-('61205', 'Loteny Telecom Cote d Ivoire', '612', 'CI'),
-('61206', 'Oricel Cote d Ivoire', '612', 'CI'),
-('61207', 'Aircomm Cote d Ivoire', '612', 'CI'),
-('61302', 'Celtel Burkina Faso', '613', 'BF'),
-('61303', 'Telecel Burkina Faso', '613', 'BF'),
-('61401', 'Sahel.Com Niger', '614', 'NE'),
-('61402', 'Celtel Niger', '614', 'NE'),
-('61403', 'Telecel Niger', '614', 'NE'),
-('61501', 'Togo Telecom', '615', 'TG'),
-('61601', 'Libercom Benin', '616', 'BJ'),
-('61602', 'Telecel Benin', '616', 'BJ'),
-('61603', 'Spacetel Benin', '616', 'BJ'),
-('61701', 'Cellplus Mauritius', '617', 'MU'),
-('61702', 'Mahanagar Telephone (Mauritius) Ltd.', '617', 'MU'),
-('61710', 'Emtel Mauritius', '617', 'MU'),
-('61804', 'Comium Liberia', '618', 'LR'),
-('61901', 'Celtel Sierra Leone', '619', 'SL'),
-('61902', 'Millicom Sierra Leone', '619', 'SL'),
-('61903', 'Africell Sierra Leone', '619', 'SL'),
-('61904', 'Comium (Sierra Leone) Ltd.', '619', 'SL'),
-('61905', 'Lintel (Sierra Leone) Ltd.', '619', 'SL'),
-('61925', 'Mobitel Sierra Leone', '619', 'SL'),
-('61940', 'Datatel (SL) Ltd GSM Sierra Leone', '619', 'SL'),
-('61950', 'Dtatel (SL) Ltd CDMA Sierra Leone', '619', 'SL'),
-('62001', 'Spacefon Ghana', '620', 'GH'),
-('62002', 'Ghana Telecom Mobile', '620', 'GH'),
-('62003', 'Mobitel Ghana', '620', 'GH'),
-('62004', 'Kasapa Telecom Ltd. Ghana', '620', 'GH'),
-('62120', 'Econet Wireless Nigeria Ltd.', '621', 'NG'),
-('62130', 'MTN Nigeria Communications', '621', 'NG'),
-('62140', 'Nigeria Telecommunications Ltd.', '621', 'NG'),
-('62201', 'Celtel Chad', '622', 'TD'),
-('62202', 'Tchad Mobile', '622', 'TD'),
-('62301', 'Centrafrique Telecom Plus (CTP)', '623', 'CF'),
-('62302', 'Telecel Centrafrique (TC)', '623', 'CF'),
-('62303', 'Celca (Socatel) Central African Rep.', '623', 'CF'),
-('62401', 'Mobile Telephone Networks Cameroon', '624', 'CM'),
-('62402', 'Orange Cameroun', '624', 'CM'),
-('62501', 'Cabo Verde Telecom', '625', 'CV'),
-('62601', 'Companhia Santomese de Telecomunicacoes', '626', 'ST'),
-('62701', 'Guinea Ecuatorial de Telecomunicaciones Sociedad Anonima', '627', 'GQ'),
-('62801', 'Libertis S.A. Gabon', '628', 'GA'),
-('62802', 'Telecel Gabon S.A.', '628', 'GA'),
-('62803', 'Celtel Gabon S.A.', '628', 'GA'),
-('62901', 'Celtel Congo', '629', 'CG'),
-('62910', 'Libertis Telecom Congo', '629', 'CG'),
-('63001', 'Vodacom Congo RDC sprl', '630', 'CD'),
-('63005', 'Supercell Sprl Congo', '630', 'CD'),
-('63086', 'Congo-Chine Telecom s.a.r.l.', '630', 'CD'),
-('63102', 'Unitel Angola', '631', 'AO'),
-('63201', 'Guinetel S.A. Guinea-Bissau', '632', 'GW'),
-('63202', 'Spacetel Guine-Bissau S.A.', '632', 'GW'),
-('63301', 'Cable & Wireless (Seychelles) Ltd.', '633', 'SC'),
-('63302', 'Mediatech International Ltd. Seychelles', '633', 'SC'),
-('63310', 'Telecom (Seychelles) Ltd.', '633', 'SC'),
-('63401', 'SD Mobitel Sudan', '634', 'MZ'),
-('63402', 'Areeba-Sudan', '634', 'MZ'),
-('63510', 'MTN Rwandacell', '635', 'RW'),
-('63601', 'ETH MTN Ethiopia', '636', 'ET'),
-('63730', 'Golis Telecommunications Company Somalia', '637', 'SO'),
-('63801', 'Evatis Djibouti', '638', 'DJ'),
-('63902', 'Safaricom Ltd. Kenya', '639', 'KE'),
-('63903', 'Kencell Communications Ltd. Kenya', '639', 'KE'),
-('64002', 'MIC (T) Ltd. Tanzania', '640', 'TZ'),
-('64003', 'Zantel Tanzania', '640', 'TZ'),
-('64004', 'Vodacom (T) Ltd. Tanzania', '640', 'TZ'),
-('64005', 'Celtel (T) Ltd. Tanzania', '640', 'TZ'),
-('64101', 'Celtel Uganda', '641', 'UG'),
-('64110', 'MTN Uganda Ltd.', '641', 'UG'),
-('64111', 'Uganda Telecom Ltd.', '641', 'UG'),
-('64201', 'Spacetel Burundi', '642', 'BI'),
-('64202', 'Safaris Burundi', '642', 'BI'),
-('64203', 'Telecel Burundi Company', '642', 'BI'),
-('64301', 'T.D.M. GSM Mozambique', '643', 'MZ'),
-('64304', 'VM Sarl Mozambique', '643', 'MZ'),
-('64501', 'Celtel Zambia Ltd.', '645', 'ZM'),
-('64502', 'Telecel Zambia Ltd.', '645', 'ZM'),
-('64503', 'Zamtel Zambia', '645', 'ZM'),
-('64601', 'MADACOM Madagascar', '646', 'MG'),
-('64602', 'Orange Madagascar', '646', 'MG'),
-('64604', 'Telecom Malagasy Mobile Madagascar', '646', 'MG'),
-('64700', 'Orange La Reunion', '647', 'RE'),
-('64702', 'Outremer Telecom', '647', 'RE'),
-('64710', 'Societe Reunionnaise du Radiotelephone', '647', 'RE'),
-('64801', 'Net One Zimbabwe', '648', 'ZW'),
-('64803', 'Telecel Zimbabwe', '648', 'ZW'),
-('64804', 'Econet Zimbabwe', '648', 'ZW'),
-('64901', 'Mobile Telecommunications Ltd. Namibia', '649', 'NA'),
-('64903', 'Powercom Pty Ltd Namibia', '649', 'NA'),
-('65001', 'Telekom Network Ltd. Malawi', '650', 'MW'),
-('65010', 'Celtel ltd. Malawi', '650', 'MW'),
-('65101', 'Vodacom Lesotho (pty) Ltd.', '651', 'LS'),
-('65102', 'Econet Ezin-cel Lesotho', '651', 'LS'),
-('65201', 'Mascom Wireless (Pty) Ltd. Botswana', '652', 'BW'),
-('65202', 'Orange Botswana (Pty) Ltd.', '652', 'BW'),
-('65310', 'Swazi MTN', '653', 'SZ'),
-('65401', 'HURI - SNPT Comoros', '654', 'KM'),
-('65501', 'Vodacom (Pty) Ltd. South Africa', '655', 'ZA'),
-('65506', 'Sentech (Pty) Ltd. South Africa', '655', 'ZA'),
-('65507', 'Cell C (Pty) Ltd. South Africa', '655', 'ZA'),
-('65510', 'Mobile Telephone Networks South Africa', '655', 'ZA'),
-('65511', 'SAPS Gauteng South Africa', '655', 'ZA'),
-('65521', 'Cape Town Metropolitan Council South Africa', '655', 'ZA'),
-('65530', 'Bokamoso Consortium South Africa', '655', 'ZA'),
-('65531', 'Karabo Telecoms (Pty) Ltd. South Africa', '655', 'ZA'),
-('65532', 'Ilizwi Telecommunications South Africa', '655', 'ZA'),
-('65533', 'Thinta Thinta Telecommunications South Africa', '655', 'ZA'),
-('65534', 'Bokone Telecoms South Africa', '655', 'ZA'),
-('65535', 'Kingdom Communications South Africa', '655', 'ZA'),
-('65536', 'Amatole Telecommunication Services South Africa', '655', 'ZA'),
-('70267', 'Belize Telecommunications Ltd., GSM 1900', '702', 'BZ'),
-('70268', 'International Telecommunications Ltd. (INTELCO) Belize', '702', 'BZ'),
-('70401', 'Servicios de Comunicaciones Personales Inalambricas, S.A. Guatemala', '704', 'GT'),
-('70402', 'Comunicaciones Celulares S.A. Guatemala', '704', 'GT'),
-('70403', 'Telefonica Centroamerica Guatemala S.A.', '704', 'GT'),
-('70601', 'CTE Telecom Personal, S.A. de C.V. El Salvador', '706', 'SV'),
-('70602', 'Digicel, S.A. de C.V. El Salvador', '706', 'SV'),
-('70603', 'Telemovil El Salvador, S.A.', '706', 'SV'),
-('708001', 'Megatel Honduras', '708', 'HN'),
-('708002', 'Celtel Honduras', '708', 'HN'),
-('708040', 'Digicel Honduras', '708', 'HN'),
-('71021', 'Empresa Nicaraguense de Telecomunicaciones, S.A. (ENITEL)', '710', 'NI'),
-('71073', 'Servicios de Comunicaciones, S.A. (SERCOM) Nicaragua', '710', 'NI'),
-('71201', 'Instituto Costarricense de Electricidad - ICE', '712', 'CR'),
-('71401', 'Cable & Wireless Panama S.A.', '714', 'PA'),
-('71402', 'BSC de Panama S.A.', '714', 'PA'),
-('71610', 'TIM Peru', '716', 'PE'),
-('722010', 'Compaia de Radiocomunicaciones Moviles S.A. Argentina', '722', 'AR'),
-('722020', 'Nextel Argentina srl', '722', 'AR'),
-('722070', 'Telefonica Comunicaciones Personales S.A. Argentina', '722', 'AR'),
-('722310', 'CTI PCS S.A. Argentina', '722', 'AR'),
-('722320', 'Compaia de Telefonos del Interior Norte S.A. Argentina', '722', 'AR'),
-('722330', 'Compaia de Telefonos del Interior S.A. Argentina', '722', 'AR'),
-('722341', 'Telecom Personal S.A. Argentina', '722', 'AR'),
-('72400', 'Telet Brazil', '724', 'BR'),
-('72401', 'CRT Cellular Brazil', '724', 'BR'),
-('72402', 'Global Telecom Brazil', '724', 'BR'),
-('72403', 'CTMR Cel Brazil', '724', 'BR'),
-('72404', 'BCP Brazil', '724', 'BR'),
-('72405', 'Telesc Cel Brazil', '724', 'BR'),
-('72406', 'Tess Brazil', '724', 'BR'),
-('72407', 'Sercontel Cel Brazil', '724', 'BR'),
-('72408', 'Maxitel MG Brazil', '724', 'BR'),
-('72409', 'Telepar Cel Brazil', '724', 'BR'),
-('72410', 'ATL Algar Brazil', '724', 'BR'),
-('72411', 'Telems Cel Brazil', '724', 'BR'),
-('72412', 'Americel Brazil', '724', 'BR'),
-('72413', 'Telesp Cel Brazil', '724', 'BR'),
-('72414', 'Maxitel BA Brazil', '724', 'BR'),
-('72415', 'CTBC Cel Brazil', '724', 'BR'),
-('72416', 'BSE Brazil', '724', 'BR'),
-('72417', 'Ceterp Cel Brazil', '724', 'BR');
-</code>
-====== 3、修改存储过程 ======
-修改存储过程 **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** 和 **runweekly** 。
-步骤：
-步骤一:下载新的v0.7版本的代码，目录assets\sql下的存储过程有 sp_rundaily.sql 、 sp_rundim.sql 、 sp_runfact.sql 、 sp_runmonthly.sql 、 sp_runsum.sql和 sp_runweekly.sql 。
-步骤二：修改表前缀名,将各个存储过程中的umsinstall_修改为你数据仓库中的表前缀名,如你的数据仓库中的表前缀为”razordw_”；另外将其中的“databaseprefix.umsdatainstall_”换成“数据库名称.基础数据库前缀”，如你的数据库名称为cobubrazor，数据库表前缀为razor_,则修改为“cobubrazor.razor_”。
-步骤三: 暂停数据库的数据插入和及数据仓库中的抽数过程。
-暂时停止前请先准备好相关的SQL脚本（即步骤二中生成的相关脚本）。
-步骤四: 删除数据仓库中所有存储过程。
-步骤五: 执行步骤二中生成的相关sql脚本。
-执行相关脚本前，请先备份一下数据库和数据仓库中的数据。
-步骤六:重新启动数据库和数据仓库。
-重启数据库和数据仓库前，请先将步骤一中的第2步中以前版本的“web”目录备份，命名为web-backup0.6,存储在合适的地方，删除“web”。然后将“razor_v6”修改成“web”(以前的版本的名称)，并修改config.php文件的$config['base_url']= ‘http://192.168.1.103/web’。

Cobub文档中心

用户工具

站点工具

差别

页面工具