用户工具

站点工具


该文档适用于Cobub Razor 0.7版本。

V6-v7升级手册

Cobub Razor从版本0.6升级到版本0.7,具体需要如下步骤:

步骤一: 下载V0.7版本最新代码

1、从 https://github.com/cobub/razor 下载0.7版本的代码,得到razor-0.7.zip压缩包,将其解压得到razor-0.7文件夹,里面包含sdk和web文件夹等。

2、将上面的 web 文件夹复制你准备升级部署网站的web目录下(注意复制前 web 名称不能与前几个版本的名称相同)。为了方便调试,你可以将”web”修改成”razor_v7″,并将里面的application文件夹下的config.php文件中的$config['base_url']= ‘http://yoururl/razor_v7′。

3、将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、增加表

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_,下同):

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;

1.2、删除表

1)删除表 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_,下同):

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;

1.3、修改表

1)修改表 umsinstall_clientdata

属性名称 属性值 变化
country varchar(50) DEFAULT NULL → DEFAULT 'unknown'
region varchar(50) DEFAULT NULL → DEFAULT 'unknown'
city varchar(50) DEFAULT NULL → DEFAULT 'unknown'

sql语句:

UPDATE `razor_umsinstall_clientdata` SET `country`='unknown',`region`='unknown',`city`='unknown'

2)修改表 umsinstall_product_category sql语句:

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);

3)修改表 umsinstall_user_resources sql语句:

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);

2、修改数据仓库

2.1、修改表

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语句:

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`);

2)修改表 umsinstall_dim_devicesupplier sql语句:

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');

3)修改表 umsinstall_dim_devicesupplier sql语句:

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');

4)修改表 umsinstall_dim_devicesupplier sql语句:

('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');

3、修改存储过程

修改存储过程 rundailyrundimrunfactrunmonthlyrunsumrunweekly

步骤: 步骤一:下载新的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://yoururl/web’。

razor/upgrade-instruction-v0-6-to-v0-7.txt · 最后更改: 2017/07/14 11:18 (外部编辑)