SQL of iOS (iPhone/iPad/iPod) models described

device_models.sql

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `device_models`;
CREATE TABLE `device_models` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` varchar(10) NOT NULL,
  `model_name` varchar(50) NOT NULL,
  `model_variation` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `device_models` (`id`, `model_id`, `model_name`, `model_variation`) VALUES
(1,	'i386',	'Simulator',	''),
(2,	'x86_64',	'Simulator',	''),
(3,	'iPod1,1',	'iPod Touch',	'Original'),
(4,	'iPod2,1',	'iPod Touch',	'Second Generation'),
(5,	'iPod3,1',	'iPod Touch',	'Third Generation'),
(6,	'iPod4,1',	'iPod Touch',	'Fourth Generation'),
(7,	'iPod7,1',	'iPod Touch',	'6th Generation'),
(8,	'iPhone1,1',	'iPhone',	'Original'),
(9,	'iPhone1,2',	'iPhone',	'3G'),
(10,	'iPhone2,1',	'iPhone',	'3GS'),
(11,	'iPad1,1',	'iPad',	'Original'),
(12,	'iPad2,1',	'iPad 2',	''),
(13,	'iPad3,1',	'iPad',	'3rd Generation'),
(14,	'iPhone3,1',	'iPhone 4',	'GSM'),
(15,	'iPhone3,3',	'iPhone 4',	'CDMA/Verizon/Sprint'),
(16,	'iPhone4,1',	'iPhone 4S',	''),
(17,	'iPhone5,1',	'iPhone 5',	'model A1428, AT&T/Canada'),
(18,	'iPhone5,2',	'iPhone 5',	'model A1429, everything else'),
(19,	'iPad3,4',	'iPad',	'4th Generation'),
(20,	'iPad2,5',	'iPad Mini',	'Original'),
(21,	'iPhone5,3',	'iPhone 5c',	'model A1456, A1532 | GSM'),
(22,	'iPhone5,4',	'iPhone 5c',	'model A1507, A1516, A1526 '),
(23,	'iPhone6,1',	'iPhone 5s',	'model A1433, A1533 | GSM'),
(24,	'iPhone6,2',	'iPhone 5s',	'model A1457, A1518, A1528 '),
(25,	'iPhone7,1',	'iPhone 6 Plus',	''),
(26,	'iPhone7,2',	'iPhone 6',	''),
(27,	'iPhone8,1',	'iPhone 6S',	''),
(28,	'iPhone8,2',	'iPhone 6S Plus',	''),
(29,	'iPad4,1',	'iPad Air',	'Wifi'),
(30,	'iPad4,2',	'iPad Air',	'Cellular'),
(31,	'iPad4,4',	'iPad Mini',	'2nd Generation iPad Mini - Wifi'),
(32,	'iPad4,5',	'iPad Mini',	'2nd Generation iPad Mini - Cellular'),
(33,	'iPad4,7',	'iPad Mini',	'3rd Generation iPad Mini - Wifi ');