Digital_Repository/Misc/survey_1.sql at 306ce8fa1f6a963a67d8f587e4c2fecc30412ae0

nigel.stanger / Digital_Repository
Find file
Newer
Older
Digital_Repository / Misc / survey_1.sql
Nigel Stanger on 7 May 2013 52 KB - Imported Misc directory.
Raw Blame History
#<pre>
# SURVEYOR SURVEY DUMP
#
# This is a dumped survey from the PHPSurveyor Script
# http://www.phpsurveyor.org/

# NEW TABLE
# SURVEYS TABLE
#
INSERT INTO surveys (`sid`, `short_title`, `description`, `admin`, `active`, `welcome`, `useexpiry`, `expires`, `adminemail`, `private`, `faxto`, `format`, `template`, `url`, `urldescrip`, `language`, `datestamp`, `ipaddr`, `usecookie`, `notification`, `allowregister`, `attribute1`, `attribute2`, `email_invite_subj`, `email_invite`, `email_remind_subj`, `email_remind`, `email_register_subj`, `email_register`, `email_confirm_subj`, `email_confirm`, `allowsave`, `autonumber_start`, `autoredirect`, `allowprev`) VALUES ('1', 'Otago Repository Usage Survey', 'A survey to help find out why the Otago EPrints Repository is so popular.', 'Nigel Stanger', 'N', '<p>Welcome to the Otago Repository Usage Survey. The Otago Repository seems to have been wildly popular since its launch on November 17 2005, with a grand total of over 35,000 downloads from more than 110 countries as of early April 2006. This is clearly quite spectacular and exhibits a much greater growth rate than several other similar repositories.</p>\n\n<p>We therefore invite you to complete our survey so that we might better understand the sources and interests of our visitors, which in turn will help us determine why the Otago Repository has experienced such high traffic growth. The survey is open to all \"end-users\" of the repository, including authors of items in the repository.</p>\n\n<p>You will be asked several questions about how and why you discovered the Otago Repository, and how you have used the repository since. You will also be given an opportunity to provide us with your own thoughts as to why we might be experiencing such spectacular traffic growth and how we might further enhance the repository. Questions marked with a red asterisk (<span style=\"color:red;\">*</span>) must be answered.</p>\n\n<p>No personally identifying information is collected during the survey and all responses are anonymous. Note that the IP address of the computer that you use to complete the survey will be logged and a cookie will be saved to that computer as a simple measure to avoid \"survey spam\". This means that the survey normally cannot be completed more than once from the same computer. The cookie does not identify you, nor is it associated with your survey responses in any way.</p>', 'N', '1980-01-01', 'nigel.stanger@gmail.com', 'Y', '', 'G', 'bluengrey', 'http://ou075110.otago.ac.nz:8008/', 'Return to the repository home page', 'english', 'Y', 'Y', 'Y', '0', 'N', '', '', 'Invitation to participate in survey', 'Dear {FIRSTNAME},\n\nYou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}', 'Reminder to participate in survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}', 'Survey Registration Confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of completed survey', 'Dear {FIRSTNAME},\n\nThis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', 'Y', '0', 'N', 'Y');

# NEW TABLE
# GROUPS TABLE
#
INSERT INTO groups (`gid`, `sid`, `group_name`, `description`) VALUES ('1', '1', 'Page 1: Why did you come here?', 'The questions on this page relate to why you visited the Otago Repository. You may be asked additional follow-up questions depending on your answers.');
INSERT INTO groups (`gid`, `sid`, `group_name`, `description`) VALUES ('2', '1', 'Page 2: Previous visits', 'The questions on this page relate to whether you have previously visited the Otago Repository and how frequently you visit. You may be asked additional follow-up questions depending on your answers.');
INSERT INTO groups (`gid`, `sid`, `group_name`, `description`) VALUES ('3', '1', 'Page 3: How did you find us?', 'The questions on this page relate to how you discovered the Otago Repository. You may be asked additional follow-up questions depending on your answers.');
INSERT INTO groups (`gid`, `sid`, `group_name`, `description`) VALUES ('4', '1', 'Page 4: Miscellaneous', 'The questions on this page provide an opportunity for you to give us your thoughts on various aspects of the Otago Repository and how it might be enhanced. All of the questions on this page are optional.');
INSERT INTO groups (`gid`, `sid`, `group_name`, `description`) VALUES ('6', '1', 'Page 5: Tell us about yourself', 'The questions in this section collect some useful demographic information that will help us in our analysis of the results. There is nothing in these questions that can be used personally identify you, but you may choose not to answer these questions if you wish.');

# NEW TABLE
# QUESTIONS TABLE
#
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('1', '1', '1', 'L', 'Q1a', 'What is your main reason for visiting the Otago Repository?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('2', '1', '1', 'T', 'Q1b', 'Which specific author(s) are you interested in?', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('3', '1', '2', 'Y', 'Q2a', 'Have you visited the Otago Repository before?', '', '', 'N', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('4', '1', '2', 'L', 'Q2b', 'How many times have you visited the Otago Repository?', '', '', 'N', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('5', '1', '2', 'L', 'Q2c', 'What is your main reason for returning?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('6', '1', '3', 'M', 'Q3a', 'How did you find out about the Otago Repository?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('7', '1', '3', 'L', 'Q3b', 'Where did you see the announcement or news item?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('8', '1', '3', 'L', 'Q3c', 'Which general web search engine did you use?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('9', '1', '3', 'L', 'Q3d', 'Which specialised research search engine or aggregator did you use?', '', '', 'Y', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('10', '1', '3', 'L', 'Q3c1', 'At approximately what position did the Otago Repository appear in the search results?', '', '', 'N', 'Y', '1');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('11', '1', '3', 'L', 'Q3d1', 'At approximately what position did the Otago Repository appear in the search results?', '', '', 'N', 'Y', '1');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('12', '1', '4', 'A', 'Q4a', 'Please rate the Otago Repository on the following attributes, where 1 is best and 5 is worst:', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('13', '1', '4', 'U', 'Q4b', 'What additional feature(s) do you think might enhance the Otago Repository?', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('14', '1', '4', 'U', 'Q4d', 'Please enter any other comments that you would like to make.', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('17', '1', '2', 'T', 'Q2d', 'Which specific author(s) are you interested in?', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('18', '1', '2', 'L', 'Q2b1', 'How frequently do you visit the Otago Repository?', '', '', 'N', 'Y', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('27', '1', '6', 'M', 'Q5d', 'Are you associated with the University of Otago or the Otago Repository?', '', '', 'Y', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('26', '1', '6', 'T', 'Q5c', 'What is your primary area of expertise (e.g., Marketing, Computer Science, History)?', '', '', 'N', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('24', '1', '6', '!', 'Q5a', 'Which country are you connecting from?', '', '', 'Y', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('25', '1', '6', 'L', 'Q5b', 'What kind of organisation are you connecting from?', '', '', 'Y', 'N', '0');
INSERT INTO questions (`qid`, `sid`, `gid`, `type`, `title`, `question`, `preg`, `help`, `other`, `mandatory`, `lid`) VALUES ('23', '1', '4', 'U', 'Q4c', 'Do you have any thoughts as to why there is so much apparent interest in the Otago Repository?', '', '', 'N', 'N', '0');

# NEW TABLE
# ANSWERS TABLE
#
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'SRCH', 'No particular reason; it just appeared in the search results', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'RREP', 'Otago\'s research reputation', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'SOB', 'Because it\'s mainly School of Business publications', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'AUTH', 'I\'m looking for work by a specific author or authors (please provide more detail at Q1b below)', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'CURIS', 'I heard that Otago had a repository and was curious', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'FIRST', 'Because it\'s New Zealand\'s first publicly available repository', 'N', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'CITED', 'It was cited in a paper', 'N', '00006');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('4', '5DOWN', 'Less than five times', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('4', '5TEN', 'Between five and ten times', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('4', '1020', 'Between ten and twenty times', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('4', '20UP', 'More than twenty times', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('5', 'SRCH', 'No particular reason; it just appeared in the search results', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('5', 'SLCTN', 'The repository has a great selection of papers', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('5', 'DUNNO', 'Don\'t know', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('6', 'MOUTH', 'Heard about it through word of mouth', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('6', 'FORML', 'Saw an announcement or news item about it in the press or on a web site (please provide more detail at Q3b below)', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('6', 'GSRCH', 'Found it through a general web search engine (please provide more detail at Q3c and Q3c1 below)', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('6', 'SSRCH', 'Found it through a specialised research search engine or aggregator (please provide more detail at Q3d and Q3d1 below)', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('7', 'OUWEB', 'University of Otago web site', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('7', 'AWIKI', 'AuseAccess wiki', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('7', 'AMSCI', 'American Scientist forum', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('8', 'ALTAV', 'AltaVista', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('8', 'ASK', 'Ask.com', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('8', 'GOOGL', 'Google (excluding Google Scholar)', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('8', 'MSN', 'MSN', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('8', 'YAHOO', 'Yahoo!', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('9', 'CBASE', 'Citebase', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('9', 'CSEER', 'Citeseer', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('9', 'GSCOL', 'Google Scholar', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('9', 'OASTR', 'OAIster', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('9', 'ROAR', 'Registry of Open Access Repositories (ROAR)', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'P1', 'First', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'P2', 'Second', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'P3', 'Third', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'P4', 'Fourth', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'P5', 'Fifth', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'PAGE1', 'On the first page of results', 'N', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'PAGE2', 'On the second page of results', 'N', '00006');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'PAGEN', 'On the third or later page of results', 'N', '00007');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'DUNNO', 'Don\'t know', 'N', '00008');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('10', 'NA', 'N/A', 'N', '00009');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'DUNNO', 'Don\'t know', 'N', '00008');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'NA', 'N/A', 'N', '00009');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'P1', 'First', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'P2', 'Second', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'P3', 'Third', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'P4', 'Fourth', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'P5', 'Fifth', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'PAGE1', 'On the first page of results', 'N', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'PAGE2', 'On the second page of results', 'N', '00006');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('11', 'PAGEN', 'On the third or later page of results', 'N', '00007');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('12', 'DESI', 'Site design', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('12', 'CONT', 'Quality of content', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('12', 'SRCH', 'Ease of searching', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('12', 'BRWS', 'Ease of browsing', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('4', 'DUNNO', 'Don\'t know', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('7', 'SBWEB', 'School of Business web site', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('5', 'AUTH', 'The repository has papers by a specific author or authors', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', 'L1MTH', 'Less than once per month', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', '12MTH', 'Once or twice per month', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', '12WK', 'Once or twice per week', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', '1DAY', 'Once per day', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', 'MDAY', 'Several times per day', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('18', 'DUNNO', 'Don\'t know', 'N', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('5', 'NEW', 'I want to see if any new items have been added', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SO', 'Somalia', '', '00192');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SB', 'Solomon Islands', '', '00191');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SI', 'Slovenia', '', '00190');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SK', 'Slovakia', '', '00189');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SL', 'Sierra Leone', '', '00187');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SG', 'Singapore', '', '00188');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SC', 'Seychelles', '', '00186');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SN', 'Senegal', '', '00185');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SA', 'Saudi Arabia', '', '00184');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ST', 'Sao Tome and Principe', '', '00183');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'WS', 'Samoa', '', '00181');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SM', 'San Marino', '', '00182');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VC', 'Saint Vincent and the Grenadines', '', '00180');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PM', 'Saint Pierre and Miquelon', '', '00179');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LC', 'Saint Lucia', '', '00178');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KN', 'Saint Kitts and Nevis', '', '00177');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SH', 'Saint Helena', '', '00176');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'RW', 'Rwanda', '', '00175');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'RU', 'Russian Federation', '', '00174');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'RO', 'Romania', '', '00173');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'RE', 'Reunion', '', '00172');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'QA', 'Qatar', '', '00171');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PR', 'Puerto Rico', '', '00170');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PT', 'Portugal', '', '00169');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PL', 'Poland', '', '00168');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PN', 'Pitcairn', '', '00167');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PH', 'Philippines', '', '00166');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PE', 'Peru', '', '00165');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PY', 'Paraguay', '', '00164');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PG', 'Papua New Guinea', '', '00163');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PA', 'Panama', '', '00162');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PS', 'Palestine', '', '00161');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PW', 'Palau', '', '00160');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PK', 'Pakistan', '', '00159');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'OM', 'Oman', '', '00158');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NO', 'Norway', '', '00157');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MP', 'Northern Mariana Islands', '', '00156');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NF', 'Norfolk Island', '', '00154');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NU', 'Niue', '', '00153');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NG', 'Nigeria', '', '00152');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NE', 'Niger', '', '00151');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NI', 'Nicaragua', '', '00150');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NZ', 'New Zealand', '', '00149');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NC', 'New Caledonia', '', '00148');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AN', 'Netherlands Antilles', '', '00147');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NL', 'Netherlands', '', '00146');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NP', 'Nepal', '', '00145');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NR', 'Nauru', '', '00144');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'NA', 'Namibia', '', '00143');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MM', 'Myanmar', '', '00142');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MZ', 'Mozambique', '', '00141');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MA', 'Morocco', '', '00140');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MS', 'Montserrat', '', '00139');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MN', 'Mongolia', '', '00138');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MC', 'Monaco', '', '00137');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MD', 'Moldova', '', '00136');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FM', 'Micronesia', '', '00135');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MX', 'Mexico', '', '00134');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'YT', 'Mayotte', '', '00133');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MU', 'Mauritius', '', '00132');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MR', 'Mauritania', '', '00131');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MQ', 'Martinique', '', '00130');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MH', 'Marshall Islands', '', '00129');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MT', 'Malta', '', '00128');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ML', 'Mali', '', '00127');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MV', 'Maldives', '', '00126');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MY', 'Malaysia', '', '00125');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MW', 'Malawi', '', '00124');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MG', 'Madagascar', '', '00123');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MK', 'Macedonia', '', '00122');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'MO', 'Macau', '', '00121');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LU', 'Luxembourg', '', '00120');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LT', 'Lithuania', '', '00119');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LI', 'Liechtenstein', '', '00118');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LY', 'Libya', '', '00117');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LR', 'Liberia', '', '00116');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LS', 'Lesotho', '', '00115');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LB', 'Lebanon', '', '00114');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LV', 'Latvia', '', '00113');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LA', 'Laos', '', '00112');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KG', 'Kyrgyzstan', '', '00111');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KW', 'Kuwait', '', '00110');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KR', 'South Korea', '', '00195');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KP', 'North Korea', '', '00155');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KI', 'Kiribati', '', '00109');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KE', 'Kenya', '', '00108');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KZ', 'Kazakhstan', '', '00107');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'JO', 'Jordan', '', '00106');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'JP', 'Japan', '', '00105');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'JM', 'Jamaica', '', '00104');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IT', 'Italy', '', '00103');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IL', 'Israel', '', '00102');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IE', 'Ireland', '', '00101');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IQ', 'Iraq', '', '00100');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IR', 'Iran', '', '00099');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ID', 'Indonesia', '', '00098');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IN', 'India', '', '00097');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IS', 'Iceland', '', '00096');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HU', 'Hungary', '', '00095');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HK', 'Hong Kong', '', '00094');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HN', 'Honduras', '', '00093');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HM', 'Heard and McDonald Islands', '', '00092');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HT', 'Haiti', '', '00091');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GY', 'Guyana', '', '00090');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GW', 'Guinea-Bissau', '', '00089');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GN', 'Guinea', '', '00088');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GT', 'Guatemala', '', '00087');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GU', 'Guam', '', '00086');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GP', 'Guadeloupe', '', '00085');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GD', 'Grenada', '', '00084');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GL', 'Greenland', '', '00083');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GR', 'Greece', '', '00082');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GI', 'Gibraltar', '', '00081');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GH', 'Ghana', '', '00080');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DE', 'Germany', '', '00079');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GE', 'Georgia', '', '00078');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GM', 'Gambia', '', '00077');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GA', 'Gabon', '', '00076');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TF', 'French Southern Territories', '', '00075');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'PF', 'French Polynesia', '', '00074');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GF', 'French Guiana', '', '00073');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FR', 'France', '', '00072');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FI', 'Finland', '', '00071');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FJ', 'Fiji', '', '00070');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FO', 'Faroe Islands', '', '00069');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'FK', 'Falkland Islands', '', '00068');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ET', 'Ethiopia', '', '00067');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'EE', 'Estonia', '', '00066');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ER', 'Eritrea', '', '00065');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GQ', 'Equatorial Guinea', '', '00064');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SV', 'El Salvador', '', '00063');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'EG', 'Egypt', '', '00062');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'EC', 'Ecuador', '', '00061');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DO', 'Dominican Republic', '', '00060');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DM', 'Dominica', '', '00059');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DJ', 'Djibouti', '', '00058');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DK', 'Denmark', '', '00057');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CZ', 'Czech Republic', '', '00056');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CY', 'Cyprus', '', '00055');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CU', 'Cuba', '', '00054');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'HR', 'Croatia', '', '00053');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CI', 'C?te d\'Ivoire', '', '00052');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CR', 'Costa Rica', '', '00051');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CK', 'Cook Islands', '', '00050');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CD', 'Congo (Kinshasa)', '', '00049');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CG', 'Congo (Brazzaville)', '', '00048');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KM', 'Comoros', '', '00047');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CO', 'Colombia', '', '00046');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CC', 'Cocos (Keeling) Islands', '', '00045');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CX', 'Christmas Island', '', '00044');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CN', 'China', '', '00043');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CL', 'Chile', '', '00042');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TD', 'Chad', '', '00041');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CF', 'Central African Republic', '', '00040');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KY', 'Cayman Islands', '', '00039');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CV', 'Cape Verde', '', '00038');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CA', 'Canada', '', '00037');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CM', 'Cameroon', '', '00036');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'KH', 'Cambodia', '', '00035');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BI', 'Burundi', '', '00034');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BF', 'Burkina Faso', '', '00033');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BG', 'Bulgaria', '', '00032');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BN', 'Brunei Darussalam', '', '00031');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'IO', 'British Indian Ocean Territory', '', '00030');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BR', 'Brazil', '', '00029');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BV', 'Bouvet Island', '', '00028');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BW', 'Botswana', '', '00027');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BA', 'Bosnia and Herzegovina', '', '00026');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BO', 'Bolivia', '', '00025');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BT', 'Bhutan', '', '00024');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BM', 'Bermuda', '', '00023');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BJ', 'Benin', '', '00022');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BZ', 'Belize', '', '00021');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BE', 'Belgium', '', '00020');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BY', 'Belarus', '', '00019');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BB', 'Barbados', '', '00018');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BD', 'Bangladesh', '', '00017');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BH', 'Bahrain', '', '00016');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'BS', 'Bahamas', '', '00015');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AZ', 'Azerbaijan', '', '00014');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AT', 'Austria', '', '00013');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AU', 'Australia', '', '00012');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AW', 'Aruba', '', '00011');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AM', 'Armenia', '', '00010');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AR', 'Argentina', '', '00009');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AG', 'Antigua and Barbuda', '', '00008');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AQ', 'Antarctica', '', '00007');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AI', 'Anguilla', '', '00006');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AO', 'Angola', '', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AD', 'Andorra', '', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AS', 'American Samoa', '', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'DZ', 'Algeria', '', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AL', 'Albania', '', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AF', 'Afghanistan', '', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('1', 'DUNNO', 'Don\'t know', 'N', '00007');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ZA', 'South Africa', '', '00193');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GS', 'South Georgia and South Sandwich Islands', '', '00194');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ES', 'Spain', '', '00196');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'LK', 'Sri Lanka', '', '00197');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SD', 'Sudan', '', '00198');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SR', 'Suriname', '', '00199');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SJ', 'Svalbard and Jan Mayen Islands', '', '00200');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SZ', 'Swaziland', '', '00201');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SE', 'Sweden', '', '00202');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'CH', 'Switzerland', '', '00203');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'SY', 'Syrian Arab Republic', '', '00204');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TW', 'Taiwan', '', '00205');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TJ', 'Tajikistan', '', '00206');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TZ', 'Tanzania', '', '00207');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TH', 'Thailand', '', '00208');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TL', 'Timor-Leste', '', '00209');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TG', 'Togo', '', '00210');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TK', 'Tokelau', '', '00211');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TO', 'Tonga', '', '00212');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TT', 'Trinidad and Tobago', '', '00213');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TN', 'Tunisia', '', '00214');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TR', 'Turkey', '', '00215');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TM', 'Turkmenistan', '', '00216');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TC', 'Turks and Caicos Islands', '', '00217');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'TV', 'Tuvalu', '', '00218');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'UG', 'Uganda', '', '00219');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'UA', 'Ukraine', '', '00220');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'AE', 'United Arab Emirates', '', '00221');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'GB', 'United Kingdom', '', '00222');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'UM', 'United States Minor Outlying Islands', '', '00223');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'US', 'United States of America', '', '00224');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'UY', 'Uruguay', '', '00225');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'UZ', 'Uzbekistan', '', '00226');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VU', 'Vanuatu', '', '00227');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VA', 'Vatican City', '', '00228');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VE', 'Venezuela', '', '00229');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VN', 'Viet Nam', '', '00230');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VG', 'Virgin Islands - British', '', '00231');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'VI', 'Virgin Islands - U.S.', '', '00232');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'WF', 'Wallis and Futuna Islands', '', '00233');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'EH', 'Western Sahara', '', '00234');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'YE', 'Yemen', '', '00235');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'YU', 'Yugoslavia', '', '00236');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('24', 'ZM', 'Zambia', '', '00237');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'SMB', 'Small to medium business', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'LBUS', 'Large business', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'TEO', 'University or other tertiary education organisation', 'N', '00002');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'SKOOL', 'Primary or secondary school', 'N', '00003');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'NOORG', 'Not connecting from an organisation (e.g., home connection)', 'N', '00004');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'GOVT', 'Government department or organisation', 'N', '00005');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('25', 'NONP', 'Non-profit organisation', 'N', '00006');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('27', 'OUSTF', 'I work for the University of Otago', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('27', 'OUATH', 'I am an author of one or more items in the repository', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('27', 'OUSTD', 'I am a student at the University of Otago', 'N', '00002');

# NEW TABLE
# CONDITIONS TABLE
#
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('1', '2', '1', '1X1X1', '', 'AUTH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('2', '4', '3', '1X2X3', '', 'Y');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('3', '5', '3', '1X2X3', '', 'Y');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('4', '7', '6', '1X3X6', '', 'FORML');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('5', '8', '6', '1X3X6', '', 'GSRCH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('6', '9', '6', '1X3X6', '', 'SSRCH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('7', '10', '6', '1X3X6', '', 'GSRCH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('8', '11', '6', '1X3X6', '', 'SSRCH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('9', '17', '5', '1X2X5', '', 'AUTH');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('10', '18', '3', '1X2X3', '', 'Y');
INSERT INTO conditions (`cid`, `qid`, `cqid`, `cfieldname`, `method`, `value`) VALUES ('11', '17', '3', '1X2X3', '', 'Y');

# NEW TABLE
# LABELSETS TABLE
#

# NEW TABLE
# LABELS TABLE
#

# NEW TABLE
# QUESTION_ATTRIBUTES TABLE
#
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('1', '1', 'random_order', '1');
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('3', '5', 'random_order', '1');
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('4', '6', 'random_order', '1');
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('5', '7', 'random_order', '1');
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('6', '8', 'random_order', '1');
INSERT INTO question_attributes (`qaid`, `qid`, `attribute`, `value`) VALUES ('7', '9', 'random_order', '1');

# NEW TABLE
# ASSESSMENTS TABLE
#
#</pre>