--
-- Host: localhost    Database: grn_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=32 DEFAULT CHARSET=latin1;

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

INSERT INTO `course` VALUES (27,'CRSS - Class #1 - Legal and Professional Responsibility','<p><strong>Legal and Professional Responsibility Track, 22 hours</strong></p>','<p><strong>Legal and Professional Responsibility Track, 22 hours</strong>: The legal and professional responsibility portion of the Certified Recovery Support Specialist certification will provide and in-depth review of ethical and moral obligations faced in the treatment setting. Further, understanding of confidentiality and related legislation, professional development, as well as cultural competence will be covered. This 22 hour course will be guided by Florida Certification Board (FCB) certification standards.</p>',80,'','',NULL,'CRSS+Class+1.pdf',NULL,NULL,'CRSS-1.ppsx',NULL,'CRSS-1-syllabus-Final.pdf',NULL,22,'','',NULL,'','0',1,'Please write at least 1000 words on one of the following topics. If your essay does not meet the word requirement it will not be considered for grading: (Pick one)\r\n\r\n1. Explain safeguards that have been put in place to protect client confidentiality. Please include information on Health Insurance Portability and Accountability Act (HIPAA), protected health information (PHI), and the Health Information Technology for Economic and Clinical Health Act (HITECH).\r\n\r\n-or-\r\n\r\n2. Please give information on the boundaries an addiction professional must follow. Why are they important? If possible, draw on personal experience.'),(28,'CRSS - Class #2 - Reengagement, Crisis Support and Safety','<p><strong>Reengagement, Crisis Support and Safety, 13 hours</strong></p>','<p>Reengagement, crisis support and safety portion of the Certified Recovery Support Specialist certification will provide an in-depth understanding of the principles of crisis management including identification of and response to crisis situations. Signs and symptoms of domestic violence along with tactics to identify and assist victims will be covered. The elective class will cover infectious diseases in the treatment setting including prevention, identification and control. This 13 hour course will be guided by Florida Certification Board (FCB) certification standards.</p>',80,'','',NULL,'CRSS-Class-2.pdf',NULL,NULL,'CRSS-2.ppsx',NULL,'CRSS-2-Syllabus-Final.pdf',NULL,13,'','',NULL,'','0',1,'Please write at least 1000 words on one of the following topics. If your essay does not meet the word requirement it will not be considered for grading: (Pick one)\r\n\r\n1. John Lundholm states that there are five strategies to follow for effective verbal de-escalation. Please write 100 words each on the following five strategies:\r\n-Self-management\r\n-Situational Awareness\r\n-Non-verbal communication\r\n-Listening (active and empathetic)\r\n-Assertive verbal communication\r\n\r\n-OR-\r\n\r\n2. Jeff is a 23 year old alcoholic and a client at the facility you work for, the community has informed staff that Jeff has been severely depressed and has been discussing self-harm. What could you do as an addiction professional to help Jeff? What if he became suicidal, what policies and procedures should you follow?'),(29,'CRSS - Class #3 - Resource Linkage/Follow-Up','<p><strong>Resource Linkage/Follow-Up, 13 hours</strong></p>','<p>The resource linkage / follow-up portion of the Certified Recovery Support Specialist certification will provide guidance on the basic principles of a referral, the agencies and organizations to which a client can be referred and the evaluation and measurement of client progress at the referral facility. Proper methods for clinical documentation and secure storage of client records will also be covered in-depth. The elective class will offer an overview of drug abuse prevention techniques through education and information dissemination. This 13 hour course will be guided by Florida Certification Board (FCB) certification standards.</p>',80,'','',NULL,'CRSS-Class-3.pdf',NULL,NULL,'CRSS-3.ppsx',NULL,'CRSS-3-Syllabus-Final.pdf',NULL,13,'','',NULL,'','0',1,'Please write at least 1000 words on one of the following topics. If your essay does not meet the word requirement it will not be considered for grading: (Pick one)\r\n\r\n1. There are seven key purposes for clinical documentation, please expand on 4 of the seven purposes:\r\n - Document professional work\r\n - Organization and continuity of care of the client by the practitioner\r\n - Subsequent continuity of care of the client by recording for use by other practitioners who may serve the client in the future\r\n - Risk management\r\n - Comply with legal, regulatory and institutional requirements\r\n - Facilitate quality assurance and utilization review\r\n - Facilitate coordination of professional efforts by fostering communication and collaboration between members of the treatment team\r\n\r\n-or-\r\n\r\n2. Please give examples of what types of services within a community that an addiction professional may refer a client to. How would this service be presented to client?'),(30,'CRSS - Class #4 - Practical Living / Social Development','<p><strong>Practical Living Skills / Social Development, 10 hours</strong></p>','<p>Practical Living Skills / Social Development portion of the Certified Recovery Support Specialist certification will provide an in-depth look at normal social development post-treatment and the life skills to be learned in treatment to help ensure recovery progresses constructively. The elective class will delve into understanding HIV/AIDS, prevention, testing and infection control. This 10 hour course will be guided by Florida Certification Board (FCB) certification standards.</p>',80,'','',NULL,'CRSS-Class-4.pdf',NULL,NULL,'CRSS-4.pps',NULL,'CRSS-4-Syllabus-Final.pdf',NULL,10,'','',NULL,'','0',1,'Please write at least 1000 words on one of the following topics. If your essay does not meet the word requirement it will not be considered for grading: (Pick one)\r\n\r\n1. Please describe the six different family roles and the underlying feelings associated with each role: The Addict, the Hero, the Mascot, the Lost Child, the Scapegoat, and the Caretaker.\r\n\r\n-or-\r\n\r\n2. How are psycho-educational groups for the individual and for families useful? What role do life skills play in treating the client?'),(31,'CRSS - Class #5 - Recovery Management','<p><strong>Recovery Management, 17 hours</strong></p>','<p>The Recovery Management portion of the Certified Recovery Support Specialist certification will offer the student a complete understanding of the history of addiction, its effects on the brain (including a basic overview of pharmacology) and the stages of change including motivational strategies for client success. Co-occurring disorders will be understood in depth. This class will also delve into relapse prevention techniques and outcomes after treatment. This 17 hour course will be guided by Florida Certification Board (FCB) certification standards. Experiential individual and group activities provide opportunities for the practical application of the topics covered in class.</p>',80,'','',NULL,'CRSS-Class-5.pdf',NULL,NULL,'CRSS-5-show.ppsx',NULL,'CRSS-5-Syllabus-Final.pdf',NULL,17,'','',NULL,'','0',1,'Please write at least 1000 words on one of the following topics. If your essay does not meet the word requirement it will not be considered for grading: (Pick one)\r\n \r\nThere are many different definitions of addiction provided in the coursework. Drawing on your own experience, please provide your own definition using supporting information.\r\n\r\n-or-\r\n\r\nAdolescents using and abusing drugs is particularly dangerous. What happens to the brain of an adolescent when using drugs? How would one be able to discern the behaviors associated with Drug use in an adolescent?\r\n\r\n-or-\r\n\r\nRelapse is one of the major characteristics of addiction. What is relapse? What are some of the behaviors that could potentially lead to relapse?');

--
-- 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=30 DEFAULT CHARSET=latin1;

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

INSERT INTO `course_has_category` VALUES (25,27,1,1),(26,28,1,1),(27,29,1,1),(28,30,1,1),(29,31,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=37 DEFAULT CHARSET=utf8;

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

INSERT INTO `evaluation` VALUES (1,28,1540655235,'Joseph Kelley','Power Point presentation','none','none','Yes','Motivational Interviewing\r\n\r\nHarm Reduction',5),(2,26,1543793313,'FREDRICK OKOLIE','This course gave me the skills and tools that will enable me render effective and efficient services to the patients at Gateway community services. ','I enjoyed the information acquired from HIPAA, professional boundaries and infection control','Online experience is awesome','yes','More of clinical',5),(3,29,1545405768,'Janice Gilpin','','','','Yes','',4),(4,29,1545405943,'Janice Gilpin','The part on referrals and collaborating for the client needs','n/a','Using real life examples is helpful is determining the precision of care.','Yes','Learning by real life examples',4),(5,26,1546702469,'JUNE FLOYD','I enjoyed the course and all aspects of taking.  The information was very knowledgeable and I can use in the \r\nfuture of my career','N/A','N/A','I thoroughly enjoyed having the hunger to sponge in information and connect the dots to be able to assist\r\nmy Patients in a better way','N/A',5),(6,26,1556279077,'kimwilson1060@gmail.com','the course is educative','Hippa and ','application of knowledge','yes','cbcm',5),(7,26,1556279085,'kimwilson1060@gmail.com','the course is educative','Hippa and ','application of knowledge','yes','cbcm',5),(8,14,1564169378,'Steven Greene','Learning more about the causes of self harm.','The reading. ','Use of some auditory or visual aspects. ','It kept minimal attention','Unknown at this time.',3),(9,27,1565043594,'Kellyn Roy','I enjoyed learning more in depth the legal and professional responsibilities of my job.','None at this time.','Nothing at this time.','Yes, the course content was very stimulating.','Any that will continue my education!',5),(10,28,1565043781,'Kellyn Roy','I enjoyed learning in depth reengagement, crisis support and safety which are very important components of my job.','None at this time.','Nothing at this time.','Yes, the course content was stimulating.','Any course to continue my education!',5),(11,29,1565044226,'Kellyn Roy','I enjoyed learning resources linkage/follow up to help me better assist in my job.','None at this time.','Nothing at this time.','Yes, the course content was stimulating.','Any courses the continue my education!',5),(12,30,1565044399,'Kellyn Roy','I enjoyed learning more about practical living/social development to help assist me in my job.','None at this time.','Nothing at this time.','Yes, this course was stimulating.\r\n','Any course to continue my education!',5),(13,27,1570714495,'Steven Greene','I enjoyed reinforcing a knowledge base that I already had.','The PowerPoint was a little vague.','Have an audio component ','Not really, very technical','Do not know at this time',4),(14,28,1571443470,'','','','','','',4),(15,27,1575320283,'Toni Davey','I liked the parts about professional boundaries and ethics the most.','It was long, but it had to be in order to cover all the material.','I could not \'pick up where I left off\' during the power point presentation.','I was a good refresher for me, reminding me od things I had learned before.','I woud be interested in learning about the more current drugs people are using now.',4),(16,28,1576308553,'Toni Davey','It was interesting to learn more about self harm, as I come into contact with many clients who suffer from this.','I don\'t really like all the statistical information.  Too much of it becomes meaningless after a while.','I like it the way it is.  It\'s easy to scroll back and forth through the subject matter.','Yes.  I found it very relevant.  Some of the information I had been familiar with, but some was new to  me and very interesting.','I would like to learn more about the current \'slang\' for different drugs, as well as what new drugs people are abusing/misusing.',5),(17,27,1576893085,'Kathrine Minotti','I liked learning about HIPPA because I was always confused by the requirements.','Writing the essay!','The links did not work in the syllabus.  Also, I called the academy\'s number twice to ask about it and it goes to a woman\'s voicemail (that lists a different number on the voicemail than the one you have to dial) and her voicemail was full! Seems hard to get in touch with someone regarding this course. ','','',4),(18,29,1578027165,'Toni Davey','I liked seeing examples of well written progress notes, both for individual and group sessions.','It actually was very important information.  I would have liked more detailed information on community resources.','Simply numbering the pages would be very helpful, as I did not read all the information in one sitting, and was unable to print out the whole course.','Yes, I found it interesting, even though some parts were a bit dry.','I would like to see a course on how to handle potential Baker act situations. What are the things one should ask a client who says something like \"I just want to die sometimes\", or \"I\'m so mad at her I could just slit her throat.\"',5),(19,30,1578865638,'Toni Davey','I enjoyed the discussion about family roles.','actually, this course was more interesting to me than some of the previous ones.  There wasn\'t anything that i found boring or mundane.','It\'s pretty easy to follow.  But I still think the pages should be numbered.  i have mentioned that in previous evaluations.','Yes, i enjoyed it.','More information about some of the street drugs that are being used now, and their street names. It helps to be able to understand the clients better.',5),(20,31,1580688815,'Toni Davey','I liked the various definitions of addiction and the information about how drugs actually affect the neurotransmitter etc..  I also liked the historical information.','I don\'t like all the statistical information.  I feel like too much of it makes it difficult to retain.','More pictures.','Yes.  I really liked this one.','More current information about effects on the brain and nervous system.',5),(21,27,1580696752,'Rachel Levenson','I enjoyed learning more about boundaries and I found this course to be an eye-opener about ethical practices in addiction treatment. Boundaries has always been a work in progress for me in this field. ','I enjoyed this course, except 1,000 words was a little excessive. I felt like I was getting to a point where I was repeating myself.','I can\'t think of anything','Yes','Not sure',4),(22,28,1580697010,'Rachel Levenson','This course was especially helpful in learning about how to handle aggressive clients and be clinically sound. This reassured for me that I am in the right profession as I feel like I possess a lot of the qualities it mentioned it takes to handle a hostile situation.','I enjoyed this course, except 1,000 words was a little excessive. I felt like I was getting to a point where I was repeating myself.','I\'m not sure','Yes','I\'m not sure',5),(23,28,1580697013,'Rachel Levenson','This course was especially helpful in learning about how to handle aggressive clients and be clinically sound. This reassured for me that I am in the right profession as I feel like I possess a lot of the qualities it mentioned it takes to handle a hostile situation.','I enjoyed this course, except 1,000 words was a little excessive. I felt like I was getting to a point where I was repeating myself.','I\'m not sure','Yes','I\'m not sure',5),(24,29,1580697190,'Rachel Levenson','I found it interesting to learn about all the resources out there to connect the clients with in their continuum of treatment. I felt like this course was a good look into case management skills and techniques. I also enjoyed learning about proper clinical documentation. ','I enjoyed this course, except 1,000 words was a little excessive. I felt like I was getting to a point where I was repeating myself.','Not sure ','Yes','Not sure.',5),(25,30,1580697372,'Rachel Levenson','I enjoyed learning about the different dynamics in a family struggling with addiction. It was eye-opening to see the many roles within the family.','I enjoyed this course, except 1,000 words was a little excessive. I felt like I was getting to a point where I was repeating myself.','Not sure.','Yes','Not sure.',5),(26,28,1581207481,'Todd Hoher','Very informative.','I don\'t like proving competence through essay writing.','Aside from the mandatory 1000 word essay\'s to access the exams, I believe this online experience is a great tool. ','Yes.','I believe it would be great to be able to access all Medical and clinical field CEU\'s through this site. ',5),(27,27,1581908888,'Todd Hoher','Very informational. Great Learning experience.','The Essays.','I do not believe that writing a 1000 word essay for each course should be mandatory to show competence. ','Yes.','I would love to see all possible CEU\'s available.',5),(28,31,1581965377,'Rachel Levenson','I enjoyed writing about my own interpretation of addiction and how it is defined.','The 1,000 word essay was a little excessive and I felt like I was beginning to repeat myself.','I wasn\'t too big on reading all the statistics.','Yes','Not sure.',4),(29,27,1583195464,'Justina Sullivan','I en','','','','',5),(30,27,1583760339,'Jason Steinberg','Just about everything.','There were questions and topics in the exam that were not in reading material.','Nothing.','Yes.','n/a',4),(31,27,1583760417,'Jason Steinberg','Everything.','There were questions and topics in the exam that were not in reading material.','Nothing.','Yes','n/a',4),(32,28,1583760460,'Jason Steinberg','Almost everything.','There were questions and topics in the exam that were not in reading material.','Nothing.','Yes','n/a',4),(33,27,1588107110,'Brandon DeoNarine','the exam','the reading ','','yes','',3),(34,28,1588266200,'Brandon DeoNarine','All','All','','Yes','',5),(35,31,1589216698,'Brandon DeoNarine','','','','','',5),(36,27,1594078820,'Craig Mastrony','The information and how it related to my current position.','Exam questions were not covered in the lectures.','Provide all the information in regards to what is on the exam.','Yes','CBHT',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=323 DEFAULT CHARSET=utf8;

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

INSERT INTO `exam_results` VALUES (216,303,27,85),(217,303,28,80),(218,304,27,93),(219,296,27,78),(220,296,27,96),(221,292,27,70),(222,292,27,93),(223,304,28,90),(224,303,29,78),(225,303,29,89),(226,297,27,96),(227,296,28,65),(228,296,28,85),(229,309,27,85),(230,303,30,95),(231,296,29,89),(232,292,28,55),(233,292,28,90),(234,304,29,94),(235,295,30,100),(236,293,27,96),(237,293,28,80),(238,293,28,85),(239,304,30,90),(240,296,30,100),(241,303,31,80),(242,293,29,100),(243,292,29,67),(244,292,29,100),(245,292,30,81),(246,293,30,95),(247,301,27,85),(248,304,31,80),(249,295,28,100),(250,309,28,90),(251,301,28,80),(252,293,31,95),(253,305,27,81),(254,292,31,60),(255,292,31,95),(256,308,27,89),(257,308,28,85),(258,308,29,72),(259,308,29,83),(260,308,30,86),(261,295,31,95),(262,295,29,94),(263,295,27,96),(264,296,31,85),(265,301,29,72),(266,301,29,83),(267,305,28,90),(268,301,30,95),(269,305,29,67),(270,305,29,89),(271,308,31,70),(272,308,31,90),(273,309,29,78),(274,309,29,94),(275,309,30,81),(276,309,31,65),(277,309,31,80),(278,309,31,80),(279,301,31,75),(280,301,31,90),(281,297,28,90),(282,299,27,81),(283,305,30,81),(284,301,28,90),(285,305,31,45),(286,305,31,80),(287,297,29,72),(288,297,29,83),(289,110,29,78),(290,110,29,89),(291,110,29,89),(292,110,29,89),(293,110,29,89),(294,297,30,86),(295,294,27,78),(296,294,27,89),(297,294,28,90),(298,294,29,61),(299,294,29,83),(300,294,30,90),(301,294,31,55),(302,294,31,80),(303,310,27,85),(304,310,28,80),(305,302,27,96),(306,302,28,100),(307,302,29,61),(308,302,29,83),(309,311,27,100),(310,310,29,94),(311,302,30,86),(312,302,31,60),(313,302,31,80),(314,310,30,100),(315,297,31,55),(316,297,31,80),(317,310,31,85),(318,311,28,80),(319,311,29,61),(320,311,29,83),(321,311,30,76),(322,311,30,95);

--
-- 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=12402 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),(11971,1157,'True',NULL),(11972,1157,'False',1),(11973,1158,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(11974,1158,'An unaviodable part of doing business in the addiction treatment industry',NULL),(11975,1158,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(11976,1158,'All of the above',NULL),(11977,1159,'To punish addiction treatment centers that misuse personal information',NULL),(11978,1159,'To define the the proper use of an individual\'s health records',1),(11979,1159,'To secure a person\'s private financial information',NULL),(11980,1159,'To give authorization for treatment center employees to use private information',NULL),(11981,1160,'Health Information Portability Protection Act',NULL),(11982,1160,'Human Interest Protection  Act',NULL),(11983,1160,'Health Insurance Portability and Accountability Act',1),(11984,1160,'None of the above',NULL),(11985,1161,'True',NULL),(11986,1161,'False',1),(11987,1162,'A fraudulent accounting scheme',NULL),(11988,1162,'The legal definition of self-inflicted bodily harm',NULL),(11989,1162,'The requirement for an arrested person to be brought into court or before a judge',1),(11990,1162,'None of the above',NULL),(11995,1164,'True',1),(11996,1164,'False',NULL),(11997,1165,'Quid Pro Quo',NULL),(11998,1165,'Dual Relationship',1),(11999,1165,'Professional Business',NULL),(12000,1165,'None of the Above',NULL),(12005,1166,'When parents ask',NULL),(12006,1166,'Client information can never be disclosed without written consent',NULL),(12007,1166,'On a need to know basis within the facility',1),(12008,1166,'None of the Above',NULL),(12009,1167,'Crossed Legs',NULL),(12010,1167,'Slouching',NULL),(12011,1167,'Eye contact',NULL),(12012,1167,'Standing Tall',1),(12013,1168,'True',NULL),(12014,1168,'False',1),(12015,1169,'A long marriage',NULL),(12016,1169,'Stress',1),(12017,1169,'A high degree of social interaction',NULL),(12018,1169,'Regular exercise ',NULL),(12019,1170,'Perception and prejudice',NULL),(12020,1170,'Noise',NULL),(12021,1170,'Language',NULL),(12022,1170,'All of the above',1),(12023,1171,'Common depression',NULL),(12024,1171,'Bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(12025,1171,'Significant mood changes that last for weeks or months',1),(12026,1171,'Mood changes that last for 48 hours or less',NULL),(12027,1172,'True',NULL),(12028,1172,'False',1),(12029,1173,'Use',NULL),(12030,1173,'Misuse',NULL),(12031,1173,'Addiction',NULL),(12032,1173,'Abuse',1),(12033,1174,'A good idea to use as proof',NULL),(12034,1174,'A bad idea unless needed for an important purpose.',1),(12035,1174,'Not a problem if the copies are lost',NULL),(12036,1174,'Something that should never be done',NULL),(12037,1175,'It helps determine the exposure risk of staff members',1),(12038,1175,'It eliminates the possibility of infection',NULL),(12039,1175,'A and B',NULL),(12040,1175,'None of the above',NULL),(12041,1176,'Common cold',NULL),(12042,1176,'HIV',NULL),(12043,1176,'Pinkeye',NULL),(12044,1176,'A & C',1),(12045,1176,'A & B',NULL),(12046,1177,'A hospital',NULL),(12047,1177,'A detox',NULL),(12048,1177,'An ARF',NULL),(12049,1177,'All of the above',1),(12050,1178,'True',NULL),(12051,1178,'False',1),(12052,1179,'True',NULL),(12053,1179,'False',1),(12054,1180,'True',NULL),(12055,1180,'False',1),(12056,1181,'True',1),(12057,1181,'False',NULL),(12058,1182,'True',NULL),(12059,1182,'False',1),(12060,1163,'The clinician is the professional',1),(12061,1163,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(12062,1163,'The clients understand proper boundaries and are able to defend themselves against violations',NULL),(12063,1163,'The counselor must report to their supervisor',NULL),(12064,1183,'True',1),(12065,1183,'False',NULL),(12066,1184,'Dependence',NULL),(12067,1184,'Addiction',NULL),(12068,1184,'Resistance',NULL),(12069,1184,'Tolerance',1),(12070,1185,'True',NULL),(12071,1185,'False',1),(12072,1186,'True',1),(12073,1186,'False',NULL),(12074,1187,'True',NULL),(12075,1187,'False',1),(12076,1188,'True',NULL),(12077,1188,'False',1),(12078,1189,'True',1),(12079,1189,'False',NULL),(12080,1190,'True',NULL),(12081,1190,'False',1),(12082,1191,'True',NULL),(12083,1191,'False',1),(12084,1192,'True',NULL),(12085,1192,'False',1),(12086,1193,'True',1),(12087,1193,'False',NULL),(12088,1194,'True',1),(12089,1194,'False',NULL),(12090,1195,'True',NULL),(12091,1195,'False',1),(12092,1196,'True',1),(12093,1196,'False',NULL),(12094,1197,'When a client admits to their disease',NULL),(12095,1197,'Waived when a client enters rehab',NULL),(12096,1197,'When a client informs the counselor of their problem',NULL),(12097,1197,'When a client understands and can help decide on their treatment',1),(12098,1198,'You have the client’s written consent',NULL),(12099,1198,'You have a court order',NULL),(12100,1198,'The Client is a threat to themselves or others',NULL),(12101,1198,'Their spouse asks for it',NULL),(12102,1198,'A, B and C',1),(12103,1198,'A, B and D',NULL),(12104,1199,'It is therapeutic to the counselor',NULL),(12105,1199,'It can help the client in their treatment',1),(12106,1199,'There is not much to talk about in treatment',NULL),(12107,1199,'At all times',NULL),(12108,1200,'A potentially helpful sub-set of clinical professionals',NULL),(12109,1200,'An un-objective sub-set of clinical professionals',NULL),(12110,1200,'A potentially empathetic course of treatment',NULL),(12111,1200,'A moral breach of duty',NULL),(12112,1200,'Both A and C',1),(12113,1201,'Risk of relapse due to client problems and issues',1),(12114,1201,'They often deviate from the prescribed treatment plan',NULL),(12115,1201,'They over-share, causing ethical dilemma',NULL),(12116,1201,'They do not need additional supervision',NULL),(12117,1202,'Experiential treatment protocols',NULL),(12118,1202,'Additional counseling sessions',NULL),(12119,1202,'Giving or receiving gifts',1),(12120,1202,'Separate and distinct social lives',NULL),(12121,1203,'When you bump into your client on the street',NULL),(12122,1203,'When you client serves you at a retail store',NULL),(12123,1203,'When your client returns for additional treatment',NULL),(12124,1203,'Being friends outside of treatment',1),(12125,1204,'Contracts',NULL),(12126,1204,'Government law',1),(12127,1204,'Case law precedents',NULL),(12128,1204,'Common sense',NULL),(12129,1205,'Habeas Corpus',NULL),(12130,1205,'Client’s right to wean off drugs rather than go cold-turkey in treatment',1),(12131,1205,'Confidentiality',NULL),(12132,1205,'Quality service',NULL),(12133,1206,'By asking other counselors of that culture',NULL),(12134,1206,'By doing research',NULL),(12135,1206,'By asking questions and being open to the answers',NULL),(12136,1206,'All of the above',1),(12137,1207,'American Development Act',NULL),(12138,1207,'American Disability Association',NULL),(12139,1207,'Americans with Disabilities Act',1),(12140,1207,'American Dental Association',NULL),(12141,1208,'Have no place in the treatment setting',NULL),(12142,1208,'Hinder the treatment process',NULL),(12143,1208,'Are an ethical breach of fiduciary duty',NULL),(12144,1208,'Require understanding on the part of the counselor to tailor a treatment plan',1),(12145,1209,'Right',NULL),(12146,1209,'Worst nightmare',NULL),(12147,1209,'Professional responsibility',1),(12148,1209,'Primary duty',NULL),(12149,1210,'True',1),(12150,1210,'False',NULL),(12151,1211,'True',NULL),(12152,1211,'False',1),(12153,1212,'True',1),(12154,1212,'False',NULL),(12155,1213,'True',NULL),(12156,1213,'False',1),(12157,1214,'True',1),(12158,1214,'False',NULL),(12159,1215,'True',NULL),(12160,1215,'False',1),(12161,1216,'True',NULL),(12162,1216,'False',1),(12163,1217,'True',1),(12164,1217,'False',NULL),(12165,1218,'True',NULL),(12166,1218,'False',1),(12167,1219,'True',NULL),(12168,1219,'False',1),(12169,1220,'Recognize the crisis',NULL),(12170,1220,'Implement an immediate action plan',NULL),(12171,1220,'Enhance treatment using crisis events',NULL),(12172,1220,'All of the above',1),(12173,1221,'Verbal and physical confrontation',1),(12174,1221,'Ask questions about violence at admission',NULL),(12175,1221,'Deescalate aggressive actions',NULL),(12176,1221,'Non-physical strategies',NULL),(12177,1222,'32 million Americans each year',NULL),(12178,1222,'All age groups',NULL),(12179,1222,'Both men and women',NULL),(12180,1222,'All cultures',NULL),(12181,1222,'All of the above',1),(12182,1223,'Increased 10%',NULL),(12183,1223,'Increased 50%',NULL),(12184,1223,'Decreased 50%',1),(12185,1223,'Decreased 10%',NULL),(12191,1225,'Sobriety',1),(12192,1225,'Drug use',NULL),(12193,1225,'High risk sexual behavior',NULL),(12194,1225,'Low education levels',NULL),(12195,1225,'Unemployment',NULL),(12196,1226,'Chronic pain',NULL),(12197,1226,'Unexplained injuries',NULL),(12198,1226,'Social isolation',NULL),(12199,1226,'Depression',NULL),(12200,1226,'All the above',1),(12201,1227,'Contact',NULL),(12202,1227,'Droplet',NULL),(12203,1227,'Thought',1),(12204,1227,'Airborne',NULL),(12205,1227,'None of these',NULL),(12206,1228,'30%',NULL),(12207,1228,'60%',1),(12208,1228,'90%',NULL),(12209,1228,'85%',NULL),(12210,1228,'None of these',NULL),(12211,1229,'Single sexual partner',NULL),(12212,1229,'Blood transfusion before 2008',NULL),(12213,1229,'IV drug use',1),(12214,1229,'A and C',NULL),(12215,1229,'A and B',NULL),(12216,1230,'True',1),(12217,1230,'False',NULL),(12218,1231,'True',NULL),(12219,1231,'False',1),(12220,1232,'True',1),(12221,1232,'False',NULL),(12222,1233,'True',1),(12223,1233,'False',NULL),(12224,1234,'True',NULL),(12225,1234,'False',1),(12226,1235,'True',1),(12227,1235,'False',NULL),(12228,1236,'True',NULL),(12229,1236,'False',1),(12230,1237,'True',1),(12231,1237,'False',NULL),(12232,1238,'True',NULL),(12233,1238,'False',1),(12234,1239,'True',1),(12235,1239,'False',NULL),(12236,1240,'Identifying risks',NULL),(12237,1240,'Identifying protective factors',NULL),(12238,1240,'Intervening early in transitional stages',NULL),(12239,1240,'Effectively managing prevention programs',NULL),(12240,1240,'All the above',1),(12241,1241,'Clients',NULL),(12242,1241,'Treatment centers',NULL),(12243,1241,'Jails and prisons',NULL),(12244,1241,'States and communities',1),(12245,1242,'Is a treatment improvement protocol used by most modern treatment centers',NULL),(12246,1242,'Identifies a list of positive traits that if present from 3-18 years of age should avoid detrimental behavior',1),(12247,1242,'Was proven ineffective in a 1990 controlled study on effectiveness of addiction treatment',NULL),(12248,1242,'Works for both adults and adolescents',NULL),(12249,1243,'Helping someone avoid bad behavior',1),(12250,1243,'Discouraging overly positive behaviors',NULL),(12251,1243,'Encouraging destructive behavior to make a point',NULL),(12252,1243,'Redirecting bad behavior towards those we don’t like, or deserve it',NULL),(12253,1244,'Over-embellishment to ensure a complete understanding',NULL),(12254,1244,'Use of negative language where appropriate to show your true feelings',NULL),(12255,1244,'Subjective comments to add context',NULL),(12256,1244,'Simplicity and conciseness of descriptions and terminology',1),(12257,1245,'Remain at the counselors residence during off hours',NULL),(12258,1245,'Should be kept for 1 year then can be discarded',NULL),(12259,1245,'Must be out of site of unauthorized personnel',1),(12260,1245,'Are an unnecessary waste of time and paper',NULL),(12261,1246,'The state government',NULL),(12262,1246,'Title 42 CFR',1),(12263,1246,'Title 50 CFR HIPAA',NULL),(12264,1246,'The IRS',NULL),(12265,1247,'A trail of actions',NULL),(12266,1247,'A trail of inaction',NULL),(12267,1247,'A primary means communication between counselors and facility',NULL),(12268,1247,'Describing a counselor’s self-disclosure policy',1),(12269,1248,'True',1),(12270,1248,'False',NULL),(12271,1249,'True',NULL),(12272,1249,'False',1),(12273,1250,'True',1),(12274,1250,'False',NULL),(12275,1251,'True',1),(12276,1251,'False',NULL),(12277,1252,'True',NULL),(12278,1252,'False',1),(12279,1253,'True',1),(12280,1253,'False',NULL),(12281,1254,'True',1),(12282,1254,'False',NULL),(12283,1255,'True',NULL),(12284,1255,'False',1),(12285,1256,'True',NULL),(12286,1256,'False',1),(12287,1257,'Only applicable to co-occurring disorders',NULL),(12288,1257,'A one-time event',NULL),(12289,1257,'An ongoing process facilitated by clinicians',1),(12290,1257,'A solo activity but necessary for recovery',NULL),(12291,1258,'Repairing relationships with loved ones, one at a time',1),(12292,1258,'Having only one drink next week',NULL),(12293,1258,'Losing all excess weight in 2 months',NULL),(12294,1258,'Getting a great, high paying job in another city',NULL),(12295,1259,'Discuss medication changes with their doctors',NULL),(12296,1259,'Ask questions of their medical team',NULL),(12297,1259,'Stop abruptly',1),(12298,1259,'Discuss effects – positive and negative – with their medical team',NULL),(12299,1260,'Avoiding addiction treatment work altogether',NULL),(12300,1260,'Avoiding job fairs as they offer lower paying jobs',NULL),(12301,1260,'Looking for a job for which they have no skills, but will learn over time',NULL),(12302,1260,'Looking for a job in addiction treatment',1),(12303,1261,'Better relationships and improved thinking patterns',1),(12304,1261,'More stress',NULL),(12305,1261,'Relapse',NULL),(12306,1261,'Looking for a job in addiction treatment',NULL),(12307,1261,'Medical problems including heart disease',NULL),(12308,1262,'Treatment programs based in the Southeastern US',NULL),(12309,1262,'Largely avoided by competent clinicians',NULL),(12310,1262,'Often effective for a wide range of recovering addicts, especially alcoholics',1),(12311,1262,'Programs that should be started before treatment',NULL),(12312,1263,'Achieve sobriety',NULL),(12313,1263,'Giving those in recovery the ability to manage an occasional drink without relapse',1),(12314,1263,'Increase quality of life',NULL),(12315,1263,'Promote new and better behaviors',NULL),(12316,1264,'Free HIV testing of all patients over age 13.',NULL),(12317,1264,'Developing a vaccine to prevent HIV infection.',NULL),(12318,1264,'Compulsory HIV testing of all patients in emergency departments.',NULL),(12319,1264,'Reducing the rate of new infections.',1),(12320,1265,'Women and children, seniors, and transgender persons',NULL),(12321,1265,'Men who have sex with men, women who have sex with women, prisoners',NULL),(12322,1265,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(12323,1265,'Women who have sex with women, homeless people, and seniors',NULL),(12324,1266,'Casual contact with an infected client',NULL),(12325,1266,'Used needles and syringes',1),(12326,1266,'Blood collected for transfusion',NULL),(12327,1266,'A public toilet seat',NULL),(12328,1267,'Correct use of latex condoms',NULL),(12329,1267,'Abstaining from sexual contact',NULL),(12330,1267,'The use of barriers such as dental dams during oral sex',1),(12331,1267,'Knowing one\'s own and one\'s partner\'s HIV status',NULL),(12332,1268,'Phone the National Clinicians\' Post-Exposure Prophylaxis Hotline (PEPline).',NULL),(12333,1268,'Take a disability leave until infection has been ruled out.',NULL),(12334,1268,'Remove and properly dispose of exposed clothing.',NULL),(12335,1268,'Wash the affected area with soap and water and report the incident.',1),(12336,1269,'True',NULL),(12337,1269,'False',1),(12338,1270,'True',NULL),(12339,1270,'False',1),(12340,1271,'True',NULL),(12341,1271,'False',1),(12342,1272,'True',NULL),(12343,1272,'False',1),(12344,1273,'True',NULL),(12345,1273,'False',1),(12346,1274,'True',1),(12347,1274,'False',NULL),(12348,1275,'True',1),(12349,1275,'False',NULL),(12350,1276,'True',1),(12351,1276,'False',NULL),(12352,1277,'True',1),(12353,1277,'False',NULL),(12354,1278,'True',1),(12355,1278,'False',NULL),(12356,1279,'Drug Availability',NULL),(12357,1279,'Early aggressive behavior',1),(12358,1279,'Poverty',NULL),(12359,1279,'None of these',NULL),(12360,1280,'Has been replaced by other more structured therapies',NULL),(12361,1280,'Was developed by the US Department of HHS',NULL),(12362,1280,'Has a 32% failure rate',NULL),(12363,1280,'Is a recovery and relapse prevention system',1),(12364,1281,'Recovery being easy, but complicated by the human mind',NULL),(12365,1281,'Recovery being a long-term process',1),(12366,1281,'Partial abstinence leading to complete abstinence',NULL),(12367,1281,'Chaos leading to sobriety',NULL),(12368,1282,'one to three years',NULL),(12369,1282,'ten to twenty years',NULL),(12370,1282,'eight to twelve years',NULL),(12371,1282,'three to fifteen years',1),(12372,1283,'Degrade the neurotransmitters',NULL),(12373,1283,'Are any medication that affects the mind, emotions and behavior',1),(12374,1283,'Increase receptor site sensitivity',NULL),(12375,1283,'Do not cross the blood-brain barrier',NULL),(12376,1284,'Parietal',NULL),(12377,1284,'Temporal',NULL),(12378,1284,'Frontal',1),(12379,1284,'Occipital',NULL),(12380,1285,'1950s',NULL),(12381,1285,'1960s',NULL),(12382,1285,'1970s',1),(12383,1285,'2000s',NULL),(12384,1286,'Better understand the client',NULL),(12385,1286,'Signal a state of mind',NULL),(12386,1286,'Help clients clarify thoughts',NULL),(12387,1286,'A and C',1),(12388,1286,'A and B',NULL),(12389,1287,'Elevated',NULL),(12390,1287,'Euphoric',NULL),(12391,1287,'Dysphoric',NULL),(12392,1287,'Happy',1),(12393,1288,'Restricted',NULL),(12394,1288,'Reserved',1),(12395,1288,'Blunted',NULL),(12396,1288,'Flat',NULL),(12397,1224,'Underreported',NULL),(12398,1224,'The most common form of domestic violence',NULL),(12399,1224,'Often an emergency situation',NULL),(12400,1224,'All of the above',1),(12401,1224,'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,
  `course_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1289 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,NULL),(7,'Americans have become complacent about HIV/AIDS because:',1,8,NULL,NULL),(8,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',1,12,NULL,NULL),(9,'The Florida population hardest hit by HIV/AIDS is:',1,18,NULL,NULL),(10,'Which risk groups account for 75 percent of new HIV/AIDS infections?',1,22,NULL,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,NULL),(12,'Florida state law requires HIV testing of inmates:',1,28,NULL,NULL),(13,'Health professionals may fail to recognize the signs of HIV/AIDS infection in seniors because:',1,32,NULL,NULL),(14,'Which body fluids have been proven to transmit HIV infection?',1,36,NULL,NULL),(15,'Which of the following would most likely transmit an HIV infection?',1,40,NULL,NULL),(16,'Coinfection with STDs such as syphilis, gonorrhea, and genital warts:',1,44,NULL,NULL),(17,'The most common and most deadly coinfection for HIV-positive individuals is:',1,48,NULL,NULL),(18,'Treatment of HIV/TB coinfected patients is:',1,52,NULL,NULL),(19,'Respiratory protection equipment for healthcare workers is:',1,56,NULL,NULL),(20,'One of the leading causes of death among HIV-infected people is:',1,60,NULL,NULL),(26,'More than 1 million people in the U.S. are living with HIV. ',3,463,NULL,NULL),(27,'AIDS and HIV are the same',3,465,NULL,NULL),(28,'You can’t always tell by appearance if someone has HIV. ',3,467,NULL,NULL),(29,'Medications can cure HIV/AIDS.',3,469,NULL,NULL),(30,'All 50 states have people living with AIDS.',3,471,NULL,NULL),(31,'HIV is transmitted through casual contact such as sharing utensils. ',3,474,NULL,NULL),(32,'Abstinence is the only 100% effective method of not acquiring HIV/AIDS               ',3,475,NULL,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,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,NULL),(35,'Way to protect yourself from HIV/AIDS include: \r\n',3,485,NULL,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,NULL),(37,'The Florida population hardest hit by HIV/AIDS is:',3,490,NULL,NULL),(38,'Which risk groups account for 75 percent of new HIV/AIDS infections?',3,500,NULL,NULL),(39,'Which body fluids have been proven to transmit HIV infection?',3,508,NULL,NULL),(40,'Which of the following would most likely transmit an HIV infection?',3,511,NULL,NULL),(41,'Under Florida law, parents of a child under 18:',3,515,NULL,NULL),(42,'Florida law mandates that all pregnant women:',3,533,NULL,NULL),(47,'A provider may test without consent in which of the following:',3,521,NULL,NULL),(48,'Symptoms of AIDS Dementia Complex (ADC) include:',3,526,NULL,NULL),(49,'Need to know is outlined in section 64D-.003 F.A.C. and includes but is not limited to:',3,532,NULL,NULL),(53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL,NULL),(57,'To paraphrase means?',4,452,NULL,NULL),(58,'Active listening involves:',4,414,NULL,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL,NULL),(67,'The transmission of infectious agents requires?',5,540,NULL,NULL),(68,'What is true about infection prevention and control?',5,544,NULL,NULL),(69,'Which statement is NOT true about Droplet transmission?',5,546,NULL,NULL),(70,'Which of the following is NOT an example of a Bloodborne Pathogen?',5,551,NULL,NULL),(71,'When does Vector-borne transmission occur?',5,553,NULL,NULL),(72,'To protect yourself from airborne diseases, you should?',5,557,NULL,NULL),(73,' Bloodborne pathogens can be spread through',5,565,NULL,NULL),(74,'What is considered Personal Protective Equipment?',5,569,NULL,NULL),(75,'When cleaning a spill:',5,575,NULL,NULL),(78,'How long should you wash your hands for with soap and water?',5,582,NULL,NULL),(79,'Infectious diseases are caused by',5,588,NULL,NULL),(80,'Infectious diseases are transmitted most quickly through:',5,592,NULL,NULL),(81,'What is the body fluid NOT considered infectious?',5,576,NULL,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL,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,NULL),(88,'The most frequent mode of infection transmission in the healthcare setting is',5,596,NULL,NULL),(89,'Precautions recommended by CDC for the care of all patients is known as:',5,600,NULL,NULL),(90,'A counselor and client can enter into a personal relationship after five years has elapsed.',6,603,NULL,NULL),(91,'What is a “Dual Relationship”?',6,604,NULL,NULL),(92,'Explain the purpose of HIPAA guidelines.',6,610,NULL,NULL),(93,'What does the acronym HIPAA stand for?',6,613,NULL,NULL),(94,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',6,617,NULL,NULL),(95,'What is the Right of Habeas Corpus?',6,619,NULL,NULL),(96,'Give two reason why maintaining proper boundaries is the responsibility of the staff.',6,626,NULL,NULL),(97,'Anger is a choice in a range of available behaviors',6,628,NULL,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,NULL),(99,'Give two instances when client confidential information can be disclosed without their consent.',6,639,NULL,NULL),(100,'Name 2 signs of Aggression',6,644,NULL,NULL),(101,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',6,647,NULL,NULL),(102,'Name 2 Risk Factors to Aggression',6,648,NULL,NULL),(103,'Which of the following can inhibit communication?',6,655,NULL,NULL),(104,'How does DSMIV-TR characterize bipolar disorder?',6,659,NULL,NULL),(105,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',6,661,NULL,NULL),(106,'Stage 3 of susbtance dependence is',6,663,NULL,NULL),(107,'Copying confidential information is:',6,668,NULL,NULL),(108,'Behavioral Healthcare facilities are able, by law to bill insurance companies without actual written consent from client',6,671,NULL,NULL),(109,'With written permission behavioral healthcare facilities can share information with parents and spouses',6,682,NULL,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,NULL),(111,'Oral information is not protected by HIPAA guidelines',6,677,NULL,NULL),(112,'There is a fine for healthcare facilities that violate HIPAA guidelines',6,678,NULL,NULL),(113,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',6,681,NULL,NULL),(114,'Why is infection control important?',6,685,NULL,NULL),(115,'What illnesses are spread through contact? ',6,688,NULL,NULL),(116,'What does HIPAA stand for?',7,694,NULL,NULL),(117,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',7,697,NULL,NULL),(118,'What is an example/examples of PHI (Protected Health Information?',7,703,NULL,NULL),(119,'It is ok to discuss a patient with my spouse of he/she won’t tell anyone.',7,706,NULL,NULL),(120,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',7,711,NULL,NULL),(121,'If someone forgets his log-in ID, can I let him use mine?',7,714,NULL,NULL),(122,'What does \"minimum necessary\" mean?',7,720,NULL,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,NULL),(125,'Are Consents and Authorizations the same?',7,745,NULL,NULL),(126,'Is text messaging is a secure way to transmit patient information within your facility.',7,735,NULL,NULL),(127,'Who must comply with the ADA?',8,750,NULL,NULL),(128,'According to the ADA, a person with a disability has:',8,753,NULL,NULL),(129,'What is a condition not covered by the ADA?',8,759,NULL,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,NULL),(131,'What is an example of a “reasonable accommodation”?',8,767,NULL,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,NULL),(133,'The ADA requires that organizations hire the disabled.',8,773,NULL,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,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,NULL),(136,'According to the ADA, “major life activities” include',8,782,NULL,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,NULL),(138,'Incident Reporting is the affirmative duty of',9,11904,NULL,NULL),(139,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',9,11909,NULL,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,NULL),(141,'Which of the following statements is NOT true of Incident Reporting ',9,11917,NULL,NULL),(142,'When entering narrative documentation on an Incident Report Form staff MUST ',9,11922,NULL,NULL),(143,'DCF has created an online reporting system called:',9,11927,NULL,NULL),(144,'The DCF incident reporting procedures replace exploitation reporting protocols, as required by law. ',9,11929,NULL,NULL),(145,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',9,11932,NULL,NULL),(146,'Domestic Violence is best conceptualized as:',11,831,NULL,NULL),(147,'The four main types of Domestic Violence are:',11,961,NULL,NULL),(148,'Risk factors for Domestic Violence victimization include all the following EXCEPT:',11,964,NULL,NULL),(149,'What combination contributes to the risk of becoming a victim or a perpetrator of Domestic Violence?',11,920,NULL,NULL),(150,'Children from violent homes may demonstrate:',11,849,NULL,NULL),(151,'Patterns of controlling behavior can include:',11,854,NULL,NULL),(152,'Signs of a potential abuser in a dating relationship include all of the following EXCEPT',11,857,NULL,NULL),(153,'Which of the following are characteristics of a potential abuser:',11,859,NULL,NULL),(154,'To gain power and control an abuser may:',11,870,NULL,NULL),(155,'Tension building and making up are:',11,873,NULL,NULL),(156,'In dealing with Domestic Violence the most important phone numbers are:',11,950,NULL,NULL),(157,'The rate of Domestic Violence detection among behavioral health practitioners and healthcare workers is:',11,967,NULL,NULL),(158,'Missed cases of Domestic Violence may be due to all of the following EXCEPT:',11,928,NULL,NULL),(159,'Healthcare workers can help in detecting Domestic Violence by:',11,931,NULL,NULL),(160,'Mental health staff can become effective advocates by:',11,892,NULL,NULL),(161,'Advocating for Domestic Violence victims includes all of the following EXCEPT:',11,940,NULL,NULL),(162,'In Florida, the Domestic Violence Hotline Number is:',11,956,NULL,NULL),(163,'Safety plans cover: ',11,906,NULL,NULL),(164,'Florida state reporting laws require:',11,907,NULL,NULL),(165,'If a patient does not disclose Domestic Violence to a behavioral healthcare worker, the worker should document:',11,945,NULL,NULL),(166,'What does co-occurring disorder mean?',12,971,NULL,NULL),(167,'What mental conditions are more likely to abuse substances?',12,984,NULL,NULL),(168,'Which of the following statements are False?',12,981,NULL,NULL),(169,'What describes the term Denial?',12,990,NULL,NULL),(170,'What are signs and symptoms of anxiety disorders?',12,994,NULL,NULL),(171,'SAMSHA recommends the following treatment model for co-occurring disorders:',12,997,NULL,NULL),(172,'Mental disorders are caused by:',12,1000,NULL,NULL),(173,'A common sign of binge eating disorder is:',12,1134,NULL,NULL),(174,'A common sign of bulimia nervosa is',12,1138,NULL,NULL),(175,'Hand-washing until your skin becomes raw is a sign of which of the following disorders:',12,1013,NULL,NULL),(176,'Hyperactivity is a symptom of which of the following disorders:',12,1017,NULL,NULL),(177,'Some people develop mental health issues after excessive drinking or drug use.',12,1019,NULL,NULL),(178,'A mental disorder can complicate the challenge in overcoming an addiction to drugs or alcohol.',12,1021,NULL,NULL),(179,'About 50% of people with severe mental disorders are affected by substance abuse.',12,1023,NULL,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,NULL),(181,'The ramifications of allowing/causing a breach in confidentiality can include:',13,1199,NULL,NULL),(182,'Adhering to confidentiality',13,1201,NULL,NULL),(183,'Some dual roles are unavoidable. How do you deal with them?',13,1209,NULL,NULL),(184,'Which of the following is not generally a basis of decision making?',13,1045,NULL,NULL),(185,'Ethical decisions in treatment are:',13,1212,NULL,NULL),(186,'Dual relationships occur when',13,1222,NULL,NULL),(187,'Boundaries',13,1228,NULL,NULL),(188,'Professional Ethics:',13,1234,NULL,NULL),(189,'Ethical Nuances',13,1072,NULL,NULL),(190,'42 CFR applies to:',13,1076,NULL,NULL),(191,'Both HIPAA and 42 CFR are concerned with client confidentiality as it relates to substance use disorder. ',13,1236,NULL,NULL),(192,'Blurring boundaries',13,1084,NULL,NULL),(193,'Informed consent is:',13,1090,NULL,NULL),(194,'Counselor self-disclosure:',13,1274,NULL,NULL),(195,'Transference is:',13,1267,NULL,NULL),(196,'Counter-transference is:',13,1263,NULL,NULL),(197,'When a counselor is not aware of transference & counter-transference issues, the counselor:',13,1261,NULL,NULL),(198,'Which of the following are examples of dual relationships?',13,1256,NULL,NULL),(199,'Scope of Practice is defined as:',13,1249,NULL,NULL),(200,'Ethical considerations can typically be viewed from which of the following three different perspectives?',13,1243,NULL,NULL),(201,'What are the usual Demographics of Self-Harm?',14,1142,NULL,NULL),(202,'The suicide rate is higher than the rate of homicide',14,1146,NULL,NULL),(203,'What is the age group with highest suicide risk?',14,1152,NULL,NULL),(204,'What are observable signs of serious depression that are correlated to Suicidality? ',14,1157,NULL,NULL),(205,'What are the components of a good Suicide Assessment?',14,1162,NULL,NULL),(206,'Do behavioral addictions increase a person’s risk of suicide?',14,1163,NULL,NULL),(207,'What are the two most prevalent risk factors associated with suicide?',14,1165,NULL,NULL),(208,'How much more likely to commit suicide are victims of domestic abuse?',14,1169,NULL,NULL),(209,'How much higher is the rate of Suicide with Eating Disorder clients’?',14,1174,NULL,NULL),(210,'What are some crisis elements that increase suicidality?',14,1179,NULL,NULL),(211,'Both race and ethnicity represent cultures',15,1180,NULL,NULL),(212,'The process that represents the absorption of many different cultures into a given area',15,1185,NULL,NULL),(213,'Which of the following is not a racial and ethnic minority group',15,1189,NULL,NULL),(214,'Eye contact has a similar meaning among most cultures',15,1192,NULL,NULL),(215,'Spirituality is part of every ethnic group',15,1193,NULL,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,NULL),(592,'Incident Reporting is the affirmative duty of',25,11847,NULL,NULL),(593,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',25,11852,NULL,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,NULL),(703,'If two staff members are involved in or witness an unusual event the staff members are required to',25,11859,NULL,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,NULL),(705,'If more than one client is involved in an unusual event staff must ',25,11864,NULL,NULL),(706,'Which of the following statements is NOT true of Incident Reporting ',25,11868,NULL,NULL),(707,'When entering narrative documentation on an Incident Report Form staff MUST ',25,11873,NULL,NULL),(708,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',25,11877,NULL,NULL),(709,'DCF has created an online reporting system called:',25,11882,NULL,NULL),(710,'Providers who must report critical incidents through IRAS include:',25,11886,NULL,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,NULL),(712,'The Joint Commission adopted a formal Sentinel Event Policy to assist healthcare providers ',25,11892,NULL,NULL),(713,'It is mandatory for all substance abuse providers  have to report sentinel events to The Joint Commission',25,11895,NULL,NULL),(1131,'If you reasonably suspect child abuse you are required:',9,11936,NULL,NULL),(1132,'If a child is deprived of clothing, shelter, or medical services it is called:',9,11941,NULL,NULL),(1133,'Who is considered a professional mandatory reporter?',9,11945,NULL,NULL),(1134,'What is the reason that victims may not report their abusers?',9,11949,NULL,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,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,NULL),(1137,'What is consider exploitation of a vulnerable adult?',9,11957,NULL,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,NULL),(1139,'Providers shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under:',9,11965,NULL,NULL),(1140,'The Abuse Hotline Phone Number is:',9,11968,NULL,NULL),(1141,'According to EEOC in order for behavior to be considered sexual harassment it must be ',10,1870,NULL,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,NULL),(1143,'The Quid Pro Quo theory of sexual harassment involves:',10,1873,NULL,NULL),(1144,'IF you feel you are the victim of unwelcome sexual behavior you are encouraged to:',10,1881,NULL,NULL),(1145,'It is illegal for an employer or other employees to retaliate against any individual who:',10,1885,NULL,NULL),(1146,'Sexual Harassment in employment is legally recognized as a form of sex discrimination and is illegal.',10,1886,NULL,NULL),(1147,'Sexual harassment can occur outside the work site and still be considered work related.',10,1888,NULL,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,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,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,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,NULL),(1152,'It is solely the company’s responsibility to prevent sexual harassment',10,1899,NULL,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,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,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,NULL),(1157,'A counselor and client can enter into a personal relationship after five years has elapsed.',26,11972,NULL,NULL),(1158,'What is a “Dual Relationship”?',26,11973,NULL,NULL),(1159,'Explain the purpose of HIPAA guidelines.',26,11978,NULL,NULL),(1160,'What does the acronym HIPAA stand for?',26,11983,NULL,NULL),(1161,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',26,11986,NULL,NULL),(1162,'What is the Right of Habeas Corpus?',26,11989,NULL,NULL),(1163,'Give a reason why maintaining proper boundaries is the responsibility of the staff.',26,12060,NULL,NULL),(1164,'Anger is a choice in a range of available behaviors',26,11995,NULL,NULL),(1165,'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?',26,11998,NULL,NULL),(1166,'Give an instance when client confidential information can be disclosed without their consent.',26,12007,NULL,NULL),(1167,'Name a sign of Aggression',26,12012,NULL,NULL),(1168,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',26,12014,NULL,NULL),(1169,'Name a Risk Factor to Aggression',26,12016,NULL,NULL),(1170,'Which of the following can inhibit communication?',26,12022,NULL,NULL),(1171,'How does DSMIV-TR characterize bipolar disorder?',26,12025,NULL,NULL),(1172,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',26,12028,NULL,NULL),(1173,'Stage 3 of susbtance dependence is',26,12032,NULL,NULL),(1174,'Copying confidential information is:',26,12034,NULL,NULL),(1175,'Why is infection control important?',26,12037,NULL,NULL),(1176,'What illnesses are spread through contact? ',26,12044,NULL,NULL),(1177,'Under the Marchman Act people can be taken into protective custody without consent to:',26,12049,NULL,NULL),(1178,'Without written permission behavioral healthcare facilities can only share information with parents and spouses',26,12051,NULL,NULL),(1179,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',26,12053,NULL,NULL),(1180,'Oral information is not protected by HIPAA guidelines',26,12055,NULL,NULL),(1181,'There is a fine for healthcare facilities that violate HIPAA guidelines',26,12056,NULL,NULL),(1182,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',26,12059,NULL,NULL),(1183,'The initial decision to take drugs is voluntary.',27,12064,NULL,NULL),(1184,'A state of ________  is when someone is able to consume large doses of a drug continuously with no ill effects.',27,12069,NULL,NULL),(1185,'Addiction is often broken when negative consequences occur.',27,12071,NULL,NULL),(1186,'Genetics is a contributing factor to addiction.',27,12072,NULL,NULL),(1187,'Following the rules ensures ethical conduct.',27,12075,NULL,NULL),(1188,'Information releases in the criminal justice system are the same as outside the justice system.',27,12077,NULL,NULL),(1189,'Every state requires disclosure of harmful situations to minors.',27,12078,NULL,NULL),(1190,'Boundaries must be set primarily by the client, then the professional.',27,12081,NULL,NULL),(1191,'It is not exploitation if the client initiates the action.',27,12083,NULL,NULL),(1192,'Counselors are culturally competent when they are open to other cultures.',27,12085,NULL,NULL),(1193,'About one-sixth of Americans have a disability.',27,12086,NULL,NULL),(1194,'A client’s sex/gender can come with cultural considerations.',27,12088,NULL,NULL),(1195,'Supervision and counseling are basically the same thing.',27,12091,NULL,NULL),(1196,'Counselors and supervisors should have similar boundaries to counselors and clients.',27,12092,NULL,NULL),(1197,'Informed consent is:',27,12097,NULL,NULL),(1198,'Confidential information cannot be released unless:',27,12102,NULL,NULL),(1199,'Self-disclosure is appropriate when:',27,12105,NULL,NULL),(1200,'Counselors in recovery themselves represent:',27,12112,NULL,NULL),(1201,'Why do counselors who are themselves in recovery need additional supervision?',27,12113,NULL,NULL),(1202,'A good example of blurred boundaries can include:',27,12119,NULL,NULL),(1203,'A good example of a dual relationship is:',27,12124,NULL,NULL),(1204,'Which of the regulation below must an agency follow first?',27,12126,NULL,NULL),(1205,'The below are all client rights except:',27,12130,NULL,NULL),(1206,'How can counselors become truly culturally competent?',27,12136,NULL,NULL),(1207,'ADA (Legislative Acronym) Stands for:',27,12139,NULL,NULL),(1208,'Diverse Values:',27,12144,NULL,NULL),(1209,'Seeking out supervision when needed is a counselor’s:',27,12147,NULL,NULL),(1210,'A crisis can ultimately be either positive or negative. ',28,12149,NULL,NULL),(1211,'Substance abuse itself cannot lead to a crisis. ',28,12152,NULL,NULL),(1212,'¾ of domestic violence victims are female. ',28,12153,NULL,NULL),(1213,'Domestic violence does not affect the elderly. ',28,12156,NULL,NULL),(1214,'Same-sex partners are often overlooked when determining domestic violence.',28,12157,NULL,NULL),(1215,'Threats are not Domestic Violence. ',28,12160,NULL,NULL),(1216,'Domestic Violence does not apply to those dating. ',28,12162,NULL,NULL),(1217,'Measles can be transmitted without physical contact. ',28,12163,NULL,NULL),(1218,'Hepatitis is an illness of the kidney. ',28,12166,NULL,NULL),(1219,'Hand sanitizers eliminate all germs. ',28,12168,NULL,NULL),(1220,'Crisis intervention requires the counselor to:',28,12172,NULL,NULL),(1221,'Which of the following is not a way to prevent a crisis?',28,12173,NULL,NULL),(1222,'Domestic violence affects:',28,12181,NULL,NULL),(1223,'Between 1990 and 2003 the rate of Domestic Violence:',28,12184,NULL,NULL),(1224,'Intimate Partner Violence is:',28,12400,NULL,NULL),(1225,'Which of the following is not a risk factor of intimate partner violence?',28,12191,NULL,NULL),(1226,'What are some of the most common signs of IPV?',28,12200,NULL,NULL),(1227,'Which of the following is not a route of infection transmission?',28,12203,NULL,NULL),(1228,'Effective hand sanitizers should contain at least how much alcohol by volume?',28,12207,NULL,NULL),(1229,'Which of the following are risk factors of HEP C Infection?',28,12213,NULL,NULL),(1230,'A referral is needed when the treatment center cannot fulfill the needs of the client. ',29,12216,NULL,NULL),(1231,'Referrals should not be made to religious organizations.',29,12219,NULL,NULL),(1232,'Treatment breakdowns are often caused by erroneous referrals.',29,12220,NULL,NULL),(1233,'There is no wrong time to refer out.',29,12222,NULL,NULL),(1234,'Documentation is a convenience not a necessity.',29,12225,NULL,NULL),(1235,'HIPAA regulates client privacy. ',29,12226,NULL,NULL),(1236,'Stored records belong to the counselor treating the client. ',29,12229,NULL,NULL),(1237,'Documentation should be objective, avoiding conjecture. ',29,12230,NULL,NULL),(1238,'The developmental assets model describes 50 positive traits. ',29,12233,NULL,NULL),(1239,'The strategic Prevention Framework was created by CSAP and SAMHSA. ',29,12234,NULL,NULL),(1240,'Evidence-based principles for substance abuse prevention include:',29,12240,NULL,NULL),(1241,'CSAP’s prevention strategies were created for:',29,12244,NULL,NULL),(1242,'The Developmental Assets Model:',29,12246,NULL,NULL),(1243,'Prevention goals can include:',29,12249,NULL,NULL),(1244,'Documentation skills include:',29,12256,NULL,NULL),(1245,'Client files:',29,12259,NULL,NULL),(1246,'Access to client information is regulated by:',29,12262,NULL,NULL),(1247,'Which of the following is not a function of client treatment documentation?',29,12268,NULL,NULL),(1248,'Loneliness and isolation is a relapse risk factor ',30,12269,NULL,NULL),(1249,'Clinicians should take clients off their medication as soon as they are feeling better ',30,12272,NULL,NULL),(1250,'Completing education in recovering addicts can offer a sense of purpose and achievement ',30,12273,NULL,NULL),(1251,'Stress can lead to relapse',30,12275,NULL,NULL),(1252,'12 steps are a popular but largely unproven aftercare resource for alcoholics ',30,12278,NULL,NULL),(1253,'Cultural competence is important in aftercare too ',30,12279,NULL,NULL),(1254,'Florida has the third highest incidence of HIV/AIDS in the US ',30,12281,NULL,NULL),(1255,'HIV can be transmitted through casual contact ',30,12284,NULL,NULL),(1256,'HIV is both a bacterial and viral infection ',30,12286,NULL,NULL),(1257,'Aftercare is:',30,12289,NULL,NULL),(1258,'Appropriate interim goals may include:',30,12291,NULL,NULL),(1259,'It is important that, when taking medicine, clients do not:',30,12297,NULL,NULL),(1260,'Recovering addicts may find career success by:',30,12302,NULL,NULL),(1261,'Stress and anxiety management often leads to:',30,12303,NULL,NULL),(1262,'12 step programs are:',30,12310,NULL,NULL),(1263,'Which of the following is not a goal of social development?',30,12313,NULL,NULL),(1264,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',30,12319,NULL,NULL),(1265,'Which risk groups account for 75 percent of new HIV/AIDS infections?',30,12322,NULL,NULL),(1266,'Which of the following would be most likely transmit an HIV infection?',30,12325,NULL,NULL),(1267,'Which of the following safer sex precautionary measures has not been demonstrated to reduce the spread of HIV?',30,12330,NULL,NULL),(1268,'Immediately after exposure to the blood of a patient, a healthcare worker should:',30,12335,NULL,NULL),(1269,'Dual disorders must be treated by multiple facilities ',31,12337,NULL,NULL),(1270,'The Developmental Model of Recovery has 5 stages ',31,12339,NULL,NULL),(1271,'Substance abuse and mental illness levels of care are the same for all clinicians',31,12341,NULL,NULL),(1272,'Extrinsic motivators are internal motivators',31,12343,NULL,NULL),(1273,'Affect is a pattern of implied behavior and emotion',31,12345,NULL,NULL),(1274,'The Developmental Model of Recovery asserts that there are often predictable stages in recovery ',31,12346,NULL,NULL),(1275,'Protective factors reduce the risk of addiction ',31,12348,NULL,NULL),(1276,'Prophylactic drug treatment refers to prevention of future episodes ',31,12350,NULL,NULL),(1277,'Many people are not adequately treated for co-occurring disorders ',31,12352,NULL,NULL),(1278,'Dysphoric is a term used to identify mood',31,12354,NULL,NULL),(1279,'Which of the following is a risk factor in the individual domain:',31,12357,NULL,NULL),(1280,'The Developmental Model of Recovery',31,12363,NULL,NULL),(1281,'The Developmental Model of Recovery is based upon',31,12365,NULL,NULL),(1282,'Graduating to maintenance from stabilization in The Developmental Model of Recovery requires:',31,12371,NULL,NULL),(1283,'Psychotropic medications:',31,12373,NULL,NULL),(1284,'The lobe of the brain responsible for movement is the:',31,12378,NULL,NULL),(1285,'Clinicians began seeing the relationships between substance abuse and mental illness in the',31,12382,NULL,NULL),(1286,'Questions in recovery are used to:',31,12387,NULL,NULL),(1287,'Which of the following is not an often-used term to describe a client’s mood:',31,12392,NULL,NULL),(1288,'Which of the following is not an often-used term to describe affect:',31,12394,NULL,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=6951 DEFAULT CHARSET=utf8;

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

INSERT INTO `response` VALUES (4727,303,1183,27,'12064',1,1),(4728,303,1184,27,'12069',1,1),(4729,303,1185,27,'12071',1,1),(4730,303,1186,27,'12072',1,1),(4731,303,1187,27,'12074',1,NULL),(4732,303,1188,27,'12077',1,1),(4733,303,1189,27,'12079',1,NULL),(4734,303,1190,27,'12081',1,1),(4735,303,1191,27,'12083',1,1),(4736,303,1192,27,'12084',1,NULL),(4737,303,1193,27,'12086',1,1),(4738,303,1194,27,'12088',1,1),(4739,303,1195,27,'12091',1,1),(4740,303,1196,27,'12092',1,1),(4741,303,1197,27,'12097',1,1),(4742,303,1198,27,'12102',1,1),(4743,303,1199,27,'12105',1,1),(4744,303,1200,27,'12112',1,1),(4745,303,1201,27,'12113',1,1),(4746,303,1202,27,'12119',1,1),(4747,303,1203,27,'12124',1,1),(4748,303,1204,27,'12126',1,1),(4749,303,1205,27,'12129',1,NULL),(4750,303,1206,27,'12136',1,1),(4751,303,1207,27,'12139',1,1),(4752,303,1208,27,'12144',1,1),(4753,303,1209,27,'12147',1,1),(4754,303,1210,28,'12150',1,NULL),(4755,303,1211,28,'12152',1,1),(4756,303,1212,28,'12153',1,1),(4757,303,1213,28,'12156',1,1),(4758,303,1214,28,'12157',1,1),(4759,303,1215,28,'12160',1,1),(4760,303,1216,28,'12162',1,1),(4761,303,1217,28,'12163',1,1),(4762,303,1218,28,'12166',1,1),(4763,303,1219,28,'12168',1,1),(4764,303,1220,28,'12172',1,1),(4765,303,1221,28,'12173',1,1),(4766,303,1222,28,'12181',1,1),(4767,303,1223,28,'12183',1,NULL),(4768,303,1224,28,'12400',1,1),(4769,303,1225,28,'12191',1,1),(4770,303,1226,28,'12200',1,1),(4771,303,1227,28,'12203',1,1),(4772,303,1228,28,'12210',1,NULL),(4773,303,1229,28,'12212',1,NULL),(4774,304,1183,27,'12064',1,1),(4775,304,1184,27,'12069',1,1),(4776,304,1185,27,'12071',1,1),(4777,304,1186,27,'12072',1,1),(4778,304,1187,27,'12075',1,1),(4779,304,1188,27,'12077',1,1),(4780,304,1189,27,'12078',1,1),(4781,304,1190,27,'12081',1,1),(4782,304,1191,27,'12083',1,1),(4783,304,1192,27,'12085',1,1),(4784,304,1193,27,'12087',1,NULL),(4785,304,1194,27,'12088',1,1),(4786,304,1195,27,'12091',1,1),(4787,304,1196,27,'12092',1,1),(4788,304,1197,27,'12097',1,1),(4789,304,1198,27,'12102',1,1),(4790,304,1199,27,'12105',1,1),(4791,304,1200,27,'12112',1,1),(4792,304,1201,27,'12115',1,NULL),(4793,304,1202,27,'12119',1,1),(4794,304,1203,27,'12124',1,1),(4795,304,1204,27,'12126',1,1),(4796,304,1205,27,'12130',1,1),(4797,304,1206,27,'12136',1,1),(4798,304,1207,27,'12139',1,1),(4799,304,1208,27,'12144',1,1),(4800,304,1209,27,'12147',1,1),(4801,296,1183,27,'12064',1,1),(4802,296,1184,27,'12068',1,NULL),(4803,296,1185,27,'12071',1,1),(4804,296,1186,27,'12072',1,1),(4805,296,1187,27,'12074',1,NULL),(4806,296,1188,27,'12077',1,1),(4807,296,1189,27,'12078',1,1),(4808,296,1190,27,'12081',1,1),(4809,296,1191,27,'12083',1,1),(4810,296,1192,27,'12084',1,NULL),(4811,296,1193,27,'12087',1,NULL),(4812,296,1194,27,'12088',1,1),(4813,296,1195,27,'12091',1,1),(4814,296,1196,27,'12092',1,1),(4815,296,1197,27,'12097',1,1),(4816,296,1198,27,'12102',1,1),(4817,296,1199,27,'12105',1,1),(4818,296,1200,27,'12112',1,1),(4819,296,1201,27,'12116',1,NULL),(4820,296,1202,27,'12119',1,1),(4821,296,1203,27,'12124',1,1),(4822,296,1204,27,'12126',1,1),(4823,296,1205,27,'12129',1,NULL),(4824,296,1206,27,'12136',1,1),(4825,296,1207,27,'12139',1,1),(4826,296,1208,27,'12144',1,1),(4827,296,1209,27,'12147',1,1),(4828,296,1183,27,'12064',2,1),(4829,296,1184,27,'12069',2,1),(4830,296,1185,27,'12071',2,1),(4831,296,1186,27,'12072',2,1),(4832,296,1187,27,'12075',2,1),(4833,296,1188,27,'12077',2,1),(4834,296,1189,27,'12078',2,1),(4835,296,1190,27,'12081',2,1),(4836,296,1191,27,'12083',2,1),(4837,296,1192,27,'12085',2,1),(4838,296,1193,27,'12086',2,1),(4839,296,1194,27,'12088',2,1),(4840,296,1195,27,'12091',2,1),(4841,296,1196,27,'12092',2,1),(4842,296,1197,27,'12097',2,1),(4843,296,1198,27,'12102',2,1),(4844,296,1199,27,'12105',2,1),(4845,296,1200,27,'12112',2,1),(4846,296,1201,27,'12114',2,NULL),(4847,296,1202,27,'12119',2,1),(4848,296,1203,27,'12124',2,1),(4849,296,1204,27,'12126',2,1),(4850,296,1205,27,'12130',2,1),(4851,296,1206,27,'12136',2,1),(4852,296,1207,27,'12139',2,1),(4853,296,1208,27,'12144',2,1),(4854,296,1209,27,'12147',2,1),(4855,292,1183,27,'12064',1,1),(4856,292,1184,27,'12069',1,1),(4857,292,1185,27,'12070',1,NULL),(4858,292,1186,27,'12073',1,NULL),(4859,292,1187,27,'12074',1,NULL),(4860,292,1188,27,'12077',1,1),(4861,292,1189,27,'12078',1,1),(4862,292,1190,27,'12081',1,1),(4863,292,1191,27,'12083',1,1),(4864,292,1192,27,'12085',1,1),(4865,292,1193,27,'12086',1,1),(4866,292,1194,27,'12089',1,NULL),(4867,292,1195,27,'12091',1,1),(4868,292,1196,27,'12092',1,1),(4869,292,1197,27,'12096',1,NULL),(4870,292,1198,27,'12098',1,NULL),(4871,292,1199,27,'12105',1,1),(4872,292,1200,27,'12112',1,1),(4873,292,1201,27,'12114',1,NULL),(4874,292,1202,27,'12119',1,1),(4875,292,1203,27,'12124',1,1),(4876,292,1204,27,'12126',1,1),(4877,292,1205,27,'12130',1,1),(4878,292,1206,27,'12136',1,1),(4879,292,1207,27,'12138',1,NULL),(4880,292,1208,27,'12144',1,1),(4881,292,1209,27,'12147',1,1),(4882,292,1183,27,'12064',2,1),(4883,292,1184,27,'12069',2,1),(4884,292,1185,27,'12071',2,1),(4885,292,1186,27,'12072',2,1),(4886,292,1187,27,'12075',2,1),(4887,292,1188,27,'12077',2,1),(4888,292,1189,27,'12078',2,1),(4889,292,1190,27,'12081',2,1),(4890,292,1191,27,'12083',2,1),(4891,292,1192,27,'12085',2,1),(4892,292,1193,27,'12086',2,1),(4893,292,1194,27,'12088',2,1),(4894,292,1195,27,'12091',2,1),(4895,292,1196,27,'12092',2,1),(4896,292,1197,27,'12097',2,1),(4897,292,1198,27,'12100',2,NULL),(4898,292,1199,27,'12105',2,1),(4899,292,1200,27,'12112',2,1),(4900,292,1201,27,'12113',2,1),(4901,292,1202,27,'12119',2,1),(4902,292,1203,27,'12124',2,1),(4903,292,1204,27,'12126',2,1),(4904,292,1205,27,'12130',2,1),(4905,292,1206,27,'12136',2,1),(4906,292,1207,27,'12137',2,NULL),(4907,292,1208,27,'12144',2,1),(4908,292,1209,27,'12147',2,1),(4909,304,1210,28,'12150',1,NULL),(4910,304,1211,28,'12152',1,1),(4911,304,1212,28,'12153',1,1),(4912,304,1213,28,'12156',1,1),(4913,304,1214,28,'12157',1,1),(4914,304,1215,28,'12160',1,1),(4915,304,1216,28,'12162',1,1),(4916,304,1217,28,'12163',1,1),(4917,304,1218,28,'12166',1,1),(4918,304,1219,28,'12168',1,1),(4919,304,1220,28,'12172',1,1),(4920,304,1221,28,'12173',1,1),(4921,304,1222,28,'12181',1,1),(4922,304,1223,28,'12185',1,NULL),(4923,304,1224,28,'12400',1,1),(4924,304,1225,28,'12191',1,1),(4925,304,1226,28,'12200',1,1),(4926,304,1227,28,'12203',1,1),(4927,304,1228,28,'12207',1,1),(4928,304,1229,28,'12213',1,1),(4929,303,1230,29,'12216',1,1),(4930,303,1231,29,'12219',1,1),(4931,303,1232,29,'12220',1,1),(4932,303,1233,29,'12223',1,NULL),(4933,303,1234,29,'12225',1,1),(4934,303,1235,29,'12226',1,1),(4935,303,1236,29,'12229',1,1),(4936,303,1237,29,'12230',1,1),(4937,303,1238,29,'12232',1,NULL),(4938,303,1239,29,'12234',1,1),(4939,303,1240,29,'12240',1,1),(4940,303,1241,29,'12244',1,1),(4941,303,1242,29,'12248',1,NULL),(4942,303,1243,29,'12249',1,1),(4943,303,1244,29,'12256',1,1),(4944,303,1245,29,'12259',1,1),(4945,303,1246,29,'12262',1,1),(4946,303,1247,29,'12266',1,NULL),(4947,303,1230,29,'12216',2,1),(4948,303,1231,29,'12219',2,1),(4949,303,1232,29,'12220',2,1),(4950,303,1233,29,'12222',2,1),(4951,303,1234,29,'12225',2,1),(4952,303,1236,29,'12229',2,1),(4953,303,1238,29,'12233',2,1),(4954,303,1239,29,'12234',2,1),(4955,303,1240,29,'12240',2,1),(4956,303,1241,29,'12244',2,1),(4957,303,1242,29,'12246',2,1),(4958,303,1243,29,'12249',2,1),(4959,303,1244,29,'12256',2,1),(4960,303,1245,29,'12259',2,1),(4961,303,1246,29,'12262',2,1),(4962,303,1247,29,'12268',2,1),(4963,297,1183,27,'12064',1,1),(4964,297,1184,27,'12069',1,1),(4965,297,1185,27,'12071',1,1),(4966,297,1186,27,'12072',1,1),(4967,297,1187,27,'12075',1,1),(4968,297,1188,27,'12077',1,1),(4969,297,1189,27,'12078',1,1),(4970,297,1190,27,'12081',1,1),(4971,297,1191,27,'12083',1,1),(4972,297,1192,27,'12085',1,1),(4973,297,1193,27,'12086',1,1),(4974,297,1194,27,'12089',1,NULL),(4975,297,1195,27,'12091',1,1),(4976,297,1196,27,'12092',1,1),(4977,297,1197,27,'12097',1,1),(4978,297,1198,27,'12102',1,1),(4979,297,1199,27,'12105',1,1),(4980,297,1200,27,'12112',1,1),(4981,297,1201,27,'12113',1,1),(4982,297,1202,27,'12119',1,1),(4983,297,1203,27,'12124',1,1),(4984,297,1204,27,'12126',1,1),(4985,297,1205,27,'12130',1,1),(4986,297,1206,27,'12136',1,1),(4987,297,1207,27,'12139',1,1),(4988,297,1208,27,'12144',1,1),(4989,297,1209,27,'12147',1,1),(4990,296,1210,28,'12149',1,1),(4991,296,1211,28,'12152',1,1),(4992,296,1212,28,'12154',1,NULL),(4993,296,1213,28,'12156',1,1),(4994,296,1214,28,'12157',1,1),(4995,296,1215,28,'12159',1,NULL),(4996,296,1216,28,'12162',1,1),(4997,296,1217,28,'12164',1,NULL),(4998,296,1218,28,'12165',1,NULL),(4999,296,1219,28,'12168',1,1),(5000,296,1220,28,'12172',1,1),(5001,296,1221,28,'12173',1,1),(5002,296,1222,28,'12181',1,1),(5003,296,1223,28,'12182',1,NULL),(5004,296,1224,28,'12398',1,NULL),(5005,296,1225,28,'12191',1,1),(5006,296,1226,28,'12200',1,1),(5007,296,1227,28,'12203',1,1),(5008,296,1228,28,'12207',1,1),(5009,296,1229,28,'12214',1,NULL),(5010,296,1210,28,'12149',2,1),(5011,296,1211,28,'12151',2,NULL),(5012,296,1212,28,'12153',2,1),(5013,296,1213,28,'12156',2,1),(5014,296,1214,28,'12157',2,1),(5015,296,1215,28,'12160',2,1),(5016,296,1216,28,'12162',2,1),(5017,296,1217,28,'12163',2,1),(5018,296,1218,28,'12166',2,1),(5019,296,1219,28,'12168',2,1),(5020,296,1220,28,'12172',2,1),(5021,296,1221,28,'12173',2,1),(5022,296,1222,28,'12181',2,1),(5023,296,1223,28,'12185',2,NULL),(5024,296,1224,28,'12397',2,NULL),(5025,296,1225,28,'12191',2,1),(5026,296,1226,28,'12200',2,1),(5027,296,1227,28,'12203',2,1),(5028,296,1228,28,'12207',2,1),(5029,296,1229,28,'12213',2,1),(5030,309,1183,27,'12064',1,1),(5031,309,1184,27,'12069',1,1),(5032,309,1185,27,'12071',1,1),(5033,309,1186,27,'12072',1,1),(5034,309,1187,27,'12075',1,1),(5035,309,1188,27,'12077',1,1),(5036,309,1189,27,'12078',1,1),(5037,309,1190,27,'12081',1,1),(5038,309,1191,27,'12083',1,1),(5039,309,1192,27,'12084',1,NULL),(5040,309,1193,27,'12087',1,NULL),(5041,309,1194,27,'12088',1,1),(5042,309,1195,27,'12091',1,1),(5043,309,1196,27,'12092',1,1),(5044,309,1197,27,'12097',1,1),(5045,309,1198,27,'12102',1,1),(5046,309,1199,27,'12105',1,1),(5047,309,1200,27,'12112',1,1),(5048,309,1201,27,'12113',1,1),(5049,309,1202,27,'12119',1,1),(5050,309,1203,27,'12124',1,1),(5051,309,1204,27,'12126',1,1),(5052,309,1205,27,'12129',1,NULL),(5053,309,1206,27,'12136',1,1),(5054,309,1207,27,'12139',1,1),(5055,309,1208,27,'12144',1,1),(5056,309,1209,27,'12148',1,NULL),(5057,303,1248,30,'12269',1,1),(5058,303,1249,30,'12272',1,1),(5059,303,1250,30,'12273',1,1),(5060,303,1251,30,'12275',1,1),(5061,303,1252,30,'12278',1,1),(5062,303,1253,30,'12279',1,1),(5063,303,1254,30,'12281',1,1),(5064,303,1255,30,'12284',1,1),(5065,303,1256,30,'12286',1,1),(5066,303,1257,30,'12289',1,1),(5067,303,1258,30,'12291',1,1),(5068,303,1259,30,'12297',1,1),(5069,303,1260,30,'12301',1,NULL),(5070,303,1261,30,'12303',1,1),(5071,303,1262,30,'12310',1,1),(5072,303,1263,30,'12313',1,1),(5073,303,1264,30,'12319',1,1),(5074,303,1265,30,'12322',1,1),(5075,303,1266,30,'12325',1,1),(5076,303,1267,30,'12330',1,1),(5077,303,1268,30,'12335',1,1),(5078,296,1230,29,'12216',1,1),(5079,296,1231,29,'12219',1,1),(5080,296,1232,29,'12221',1,NULL),(5081,296,1233,29,'12222',1,1),(5082,296,1234,29,'12225',1,1),(5083,296,1235,29,'12226',1,1),(5084,296,1236,29,'12229',1,1),(5085,296,1237,29,'12230',1,1),(5086,296,1238,29,'12233',1,1),(5087,296,1239,29,'12234',1,1),(5088,296,1240,29,'12240',1,1),(5089,296,1241,29,'12242',1,NULL),(5090,296,1242,29,'12246',1,1),(5091,296,1243,29,'12249',1,1),(5092,296,1244,29,'12256',1,1),(5093,296,1245,29,'12259',1,1),(5094,296,1246,29,'12262',1,1),(5095,296,1247,29,'12268',1,1),(5096,292,1210,28,'12150',1,NULL),(5097,292,1211,28,'12151',1,NULL),(5098,292,1212,28,'12153',1,1),(5099,292,1213,28,'12156',1,1),(5100,292,1214,28,'12157',1,1),(5101,292,1215,28,'12159',1,NULL),(5102,292,1216,28,'12162',1,1),(5103,292,1217,28,'12164',1,NULL),(5104,292,1218,28,'12165',1,NULL),(5105,292,1219,28,'12168',1,1),(5106,292,1220,28,'12172',1,1),(5107,292,1221,28,'12173',1,1),(5108,292,1222,28,'12181',1,1),(5109,292,1223,28,'12183',1,NULL),(5110,292,1224,28,'12398',1,NULL),(5111,292,1225,28,'12191',1,1),(5112,292,1226,28,'12200',1,1),(5113,292,1227,28,'12203',1,1),(5114,292,1228,28,'12209',1,NULL),(5115,292,1229,28,'12214',1,NULL),(5116,292,1210,28,'12149',2,1),(5117,292,1211,28,'12152',2,1),(5118,292,1212,28,'12153',2,1),(5119,292,1213,28,'12156',2,1),(5120,292,1214,28,'12157',2,1),(5121,292,1215,28,'12160',2,1),(5122,292,1216,28,'12162',2,1),(5123,292,1217,28,'12163',2,1),(5124,292,1218,28,'12166',2,1),(5125,292,1219,28,'12168',2,1),(5126,292,1220,28,'12172',2,1),(5127,292,1221,28,'12173',2,1),(5128,292,1222,28,'12181',2,1),(5129,292,1223,28,'12184',2,1),(5130,292,1224,28,'12397',2,NULL),(5131,292,1225,28,'12191',2,1),(5132,292,1226,28,'12200',2,1),(5133,292,1227,28,'12203',2,1),(5134,292,1228,28,'12208',2,NULL),(5135,292,1229,28,'12213',2,1),(5136,304,1230,29,'12216',1,1),(5137,304,1231,29,'12219',1,1),(5138,304,1232,29,'12220',1,1),(5139,304,1233,29,'12223',1,NULL),(5140,304,1234,29,'12225',1,1),(5141,304,1235,29,'12226',1,1),(5142,304,1236,29,'12229',1,1),(5143,304,1237,29,'12230',1,1),(5144,304,1238,29,'12233',1,1),(5145,304,1239,29,'12234',1,1),(5146,304,1240,29,'12240',1,1),(5147,304,1241,29,'12244',1,1),(5148,304,1242,29,'12246',1,1),(5149,304,1243,29,'12249',1,1),(5150,304,1244,29,'12256',1,1),(5151,304,1245,29,'12259',1,1),(5152,304,1246,29,'12262',1,1),(5153,304,1247,29,'12268',1,1),(5154,295,1248,30,'12269',1,1),(5155,295,1249,30,'12272',1,1),(5156,295,1250,30,'12273',1,1),(5157,295,1251,30,'12275',1,1),(5158,295,1252,30,'12278',1,1),(5159,295,1253,30,'12279',1,1),(5160,295,1254,30,'12281',1,1),(5161,295,1255,30,'12284',1,1),(5162,295,1256,30,'12286',1,1),(5163,295,1257,30,'12289',1,1),(5164,295,1258,30,'12291',1,1),(5165,295,1259,30,'12297',1,1),(5166,295,1260,30,'12302',1,1),(5167,295,1261,30,'12303',1,1),(5168,295,1262,30,'12310',1,1),(5169,295,1263,30,'12313',1,1),(5170,295,1264,30,'12319',1,1),(5171,295,1265,30,'12322',1,1),(5172,295,1266,30,'12325',1,1),(5173,295,1267,30,'12330',1,1),(5174,295,1268,30,'12335',1,1),(5175,293,1183,27,'12064',1,1),(5176,293,1184,27,'12069',1,1),(5177,293,1185,27,'12071',1,1),(5178,293,1186,27,'12072',1,1),(5179,293,1187,27,'12075',1,1),(5180,293,1188,27,'12077',1,1),(5181,293,1189,27,'12078',1,1),(5182,293,1190,27,'12081',1,1),(5183,293,1191,27,'12083',1,1),(5184,293,1192,27,'12085',1,1),(5185,293,1193,27,'12086',1,1),(5186,293,1194,27,'12088',1,1),(5187,293,1195,27,'12091',1,1),(5188,293,1196,27,'12092',1,1),(5189,293,1197,27,'12097',1,1),(5190,293,1198,27,'12102',1,1),(5191,293,1199,27,'12105',1,1),(5192,293,1200,27,'12112',1,1),(5193,293,1201,27,'12113',1,1),(5194,293,1202,27,'12119',1,1),(5195,293,1203,27,'12124',1,1),(5196,293,1204,27,'12126',1,1),(5197,293,1205,27,'12130',1,1),(5198,293,1206,27,'12136',1,1),(5199,293,1207,27,'12138',1,NULL),(5200,293,1208,27,'12144',1,1),(5201,293,1209,27,'12147',1,1),(5202,293,1210,28,'12149',1,1),(5203,293,1211,28,'12152',1,1),(5204,293,1212,28,'12153',1,1),(5205,293,1213,28,'12156',1,1),(5206,293,1214,28,'12157',1,1),(5207,293,1215,28,'12160',1,1),(5208,293,1216,28,'12162',1,1),(5209,293,1217,28,'12163',1,1),(5210,293,1218,28,'12165',1,NULL),(5211,293,1219,28,'12168',1,1),(5212,293,1220,28,'12172',1,1),(5213,293,1221,28,'12173',1,1),(5214,293,1222,28,'12181',1,1),(5215,293,1223,28,'12185',1,NULL),(5216,293,1224,28,'12400',1,1),(5217,293,1225,28,'12194',1,NULL),(5218,293,1226,28,'12200',1,1),(5219,293,1227,28,'12203',1,1),(5220,293,1228,28,'12207',1,1),(5221,293,1229,28,'12215',1,NULL),(5222,293,1210,28,'12149',2,1),(5223,293,1211,28,'12152',2,1),(5224,293,1212,28,'12153',2,1),(5225,293,1213,28,'12156',2,1),(5226,293,1214,28,'12157',2,1),(5227,293,1215,28,'12159',2,NULL),(5228,293,1216,28,'12162',2,1),(5229,293,1217,28,'12163',2,1),(5230,293,1218,28,'12166',2,1),(5231,293,1219,28,'12168',2,1),(5232,293,1220,28,'12172',2,1),(5233,293,1221,28,'12173',2,1),(5234,293,1222,28,'12181',2,1),(5235,293,1223,28,'12184',2,1),(5236,293,1224,28,'12400',2,1),(5237,293,1225,28,'12195',2,NULL),(5238,293,1226,28,'12200',2,1),(5239,293,1227,28,'12203',2,1),(5240,293,1228,28,'12207',2,1),(5241,293,1229,28,'12214',2,NULL),(5242,304,1248,30,'12269',1,1),(5243,304,1249,30,'12272',1,1),(5244,304,1250,30,'12273',1,1),(5245,304,1251,30,'12275',1,1),(5246,304,1252,30,'12278',1,1),(5247,304,1253,30,'12279',1,1),(5248,304,1254,30,'12281',1,1),(5249,304,1255,30,'12284',1,1),(5250,304,1256,30,'12286',1,1),(5251,304,1257,30,'12289',1,1),(5252,304,1258,30,'12291',1,1),(5253,304,1259,30,'12297',1,1),(5254,304,1260,30,'12302',1,1),(5255,304,1261,30,'12303',1,1),(5256,304,1262,30,'12310',1,1),(5257,304,1263,30,'12313',1,1),(5258,304,1264,30,'12318',1,NULL),(5259,304,1265,30,'12322',1,1),(5260,304,1266,30,'12325',1,1),(5261,304,1267,30,'12331',1,NULL),(5262,304,1268,30,'12335',1,1),(5263,296,1248,30,'12269',1,1),(5264,296,1249,30,'12272',1,1),(5265,296,1250,30,'12273',1,1),(5266,296,1251,30,'12275',1,1),(5267,296,1252,30,'12278',1,1),(5268,296,1253,30,'12279',1,1),(5269,296,1254,30,'12281',1,1),(5270,296,1255,30,'12284',1,1),(5271,296,1256,30,'12286',1,1),(5272,296,1257,30,'12289',1,1),(5273,296,1258,30,'12291',1,1),(5274,296,1259,30,'12297',1,1),(5275,296,1260,30,'12302',1,1),(5276,296,1261,30,'12303',1,1),(5277,296,1262,30,'12310',1,1),(5278,296,1263,30,'12313',1,1),(5279,296,1264,30,'12319',1,1),(5280,296,1265,30,'12322',1,1),(5281,296,1266,30,'12325',1,1),(5282,296,1267,30,'12330',1,1),(5283,296,1268,30,'12335',1,1),(5284,303,1280,31,'12363',1,1),(5285,303,1281,31,'12365',1,1),(5286,303,1282,31,'12368',1,NULL),(5287,303,1283,31,'12373',1,1),(5288,303,1284,31,'12378',1,1),(5289,303,1285,31,'12382',1,1),(5290,303,1286,31,'12387',1,1),(5291,303,1287,31,'12392',1,1),(5292,303,1288,31,'12393',1,NULL),(5293,303,1269,31,'12337',1,1),(5294,303,1270,31,'12338',1,NULL),(5295,303,1271,31,'12341',1,1),(5296,303,1272,31,'12343',1,1),(5297,303,1273,31,'12345',1,1),(5298,303,1274,31,'12346',1,1),(5299,303,1275,31,'12348',1,1),(5300,303,1276,31,'12350',1,1),(5301,303,1277,31,'12352',1,1),(5302,303,1278,31,'12354',1,1),(5303,303,1279,31,'12356',1,NULL),(5304,293,1230,29,'12216',1,1),(5305,293,1231,29,'12219',1,1),(5306,293,1232,29,'12220',1,1),(5307,293,1233,29,'12222',1,1),(5308,293,1234,29,'12225',1,1),(5309,293,1235,29,'12226',1,1),(5310,293,1236,29,'12229',1,1),(5311,293,1237,29,'12230',1,1),(5312,293,1238,29,'12233',1,1),(5313,293,1239,29,'12234',1,1),(5314,293,1240,29,'12240',1,1),(5315,293,1241,29,'12244',1,1),(5316,293,1242,29,'12246',1,1),(5317,293,1243,29,'12249',1,1),(5318,293,1244,29,'12256',1,1),(5319,293,1245,29,'12259',1,1),(5320,293,1246,29,'12262',1,1),(5321,293,1247,29,'12268',1,1),(5322,292,1230,29,'12216',1,1),(5323,292,1231,29,'12218',1,NULL),(5324,292,1232,29,'12221',1,NULL),(5325,292,1233,29,'12223',1,NULL),(5326,292,1234,29,'12225',1,1),(5327,292,1235,29,'12226',1,1),(5328,292,1236,29,'12229',1,1),(5329,292,1237,29,'12230',1,1),(5330,292,1238,29,'12233',1,1),(5331,292,1239,29,'12234',1,1),(5332,292,1240,29,'12240',1,1),(5333,292,1241,29,'12242',1,NULL),(5334,292,1242,29,'12248',1,NULL),(5335,292,1243,29,'12249',1,1),(5336,292,1244,29,'12256',1,1),(5337,292,1245,29,'12259',1,1),(5338,292,1246,29,'12263',1,NULL),(5339,292,1247,29,'12268',1,1),(5340,292,1230,29,'12216',2,1),(5341,292,1231,29,'12219',2,1),(5342,292,1232,29,'12220',2,1),(5343,292,1233,29,'12222',2,1),(5344,292,1234,29,'12225',2,1),(5345,292,1235,29,'12226',2,1),(5346,292,1236,29,'12229',2,1),(5347,292,1237,29,'12230',2,1),(5348,292,1238,29,'12233',2,1),(5349,292,1239,29,'12234',2,1),(5350,292,1240,29,'12240',2,1),(5351,292,1241,29,'12244',2,1),(5352,292,1242,29,'12246',2,1),(5353,292,1243,29,'12249',2,1),(5354,292,1244,29,'12256',2,1),(5355,292,1245,29,'12259',2,1),(5356,292,1246,29,'12262',2,1),(5357,292,1247,29,'12268',2,1),(5358,292,1248,30,'12269',1,1),(5359,292,1249,30,'12272',1,1),(5360,292,1250,30,'12273',1,1),(5361,292,1251,30,'12275',1,1),(5362,292,1252,30,'12278',1,1),(5363,292,1253,30,'12280',1,NULL),(5364,292,1254,30,'12282',1,NULL),(5365,292,1255,30,'12284',1,1),(5366,292,1256,30,'12285',1,NULL),(5367,292,1257,30,'12289',1,1),(5368,292,1258,30,'12291',1,1),(5369,292,1259,30,'12297',1,1),(5370,292,1260,30,'12302',1,1),(5371,292,1261,30,'12303',1,1),(5372,292,1262,30,'12310',1,1),(5373,292,1263,30,'12313',1,1),(5374,292,1264,30,'12319',1,1),(5375,292,1265,30,'12322',1,1),(5376,292,1266,30,'12325',1,1),(5377,292,1267,30,'12328',1,NULL),(5378,292,1268,30,'12335',1,1),(5379,293,1248,30,'12269',1,1),(5380,293,1249,30,'12272',1,1),(5381,293,1250,30,'12273',1,1),(5382,293,1251,30,'12275',1,1),(5383,293,1252,30,'12278',1,1),(5384,293,1253,30,'12279',1,1),(5385,293,1254,30,'12281',1,1),(5386,293,1255,30,'12284',1,1),(5387,293,1256,30,'12286',1,1),(5388,293,1257,30,'12289',1,1),(5389,293,1258,30,'12291',1,1),(5390,293,1259,30,'12297',1,1),(5391,293,1260,30,'12301',1,NULL),(5392,293,1261,30,'12303',1,1),(5393,293,1262,30,'12310',1,1),(5394,293,1263,30,'12313',1,1),(5395,293,1264,30,'12319',1,1),(5396,293,1265,30,'12322',1,1),(5397,293,1266,30,'12325',1,1),(5398,293,1267,30,'12330',1,1),(5399,293,1268,30,'12335',1,1),(5400,301,1183,27,'12064',1,1),(5401,301,1184,27,'12068',1,NULL),(5402,301,1185,27,'12071',1,1),(5403,301,1186,27,'12072',1,1),(5404,301,1187,27,'12074',1,NULL),(5405,301,1188,27,'12077',1,1),(5406,301,1189,27,'12078',1,1),(5407,301,1190,27,'12081',1,1),(5408,301,1191,27,'12083',1,1),(5409,301,1192,27,'12084',1,NULL),(5410,301,1193,27,'12086',1,1),(5411,301,1194,27,'12088',1,1),(5412,301,1195,27,'12091',1,1),(5413,301,1196,27,'12092',1,1),(5414,301,1197,27,'12097',1,1),(5415,301,1198,27,'12102',1,1),(5416,301,1199,27,'12105',1,1),(5417,301,1200,27,'12112',1,1),(5418,301,1201,27,'12113',1,1),(5419,301,1202,27,'12119',1,1),(5420,301,1203,27,'12124',1,1),(5421,301,1204,27,'12126',1,1),(5422,301,1205,27,'12129',1,NULL),(5423,301,1206,27,'12136',1,1),(5424,301,1207,27,'12139',1,1),(5425,301,1208,27,'12144',1,1),(5426,301,1209,27,'12147',1,1),(5427,304,1280,31,'12363',1,1),(5428,304,1281,31,'12365',1,1),(5429,304,1282,31,'12368',1,NULL),(5430,304,1283,31,'12373',1,1),(5431,304,1284,31,'12378',1,1),(5432,304,1285,31,'12380',1,NULL),(5433,304,1286,31,'12388',1,NULL),(5434,304,1287,31,'12392',1,1),(5435,304,1288,31,'12394',1,1),(5436,304,1269,31,'12337',1,1),(5437,304,1270,31,'12339',1,1),(5438,304,1271,31,'12341',1,1),(5439,304,1272,31,'12343',1,1),(5440,304,1273,31,'12344',1,NULL),(5441,304,1274,31,'12346',1,1),(5442,304,1275,31,'12348',1,1),(5443,304,1276,31,'12350',1,1),(5444,304,1277,31,'12352',1,1),(5445,304,1278,31,'12354',1,1),(5446,304,1279,31,'12357',1,1),(5447,295,1210,28,'12149',1,1),(5448,295,1211,28,'12152',1,1),(5449,295,1212,28,'12153',1,1),(5450,295,1213,28,'12156',1,1),(5451,295,1214,28,'12157',1,1),(5452,295,1215,28,'12160',1,1),(5453,295,1216,28,'12162',1,1),(5454,295,1217,28,'12163',1,1),(5455,295,1218,28,'12166',1,1),(5456,295,1219,28,'12168',1,1),(5457,295,1220,28,'12172',1,1),(5458,295,1221,28,'12173',1,1),(5459,295,1222,28,'12181',1,1),(5460,295,1223,28,'12184',1,1),(5461,295,1224,28,'12400',1,1),(5462,295,1225,28,'12191',1,1),(5463,295,1226,28,'12200',1,1),(5464,295,1227,28,'12203',1,1),(5465,295,1228,28,'12207',1,1),(5466,295,1229,28,'12213',1,1),(5467,309,1210,28,'12149',1,1),(5468,309,1211,28,'12152',1,1),(5469,309,1212,28,'12153',1,1),(5470,309,1213,28,'12156',1,1),(5471,309,1214,28,'12157',1,1),(5472,309,1215,28,'12160',1,1),(5473,309,1216,28,'12162',1,1),(5474,309,1217,28,'12163',1,1),(5475,309,1218,28,'12166',1,1),(5476,309,1219,28,'12168',1,1),(5477,309,1220,28,'12172',1,1),(5478,309,1221,28,'12173',1,1),(5479,309,1222,28,'12177',1,NULL),(5480,309,1223,28,'12182',1,NULL),(5481,309,1224,28,'12400',1,1),(5482,309,1225,28,'12191',1,1),(5483,309,1226,28,'12200',1,1),(5484,309,1227,28,'12203',1,1),(5485,309,1228,28,'12207',1,1),(5486,309,1229,28,'12213',1,1),(5487,301,1210,28,'12149',1,1),(5488,301,1211,28,'12152',1,1),(5489,301,1212,28,'12154',1,NULL),(5490,301,1213,28,'12156',1,1),(5491,301,1214,28,'12158',1,NULL),(5492,301,1215,28,'12160',1,1),(5493,301,1216,28,'12162',1,1),(5494,301,1217,28,'12163',1,1),(5495,301,1218,28,'12166',1,1),(5496,301,1219,28,'12168',1,1),(5497,301,1220,28,'12172',1,1),(5498,301,1221,28,'12173',1,1),(5499,301,1222,28,'12181',1,1),(5500,301,1223,28,'12185',1,NULL),(5501,301,1224,28,'12400',1,1),(5502,301,1225,28,'12191',1,1),(5503,301,1226,28,'12200',1,1),(5504,301,1227,28,'12203',1,1),(5505,301,1228,28,'12207',1,1),(5506,301,1229,28,'12215',1,NULL),(5507,293,1280,31,'12363',1,1),(5508,293,1281,31,'12365',1,1),(5509,293,1282,31,'12371',1,1),(5510,293,1283,31,'12373',1,1),(5511,293,1284,31,'12378',1,1),(5512,293,1285,31,'12382',1,1),(5513,293,1286,31,'12387',1,1),(5514,293,1287,31,'12392',1,1),(5515,293,1288,31,'12394',1,1),(5516,293,1269,31,'12337',1,1),(5517,293,1270,31,'12339',1,1),(5518,293,1271,31,'12340',1,NULL),(5519,293,1272,31,'12343',1,1),(5520,293,1273,31,'12345',1,1),(5521,293,1274,31,'12346',1,1),(5522,293,1275,31,'12348',1,1),(5523,293,1276,31,'12350',1,1),(5524,293,1277,31,'12352',1,1),(5525,293,1278,31,'12354',1,1),(5526,293,1279,31,'12357',1,1),(5527,305,1183,27,'12064',1,1),(5528,305,1184,27,'12069',1,1),(5529,305,1185,27,'12070',1,NULL),(5530,305,1186,27,'12072',1,1),(5531,305,1187,27,'12074',1,NULL),(5532,305,1188,27,'12077',1,1),(5533,305,1189,27,'12078',1,1),(5534,305,1190,27,'12081',1,1),(5535,305,1191,27,'12083',1,1),(5536,305,1192,27,'12084',1,NULL),(5537,305,1193,27,'12086',1,1),(5538,305,1194,27,'12088',1,1),(5539,305,1195,27,'12091',1,1),(5540,305,1196,27,'12092',1,1),(5541,305,1197,27,'12097',1,1),(5542,305,1198,27,'12100',1,NULL),(5543,305,1199,27,'12105',1,1),(5544,305,1200,27,'12112',1,1),(5545,305,1201,27,'12115',1,NULL),(5546,305,1202,27,'12119',1,1),(5547,305,1203,27,'12124',1,1),(5548,305,1204,27,'12126',1,1),(5549,305,1205,27,'12130',1,1),(5550,305,1206,27,'12136',1,1),(5551,305,1207,27,'12139',1,1),(5552,305,1208,27,'12144',1,1),(5553,305,1209,27,'12147',1,1),(5554,292,1280,31,'12361',1,NULL),(5555,292,1281,31,'12365',1,1),(5556,292,1282,31,'12368',1,NULL),(5557,292,1283,31,'12375',1,NULL),(5558,292,1284,31,'12378',1,1),(5559,292,1285,31,'12381',1,NULL),(5560,292,1286,31,'12387',1,1),(5561,292,1287,31,'12392',1,1),(5562,292,1288,31,'12395',1,NULL),(5563,292,1269,31,'12337',1,1),(5564,292,1270,31,'12338',1,NULL),(5565,292,1271,31,'12341',1,1),(5566,292,1272,31,'12343',1,1),(5567,292,1273,31,'12344',1,NULL),(5568,292,1274,31,'12346',1,1),(5569,292,1275,31,'12348',1,1),(5570,292,1276,31,'12350',1,1),(5571,292,1277,31,'12352',1,1),(5572,292,1278,31,'12354',1,1),(5573,292,1279,31,'12356',1,NULL),(5574,292,1280,31,'12363',2,1),(5575,292,1281,31,'12365',2,1),(5576,292,1282,31,'12371',2,1),(5577,292,1283,31,'12373',2,1),(5578,292,1284,31,'12378',2,1),(5579,292,1285,31,'12382',2,1),(5580,292,1286,31,'12387',2,1),(5581,292,1287,31,'12392',2,1),(5582,292,1288,31,'12394',2,1),(5583,292,1269,31,'12337',2,1),(5584,292,1270,31,'12339',2,1),(5585,292,1271,31,'12341',2,1),(5586,292,1272,31,'12343',2,1),(5587,292,1273,31,'12344',2,NULL),(5588,292,1274,31,'12346',2,1),(5589,292,1275,31,'12348',2,1),(5590,292,1276,31,'12350',2,1),(5591,292,1277,31,'12352',2,1),(5592,292,1278,31,'12354',2,1),(5593,292,1279,31,'12357',2,1),(5594,308,1183,27,'12065',1,NULL),(5595,308,1184,27,'12069',1,1),(5596,308,1185,27,'12071',1,1),(5597,308,1186,27,'12072',1,1),(5598,308,1187,27,'12074',1,NULL),(5599,308,1188,27,'12077',1,1),(5600,308,1189,27,'12078',1,1),(5601,308,1190,27,'12081',1,1),(5602,308,1191,27,'12083',1,1),(5603,308,1192,27,'12085',1,1),(5604,308,1193,27,'12086',1,1),(5605,308,1194,27,'12088',1,1),(5606,308,1195,27,'12091',1,1),(5607,308,1196,27,'12092',1,1),(5608,308,1197,27,'12097',1,1),(5609,308,1198,27,'12102',1,1),(5610,308,1199,27,'12105',1,1),(5611,308,1200,27,'12112',1,1),(5612,308,1201,27,'12116',1,NULL),(5613,308,1202,27,'12119',1,1),(5614,308,1203,27,'12124',1,1),(5615,308,1204,27,'12126',1,1),(5616,308,1205,27,'12130',1,1),(5617,308,1206,27,'12136',1,1),(5618,308,1207,27,'12139',1,1),(5619,308,1208,27,'12144',1,1),(5620,308,1209,27,'12147',1,1),(5621,308,1210,28,'12149',1,1),(5622,308,1211,28,'12152',1,1),(5623,308,1212,28,'12153',1,1),(5624,308,1213,28,'12156',1,1),(5625,308,1214,28,'12157',1,1),(5626,308,1215,28,'12160',1,1),(5627,308,1216,28,'12162',1,1),(5628,308,1217,28,'12164',1,NULL),(5629,308,1218,28,'12166',1,1),(5630,308,1219,28,'12168',1,1),(5631,308,1220,28,'12172',1,1),(5632,308,1221,28,'12173',1,1),(5633,308,1222,28,'12181',1,1),(5634,308,1223,28,'12182',1,NULL),(5635,308,1224,28,'12400',1,1),(5636,308,1225,28,'12191',1,1),(5637,308,1226,28,'12200',1,1),(5638,308,1227,28,'12203',1,1),(5639,308,1228,28,'12207',1,1),(5640,308,1229,28,'12214',1,NULL),(5641,308,1230,29,'12216',1,1),(5642,308,1231,29,'12218',1,NULL),(5643,308,1232,29,'12220',1,1),(5644,308,1233,29,'12222',1,1),(5645,308,1234,29,'12224',1,NULL),(5646,308,1235,29,'12226',1,1),(5647,308,1236,29,'12229',1,1),(5648,308,1237,29,'12230',1,1),(5649,308,1238,29,'12233',1,1),(5650,308,1239,29,'12234',1,1),(5651,308,1240,29,'12240',1,1),(5652,308,1241,29,'12241',1,NULL),(5653,308,1242,29,'12248',1,NULL),(5654,308,1243,29,'12249',1,1),(5655,308,1244,29,'12256',1,1),(5656,308,1245,29,'12259',1,1),(5657,308,1246,29,'12263',1,NULL),(5658,308,1247,29,'12268',1,1),(5659,308,1230,29,'12216',2,1),(5660,308,1231,29,'12219',2,1),(5661,308,1232,29,'12220',2,1),(5662,308,1233,29,'12222',2,1),(5663,308,1234,29,'12225',2,1),(5664,308,1235,29,'12226',2,1),(5665,308,1236,29,'12229',2,1),(5666,308,1237,29,'12230',2,1),(5667,308,1238,29,'12233',2,1),(5668,308,1239,29,'12234',2,1),(5669,308,1240,29,'12240',2,1),(5670,308,1241,29,'12242',2,NULL),(5671,308,1242,29,'12245',2,NULL),(5672,308,1243,29,'12249',2,1),(5673,308,1244,29,'12256',2,1),(5674,308,1245,29,'12259',2,1),(5675,308,1246,29,'12261',2,NULL),(5676,308,1247,29,'12268',2,1),(5677,308,1248,30,'12269',1,1),(5678,308,1249,30,'12272',1,1),(5679,308,1250,30,'12273',1,1),(5680,308,1251,30,'12275',1,1),(5681,308,1252,30,'12278',1,1),(5682,308,1253,30,'12279',1,1),(5683,308,1254,30,'12281',1,1),(5684,308,1255,30,'12284',1,1),(5685,308,1256,30,'12286',1,1),(5686,308,1257,30,'12289',1,1),(5687,308,1258,30,'12291',1,1),(5688,308,1259,30,'12298',1,NULL),(5689,308,1260,30,'12302',1,1),(5690,308,1261,30,'12303',1,1),(5691,308,1262,30,'12310',1,1),(5692,308,1263,30,'12313',1,1),(5693,308,1264,30,'12318',1,NULL),(5694,308,1265,30,'12322',1,1),(5695,308,1266,30,'12325',1,1),(5696,308,1267,30,'12330',1,1),(5697,308,1268,30,'12332',1,NULL),(5698,295,1280,31,'12363',1,1),(5699,295,1281,31,'12365',1,1),(5700,295,1282,31,'12371',1,1),(5701,295,1283,31,'12373',1,1),(5702,295,1284,31,'12378',1,1),(5703,295,1285,31,'12382',1,1),(5704,295,1286,31,'12387',1,1),(5705,295,1287,31,'12392',1,1),(5706,295,1288,31,'12394',1,1),(5707,295,1269,31,'12337',1,1),(5708,295,1270,31,'12339',1,1),(5709,295,1271,31,'12341',1,1),(5710,295,1272,31,'12343',1,1),(5711,295,1273,31,'12344',1,NULL),(5712,295,1274,31,'12346',1,1),(5713,295,1275,31,'12348',1,1),(5714,295,1276,31,'12350',1,1),(5715,295,1277,31,'12352',1,1),(5716,295,1278,31,'12354',1,1),(5717,295,1279,31,'12357',1,1),(5718,295,1230,29,'12216',1,1),(5719,295,1231,29,'12219',1,1),(5720,295,1232,29,'12220',1,1),(5721,295,1233,29,'12222',1,1),(5722,295,1234,29,'12225',1,1),(5723,295,1235,29,'12226',1,1),(5724,295,1236,29,'12229',1,1),(5725,295,1237,29,'12231',1,NULL),(5726,295,1238,29,'12233',1,1),(5727,295,1239,29,'12234',1,1),(5728,295,1240,29,'12240',1,1),(5729,295,1241,29,'12244',1,1),(5730,295,1242,29,'12246',1,1),(5731,295,1243,29,'12249',1,1),(5732,295,1244,29,'12256',1,1),(5733,295,1245,29,'12259',1,1),(5734,295,1246,29,'12262',1,1),(5735,295,1247,29,'12268',1,1),(5736,295,1183,27,'12064',1,1),(5737,295,1184,27,'12069',1,1),(5738,295,1185,27,'12071',1,1),(5739,295,1186,27,'12072',1,1),(5740,295,1187,27,'12075',1,1),(5741,295,1188,27,'12077',1,1),(5742,295,1189,27,'12078',1,1),(5743,295,1190,27,'12081',1,1),(5744,295,1191,27,'12083',1,1),(5745,295,1192,27,'12084',1,NULL),(5746,295,1193,27,'12086',1,1),(5747,295,1194,27,'12088',1,1),(5748,295,1195,27,'12091',1,1),(5749,295,1196,27,'12092',1,1),(5750,295,1197,27,'12097',1,1),(5751,295,1198,27,'12102',1,1),(5752,295,1199,27,'12105',1,1),(5753,295,1200,27,'12112',1,1),(5754,295,1201,27,'12113',1,1),(5755,295,1202,27,'12119',1,1),(5756,295,1203,27,'12124',1,1),(5757,295,1204,27,'12126',1,1),(5758,295,1205,27,'12130',1,1),(5759,295,1206,27,'12136',1,1),(5760,295,1207,27,'12139',1,1),(5761,295,1208,27,'12144',1,1),(5762,295,1209,27,'12147',1,1),(5763,296,1280,31,'12363',1,1),(5764,296,1281,31,'12365',1,1),(5765,296,1282,31,'12368',1,NULL),(5766,296,1283,31,'12373',1,1),(5767,296,1284,31,'12378',1,1),(5768,296,1285,31,'12382',1,1),(5769,296,1286,31,'12387',1,1),(5770,296,1287,31,'12392',1,1),(5771,296,1288,31,'12394',1,1),(5772,296,1269,31,'12337',1,1),(5773,296,1270,31,'12339',1,1),(5774,296,1271,31,'12341',1,1),(5775,296,1272,31,'12343',1,1),(5776,296,1273,31,'12344',1,NULL),(5777,296,1274,31,'12346',1,1),(5778,296,1275,31,'12348',1,1),(5779,296,1276,31,'12350',1,1),(5780,296,1277,31,'12352',1,1),(5781,296,1278,31,'12354',1,1),(5782,296,1279,31,'12359',1,NULL),(5783,301,1230,29,'12216',1,1),(5784,301,1231,29,'12219',1,1),(5785,301,1232,29,'12221',1,NULL),(5786,301,1233,29,'12223',1,NULL),(5787,301,1234,29,'12225',1,1),(5788,301,1235,29,'12226',1,1),(5789,301,1236,29,'12228',1,NULL),(5790,301,1237,29,'12230',1,1),(5791,301,1238,29,'12233',1,1),(5792,301,1239,29,'12234',1,1),(5793,301,1240,29,'12240',1,1),(5794,301,1241,29,'12242',1,NULL),(5795,301,1242,29,'12245',1,NULL),(5796,301,1243,29,'12249',1,1),(5797,301,1244,29,'12256',1,1),(5798,301,1245,29,'12259',1,1),(5799,301,1246,29,'12262',1,1),(5800,301,1247,29,'12268',1,1),(5801,301,1230,29,'12216',2,1),(5802,301,1231,29,'12219',2,1),(5803,301,1232,29,'12220',2,1),(5804,301,1233,29,'12222',2,1),(5805,301,1234,29,'12225',2,1),(5806,301,1235,29,'12226',2,1),(5807,301,1236,29,'12229',2,1),(5808,301,1237,29,'12230',2,1),(5809,301,1238,29,'12233',2,1),(5810,301,1239,29,'12234',2,1),(5811,301,1240,29,'12240',2,1),(5812,301,1241,29,'12241',2,NULL),(5813,301,1242,29,'12248',2,NULL),(5814,301,1243,29,'12249',2,1),(5815,301,1245,29,'12259',2,1),(5816,301,1246,29,'12262',2,1),(5817,301,1247,29,'12268',2,1),(5818,305,1210,28,'12149',1,1),(5819,305,1211,28,'12152',1,1),(5820,305,1212,28,'12153',1,1),(5821,305,1213,28,'12156',1,1),(5822,305,1214,28,'12157',1,1),(5823,305,1215,28,'12160',1,1),(5824,305,1216,28,'12162',1,1),(5825,305,1217,28,'12163',1,1),(5826,305,1218,28,'12166',1,1),(5827,305,1219,28,'12168',1,1),(5828,305,1220,28,'12172',1,1),(5829,305,1221,28,'12173',1,1),(5830,305,1222,28,'12181',1,1),(5831,305,1223,28,'12182',1,NULL),(5832,305,1224,28,'12400',1,1),(5833,305,1225,28,'12191',1,1),(5834,305,1226,28,'12200',1,1),(5835,305,1227,28,'12203',1,1),(5836,305,1228,28,'12209',1,NULL),(5837,305,1229,28,'12213',1,1),(5838,301,1248,30,'12269',1,1),(5839,301,1249,30,'12272',1,1),(5840,301,1250,30,'12273',1,1),(5841,301,1251,30,'12275',1,1),(5842,301,1252,30,'12278',1,1),(5843,301,1253,30,'12279',1,1),(5844,301,1254,30,'12281',1,1),(5845,301,1255,30,'12284',1,1),(5846,301,1256,30,'12286',1,1),(5847,301,1257,30,'12289',1,1),(5848,301,1258,30,'12291',1,1),(5849,301,1259,30,'12297',1,1),(5850,301,1260,30,'12302',1,1),(5851,301,1261,30,'12303',1,1),(5852,301,1262,30,'12310',1,1),(5853,301,1263,30,'12313',1,1),(5854,301,1264,30,'12319',1,1),(5855,301,1265,30,'12322',1,1),(5856,301,1266,30,'12325',1,1),(5857,301,1267,30,'12331',1,NULL),(5858,301,1268,30,'12335',1,1),(5859,305,1230,29,'12216',1,1),(5860,305,1231,29,'12218',1,NULL),(5861,305,1232,29,'12220',1,1),(5862,305,1233,29,'12223',1,NULL),(5863,305,1234,29,'12225',1,1),(5864,305,1235,29,'12226',1,1),(5865,305,1236,29,'12229',1,1),(5866,305,1237,29,'12230',1,1),(5867,305,1238,29,'12232',1,NULL),(5868,305,1239,29,'12234',1,1),(5869,305,1240,29,'12240',1,1),(5870,305,1241,29,'12241',1,NULL),(5871,305,1242,29,'12246',1,1),(5872,305,1243,29,'12249',1,1),(5873,305,1244,29,'12253',1,NULL),(5874,305,1245,29,'12259',1,1),(5875,305,1246,29,'12263',1,NULL),(5876,305,1247,29,'12268',1,1),(5877,305,1230,29,'12216',2,1),(5878,305,1231,29,'12219',2,1),(5879,305,1232,29,'12220',2,1),(5880,305,1233,29,'12222',2,1),(5881,305,1234,29,'12225',2,1),(5882,305,1235,29,'12226',2,1),(5883,305,1236,29,'12229',2,1),(5884,305,1237,29,'12230',2,1),(5885,305,1238,29,'12233',2,1),(5886,305,1239,29,'12234',2,1),(5887,305,1240,29,'12240',2,1),(5888,305,1241,29,'12242',2,NULL),(5889,305,1242,29,'12246',2,1),(5890,305,1243,29,'12249',2,1),(5891,305,1244,29,'12255',2,NULL),(5892,305,1245,29,'12259',2,1),(5893,305,1246,29,'12262',2,1),(5894,305,1247,29,'12268',2,1),(5895,308,1280,31,'12363',1,1),(5896,308,1281,31,'12365',1,1),(5897,308,1282,31,'12368',1,NULL),(5898,308,1283,31,'12373',1,1),(5899,308,1284,31,'12376',1,NULL),(5900,308,1285,31,'12380',1,NULL),(5901,308,1286,31,'12387',1,1),(5902,308,1287,31,'12392',1,1),(5903,308,1288,31,'12395',1,NULL),(5904,308,1269,31,'12337',1,1),(5905,308,1270,31,'12339',1,1),(5906,308,1271,31,'12341',1,1),(5907,308,1272,31,'12343',1,1),(5908,308,1273,31,'12344',1,NULL),(5909,308,1274,31,'12346',1,1),(5910,308,1275,31,'12349',1,NULL),(5911,308,1276,31,'12350',1,1),(5912,308,1277,31,'12352',1,1),(5913,308,1278,31,'12354',1,1),(5914,308,1279,31,'12357',1,1),(5915,308,1280,31,'12363',2,1),(5916,308,1281,31,'12365',2,1),(5917,308,1282,31,'12371',2,1),(5918,308,1283,31,'12373',2,1),(5919,308,1284,31,'12379',2,NULL),(5920,308,1285,31,'12381',2,NULL),(5921,308,1286,31,'12387',2,1),(5922,308,1287,31,'12392',2,1),(5923,308,1288,31,'12394',2,1),(5924,308,1269,31,'12337',2,1),(5925,308,1270,31,'12339',2,1),(5926,308,1271,31,'12341',2,1),(5927,308,1272,31,'12343',2,1),(5928,308,1273,31,'12345',2,1),(5929,308,1274,31,'12346',2,1),(5930,308,1275,31,'12348',2,1),(5931,308,1276,31,'12350',2,1),(5932,308,1277,31,'12352',2,1),(5933,308,1278,31,'12354',2,1),(5934,308,1279,31,'12357',2,1),(5935,309,1230,29,'12216',1,1),(5936,309,1231,29,'12219',1,1),(5937,309,1232,29,'12220',1,1),(5938,309,1233,29,'12223',1,NULL),(5939,309,1234,29,'12225',1,1),(5940,309,1235,29,'12226',1,1),(5941,309,1236,29,'12228',1,NULL),(5942,309,1237,29,'12230',1,1),(5943,309,1238,29,'12232',1,NULL),(5944,309,1239,29,'12234',1,1),(5945,309,1240,29,'12240',1,1),(5946,309,1241,29,'12241',1,NULL),(5947,309,1242,29,'12246',1,1),(5948,309,1243,29,'12249',1,1),(5949,309,1244,29,'12256',1,1),(5950,309,1245,29,'12259',1,1),(5951,309,1246,29,'12262',1,1),(5952,309,1247,29,'12268',1,1),(5953,309,1230,29,'12216',2,1),(5954,309,1231,29,'12219',2,1),(5955,309,1232,29,'12220',2,1),(5956,309,1233,29,'12222',2,1),(5957,309,1234,29,'12225',2,1),(5958,309,1235,29,'12226',2,1),(5959,309,1236,29,'12229',2,1),(5960,309,1237,29,'12230',2,1),(5961,309,1238,29,'12233',2,1),(5962,309,1239,29,'12234',2,1),(5963,309,1240,29,'12240',2,1),(5964,309,1241,29,'12242',2,NULL),(5965,309,1242,29,'12246',2,1),(5966,309,1243,29,'12249',2,1),(5967,309,1244,29,'12256',2,1),(5968,309,1245,29,'12259',2,1),(5969,309,1246,29,'12262',2,1),(5970,309,1247,29,'12268',2,1),(5971,309,1248,30,'12269',1,1),(5972,309,1249,30,'12272',1,1),(5973,309,1250,30,'12273',1,1),(5974,309,1251,30,'12275',1,1),(5975,309,1252,30,'12278',1,1),(5976,309,1253,30,'12279',1,1),(5977,309,1254,30,'12281',1,1),(5978,309,1255,30,'12284',1,1),(5979,309,1256,30,'12286',1,1),(5980,309,1257,30,'12290',1,NULL),(5981,309,1258,30,'12291',1,1),(5982,309,1259,30,'12297',1,1),(5983,309,1260,30,'12302',1,1),(5984,309,1261,30,'12307',1,NULL),(5985,309,1262,30,'12310',1,1),(5986,309,1263,30,'12313',1,1),(5987,309,1264,30,'12318',1,NULL),(5988,309,1265,30,'12322',1,1),(5989,309,1266,30,'12325',1,1),(5990,309,1267,30,'12329',1,NULL),(5991,309,1268,30,'12335',1,1),(5992,309,1280,31,'12363',1,1),(5993,309,1281,31,'12365',1,1),(5994,309,1282,31,'12368',1,NULL),(5995,309,1283,31,'12374',1,NULL),(5996,309,1284,31,'12378',1,1),(5997,309,1285,31,'12380',1,NULL),(5998,309,1286,31,'12388',1,NULL),(5999,309,1287,31,'12392',1,1),(6000,309,1288,31,'12396',1,NULL),(6001,309,1269,31,'12337',1,1),(6002,309,1270,31,'12338',1,NULL),(6003,309,1271,31,'12341',1,1),(6004,309,1272,31,'12343',1,1),(6005,309,1273,31,'12344',1,NULL),(6006,309,1274,31,'12346',1,1),(6007,309,1275,31,'12348',1,1),(6008,309,1276,31,'12350',1,1),(6009,309,1277,31,'12352',1,1),(6010,309,1278,31,'12354',1,1),(6011,309,1279,31,'12357',1,1),(6012,309,1280,31,'12363',2,1),(6013,309,1281,31,'12365',2,1),(6014,309,1282,31,'12369',2,NULL),(6015,309,1283,31,'12372',2,NULL),(6016,309,1284,31,'12378',2,1),(6017,309,1285,31,'12381',2,NULL),(6018,309,1286,31,'12387',2,1),(6019,309,1287,31,'12392',2,1),(6020,309,1288,31,'12395',2,NULL),(6021,309,1269,31,'12337',2,1),(6022,309,1270,31,'12339',2,1),(6023,309,1271,31,'12341',2,1),(6024,309,1272,31,'12343',2,1),(6025,309,1273,31,'12345',2,1),(6026,309,1274,31,'12346',2,1),(6027,309,1275,31,'12348',2,1),(6028,309,1276,31,'12350',2,1),(6029,309,1277,31,'12352',2,1),(6030,309,1278,31,'12354',2,1),(6031,309,1279,31,'12357',2,1),(6032,309,1280,31,'12363',3,1),(6033,309,1281,31,'12365',3,1),(6034,309,1282,31,'12369',3,NULL),(6035,309,1283,31,'12372',3,NULL),(6036,309,1284,31,'12378',3,1),(6037,309,1285,31,'12381',3,NULL),(6038,309,1286,31,'12387',3,1),(6039,309,1287,31,'12392',3,1),(6040,309,1288,31,'12395',3,NULL),(6041,309,1269,31,'12337',3,1),(6042,309,1270,31,'12339',3,1),(6043,309,1271,31,'12341',3,1),(6044,309,1272,31,'12343',3,1),(6045,309,1273,31,'12345',3,1),(6046,309,1274,31,'12346',3,1),(6047,309,1275,31,'12348',3,1),(6048,309,1276,31,'12350',3,1),(6049,309,1277,31,'12352',3,1),(6050,309,1278,31,'12354',3,1),(6051,309,1279,31,'12357',3,1),(6052,301,1280,31,'12363',1,1),(6053,301,1281,31,'12365',1,1),(6054,301,1282,31,'12371',1,1),(6055,301,1283,31,'12373',1,1),(6056,301,1284,31,'12378',1,1),(6057,301,1285,31,'12380',1,NULL),(6058,301,1286,31,'12387',1,1),(6059,301,1287,31,'12391',1,NULL),(6060,301,1288,31,'12393',1,NULL),(6061,301,1269,31,'12337',1,1),(6062,301,1270,31,'12339',1,1),(6063,301,1271,31,'12341',1,1),(6064,301,1272,31,'12343',1,1),(6065,301,1273,31,'12344',1,NULL),(6066,301,1274,31,'12346',1,1),(6067,301,1275,31,'12348',1,1),(6068,301,1276,31,'12350',1,1),(6069,301,1277,31,'12352',1,1),(6070,301,1278,31,'12355',1,NULL),(6071,301,1279,31,'12357',1,1),(6072,301,1280,31,'12363',2,1),(6073,301,1281,31,'12365',2,1),(6074,301,1282,31,'12371',2,1),(6075,301,1283,31,'12373',2,1),(6076,301,1284,31,'12378',2,1),(6077,301,1285,31,'12382',2,1),(6078,301,1286,31,'12387',2,1),(6079,301,1287,31,'12392',2,1),(6080,301,1288,31,'12395',2,NULL),(6081,301,1269,31,'12337',2,1),(6082,301,1271,31,'12341',2,1),(6083,301,1272,31,'12343',2,1),(6084,301,1273,31,'12345',2,1),(6085,301,1274,31,'12346',2,1),(6086,301,1275,31,'12348',2,1),(6087,301,1276,31,'12350',2,1),(6088,301,1277,31,'12352',2,1),(6089,301,1278,31,'12354',2,1),(6090,301,1279,31,'12357',2,1),(6091,297,1210,28,'12149',1,1),(6092,297,1211,28,'12152',1,1),(6093,297,1212,28,'12153',1,1),(6094,297,1213,28,'12156',1,1),(6095,297,1214,28,'12157',1,1),(6096,297,1215,28,'12160',1,1),(6097,297,1216,28,'12162',1,1),(6098,297,1217,28,'12163',1,1),(6099,297,1218,28,'12165',1,NULL),(6100,297,1219,28,'12168',1,1),(6101,297,1220,28,'12172',1,1),(6102,297,1221,28,'12173',1,1),(6103,297,1222,28,'12181',1,1),(6104,297,1223,28,'12183',1,NULL),(6105,297,1224,28,'12400',1,1),(6106,297,1225,28,'12191',1,1),(6107,297,1226,28,'12200',1,1),(6108,297,1227,28,'12203',1,1),(6109,297,1228,28,'12207',1,1),(6110,297,1229,28,'12213',1,1),(6111,299,1183,27,'12064',1,1),(6112,299,1184,27,'12069',1,1),(6113,299,1185,27,'12071',1,1),(6114,299,1186,27,'12072',1,1),(6115,299,1187,27,'12074',1,NULL),(6116,299,1188,27,'12077',1,1),(6117,299,1189,27,'12078',1,1),(6118,299,1190,27,'12081',1,1),(6119,299,1191,27,'12083',1,1),(6120,299,1192,27,'12084',1,NULL),(6121,299,1193,27,'12086',1,1),(6122,299,1194,27,'12088',1,1),(6123,299,1195,27,'12091',1,1),(6124,299,1196,27,'12092',1,1),(6125,299,1197,27,'12096',1,NULL),(6126,299,1198,27,'12102',1,1),(6127,299,1199,27,'12105',1,1),(6128,299,1200,27,'12112',1,1),(6129,299,1201,27,'12115',1,NULL),(6130,299,1202,27,'12119',1,1),(6131,299,1203,27,'12124',1,1),(6132,299,1204,27,'12126',1,1),(6133,299,1205,27,'12130',1,1),(6134,299,1206,27,'12136',1,1),(6135,299,1207,27,'12138',1,NULL),(6136,299,1208,27,'12144',1,1),(6137,299,1209,27,'12147',1,1),(6138,305,1248,30,'12269',1,1),(6139,305,1249,30,'12272',1,1),(6140,305,1250,30,'12273',1,1),(6141,305,1251,30,'12275',1,1),(6142,305,1252,30,'12278',1,1),(6143,305,1253,30,'12279',1,1),(6144,305,1254,30,'12281',1,1),(6145,305,1255,30,'12284',1,1),(6146,305,1256,30,'12285',1,NULL),(6147,305,1257,30,'12289',1,1),(6148,305,1258,30,'12291',1,1),(6149,305,1259,30,'12297',1,1),(6150,305,1260,30,'12302',1,1),(6151,305,1261,30,'12303',1,1),(6152,305,1262,30,'12311',1,NULL),(6153,305,1263,30,'12313',1,1),(6154,305,1264,30,'12317',1,NULL),(6155,305,1265,30,'12322',1,1),(6156,305,1266,30,'12326',1,NULL),(6157,305,1267,30,'12330',1,1),(6158,305,1268,30,'12335',1,1),(6159,301,1210,28,'12149',2,1),(6160,301,1211,28,'12152',2,1),(6161,301,1212,28,'12153',2,1),(6162,301,1213,28,'12156',2,1),(6163,301,1214,28,'12157',2,1),(6164,301,1215,28,'12160',2,1),(6165,301,1216,28,'12162',2,1),(6166,301,1217,28,'12163',2,1),(6167,301,1218,28,'12166',2,1),(6168,301,1219,28,'12168',2,1),(6169,301,1220,28,'12172',2,1),(6170,301,1221,28,'12173',2,1),(6171,301,1222,28,'12181',2,1),(6172,301,1223,28,'12182',2,NULL),(6173,301,1224,28,'12399',2,NULL),(6174,301,1225,28,'12191',2,1),(6175,301,1226,28,'12200',2,1),(6176,301,1227,28,'12203',2,1),(6177,301,1228,28,'12207',2,1),(6178,301,1229,28,'12213',2,1),(6179,305,1280,31,'12361',1,NULL),(6180,305,1281,31,'12365',1,1),(6181,305,1282,31,'12368',1,NULL),(6182,305,1283,31,'12372',1,NULL),(6183,305,1284,31,'12377',1,NULL),(6184,305,1285,31,'12380',1,NULL),(6185,305,1286,31,'12388',1,NULL),(6186,305,1287,31,'12392',1,1),(6187,305,1288,31,'12396',1,NULL),(6188,305,1269,31,'12337',1,1),(6189,305,1270,31,'12338',1,NULL),(6190,305,1271,31,'12341',1,1),(6191,305,1272,31,'12343',1,1),(6192,305,1273,31,'12344',1,NULL),(6193,305,1274,31,'12346',1,1),(6194,305,1275,31,'12349',1,NULL),(6195,305,1276,31,'12351',1,NULL),(6196,305,1277,31,'12352',1,1),(6197,305,1278,31,'12354',1,1),(6198,305,1279,31,'12357',1,1),(6199,305,1280,31,'12363',2,1),(6200,305,1281,31,'12365',2,1),(6201,305,1282,31,'12371',2,1),(6202,305,1283,31,'12373',2,1),(6203,305,1284,31,'12378',2,1),(6204,305,1285,31,'12383',2,NULL),(6205,305,1286,31,'12387',2,1),(6206,305,1287,31,'12392',2,1),(6207,305,1288,31,'12393',2,NULL),(6208,305,1269,31,'12337',2,1),(6209,305,1270,31,'12339',2,1),(6210,305,1271,31,'12340',2,NULL),(6211,305,1272,31,'12342',2,NULL),(6212,305,1273,31,'12345',2,1),(6213,305,1274,31,'12346',2,1),(6214,305,1275,31,'12348',2,1),(6215,305,1276,31,'12350',2,1),(6216,305,1277,31,'12352',2,1),(6217,305,1278,31,'12354',2,1),(6218,305,1279,31,'12357',2,1),(6219,297,1230,29,'12216',1,1),(6220,297,1231,29,'12219',1,1),(6221,297,1232,29,'12221',1,NULL),(6222,297,1233,29,'12222',1,1),(6223,297,1234,29,'12225',1,1),(6224,297,1235,29,'12226',1,1),(6225,297,1236,29,'12229',1,1),(6226,297,1237,29,'12231',1,NULL),(6227,297,1238,29,'12232',1,NULL),(6228,297,1239,29,'12234',1,1),(6229,297,1240,29,'12240',1,1),(6230,297,1241,29,'12244',1,1),(6231,297,1242,29,'12248',1,NULL),(6232,297,1243,29,'12250',1,NULL),(6233,297,1244,29,'12256',1,1),(6234,297,1245,29,'12259',1,1),(6235,297,1246,29,'12262',1,1),(6236,297,1247,29,'12268',1,1),(6237,297,1230,29,'12216',2,1),(6238,297,1231,29,'12219',2,1),(6239,297,1232,29,'12220',2,1),(6240,297,1233,29,'12223',2,NULL),(6241,297,1235,29,'12226',2,1),(6242,297,1236,29,'12229',2,1),(6243,297,1237,29,'12230',2,1),(6244,297,1238,29,'12233',2,1),(6245,297,1239,29,'12234',2,1),(6246,297,1240,29,'12240',2,1),(6247,297,1241,29,'12244',2,1),(6248,297,1242,29,'12245',2,NULL),(6249,297,1243,29,'12249',2,1),(6250,297,1244,29,'12256',2,1),(6251,297,1245,29,'12259',2,1),(6252,297,1246,29,'12262',2,1),(6253,297,1247,29,'12268',2,1),(6254,110,1230,29,'12216',1,1),(6255,110,1231,29,'12219',1,1),(6256,110,1232,29,'12220',1,1),(6257,110,1233,29,'12222',1,1),(6258,110,1234,29,'12225',1,1),(6259,110,1235,29,'12226',1,1),(6260,110,1236,29,'12229',1,1),(6261,110,1237,29,'12230',1,1),(6262,110,1238,29,'12232',1,NULL),(6263,110,1239,29,'12234',1,1),(6264,110,1240,29,'12240',1,1),(6265,110,1241,29,'12242',1,NULL),(6266,110,1242,29,'12248',1,NULL),(6267,110,1243,29,'12249',1,1),(6268,110,1244,29,'12256',1,1),(6269,110,1245,29,'12259',1,1),(6270,110,1246,29,'12262',1,1),(6271,110,1247,29,'12266',1,NULL),(6272,110,1230,29,'12216',2,1),(6273,110,1231,29,'12219',2,1),(6274,110,1232,29,'12220',2,1),(6275,110,1233,29,'12222',2,1),(6276,110,1234,29,'12225',2,1),(6277,110,1235,29,'12226',2,1),(6278,110,1236,29,'12229',2,1),(6279,110,1237,29,'12230',2,1),(6280,110,1238,29,'12233',2,1),(6281,110,1239,29,'12234',2,1),(6282,110,1240,29,'12240',2,1),(6283,110,1241,29,'12242',2,NULL),(6284,110,1242,29,'12245',2,NULL),(6285,110,1243,29,'12249',2,1),(6286,110,1244,29,'12256',2,1),(6287,110,1245,29,'12259',2,1),(6288,110,1246,29,'12262',2,1),(6289,110,1247,29,'12268',2,1),(6290,110,1230,29,'12216',3,1),(6291,110,1231,29,'12219',3,1),(6292,110,1232,29,'12220',3,1),(6293,110,1233,29,'12222',3,1),(6294,110,1234,29,'12225',3,1),(6295,110,1235,29,'12226',3,1),(6296,110,1236,29,'12229',3,1),(6297,110,1237,29,'12230',3,1),(6298,110,1238,29,'12233',3,1),(6299,110,1239,29,'12234',3,1),(6300,110,1240,29,'12240',3,1),(6301,110,1241,29,'12242',3,NULL),(6302,110,1242,29,'12245',3,NULL),(6303,110,1243,29,'12249',3,1),(6304,110,1244,29,'12256',3,1),(6305,110,1245,29,'12259',3,1),(6306,110,1246,29,'12262',3,1),(6307,110,1247,29,'12268',3,1),(6308,110,1230,29,'12216',4,1),(6309,110,1231,29,'12219',4,1),(6310,110,1232,29,'12220',4,1),(6311,110,1233,29,'12222',4,1),(6312,110,1234,29,'12225',4,1),(6313,110,1235,29,'12226',4,1),(6314,110,1236,29,'12229',4,1),(6315,110,1237,29,'12230',4,1),(6316,110,1238,29,'12233',4,1),(6317,110,1239,29,'12234',4,1),(6318,110,1240,29,'12240',4,1),(6319,110,1241,29,'12242',4,NULL),(6320,110,1242,29,'12245',4,NULL),(6321,110,1243,29,'12249',4,1),(6322,110,1244,29,'12256',4,1),(6323,110,1245,29,'12259',4,1),(6324,110,1246,29,'12262',4,1),(6325,110,1247,29,'12268',4,1),(6326,110,1230,29,'12216',5,1),(6327,110,1231,29,'12219',5,1),(6328,110,1232,29,'12220',5,1),(6329,110,1233,29,'12222',5,1),(6330,110,1234,29,'12225',5,1),(6331,110,1235,29,'12226',5,1),(6332,110,1236,29,'12229',5,1),(6333,110,1237,29,'12230',5,1),(6334,110,1238,29,'12233',5,1),(6335,110,1239,29,'12234',5,1),(6336,110,1240,29,'12240',5,1),(6337,110,1241,29,'12242',5,NULL),(6338,110,1242,29,'12245',5,NULL),(6339,110,1243,29,'12249',5,1),(6340,110,1244,29,'12256',5,1),(6341,110,1245,29,'12259',5,1),(6342,110,1246,29,'12262',5,1),(6343,110,1247,29,'12268',5,1),(6344,297,1248,30,'12269',1,1),(6345,297,1249,30,'12272',1,1),(6346,297,1250,30,'12273',1,1),(6347,297,1251,30,'12275',1,1),(6348,297,1252,30,'12278',1,1),(6349,297,1253,30,'12279',1,1),(6350,297,1254,30,'12282',1,NULL),(6351,297,1255,30,'12284',1,1),(6352,297,1256,30,'12286',1,1),(6353,297,1257,30,'12289',1,1),(6354,297,1258,30,'12291',1,1),(6355,297,1259,30,'12297',1,1),(6356,297,1260,30,'12301',1,NULL),(6357,297,1261,30,'12303',1,1),(6358,297,1262,30,'12310',1,1),(6359,297,1263,30,'12313',1,1),(6360,297,1264,30,'12319',1,1),(6361,297,1265,30,'12322',1,1),(6362,297,1266,30,'12326',1,NULL),(6363,297,1267,30,'12330',1,1),(6364,297,1268,30,'12335',1,1),(6365,294,1183,27,'12064',1,1),(6366,294,1184,27,'12069',1,1),(6367,294,1185,27,'12071',1,1),(6368,294,1186,27,'12072',1,1),(6369,294,1187,27,'12074',1,NULL),(6370,294,1188,27,'12076',1,NULL),(6371,294,1189,27,'12078',1,1),(6372,294,1190,27,'12081',1,1),(6373,294,1191,27,'12083',1,1),(6374,294,1192,27,'12084',1,NULL),(6375,294,1193,27,'12086',1,1),(6376,294,1194,27,'12088',1,1),(6377,294,1195,27,'12091',1,1),(6378,294,1196,27,'12093',1,NULL),(6379,294,1197,27,'12097',1,1),(6380,294,1198,27,'12102',1,1),(6381,294,1199,27,'12105',1,1),(6382,294,1200,27,'12112',1,1),(6383,294,1201,27,'12115',1,NULL),(6384,294,1202,27,'12119',1,1),(6385,294,1203,27,'12124',1,1),(6386,294,1204,27,'12126',1,1),(6387,294,1205,27,'12129',1,NULL),(6388,294,1206,27,'12136',1,1),(6389,294,1207,27,'12139',1,1),(6390,294,1208,27,'12144',1,1),(6391,294,1209,27,'12147',1,1),(6392,294,1183,27,'12064',2,1),(6393,294,1184,27,'12069',2,1),(6394,294,1185,27,'12071',2,1),(6395,294,1186,27,'12072',2,1),(6396,294,1187,27,'12075',2,1),(6397,294,1188,27,'12077',2,1),(6398,294,1189,27,'12078',2,1),(6399,294,1190,27,'12081',2,1),(6400,294,1191,27,'12083',2,1),(6401,294,1192,27,'12085',2,1),(6402,294,1193,27,'12086',2,1),(6403,294,1194,27,'12088',2,1),(6404,294,1195,27,'12091',2,1),(6405,294,1196,27,'12092',2,1),(6406,294,1197,27,'12097',2,1),(6407,294,1198,27,'12102',2,1),(6408,294,1199,27,'12105',2,1),(6409,294,1200,27,'12112',2,1),(6410,294,1201,27,'12114',2,NULL),(6411,294,1202,27,'12119',2,1),(6412,294,1203,27,'12124',2,1),(6413,294,1204,27,'12127',2,NULL),(6414,294,1205,27,'12129',2,NULL),(6415,294,1206,27,'12136',2,1),(6416,294,1207,27,'12139',2,1),(6417,294,1208,27,'12144',2,1),(6418,294,1209,27,'12147',2,1),(6419,294,1210,28,'12149',1,1),(6420,294,1211,28,'12152',1,1),(6421,294,1212,28,'12153',1,1),(6422,294,1213,28,'12156',1,1),(6423,294,1214,28,'12157',1,1),(6424,294,1215,28,'12160',1,1),(6425,294,1216,28,'12162',1,1),(6426,294,1217,28,'12163',1,1),(6427,294,1218,28,'12166',1,1),(6428,294,1219,28,'12168',1,1),(6429,294,1220,28,'12172',1,1),(6430,294,1221,28,'12173',1,1),(6431,294,1222,28,'12181',1,1),(6432,294,1223,28,'12183',1,NULL),(6433,294,1224,28,'12400',1,1),(6434,294,1225,28,'12191',1,1),(6435,294,1226,28,'12200',1,1),(6436,294,1227,28,'12203',1,1),(6437,294,1228,28,'12208',1,NULL),(6438,294,1229,28,'12213',1,1),(6439,294,1230,29,'12216',1,1),(6440,294,1231,29,'12219',1,1),(6441,294,1232,29,'12221',1,NULL),(6442,294,1233,29,'12223',1,NULL),(6443,294,1234,29,'12225',1,1),(6444,294,1235,29,'12226',1,1),(6445,294,1236,29,'12229',1,1),(6446,294,1237,29,'12230',1,1),(6447,294,1238,29,'12232',1,NULL),(6448,294,1239,29,'12235',1,NULL),(6449,294,1240,29,'12240',1,1),(6450,294,1241,29,'12241',1,NULL),(6451,294,1242,29,'12245',1,NULL),(6452,294,1243,29,'12249',1,1),(6453,294,1244,29,'12256',1,1),(6454,294,1245,29,'12259',1,1),(6455,294,1246,29,'12263',1,NULL),(6456,294,1247,29,'12268',1,1),(6457,294,1230,29,'12216',2,1),(6458,294,1231,29,'12219',2,1),(6459,294,1232,29,'12221',2,NULL),(6460,294,1233,29,'12222',2,1),(6461,294,1234,29,'12225',2,1),(6462,294,1235,29,'12226',2,1),(6463,294,1236,29,'12229',2,1),(6464,294,1237,29,'12230',2,1),(6465,294,1238,29,'12233',2,1),(6466,294,1239,29,'12234',2,1),(6467,294,1240,29,'12240',2,1),(6468,294,1241,29,'12241',2,NULL),(6469,294,1242,29,'12246',2,1),(6470,294,1243,29,'12249',2,1),(6471,294,1244,29,'12256',2,1),(6472,294,1245,29,'12259',2,1),(6473,294,1246,29,'12261',2,NULL),(6474,294,1247,29,'12268',2,1),(6475,294,1248,30,'12269',1,1),(6476,294,1249,30,'12272',1,1),(6477,294,1250,30,'12273',1,1),(6478,294,1251,30,'12275',1,1),(6479,294,1252,30,'12278',1,1),(6480,294,1253,30,'12279',1,1),(6481,294,1254,30,'12281',1,1),(6482,294,1255,30,'12284',1,1),(6483,294,1256,30,'12286',1,1),(6484,294,1257,30,'12289',1,1),(6485,294,1258,30,'12291',1,1),(6486,294,1259,30,'12298',1,NULL),(6487,294,1260,30,'12302',1,1),(6488,294,1261,30,'12303',1,1),(6489,294,1262,30,'12310',1,1),(6490,294,1263,30,'12313',1,1),(6491,294,1264,30,'12317',1,NULL),(6492,294,1265,30,'12322',1,1),(6493,294,1266,30,'12325',1,1),(6494,294,1267,30,'12330',1,1),(6495,294,1268,30,'12335',1,1),(6496,294,1280,31,'12363',1,1),(6497,294,1281,31,'12365',1,1),(6498,294,1282,31,'12368',1,NULL),(6499,294,1283,31,'12373',1,1),(6500,294,1284,31,'12376',1,NULL),(6501,294,1285,31,'12380',1,NULL),(6502,294,1286,31,'12387',1,1),(6503,294,1287,31,'12392',1,1),(6504,294,1288,31,'12395',1,NULL),(6505,294,1269,31,'12337',1,1),(6506,294,1270,31,'12338',1,NULL),(6507,294,1271,31,'12341',1,1),(6508,294,1272,31,'12343',1,1),(6509,294,1273,31,'12344',1,NULL),(6510,294,1274,31,'12346',1,1),(6511,294,1275,31,'12349',1,NULL),(6512,294,1276,31,'12351',1,NULL),(6513,294,1277,31,'12352',1,1),(6514,294,1278,31,'12354',1,1),(6515,294,1279,31,'12359',1,NULL),(6516,294,1280,31,'12363',2,1),(6517,294,1281,31,'12365',2,1),(6518,294,1282,31,'12371',2,1),(6519,294,1283,31,'12373',2,1),(6520,294,1284,31,'12377',2,NULL),(6521,294,1285,31,'12383',2,NULL),(6522,294,1286,31,'12387',2,1),(6523,294,1287,31,'12392',2,1),(6524,294,1288,31,'12396',2,NULL),(6525,294,1269,31,'12337',2,1),(6526,294,1270,31,'12339',2,1),(6527,294,1271,31,'12341',2,1),(6528,294,1272,31,'12343',2,1),(6529,294,1273,31,'12345',2,1),(6530,294,1274,31,'12346',2,1),(6531,294,1275,31,'12348',2,1),(6532,294,1276,31,'12350',2,1),(6533,294,1277,31,'12352',2,1),(6534,294,1278,31,'12354',2,1),(6535,294,1279,31,'12358',2,NULL),(6536,310,1183,27,'12064',1,1),(6537,310,1184,27,'12069',1,1),(6538,310,1185,27,'12071',1,1),(6539,310,1186,27,'12072',1,1),(6540,310,1187,27,'12074',1,NULL),(6541,310,1188,27,'12077',1,1),(6542,310,1189,27,'12078',1,1),(6543,310,1190,27,'12081',1,1),(6544,310,1191,27,'12083',1,1),(6545,310,1192,27,'12084',1,NULL),(6546,310,1193,27,'12087',1,NULL),(6547,310,1194,27,'12088',1,1),(6548,310,1195,27,'12091',1,1),(6549,310,1196,27,'12092',1,1),(6550,310,1197,27,'12097',1,1),(6551,310,1198,27,'12102',1,1),(6552,310,1199,27,'12105',1,1),(6553,310,1200,27,'12112',1,1),(6554,310,1201,27,'12113',1,1),(6555,310,1202,27,'12119',1,1),(6556,310,1203,27,'12124',1,1),(6557,310,1204,27,'12126',1,1),(6558,310,1205,27,'12129',1,NULL),(6559,310,1206,27,'12136',1,1),(6560,310,1207,27,'12139',1,1),(6561,310,1208,27,'12144',1,1),(6562,310,1209,27,'12147',1,1),(6563,310,1210,28,'12150',1,NULL),(6564,310,1211,28,'12152',1,1),(6565,310,1212,28,'12153',1,1),(6566,310,1213,28,'12156',1,1),(6567,310,1214,28,'12158',1,NULL),(6568,310,1215,28,'12160',1,1),(6569,310,1216,28,'12162',1,1),(6570,310,1217,28,'12164',1,NULL),(6571,310,1218,28,'12166',1,1),(6572,310,1219,28,'12168',1,1),(6573,310,1220,28,'12172',1,1),(6574,310,1221,28,'12173',1,1),(6575,310,1222,28,'12181',1,1),(6576,310,1223,28,'12185',1,NULL),(6577,310,1224,28,'12400',1,1),(6578,310,1225,28,'12191',1,1),(6579,310,1226,28,'12200',1,1),(6580,310,1227,28,'12203',1,1),(6581,310,1228,28,'12207',1,1),(6582,310,1229,28,'12213',1,1),(6583,302,1183,27,'12064',1,1),(6584,302,1184,27,'12069',1,1),(6585,302,1185,27,'12071',1,1),(6586,302,1186,27,'12072',1,1),(6587,302,1187,27,'12075',1,1),(6588,302,1188,27,'12077',1,1),(6589,302,1189,27,'12078',1,1),(6590,302,1190,27,'12081',1,1),(6591,302,1191,27,'12083',1,1),(6592,302,1192,27,'12085',1,1),(6593,302,1193,27,'12086',1,1),(6594,302,1194,27,'12088',1,1),(6595,302,1195,27,'12091',1,1),(6596,302,1196,27,'12092',1,1),(6597,302,1197,27,'12097',1,1),(6598,302,1198,27,'12102',1,1),(6599,302,1199,27,'12105',1,1),(6600,302,1200,27,'12112',1,1),(6601,302,1201,27,'12113',1,1),(6602,302,1202,27,'12119',1,1),(6603,302,1203,27,'12124',1,1),(6604,302,1204,27,'12126',1,1),(6605,302,1205,27,'12129',1,NULL),(6606,302,1206,27,'12136',1,1),(6607,302,1207,27,'12139',1,1),(6608,302,1208,27,'12144',1,1),(6609,302,1209,27,'12147',1,1),(6610,302,1210,28,'12149',1,1),(6611,302,1211,28,'12152',1,1),(6612,302,1212,28,'12153',1,1),(6613,302,1213,28,'12156',1,1),(6614,302,1214,28,'12157',1,1),(6615,302,1215,28,'12160',1,1),(6616,302,1216,28,'12162',1,1),(6617,302,1217,28,'12163',1,1),(6618,302,1218,28,'12166',1,1),(6619,302,1219,28,'12168',1,1),(6620,302,1220,28,'12172',1,1),(6621,302,1221,28,'12173',1,1),(6622,302,1222,28,'12181',1,1),(6623,302,1223,28,'12184',1,1),(6624,302,1224,28,'12400',1,1),(6625,302,1225,28,'12191',1,1),(6626,302,1226,28,'12200',1,1),(6627,302,1227,28,'12203',1,1),(6628,302,1228,28,'12207',1,1),(6629,302,1229,28,'12213',1,1),(6630,302,1230,29,'12216',1,1),(6631,302,1231,29,'12219',1,1),(6632,302,1232,29,'12221',1,NULL),(6633,302,1233,29,'12222',1,1),(6634,302,1234,29,'12225',1,1),(6635,302,1235,29,'12226',1,1),(6636,302,1236,29,'12228',1,NULL),(6637,302,1237,29,'12230',1,1),(6638,302,1238,29,'12232',1,NULL),(6639,302,1239,29,'12235',1,NULL),(6640,302,1240,29,'12240',1,1),(6641,302,1241,29,'12243',1,NULL),(6642,302,1242,29,'12248',1,NULL),(6643,302,1243,29,'12249',1,1),(6644,302,1244,29,'12256',1,1),(6645,302,1245,29,'12259',1,1),(6646,302,1246,29,'12263',1,NULL),(6647,302,1247,29,'12268',1,1),(6648,302,1230,29,'12216',2,1),(6649,302,1231,29,'12219',2,1),(6650,302,1232,29,'12220',2,1),(6651,302,1233,29,'12222',2,1),(6652,302,1234,29,'12225',2,1),(6653,302,1235,29,'12226',2,1),(6654,302,1236,29,'12229',2,1),(6655,302,1237,29,'12230',2,1),(6656,302,1238,29,'12233',2,1),(6657,302,1239,29,'12234',2,1),(6658,302,1240,29,'12240',2,1),(6659,302,1241,29,'12241',2,NULL),(6660,302,1242,29,'12245',2,NULL),(6661,302,1243,29,'12249',2,1),(6662,302,1244,29,'12256',2,1),(6663,302,1245,29,'12259',2,1),(6664,302,1246,29,'12261',2,NULL),(6665,302,1247,29,'12268',2,1),(6666,311,1183,27,'12064',1,1),(6667,311,1184,27,'12069',1,1),(6668,311,1185,27,'12071',1,1),(6669,311,1186,27,'12072',1,1),(6670,311,1187,27,'12075',1,1),(6671,311,1188,27,'12077',1,1),(6672,311,1189,27,'12078',1,1),(6673,311,1190,27,'12081',1,1),(6674,311,1191,27,'12083',1,1),(6675,311,1192,27,'12085',1,1),(6676,311,1193,27,'12086',1,1),(6677,311,1194,27,'12088',1,1),(6678,311,1195,27,'12091',1,1),(6679,311,1196,27,'12092',1,1),(6680,311,1197,27,'12097',1,1),(6681,311,1198,27,'12102',1,1),(6682,311,1199,27,'12105',1,1),(6683,311,1200,27,'12112',1,1),(6684,311,1201,27,'12113',1,1),(6685,311,1202,27,'12119',1,1),(6686,311,1203,27,'12124',1,1),(6687,311,1204,27,'12126',1,1),(6688,311,1205,27,'12130',1,1),(6689,311,1206,27,'12136',1,1),(6690,311,1207,27,'12139',1,1),(6691,311,1208,27,'12144',1,1),(6692,311,1209,27,'12147',1,1),(6693,310,1230,29,'12216',1,1),(6694,310,1231,29,'12219',1,1),(6695,310,1232,29,'12220',1,1),(6696,310,1233,29,'12222',1,1),(6697,310,1234,29,'12225',1,1),(6698,310,1235,29,'12226',1,1),(6699,310,1236,29,'12229',1,1),(6700,310,1237,29,'12230',1,1),(6701,310,1238,29,'12233',1,1),(6702,310,1239,29,'12234',1,1),(6703,310,1240,29,'12240',1,1),(6704,310,1241,29,'12244',1,1),(6705,310,1242,29,'12245',1,NULL),(6706,310,1243,29,'12249',1,1),(6707,310,1244,29,'12256',1,1),(6708,310,1245,29,'12259',1,1),(6709,310,1246,29,'12262',1,1),(6710,310,1247,29,'12268',1,1),(6711,302,1248,30,'12269',1,1),(6712,302,1249,30,'12272',1,1),(6713,302,1250,30,'12273',1,1),(6714,302,1251,30,'12275',1,1),(6715,302,1252,30,'12278',1,1),(6716,302,1253,30,'12279',1,1),(6717,302,1254,30,'12281',1,1),(6718,302,1255,30,'12284',1,1),(6719,302,1256,30,'12286',1,1),(6720,302,1257,30,'12289',1,1),(6721,302,1258,30,'12291',1,1),(6722,302,1259,30,'12297',1,1),(6723,302,1260,30,'12302',1,1),(6724,302,1261,30,'12303',1,1),(6725,302,1262,30,'12310',1,1),(6726,302,1263,30,'12313',1,1),(6727,302,1264,30,'12318',1,NULL),(6728,302,1265,30,'12322',1,1),(6729,302,1266,30,'12325',1,1),(6730,302,1267,30,'12331',1,NULL),(6731,302,1268,30,'12334',1,NULL),(6732,302,1280,31,'12363',1,1),(6733,302,1281,31,'12365',1,1),(6734,302,1282,31,'12368',1,NULL),(6735,302,1283,31,'12372',1,NULL),(6736,302,1284,31,'12378',1,1),(6737,302,1285,31,'12382',1,1),(6738,302,1286,31,'12387',1,1),(6739,302,1287,31,'12392',1,1),(6740,302,1288,31,'12396',1,NULL),(6741,302,1269,31,'12337',1,1),(6742,302,1270,31,'12338',1,NULL),(6743,302,1271,31,'12341',1,1),(6744,302,1272,31,'12342',1,NULL),(6745,302,1273,31,'12344',1,NULL),(6746,302,1274,31,'12346',1,1),(6747,302,1275,31,'12348',1,1),(6748,302,1276,31,'12351',1,NULL),(6749,302,1277,31,'12352',1,1),(6750,302,1278,31,'12354',1,1),(6751,302,1279,31,'12356',1,NULL),(6752,302,1280,31,'12363',2,1),(6753,302,1281,31,'12365',2,1),(6754,302,1282,31,'12371',2,1),(6755,302,1283,31,'12373',2,1),(6756,302,1284,31,'12378',2,1),(6757,302,1285,31,'12382',2,1),(6758,302,1286,31,'12387',2,1),(6759,302,1287,31,'12392',2,1),(6760,302,1288,31,'12395',2,NULL),(6761,302,1269,31,'12337',2,1),(6762,302,1270,31,'12339',2,1),(6763,302,1271,31,'12341',2,1),(6764,302,1272,31,'12343',2,1),(6765,302,1273,31,'12344',2,NULL),(6766,302,1274,31,'12346',2,1),(6767,302,1275,31,'12348',2,1),(6768,302,1276,31,'12351',2,NULL),(6769,302,1277,31,'12352',2,1),(6770,302,1278,31,'12354',2,1),(6771,302,1279,31,'12359',2,NULL),(6772,310,1248,30,'12269',1,1),(6773,310,1249,30,'12272',1,1),(6774,310,1250,30,'12273',1,1),(6775,310,1251,30,'12275',1,1),(6776,310,1252,30,'12278',1,1),(6777,310,1253,30,'12279',1,1),(6778,310,1254,30,'12281',1,1),(6779,310,1255,30,'12284',1,1),(6780,310,1256,30,'12286',1,1),(6781,310,1257,30,'12289',1,1),(6782,310,1258,30,'12291',1,1),(6783,310,1259,30,'12297',1,1),(6784,310,1260,30,'12302',1,1),(6785,310,1261,30,'12303',1,1),(6786,310,1262,30,'12310',1,1),(6787,310,1263,30,'12313',1,1),(6788,310,1264,30,'12319',1,1),(6789,310,1265,30,'12322',1,1),(6790,310,1266,30,'12325',1,1),(6791,310,1267,30,'12330',1,1),(6792,310,1268,30,'12335',1,1),(6793,297,1280,31,'12363',1,1),(6794,297,1281,31,'12366',1,NULL),(6795,297,1282,31,'12368',1,NULL),(6796,297,1283,31,'12373',1,1),(6797,297,1284,31,'12378',1,1),(6798,297,1285,31,'12381',1,NULL),(6799,297,1286,31,'12388',1,NULL),(6800,297,1287,31,'12392',1,1),(6801,297,1288,31,'12393',1,NULL),(6802,297,1269,31,'12337',1,1),(6803,297,1270,31,'12338',1,NULL),(6804,297,1271,31,'12341',1,1),(6805,297,1272,31,'12343',1,1),(6806,297,1273,31,'12344',1,NULL),(6807,297,1274,31,'12347',1,NULL),(6808,297,1275,31,'12348',1,1),(6809,297,1276,31,'12350',1,1),(6810,297,1277,31,'12352',1,1),(6811,297,1278,31,'12354',1,1),(6812,297,1279,31,'12359',1,NULL),(6813,297,1280,31,'12363',2,1),(6814,297,1281,31,'12365',2,1),(6815,297,1282,31,'12371',2,1),(6816,297,1283,31,'12373',2,1),(6817,297,1284,31,'12378',2,1),(6818,297,1285,31,'12382',2,1),(6819,297,1286,31,'12384',2,NULL),(6820,297,1287,31,'12390',2,NULL),(6821,297,1288,31,'12394',2,1),(6822,297,1269,31,'12337',2,1),(6823,297,1270,31,'12338',2,NULL),(6824,297,1271,31,'12341',2,1),(6825,297,1272,31,'12343',2,1),(6826,297,1273,31,'12345',2,1),(6827,297,1274,31,'12346',2,1),(6828,297,1275,31,'12348',2,1),(6829,297,1276,31,'12350',2,1),(6830,297,1277,31,'12352',2,1),(6831,297,1278,31,'12354',2,1),(6832,297,1279,31,'12358',2,NULL),(6833,310,1280,31,'12363',1,1),(6834,310,1281,31,'12365',1,1),(6835,310,1282,31,'12368',1,NULL),(6836,310,1283,31,'12373',1,1),(6837,310,1284,31,'12378',1,1),(6838,310,1285,31,'12382',1,1),(6839,310,1286,31,'12387',1,1),(6840,310,1287,31,'12392',1,1),(6841,310,1288,31,'12394',1,1),(6842,310,1269,31,'12337',1,1),(6843,310,1270,31,'12339',1,1),(6844,310,1271,31,'12341',1,1),(6845,310,1272,31,'12343',1,1),(6846,310,1273,31,'12344',1,NULL),(6847,310,1274,31,'12346',1,1),(6848,310,1275,31,'12348',1,1),(6849,310,1276,31,'12350',1,1),(6850,310,1277,31,'12352',1,1),(6851,310,1278,31,'12354',1,1),(6852,310,1279,31,'12358',1,NULL),(6853,311,1210,28,'12149',1,1),(6854,311,1211,28,'12151',1,NULL),(6855,311,1212,28,'12153',1,1),(6856,311,1213,28,'12156',1,1),(6857,311,1214,28,'12157',1,1),(6858,311,1215,28,'12160',1,1),(6859,311,1216,28,'12162',1,1),(6860,311,1217,28,'12163',1,1),(6861,311,1218,28,'12166',1,1),(6862,311,1219,28,'12168',1,1),(6863,311,1220,28,'12172',1,1),(6864,311,1221,28,'12173',1,1),(6865,311,1222,28,'12181',1,1),(6866,311,1223,28,'12183',1,NULL),(6867,311,1224,28,'12398',1,NULL),(6868,311,1225,28,'12191',1,1),(6869,311,1226,28,'12200',1,1),(6870,311,1227,28,'12203',1,1),(6871,311,1228,28,'12207',1,1),(6872,311,1229,28,'12214',1,NULL),(6873,311,1230,29,'12216',1,1),(6874,311,1231,29,'12219',1,1),(6875,311,1232,29,'12220',1,1),(6876,311,1233,29,'12223',1,NULL),(6877,311,1234,29,'12225',1,1),(6878,311,1235,29,'12226',1,1),(6879,311,1236,29,'12228',1,NULL),(6880,311,1237,29,'12230',1,1),(6881,311,1238,29,'12233',1,1),(6882,311,1239,29,'12234',1,1),(6883,311,1240,29,'12240',1,1),(6884,311,1241,29,'12241',1,NULL),(6885,311,1242,29,'12245',1,NULL),(6886,311,1243,29,'12249',1,1),(6887,311,1244,29,'12255',1,NULL),(6888,311,1245,29,'12259',1,1),(6889,311,1246,29,'12263',1,NULL),(6890,311,1247,29,'12267',1,NULL),(6891,311,1230,29,'12216',2,1),(6892,311,1231,29,'12219',2,1),(6893,311,1232,29,'12220',2,1),(6894,311,1233,29,'12222',2,1),(6895,311,1234,29,'12225',2,1),(6896,311,1235,29,'12226',2,1),(6897,311,1236,29,'12229',2,1),(6898,311,1237,29,'12230',2,1),(6899,311,1238,29,'12233',2,1),(6900,311,1239,29,'12234',2,1),(6901,311,1240,29,'12240',2,1),(6902,311,1241,29,'12242',2,NULL),(6903,311,1242,29,'12246',2,1),(6904,311,1243,29,'12249',2,1),(6905,311,1244,29,'12256',2,1),(6906,311,1245,29,'12259',2,1),(6907,311,1246,29,'12261',2,NULL),(6908,311,1247,29,'12265',2,NULL),(6909,311,1248,30,'12269',1,1),(6910,311,1249,30,'12272',1,1),(6911,311,1250,30,'12273',1,1),(6912,311,1251,30,'12275',1,1),(6913,311,1252,30,'12278',1,1),(6914,311,1253,30,'12279',1,1),(6915,311,1254,30,'12281',1,1),(6916,311,1255,30,'12284',1,1),(6917,311,1256,30,'12286',1,1),(6918,311,1257,30,'12289',1,1),(6919,311,1258,30,'12291',1,1),(6920,311,1259,30,'12297',1,1),(6921,311,1260,30,'12301',1,NULL),(6922,311,1261,30,'12306',1,NULL),(6923,311,1262,30,'12310',1,1),(6924,311,1263,30,'12313',1,1),(6925,311,1264,30,'12316',1,NULL),(6926,311,1265,30,'12322',1,1),(6927,311,1266,30,'12326',1,NULL),(6928,311,1267,30,'12331',1,NULL),(6929,311,1268,30,'12335',1,1),(6930,311,1248,30,'12269',2,1),(6931,311,1249,30,'12272',2,1),(6932,311,1250,30,'12273',2,1),(6933,311,1251,30,'12275',2,1),(6934,311,1252,30,'12278',2,1),(6935,311,1253,30,'12279',2,1),(6936,311,1254,30,'12281',2,1),(6937,311,1255,30,'12284',2,1),(6938,311,1256,30,'12286',2,1),(6939,311,1257,30,'12289',2,1),(6940,311,1258,30,'12291',2,1),(6941,311,1259,30,'12297',2,1),(6942,311,1260,30,'12302',2,1),(6943,311,1261,30,'12303',2,1),(6944,311,1262,30,'12310',2,1),(6945,311,1263,30,'12313',2,1),(6946,311,1264,30,'12319',2,1),(6947,311,1265,30,'12322',2,1),(6948,311,1266,30,'12325',2,1),(6949,311,1267,30,'12329',2,NULL),(6950,311,1268,30,'12335',2,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,'grn321',NULL,'','',0);

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `title` varchar(90) DEFAULT NULL,
  `date_completed` int(90) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `training`
--


--
-- 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',
  `essay_grade` varchar(11) DEFAULT NULL,
  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=1154 DEFAULT CHARSET=utf8;

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

INSERT INTO `user_course_access` VALUES (1025,110,27,'In Progress',1573497059,0,'1'),(1026,110,28,'In Progress',1573497066,0,'1'),(1027,110,29,'Completed',1585706794,0,'1'),(1028,110,30,'In Progress',1573497073,0,'1'),(1029,110,31,'In Progress',1573497076,0,'1'),(1030,289,27,'In Progress',NULL,0,NULL),(1031,291,27,'In Progress',1574485655,0,'1'),(1032,290,27,'In Progress',NULL,0,NULL),(1033,291,28,'In Progress',NULL,0,NULL),(1034,290,27,'In Progress',NULL,0,NULL),(1035,292,27,'Completed',1577993165,0,'1'),(1036,293,27,'Completed',1580160695,0,'1'),(1037,290,27,'In Progress',NULL,0,NULL),(1038,290,28,'In Progress',NULL,0,NULL),(1039,290,28,'In Progress',NULL,0,NULL),(1040,290,29,'In Progress',NULL,0,NULL),(1041,290,29,'In Progress',NULL,0,NULL),(1042,290,30,'In Progress',NULL,0,NULL),(1043,290,30,'In Progress',NULL,0,NULL),(1044,290,31,'In Progress',NULL,0,NULL),(1045,290,31,'In Progress',NULL,0,NULL),(1046,294,27,'Completed',1588107051,1,'1'),(1047,295,27,'Completed',1581796727,1,'1'),(1048,295,27,'Completed',1581796727,1,NULL),(1049,295,28,'Completed',1581207203,1,'1'),(1050,295,28,'Completed',1581207203,1,NULL),(1051,296,27,'Completed',1577157308,1,'1'),(1052,297,27,'Completed',1578090374,0,'1'),(1053,297,28,'Completed',1583165026,0,'1'),(1054,297,29,'Completed',1584991332,0,'1'),(1055,297,30,'Completed',1585766806,0,'1'),(1056,297,31,'Completed',1595016590,0,'1'),(1057,298,27,'In Progress',NULL,0,NULL),(1058,299,27,'Completed',1583195336,1,'1'),(1059,301,27,'Completed',1581108497,1,'1'),(1060,301,27,'Completed',1581108497,1,NULL),(1061,302,27,'Completed',1592866807,1,'1'),(1062,291,31,'In Progress',NULL,0,NULL),(1063,303,27,'Completed',1575319552,1,'1'),(1064,303,27,'Completed',1575319552,1,NULL),(1065,304,27,'Completed',1576892769,1,'1'),(1066,304,27,'Completed',1576892769,1,NULL),(1067,303,28,'Completed',1576307789,1,'1'),(1068,295,30,'Completed',1580079669,0,'1'),(1069,296,28,'Completed',1578679396,1,'1'),(1070,296,28,'Completed',1578679396,1,NULL),(1071,303,29,'Completed',1578024207,1,'1'),(1076,305,27,'Completed',1581524111,0,'1'),(1077,304,28,'Completed',1578019425,0,'1'),(1078,304,29,'Completed',1579927714,0,'1'),(1079,304,30,'Completed',1580185847,0,'1'),(1080,304,31,'Completed',1581128253,0,'1'),(1081,308,27,'Completed',1581690852,0,'1'),(1082,309,27,'Completed',1578683763,0,'1'),(1083,309,28,'Completed',1581364837,0,'1'),(1084,309,29,'Completed',1582483754,0,'1'),(1085,309,30,'Completed',1582484135,0,'1'),(1086,309,31,'Completed',1582485033,0,'1'),(1087,303,30,'Completed',1578865245,1,'1'),(1088,303,31,'Completed',1580688082,1,'1'),(1089,303,31,'Completed',1580688082,1,NULL),(1090,292,28,'Completed',1579199195,0,'1'),(1091,300,27,'In Progress',NULL,0,NULL),(1092,300,28,'In Progress',NULL,0,NULL),(1093,300,28,'In Progress',NULL,0,NULL),(1094,296,29,'Completed',1579054948,1,'1'),(1095,296,30,'Completed',1580681492,1,'1'),(1096,292,29,'Completed',1580917438,0,'1'),(1097,296,31,'Completed',1581965278,1,'1'),(1098,308,28,'Completed',1581691538,0,'1'),(1099,293,28,'Completed',1580161681,0,'1'),(1100,293,29,'Completed',1580735298,0,'1'),(1101,293,30,'Completed',1581101804,0,'1'),(1102,293,31,'Completed',1581460634,0,'1'),(1103,291,29,'In Progress',NULL,0,NULL),(1104,291,30,'In Progress',NULL,0,NULL),(1105,308,29,'Completed',1581693720,0,'1'),(1106,308,29,'Completed',1581693720,0,NULL),(1107,308,30,'Completed',1581694403,0,'1'),(1108,301,28,'Completed',1583760674,1,'1'),(1109,292,30,'Completed',1581083971,0,'1'),(1110,308,31,'Completed',1582321991,0,'1'),(1111,292,31,'Completed',1581539444,0,'1'),(1112,295,29,'Completed',1581794533,0,'1'),(1113,295,31,'Completed',1581788627,0,'1'),(1114,306,27,'In Progress',NULL,0,NULL),(1115,301,29,'Completed',1581968802,0,'1'),(1116,301,29,'Completed',1581968802,0,NULL),(1117,305,28,'Completed',1582140698,0,'1'),(1118,305,28,'Completed',1582140698,0,NULL),(1119,305,29,'Completed',1582207766,0,'1'),(1120,305,29,'Completed',1582207766,0,NULL),(1121,305,30,'Completed',1583246151,0,'1'),(1122,305,31,'Completed',1584556465,0,'1'),(1123,301,30,'Completed',1582150568,0,'1'),(1124,301,31,'Completed',1583023363,0,'1'),(1125,299,28,'In Progress',1597276336,0,'1'),(1126,299,29,'In Progress',1597276378,0,'1'),(1127,299,30,'In Progress',1597276384,0,'1'),(1128,299,31,'In Progress',1597276388,0,'1'),(1129,294,28,'Completed',1588266164,1,'1'),(1130,294,29,'Completed',1588376816,0,'1'),(1131,294,30,'Completed',1588850065,0,'1'),(1132,294,31,'Completed',1589216646,1,'1'),(1133,310,27,'Completed',1591986172,0,'1'),(1134,310,28,'Completed',1592501407,0,'1'),(1135,310,29,'Completed',1593195802,0,'1'),(1136,310,30,'Completed',1594909516,0,'1'),(1137,310,31,'Completed',1595157509,0,'1'),(1138,311,27,'Completed',1592920104,0,'1'),(1139,302,28,'Completed',1592867839,0,'1'),(1140,302,29,'Completed',1592869362,0,'1'),(1141,311,27,'Completed',1592920104,0,NULL),(1142,302,30,'Completed',1593557627,0,'1'),(1143,302,31,'Completed',1594077741,0,'1'),(1144,311,28,'Completed',1595517580,0,'1'),(1145,312,27,'In Progress',NULL,0,NULL),(1146,312,28,'In Progress',NULL,0,NULL),(1147,312,28,'In Progress',NULL,0,NULL),(1148,312,29,'In Progress',NULL,0,NULL),(1149,312,30,'In Progress',NULL,0,NULL),(1150,312,31,'In Progress',NULL,0,NULL),(1151,311,29,'Completed',1595680884,0,'1'),(1152,311,30,'Completed',1597277789,0,'1'),(1153,311,31,'In Progress',NULL,0,NULL);


