Cobub文档中心

用户工具

站点工具

侧边栏

文档首页

Cobub Razor

Cobub Toaster

其它链接

这是本文档旧的修订版！

目录

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'

1、修改数据仓库

1.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语句： 

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

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’。

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

页面工具

© Copyright 2012 - 2015 南京西桥科技有限公司 Western Bridge Tech Co., Ltd.
苏ICP备13039116号-1