
--
-- Table structure for table `host`
--

CREATE TABLE `host` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`Db`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges;  Merged with database privileges';

--
-- Dumping data for table `host`
--


--
-- Table structure for table `ndb_binlog_index`
--

CREATE TABLE `ndb_binlog_index` (
  `Position` bigint(20) unsigned NOT NULL,
  `File` varchar(255) NOT NULL,
  `epoch` bigint(20) unsigned NOT NULL,
  `inserts` bigint(20) unsigned NOT NULL,
  `updates` bigint(20) unsigned NOT NULL,
  `deletes` bigint(20) unsigned NOT NULL,
  `schemaops` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`epoch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ndb_binlog_index`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--


--
-- Table structure for table `proc`
--

CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';

--
-- Dumping data for table `proc`
--


--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'','2014-03-07 19:18:48'),('addictionacademy','root','','',1,'','2014-03-07 19:18:48');

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--


--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT '0',
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin DEFAULT '',
  `authentication_string` text COLLATE utf8_bin,
  PRIMARY KEY (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','root','*76FD07A2EED651AD5CE0E393C3A8C9011B0FE506','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('addictionacademy','root','*76FD07A2EED651AD5CE0E393C3A8C9011B0FE506','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('127.0.0.1','root','*76FD07A2EED651AD5CE0E393C3A8C9011B0FE506','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('::1','root','*76FD07A2EED651AD5CE0E393C3A8C9011B0FE506','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('localhost','debian-sys-maint','*881103258FC301A8C7F798793FDCA36D40A72E79','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL);

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `thread_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `query_time` time NOT NULL,
  `lock_time` time NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

--
-- Current Database: `ourplace_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ourplace_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `ourplace_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (4,'Aggression Management','The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. ','<strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: <br><br><ol><li>Define “Aggression” and “Verbal De-escalation\" <br></li><li>Identify warning signs for aggressive behavior. <br></li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',NULL,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,''),(10,'Sexual Harassment','After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.','After completing this self-study session, you will be able to:<br><ul><li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',70,'0','Online',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'All Staff'),(2,'Direct Care');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (9,4,2,1),(19,10,1,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--


--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--


--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Compliance Training');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=869 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(785,141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(786,141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(787,141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(788,141,'Unwelcome, physical in nature and occur in the workplace',NULL),(789,142,'Making derogatory or sexually explicit comments',NULL),(790,142,'Displaying sexually suggestive posters',NULL),(791,142,'Making unwanted physical contact',NULL),(792,142,'All of the above',1),(793,143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(794,143,'Behavior that makes the workplace uncomfortable ',NULL),(795,143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(796,143,'Sexually explicit offensive comments',NULL),(797,144,'Express yourself verbally',NULL),(798,144,'Tell the harasser the behavior is making you uncomfortable',NULL),(799,144,'Express yourself non verbally',NULL),(800,144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(801,144,'All of the above',1),(802,145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(803,145,'Files a discrimination charge',NULL),(804,145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(805,145,'All of the above',1),(810,148,'True',1),(811,148,'False',NULL),(812,149,'True',1),(813,149,'False',NULL),(814,150,'True',1),(815,150,'False',NULL),(816,151,'True',NULL),(817,151,'False',1),(818,152,'True',NULL),(819,152,'False',1),(820,154,'Yes',1),(821,154,'No',NULL),(822,155,'Yes',NULL),(823,155,'No',1),(824,156,'Yes',1),(825,156,'No',NULL),(865,146,'True',1),(866,146,'False',NULL),(867,147,'True',1),(868,147,'False',NULL);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL),(57,'To paraphrase means?',4,452,NULL),(58,'Active listening involves:',4,414,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL),(85,'Verbal de-escalation is the communication skills we use during a potentially dangerous, or threatening, situation in an attempt to prevent a person from causing harm to us, themselves or others. ',4,459,NULL),(141,'According to EEOC in order for behavior to be considered sexual harassment it must be ',10,786,NULL),(142,'A co-worker or supervisor can create a hostile work environment when they engage in one or more of the following behaviors:',10,792,NULL),(143,'The Quid Pro Quo theory of sexual harassment involves:',10,793,NULL),(144,'IF you feel you are the victim of unwelcome sexual behavior you are encouraged to:',10,801,NULL),(145,'It is illegal for an employer or other employees to retaliate against any individual who:',10,805,NULL),(146,'Sexual Harassment in employment is legally recognized as a form of sex discrimination and is illegal.',10,865,NULL),(147,'Sexual harassment can occur outside the work site and still be considered work related.',10,867,NULL),(148,'Quid Pro Quo harassment is a form of sexual harassment when there is a request or demand of sexual favors in exchange for employment benefits or threatening reprisals if the favors are not given.',10,810,NULL),(149,'Friendly flirting is not sexual harassment when flirting is practiced between mutually consenting individuals who are equal in power or authority.',10,812,NULL),(150,'An employee witnesses another employee being harassed. Even though this involved a co-worker, the witness can be considered a victim in this case.',10,814,NULL),(151,'In order for it to be determined sexual harassment, the victim has to be of the opposite sex of the harasser.',10,817,NULL),(152,'It is solely the company’s responsibility to prevent sexual harassment',10,819,NULL),(154,'Adella wants Antonio to feel part of the team and tries to encourage his participation. She approaches him more frequently than the other workers and she is constantly touching his shoulder and arm. Antonio feels uncomfortable with Adella invading his personal space and grimaces as she touches his shoulders. His facial and body expressions clearly indicate his annoyance. Could this be considered sexual harassment?”',10,820,NULL),(155,'Karen Linda and Elis have become good friends and sit together at lunch. They decided to have some fun by rating the men in the lunchroom. Joking, they rate the men who walk into the lunchroom and discuss the ratings with each other. Ted, a male therapist, who is sitting at a nearby table overhears their remarks. He finds the behavior offensive and unprofessional. Ted reports the incident to HR when he returns from lunch. Was the women’s behavior sexual harassment?',10,823,NULL),(156,'Susan, the director of marketing, has several employees reporting to her. One of the employees, John, has been called into her office right before lunch. Susan requests that John have lunch with her to discuss one of the major accounts that he is trying to acquire. John agrees to the lunch and realizes that this is a good opportunity to explain some of the problems he has encountered. While John and Susan are out at lunch she puts her hand on his leg and says she wants him to do well in the company and would like him to come over to her place tonight. Is this considered sexual harassment?',10,824,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'OPlace2015',NULL,'<h4>South Campus</h4>\n6555 NW 9th Avenue, Suite 210<br>\nFt. Lauderdale, FL 33309<br>\nPhone: (877) 944-4235<br>\nFax: (954) 771-2098','<h4>North Campus</h4>\n4731 West Atlantic Avenue, Ste B16<br>\nDelray Beach, FL 33445<br>',1);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,0,1,NULL),(11,'Cornell','Peters','cjp@fortriscorp.com','02ddfa996b303cd6e1f57c9a51243e5f2b9ef3c5133959cda431d4395f39b3db',2,6,1982,'2014-03-08 02:31:35',63198034,1,0,1,NULL),(12,'mary','Curtis','marytcurtis@comcast.net','36fc8dffff1b4fa0c4de6df5483d2d358b729c2fb9f41b45c9f95f13e782f2bd',26,10,1960,'2014-03-10 15:33:21',82939153,1,4,1,NULL),(13,'CJ','Peters','info@fortriscorp.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1991,'2014-08-05 22:35:19',72423850,1,0,1,NULL),(14,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1948,'2014-08-06 02:19:45',60313016,1,114,1,NULL),(16,'nmn','FG','maryc@destinationhope.net','a472394adf994d65bdaa0e07a02b8715479b96aa35de4281e2a29efe8c0f0707',26,10,1960,'2014-08-29 20:20:10',23609755,1,0,0,NULL),(17,'Maura','Curtis','mary@marytcurtis.com','23f3625ad3b8ae045637690d072faf49e54f111a86ff0b4090753772770c7c36',24,6,1968,'2014-09-06 23:50:20',38805799,1,0,0,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--

INSERT INTO `user_course_access` VALUES (1,10,10,'In Progress',NULL,0);

--
-- Current Database: `quantum_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `quantum_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `quantum_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` varchar(90) DEFAULT NULL,
  `staff_requirement` varchar(90) DEFAULT NULL,
  `required_within_time` varchar(90) DEFAULT NULL,
  `in_person` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (3,'HIV / AIDS - 2 CEU','HIV is an acronym for human immunodeficiency virus and it is the disease that often leads to AIDS. Continuing Education Course (2 CEUs)','<p style=\"margin: 0px; padding: 0px; font-size: 12px; color: rgb(68, 68, 68); line-height: 18px; font-family: helvetica, arial, sans-serif;\">This class provides information on HIV and AIDS- related illnesses. Materials will be presented on the symptoms, causes, pathophysiology, diagnosis, transmission and prevention, treatment, epidemiology, prognosis, and history of HIV and AIDS.</p>',80,'0','Online Only',NULL,'Online-HIVAIDS-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'30','0'),(4,'Aggression Management - 2 CEU','The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. ','<strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: <br><br><ol><li>Define “Aggression” and “Verbal De-escalation\" <br></li><li>Identify warning signs for aggressive behavior. <br></li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',80,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(5,'Infection Control - 1 CEU','Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p>\r\n<ul>\r\n<li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li>\r\n<li>Take action to prevention of the spread of disease in your workplace</li>\r\n</ul>\r\n\r\n\r\n\r\n',80,'0','Online Only',NULL,'Online-InfectionControl-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,NULL),(7,'HIPAA - 2 CEU','Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.','<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"><br></p>\r\n<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">This course is designed to:</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"></p><ol><li>Give you an overview of The Health Insurance Portability and Accountability Act of 1996 (HIPAA).</li><li>Familiarize you with any major changes that have been implemented with the new 2013 Omnibus Rule Changes.</li><li>Help you recognize the serious consequences if you fail to comply with HIPAA.</li></ol><p></p>\r\n\r\n',80,'0','Online Only',NULL,'Online-HIPAA-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(8,'The American’s With Disability Act - 1 CEU','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.',80,'0','Online',NULL,'ADAonlinefinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,NULL),(9,'Abuse Reporting & Affirmative Duties - 1 CEU','Every individual in Florida has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to report abuse or neglect. This course will take you through the legal requirements in Florida regarding abuse reporting and affirmative duties.','<p>Everyone in Florida is a mandated reporter but some people are professionally mandated reporters. Every person has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to do so. These professionals are mandated to make a report if they have reasonable  cause to suspect abuse, neglect or exploitation is of a child or a vulnerable adult. Providers of substance abuse services shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under Chapter 39, F.S., and of adults under Section 415.1034 and paragraph 397.501(7)(c), F.S.</p>',80,'0','Online',NULL,'finalcurrentchapter 415.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'','730',NULL,'90','0'),(10,'Sexual Harassment - 2 CEU','After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.','<p>After completing this self-study session, you will be able to:</p><ul>\r\n<li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',80,'0','Online',NULL,'finalsexualharassment.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'90','0'),(11,'Domestic Violence - 2 CEU','This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.','This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.&nbsp;\r\n<div><br></div><div>Upon completion of this course the participant will:&nbsp;</div><div><ul><li><span style=\"font-size: 10pt;\">Be able to define domestic violence.</span></li><li><span style=\"font-size: 10pt;\">Be able to discuss the statistics related to domestic violence.</span></li><li><span style=\"font-size: 10pt;\">Develop an understanding of the impact and consequences of domestic violence on the\r\nvictim from a health, psychological, and emotional perspective.</span></li><li><span style=\"font-size: 10pt;\">Be able to assess, counsel and formulate safety plans for clients at risk of domestic violence\r\nor who are currently in a violence relationship.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">Be able to identify national and local domestic violence resources.</span></li></ul></div>',80,'0','Online Only',NULL,'finaldomesticviolence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(12,'Understanding Co-occurring Disorders - 2 CEU','Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders.','Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders. &nbsp;<div><br></div><div>On completion of this course, participants will be able to identify/demonstrate familiarity with:&nbsp;</div><div><ol><li><span style=\"font-size: 10pt;\">The definition and terms related to co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The assessment of co-occurring disorders and common symptoms.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The relationship between substance abuse and mental health concerns.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The symptoms of specific co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">Available treatments for clients with co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">A special population example and co-occurring disorders.</span></li></ol></div>',80,'0','Online',NULL,'Co-Occuring Disorders.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(13,'Ethics & Boundaries - 2 CEU','The purpose of this training is to clarify professional ethical expectations for addiction professionals, assist in defining professional boundaries, and highlight potential boundary problems.','<p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\">The purpose of this training is to clarify professional ethical expectations for addiction professionals, assist in defining professional boundaries, and highlight potential boundary problems.</p><p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\">Upon completion of this course the participant will:</p><p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\"></p><ol><li>Be able to understand and define ethics.</li><li>Understand and be able to demonstrate ethical and professional behavior.</li><li>Be able to define, implement and practice client informed consent.</li><li>Be able to define and recognize boundary issues between client and counselor.</li><li>Be able to define and interpret the roles of transference, counter-transference and other potential boundary issues in clinical practice.</li></ol><p></p>',80,'0','Online Only',NULL,'ethicsfinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(14,'Suicide and Self-Harm - 2 CEU','Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is temporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.','Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is\r\ntemporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.',80,'0','',NULL,'AAP-Suicide-Self-Harm.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(15,'Cultural Diversity - 2 CEU','','',80,'0','Online Only',NULL,NULL,NULL,NULL,'Cultural-Diversity.ppsx',NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL),(25,'Incident Reporting Requirements - 1 CEU','All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting.','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting. This course details the internal procedure for completing and filing an incident report form for an unusual event, as well as, the procedure for reporting a critical incident to the DCF and Joint Commission.</p>',80,'0','',NULL,'AAP-Incident-Reporting.pdf','Incident-Reporting-Appendix.pdf',NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,'0');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Continuing Education'),(2,'Personal Development'),(3,'Communication'),(4,'Management & Leadership'),(5,'Marketing'),(6,'Organizational Efficiency'),(7,'Certified Behavioral Health Technician (CBHT)');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (9,4,1,1),(13,5,1,1),(14,11,1,1),(15,12,1,1),(16,15,1,1),(17,13,1,1),(18,14,1,1),(19,7,1,1),(20,8,1,1),(21,10,1,1),(22,3,1,1),(23,25,1,1),(24,9,1,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (15,4,1427386170,'kris schupbach','learning','nothing\r\n','nothing','yes','same',5),(16,4,1427421842,'Deshaun Jones','The Different types of barriers.','Nothing,Everything was informative. ','I think this was well but together.','Yes it was.','First time taken this course in the future I will no a little more about these courses and will be able to choice..',4),(17,5,1427423480,'Deshaun Jones ','The different types of diseases that\'s out there','Everything was very informative','Nothing','Yes is was','',4),(18,5,1427423580,'Deshaun Jones ','The different types of diseases that\'s out there','Everything was very informative','Nothing','Yes is was','First time take course',5),(19,4,1427435159,'William Robinson ','Very easy to understand ','Nothing','Nothing','Yes','Searching a client ',3),(20,4,1427498282,'a','everythig','othing','nothing','yes','cpr',3),(21,5,1431426018,'Joyns Fleming','ease of use','information was valuable','nothing','yes','computerized',5),(22,11,1433064894,'Robert Elvir','The clear presentation.','Lack of A/V aides.','Add A/V aids.','yes','Laws',3),(23,13,1433270595,'','','','','','',5),(24,12,1433271685,'Ron Cook','','','','','',4),(25,11,1433864218,'Albert Diaz','Wording.','Obvious','None','Yes','Same',4),(26,5,1433864456,'Albert Diaz','Yes','Yes','Nothing','Yes','All',4),(27,5,1433864459,'Albert Diaz','Yes','Yes','Nothing','Yes','All',4),(28,9,1433946160,'Ron Cook','','','','','',4),(29,14,1433946716,'Ron Cook','','','','','',4),(30,12,1434374865,'Pedro Diaz','','','','','',5),(31,13,1434375773,'Pedro Diaz','','','','','',4),(32,9,1434375995,'Pedro Diaz','','','','','',5),(33,14,1434376329,'Pedro Diaz','','','','','',4),(34,15,1434376575,'Pedro Diaz','','','','','',4),(35,5,1435166762,'','','','','','',5),(36,4,1454952013,'Eric Crear','it was quick','nothing','nothing','yes','The same',5),(37,4,1455022353,'Al Diaz','Everything.','Reading.','Nothing.','Yes.','All types.',5),(38,4,1455045695,'','','','','','',5),(39,5,1455491901,'Melanie Duffy','Very informative.','It was all fine. No complaints.','I have no answer for that.','Yes, it was well written.','Psychopharmacology',4),(40,5,1455640585,'Burt Boyle','All','All','Good','Yes it was','',5),(41,11,1458136526,'Pedro Diaz','Convenience. ','It was all good.','Don\'t know.','It was interesting.','Don\'t know.',4),(42,4,1459528711,'Sonya Skinner','Everything.','None.','Nothing, great course!!','Very stimulating, thank you.','',5),(43,14,1460250321,'Sonya Skinner','Everything','N/A','Nothing','Yes','',5),(44,7,1460252018,'Sonya Skinner','Everything','Nothing','Nothing','Yes','',5),(45,5,1461184659,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','Required courses to renew our credentials.',5),(46,11,1461186639,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','Required courses to renew our credentials.',5),(47,15,1461465425,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','CEU\'s that are needed to nenew our nursing credentials.',5),(48,12,1461468529,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU\'s that pertain to our nursing credentials.',5),(49,13,1461776358,'Sonya Skinner','Everything','None','Nothing','Very stimulating.','CEU\'s needed for licensure.',5),(50,8,1461860606,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','CEU\'s pertaining to renewal of licensure.',5),(51,8,1462002614,'Joyns Fleming','everything','nothing','nothing','very','same',5),(52,10,1462487919,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU on Medical Errors, required for our licensure!',5),(53,3,1463162417,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU\'s  that are required for licensure.',5),(54,5,1487903557,'Andrea Bonkosky','that the course is online. ','the web portal was down at times','n/a','yes.','n/a',4),(55,25,1488072433,'Andrea Bonkosky','It\'s offered online and I can access at any time.','n/a. the course was great.','n/a. the course was great. ','yes.','No other courses at this time. ',4),(56,5,1488072513,'Andrea Bonkosky','I can access the course online at any time. ','n/a. I enjoyed the course.','n/a. I enjoyed the course.','yes. ','no other courses at this time. ',4),(57,8,1488072656,'Andrea Bonkosky','I can access the course online at any time. ','n/a. I enjoyed the course. ','n/a. ','Yes. ','no other courses at this time. ',4),(58,10,1488075475,'Andrea Bonkosky','It was online and was accessible at all times. ','Experienced problems with the portal. The exam was not loading. Once it loaded, it shows me as taking it 5 times; when in fact, it was taken and passed successfully on the first attempt. ','Experienced problems with the web portal that requiring fixing. ','yes. ','n/a',4),(59,11,1488076863,'Andrea Bonkosky','I can access course online at any time. ','I had to take the exam several times due to experiencing technical difficulties with loading the portal among other factors. ','n.a','yes.','none at this time. ',3),(60,13,1488078041,'Andrea Bonkosky','online course that can be accessed online at any time. ','none at this time. ','none at this time','yes.','none at this time',3),(61,15,1488078303,'Andrea Bonkosky','The course can be accessed online at any time. ','too short. not enough information covered. important information was left out. ','n.a','no','a more developed cultural competency course. ',1),(62,12,1488079543,'Andrea Bonkosky','The course is accessible online. ','n/a','n/a','yes.','I can\'t think of any at this time. ',4),(63,3,1488163905,'Theodore Thompson ','','','','','',5);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (1,111,4,93);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3),(1,4),(1,5);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Professional Development');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11971 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(463,26,'True',1),(464,26,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(479,34,'True',1),(480,34,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(486,36,'a)	1 in 2',NULL),(487,36,'b)	1 in 6',1),(488,36,'c)	1 in 3',NULL),(489,36,'d)	1 in 4',NULL),(490,37,'Black/African Americans',1),(491,37,'Seniors',NULL),(492,37,'Hispanics',NULL),(493,37,'Native Americans',NULL),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(514,41,'Are entitled to know their child\'s HIV test results without their child\'s consent.',NULL),(515,41,'May not be informed directly or indirectly of their child\'s HIV test results without the child\'s consent.',1),(516,41,'May be informed indirectly of their child\'s HIV test results when sent a bill for said testing.',NULL),(517,41,'Must give consent for their child to be tested for HIV.',NULL),(519,47,'Bona fide medical emergencies',NULL),(520,47,'Court order',NULL),(521,47,'All of the above',1),(522,48,'Sudden shift in mood or behavior',NULL),(523,48,'Skin rash',NULL),(524,48,'Muscle weakness',NULL),(525,48,'Confusion',NULL),(526,48,'a, c, and d ',1),(527,49,'Medical personnel involved with the diagnosis or treatment of the person tested; ',NULL),(528,49,'Licensed medical professionals who regularly participate as part of an interdisciplinary team ',NULL),(529,49,'Staff that handle body fluids ',NULL),(530,49,'Personnel involved in utilization review, risk management or peer review activities; ',NULL),(531,49,'Financial staff who compile or review medical records as part of routine billing activities',NULL),(532,49,'All of the above',1),(533,42,'Be tested for HIV at their initial prenatal visit and at 28-32 weeks.',1),(534,42,'Be tested for HCV at the first prenatal visit.',NULL),(535,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(536,42,'Request to be tested for HIV',NULL),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(566,74,'Gloves, gowns, respirators',NULL),(567,74,'Face masks, goggles, face shields',NULL),(568,74,'Shoes and socks',NULL),(569,74,'A and B',1),(570,74,'A and C',NULL),(571,75,'Wear protective gloves',NULL),(572,75,'Run away from spill in order to not get contaminated ',NULL),(573,75,'Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(574,75,'A and B',NULL),(575,75,'A and C',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(584,79,'Viruses',NULL),(585,79,'Parasites',NULL),(586,79,'Bacteria',NULL),(587,79,'Fungus',NULL),(588,79,'All of the above',1),(589,80,'Air',NULL),(590,80,'Water',NULL),(591,80,'Bodily fluids',NULL),(592,80,'A and B',1),(593,80,'A and C',NULL),(594,88,'Airborne',NULL),(595,88,'Droplet',NULL),(596,88,'Contact',1),(597,88,'A and B',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'Health Information Property Accountability Association',NULL),(693,116,'Human Insurance Process Accumulation Act',NULL),(694,116,'Health Insurance Portability and Accountability Act',1),(695,117,'Electronic Medical Record ',NULL),(696,117,'Security ',NULL),(697,117,'HITECH',1),(698,117,'HHS',NULL),(699,118,'Medical record number',NULL),(700,118,'Telephone number',NULL),(701,118,'Fax number',NULL),(702,118,'Social security number',NULL),(703,118,'All of the above',1),(704,118,'a, b, d',NULL),(705,119,'True',NULL),(706,119,'False',1),(707,120,'Disciplinary action',NULL),(708,120,'Loss of access privileges',NULL),(709,120,'Fines and penalties',NULL),(710,120,'Imprisonment',NULL),(711,120,'All of the above',1),(712,121,'Yes, if he is an employee and you know him.',NULL),(713,121,'Yes, if your manager says that it’s okay.',NULL),(714,121,'No, sharing log-in IDs and passwords is a security violation.',1),(715,121,'a and b',NULL),(716,122,'I am only expected to complete the minimum requirements of my job.',NULL),(717,122,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(718,122,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(719,122,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(720,122,'b and c',1),(725,124,'Yes',NULL),(726,124,'No',1),(734,126,'Yes for example I may need to  communicate client information to my boss for shift change.',NULL),(735,126,'No, because the intended users phone could be lost or stolen and exposed to a third party.',1),(744,125,'Yes.  They can be used interchangeably.',NULL),(745,125,'No. Consents are used to get the patient\'s permission to use or disclose health information for treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(746,127,'State and local governments',NULL),(747,127,'Private employers',NULL),(748,127,'Employment agencies',NULL),(749,127,'Labor organizations',NULL),(750,127,'All of the above',1),(751,128,'No means of transportation',NULL),(752,128,'A criminal history',NULL),(753,128,'A physical or mental impairment that substantially limits one or more life activities',1),(754,128,'None of the above',NULL),(755,128,'All of the above',NULL),(756,129,'Sexual preference',NULL),(757,129,'Kleptomania',NULL),(758,129,'Illegal Drug use',NULL),(759,129,'All of the above',1),(764,131,'Changing a training manual',NULL),(765,131,'Letting employee sleep during work hours',NULL),(766,131,'Providing an interpreter',NULL),(767,131,'A and C',1),(768,130,'True',1),(769,130,'False',NULL),(770,132,'True',1),(771,132,'False',NULL),(772,133,'True',NULL),(773,133,'False',1),(774,134,'True',1),(775,134,'False',NULL),(776,135,'True',NULL),(777,135,'False',1),(778,136,'Walking',NULL),(779,136,'Breathing',NULL),(780,136,'Eating',NULL),(781,136,'Major bodily functions',NULL),(782,136,'All of the above',1),(831,146,'A public health problem, impacting large numbers of the population',1),(832,146,'A family problem, best dealt with within the family ',NULL),(833,146,'A reportable crime in Florida regardless of whether or not a weapon was used in the abuse',NULL),(834,146,'All of the above',NULL),(847,150,'Verbal abuse',NULL),(848,150,'Physical acting out',NULL),(849,150,'Difficulty getting along with others',1),(850,150,'All of the above',NULL),(851,151,'Forcing sexual acts',NULL),(852,151,'Isolating the victim',NULL),(853,151,'The abuser threatening suicide',NULL),(854,151,'All of the above',1),(855,152,'Drug or alcohol abuse',NULL),(856,152,'Intense jealousy',NULL),(857,152,'Welcoming of others into relationship',1),(858,152,'Will not allow a break-up of the relationship',NULL),(859,153,'Emotional insecurity and depression',1),(860,153,'Belief in the bonds of marriage and monogamy',NULL),(861,153,'Maturity and self-reliance',NULL),(862,153,'Strong ego and many friends',NULL),(867,154,'Withhold money',NULL),(868,154,'Intimidate',NULL),(869,154,'Use children to deliver messages',NULL),(870,154,'All of the above',1),(871,155,'Signs of a victim',NULL),(872,155,'Parts of the cycle of violence',NULL),(873,155,'Signs of an abuser',1),(874,155,'Signs of marital conflict',NULL),(891,160,'Intervening directly with the abuser',NULL),(892,160,'Acknowledging client barriers for seeking help',1),(893,160,'Filing police reports on behalf of the victim',NULL),(894,160,'None of the above',NULL),(903,163,'Increasing safety at home',NULL),(904,163,'Planning for emotional support',NULL),(905,163,'Immediate and long term safety',NULL),(906,163,'All of the above',1),(907,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a gunshot wound, or life threatening injury indicating an act of violence.',1),(908,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a broken arm, leg etc.',NULL),(909,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a fall',NULL),(910,164,'None of the above',NULL),(919,149,'Low self-esteem, low income and drug and alcohol abuse',NULL),(920,149,'Individual, societal, relational and community',1),(921,149,'Anger, passivity, Anti-social personality traits and Borderline personality traits',NULL),(922,149,'All of the above',NULL),(927,158,'Emotional discomfort',NULL),(928,158,'Blaming the victim',1),(929,158,'Cultural barriers',NULL),(930,158,'Uncooperative behavior by the victim',NULL),(931,159,'Accurate documentation and safe guarding evidence',1),(932,159,'Staying disconnected',NULL),(933,159,'Demand the criminal justice system get involved',NULL),(934,159,'All of the above',NULL),(939,161,'Helping victim create a safety plan',NULL),(940,161,'Give advice whether to leave or stay in abusive relationship',1),(941,161,'Validate victims experience',NULL),(942,161,'Respect confidentiality of victim',NULL),(943,165,'That the assessment was conducted and no Domestic Violence signs were indicated',NULL),(944,165,'That the assessment was conducted and the worker did not get an answer about DV from the patient',NULL),(945,165,'That the assessment was conducted and that the patient did not disclose abuse',1),(946,165,'None of the above',NULL),(947,156,'911—If you are in immediate danger',NULL),(948,156,'The National Domestic Violence Hotline at 1-800-799-SAFE (7233)',NULL),(949,156,'The National Sexual Assault Hotline at 1-800-656-4673',NULL),(950,156,'All of the above',1),(955,162,'800-799-7233',NULL),(956,162,'800-500-1119',1),(957,162,'800-656-4673',NULL),(958,162,'800-656-6767',NULL),(959,147,'Stalking, psychological violence; neglect and physical violence',NULL),(960,147,'Physical violence, sexual violence; stalking; and emotional violence',NULL),(961,147,'Physical violence; sexual violence; threats of physical and sexual violence; emotional and psychological violence',1),(962,147,'None of the above',NULL),(963,148,'Witnessing or experiencing violence as a child',NULL),(964,148,'Economic security',1),(965,148,'Weak community sanctions against Domestic Violence such as police being unwilling to intervene',NULL),(966,148,'Dominance and control by one partner in the relationship',NULL),(967,157,'9.2% to 30.5%',1),(968,157,'15%',NULL),(969,157,'24.3%',NULL),(970,157,'14.8%',NULL),(971,166,'a. The presence of two or more disorders at the same time',1),(972,166,'b. The presence of at least 2 mental health disorders',NULL),(973,166,'c. The presence of at least 2 substance related disorders',NULL),(974,166,'d. None of the above',NULL),(979,168,'a. Alcohol and drugs can increase underlying risk for mental disorders.',NULL),(980,168,'b. Alcohol or drugs are often used to self-medicate symptoms of depression or anxiety.',NULL),(981,168,'c. Psychiatric problems do not get worse by using drugs or alcohol.',1),(982,168,'d. Alcohol and drug abuse can make symptoms of a mental health problem worse.',NULL),(983,167,'a. Schizophrenia and Depression ',NULL),(984,167,'b. Bipolar Disorder and Anxiety Disorder',1),(985,167,'c. Depression and Fibromyalgia',NULL),(986,167,'d. Bipolar Disorder and Chronic Fatigue',NULL),(987,169,'a. Lying about one’s addiction',NULL),(988,169,'b. Denial frequently occurs in mental disorders',NULL),(989,169,'c. If the problem is not acknowledged, it doesn\'t exist.',NULL),(990,169,'d. All of the above',1),(991,170,'a. Feeling restless or jumpy',NULL),(992,170,'b. Trouble concentrating',NULL),(993,170,'c. Decreased need for sleep',NULL),(994,170,'d. A and B',1),(995,171,'a. Sequential model of treatment',NULL),(996,171,'b. Parallel model of treatment',NULL),(997,171,'c. Integrated model of treatment',1),(998,171,'d. All of the above',NULL),(999,172,'a. Abusing alcohol and/or other drugs',NULL),(1000,172,'b. A complex interplay of genetics, the environment, and other outside factors. ',1),(1001,172,'c. The environment',NULL),(1002,172,'d. Genetics',NULL),(1011,175,'a. Depression?',NULL),(1012,175,'b. Bipolar Disorder?',NULL),(1013,175,'c. Obsessive Compulsive Disorder?',1),(1014,175,'d. Social Anxiety Disorder? ',NULL),(1015,176,'a. Obsessive Compulsive Disorder?',NULL),(1016,176,'b. Anxiety Disorder?',NULL),(1017,176,'c. Mania phase in Bipolar Disorder?',1),(1018,176,'d. Depression?',NULL),(1019,177,'True',1),(1020,177,'False',NULL),(1021,178,'True',1),(1022,178,'False',NULL),(1023,179,'True',1),(1024,179,'False',NULL),(1025,180,'True',1),(1026,180,'False',NULL),(1042,184,'a. A counselor\'s beliefs',NULL),(1043,184,'b. A counselor\'s moral compass',NULL),(1044,184,'c. A counselor\'s values',NULL),(1045,184,'d. A counselor\'s daily routine',1),(1071,189,'a. Are not worth understanding',NULL),(1072,189,'b. Mean that a counselor must be able to make ethical decisions on the fly.',1),(1073,189,'c. Are unavoidable but largely irrelevant.',NULL),(1074,189,'d. Don\'t exist - there are standard responses to every problem.',NULL),(1075,189,'e. All of the above',NULL),(1076,190,'a. Confidentiality',1),(1077,190,'b. Issuance of a Certificate of Financial Responsibility',NULL),(1078,190,'c. Oral records only',NULL),(1079,190,'d. Current clients only',NULL),(1080,190,'e. All of the above',NULL),(1083,192,'a. Should be encouraged',NULL),(1084,192,'b. Can increase the risk of exploitation or misinterpretation',1),(1085,192,'c. Is rarely a problem',NULL),(1086,192,'d. Can keep the client-counselor relationship more interesting',NULL),(1087,192,'e. All of the above',NULL),(1088,193,'a. Administered by the counselor with minimal client input.',NULL),(1089,193,'b. Not a part of professional ethics.',NULL),(1090,193,'c. Helpful in allowing the client to understand the direction of their treatment.',1),(1091,193,'d. Just about signing paperwork',NULL),(1092,193,'e. All of the above',NULL),(1133,173,'a. Behaviors to prevent weight gain such as self-induced vomiting',NULL),(1134,173,'b. Frequent episodes of consuming very large amounts of food ',1),(1135,173,'c. Intense fear of weight gain',NULL),(1136,173,'d. All of the above',NULL),(1137,174,'a. Restricting food intake',NULL),(1138,174,'b. Frequent episodes of consuming  large amount of food followed by self-induced vomiting',1),(1139,174,'c. Extreme loss of weight',NULL),(1140,174,'d. All of the above',NULL),(1141,201,'Self-Harm is most common in early adolescence',NULL),(1142,201,'Self-Harm is most common in college age students',1),(1143,201,'Self-Harm is most common at the age of 20',NULL),(1144,201,'Self-Harm is most common at the age of 40',NULL),(1145,201,'Self-Harm is most common in early twenties.',NULL),(1146,202,'True    ',1),(1147,202,'False',NULL),(1148,203,'Suicide is highest in college students',NULL),(1149,203,'Suicide is highest in white males over 85',NULL),(1150,203,'Suicide is highest for people aged 10-24',NULL),(1151,203,'Suicide is highest for people aged 25-34',NULL),(1152,203,'Suicide is highest for people aged 45-64',1),(1153,204,'Unrelenting low mood',NULL),(1154,204,'Anxiety, psychic pain, inner tension',NULL),(1155,204,'Sleep problems',NULL),(1156,204,'Threatening suicide or expressing strong wish to die',NULL),(1157,204,'All of the above',1),(1158,205,'Ask directly about suicide, be specific in your inquiry',NULL),(1159,205,'Determine level of suicide risk; low, moderate or high',NULL),(1160,205,'Medications, what they are currently taking, what they have taken in the past and what did or did not work',NULL),(1161,205,'Prior attempts increase possibility of successful suicide',NULL),(1162,205,'All of the above',1),(1163,206,'Yes',1),(1164,206,'No',NULL),(1165,207,'Substance Abuse and Mental Health Disorders',1),(1166,207,'Self-Harm and Substance Abuse',NULL),(1167,207,'Eating Disorder and Mental Health Disorder',NULL),(1168,208,'Victims of Domestic Violence are 5 times more likely to commit suicide.',NULL),(1169,208,'Victims of Domestic Violence are 12 times more likely to commit suicide.',1),(1170,208,'Victims of Domestic Violence are 21 times more likely to commit suicide.',NULL),(1171,209,'10 times',NULL),(1172,209,'17 times',NULL),(1173,209,'42 times',NULL),(1174,209,'23 times',1),(1175,210,'Can’t get out of the depression',NULL),(1176,210,'Can’t think clearly',NULL),(1177,210,'Can’t stop the pain',NULL),(1178,210,'Can’t see themselves as worthwhile',NULL),(1179,210,'All of the above',1),(1180,211,'True',1),(1181,211,'False',NULL),(1182,212,'Cultural Tolerance',NULL),(1183,212,'Cultural Acculturation',NULL),(1184,212,'Cultural Competence',NULL),(1185,212,'Cultural Assimilation',1),(1186,213,'African American',NULL),(1187,213,'American Indian',NULL),(1188,213,'Asian American',NULL),(1189,213,'Caucasian',1),(1190,213,'Hispanic',NULL),(1191,214,'True',NULL),(1192,214,'False',1),(1193,215,'True',1),(1194,215,'False',NULL),(1195,181,'a. Fines under federal law',NULL),(1196,181,'b. Losing your job',NULL),(1197,181,'c. Prison time',NULL),(1198,181,'d. Legal issues',NULL),(1199,181,'e. All of the above',1),(1200,182,'a. Is our moral but not legal obligation',NULL),(1201,182,'b. Is our legal and moral obligation',1),(1202,182,'c. Is neither our legal nor moral obligation',NULL),(1203,182,'d. Is our legal but not moral obligation',NULL),(1204,182,'e. All of the above',NULL),(1205,183,'a. Keep functions separate based on location',NULL),(1206,183,'b. Understand your role as a counselor',NULL),(1207,183,'c. By having an honest conversation with the client about your relationship',NULL),(1208,183,'d. Stay wary of possible confidentiality breaches',NULL),(1209,183,'e. All of the above',1),(1210,185,'a. Basic requiring no knowledge of law and precedent',NULL),(1211,185,'b. Generally easy and apply to every client',NULL),(1212,185,'c. Nuanced making them often very difficult',1),(1213,185,'d. Cut and dried when following the law',NULL),(1214,185,'e. All of the above',NULL),(1220,186,'a. The counselor cannot make up their mind',NULL),(1221,186,'b. Counselors have more than one client',NULL),(1222,186,'c. Counselors have more than one relationship with the client',1),(1223,186,'d. The counselor is empathetic towards a client',NULL),(1224,186,'e. All of the above',NULL),(1225,187,'a. Are set by the client',NULL),(1226,187,'b. Don’t generally apply to counselors',NULL),(1227,187,'c. Were more important in the past',NULL),(1228,187,'d. Are an important part of counseling',1),(1229,187,'e. All of the above',NULL),(1230,188,'a. May require a counselor to sign an agreement to uphold certain standards.',NULL),(1231,188,'b. Are important',NULL),(1232,188,'c. Require counselor training, in most states',NULL),(1233,188,'d. Are generally self-regulated by the industry',NULL),(1234,188,'e. All of the above',1),(1235,191,'True',NULL),(1236,191,'False',1),(1242,200,'a. Clinical, moral, legal',NULL),(1243,200,'b. Legal, moral, ethical',1),(1244,200,'c. Ethical, moral, clinical',NULL),(1245,200,'d. Ethical, legal, clinical',NULL),(1246,200,'e. None of the above',NULL),(1247,199,'a. Areas a professional counselor is interested in working in',NULL),(1248,199,'b. All areas of clinical practice',NULL),(1249,199,'c. Actions that a member of the profession is trained and authorized to perform',1),(1250,199,'d. Clinical practice in areas where the counselor can receive clinical supervision',NULL),(1251,199,'e. None of the above',NULL),(1252,198,'a. Counselor and hair stylist',NULL),(1253,198,'b. Counselor to your best friends brother',NULL),(1254,198,'c. Counselor and supervisor',NULL),(1255,198,'d. Counselor and 12-step sponsor',NULL),(1256,198,'e. All of the above',1),(1257,197,'a. May make clinical mistakes',NULL),(1258,197,'b. May begin to burn out',NULL),(1259,197,'c. May cross professional boundaries',NULL),(1260,197,'d. May exploit the client',NULL),(1261,197,'e. All of the above',1),(1262,196,'a. A counselor sharing their personal feelings with their client',NULL),(1263,196,'b. A counselor experiencing an emotional connection beyond what is acceptable in the client-counselor relationship.',1),(1264,196,'c. A client focusing on their feelings for the counselor',NULL),(1265,196,'d. A counselor having a dual relationship with their client',NULL),(1266,196,'e. A client placing feelings about others from their lies onto the counselor',NULL),(1267,195,'a. A client placing feelings about others from their lives onto the counselor',1),(1268,195,'b. A client focusing on their feelings for the counselor',NULL),(1269,195,'c. A client transferring their feelings with the feelings of the counselor',NULL),(1270,195,'d. A client falling in love with the counselor',NULL),(1271,195,'e. All of the above',NULL),(1272,194,'a. Should never be done',NULL),(1273,194,'b. Should be done with every client',NULL),(1274,194,'c. Should be done when counselor has strong belief client will benefit',1),(1275,194,'d. Should be done when the client asks a personal questions',NULL),(1276,194,'e. All of the above',NULL),(1789,1142,'Making derogatory or sexually explicit comments',NULL),(1790,1142,'Displaying sexually suggestive posters',NULL),(1791,1142,'Making unwanted physical contact',NULL),(1792,1142,'All of the above',1),(1869,1141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(1870,1141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(1871,1141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(1872,1141,'Unwelcome, physical in nature and occur in the workplace',NULL),(1873,1143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(1874,1143,'Behavior that makes the workplace uncomfortable ',NULL),(1875,1143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(1876,1143,'Sexually explicit offensive comments',NULL),(1877,1144,'Express yourself verbally',NULL),(1878,1144,'Tell the harasser the behavior is making you uncomfortable',NULL),(1879,1144,'Express yourself non verbally',NULL),(1880,1144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(1881,1144,'All of the above',1),(1882,1145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(1883,1145,'Files a discrimination charge',NULL),(1884,1145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(1885,1145,'All of the above',1),(1886,1146,'True',1),(1887,1146,'False',NULL),(1888,1147,'True',1),(1889,1147,'False',NULL),(1890,1148,'True',1),(1891,1148,'False',NULL),(1892,1149,'True',1),(1893,1149,'False',NULL),(1894,1150,'True',1),(1895,1150,'False',NULL),(1896,1151,'True',NULL),(1897,1151,'False',1),(1898,1152,'True',NULL),(1899,1152,'False',1),(1900,1154,'Yes',1),(1901,1154,'No',NULL),(1902,1155,'Yes',NULL),(1903,1155,'No',1),(1904,1156,'Yes',1),(1905,1156,'No',NULL),(11840,591,'FS 387.219 (1)',NULL),(11841,591,'FS 456.222 (4)',NULL),(11842,591,'FS 397.419 (2)',1),(11843,591,'FS 298.419 (1)',NULL),(11844,592,'Organizations',NULL),(11845,592,'Supervisors',NULL),(11846,592,'Risk Managers',NULL),(11847,592,'All Staff',1),(11848,593,'Verification of corrective action',NULL),(11849,593,'Results of Root Cause Analyses',NULL),(11850,593,'Provision for reporting to the Department',NULL),(11851,593,'a and b',NULL),(11852,593,'a and c',1),(11853,702,'As soon as possible and no later than 48 hours',NULL),(11854,702,'As soon as possible and no later than 72 hours',NULL),(11855,702,'As soon as possible and no later than 24 hours',1),(11856,702,'As soon as possible',NULL),(11857,703,'Collaborate for accuracy of events witnessed',NULL),(11858,703,'Both sign the Incident Report Form',NULL),(11859,703,'Each file a separate Incident Report Form',1),(11860,703,'Jointly prepare one Incident Report Form',NULL),(11861,704,'True',NULL),(11862,704,'False',1),(11863,705,'Complete one Incident Report listing all clients involved in the incident',NULL),(11864,705,'Complete a separate Incident Report for each client involved',1),(11865,705,'Have client’s Primary Therapist complete an incident report',NULL),(11866,705,'None of the above',NULL),(11867,706,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11868,706,'A copy of the IRF is always included in the client’s medical records on file. ',1),(11869,706,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11870,706,'Incident Report Forms are confidential reports ',NULL),(11871,707,'Enter concise subjective statements of fact',NULL),(11872,707,'Express their own opinion of the occurrence',NULL),(11873,707,'Enter concise objective statements of fact',1),(11874,707,'a and b',NULL),(11875,708,'Promptly report a critical incidence within 6 hours',NULL),(11876,708,'Promptly report a critical incident within 24 hours',NULL),(11877,708,'Promptly report a critical incident within one business day',1),(11878,708,'None of the above',NULL),(11879,709,'The Critical Incident Reporting System (CIRS)',NULL),(11880,709,'The Critical Incident Analyses System (CIAS)',NULL),(11881,709,'The Incident Analysis and Reporting System (IRAS)',NULL),(11882,709,'The Incident Reporting and Analysis System (IRAS)',1),(11883,710,'All Substance Abuse Providers licensed by the DCF',NULL),(11884,710,'Managing Entities',NULL),(11885,710,'State  mental health treatment facilities  ',NULL),(11886,710,'A and B',1),(11887,710,'A and C',NULL),(11888,711,'True',1),(11889,711,'False',NULL),(11890,712,'1994',NULL),(11891,712,'1998',NULL),(11892,712,'1996',1),(11893,712,'1997',NULL),(11894,713,'True',NULL),(11895,713,'False',1),(11896,137,'FS 387.219 (1)',NULL),(11897,137,'FS 456.222 (4)',NULL),(11898,137,'FS 397.419 (2)',1),(11899,137,'FS 298.419 (1)',NULL),(11900,138,'Organizations',NULL),(11901,138,'FS 456.222 (4)',NULL),(11902,138,'Supervisors',NULL),(11903,138,'Risk Managers',NULL),(11904,138,'All Staff',1),(11905,139,'Verification of corrective action',NULL),(11906,139,'Results of Root Cause Analyses',NULL),(11907,139,'Provision for reporting to the Department',NULL),(11908,139,'a and b',NULL),(11909,139,'a and c',1),(11910,140,'True',NULL),(11911,140,'False',1),(11916,141,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11917,141,'Incident Report Forms are always included in the client’s medical records on file. ',1),(11918,141,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11919,141,'Incident Report Forms are confidential reports ',NULL),(11920,142,'Promptly report a critical incidence within 6 hours',NULL),(11921,142,'Promptly report a critical incident within 24 hours',NULL),(11922,142,'Promptly report a critical incident within one business day',1),(11923,142,'None of the above',NULL),(11924,143,'The Critical Incident Reporting System (CIRS)',NULL),(11925,143,'The Critical Incident Analyses System (CIAS)',NULL),(11926,143,'The Incident Analysis and Reporting System (IRAS)',NULL),(11927,143,'The Incident Reporting and Analysis System (IRAS). ',1),(11928,144,'True',NULL),(11929,144,'False',1),(11930,145,'Promptly report a critical incidence within 6 hours',NULL),(11931,145,'Promptly report a critical incident within 24 hours',NULL),(11932,145,'Promptly report a critical incident within one business day',1),(11933,145,'None of the above',NULL),(11934,1131,'To report it to your supervisor',NULL),(11935,1131,'To report it only if you believe it is an emergency',NULL),(11936,1131,'To report it to the Florida Abuse Hotline of Children and Families',1),(11937,1131,'You are only required to report it to the person’s insurance company',NULL),(11938,1132,'Abandonment',NULL),(11939,1132,'Abuse',NULL),(11940,1132,'Exploitation',NULL),(11941,1132,'Neglect',1),(11942,1133,'Law enforcement officer',NULL),(11943,1133,'Nurse in an assisted living facility',NULL),(11944,1133,'School teacher',NULL),(11945,1133,'All of the above',1),(11946,1134,'They are ashamed ',NULL),(11947,1134,'They feel no one will believe them',NULL),(11948,1134,'They are afraid someone may retaliate if they report them',NULL),(11949,1134,'All of the above',1),(11950,1135,'True',1),(11951,1135,'False',NULL),(11952,1136,'True',NULL),(11953,1136,'False',1),(11954,1137,'Unauthorized taking of personal assets',NULL),(11955,1137,'Sale of the vulnerable adults home without their authorization',NULL),(11956,1137,'Caregiver failing to provide appropriate food to vulnerable adult',NULL),(11957,1137,'A and B',1),(11958,1137,'B and C',NULL),(11959,1138,'Exploitation',NULL),(11960,1138,'Abuse',1),(11961,1138,'Neglect',NULL),(11962,1138,'All of the above',NULL),(11963,1139,'Section 415.1034',NULL),(11964,1139,'Chapter 40, F.S.',NULL),(11965,1139,'Chapter 39, F.S.',1),(11966,1139,'Section 48 F.S.',NULL),(11967,1140,'800-222-2873',NULL),(11968,1140,'800-962-2873',1),(11969,1140,'800-914-0004',NULL),(11970,1140,'800-453-5145',NULL);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1157 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (6,'According to CDC estimates, what proportion of people in the United States who are infected with HIV are unaware of their infection?',1,5,NULL),(7,'Americans have become complacent about HIV/AIDS because:',1,8,NULL),(8,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',1,12,NULL),(9,'The Florida population hardest hit by HIV/AIDS is:',1,18,NULL),(10,'Which risk groups account for 75 percent of new HIV/AIDS infections?',1,22,NULL),(11,'Higher than average rates of AIDS and other STDs among correctional populations could be reduced by following the World Health Organization recommendation to:',1,24,NULL),(12,'Florida state law requires HIV testing of inmates:',1,28,NULL),(13,'Health professionals may fail to recognize the signs of HIV/AIDS infection in seniors because:',1,32,NULL),(14,'Which body fluids have been proven to transmit HIV infection?',1,36,NULL),(15,'Which of the following would most likely transmit an HIV infection?',1,40,NULL),(16,'Coinfection with STDs such as syphilis, gonorrhea, and genital warts:',1,44,NULL),(17,'The most common and most deadly coinfection for HIV-positive individuals is:',1,48,NULL),(18,'Treatment of HIV/TB coinfected patients is:',1,52,NULL),(19,'Respiratory protection equipment for healthcare workers is:',1,56,NULL),(20,'One of the leading causes of death among HIV-infected people is:',1,60,NULL),(26,'More than 1 million people in the U.S. are living with HIV. ',3,463,NULL),(27,'AIDS and HIV are the same',3,465,NULL),(28,'You can’t always tell by appearance if someone has HIV. ',3,467,NULL),(29,'Medications can cure HIV/AIDS.',3,469,NULL),(30,'All 50 states have people living with AIDS.',3,471,NULL),(31,'HIV is transmitted through casual contact such as sharing utensils. ',3,474,NULL),(32,'Abstinence is the only 100% effective method of not acquiring HIV/AIDS               ',3,475,NULL),(33,'Health care workers should assume that the blood and other body fluids               from all patients are potentially infectious.    \r\n               ',3,477,NULL),(34,'The results of HIV antibody tests are confidential and may not be publicly disclosed except with the resident’s written permission or as otherwise provided in Chapter 384, Florida Statues.\r\n',3,479,NULL),(35,'Way to protect yourself from HIV/AIDS include: \r\n',3,485,NULL),(36,'According to CDC estimates, what proportions of people in the United States who are infected with HIV are unaware of their infection?\r\n',3,487,NULL),(37,'The Florida population hardest hit by HIV/AIDS is:',3,490,NULL),(38,'Which risk groups account for 75 percent of new HIV/AIDS infections?',3,500,NULL),(39,'Which body fluids have been proven to transmit HIV infection?',3,508,NULL),(40,'Which of the following would most likely transmit an HIV infection?',3,511,NULL),(41,'Under Florida law, parents of a child under 18:',3,515,NULL),(42,'Florida law mandates that all pregnant women:',3,533,NULL),(47,'A provider may test without consent in which of the following:',3,521,NULL),(48,'Symptoms of AIDS Dementia Complex (ADC) include:',3,526,NULL),(49,'Need to know is outlined in section 64D-.003 F.A.C. and includes but is not limited to:',3,532,NULL),(53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL),(57,'To paraphrase means?',4,452,NULL),(58,'Active listening involves:',4,414,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL),(67,'The transmission of infectious agents requires?',5,540,NULL),(68,'What is true about infection prevention and control?',5,544,NULL),(69,'Which statement is NOT true about Droplet transmission?',5,546,NULL),(70,'Which of the following is NOT an example of a Bloodborne Pathogen?',5,551,NULL),(71,'When does Vector-borne transmission occur?',5,553,NULL),(72,'To protect yourself from airborne diseases, you should?',5,557,NULL),(73,' Bloodborne pathogens can be spread through',5,565,NULL),(74,'What is considered Personal Protective Equipment?',5,569,NULL),(75,'When cleaning a spill:',5,575,NULL),(78,'How long should you wash your hands for with soap and water?',5,582,NULL),(79,'Infectious diseases are caused by',5,588,NULL),(80,'Infectious diseases are transmitted most quickly through:',5,592,NULL),(81,'What is the body fluid NOT considered infectious?',5,576,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL),(85,'Verbal de-escalation is the communication skills we use during a potentially dangerous, or threatening, situation in an attempt to prevent a person from causing harm to us, themselves or others. ',4,459,NULL),(88,'The most frequent mode of infection transmission in the healthcare setting is',5,596,NULL),(89,'Precautions recommended by CDC for the care of all patients is known as:',5,600,NULL),(90,'A counselor and client can enter into a personal relationship after five years has elapsed.',6,603,NULL),(91,'What is a “Dual Relationship”?',6,604,NULL),(92,'Explain the purpose of HIPAA guidelines.',6,610,NULL),(93,'What does the acronym HIPAA stand for?',6,613,NULL),(94,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',6,617,NULL),(95,'What is the Right of Habeas Corpus?',6,619,NULL),(96,'Give two reason why maintaining proper boundaries is the responsibility of the staff.',6,626,NULL),(97,'Anger is a choice in a range of available behaviors',6,628,NULL),(98,'Your client owns a mechanic shop and offers to repair your car for free out of appreciation for your help.  This is an example of what type of relationship?',6,632,NULL),(99,'Give two instances when client confidential information can be disclosed without their consent.',6,639,NULL),(100,'Name 2 signs of Aggression',6,644,NULL),(101,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',6,647,NULL),(102,'Name 2 Risk Factors to Aggression',6,648,NULL),(103,'Which of the following can inhibit communication?',6,655,NULL),(104,'How does DSMIV-TR characterize bipolar disorder?',6,659,NULL),(105,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',6,661,NULL),(106,'Stage 3 of susbtance dependence is',6,663,NULL),(107,'Copying confidential information is:',6,668,NULL),(108,'Behavioral Healthcare facilities are able, by law to bill insurance companies without actual written consent from client',6,671,NULL),(109,'With written permission behavioral healthcare facilities can share information with parents and spouses',6,682,NULL),(110,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',6,675,NULL),(111,'Oral information is not protected by HIPAA guidelines',6,677,NULL),(112,'There is a fine for healthcare facilities that violate HIPAA guidelines',6,678,NULL),(113,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',6,681,NULL),(114,'Why is infection control important?',6,685,NULL),(115,'What illnesses are spread through contact? ',6,688,NULL),(116,'What does HIPAA stand for?',7,694,NULL),(117,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',7,697,NULL),(118,'What is an example/examples of PHI (Protected Health Information?',7,703,NULL),(119,'It is ok to discuss a patient with my spouse of he/she won’t tell anyone.',7,706,NULL),(120,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',7,711,NULL),(121,'If someone forgets his log-in ID, can I let him use mine?',7,714,NULL),(122,'What does \"minimum necessary\" mean?',7,720,NULL),(124,'Are members of your organization who are not involved in a patient\'s care allowed to review the patient\'s chart out of curiosity?',7,726,NULL),(125,'Are Consents and Authorizations the same?',7,745,NULL),(126,'Is text messaging is a secure way to transmit patient information within your facility.',7,735,NULL),(127,'Who must comply with the ADA?',8,750,NULL),(128,'According to the ADA, a person with a disability has:',8,753,NULL),(129,'What is a condition not covered by the ADA?',8,759,NULL),(130,'Under the ADA, an employer is required to make a reasonable accommodation to the known disability of a qualified applicant or employee if it does not impose “undue hardship”?',8,768,NULL),(131,'What is an example of a “reasonable accommodation”?',8,767,NULL),(132,'Under Title V, ADA prohibits coercion and retaliation to anyone who has assisted, encouraged or made a charge under the Act.',8,770,NULL),(133,'The ADA requires that organizations hire the disabled.',8,773,NULL),(134,'If an employer believes that a medical condition is causing a performance or conduct problem, it may ask the employee how to solve the problem.',8,774,NULL),(135,'According to the ADA, all people with disabilities (or even all people with the same disability) will require the same accommodation.',8,777,NULL),(136,'According to the ADA, “major life activities” include',8,782,NULL),(137,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:',9,11898,NULL),(138,'Incident Reporting is the affirmative duty of',9,11904,NULL),(139,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',9,11909,NULL),(140,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',9,11911,NULL),(141,'Which of the following statements is NOT true of Incident Reporting ',9,11917,NULL),(142,'When entering narrative documentation on an Incident Report Form staff MUST ',9,11922,NULL),(143,'DCF has created an online reporting system called:',9,11927,NULL),(144,'The DCF incident reporting procedures replace exploitation reporting protocols, as required by law. ',9,11929,NULL),(145,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',9,11932,NULL),(146,'Domestic Violence is best conceptualized as:',11,831,NULL),(147,'The four main types of Domestic Violence are:',11,961,NULL),(148,'Risk factors for Domestic Violence victimization include all the following EXCEPT:',11,964,NULL),(149,'What combination contributes to the risk of becoming a victim or a perpetrator of Domestic Violence?',11,920,NULL),(150,'Children from violent homes may demonstrate:',11,849,NULL),(151,'Patterns of controlling behavior can include:',11,854,NULL),(152,'Signs of a potential abuser in a dating relationship include all of the following EXCEPT',11,857,NULL),(153,'Which of the following are characteristics of a potential abuser:',11,859,NULL),(154,'To gain power and control an abuser may:',11,870,NULL),(155,'Tension building and making up are:',11,873,NULL),(156,'In dealing with Domestic Violence the most important phone numbers are:',11,950,NULL),(157,'The rate of Domestic Violence detection among behavioral health practitioners and healthcare workers is:',11,967,NULL),(158,'Missed cases of Domestic Violence may be due to all of the following EXCEPT:',11,928,NULL),(159,'Healthcare workers can help in detecting Domestic Violence by:',11,931,NULL),(160,'Mental health staff can become effective advocates by:',11,892,NULL),(161,'Advocating for Domestic Violence victims includes all of the following EXCEPT:',11,940,NULL),(162,'In Florida, the Domestic Violence Hotline Number is:',11,956,NULL),(163,'Safety plans cover: ',11,906,NULL),(164,'Florida state reporting laws require:',11,907,NULL),(165,'If a patient does not disclose Domestic Violence to a behavioral healthcare worker, the worker should document:',11,945,NULL),(166,'What does co-occurring disorder mean?',12,971,NULL),(167,'What mental conditions are more likely to abuse substances?',12,984,NULL),(168,'Which of the following statements are False?',12,981,NULL),(169,'What describes the term Denial?',12,990,NULL),(170,'What are signs and symptoms of anxiety disorders?',12,994,NULL),(171,'SAMSHA recommends the following treatment model for co-occurring disorders:',12,997,NULL),(172,'Mental disorders are caused by:',12,1000,NULL),(173,'A common sign of binge eating disorder is:',12,1134,NULL),(174,'A common sign of bulimia nervosa is',12,1138,NULL),(175,'Hand-washing until your skin becomes raw is a sign of which of the following disorders:',12,1013,NULL),(176,'Hyperactivity is a symptom of which of the following disorders:',12,1017,NULL),(177,'Some people develop mental health issues after excessive drinking or drug use.',12,1019,NULL),(178,'A mental disorder can complicate the challenge in overcoming an addiction to drugs or alcohol.',12,1021,NULL),(179,'About 50% of people with severe mental disorders are affected by substance abuse.',12,1023,NULL),(180,'People with a mental health illness are more likely to experience an alcohol or substance use disorder than those not affected by a mental illness.',12,1025,NULL),(181,'The ramifications of allowing/causing a breach in confidentiality can include:',13,1199,NULL),(182,'Adhering to confidentiality',13,1201,NULL),(183,'Some dual roles are unavoidable. How do you deal with them?',13,1209,NULL),(184,'Which of the following is not generally a basis of decision making?',13,1045,NULL),(185,'Ethical decisions in treatment are:',13,1212,NULL),(186,'Dual relationships occur when',13,1222,NULL),(187,'Boundaries',13,1228,NULL),(188,'Professional Ethics:',13,1234,NULL),(189,'Ethical Nuances',13,1072,NULL),(190,'42 CFR applies to:',13,1076,NULL),(191,'Both HIPAA and 42 CFR are concerned with client confidentiality as it relates to substance use disorder. ',13,1236,NULL),(192,'Blurring boundaries',13,1084,NULL),(193,'Informed consent is:',13,1090,NULL),(194,'Counselor self-disclosure:',13,1274,NULL),(195,'Transference is:',13,1267,NULL),(196,'Counter-transference is:',13,1263,NULL),(197,'When a counselor is not aware of transference & counter-transference issues, the counselor:',13,1261,NULL),(198,'Which of the following are examples of dual relationships?',13,1256,NULL),(199,'Scope of Practice is defined as:',13,1249,NULL),(200,'Ethical considerations can typically be viewed from which of the following three different perspectives?',13,1243,NULL),(201,'What are the usual Demographics of Self-Harm?',14,1142,NULL),(202,'The suicide rate is higher than the rate of homicide',14,1146,NULL),(203,'What is the age group with highest suicide risk?',14,1152,NULL),(204,'What are observable signs of serious depression that are correlated to Suicidality? ',14,1157,NULL),(205,'What are the components of a good Suicide Assessment?',14,1162,NULL),(206,'Do behavioral addictions increase a person’s risk of suicide?',14,1163,NULL),(207,'What are the two most prevalent risk factors associated with suicide?',14,1165,NULL),(208,'How much more likely to commit suicide are victims of domestic abuse?',14,1169,NULL),(209,'How much higher is the rate of Suicide with Eating Disorder clients’?',14,1174,NULL),(210,'What are some crisis elements that increase suicidality?',14,1179,NULL),(211,'Both race and ethnicity represent cultures',15,1180,NULL),(212,'The process that represents the absorption of many different cultures into a given area',15,1185,NULL),(213,'Which of the following is not a racial and ethnic minority group',15,1189,NULL),(214,'Eye contact has a similar meaning among most cultures',15,1192,NULL),(215,'Spirituality is part of every ethnic group',15,1193,NULL),(591,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:	',25,11842,NULL),(592,'Incident Reporting is the affirmative duty of',25,11847,NULL),(593,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',25,11852,NULL),(702,'The staff member most immediately involved in and/or observing an unusual incident is required to complete an Incident Report Form.  ',25,11855,NULL),(703,'If two staff members are involved in or witness an unusual event the staff members are required to',25,11859,NULL),(704,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',25,11862,NULL),(705,'If more than one client is involved in an unusual event staff must ',25,11864,NULL),(706,'Which of the following statements is NOT true of Incident Reporting ',25,11868,NULL),(707,'When entering narrative documentation on an Incident Report Form staff MUST ',25,11873,NULL),(708,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',25,11877,NULL),(709,'DCF has created an online reporting system called:',25,11882,NULL),(710,'Providers who must report critical incidents through IRAS include:',25,11886,NULL),(711,'The entry of the critical incident into IRAS DOES NOT substitute for a direct phone call to the Department’s leadership staff when the incident type or severity of the incident warrants such contact.',25,11888,NULL),(712,'The Joint Commission adopted a formal Sentinel Event Policy to assist healthcare providers ',25,11892,NULL),(713,'It is mandatory for all substance abuse providers  have to report sentinel events to The Joint Commission',25,11895,NULL),(1131,'If you reasonably suspect child abuse you are required:',9,11936,NULL),(1132,'If a child is deprived of clothing, shelter, or medical services it is called:',9,11941,NULL),(1133,'Who is considered a professional mandatory reporter?',9,11945,NULL),(1134,'What is the reason that victims may not report their abusers?',9,11949,NULL),(1135,'A False Report is a report of abuse, neglect, or abandonment of a child to the central abuse hotline, in which the report is made maliciously.',9,11950,NULL),(1136,'A person who is required to report, and who knowingly and willfully fails to do so, or who knowingly and willfully prevents another person from doing so, is guilty of a misdemeanor of the first degree.',9,11953,NULL),(1137,'What is consider exploitation of a vulnerable adult?',9,11957,NULL),(1138,'Any willful act or threatened act by a relative, caregiver, or household member which causes or is likely to cause significant impairment to a vulnerable adult’s physical, mental, or emotional health is called',9,11960,NULL),(1139,'Providers shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under:',9,11965,NULL),(1140,'The Abuse Hotline Phone Number is:',9,11968,NULL),(1141,'According to EEOC in order for behavior to be considered sexual harassment it must be ',10,1870,NULL),(1142,'A co-worker or supervisor can create a hostile work environment when they engage in one or more of the following behaviors:',10,792,NULL),(1143,'The Quid Pro Quo theory of sexual harassment involves:',10,1873,NULL),(1144,'IF you feel you are the victim of unwelcome sexual behavior you are encouraged to:',10,1881,NULL),(1145,'It is illegal for an employer or other employees to retaliate against any individual who:',10,1885,NULL),(1146,'Sexual Harassment in employment is legally recognized as a form of sex discrimination and is illegal.',10,1886,NULL),(1147,'Sexual harassment can occur outside the work site and still be considered work related.',10,1888,NULL),(1148,'Quid Pro Quo harassment is a form of sexual harassment when there is a request or demand of sexual favors in exchange for employment benefits or threatening reprisals if the favors are not given.',10,1890,NULL),(1149,'Friendly flirting is not sexual harassment when flirting is practiced between mutually consenting individuals who are equal in power or authority.',10,1892,NULL),(1150,'An employee witnesses another employee being harassed. Even though this involved a co-worker, the witness can be considered a victim in this case.',10,1894,NULL),(1151,'In order for it to be determined sexual harassment, the victim has to be of the opposite sex of the harasser.',10,1897,NULL),(1152,'It is solely the company’s responsibility to prevent sexual harassment',10,1899,NULL),(1154,'Adella wants Antonio to feel part of the team and tries to encourage his participation. She approaches him more frequently than the other workers and she is constantly touching his shoulder and arm. Antonio feels uncomfortable with Adella invading his personal space and grimaces as she touches his shoulders. His facial and body expressions clearly indicate his annoyance. Could this be considered sexual harassment?”',10,1900,NULL),(1155,'Karen Linda and Elis have become good friends and sit together at lunch. They decided to have some fun by rating the men in the lunchroom. Joking, they rate the men who walk into the lunchroom and discuss the ratings with each other. Ted, a male therapist, who is sitting at a nearby table overhears their remarks. He finds the behavior offensive and unprofessional. Ted reports the incident to HR when he returns from lunch. Was the women’s behavior sexual harassment?',10,1903,NULL),(1156,'Susan, the director of marketing, has several employees reporting to her. One of the employees, John, has been called into her office right before lunch. Susan requests that John have lunch with her to discuss one of the major accounts that he is trying to acquire. John agrees to the lunch and realizes that this is a good opportunity to explain some of the problems he has encountered. While John and Susan are out at lunch she puts her hand on his leg and says she wants him to do well in the company and would like him to come over to her place tonight. Is this considered sexual harassment?',10,1904,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--

INSERT INTO `response` VALUES (1,111,53,4,'296',1,1),(2,111,54,4,'449',1,1),(3,111,55,4,'300',1,1),(4,111,57,4,'452',1,1),(5,111,58,4,'414',1,1),(6,111,59,4,'419',1,1),(7,111,60,4,'325',1,1),(8,111,61,4,'425',1,1),(9,111,62,4,'327',1,1),(10,111,63,4,'332',1,NULL),(11,111,64,4,'333',1,1),(12,111,65,4,'458',1,1),(13,111,82,4,'343',1,1),(14,111,83,4,'347',1,1),(15,111,85,4,'459',1,1);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'mbhatc17',NULL,'6555 NW 9th Avenue, Suite 210<br>\nFt. Lauderdale, FL 33309<br>\nPhone: (877) 944-4235<br>\nFax: (954) 771-2098','',0);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,0,1,NULL),(110,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1982,'2015-02-18 19:54:58',30182285,1,5,1,NULL),(111,'dayle','selix','dselix@addictionacademy.com','123',1,7,1957,'2017-04-05 19:29:02',43452207,1,2,0,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--

INSERT INTO `user_course_access` VALUES (3,110,9,'In Progress',NULL,0),(4,111,4,'Completed',1491421418,0);

--
-- Current Database: `recoveryrestart_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `recoveryrestart_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `recoveryrestart_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (5,'Infection Control','Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p>\r\n<ul>\r\n<li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li>\r\n<li>Take action to prevention of the spread of disease in your workplace</li>\r\n</ul>\r\n\r\n\r\n\r\n',80,'0','Online Only',NULL,'AAP-Infection-Control.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,''),(8,'The American’s With Disability Act','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.',80,'','Online',NULL,NULL,NULL,NULL,NULL,NULL,'AAP-ADA.pdf',NULL,1,'');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Continuing Education'),(2,'Personal Development'),(3,'Communication'),(4,'Management & Leadership'),(5,'Marketing'),(6,'Organizational Efficiency'),(7,'Certified Behavioral Health Technician (CBHT)');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (13,5,1,1),(17,8,1,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (13,4,1424551831,'','','','','','',5),(14,5,1424821796,'Jason Starnes','','','','','',4),(15,3,1425659194,'lee Phillips','Review of material','all the statistics  Important but too much','','fair ','mental health issues ',3),(16,7,1426019470,'lee phillips','','','','','',3),(17,5,1445355697,'Kathy Reed','Multiple choice test','','nothing','yes','',4),(18,8,1445364656,'Denise Minshew','','','','','',4),(19,5,1446478785,'Chrystal Crawford','The entire course was very informative.','','','','',4);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=355 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (307,110,5,80),(308,110,8,80),(309,123,5,67),(310,123,5,100),(311,123,8,100),(312,124,5,67),(313,124,5,100),(314,124,8,100),(315,125,8,90),(316,126,8,90),(317,126,5,73),(318,126,5,87),(319,125,5,60),(320,125,5,93),(321,127,8,90),(322,127,5,100),(323,128,5,73),(324,128,5,73),(325,128,5,80),(326,128,8,100),(327,129,5,87),(328,130,5,73),(329,130,5,93),(330,130,8,80),(331,122,5,80),(332,122,8,80),(333,131,5,67),(334,131,5,73),(335,131,5,73),(336,131,5,80),(337,131,8,90),(338,132,5,60),(339,132,5,87),(340,133,5,60),(341,133,5,73),(342,133,5,53),(343,133,5,87),(344,133,8,70),(345,133,8,100),(346,134,5,80),(347,134,8,100),(348,135,5,73),(349,135,5,100),(350,135,8,70),(351,135,8,90),(352,132,8,60),(353,132,8,100),(354,129,8,100);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3),(1,4),(1,5);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Professional Development');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=829 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(461,87,'Correct Answer',1),(462,87,'Incorrect',NULL),(463,26,'True',1),(464,26,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(479,34,'True',1),(480,34,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(486,36,'a)	1 in 2',NULL),(487,36,'b)	1 in 6',1),(488,36,'c)	1 in 3',NULL),(489,36,'d)	1 in 4',NULL),(490,37,'Black/African Americans',1),(491,37,'Seniors',NULL),(492,37,'Hispanics',NULL),(493,37,'Native Americans',NULL),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(514,41,'Are entitled to know their child\'s HIV test results without their child\'s consent.',NULL),(515,41,'May not be informed directly or indirectly of their child\'s HIV test results without the child\'s consent.',1),(516,41,'May be informed indirectly of their child\'s HIV test results when sent a bill for said testing.',NULL),(517,41,'Must give consent for their child to be tested for HIV.',NULL),(519,47,'Bona fide medical emergencies',NULL),(520,47,'Court order',NULL),(521,47,'All of the above',1),(522,48,'Sudden shift in mood or behavior',NULL),(523,48,'Skin rash',NULL),(524,48,'Muscle weakness',NULL),(525,48,'Confusion',NULL),(526,48,'a, c, and d ',1),(527,49,'Medical personnel involved with the diagnosis or treatment of the person tested; ',NULL),(528,49,'Licensed medical professionals who regularly participate as part of an interdisciplinary team ',NULL),(529,49,'Staff that handle body fluids ',NULL),(530,49,'Personnel involved in utilization review, risk management or peer review activities; ',NULL),(531,49,'Financial staff who compile or review medical records as part of routine billing activities',NULL),(532,49,'All of the above',1),(533,42,'Be tested for HIV at their initial prenatal visit and at 28-32 weeks.',1),(534,42,'Be tested for HCV at the first prenatal visit.',NULL),(535,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(536,42,'Request to be tested for HIV',NULL),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(566,74,'Gloves, gowns, respirators',NULL),(567,74,'Face masks, goggles, face shields',NULL),(568,74,'Shoes and socks',NULL),(569,74,'A and B',1),(570,74,'A and C',NULL),(571,75,'Wear protective gloves',NULL),(572,75,'Run away from spill in order to not get contaminated ',NULL),(573,75,'Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(574,75,'A and B',NULL),(575,75,'A and C',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(584,79,'Viruses',NULL),(585,79,'Parasites',NULL),(586,79,'Bacteria',NULL),(587,79,'Fungus',NULL),(588,79,'All of the above',1),(589,80,'Air',NULL),(590,80,'Water',NULL),(591,80,'Bodily fluids',NULL),(592,80,'A and B',1),(593,80,'A and C',NULL),(594,88,'Airborne',NULL),(595,88,'Droplet',NULL),(596,88,'Contact',1),(597,88,'A and B',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'Health Information Property Accountability Association',NULL),(693,116,'Human Insurance Process Accumulation Act',NULL),(694,116,'Health Insurance Portability and Accountability Act',1),(695,117,'Electronic Medical Record ',NULL),(696,117,'Security ',NULL),(697,117,'HITECH',1),(698,117,'HHS',NULL),(699,118,'Medical record number',NULL),(700,118,'Telephone number',NULL),(701,118,'Fax number',NULL),(702,118,'Social security number',NULL),(703,118,'All of the above',1),(704,118,'a, b, d',NULL),(705,119,'True',NULL),(706,119,'False',1),(707,120,'Disciplinary action',NULL),(708,120,'Loss of access privileges',NULL),(709,120,'Fines and penalties',NULL),(710,120,'Imprisonment',NULL),(711,120,'All of the above',1),(712,121,'Yes, if he is an employee and you know him.',NULL),(713,121,'Yes, if your manager says that it’s okay.',NULL),(714,121,'No, sharing log-in IDs and passwords is a security violation.',1),(715,121,'a and b',NULL),(716,122,'I am only expected to complete the minimum requirements of my job.',NULL),(717,122,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(718,122,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(719,122,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(720,122,'b and c',1),(725,124,'Yes',NULL),(726,124,'No',1),(734,126,'Yes for example I may need to  communicate client information to my boss for shift change.',NULL),(735,126,'No, because the intended users phone could be lost or stolen and exposed to a third party.',1),(744,125,'Yes.  They can be used interchangeably.',NULL),(745,125,'No. Consents are used to get the patient\'s permission to use or disclose health information for treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(746,127,'State and local governments',NULL),(747,127,'Private employers',NULL),(748,127,'Employment agencies',NULL),(749,127,'Labor organizations',NULL),(750,127,'All of the above',1),(751,128,'No means of transportation',NULL),(752,128,'A criminal history',NULL),(753,128,'A physical or mental impairment that substantially limits one or more life activities',1),(754,128,'None of the above',NULL),(755,128,'All of the above',NULL),(756,129,'Sexual preference',NULL),(757,129,'Kleptomania',NULL),(758,129,'Illegal Drug use',NULL),(759,129,'All of the above',1),(764,131,'Changing a training manual',NULL),(765,131,'Letting employee sleep during work hours',NULL),(766,131,'Providing an interpreter',NULL),(767,131,'A and C',1),(768,130,'True',1),(769,130,'False',NULL),(770,132,'True',1),(771,132,'False',NULL),(772,133,'True',NULL),(773,133,'False',1),(774,134,'True',1),(775,134,'False',NULL),(776,135,'True',NULL),(777,135,'False',1),(778,136,'Walking',NULL),(779,136,'Breathing',NULL),(780,136,'Eating',NULL),(781,136,'Major bodily functions',NULL),(782,136,'All of the above',1),(783,137,'FS 387.219 (1)',NULL),(784,137,'FS 456.222 (4)',NULL),(785,137,'FS 397.419 (2)',1),(786,137,'FS 298.419 (1)',NULL),(787,138,'Organizations',NULL),(788,138,'FS 456.222 (4)',NULL),(789,138,'Supervisors',NULL),(790,138,'Risk Managers',NULL),(791,138,'All Staff',1),(792,139,'Verification of corrective action',NULL),(793,139,'Results of Root Cause Analyses',NULL),(794,139,'Provision for reporting to the Department',NULL),(795,139,'a and b',NULL),(796,139,'a and c',1),(797,140,'True',NULL),(798,140,'False',1),(799,141,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(800,141,'Incident Report Forms are always included in the client’s medical records on file. ',1),(801,141,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(802,141,'Incident Report Forms are confidential reports ',NULL),(803,142,'Promptly report a critical incidence within 6 hours',NULL),(804,142,'Promptly report a critical incident within 24 hours',NULL),(805,142,'Promptly report a critical incident within one business day',1),(806,142,'None of the above',NULL),(807,143,'The Critical Incident Reporting System (CIRS)',NULL),(808,143,'The Critical Incident Analyses System (CIAS)',NULL),(809,143,'The Incident Analysis and Reporting System (IRAS)',NULL),(810,143,'The Incident Reporting and Analysis System (IRAS). ',1),(818,144,'True',NULL),(819,144,'False',1),(825,145,'Promptly report a critical incidence within 6 hours',NULL),(826,145,'Promptly report a critical incident within 24 hours',NULL),(827,145,'Promptly report a critical incident within one business day',1),(828,145,'None of the above',NULL);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (6,'According to CDC estimates, what proportion of people in the United States who are infected with HIV are unaware of their infection?',1,5,NULL),(7,'Americans have become complacent about HIV/AIDS because:',1,8,NULL),(8,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',1,12,NULL),(9,'The Florida population hardest hit by HIV/AIDS is:',1,18,NULL),(10,'Which risk groups account for 75 percent of new HIV/AIDS infections?',1,22,NULL),(11,'Higher than average rates of AIDS and other STDs among correctional populations could be reduced by following the World Health Organization recommendation to:',1,24,NULL),(12,'Florida state law requires HIV testing of inmates:',1,28,NULL),(13,'Health professionals may fail to recognize the signs of HIV/AIDS infection in seniors because:',1,32,NULL),(14,'Which body fluids have been proven to transmit HIV infection?',1,36,NULL),(15,'Which of the following would most likely transmit an HIV infection?',1,40,NULL),(16,'Coinfection with STDs such as syphilis, gonorrhea, and genital warts:',1,44,NULL),(17,'The most common and most deadly coinfection for HIV-positive individuals is:',1,48,NULL),(18,'Treatment of HIV/TB coinfected patients is:',1,52,NULL),(19,'Respiratory protection equipment for healthcare workers is:',1,56,NULL),(20,'One of the leading causes of death among HIV-infected people is:',1,60,NULL),(26,'More than 1 million people in the U.S. are living with HIV. ',3,463,NULL),(27,'AIDS and HIV are the same',3,465,NULL),(28,'You can’t always tell by appearance if someone has HIV. ',3,467,NULL),(29,'Medications can cure HIV/AIDS.',3,469,NULL),(30,'All 50 states have people living with AIDS.',3,471,NULL),(31,'HIV is transmitted through casual contact such as sharing utensils. ',3,474,NULL),(32,'Abstinence is the only 100% effective method of not acquiring HIV/AIDS               ',3,475,NULL),(33,'Health care workers should assume that the blood and other body fluids               from all patients are potentially infectious.    \r\n               ',3,477,NULL),(34,'The results of HIV antibody tests are confidential and may not be publicly disclosed except with the resident’s written permission or as otherwise provided in Chapter 384, Florida Statues.\r\n',3,479,NULL),(35,'Way to protect yourself from HIV/AIDS include: \r\n',3,485,NULL),(36,'According to CDC estimates, what proportions of people in the United States who are infected with HIV are unaware of their infection?\r\n',3,487,NULL),(37,'The Florida population hardest hit by HIV/AIDS is:',3,490,NULL),(38,'Which risk groups account for 75 percent of new HIV/AIDS infections?',3,500,NULL),(39,'Which body fluids have been proven to transmit HIV infection?',3,508,NULL),(40,'Which of the following would most likely transmit an HIV infection?',3,511,NULL),(41,'Under Florida law, parents of a child under 18:',3,515,NULL),(42,'Florida law mandates that all pregnant women:',3,533,NULL),(47,'A provider may test without consent in which of the following:',3,521,NULL),(48,'Symptoms of AIDS Dementia Complex (ADC) include:',3,526,NULL),(49,'Need to know is outlined in section 64D-.003 F.A.C. and includes but is not limited to:',3,532,NULL),(53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL),(57,'To paraphrase means?',4,452,NULL),(58,'Active listening involves:',4,414,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL),(67,'The transmission of infectious agents requires?',5,540,NULL),(68,'What is true about infection prevention and control?',5,544,NULL),(69,'Which statement is NOT true about Droplet transmission?',5,546,NULL),(70,'Which of the following is NOT an example of a Bloodborne Pathogen?',5,551,NULL),(71,'When does Vector-borne transmission occur?',5,553,NULL),(72,'To protect yourself from airborne diseases, you should?',5,557,NULL),(73,' Bloodborne pathogens can be spread through',5,565,NULL),(74,'What is considered Personal Protective Equipment?',5,569,NULL),(75,'When cleaning a spill:',5,575,NULL),(78,'How long should you wash your hands for with soap and water?',5,582,NULL),(79,'Infectious diseases are caused by',5,588,NULL),(80,'Infectious diseases are transmitted most quickly through:',5,592,NULL),(81,'What is the body fluid NOT considered infectious?',5,576,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL),(85,'Verbal de-escalation is the communication skills we use during a potentially dangerous, or threatening, situation in an attempt to prevent a person from causing harm to us, themselves or others. ',4,459,NULL),(87,'Test',10,461,NULL),(88,'The most frequent mode of infection transmission in the healthcare setting is',5,596,NULL),(89,'Precautions recommended by CDC for the care of all patients is known as:',5,600,NULL),(90,'A counselor and client can enter into a personal relationship after five years has elapsed.',6,603,NULL),(91,'What is a “Dual Relationship”?',6,604,NULL),(92,'Explain the purpose of HIPAA guidelines.',6,610,NULL),(93,'What does the acronym HIPAA stand for?',6,613,NULL),(94,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',6,617,NULL),(95,'What is the Right of Habeas Corpus?',6,619,NULL),(96,'Give two reason why maintaining proper boundaries is the responsibility of the staff.',6,626,NULL),(97,'Anger is a choice in a range of available behaviors',6,628,NULL),(98,'Your client owns a mechanic shop and offers to repair your car for free out of appreciation for your help.  This is an example of what type of relationship?',6,632,NULL),(99,'Give two instances when client confidential information can be disclosed without their consent.',6,639,NULL),(100,'Name 2 signs of Aggression',6,644,NULL),(101,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',6,647,NULL),(102,'Name 2 Risk Factors to Aggression',6,648,NULL),(103,'Which of the following can inhibit communication?',6,655,NULL),(104,'How does DSMIV-TR characterize bipolar disorder?',6,659,NULL),(105,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',6,661,NULL),(106,'Stage 3 of susbtance dependence is',6,663,NULL),(107,'Copying confidential information is:',6,668,NULL),(108,'Behavioral Healthcare facilities are able, by law to bill insurance companies without actual written consent from client',6,671,NULL),(109,'With written permission behavioral healthcare facilities can share information with parents and spouses',6,682,NULL),(110,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',6,675,NULL),(111,'Oral information is not protected by HIPAA guidelines',6,677,NULL),(112,'There is a fine for healthcare facilities that violate HIPAA guidelines',6,678,NULL),(113,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',6,681,NULL),(114,'Why is infection control important?',6,685,NULL),(115,'What illnesses are spread through contact? ',6,688,NULL),(116,'What does HIPAA stand for?',7,694,NULL),(117,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',7,697,NULL),(118,'What is an example/examples of PHI (Protected Health Information?',7,703,NULL),(119,'It is ok to discuss a patient with my spouse of he/she won’t tell anyone.',7,706,NULL),(120,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',7,711,NULL),(121,'If someone forgets his log-in ID, can I let him use mine?',7,714,NULL),(122,'What does \"minimum necessary\" mean?',7,720,NULL),(124,'Are members of your organization who are not involved in a patient\'s care allowed to review the patient\'s chart out of curiosity?',7,726,NULL),(125,'Are Consents and Authorizations the same?',7,745,NULL),(126,'Is text messaging is a secure way to transmit patient information within your facility.',7,735,NULL),(127,'Who must comply with the ADA?',8,750,NULL),(128,'According to the ADA, a person with a disability has:',8,753,NULL),(129,'What is a condition not covered by the ADA?',8,759,NULL),(130,'Under the ADA, an employer is required to make a reasonable accommodation to the known disability of a qualified applicant or employee if it does not impose “undue hardship”?',8,768,NULL),(131,'What is an example of a “reasonable accommodation”?',8,767,NULL),(132,'Under Title V, ADA prohibits coercion and retaliation to anyone who has assisted, encouraged or made a charge under the Act.',8,770,NULL),(133,'The ADA requires that organizations hire the disabled.',8,773,NULL),(134,'If an employer believes that a medical condition is causing a performance or conduct problem, it may ask the employee how to solve the problem.',8,774,NULL),(135,'According to the ADA, all people with disabilities (or even all people with the same disability) will require the same accommodation.',8,777,NULL),(136,'According to the ADA, “major life activities” include',8,782,NULL),(137,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:',9,785,NULL),(138,'Incident Reporting is the affirmative duty of',9,791,NULL),(139,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',9,796,NULL),(140,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',9,798,NULL),(141,'Which of the following statements is NOT true of Incident Reporting ',9,800,NULL),(142,'When entering narrative documentation on an Incident Report Form staff MUST ',9,805,NULL),(143,'DCF has created an online reporting system called:',9,810,NULL),(144,'The DCF incident reporting procedures replace exploitation reporting protocols, as required by law. ',9,819,NULL),(145,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',9,827,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1403 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--

INSERT INTO `response` VALUES (776,110,67,5,'540',1,1),(777,110,68,5,'544',1,1),(778,110,69,5,'546',1,1),(779,110,70,5,'551',1,1),(780,110,71,5,'553',1,1),(781,110,72,5,'557',1,1),(782,110,73,5,'561',1,NULL),(783,110,74,5,'569',1,1),(784,110,75,5,'575',1,1),(785,110,78,5,'582',1,1),(786,110,79,5,'588',1,1),(787,110,80,5,'593',1,NULL),(788,110,81,5,'579',1,NULL),(789,110,88,5,'596',1,1),(790,110,89,5,'600',1,1),(791,110,127,8,'750',1,1),(792,110,128,8,'753',1,1),(793,110,129,8,'758',1,NULL),(794,110,130,8,'769',1,NULL),(795,110,131,8,'767',1,1),(796,110,132,8,'770',1,1),(797,110,133,8,'773',1,1),(798,110,134,8,'774',1,1),(799,110,135,8,'777',1,1),(800,110,136,8,'782',1,1),(801,123,67,5,'540',1,1),(802,123,68,5,'544',1,1),(803,123,69,5,'548',1,NULL),(804,123,70,5,'552',1,NULL),(805,123,71,5,'553',1,1),(806,123,72,5,'560',1,NULL),(807,123,73,5,'565',1,1),(808,123,74,5,'569',1,1),(809,123,75,5,'575',1,1),(810,123,78,5,'582',1,1),(811,123,79,5,'588',1,1),(812,123,80,5,'593',1,NULL),(813,123,81,5,'576',1,1),(814,123,88,5,'597',1,NULL),(815,123,89,5,'600',1,1),(816,123,67,5,'540',2,1),(817,123,68,5,'544',2,1),(818,123,69,5,'546',2,1),(819,123,70,5,'551',2,1),(820,123,71,5,'553',2,1),(821,123,72,5,'557',2,1),(822,123,73,5,'565',2,1),(823,123,74,5,'569',2,1),(824,123,75,5,'575',2,1),(825,123,78,5,'582',2,1),(826,123,79,5,'588',2,1),(827,123,80,5,'592',2,1),(828,123,81,5,'576',2,1),(829,123,88,5,'596',2,1),(830,123,89,5,'600',2,1),(831,123,127,8,'750',1,1),(832,123,128,8,'753',1,1),(833,123,129,8,'759',1,1),(834,123,130,8,'768',1,1),(835,123,131,8,'767',1,1),(836,123,132,8,'770',1,1),(837,123,133,8,'773',1,1),(838,123,134,8,'774',1,1),(839,123,135,8,'777',1,1),(840,123,136,8,'782',1,1),(841,124,67,5,'540',1,1),(842,124,68,5,'544',1,1),(843,124,69,5,'546',1,1),(844,124,70,5,'551',1,1),(845,124,71,5,'556',1,NULL),(846,124,72,5,'557',1,1),(847,124,73,5,'561',1,NULL),(848,124,74,5,'569',1,1),(849,124,75,5,'575',1,1),(850,124,78,5,'582',1,1),(851,124,80,5,'593',1,NULL),(852,124,81,5,'576',1,1),(853,124,88,5,'597',1,NULL),(854,124,89,5,'600',1,1),(855,124,67,5,'540',2,1),(856,124,68,5,'544',2,1),(857,124,69,5,'546',2,1),(858,124,70,5,'551',2,1),(859,124,71,5,'553',2,1),(860,124,72,5,'557',2,1),(861,124,73,5,'565',2,1),(862,124,74,5,'569',2,1),(863,124,75,5,'575',2,1),(864,124,78,5,'582',2,1),(865,124,79,5,'588',2,1),(866,124,80,5,'592',2,1),(867,124,81,5,'576',2,1),(868,124,88,5,'596',2,1),(869,124,89,5,'600',2,1),(870,124,127,8,'750',1,1),(871,124,128,8,'753',1,1),(872,124,129,8,'759',1,1),(873,124,130,8,'768',1,1),(874,124,131,8,'767',1,1),(875,124,132,8,'770',1,1),(876,124,133,8,'773',1,1),(877,124,134,8,'774',1,1),(878,124,135,8,'777',1,1),(879,124,136,8,'782',1,1),(880,125,127,8,'750',1,1),(881,125,128,8,'753',1,1),(882,125,129,8,'759',1,1),(883,125,130,8,'768',1,1),(884,125,131,8,'767',1,1),(885,125,132,8,'770',1,1),(886,125,133,8,'773',1,1),(887,125,134,8,'774',1,1),(888,125,135,8,'776',1,NULL),(889,125,136,8,'782',1,1),(890,126,127,8,'750',1,1),(891,126,128,8,'753',1,1),(892,126,129,8,'759',1,1),(893,126,130,8,'768',1,1),(894,126,131,8,'767',1,1),(895,126,132,8,'770',1,1),(896,126,133,8,'773',1,1),(897,126,134,8,'774',1,1),(898,126,135,8,'776',1,NULL),(899,126,136,8,'782',1,1),(900,126,67,5,'540',1,1),(901,126,68,5,'544',1,1),(902,126,69,5,'546',1,1),(903,126,70,5,'551',1,1),(904,126,71,5,'554',1,NULL),(905,126,72,5,'557',1,1),(906,126,73,5,'565',1,1),(907,126,74,5,'570',1,NULL),(908,126,75,5,'575',1,1),(909,126,78,5,'582',1,1),(910,126,79,5,'588',1,1),(911,126,80,5,'593',1,NULL),(912,126,81,5,'576',1,1),(913,126,88,5,'595',1,NULL),(914,126,89,5,'600',1,1),(915,126,67,5,'540',2,1),(916,126,68,5,'544',2,1),(917,126,69,5,'546',2,1),(918,126,70,5,'551',2,1),(919,126,71,5,'553',2,1),(920,126,72,5,'557',2,1),(921,126,73,5,'561',2,NULL),(922,126,74,5,'569',2,1),(923,126,75,5,'575',2,1),(924,126,78,5,'582',2,1),(925,126,79,5,'588',2,1),(926,126,80,5,'593',2,NULL),(927,126,81,5,'576',2,1),(928,126,88,5,'596',2,1),(929,126,89,5,'600',2,1),(930,125,67,5,'540',1,1),(931,125,68,5,'544',1,1),(932,125,69,5,'548',1,NULL),(933,125,70,5,'550',1,NULL),(934,125,71,5,'554',1,NULL),(935,125,72,5,'558',1,NULL),(936,125,73,5,'565',1,1),(937,125,74,5,'569',1,1),(938,125,75,5,'575',1,1),(939,125,78,5,'583',1,NULL),(940,125,79,5,'588',1,1),(941,125,80,5,'591',1,NULL),(942,125,81,5,'576',1,1),(943,125,88,5,'596',1,1),(944,125,89,5,'600',1,1),(945,125,67,5,'540',2,1),(946,125,68,5,'544',2,1),(947,125,69,5,'546',2,1),(948,125,70,5,'551',2,1),(949,125,71,5,'553',2,1),(950,125,72,5,'557',2,1),(951,125,73,5,'565',2,1),(952,125,74,5,'569',2,1),(953,125,75,5,'575',2,1),(954,125,78,5,'582',2,1),(955,125,79,5,'588',2,1),(956,125,80,5,'593',2,NULL),(957,125,81,5,'576',2,1),(958,125,88,5,'596',2,1),(959,125,89,5,'600',2,1),(960,127,127,8,'750',1,1),(961,127,128,8,'753',1,1),(962,127,129,8,'759',1,1),(963,127,130,8,'768',1,1),(964,127,132,8,'770',1,1),(965,127,133,8,'773',1,1),(966,127,134,8,'774',1,1),(967,127,135,8,'777',1,1),(968,127,136,8,'782',1,1),(969,127,67,5,'540',1,1),(970,127,68,5,'544',1,1),(971,127,69,5,'546',1,1),(972,127,70,5,'551',1,1),(973,127,71,5,'553',1,1),(974,127,72,5,'557',1,1),(975,127,73,5,'565',1,1),(976,127,74,5,'569',1,1),(977,127,75,5,'575',1,1),(978,127,78,5,'582',1,1),(979,127,79,5,'588',1,1),(980,127,80,5,'592',1,1),(981,127,81,5,'576',1,1),(982,127,88,5,'596',1,1),(983,127,89,5,'600',1,1),(984,128,67,5,'540',1,1),(985,128,68,5,'544',1,1),(986,128,69,5,'546',1,1),(987,128,70,5,'551',1,1),(988,128,71,5,'553',1,1),(989,128,72,5,'558',1,NULL),(990,128,73,5,'565',1,1),(991,128,74,5,'569',1,1),(992,128,75,5,'575',1,1),(993,128,78,5,'580',1,NULL),(994,128,79,5,'588',1,1),(995,128,80,5,'593',1,NULL),(996,128,81,5,'576',1,1),(997,128,88,5,'597',1,NULL),(998,128,89,5,'600',1,1),(999,128,67,5,'540',2,1),(1000,128,68,5,'544',2,1),(1001,128,69,5,'546',2,1),(1002,128,70,5,'552',2,NULL),(1003,128,71,5,'553',2,1),(1004,128,72,5,'558',2,NULL),(1005,128,73,5,'565',2,1),(1006,128,74,5,'569',2,1),(1007,128,75,5,'575',2,1),(1008,128,78,5,'580',2,NULL),(1009,128,79,5,'588',2,1),(1010,128,80,5,'593',2,NULL),(1011,128,81,5,'576',2,1),(1012,128,88,5,'596',2,1),(1013,128,89,5,'600',2,1),(1014,128,67,5,'540',3,1),(1015,128,68,5,'544',3,1),(1016,128,69,5,'546',3,1),(1017,128,70,5,'552',3,NULL),(1018,128,71,5,'553',3,1),(1019,128,72,5,'557',3,1),(1020,128,73,5,'565',3,1),(1021,128,74,5,'570',3,NULL),(1022,128,75,5,'575',3,1),(1023,128,78,5,'582',3,1),(1024,128,79,5,'588',3,1),(1025,128,80,5,'592',3,1),(1026,128,81,5,'576',3,1),(1027,128,89,5,'600',3,1),(1028,128,127,8,'750',1,1),(1029,128,128,8,'753',1,1),(1030,128,129,8,'759',1,1),(1031,128,130,8,'768',1,1),(1032,128,131,8,'767',1,1),(1033,128,132,8,'770',1,1),(1034,128,133,8,'773',1,1),(1035,128,134,8,'774',1,1),(1036,128,135,8,'777',1,1),(1037,128,136,8,'782',1,1),(1038,129,67,5,'540',1,1),(1039,129,68,5,'544',1,1),(1040,129,69,5,'546',1,1),(1041,129,70,5,'551',1,1),(1042,129,71,5,'553',1,1),(1043,129,72,5,'557',1,1),(1044,129,73,5,'565',1,1),(1045,129,74,5,'569',1,1),(1046,129,75,5,'575',1,1),(1047,129,78,5,'582',1,1),(1048,129,79,5,'588',1,1),(1049,129,80,5,'592',1,1),(1050,129,81,5,'579',1,NULL),(1051,129,88,5,'597',1,NULL),(1052,129,89,5,'600',1,1),(1053,130,67,5,'537',1,NULL),(1054,130,68,5,'544',1,1),(1055,130,69,5,'548',1,NULL),(1056,130,70,5,'551',1,1),(1057,130,71,5,'553',1,1),(1058,130,72,5,'557',1,1),(1059,130,73,5,'565',1,1),(1060,130,74,5,'569',1,1),(1061,130,75,5,'575',1,1),(1062,130,78,5,'582',1,1),(1063,130,79,5,'588',1,1),(1064,130,80,5,'591',1,NULL),(1065,130,81,5,'576',1,1),(1066,130,88,5,'597',1,NULL),(1067,130,89,5,'600',1,1),(1068,130,67,5,'540',2,1),(1069,130,68,5,'544',2,1),(1070,130,69,5,'546',2,1),(1071,130,70,5,'551',2,1),(1072,130,71,5,'553',2,1),(1073,130,72,5,'557',2,1),(1074,130,73,5,'565',2,1),(1075,130,74,5,'569',2,1),(1076,130,75,5,'575',2,1),(1077,130,78,5,'582',2,1),(1078,130,79,5,'588',2,1),(1079,130,80,5,'591',2,NULL),(1080,130,81,5,'576',2,1),(1081,130,88,5,'596',2,1),(1082,130,89,5,'600',2,1),(1083,130,127,8,'750',1,1),(1084,130,128,8,'753',1,1),(1085,130,129,8,'759',1,1),(1086,130,130,8,'768',1,1),(1087,130,131,8,'767',1,1),(1088,130,132,8,'771',1,NULL),(1089,130,133,8,'773',1,1),(1090,130,134,8,'774',1,1),(1091,130,135,8,'776',1,NULL),(1092,130,136,8,'782',1,1),(1093,122,67,5,'540',1,1),(1094,122,68,5,'544',1,1),(1095,122,69,5,'546',1,1),(1096,122,70,5,'551',1,1),(1097,122,71,5,'554',1,NULL),(1098,122,72,5,'557',1,1),(1099,122,73,5,'565',1,1),(1100,122,74,5,'569',1,1),(1101,122,75,5,'575',1,1),(1102,122,78,5,'582',1,1),(1103,122,79,5,'588',1,1),(1104,122,80,5,'593',1,NULL),(1105,122,81,5,'576',1,1),(1106,122,88,5,'594',1,NULL),(1107,122,89,5,'600',1,1),(1108,122,127,8,'750',1,1),(1109,122,128,8,'753',1,1),(1110,122,129,8,'759',1,1),(1111,122,130,8,'768',1,1),(1112,122,131,8,'766',1,NULL),(1113,122,132,8,'770',1,1),(1114,122,133,8,'773',1,1),(1115,122,134,8,'774',1,1),(1116,122,135,8,'777',1,1),(1117,122,136,8,'781',1,NULL),(1118,131,67,5,'540',1,1),(1119,131,68,5,'544',1,1),(1120,131,69,5,'548',1,NULL),(1121,131,70,5,'551',1,1),(1122,131,71,5,'555',1,NULL),(1123,131,72,5,'557',1,1),(1124,131,73,5,'565',1,1),(1125,131,74,5,'569',1,1),(1126,131,75,5,'575',1,1),(1127,131,78,5,'583',1,NULL),(1128,131,79,5,'588',1,1),(1129,131,80,5,'593',1,NULL),(1130,131,81,5,'576',1,1),(1131,131,88,5,'597',1,NULL),(1132,131,89,5,'600',1,1),(1133,131,67,5,'540',2,1),(1134,131,68,5,'544',2,1),(1135,131,69,5,'548',2,NULL),(1136,131,70,5,'551',2,1),(1137,131,71,5,'555',2,NULL),(1138,131,72,5,'557',2,1),(1139,131,73,5,'565',2,1),(1140,131,74,5,'569',2,1),(1141,131,75,5,'575',2,1),(1142,131,78,5,'582',2,1),(1143,131,79,5,'584',2,NULL),(1144,131,80,5,'591',2,NULL),(1145,131,81,5,'576',2,1),(1146,131,88,5,'596',2,1),(1147,131,89,5,'600',2,1),(1148,131,67,5,'540',3,1),(1149,131,68,5,'544',3,1),(1150,131,69,5,'548',3,NULL),(1151,131,70,5,'551',3,1),(1152,131,71,5,'553',3,1),(1153,131,72,5,'557',3,1),(1154,131,73,5,'565',3,1),(1155,131,74,5,'569',3,1),(1156,131,75,5,'575',3,1),(1157,131,78,5,'582',3,1),(1158,131,79,5,'584',3,NULL),(1159,131,80,5,'593',3,NULL),(1160,131,81,5,'576',3,1),(1161,131,88,5,'597',3,NULL),(1162,131,89,5,'600',3,1),(1163,131,67,5,'540',4,1),(1164,131,68,5,'544',4,1),(1165,131,69,5,'546',4,1),(1166,131,70,5,'551',4,1),(1167,131,71,5,'555',4,NULL),(1168,131,72,5,'557',4,1),(1169,131,73,5,'565',4,1),(1170,131,74,5,'569',4,1),(1171,131,75,5,'575',4,1),(1172,131,78,5,'583',4,NULL),(1173,131,79,5,'588',4,1),(1174,131,80,5,'593',4,NULL),(1175,131,81,5,'576',4,1),(1176,131,88,5,'596',4,1),(1177,131,89,5,'600',4,1),(1178,131,127,8,'750',1,1),(1179,131,128,8,'753',1,1),(1180,131,129,8,'756',1,NULL),(1181,131,130,8,'768',1,1),(1182,131,131,8,'767',1,1),(1183,131,132,8,'770',1,1),(1184,131,133,8,'773',1,1),(1185,131,134,8,'774',1,1),(1186,131,135,8,'777',1,1),(1187,131,136,8,'782',1,1),(1188,132,67,5,'540',1,1),(1189,132,68,5,'544',1,1),(1190,132,69,5,'547',1,NULL),(1191,132,70,5,'551',1,1),(1192,132,71,5,'553',1,1),(1193,132,72,5,'558',1,NULL),(1194,132,73,5,'565',1,1),(1195,132,74,5,'569',1,1),(1196,132,75,5,'575',1,1),(1197,132,78,5,'580',1,NULL),(1198,132,79,5,'588',1,1),(1199,132,80,5,'591',1,NULL),(1200,132,81,5,'579',1,NULL),(1201,132,88,5,'597',1,NULL),(1202,132,89,5,'600',1,1),(1203,132,67,5,'540',2,1),(1204,132,68,5,'544',2,1),(1205,132,69,5,'546',2,1),(1206,132,70,5,'551',2,1),(1207,132,71,5,'553',2,1),(1208,132,72,5,'557',2,1),(1209,132,73,5,'565',2,1),(1210,132,74,5,'569',2,1),(1211,132,75,5,'575',2,1),(1212,132,78,5,'580',2,NULL),(1213,132,79,5,'588',2,1),(1214,132,80,5,'592',2,1),(1215,132,81,5,'579',2,NULL),(1216,132,88,5,'596',2,1),(1217,132,89,5,'600',2,1),(1218,133,67,5,'540',1,1),(1219,133,68,5,'544',1,1),(1220,133,69,5,'545',1,NULL),(1221,133,70,5,'551',1,1),(1222,133,71,5,'556',1,NULL),(1223,133,72,5,'557',1,1),(1224,133,73,5,'561',1,NULL),(1225,133,74,5,'569',1,1),(1226,133,75,5,'575',1,1),(1227,133,78,5,'583',1,NULL),(1228,133,79,5,'588',1,1),(1229,133,80,5,'591',1,NULL),(1230,133,81,5,'576',1,1),(1231,133,88,5,'597',1,NULL),(1232,133,89,5,'600',1,1),(1233,133,67,5,'540',2,1),(1234,133,68,5,'544',2,1),(1235,133,69,5,'545',2,NULL),(1236,133,70,5,'551',2,1),(1237,133,71,5,'556',2,NULL),(1238,133,72,5,'557',2,1),(1239,133,73,5,'565',2,1),(1240,133,74,5,'569',2,1),(1241,133,75,5,'573',2,NULL),(1242,133,78,5,'582',2,1),(1243,133,79,5,'588',2,1),(1244,133,80,5,'591',2,NULL),(1245,133,81,5,'576',2,1),(1246,133,88,5,'596',2,1),(1247,133,89,5,'600',2,1),(1248,133,67,5,'540',3,1),(1249,133,68,5,'544',3,1),(1250,133,69,5,'545',3,NULL),(1251,133,70,5,'551',3,1),(1252,133,71,5,'556',3,NULL),(1253,133,72,5,'557',3,1),(1254,133,73,5,'561',3,NULL),(1255,133,74,5,'569',3,1),(1256,133,75,5,'573',3,NULL),(1257,133,78,5,'582',3,1),(1258,133,79,5,'588',3,1),(1259,133,80,5,'591',3,NULL),(1260,133,81,5,'579',3,NULL),(1261,133,88,5,'597',3,NULL),(1262,133,89,5,'600',3,1),(1263,133,67,5,'540',4,1),(1264,133,68,5,'544',4,1),(1265,133,69,5,'546',4,1),(1266,133,70,5,'551',4,1),(1267,133,71,5,'553',4,1),(1268,133,72,5,'557',4,1),(1269,133,73,5,'564',4,NULL),(1270,133,74,5,'569',4,1),(1271,133,75,5,'574',4,NULL),(1272,133,78,5,'582',4,1),(1273,133,79,5,'588',4,1),(1274,133,80,5,'592',4,1),(1275,133,81,5,'576',4,1),(1276,133,88,5,'596',4,1),(1277,133,89,5,'600',4,1),(1278,133,127,8,'750',1,1),(1279,133,128,8,'753',1,1),(1280,133,129,8,'759',1,1),(1281,133,130,8,'768',1,1),(1282,133,131,8,'767',1,1),(1283,133,132,8,'770',1,1),(1284,133,133,8,'772',1,NULL),(1285,133,134,8,'774',1,1),(1286,133,135,8,'776',1,NULL),(1287,133,136,8,'781',1,NULL),(1288,133,127,8,'750',2,1),(1289,133,128,8,'753',2,1),(1290,133,129,8,'759',2,1),(1291,133,130,8,'768',2,1),(1292,133,131,8,'767',2,1),(1293,133,132,8,'770',2,1),(1294,133,133,8,'773',2,1),(1295,133,134,8,'774',2,1),(1296,133,135,8,'777',2,1),(1297,133,136,8,'782',2,1),(1298,134,67,5,'540',1,1),(1299,134,68,5,'544',1,1),(1300,134,69,5,'546',1,1),(1301,134,70,5,'551',1,1),(1302,134,71,5,'553',1,1),(1303,134,72,5,'558',1,NULL),(1304,134,73,5,'565',1,1),(1305,134,74,5,'569',1,1),(1306,134,75,5,'575',1,1),(1307,134,78,5,'582',1,1),(1308,134,79,5,'588',1,1),(1309,134,80,5,'593',1,NULL),(1310,134,81,5,'576',1,1),(1311,134,88,5,'597',1,NULL),(1312,134,89,5,'600',1,1),(1313,134,127,8,'750',1,1),(1314,134,128,8,'753',1,1),(1315,134,129,8,'759',1,1),(1316,134,130,8,'768',1,1),(1317,134,131,8,'767',1,1),(1318,134,132,8,'770',1,1),(1319,134,133,8,'773',1,1),(1320,134,134,8,'774',1,1),(1321,134,135,8,'777',1,1),(1322,134,136,8,'782',1,1),(1323,135,67,5,'540',1,1),(1324,135,68,5,'544',1,1),(1325,135,69,5,'546',1,1),(1326,135,70,5,'551',1,1),(1327,135,71,5,'553',1,1),(1328,135,72,5,'558',1,NULL),(1329,135,73,5,'565',1,1),(1330,135,74,5,'569',1,1),(1331,135,75,5,'575',1,1),(1332,135,78,5,'582',1,1),(1333,135,79,5,'588',1,1),(1334,135,80,5,'593',1,NULL),(1335,135,81,5,'579',1,NULL),(1336,135,88,5,'597',1,NULL),(1337,135,89,5,'600',1,1),(1338,135,67,5,'540',2,1),(1339,135,68,5,'544',2,1),(1340,135,69,5,'546',2,1),(1341,135,70,5,'551',2,1),(1342,135,71,5,'553',2,1),(1343,135,72,5,'557',2,1),(1344,135,73,5,'565',2,1),(1345,135,74,5,'569',2,1),(1346,135,75,5,'575',2,1),(1347,135,78,5,'582',2,1),(1348,135,79,5,'588',2,1),(1349,135,80,5,'592',2,1),(1350,135,81,5,'576',2,1),(1351,135,88,5,'596',2,1),(1352,135,89,5,'600',2,1),(1353,135,127,8,'750',1,1),(1354,135,128,8,'753',1,1),(1355,135,129,8,'758',1,NULL),(1356,135,130,8,'768',1,1),(1357,135,131,8,'767',1,1),(1358,135,132,8,'770',1,1),(1359,135,133,8,'772',1,NULL),(1360,135,134,8,'774',1,1),(1361,135,135,8,'776',1,NULL),(1362,135,136,8,'782',1,1),(1363,135,127,8,'750',2,1),(1364,135,128,8,'754',2,NULL),(1365,135,129,8,'759',2,1),(1366,135,130,8,'768',2,1),(1367,135,131,8,'767',2,1),(1368,135,132,8,'770',2,1),(1369,135,133,8,'773',2,1),(1370,135,134,8,'774',2,1),(1371,135,135,8,'777',2,1),(1372,135,136,8,'782',2,1),(1373,132,127,8,'750',1,1),(1374,132,128,8,'753',1,1),(1375,132,129,8,'758',1,NULL),(1376,132,130,8,'768',1,1),(1377,132,131,8,'766',1,NULL),(1378,132,132,8,'770',1,1),(1379,132,133,8,'772',1,NULL),(1380,132,134,8,'774',1,1),(1381,132,135,8,'776',1,NULL),(1382,132,136,8,'782',1,1),(1383,132,127,8,'750',2,1),(1384,132,128,8,'753',2,1),(1385,132,129,8,'759',2,1),(1386,132,130,8,'768',2,1),(1387,132,131,8,'767',2,1),(1388,132,132,8,'770',2,1),(1389,132,133,8,'773',2,1),(1390,132,134,8,'774',2,1),(1391,132,135,8,'777',2,1),(1392,132,136,8,'782',2,1),(1393,129,127,8,'750',1,1),(1394,129,128,8,'753',1,1),(1395,129,129,8,'759',1,1),(1396,129,130,8,'768',1,1),(1397,129,131,8,'767',1,1),(1398,129,132,8,'770',1,1),(1399,129,133,8,'773',1,1),(1400,129,134,8,'774',1,1),(1401,129,135,8,'777',1,1),(1402,129,136,8,'782',1,1);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'recres01',NULL,'6555 NW 9th Avenue, Suite 210<br>\nFt. Lauderdale, FL 33309<br>\nPhone: (877) 944-4235<br>\nFax: (954) 771-2098','',0);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,0,1,NULL),(110,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1982,'2015-02-18 19:54:58',30182285,1,3,1,NULL),(121,'Shira','Ackerman','shira@addictionacademy.com','NULL',4,10,1970,'2015-10-20 13:09:23',46048958,1,0,0,NULL),(122,'Chrystal','Crawford','bookkeeping@recoveryrestart.com','9e4c7dc08e7ca80e29d06c716f15755e923671df0ecef5c95c4d7dea67a4c78e',11,1,1954,'2015-10-20 14:29:41',20116988,1,2,0,NULL),(123,'Jessica','Yates','jessica@recoveryrestart.com','c0dd533eb5ddb6109359e92ff9ec8ef36c10eec0b4d2b451270e8dfee8933d5e',7,7,1992,'2015-10-20 15:08:02',14106289,1,2,0,NULL),(124,'Kathy','Reed','kathy@recoveryrestart.com','0a6e0757632823536324e04e5107691e7d26358d2c047f108a3296bcc34c387a',13,5,1989,'2015-10-20 15:23:33',95970961,1,2,0,NULL),(125,'N.John','Lombardi','njohn711@gmail.com','87134aeb3b8cfbbedc288b807c1c83b4f0e0c225124abd3cec52cc0280a3a3fe',2,3,1960,'2015-10-20 16:08:00',60289024,1,2,0,NULL),(126,'Denise','Minshew','denise@recoveryrestart.com','923a44b2b01437419a5a30e232bf6ce3c1df74daaa4218df05d65c7b1e03b20d',17,2,1967,'2015-10-20 18:07:45',68718295,1,2,0,NULL),(127,'Gloria','Ahlman','gloria@recoveryrestart.com','a902b255a3d49c6a9d8c61c73ae4c5e1e172609aa0b0435d19470d32e0ea45b3',10,12,1952,'2015-10-20 19:42:49',11733909,1,2,0,NULL),(128,'Hillary','Gale','hillary@recoveryrestart.com','58906fc8e0a90e08296adec13c769cb314ade8cef3ab9bdb374772b9a941d25b',26,10,1991,'2015-10-23 14:22:37',93082086,1,2,0,NULL),(129,'Nick','Tucker','tuckern676@yahoo.com','4d22e090a424b809addbbe61534c75ebf0a735f8abccc41068eff8c9b7d6ac0a',15,7,1988,'2015-10-29 14:54:02',54275705,1,2,0,NULL),(130,'Dwayne','Green','dgreen689@att.net','5717fbec529e9803200be3486655153f0e0c528bcdb21717b78ade067f1f35bd',23,4,1984,'2015-11-01 20:45:25',70479200,1,2,0,NULL),(131,'Rovener','Daniel','rovener@recoveryrestart.com','bad51d37bd362eb20e266b6159f72d3ed920c42e0a19f1c7a54ce39d2e9a7020',5,11,1985,'2015-11-03 16:54:56',78094034,1,2,0,NULL),(132,'RICARDO ','QUITMAN','REQUITMAN@GMAIL.COM','5bcb5d3234fb20247b7f3e723e4862dc6cfad812b24b99a82a58e82c87dab8e3',15,8,1984,'2015-11-03 22:10:52',90079593,1,2,0,NULL),(133,'Charlie','Williams','charliewilliams970@gmail.com','05344ea7f7a1414a5c84a123c79bb17e0dd15a096efb023511827438cf83af8c',8,8,1990,'2015-11-04 15:38:33',66700977,1,2,0,NULL),(134,'Raheem','Byrd','raheembyrd@yahoo.com','70eba1c49141a5cb3cff7639285d035b54a9d880f32cd6646d0548bc9456896a',11,10,1979,'2015-11-04 15:56:54',86711352,1,2,0,NULL),(135,'Daniel','Crocitto','djc.3@live.com','2d25b99eea2d3c177fd3eb962ba70acd8ebbfaca3a8cace26621c4a83a316e8e',0,2,1963,'2015-11-05 15:36:46',12078801,1,2,0,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=267 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--

INSERT INTO `user_course_access` VALUES (235,110,5,'Completed',1444996612,0),(236,110,8,'Completed',1444996721,0),(237,123,5,'Completed',1445354290,0),(238,123,8,'Completed',1445354609,0),(239,124,5,'Completed',1445355587,1),(240,124,8,'Completed',1445355874,0),(241,125,8,'Completed',1445358465,0),(242,126,5,'Completed',1445364951,0),(243,126,8,'Completed',1445364607,1),(244,125,5,'Completed',1445367909,0),(245,127,8,'Completed',1445370342,0),(246,127,8,'In Progress',NULL,0),(247,127,8,'In Progress',NULL,0),(248,127,5,'Completed',1445370602,0),(249,128,5,'Completed',1445610792,0),(250,128,8,'Completed',1445613558,0),(251,129,5,'Completed',1446138781,0),(252,130,5,'Completed',1446412304,0),(253,130,8,'Completed',1446413185,0),(254,122,5,'Completed',1446478306,1),(255,122,8,'Completed',1446480278,0),(256,131,5,'Completed',1446570510,0),(257,131,8,'Completed',1446570656,0),(258,132,5,'Completed',1446589512,0),(259,133,5,'Completed',1446652363,0),(260,133,8,'Completed',1446652813,0),(261,134,5,'Completed',1446653019,0),(262,134,8,'Completed',1446653294,0),(263,129,8,'Completed',1447177644,0),(264,135,5,'Completed',1446754184,0),(265,135,8,'Completed',1446755331,0),(266,132,8,'Completed',1446837809,0);

--
-- Current Database: `rutn_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rutn_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `rutn_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` varchar(90) DEFAULT NULL,
  `staff_requirement` varchar(90) DEFAULT NULL,
  `required_within_time` varchar(90) DEFAULT NULL,
  `in_person` varchar(11) DEFAULT NULL,
  `essay_question` int(1) DEFAULT NULL,
  `essay_question_content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (3,'HIV / AIDS - 2 CEU','<p>HIV is an acronym for human immunodeficiency virus and it is the disease that often leads to AIDS. Continuing Education Course (2 CEUs)</p>','<p style=\"margin: 0px; padding: 0px; font-size: 12px; color: rgb(68, 68, 68); line-height: 18px; font-family: helvetica, arial, sans-serif;\">This class provides information on HIV and AIDS- related illnesses. Materials will be presented on the symptoms, causes, pathophysiology, diagnosis, transmission and prevention, treatment, epidemiology, prognosis, and history of HIV and AIDS.</p>',80,'0','Online Only',NULL,'Tennessee-HIV-AIDS.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'30','0',NULL,''),(4,'Aggression Management','<p>The effective handling of aggression is a demanding aspect of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions.</p>','<p><strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: </p><ol><li>Define “Aggression” and “Verbal De-escalation\" </li><li>Identify warning signs for aggressive behavior. </li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',80,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,'365',NULL,'180','0',NULL,NULL),(5,'Infection Control - 1 CEU','Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p>\r\n<ul>\r\n<li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li>\r\n<li>Take action to prevention of the spread of disease in your workplace</li>\r\n</ul>\r\n\r\n\r\n\r\n',80,'0','Online Only',NULL,'Online-InfectionControl-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,NULL,NULL,NULL),(7,'HIPAA - 2 CEU','Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.','<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"><br></p>\r\n<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">This course is designed to:</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"></p><ol><li>Give you an overview of The Health Insurance Portability and Accountability Act of 1996 (HIPAA).</li><li>Familiarize you with any major changes that have been implemented with the new 2013 Omnibus Rule Changes.</li><li>Help you recognize the serious consequences if you fail to comply with HIPAA.</li></ol><p></p>\r\n\r\n',80,'0','Online Only',NULL,'Online-HIPAA-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(10,'Sexual Harassment - 2 CEU','<p>After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.</p>','<p>After completing this self-study session, you will be able to:</p><ul><li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',80,'0','Online',NULL,'finalsexualharassment.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'90','0',NULL,''),(14,'Suicide and Self-Harm - 2 CEU','<p>Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is temporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.</p>','<p>Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is\r\ntemporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.</p>',80,'0','',NULL,'Suicide-Self-Harm-Final.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','',NULL,'','0',NULL,''),(15,'Cultural Diversity - 2 CEU','','',80,'0','Online Only',NULL,NULL,NULL,NULL,'Cultural-Diversity.ppsx',NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(25,'Incident Reporting Requirements - 1 CEU','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting.</p>','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting. This course details the internal procedure for completing and filing an incident report form for an unusual event, as well as, the procedure for reporting a critical incident to the DCF and Joint Commission.</p>',80,'0','',NULL,'Incident-Reporting-TN.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'','',NULL,'','0',NULL,''),(27,'Tuberculosis - 1CE','<p>Two TB-related conditions exist: latent TB infection (LTBI) and TB disease. If not treated properly, TB disease can be fatal.</p>','<p>Tuberculosis (TB) is caused by a bacterium called Mycobacterium tuberculosis. The bacteria usually attack the lungs but can affect any part of the body such as the kidney, spine, and brain. Not everyone infected with TB bacteria becomes sick. As a result, two TB-related conditions exist: latent TB infection (LTBI) and TB disease. If not treated properly, TB disease can be fatal.</p>',80,'','',NULL,'Tuberculosis-TN.pdf','Tuberculosis-TN-Policy.pdf',NULL,NULL,NULL,NULL,NULL,1,'','',NULL,'','0',NULL,''),(28,'Reporting Communicable Diseases','<p>According to 1200-14-01-.02: “All healthcare providers and other persons knowing of or suspecting a case, culture, or specimen of a reportable disease or event shall report that occurrence to the Department of Health in the time and manner set forth by the Commissioner”</p>','<p>According to 1200-14-01-.02: “All healthcare providers and other persons knowing of or suspecting a case, culture, or specimen of a reportable disease or event shall report that occurrence to the Department of Health in the time and manner set forth by the Commissioner”</p>',70,'','Online',NULL,'Reporting-Communicable-Diseases-TN.pdf','Disease-List-Healthcare-Providers.pdf',NULL,NULL,NULL,NULL,NULL,1,'','',NULL,'','0',NULL,''),(29,'Abuse Reporting & Affirmative Duties','','',70,'','',NULL,'Abuse-Reporting-TN.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','',NULL,'','0',NULL,'');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Continuing Education'),(2,'Personal Development'),(3,'Communication'),(4,'Management & Leadership'),(5,'Marketing'),(6,'Organizational Efficiency'),(7,'Certified Behavioral Health Technician (CBHT)');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (13,5,1,1),(16,15,1,1),(18,14,1,1),(19,7,1,1),(21,10,1,1),(22,3,1,1),(23,25,1,1),(25,27,1,1),(26,28,1,1),(27,29,1,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (117,5,1578595896,'Brian Hathcock ','Information ','Boring ','0','No','Idk',4),(118,5,1578606992,'','','','','','',3),(119,7,1578856250,'Charles H Bennett III','I enjoyed learning new things regarding HIPPA Law','','','','',5),(120,3,1579293434,'','','','','','',3),(121,3,1579794697,'Mary Elizabeth Condon','informative','not much','not much','sure','not sure',4),(122,5,1579794745,'Mary Elizabeth Condon','informative','not sure','not sure','sure','not sure',4),(123,7,1579794787,'Mary Elizabeth Condon','informative','not sure','not sure','sure','not sure',4),(124,10,1579794829,'Mary Elizabeth Condon','informative','not sure','not sure','sure','not sure',4),(125,3,1580715214,'Farrence Williamson','Everything','Nothing; everything was great!','N/A','Yes','N/A',4),(126,5,1580716209,'Farrence Williamson','Everything','Nothing; everything was great!','N/A','Yes','N/A',4),(127,7,1580717357,'Farrence Williamson','Everything','Nothing','N/A','No','N/N',3),(128,10,1580719096,'Farrence Williamson','Yes','Nothing; everything was great!','N/A','Yes','N/A',4),(129,10,1580719098,'Farrence Williamson','Yes','Nothing; everything was great!','N/A','Yes','N/A',4),(130,14,1580734274,'Farrence Williamson','Everything','N/A','N/A','Yes','N/A',4),(131,3,1580853190,'Asher Levine','facts about testing and number of infected','i dont know ','more info about cures','no','addiction',3),(132,3,1580853190,'Asher Levine','facts about testing and number of infected','i dont know ','more info about cures','no','addiction',3),(133,27,1580890093,'Farrence Williamson','Everything','N/A','N/A','Yes','N/A',4),(134,14,1580978681,'Angela McCartney','','','','','',4),(135,15,1580982099,'Angela McCartney','','','','','',4),(136,7,1580982394,'Angela McCartney','','','','','',4),(137,25,1580983343,'Angela McCartney','','','','','',3),(138,15,1580983403,'Angela McCartney','','','','','',4),(139,15,1580987672,'Angela McCartney','','','','','',3),(140,29,1580988616,'Angela McCartney','','','','','',3),(141,3,1584114074,'','','','','','',4),(142,3,1584114085,'','','','','','',4),(143,4,1584114896,'','','','','','',4),(144,4,1584114915,'','','','','','',4),(145,4,1584114934,'','','','','','',4),(146,3,1586817317,'','','','','','',4),(147,29,1586817784,'','','','','','',4),(148,3,1587748451,'Hannah Younger','','','','','',5),(149,4,1587748779,'Hannah Younger','','','','','',5),(150,5,1587749400,'Hannah Younger','','','','','',5),(151,7,1587749931,'Hannah Younger','','','','','',5),(152,14,1587750564,'Hannah Younger','','','','','',5),(153,27,1587752343,'Hannah Younger','','','','','',5),(154,28,1587752656,'Hannah Younger','','','','','',5),(155,3,1588626957,'Madeline Young','I felt that the course was very informative, and I learned some things I didn\'t know before.','HIV and AIDS are not particularly enjoyable subjects to discuss.','n/a','Not really.','n/a',5),(156,3,1595047827,'Carla Perry','It was educational ','No e','No e','Yes','Health',4),(157,5,1595437721,'Carla ','','','','','',3),(158,5,1595437802,' Area Perry ','Learing','Learing','Nothing','Yes','Health',3),(159,5,1595445939,'Carla perry','Na','Na','Na','Na','Na',3),(160,5,1595446401,'Carla Perry','','','','','',3),(161,4,1595702104,'angie wilson','looking at the different solutions and coping techniques ','the length of time ','','','',4),(162,5,1595702617,'angie wilson','reveiw ','review ','','','',4),(163,7,1595710239,'angie wilson','review of information ','','','','more therapeutic information ',3),(164,10,1595710861,'angie wilson','reveiw of information ','','','','',4),(165,3,1595866630,'Paige Taylor','Easy to read','n/a','n/a','yes','n/a',5),(166,4,1595867242,'Paige Taylor','easy to read','n/a','n/a','yes','n/a',5),(167,5,1595867814,'Paige Taylor','easy to read','n/a','n/a','yes','n/a',5),(168,15,1596051075,'angie wilson','reveiw of material','','','','',4),(169,3,1596157270,'Derrick Johnson','','','','','',4),(170,3,1597243680,'','','','','','',2),(171,4,1597244311,'','','','','','',2),(172,5,1597244898,'','','','','','',2),(173,7,1597245751,'','','','','','',2),(174,10,1597247085,'','','','','','',2),(175,10,1597247115,'','','','','','',2),(176,14,1597247764,'','','','','','',2),(177,15,1597247867,'','','','','','',3),(178,25,1597248689,'','','','','','',2),(179,27,1597249805,'','','','','','',2),(180,28,1597249992,'','','','','','',2),(181,29,1597250643,'','','','','','',2);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2650 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (1519,245,3,89),(1520,245,3,89),(1521,110,3,94),(1522,245,5,87),(1523,245,7,80),(1524,248,3,94),(1525,250,3,100),(1526,251,3,82),(1527,245,10,87),(1528,251,5,80),(1529,251,5,80),(1530,251,7,90),(1531,246,3,100),(1532,245,14,90),(1533,246,5,93),(1534,246,7,100),(1535,248,5,53),(1536,245,15,40),(1537,245,15,80),(1538,245,15,100),(1542,246,10,87),(1543,246,10,87),(1545,248,5,53),(1546,245,25,91),(1547,248,5,60),(1548,246,14,80),(1549,248,5,47),(1551,248,5,67),(1552,246,15,80),(1553,246,15,100),(1554,246,25,91),(1555,246,27,70),(1556,251,10,73),(1557,246,27,90),(1558,251,10,93),(1559,251,14,80),(1560,251,15,80),(1561,248,5,73),(1562,248,5,80),(1563,248,5,80),(1564,110,10,53),(1565,248,7,70),(1566,248,7,80),(1567,110,10,60),(1568,250,5,60),(1569,251,27,40),(1570,250,5,80),(1571,251,27,80),(1572,250,7,80),(1573,249,14,60),(1574,247,3,94),(1575,247,5,100),(1576,247,7,100),(1577,251,25,73),(1578,247,10,93),(1579,251,25,91),(1580,247,14,90),(1581,247,15,100),(1582,247,25,91),(1583,247,27,80),(1584,253,3,82),(1585,253,5,80),(1586,253,7,90),(1587,253,10,93),(1588,255,3,94),(1589,245,27,80),(1590,254,3,88),(1591,248,10,80),(1592,254,5,73),(1593,254,5,67),(1594,248,14,60),(1595,254,5,73),(1596,254,5,73),(1597,254,5,80),(1598,254,7,80),(1599,248,14,60),(1600,254,10,87),(1601,248,14,80),(1602,252,3,94),(1603,254,14,50),(1604,254,14,50),(1605,254,14,60),(1606,254,14,60),(1607,254,14,60),(1608,254,14,80),(1609,252,5,100),(1610,256,14,70),(1611,256,14,80),(1612,252,7,100),(1613,252,10,93),(1614,252,14,80),(1615,252,15,80),(1616,252,25,100),(1617,252,27,100),(1618,259,3,94),(1619,258,3,94),(1620,259,5,87),(1621,258,5,93),(1622,258,7,90),(1623,258,10,100),(1624,260,3,100),(1625,260,5,80),(1626,260,7,70),(1627,260,7,90),(1628,261,3,100),(1629,260,10,80),(1630,260,14,70),(1631,260,14,80),(1632,260,15,60),(1633,260,15,80),(1634,260,25,64),(1635,260,25,91),(1636,260,25,91),(1637,260,27,50),(1638,260,27,60),(1639,260,27,90),(1640,260,27,90),(1641,261,5,93),(1642,261,7,100),(1643,261,10,93),(1644,259,7,100),(1645,259,10,100),(1646,261,14,70),(1647,261,14,90),(1648,261,14,90),(1649,261,14,90),(1650,261,15,60),(1651,261,15,60),(1652,261,15,100),(1653,261,25,55),(1654,261,25,64),(1655,261,25,91),(1656,261,27,40),(1657,261,27,80),(1658,259,14,80),(1659,258,14,90),(1660,257,27,90),(1661,254,15,80),(1662,254,25,36),(1663,254,25,73),(1664,254,25,64),(1665,254,25,82),(1666,254,27,40),(1667,254,27,60),(1668,254,27,60),(1669,259,15,100),(1670,258,15,100),(1671,254,27,50),(1672,259,25,64),(1673,254,27,40),(1674,259,25,73),(1675,258,25,73),(1676,259,25,91),(1677,258,25,91),(1678,259,27,50),(1679,258,27,70),(1680,259,27,90),(1681,258,27,80),(1682,254,27,70),(1683,254,27,90),(1684,263,3,94),(1685,263,7,100),(1686,263,10,87),(1687,263,5,93),(1688,263,27,90),(1689,263,25,100),(1690,263,15,80),(1691,263,14,80),(1692,257,25,82),(1693,257,25,82),(1694,265,3,100),(1695,255,5,93),(1696,265,5,93),(1697,255,7,100),(1698,265,7,100),(1699,265,10,80),(1700,255,10,87),(1701,265,10,73),(1702,265,10,93),(1703,265,14,70),(1704,265,14,80),(1705,265,15,40),(1706,265,15,40),(1707,265,15,80),(1708,265,25,82),(1709,255,27,80),(1710,265,27,70),(1711,265,27,90),(1712,255,14,90),(1713,255,15,80),(1714,255,25,82),(1715,266,3,88),(1716,266,5,87),(1717,266,7,100),(1718,266,10,87),(1719,266,14,100),(1720,266,15,80),(1721,266,25,82),(1722,266,27,90),(1723,267,3,94),(1724,267,5,93),(1725,267,7,100),(1726,267,10,100),(1727,267,14,100),(1728,267,15,80),(1729,267,25,82),(1730,267,27,90),(1731,268,3,100),(1732,268,5,93),(1733,268,7,90),(1734,268,10,100),(1735,268,14,90),(1736,268,15,100),(1737,268,25,91),(1738,268,27,80),(1739,257,5,93),(1740,257,7,100),(1741,257,10,93),(1742,257,3,100),(1743,257,15,100),(1744,257,14,90),(1745,269,3,88),(1746,269,5,67),(1747,269,5,87),(1748,269,7,80),(1749,269,10,93),(1750,269,14,70),(1751,269,14,90),(1752,269,15,60),(1753,269,15,60),(1754,269,15,100),(1755,269,27,80),(1756,269,25,64),(1757,269,25,82),(1758,256,5,73),(1759,256,5,80),(1760,270,3,100),(1761,270,5,47),(1762,110,28,100),(1763,110,29,100),(1764,253,14,90),(1765,253,15,80),(1766,253,25,91),(1767,253,27,80),(1768,270,5,87),(1769,270,7,90),(1770,270,10,93),(1771,270,14,90),(1772,270,15,60),(1773,270,15,80),(1774,256,3,100),(1775,270,25,64),(1776,270,25,91),(1777,256,7,100),(1778,256,10,80),(1779,270,27,80),(1780,270,28,71),(1781,270,29,100),(1782,271,3,94),(1783,272,15,80),(1784,264,3,88),(1785,264,5,73),(1786,264,5,80),(1787,264,7,70),(1788,264,7,90),(1789,264,10,67),(1790,264,10,93),(1791,273,3,94),(1792,257,28,100),(1793,257,29,100),(1794,249,14,60),(1795,274,3,76),(1796,249,14,90),(1797,274,3,94),(1798,249,3,76),(1799,249,3,82),(1800,274,5,80),(1801,249,29,85),(1802,274,7,90),(1803,249,5,53),(1804,274,10,87),(1805,249,5,73),(1806,274,14,80),(1807,249,5,80),(1808,249,15,100),(1809,249,7,70),(1810,249,7,80),(1811,249,10,73),(1812,249,10,87),(1813,249,27,80),(1814,249,25,9),(1815,249,28,29),(1816,249,28,57),(1817,249,28,71),(1818,272,10,93),(1819,272,14,100),(1820,272,25,82),(1821,272,3,94),(1822,272,5,80),(1823,272,27,80),(1824,272,27,80),(1825,272,7,90),(1826,272,28,71),(1827,272,29,100),(1828,245,28,100),(1829,245,29,100),(1830,274,15,80),(1831,274,25,100),(1832,274,27,60),(1833,274,27,80),(1834,274,28,100),(1835,274,29,92),(1836,273,5,100),(1837,273,7,100),(1838,273,10,93),(1839,273,14,80),(1840,273,15,80),(1841,267,28,86),(1842,267,29,85),(1843,255,28,86),(1844,255,29,92),(1845,266,28,86),(1846,266,29,92),(1847,273,25,91),(1848,273,27,100),(1849,273,28,100),(1850,273,29,77),(1851,256,15,40),(1852,256,15,100),(1853,256,25,45),(1854,256,25,73),(1855,256,25,82),(1856,256,27,70),(1857,256,27,80),(1858,256,28,71),(1859,256,29,85),(1860,276,3,94),(1861,276,10,87),(1862,246,28,100),(1863,246,29,100),(1864,277,3,94),(1865,277,5,100),(1866,277,7,90),(1867,277,7,100),(1868,277,10,93),(1869,248,15,60),(1870,248,15,80),(1871,248,25,55),(1872,248,25,64),(1873,248,25,91),(1874,248,27,60),(1875,248,27,70),(1876,248,27,100),(1877,248,28,57),(1878,248,28,71),(1879,248,29,77),(1880,278,3,82),(1881,278,5,67),(1882,278,5,80),(1883,278,7,80),(1884,278,10,87),(1885,264,14,40),(1886,264,14,50),(1887,264,14,70),(1888,278,14,80),(1889,264,14,90),(1890,278,15,60),(1891,278,15,60),(1892,264,15,60),(1893,264,15,100),(1894,278,15,80),(1895,264,25,27),(1896,264,25,64),(1897,264,25,82),(1898,264,27,50),(1899,264,27,60),(1900,264,27,80),(1901,264,28,57),(1902,264,28,100),(1903,278,25,73),(1904,278,25,64),(1905,278,25,91),(1906,264,29,62),(1907,264,29,100),(1908,278,29,92),(1909,278,27,90),(1910,278,28,100),(1911,250,10,80),(1912,250,14,60),(1913,250,14,90),(1914,250,15,60),(1915,250,15,100),(1916,250,25,64),(1917,250,25,91),(1918,250,27,50),(1919,250,27,70),(1920,250,27,100),(1921,250,28,43),(1922,250,28,71),(1923,250,29,85),(1924,280,3,76),(1925,280,3,88),(1926,280,5,73),(1927,280,5,93),(1928,280,7,80),(1929,277,14,100),(1930,261,28,100),(1931,261,29,85),(1932,282,3,88),(1933,282,5,67),(1934,283,3,94),(1935,282,5,93),(1936,283,5,100),(1937,283,7,90),(1938,284,3,94),(1939,284,3,94),(1940,271,5,80),(1941,284,7,100),(1942,284,5,80),(1943,271,7,100),(1944,284,14,80),(1945,271,10,87),(1946,271,14,80),(1947,284,10,100),(1948,284,15,100),(1949,271,25,91),(1950,284,25,91),(1951,271,15,100),(1952,271,27,80),(1953,284,28,57),(1954,284,28,86),(1955,284,27,90),(1956,271,29,85),(1957,284,29,85),(1958,271,28,86),(1959,280,10,87),(1960,280,14,50),(1961,280,14,60),(1962,280,14,90),(1963,280,15,80),(1964,280,25,64),(1965,280,25,91),(1966,280,27,80),(1967,280,28,86),(1968,280,29,77),(1969,269,28,57),(1970,269,28,57),(1971,269,28,86),(1972,269,29,92),(1973,277,25,82),(1974,262,3,88),(1975,262,5,100),(1976,262,7,100),(1977,262,10,87),(1978,262,14,90),(1979,262,27,60),(1980,275,3,94),(1981,251,28,100),(1982,275,5,100),(1983,275,7,100),(1984,253,28,86),(1985,275,10,93),(1986,260,29,85),(1987,260,28,86),(1988,285,3,88),(1989,285,5,93),(1990,285,7,80),(1991,285,10,87),(1992,286,3,65),(1993,285,14,50),(1994,286,3,94),(1995,285,14,80),(1996,285,15,80),(1997,286,5,80),(1998,286,7,80),(1999,286,10,93),(2000,285,25,55),(2001,286,14,60),(2002,285,25,100),(2003,286,14,70),(2004,286,14,80),(2005,285,27,60),(2006,286,15,100),(2007,285,27,70),(2008,285,27,100),(2009,285,28,29),(2010,286,25,55),(2011,285,28,71),(2012,286,25,91),(2013,285,29,77),(2014,286,27,80),(2015,286,28,57),(2016,286,28,100),(2017,286,29,69),(2018,286,29,77),(2019,258,28,57),(2020,258,28,71),(2021,258,29,100),(2022,252,28,100),(2023,252,29,100),(2024,247,28,71),(2025,247,29,100),(2026,249,25,55),(2027,249,25,91),(2028,268,28,71),(2029,279,3,82),(2030,268,29,69),(2031,268,29,85),(2032,253,29,100),(2033,279,5,93),(2034,279,7,90),(2035,279,10,100),(2036,275,14,90),(2037,262,27,100),(2038,262,25,45),(2039,262,25,82),(2040,262,15,80),(2041,262,15,100),(2042,262,28,100),(2043,262,29,100),(2044,275,27,100),(2045,275,15,100),(2046,275,25,82),(2047,282,14,90),(2048,282,27,80),(2049,275,29,100),(2050,282,7,80),(2051,275,28,71),(2052,282,10,100),(2053,282,15,100),(2054,282,28,100),(2055,282,25,55),(2056,282,25,82),(2057,282,29,92),(2058,276,14,60),(2059,276,14,90),(2060,276,15,100),(2061,276,5,80),(2062,276,7,100),(2063,276,25,91),(2064,276,27,70),(2065,276,27,90),(2066,276,28,86),(2067,276,29,85),(2068,265,28,71),(2069,265,29,77),(2070,279,14,90),(2071,279,15,100),(2072,279,15,100),(2073,279,25,73),(2074,277,27,60),(2075,279,25,82),(2076,279,25,82),(2077,277,27,90),(2078,277,15,100),(2079,277,28,100),(2080,279,27,80),(2081,279,28,86),(2082,279,29,100),(2083,277,29,100),(2084,288,3,94),(2085,288,5,100),(2086,288,7,100),(2087,259,28,57),(2088,259,28,57),(2089,259,28,86),(2090,259,29,69),(2091,259,29,92),(2092,288,28,100),(2093,288,10,93),(2094,288,25,91),(2095,288,15,100),(2096,288,14,90),(2097,288,27,100),(2098,288,29,100),(2099,254,28,57),(2100,254,28,71),(2101,254,29,69),(2102,254,29,77),(2103,110,4,87),(2104,290,3,100),(2105,290,4,93),(2106,290,5,100),(2107,290,7,90),(2108,290,10,87),(2109,290,14,90),(2110,290,15,80),(2111,290,25,91),(2112,290,27,50),(2113,290,27,50),(2114,290,27,70),(2115,290,27,100),(2116,290,28,57),(2117,290,28,86),(2118,290,29,92),(2119,289,3,88),(2120,289,4,93),(2121,289,5,100),(2122,258,4,80),(2123,281,3,88),(2124,281,29,100),(2125,281,27,100),(2126,281,4,93),(2127,281,28,86),(2128,281,5,87),(2129,281,7,90),(2130,281,25,82),(2131,281,15,80),(2132,281,14,70),(2133,281,14,90),(2134,281,10,93),(2135,292,29,85),(2136,293,3,82),(2137,295,3,100),(2138,295,29,85),(2139,295,28,57),(2140,295,28,86),(2141,295,27,60),(2142,295,27,80),(2143,295,25,45),(2144,295,25,73),(2145,295,25,100),(2146,295,15,80),(2147,295,14,70),(2148,295,14,90),(2149,295,10,93),(2150,295,7,80),(2151,295,5,80),(2152,295,4,93),(2153,293,4,87),(2154,297,3,88),(2155,297,4,87),(2156,297,5,80),(2157,297,7,90),(2158,297,10,80),(2159,297,14,50),(2160,297,14,90),(2161,297,15,100),(2162,297,25,82),(2163,297,27,80),(2164,297,28,71),(2165,297,29,77),(2166,298,3,94),(2167,298,10,87),(2168,298,14,60),(2169,298,14,90),(2170,298,15,80),(2171,298,4,80),(2172,298,7,100),(2173,298,5,67),(2174,298,5,100),(2175,298,25,64),(2176,298,25,91),(2177,298,27,80),(2178,298,28,86),(2179,298,29,100),(2180,299,3,94),(2181,299,4,60),(2182,299,4,80),(2183,299,5,67),(2184,293,5,80),(2185,300,3,94),(2186,300,4,93),(2187,300,5,100),(2188,300,7,100),(2189,300,10,93),(2190,300,14,70),(2191,300,14,80),(2192,300,15,60),(2193,300,15,100),(2194,300,25,82),(2195,300,27,100),(2196,300,28,86),(2197,300,28,86),(2198,300,29,85),(2199,293,7,90),(2200,293,10,93),(2201,301,3,88),(2202,301,4,80),(2203,301,5,87),(2204,301,7,90),(2205,301,10,73),(2206,301,10,93),(2207,293,14,50),(2208,293,14,50),(2209,293,14,80),(2210,293,15,40),(2211,293,15,60),(2212,293,15,80),(2213,248,4,87),(2214,302,3,94),(2215,302,4,93),(2216,302,5,87),(2217,302,7,90),(2218,302,10,87),(2219,302,14,50),(2220,302,14,70),(2221,302,14,90),(2222,302,15,80),(2223,302,25,55),(2224,302,25,82),(2225,302,27,30),(2226,302,27,100),(2227,302,28,86),(2228,302,29,85),(2229,292,25,73),(2230,292,25,91),(2231,292,28,71),(2232,292,5,93),(2233,292,27,80),(2234,292,7,80),(2235,303,3,100),(2236,292,10,87),(2237,292,14,80),(2238,292,29,85),(2239,292,3,94),(2240,303,4,93),(2241,303,5,93),(2242,303,7,100),(2243,303,10,73),(2244,303,10,93),(2245,303,28,71),(2246,303,27,80),(2247,303,29,85),(2248,303,25,64),(2249,303,25,82),(2250,293,25,55),(2251,293,25,45),(2252,293,25,64),(2253,293,25,82),(2254,293,27,20),(2255,293,27,30),(2256,293,27,60),(2257,293,27,90),(2258,293,28,43),(2259,293,28,71),(2260,293,29,54),(2261,293,29,62),(2262,293,29,77),(2263,253,4,87),(2264,294,5,93),(2265,294,27,80),(2266,294,25,91),(2267,294,3,94),(2268,294,28,86),(2269,294,4,100),(2270,294,14,100),(2271,294,29,100),(2272,294,10,87),(2273,294,15,100),(2274,294,7,90),(2275,301,14,60),(2276,301,14,70),(2277,301,14,100),(2278,301,15,20),(2279,301,15,100),(2280,273,4,87),(2281,257,4,100),(2282,301,25,64),(2283,301,25,73),(2284,301,25,82),(2285,301,27,70),(2286,301,27,90),(2287,301,28,71),(2288,301,28,100),(2289,301,29,69),(2290,301,29,100),(2291,284,4,80),(2292,261,4,93),(2293,251,4,93),(2294,245,4,100),(2295,270,4,93),(2296,249,4,80),(2297,305,3,94),(2298,305,4,100),(2299,305,5,87),(2300,305,7,100),(2301,305,10,93),(2302,305,14,80),(2303,305,15,100),(2304,305,25,91),(2305,305,27,80),(2306,305,28,100),(2307,305,29,100),(2308,304,3,100),(2309,304,4,80),(2310,304,5,93),(2311,304,7,100),(2312,304,10,93),(2313,304,14,90),(2314,304,15,100),(2315,304,25,73),(2316,304,25,91),(2317,304,27,70),(2318,304,27,80),(2319,304,28,86),(2320,304,29,92),(2321,252,4,100),(2322,274,4,100),(2323,306,7,70),(2324,306,7,90),(2325,306,10,80),(2326,306,14,60),(2327,306,14,80),(2328,306,15,60),(2329,306,15,100),(2330,306,25,55),(2331,306,25,73),(2332,306,25,73),(2333,287,5,93),(2334,287,4,100),(2335,287,3,94),(2336,287,7,90),(2337,287,10,93),(2338,287,27,90),(2339,287,25,91),(2340,287,14,90),(2341,287,15,80),(2342,287,15,80),(2343,287,28,86),(2344,287,29,100),(2345,287,29,100),(2346,307,3,94),(2347,307,4,87),(2348,307,5,93),(2349,307,7,100),(2350,307,10,87),(2351,307,14,90),(2352,307,15,80),(2353,307,25,91),(2354,307,27,80),(2355,307,28,100),(2356,307,29,100),(2357,308,29,100),(2358,308,4,100),(2359,308,15,80),(2360,308,7,100),(2361,308,3,100),(2362,309,5,67),(2363,309,5,73),(2364,309,5,80),(2365,309,29,85),(2366,309,4,73),(2367,309,4,87),(2368,309,15,100),(2369,309,3,71),(2370,309,3,88),(2371,308,25,91),(2372,308,5,93),(2373,308,28,57),(2374,308,28,86),(2375,308,10,80),(2376,308,14,80),(2377,308,27,70),(2378,308,27,100),(2379,313,3,94),(2380,313,4,100),(2381,311,3,88),(2382,311,4,87),(2383,311,5,87),(2384,313,5,93),(2385,313,7,90),(2386,313,10,93),(2387,313,14,90),(2388,313,15,80),(2389,313,25,91),(2390,313,27,80),(2391,313,28,100),(2392,313,29,100),(2393,310,3,76),(2394,310,3,94),(2395,310,4,93),(2396,310,5,87),(2397,310,7,80),(2398,310,10,93),(2399,310,14,50),(2400,310,14,90),(2401,310,15,80),(2402,310,25,55),(2403,310,25,73),(2404,310,25,73),(2405,310,25,91),(2406,310,27,60),(2407,310,27,80),(2408,310,28,71),(2409,310,29,69),(2410,310,29,85),(2411,311,7,80),(2412,311,10,80),(2413,311,14,90),(2414,311,15,80),(2415,311,25,82),(2416,311,27,80),(2417,311,28,71),(2418,311,29,100),(2419,314,3,94),(2420,314,4,80),(2421,314,5,80),(2422,314,7,90),(2423,314,10,87),(2424,314,14,60),(2425,314,14,90),(2426,314,15,60),(2427,314,15,100),(2428,314,25,91),(2429,314,27,80),(2430,314,28,71),(2431,314,29,100),(2432,312,3,94),(2433,312,4,87),(2434,312,4,87),(2435,312,5,80),(2436,315,3,94),(2437,315,4,100),(2438,315,5,100),(2439,315,7,90),(2440,312,3,88),(2441,312,4,87),(2442,312,5,67),(2443,312,7,70),(2444,312,7,90),(2445,316,3,82),(2446,316,4,87),(2447,312,14,60),(2448,312,14,50),(2449,312,14,50),(2450,312,14,80),(2451,312,15,60),(2452,312,15,40),(2453,312,15,100),(2454,312,25,36),(2455,312,25,45),(2456,312,25,73),(2457,312,25,91),(2458,316,5,73),(2459,316,5,87),(2460,316,7,80),(2461,316,10,87),(2462,316,14,70),(2463,316,14,90),(2464,299,5,73),(2465,299,5,73),(2466,299,5,80),(2467,299,5,80),(2468,299,7,60),(2469,299,7,100),(2470,299,10,93),(2471,299,14,70),(2472,299,14,80),(2473,299,15,80),(2474,299,25,64),(2475,299,25,82),(2476,299,27,40),(2477,299,27,60),(2478,299,27,80),(2479,299,28,57),(2480,299,28,71),(2481,299,29,77),(2482,312,29,77),(2483,317,3,88),(2484,317,4,93),(2485,317,5,100),(2486,317,7,100),(2487,317,10,93),(2488,317,14,90),(2489,317,15,100),(2490,317,27,70),(2491,317,27,90),(2492,317,25,73),(2493,317,25,100),(2494,317,28,86),(2495,317,29,92),(2496,316,15,80),(2497,316,25,73),(2498,316,25,82),(2499,316,27,40),(2500,316,27,70),(2501,316,27,70),(2502,316,27,90),(2503,316,28,86),(2504,316,29,100),(2505,318,3,94),(2506,318,4,87),(2507,318,5,87),(2508,318,7,100),(2509,318,10,87),(2510,318,14,100),(2511,318,15,100),(2512,318,25,82),(2513,318,27,70),(2514,318,27,90),(2515,318,28,86),(2516,318,29,100),(2517,319,3,76),(2518,319,3,82),(2519,319,4,93),(2520,319,5,67),(2521,319,5,93),(2522,319,7,90),(2523,319,10,80),(2524,319,14,70),(2525,319,14,80),(2526,319,15,80),(2527,319,25,64),(2528,319,25,100),(2529,319,27,60),(2530,319,27,80),(2531,319,28,86),(2532,319,28,86),(2533,319,29,92),(2534,312,5,60),(2535,312,5,67),(2536,312,10,80),(2537,312,27,50),(2538,312,27,70),(2539,312,27,60),(2540,312,27,70),(2541,312,27,40),(2542,312,27,60),(2543,312,27,70),(2544,312,27,70),(2545,312,27,80),(2546,312,28,86),(2547,320,3,100),(2548,320,4,73),(2549,320,4,93),(2550,320,5,93),(2551,320,7,90),(2552,320,29,92),(2553,320,10,93),(2554,320,28,86),(2555,320,28,100),(2556,320,10,100),(2557,320,10,100),(2558,320,4,80),(2559,320,4,87),(2560,320,4,100),(2561,320,5,93),(2562,320,5,93),(2563,320,5,93),(2564,320,5,93),(2565,320,5,100),(2566,320,7,100),(2567,320,29,100),(2568,320,27,70),(2569,320,27,90),(2570,320,27,100),(2571,320,25,91),(2572,320,25,82),(2573,320,25,100),(2574,320,15,60),(2575,320,15,80),(2576,320,15,80),(2577,320,15,100),(2578,320,14,100),(2579,321,27,50),(2580,321,27,60),(2581,321,27,70),(2582,321,27,60),(2583,321,27,70),(2584,321,27,80),(2585,321,29,69),(2586,321,29,92),(2587,321,28,86),(2588,321,25,91),(2589,321,15,40),(2590,321,15,80),(2591,321,14,60),(2592,321,14,90),(2593,321,7,80),(2594,321,5,67),(2595,321,5,80),(2596,321,10,80),(2597,321,4,87),(2598,321,3,88),(2599,315,10,93),(2600,315,14,100),(2601,315,15,80),(2602,315,25,64),(2603,315,25,73),(2604,315,25,82),(2605,315,27,40),(2606,315,27,80),(2607,315,27,90),(2608,315,28,57),(2609,315,28,71),(2610,315,29,62),(2611,315,29,69),(2612,315,29,92),(2613,322,3,82),(2614,322,4,80),(2615,322,5,80),(2616,322,7,80),(2617,322,10,80),(2618,322,14,50),(2619,322,29,77),(2620,322,29,77),(2621,322,15,60),(2622,322,15,80),(2623,322,15,80),(2624,322,14,70),(2625,323,3,76),(2626,323,3,88),(2627,323,4,87),(2628,323,5,87),(2629,323,7,70),(2630,323,7,100),(2631,323,10,87),(2632,323,14,70),(2633,323,14,100),(2634,323,15,100),(2635,323,25,45),(2636,323,25,82),(2637,323,27,50),(2638,323,27,70),(2639,323,27,90),(2640,323,28,86),(2641,323,29,77),(2642,322,25,73),(2643,322,25,82),(2644,322,27,60),(2645,322,27,80),(2646,322,28,86),(2647,322,28,86),(2648,322,14,60),(2649,322,14,90);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3),(1,4),(1,5);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Professional Development');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12368 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(327,62,'True',1),(328,62,'False',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(463,26,'True',1),(464,26,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(522,48,'Sudden shift in mood or behavior',NULL),(523,48,'Skin rash',NULL),(524,48,'Muscle weakness',NULL),(525,48,'Confusion',NULL),(526,48,'a, c, and d ',1),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(566,74,'Gloves, gowns, respirators',NULL),(567,74,'Face masks, goggles, face shields',NULL),(568,74,'Shoes and socks',NULL),(569,74,'A and B',1),(570,74,'A and C',NULL),(571,75,'Wear protective gloves',NULL),(572,75,'Run away from spill in order to not get contaminated ',NULL),(573,75,'Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(574,75,'A and B',NULL),(575,75,'A and C',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(584,79,'Viruses',NULL),(585,79,'Parasites',NULL),(586,79,'Bacteria',NULL),(587,79,'Fungus',NULL),(588,79,'All of the above',1),(589,80,'Air',NULL),(590,80,'Water',NULL),(591,80,'Bodily fluids',NULL),(592,80,'A and B',1),(593,80,'A and C',NULL),(594,88,'Airborne',NULL),(595,88,'Droplet',NULL),(596,88,'Contact',1),(597,88,'A and B',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'Health Information Property Accountability Association',NULL),(693,116,'Human Insurance Process Accumulation Act',NULL),(694,116,'Health Insurance Portability and Accountability Act',1),(695,117,'Electronic Medical Record ',NULL),(696,117,'Security ',NULL),(697,117,'HITECH',1),(698,117,'HHS',NULL),(699,118,'Medical record number',NULL),(700,118,'Telephone number',NULL),(701,118,'Fax number',NULL),(702,118,'Social security number',NULL),(703,118,'All of the above',1),(704,118,'a, b, d',NULL),(705,119,'True',NULL),(706,119,'False',1),(707,120,'Disciplinary action',NULL),(708,120,'Loss of access privileges',NULL),(709,120,'Fines and penalties',NULL),(710,120,'Imprisonment',NULL),(711,120,'All of the above',1),(712,121,'Yes, if he is an employee and you know him.',NULL),(713,121,'Yes, if your manager says that it’s okay.',NULL),(714,121,'No, sharing log-in IDs and passwords is a security violation.',1),(715,121,'a and b',NULL),(716,122,'I am only expected to complete the minimum requirements of my job.',NULL),(717,122,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(718,122,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(719,122,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(720,122,'b and c',1),(725,124,'Yes',NULL),(726,124,'No',1),(734,126,'Yes for example I may need to  communicate client information to my boss for shift change.',NULL),(735,126,'No, because the intended users phone could be lost or stolen and exposed to a third party.',1),(744,125,'Yes.  They can be used interchangeably.',NULL),(745,125,'No. Consents are used to get the patient\'s permission to use or disclose health information for treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(746,127,'State and local governments',NULL),(747,127,'Private employers',NULL),(748,127,'Employment agencies',NULL),(749,127,'Labor organizations',NULL),(750,127,'All of the above',1),(751,128,'No means of transportation',NULL),(752,128,'A criminal history',NULL),(753,128,'A physical or mental impairment that substantially limits one or more life activities',1),(754,128,'None of the above',NULL),(755,128,'All of the above',NULL),(756,129,'Sexual preference',NULL),(757,129,'Kleptomania',NULL),(758,129,'Illegal Drug use',NULL),(759,129,'All of the above',1),(764,131,'Changing a training manual',NULL),(765,131,'Letting employee sleep during work hours',NULL),(766,131,'Providing an interpreter',NULL),(767,131,'A and C',1),(768,130,'True',1),(769,130,'False',NULL),(770,132,'True',1),(771,132,'False',NULL),(772,133,'True',NULL),(773,133,'False',1),(774,134,'True',1),(775,134,'False',NULL),(776,135,'True',NULL),(777,135,'False',1),(778,136,'Walking',NULL),(779,136,'Breathing',NULL),(780,136,'Eating',NULL),(781,136,'Major bodily functions',NULL),(782,136,'All of the above',1),(831,146,'A public health problem, impacting large numbers of the population',1),(832,146,'A family problem, best dealt with within the family ',NULL),(833,146,'A reportable crime in Florida regardless of whether or not a weapon was used in the abuse',NULL),(834,146,'All of the above',NULL),(847,150,'Verbal abuse',NULL),(848,150,'Physical acting out',NULL),(849,150,'Difficulty getting along with others',1),(850,150,'All of the above',NULL),(851,151,'Forcing sexual acts',NULL),(852,151,'Isolating the victim',NULL),(853,151,'The abuser threatening suicide',NULL),(854,151,'All of the above',1),(855,152,'Drug or alcohol abuse',NULL),(856,152,'Intense jealousy',NULL),(857,152,'Welcoming of others into relationship',1),(858,152,'Will not allow a break-up of the relationship',NULL),(859,153,'Emotional insecurity and depression',1),(860,153,'Belief in the bonds of marriage and monogamy',NULL),(861,153,'Maturity and self-reliance',NULL),(862,153,'Strong ego and many friends',NULL),(867,154,'Withhold money',NULL),(868,154,'Intimidate',NULL),(869,154,'Use children to deliver messages',NULL),(870,154,'All of the above',1),(871,155,'Signs of a victim',NULL),(872,155,'Parts of the cycle of violence',NULL),(873,155,'Signs of an abuser',1),(874,155,'Signs of marital conflict',NULL),(891,160,'Intervening directly with the abuser',NULL),(892,160,'Acknowledging client barriers for seeking help',1),(893,160,'Filing police reports on behalf of the victim',NULL),(894,160,'None of the above',NULL),(903,163,'Increasing safety at home',NULL),(904,163,'Planning for emotional support',NULL),(905,163,'Immediate and long term safety',NULL),(906,163,'All of the above',1),(907,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a gunshot wound, or life threatening injury indicating an act of violence.',1),(908,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a broken arm, leg etc.',NULL),(909,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a fall',NULL),(910,164,'None of the above',NULL),(919,149,'Low self-esteem, low income and drug and alcohol abuse',NULL),(920,149,'Individual, societal, relational and community',1),(921,149,'Anger, passivity, Anti-social personality traits and Borderline personality traits',NULL),(922,149,'All of the above',NULL),(927,158,'Emotional discomfort',NULL),(928,158,'Blaming the victim',1),(929,158,'Cultural barriers',NULL),(930,158,'Uncooperative behavior by the victim',NULL),(931,159,'Accurate documentation and safe guarding evidence',1),(932,159,'Staying disconnected',NULL),(933,159,'Demand the criminal justice system get involved',NULL),(934,159,'All of the above',NULL),(939,161,'Helping victim create a safety plan',NULL),(940,161,'Give advice whether to leave or stay in abusive relationship',1),(941,161,'Validate victims experience',NULL),(942,161,'Respect confidentiality of victim',NULL),(943,165,'That the assessment was conducted and no Domestic Violence signs were indicated',NULL),(944,165,'That the assessment was conducted and the worker did not get an answer about DV from the patient',NULL),(945,165,'That the assessment was conducted and that the patient did not disclose abuse',1),(946,165,'None of the above',NULL),(947,156,'911—If you are in immediate danger',NULL),(948,156,'The National Domestic Violence Hotline at 1-800-799-SAFE (7233)',NULL),(949,156,'The National Sexual Assault Hotline at 1-800-656-4673',NULL),(950,156,'All of the above',1),(955,162,'800-799-7233',NULL),(956,162,'800-500-1119',1),(957,162,'800-656-4673',NULL),(958,162,'800-656-6767',NULL),(959,147,'Stalking, psychological violence; neglect and physical violence',NULL),(960,147,'Physical violence, sexual violence; stalking; and emotional violence',NULL),(961,147,'Physical violence; sexual violence; threats of physical and sexual violence; emotional and psychological violence',1),(962,147,'None of the above',NULL),(963,148,'Witnessing or experiencing violence as a child',NULL),(964,148,'Economic security',1),(965,148,'Weak community sanctions against Domestic Violence such as police being unwilling to intervene',NULL),(966,148,'Dominance and control by one partner in the relationship',NULL),(967,157,'9.2% to 30.5%',1),(968,157,'15%',NULL),(969,157,'24.3%',NULL),(970,157,'14.8%',NULL),(971,166,'a. The presence of two or more disorders at the same time',1),(972,166,'b. The presence of at least 2 mental health disorders',NULL),(973,166,'c. The presence of at least 2 substance related disorders',NULL),(974,166,'d. None of the above',NULL),(979,168,'a. Alcohol and drugs can increase underlying risk for mental disorders.',NULL),(980,168,'b. Alcohol or drugs are often used to self-medicate symptoms of depression or anxiety.',NULL),(981,168,'c. Psychiatric problems do not get worse by using drugs or alcohol.',1),(982,168,'d. Alcohol and drug abuse can make symptoms of a mental health problem worse.',NULL),(983,167,'a. Schizophrenia and Depression ',NULL),(984,167,'b. Bipolar Disorder and Anxiety Disorder',1),(985,167,'c. Depression and Fibromyalgia',NULL),(986,167,'d. Bipolar Disorder and Chronic Fatigue',NULL),(987,169,'a. Lying about one’s addiction',NULL),(988,169,'b. Denial frequently occurs in mental disorders',NULL),(989,169,'c. If the problem is not acknowledged, it doesn\'t exist.',NULL),(990,169,'d. All of the above',1),(991,170,'a. Feeling restless or jumpy',NULL),(992,170,'b. Trouble concentrating',NULL),(993,170,'c. Decreased need for sleep',NULL),(994,170,'d. A and B',1),(995,171,'a. Sequential model of treatment',NULL),(996,171,'b. Parallel model of treatment',NULL),(997,171,'c. Integrated model of treatment',1),(998,171,'d. All of the above',NULL),(999,172,'a. Abusing alcohol and/or other drugs',NULL),(1000,172,'b. A complex interplay of genetics, the environment, and other outside factors. ',1),(1001,172,'c. The environment',NULL),(1002,172,'d. Genetics',NULL),(1011,175,'a. Depression?',NULL),(1012,175,'b. Bipolar Disorder?',NULL),(1013,175,'c. Obsessive Compulsive Disorder?',1),(1014,175,'d. Social Anxiety Disorder? ',NULL),(1015,176,'a. Obsessive Compulsive Disorder?',NULL),(1016,176,'b. Anxiety Disorder?',NULL),(1017,176,'c. Mania phase in Bipolar Disorder?',1),(1018,176,'d. Depression?',NULL),(1019,177,'True',1),(1020,177,'False',NULL),(1021,178,'True',1),(1022,178,'False',NULL),(1023,179,'True',1),(1024,179,'False',NULL),(1025,180,'True',1),(1026,180,'False',NULL),(1042,184,'a. A counselor\'s beliefs',NULL),(1043,184,'b. A counselor\'s moral compass',NULL),(1044,184,'c. A counselor\'s values',NULL),(1045,184,'d. A counselor\'s daily routine',1),(1071,189,'a. Are not worth understanding',NULL),(1072,189,'b. Mean that a counselor must be able to make ethical decisions on the fly.',1),(1073,189,'c. Are unavoidable but largely irrelevant.',NULL),(1074,189,'d. Don\'t exist - there are standard responses to every problem.',NULL),(1075,189,'e. All of the above',NULL),(1076,190,'a. Confidentiality',1),(1077,190,'b. Issuance of a Certificate of Financial Responsibility',NULL),(1078,190,'c. Oral records only',NULL),(1079,190,'d. Current clients only',NULL),(1080,190,'e. All of the above',NULL),(1083,192,'a. Should be encouraged',NULL),(1084,192,'b. Can increase the risk of exploitation or misinterpretation',1),(1085,192,'c. Is rarely a problem',NULL),(1086,192,'d. Can keep the client-counselor relationship more interesting',NULL),(1087,192,'e. All of the above',NULL),(1088,193,'a. Administered by the counselor with minimal client input.',NULL),(1089,193,'b. Not a part of professional ethics.',NULL),(1090,193,'c. Helpful in allowing the client to understand the direction of their treatment.',1),(1091,193,'d. Just about signing paperwork',NULL),(1092,193,'e. All of the above',NULL),(1133,173,'a. Behaviors to prevent weight gain such as self-induced vomiting',NULL),(1134,173,'b. Frequent episodes of consuming very large amounts of food ',1),(1135,173,'c. Intense fear of weight gain',NULL),(1136,173,'d. All of the above',NULL),(1137,174,'a. Restricting food intake',NULL),(1138,174,'b. Frequent episodes of consuming  large amount of food followed by self-induced vomiting',1),(1139,174,'c. Extreme loss of weight',NULL),(1140,174,'d. All of the above',NULL),(1141,201,'Self-Harm is most common in early adolescence',NULL),(1142,201,'Self-Harm is most common in college age students',1),(1143,201,'Self-Harm is most common at the age of 20',NULL),(1144,201,'Self-Harm is most common at the age of 40',NULL),(1145,201,'Self-Harm is most common in early twenties.',NULL),(1146,202,'True    ',1),(1147,202,'False',NULL),(1153,204,'Unrelenting low mood',NULL),(1154,204,'Anxiety, psychic pain, inner tension',NULL),(1155,204,'Sleep problems',NULL),(1156,204,'Threatening suicide or expressing strong wish to die',NULL),(1157,204,'All of the above',1),(1158,205,'Ask directly about suicide, be specific in your inquiry',NULL),(1159,205,'Determine level of suicide risk; low, moderate or high',NULL),(1160,205,'Medications, what they are currently taking, what they have taken in the past and what did or did not work',NULL),(1161,205,'Prior attempts increase possibility of successful suicide',NULL),(1162,205,'All of the above',1),(1163,206,'Yes',1),(1164,206,'No',NULL),(1165,207,'Substance Abuse and Mental Health Disorders',1),(1166,207,'Self-Harm and Substance Abuse',NULL),(1167,207,'Eating Disorder and Mental Health Disorder',NULL),(1168,208,'Victims of Domestic Violence are 5 times more likely to commit suicide.',NULL),(1169,208,'Victims of Domestic Violence are 12 times more likely to commit suicide.',1),(1170,208,'Victims of Domestic Violence are 21 times more likely to commit suicide.',NULL),(1171,209,'10 times',NULL),(1172,209,'17 times',NULL),(1173,209,'42 times',NULL),(1174,209,'23 times',1),(1175,210,'Can’t get out of the depression',NULL),(1176,210,'Can’t think clearly',NULL),(1177,210,'Can’t stop the pain',NULL),(1178,210,'Can’t see themselves as worthwhile',NULL),(1179,210,'All of the above',1),(1180,211,'True',1),(1181,211,'False',NULL),(1182,212,'Cultural Tolerance',NULL),(1183,212,'Cultural Acculturation',NULL),(1184,212,'Cultural Competence',NULL),(1185,212,'Cultural Assimilation',1),(1186,213,'African American',NULL),(1187,213,'American Indian',NULL),(1188,213,'Asian American',NULL),(1189,213,'Caucasian',1),(1190,213,'Hispanic',NULL),(1191,214,'True',NULL),(1192,214,'False',1),(1193,215,'True',1),(1194,215,'False',NULL),(1195,181,'a. Fines under federal law',NULL),(1196,181,'b. Losing your job',NULL),(1197,181,'c. Prison time',NULL),(1198,181,'d. Legal issues',NULL),(1199,181,'e. All of the above',1),(1200,182,'a. Is our moral but not legal obligation',NULL),(1201,182,'b. Is our legal and moral obligation',1),(1202,182,'c. Is neither our legal nor moral obligation',NULL),(1203,182,'d. Is our legal but not moral obligation',NULL),(1204,182,'e. All of the above',NULL),(1205,183,'a. Keep functions separate based on location',NULL),(1206,183,'b. Understand your role as a counselor',NULL),(1207,183,'c. By having an honest conversation with the client about your relationship',NULL),(1208,183,'d. Stay wary of possible confidentiality breaches',NULL),(1209,183,'e. All of the above',1),(1210,185,'a. Basic requiring no knowledge of law and precedent',NULL),(1211,185,'b. Generally easy and apply to every client',NULL),(1212,185,'c. Nuanced making them often very difficult',1),(1213,185,'d. Cut and dried when following the law',NULL),(1214,185,'e. All of the above',NULL),(1220,186,'a. The counselor cannot make up their mind',NULL),(1221,186,'b. Counselors have more than one client',NULL),(1222,186,'c. Counselors have more than one relationship with the client',1),(1223,186,'d. The counselor is empathetic towards a client',NULL),(1224,186,'e. All of the above',NULL),(1225,187,'a. Are set by the client',NULL),(1226,187,'b. Don’t generally apply to counselors',NULL),(1227,187,'c. Were more important in the past',NULL),(1228,187,'d. Are an important part of counseling',1),(1229,187,'e. All of the above',NULL),(1230,188,'a. May require a counselor to sign an agreement to uphold certain standards.',NULL),(1231,188,'b. Are important',NULL),(1232,188,'c. Require counselor training, in most states',NULL),(1233,188,'d. Are generally self-regulated by the industry',NULL),(1234,188,'e. All of the above',1),(1235,191,'True',NULL),(1236,191,'False',1),(1242,200,'a. Clinical, moral, legal',NULL),(1243,200,'b. Legal, moral, ethical',1),(1244,200,'c. Ethical, moral, clinical',NULL),(1245,200,'d. Ethical, legal, clinical',NULL),(1246,200,'e. None of the above',NULL),(1247,199,'a. Areas a professional counselor is interested in working in',NULL),(1248,199,'b. All areas of clinical practice',NULL),(1249,199,'c. Actions that a member of the profession is trained and authorized to perform',1),(1250,199,'d. Clinical practice in areas where the counselor can receive clinical supervision',NULL),(1251,199,'e. None of the above',NULL),(1252,198,'a. Counselor and hair stylist',NULL),(1253,198,'b. Counselor to your best friends brother',NULL),(1254,198,'c. Counselor and supervisor',NULL),(1255,198,'d. Counselor and 12-step sponsor',NULL),(1256,198,'e. All of the above',1),(1257,197,'a. May make clinical mistakes',NULL),(1258,197,'b. May begin to burn out',NULL),(1259,197,'c. May cross professional boundaries',NULL),(1260,197,'d. May exploit the client',NULL),(1261,197,'e. All of the above',1),(1262,196,'a. A counselor sharing their personal feelings with their client',NULL),(1263,196,'b. A counselor experiencing an emotional connection beyond what is acceptable in the client-counselor relationship.',1),(1264,196,'c. A client focusing on their feelings for the counselor',NULL),(1265,196,'d. A counselor having a dual relationship with their client',NULL),(1266,196,'e. A client placing feelings about others from their lies onto the counselor',NULL),(1267,195,'a. A client placing feelings about others from their lives onto the counselor',1),(1268,195,'b. A client focusing on their feelings for the counselor',NULL),(1269,195,'c. A client transferring their feelings with the feelings of the counselor',NULL),(1270,195,'d. A client falling in love with the counselor',NULL),(1271,195,'e. All of the above',NULL),(1272,194,'a. Should never be done',NULL),(1273,194,'b. Should be done with every client',NULL),(1274,194,'c. Should be done when counselor has strong belief client will benefit',1),(1275,194,'d. Should be done when the client asks a personal questions',NULL),(1276,194,'e. All of the above',NULL),(1869,1141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(1870,1141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(1871,1141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(1872,1141,'Unwelcome, physical in nature and occur in the workplace',NULL),(1873,1143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(1874,1143,'Behavior that makes the workplace uncomfortable ',NULL),(1875,1143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(1876,1143,'Sexually explicit offensive comments',NULL),(1877,1144,'Express yourself verbally',NULL),(1878,1144,'Tell the harasser the behavior is making you uncomfortable',NULL),(1879,1144,'Express yourself non verbally',NULL),(1880,1144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(1881,1144,'All of the above',1),(1882,1145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(1883,1145,'Files a discrimination charge',NULL),(1884,1145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(1885,1145,'All of the above',1),(1886,1146,'True',1),(1887,1146,'False',NULL),(1888,1147,'True',1),(1889,1147,'False',NULL),(1890,1148,'True',1),(1891,1148,'False',NULL),(1892,1149,'True',1),(1893,1149,'False',NULL),(1894,1150,'True',1),(1895,1150,'False',NULL),(1896,1151,'True',NULL),(1897,1151,'False',1),(1898,1152,'True',NULL),(1899,1152,'False',1),(1900,1154,'Yes',1),(1901,1154,'No',NULL),(1902,1155,'Yes',NULL),(1903,1155,'No',1),(1904,1156,'Yes',1),(1905,1156,'No',NULL),(11844,592,'Organizations',NULL),(11845,592,'Supervisors',NULL),(11846,592,'Risk Managers',NULL),(11847,592,'All Staff',1),(11857,703,'Collaborate for accuracy of events witnessed',NULL),(11858,703,'Both sign the Incident Report Form',NULL),(11859,703,'Each file a separate Incident Report Form',1),(11860,703,'Jointly prepare one Incident Report Form',NULL),(11861,704,'True',NULL),(11862,704,'False',1),(11863,705,'Complete one Incident Report listing all clients involved in the incident',NULL),(11864,705,'Complete a separate Incident Report for each client involved',1),(11865,705,'Have client’s Primary Therapist complete an incident report',NULL),(11866,705,'None of the above',NULL),(11867,706,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11868,706,'A copy of the IRF is always included in the client’s medical records on file. ',1),(11869,706,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11870,706,'Incident Report Forms are confidential reports ',NULL),(11871,707,'Enter concise subjective statements of fact',NULL),(11872,707,'Express their own opinion of the occurrence',NULL),(11873,707,'Enter concise objective statements of fact',1),(11874,707,'a and b',NULL),(11890,712,'1994',NULL),(11891,712,'1998',NULL),(11892,712,'1996',1),(11893,712,'1997',NULL),(11894,713,'True',NULL),(11895,713,'False',1),(11896,137,'FS 387.219 (1)',NULL),(11897,137,'FS 456.222 (4)',NULL),(11898,137,'FS 397.419 (2)',1),(11899,137,'FS 298.419 (1)',NULL),(11900,138,'Organizations',NULL),(11901,138,'FS 456.222 (4)',NULL),(11902,138,'Supervisors',NULL),(11903,138,'Risk Managers',NULL),(11904,138,'All Staff',1),(11905,139,'Verification of corrective action',NULL),(11906,139,'Results of Root Cause Analyses',NULL),(11907,139,'Provision for reporting to the Department',NULL),(11908,139,'a and b',NULL),(11909,139,'a and c',1),(11910,140,'True',NULL),(11911,140,'False',1),(11916,141,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11917,141,'Incident Report Forms are always included in the client’s medical records on file. ',1),(11918,141,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11919,141,'Incident Report Forms are confidential reports ',NULL),(11920,142,'Promptly report a critical incidence within 6 hours',NULL),(11921,142,'Promptly report a critical incident within 24 hours',NULL),(11922,142,'Promptly report a critical incident within one business day',1),(11923,142,'None of the above',NULL),(11924,143,'The Critical Incident Reporting System (CIRS)',NULL),(11925,143,'The Critical Incident Analyses System (CIAS)',NULL),(11926,143,'The Incident Analysis and Reporting System (IRAS)',NULL),(11927,143,'The Incident Reporting and Analysis System (IRAS). ',1),(11928,144,'True',NULL),(11929,144,'False',1),(11930,145,'Promptly report a critical incidence within 6 hours',NULL),(11931,145,'Promptly report a critical incident within 24 hours',NULL),(11932,145,'Promptly report a critical incident within one business day',1),(11933,145,'None of the above',NULL),(11934,1131,'To report it to your supervisor',NULL),(11935,1131,'To report it only if you believe it is an emergency',NULL),(11936,1131,'To report it to the Florida Abuse Hotline of Children and Families',1),(11937,1131,'You are only required to report it to the person’s insurance company',NULL),(11938,1132,'Abandonment',NULL),(11939,1132,'Abuse',NULL),(11940,1132,'Exploitation',NULL),(11941,1132,'Neglect',1),(11942,1133,'Law enforcement officer',NULL),(11943,1133,'Nurse in an assisted living facility',NULL),(11944,1133,'School teacher',NULL),(11945,1133,'All of the above',1),(11946,1134,'They are ashamed ',NULL),(11947,1134,'They feel no one will believe them',NULL),(11948,1134,'They are afraid someone may retaliate if they report them',NULL),(11949,1134,'All of the above',1),(11950,1135,'True',1),(11951,1135,'False',NULL),(11952,1136,'True',NULL),(11953,1136,'False',1),(11954,1137,'Unauthorized taking of personal assets',NULL),(11955,1137,'Sale of the vulnerable adults home without their authorization',NULL),(11956,1137,'Caregiver failing to provide appropriate food to vulnerable adult',NULL),(11957,1137,'A and B',1),(11958,1137,'B and C',NULL),(11959,1138,'Exploitation',NULL),(11960,1138,'Abuse',1),(11961,1138,'Neglect',NULL),(11962,1138,'All of the above',NULL),(11963,1139,'Section 415.1034',NULL),(11964,1139,'Chapter 40, F.S.',NULL),(11965,1139,'Chapter 39, F.S.',1),(11966,1139,'Section 48 F.S.',NULL),(11967,1140,'800-222-2873',NULL),(11968,1140,'800-962-2873',1),(11969,1140,'800-914-0004',NULL),(11970,1140,'800-453-5145',NULL),(12060,1157,'True',NULL),(12061,1157,'False',1),(12062,1158,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(12063,1158,'An unaviodable part of doing business in the addiction treatment industry',NULL),(12064,1158,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(12065,1158,'All of the above',NULL),(12066,1159,'To punish addiction treatment centers that misuse personal information',NULL),(12067,1159,'To define the the proper use of an individual\'s health records',1),(12068,1159,'To secure a person\'s private financial information',NULL),(12069,1159,'To give authorization for treatment center employees to use private information',NULL),(12070,1160,'Health Information Portability Protection Act',NULL),(12071,1160,'Human Interest Protection  Act',NULL),(12072,1160,'Health Insurance Portability and Accountability Act',1),(12073,1160,'None of the above',NULL),(12074,1161,'True',NULL),(12075,1161,'False',1),(12076,1162,'A fraudulent accounting scheme',NULL),(12077,1162,'The legal definition of self-inflicted bodily harm',NULL),(12078,1162,'The requirement for an arrested person to be brought into court or before a judge',1),(12079,1162,'None of the above',NULL),(12080,1163,'The clinician is the professional',1),(12081,1163,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(12082,1163,'The clients understand proper boundaries and are able to defend themselves against violations',NULL),(12083,1163,'The counselor must report to their supervisor',NULL),(12084,1164,'True',1),(12085,1164,'False',NULL),(12086,1165,'Quid Pro Quo',NULL),(12087,1165,'Dual Relationship',1),(12088,1165,'Professional Business',NULL),(12089,1165,'None of the Above',NULL),(12090,1166,'When parents ask',NULL),(12091,1166,'Client information can never be disclosed without written consent',NULL),(12092,1166,'On a need to know basis within the facility',1),(12093,1166,'None of the Above',NULL),(12094,1167,'Crossed Legs',NULL),(12095,1167,'Slouching',NULL),(12096,1167,'Eye contact',NULL),(12097,1167,'Standing Tall',1),(12098,1168,'True',NULL),(12099,1168,'False',1),(12100,1169,'A long marriage',NULL),(12101,1169,'Stress',1),(12102,1169,'A high degree of social interaction',NULL),(12103,1169,'Regular exercise ',NULL),(12104,1170,'Perception and prejudice',NULL),(12105,1170,'Noise',NULL),(12106,1170,'Language',NULL),(12107,1170,'All of the above',1),(12108,1171,'Common depression',NULL),(12109,1171,'Bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(12110,1171,'Significant mood changes that last for weeks or months',1),(12111,1171,'Mood changes that last for 48 hours or less',NULL),(12112,1172,'True',NULL),(12113,1172,'False',1),(12114,1173,'Use',NULL),(12115,1173,'Misuse',NULL),(12116,1173,'Addiction',NULL),(12117,1173,'Abuse',1),(12118,1174,'A good idea to use as proof',NULL),(12119,1174,'A bad idea unless needed for an important purpose.',1),(12120,1174,'Not a problem if the copies are lost',NULL),(12121,1174,'Something that should never be done',NULL),(12122,1175,'It helps determine the exposure risk of staff members',1),(12123,1175,'It eliminates the possibility of infection',NULL),(12124,1175,'A and B',NULL),(12125,1175,'None of the above',NULL),(12126,1176,'Common cold',NULL),(12127,1176,'HIV',NULL),(12128,1176,'Pinkeye',NULL),(12129,1176,'A & C',1),(12130,1176,'A & B',NULL),(12131,1177,'A hospital',NULL),(12132,1177,'A detox',NULL),(12133,1177,'An ARF',NULL),(12134,1177,'All of the above',1),(12137,1178,'True',NULL),(12138,1178,'False',1),(12139,1179,'True',NULL),(12140,1179,'False',1),(12141,1180,'True',NULL),(12142,1180,'False',1),(12145,1181,'True',1),(12146,1181,'False',NULL),(12147,1182,'True',NULL),(12148,1182,'False',1),(12149,591,'0941-5-2-.20 ',NULL),(12150,591,'0940-5-2-.15',NULL),(12151,591,'0940-5-2-.20 ',1),(12152,591,'0942-5-2-.20 ',NULL),(12158,593,'Quality of service issues',NULL),(12159,593,'Staff only injuries',NULL),(12160,593,'Staff misconduct when off duty',NULL),(12161,593,'Theft of service recipients belongings by staff',NULL),(12162,593,'a, b and c',1),(12163,593,'All of the above',NULL),(12164,702,'As soon as possible and no later than 48 hours',NULL),(12165,702,'As soon as possible and no later than 72 hours',NULL),(12166,702,'As soon as possible and no later than 24 hours',1),(12167,702,'As soon as possible',NULL),(12168,1183,'Can be spread to others',NULL),(12169,1183,'Cannot be spread to others',1),(12170,1183,'Is deadly',NULL),(12171,1183,'Leads to TB Disease 90% of the time',NULL),(12172,1184,'True',1),(12173,1184,'False',NULL),(12174,1185,'Up to 10 million Americans have latent TB and 1 in 13 will get TB Disease',NULL),(12175,1185,'Up to 13 million Americans have latent TB and 1 in 50 will get TB Disease',NULL),(12176,1185,'Up to 10 million Americans have latent TB and 1 in 5 will get TB Disease',NULL),(12177,1185,'Up to 13 million Americans have latent TB and 1 in 10 will get TB Disease',1),(12178,1186,'You are immediately contagious',NULL),(12179,1186,'You are not immediately contagious',NULL),(12180,1186,'You may get TB Disease in weeks or even years',NULL),(12181,1186,'A and C',NULL),(12182,1186,'B and C',1),(12183,1187,'True',NULL),(12184,1187,'False',1),(12185,1188,'Are illegale',NULL),(12186,1188,'Should be encouraged due to the number of TB cases in the US every year',NULL),(12187,1188,'Should be discouraged unless the targeted groups contain substantial proportions of persons at high-risk',1),(12188,1188,'None of the above',NULL),(12189,1189,'Foreign-born persons from high-prevalence countries ',NULL),(12190,1189,'Close contacts of active TB cases or suspects',NULL),(12191,1189,'Injection drug users',NULL),(12192,1189,'Residents and staff or volunteer workers in high-risk congregate settings ',NULL),(12193,1189,'All of the above',1),(12194,1190,'Is no longer recommended',1),(12195,1190,'Is mandatory',NULL),(12196,1190,'Is recommended',NULL),(12197,1191,'All new employees and volunteers must be screened with the “TB Symptom Screening Tool” prior to beginning employment or providing volunteer services',NULL),(12198,1191,'All new employees and volunteers who provide direct care services appropriately tested for TBI within three (3) business days of beginning employment or providing volunteer services',NULL),(12199,1191,'All employees or volunteers providing direct care services must be screened annually for symptoms of active TB disease and appropriately tested with follow-up',NULL),(12200,1191,'Documentation of all TB symptom screening and TB skin testing for TBI must be treated as personal medical information and archived according to HIPAA guidelines',NULL),(12201,1191,'All of the above',1),(12202,1192,'All recipients of residential A&D treatment services must be screened with the “TB Symptom Screening Tool” prior to enrollment in an A&D treatment program',NULL),(12203,1192,'Recipients must be appropriately tested for TBI with a TST or IGRA within five (5) business days of receiving A&D treatment services',NULL),(12204,1192,'Documentation of all TB symptom screening and TB testing for TBI of service recipients must be treated as personal medical information and archived according to HIPAA guidelines',NULL),(12205,1192,'c.	All new service recipients of residential A&D treatment services must receive education and signs and symptoms of active TB disease with three (3) business days of beginning A&D services, regardless of receipt of such services within the past year.',NULL),(12206,1192,'All of the above',1),(12207,37,'Black/African Americans',1),(12208,37,'Seniors',NULL),(12209,37,'Hispanics',NULL),(12210,37,'Native Americans',NULL),(12215,34,'True',1),(12216,34,'False',NULL),(12217,42,'Be tested for HIV as early as possible unless they opt out in writing',NULL),(12218,42,'Be tested for HPV at the first prenatal visit.',NULL),(12219,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(12220,42,'Request to be tested for HIV',NULL),(12221,42,'Are tested again in the third trimester',NULL),(12222,42,'A and E',1),(12223,36,'a)	1 in 2',NULL),(12224,36,'b)	1 in 7',1),(12225,36,'c)	1 in 3',NULL),(12226,36,'d)	1 in 4',NULL),(12227,1193,'Making derogatory or sexually explicit comments',NULL),(12228,1193,'Displaying sexually suggestive posters',NULL),(12229,1193,'Making unwanted physical contact',NULL),(12230,1193,'All of the above',1),(12231,203,'Suicide is highest in college students',NULL),(12232,203,'Suicide is highest in white males over 85',NULL),(12233,203,'Suicide is highest for people aged 10-24',NULL),(12234,203,'Suicide is highest for people aged 25-34',NULL),(12235,203,'Suicide is highest for males over the age of 75',1),(12236,1194,'The PH-1500',NULL),(12237,1194,'The PH-1600',1),(12238,1194,'The PH-1060',NULL),(12239,1194,'The PH-1560',NULL),(12240,1195,'True',1),(12241,1195,'False',NULL),(12242,1195,'The PH-1060',NULL),(12243,1195,'The PH-1560',NULL),(12244,1196,'HIV',NULL),(12245,1196,'Rabies',NULL),(12246,1196,'Smallpox',NULL),(12247,1196,'Botulism',NULL),(12248,1196,'All of the above',NULL),(12249,1196,'B, C and D only',1),(12250,1197,'HIV',NULL),(12251,1197,'Tuberculosis',1),(12252,1197,'Smallpox',NULL),(12253,1197,'Hep B',NULL),(12254,1197,'All of the above',NULL),(12255,1198,'Medical Professionals',NULL),(12256,1198,'Nurses',NULL),(12257,1198,'Addiction Counselors',NULL),(12258,1198,'Psychiatrists',NULL),(12259,1198,'All of the above',1),(12260,1199,'True',1),(12261,1199,'False',NULL),(12262,1200,'Declined from 1995 to 2018',1),(12263,1200,'Increased from 1998-2018',NULL),(12264,1200,'Stayed about the same in the past decade',NULL),(12265,1201,'Children ',NULL),(12266,1201,'Vulnerable Adults',NULL),(12267,1201,'Both Children and Vulnerable Adults',1),(12268,1202,'Adult children of the elderly person',NULL),(12269,1202,'Spouse of the elderly person',NULL),(12270,1202,'Partners of the elderly person',NULL),(12271,1202,'All of the above',1),(12272,1203,'Physical pain',NULL),(12273,1203,'Mental anguish',NULL),(12274,1203,'Deprivation of service',NULL),(12275,1203,'A&C Only',NULL),(12276,1203,'All of the above',1),(12277,1204,'True',1),(12278,1204,'False',NULL),(12279,1205,'An oral or written report shall be made within 1 week to the department upon knowledge of the occurrence of suspected abuse, neglect, or exploitation of an adult. ',NULL),(12280,1205,'An oral or written report shall be made within 48 hours to the department upon knowledge of the occurrence of suspected abuse, neglect, or exploitation of an adult. ',NULL),(12281,1205,'An oral or written report shall be made immediately to the department upon knowledge of the occurrence of suspected abuse, neglect, or exploitation of an adult. ',1),(12282,1205,'Oral reports are not sufficient to fulfill reporting requirements',NULL),(12283,1205,'Written reports are not sufficient to fulfill reporting requirements',NULL),(12284,1206,'Fear of retaliation',NULL),(12285,1206,'Fear of loss',NULL),(12286,1206,'Not caring',NULL),(12287,1206,'Not recognizing abuse',NULL),(12288,1206,'A, B & D',1),(12289,1206,'None of the above',NULL),(12290,1207,'Call APS intake hotline then dial 911',NULL),(12291,1207,'Dial 911 then report online',NULL),(12292,1207,'Dial 911 then the APS intake hotline',1),(12293,1207,'Report online',NULL),(12294,1207,'Ignore',NULL),(12295,1208,'A Class A misdemeanor',1),(12296,1208,'A Class A felony',NULL),(12297,1208,'A Class B misdemeanor',NULL),(12298,1208,'Not punishable criminally',NULL),(12299,1209,'True',1),(12300,1209,'False',NULL),(12301,1210,'Over 10 million',NULL),(12302,1210,'Over 1 million',1),(12303,1210,'Over 5 million',NULL),(12304,1210,'Over 7 million',NULL),(12305,1211,'Only law enforcement to make a report when they suspect sexual or physical abuse or neglect of a minor',NULL),(12306,1211,'Only physicians to make a report when they suspect sexual or physical abuse or neglect of a minor',NULL),(12307,1211,'Every person to make a report when they suspect sexual or physical abuse or neglect of a minor',1),(12308,1212,'Failure to protect a child from harm',NULL),(12309,1212,'Creating an environment for risk of harm to a child',NULL),(12310,1212,'Corporal punishment',1),(12311,1212,'Extreme conveyance of worthlessness by a caregiver',NULL),(12312,1213,'Requires public schools to implement a prevention-oriented program regarding child sexual abuse',1),(12313,1213,'Applies only to elementary school kids',NULL),(12314,1213,'Does not include school personnel',NULL),(12315,1213,'Is not applicable to TN',NULL),(12320,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(12321,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(12322,63,'Anxiety level, defensive level, acting out, tension reduction',1),(12323,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(12324,64,'True',1),(12325,64,'False',NULL),(12326,65,'Acting out',NULL),(12327,65,'Tension Reduction',NULL),(12328,65,'Anxiety Level',NULL),(12329,65,'Defensive Level',1),(12330,82,'Clenched fists',NULL),(12331,82,'Pacing',NULL),(12332,82,'Rapid breathing',NULL),(12333,82,'Withdrawn behavior',NULL),(12334,82,'All of the Above',1),(12335,83,'The person is under the influence of a substance',NULL),(12336,83,'The person has a history of psychiatric illness',NULL),(12337,83,'The person is facing a high level of stress',NULL),(12338,83,'All of the Above',1),(12339,83,'A and B',NULL),(12340,85,'True',1),(12341,85,'False',NULL),(12342,53,'True',NULL),(12343,53,'False',1),(12344,54,'True',1),(12345,54,'False',NULL),(12346,55,'True',NULL),(12347,55,'False',1),(12348,57,'Telling the patient what he/she is feeling.',NULL),(12349,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(12350,57,'Make client aware of the incongruities from their statement',NULL),(12351,57,'None of the above',NULL),(12352,58,'Using a calm voice and acronyms or jargon',NULL),(12353,58,'Giving the person your full attention',NULL),(12354,58,'Paraphrasing what the person is saying',NULL),(12355,58,'Validating the person’s feelings about the situation',NULL),(12356,58,'All of the above',NULL),(12357,58,'B, C, and D',1),(12358,59,'Speak slowly clearly and gently',NULL),(12359,59,'Walk fast away from client to avoid an altercation',NULL),(12360,59,'Appear confident and display calmness',NULL),(12361,59,'Show you are listening',NULL),(12362,59,'A, C, and D',1),(12363,59,'A and B',NULL),(12366,60,'True',1),(12367,60,'False',NULL);

--
