#------------------------------------------
# LimeSurvey Database Dump of `umfragendb`
# Date of Dump: 06-Apr-2010
#------------------------------------------
#------------------------------------------
# Table definition for answers
#------------------------------------------
DROP TABLE IF EXISTS answers;
CREATE TABLE answers (
`qid` int(11) DEFAULT '0' NOT NULL,
`code` varchar(5) DEFAULT '' NOT NULL,
`answer` text NOT NULL,
`default_value` char(1) DEFAULT 'N' NOT NULL,
`assessment_value` int(11) DEFAULT '0' NOT NULL,
`sortorder` int(11) NOT NULL,
`language` varchar(20) DEFAULT 'en' NOT NULL,
PRIMARY KEY (qid, code, language),
KEY answers_idx2 (sortorder)
);
#------------------------------------------
# Table data for answers
#------------------------------------------
INSERT INTO answers VALUES("3","0-14","0-14 Years","N","0","1","en");
INSERT INTO answers VALUES("3","15-19","15-19 Years","N","15","2","en");
INSERT INTO answers VALUES("3","20-24","20-24 Years","N","20","3","en");
INSERT INTO answers VALUES("3","25-29","25-29 Years","N","25","4","en");
INSERT INTO answers VALUES("3","30-34","30-34 Years","N","30","5","en");
INSERT INTO answers VALUES("3","35-39","35-39 Years","N","35","6","en");
INSERT INTO answers VALUES("3","40-44","40-44 Years","N","40","7","en");
INSERT INTO answers VALUES("3","45-49","45-49 Years","N","45","8","en");
INSERT INTO answers VALUES("3","50-54","50-54 Years","N","50","9","en");
INSERT INTO answers VALUES("3","55-59","55-59 Years","N","55","10","en");
INSERT INTO answers VALUES("3","60-64","60-64 Years","N","60","11","en");
INSERT INTO answers VALUES("3","65-69","65-69 Years","N","65","12","en");
INSERT INTO answers VALUES("3","70-74","70-74 Years","N","70","13","en");
INSERT INTO answers VALUES("3","75-79","75-79 Years","N","75","14","en");
INSERT INTO answers VALUES("3","80-","80 and over","N","80","15","en");
INSERT INTO answers VALUES("5","01","Very difficult to read, my eyesight is dim","N","1","1","en");
INSERT INTO answers VALUES("5","02","Easy, my carer is doing it all for me","N","2","2","en");
INSERT INTO answers VALUES("5","03","How dare you insult me like that! I\'m YOUNG","N","3","3","en");
INSERT INTO answers VALUES("6","1","Ad One
","N","1","1","en");
INSERT INTO answers VALUES("6","2","Ad Two
","N","2","2","en");
INSERT INTO answers VALUES("6","3","Ad Three
","N","3","3","en");
INSERT INTO answers VALUES("7","01","This ad gives me confidence in the lawyers experience","N","1","1","en");
INSERT INTO answers VALUES("7","02","This ad suggests the lawyer is on my side, not his own","N","2","2","en");
INSERT INTO answers VALUES("7","03","This ad suggests that the lawyer is interested in a life of frugal community service","N","3","3","en");
INSERT INTO answers VALUES("7","04","This ad would be enough to get me to hire this lawyer","N","4","4","en");
INSERT INTO answers VALUES("8","01","This ad gives me confidence in the lawyers experience","N","1","1","en");
INSERT INTO answers VALUES("8","02","This ad suggests the lawyer is on my side, not his own","N","2","2","en");
INSERT INTO answers VALUES("8","03","This ad suggests that the lawyer is interested in a life of frugal community service","N","3","3","en");
INSERT INTO answers VALUES("8","04","This ad would be enough to get me to hire this lawyer","N","4","4","en");
INSERT INTO answers VALUES("9","01","This ad gives me confidence in the lawyers experience","N","1","1","en");
INSERT INTO answers VALUES("9","02","This ad suggests the lawyer is on my side, not his own","N","2","2","en");
INSERT INTO answers VALUES("9","03","This ad suggests that the lawyer is interested in a life of frugal community service","N","3","3","en");
INSERT INTO answers VALUES("9","04","This ad would be enough to get me to hire this lawyer","N","4","4","en");
INSERT INTO answers VALUES("29","24","","N","23","1","de");
INSERT INTO answers VALUES("46","011","User A","N","0","1","de");
INSERT INTO answers VALUES("46","012","User B","N","0","2","de");
INSERT INTO answers VALUES("21","032","Umschulung","N","0","2","de");
INSERT INTO answers VALUES("21","031","Ausbildung","N","0","1","de");
INSERT INTO answers VALUES("39","202","die Räumlichkeiten und deren Einrichtung","N","0","2","de");
INSERT INTO answers VALUES("27","101","","N","0","1","de");
INSERT INTO answers VALUES("39","203","die Umgebung des Instituts","N","0","3","de");
INSERT INTO answers VALUES("39","204","die Ausstattung","N","0","4","de");
INSERT INTO answers VALUES("39","201","den Eingangsbereich","N","0","1","de");
INSERT INTO answers VALUES("40","214","insgesamter Eindruck","N","0","4","de");
INSERT INTO answers VALUES("40","211","Freundlichkeit","N","0","1","de");
INSERT INTO answers VALUES("40","212","Atmosphäre","N","0","2","de");
INSERT INTO answers VALUES("40","213","Kompetenz","N","0","3","de");
INSERT INTO answers VALUES("22","041","","N","0","1","de");
INSERT INTO answers VALUES("32","131","","N","0","1","de");
INSERT INTO answers VALUES("24","061","","N","0","1","de");
INSERT INTO answers VALUES("23","051","","N","0","1","de");
#------------------------------------------
# Table definition for assessments
#------------------------------------------
DROP TABLE IF EXISTS assessments;
CREATE TABLE assessments (
`id` int(11) NOT NULL auto_increment,
`sid` int(11) DEFAULT '0' NOT NULL,
`scope` varchar(5) DEFAULT '' NOT NULL,
`gid` int(11) DEFAULT '0' NOT NULL,
`name` text NOT NULL,
`minimum` varchar(50) DEFAULT '' NOT NULL,
`maximum` varchar(50) DEFAULT '' NOT NULL,
`message` text NOT NULL,
`language` varchar(20) DEFAULT 'en' NOT NULL,
PRIMARY KEY (id, language),
KEY assessments_idx2 (sid),
KEY assessments_idx3 (gid)
);
#------------------------------------------
# Table data for assessments
#------------------------------------------
#------------------------------------------
# Table definition for conditions
#------------------------------------------
DROP TABLE IF EXISTS conditions;
CREATE TABLE conditions (
`cid` int(11) NOT NULL auto_increment,
`qid` int(11) DEFAULT '0' NOT NULL,
`scenario` int(11) DEFAULT '1' NOT NULL,
`cqid` int(11) DEFAULT '0' NOT NULL,
`cfieldname` varchar(50) DEFAULT '' NOT NULL,
`method` char(2) DEFAULT '' NOT NULL,
`value` varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (cid),
KEY conditions_idx2 (qid),
KEY conditions_idx3 (cqid)
);
#------------------------------------------
# Table data for conditions
#------------------------------------------
INSERT INTO conditions VALUES("1","5","1","3","29975X1X3","==","80-");
INSERT INTO conditions VALUES("2","7","1","6","29975X3X6","==","1");
INSERT INTO conditions VALUES("3","8","1","6","29975X3X6","==","2");
INSERT INTO conditions VALUES("4","9","1","6","29975X3X6","==","3");
INSERT INTO conditions VALUES("25","39","1","34","23766X14X34","==","Y");
INSERT INTO conditions VALUES("27","27","1","29","23766X13X29","!=","4004");
INSERT INTO conditions VALUES("28","32","1","29","23766X13X29","!=","4004");
INSERT INTO conditions VALUES("29","40","1","29","23766X13X29","!=","4004");
#------------------------------------------
# Table definition for groups
#------------------------------------------
DROP TABLE IF EXISTS groups;
CREATE TABLE groups (
`gid` int(11) NOT NULL auto_increment,
`sid` int(11) DEFAULT '0' NOT NULL,
`group_name` varchar(100) DEFAULT '' NOT NULL,
`group_order` int(11) DEFAULT '0' NOT NULL,
`description` text,
`language` varchar(20) DEFAULT 'en' NOT NULL,
PRIMARY KEY (gid, language),
KEY groups_idx2 (sid)
);
#------------------------------------------
# Table data for groups
#------------------------------------------
INSERT INTO groups VALUES("1","29975","Group 1","0","","en");
INSERT INTO groups VALUES("2","29975","Group 2","1","","en");
INSERT INTO groups VALUES("3","29975","Group 3","2","","en");
INSERT INTO groups VALUES("15","48842","User","0","","de");
INSERT INTO groups VALUES("11","23766","Teilnehmer","0","","de");
INSERT INTO groups VALUES("12","23766","Erstkontakt","1","","de");
INSERT INTO groups VALUES("13","23766","Beratung","2","","de");
INSERT INTO groups VALUES("14","23766","Räumlichkeiten","3","","de");
#------------------------------------------
# Table definition for labels
#------------------------------------------
DROP TABLE IF EXISTS labels;
CREATE TABLE labels (
`lid` int(11) DEFAULT '0' NOT NULL,
`code` varchar(5) DEFAULT '' NOT NULL,
`title` text,
`sortorder` int(11) NOT NULL,
`assessment_value` int(11) DEFAULT '0' NOT NULL,
`language` varchar(20) DEFAULT 'en' NOT NULL,
PRIMARY KEY (lid, sortorder, language),
KEY ixcode (code)
);
#------------------------------------------
# Table data for labels
#------------------------------------------
INSERT INTO labels VALUES("1","3","trifft teilweise zu","2","3","de");
INSERT INTO labels VALUES("1","4","trifft eher zu","1","4","de");
INSERT INTO labels VALUES("1","1","trifft eher nicht zu","3","1","de");
INSERT INTO labels VALUES("1","5","trifft vollkommen zu","0","5","de");
INSERT INTO labels VALUES("1","2","trifft überhaupt nicht zu","4","2","de");
INSERT INTO labels VALUES("2","1","sehr gut","0","1","de");
INSERT INTO labels VALUES("2","2","gut","1","2","de");
INSERT INTO labels VALUES("8","113","","2","3","de");
INSERT INTO labels VALUES("2","3","befriedigend","2","3","de");
INSERT INTO labels VALUES("9","112","Umschulung","1","2430","de");
INSERT INTO labels VALUES("2","4","ausreichend","3","4","de");
INSERT INTO labels VALUES("8","112","","1","2","de");
INSERT INTO labels VALUES("2","5","mangelhaft","4","5","de");
INSERT INTO labels VALUES("2","6","sehr schlecht","5","6","de");
INSERT INTO labels VALUES("3","1","kein Abschluss","1","1","de");
INSERT INTO labels VALUES("3","2","noch Schüler","2","2","de");
INSERT INTO labels VALUES("3","3","Volksschule / Hauptschule","3","3","de");
INSERT INTO labels VALUES("3","4","Mittlere Reife / POS","4","4","de");
INSERT INTO labels VALUES("3","5","Fachschulabschluss","5","5","de");
INSERT INTO labels VALUES("3","6","Fachabitur / Fachhochschulreife","6","6","de");
INSERT INTO labels VALUES("3","7","Allgemeine Hochschulreife / Abitur / EOS","7","7","de");
INSERT INTO labels VALUES("3","8","Hochschulabschluss","8","8","de");
INSERT INTO labels VALUES("3","9","Promotion","9","9","de");
INSERT INTO labels VALUES("3","10","Sonstiges","10","10","de");
INSERT INTO labels VALUES("4","1","weniger als 1 Stunde","1","1","de");
INSERT INTO labels VALUES("4","2","1 bis 2 Stunden täglich","2","2","de");
INSERT INTO labels VALUES("4","3","3 bis 6 Stunden täglich","3","3","de");
INSERT INTO labels VALUES("4","4","6 bis 12 Stunden täglich","4","4","de");
INSERT INTO labels VALUES("4","5","mehr als 12 Stunden","5","5","de");
INSERT INTO labels VALUES("5","1","1 Tag","1","1","de");
INSERT INTO labels VALUES("5","2","2 Tage","2","2","de");
INSERT INTO labels VALUES("5","3","3 Tage","3","3","de");
INSERT INTO labels VALUES("5","4","4 Tage","4","4","de");
INSERT INTO labels VALUES("5","5","5 Tage","5","5","de");
INSERT INTO labels VALUES("5","6","6 Tage","6","6","de");
INSERT INTO labels VALUES("5","7","7 Tage","7","7","de");
INSERT INTO labels VALUES("5","0","seltener","8","0","de");
INSERT INTO labels VALUES("6","01","Agree strongly","1","1","en");
INSERT INTO labels VALUES("6","02","Agree somewhat","2","2","en");
INSERT INTO labels VALUES("6","03","Neither agree nor disagree","3","3","en");
INSERT INTO labels VALUES("6","04","Disagree somewhat","4","4","en");
INSERT INTO labels VALUES("6","05","Disagree strongly","5","5","en");
INSERT INTO labels VALUES("7","1","1 - sehr wichtig","0","1","de");
INSERT INTO labels VALUES("7","2","2","1","2","de");
INSERT INTO labels VALUES("7","3","3","2","3","de");
INSERT INTO labels VALUES("7","4","4","3","4","de");
INSERT INTO labels VALUES("7","5","5","4","5","de");
INSERT INTO labels VALUES("7","6","6 - unwichtig","5","6","de");
INSERT INTO labels VALUES("8","114","
","","This question only displays if lawyer one was chosen.","N","N","6","0","1","en");
INSERT INTO questions VALUES("8","29975","3","F","03a","Please have a good look at this ad, and then complete the questions below.
","","This question only displays if lawyer two was chosen.","N","N","6","0","2","en");
INSERT INTO questions VALUES("9","29975","3","F","04a","Please have a good look at this ad, and then complete the questions below.
","","This question only displays if lawyer three was chosen.","N","N","6","0","3","en");
INSERT INTO questions VALUES("19","23766","11","G","01","Sind Sie weiblich oder männlich?","","","N","N","0","0","0","de");
INSERT INTO questions VALUES("20","23766","11","N","02","Wie alt sind Sie?","","","N","N","0","0","1","de");
INSERT INTO questions VALUES("21","23766","11","Z","03","Haben Sie sich bei uns für eine Ausbildung oder Umschulung beworben?","","","N","N","9","0","2","de");
INSERT INTO questions VALUES("22","23766","12","F","04","Mein erster Eindruck von der GPB war…","","","N","N","2","0","2","de");
INSERT INTO questions VALUES("23","23766","12","F","05","Die Aufbereitung der erhaltenen Info-Materialien fand ich…","","","N","N","2","0","1","de");
INSERT INTO questions VALUES("24","23766","12","F","06","Mein Gesamteindruck von der GPB war...","","","N","N","2","0","0","de");
INSERT INTO questions VALUES("29","23766","13","Z","07","Haben Sie an einer Informationsveranstaltung oder einer individuellen Beratung teilgenommen?","","","N","Y","10","0","0","de");
INSERT INTO questions VALUES("46","48842","15","L","01","User A or B?","","","N","N","0","0","0","de");
INSERT INTO questions VALUES("27","23766","13","F","10","Wie wurde auf Ihre speziellen Fragen eingegangen?","","","N","N","2","0","1","de");
INSERT INTO questions VALUES("39","23766","14","F","20","Wie fanden Sie...","","","N","N","2","0","1","de");
INSERT INTO questions VALUES("32","23766","13","F","13","Wie beurteilen Sie den Inhalt der Informationsmaterialien?","","","N","N","2","0","2","de");
INSERT INTO questions VALUES("34","23766","14","Y","15","Waren Sie schon einmal in den Räumlichkeiten der GPB?","","","N","N","0","0","0","de");
INSERT INTO questions VALUES("40","23766","13","F","21","Bitte beurteilen Sie die einzelnen Aspekte unserer Beratung:","","","N","N","2","0","3","de");
#------------------------------------------
# Table definition for quota
#------------------------------------------
DROP TABLE IF EXISTS quota;
CREATE TABLE quota (
`id` int(11) NOT NULL auto_increment,
`sid` int(11),
`name` varchar(255),
`qlimit` int(8),
`action` int(2),
`active` int(1) DEFAULT '1' NOT NULL,
`autoload_url` int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY quota_idx2 (sid)
);
#------------------------------------------
# Table data for quota
#------------------------------------------
#------------------------------------------
# Table definition for quota_languagesettings
#------------------------------------------
DROP TABLE IF EXISTS quota_languagesettings;
CREATE TABLE quota_languagesettings (
`quotals_id` int(11) NOT NULL auto_increment,
`quotals_quota_id` int(11) DEFAULT '0' NOT NULL,
`quotals_language` varchar(45) DEFAULT 'en' NOT NULL,
`quotals_name` varchar(255),
`quotals_message` text NOT NULL,
`quotals_url` varchar(255),
`quotals_urldescrip` varchar(255),
PRIMARY KEY (quotals_id)
);
#------------------------------------------
# Table data for quota_languagesettings
#------------------------------------------
#------------------------------------------
# Table definition for quota_members
#------------------------------------------
DROP TABLE IF EXISTS quota_members;
CREATE TABLE quota_members (
`id` int(11) NOT NULL auto_increment,
`sid` int(11),
`qid` int(11),
`quota_id` int(11),
`code` varchar(11),
PRIMARY KEY (id),
UNIQUE sid (sid, qid, quota_id, code)
);
#------------------------------------------
# Table data for quota_members
#------------------------------------------
#------------------------------------------
# Table definition for saved_control
#------------------------------------------
DROP TABLE IF EXISTS saved_control;
CREATE TABLE saved_control (
`scid` int(11) NOT NULL auto_increment,
`sid` int(11) DEFAULT '0' NOT NULL,
`srid` int(11) DEFAULT '0' NOT NULL,
`identifier` text NOT NULL,
`access_code` text NOT NULL,
`email` varchar(320),
`ip` text NOT NULL,
`saved_thisstep` text NOT NULL,
`status` char(1) DEFAULT '' NOT NULL,
`saved_date` datetime NOT NULL,
`refurl` text,
PRIMARY KEY (scid),
KEY saved_control_idx2 (sid)
);
#------------------------------------------
# Table data for saved_control
#------------------------------------------
#------------------------------------------
# Table definition for settings_global
#------------------------------------------
DROP TABLE IF EXISTS settings_global;
CREATE TABLE settings_global (
`stg_name` varchar(50) DEFAULT '' NOT NULL,
`stg_value` varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (stg_name)
);
#------------------------------------------
# Table data for settings_global
#------------------------------------------
INSERT INTO settings_global VALUES("DBVersion","142");
INSERT INTO settings_global VALUES("SessionName","ls76217754372633395294");
INSERT INTO settings_global VALUES("updateavailable","0");
INSERT INTO settings_global VALUES("updatelastcheck","2010-03-22 13:40:11");
INSERT INTO settings_global VALUES("updatecheckperiod","30");
INSERT INTO settings_global VALUES("sitename","*** Umfragen ***");
INSERT INTO settings_global VALUES("defaultlang","de");
INSERT INTO settings_global VALUES("defaulttemplate","Kopie_von_basic");
INSERT INTO settings_global VALUES("defaulthtmleditormode","popup");
INSERT INTO settings_global VALUES("timeadjust","+0 hours");
INSERT INTO settings_global VALUES("usepdfexport","1");
INSERT INTO settings_global VALUES("addTitleToLinks","0");
INSERT INTO settings_global VALUES("sessionlifetime","3600");
INSERT INTO settings_global VALUES("siteadminemail","webmaster@faktorweb.de");
INSERT INTO settings_global VALUES("siteadminbounce","webmaster@faktorweb.de");
INSERT INTO settings_global VALUES("siteadminname","Axel Kloss");
INSERT INTO settings_global VALUES("emailmethod","mail");
INSERT INTO settings_global VALUES("emailsmtphost","");
INSERT INTO settings_global VALUES("emailsmtpuser","");
INSERT INTO settings_global VALUES("emailsmtpssl","");
INSERT INTO settings_global VALUES("emailsmtpdebug","");
INSERT INTO settings_global VALUES("maxemails","50");
INSERT INTO settings_global VALUES("surveyPreview_require_Auth","1");
INSERT INTO settings_global VALUES("filterxsshtml","1");
INSERT INTO settings_global VALUES("usercontrolSameGroupPolicy","1");
INSERT INTO settings_global VALUES("shownoanswer","0");
INSERT INTO settings_global VALUES("repeatheadings","25");
INSERT INTO settings_global VALUES("emailsmtppassword","");
#------------------------------------------
# Table definition for survey_23766
#------------------------------------------
DROP TABLE IF EXISTS survey_23766;
CREATE TABLE survey_23766 (
`id` int(11) NOT NULL auto_increment,
`submitdate` datetime,
`startlanguage` varchar(20) NOT NULL,
`token` varchar(36),
`23766X11X19` varchar(1),
`23766X11X20` double,
`23766X11X21` varchar(5),
`23766X12X24061` varchar(5),
`23766X12X23051` varchar(5),
`23766X12X22041` varchar(5),
`23766X13X29` varchar(5),
`23766X13X27101` varchar(5),
`23766X13X32131` varchar(5),
`23766X13X40211` varchar(5),
`23766X13X40212` varchar(5),
`23766X13X40213` varchar(5),
`23766X13X40214` varchar(5),
`23766X14X34` varchar(1),
`23766X14X39201` varchar(5),
`23766X14X39202` varchar(5),
`23766X14X39203` varchar(5),
`23766X14X39204` varchar(5),
`lastpage` int(11),
PRIMARY KEY (id)
);
#------------------------------------------
# Table data for survey_23766
#------------------------------------------
INSERT INTO survey_23766 VALUES("6","2010-03-20 09:49:37","de","emehrtjrz7v9nrj","M","43","112","3","4","4","4003","5","2","1","3","2","2","Y","6","2","3","2",NULL);
INSERT INTO survey_23766 VALUES("7","2010-03-20 13:24:32","de","5fv456bkstbkp3x","F","26","112","1","2","2","4002","1","1","1","1","1","1","Y","2","2","4","2",NULL);
INSERT INTO survey_23766 VALUES("8","2010-03-22 08:38:51","de","kbwf5be43ytjt5s","F","29","","","","","4003","","","","","","","","","","","",NULL);
INSERT INTO survey_23766 VALUES("9","2010-03-22 10:27:18","de","z7xvm27z48xwsrz","M","89","112","","","","","","","","","","","Y","2","2","5","2","3");
INSERT INTO survey_23766 VALUES("15","2010-03-29 15:06:13","de","b7k9sair8trvb9f","M","25","111","2","4","2","4002","1","2","1","2","2","2","Y","3","3","4","2","4");
INSERT INTO survey_23766 VALUES("11","2010-03-22 10:49:43","de","ifbs8etsk3y2cem","F","26","112","2","3","3","4001","3","3","2","3","2","3","Y","5","3","5","2",NULL);
INSERT INTO survey_23766 VALUES("14","2010-03-22 17:17:31","de","qcas52k7a7gbgkn","M","4","112","1","3","1","4001","2","4","1","","","","N",NULL,NULL,NULL,NULL,"4");
#------------------------------------------
# Table definition for survey_48842
#------------------------------------------
DROP TABLE IF EXISTS survey_48842;
CREATE TABLE survey_48842 (
`id` int(11) NOT NULL auto_increment,
`submitdate` datetime,
`lastpage` int(11),
`startlanguage` varchar(20) NOT NULL,
`token` varchar(36),
`48842X15X46` varchar(5),
PRIMARY KEY (id)
);
#------------------------------------------
# Table data for survey_48842
#------------------------------------------
INSERT INTO survey_48842 VALUES("5","2010-04-05 20:02:53","2","de","b2dt634g3d2ivmu","011");
INSERT INTO survey_48842 VALUES("6","2010-04-05 20:03:58","2","de","b3ma8vv459zfukf","012");
INSERT INTO survey_48842 VALUES("7","2010-04-06 18:09:29","1","de","xg6phhemg9489x6","012");
INSERT INTO survey_48842 VALUES("8","2010-04-06 18:45:09","1","de","3kautsmpdk5p2br","012");
INSERT INTO survey_48842 VALUES("9","2010-04-06 18:27:41","2","de","gnckiajkzuuerrb","012");
INSERT INTO survey_48842 VALUES("10","2010-04-06 18:34:37","2","de","n2w7sv773jv7h4k","011");
INSERT INTO survey_48842 VALUES("11","2010-04-06 18:35:37","2","de","mwt4u9bqmn38pp5","012");
INSERT INTO survey_48842 VALUES("12","2010-04-06 18:51:37","1","de","qqyzezu6np6ymsv","012");
INSERT INTO survey_48842 VALUES("13","2010-04-06 18:56:03","2","de","jncpmxffawcuv2i","011");
INSERT INTO survey_48842 VALUES("14","2010-04-06 18:57:01","2","de","ci52ctcm3aeehsr","012");
#------------------------------------------
# Table definition for surveys
#------------------------------------------
DROP TABLE IF EXISTS surveys;
CREATE TABLE surveys (
`sid` int(11) NOT NULL,
`owner_id` int(11) NOT NULL,
`admin` varchar(50),
`active` char(1) DEFAULT 'N' NOT NULL,
`expires` datetime,
`startdate` datetime,
`adminemail` varchar(320),
`private` char(1),
`faxto` varchar(20),
`format` char(1),
`template` varchar(100) DEFAULT 'default',
`language` varchar(50),
`additional_languages` varchar(255),
`datestamp` char(1) DEFAULT 'N',
`usecookie` char(1) DEFAULT 'N',
`notification` char(1) DEFAULT '0',
`allowregister` char(1) DEFAULT 'N',
`allowsave` char(1) DEFAULT 'Y',
`autonumber_start` bigint(11) DEFAULT '0',
`autoredirect` char(1) DEFAULT 'N',
`allowprev` char(1) DEFAULT 'Y',
`printanswers` char(1) DEFAULT 'N',
`ipaddr` char(1) DEFAULT 'N',
`refurl` char(1) DEFAULT 'N',
`datecreated` date,
`publicstatistics` char(1) DEFAULT 'N',
`publicgraphs` char(1) DEFAULT 'N',
`listpublic` char(1) DEFAULT 'N',
`htmlemail` char(1) DEFAULT 'N',
`tokenanswerspersistence` char(1) DEFAULT 'N',
`assessments` char(1) DEFAULT 'N',
`usecaptcha` char(1) DEFAULT 'N',
`usetokens` char(1) DEFAULT 'N',
`bounce_email` varchar(320),
`attributedescriptions` text,
`emailresponseto` text,
`tokenlength` tinyint(2) DEFAULT '15' NOT NULL,
PRIMARY KEY (sid)
);
#------------------------------------------
# Table data for surveys
#------------------------------------------
INSERT INTO surveys VALUES("29975","1","","N",NULL,NULL,"","Y","","S","default","en","","Y","N","0","N","N","0","N","Y","N","Y","Y","2007-10-18","N","N","N","N","N","N","N","N","",NULL,NULL,"15");
INSERT INTO surveys VALUES("23766","4","GPB Kundenservice","Y",NULL,NULL,"webmaster@gpb.de","N","","G","Kopie_von_basic","de","","N","N","0","N","N","6","N","Y","N","N","N","2010-02-12","N","N","N","N","Y","Y","D","N","webmaster@gpb.de",NULL,NULL,"15");
INSERT INTO surveys VALUES("48842","4","Philipp Eissfeldt","Y",NULL,NULL,"oscarwalt@googlemail.com","N","","G","basic","de",NULL,"N","N","0","N","N","5","N","Y","N","N","N","2010-03-25","N","N","N","N","Y","Y","D","N","oscarwalt@googlemail.com",NULL,"","15");
#------------------------------------------
# Table definition for surveys_languagesettings
#------------------------------------------
DROP TABLE IF EXISTS surveys_languagesettings;
CREATE TABLE surveys_languagesettings (
`surveyls_survey_id` int(10) unsigned DEFAULT '0' NOT NULL,
`surveyls_language` varchar(45) DEFAULT 'en' NOT NULL,
`surveyls_title` varchar(200) NOT NULL,
`surveyls_description` text,
`surveyls_welcometext` text,
`surveyls_endtext` text,
`surveyls_url` varchar(255),
`surveyls_urldescription` varchar(255),
`surveyls_email_invite_subj` varchar(255),
`surveyls_email_invite` text,
`surveyls_email_remind_subj` varchar(255),
`surveyls_email_remind` text,
`surveyls_email_register_subj` varchar(255),
`surveyls_email_register` text,
`surveyls_email_confirm_subj` varchar(255),
`surveyls_email_confirm` text,
`surveyls_dateformat` int(10) unsigned DEFAULT '1' NOT NULL,
PRIMARY KEY (surveyls_survey_id, surveyls_language)
);
#------------------------------------------
# Table data for surveys_languagesettings
#------------------------------------------
INSERT INTO surveys_languagesettings VALUES("29975","en","Slightly Trickier Sample Survey","This is a sample survey designed for testing LimeSurvey.
One of the first things you\'ll need to do, in order to make this work properly, is to fix up the "reference to previous answers" codes in the first two questions of Group 2. These questions contain (INSERTANS:1X2X3) code that needs the numbers changed to match questions 1 and 3 of Group 1. In order to find this number out, browse to question 1 of Group 1, and then copy the code from the URL bar in your web browser, starting from the number after "SID="
IE: 29975&gid=2&qid=4
Then, replace the "&gid=" with an X, and replace the "&qid=" with an X. So you should have:
29975X2X4
Then, you can replace the number in the curly brackets of question 1, group 2, so that it says:
(INSERTANS:29975X2X4)
Do the same with the other codes in the questions.
More information on using the answers to previous questions in your questions is available in the documentation.
","Welcome to the LimeSurvey Sample Survey",NULL,NULL,"","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}","1"); INSERT INTO surveys_languagesettings VALUES("23766","de","Ihre Meinung ist uns wichtig","