text: CREATE DATABASE  IF NOT EXISTS `dbms_phone1` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `dbms_phone1`;
  -- MySQL dump 10.13  Distrib 5.7.19, for Win64 (x86_64)
  --
  -- Host: localhost    Database: dbms_phone1
  -- ------------------------------------------------------
  -- Server version	5.7.19-log
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `phone`
  --
  
  DROP TABLE IF EXISTS `phone`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `phone` (
    `make` text,
    `model` text,
    `price($)` text,
    `RAM(GB)` text,
    `screen(in)` text,
    `mem(GB)` text,
    `avgRating` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `phone`
  --
  
  LOCK TABLES `phone` WRITE;
  /*!40000 ALTER TABLE `phone` DISABLE KEYS */;
  INSERT INTO `phone` VALUES ('Samsung','Galaxy Note8','960','8','6.3','128',41),('Apple','iphone 8 ','960','2','4.7','256',51),('Sony','Xperia XZ1','600','4','5.2','64',43),('LG','V30','500','4','6','64',46),('HTC','U11','649','6','5.5','63',54),('Motorolla','X4','350','3','5.2','32',47),('Huawie','Mate 10','499','4','5.9','64',58),('Microsoft','Lumia 650','120','1','5','16',37),('Nokia','8x','600','6','5.3','64',57),('OnePlus','oneplus 5','500','8','5.5','64',36),('Blackberry','Motion','650','4','5.5','32',63),('Alcatel','Idol 5s','350','3','5.2','32',51),('ZTE','Nubia Z17s','600','8','5.73','64',49),('Xiaomi','MI Mix2','600','8','5.99','64',53),('Google','Pixel 2','649','4','5','64',50),('Acer','Liquid Z6 Plus','649','3','5.5','32',50),('Oppo','A77 ','350','4','5.5','64',47),('Blu','Grand XL','120','2','5.5','16',47),('Vivo','X20','590','4','6.43','64',49),('Meizu','M6 note','240','4','5.5','16',52);
  /*!40000 ALTER TABLE `phone` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `rating`
  --
  
  DROP TABLE IF EXISTS `rating`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `rating` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `make` text,
    `model` text,
    `username` text,
    `userRating` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=801 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `rating`
  --
  
  LOCK TABLES `rating` WRITE;
  /*!40000 ALTER TABLE `rating` DISABLE KEYS */;
  INSERT INTO `rating` VALUES (1,'Samsung','Galaxy Note8','DustyOregeno',92),(2,'Apple','iphone 8 ','DustyOregeno',40),(3,'Sony','Xperia XZ1','DustyOregeno',27),(4,'LG','V30','DustyOregeno',15),(5,'HTC','U11','DustyOregeno',97),(6,'Motorolla','X4','DustyOregeno',34),(7,'Huawie','Mate 10','DustyOregeno',82),(8,'Microsoft','Lumia 650','DustyOregeno',6),(9,'Nokia','8x','DustyOregeno',86),(10,'OnePlus','oneplus 5','DustyOregeno',9),(11,'Blackberry','Motion','DustyOregeno',91),(12,'Alcatel','Idol 5s','DustyOregeno',26),(13,'ZTE','Nubia Z17s','DustyOregeno',58),(14,'Xiaomi','MI Mix2','DustyOregeno',11),(15,'Google','Pixel 2','DustyOregeno',82),(16,'Acer','Liquid Z6 Plus','DustyOregeno',75),(17,'Oppo','A77 ','DustyOregeno',30),(18,'Blu','Grand XL','DustyOregeno',28),(19,'Vivo','X20','DustyOregeno',48),(20,'Meizu','M6 note','DustyOregeno',55),(21,'Samsung','Galaxy Note8','BuckleKuckle',29),(22,'Apple','iphone 8 ','BuckleKuckle',84),(23,'Sony','Xperia XZ1','BuckleKuckle',29),(24,'LG','V30','BuckleKuckle',95),(25,'HTC','U11','BuckleKuckle',86),(26,'Motorolla','X4','BuckleKuckle',43),(27,'Huawie','Mate 10','BuckleKuckle',60),(28,'Microsoft','Lumia 650','BuckleKuckle',69),(29,'Nokia','8x','BuckleKuckle',64),(30,'OnePlus','oneplus 5','BuckleKuckle',13),(31,'Blackberry','Motion','BuckleKuckle',75),(32,'Alcatel','Idol 5s','BuckleKuckle',32),(33,'ZTE','Nubia Z17s','BuckleKuckle',39),(34,'Xiaomi','MI Mix2','BuckleKuckle',0),(35,'Google','Pixel 2','BuckleKuckle',84),(36,'Acer','Liquid Z6 Plus','BuckleKuckle',15),(37,'Oppo','A77 ','BuckleKuckle',25),(38,'Blu','Grand XL','BuckleKuckle',80),(39,'Vivo','X20','BuckleKuckle',22),(40,'Meizu','M6 note','BuckleKuckle',72),(41,'Samsung','Galaxy Note8','ApacalypseMartyr',95),(42,'Apple','iphone 8 ','ApacalypseMartyr',57),(43,'Sony','Xperia XZ1','ApacalypseMartyr',2),(44,'LG','V30','ApacalypseMartyr',39),(45,'HTC','U11','ApacalypseMartyr',91),(46,'Motorolla','X4','ApacalypseMartyr',33),(47,'Huawie','Mate 10','ApacalypseMartyr',94),(48,'Microsoft','Lumia 650','ApacalypseMartyr',69),(49,'Nokia','8x','ApacalypseMartyr',64),(50,'OnePlus','oneplus 5','ApacalypseMartyr',12),(51,'Blackberry','Motion','ApacalypseMartyr',71),(52,'Alcatel','Idol 5s','ApacalypseMartyr',18),(53,'ZTE','Nubia Z17s','ApacalypseMartyr',79),(54,'Xiaomi','MI Mix2','ApacalypseMartyr',39),(55,'Google','Pixel 2','ApacalypseMartyr',58),(56,'Acer','Liquid Z6 Plus','ApacalypseMartyr',71),(57,'Oppo','A77 ','ApacalypseMartyr',82),(58,'Blu','Grand XL','ApacalypseMartyr',98),(59,'Vivo','X20','ApacalypseMartyr',42),(60,'Meizu','M6 note','ApacalypseMartyr',19),(61,'Samsung','Galaxy Note8','AllCool',67),(62,'Apple','iphone 8 ','AllCool',78),(63,'Sony','Xperia XZ1','AllCool',90),(64,'LG','V30','AllCool',14),(65,'HTC','U11','AllCool',4),(66,'Motorolla','X4','AllCool',78),(67,'Huawie','Mate 10','AllCool',78),(68,'Microsoft','Lumia 650','AllCool',53),(69,'Nokia','8x','AllCool',30),(70,'OnePlus','oneplus 5','AllCool',95),(71,'Blackberry','Motion','AllCool',81),(72,'Alcatel','Idol 5s','AllCool',20),(73,'ZTE','Nubia Z17s','AllCool',58),(74,'Xiaomi','MI Mix2','AllCool',28),(75,'Google','Pixel 2','AllCool',68),(76,'Acer','Liquid Z6 Plus','AllCool',56),(77,'Oppo','A77 ','AllCool',75),(78,'Blu','Grand XL','AllCool',8),(79,'Vivo','X20','AllCool',14),(80,'Meizu','M6 note','AllCool',49),(81,'Samsung','Galaxy Note8','AshamedWallnut',2),(82,'Apple','iphone 8 ','AshamedWallnut',65),(83,'Sony','Xperia XZ1','AshamedWallnut',17),(84,'LG','V30','AshamedWallnut',90),(85,'HTC','U11','AshamedWallnut',98),(86,'Motorolla','X4','AshamedWallnut',18),(87,'Huawie','Mate 10','AshamedWallnut',0),(88,'Microsoft','Lumia 650','AshamedWallnut',46),(89,'Nokia','8x','AshamedWallnut',30),(90,'OnePlus','oneplus 5','AshamedWallnut',13),(91,'Blackberry','Motion','AshamedWallnut',75),(92,'Alcatel','Idol 5s','AshamedWallnut',36),(93,'ZTE','Nubia Z17s','AshamedWallnut',53),(94,'Xiaomi','MI Mix2','AshamedWallnut',59),(95,'Google','Pixel 2','AshamedWallnut',35),(96,'Acer','Liquid Z6 Plus','AshamedWallnut',100),(97,'Oppo','A77 ','AshamedWallnut',92),(98,'Blu','Grand XL','AshamedWallnut',59),(99,'Vivo','X20','AshamedWallnut',18),(100,'Meizu','M6 note','AshamedWallnut',16),(101,'Samsung','Galaxy Note8','EditedWalker',25),(102,'Apple','iphone 8 ','EditedWalker',77),(103,'Sony','Xperia XZ1','EditedWalker',10),(104,'LG','V30','EditedWalker',20),(105,'HTC','U11','EditedWalker',72),(106,'Motorolla','X4','EditedWalker',98),(107,'Huawie','Mate 10','EditedWalker',70),(108,'Microsoft','Lumia 650','EditedWalker',59),(109,'Nokia','8x','EditedWalker',84),(110,'OnePlus','oneplus 5','EditedWalker',44),(111,'Blackberry','Motion','EditedWalker',67),(112,'Alcatel','Idol 5s','EditedWalker',3),(113,'ZTE','Nubia Z17s','EditedWalker',15),(114,'Xiaomi','MI Mix2','EditedWalker',68),(115,'Google','Pixel 2','EditedWalker',93),(116,'Acer','Liquid Z6 Plus','EditedWalker',59),(117,'Oppo','A77 ','EditedWalker',17),(118,'Blu','Grand XL','EditedWalker',10),(119,'Vivo','X20','EditedWalker',98),(120,'Meizu','M6 note','EditedWalker',60),(121,'Samsung','Galaxy Note8','RisenTalker',5),(122,'Apple','iphone 8 ','RisenTalker',46),(123,'Sony','Xperia XZ1','RisenTalker',17),(124,'LG','V30','RisenTalker',45),(125,'HTC','U11','RisenTalker',76),(126,'Motorolla','X4','RisenTalker',44),(127,'Huawie','Mate 10','RisenTalker',93),(128,'Microsoft','Lumia 650','RisenTalker',28),(129,'Nokia','8x','RisenTalker',67),(130,'OnePlus','oneplus 5','RisenTalker',46),(131,'Blackberry','Motion','RisenTalker',32),(132,'Alcatel','Idol 5s','RisenTalker',24),(133,'ZTE','Nubia Z17s','RisenTalker',22),(134,'Xiaomi','MI Mix2','RisenTalker',37),(135,'Google','Pixel 2','RisenTalker',21),(136,'Acer','Liquid Z6 Plus','RisenTalker',93),(137,'Oppo','A77 ','RisenTalker',2),(138,'Blu','Grand XL','RisenTalker',32),(139,'Vivo','X20','RisenTalker',52),(140,'Meizu','M6 note','RisenTalker',67),(141,'Samsung','Galaxy Note8','BahefulExpert',75),(142,'Apple','iphone 8 ','BahefulExpert',75),(143,'Sony','Xperia XZ1','BahefulExpert',50),(144,'LG','V30','BahefulExpert',26),(145,'HTC','U11','BahefulExpert',83),(146,'Motorolla','X4','BahefulExpert',31),(147,'Huawie','Mate 10','BahefulExpert',9),(148,'Microsoft','Lumia 650','BahefulExpert',54),(149,'Nokia','8x','BahefulExpert',40),(150,'OnePlus','oneplus 5','BahefulExpert',39),(151,'Blackberry','Motion','BahefulExpert',74),(152,'Alcatel','Idol 5s','BahefulExpert',52),(153,'ZTE','Nubia Z17s','BahefulExpert',40),(154,'Xiaomi','MI Mix2','BahefulExpert',44),(155,'Google','Pixel 2','BahefulExpert',1),(156,'Acer','Liquid Z6 Plus','BahefulExpert',75),(157,'Oppo','A77 ','BahefulExpert',68),(158,'Blu','Grand XL','BahefulExpert',15),(159,'Vivo','X20','BahefulExpert',75),(160,'Meizu','M6 note','BahefulExpert',28),(161,'Samsung','Galaxy Note8','CommunistKilljoy',14),(162,'Apple','iphone 8 ','CommunistKilljoy',89),(163,'Sony','Xperia XZ1','CommunistKilljoy',100),(164,'LG','V30','CommunistKilljoy',29),(165,'HTC','U11','CommunistKilljoy',51),(166,'Motorolla','X4','CommunistKilljoy',68),(167,'Huawie','Mate 10','CommunistKilljoy',87),(168,'Microsoft','Lumia 650','CommunistKilljoy',27),(169,'Nokia','8x','CommunistKilljoy',78),(170,'OnePlus','oneplus 5','CommunistKilljoy',4),(171,'Blackberry','Motion','CommunistKilljoy',93),(172,'Alcatel','Idol 5s','CommunistKilljoy',49),(173,'ZTE','Nubia Z17s','CommunistKilljoy',65),(174,'Xiaomi','MI Mix2','CommunistKilljoy',78),(175,'Google','Pixel 2','CommunistKilljoy',95),(176,'Acer','Liquid Z6 Plus','CommunistKilljoy',39),(177,'Oppo','A77 ','CommunistKilljoy',13),(178,'Blu','Grand XL','CommunistKilljoy',48),(179,'Vivo','X20','CommunistKilljoy',1),(180,'Meizu','M6 note','CommunistKilljoy',64),(181,'Samsung','Galaxy Note8','KrampusDeject',13),(182,'Apple','iphone 8 ','KrampusDeject',75),(183,'Sony','Xperia XZ1','KrampusDeject',35),(184,'LG','V30','KrampusDeject',49),(185,'HTC','U11','KrampusDeject',40),(186,'Motorolla','X4','KrampusDeject',55),(187,'Huawie','Mate 10','KrampusDeject',55),(188,'Microsoft','Lumia 650','KrampusDeject',7),(189,'Nokia','8x','KrampusDeject',75),(190,'OnePlus','oneplus 5','KrampusDeject',49),(191,'Blackberry','Motion','KrampusDeject',20),(192,'Alcatel','Idol 5s','KrampusDeject',55),(193,'ZTE','Nubia Z17s','KrampusDeject',13),(194,'Xiaomi','MI Mix2','KrampusDeject',2),(195,'Google','Pixel 2','KrampusDeject',71),(196,'Acer','Liquid Z6 Plus','KrampusDeject',49),(197,'Oppo','A77 ','KrampusDeject',33),(198,'Blu','Grand XL','KrampusDeject',19),(199,'Vivo','X20','KrampusDeject',97),(200,'Meizu','M6 note','KrampusDeject',24),(201,'Samsung','Galaxy Note8','BrusqueJanitor',31),(202,'Apple','iphone 8 ','BrusqueJanitor',85),(203,'Sony','Xperia XZ1','BrusqueJanitor',31),(204,'LG','V30','BrusqueJanitor',100),(205,'HTC','U11','BrusqueJanitor',2),(206,'Motorolla','X4','BrusqueJanitor',15),(207,'Huawie','Mate 10','BrusqueJanitor',72),(208,'Microsoft','Lumia 650','BrusqueJanitor',9),(209,'Nokia','8x','BrusqueJanitor',32),(210,'OnePlus','oneplus 5','BrusqueJanitor',34),(211,'Blackberry','Motion','BrusqueJanitor',75),(212,'Alcatel','Idol 5s','BrusqueJanitor',72),(213,'ZTE','Nubia Z17s','BrusqueJanitor',33),(214,'Xiaomi','MI Mix2','BrusqueJanitor',53),(215,'Google','Pixel 2','BrusqueJanitor',62),(216,'Acer','Liquid Z6 Plus','BrusqueJanitor',52),(217,'Oppo','A77 ','BrusqueJanitor',75),(218,'Blu','Grand XL','BrusqueJanitor',19),(219,'Vivo','X20','BrusqueJanitor',69),(220,'Meizu','M6 note','BrusqueJanitor',90),(221,'Samsung','Galaxy Note8','AquaticMummy',40),(222,'Apple','iphone 8 ','AquaticMummy',33),(223,'Sony','Xperia XZ1','AquaticMummy',46),(224,'LG','V30','AquaticMummy',31),(225,'HTC','U11','AquaticMummy',15),(226,'Motorolla','X4','AquaticMummy',83),(227,'Huawie','Mate 10','AquaticMummy',70),(228,'Microsoft','Lumia 650','AquaticMummy',100),(229,'Nokia','8x','AquaticMummy',91),(230,'OnePlus','oneplus 5','AquaticMummy',52),(231,'Blackberry','Motion','AquaticMummy',89),(232,'Alcatel','Idol 5s','AquaticMummy',89),(233,'ZTE','Nubia Z17s','AquaticMummy',76),(234,'Xiaomi','MI Mix2','AquaticMummy',12),(235,'Google','Pixel 2','AquaticMummy',37),(236,'Acer','Liquid Z6 Plus','AquaticMummy',45),(237,'Oppo','A77 ','AquaticMummy',16),(238,'Blu','Grand XL','AquaticMummy',47),(239,'Vivo','X20','AquaticMummy',87),(240,'Meizu','M6 note','AquaticMummy',92),(241,'Samsung','Galaxy Note8','LoralMockups',98),(242,'Apple','iphone 8 ','LoralMockups',15),(243,'Sony','Xperia XZ1','LoralMockups',82),(244,'LG','V30','LoralMockups',61),(245,'HTC','U11','LoralMockups',63),(246,'Motorolla','X4','LoralMockups',30),(247,'Huawie','Mate 10','LoralMockups',62),(248,'Microsoft','Lumia 650','LoralMockups',21),(249,'Nokia','8x','LoralMockups',18),(250,'OnePlus','oneplus 5','LoralMockups',27),(251,'Blackberry','Motion','LoralMockups',82),(252,'Alcatel','Idol 5s','LoralMockups',28),(253,'ZTE','Nubia Z17s','LoralMockups',94),(254,'Xiaomi','MI Mix2','LoralMockups',85),(255,'Google','Pixel 2','LoralMockups',41),(256,'Acer','Liquid Z6 Plus','LoralMockups',54),(257,'Oppo','A77 ','LoralMockups',46),(258,'Blu','Grand XL','LoralMockups',67),(259,'Vivo','X20','LoralMockups',97),(260,'Meizu','M6 note','LoralMockups',81),(261,'Samsung','Galaxy Note8','StupidMarxist',13),(262,'Apple','iphone 8 ','StupidMarxist',25),(263,'Sony','Xperia XZ1','StupidMarxist',87),(264,'LG','V30','StupidMarxist',56),(265,'HTC','U11','StupidMarxist',22),(266,'Motorolla','X4','StupidMarxist',43),(267,'Huawie','Mate 10','StupidMarxist',49),(268,'Microsoft','Lumia 650','StupidMarxist',17),(269,'Nokia','8x','StupidMarxist',38),(270,'OnePlus','oneplus 5','StupidMarxist',39),(271,'Blackberry','Motion','StupidMarxist',81),(272,'Alcatel','Idol 5s','StupidMarxist',86),(273,'ZTE','Nubia Z17s','StupidMarxist',87),(274,'Xiaomi','MI Mix2','StupidMarxist',75),(275,'Google','Pixel 2','StupidMarxist',13),(276,'Acer','Liquid Z6 Plus','StupidMarxist',42),(277,'Oppo','A77 ','StupidMarxist',71),(278,'Blu','Grand XL','StupidMarxist',26),(279,'Vivo','X20','StupidMarxist',22),(280,'Meizu','M6 note','StupidMarxist',30),(281,'Samsung','Galaxy Note8','EvillPotter',85),(282,'Apple','iphone 8 ','EvillPotter',32),(283,'Sony','Xperia XZ1','EvillPotter',9),(284,'LG','V30','EvillPotter',48),(285,'HTC','U11','EvillPotter',11),(286,'Motorolla','X4','EvillPotter',15),(287,'Huawie','Mate 10','EvillPotter',41),(288,'Microsoft','Lumia 650','EvillPotter',60),(289,'Nokia','8x','EvillPotter',77),(290,'OnePlus','oneplus 5','EvillPotter',3),(291,'Blackberry','Motion','EvillPotter',86),(292,'Alcatel','Idol 5s','EvillPotter',20),(293,'ZTE','Nubia Z17s','EvillPotter',45),(294,'Xiaomi','MI Mix2','EvillPotter',65),(295,'Google','Pixel 2','EvillPotter',90),(296,'Acer','Liquid Z6 Plus','EvillPotter',51),(297,'Oppo','A77 ','EvillPotter',89),(298,'Blu','Grand XL','EvillPotter',90),(299,'Vivo','X20','EvillPotter',83),(300,'Meizu','M6 note','EvillPotter',43),(301,'Samsung','Galaxy Note8','ArenoidSubject',68),(302,'Apple','iphone 8 ','ArenoidSubject',9),(303,'Sony','Xperia XZ1','ArenoidSubject',42),(304,'LG','V30','ArenoidSubject',84),(305,'HTC','U11','ArenoidSubject',92),(306,'Motorolla','X4','ArenoidSubject',8),(307,'Huawie','Mate 10','ArenoidSubject',68),(308,'Microsoft','Lumia 650','ArenoidSubject',14),(309,'Nokia','8x','ArenoidSubject',69),(310,'OnePlus','oneplus 5','ArenoidSubject',0),(311,'Blackberry','Motion','ArenoidSubject',96),(312,'Alcatel','Idol 5s','ArenoidSubject',76),(313,'ZTE','Nubia Z17s','ArenoidSubject',91),(314,'Xiaomi','MI Mix2','ArenoidSubject',26),(315,'Google','Pixel 2','ArenoidSubject',60),(316,'Acer','Liquid Z6 Plus','ArenoidSubject',22),(317,'Oppo','A77 ','ArenoidSubject',31),(318,'Blu','Grand XL','ArenoidSubject',90),(319,'Vivo','X20','ArenoidSubject',55),(320,'Meizu','M6 note','ArenoidSubject',6),(321,'Samsung','Galaxy Note8','KindMeddler',65),(322,'Apple','iphone 8 ','KindMeddler',7),(323,'Sony','Xperia XZ1','KindMeddler',40),(324,'LG','V30','KindMeddler',78),(325,'HTC','U11','KindMeddler',69),(326,'Motorolla','X4','KindMeddler',10),(327,'Huawie','Mate 10','KindMeddler',47),(328,'Microsoft','Lumia 650','KindMeddler',3),(329,'Nokia','8x','KindMeddler',75),(330,'OnePlus','oneplus 5','KindMeddler',65),(331,'Blackberry','Motion','KindMeddler',99),(332,'Alcatel','Idol 5s','KindMeddler',98),(333,'ZTE','Nubia Z17s','KindMeddler',95),(334,'Xiaomi','MI Mix2','KindMeddler',78),(335,'Google','Pixel 2','KindMeddler',7),(336,'Acer','Liquid Z6 Plus','KindMeddler',1),(337,'Oppo','A77 ','KindMeddler',88),(338,'Blu','Grand XL','KindMeddler',33),(339,'Vivo','X20','KindMeddler',4),(340,'Meizu','M6 note','KindMeddler',22),(341,'Samsung','Galaxy Note8','TakenProctor',97),(342,'Apple','iphone 8 ','TakenProctor',16),(343,'Sony','Xperia XZ1','TakenProctor',95),(344,'LG','V30','TakenProctor',21),(345,'HTC','U11','TakenProctor',22),(346,'Motorolla','X4','TakenProctor',48),(347,'Huawie','Mate 10','TakenProctor',72),(348,'Microsoft','Lumia 650','TakenProctor',14),(349,'Nokia','8x','TakenProctor',58),(350,'OnePlus','oneplus 5','TakenProctor',48),(351,'Blackberry','Motion','TakenProctor',66),(352,'Alcatel','Idol 5s','TakenProctor',83),(353,'ZTE','Nubia Z17s','TakenProctor',17),(354,'Xiaomi','MI Mix2','TakenProctor',40),(355,'Google','Pixel 2','TakenProctor',46),(356,'Acer','Liquid Z6 Plus','TakenProctor',10),(357,'Oppo','A77 ','TakenProctor',13),(358,'Blu','Grand XL','TakenProctor',34),(359,'Vivo','X20','TakenProctor',33),(360,'Meizu','M6 note','TakenProctor',64),(361,'Samsung','Galaxy Note8','ToxicAbjured',19),(362,'Apple','iphone 8 ','ToxicAbjured',3),(363,'Sony','Xperia XZ1','ToxicAbjured',58),(364,'LG','V30','ToxicAbjured',83),(365,'HTC','U11','ToxicAbjured',39),(366,'Motorolla','X4','ToxicAbjured',47),(367,'Huawie','Mate 10','ToxicAbjured',16),(368,'Microsoft','Lumia 650','ToxicAbjured',42),(369,'Nokia','8x','ToxicAbjured',60),(370,'OnePlus','oneplus 5','ToxicAbjured',76),(371,'Blackberry','Motion','ToxicAbjured',98),(372,'Alcatel','Idol 5s','ToxicAbjured',61),(373,'ZTE','Nubia Z17s','ToxicAbjured',12),(374,'Xiaomi','MI Mix2','ToxicAbjured',78),(375,'Google','Pixel 2','ToxicAbjured',52),(376,'Acer','Liquid Z6 Plus','ToxicAbjured',29),(377,'Oppo','A77 ','ToxicAbjured',88),(378,'Blu','Grand XL','ToxicAbjured',50),(379,'Vivo','X20','ToxicAbjured',90),(380,'Meizu','M6 note','ToxicAbjured',97),(381,'Samsung','Galaxy Note8','LyminalTaxing',13),(382,'Apple','iphone 8 ','LyminalTaxing',80),(383,'Sony','Xperia XZ1','LyminalTaxing',56),(384,'LG','V30','LyminalTaxing',43),(385,'HTC','U11','LyminalTaxing',48),(386,'Motorolla','X4','LyminalTaxing',8),(387,'Huawie','Mate 10','LyminalTaxing',99),(388,'Microsoft','Lumia 650','LyminalTaxing',68),(389,'Nokia','8x','LyminalTaxing',42),(390,'OnePlus','oneplus 5','LyminalTaxing',9),(391,'Blackberry','Motion','LyminalTaxing',20),(392,'Alcatel','Idol 5s','LyminalTaxing',75),(393,'ZTE','Nubia Z17s','LyminalTaxing',10),(394,'Xiaomi','MI Mix2','LyminalTaxing',27),(395,'Google','Pixel 2','LyminalTaxing',5),(396,'Acer','Liquid Z6 Plus','LyminalTaxing',45),(397,'Oppo','A77 ','LyminalTaxing',8),(398,'Blu','Grand XL','LyminalTaxing',8),(399,'Vivo','X20','LyminalTaxing',14),(400,'Meizu','M6 note','LyminalTaxing',49),(401,'Samsung','Galaxy Note8','UltimatumHero',2),(402,'Apple','iphone 8 ','UltimatumHero',62),(403,'Sony','Xperia XZ1','UltimatumHero',5),(404,'LG','V30','UltimatumHero',42),(405,'HTC','U11','UltimatumHero',92),(406,'Motorolla','X4','UltimatumHero',34),(407,'Huawie','Mate 10','UltimatumHero',96),(408,'Microsoft','Lumia 650','UltimatumHero',75),(409,'Nokia','8x','UltimatumHero',87),(410,'OnePlus','oneplus 5','UltimatumHero',8),(411,'Blackberry','Motion','UltimatumHero',82),(412,'Alcatel','Idol 5s','UltimatumHero',82),(413,'ZTE','Nubia Z17s','UltimatumHero',67),(414,'Xiaomi','MI Mix2','UltimatumHero',88),(415,'Google','Pixel 2','UltimatumHero',38),(416,'Acer','Liquid Z6 Plus','UltimatumHero',29),(417,'Oppo','A77 ','UltimatumHero',32),(418,'Blu','Grand XL','UltimatumHero',72),(419,'Vivo','X20','UltimatumHero',61),(420,'Meizu','M6 note','UltimatumHero',90),(421,'Samsung','Galaxy Note8','GlossyLier',65),(422,'Apple','iphone 8 ','GlossyLier',58),(423,'Sony','Xperia XZ1','GlossyLier',93),(424,'LG','V30','GlossyLier',91),(425,'HTC','U11','GlossyLier',74),(426,'Motorolla','X4','GlossyLier',98),(427,'Huawie','Mate 10','GlossyLier',68),(428,'Microsoft','Lumia 650','GlossyLier',45),(429,'Nokia','8x','GlossyLier',22),(430,'OnePlus','oneplus 5','GlossyLier',75),(431,'Blackberry','Motion','GlossyLier',6),(432,'Alcatel','Idol 5s','GlossyLier',8),(433,'ZTE','Nubia Z17s','GlossyLier',22),(434,'Xiaomi','MI Mix2','GlossyLier',85),(435,'Google','Pixel 2','GlossyLier',59),(436,'Acer','Liquid Z6 Plus','GlossyLier',41),(437,'Oppo','A77 ','GlossyLier',27),(438,'Blu','Grand XL','GlossyLier',11),(439,'Vivo','X20','GlossyLier',79),(440,'Meizu','M6 note','GlossyLier',57),(441,'Samsung','Galaxy Note8','ExoticPeacock',47),(442,'Apple','iphone 8 ','ExoticPeacock',66),(443,'Sony','Xperia XZ1','ExoticPeacock',90),(444,'LG','V30','ExoticPeacock',51),(445,'HTC','U11','ExoticPeacock',84),(446,'Motorolla','X4','ExoticPeacock',66),(447,'Huawie','Mate 10','ExoticPeacock',81),(448,'Microsoft','Lumia 650','ExoticPeacock',3),(449,'Nokia','8x','ExoticPeacock',76),(450,'OnePlus','oneplus 5','ExoticPeacock',68),(451,'Blackberry','Motion','ExoticPeacock',13),(452,'Alcatel','Idol 5s','ExoticPeacock',62),(453,'ZTE','Nubia Z17s','ExoticPeacock',69),(454,'Xiaomi','MI Mix2','ExoticPeacock',60),(455,'Google','Pixel 2','ExoticPeacock',94),(456,'Acer','Liquid Z6 Plus','ExoticPeacock',86),(457,'Oppo','A77 ','ExoticPeacock',48),(458,'Blu','Grand XL','ExoticPeacock',84),(459,'Vivo','X20','ExoticPeacock',73),(460,'Meizu','M6 note','ExoticPeacock',14),(461,'Samsung','Galaxy Note8','AmorphusAlchemy',52),(462,'Apple','iphone 8 ','AmorphusAlchemy',18),(463,'Sony','Xperia XZ1','AmorphusAlchemy',35),(464,'LG','V30','AmorphusAlchemy',22),(465,'HTC','U11','AmorphusAlchemy',4),(466,'Motorolla','X4','AmorphusAlchemy',57),(467,'Huawie','Mate 10','AmorphusAlchemy',72),(468,'Microsoft','Lumia 650','AmorphusAlchemy',88),(469,'Nokia','8x','AmorphusAlchemy',21),(470,'OnePlus','oneplus 5','AmorphusAlchemy',44),(471,'Blackberry','Motion','AmorphusAlchemy',58),(472,'Alcatel','Idol 5s','AmorphusAlchemy',57),(473,'ZTE','Nubia Z17s','AmorphusAlchemy',8),(474,'Xiaomi','MI Mix2','AmorphusAlchemy',74),(475,'Google','Pixel 2','AmorphusAlchemy',41),(476,'Acer','Liquid Z6 Plus','AmorphusAlchemy',86),(477,'Oppo','A77 ','AmorphusAlchemy',5),(478,'Blu','Grand XL','AmorphusAlchemy',70),(479,'Vivo','X20','AmorphusAlchemy',34),(480,'Meizu','M6 note','AmorphusAlchemy',62),(481,'Samsung','Galaxy Note8','DazedDuck',6),(482,'Apple','iphone 8 ','DazedDuck',45),(483,'Sony','Xperia XZ1','DazedDuck',7),(484,'LG','V30','DazedDuck',2),(485,'HTC','U11','DazedDuck',90),(486,'Motorolla','X4','DazedDuck',40),(487,'Huawie','Mate 10','DazedDuck',31),(488,'Microsoft','Lumia 650','DazedDuck',36),(489,'Nokia','8x','DazedDuck',86),(490,'OnePlus','oneplus 5','DazedDuck',22),(491,'Blackberry','Motion','DazedDuck',52),(492,'Alcatel','Idol 5s','DazedDuck',94),(493,'ZTE','Nubia Z17s','DazedDuck',13),(494,'Xiaomi','MI Mix2','DazedDuck',88),(495,'Google','Pixel 2','DazedDuck',96),(496,'Acer','Liquid Z6 Plus','DazedDuck',13),(497,'Oppo','A77 ','DazedDuck',84),(498,'Blu','Grand XL','DazedDuck',77),(499,'Vivo','X20','DazedDuck',34),(500,'Meizu','M6 note','DazedDuck',38),(501,'Samsung','Galaxy Note8','ExemptJabberwocky',90),(502,'Apple','iphone 8 ','ExemptJabberwocky',35),(503,'Sony','Xperia XZ1','ExemptJabberwocky',4),(504,'LG','V30','ExemptJabberwocky',19),(505,'HTC','U11','ExemptJabberwocky',83),(506,'Motorolla','X4','ExemptJabberwocky',57),(507,'Huawie','Mate 10','ExemptJabberwocky',36),(508,'Microsoft','Lumia 650','ExemptJabberwocky',9),(509,'Nokia','8x','ExemptJabberwocky',38),(510,'OnePlus','oneplus 5','ExemptJabberwocky',63),(511,'Blackberry','Motion','ExemptJabberwocky',99),(512,'Alcatel','Idol 5s','ExemptJabberwocky',4),(513,'ZTE','Nubia Z17s','ExemptJabberwocky',29),(514,'Xiaomi','MI Mix2','ExemptJabberwocky',30),(515,'Google','Pixel 2','ExemptJabberwocky',63),(516,'Acer','Liquid Z6 Plus','ExemptJabberwocky',24),(517,'Oppo','A77 ','ExemptJabberwocky',32),(518,'Blu','Grand XL','ExemptJabberwocky',88),(519,'Vivo','X20','ExemptJabberwocky',42),(520,'Meizu','M6 note','ExemptJabberwocky',46),(521,'Samsung','Galaxy Note8','AllEtudes',5),(522,'Apple','iphone 8 ','AllEtudes',91),(523,'Sony','Xperia XZ1','AllEtudes',35),(524,'LG','V30','AllEtudes',3),(525,'HTC','U11','AllEtudes',12),(526,'Motorolla','X4','AllEtudes',50),(527,'Huawie','Mate 10','AllEtudes',15),(528,'Microsoft','Lumia 650','AllEtudes',26),(529,'Nokia','8x','AllEtudes',86),(530,'OnePlus','oneplus 5','AllEtudes',48),(531,'Blackberry','Motion','AllEtudes',86),(532,'Alcatel','Idol 5s','AllEtudes',83),(533,'ZTE','Nubia Z17s','AllEtudes',57),(534,'Xiaomi','MI Mix2','AllEtudes',36),(535,'Google','Pixel 2','AllEtudes',8),(536,'Acer','Liquid Z6 Plus','AllEtudes',35),(537,'Oppo','A77 ','AllEtudes',52),(538,'Blu','Grand XL','AllEtudes',53),(539,'Vivo','X20','AllEtudes',9),(540,'Meizu','M6 note','AllEtudes',88),(541,'Samsung','Galaxy Note8','SubtleAroma',11),(542,'Apple','iphone 8 ','SubtleAroma',95),(543,'Sony','Xperia XZ1','SubtleAroma',37),(544,'LG','V30','SubtleAroma',2),(545,'HTC','U11','SubtleAroma',0),(546,'Motorolla','X4','SubtleAroma',97),(547,'Huawie','Mate 10','SubtleAroma',79),(548,'Microsoft','Lumia 650','SubtleAroma',4),(549,'Nokia','8x','SubtleAroma',88),(550,'OnePlus','oneplus 5','SubtleAroma',25),(551,'Blackberry','Motion','SubtleAroma',61),(552,'Alcatel','Idol 5s','SubtleAroma',30),(553,'ZTE','Nubia Z17s','SubtleAroma',66),(554,'Xiaomi','MI Mix2','SubtleAroma',41),(555,'Google','Pixel 2','SubtleAroma',6),(556,'Acer','Liquid Z6 Plus','SubtleAroma',10),(557,'Oppo','A77 ','SubtleAroma',32),(558,'Blu','Grand XL','SubtleAroma',31),(559,'Vivo','X20','SubtleAroma',60),(560,'Meizu','M6 note','SubtleAroma',3),(561,'Samsung','Galaxy Note8','DilapidatedIsotope',39),(562,'Apple','iphone 8 ','DilapidatedIsotope',84),(563,'Sony','Xperia XZ1','DilapidatedIsotope',2),(564,'LG','V30','DilapidatedIsotope',61),(565,'HTC','U11','DilapidatedIsotope',99),(566,'Motorolla','X4','DilapidatedIsotope',8),(567,'Huawie','Mate 10','DilapidatedIsotope',46),(568,'Microsoft','Lumia 650','DilapidatedIsotope',6),(569,'Nokia','8x','DilapidatedIsotope',93),(570,'OnePlus','oneplus 5','DilapidatedIsotope',42),(571,'Blackberry','Motion','DilapidatedIsotope',35),(572,'Alcatel','Idol 5s','DilapidatedIsotope',49),(573,'ZTE','Nubia Z17s','DilapidatedIsotope',37),(574,'Xiaomi','MI Mix2','DilapidatedIsotope',41),(575,'Google','Pixel 2','DilapidatedIsotope',96),(576,'Acer','Liquid Z6 Plus','DilapidatedIsotope',52),(577,'Oppo','A77 ','DilapidatedIsotope',75),(578,'Blu','Grand XL','DilapidatedIsotope',16),(579,'Vivo','X20','DilapidatedIsotope',57),(580,'Meizu','M6 note','DilapidatedIsotope',34),(581,'Samsung','Galaxy Note8','GreenJuggleer',3),(582,'Apple','iphone 8 ','GreenJuggleer',12),(583,'Sony','Xperia XZ1','GreenJuggleer',54),(584,'LG','V30','GreenJuggleer',31),(585,'HTC','U11','GreenJuggleer',94),(586,'Motorolla','X4','GreenJuggleer',76),(587,'Huawie','Mate 10','GreenJuggleer',100),(588,'Microsoft','Lumia 650','GreenJuggleer',68),(589,'Nokia','8x','GreenJuggleer',42),(590,'OnePlus','oneplus 5','GreenJuggleer',6),(591,'Blackberry','Motion','GreenJuggleer',3),(592,'Alcatel','Idol 5s','GreenJuggleer',1),(593,'ZTE','Nubia Z17s','GreenJuggleer',97),(594,'Xiaomi','MI Mix2','GreenJuggleer',80),(595,'Google','Pixel 2','GreenJuggleer',7),(596,'Acer','Liquid Z6 Plus','GreenJuggleer',99),(597,'Oppo','A77 ','GreenJuggleer',70),(598,'Blu','Grand XL','GreenJuggleer',55),(599,'Vivo','X20','GreenJuggleer',65),(600,'Meizu','M6 note','GreenJuggleer',59),(601,'Samsung','Galaxy Note8','TatteredTaker',0),(602,'Apple','iphone 8 ','TatteredTaker',27),(603,'Sony','Xperia XZ1','TatteredTaker',34),(604,'LG','V30','TatteredTaker',89),(605,'HTC','U11','TatteredTaker',39),(606,'Motorolla','X4','TatteredTaker',32),(607,'Huawie','Mate 10','TatteredTaker',41),(608,'Microsoft','Lumia 650','TatteredTaker',10),(609,'Nokia','8x','TatteredTaker',29),(610,'OnePlus','oneplus 5','TatteredTaker',13),(611,'Blackberry','Motion','TatteredTaker',81),(612,'Alcatel','Idol 5s','TatteredTaker',62),(613,'ZTE','Nubia Z17s','TatteredTaker',67),(614,'Xiaomi','MI Mix2','TatteredTaker',48),(615,'Google','Pixel 2','TatteredTaker',38),(616,'Acer','Liquid Z6 Plus','TatteredTaker',50),(617,'Oppo','A77 ','TatteredTaker',34),(618,'Blu','Grand XL','TatteredTaker',21),(619,'Vivo','X20','TatteredTaker',3),(620,'Meizu','M6 note','TatteredTaker',55),(621,'Samsung','Galaxy Note8','ShatteredGardener',66),(622,'Apple','iphone 8 ','ShatteredGardener',62),(623,'Sony','Xperia XZ1','ShatteredGardener',10),(624,'LG','V30','ShatteredGardener',70),(625,'HTC','U11','ShatteredGardener',15),(626,'Motorolla','X4','ShatteredGardener',68),(627,'Huawie','Mate 10','ShatteredGardener',92),(628,'Microsoft','Lumia 650','ShatteredGardener',57),(629,'Nokia','8x','ShatteredGardener',8),(630,'OnePlus','oneplus 5','ShatteredGardener',72),(631,'Blackberry','Motion','ShatteredGardener',33),(632,'Alcatel','Idol 5s','ShatteredGardener',51),(633,'ZTE','Nubia Z17s','ShatteredGardener',55),(634,'Xiaomi','MI Mix2','ShatteredGardener',22),(635,'Google','Pixel 2','ShatteredGardener',46),(636,'Acer','Liquid Z6 Plus','ShatteredGardener',62),(637,'Oppo','A77 ','ShatteredGardener',71),(638,'Blu','Grand XL','ShatteredGardener',71),(639,'Vivo','X20','ShatteredGardener',39),(640,'Meizu','M6 note','ShatteredGardener',84),(641,'Samsung','Galaxy Note8','ZaggingZeebra',1),(642,'Apple','iphone 8 ','ZaggingZeebra',57),(643,'Sony','Xperia XZ1','ZaggingZeebra',79),(644,'LG','V30','ZaggingZeebra',23),(645,'HTC','U11','ZaggingZeebra',81),(646,'Motorolla','X4','ZaggingZeebra',35),(647,'Huawie','Mate 10','ZaggingZeebra',33),(648,'Microsoft','Lumia 650','ZaggingZeebra',62),(649,'Nokia','8x','ZaggingZeebra',7),(650,'OnePlus','oneplus 5','ZaggingZeebra',51),(651,'Blackberry','Motion','ZaggingZeebra',33),(652,'Alcatel','Idol 5s','ZaggingZeebra',11),(653,'ZTE','Nubia Z17s','ZaggingZeebra',61),(654,'Xiaomi','MI Mix2','ZaggingZeebra',68),(655,'Google','Pixel 2','ZaggingZeebra',58),(656,'Acer','Liquid Z6 Plus','ZaggingZeebra',88),(657,'Oppo','A77 ','ZaggingZeebra',62),(658,'Blu','Grand XL','ZaggingZeebra',47),(659,'Vivo','X20','ZaggingZeebra',48),(660,'Meizu','M6 note','ZaggingZeebra',1),(661,'Samsung','Galaxy Note8','EndlessOrchid',61),(662,'Apple','iphone 8 ','EndlessOrchid',1),(663,'Sony','Xperia XZ1','EndlessOrchid',22),(664,'LG','V30','EndlessOrchid',10),(665,'HTC','U11','EndlessOrchid',85),(666,'Motorolla','X4','EndlessOrchid',92),(667,'Huawie','Mate 10','EndlessOrchid',2),(668,'Microsoft','Lumia 650','EndlessOrchid',40),(669,'Nokia','8x','EndlessOrchid',90),(670,'OnePlus','oneplus 5','EndlessOrchid',31),(671,'Blackberry','Motion','EndlessOrchid',86),(672,'Alcatel','Idol 5s','EndlessOrchid',35),(673,'ZTE','Nubia Z17s','EndlessOrchid',18),(674,'Xiaomi','MI Mix2','EndlessOrchid',87),(675,'Google','Pixel 2','EndlessOrchid',80),(676,'Acer','Liquid Z6 Plus','EndlessOrchid',36),(677,'Oppo','A77 ','EndlessOrchid',42),(678,'Blu','Grand XL','EndlessOrchid',0),(679,'Vivo','X20','EndlessOrchid',77),(680,'Meizu','M6 note','EndlessOrchid',84),(681,'Samsung','Galaxy Note8','YodelingKench',86),(682,'Apple','iphone 8 ','YodelingKench',78),(683,'Sony','Xperia XZ1','YodelingKench',31),(684,'LG','V30','YodelingKench',23),(685,'HTC','U11','YodelingKench',23),(686,'Motorolla','X4','YodelingKench',48),(687,'Huawie','Mate 10','YodelingKench',71),(688,'Microsoft','Lumia 650','YodelingKench',7),(689,'Nokia','8x','YodelingKench',27),(690,'OnePlus','oneplus 5','YodelingKench',12),(691,'Blackberry','Motion','YodelingKench',80),(692,'Alcatel','Idol 5s','YodelingKench',62),(693,'ZTE','Nubia Z17s','YodelingKench',70),(694,'Xiaomi','MI Mix2','YodelingKench',64),(695,'Google','Pixel 2','YodelingKench',9),(696,'Acer','Liquid Z6 Plus','YodelingKench',54),(697,'Oppo','A77 ','YodelingKench',45),(698,'Blu','Grand XL','YodelingKench',61),(699,'Vivo','X20','YodelingKench',70),(700,'Meizu','M6 note','YodelingKench',67),(701,'Samsung','Galaxy Note8','NeatCutter',22),(702,'Apple','iphone 8 ','NeatCutter',14),(703,'Sony','Xperia XZ1','NeatCutter',2),(704,'LG','V30','NeatCutter',71),(705,'HTC','U11','NeatCutter',45),(706,'Motorolla','X4','NeatCutter',15),(707,'Huawie','Mate 10','NeatCutter',42),(708,'Microsoft','Lumia 650','NeatCutter',61),(709,'Nokia','8x','NeatCutter',82),(710,'OnePlus','oneplus 5','NeatCutter',23),(711,'Blackberry','Motion','NeatCutter',72),(712,'Alcatel','Idol 5s','NeatCutter',89),(713,'ZTE','Nubia Z17s','NeatCutter',30),(714,'Xiaomi','MI Mix2','NeatCutter',84),(715,'Google','Pixel 2','NeatCutter',26),(716,'Acer','Liquid Z6 Plus','NeatCutter',80),(717,'Oppo','A77 ','NeatCutter',20),(718,'Blu','Grand XL','NeatCutter',62),(719,'Vivo','X20','NeatCutter',50),(720,'Meizu','M6 note','NeatCutter',63),(721,'Samsung','Galaxy Note8','AloofVindicator',67),(722,'Apple','iphone 8 ','AloofVindicator',42),(723,'Sony','Xperia XZ1','AloofVindicator',11),(724,'LG','V30','AloofVindicator',32),(725,'HTC','U11','AloofVindicator',26),(726,'Motorolla','X4','AloofVindicator',34),(727,'Huawie','Mate 10','AloofVindicator',91),(728,'Microsoft','Lumia 650','AloofVindicator',53),(729,'Nokia','8x','AloofVindicator',94),(730,'OnePlus','oneplus 5','AloofVindicator',6),(731,'Blackberry','Motion','AloofVindicator',52),(732,'Alcatel','Idol 5s','AloofVindicator',42),(733,'ZTE','Nubia Z17s','AloofVindicator',53),(734,'Xiaomi','MI Mix2','AloofVindicator',38),(735,'Google','Pixel 2','AloofVindicator',30),(736,'Acer','Liquid Z6 Plus','AloofVindicator',39),(737,'Oppo','A77 ','AloofVindicator',5),(738,'Blu','Grand XL','AloofVindicator',10),(739,'Vivo','X20','AloofVindicator',36),(740,'Meizu','M6 note','AloofVindicator',47),(741,'Samsung','Galaxy Note8','JadeReject',25),(742,'Apple','iphone 8 ','JadeReject',89),(743,'Sony','Xperia XZ1','JadeReject',67),(744,'LG','V30','JadeReject',68),(745,'HTC','U11','JadeReject',38),(746,'Motorolla','X4','JadeReject',86),(747,'Huawie','Mate 10','JadeReject',17),(748,'Microsoft','Lumia 650','JadeReject',26),(749,'Nokia','8x','JadeReject',83),(750,'OnePlus','oneplus 5','JadeReject',32),(751,'Blackberry','Motion','JadeReject',14),(752,'Alcatel','Idol 5s','JadeReject',77),(753,'ZTE','Nubia Z17s','JadeReject',38),(754,'Xiaomi','MI Mix2','JadeReject',60),(755,'Google','Pixel 2','JadeReject',86),(756,'Acer','Liquid Z6 Plus','JadeReject',49),(757,'Oppo','A77 ','JadeReject',88),(758,'Blu','Grand XL','JadeReject',93),(759,'Vivo','X20','JadeReject',0),(760,'Meizu','M6 note','JadeReject',24),(761,'Samsung','Galaxy Note8','GreatDaedalus',21),(762,'Apple','iphone 8 ','GreatDaedalus',32),(763,'Sony','Xperia XZ1','GreatDaedalus',97),(764,'LG','V30','GreatDaedalus',86),(765,'HTC','U11','GreatDaedalus',37),(766,'Motorolla','X4','GreatDaedalus',30),(767,'Huawie','Mate 10','GreatDaedalus',40),(768,'Microsoft','Lumia 650','GreatDaedalus',10),(769,'Nokia','8x','GreatDaedalus',31),(770,'OnePlus','oneplus 5','GreatDaedalus',25),(771,'Blackberry','Motion','GreatDaedalus',32),(772,'Alcatel','Idol 5s','GreatDaedalus',84),(773,'ZTE','Nubia Z17s','GreatDaedalus',23),(774,'Xiaomi','MI Mix2','GreatDaedalus',67),(775,'Google','Pixel 2','GreatDaedalus',64),(776,'Acer','Liquid Z6 Plus','GreatDaedalus',16),(777,'Oppo','A77 ','GreatDaedalus',92),(778,'Blu','Grand XL','GreatDaedalus',9),(779,'Vivo','X20','GreatDaedalus',72),(780,'Meizu','M6 note','GreatDaedalus',29),(781,'Samsung','Galaxy Note8','KineticArmorer',33),(782,'Apple','iphone 8 ','KineticArmorer',79),(783,'Sony','Xperia XZ1','KineticArmorer',94),(784,'LG','V30','KineticArmorer',29),(785,'HTC','U11','KineticArmorer',68),(786,'Motorolla','X4','KineticArmorer',52),(787,'Huawie','Mate 10','KineticArmorer',55),(788,'Microsoft','Lumia 650','KineticArmorer',18),(789,'Nokia','8x','KineticArmorer',29),(790,'OnePlus','oneplus 5','KineticArmorer',91),(791,'Blackberry','Motion','KineticArmorer',66),(792,'Alcatel','Idol 5s','KineticArmorer',57),(793,'ZTE','Nubia Z17s','KineticArmorer',85),(794,'Xiaomi','MI Mix2','KineticArmorer',56),(795,'Google','Pixel 2','KineticArmorer',25),(796,'Acer','Liquid Z6 Plus','KineticArmorer',57),(797,'Oppo','A77 ','KineticArmorer',8),(798,'Blu','Grand XL','KineticArmorer',74),(799,'Vivo','X20','KineticArmorer',43),(800,'Meizu','M6 note','KineticArmorer',95);
  /*!40000 ALTER TABLE `rating` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  /*!50003 SET character_set_client  = utf8 */ ;
  /*!50003 SET character_set_results = utf8 */ ;
  /*!50003 SET collation_connection  = utf8_general_ci */ ;
  /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  /*!50003 SET sql_mode              = '' */ ;
  DELIMITER ;;
  /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER after_rating_update 
      AFTER UPDATE ON rating
      FOR EACH ROW 
  BEGIN
  	update phone p join
         (select model, avg(userRating) as avgscore
          from rating r
          group by model
         ) r
         on p.model = r.model
      set p.avgRating = r.avgscore;
  END */;;
  DELIMITER ;
  /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  /*!50003 SET character_set_client  = @saved_cs_client */ ;
  /*!50003 SET character_set_results = @saved_cs_results */ ;
  /*!50003 SET collation_connection  = @saved_col_connection */ ;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `username` text,
    `password` text,
    `firstname` text,
    `lastname` text,
    `email` text,
    `phoneNum` text,
    `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES ('DustyOregeno','MTwU7b','Dean','Orrell','DustyOregeno@email.com','202-555-0194','2017-10-18 19:03:45'),('BuckleKuckle','wKDq6F','Brandit','Kole','BuckleKuckle@email.com','202-555-0169','2017-10-18 19:03:45'),('ApacalypseMartyr','5WVZgy','Alycia','Mort','ApacalypseMartyr@email.com','303-350-7462','2017-10-18 19:03:45'),('AllCool','5EdcHX','Arron','Christholm','AllCool@email.com','347-618-5679','2017-10-18 19:03:45'),('AshamedWallnut','V5QBnF','Alma','Wilbur','AshamedWallnut@email.com','318-258-8647','2017-10-18 19:03:45'),('EditedWalker','g7RyzE','Elyse','Woody','EditedWalker@email.com','618-342-1938','2017-10-18 19:03:45'),('RisenTalker','9D4zgz','Rita','Tyrone','RisenTalker@email.com','661-538-8255','2017-10-18 19:03:45'),('BahefulExpert','EhRL8c','Buddy','Essence','BahefulExpert@email.com','360-735-4402','2017-10-18 19:03:45'),('CommunistKilljoy','QpG8Ga','Christine','Kaeden','CommunistKilljoy@email.com','713-815-9851','2017-10-18 19:03:45'),('KrampusDeject','4Bd7eX','Kameron','Dorretta','KrampusDeject@email.com','414-758-1868','2017-10-18 19:03:45'),('BrusqueJanitor','3pwQ7Y','Bristol','Jason','BrusqueJanitor@email.com','205-913-1518','2017-10-18 19:03:45'),('AquaticMummy','eeKs2R','Alger','Makayla','AquaticMummy@email.com','561-275-0896','2017-10-18 19:03:45'),('LoralMockups','A5Rc2d','Lorettal','Mortemer','LoralMockups@email.com','314-660-2421','2017-10-18 19:03:45'),('StupidMarxist','55jnDN','Stefani','Mortemer','StupidMarxist@email.com','618-779-5115','2017-10-18 19:03:45'),('EvillPotter','QDL5zw','Evelyn','Phebe','EvillPotter@email.com','661-859-1580','2017-10-18 19:03:45'),('ArenoidSubject','4Ljp8A','Annie','Stacey','ArenoidSubject@email.com','256-867-3904','2017-10-18 19:03:45'),('KindMeddler','2vDXwz','Kelsi','Moria','KindMeddler@email.com','828-245-5448','2017-10-18 19:03:45'),('TakenProctor','L3uNWJ','Tamara','Phil','TakenProctor@email.com','760-367-6794','2017-10-18 19:03:45'),('ToxicAbjured','raTU8F','Tracie','Amilia','ToxicAbjured@email.com','218-538-2551','2017-10-18 19:03:45'),('LyminalTaxing','cm3Uvf','Lynnette','Tristen','LyminalTaxing@email.com','361-576-4676','2017-10-18 19:03:45'),('UltimatumHero','3xkDtB','Urbana','Herminia','UltimatumHero@email.com','213-200-4930','2017-10-18 19:03:45'),('GlossyLier','7fvMEg','Grover','Lynette','GlossyLier@email.com','574-505-8933','2017-10-18 19:03:45'),('ExoticPeacock','8NnaMV','Elosia','Philippa','ExoticPeacock@email.com','317-364-2622','2017-10-18 19:03:45'),('AmorphusAlchemy','s9ThhY','Avice','Amyletta','AmorphusAlchemy@email.com','660-553-9208','2017-10-18 19:03:45'),('DazedDuck','7gnHVe','Doris','Danica','DazedDuck@email.com','417-737-6552','2017-10-18 19:03:45'),('ExemptJabberwocky','k27hQk','Eula','Jayla','ExemptJabberwocky@email.com','832-570-7255','2017-10-18 19:03:45'),('AllEtudes','9LKx6j','Alexandra','Eladio','AllEtudes@email.com','661-859-1580','2017-10-18 19:03:45'),('SubtleAroma','dPve9g','Sandie','Alene','SubtleAroma@email.com','256-867-3904','2017-10-18 19:03:45'),('DilapidatedIsotope','Zs4JuS','Dayna','Issy','DilapidatedIsotope@email.com','828-245-5448','2017-10-18 19:03:45'),('GreenJuggleer','4aMhRW','Grabriella','Jasia','GreenJuggleer@email.com','760-367-6794','2017-10-18 19:03:45'),('TatteredTaker','DT9jwc','Terenzio','Tucker','TatteredTaker@email.com','419-482-3356','2017-10-18 19:03:45'),('ShatteredGardener','Eqk6Jz','Shelton','Gwen','ShatteredGardener@email.com','850-492-7390','2017-10-18 19:03:45'),('ZaggingZeebra','S5gw9J','Zachery','Zachariah','ZaggingZeebra@email.com','337-678-2173','2017-10-18 19:03:45'),('EndlessOrchid','UW2wmV','Erica','Oli','EndlessOrchid@email.com','719-302-3011','2017-10-18 19:03:45'),('YodelingKench','Y6naVA','Yolanda','Kathleen','YodelingKench@email.com','703-579-6450','2017-10-18 19:03:45'),('NeatCutter','7adYrQ','Nate','Charley','NeatCutter@email.com','214-855-9728','2017-10-18 19:03:45'),('AloofVindicator','jRBa7j','Amatore','Valentine','AloofVindicator@email.com','559-536-7723','2017-10-18 19:03:45'),('JadeReject','xy49GJ','Jacinda','Raegan','JadeReject@email.com','213-200-9777','2017-10-18 19:03:45'),('GreatDaedalus','2mfGQB','George','Dorretta','GreatDaedalus@email.com','909-827-6166','2017-10-18 19:03:45'),('KineticArmorer','we5Eme','Kristie','Ambrose','KineticArmorer@email.com','440-539-5487','2017-10-18 19:03:45');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Dumping events for database 'dbms_phone1'
  --
  
  --
  -- Dumping routines for database 'dbms_phone1'
  --
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2017-11-21 20:46:15
  