API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 12th, 2018
152
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 137.98 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.16 Distrib 10.1.35-MariaDB, for Win32 (AMD64)
  2. --
  3. -- Host: localhost Database: lighthouse
  4. -- ------------------------------------------------------
  5. -- Server version 10.1.35-MariaDB
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `cbm_data`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `cbm_data`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `cbm_data` (
  26. `diag` varchar(50) DEFAULT NULL,
  27. `obm` int(11) DEFAULT NULL,
  28. `obf` int(11) DEFAULT NULL,
  29. `abmm` int(11) DEFAULT NULL,
  30. `abmf` int(11) DEFAULT NULL,
  31. `abcm` int(11) DEFAULT NULL,
  32. `abcf` int(11) DEFAULT NULL,
  33. `abpm` int(11) DEFAULT NULL,
  34. `abpf` int(11) DEFAULT NULL,
  35. `cdid` int(11) NOT NULL AUTO_INCREMENT,
  36. `paem` int(11) DEFAULT NULL,
  37. `paef` int(11) DEFAULT NULL,
  38. PRIMARY KEY (`cdid`)
  39. ) ENGINE=InnoDB AUTO_INCREMENT=7691 DEFAULT CHARSET=latin1;
  40. /*!40101 SET character_set_client = @saved_cs_client */;
  41.  
  42. --
  43. -- Dumping data for table `cbm_data`
  44. --
  45.  
  46. LOCK TABLES `cbm_data` WRITE;
  47. /*!40000 ALTER TABLE `cbm_data` DISABLE KEYS */;
  48. INSERT INTO `cbm_data` VALUES ('Cataracts 0-1 yr',0,0,0,0,0,0,0,0,6265,0,0),('Cataracts 1-5 yr',0,0,0,0,0,0,0,0,6266,0,0),('Cataracts 6-15 yrs',0,0,0,0,0,0,0,0,6267,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,0,6268,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6269,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6270,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6271,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6272,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6273,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6274,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6275,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6276,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6277,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6278,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6279,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6280,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6281,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6282,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6283,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6284,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6285,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6286,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6287,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6288,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6289,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6290,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6291,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6292,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6293,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6294,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6295,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6296,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6297,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6298,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6299,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6300,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6301,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6302,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6303,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6304,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6305,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6306,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6307,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6308,0,0),('Cataracts 16 yrs & Above',0,2,0,0,0,0,0,0,6309,0,0),('Cataracts 16 yrs & Above',1,0,0,0,0,0,0,0,6310,0,0),('Cataracts 16 yrs & Above',0,1,0,0,0,0,0,0,6311,0,0),('Glaucoma 0-15 yrs',0,0,0,0,0,0,0,0,6312,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,0,6313,0,0),('Glaucoma 16 yrs & Above',1,0,0,0,0,0,0,0,6314,0,0),('Glaucoma 16 yrs & Above',0,1,0,0,0,0,0,0,6315,0,0),('Glaucoma 16 yrs & Above',0,1,0,0,0,0,0,0,6316,0,0),('Glaucoma 16 yrs & Above',1,0,0,0,0,0,0,0,6317,0,0),('Glaucoma 16 yrs & Above',0,1,0,0,0,0,0,0,6318,0,0),('Glaucoma 16 yrs & Above',0,1,0,0,0,0,0,0,6319,0,0),('Glaucoma 16 yrs & Above',0,1,0,0,0,0,0,0,6320,0,0),('Glaucoma 16 yrs & Above',1,0,0,0,0,0,0,0,6321,0,0),('Xerophthalmia 0-15 yrs',0,0,0,0,0,0,0,0,6322,0,0),('Xerophthalmia 16 yrs & Above',0,0,0,0,0,0,0,0,6323,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,0,6324,0,0),('Refraction 0-15 yrs',1,0,0,0,0,0,0,0,6325,0,0),('Refraction 0-15 yrs',0,1,0,0,0,0,0,0,6326,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,0,6327,0,0),('Refraction 16 yrs & Above',1,0,0,0,0,0,0,0,6328,0,0),('Refraction 16 yrs & Above',1,0,0,0,0,0,0,0,6329,0,0),('Refraction 16 yrs & Above',0,1,0,0,0,0,0,0,6330,0,0),('Refraction 16 yrs & Above',0,1,0,0,0,0,0,0,6331,0,0),('Refraction 16 yrs & Above',1,0,0,0,0,0,0,0,6332,0,0),('Trachoma 0-15 yrs',0,0,0,0,0,0,0,0,6333,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,0,6334,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,0,6335,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6336,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6337,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6338,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6339,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6340,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6341,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6342,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6343,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6344,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6345,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6346,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6347,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6348,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6349,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6350,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6351,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6352,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6353,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6354,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6355,0,0),('Others 0-15 yrs',0,1,0,0,0,0,0,0,6356,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6357,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6358,0,0),('Others 0-15 yrs',1,0,0,0,0,0,0,0,6359,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,6360,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6361,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6362,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6363,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6364,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6365,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6366,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6367,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6368,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6369,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6370,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6371,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6372,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6373,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6374,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6375,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6376,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6377,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6378,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6379,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6380,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6381,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6382,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6383,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6384,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6385,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6386,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6387,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6388,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6389,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6390,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6391,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6392,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6393,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6394,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6395,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6396,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6397,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6398,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6399,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6400,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6401,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6402,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6403,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6404,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6405,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6406,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6407,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6408,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6409,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6410,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6411,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6412,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6413,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6414,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6415,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6416,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6417,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6418,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6419,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6420,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6421,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6422,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6423,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6424,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6425,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6426,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6427,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6428,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6429,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6430,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6431,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6432,0,0),('Others 16 yrs & Above',0,1,0,0,0,0,0,0,6433,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6434,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6435,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6436,0,0),('Others 16 yrs & Above',1,0,0,0,0,0,0,0,6437,0,0),('Cataracts 0-1 yr',0,0,0,0,0,1,0,0,6438,0,0),('Cataracts 1-5 yr',0,0,0,0,0,0,1,0,6439,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6440,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6441,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6442,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6443,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6444,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6445,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6446,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6447,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6448,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6449,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6450,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6451,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6452,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6453,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6454,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6455,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6456,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6457,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,0,6458,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6459,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6460,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6461,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6462,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6463,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6464,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6465,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6466,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6467,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6468,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6469,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6470,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6471,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6472,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6473,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6474,0,0),('Cataracts 16 yrs & Above',0,0,1,0,0,0,0,0,6475,0,0),('Cataracts 16 yrs & Above',0,0,1,0,0,0,0,0,6476,0,0),('Cataracts 16 yrs & Above',0,0,2,0,0,0,0,0,6477,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6478,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6479,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6480,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6481,0,0),('Cataracts 16 yrs & Above',0,0,1,0,0,0,0,0,6482,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6483,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6484,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6485,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6486,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,0,6487,0,0),('Cataracts 16 yrs & Above',0,0,1,0,0,0,0,0,6488,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6489,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6490,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6491,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6492,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6493,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6494,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6495,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6496,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6497,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6498,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,1,0,6499,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6500,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6501,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6502,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6503,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6504,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6505,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6506,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6507,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6508,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6509,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6510,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6511,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6512,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6513,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6514,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,2,0,0,6515,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6516,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6517,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6518,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6519,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6520,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6521,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6522,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6523,0,0),('Cataracts 16 yrs & Above',0,0,0,1,0,0,0,0,6524,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6525,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6526,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6527,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6528,0,0),('Cataracts 16 yrs & Above',0,0,0,0,1,0,0,0,6529,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6530,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,1,0,0,6531,0,0),('Cataracts 16 yrs & Above',0,0,0,0,0,0,0,1,6532,0,0),('Glaucoma 0-15 yrs',0,0,0,0,1,0,0,0,6533,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6534,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6535,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6536,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6537,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6538,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6539,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6540,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,0,6541,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6542,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6543,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6544,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6545,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6546,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6547,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6548,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6549,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6550,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,0,6551,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6552,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6553,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6554,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6555,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6556,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6557,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6558,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6559,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6560,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6561,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6562,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6563,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6564,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6565,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6566,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6567,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6568,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6569,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6570,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6571,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6572,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6573,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6574,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6575,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6576,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6577,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6578,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6579,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6580,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6581,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6582,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6583,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6584,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,0,1,6585,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6586,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6587,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6588,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,0,1,0,6589,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6590,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,1,0,0,0,6591,0,0),('Glaucoma 16 yrs & Above',0,0,0,0,0,1,0,0,6592,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6593,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6594,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,1,0,6595,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6596,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6597,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6598,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6599,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6600,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6601,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6602,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6603,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6604,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6605,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6606,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,1,0,6607,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6608,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6609,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6610,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6611,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6612,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,1,0,6613,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6614,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6615,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6616,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6617,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6618,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6619,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6620,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,0,6621,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6622,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6623,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6624,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6625,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6626,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6627,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6628,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6629,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6630,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6631,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6632,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6633,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6634,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6635,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6636,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6637,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6638,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6639,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6640,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6641,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6642,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6643,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6644,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6645,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6646,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6647,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6648,0,0),('Refraction 0-15 yrs',0,0,0,0,0,0,0,1,6649,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6650,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6651,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6652,0,0),('Refraction 0-15 yrs',0,0,1,0,0,0,0,0,6653,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6654,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6655,0,0),('Refraction 0-15 yrs',0,0,0,0,1,0,0,0,6656,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6657,0,0),('Refraction 0-15 yrs',0,0,0,0,0,1,0,0,6658,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6659,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6660,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6661,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6662,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6663,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6664,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6665,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6666,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6667,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6668,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6669,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6670,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6671,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6672,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6673,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6674,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6675,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6676,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6677,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6678,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6679,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6680,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6681,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,0,6682,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6683,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6684,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6685,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6686,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6687,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6688,0,0),('Refraction 16 yrs & Above',0,0,0,0,2,0,0,0,6689,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6690,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6691,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6692,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6693,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6694,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6695,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,0,6696,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6697,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6698,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6699,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6700,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6701,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,0,6702,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6703,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6704,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6705,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6706,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6707,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6708,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6709,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6710,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6711,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6712,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6713,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6714,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6715,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6716,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6717,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6718,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6719,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6720,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6721,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6722,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6723,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6724,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6725,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6726,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6727,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6728,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6729,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6730,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6731,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6732,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6733,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6734,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6735,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6736,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6737,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6738,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6739,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6740,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6741,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6742,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6743,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6744,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6745,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6746,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6747,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6748,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6749,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6750,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6751,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6752,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6753,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,2,0,0,6754,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6755,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6756,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6757,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6758,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6759,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6760,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6761,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6762,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6763,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6764,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6765,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6766,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6767,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6768,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6769,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6770,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6771,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6772,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6773,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6774,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6775,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6776,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6777,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6778,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6779,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6780,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6781,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6782,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6783,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6784,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6785,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6786,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6787,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6788,0,0),('Refraction 16 yrs & Above',0,0,0,0,2,0,0,0,6789,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6790,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6791,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6792,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6793,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6794,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6795,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6796,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6797,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6798,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6799,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6800,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6801,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6802,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6803,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6804,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6805,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6806,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6807,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6808,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,0,1,6809,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6810,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6811,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6812,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6813,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6814,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6815,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6816,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6817,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,0,1,0,6818,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6819,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6820,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6821,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6822,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6823,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6824,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6825,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6826,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6827,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6828,0,0),('Refraction 16 yrs & Above',0,0,0,0,0,1,0,0,6829,0,0),('Refraction 16 yrs & Above',0,0,0,0,1,0,0,0,6830,0,0),('Trachoma 16 yrs & Above',0,0,0,0,0,1,0,0,6831,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6832,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6833,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6834,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6835,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6836,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6837,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6838,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6839,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6840,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6841,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6842,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6843,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6844,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6845,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6846,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6847,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6848,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6849,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6850,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6851,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6852,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6853,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6854,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6855,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6856,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6857,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6858,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6859,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6860,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6861,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6862,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6863,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6864,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6865,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6866,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6867,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6868,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6869,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6870,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6871,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6872,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6873,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6874,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6875,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6876,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6877,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6878,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6879,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6880,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6881,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6882,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6883,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6884,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6885,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6886,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6887,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6888,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6889,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6890,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6891,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6892,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6893,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6894,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6895,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6896,0,0),('Others 0-15 yrs',0,0,0,1,0,0,0,0,6897,0,0),('Others 0-15 yrs',0,0,0,1,0,0,0,0,6898,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6899,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,0,6900,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,0,6901,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,0,6902,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,0,6903,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6904,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6905,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6906,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6907,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6908,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6909,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6910,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6911,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6912,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6913,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6914,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6915,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6916,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6917,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6918,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6919,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6920,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6921,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6922,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6923,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6924,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6925,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6926,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6927,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6928,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6929,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6930,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6931,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6932,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6933,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6934,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6935,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6936,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6937,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6938,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6939,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6940,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6941,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6942,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6943,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6944,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6945,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6946,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6947,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6948,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6949,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6950,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6951,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6952,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6953,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6954,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6955,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6956,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6957,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6958,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6959,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6960,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6961,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6962,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6963,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6964,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6965,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6966,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6967,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6968,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6969,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6970,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6971,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6972,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6973,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6974,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6975,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6976,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6977,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6978,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6979,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6980,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6981,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6982,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6983,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6984,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6985,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6986,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6987,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6988,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6989,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6990,0,0),('Others 0-15 yrs',0,0,0,0,0,0,1,0,6991,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6992,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6993,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6994,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6995,0,0),('Others 0-15 yrs',0,0,0,0,0,0,0,1,6996,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6997,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,6998,0,0),('Others 0-15 yrs',0,0,0,0,0,1,0,0,6999,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,7000,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,7001,0,0),('Others 0-15 yrs',0,0,0,0,1,0,0,0,7002,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7003,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7004,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7005,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7006,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7007,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7008,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7009,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7010,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7011,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7012,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7013,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7014,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7015,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7016,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7017,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7018,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7019,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7020,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7021,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7022,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7023,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7024,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7025,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7026,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7027,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7028,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7029,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7030,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7031,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7032,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7033,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7034,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7035,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7036,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7037,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7038,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7039,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7040,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7041,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7042,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7043,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7044,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7045,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7046,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7047,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7048,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7049,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7050,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7051,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7052,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7053,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7054,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7055,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7056,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7057,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7058,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7059,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7060,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7061,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7062,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7063,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7064,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7065,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7066,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7067,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7068,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7069,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7070,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7071,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7072,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7073,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7074,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7075,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7076,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7077,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7078,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7079,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7080,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7081,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7082,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7083,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7084,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7085,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7086,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7087,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7088,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7089,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7090,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7091,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7092,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7093,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7094,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7095,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7096,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7097,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7098,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7099,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7100,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7101,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7102,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7103,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7104,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7105,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7106,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7107,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7108,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7109,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7110,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7111,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7112,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7113,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7114,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7115,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7116,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7117,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7118,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7119,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7120,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7121,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7122,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7123,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7124,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7125,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7126,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7127,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7128,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7129,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7130,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7131,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7132,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7133,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7134,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7135,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7136,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7137,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7138,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7139,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7140,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7141,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7142,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7143,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7144,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7145,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7146,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7147,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7148,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7149,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7150,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7151,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7152,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7153,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7154,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7155,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7156,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7157,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7158,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7159,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7160,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7161,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7162,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7163,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7164,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7165,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7166,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7167,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7168,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7169,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7170,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7171,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7172,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7173,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7174,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7175,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7176,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7177,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7178,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7179,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7180,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7181,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7182,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7183,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7184,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7185,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7186,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7187,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7188,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7189,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7190,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7191,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7192,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7193,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7194,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7195,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7196,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7197,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7198,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7199,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7200,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7201,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7202,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7203,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7204,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7205,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7206,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7207,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7208,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7209,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7210,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7211,0,0),('Others 16 yrs & Above',0,0,0,0,2,0,0,0,7212,0,0),('Others 16 yrs & Above',0,0,0,0,2,0,0,0,7213,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7214,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7215,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7216,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7217,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7218,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7219,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7220,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7221,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7222,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7223,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7224,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7225,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7226,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7227,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7228,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7229,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7230,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7231,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7232,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7233,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7234,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7235,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7236,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7237,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7238,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7239,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7240,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7241,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7242,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7243,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7244,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7245,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7246,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7247,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7248,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7249,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7250,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7251,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7252,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7253,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7254,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7255,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7256,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7257,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7258,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7259,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7260,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7261,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7262,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7263,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7264,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7265,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7266,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7267,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7268,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7269,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7270,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7271,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7272,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7273,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7274,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7275,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7276,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7277,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7278,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7279,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7280,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7281,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7282,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7283,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7284,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7285,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7286,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7287,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7288,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7289,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7290,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7291,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7292,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7293,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7294,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7295,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7296,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7297,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7298,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7299,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7300,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7301,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7302,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7303,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7304,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7305,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7306,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7307,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7308,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7309,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7310,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7311,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7312,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7313,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7314,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7315,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7316,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7317,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7318,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7319,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7320,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7321,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7322,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7323,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7324,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,0,7325,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7326,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7327,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7328,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7329,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7330,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7331,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7332,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7333,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7334,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7335,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7336,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7337,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7338,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7339,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7340,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7341,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7342,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7343,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7344,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7345,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7346,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7347,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7348,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7349,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7350,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7351,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7352,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7353,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7354,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7355,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7356,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7357,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7358,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7359,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7360,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7361,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7362,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7363,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7364,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7365,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7366,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7367,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7368,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7369,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7370,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7371,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7372,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7373,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7374,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7375,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7376,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7377,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7378,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7379,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7380,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7381,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7382,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7383,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7384,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7385,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7386,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7387,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7388,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7389,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7390,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7391,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7392,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7393,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7394,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7395,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7396,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7397,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7398,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7399,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7400,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7401,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7402,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7403,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7404,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7405,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7406,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7407,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7408,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7409,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7410,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7411,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7412,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7413,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7414,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7415,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7416,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7417,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7418,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7419,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7420,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7421,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7422,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7423,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7424,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7425,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7426,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7427,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7428,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7429,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7430,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7431,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7432,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7433,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7434,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7435,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7436,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7437,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7438,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7439,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7440,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7441,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7442,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7443,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7444,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7445,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7446,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7447,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7448,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7449,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7450,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7451,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7452,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7453,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7454,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7455,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7456,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7457,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7458,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7459,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7460,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7461,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7462,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7463,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7464,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7465,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7466,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7467,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7468,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7469,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7470,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7471,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7472,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7473,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7474,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7475,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7476,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7477,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7478,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7479,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7480,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7481,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7482,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7483,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7484,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7485,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7486,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7487,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7488,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7489,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7490,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7491,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7492,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7493,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7494,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7495,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7496,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7497,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7498,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7499,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7500,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7501,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7502,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7503,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7504,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7505,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7506,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7507,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7508,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7509,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7510,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7511,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7512,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7513,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7514,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7515,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7516,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7517,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7518,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7519,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7520,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7521,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7522,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7523,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7524,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7525,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7526,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7527,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7528,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7529,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7530,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7531,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7532,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7533,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7534,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7535,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7536,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7537,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7538,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7539,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7540,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7541,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7542,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7543,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7544,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7545,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7546,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7547,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7548,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7549,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7550,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7551,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7552,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7553,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7554,0,0),('Others 16 yrs & Above',0,0,0,0,0,2,0,0,7555,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7556,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7557,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7558,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7559,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7560,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7561,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7562,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7563,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7564,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7565,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7566,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7567,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7568,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7569,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7570,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7571,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7572,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7573,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7574,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7575,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7576,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7577,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7578,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7579,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7580,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7581,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7582,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7583,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7584,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7585,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7586,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7587,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7588,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7589,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7590,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7591,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7592,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7593,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7594,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7595,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7596,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7597,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7598,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7599,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7600,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7601,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7602,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7603,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7604,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7605,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7606,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7607,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7608,0,0),('Others 16 yrs & Above',0,0,0,1,0,0,0,0,7609,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7610,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7611,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7612,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7613,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7614,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7615,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7616,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7617,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7618,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7619,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7620,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7621,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7622,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7623,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7624,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7625,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7626,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7627,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7628,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7629,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7630,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7631,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7632,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7633,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7634,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7635,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7636,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7637,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7638,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7639,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7640,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7641,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7642,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7643,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7644,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7645,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7646,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7647,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7648,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7649,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7650,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7651,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7652,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7653,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7654,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7655,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7656,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7657,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7658,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7659,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7660,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,1,0,7661,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7662,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7663,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7664,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7665,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7666,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7667,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7668,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7669,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7670,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7671,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7672,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7673,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7674,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7675,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7676,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7677,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7678,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7679,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7680,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7681,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7682,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7683,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7684,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7685,0,0),('Others 16 yrs & Above',0,0,0,0,0,0,0,1,7686,0,0),('Others 16 yrs & Above',0,0,0,0,1,0,0,0,7687,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7688,0,0),('Others 16 yrs & Above',0,0,0,0,0,1,0,0,7689,0,0),('Others 16 yrs & Above',0,0,1,0,0,0,0,0,7690,0,0);
  49. /*!40000 ALTER TABLE `cbm_data` ENABLE KEYS */;
  50. UNLOCK TABLES;
  51.  
  52. --
  53. -- Table structure for table `chaplain`
  54. --
  55.  
  56. DROP TABLE IF EXISTS `chaplain`;
  57. /*!40101 SET @saved_cs_client = @@character_set_client */;
  58. /*!40101 SET character_set_client = utf8 */;
  59. CREATE TABLE `chaplain` (
  60. `id` int(9) NOT NULL AUTO_INCREMENT,
  61. `pid` int(9) NOT NULL,
  62. `religion` int(9) DEFAULT NULL,
  63. `baptised` int(9) DEFAULT NULL,
  64. `pastor` int(9) DEFAULT NULL,
  65. `remarks` text,
  66. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  67. PRIMARY KEY (`id`)
  68. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  69. /*!40101 SET character_set_client = @saved_cs_client */;
  70.  
  71. --
  72. -- Dumping data for table `chaplain`
  73. --
  74.  
  75. LOCK TABLES `chaplain` WRITE;
  76. /*!40000 ALTER TABLE `chaplain` DISABLE KEYS */;
  77. INSERT INTO `chaplain` VALUES (4,25,202,138,1,'jakafiri','2018-11-10 08:06:32');
  78. /*!40000 ALTER TABLE `chaplain` ENABLE KEYS */;
  79. UNLOCK TABLES;
  80.  
  81. --
  82. -- Table structure for table `chat`
  83. --
  84.  
  85. DROP TABLE IF EXISTS `chat`;
  86. /*!40101 SET @saved_cs_client = @@character_set_client */;
  87. /*!40101 SET character_set_client = utf8 */;
  88. CREATE TABLE `chat` (
  89. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  90. `from_` varchar(32) DEFAULT NULL,
  91. `to_` varchar(32) DEFAULT NULL,
  92. `message` text NOT NULL,
  93. `sent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  94. `recd` int(10) unsigned NOT NULL DEFAULT '0',
  95. `date` datetime DEFAULT CURRENT_TIMESTAMP,
  96. PRIMARY KEY (`id`),
  97. KEY `to` (`to_`),
  98. KEY `from` (`from_`)
  99. ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
  100. /*!40101 SET character_set_client = @saved_cs_client */;
  101.  
  102. --
  103. -- Dumping data for table `chat`
  104. --
  105.  
  106. LOCK TABLES `chat` WRITE;
  107. /*!40000 ALTER TABLE `chat` DISABLE KEYS */;
  108. INSERT INTO `chat` VALUES (1,'8','2','hello 40','2018-11-09 14:54:14',1,'2018-11-09 17:54:14'),(2,'8','2','tqalk a talka','2018-11-09 14:54:53',0,'2018-11-09 17:54:53'),(3,'8','9','omera','2018-11-09 15:01:14',0,'2018-11-09 18:01:14'),(4,'8','9','wachane','2018-11-09 15:02:22',0,'2018-11-09 18:02:22'),(5,'8','1','un kanye jowa','2018-11-09 15:02:44',1,'2018-11-09 18:02:44'),(6,'8','4','un kanye jowa','2018-11-09 15:02:44',0,'2018-11-09 18:02:44'),(7,'8','5','un kanye jowa','2018-11-09 15:02:44',0,'2018-11-09 18:02:44'),(8,'1','6','Admin TEst','2018-11-09 15:03:21',1,'2018-11-09 18:03:21'),(9,'8','1','admin omera','2018-11-09 15:04:31',1,'2018-11-09 18:04:31'),(10,'8','1','Lorem ipsum dolor sit amet consectetur adipisicing elit. Sed, quidem?','2018-11-09 15:55:35',1,'2018-11-09 18:55:35'),(11,'6','8','To aje admin','2018-11-09 17:20:44',0,'2018-11-09 20:20:44'),(12,'6','8','chal nade admin','2018-11-09 17:22:07',0,'2018-11-09 20:22:07'),(13,'6','1','chal o nade','2018-11-09 17:22:31',1,'2018-11-09 20:22:31'),(14,'1','8','niko budah','2018-11-09 18:40:56',0,'2018-11-09 21:40:56'),(15,'6','1','kendo','2018-11-09 19:49:48',1,'2018-11-09 22:49:48'),(16,'1','8','itest ango?','2018-11-09 21:14:24',0,'2018-11-10 00:14:24'),(17,'1','6','ango matestre?','2018-11-09 21:14:51',0,'2018-11-10 00:14:51'),(18,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 22:51:21',0,'2018-11-11 01:51:21'),(19,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:01:22',0,'2018-11-11 02:01:22'),(20,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:09:22',0,'2018-11-11 02:09:22'),(21,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:10:03',0,'2018-11-11 02:10:03'),(22,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:12:56',0,'2018-11-11 02:12:56'),(23,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:14:31',0,'2018-11-11 02:14:31'),(24,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:33:13',0,'2018-11-11 02:33:13'),(25,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:36:59',0,'2018-11-11 02:36:59'),(26,'1','skylark_stores','product#x4 (Iphone) is at critical','2018-11-10 23:37:19',0,'2018-11-11 02:37:19');
  109. /*!40000 ALTER TABLE `chat` ENABLE KEYS */;
  110. UNLOCK TABLES;
  111.  
  112. --
  113. -- Table structure for table `dataconf`
  114. --
  115.  
  116. DROP TABLE IF EXISTS `dataconf`;
  117. /*!40101 SET @saved_cs_client = @@character_set_client */;
  118. /*!40101 SET character_set_client = utf8 */;
  119. CREATE TABLE `dataconf` (
  120. `id` int(9) NOT NULL AUTO_INCREMENT,
  121. `a` varchar(32) DEFAULT NULL,
  122. `b` varchar(32) DEFAULT NULL,
  123. `c` varchar(32) DEFAULT NULL,
  124. `d` varchar(32) DEFAULT NULL,
  125. PRIMARY KEY (`id`)
  126. ) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=latin1;
  127. /*!40101 SET character_set_client = @saved_cs_client */;
  128.  
  129. --
  130. -- Dumping data for table `dataconf`
  131. --
  132.  
  133. LOCK TABLES `dataconf` WRITE;
  134. /*!40000 ALTER TABLE `dataconf` DISABLE KEYS */;
  135. INSERT INTO `dataconf` VALUES (1,'patient_type','General',NULL,NULL),(2,'patient_type','Private',NULL,NULL),(3,'gender','Male',NULL,NULL),(4,'gender','female',NULL,NULL),(38,'usertype','Reception/Nurse/Doctor',NULL,NULL),(39,'usertype','Resident Doctor',NULL,NULL),(44,'usertype','Theatre',NULL,NULL),(53,'usertype','Laboratory',NULL,NULL),(59,'usertype','Optical Shop',NULL,NULL),(60,'usertype','Pharmacist',NULL,NULL),(68,'usertype','Others',NULL,NULL),(69,'usertype','Administrator',NULL,NULL),(91,'usertype','Reception',NULL,NULL),(92,'payment_method','mpesa',NULL,NULL),(93,'payment_method','cash',NULL,NULL),(94,'payment_method','insurance',NULL,NULL),(95,'optical_cat','ANTIGLARE',NULL,NULL),(96,'optical_cat','PLASTIC PHOTO CYLINDER',NULL,NULL),(97,'optical_cat','PLASTIC CLEAR SPHERE',NULL,NULL),(98,'optical_cat','PLASTIC CLEAR CYLINDER',NULL,NULL),(99,'optical_cat','GLASS PHOTO SPHERE',NULL,NULL),(100,'optical_cat','GLASS CLEAR SPHERE',NULL,NULL),(101,'optical_cat','GLASS PHOTO CYLINDER',NULL,NULL),(102,'optical_cat','GLASS CLEAR CYLINDER',NULL,NULL),(103,'optical_cat','CRUXITE- TINTED',NULL,NULL),(104,'optical_cat','CRUXITE-TINTED CYLINDER',NULL,NULL),(105,'optical_cat','HARDCASE',NULL,NULL),(106,'optical_cat','LEATHERCASE',NULL,NULL),(107,'optical_cat','PLASTIC FRAMES',NULL,NULL),(108,'optical_cat','METAL FRAMES',NULL,NULL),(109,'optical_cat','DESIGNER FRAMES',NULL,NULL),(110,'optical_cat','USA FRAMES',NULL,NULL),(111,'optical_cat','KIDS USA',NULL,NULL),(112,'optical_cat','SUN GLASSES',NULL,NULL),(113,'optical_cat','STRAPS',NULL,NULL),(114,'optical_cat','CLOTH',NULL,NULL),(115,'optical_cat','PENCASE ',NULL,NULL),(116,'optical_cat','POSTOP SUNGLASSES PRIVATE',NULL,NULL),(117,'optical_cat','POSTOP SUNGLASSES GENERAL ',NULL,NULL),(118,'optical_cat','ARTIFICIAL EYES - ADULTS',NULL,NULL),(119,'optical_cat','ARTIFICIAL EYES - CHILDREN',NULL,NULL),(120,'optical_cat','NC CASES',NULL,NULL),(121,'optical_cat','PLASTIC USA',NULL,NULL),(122,'optical_cat','MOBILE NC',NULL,NULL),(123,'optical_cat','USA KIDS PLASTIC',NULL,NULL),(124,'optical_cat','SPECTS KIDS FRAMES',NULL,NULL),(125,'optical_cat','READERS',NULL,NULL),(126,'lens_type','photocromatic_glass',NULL,NULL),(127,'lens_type','photocromatic_plastic',NULL,NULL),(128,'lens_type','bifocal_glass',NULL,NULL),(129,'lens_type','bifocal_plastic',NULL,NULL),(130,'lens_type','progressive_glass',NULL,NULL),(131,'lens_type','progressive_plastic',NULL,NULL),(132,'lens_type','clear_glass',NULL,NULL),(133,'lens_type','clear_plastic',NULL,NULL),(134,'upcharge','children',NULL,NULL),(135,'upcharge','simple',NULL,NULL),(136,'upcharge','designer',NULL,NULL),(137,'upcharge','donation',NULL,NULL),(138,'yesno','YES',NULL,NULL),(139,'yesno','NO',NULL,NULL),(140,'qtype','screeningq',NULL,NULL),(141,'qtype','chaplainq',NULL,NULL),(142,'qtype','refractionq',NULL,NULL),(143,'qtype','theatreq',NULL,NULL),(144,'qtype','pharmacyq',NULL,NULL),(145,'qtype','opticalq',NULL,NULL),(146,'qtype','cashierq',NULL,NULL),(147,'group_cat','skylark_doctor',NULL,NULL),(149,'group_cat','skylark_cashier',NULL,NULL),(150,'group_cat','skylark_pharmacy',NULL,NULL),(151,'group_cat','skylark_theatre',NULL,NULL),(152,'group_cat','skylark_finance',NULL,NULL),(156,'groupstore','undefined','undefined',NULL),(157,'groupstore','undefined','undefined',NULL),(158,'groupstore','undefined','undefined',NULL),(159,'groupstore','undefined','undefined',NULL),(160,'groupstore','150','10',NULL),(168,'groupstore','150','13',NULL),(170,'groupstore','150','19',NULL),(172,'groupstore','171','2',NULL),(173,'groupstore','171','5',NULL),(174,'groupstore','171','13',NULL),(177,'groupstore','147','13',NULL),(178,'groupstore','147','2',NULL),(180,'groupstore','147','5',NULL),(181,'groupstore','149','2',NULL),(182,'groupstore','149','5',NULL),(183,'groupstore','149','13',NULL),(184,'groupstore','149','11',NULL),(185,'groupstore','149','10',NULL),(186,'groupstore','149','18',NULL),(187,'group_cat','skylark_screening',NULL,NULL),(188,'groupstore','187','11',NULL),(189,'groupstore','187','1',NULL),(190,'groupstore','147','1',NULL),(191,'groupstore','148','1',NULL),(192,'groupstore','149','1',NULL),(193,'groupstore','150','1',NULL),(194,'groupstore','151','1',NULL),(195,'groupstore','152','1',NULL),(196,'group_cat','skylark_optical',NULL,NULL),(197,'group_cat','skylark_chaplain',NULL,NULL),(198,'groupstore','197','1',NULL),(199,'groupstore','197','20',NULL),(201,NULL,'christian',NULL,NULL),(202,'religion','muslims',NULL,NULL),(203,NULL,'christian',NULL,NULL),(204,NULL,'xtian',NULL,NULL),(205,'religion','christian',NULL,NULL),(206,'group_cat','skylark_stores',NULL,NULL),(207,'groupstore','206','1',NULL),(209,'groupstore','206','20',NULL);
  136. /*!40000 ALTER TABLE `dataconf` ENABLE KEYS */;
  137. UNLOCK TABLES;
  138.  
  139. --
  140. -- Table structure for table `datalog`
  141. --
  142.  
  143. DROP TABLE IF EXISTS `datalog`;
  144. /*!40101 SET @saved_cs_client = @@character_set_client */;
  145. /*!40101 SET character_set_client = utf8 */;
  146. CREATE TABLE `datalog` (
  147. `id` int(9) NOT NULL AUTO_INCREMENT,
  148. `userid` int(9) NOT NULL,
  149. `operation` varchar(100) DEFAULT NULL,
  150. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  151. `host` varchar(50) DEFAULT NULL,
  152. PRIMARY KEY (`id`)
  153. ) ENGINE=InnoDB AUTO_INCREMENT=335 DEFAULT CHARSET=latin1;
  154. /*!40101 SET character_set_client = @saved_cs_client */;
  155.  
  156. --
  157. -- Dumping data for table `datalog`
  158. --
  159.  
  160. LOCK TABLES `datalog` WRITE;
  161. /*!40000 ALTER TABLE `datalog` DISABLE KEYS */;
  162. INSERT INTO `datalog` VALUES (283,1,'access on admin dashboard','2018-11-09 23:03:04','violet'),(284,1,'New Record created on dataconf','2018-11-09 23:38:09','violet'),(285,1,'New Record created on dataconf','2018-11-09 23:51:31','violet'),(286,1,'logged in to the system','2018-11-10 05:38:17','violet'),(287,1,'logged in to the system','2018-11-10 05:38:18','violet'),(288,6,'logged in to the system','2018-11-10 06:14:07','violet'),(289,6,'access on admin dashboard','2018-11-10 06:14:12','violet'),(290,1,'Update of Record 202 on dataconf','2018-11-10 06:45:40','violet'),(291,1,'New Record created on dataconf','2018-11-10 06:46:35','violet'),(292,1,'New Record created on dataconf','2018-11-10 06:57:09','violet'),(293,1,'New Record created on dataconf','2018-11-10 06:57:57','violet'),(294,1,'Update of Record 205 on dataconf','2018-11-10 07:16:58','violet'),(295,1,'New Record created on chaplain','2018-11-10 07:47:15','violet'),(296,1,'New Record created on chaplain','2018-11-10 07:50:17','violet'),(297,1,'New Record created on chaplain','2018-11-10 07:51:12','violet'),(298,1,'New Record created on chaplain','2018-11-10 08:06:37','violet'),(299,1,'Update of Record 4 on chaplain','2018-11-10 08:07:00','violet'),(300,1,'logged in to the system','2018-11-10 15:32:58','violet'),(301,6,'logged in to the system','2018-11-10 15:40:06','violet'),(302,1,'1 items totalling KES15.00 with reference number 86785492 was purchased','2018-11-10 17:19:29','violet'),(304,1,'350 quantities of lpo120 was removed from stock\r\n Reason: stolen','2018-11-10 19:20:51','violet'),(305,1,'40 quantities of lpo120 was removed from stock\r\n Reason: transfered to mobile clinic','2018-11-10 19:21:36','violet'),(306,1,'Details of item with code \'x4\' was updated','2018-11-10 19:46:02','violet'),(307,1,'Details of item with code \'x4\' was updated','2018-11-10 21:25:01','violet'),(308,1,'Details of item with code \'x4\' was updated','2018-11-10 21:27:11','violet'),(309,1,'Details of item with code \'x4\' was updated','2018-11-10 21:28:09','violet'),(310,1,'Details of item with code \'x4\' was updated','2018-11-10 21:28:24','violet'),(311,1,'Details of item with code \'x4\' was updated','2018-11-10 21:29:36','violet'),(312,1,'30 quantities of Iphone was added to stock\r\n Reason: New items were purchased','2018-11-10 22:46:31','violet'),(313,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 22:47:11','violet'),(314,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 22:51:26','violet'),(315,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:01:27','violet'),(316,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:09:27','violet'),(317,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:10:08','violet'),(318,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:13:01','violet'),(319,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:14:35','violet'),(320,1,'35 quantities of Iphone was removed from stock\r\n Reason: lost','2018-11-10 23:29:51','violet'),(321,1,'300 quantities of Iphone was added to stock\r\n Reason: New items were purchased','2018-11-10 23:30:32','violet'),(322,1,'50 quantities of Iphone was removed from stock\r\n Reason: adas','2018-11-10 23:31:48','violet'),(323,1,'1 quantities of Iphone was removed from stock\r\n Reason: as','2018-11-10 23:33:13','violet'),(324,1,'1 quantities of Iphone was removed from stock\r\n Reason: as','2018-11-10 23:36:58','violet'),(325,1,'1 quantities of Iphone was removed from stock\r\n Reason: sada','2018-11-10 23:37:19','violet'),(326,6,'logged in to the system','2018-11-10 23:45:07','violet'),(327,1,'logging out','2018-11-11 01:24:19','violet'),(328,1,'logged in to the system','2018-11-11 01:24:26','violet'),(329,1,'logged in to the system','2018-11-11 09:55:34','violet'),(330,1,'Update of Record 4 on chaplain','2018-11-11 11:46:16','violet'),(331,1,'Update of Record 4 on chaplain','2018-11-11 11:49:52','violet'),(332,1,'Update of Record 4 on chaplain','2018-11-11 11:55:35','violet'),(333,1,'logged in to the system','2018-11-11 22:53:14','violet'),(334,1,'logged in to the system','2018-11-12 06:28:41','violet');
  163. /*!40000 ALTER TABLE `datalog` ENABLE KEYS */;
  164. UNLOCK TABLES;
  165.  
  166. --
  167. -- Table structure for table `diag`
  168. --
  169.  
  170. DROP TABLE IF EXISTS `diag`;
  171. /*!40101 SET @saved_cs_client = @@character_set_client */;
  172. /*!40101 SET character_set_client = utf8 */;
  173. CREATE TABLE `diag` (
  174. `id` int(9) NOT NULL AUTO_INCREMENT,
  175. `lids_os` varchar(32) DEFAULT NULL,
  176. `lids_od` varchar(32) DEFAULT NULL,
  177. `conjuvtiva_os` varchar(32) DEFAULT NULL,
  178. `conjuvtiva_od` varchar(32) DEFAULT NULL,
  179. `lens_os` varchar(32) DEFAULT NULL,
  180. `lens_od` varchar(32) DEFAULT NULL,
  181. `cornea_os` varchar(32) DEFAULT NULL,
  182. `cornea_od` varchar(32) DEFAULT NULL,
  183. `iris_os` varchar(32) DEFAULT NULL,
  184. `iris_od` varchar(32) DEFAULT NULL,
  185. `pupil_os` varchar(32) DEFAULT NULL,
  186. `pupil_od` varchar(32) DEFAULT NULL,
  187. `retina_os` varchar(32) DEFAULT NULL,
  188. `retina_od` varchar(32) DEFAULT NULL,
  189. `docid` int(9) DEFAULT NULL,
  190. `notes` text,
  191. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  192. PRIMARY KEY (`id`)
  193. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  194. /*!40101 SET character_set_client = @saved_cs_client */;
  195.  
  196. --
  197. -- Dumping data for table `diag`
  198. --
  199.  
  200. LOCK TABLES `diag` WRITE;
  201. /*!40000 ALTER TABLE `diag` DISABLE KEYS */;
  202. /*!40000 ALTER TABLE `diag` ENABLE KEYS */;
  203. UNLOCK TABLES;
  204.  
  205. --
  206. -- Table structure for table `eventlog`
  207. --
  208.  
  209. DROP TABLE IF EXISTS `eventlog`;
  210. /*!40101 SET @saved_cs_client = @@character_set_client */;
  211. /*!40101 SET character_set_client = utf8 */;
  212. CREATE TABLE `eventlog` (
  213. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  214. `event` varchar(200) NOT NULL,
  215. `eventRowIdOrRef` varchar(20) DEFAULT NULL,
  216. `eventDesc` text,
  217. `eventTable` varchar(20) DEFAULT NULL,
  218. `staffInCharge` bigint(20) unsigned NOT NULL,
  219. `eventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  220. PRIMARY KEY (`id`)
  221. ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
  222. /*!40101 SET character_set_client = @saved_cs_client */;
  223.  
  224. --
  225. -- Dumping data for table `eventlog`
  226. --
  227.  
  228. LOCK TABLES `eventlog` WRITE;
  229. /*!40000 ALTER TABLE `eventlog` DISABLE KEYS */;
  230. INSERT INTO `eventlog` VALUES (1,'Creation of new item','1','Addition of 100 quantities of a new item \'IUahdis\' with a unit price of &#8358;10.00 to stock','items',1,'2018-10-17 09:08:43'),(2,'Creation of new item','2','Addition of 1000 quantities of a new item \'Retrolux\' with a unit price of &#8358;100.00 to stock','items',1,'2018-10-17 09:09:43'),(3,'Stock Update (New Stock)','2','<p>100 quantities of Retrolux was added to stock</p>\r\n Reason: <p>New items were purchased</p>','items',1,'2018-10-17 09:35:40'),(4,'Stock Update (Deficit)','2','<p>300 quantities of Retrolux was removed from stock</p>\r\n Reason: <p>to mobile clinic</p>','items',1,'2018-10-17 09:36:25'),(5,'Creation of new region','1','New addition of region:general','Cusomer Region',1,'2018-10-17 10:12:24'),(6,'Creation of new group','1','New addition of product group dfsd','product group',1,'2018-10-17 17:11:43'),(7,'Group Info Update','1','Details of item with code \'1\' was updated','product group',1,'2018-10-17 17:37:16'),(8,'Region Info Update','1','Details of item with code \'1\' was updated','Customer Region',1,'2018-10-18 08:52:21'),(9,'Creation of new priority','1','New addition of priority:HIGH','priority',1,'2018-10-18 08:54:10'),(10,'Creation of new priority','2','New addition of priority:LOW','priority',1,'2018-10-18 08:54:18'),(11,'Creation of new customer','1','New addition of customer:AMIR SHAH','Customer',1,'2018-10-18 08:59:38'),(12,'New Transaction','1501640','1 items totalling &#8358;1,500.00 with reference number 1501640 was purchased','transactions',1,'2018-10-18 09:09:24'),(13,'Creation of new product','1','New addition of product:Boild','product',1,'2018-10-18 09:13:09'),(14,'Group Info Update','1','Details of item with code \'1\' was updated','product group',1,'2018-10-18 09:17:14'),(15,'Creation of new priority','1','New addition of platform:Off Shelf','Platform',1,'2018-10-18 09:26:46'),(16,'Creation of new item','19','Addition of 344 quantities of a new item \\\'Sels\\\' with a unit price of &#8358;23.00 to stock','items',0,'2018-10-18 23:53:17'),(17,'Creation of new item','20','Addition of 250 quantities of a new item \\\'Sam 121\\\' with a unit price of &#8358;15.00 to stock','items',0,'2018-10-18 23:56:43'),(18,'Creation of new item','21','Addition of 250 quantities of a new item \\\'Sam 122\\\' with a unit price of &#8358;15.00 to stock','items',0,'2018-10-18 23:58:09'),(19,'Creation of new item','22','Addition of 250 quantities of a new item \\\'Sam 123\\\' with a unit price of &#8358;15.00 to stock','items',0,'2018-10-18 23:58:26'),(20,'Creation of new item','23','Addition of 100 quantities of a new item \\\'pf120\\\' with a unit price of &#8358;10.00 to stock','items',0,'2018-10-19 00:03:50'),(21,'Creation of new item','24','Addition of 200 quantities of a new item \\\'lp130\\\' with a unit price of &#8358;14.00 to stock','items',0,'2018-10-19 00:05:59'),(22,'Creation of new item','25','Addition of 400 quantities of a new item \\\'lpo120\\\' with a unit price of &#8358;35.00 to stock','items',0,'2018-10-19 00:11:44'),(23,'New Transaction','7268852','1 items totalling &#8358;75.00 with reference number 7268852 was purchased','transactions',1,'2018-10-19 08:25:35'),(24,'New Transaction','8615293','2 items totalling &#8358;325.00 with reference number 8615293 was purchased','transactions',1,'2018-10-19 08:30:37'),(25,'New Transaction','796746592','1 items totalling KES180.00 with reference number 796746592 was purchased','transactions',1,'2018-10-20 08:28:09'),(26,'Stock Update (Deficit)','24','<p>10 quantities of lp130 was removed from stock</p>\r\n Reason: <p>sent to mobile camp</p>','items',0,'2018-10-20 08:39:05'),(27,'New Transaction','351480369','1 items totalling KES200.00 with reference number 351480369 was purchased','transactions',1,'2018-10-23 15:09:53'),(28,'Creation of new item','26','Addition of 20 quantities of a new item \\\'Iphone\\\' with a unit price of KES23,000.00 to stock','items',0,'2018-11-10 16:04:32'),(29,'New Transaction','739241697','1 items totalling KES46,000.00 with reference number 739241697 was purchased','transactions',1,'2018-11-10 16:11:21'),(30,'New Transaction','49079715','1 items totalling KES45.00 with reference number 49079715 was purchased','transactions',1,'2018-11-10 17:13:41'),(31,'New Transaction','86785492','1 items totalling KES15.00 with reference number 86785492 was purchased','transactions',1,'2018-11-10 17:19:29'),(32,'Stock Update (Deficit)','25','<p>350 quantities of lpo120 was removed from stock</p>\r\n Reason: <p>stolen</p>','items',1,'2018-11-10 19:20:51'),(33,'Stock Update (Deficit)','25','<p>40 quantities of lpo120 was removed from stock</p>\r\n Reason: <p>transfered to mobile clinic</p>','items',1,'2018-11-10 19:21:36'),(34,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 19:46:02'),(35,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 21:25:01'),(36,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 21:27:11'),(37,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 21:28:09'),(38,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 21:28:24'),(39,'Item Update','26','Details of item with code \'x4\' was updated','items',1,'2018-11-10 21:29:36'),(40,'Stock Update (New Stock)','26','<p>30 quantities of Iphone was added to stock</p>\r\n Reason: <p>New items were purchased</p>','items',1,'2018-11-10 22:46:31'),(41,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 22:47:11'),(42,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 22:51:26'),(43,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:01:27'),(44,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:09:27'),(45,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:10:08'),(46,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:13:01'),(47,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:14:35'),(48,'Stock Update (Deficit)','26','<p>35 quantities of Iphone was removed from stock</p>\r\n Reason: <p>lost</p>','items',1,'2018-11-10 23:29:51'),(49,'Stock Update (New Stock)','26','<p>300 quantities of Iphone was added to stock</p>\r\n Reason: <p>New items were purchased</p>','items',1,'2018-11-10 23:30:32'),(50,'Stock Update (Deficit)','26','<p>50 quantities of Iphone was removed from stock</p>\r\n Reason: <p>adas</p>','items',1,'2018-11-10 23:31:48'),(51,'Stock Update (Deficit)','26','<p>1 quantities of Iphone was removed from stock</p>\r\n Reason: <p>as</p>','items',1,'2018-11-10 23:33:13'),(52,'Stock Update (Deficit)','26','<p>1 quantities of Iphone was removed from stock</p>\r\n Reason: <p>as</p>','items',1,'2018-11-10 23:36:58'),(53,'Stock Update (Deficit)','26','<p>1 quantities of Iphone was removed from stock</p>\r\n Reason: <p>sada</p>','items',1,'2018-11-10 23:37:19');
  231. /*!40000 ALTER TABLE `eventlog` ENABLE KEYS */;
  232. UNLOCK TABLES;
  233.  
  234. --
  235. -- Table structure for table `groups`
  236. --
  237.  
  238. DROP TABLE IF EXISTS `groups`;
  239. /*!40101 SET @saved_cs_client = @@character_set_client */;
  240. /*!40101 SET character_set_client = utf8 */;
  241. CREATE TABLE `groups` (
  242. `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  243. `name` varchar(20) NOT NULL,
  244. `description` varchar(100) NOT NULL,
  245. PRIMARY KEY (`id`)
  246. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
  247. /*!40101 SET character_set_client = @saved_cs_client */;
  248.  
  249. --
  250. -- Dumping data for table `groups`
  251. --
  252.  
  253. LOCK TABLES `groups` WRITE;
  254. /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
  255. INSERT INTO `groups` VALUES (1,'admin','Administrators only'),(2,'members','General User'),(5,'doctor','doctor'),(6,'laboratory','Laboratory'),(7,'nurse','nurse'),(8,'optical_shop','Optical Shop'),(10,'pharmacy','Pharmacist'),(11,'reception','Reception'),(13,'resident_doctor','Resident Doctor'),(15,'theatre','Theatre'),(18,'ict','IT support group'),(19,'cashier','invoicing products & services'),(20,'chaplain','counseling etc.');
  256. /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
  257. UNLOCK TABLES;
  258. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  259. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  260. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  261. /*!50003 SET character_set_client = cp850 */ ;
  262. /*!50003 SET character_set_results = cp850 */ ;
  263. /*!50003 SET collation_connection = cp850_general_ci */ ;
  264. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  265. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  266. DELIMITER ;;
  267. /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger lower_name before insert on groups for each row begin set new.name = lcase(new.name); end */;;
  268. DELIMITER ;
  269. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  270. /*!50003 SET character_set_client = @saved_cs_client */ ;
  271. /*!50003 SET character_set_results = @saved_cs_results */ ;
  272. /*!50003 SET collation_connection = @saved_col_connection */ ;
  273. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  274. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  275. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  276. /*!50003 SET character_set_client = cp850 */ ;
  277. /*!50003 SET character_set_results = cp850 */ ;
  278. /*!50003 SET collation_connection = cp850_general_ci */ ;
  279. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  280. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  281. DELIMITER ;;
  282. /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger secure_group after insert on groups for each row begin insert into users_groups (user_id, group_id) values(1, new.id); end */;;
  283. DELIMITER ;
  284. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  285. /*!50003 SET character_set_client = @saved_cs_client */ ;
  286. /*!50003 SET character_set_results = @saved_cs_results */ ;
  287. /*!50003 SET collation_connection = @saved_col_connection */ ;
  288. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  289. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  290. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  291. /*!50003 SET character_set_client = cp850 */ ;
  292. /*!50003 SET character_set_results = cp850 */ ;
  293. /*!50003 SET collation_connection = cp850_general_ci */ ;
  294. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  295. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  296. DELIMITER ;;
  297. /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger protect_admin before delete on groups for each row begin if old.id = 1 then signal sqlstate "45000" set message_text = "Base group protected by admin"; end if; end */;;
  298. DELIMITER ;
  299. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  300. /*!50003 SET character_set_client = @saved_cs_client */ ;
  301. /*!50003 SET character_set_results = @saved_cs_results */ ;
  302. /*!50003 SET collation_connection = @saved_col_connection */ ;
  303.  
  304. --
  305. -- Table structure for table `items`
  306. --
  307.  
  308. DROP TABLE IF EXISTS `items`;
  309. /*!40101 SET @saved_cs_client = @@character_set_client */;
  310. /*!40101 SET character_set_client = utf8 */;
  311. CREATE TABLE `items` (
  312. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  313. `name` varchar(50) NOT NULL,
  314. `code` varchar(10) NOT NULL,
  315. `description` text,
  316. `unitPrice` decimal(10,2) NOT NULL,
  317. `quantity` int(6) NOT NULL,
  318. `dateAdded` datetime NOT NULL,
  319. `lastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  320. `critical_level` int(9) NOT NULL DEFAULT '10',
  321. `reorder_level` int(9) NOT NULL DEFAULT '25',
  322. PRIMARY KEY (`id`),
  323. UNIQUE KEY `name` (`name`),
  324. UNIQUE KEY `code` (`code`)
  325. ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
  326. /*!40101 SET character_set_client = @saved_cs_client */;
  327.  
  328. --
  329. -- Dumping data for table `items`
  330. --
  331.  
  332. LOCK TABLES `items` WRITE;
  333. /*!40000 ALTER TABLE `items` DISABLE KEYS */;
  334. INSERT INTO `items` VALUES (2,'Retrolux','98-retro','good',100.00,783,'2018-10-17 12:09:43','2018-10-23 15:09:52',10,25),(5,'Paper Clip','pap','',10.00,100,'2018-10-19 02:01:41','2018-10-18 23:01:41',10,25),(20,'Sam 121','121','quick sand sams',15.00,237,'2018-10-19 02:56:43','2018-11-10 17:19:29',10,25),(21,'Sam 122','122','quick sand sams',15.00,225,'2018-10-19 02:58:09','2018-11-10 17:13:41',10,25),(22,'Sam 123','123','quick sand sams',15.00,250,'2018-10-19 02:58:26','2018-10-18 23:58:26',10,25),(23,'pf120','pf12','test',10.00,100,'2018-10-19 03:03:50','2018-10-19 00:03:50',10,25),(24,'lp130','lp13','test',14.00,190,'2018-10-19 03:05:59','2018-10-20 08:39:05',10,25),(25,'lpo120','lpo12','',35.00,5,'2018-10-19 03:11:44','2018-11-10 19:21:36',10,25),(26,'Iphone','x4','refurbished',23000.00,15,'2018-11-10 19:04:32','2018-11-10 23:37:14',10,25);
  335. /*!40000 ALTER TABLE `items` ENABLE KEYS */;
  336. UNLOCK TABLES;
  337.  
  338. --
  339. -- Table structure for table `login_attempts`
  340. --
  341.  
  342. DROP TABLE IF EXISTS `login_attempts`;
  343. /*!40101 SET @saved_cs_client = @@character_set_client */;
  344. /*!40101 SET character_set_client = utf8 */;
  345. CREATE TABLE `login_attempts` (
  346. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  347. `ip_address` varchar(45) NOT NULL,
  348. `login` varchar(100) NOT NULL,
  349. `time` int(11) unsigned DEFAULT NULL,
  350. PRIMARY KEY (`id`)
  351. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  352. /*!40101 SET character_set_client = @saved_cs_client */;
  353.  
  354. --
  355. -- Dumping data for table `login_attempts`
  356. --
  357.  
  358. LOCK TABLES `login_attempts` WRITE;
  359. /*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
  360. /*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
  361. UNLOCK TABLES;
  362.  
  363. --
  364. -- Table structure for table `optical_orders`
  365. --
  366.  
  367. DROP TABLE IF EXISTS `optical_orders`;
  368. /*!40101 SET @saved_cs_client = @@character_set_client */;
  369. /*!40101 SET character_set_client = utf8 */;
  370. CREATE TABLE `optical_orders` (
  371. `id` int(11) NOT NULL AUTO_INCREMENT,
  372. `pid` int(9) DEFAULT NULL,
  373. `lens_type` int(9) DEFAULT NULL,
  374. `frame_level` int(9) DEFAULT NULL,
  375. `frame_upcharge` int(9) DEFAULT NULL,
  376. `addons` int(9) DEFAULT NULL,
  377. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  378. PRIMARY KEY (`id`)
  379. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  380. /*!40101 SET character_set_client = @saved_cs_client */;
  381.  
  382. --
  383. -- Dumping data for table `optical_orders`
  384. --
  385.  
  386. LOCK TABLES `optical_orders` WRITE;
  387. /*!40000 ALTER TABLE `optical_orders` DISABLE KEYS */;
  388. INSERT INTO `optical_orders` VALUES (1,4,129,34,135,112,'2018-10-27 21:40:06'),(2,7,126,56,134,95,'2018-10-27 22:01:47');
  389. /*!40000 ALTER TABLE `optical_orders` ENABLE KEYS */;
  390. UNLOCK TABLES;
  391.  
  392. --
  393. -- Table structure for table `patient_master`
  394. --
  395.  
  396. DROP TABLE IF EXISTS `patient_master`;
  397. /*!40101 SET @saved_cs_client = @@character_set_client */;
  398. /*!40101 SET character_set_client = utf8 */;
  399. CREATE TABLE `patient_master` (
  400. `id` int(11) NOT NULL AUTO_INCREMENT,
  401. `patient_names` varchar(50) DEFAULT '',
  402. `nationalid` varchar(15) DEFAULT NULL,
  403. `dob` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  404. `sex` varchar(6) DEFAULT 'Male',
  405. `tel1` varchar(15) DEFAULT NULL,
  406. `tel2` varchar(15) DEFAULT NULL,
  407. `postaladdress` varchar(30) DEFAULT NULL,
  408. `email` varchar(40) DEFAULT NULL,
  409. `category` varchar(10) DEFAULT NULL,
  410. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  411. PRIMARY KEY (`id`)
  412. ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
  413. /*!40101 SET character_set_client = @saved_cs_client */;
  414.  
  415. --
  416. -- Dumping data for table `patient_master`
  417. --
  418.  
  419. LOCK TABLES `patient_master` WRITE;
  420. /*!40000 ALTER TABLE `patient_master` DISABLE KEYS */;
  421. INSERT INTO `patient_master` VALUES (4,'JYOTSNA PANDYA','27248899','1998-09-20 07:00:00','4','0726939482','1234567819','Kanu','fourty400@gmail.com','1','2018-09-05 19:22:30'),(7,'ANN KAMENE','nationalid','2018-09-23 06:00:00','3','0722929916','1234567890','92007 MSA','example@example.com','1','2018-09-05 19:22:30'),(8,'DAMA KAZUNGU','nationalis','2018-09-23 06:00:00','3','0728815589','1234567890','14432 MSA','example@example.com','1','2018-09-05 19:22:30'),(10,'GRACE IRUNGU','3456789','1993-10-03 07:00:00','3','1234567890','1234567890','postaladdress','example@example.com','1','2018-10-01 16:44:59'),(13,'DOROTHY WACHIRA','098345678','1998-10-01 07:00:00','4','0721957414','0721554117','32','doro@gmail.com','2','2018-10-01 16:50:41'),(16,'James Maina Nyanguka','2343556','2016-04-05 07:00:00','3','0704832470','-','576','fourty400@gmail.com','2','2018-10-07 19:22:24'),(17,'Gondwe Benard','34345345','1985-10-20 21:00:00','3','1234567890','1234567890','234 Syokimau','example@example.net','1','2018-10-21 17:12:05'),(18,'patient_names','nationalid','2018-10-20 21:00:00','3','1234567890','1234567890','postaladdress','example@example.com','1','2018-10-21 18:18:34'),(19,'Emmaculate Rono','30456856','2010-10-20 21:00:00','4','1234567890','1234567890','postaladdress','example@example.com','1','2018-10-21 18:22:01'),(20,'Test Patient Omollo','356790','2010-09-27 21:00:00','4','23984u998','23o45u9u89','123 Kaloleni','aldjslk','2','2018-10-29 08:47:09'),(21,'weijojiweodj dsfslikl','23845','0000-00-00 00:00:00','3','l30495','989898','0923fjsldfml','sdfmdkl','1','2018-10-29 08:56:37'),(22,'Test Patient Omollos','23845','2014-08-27 21:00:00','4','23984u998','23o45u9u89','0923fjsldfml','aldjslk','2','2018-10-30 05:58:31'),(23,'Alfred Mutua','56578980','2018-11-02 21:00:00','3','1234567890','1234567890','postaladdress','example@example.com','1','2018-11-03 07:59:13'),(24,'Obado O. Obado','56578980','2018-11-02 21:00:00','3','1234567890','1234567890','postaladdress','example@example.com','1','2018-11-03 08:00:49'),(25,'mike tyson','nationalid','2018-11-05 21:00:00','3','1234567890','1234567890','postaladdress','example@example.com','1','2018-11-06 14:22:41');
  422. /*!40000 ALTER TABLE `patient_master` ENABLE KEYS */;
  423. UNLOCK TABLES;
  424.  
  425. --
  426. -- Table structure for table `pos_details`
  427. --
  428.  
  429. DROP TABLE IF EXISTS `pos_details`;
  430. /*!40101 SET @saved_cs_client = @@character_set_client */;
  431. /*!40101 SET character_set_client = utf8 */;
  432. CREATE TABLE `pos_details` (
  433. `receiptno` varchar(20) NOT NULL DEFAULT '',
  434. `posdid` int(11) NOT NULL AUTO_INCREMENT,
  435. `code` varchar(50) NOT NULL,
  436. `description` varchar(100) NOT NULL DEFAULT '',
  437. `qty` decimal(20,2) DEFAULT '0.00',
  438. `price` decimal(20,5) NOT NULL DEFAULT '0.00000',
  439. `total` decimal(20,5) NOT NULL DEFAULT '0.00000',
  440. `vat` decimal(10,5) NOT NULL DEFAULT '0.00000',
  441. `location` varchar(30) DEFAULT '',
  442. `item` tinyint(1) DEFAULT '0',
  443. `ref_` varchar(10) DEFAULT NULL,
  444. `punit` varchar(20) DEFAULT NULL,
  445. `patname` varchar(540) DEFAULT NULL,
  446. `cno` varchar(500) DEFAULT NULL,
  447. PRIMARY KEY (`posdid`),
  448. UNIQUE KEY `posdid` (`posdid`),
  449. KEY `posd_idx` (`receiptno`,`code`,`location`)
  450. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
  451. /*!40101 SET character_set_client = @saved_cs_client */;
  452.  
  453. --
  454. -- Dumping data for table `pos_details`
  455. --
  456.  
  457. LOCK TABLES `pos_details` WRITE;
  458. /*!40000 ALTER TABLE `pos_details` DISABLE KEYS */;
  459. INSERT INTO `pos_details` VALUES ('00001',1,'H002','HEDEX EXTRA',1.00,13.00000,13.00000,0.00000,'PHARMACY',0,NULL,'PACKETS',NULL,NULL),('00003',2,'P001','PANADOL',1.00,9.00000,9.00000,0.00000,'PHARMACY',0,NULL,'PACKETS',NULL,NULL),('00005',3,'P001','PANADOL',1.00,9.00000,9.00000,0.00000,'PHARMACY',0,NULL,'PACKETS',NULL,NULL),('00007',4,'D001','DRESSING',1.00,90.00000,90.00000,0.00000,'PHARMACY',0,NULL,'ROLLS',NULL,NULL),('00009',5,'HEDEX','HEDEX',1.00,9.00000,9.00000,0.00000,'PHARMACY',0,NULL,'UNIT',NULL,NULL),('00001',6,'CONSULTATION','CONSULTATION',1.00,45.00000,45.00000,0.00000,'PHARMACY',0,NULL,'ROLLS',NULL,NULL),('00002',7,'CONSULTATION','CONSULTATION',1.00,45.00000,45.00000,0.00000,'PHARMACY',0,NULL,'ROLLS',NULL,NULL),('00001',8,'HEDEX','HEDEX',10.00,20.00000,200.00000,0.00000,'PHARMACY',0,NULL,'UNIT',NULL,NULL),('00001',9,'PANADOL','PANADOL',5.00,70.00000,350.00000,0.00000,'PHARMACY',0,NULL,'UNIT',NULL,NULL),('I00069',10,'IVYDEXONE','DEXAMETHASONE',112.00,100.00000,11200.00000,0.00000,'PHARMACY',0,NULL,'MLS',NULL,NULL),('I00069',11,'IVYGENTACIN','GENTAMYCIN',123.00,130.00000,15990.00000,0.00000,'PHARMACY',0,NULL,'MLS',NULL,NULL),('I00528',12,'30','30',14.00,343.00000,4802.00000,0.00000,'PHARMACY',0,NULL,'BOX','PRAVIN CHANDI','000126030'),('I00569',13,'ZYMAR','GATIFLOXACINE',1.00,500.00000,500.00000,0.00000,'PHARMACY',0,NULL,'MLS','FAUZIA RASHID','000518027'),('I00707',14,'ZYMAR','GATIFLOXACINE',1.00,500.00000,500.00000,0.00000,'PHARMACY',0,NULL,'MLS','FHELISTA KINAMA','000118016'),('I00914',15,'ZYMAR','GATIFLOXACINE',5.00,500.00000,2500.00000,0.00000,'PHARMACY',0,NULL,'MLS','AZIZ LAKHPATY','000111025'),('I00914',16,'VIT-A','VITAMIN A',5.00,200.00000,1000.00000,0.00000,'PHARMACY',0,NULL,'TINS','AZIZ LAKHPATY','000111025'),('I00916',17,'ZYMAR','GATIFLOXACINE',1.00,500.00000,500.00000,0.00000,'PHARMACY',0,NULL,'MLS','KHADIJA MOHAMED','000126030'),('I00918',18,'DEXA','DEXAMETHASONE INJECT',1.00,100.00000,100.00000,0.00000,'PHARMACY',0,NULL,'AMPS','PRABHULAL J. SHAH','070529020'),('I00918',19,'HYDROCORT','HYDROCORTISONE INJ 100MG',1.00,100.00000,100.00000,0.00000,'PHARMACY',0,NULL,'VIALS','PRABHULAL J. SHAH','070529020'),('I00920',20,'ATROPINE-OINT','ATROPINE EYE OINTMENT.',1.00,100.00000,100.00000,0.00000,'PHARMACY',0,NULL,'PCS','FHELISTA KINAMA','000118016');
  460. /*!40000 ALTER TABLE `pos_details` ENABLE KEYS */;
  461. UNLOCK TABLES;
  462.  
  463. --
  464. -- Table structure for table `pos_header`
  465. --
  466.  
  467. DROP TABLE IF EXISTS `pos_header`;
  468. /*!40101 SET @saved_cs_client = @@character_set_client */;
  469. /*!40101 SET character_set_client = utf8 */;
  470. CREATE TABLE `pos_header` (
  471. `posid` int(11) NOT NULL AUTO_INCREMENT,
  472. `receiptno` varchar(20) NOT NULL DEFAULT '',
  473. `amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  474. `paid` decimal(20,2) NOT NULL DEFAULT '0.00',
  475. `changee` decimal(20,2) NOT NULL DEFAULT '0.00',
  476. `tax` decimal(20,2) NOT NULL DEFAULT '0.00',
  477. `staff` varchar(50) NOT NULL DEFAULT '',
  478. `notes` varchar(100) NOT NULL DEFAULT '',
  479. `pos` varchar(20) NOT NULL DEFAULT '',
  480. `posdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  481. `arcode` varchar(30) NOT NULL DEFAULT '',
  482. `arname` varchar(100) NOT NULL DEFAULT '',
  483. `tyype` varchar(50) NOT NULL DEFAULT '',
  484. `ref` varchar(30) DEFAULT '',
  485. `posted` tinyint(1) DEFAULT '1',
  486. `smallestunit` varchar(30) DEFAULT 'Unit',
  487. `location` varchar(30) NOT NULL DEFAULT '',
  488. `pricelist` varchar(30) NOT NULL DEFAULT '',
  489. `details` varchar(30) NOT NULL DEFAULT '',
  490. `pname` varchar(540) DEFAULT NULL,
  491. `cardno` varchar(200) DEFAULT NULL,
  492. `pdoc` varchar(540) DEFAULT NULL,
  493. `ptype` varchar(60) DEFAULT NULL,
  494. PRIMARY KEY (`posid`),
  495. UNIQUE KEY `posid` (`posid`),
  496. KEY `pos_idx` (`receiptno`,`arcode`,`arname`,`ref`,`posdate`)
  497. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
  498. /*!40101 SET character_set_client = @saved_cs_client */;
  499.  
  500. --
  501. -- Dumping data for table `pos_header`
  502. --
  503.  
  504. LOCK TABLES `pos_header` WRITE;
  505. /*!40000 ALTER TABLE `pos_header` DISABLE KEYS */;
  506. INSERT INTO `pos_header` VALUES (1,'00001',13.00,13.00,1.00,0.00,'electra','','PHARMACY','2007-02-22 07:47:36','Cash',' HEDEX EXTRA','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(2,'00003',9.00,9.00,1.00,0.00,'electra','','PHARMACY','2007-02-22 07:48:00','Cash',' PANADOL','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(3,'00005',9.00,9.00,1.00,0.00,'electra','','PHARMACY','2007-02-22 07:51:07','Cash',' PANADOL','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(4,'00007',90.00,90.00,1.00,0.00,'electra','','PHARMACY','2007-02-22 07:52:22','Cash',' DRESSING','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(5,'00009',9.00,9.00,1.00,0.00,'electra','','PHARMACY','2007-02-22 07:53:16','Cash',' HEDEX','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(6,'00001',45.00,45.00,1.00,0.00,'pharm','','PHARMACY','2007-02-22 15:10:40','Post-Operative',' CONSULTATION','Post-Operative','',1,'Unit','','','',NULL,NULL,NULL,NULL),(7,'00002',45.00,45.00,1.00,0.00,'pharm','','PHARMACY','2007-02-22 15:11:12','Post-Operative',' CONSULTATION','Post-Operative','',1,'Unit','','','',NULL,NULL,NULL,NULL),(8,'00001',550.00,550.00,15.00,0.00,'pharm','','PHARMACY','2007-02-23 11:01:21','Cash',' HEDEX PANADOL','Cash','',1,'Unit','','','',NULL,NULL,NULL,NULL),(9,'I00069',27190.00,27190.00,235.00,0.00,'carol','','PHARMACY','2007-04-24 14:18:51','Cash',' DEXAMETHASONE GENTAMYCIN','Cash',NULL,0,'Unit','','','',NULL,NULL,NULL,NULL),(10,'I00528',4802.00,4802.00,14.00,0.00,'admin','','PHARMACY','2008-01-21 11:43:56','Cash',' 30','Cash',NULL,0,'Unit','','','','PRAVIN CHANDI','000126030','Prudence',NULL),(11,'I00569',500.00,500.00,1.00,0.00,'carol','','PHARMACY','2008-01-24 16:19:03','Cash',' GATIFLOXACINE','Cash',NULL,0,'Unit','','','','FAUZIA RASHID','000518027','Dr.Matende',NULL),(12,'I00707',500.00,500.00,1.00,0.00,'electra','','PHARMACY','2008-02-27 12:37:54','Cash',' GATIFLOXACINE','Cash',NULL,0,'Unit','','','','FHELISTA KINAMA','000118016','Dr. Inoti',NULL),(13,'I00914',3500.00,3500.00,10.00,0.00,'paul','','PHARMACY','2008-05-16 15:11:40','Cash',' GATIFLOXACINE VITAMIN A','Cash',NULL,0,'Unit','','','','AZIZ LAKHPATY','000111025','Prudence',NULL),(14,'I00916',500.00,500.00,1.00,0.00,'paul','','PHARMACY','2008-05-16 16:32:44','Cash',' GATIFLOXACINE','Cash',NULL,0,'Unit','','','','KHADIJA MOHAMED','000126030','Visiting Doctor',NULL),(15,'I00918',200.00,200.00,2.00,0.00,'paul','','PHARMACY','2008-05-17 14:07:22','Cash',' DEXAMETHASONE INJECT HYDROCORTISONE INJ 100MG','Cash',NULL,0,'Unit','','','','PRABHULAL J. SHAH','070529020','Dr.Matende',NULL),(16,'I00920',100.00,100.00,1.00,0.00,'paul','','PHARMACY','2008-05-17 14:14:14','Cash',' ATROPINE EYE OINTMENT.','Cash',NULL,0,'Unit','','','','FHELISTA KINAMA','000118016','Prudence',NULL),(17,'I00922',450.00,450.00,1.00,0.00,'paul','','PHARMACY','2008-05-17 14:25:23','Cash',' CIPROFLOXACINE','Cash',NULL,0,'Unit','','','','SHILPA SHAH','000107010','Visiting Doctor',NULL),(18,'I00924',100.00,100.00,1.00,0.00,'paul','','PHARMACY','2008-05-17 14:31:24','Cash',' ARTIFICIAL TEARS.','Cash',NULL,0,'Unit','','','','MRS K. E. SHEIKH','000324013','Dr. Inoti',NULL),(19,'I00926',1400.00,1400.00,1.00,0.00,'paul','','PHARMACY','2008-05-17 14:39:42','Cash',' LUMIGAN','Cash',NULL,0,'Unit','','','','MOHAMED S ALI','000526027','Dr. Inoti',NULL),(20,'I00928',1700.00,1700.00,2.00,0.00,'paul','','PHARMACY','2008-05-17 17:29:08','Cash',' DEXATROL +13.0rigid','Cash',NULL,0,'Unit','','','','MAHENDRA MARU','001221022','Student Doctor',NULL);
  507. /*!40000 ALTER TABLE `pos_header` ENABLE KEYS */;
  508. UNLOCK TABLES;
  509.  
  510. --
  511. -- Table structure for table `qlist`
  512. --
  513.  
  514. DROP TABLE IF EXISTS `qlist`;
  515. /*!40101 SET @saved_cs_client = @@character_set_client */;
  516. /*!40101 SET character_set_client = utf8 */;
  517. CREATE TABLE `qlist` (
  518. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  519. `from` varchar(255) NOT NULL DEFAULT '',
  520. `to` varchar(255) NOT NULL DEFAULT '',
  521. `message` text NOT NULL,
  522. `sent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  523. `recd` int(10) unsigned NOT NULL DEFAULT '0',
  524. `date` datetime DEFAULT CURRENT_TIMESTAMP,
  525. PRIMARY KEY (`id`),
  526. KEY `to` (`to`),
  527. KEY `from` (`from`)
  528. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  529. /*!40101 SET character_set_client = @saved_cs_client */;
  530.  
  531. --
  532. -- Dumping data for table `qlist`
  533. --
  534.  
  535. LOCK TABLES `qlist` WRITE;
  536. /*!40000 ALTER TABLE `qlist` DISABLE KEYS */;
  537. /*!40000 ALTER TABLE `qlist` ENABLE KEYS */;
  538. UNLOCK TABLES;
  539.  
  540. --
  541. -- Table structure for table `refraction`
  542. --
  543.  
  544. DROP TABLE IF EXISTS `refraction`;
  545. /*!40101 SET @saved_cs_client = @@character_set_client */;
  546. /*!40101 SET character_set_client = utf8 */;
  547. CREATE TABLE `refraction` (
  548. `id` int(9) NOT NULL AUTO_INCREMENT,
  549. `sphere_os` varchar(32) DEFAULT NULL,
  550. `sphere_od` varchar(32) DEFAULT NULL,
  551. `cylinder_os` varchar(32) DEFAULT NULL,
  552. `cylinder_od` varchar(32) DEFAULT NULL,
  553. `axis_os` varchar(32) DEFAULT NULL,
  554. `axis_od` varchar(32) DEFAULT NULL,
  555. `VA_os` varchar(32) DEFAULT NULL,
  556. `VA_od` varchar(32) DEFAULT NULL,
  557. `docid` int(9) DEFAULT NULL,
  558. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  559. `notes` text,
  560. PRIMARY KEY (`id`)
  561. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  562. /*!40101 SET character_set_client = @saved_cs_client */;
  563.  
  564. --
  565. -- Dumping data for table `refraction`
  566. --
  567.  
  568. LOCK TABLES `refraction` WRITE;
  569. /*!40000 ALTER TABLE `refraction` DISABLE KEYS */;
  570. /*!40000 ALTER TABLE `refraction` ENABLE KEYS */;
  571. UNLOCK TABLES;
  572.  
  573. --
  574. -- Table structure for table `screening`
  575. --
  576.  
  577. DROP TABLE IF EXISTS `screening`;
  578. /*!40101 SET @saved_cs_client = @@character_set_client */;
  579. /*!40101 SET character_set_client = utf8 */;
  580. CREATE TABLE `screening` (
  581. `id` int(9) NOT NULL AUTO_INCREMENT,
  582. `pid` int(9) NOT NULL,
  583. `od` varchar(16) DEFAULT NULL,
  584. `os` varchar(16) DEFAULT NULL,
  585. `notes` text,
  586. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  587. `cc` text,
  588. PRIMARY KEY (`id`)
  589. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  590. /*!40101 SET character_set_client = @saved_cs_client */;
  591.  
  592. --
  593. -- Dumping data for table `screening`
  594. --
  595.  
  596. LOCK TABLES `screening` WRITE;
  597. /*!40000 ALTER TABLE `screening` DISABLE KEYS */;
  598. INSERT INTO `screening` VALUES (1,4,'4','5',NULL,'2018-10-10 15:50:05','where is my complaint'),(2,7,'45','34',NULL,'2018-10-10 18:04:46','This is annes'),(3,17,'34','345',NULL,'2018-10-21 18:25:02','hit by a passing star'),(4,21,'34','21',NULL,'2018-10-30 04:51:07','blind spot guy'),(5,22,'23','99',NULL,'2018-10-30 06:09:23','adasdsd'),(6,23,'15','34',NULL,'2018-11-03 08:02:01','knocked down by accident'),(7,25,'34','234',NULL,'2018-11-06 14:39:16','');
  599. /*!40000 ALTER TABLE `screening` ENABLE KEYS */;
  600. UNLOCK TABLES;
  601.  
  602. --
  603. -- Table structure for table `settings`
  604. --
  605.  
  606. DROP TABLE IF EXISTS `settings`;
  607. /*!40101 SET @saved_cs_client = @@character_set_client */;
  608. /*!40101 SET character_set_client = utf8 */;
  609. CREATE TABLE `settings` (
  610. `id` int(9) NOT NULL AUTO_INCREMENT,
  611. `name` varchar(255) NOT NULL,
  612. `pnumber` int(11) NOT NULL,
  613. `location` varchar(255) NOT NULL,
  614. `logo` varchar(255) NOT NULL,
  615. `postal_code` int(9) DEFAULT NULL,
  616. `email` varchar(100) DEFAULT NULL,
  617. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  618. `version` varchar(16) DEFAULT '2.0',
  619. PRIMARY KEY (`id`)
  620. ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;
  621. /*!40101 SET character_set_client = @saved_cs_client */;
  622.  
  623. --
  624. -- Dumping data for table `settings`
  625. --
  626.  
  627. LOCK TABLES `settings` WRITE;
  628. /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
  629. INSERT INTO `settings` VALUES (38,'Skylark',0,'location','15328117037339.png',1,'example@example.com','2018-07-28 21:01:19','2.0');
  630. /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
  631. UNLOCK TABLES;
  632.  
  633. --
  634. -- Table structure for table `tbl_charges`
  635. --
  636.  
  637. DROP TABLE IF EXISTS `tbl_charges`;
  638. /*!40101 SET @saved_cs_client = @@character_set_client */;
  639. /*!40101 SET character_set_client = utf8 */;
  640. CREATE TABLE `tbl_charges` (
  641. `id` int(11) NOT NULL AUTO_INCREMENT,
  642. `txn` varchar(32) DEFAULT NULL,
  643. `charge_id` int(9) DEFAULT NULL,
  644. `item_id` int(11) NOT NULL,
  645. `quantity` int(9) DEFAULT '0',
  646. `user_id` int(11) NOT NULL,
  647. `a_status` int(11) NOT NULL,
  648. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  649. PRIMARY KEY (`id`)
  650. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
  651. /*!40101 SET character_set_client = @saved_cs_client */;
  652.  
  653. --
  654. -- Dumping data for table `tbl_charges`
  655. --
  656.  
  657. LOCK TABLES `tbl_charges` WRITE;
  658. /*!40000 ALTER TABLE `tbl_charges` DISABLE KEYS */;
  659. INSERT INTO `tbl_charges` VALUES (14,'1538849026',13,1,5,1,1,'2018-10-06 18:03:46'),(15,'1538849026',13,11,1,1,1,'2018-10-06 18:03:46'),(16,'1538866547',13,8,10,1,3,'2018-10-06 22:55:47'),(17,'1538897424',12,6,100,1,1,'2018-10-07 07:30:24'),(18,'1538898355',4,7,50,1,1,'2018-10-07 07:45:55'),(19,'1538898355',4,7,50,1,1,'2018-10-07 07:45:55'),(20,'1538898472',4,6,30,1,1,'2018-10-07 07:47:52'),(21,'1538898679',4,7,40,1,1,'2018-10-07 07:51:19'),(22,'1538898776',4,6,80,1,2,'2018-10-07 07:52:56'),(23,'1538898856',4,8,16,1,2,'2018-10-07 07:54:16'),(24,'1538900028',4,7,20,1,0,'2018-10-07 08:13:48'),(25,'1538932347',4,7,11,1,1,'2018-10-07 17:12:27'),(26,'1538937449',4,7,20,1,3,'2018-10-07 18:37:29'),(27,'1539016108',16,7,10,1,3,'2018-10-08 16:28:28'),(28,'1539016632',16,7,100,1,1,'2018-10-08 16:37:12'),(29,'1539017112',16,1,12,1,2,'2018-10-08 16:45:12'),(30,'1539685001',16,1,100,0,0,'2018-10-16 10:16:41');
  660. /*!40000 ALTER TABLE `tbl_charges` ENABLE KEYS */;
  661. UNLOCK TABLES;
  662.  
  663. --
  664. -- Table structure for table `tbl_item`
  665. --
  666.  
  667. DROP TABLE IF EXISTS `tbl_item`;
  668. /*!40101 SET @saved_cs_client = @@character_set_client */;
  669. /*!40101 SET character_set_client = utf8 */;
  670. CREATE TABLE `tbl_item` (
  671. `id` int(11) NOT NULL AUTO_INCREMENT,
  672. `item` varchar(255) NOT NULL,
  673. `description` text NOT NULL,
  674. `item_category_id` int(11) NOT NULL,
  675. `user_id` int(11) NOT NULL,
  676. `unit_cost` int(9) DEFAULT '1',
  677. `barcode` varchar(100) DEFAULT NULL,
  678. `date` date NOT NULL,
  679. `time` time NOT NULL,
  680. `a_status` int(11) NOT NULL,
  681. PRIMARY KEY (`id`)
  682. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  683. /*!40101 SET character_set_client = @saved_cs_client */;
  684.  
  685. --
  686. -- Dumping data for table `tbl_item`
  687. --
  688.  
  689. LOCK TABLES `tbl_item` WRITE;
  690. /*!40000 ALTER TABLE `tbl_item` DISABLE KEYS */;
  691. INSERT INTO `tbl_item` VALUES (1,'Amoxil','capsules',1,1,15,'-','2017-08-30','04:31:18',1),(2,'Prednisone','Antibiotics, Antihistahime',1,1,1,'-','2017-08-30','04:32:06',1),(3,'Item 3','item 3',1,1,1,NULL,'2017-08-30','04:32:41',1),(4,'Item 4','item 4',1,1,1,NULL,'2017-08-30','04:32:56',1),(5,'Item 5','item 5',1,1,1,NULL,'2017-08-30','04:33:17',1),(6,'Services1','services 1',2,1,1,NULL,'2017-08-30','04:33:31',1),(7,'Services2','services 2',2,1,1,NULL,'2017-08-30','04:33:44',1),(8,'Services3','services 3',2,1,1,NULL,'2017-08-30','04:33:59',1),(9,'Services4','services 4',2,1,1,NULL,'2017-08-30','04:34:10',1),(10,'Services5','services 5',2,1,1,NULL,'2017-08-30','04:34:22',1),(11,'CT Scan','Full body xray',3,1,1500,'-','2018-04-03','01:30:10',1),(12,'Ketoz','Ketoconazole Blister Pack\r\n',1,1,1,NULL,'0000-00-00','00:00:00',0);
  692. /*!40000 ALTER TABLE `tbl_item` ENABLE KEYS */;
  693. UNLOCK TABLES;
  694.  
  695. --
  696. -- Table structure for table `tbx_transact`
  697. --
  698.  
  699. DROP TABLE IF EXISTS `tbx_transact`;
  700. /*!40101 SET @saved_cs_client = @@character_set_client */;
  701. /*!40101 SET character_set_client = utf8 */;
  702. CREATE TABLE `tbx_transact` (
  703. `id` int(9) NOT NULL AUTO_INCREMENT,
  704. `txnid` int(9) DEFAULT NULL,
  705. `pmethod` int(9) DEFAULT NULL,
  706. `amount` float(10,2) NOT NULL,
  707. `user_id` int(9) DEFAULT NULL,
  708. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  709. PRIMARY KEY (`id`)
  710. ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
  711. /*!40101 SET character_set_client = @saved_cs_client */;
  712.  
  713. --
  714. -- Dumping data for table `tbx_transact`
  715. --
  716.  
  717. LOCK TABLES `tbx_transact` WRITE;
  718. /*!40000 ALTER TABLE `tbx_transact` DISABLE KEYS */;
  719. INSERT INTO `tbx_transact` VALUES (7,1538866547,93,1.00,1,'2018-10-06 23:05:07'),(8,1538866547,93,1.00,1,'2018-10-06 23:14:50'),(9,1538866547,93,1.00,1,'2018-10-06 23:16:16'),(10,1538866547,93,1.00,1,'2018-10-06 23:22:43'),(11,1538866547,93,1.00,1,'2018-10-06 23:25:41'),(12,1538866547,93,1.00,1,'2018-10-06 23:36:01'),(13,1538897424,93,20.00,1,'2018-10-07 07:41:15'),(14,1538897424,93,80.00,1,'2018-10-07 07:42:43'),(15,1538849026,92,1575.00,1,'2018-10-07 07:44:39'),(16,1538898355,93,100.00,1,'2018-10-07 07:46:07'),(17,1538898472,93,30.00,1,'2018-10-07 07:48:57'),(18,1538898679,93,40.00,1,'2018-10-07 07:52:06'),(19,1538898776,93,80.00,1,'2018-10-07 07:53:04'),(20,1538898856,93,16.00,1,'2018-10-07 07:54:25'),(21,0,NULL,0.00,1,'2018-10-07 07:54:37'),(22,0,NULL,0.00,1,'2018-10-07 08:03:06'),(23,1538932347,93,1.00,1,'2018-10-07 17:20:15'),(24,1538932347,93,1.00,1,'2018-10-07 17:22:50'),(25,1538932347,93,1.00,1,'2018-10-07 17:23:13'),(26,1538932347,93,1.00,1,'2018-10-07 17:24:45'),(27,1538932347,93,1.00,1,'2018-10-07 17:25:46'),(28,1538932347,93,1.00,1,'2018-10-07 17:27:14'),(29,1538932347,93,1.00,1,'2018-10-07 17:28:07'),(30,1538932347,93,1.00,1,'2018-10-07 17:29:56'),(31,1538932347,93,1.00,1,'2018-10-07 17:30:25'),(32,1538932347,93,1.00,1,'2018-10-07 17:34:54'),(33,1538932347,93,1.00,1,'2018-10-07 17:35:48'),(34,1538937449,93,1.00,1,'2018-10-07 18:37:44'),(35,1538937449,93,1.00,1,'2018-10-07 18:37:54'),(36,1538937449,93,1.00,1,'2018-10-07 19:13:48'),(37,1539016108,93,2.00,1,'2018-10-08 16:28:56'),(38,1539016632,93,20.00,1,'2018-10-10 21:59:56'),(39,1539016632,93,10.00,1,'2018-10-10 22:00:15'),(40,0,NULL,0.00,1,'2018-10-10 22:34:09'),(41,0,NULL,0.00,1,'2018-10-10 22:34:29'),(42,1539016632,93,70.00,1,'2018-10-16 10:18:33');
  720. /*!40000 ALTER TABLE `tbx_transact` ENABLE KEYS */;
  721. UNLOCK TABLES;
  722.  
  723. --
  724. -- Table structure for table `transactions`
  725. --
  726.  
  727. DROP TABLE IF EXISTS `transactions`;
  728. /*!40101 SET @saved_cs_client = @@character_set_client */;
  729. /*!40101 SET character_set_client = utf8 */;
  730. CREATE TABLE `transactions` (
  731. `transId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  732. `ref` varchar(10) NOT NULL,
  733. `itemName` varchar(50) NOT NULL,
  734. `itemCode` varchar(50) NOT NULL,
  735. `description` text,
  736. `quantity` int(6) NOT NULL,
  737. `unitPrice` decimal(10,2) NOT NULL,
  738. `totalPrice` decimal(10,2) NOT NULL,
  739. `totalMoneySpent` decimal(10,2) NOT NULL,
  740. `amountTendered` decimal(10,2) NOT NULL,
  741. `discount_amount` decimal(10,2) NOT NULL,
  742. `discount_percentage` decimal(10,2) NOT NULL,
  743. `vatPercentage` decimal(10,2) NOT NULL,
  744. `vatAmount` decimal(10,2) NOT NULL,
  745. `changeDue` decimal(10,2) NOT NULL,
  746. `modeOfPayment` varchar(20) NOT NULL,
  747. `cust_name` varchar(20) DEFAULT NULL,
  748. `cust_phone` varchar(15) DEFAULT NULL,
  749. `cust_email` varchar(50) DEFAULT NULL,
  750. `transType` char(1) NOT NULL,
  751. `staffId` bigint(20) unsigned NOT NULL,
  752. `transDate` datetime NOT NULL,
  753. `lastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  754. `cancelled` char(1) NOT NULL DEFAULT '0',
  755. PRIMARY KEY (`transId`)
  756. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  757. /*!40101 SET character_set_client = @saved_cs_client */;
  758.  
  759. --
  760. -- Dumping data for table `transactions`
  761. --
  762.  
  763. LOCK TABLES `transactions` WRITE;
  764. /*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
  765. INSERT INTO `transactions` VALUES (1,'1501640','Retrolux','98-retro','',15,100.00,1500.00,1500.00,2000.00,0.00,0.00,0.00,0.00,500.00,'Cash','','','','1',1,'2018-10-18 12:09:24','2018-10-18 09:09:24','0'),(2,'3218456','Sam 121','121','',5,15.00,75.00,75.00,75.00,0.00,0.00,0.00,0.00,0.00,'POS','','','','1',1,'2018-10-19 11:16:27','2018-10-19 08:16:27','0'),(3,'7268852','Sam 121','121','',5,15.00,75.00,75.00,75.00,0.00,0.00,0.00,0.00,0.00,'POS','','','','1',1,'2018-10-19 11:25:34','2018-10-19 08:25:34','0'),(4,'8615293','Sam 122','122','',10,15.00,150.00,325.00,500.00,0.00,0.00,0.00,0.00,175.00,'Cash','','','','1',1,'2018-10-19 11:30:37','2018-10-19 08:30:37','0'),(5,'8615293','lpo120','lpo12','',5,35.00,175.00,325.00,500.00,0.00,0.00,0.00,0.00,175.00,'Cash','','','','1',1,'2018-10-19 11:30:37','2018-10-19 08:30:37','0'),(6,'796746592','Sam 122','122','',12,15.00,180.00,180.00,200.00,0.00,0.00,0.00,0.00,20.00,'Cash','','','','1',1,'2018-10-20 11:28:08','2018-10-20 08:28:08','0'),(7,'351480369','Retrolux','98-retro','',2,100.00,200.00,200.00,1000.00,0.00,0.00,0.00,0.00,800.00,'Cash','','','','1',1,'2018-10-23 18:09:52','2018-10-23 15:09:52','0'),(8,'739241697','Iphone','x4','',2,23000.00,46000.00,46000.00,50000.00,0.00,0.00,0.00,0.00,4000.00,'Cash','','','','1',1,'2018-11-10 19:11:21','2018-11-10 16:11:21','0'),(9,'49079715','Sam 122','122','',3,15.00,45.00,45.00,45.00,0.00,0.00,0.00,0.00,0.00,'POS','','','','1',1,'2018-11-10 20:13:41','2018-11-10 17:13:41','0'),(10,'809103946','Sam 121','121','',1,15.00,15.00,15.00,20.00,0.00,0.00,0.00,0.00,5.00,'Cash','','','','1',1,'2018-11-10 20:17:23','2018-11-10 17:17:23','0'),(11,'950789','Sam 121','121','',1,15.00,15.00,15.00,20.00,0.00,0.00,0.00,0.00,5.00,'Cash','','','','1',1,'2018-11-10 20:18:08','2018-11-10 17:18:08','0'),(12,'86785492','Sam 121','121','',1,15.00,15.00,15.00,20.00,0.00,0.00,0.00,0.00,5.00,'Cash','','','','1',1,'2018-11-10 20:19:29','2018-11-10 17:19:29','0');
  766. /*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
  767. UNLOCK TABLES;
  768.  
  769. --
  770. -- Table structure for table `user_types`
  771. --
  772.  
  773. DROP TABLE IF EXISTS `user_types`;
  774. /*!40101 SET @saved_cs_client = @@character_set_client */;
  775. /*!40101 SET character_set_client = utf8 */;
  776. CREATE TABLE `user_types` (
  777. `id` int(9) NOT NULL AUTO_INCREMENT,
  778. `names` varchar(32) DEFAULT NULL,
  779. `scode` int(9) DEFAULT NULL,
  780. PRIMARY KEY (`id`),
  781. UNIQUE KEY `names` (`names`)
  782. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  783. /*!40101 SET character_set_client = @saved_cs_client */;
  784.  
  785. --
  786. -- Dumping data for table `user_types`
  787. --
  788.  
  789. LOCK TABLES `user_types` WRITE;
  790. /*!40000 ALTER TABLE `user_types` DISABLE KEYS */;
  791. INSERT INTO `user_types` VALUES (1,'doctor',NULL),(2,'surgeon',NULL),(3,'nurse',NULL),(4,'Reception/Nurse/Doctor',NULL),(5,'Resident Doctor',NULL),(6,'',NULL),(7,'Theatre',NULL),(8,'Laboratory',NULL),(9,'Optical Shop',NULL),(10,'Pharmacist',NULL),(11,'Others',NULL),(12,'Administrator',NULL),(13,'Reception',NULL);
  792. /*!40000 ALTER TABLE `user_types` ENABLE KEYS */;
  793. UNLOCK TABLES;
  794.  
  795. --
  796. -- Table structure for table `users`
  797. --
  798.  
  799. DROP TABLE IF EXISTS `users`;
  800. /*!40101 SET @saved_cs_client = @@character_set_client */;
  801. /*!40101 SET character_set_client = utf8 */;
  802. CREATE TABLE `users` (
  803. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  804. `ip_address` varchar(45) NOT NULL,
  805. `username` varchar(100) DEFAULT NULL,
  806. `password` varchar(255) NOT NULL,
  807. `salt` varchar(255) DEFAULT NULL,
  808. `email` varchar(254) NOT NULL,
  809. `activation_code` varchar(40) DEFAULT NULL,
  810. `forgotten_password_code` varchar(40) DEFAULT NULL,
  811. `forgotten_password_time` int(11) unsigned DEFAULT NULL,
  812. `remember_code` varchar(40) DEFAULT NULL,
  813. `created_on` int(11) unsigned NOT NULL,
  814. `last_login` int(11) unsigned DEFAULT NULL,
  815. `active` tinyint(1) unsigned DEFAULT NULL,
  816. `first_name` varchar(50) DEFAULT NULL,
  817. `last_name` varchar(50) DEFAULT NULL,
  818. `company` varchar(100) DEFAULT NULL,
  819. `phone` varchar(20) DEFAULT NULL,
  820. PRIMARY KEY (`id`)
  821. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
  822. /*!40101 SET character_set_client = @saved_cs_client */;
  823.  
  824. --
  825. -- Dumping data for table `users`
  826. --
  827.  
  828. LOCK TABLES `users` WRITE;
  829. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  830. INSERT INTO `users` VALUES (1,'127.0.0.1','administrator','$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36','','admin@admin.com','','17hI-Vwo1E2gx75Mwp7Z6u5037c88789059872e4',1538761906,NULL,1268889823,1542004121,1,'Gondwe','Bernard','ADMIN','0'),(2,'::1','fourty400@gmail.com','$2y$08$Y5oCX/94BIHhb.gXVMSHeOuprruJbOIyOIc1wXLmIZp2ZPjaGmsOK',NULL,'fourty400@gmail.com','ac1e408c61ae2ce8c4b2b08152e2a1095df17484',NULL,NULL,'2YfWAQrhkKPJ7Bxdlekxge',1537900795,1537906278,0,'D','Gondwe','nardtec','0726939482'),(3,'::1','alex@gmail.com','$2y$08$skTBbrb/m9.jUmdfeTgn4ueIXT4IoF0nsP5ayLBr3LZ2qJXHTa0hq',NULL,'alex@gmail.com',NULL,'ngc1FPGVHPfaJ8KwL87Sve6e1a2d235cff378ad5',1539211493,NULL,1539084148,1539092333,1,'Alfred','Irungu','Lighthouse','0734789007'),(4,'::1','jasmine','$2y$08$DwBtzfzObHoDptKT7LYFf.NkbNNAH8wPbXxsh6unbnsppCKLioLum',NULL,'jasmine',NULL,NULL,NULL,NULL,1539099017,1540120512,1,'Jasmine','Akorino','Lighthouse','0726939482'),(5,'::1','jemsi','$2y$08$X1gw0iHuyRIjSZqkxxrGduCh6zge6025YCOOwiXfR4SJJp/OULy9u',NULL,'jemsi',NULL,NULL,NULL,NULL,1539118812,NULL,1,'James','Wanga','LFC','0734234253'),(6,'127.0.0.1','steve','$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36',NULL,'steve',NULL,NULL,NULL,NULL,1540120982,1541893503,1,'Steve','O','Tech','34567898765'),(7,'105.164.140.72','korir','$2y$08$CDIQHcngOFdPl7t9e3A0iOkS/kXmTxq3/lkQ79z5eJRLw2Kn.M1a.',NULL,'korir',NULL,NULL,NULL,NULL,1540217034,1541364554,1,'Fredrick','Korir','Lighthouse','0'),(8,'105.164.140.72','matende','$2y$08$dK6ma9n6S2ymH.c04E3DW.z.ol4EGIbUnKRHf070fcH790xaSoKT6',NULL,'matende',NULL,NULL,NULL,NULL,1540217074,1541757544,1,'Ibrahim','Matende','Lighthouse','07'),(9,'fe80::9954:621c:b470:b9a4','oyoo','$2y$08$7lompdzIOap5jnQRPMikoeBZxPrvXBGKJPW0Wmx5nVaP3.F.ZRWQm',NULL,'oyoo',NULL,NULL,NULL,NULL,1541448193,1541448201,1,'Oyoo','Ben','PeaKNETT','2348y2347y2');
  831. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  832. UNLOCK TABLES;
  833.  
  834. --
  835. -- Table structure for table `users_groups`
  836. --
  837.  
  838. DROP TABLE IF EXISTS `users_groups`;
  839. /*!40101 SET @saved_cs_client = @@character_set_client */;
  840. /*!40101 SET character_set_client = utf8 */;
  841. CREATE TABLE `users_groups` (
  842. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  843. `user_id` int(11) unsigned NOT NULL,
  844. `group_id` mediumint(8) unsigned NOT NULL,
  845. PRIMARY KEY (`id`),
  846. UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
  847. KEY `fk_users_groups_users1_idx` (`user_id`),
  848. KEY `fk_users_groups_groups1_idx` (`group_id`),
  849. CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  850. CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  851. ) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
  852. /*!40101 SET character_set_client = @saved_cs_client */;
  853.  
  854. --
  855. -- Dumping data for table `users_groups`
  856. --
  857.  
  858. LOCK TABLES `users_groups` WRITE;
  859. /*!40000 ALTER TABLE `users_groups` DISABLE KEYS */;
  860. INSERT INTO `users_groups` VALUES (90,1,1),(91,1,2),(92,1,5),(93,1,6),(94,1,7),(95,1,8),(97,1,10),(98,1,11),(99,1,13),(101,1,15),(102,1,18),(103,1,19),(122,1,20),(114,2,2),(115,3,2),(116,3,5),(117,3,13),(82,4,2),(83,4,11),(77,5,2),(126,6,2),(127,6,20),(106,7,2),(107,7,5),(108,7,6),(110,7,15),(111,8,2),(112,8,5),(113,8,15),(120,9,2),(121,9,11);
  861. /*!40000 ALTER TABLE `users_groups` ENABLE KEYS */;
  862. UNLOCK TABLES;
  863.  
  864. --
  865. -- Dumping routines for database 'lighthouse'
  866. --
  867. /*!50003 DROP FUNCTION IF EXISTS `age` */;
  868. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  869. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  870. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  871. /*!50003 SET character_set_client = utf8mb4 */ ;
  872. /*!50003 SET character_set_results = utf8mb4 */ ;
  873. /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ;
  874. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  875. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  876. DELIMITER ;;
  877. CREATE DEFINER=`root`@`localhost` FUNCTION `age`(`dob` DATE) RETURNS varchar(32) CHARSET latin1
  878. NO SQL
  879. BEGIN
  880.  
  881. DECLARE age varchar(32);
  882.  
  883. DECLARE days int(9); DECLARE yrs int(9);
  884.  
  885. DECLARE hrs int(9);
  886.  
  887. DECLARE months int(9);
  888.  
  889. set days = datediff(CURRENT_DATE, dob);
  890.  
  891. set yrs = floor(days/365);
  892.  
  893. set months = floor(days/30);
  894.  
  895. set hrs = floor(days*24);
  896.  
  897. IF yrs > 0 THEN
  898.  
  899. RETURN concat(yrs, " yrs");
  900.  
  901. ELSEIF (yrs < 1 and months > 0) THEN
  902.  
  903. RETURN concat(months, " months");
  904.  
  905. ELSEIF (months < 1 and days > 0) THEN
  906.  
  907. RETURN concat(days, " days");
  908.  
  909. ELSEIF (days < 1 and hrs > 0) THEN
  910.  
  911. RETURN concat(hrs, " hrs");
  912.  
  913. ELSE
  914.  
  915. RETURN "NA";
  916.  
  917. END IF;
  918.  
  919. RETURN age;
  920.  
  921. END ;;
  922. DELIMITER ;
  923. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  924. /*!50003 SET character_set_client = @saved_cs_client */ ;
  925. /*!50003 SET character_set_results = @saved_cs_results */ ;
  926. /*!50003 SET collation_connection = @saved_col_connection */ ;
  927. /*!50003 DROP FUNCTION IF EXISTS `rx` */;
  928. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  929. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  930. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  931. /*!50003 SET character_set_client = cp850 */ ;
  932. /*!50003 SET character_set_results = cp850 */ ;
  933. /*!50003 SET collation_connection = cp850_general_ci */ ;
  934. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  935. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  936. DELIMITER ;;
  937. CREATE DEFINER=`root`@`localhost` FUNCTION `rx`(xx varchar(32)) RETURNS varchar(32) CHARSET latin1
  938. return replace(xx, " ", "_") ;;
  939. DELIMITER ;
  940. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  941. /*!50003 SET character_set_client = @saved_cs_client */ ;
  942. /*!50003 SET character_set_results = @saved_cs_results */ ;
  943. /*!50003 SET collation_connection = @saved_col_connection */ ;
  944. /*!50003 DROP FUNCTION IF EXISTS `rxx` */;
  945. /*!50003 SET @saved_cs_client = @@character_set_client */ ;
  946. /*!50003 SET @saved_cs_results = @@character_set_results */ ;
  947. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  948. /*!50003 SET character_set_client = cp850 */ ;
  949. /*!50003 SET character_set_results = cp850 */ ;
  950. /*!50003 SET collation_connection = cp850_general_ci */ ;
  951. /*!50003 SET @saved_sql_mode = @@sql_mode */ ;
  952. /*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
  953. DELIMITER ;;
  954. CREATE DEFINER=`root`@`localhost` FUNCTION `rxx`(rx varchar(32)) RETURNS varchar(32) CHARSET latin1
  955. return replace(rx, "_", " ") ;;
  956. DELIMITER ;
  957. /*!50003 SET sql_mode = @saved_sql_mode */ ;
  958. /*!50003 SET character_set_client = @saved_cs_client */ ;
  959. /*!50003 SET character_set_results = @saved_cs_results */ ;
  960. /*!50003 SET collation_connection = @saved_col_connection */ ;
  961. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  962.  
  963. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  964. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  965. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  966. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  967. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  968. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  969. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  970.  
  971. -- Dump completed on 2018-11-12 11:07:14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!