# LimeSurvey Survey Dump # DBVersion 142 # This is a dumped survey from the LimeSurvey Script # http://www.limesurvey.org/ # Do not change this header! # # SURVEYS TABLE # "sid","owner_id","admin","active","expires","startdate","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","publicstatistics","publicgraphs","listpublic","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","emailresponseto","tokenlength" "29846","1","Administratorname","N","","","admin@localhost","Y","000-00000000","G","default","en","","Y","N","0","N","Y","4","N","Y","Y","N","N","2008-04-21","Y","Y","N","N","N","Y","N","N","admin@localhost","","admin@localhost","15" # # GROUPS TABLE # "gid","sid","group_name","group_order","description","language" "613","29846","Array Questions","0","This is a group with the different array questions.","en" "614","29846","Text Questions","4","","en" "615","29846","Mask Questions","1","This is the group description.","en" "616","29846","Single Choice Questions","3","","en" "617","29846","Multiple Choice Questions","2","This group consist only of Multiple Choice questions.","en" # # QUESTIONS TABLE # "qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language" "3406","29846","613","A","A","Type A - Array 5 Point Choice Question","","","N","N","0","0","0","en" "3407","29846","613","B","B","Type B - Array 10 point choice Question","","This is the help text for this question. ","N","N","0","0","1","en" "3408","29846","613","C","C","Type C - Array Yes/No/Uncertain Question","","","N","N","0","0","2","en" "3409","29846","613","E","E","Type E - Array Increase/Same/Decrease Question","","This is the questions help text.","N","N","0","0","3","en" "3410","29846","613","F","F","Type F - Array using Flexible Labels question","","This is a array using a flexible label set. Flexible labels sets can be created with as many answer as you like to. We created only one for this survey that will be re-used over and over.","N","N","318","0","4","en" "3411","29846","613","H","H","Type H - Array Flexible Labels by Column question","","This is the same question type as before just the orientation has changed","N","N","318","0","6","en" "3412","29846","613","F","Semantic","Semantic Differential Question Type
","","This question type is a modification of Array (flexible labels).
","N","N","319","0","7","en" "3413","29846","613","1","DualScale-radio","Array (Flexible Labels) dual scale (radio)
","","","N","N","320","320","9","en" "3414","29846","613",":",":","Array (Multi Flexi) (Numbers) - Allows a table of dropdowns containing number selections set by question attributes.
","","","N","N","321","0","11","en" "3415","29846","613",";",";","Array (Multi Flexi) (Text) - Allows a table of text inputs
","","","N","N","321","0","12","en" "3416","29846","613","1","DualScale-dropdown","Array (Flexible Labels) dual scale (dropdown)
","","","N","N","320","320","10","en" "3417","29846","613",":",":","Array (Multi Flexi) (Numbers - checkbox) - Allows a table of dropdowns containing number selections set by question attributes.
","","","N","N","321","0","13","en" "3418","29846","613","F","F","Type F - Array using Flexible Labels question (answerwidth = 50)
","","This is a array using a flexible label set. Flexible labels sets can be created with as many answer as you like to. We created only one for this survey that will be re-used over and over.","N","N","318","0","5","en" "3419","29846","614","Q","Q","Type Q - Multiple Short Text Question","","This is a Multiple Short Text Question","N","N","0","0","0","en" "3420","29846","614","T","T","Type T - Long Text Question?","","Helptext","N","N","0","0","4","en" "3421","29846","614","S","S","Type S - Short Free Text?","","helptext","N","N","0","0","3","en" "3422","29846","614","U","U","Type U - Huge Free text?","","Helptext","N","N","0","0","5","en" "3423","29846","614","Q","Q","Type Q - Multiple Short Text Question (with suffix and prefix)
","","This is a Multiple Short Text Question","N","N","0","0","1","en" "3424","29846","614","Q","Q","Type Q - Multiple Short Text Question (long "answers")
","","This is a Multiple Short Text Question","N","N","0","0","2","en" "3425","29846","615","X","X","Type X - Boilerplate question","","This is the boilerplate question type. It's not so much a question but a simple text display.","N","Y","0","0","9","en" "3426","29846","615","G","G","Type G - Gender question?","","This is a standard question aksing for the participiant's sex.","N","N","0","0","2","en" "3427","29846","615","N","N","Type N - Numerical Input Question","","","N","Y","0","0","3","en" "3428","29846","615","R","R","Type R - Ranking Question","","","N","N","0","0","8","en" "3429","29846","615","Y","Y","Type Y - Yes/No Question","","","N","N","0","0","10","en" "3430","29846","615","D","D","Type D - Date question?","","Helptext","N","N","0","0","0","en" "3431","29846","615","K","K","Multiple Numerical Input
","","","N","N","0","0","4","en" "3432","29846","615","K","K","Multiple Numerical Input (slider layout)
","","You can slide the button along.
","N","Y","0","0","7","en" "3433","29846","615","D","D","Type D - Date question? (dropdown dates)
","","Helptext","N","N","0","0","1","en" "3434","29846","615","K","K","Multiple Numerical Input (equals 10)
","","add numbers to the boxes above
","N","N","0","0","6","en" "3435","29846","615","K","K","Multiple Numerical Input (with prefix and suffix)
","","","N","N","0","0","5","en" "3436","29846","616","Z","Z","Type Z - List Flexible Labels (Radio)","","This question is reusing the same label set as some of the array questions.","N","N","318","0","5","en" "3437","29846","616","W","W","Type W - List Flexible Labels Dropdown question type","","This question is reusing the same label set as some of the array questions.","N","N","318","0","4","en" "3438","29846","616","O","O","Type O - List with Comment Question","","","N","N","0","0","3","en" "3439","29846","616","L","L","Type L - List Radio qeustion","","","Y","N","0","0","2","en" "3440","29846","616","5","5","Type 5 - 5 point choice","","Help2","N","N","0","0","1","en" "3441","29846","616","!","!","Type ! - List Dropdown Question","","","Y","N","0","0","0","en" "3442","29846","617","P","P","Type P - Multiple Options Question with Comments ","","This is a Multiple Options Question with the ability to comment it.","Y","N","0","0","1","en" "3443","29846","617","M","M","Type M - Multiple Options Question","","This is a type M multiple Options questions.","Y","N","0","0","0","en" "3444","29846","613","K","Semantic-Slider","Semantic Differential in Slider Layout Question Type
","","","N","N","0","0","8","en" # # ANSWERS TABLE # "qid","code","answer","default_value","assessment_value","sortorder","language" "3406","A1","FBI","N","0","0","en" "3406","A2","CIA","N","0","1","en" "3406","A3","G5","N","0","2","en" "3406","A4","NASA","N","0","3","en" "3407","B1","Darth Vader","N","0","0","en" "3407","B2","Luke Skywalker","N","0","1","en" "3407","B3","Princess Leia","N","0","2","en" "3407","B4","Jabba the Hut","N","0","3","en" "3408","C1","I am blonde","N","0","0","en" "3408","C2","I am blue","N","0","1","en" "3408","C3","I am pissed","N","0","2","en" "3408","C4","I am drunk","N","0","3","en" "3409","E1","Pain","N","0","0","en" "3409","E2","Pleasure","N","0","1","en" "3409","E3","Luck","N","0","2","en" "3409","E4","Happiness","N","0","3","en" "3410","F1","Deannan Troi","N","0","0","en" "3410","F2","Wesley Crusher","N","0","1","en" "3410","F3","Jean-Luc Picard","N","0","2","en" "3410","F4","Seven of Nine","N","0","3","en" "3411","H1","Deannan Troi","N","0","0","en" "3411","H2","Wesley Crusher","N","0","1","en" "3411","H3","Data","N","0","2","en" "3411","H4","Jean-Luc Picard","N","0","3","en" "3412","1","sweet|bitter","N","1","1","en" "3412","2","fair|unfair","N","2","2","en" "3412","3","warm|cold","N","3","3","en" "3412","4","beautiful|ugly","N","4","4","en" "3412","5","meaningful|meaningless","N","5","5","en" "3412","6","bright|dark","N","6","6","en" "3413","1","television program","N","1","1","en" "3413","2","radio program","N","2","2","en" "3413","3","cinema program","N","3","3","en" "3414","1","Google","N","1","1","en" "3414","2","Yahoo","N","2","2","en" "3414","3","Microsoft Search","N","3","3","en" "3415","1","Google","N","1","1","en" "3415","2","Yahoo","N","2","2","en" "3415","3","Microsoft Search","N","3","3","en" "3416","1","television program","N","1","1","en" "3416","2","radio program","N","2","2","en" "3416","3","cinema program","N","3","3","en" "3417","1","Google","N","1","1","en" "3417","2","Yahoo","N","2","2","en" "3417","3","Microsoft Search","N","3","3","en" "3418","F1","Deannan Troi","N","0","0","en" "3418","F2","Wesley Crusher","N","0","1","en" "3418","F3","Jean-Luc Picard","N","0","2","en" "3418","F4","Seven of Nine","N","0","3","en" "3419","Q1","blue","N","0","0","en" "3419","Q2","red","N","0","1","en" "3419","Q3","green","N","0","2","en" "3423","Q1","blue","N","0","0","en" "3423","Q2","red","N","0","1","en" "3423","Q3","green","N","0","2","en" "3424","Q1","blue is the colour of the sky. the sky is very high. the sky is also very big","N","0","0","en" "3424","Q2","red is the colour of blood. blood is very useful. blood is a very nice color","N","0","1","en" "3424","Q3","green is the color of trees. I like trees. I especially like climbing them with a rope and harness.","N","0","2","en" "3428","R1","Red","N","0","0","en" "3428","R2","Green","N","0","1","en" "3428","R3","Blue","N","0","2","en" "3431","1","Apples","N","1","1","en" "3431","2","Oranges","N","2","2","en" "3431","3","Bananas","N","3","3","en" "3432","1","Apples","N","1","1","en" "3432","2","Oranges","N","2","2","en" "3432","3","Bananas","N","3","3","en" "3434","1","Apples","N","1","1","en" "3434","2","Oranges","N","2","2","en" "3434","3","Bananas","N","3","3","en" "3435","1","Apples","N","1","1","en" "3435","2","Oranges","N","2","2","en" "3435","3","Bananas","N","3","3","en" "3438","O1","Red","N","0","0","en" "3438","O2","Green","N","0","1","en" "3438","O3","Blue","N","0","2","en" "3439","L1"," Green","N","0","0","en" "3439","L2","Red","N","0","1","en" "3439","L3","Blue","N","0","2","en" "3441","EC1","Green","N","0","0","en" "3441","EC2","Red","N","0","1","en" "3441","EC3","Blue","N","0","2","en" "3442","P1","I am glad","N","0","0","en" "3442","P2","I don't care","N","0","1","en" "3442","P3","I am unhappy","N","0","2","en" "3443","M1","Yes","N","0","0","en" "3443","M2","No","N","0","1","en" "3443","M3","Maybe","N","0","2","en" "3444","1","|sweet|bitter","N","0","1","en" "3444","2","|fair|unfair","N","0","2","en" "3444","3","|warm|cold","N","0","3","en" "3444","4","|beautiful|ugly","N","0","4","en" "3444","5","|meaningful|meaningless","N","0","5","en" "3444","6","|bright|dark","N","0","6","en" # # CONDITIONS TABLE # # # LABELSETS TABLE # "lid","label_name","languages" "318","Test Labelset","en" "319","-2_to_+2","en" "320","1_to_5","en" "321","Search Engine Criteria","en" # # LABELS TABLE # "lid","code","title","sortorder","language","assessment_value" "318","TL1","6 - Like it very much","0","en","0" "318","TL2","5","1","en","0" "318","TL3","4","2","en","0" "318","TL4","3","3","en","0" "318","TL5","2","4","en","0" "318","TL6","1 - Dont like it at all","5","en","0" "319","1","-2","1","en","1" "319","2","-1","2","en","2" "319","3","0","3","en","3" "319","4","1","4","en","4" "319","5","2","5","en","5" "320","1","1","1","en","1" "320","2","2","2","en","2" "320","3","3","3","en","3" "320","4","4","4","en","4" "320","5","5","5","en","5" "321","ACC","Accuracy","3","en","0" "321","DSN","Design","2","en","0" "321","SPD","Speed","1","en","0" # # QUESTION_ATTRIBUTES TABLE # "qaid","qid","attribute","value" "2758","3413","answer_width","50" "2759","3413","dualscale_headerA","satisfaction" "2760","3413","dualscale_headerB","importance" "2761","3414","multiflexible_max","20" "2762","3414","multiflexible_step","2" "2763","3414","multiflexible_min","10" "2764","3416","answer_width","50" "2765","3432","equals_num_value","10" "2766","3432","slider_layout","1" "2767","3433","dropdown_dates","1" "2768","3434","equals_num_value","10" "2769","3416","dualscale_headerA","satisfaction" "2770","3416","dualscale_headerB","importance" "2771","3416","use_dropdown","1" "2772","3417","multiflexible_max","20" "2773","3417","multiflexible_step","2" "2774","3417","multiflexible_min","10" "2775","3417","multiflexible_checkbox","1" "2776","3418","answer_width","50" "2777","3435","prefix","prefix" "2778","3423","suffix","suffix" "2779","3423","prefix","prefix" "2780","3435","suffix","suffix" "2781","3416","array_filter","" "2782","3416","array_filter_exclude","" "2783","3416","dropdown_prepostfix","" "2784","3416","dropdown_separators","" "2785","3416","hidden","0" "2786","3416","page_break","0" "2787","3416","public_statistics","0" "2788","3416","random_order","0" "2789","3416","scale_export","0" "2790","3444","equals_num_value","" "2791","3444","hide_tip","0" "2792","3444","hidden","0" "2793","3444","max_num_value","" "2794","3444","max_num_value_sgqa","" "2795","3444","maximum_chars","" "2796","3444","min_num_value","" "2797","3444","min_num_value_sgqa","" "2798","3444","num_value_equals_sgqa","" "2799","3444","page_break","0" "2800","3444","prefix","" "2801","3444","public_statistics","0" "2802","3444","random_order","0" "2803","3444","slider_layout","1" "2804","3444","slider_min","-5" "2805","3444","slider_max","+5" "2806","3444","slider_accuracy","1" "2807","3444","slider_default","0" "2808","3444","slider_middlestart","1" "2809","3444","slider_showminmax","1" "2810","3444","slider_separator","|" "2811","3444","suffix","" "2812","3444","text_input_width","" "2813","3413","array_filter","" "2814","3413","array_filter_exclude","" "2815","3413","dropdown_prepostfix","" "2816","3413","dropdown_separators","" "2817","3413","hidden","0" "2818","3413","page_break","0" "2819","3413","public_statistics","0" "2820","3413","random_order","0" "2821","3413","use_dropdown","0" "2822","3413","scale_export","0" # # ASSESSMENTS TABLE # # # SURVEYS_LANGUAGESETTINGS TABLE # "surveyls_survey_id","surveyls_language","surveyls_title","surveyls_description","surveyls_welcometext","surveyls_endtext","surveyls_url","surveyls_urldescription","surveyls_email_invite_subj","surveyls_email_invite","surveyls_email_remind_subj","surveyls_email_remind","surveyls_email_register_subj","surveyls_email_register","surveyls_email_confirm_subj","surveyls_email_confirm","surveyls_dateformat" "29846","en","Sample Survey for v1.80 (all questions plus most options)","This is a sample survey showing all the question types you can use in LimeSurvey version 1.80 (or later).
\nIt also shows some of the options available for each question.
","This is the welcome text for the survey!
\nYou can can edit it in the survey properties.","This is the end text for the survey!
\nYou can can edit it in the survey properties.
","","","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} at {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}","1" # # QUOTA TABLE # # # QUOTA_MEMBERS TABLE # # # QUOTA_LANGUAGESETTINGS TABLE #