install.sql

太烦了

INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (506, 'Liechtenstein', 35, 30);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (507, 'Malta', 35, 31);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (508, 'Netherlands, The', 35, 32);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (509, 'Romania', 35, 33);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (510, 'Slovakia', 35, 34);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (511, 'Sweden', 35, 35);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (512, 'Vatican City State', 35, 36);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (513, 'Belarus', 35, 37);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (514, 'Croatia', 35, 38);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (515, 'Estonia', 35, 39);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (516, 'Germany', 35, 40);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (517, 'Ireland', 35, 41);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (518, 'Lithuania', 35, 42);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (519, 'Moldova', 35, 43);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (520, 'Norway', 35, 44);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (521, 'Russia', 35, 45);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (522, 'Slovenia', 35, 46);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (523, 'Switzerland', 35, 47);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (524, 'United States', 37, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (525, 'St. Pierre', 37, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (526, 'Canada', 37, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (527, 'Greenland', 37, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (528, 'Mexico', 37, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (529, 'Anguilla', 38, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (530, 'Bahamas', 38, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (531, 'Bolivia', 38, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (532, 'Chile', 38, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (533, 'Dominican Republic', 38, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (534, 'French Guiana', 38, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (535, 'Guyana', 38, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (536, 'Martinique', 38, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (537, 'Panama', 38, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (538, 'St. Kitts', 38, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (539, 'Suriname', 38, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (540, 'Venezuela', 38, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (541, 'Antigua', 38, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (542, 'Barbados', 38, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (543, 'Bouvet Island', 38, 15);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (544, 'Colombia', 38, 16);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (545, 'Ecuador', 38, 17);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (546, 'Grenada', 38, 18);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (547, 'Haiti', 38, 19);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (548, 'Montserrat', 38, 20);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (549, 'Paraguay', 38, 21);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (550, 'St. Lucia', 38, 22);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (551, 'Trinidad and Tobago', 38, 23);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (552, 'Virgin Islands (Br.)', 38, 24);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (553, 'Argentina', 38, 25);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (554, 'Belize', 38, 26);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (555, 'Brazil', 38, 27);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (556, 'Costa Rica', 38, 28);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (557, 'El Salvador', 38, 29);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (558, 'Guadeloupe', 38, 30);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (559, 'Honduras', 38, 31);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (560, 'Netherlands Antiles', 38, 32);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (561, 'Peru', 38, 33);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (562, 'St. Vincent', 38, 34);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (563, 'Turks and Caicos', 38, 35);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (564, 'Virgin Islands (US)', 38, 36);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (565, 'Aruba', 38, 37);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (566, 'Bermuda', 38, 38);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (567, 'Cayman Islands', 38, 39);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (568, 'Dominica', 38, 40);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (569, 'Falkland Islands', 38, 41);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (570, 'Guatemala', 38, 42);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (571, 'Jamaica', 38, 43);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (572, 'Nicaragua', 38, 44);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (573, 'Puerto Rico', 38, 45);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (574, 'South Georgia', 38, 46);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (575, 'Uruguay', 38, 47);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (576, 'How important is your match''s religion to you?', 20, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (577, 'How important is your match''s religious denomination to you?', 20, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (578, 'I try to make sure that my position prevails (that I win)', 27, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (579, 'How important is your match''s distance from you?', 32, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (581, 'Toned', 33, 7);


CREATE TABLE `__DB_PREFIX__compQuest_question` (
  `qid` int(11) NOT NULL auto_increment,
  `question` text NOT NULL,
  `type` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `maxopt` int(11) NOT NULL default '0',
  `ord` int(11) NOT NULL default '0',
  `minopt` int(11) default '0',
  `showopt` int(11) default '0',
  PRIMARY KEY  (`qid`)
) AUTO_INCREMENT=39 ;


INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (1, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 1, 7, 1, 0, 0);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (9, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 7, 7, 1, 0, 0);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (10, 'Imagine that your friends had to choose the best FOUR descriptions of you from the items listed below. Click next to the four items that they would be most likely to pick:', 2, 11, 4, 1, 4, 4);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (11, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 8, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (12, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 9, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (13, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 10, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (14, 'Please use the scale below to rate how well you believe each of the following words generally describes you', 1, 11, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (15, 'Use the scale below to indicate how well each of the following describes you.<br/><br/>Remember: There are no right or wrong answers. Please be honest with us, and yourself, as possible', 1, 12, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (16, 'Use the scale below to indicate how well each of the following describes you', 1, 13, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (17, 'Please use the scale below to rate how often during the past month you have felt the following ways', 1, 14, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (18, 'Use the scale below to indicate how important each of the following characteristics would be to you in finding a partner for a relationship', 1, 15, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (20, 'Please use the scale below to answer next questions', 1, 16, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (21, 'Please decide whether each of the following statements is a good description of you. For statements that are <b>NOT</b> at all like you, please click "<b>F</b>" for False. For statements that are at least somewhat like you, click "<b>T</b>" for True', 1, 17, 2, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (22, 'Please use the scale below to rate your interest in the following things', 1, 18, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (23, 'Please use the scale below to rate your interest in the following things', 1, 19, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (24, 'Please use the scale below to rate your interest in the following things', 1, 20, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (25, 'Please use the scale below to rate your approximate level of skill in each of the following areas. Try to consider each skill as it relates to your personal life, and not necessarily from a work or career perspective', 1, 21, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (26, 'From the list below, please choose <b>the three that you do the best</b>. Remember to consider these skills as they relate to your entire life, and not necessarily just your work or career activities', 2, 22, 3, 1, 3, 2);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (27, 'Please rate how important to you each of the following factors is when you are involved in a conflict or argument with a friend, co-worker or family member', 1, 23, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (28, 'When you think about what you want in a relationship, how important are the following items?<br/>Please use the scale below to select your answers', 1, 24, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (29, 'Please indicate how well each of the following statements describe you. There are no "right" or "wrong" answers, so select the answer that most closely describes you', 1, 25, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (30, 'Please use the scale below to tell us how well each of the following describes your relationship with your parents (or guardians) when you were growing up. If your parents were not both equally present, please focus on the parent with whom you felt the closest and most involved', 1, 26, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (31, 'Using the same scale, how well do the following describe your relationship with your parents now? If deceased describe your relationship when they were alive. Please focus on the parent with whom you feel the closest and most involved', 1, 26, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (32, 'Please use the scale below to answer next questions', 1, 27, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (33, 'Rate the following words as to how each one describes your physical appearance. Use the following rating scale for each item', 1, 27, 7, 1, NULL, NULL);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (35, 'Please select the countries we should search for your matches. (Check all that apply)<br/><br/><b>Europe</b>', 2, 28, 99, 1, 0, 3);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (37, '<b>North America</b>', 2, 28, 5, 2, 0, 3);
INSERT INTO `__DB_PREFIX__compQuest_question` VALUES (38, '<b>South America</b>', 2, 28, 99, 3, 0, 3);



CREATE TABLE `__DB_PREFIX__compQuest_section` (
  `sid` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `ord` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) AUTO_INCREMENT=29 ;


INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (1, 'Section 1: Self Descriptions', 1);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (7, 'Section 1: Self Descriptions (continued)', 2);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (8, 'Section 1: Self Descriptions (continued)', 3);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (9, 'Section 1: Self Descriptions (continued)', 4);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (10, 'Section 1: Self Descriptions (continued)', 5);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (11, 'Section 1: Self Descriptions (continued)', 6);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (12, 'Section 2: Personal Characteristics', 7);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (13, 'Section 2: Personal Characteristics (continued)', 8);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (14, 'Section 3: About Your Feelings', 9);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (15, 'Section 4: Important Qualities', 10);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (16, 'Section 5: Personal Beliefs', 11);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (17, 'Section 6: About Your Personality', 12);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (18, 'Section 7: Your Personal Interests', 13);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (19, 'Section 7: Your Personal Interests (continued)', 14);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (20, 'Section 7: Your Personal Interests (continued)', 15);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (21, 'Section 8: Living Skills', 16);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (22, 'Section 8: Living Skills (continued)', 17);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (23, 'Section 9: Communication Style', 18);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (24, 'Section 10: Relationship Style', 19);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (25, 'Section 11: More About You', 20);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (26, 'Section 12: Family Relationships', 21);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (27, 'Section 13: General Information', 23);
INSERT INTO `__DB_PREFIX__compQuest_section` VALUES (28, 'Section 14: Matching Information', 22);