USE `test`; -- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86) -- -- Host: dev-mysql1.dev.cognito.co.uk Database: test -- ------------------------------------------------------ -- Server version 5.5.21-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 `RawData` -- DROP TABLE IF EXISTS `RawData`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `RawData` ( `rowid` bigint(20) DEFAULT NULL, `parent_org_struct_id` int(11) DEFAULT NULL, `org_struct_id` int(11) DEFAULT NULL, `org_struct_name` varchar(100) DEFAULT NULL, `tasks_closed` int(11) DEFAULT NULL, `tasks_closed_outside_sla` int(11) DEFAULT NULL, `tasks_nps_promoter` int(11) DEFAULT NULL, `promoter_percent` float DEFAULT NULL, `tasks_nps_neutral` int(11) DEFAULT NULL, `neutral_percent` float DEFAULT NULL, `tasks_nps_detractor` int(11) DEFAULT NULL, `detractor_percent` float DEFAULT NULL, `nps_score` float DEFAULT NULL, `count_01` int(11) DEFAULT NULL, `count_02` int(11) DEFAULT NULL, `count_03` int(11) DEFAULT NULL, `count_04` int(11) DEFAULT NULL, `count_05` int(11) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `RawData` -- LOCK TABLES `RawData` WRITE; /*!40000 ALTER TABLE `RawData` DISABLE KEYS */; INSERT INTO `RawData` VALUES (22364454717488109,101,1001,'Team 1',67,18,15,22.3881,2,2.98507,50,74.6269,-52.2388,0,0,0,0,0),(22364454717488110,101,1002,'Team 2',18,2,2,11.1111,0,0,16,88.8889,-77.7778,0,0,0,0,0),(22364454717488111,101,1003,'Team 3',50,14,6,12,1,2,43,86,-74,0,0,0,0,0),(22364454717488112,101,1004,'Team 4',21,9,2,9.52381,1,4.7619,18,85.7143,-76.1905,0,0,0,0,0),(22364454717488113,101,1005,'Team 5',15,6,0,0,3,20,12,80,-80,0,0,0,0,0),(22364454717488114,101,1007,'Team 7',49,13,5,10.2041,3,6.12245,41,83.6735,-73.4694,0,0,0,0,0),(22364454717488115,101,1009,'Team 9',48,9,13,27.0833,0,0,35,72.9167,-45.8333,0,0,0,0,0),(22364454717488116,101,1010,'Team 10',18,4,3,16.6667,1,5.55556,14,77.7778,-61.1111,0,0,0,0,0),(22364454717488117,102,1011,'Team 11',16,4,3,18.75,0,0,13,81.25,-62.5,0,0,0,0,0),(22364454717488118,102,1012,'Team 12',51,13,13,25.4902,0,0,38,74.5098,-49.0196,0,0,0,0,0),(22364454717488119,102,1013,'Team 13',66,22,13,19.697,3,4.54545,50,75.7576,-56.0606,0,0,0,0,0),(22364454717488120,102,1014,'Team 14',11,1,2,18.1818,1,9.09091,8,72.7273,-54.5455,0,0,0,0,0),(22364454717488121,102,1015,'Team 15',16,1,2,12.5,1,6.25,13,81.25,-68.75,0,0,0,0,0),(22364454717488122,102,1016,'Team 16',71,12,10,14.0845,0,0,61,85.9155,-71.831,0,0,0,0,0),(22364454717488123,102,1017,'Team 17',96,25,17,17.7083,3,3.125,76,79.1667,-61.4583,0,0,0,0,0),(22364454717488124,102,1018,'Team 18',53,15,5,9.43396,1,1.88679,47,88.6792,-79.2453,0,0,0,0,0),(22364454717488125,102,1019,'Team 19',87,17,17,19.5402,1,1.14943,69,79.3103,-59.7701,0,0,0,0,0),(22364454717488126,102,1020,'Team 20',29,8,3,10.3448,1,3.44828,25,86.2069,-75.8621,0,0,0,0,0),(22364454717488127,103,1021,'Team 21',40,13,6,15,2,5,32,80,-65,0,0,0,0,0),(22364454717488128,103,1022,'Team 22',32,7,3,9.375,2,6.25,27,84.375,-75,0,0,0,0,0),(22364454717488129,103,1023,'Team 23',20,6,4,20,0,0,16,80,-60,0,0,0,0,0),(22364454717488130,103,1024,'Team 24',19,6,2,10.5263,0,0,17,89.4737,-78.9474,0,0,0,0,0),(22364454717488131,103,1026,'Team 26',47,18,13,27.6596,1,2.12766,33,70.2128,-42.5532,0,0,0,0,0),(22364454717488132,103,1027,'Team 27',18,5,4,22.2222,1,5.55556,13,72.2222,-50,0,0,0,0,0),(22364454717488133,103,1028,'Team 28',49,15,10,20.4082,0,0,39,79.5918,-59.1837,0,0,0,0,0),(22364454717488134,103,1030,'Team 30',49,13,6,12.2449,1,2.04082,42,85.7143,-73.4694,0,0,0,0,0),(22364454717488135,104,1031,'Team 31',30,6,8,26.6667,0,0,22,73.3333,-46.6667,0,0,0,0,0),(22364454717488136,104,1032,'Team 32',39,7,9,23.0769,1,2.5641,29,74.359,-51.2821,0,0,0,0,0),(22364454717488137,104,1033,'Team 33',32,14,4,12.5,2,6.25,26,81.25,-68.75,0,0,0,0,0),(22364454717488138,104,1034,'Team 34',15,5,3,20,0,0,12,80,-60,0,0,0,0,0),(22364454717488139,104,1035,'Team 35',19,3,1,5.26316,1,5.26316,17,89.4737,-84.2105,0,0,0,0,0),(22364454717488140,104,1036,'Team 36',31,6,6,19.3548,1,3.22581,24,77.4194,-58.0645,0,0,0,0,0),(22364454717488141,104,1037,'Team 37',31,4,3,9.67742,1,3.22581,27,87.0968,-77.4194,0,0,0,0,0),(22364454717488142,104,1038,'Team 38',13,2,3,23.0769,0,0,10,76.9231,-53.8462,0,0,0,0,0),(22364454717488143,104,1039,'Team 39',18,5,2,11.1111,0,0,16,88.8889,-77.7778,0,0,0,0,0),(22364454717488144,104,1040,'Team 40',53,15,9,16.9811,3,5.66038,41,77.3585,-60.3774,0,0,0,0,0),(22364454717488145,105,1041,'Team 41',30,10,7,23.3333,0,0,23,76.6667,-53.3333,0,0,0,0,0),(22364454717488146,105,1042,'Team 42',40,9,8,20,0,0,32,80,-60,0,0,0,0,0),(22364454717488147,105,1043,'Team 43',61,20,12,19.6721,7,11.4754,42,68.8525,-49.1803,0,0,0,0,0),(22364454717488148,105,1044,'Team 44',37,11,5,13.5135,0,0,32,86.4865,-72.973,0,0,0,0,0),(22364454717488149,105,1045,'Team 45',51,11,12,23.5294,4,7.84314,35,68.6274,-45.098,0,0,0,0,0),(22364454717488150,105,1047,'Team 47',26,8,7,26.9231,2,7.69231,17,65.3846,-38.4615,0,0,0,0,0),(22364454717488151,105,1048,'Team 48',32,6,9,28.125,1,3.125,22,68.75,-40.625,0,0,0,0,0),(22364454717488152,105,1049,'Team 49',42,10,8,19.0476,0,0,34,80.9524,-61.9048,0,0,0,0,0),(22364454717488153,105,1050,'Team 50',81,17,11,13.5802,4,4.93827,66,81.4815,-67.9012,0,0,0,0,0); /*!40000 ALTER TABLE `RawData` ENABLE KEYS */; UNLOCK TABLES; /*!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 2012-04-03 13:50:35