-- phpMyAdmin SQL Dump -- version 2.6.1-pl2 -- http://www.phpmyadmin.net -- -- Generation Time: Apr 01, 2005 at 02:20 PM -- Server version: 4.0.24 -- PHP Version: 4.3.10 -- -- -- Dumping data for table `ALLELE_VALIDS` -- -- -- Dumping data for table `ANSWER` -- INSERT INTO `ANSWER` VALUES (1, 'yes'); INSERT INTO `ANSWER` VALUES (2, 'no'); INSERT INTO `ANSWER` VALUES (3, '0'); INSERT INTO `ANSWER` VALUES (4, '1'); INSERT INTO `ANSWER` VALUES (5, '2'); INSERT INTO `ANSWER` VALUES (6, '3'); INSERT INTO `ANSWER` VALUES (7, '4'); INSERT INTO `ANSWER` VALUES (8, '5'); INSERT INTO `ANSWER` VALUES (9, '6'); INSERT INTO `ANSWER` VALUES (10, '7'); INSERT INTO `ANSWER` VALUES (11, 'Two or more'); INSERT INTO `ANSWER` VALUES (12, 'One - Two'); INSERT INTO `ANSWER` VALUES (23, 'Group I (Opiate)'); INSERT INTO `ANSWER` VALUES (24, 'Group II (Cocaine)'); INSERT INTO `ANSWER` VALUES (25, 'Group III (Alcohol)'); INSERT INTO `ANSWER` VALUES (26, 'Group IV (Normal)'); INSERT INTO `ANSWER` VALUES (27, 'Addiction only'); INSERT INTO `ANSWER` VALUES (28, 'Everything'); INSERT INTO `ANSWER` VALUES (29, 'One'); INSERT INTO `ANSWER` VALUES (30, 'Two'); INSERT INTO `ANSWER` VALUES (31, 'EFR'); INSERT INTO `ANSWER` VALUES (32, 'EPR'); INSERT INTO `ANSWER` VALUES (33, 'SFR'); INSERT INTO `ANSWER` VALUES (34, 'SPR'); INSERT INTO `ANSWER` VALUES (62, 'None'); INSERT INTO `ANSWER` VALUES (68, 'Never'); INSERT INTO `ANSWER` VALUES (69, 'Past'); INSERT INTO `ANSWER` VALUES (70, 'Current'); -- -- Dumping data for table `ANSWER_GROUP` -- INSERT INTO `ANSWER_GROUP` VALUES (1, 'Bool'); INSERT INTO `ANSWER_GROUP` VALUES (2, 'KMSK_0-5'); INSERT INTO `ANSWER_GROUP` VALUES (3, 'KMSK_0-3'); INSERT INTO `ANSWER_GROUP` VALUES (4, 'KMSK_Amount'); INSERT INTO `ANSWER_GROUP` VALUES (5, 'KMSK_0-7'); INSERT INTO `ANSWER_GROUP` VALUES (6, 'KMSK_0-6'); INSERT INTO `ANSWER_GROUP` VALUES (7, 'KMSK_Cigars'); INSERT INTO `ANSWER_GROUP` VALUES (8, 'KMSK_0-4'); INSERT INTO `ANSWER_GROUP` VALUES (19, 'Routing Diagnosis'); INSERT INTO `ANSWER_GROUP` VALUES (20, 'Routing Sharing'); INSERT INTO `ANSWER_GROUP` VALUES (21, 'Routing E/S F/P R'); INSERT INTO `ANSWER_GROUP` VALUES (26, 'KMSK_1-4'); INSERT INTO `ANSWER_GROUP` VALUES (51, 'MMTP History'); -- -- Dumping data for table `ANSWER_GROUP_DETAIL` -- INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (1, 1); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (1, 2); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (3, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (8, 3); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (3, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (8, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (26, 4); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (3, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (8, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (26, 5); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (3, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (8, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (26, 6); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (8, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (26, 7); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (2, 8); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (4, 8); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 8); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 8); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 9); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (6, 9); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (5, 10); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (7, 11); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (7, 12); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (19, 23); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (19, 24); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (19, 25); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (19, 26); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (20, 27); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (20, 28); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (7, 29); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (21, 31); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (21, 32); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (21, 33); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (21, 34); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (7, 62); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (51, 68); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (51, 69); INSERT INTO `ANSWER_GROUP_DETAIL` VALUES (51, 70); -- -- Dumping data for table `AUDIT_LOG` -- -- -- Dumping data for table `COLLECT_SITE` -- INSERT INTO `COLLECT_SITE` VALUES (1, 'Rockefeller U. Hospital', 'New York City', 'NY', 'USA'); -- -- Dumping data for table `DBSNP_LOOKUP` -- -- -- Dumping data for table `FORM` -- INSERT INTO `FORM` VALUES (3, 'KMSK', '1', NULL); INSERT INTO `FORM` VALUES (7, 'COVERSHEET', '1', NULL); INSERT INTO `FORM` VALUES (11, 'BloodRouting', '1', NULL); -- -- Dumping data for table `FORM_EVENT` -- -- -- Dumping data for table `QUESTION` -- INSERT INTO `QUESTION` VALUES (146, 2, 'ALCOHOL_1', 'At the time in your life when you were drinking the most alcohol, were you drinking it:', '0'); INSERT INTO `QUESTION` VALUES (147, NULL, 'ALCOHOL_2A', 'When was this?', '1'); INSERT INTO `QUESTION` VALUES (148, NULL, 'ALCOHOL_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (149, 1, 'ALCOHOL_3', 'Are you using currently?', '0'); INSERT INTO `QUESTION` VALUES (150, 3, 'ALCOHOL_4', 'How long did this pattern of drinking last?', '0'); INSERT INTO `QUESTION` VALUES (151, 2, 'ALCOHOL_5', 'During this time when you were drinking the most, how many drinks at a sitting or in a day would you typically drink?', '0'); INSERT INTO `QUESTION` VALUES (152, 1, 'ALCOHOL_6', 'Is alcohol your drug of choice?', '0'); INSERT INTO `QUESTION` VALUES (155, 2, 'TOBACCO_1', 'At the time in your life when you were smoking the most (a) cigarettes or (b) cigars, were you smoking:', '0'); INSERT INTO `QUESTION` VALUES (156, NULL, 'TOBACCO_2A', 'When was this?', '1'); INSERT INTO `QUESTION` VALUES (157, NULL, 'TOBACCO_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (158, 1, 'TOBACCO_3', 'Are you using currently?', '0'); INSERT INTO `QUESTION` VALUES (159, 3, 'TOBACCO_4', 'How long did this pattern of smoking last?', '0'); INSERT INTO `QUESTION` VALUES (160, 2, 'TOBACCO_5', 'How many packs per day of cigarettes would you typically smoke, at your heaviest use?', '0'); INSERT INTO `QUESTION` VALUES (161, 7, 'TOBACCO_6', 'How many cigars per day would you typically smoke, at your heaviest use?(Not scored)', '0'); INSERT INTO `QUESTION` VALUES (162, 1, 'TOBACCO_7', 'Is tobacco your drug of choice?', '0'); INSERT INTO `QUESTION` VALUES (165, 5, 'COCAINE_1', 'At the time in your life when you were using the most cocaine or crack cocaine, were you using it:', '0'); INSERT INTO `QUESTION` VALUES (166, NULL, 'COCAINE_2A', 'When was this?', '1'); INSERT INTO `QUESTION` VALUES (167, NULL, 'COCAINE_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (168, 1, 'COCAINE_3', 'Are you currently using?', '0'); INSERT INTO `QUESTION` VALUES (169, 3, 'COCAINE_4', 'How long did this pattern of cocaine use last?', '0'); INSERT INTO `QUESTION` VALUES (171, 6, 'COCAINE_5', 'Amount Scoring', '0'); INSERT INTO `QUESTION` VALUES (172, 1, 'COCAINE_6', 'Is cocaine your drug of choice?', '0'); INSERT INTO `QUESTION` VALUES (175, 8, 'HEROIN_1', 'At the time in your life when you were using the most (a) heroin or (b) illicit (not prescribed) opiates, were you using it:', '0'); INSERT INTO `QUESTION` VALUES (176, NULL, 'HEROIN_2A', 'When was this?', '1'); INSERT INTO `QUESTION` VALUES (177, NULL, 'HEROIN_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (178, 1, 'HEROIN_3', 'Are you currently using?', '0'); INSERT INTO `QUESTION` VALUES (180, 3, 'HEROIN_4', 'How long did this pattern of heroin and/or opiate use last?', '0'); INSERT INTO `QUESTION` VALUES (181, NULL, 'HEROIN_5', NULL, '1'); INSERT INTO `QUESTION` VALUES (182, 6, 'HEROIN_6', 'During this time when you were using the most heroin or opiates, how much would you typically use/spend at one sitting? (Score as doses)', '0'); INSERT INTO `QUESTION` VALUES (183, 1, 'HEROIN_7', 'Is heroin (opiates) your drug of choice?', '0'); INSERT INTO `QUESTION` VALUES (186, 6, 'MARIJUANA_1', 'At the time in your life when you were using the most marijuana, were you using it:', '0'); INSERT INTO `QUESTION` VALUES (187, NULL, 'MARIJUANA_2A', 'When was this?', '1'); INSERT INTO `QUESTION` VALUES (188, NULL, 'MARIJUANA_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (189, NULL, 'MARIJUANA_3', 'What form of marijuana did you use (e.g., plant, oil, hash, etc.) and how did you typically use it?', '1'); INSERT INTO `QUESTION` VALUES (190, 1, 'MARIJUANA_4', 'Are you using currently?', '0'); INSERT INTO `QUESTION` VALUES (191, 3, 'MARIJUANA_5', 'How long did this pattern of marijuana use last?', '0'); INSERT INTO `QUESTION` VALUES (192, 2, 'MARIJUANA_6', 'During this time when you were using the most, how much marijuana at a sitting would you typically use?', '0'); INSERT INTO `QUESTION` VALUES (193, 1, 'MARIJUANA_7', 'Is marijuana your drug of choice?', '0'); INSERT INTO `QUESTION` VALUES (674, NULL, 'MD_RN_COMPLETING', NULL, '1'); INSERT INTO `QUESTION` VALUES (675, 1, 'SHIP', NULL, '0'); INSERT INTO `QUESTION` VALUES (676, NULL, 'ROUTING_DATE', NULL, '1'); INSERT INTO `QUESTION` VALUES (677, 1, 'ELIGIBLE_SHARING', NULL, '0'); INSERT INTO `QUESTION` VALUES (678, 1, 'IF-B1', NULL, '0'); INSERT INTO `QUESTION` VALUES (679, 1, 'IF-C1', NULL, '0'); INSERT INTO `QUESTION` VALUES (680, 1, 'IF-D1', NULL, '0'); INSERT INTO `QUESTION` VALUES (681, 1, 'IF-B2', NULL, '0'); INSERT INTO `QUESTION` VALUES (682, 1, 'IF-C2', NULL, '0'); INSERT INTO `QUESTION` VALUES (683, 1, 'IF-D2', NULL, '0'); INSERT INTO `QUESTION` VALUES (684, 1, 'IF-B3', NULL, '0'); INSERT INTO `QUESTION` VALUES (685, 1, 'IF-C3', NULL, '0'); INSERT INTO `QUESTION` VALUES (686, 1, 'IF-D3', NULL, '0'); INSERT INTO `QUESTION` VALUES (687, 1, 'RU_CELL_LINE', NULL, '0'); INSERT INTO `QUESTION` VALUES (688, 1, 'NIDA_CELL_LINE', NULL, '0'); INSERT INTO `QUESTION` VALUES (689, 19, 'ROUTING_DIAGNOSIS', NULL, '0'); INSERT INTO `QUESTION` VALUES (690, NULL, 'PSYCHIATRIC_DIAGNOSIS', NULL, '1'); INSERT INTO `QUESTION` VALUES (691, 1, 'ALC_ABUSE', NULL, '0'); INSERT INTO `QUESTION` VALUES (692, 1, 'ALC_DEPENDENT', NULL, '0'); INSERT INTO `QUESTION` VALUES (693, 21, 'ALC_R', NULL, '0'); INSERT INTO `QUESTION` VALUES (694, 1, 'OPI_ABUSE', NULL, '0'); INSERT INTO `QUESTION` VALUES (695, 1, 'OPI_DEPENDENT', NULL, '0'); INSERT INTO `QUESTION` VALUES (696, 21, 'OPI_R', NULL, '0'); INSERT INTO `QUESTION` VALUES (697, 1, 'COC_ABUSE', NULL, '0'); INSERT INTO `QUESTION` VALUES (698, 1, 'COC_DEPENDENT', NULL, '0'); INSERT INTO `QUESTION` VALUES (699, 21, 'COC_R', NULL, '0'); INSERT INTO `QUESTION` VALUES (700, 1, 'CONTACT_GENETIC', NULL, '0'); INSERT INTO `QUESTION` VALUES (701, 1, 'CONTACT_TEST_INFORMATION', NULL, '0'); INSERT INTO `QUESTION` VALUES (702, 1, 'CONTACT_FUTURE_STUDY', NULL, '0'); INSERT INTO `QUESTION` VALUES (703, 1, 'CONTACT_FINDINGS', NULL, '0'); INSERT INTO `QUESTION` VALUES (801, 2, 'OPIATES_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (802, NULL, 'OPIATES_2A', NULL, '1'); INSERT INTO `QUESTION` VALUES (803, NULL, 'OPIATES_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (804, 1, 'OPIATES_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (805, NULL, 'OPIATES_4', NULL, '1'); INSERT INTO `QUESTION` VALUES (806, 3, 'OPIATES_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (807, 8, 'OPIATES_6', NULL, '0'); INSERT INTO `QUESTION` VALUES (808, 1, 'OPIATES_7', NULL, '0'); INSERT INTO `QUESTION` VALUES (809, NULL, 'AMPH_1A', NULL, '1'); INSERT INTO `QUESTION` VALUES (810, NULL, 'AMPH_1B', NULL, '1'); INSERT INTO `QUESTION` VALUES (811, 2, 'AMPH_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (812, NULL, 'AMPH_2A', NULL, '1'); INSERT INTO `QUESTION` VALUES (813, NULL, 'AMPH_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (814, 1, 'AMPH_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (815, 3, 'AMPH_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (816, 26, 'AMPH_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (817, 1, 'AMPH_6', NULL, '0'); INSERT INTO `QUESTION` VALUES (818, 2, 'BENZO_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (819, NULL, 'BENZO_2A', NULL, '1'); INSERT INTO `QUESTION` VALUES (820, NULL, 'BENZO_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (821, 1, 'BENZO_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (822, NULL, 'BENZO_4', NULL, '1'); INSERT INTO `QUESTION` VALUES (823, 3, 'BENZO_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (824, 8, 'BENZO_6', NULL, '0'); INSERT INTO `QUESTION` VALUES (825, 1, 'BENZO_7', NULL, '0'); INSERT INTO `QUESTION` VALUES (826, 2, 'BARB_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (827, NULL, 'BARB_2A', NULL, '1'); INSERT INTO `QUESTION` VALUES (828, NULL, 'BARB_2B', NULL, '1'); INSERT INTO `QUESTION` VALUES (829, 1, 'BARB_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (830, NULL, 'BARB_4', NULL, '1'); INSERT INTO `QUESTION` VALUES (831, 3, 'BARB_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (832, 8, 'BARB_6', NULL, '0'); INSERT INTO `QUESTION` VALUES (833, 1, 'BARB_7', NULL, '0'); INSERT INTO `QUESTION` VALUES (834, 2, 'ALCOHOL_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (835, 3, 'ALCOHOL_30_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (836, 2, 'ALCOHOL_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (837, 1, 'ALCOHOL_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (838, 8, 'TOBACCO_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (839, 3, 'TOBACCO_30_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (840, 2, 'TOBACCO_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (841, 7, 'TOBACCO_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (842, 1, 'TOBACCO_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (843, 8, 'COCAINE_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (844, 3, 'COCAINE_30_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (845, 6, 'COCAINE_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (846, 1, 'COCAINE_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (847, 8, 'HEROIN_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (848, 3, 'HEROIN_30_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (849, NULL, 'HEROIN_30_3', NULL, '1'); INSERT INTO `QUESTION` VALUES (850, 6, 'HEROIN_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (851, 1, 'HEROIN_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (852, 8, 'OPIATES_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (853, NULL, 'OPIATES_30_2', NULL, '1'); INSERT INTO `QUESTION` VALUES (854, 3, 'OPIATES_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (855, 8, 'OPIATES_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (856, 1, 'OPIATES_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (857, 8, 'MARIJUANA_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (858, NULL, 'MARIJUANA_30_2', NULL, '1'); INSERT INTO `QUESTION` VALUES (859, 3, 'MARIJUANA_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (860, 2, 'MARIJUANA_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (861, 1, 'MARIJUANA_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (862, NULL, 'AMPH_30_1A', NULL, '1'); INSERT INTO `QUESTION` VALUES (863, NULL, 'AMPH_30_1B', NULL, '1'); INSERT INTO `QUESTION` VALUES (864, 8, 'AMPH_30_2', NULL, '0'); INSERT INTO `QUESTION` VALUES (865, 3, 'AMPH_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (866, 26, 'AMPH_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (867, 1, 'AMPH_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (868, 8, 'BENZO_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (869, NULL, 'BENZO_30_2', NULL, '1'); INSERT INTO `QUESTION` VALUES (870, 3, 'BENZO_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (871, 8, 'BENZO_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (872, 1, 'BENZO_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (873, 8, 'BARB_30_1', NULL, '0'); INSERT INTO `QUESTION` VALUES (874, NULL, 'BARB_30_2', NULL, '1'); INSERT INTO `QUESTION` VALUES (875, 3, 'BARB_30_3', NULL, '0'); INSERT INTO `QUESTION` VALUES (876, 8, 'BARB_30_4', NULL, '0'); INSERT INTO `QUESTION` VALUES (877, 1, 'BARB_30_5', NULL, '0'); INSERT INTO `QUESTION` VALUES (878, 20, 'SHARING_TYPE', NULL, '0'); INSERT INTO `QUESTION` VALUES (879, 51, 'MMTP_HISTORY', NULL, '0'); INSERT INTO `QUESTION` VALUES (880, NULL, 'ALCOHOL_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (881, NULL, 'TOBACCO_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (882, NULL, 'COCAINE_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (883, NULL, 'HEROIN_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (884, NULL, 'OPIATES_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (885, NULL, 'MARIJUANA_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (886, NULL, 'AMPH_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (887, NULL, 'BENZO_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (888, NULL, 'BARB_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (889, NULL, 'ALCOHOL_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (890, NULL, 'TOBACCO_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (891, NULL, 'COCAINE_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (892, NULL, 'HEROIN_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (893, NULL, 'OPIATES_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (894, NULL, 'MARIJUANA_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (895, NULL, 'AMPH_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (896, NULL, 'BENZO_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (897, NULL, 'BARB_30_COMMENTS', NULL, '1'); INSERT INTO `QUESTION` VALUES (993, NULL, 'AGE_OF_ONSET', NULL, '1'); INSERT INTO `QUESTION` VALUES (1491, NULL, 'ALCOHOL_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1492, NULL, 'TOBACCO_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1493, NULL, 'COCAINE_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1494, NULL, 'HEROIN_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1495, NULL, 'OPIATES_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1496, NULL, 'MARIJUANA_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1497, NULL, 'AMPH_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1498, NULL, 'BENZO_AGE', 'Age of Onset', '1'); INSERT INTO `QUESTION` VALUES (1499, NULL, 'BARB_AGE', 'Age of Onset', '1'); -- -- Dumping data for table `FORM_QUESTION` -- INSERT INTO `FORM_QUESTION` VALUES (3, 146, 1); INSERT INTO `FORM_QUESTION` VALUES (3, 147, 2); INSERT INTO `FORM_QUESTION` VALUES (3, 149, 4); INSERT INTO `FORM_QUESTION` VALUES (3, 150, 5); INSERT INTO `FORM_QUESTION` VALUES (3, 151, 6); INSERT INTO `FORM_QUESTION` VALUES (3, 152, 7); INSERT INTO `FORM_QUESTION` VALUES (3, 155, 8); INSERT INTO `FORM_QUESTION` VALUES (3, 156, 9); INSERT INTO `FORM_QUESTION` VALUES (3, 158, 11); INSERT INTO `FORM_QUESTION` VALUES (3, 159, 12); INSERT INTO `FORM_QUESTION` VALUES (3, 160, 13); INSERT INTO `FORM_QUESTION` VALUES (3, 161, 14); INSERT INTO `FORM_QUESTION` VALUES (3, 162, 15); INSERT INTO `FORM_QUESTION` VALUES (3, 165, 16); INSERT INTO `FORM_QUESTION` VALUES (3, 166, 17); INSERT INTO `FORM_QUESTION` VALUES (3, 168, 19); INSERT INTO `FORM_QUESTION` VALUES (3, 169, 20); INSERT INTO `FORM_QUESTION` VALUES (3, 171, 21); INSERT INTO `FORM_QUESTION` VALUES (3, 172, 22); INSERT INTO `FORM_QUESTION` VALUES (3, 175, 23); INSERT INTO `FORM_QUESTION` VALUES (3, 176, 24); INSERT INTO `FORM_QUESTION` VALUES (3, 178, 26); INSERT INTO `FORM_QUESTION` VALUES (3, 180, 27); INSERT INTO `FORM_QUESTION` VALUES (3, 181, 28); INSERT INTO `FORM_QUESTION` VALUES (3, 182, 29); INSERT INTO `FORM_QUESTION` VALUES (3, 183, 30); INSERT INTO `FORM_QUESTION` VALUES (3, 186, 31); INSERT INTO `FORM_QUESTION` VALUES (3, 187, 32); INSERT INTO `FORM_QUESTION` VALUES (3, 189, 34); INSERT INTO `FORM_QUESTION` VALUES (3, 190, 35); INSERT INTO `FORM_QUESTION` VALUES (3, 191, 36); INSERT INTO `FORM_QUESTION` VALUES (3, 192, 37); INSERT INTO `FORM_QUESTION` VALUES (3, 193, 38); INSERT INTO `FORM_QUESTION` VALUES (3, 801, 39); INSERT INTO `FORM_QUESTION` VALUES (3, 802, 40); INSERT INTO `FORM_QUESTION` VALUES (3, 804, 42); INSERT INTO `FORM_QUESTION` VALUES (3, 805, 43); INSERT INTO `FORM_QUESTION` VALUES (3, 806, 44); INSERT INTO `FORM_QUESTION` VALUES (3, 807, 45); INSERT INTO `FORM_QUESTION` VALUES (3, 808, 46); INSERT INTO `FORM_QUESTION` VALUES (3, 809, 47); INSERT INTO `FORM_QUESTION` VALUES (3, 810, 48); INSERT INTO `FORM_QUESTION` VALUES (3, 811, 49); INSERT INTO `FORM_QUESTION` VALUES (3, 812, 50); INSERT INTO `FORM_QUESTION` VALUES (3, 814, 52); INSERT INTO `FORM_QUESTION` VALUES (3, 815, 53); INSERT INTO `FORM_QUESTION` VALUES (3, 816, 54); INSERT INTO `FORM_QUESTION` VALUES (3, 817, 55); INSERT INTO `FORM_QUESTION` VALUES (3, 818, 56); INSERT INTO `FORM_QUESTION` VALUES (3, 819, 57); INSERT INTO `FORM_QUESTION` VALUES (3, 821, 59); INSERT INTO `FORM_QUESTION` VALUES (3, 822, 60); INSERT INTO `FORM_QUESTION` VALUES (3, 823, 61); INSERT INTO `FORM_QUESTION` VALUES (3, 824, 62); INSERT INTO `FORM_QUESTION` VALUES (3, 825, 63); INSERT INTO `FORM_QUESTION` VALUES (3, 826, 64); INSERT INTO `FORM_QUESTION` VALUES (3, 827, 65); INSERT INTO `FORM_QUESTION` VALUES (3, 829, 67); INSERT INTO `FORM_QUESTION` VALUES (3, 830, 68); INSERT INTO `FORM_QUESTION` VALUES (3, 831, 69); INSERT INTO `FORM_QUESTION` VALUES (3, 832, 70); INSERT INTO `FORM_QUESTION` VALUES (3, 833, 71); INSERT INTO `FORM_QUESTION` VALUES (3, 834, 1); INSERT INTO `FORM_QUESTION` VALUES (3, 835, 2); INSERT INTO `FORM_QUESTION` VALUES (3, 836, 3); INSERT INTO `FORM_QUESTION` VALUES (3, 837, 4); INSERT INTO `FORM_QUESTION` VALUES (3, 838, 5); INSERT INTO `FORM_QUESTION` VALUES (3, 839, 6); INSERT INTO `FORM_QUESTION` VALUES (3, 840, 7); INSERT INTO `FORM_QUESTION` VALUES (3, 841, 8); INSERT INTO `FORM_QUESTION` VALUES (3, 842, 9); INSERT INTO `FORM_QUESTION` VALUES (3, 843, 10); INSERT INTO `FORM_QUESTION` VALUES (3, 844, 11); INSERT INTO `FORM_QUESTION` VALUES (3, 845, 12); INSERT INTO `FORM_QUESTION` VALUES (3, 846, 13); INSERT INTO `FORM_QUESTION` VALUES (3, 847, 14); INSERT INTO `FORM_QUESTION` VALUES (3, 848, 15); INSERT INTO `FORM_QUESTION` VALUES (3, 849, 16); INSERT INTO `FORM_QUESTION` VALUES (3, 850, 17); INSERT INTO `FORM_QUESTION` VALUES (3, 851, 18); INSERT INTO `FORM_QUESTION` VALUES (3, 852, 19); INSERT INTO `FORM_QUESTION` VALUES (3, 853, 20); INSERT INTO `FORM_QUESTION` VALUES (3, 854, 21); INSERT INTO `FORM_QUESTION` VALUES (3, 855, 22); INSERT INTO `FORM_QUESTION` VALUES (3, 856, 23); INSERT INTO `FORM_QUESTION` VALUES (3, 857, 24); INSERT INTO `FORM_QUESTION` VALUES (3, 858, 25); INSERT INTO `FORM_QUESTION` VALUES (3, 859, 26); INSERT INTO `FORM_QUESTION` VALUES (3, 860, 27); INSERT INTO `FORM_QUESTION` VALUES (3, 861, 28); INSERT INTO `FORM_QUESTION` VALUES (3, 862, 29); INSERT INTO `FORM_QUESTION` VALUES (3, 863, 30); INSERT INTO `FORM_QUESTION` VALUES (3, 864, 31); INSERT INTO `FORM_QUESTION` VALUES (3, 865, 32); INSERT INTO `FORM_QUESTION` VALUES (3, 866, 33); INSERT INTO `FORM_QUESTION` VALUES (3, 867, 34); INSERT INTO `FORM_QUESTION` VALUES (3, 868, 35); INSERT INTO `FORM_QUESTION` VALUES (3, 869, 36); INSERT INTO `FORM_QUESTION` VALUES (3, 870, 37); INSERT INTO `FORM_QUESTION` VALUES (3, 871, 38); INSERT INTO `FORM_QUESTION` VALUES (3, 872, 39); INSERT INTO `FORM_QUESTION` VALUES (3, 873, 40); INSERT INTO `FORM_QUESTION` VALUES (3, 874, 41); INSERT INTO `FORM_QUESTION` VALUES (3, 875, 42); INSERT INTO `FORM_QUESTION` VALUES (3, 876, 43); INSERT INTO `FORM_QUESTION` VALUES (3, 877, 44); INSERT INTO `FORM_QUESTION` VALUES (3, 880, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 881, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 882, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 883, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 884, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 885, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 886, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 887, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 888, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 889, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 890, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 891, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 892, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 893, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 894, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 895, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 896, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 897, 0); INSERT INTO `FORM_QUESTION` VALUES (3, 1491, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1492, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1493, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1494, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1495, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1496, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1497, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1498, NULL); INSERT INTO `FORM_QUESTION` VALUES (3, 1499, NULL); INSERT INTO `FORM_QUESTION` VALUES (11, 674, 1); INSERT INTO `FORM_QUESTION` VALUES (11, 675, 2); INSERT INTO `FORM_QUESTION` VALUES (11, 676, 3); INSERT INTO `FORM_QUESTION` VALUES (11, 677, 4); INSERT INTO `FORM_QUESTION` VALUES (11, 678, 5); INSERT INTO `FORM_QUESTION` VALUES (11, 679, 6); INSERT INTO `FORM_QUESTION` VALUES (11, 680, 7); INSERT INTO `FORM_QUESTION` VALUES (11, 681, 8); INSERT INTO `FORM_QUESTION` VALUES (11, 682, 9); INSERT INTO `FORM_QUESTION` VALUES (11, 683, 10); INSERT INTO `FORM_QUESTION` VALUES (11, 684, 11); INSERT INTO `FORM_QUESTION` VALUES (11, 685, 12); INSERT INTO `FORM_QUESTION` VALUES (11, 686, 13); INSERT INTO `FORM_QUESTION` VALUES (11, 687, 14); INSERT INTO `FORM_QUESTION` VALUES (11, 688, 15); INSERT INTO `FORM_QUESTION` VALUES (11, 689, 16); INSERT INTO `FORM_QUESTION` VALUES (11, 690, 17); INSERT INTO `FORM_QUESTION` VALUES (11, 691, 18); INSERT INTO `FORM_QUESTION` VALUES (11, 692, 19); INSERT INTO `FORM_QUESTION` VALUES (11, 693, 20); INSERT INTO `FORM_QUESTION` VALUES (11, 694, 21); INSERT INTO `FORM_QUESTION` VALUES (11, 695, 22); INSERT INTO `FORM_QUESTION` VALUES (11, 696, 23); INSERT INTO `FORM_QUESTION` VALUES (11, 697, 24); INSERT INTO `FORM_QUESTION` VALUES (11, 698, 25); INSERT INTO `FORM_QUESTION` VALUES (11, 699, 26); INSERT INTO `FORM_QUESTION` VALUES (11, 700, 27); INSERT INTO `FORM_QUESTION` VALUES (11, 701, 28); INSERT INTO `FORM_QUESTION` VALUES (11, 702, 29); INSERT INTO `FORM_QUESTION` VALUES (11, 703, 30); INSERT INTO `FORM_QUESTION` VALUES (11, 878, 5); INSERT INTO `FORM_QUESTION` VALUES (11, 879, 18); INSERT INTO `FORM_QUESTION` VALUES (11, 993, 0); -- -- Dumping data for table `FORM_SIGNOFF` -- -- -- Dumping data for table `GENE` -- -- -- Dumping data for table `GENOTYPE_RESULT` -- -- -- Dumping data for table `GROUP` -- -- -- Dumping data for table `MASTER` -- -- -- Dumping data for table `METHOD` -- -- -- Dumping data for table `PERMISSION` -- INSERT INTO `PERMISSION` VALUES (1, 'View Personal Data'); INSERT INTO `PERMISSION` VALUES (2, 'View Clinical Data'); INSERT INTO `PERMISSION` VALUES (3, 'View Genotype Data'); INSERT INTO `PERMISSION` VALUES (4, 'Enter Clinical Data'); INSERT INTO `PERMISSION` VALUES (5, 'Enter Genotype Data'); INSERT INTO `PERMISSION` VALUES (6, 'Export Clinical Data'); INSERT INTO `PERMISSION` VALUES (7, 'Export Genotype Data'); INSERT INTO `PERMISSION` VALUES (8, 'Verify Clinical Data'); INSERT INTO `PERMISSION` VALUES (9, 'Verify Genotype Data'); INSERT INTO `PERMISSION` VALUES (10, 'Enter Personal Data'); INSERT INTO `PERMISSION` VALUES (11, 'Export Personal Data'); -- -- Dumping data for table `RESPONSE` -- -- -- Dumping data for table `RESULT` -- -- -- Dumping data for table `ROLE` -- INSERT INTO `ROLE` VALUES (1, 'Data Entry'); INSERT INTO `ROLE` VALUES (2, 'Researcher'); INSERT INTO `ROLE` VALUES (3, 'Clinician'); INSERT INTO `ROLE` VALUES (4, 'Administrator'); INSERT INTO `ROLE` VALUES (5, 'Head'); -- -- Dumping data for table `ROLE_PERM` -- INSERT INTO `ROLE_PERM` VALUES (1, 1); INSERT INTO `ROLE_PERM` VALUES (3, 1); INSERT INTO `ROLE_PERM` VALUES (4, 1); INSERT INTO `ROLE_PERM` VALUES (1, 2); INSERT INTO `ROLE_PERM` VALUES (3, 2); INSERT INTO `ROLE_PERM` VALUES (4, 2); INSERT INTO `ROLE_PERM` VALUES (5, 2); INSERT INTO `ROLE_PERM` VALUES (1, 3); INSERT INTO `ROLE_PERM` VALUES (2, 3); INSERT INTO `ROLE_PERM` VALUES (3, 3); INSERT INTO `ROLE_PERM` VALUES (4, 3); INSERT INTO `ROLE_PERM` VALUES (5, 3); INSERT INTO `ROLE_PERM` VALUES (1, 4); INSERT INTO `ROLE_PERM` VALUES (3, 4); INSERT INTO `ROLE_PERM` VALUES (4, 4); INSERT INTO `ROLE_PERM` VALUES (1, 5); INSERT INTO `ROLE_PERM` VALUES (2, 5); INSERT INTO `ROLE_PERM` VALUES (3, 5); INSERT INTO `ROLE_PERM` VALUES (4, 5); INSERT INTO `ROLE_PERM` VALUES (5, 5); INSERT INTO `ROLE_PERM` VALUES (2, 6); INSERT INTO `ROLE_PERM` VALUES (3, 6); INSERT INTO `ROLE_PERM` VALUES (4, 6); INSERT INTO `ROLE_PERM` VALUES (5, 6); INSERT INTO `ROLE_PERM` VALUES (2, 7); INSERT INTO `ROLE_PERM` VALUES (3, 7); INSERT INTO `ROLE_PERM` VALUES (4, 7); INSERT INTO `ROLE_PERM` VALUES (5, 7); INSERT INTO `ROLE_PERM` VALUES (3, 8); INSERT INTO `ROLE_PERM` VALUES (4, 8); INSERT INTO `ROLE_PERM` VALUES (2, 9); INSERT INTO `ROLE_PERM` VALUES (3, 9); INSERT INTO `ROLE_PERM` VALUES (4, 9); INSERT INTO `ROLE_PERM` VALUES (5, 9); INSERT INTO `ROLE_PERM` VALUES (1, 10); INSERT INTO `ROLE_PERM` VALUES (3, 10); INSERT INTO `ROLE_PERM` VALUES (4, 10); INSERT INTO `ROLE_PERM` VALUES (4, 11); -- -- Dumping data for table `SOURCE_DB` -- -- -- Dumping data for table `SUBJECT` -- -- -- Dumping data for table `TEST` -- -- -- Dumping data for table `USER` -- INSERT INTO `USER` VALUES (1, 'debuser', '*', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL); -- -- Dumping data for table `USER_GROUP` -- -- -- Dumping data for table `VARIANT` -- -- create a 'superGroup' for testing INSERT INTO `GROUP` VALUES ( 1, 'SuperGroup'); -- assign the 'administrator - supergroup' set with 'Data Entry' privilage INSERT INTO `USER_GROUP` VALUES ( 1, 1, 4); -- userid, GROUP_ID, ROLE_ID