--
-- Host: localhost    Database: imatter
-- ------------------------------------------------------


--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  `activationkey` varchar(150) NOT NULL,
  `accountactivated` tinyint(1) NOT NULL DEFAULT '0',
  `activationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `object` varchar(1) NOT NULL DEFAULT 'c',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` VALUES (1,'custmr_1','40bd001563085fc35165329ea1ff5c5ecbdbbeef','88b496cab076c092c564e40d69a70d175fb00bcc8e95da13161f34f61dd60e1159352203cee111a6220afc980fd548ac9e3506d424da7084ac0f157f',1,'2017-01-09 07:47:45','c'),(7,'providr_1','40bd001563085fc35165329ea1ff5c5ecbdbbeef','8e95da13161f34f61dd60e1159352203cee111a65c34be38938582c4bcdf0663fe01dce87ad97b1aa940cd4bb7caa4cdb8040f057910d0462b1fb78b',1,'2017-01-09 07:48:01','p'),(8,'custmr_2','40bd001563085fc35165329ea1ff5c5ecbdbbeef','90b496cab076c092c564e40d69a70d175fb00bcc8e95da13161f34f61dd60e1159352203cee111a6220afc980fd548ac9e3506d424da7084ac0f157f',1,'2017-01-09 08:38:06','c'),(9,'providr_2','40bd001563085fc35165329ea1ff5c5ecbdbbeef','7b95da13161f34f61dd60e1159352203cee111a65c34be38938582c4bcdf0663fe01dce87ad97b1aa940cd4bb7caa4cdb8040f057910d0462b1fb78b',1,'2017-01-09 08:38:18','p');

--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datec` date NOT NULL,
  `duration` int(3) NOT NULL,
  `customerid` int(11) NOT NULL,
  `providerid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `appointments`
--

INSERT INTO `appointments` VALUES (3,'2016-06-22',15,1,8),(4,'2016-06-16',15,1,4);

--
-- Table structure for table `billing`
--

CREATE TABLE `billing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lastname` varchar(300) NOT NULL,
  `firstname` varchar(300) NOT NULL,
  `address` varchar(250) NOT NULL,
  `city` varchar(250) NOT NULL,
  `zip` int(10) NOT NULL,
  `country` varchar(3) NOT NULL,
  `email` varchar(300) NOT NULL,
  `cellphone` varchar(20) NOT NULL,
  `sameasprofile` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing`
--

INSERT INTO `billing` VALUES (1,'Chaney','Winter',',njbhj nhhj ','Caï¿½as',129,'AO','lobortis.quis.pede@sodalesat.co.uk','(04) 2941 7525',1),(2,'Chaney','Winter','rdgdfsgsdfgdfg','Caï¿½as',129,'AO','lobortis.quis.pede@sodalesat.co.uk','(04) 2941 7525',0);

--
-- Table structure for table `cnsiq_customers`
--

CREATE TABLE `cnsiq_customers` (
  `cnsiq_questionid` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `answer` int(11) NOT NULL,
  PRIMARY KEY (`cnsiq_questionid`,`customerid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cnsiq_customers`
--


--
-- Table structure for table `cnsiqcodes`
--

CREATE TABLE `cnsiqcodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(250) NOT NULL,
  `categoryid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cnsiqcodes`
--

INSERT INTO `cnsiqcodes` VALUES (9,'More often than not, I have little interest or pleasure in doing things',1),(10,'Often I find myself feeling down, depressed, or hopeless',1),(11,'Lately to me everything is an effort',1),(12,'Often I am feeling bad about myself - I feel worthless',1),(13,'I have thoughts that I would be better off dead, or of suicide',1),(14,'Often I am feeling tired or having little energy',1),(15,'I have trouble falling or staying asleep, or sleeping too much',1),(16,' have poor appetite or I find myself overeating',1),(17,'I have trouble concentrating on things, such as reading the newspaper or watching television',1),(18,'During the low phases, my ability to function at work or socially is impaired',1),(19,'I notice that my mood and/or energy levels shift drastically from time to time',2),(20,'During these high periods, I feel over energized or feel hyper',2),(21,'During these high periods, I may feel irritable, on edge, or aggressive',2),(22,'During the high periods, I may take on too many activities at once',2),(23,'During these high periods, I feel I can go on much less sleep',2),(24,'During these high periods, I may spend money in ways that cause me trouble',2),(25,'I may be more talkative, outgoing or sexual during these periods',2),(26,'During the high periods, I did things that other people might have thought were excessive, foolish, or risky',2),(27,'Sometimes, I increase my alcohol or nonprescription drug use during the high periods',2),(28,'I am often feeling nervous, anxious, or on edge',3),(29,'I am not being able to sleep or control worrying',3),(30,'I am worrying too much about different things',3),(31,'I have trouble relaxing',3),(32,'I am being so restless that it is hard to sit still',3),(33,'I often become easily annoyed or irritable',3),(34,'I am feeling afraid, as if something awful might happen',3),(35,'I avoid situations where I may feel panicky',3),(36,'I see or hear things that other people cannot see or hear',4),(37,'I have heard two or more voices conversing with one another in voices that other people would not be able to hear',4),(38,'I think other people can sometimes read my mind, or I can read other\'s minds',4),(39,'I believe I have special or supernatural powers/gifts beyond my natural talents',4),(40,'I feel that other people are watching me or talking about me',4),(41,'I feel mistrustful or suspicious of other people',4),(42,'I believe that someone may be planning to cause me harm, or may be about to cause me harm in the near future',4),(43,'From a horrible and very bad experience in life, I have had nightmares about it or thought about it when I did not want to',5),(44,'I have tried hard not to think about this bad experience or went out of my way to avoid situations that reminded me of it',5),(45,'Ever since this bad experience, I am constantly on guard, watchful, or easily startled',5),(46,'Ever since this bad experience, I have often felt numb or detached from others, activities, or my surroundings',5),(47,'In the last 2 weeks my sleep has not been refreshing',6),(48,'In the last 2 weeks I did not got enough sleep',6),(49,'In the last 2 weeks I have had trouble falling asleep',6),(50,'I am tired, fatigued or sleepy on most days',6),(51,'I am told I snore at night',6),(52,'I doze off while watching TV, reading, or during short traffic stops while driving',6),(53,'I am having a hard time staying awake during the day',6),(54,'I find myself always worried about my weight, how I look, and about food',7),(55,'Often people tell me I am too thin, even though I feel fat',7),(56,'I overeat, feel guilty, and make myself throw up or use other means to loose weight',7),(57,'I have often felt that I ought to cut down on my drinking or drug use',8),(58,'I feel annoyed by being criticized by other people on my drinking or drug use',8),(59,'I have often felt bad or guilty about my drinking or drug use',8),(60,'I have had a drink or used drugs first thing in the morning to steady my nerves or to get rid of a hangover',8),(61,'I often find myself engaged in performing repetitive impulsive behavior over which I feel I have very little control, yet having a sense of relief when I do it',9),(62,'I often feel overly active and compelled to do things, like I was driven by a motor',9),(63,'When a task that requires a lot of thought, I avoid or delay getting started',10),(64,'I often have difficulty keeping my attention when I am doing boring or repetitive work',10),(65,'I often get distracted by activity or noise around me',10),(66,'I often have difficulty waiting my turn in situations when turn taking is required',10),(67,'I often interrupt others when they are busy',10),(68,'I often have difficulty getting things in order when I have to do a task that requires organization',10),(69,'I often have trouble wrapping up the final details of a project, once the challenging parts have been done',10);

--
-- Table structure for table `cnsiqcodes_categories`
--

CREATE TABLE `cnsiqcodes_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cnsiqcodes_categories`
--

INSERT INTO `cnsiqcodes_categories` VALUES (1,'DEPRESSION'),(2,'MANIC-DEPRESSION'),(3,'ANXIETY/PANIC'),(4,'THOUGHT DISORDER/PHOBIA'),(5,'PTSD (Post Traumatic Stress Disorder)'),(6,'SLEEP DISORDERS'),(7,'EATING DISORDER '),(8,'ALCOHOL/DRUG ABUSE'),(9,'IMPULSIVITY'),(10,'ATTENTION DEFICIT DISORDER');

--
-- Table structure for table `communications`
--

CREATE TABLE `communications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `communications`
--

INSERT INTO `communications` VALUES (0,'Default Option'),(1,'Via Phone'),(2,'Video Chat');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` varchar(2) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES ('AF','Afghanistan'),('AL','Albania'),('DZ','Algeria'),('DS','American Samoa'),('AD','Andorra'),('AO','Angola'),('AI','Anguilla'),('AQ','Antarctica'),('AG','Antigua and Barbuda'),('AR','Argentina'),('AM','Armenia'),('AW','Aruba'),('AU','Australia'),('AT','Austria'),('AZ','Azerbaijan'),('BS','Bahamas'),('BH','Bahrain'),('BD','Bangladesh'),('BB','Barbados'),('BY','Belarus'),('BE','Belgium'),('BZ','Belize'),('BJ','Benin'),('BM','Bermuda'),('BT','Bhutan'),('BO','Bolivia'),('BA','Bosnia and Herzegovina'),('BW','Botswana'),('BV','Bouvet Island'),('BR','Brazil'),('IO','British Indian Ocean Territory'),('BN','Brunei Darussalam'),('BG','Bulgaria'),('BF','Burkina Faso'),('BI','Burundi'),('KH','Cambodia'),('CM','Cameroon'),('CA','Canada'),('CV','Cape Verde'),('KY','Cayman Islands'),('CF','Central African Republic'),('TD','Chad'),('CL','Chile'),('CN','China'),('CX','Christmas Island'),('CC','Cocos (Keeling) Islands'),('CO','Colombia'),('KM','Comoros'),('CG','Congo'),('CK','Cook Islands'),('CR','Costa Rica'),('HR','Croatia (Hrvatska)'),('CU','Cuba'),('CY','Cyprus'),('CZ','Czech Republic'),('DK','Denmark'),('DJ','Djibouti'),('DM','Dominica'),('DO','Dominican Republic'),('TP','East Timor'),('EC','Ecuador'),('EG','Egypt'),('SV','El Salvador'),('GQ','Equatorial Guinea'),('ER','Eritrea'),('EE','Estonia'),('ET','Ethiopia'),('FK','Falkland Islands (Malvinas)'),('FO','Faroe Islands'),('FJ','Fiji'),('FI','Finland'),('FR','France'),('FX','France, Metropolitan'),('GF','French Guiana'),('PF','French Polynesia'),('TF','French Southern Territories'),('GA','Gabon'),('GM','Gambia'),('GE','Georgia'),('DE','Germany'),('GH','Ghana'),('GI','Gibraltar'),('GK','Guernsey'),('GR','Greece'),('GL','Greenland'),('GD','Grenada'),('GP','Guadeloupe'),('GU','Guam'),('GT','Guatemala'),('GN','Guinea'),('GW','Guinea-Bissau'),('GY','Guyana'),('HT','Haiti'),('HM','Heard and Mc Donald Islands'),('HN','Honduras'),('HK','Hong Kong'),('HU','Hungary'),('IS','Iceland'),('IN','India'),('IM','Isle of Man'),('ID','Indonesia'),('IR','Iran (Islamic Republic of)'),('IQ','Iraq'),('IE','Ireland'),('IL','Israel'),('IT','Italy'),('CI','Ivory Coast'),('JE','Jersey'),('JM','Jamaica'),('JP','Japan'),('JO','Jordan'),('KZ','Kazakhstan'),('KE','Kenya'),('KI','Kiribati'),('KP','Korea, Democratic People\'s Republic of'),('KR','Korea, Republic of'),('XK','Kosovo'),('KW','Kuwait'),('KG','Kyrgyzstan'),('LA','Lao People\'s Democratic Republic'),('LV','Latvia'),('LB','Lebanon'),('LS','Lesotho'),('LR','Liberia'),('LY','Libyan Arab Jamahiriya'),('LI','Liechtenstein'),('LT','Lithuania'),('LU','Luxembourg'),('MO','Macau'),('MK','Macedonia'),('MG','Madagascar'),('MW','Malawi'),('MY','Malaysia'),('MV','Maldives'),('ML','Mali'),('MT','Malta'),('MH','Marshall Islands'),('MQ','Martinique'),('MR','Mauritania'),('MU','Mauritius'),('TY','Mayotte'),('MX','Mexico'),('FM','Micronesia, Federated States of'),('MD','Moldova, Republic of'),('MC','Monaco'),('MN','Mongolia'),('ME','Montenegro'),('MS','Montserrat'),('MA','Morocco'),('MZ','Mozambique'),('MM','Myanmar'),('NA','Namibia'),('NR','Nauru'),('NP','Nepal'),('NL','Netherlands'),('AN','Netherlands Antilles'),('NC','New Caledonia'),('NZ','New Zealand'),('NI','Nicaragua'),('NE','Niger'),('NG','Nigeria'),('NU','Niue'),('NF','Norfolk Island'),('MP','Northern Mariana Islands'),('NO','Norway'),('OM','Oman'),('PK','Pakistan'),('PW','Palau'),('PS','Palestine'),('PA','Panama'),('PG','Papua New Guinea'),('PY','Paraguay'),('PE','Peru'),('PH','Philippines'),('PN','Pitcairn'),('PL','Poland'),('PT','Portugal'),('PR','Puerto Rico'),('QA','Qatar'),('RE','Reunion'),('RO','Romania'),('RU','Russian Federation'),('RW','Rwanda'),('KN','Saint Kitts and Nevis'),('LC','Saint Lucia'),('VC','Saint Vincent and the Grenadines'),('WS','Samoa'),('SM','San Marino'),('ST','Sao Tome and Principe'),('SA','Saudi Arabia'),('SN','Senegal'),('RS','Serbia'),('SC','Seychelles'),('SL','Sierra Leone'),('SG','Singapore'),('SK','Slovakia'),('SI','Slovenia'),('SB','Solomon Islands'),('SO','Somalia'),('ZA','South Africa'),('GS','South Georgia South Sandwich Islands'),('ES','Spain'),('LK','Sri Lanka'),('SH','St. Helena'),('PM','St. Pierre and Miquelon'),('SD','Sudan'),('SR','Suriname'),('SJ','Svalbard and Jan Mayen Islands'),('SZ','Swaziland'),('SE','Sweden'),('CH','Switzerland'),('SY','Syrian Arab Republic'),('TW','Taiwan'),('TJ','Tajikistan'),('TZ','Tanzania, United Republic of'),('TH','Thailand'),('TG','Togo'),('TK','Tokelau'),('TO','Tonga'),('TT','Trinidad and Tobago'),('TN','Tunisia'),('TR','Turkey'),('TM','Turkmenistan'),('TC','Turks and Caicos Islands'),('TV','Tuvalu'),('UG','Uganda'),('UA','Ukraine'),('AE','United Arab Emirates'),('GB','United Kingdom'),('US','United States'),('UM','United States minor outlying islands'),('UY','Uruguay'),('UZ','Uzbekistan'),('VU','Vanuatu'),('VA','Vatican City State'),('VE','Venezuela'),('VN','Vietnam'),('VG','Virgin Islands (British)'),('VI','Virgin Islands (U.S.)'),('WF','Wallis and Futuna Islands'),('EH','Western Sahara'),('YE','Yemen'),('YU','Yugoslavia'),('ZR','Zaire'),('ZM','Zambia'),('ZW','Zimbabwe');

--
-- Table structure for table `csettings`
--

CREATE TABLE `csettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyset` varchar(150) NOT NULL,
  `nameset` text NOT NULL,
  `type` set('int','text','set') NOT NULL,
  `options` text NOT NULL,
  `displayoptions` text NOT NULL,
  `defaultvalue` varchar(30) NOT NULL,
  `category` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `csettings`
--

INSERT INTO `csettings` VALUES (1,'Send an email when changes made in profile','Defines whether to send an email notification every time a change is made in the profile page','set','false,true','False,True','true','general'),(2,'Password validity period','Defines the period of validity of a password','set','90,120,150','90 days,120 days,150 days','90','general'),(3,'Communication default method','Defines the default method of communication to use for consultation','set','vchat,phone','Via Video Chat,Via Phone','email','appointments'),(4,'Set up reminder timing before meeting','Defines the period to set up a reminder alert before a meeting','set','5,10,15,20,25','5mins,10mins,15mins,20mins,25mins','10','appointments'),(5,'Reminder options','Defines the channel that the user would prefer to use for the reminder','set','sms,email','sms,email','email','appointments');

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ippid` int(11) NOT NULL,
  `payagreement_signed` tinyint(1) DEFAULT NULL,
  `payagreement_date` datetime DEFAULT NULL,
  `cnsiq_completed` tinyint(1) DEFAULT NULL,
  `billingid` int(11) DEFAULT NULL,
  `cnsiq_datecompletion` datetime DEFAULT NULL,
  `ckeystomer` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ippid` (`ippid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` VALUES (15,1,NULL,'2016-09-29 23:00:15',NULL,NULL,'2016-09-29 23:00:15','d2df8f0357844c2d9104198711f2d7a28c51ae7b'),(16,2,NULL,'2016-12-04 18:53:00',1,NULL,'2016-12-04 18:53:00','aa38cd5ca2aac37395b7a17dbfaf2c5a20dc4fd9');

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` varchar(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `samestate` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` VALUES ('DO','DO',1),('Masters','Masters',0),('MD','MD',1),('Other','Other',0),('PhD','PhD',0);

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` varchar(50) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` VALUES ('provider_registration_form','iMatter: We\'ve received your registration','\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n   <head>\r\n      <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n      <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"/>\r\n      <title>iMatter Registration</title>\r\n      <style type=\"text/css\">\r\n         /* Client-specific Styles */\r\n         #outlook a {padding:0;} /* Force Outlook to provide a \"view in browser\" menu link. */\r\n         body{width:100% !important; -webkit-text-size-adjust:100%; -ms-text-size-adjust:100%; margin:0; padding:0;}\r\n         /* Prevent Webkit and Windows Mobile platforms from changing default font sizes, while not breaking desktop design. */\r\n         .ExternalClass {width:100%;} /* Force Hotmail to display emails at full width */\r\n         .ExternalClass, .ExternalClass p, .ExternalClass span, .ExternalClass font, .ExternalClass td, .ExternalClass div {line-height: 100%;} /* Force Hotmail to display normal line spacing. */\r\n         #backgroundTable {margin:0; padding:0; width:100% !important; line-height: 100% !important;}\r\n         img {outline:none; text-decoration:none;border:none; -ms-interpolation-mode: bicubic;}\r\n         a img {border:none;}\r\n         .image_fix {display:block;}\r\n         p {margin: 0px 0px !important;}\r\n         table td {border-collapse: collapse;}\r\n         table { border-collapse:collapse; mso-table-lspace:0pt; mso-table-rspace:0pt; }\r\n         a {color: #33b9ff;text-decoration: none;text-decoration:none!important;}\r\n         /*STYLES*/\r\n         table[class=full] { width: 100%; clear: both; }\r\n         /*IPAD STYLES*/\r\n         @media only screen and (max-width: 640px) {\r\n         a[href^=\"tel\"], a[href^=\"sms\"] {\r\n         text-decoration: none;\r\n         color: #0a8cce; /* or whatever your want */\r\n         pointer-events: none;\r\n         cursor: default;\r\n         }\r\n         .mobile_link a[href^=\"tel\"], .mobile_link a[href^=\"sms\"] {\r\n         text-decoration: default;\r\n         color: #0a8cce !important;\r\n         pointer-events: auto;\r\n         cursor: default;\r\n         }\r\n         table[class=devicewidth] {width: 440px!important;text-align:center!important;}\r\n         table[class=devicewidthmob] {width: 420px!important;text-align:center!important;}\r\n         table[class=devicewidthinner] {width: 420px!important;text-align:center!important;}\r\n         img[class=banner] {width: 440px!important;height:157px!important;}\r\n         img[class=col2img] {width: 440px!important;height:330px!important;}\r\n         table[class=\"cols3inner\"] {width: 100px!important;}\r\n         table[class=\"col3img\"] {width: 131px!important;}\r\n         img[class=\"col3img\"] {width: 131px!important;height: 82px!important;}\r\n         table[class=\"removeMobile\"]{width:10px!important;}\r\n         img[class=\"blog\"] {width: 420px!important;height: 162px!important;}\r\n         }\r\n\r\n         /*IPHONE STYLES*/\r\n         @media only screen and (max-width: 480px) {\r\n         a[href^=\"tel\"], a[href^=\"sms\"] {\r\n         text-decoration: none;\r\n         color: #0a8cce; /* or whatever your want */\r\n         pointer-events: none;\r\n         cursor: default;\r\n         }\r\n         .mobile_link a[href^=\"tel\"], .mobile_link a[href^=\"sms\"] {\r\n         text-decoration: default;\r\n         color: #0a8cce !important; \r\n         pointer-events: auto;\r\n         cursor: default;\r\n         }\r\n         table[class=devicewidth] {width: 280px!important;text-align:center!important;}\r\n         table[class=devicewidthmob] {width: 260px!important;text-align:center!important;}\r\n         table[class=devicewidthinner] {width: 260px!important;text-align:center!important;}\r\n         img[class=banner] {width: 280px!important;height:100px!important;}\r\n         img[class=col2img] {width: 280px!important;height:210px!important;}\r\n         table[class=\"cols3inner\"] {width: 260px!important;}\r\n         img[class=\"col3img\"] {width: 280px!important;height: 175px!important;}\r\n         table[class=\"col3img\"] {width: 280px!important;}\r\n         img[class=\"blog\"] {width: 260px!important;height: 100px!important;}\r\n         td[class=\"padding-top-right15\"]{padding:15px 15px 0 0 !important;}\r\n         td[class=\"padding-right15\"]{padding-right:15px !important;}\r\n         }\r\n      </style>\r\n   </head>\r\n   <body>\r\n<!-- Start of preheader -->\r\n<table width=\"100%\" bgcolor=\"#dbdbdb\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" id=\"backgroundTable\" st-sortable=\"preheader\" >\r\n   <tbody>\r\n      <tr>\r\n         <td>\r\n            <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n               <tbody>\r\n                  <tr>\r\n                     <td width=\"100%\">\r\n                        <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n                           <tbody>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td width=\"100%\" height=\"10\"></td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td align=\"center\" valign=\"middle\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 10px;color: #303030;text-align:center;\" st-content=\"viewonline\">\r\n                                    If you can’t read this email.Please \r\n                                    <a href=\"#\" style=\"text-decoration: none; color: #7a6e67\">view online</a> \r\n                                 </td>\r\n                                 <!-- Spacing -->\r\n                              </tr>\r\n                              <tr>\r\n                                 <td width=\"100%\" height=\"10\"></td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                           </tbody>\r\n                        </table>\r\n                     </td>\r\n                  </tr>\r\n               </tbody>\r\n            </table>\r\n         </td>\r\n      </tr>\r\n   </tbody>\r\n</table>\r\n<!-- End of preheader -->      \r\n<!-- Start of header -->\r\n<table width=\"100%\" bgcolor=\"#d8d8d8\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" id=\"backgroundTable\" st-sortable=\"header\">\r\n   <tbody>\r\n      <tr>\r\n         <td>\r\n            <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n               <tbody>\r\n                  <tr>\r\n                     <td width=\"100%\">\r\n                        <table bgcolor=\"#FFF\" width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" style=\"border-top-left-radius:5px;border-top-right-radius:5px;\" class=\"devicewidth\">\r\n                           <tbody>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">&nbsp;</td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td>\r\n                                    <!-- logo -->\r\n                                    <table width=\"194\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                       <tbody>\r\n                                          <tr>\r\n                                             <td width=\"20\"></td>\r\n                                             <td width=\"174\" height=\"60\" align=\"left\">\r\n                                                <div class=\"imgpop\">\r\n                                                   <a target=\"_blank\" href=\"#\">\r\n                                                   Logo iMatter\r\n                                                   </a>\r\n                                                </div>\r\n                                             </td>\r\n                                          </tr>\r\n                                       </tbody>\r\n                                    </table>\r\n                                    <!-- end of logo -->\r\n\r\n                                 </td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td height=\"10\" style=\"font-size:1px; line-height:1px; mso-line-height-rule: exactly;\">&nbsp;</td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                           </tbody>\r\n                        </table>\r\n                     </td>\r\n                  </tr>\r\n               </tbody>\r\n            </table>\r\n         </td>\r\n      </tr>\r\n   </tbody>\r\n</table>\r\n<!-- End of Header -->\r\n<!-- Start of main-banner -->\r\n<table width=\"100%\" bgcolor=\"#d8d8d8\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" id=\"backgroundTable\" st-sortable=\"banner\">\r\n   <tbody>\r\n      <tr>\r\n         <td>\r\n            <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n               <tbody>\r\n                  <tr>\r\n                     <td width=\"100%\">\r\n                        <table width=\"560\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" class=\"devicewidth\">\r\n                           <tbody>\r\n                              <tr>\r\n                                 <!-- start of image -->\r\n                                 <td align=\"center\" st-image=\"banner-image\" bgcolor=\"8ec449\">\r\n                                    <table class=\"full\" align=\"center\" width=\"540\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"border-collapse:collapse; mso-table-lspace:0pt; mso-table-rspace:0pt;\"> \r\n                                       <tbody>\r\n                                          <tr> \r\n                                             <td width=\"100%\" height=\"30\">&nbsp; </td> \r\n                                          </tr> \r\n                                          <!-- START OF HEADING--> \r\n                                          <tr> \r\n\r\n                                             <td class=\"center\" align=\"center\" style=\"margin: 0; padding: 0 15px 15px 15px; margin:0; text-transform: uppercase; font-family: Helvetica, Arial; font-size: 23px; color: #ffffff; line-height: 34px; mso-line-height-rule: exactly;\"> \r\n                                                <span> Thank you for registering with us.</span> \r\n                                             </td> \r\n                                          </tr> \r\n                                          <!-- END OF HEADING--> \r\n                                          <!-- START OF TEXT--> \r\n                                          <tr> \r\n                                             <td class=\"center\" align=\"center\" style=\"margin: 0; padding:0 30px 0 30px; margin:0; font-size:14px ; color:#ffffff; font-family: Helvetica, Arial, sans-serif; line-height: 20px;mso-line-height-rule: exactly;\">\r\n                                                <span>Thank you for registering with iMatter.care as a provider. Your information is referred to our credentialing provider relations department. We will promptly send you an email regarding the status of your registration</span> \r\n                                             </td> \r\n                                          </tr> \r\n                                          <!-- END OF TEXT--> \r\n                                          <!-- START OF BUTTON-->\r\n                                          <tr> \r\n                                             <td align=\"center\" valign=\"middle\" style=\"padding-top: 20px;\"> \r\n                                                <table border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#ffffff\" style=\"margin: 0;\"> \r\n                                                   <tbody>  <tr>  \r\n                                                      <td align=\"center\" valign=\"middle\" bgcolor=\"#ffffff\" style=\"padding: 8px 20px; text-transform: uppercase; color:#666666; font-size:18px ; color:#ffffff; font-family: Helvetica, Arial, sans-serif; line-height: 28px; mso-line-height-rule: exactly;\"> \r\n                                                         <a href=\"#\" style=\"font-weight: normal; color:#444444; \"> GET BOOMERANG </a> \r\n                                                      </td> \r\n                                                   </tr> \r\n                                                </tbody>\r\n                                             </table> \r\n                                          </td> \r\n                                       </tr> \r\n                                       <!-- START OF BUTTON--> \r\n                                       <tr> \r\n                                          <td width=\"100%\" height=\"30\">&nbsp; </td> \r\n                                       </tr> \r\n                                    </tbody>\r\n                                 </table>\r\n                                   \r\n                                 </td>\r\n                              </tr>\r\n                           </tbody>\r\n                        </table>\r\n                        <!-- end of image -->\r\n                     </td>\r\n                  </tr>\r\n               </tbody>\r\n            </table>\r\n         </td>\r\n      </tr>\r\n   </tbody>\r\n</table>\r\n<!-- End of main-banner -->\r\n<!-- Start of postfooter -->\r\n<table width=\"100%\" bgcolor=\"#dbdbdb\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" id=\"backgroundTable\" st-sortable=\"preheader\" >\r\n   <tbody>\r\n      <tr>\r\n         <td>\r\n            <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n               <tbody>\r\n                  <tr>\r\n                     <td width=\"100%\">\r\n                        <table bgcolor=\"#ffffff\" width=\"560\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" class=\"devicewidth\">\r\n                           <tbody>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td width=\"100%\" height=\"10\"></td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                              <tr>\r\n                                 <td align=\"center\" valign=\"middle\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 13px;color: #7a6e67;text-align:center;\" st-content=\"viewonline\">\r\n                                    iMatter Registration System \r\n                                 </td>\r\n                              </tr>\r\n                              <tr>\r\n                                 <td align=\"center\" valign=\"middle\" style=\"font-family: Helvetica, arial, sans-serif; font-size: 13px;color: #7a6e67;text-align:center;\" st-content=\"viewonline\">\r\n                                    If you wish not to receive further updates.Please \r\n                                    <a href=\"#\" style=\"text-decoration: none; color: #303030\">Unsubscribe</a> \r\n                                 </td>\r\n                              </tr>\r\n                                 <!-- Spacing -->\r\n                              <tr>\r\n                                 <td width=\"100%\" height=\"10\"></td>\r\n                              </tr>\r\n                              <!-- Spacing -->\r\n                           </tbody>\r\n                        </table>\r\n                     </td>\r\n                  </tr>\r\n               </tbody>\r\n            </table>\r\n         </td>\r\n      </tr>\r\n   </tbody>\r\n</table>\r\n<!-- End of postfooter -->\r\n\r\n   </body>\r\n   </html>','Email sent to the provider when a registration is made.'),('user_changed_password','iMatter: Your password has changed','<p><span style=\\\"font-family:\'Segoe UI\'\\\">Dear {!firstname!}, <br /><br />Your password has been changed <br><br> The password for your iMatter account ({!username!}) was recently changed. This change was made from the following device or browser from: <br><br><br> Operating System/Browser: {!os_name!} <br> IP address: {!ip_address!} <br> Approximate location: {!location!}<br><br><br>If your iMatter password was changed without your knowledge, then please click the link below to reset it. This link will remain active for 25 hours from the time it was sent.. </span></p><span style=\\\"font-family:\'Segoe UI\'\\\"><p>Sincerely yours.<br />iMatter Automated System</p></span>','Email sent to the user when a password is changed'),('user_profile_changed','iMatter: We\'ve updated your profile information','<p><span style=\\\"font-family:\'Segoe UI\'\\\">Dear {!firstname!}, <br /><br />Your profile has been updated <br><br> As per your request, we have updated your profile information for your iMatter account ({!username!}). This change was made from the following device or browser from: <br><br><br> Operating System/Browser: {!os_name!} <br> IP address: {!ip_address!} <br> Approximate location: {!location!}<br> Information changed: {!whatischanged!}<br><br><br>If your iMatter profile was changed without your knowledge, then please contact the customer support. </span></p><span style=\\\"font-family:\'Segoe UI\'\\\"><p>Sincerely yours.<br />iMatter Automated System</p></span>','Email sent to the user when an information of his profile is changed');

--
-- Table structure for table `epps`
--

CREATE TABLE `epps` (
  `eppid` int(11) NOT NULL AUTO_INCREMENT,
  `lastname` varchar(300) NOT NULL,
  `middlename` varchar(300) DEFAULT NULL,
  `firstname` varchar(300) NOT NULL,
  `birthdate` date DEFAULT NULL,
  `sex` set('male','female') DEFAULT NULL,
  `maritalstatus` set('single','married','divorced','widowed','separated') DEFAULT NULL,
  `house_aptno` varchar(200) DEFAULT NULL,
  `streetname` varchar(250) DEFAULT NULL,
  `country` varchar(11) DEFAULT 'AZ',
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip` int(10) DEFAULT NULL,
  `address` text,
  `email` varchar(300) NOT NULL,
  `cellphone` varchar(20) DEFAULT NULL,
  `homephone` varchar(20) DEFAULT NULL,
  `workphone` varchar(20) DEFAULT NULL,
  `designation` varchar(11) DEFAULT NULL,
  `practicename` varchar(500) NOT NULL,
  `webaddress` varchar(500) DEFAULT NULL,
  `isboardcertified` tinyint(1) NOT NULL,
  `boardname` varchar(350) DEFAULT NULL,
  `boardyearsdone` int(2) DEFAULT '0',
  `areaspecialisation1` varchar(11) NOT NULL,
  `areaspecialisation2` varchar(11) NOT NULL,
  `areaspecialisation3` varchar(11) NOT NULL,
  `cvfilename` varchar(500) NOT NULL,
  `picture` varchar(300) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`eppid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `epps`
--

INSERT INTO `epps` VALUES (1,'Constantin','','Orekan',NULL,'','','','','AZ','','',NULL,'','c.orekan@ckolabs.com','009','','','DO','Dr. Quiz','',1,'Opns',5,'2','4','3','737510a0d1655614ef2d032b5f6e1d88778a1bb9c8f19f5df1adfd493754e2dd5b72e56bc6b355cf.pdf','default.jpg'),(2,'Naseem','','Chaudhry',NULL,'','','','','AZ','','',NULL,'','naseemcmd@yahoo.com','6307709387','','','MD','Naseem Chaudhry','',1,'Psychiatry and Neurology',1993,'1','1','1','1b0a56d9debfb3f98c39f700285d5004bc073e3f85812d85faa87f7058ae31bbe8c80704bbef7f2a.pdf','default.jpg');

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `photo_id` int(8) NOT NULL AUTO_INCREMENT,
  `photo_title` varchar(100) NOT NULL,
  `photo_description` text NOT NULL,
  `photo_file_name` varchar(100) NOT NULL,
  PRIMARY KEY (`photo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` VALUES (5,'Tommy','Tommy driving the train',''),(14,'Oscar','ssdsdcsdcsdc','13348858_991948020920510_811360831_n.jpg');

--
-- Table structure for table `ipps`
--

CREATE TABLE `ipps` (
  `ippid` int(11) NOT NULL AUTO_INCREMENT,
  `lastname` varchar(300) NOT NULL,
  `middlename` varchar(300) DEFAULT NULL,
  `firstname` varchar(300) NOT NULL,
  `birthdate` date DEFAULT NULL,
  `sex` set('male','female') DEFAULT NULL,
  `maritalstatus` set('single','married','divorced','widowed','separated') DEFAULT NULL,
  `address` varchar(250) NOT NULL,
  `house_aptno` varchar(200) DEFAULT NULL,
  `streetname` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip` int(10) DEFAULT NULL,
  `country` varchar(3) DEFAULT NULL,
  `email` varchar(300) NOT NULL,
  `cellphone` varchar(20) DEFAULT NULL,
  `homephone` varchar(20) DEFAULT NULL,
  `workphone` varchar(20) DEFAULT NULL,
  `occupation` varchar(300) DEFAULT NULL,
  `medicinsur_planname` varchar(300) DEFAULT NULL,
  `employerid` int(11) DEFAULT NULL,
  `picture` varchar(300) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`ippid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ipps`
--

INSERT INTO `ipps` VALUES (1,'Jimms','','Orlando','2016-09-01',NULL,NULL,'Yasmin Village, Rak, UAE',NULL,NULL,'Ras Al Khaimah',NULL,16168,'AE','c.orekan@ckolabs.com','0507501368',NULL,NULL,NULL,NULL,NULL,'default.jpg'),(2,'Alex','','Ponarm','1928-10-17',NULL,NULL,'Yasmin Village, Rak, UAE',NULL,NULL,'Ras Al Khaimah',NULL,16168,'AE','c.orekan@ckolabs.com','0507501368',NULL,NULL,NULL,NULL,NULL,'default.jpg');

--
-- Table structure for table `payplans`
--

CREATE TABLE `payplans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `duration` int(3) NOT NULL COMMENT 'in months',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payplans`
--

INSERT INTO `payplans` VALUES (1,'Yearly',12),(2,'Monthly',1);

--
-- Table structure for table `providers`
--

CREATE TABLE `providers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `startingtime` time NOT NULL,
  `endingtime` time NOT NULL,
  `workingdays` int(7) NOT NULL,
  `eppid` int(11) NOT NULL,
  `ckeyprovider` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `providers`
--

INSERT INTO `providers` VALUES (111,'00:00:00','00:00:00',0,1,'70ef526822c0326d0365bdb90f817ea4c5b3200e'),(112,'00:00:00','00:00:00',0,2,'af0eb9c34f9822832bb6f0ebd229cf0b835ef675');

--
-- Table structure for table `psessions`
--

CREATE TABLE `psessions` (
  `id` int(11) NOT NULL,
  `stimestamp` int(11) NOT NULL,
  `sipaddress` varchar(15) NOT NULL,
  `scountry` varchar(30) NOT NULL,
  `su_object` int(11) NOT NULL,
  `su_type_obj` set('su','sp','','') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `psessions`
--


--
-- Table structure for table `roscodes`
--

CREATE TABLE `roscodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(250) NOT NULL,
  `categoryid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `categoryid` (`categoryid`),
  CONSTRAINT `cat` FOREIGN KEY (`categoryid`) REFERENCES `roscodes_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roscodes`
--

INSERT INTO `roscodes` VALUES (1,'Fever',1),(2,'Weight Loss',1),(3,'Fatigue',1),(4,'Sweats',1),(5,'Chills',1),(6,'Loss of appetite',1),(7,'Change in vision',2),(8,'Double vision',2),(9,'Blood in eye',2),(10,'Red Eyes',2),(11,'Dry Eyes',2),(12,'Itchy Eyes',2),(13,'Pain in eyes',2),(14,'Discharge',2),(15,'Ringing in ears',3),(16,'Decreased hearing',3),(17,'Pain in Ears',3),(18,'Discharge from ears',3),(19,'Nose bleeds',3),(20,'Earlobe problems',3),(21,'Pain in Sinuses',3),(22,'Sore throat',3),(23,'Difficulty swallowing',3),(24,'Pain in mouth',3),(25,'Lump in throat ',3),(26,'Lump in mouth',3),(27,'Sores in mouth',3),(28,'Bleeding gums',3),(29,'Post nasal drip',3),(30,'Loose teeth',3),(31,'Chest pain',4),(32,'Skipped heartbeats',4),(33,'Palpitations',4),(34,'Pain in jaw',4),(35,'Pain in neck',4),(36,'High Blood Pressure',4),(37,'Blood clots',4),(38,'Peripheral edema',4),(39,'Shortness of breath',5),(40,'Wheezing',5),(41,'Pain with deep breath',5),(42,'Cough - dry',5),(43,'Cough up phlegm',5),(44,'Cough up blood',5),(45,'Pain on swallowing',6),(46,'Burps up food',6),(47,'Frequent belching',6),(48,'Frequent colon gas',6),(49,'Heartburn',6),(50,'Pain in stomach',6),(51,'Pain in rectal area',6),(52,'Vomiting',6),(53,'Nausea',6),(54,'Abdominal Pain',6),(55,'Vomited Blood',6),(56,'Change in bowel movements',6),(57,'Passed blood rectally',6),(58,'Food has problem going down',6),(59,'Pain in genitals',7),(60,'Pain with sex',7),(61,'Painful urination	',7),(62,'Unable to pass urine easily',7),(63,'Incontinent of urine',7),(64,'Impotence',7),(65,'Unable to get erection',7),(66,'Mass/Lump in genital area',7),(67,'Pain in pelvic area',8),(68,'Heavy periods',8),(69,'Painful Periods',8),(70,'No periods',8),(71,'Vaginal discharge or yeast',8),(72,'Pain with sex',8),(73,'Incontinent of urine',8),(74,'Pain on urination ',8),(75,'Unable to pass urine easily',8),(76,'Pain in neck',9),(77,'Pain in arms',9),(78,'Pain in legs',9),(79,'Pain in joints',9),(80,'Arthritis',9),(81,'Swelling in joints',9),(82,'Joint deformities',9),(83,'Rash',10),(84,'Itching',10),(85,'Red skin',10),(86,'Change in mole',10),(87,'Foot Ulcer',10),(88,'Foot Callous',10),(89,'Breast lump',10),(90,'Milk Production',10),(91,'Pain in breast',10),(92,'Hair loss',10),(93,'Nail deformities',10),(94,'Stroke',11),(95,'Unable to move arm',11),(96,'Unable to move leg',11),(97,'Difficulty speaking',11),(98,'Unable to balance',11),(99,'Unable to walk',11),(100,'Dizziness',11),(101,'Frequent headaches',11),(102,'Double vision',11),(103,'Change in sensations',11),(104,'Uncontrolled motions',11),(105,'Tremors',11),(106,'Pain in feet Numbness in feet or hands ',11),(107,'Unable to smile or move facial muscles',11),(108,'Blue mood',12),(109,'Depression',12),(110,'Feeling of helplessness',12),(111,'Difficulty sleeping',12),(112,'Tension',12),(113,'Paranoia',12),(114,'Anxiety',12),(115,'Memory problems',12),(116,'Agitation',12),(117,'Panic attacks',12),(118,'Compulsions',12),(119,'Seeing or hearing things that aren’t there. ',12),(120,'Thoughts of harming self or others	',12),(121,'Frequent urination',13),(122,'Excessive thirst',13),(123,'Hunger',13),(124,'Lump in neck',13),(125,'Enlarged thyroid',13),(126,'Dark skin',13),(127,'Changes in sex drive',13),(128,'Intolerance to heat/cold',13),(129,'Menstrual irregularities',13),(130,'Enlarged lymph nodes',14),(131,'Easy bruising',14),(132,'Enlarged spleen',14),(133,'Easy bleeding',14),(134,'Anemia',14),(135,'Allergies to weeds/ dusts',15),(136,'Food Allergies',15),(137,'Lupus',15),(138,'Easy to catch infections',15),(139,'Exposure to HIV',15),(140,'Itching',15);

--
-- Table structure for table `roscodes_categories`
--

CREATE TABLE `roscodes_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `conditions` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roscodes_categories`
--

INSERT INTO `roscodes_categories` VALUES (1,'Constitutional Symptoms',NULL),(2,'Eyes',NULL),(3,'Ears, Nose, Mouth, Throat',NULL),(4,'Cardiovascular',NULL),(5,'Respiratory',NULL),(6,'Gastrointestinal',NULL),(7,'Genital / Urinary For Men','sex==m'),(8,'Genital / Urinary For Women','sex==f'),(9,'Musculoskeletal',NULL),(10,'Skin, Hair, Breast',NULL),(11,'Neurological',NULL),(12,'Psychiatric',NULL),(13,'Endocrine (Glands)',NULL),(14,'Hematologic / Lymphatic',NULL),(15,'Allergic / Immunologic',NULL);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL,
  `stimestamp` int(11) NOT NULL,
  `sipaddress` varchar(15) NOT NULL,
  `scountry` varchar(30) NOT NULL,
  `su_object` int(11) NOT NULL,
  `su_type_obj` set('su','sp','','') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `sessions_ux`
--

CREATE TABLE `sessions_ux` (
  `id` varchar(20) NOT NULL,
  `topic` varchar(250) NOT NULL,
  `type` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `patient` int(11) NOT NULL,
  `datesession` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions_ux`
--

INSERT INTO `sessions_ux` VALUES ('711853454','Meeting with Patient Jimms',1,15,1,'2017-02-01 23:52:29'),('975898995','Meeting with Patient Jimms',1,15,1,'2017-02-01 23:53:09'),('660234915','Meeting with Patient Jimms',1,15,1,'2017-02-01 23:53:14'),('265314288','Meeting with Patient Jimms',1,15,1,'2017-02-02 00:10:53'),('709583119','Meeting with Patient Jimms',1,15,1,'2017-02-02 00:13:50'),('332547462','Meeting with Patient Jimms',1,15,1,'2017-02-02 00:26:42'),('512728997','Meeting with Patient Jimms',1,15,1,'2017-02-02 04:25:04');

--
-- Table structure for table `settings_cnsiq`
--

CREATE TABLE `settings_cnsiq` (
  `keygen` varchar(300) NOT NULL,
  `value` varchar(300) NOT NULL,
  PRIMARY KEY (`keygen`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings_cnsiq`
--

INSERT INTO `settings_cnsiq` VALUES ('THRESHOLD_VALUE_QUESTION','5'),('THRESHOLD_WEIGHT_QUESTION','50');

--
-- Table structure for table `settings_customers`
--

CREATE TABLE `settings_customers` (
  `customer_id` int(11) NOT NULL,
  `setting_id` int(11) NOT NULL,
  `value` varchar(50) NOT NULL,
  PRIMARY KEY (`customer_id`,`setting_id`),
  KEY `setting_id` (`setting_id`),
  KEY `customer_id` (`customer_id`),
  CONSTRAINT `settings_customers_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  CONSTRAINT `settings_customers_ibfk_2` FOREIGN KEY (`setting_id`) REFERENCES `csettings` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings_customers`
--

INSERT INTO `settings_customers` VALUES (15,3,'vchat'),(15,4,'10'),(15,5,'sms'),(16,3,'email'),(16,4,'15'),(16,5,'email');

--
-- Table structure for table `spec_designations`
--

CREATE TABLE `spec_designations` (
  `designation` varchar(11) NOT NULL,
  `specialisation` int(11) NOT NULL,
  PRIMARY KEY (`designation`,`specialisation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spec_designations`
--

INSERT INTO `spec_designations` VALUES ('DO',1),('DO',4),('DO',5),('Masters',3),('MD',1),('MD',4),('MD',5),('PhD',2);

--
-- Table structure for table `specialisations`
--

CREATE TABLE `specialisations` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `description` text NOT NULL,
  `ratesinitial` float NOT NULL COMMENT 'Rates of the consultation',
  `ratesfollowup` float NOT NULL,
  `connectnow` tinyint(4) DEFAULT NULL,
  `cnsiqrequired` tinyint(1) NOT NULL,
  `rosrequired` tinyint(1) NOT NULL,
  `discountstartup` float NOT NULL,
  `durationinitial` int(11) NOT NULL,
  `durationfollowup` int(11) NOT NULL,
  `choiceduration` tinyint(1) NOT NULL,
  `pharmarcyIsRequired` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `specialisations`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `state` varchar(22) NOT NULL,
  `state_code` char(2) NOT NULL,
  PRIMARY KEY (`state_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES ('Alaska','AK'),('Alabama','AL'),('Arkansas','AR'),('Arizona','AZ'),('California','CA'),('Colorado','CO'),('Connecticut','CT'),('District of Columbia','DC'),('Delaware','DE'),('Florida','FL'),('Georgia','GA'),('Hawaii','HI'),('Iowa','IA'),('Idaho','ID'),('Illinois','IL'),('Indiana','IN'),('Kansas','KS'),('Kentucky','KY'),('Louisiana','LA'),('Massachusetts','MA'),('Maryland','MD'),('Maine','ME'),('Michigan','MI'),('Minnesota','MN'),('Missouri','MO'),('Mississippi','MS'),('Montana','MT'),('North Carolina','NC'),('North Dakota','ND'),('Nebraska','NE'),('New Hampshire','NH'),('New Jersey','NJ'),('New Mexico','NM'),('Nevada','NV'),('New York','NY'),('Ohio','OH'),('Oklahoma','OK'),('Oregon','OR'),('Pennsylvania','PA'),('Rhode Island','RI'),('South Carolina','SC'),('South Dakota','SD'),('Tennessee','TN'),('Texas','TX'),('Utah','UT'),('Virginia','VA'),('Vermont','VT'),('Washington','WA'),('Wisconsin','WI'),('West Virginia','WV'),('Wyoming','WY');

--
-- Table structure for table `workingschedule`
--

CREATE TABLE `workingschedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datew` date NOT NULL,
  `starts` time NOT NULL,
  `ends` time NOT NULL,
  `providerid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `workingschedule`
--


--
-- Dumping events for database 'imatter'
--

--
-- Dumping routines for database 'imatter'
--


