mirror of
https://github.com/mbirth/tcl_update_db.git
synced 2024-09-19 16:53:25 +01:00
414 lines
26 KiB
SQL
414 lines
26 KiB
SQL
PRAGMA journal_mode=WAL;
|
|
PRAGMA foreign_keys=on;
|
|
|
|
BEGIN TRANSACTION;
|
|
|
|
INSERT OR IGNORE INTO "families" VALUES (1, "KEYone");
|
|
INSERT OR IGNORE INTO "families" VALUES (2, "Motion");
|
|
INSERT OR IGNORE INTO "families" VALUES (3, "DTEK");
|
|
INSERT OR IGNORE INTO "families" VALUES (4, "KEYtwo");
|
|
|
|
INSERT OR IGNORE INTO "models" VALUES ( 1, 1, "BBB100-1");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 2, 1, "BBB100-2");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 3, 1, "BBB100-3");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 4, 1, "BBB100-4");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 5, 1, "BBB100-5");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 6, 1, "BBB100-6");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 7, 1, "BBB100-7");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 8, 2, "BBD100-1");
|
|
INSERT OR IGNORE INTO "models" VALUES ( 9, 2, "BBD100-2");
|
|
INSERT OR IGNORE INTO "models" VALUES (10, 2, "BBD100-6");
|
|
INSERT OR IGNORE INTO "models" VALUES (11, 3, "50 STH100-1");
|
|
INSERT OR IGNORE INTO "models" VALUES (12, 3, "50 STH100-2");
|
|
INSERT OR IGNORE INTO "models" VALUES (13, 3, "60 BBA100-1");
|
|
INSERT OR IGNORE INTO "models" VALUES (14, 3, "60 BBA100-2");
|
|
INSERT OR IGNORE INTO "models" VALUES (15, 4, "BBF100-1");
|
|
INSERT OR IGNORE INTO "models" VALUES (16, 4, "BBF100-2");
|
|
INSERT OR IGNORE INTO "models" VALUES (17, 4, "BBF100-4");
|
|
INSERT OR IGNORE INTO "models" VALUES (18, 4, "BBF100-6");
|
|
INSERT OR IGNORE INTO "models" VALUES (19, 4, "BBF100-8");
|
|
INSERT OR IGNORE INTO "models" VALUES (20, 4, "BBF100-9");
|
|
INSERT OR IGNORE INTO "models" VALUES (21, 4, "LE BBE100-1 (EMEA/APAC-1S)");
|
|
INSERT OR IGNORE INTO "models" VALUES (22, 4, "LE BBE100-2 (NA/CA/LatAm)");
|
|
INSERT OR IGNORE INTO "models" VALUES (23, 4, "LE BBE100-4 (EMEA/APAC-2S)");
|
|
INSERT OR IGNORE INTO "models" VALUES (24, 4, "LE BBE100-5 (US OM-2S)");
|
|
|
|
-- DTEK
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-002", 11, "Retail NA");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-003", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-004", 11, "Retail NA SWAP");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-005", 11, "Rogers");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-006", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-007", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-008", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-009", 11, "Telus");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-010", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-011", 11, "Wind");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-012", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62980-701", 11, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-001", 12, "Hong-Kong");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-002", 12, "Africa");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-003", 12, "EU [AZERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-004", 12, "EU [QWERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-005", 12, "UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-006", 12, "Mediteranean");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-007", 12, "Middle East [UK plug]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-008", 12, "EU [QWERTZ]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-009", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-010", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-011", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-012", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-013", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-014", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-015", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-016", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-018", 12, "Eastern Europe");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-019", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-020", 12, "Vodafone UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-021", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-022", 12, "O2 UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-023", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-024", 12, "T-Mobile DE/AT [QWERTZ]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-026", 12, "Orange FR [AZERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-028", 12, "SFR [AZERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-030", 12, "TIM IT");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-031", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-032", 12, "WIND IT");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-044", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-045", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-046", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-047", 12, "South Pacific and Caribbean");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-048", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-049", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-050", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-053", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-054", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-055", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-056", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-060", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-061", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("62981-701", 12, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63036-001", 13, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63036-002", 13, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63036-700", 13, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-003", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-004", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-015", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-016", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-017", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-018", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-019", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-020", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-021", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-022", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-024", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-025", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-026", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-027", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-028", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-029", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-030", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-031", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-032", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-033", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-034", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-035", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-038", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-039", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-052", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-053", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-054", 14, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("63040-700", 14, NULL);
|
|
|
|
-- KEYone
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-001", 1, "Unlocked USA");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-003", 1, "Bell");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-005", 1, "Rogers");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-007", 1, "Telus");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-009", 1, "Hong Kong");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-010", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-013", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-017", 1, "Caribbean");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-020", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-021", 1, "Hong Kong?");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-023", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-024", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-026", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-027", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-029", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-033", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-036", 1, "AT&T");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-039", 1, "Black KEYone Canada");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-040", 1, "Black KEYone Malaysia");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-041", 1, "Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-042", 1, "Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-043", 1, "Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-044", 1, "Black KEYone Hong Kong");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-047", 1, "Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-050", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-051", 1, "Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-055", 1, "Black KEYone Korea");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-056", 1, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63116-700", 1, "Prerelease");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-003", 2, "Unlocked UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-011", 2, "Unlocked EMEA");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-015", 2, "NL, Belgium");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-017", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-019", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-021", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-023", 2, "AZERTY Belgium");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-025", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-027", 2, "QWERTY UAE");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-028", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-029", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-030", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-031", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-034", 2, "UAE?");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-035", 2, "Black KEYone UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-036", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-037", 2, "Black KEYone Middle East");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-039", 2, "Black KEYone Europe");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-040", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-041", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-042", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-043", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-044", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-045", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-046", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-047", 2, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-703", 2, "Prerelease");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-704", 2, "Prerelease");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63117-717", 2, "Prerelease Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63118-001", 3, "Unlocked");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63118-003", 3, "Sprint");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63734-001", 4, "Unlocked -4");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63734-002", 4, "Unlocked -4");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63734-003", 4, "Unlocked -5");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63734-004", 4, "Unlocked -5");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-002", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-004", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-005", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-006", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-007", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-008", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-009", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-010", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-011", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-012", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-014", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-015", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-016", 5, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63736-017", 5, NULL);
|
|
|
|
-- MOTION
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-001", 8, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-003", 8, "UK");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-007", 8, "Europe");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-009", 8, "Europe");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-010", 8, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63737-015", 8, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63739-009", 9, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63739-010", 9, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63739-017", 9, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-001", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-002", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-003", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-008", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-011", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-014", 10, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63753-017", 10, NULL);
|
|
|
|
-- KEYone (cont'd)
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63763-001", 6, "Unlocked");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63763-002", 6, "Unlocked Black KEYone");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63764-001", 7, "Unlocked");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63764-002", 7, "Unlocked Black KEYone Indonesia");
|
|
|
|
-- KEYtwo
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824001", 15, "UK QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824003", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824005", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824007", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824009", 15, "EU QWERTZ");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824011", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824013", 15, "EU QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824015", 15, "Mediterraean");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824017", 15, "TIM Italy?");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824019", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824021", 15, "EU AZERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824023", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824025", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824027", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824029", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824031", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824035", 15, "UK QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824036", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824037", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824038", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824039", 15, "EU QWERTZ");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824040", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824041", 15, "EU QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824042", 15, "Mediterranean");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824043", 15, "TIM Italy?");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824044", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824045", 15, "EU AZERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824046", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824047", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824048", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824049", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824050", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824052", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824053", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824054", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824055", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824056", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824057", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824058", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824059", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824060", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63824061", 15, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63824-801", 15, "Prerelease");
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825001", 16, "Unlocked");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825002", 16, "Unlocked USA");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825003", 16, "Unlocked USA");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825004", 16, "Bell");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825005", 16, "Rogers");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825006", 16, "Telus");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825007", 16, "Unlocked NA/LatAm");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825008", 16, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825009", 16, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825010", 16, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825012", 16, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63825014", 16, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("PRD-63825-801", 16, "Prerelease");
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63827001", 17, "China");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63827002", 17, "China");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63827003", 17, "China");
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828001", 18, "EMEA/APAC");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828002", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828003", 18, "EMEA/APAC QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828004", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828005", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828006", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828007", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828008", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828009", 18, "EU [QWERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828010", 18, "EMEA/APAC");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828011", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828012", 18, "EMEA/APAC QWERTY");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828013", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828015", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828016", 18, "EU [AZERTY]");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828017", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828018", 18, "Hong Kong");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828019", 18, "Hong Kong");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828020", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828021", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828022", 18, "Malaysia");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828023", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828024", 18, "APAC");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828025", 18, "APAC");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828026", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828027", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828028", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828029", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828030", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828031", 18, "India");
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828032", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828033", 18, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63828034", 18, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63830001", 19, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD63831001", 20, NULL);
|
|
|
|
-- KEYtwo LE
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001001", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001002", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001005", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001007", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001008", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001009", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001011", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001012", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001020", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001021", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001031", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001032", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001035", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001037", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001041", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001042", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001050", 21, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65001052", 21, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002001", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002002", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002003", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002004", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002005", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002006", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002007", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65002008", 22, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004001", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004002", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004003", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004004", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004005", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004021", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004022", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004023", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004024", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004025", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004032", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004033", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004034", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004035", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004036", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004040", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004041", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004042", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004043", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004044", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004045", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004046", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004047", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004049", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004050", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004051", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004052", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004056", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004057", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004058", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004060", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004061", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004062", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004063", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004064", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004065", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004066", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004067", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004068", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004069", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004070", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004071", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004072", 23, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65004076", 23, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65005001", 24, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65005002", 24, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65005003", 24, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65005004", 24, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65012001", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65012002", 22, NULL);
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65012003", 22, NULL);
|
|
|
|
INSERT OR IGNORE INTO "devices" VALUES ("APBI-PRD65014001", 23, NULL);
|
|
|
|
COMMIT;
|