用户工具

站点工具


这是本文档旧的修订版!


Upgrade Instruction (v0.6 to v0.7)

When you are ready to upgrade Cobub Razor from version 0.6 to version 0.7, following steps is required:

Step one: download the code of V0.7

1、Download the code of version 0.7 from https://github.com/cobub/razor , and you can get the razor-master.zip, unzip it to get razor-master folder, which contains the sdk and web folders.

2、Copy the web folder to the directory of your web site where you are ready to upgrade Cobub Razor (Note: web can not be the same name with Cobub Razor’s name of V0.6 or V0.7 ). To facilitate debugging, you can rename ”web” to “razor_v6“, and set the $ config ['base_url'] value to the ‘http://192.168.1.103/razor_v6 ‘ in config.php which is under the application folder.

3、Copy the autoload.php and database.php of V0.6 under the directory of application\config\ to the diretory of application\config\ of V0.7, override these two files of V0.7, and replace $route['default_controller'] = “install/installation” to $route['default_controller'] = “report/home” of V0.7 in routes.php.

Step two: modify script files of database and data warehouse

Here, assume that your database is razor and data warehouse is razordw, and umsinstall_ is the table prefix of them.

1、Modify database

1.1、Add tables

1) umsinstall_device_tag
property name property value index
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:

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、Delete tables

1) umsinstall_mccmnc
property name property value index
id int(50) NOT NULL UNIQUE
value varchar(50) Not NULL
name varchar(100) default NULL
productkey varchar(64) Not NULL

sql:

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、Modify tables

1) umsinstall_clientdata
property name property value changes
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、Modify the data warehouse

2.1、Modify tables

1) umsinstall_dim_devicesupplier
property name property value changes
devicesupplier_name varchar(60) NOT NULL →NOT NULL DEFAULT 'unknown'
mccmnc varchar(16) NOT NULL Add
countrycode varchar(8) DEFAULT NULL Add
countrycode varchar(128) DEFAULT NULL Add

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
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
('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、Modify the stored procedures

Stored procedures: rundailyrundimrunfactrunmonthlyrunsum and runweekly

Steps:

1)you will get six sql script files under the directory of assets\sql of V0.7 : sp_rundaily.sqlsp_rundim.sqlsp_runfact.sqlsp_runmonthly.sqlsp_runsum.sql and sp_runweekly.sql.

2) modify table prefix

Modify the umsinstall_ in all sql scirpt files above to your own data warehouse’s table prefix, for example,your data warehouse table prefix “razordw_”;

Replace the “databaseprefix.umsdatainstall_” to “database.database’s table prefix”, for example, your database is cobubrazor,and database’s table prefix is razor_,the ”databaseprefix.umsdatainstall_” should be “cobubrazor.razor_“.

Step three: stop inserting data to database and pause the stored procedures.

Note: you need to have prepared all the relevant SQL scripts(i.e. all sql scripts in Step two).

Step four: delete all stored procedures in data warehouse.

Step five: execute the SQL scripts generated in Step two.

Note: Please backup the data of your database and data warehouse before you execute the sql scripts.

Step six:restart the database and data warehouse.

Before this step, you need to do the last thing :

Backup the directory of the previous web site(e.g web,which is the root directory of version 0.6),store it in a suitable place and named web-backup0.6, then delete web.

Change”razor_v6” to “web”(the name of V0.6),and set $config['base_url']= ‘http://192.168.1.103/web’ in config.php.

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