#------------------------------------------
# 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 <b><i>dare</i></b> you insult me like that! I\'m YOUNG","N","3","3","en");
INSERT INTO answers VALUES("6","1","Ad One<br /><img src=\'http://www.aptigence.com.au/images/lawyer1.jpg\'>","N","1","1","en");
INSERT INTO answers VALUES("6","2","Ad Two<br /><img src=\'http://www.aptigence.com.au/images/lawyer2.jpg\'>","N","2","2","en");
INSERT INTO answers VALUES("6","3","Ad Three<br /><img src=\'http://www.aptigence.com.au/images/lawyer3.jpg\'>","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","<div style=\"text-align: center;\">neutral</div>","3","4","de");
INSERT INTO labels VALUES("8","111","<div style=\"text-align: center;\">sehr gut</div>","0","1","de");
INSERT INTO labels VALUES("9","111","Ausbildung","0","4460","de");
INSERT INTO labels VALUES("8","115","","4","5","de");
INSERT INTO labels VALUES("8","116","","5","6","de");
INSERT INTO labels VALUES("10","4001","Ja, an einer Informationsveranstaltung","0","1","de");
INSERT INTO labels VALUES("8","117","<div style=\"text-align: center;\">sehr schlecht</div>","6","7","de");
INSERT INTO labels VALUES("10","4002","Ja, an einer individuellen Beratung","1","2","de");
INSERT INTO labels VALUES("10","4003","weiß ich nicht mehr","2","3","de");
INSERT INTO labels VALUES("10","4004","Nein, ich wurde nicht persönlich beraten","3","0","de");



#------------------------------------------
# Table definition for labelsets
#------------------------------------------
DROP TABLE IF EXISTS labelsets;

CREATE TABLE labelsets (
    `lid` int(11) NOT NULL auto_increment,
    `label_name` varchar(100) DEFAULT '' NOT NULL,
    `languages` varchar(200) DEFAULT 'en',
   PRIMARY KEY (lid)
);


#------------------------------------------
# Table data for labelsets
#------------------------------------------
INSERT INTO labelsets VALUES("1","5er Skala RH","de de_informal");
INSERT INTO labelsets VALUES("2","Schulnoten 1-6","de");
INSERT INTO labelsets VALUES("3","Bildungsgrad_Schulabschluss","de");
INSERT INTO labelsets VALUES("4","Stunden pro Tag_Kategorien","de");
INSERT INTO labelsets VALUES("5","Tage pro Woche (1-7)","de");
INSERT INTO labelsets VALUES("6","Feelings","en");
INSERT INTO labelsets VALUES("7","Wichtigkeit 1-6","de");
INSERT INTO labelsets VALUES("8","1-6","de");
INSERT INTO labelsets VALUES("9","keine Ahnung","de");
INSERT INTO labelsets VALUES("10","beratung","de");



#------------------------------------------
# Table definition for old_survey_48842_20100405194854
#------------------------------------------
DROP TABLE IF EXISTS old_survey_48842_20100405194854;

CREATE TABLE old_survey_48842_20100405194854 (
    `id` int(11) NOT NULL auto_increment,
    `submitdate` datetime,
    `lastpage` int(11),
    `startlanguage` varchar(20) NOT NULL,
    `48842X15X46` varchar(5),
   PRIMARY KEY (id)
);


#------------------------------------------
# Table data for old_survey_48842_20100405194854
#------------------------------------------
INSERT INTO old_survey_48842_20100405194854 VALUES("1","1980-01-01 00:00:00","2","de","011");
INSERT INTO old_survey_48842_20100405194854 VALUES("2","1980-01-01 00:00:00","2","de","012");



#------------------------------------------
# Table definition for old_survey_48842_20100405195936
#------------------------------------------
DROP TABLE IF EXISTS old_survey_48842_20100405195936;

CREATE TABLE old_survey_48842_20100405195936 (
    `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 old_survey_48842_20100405195936
#------------------------------------------
INSERT INTO old_survey_48842_20100405195936 VALUES("3","2010-04-05 19:58:27","1","de","dzyjmyysewgb3mu","011");
INSERT INTO old_survey_48842_20100405195936 VALUES("4","2010-04-05 19:59:18","1","de","p9z5gst96hnu232","012");



#------------------------------------------
# Table definition for old_tokens_48842_20100405194854
#------------------------------------------
DROP TABLE IF EXISTS old_tokens_48842_20100405194854;

CREATE TABLE old_tokens_48842_20100405194854 (
    `tid` int(11) NOT NULL auto_increment,
    `firstname` varchar(40),
    `lastname` varchar(40),
    `email` text,
    `emailstatus` text,
    `token` varchar(36),
    `language` varchar(25),
    `sent` varchar(17) DEFAULT 'N',
    `remindersent` varchar(17) DEFAULT 'N',
    `remindercount` int(11) DEFAULT '0',
    `completed` varchar(17) DEFAULT 'N',
    `validfrom` datetime,
    `validuntil` datetime,
    `mpid` int(11),
   PRIMARY KEY (tid),
   KEY tokens_48842_idx (token),
   KEY idx_tokens_48842_efl (email, firstname, lastname)
);


#------------------------------------------
# Table data for old_tokens_48842_20100405194854
#------------------------------------------
INSERT INTO old_tokens_48842_20100405194854 VALUES("1","User","A","usera@anonmail.de","OK","k4f4x35cbx54umq","de","2010-04-05 19:45","N","0","Y",NULL,NULL,NULL);
INSERT INTO old_tokens_48842_20100405194854 VALUES("2","User","B","userb@anonmail.de","OK","7jtx6wtvjunkaf3","de","2010-04-05 19:45","N","0","Y",NULL,NULL,NULL);



#------------------------------------------
# Table definition for old_tokens_48842_20100405195936
#------------------------------------------
DROP TABLE IF EXISTS old_tokens_48842_20100405195936;

CREATE TABLE old_tokens_48842_20100405195936 (
    `tid` int(11) NOT NULL auto_increment,
    `firstname` varchar(40),
    `lastname` varchar(40),
    `email` text,
    `emailstatus` text,
    `token` varchar(36),
    `language` varchar(25),
    `sent` varchar(17) DEFAULT 'N',
    `remindersent` varchar(17) DEFAULT 'N',
    `remindercount` int(11) DEFAULT '0',
    `completed` varchar(17) DEFAULT 'N',
    `validfrom` datetime,
    `validuntil` datetime,
    `mpid` int(11),
   PRIMARY KEY (tid),
   KEY tokens_48842_idx (token),
   KEY idx_tokens_48842_efl (email, firstname, lastname)
);


#------------------------------------------
# Table data for old_tokens_48842_20100405195936
#------------------------------------------
INSERT INTO old_tokens_48842_20100405195936 VALUES("1","User","A","usera@anonmail.de","OK","dzyjmyysewgb3mu","de","2010-04-05 19:57","N","0","2010-04-05 19:58",NULL,NULL,NULL);
INSERT INTO old_tokens_48842_20100405195936 VALUES("2","User","B","userb@anonmail.de","OK","p9z5gst96hnu232","de","2010-04-05 19:57","N","0","2010-04-05 19:59",NULL,NULL,NULL);



#------------------------------------------
# Table definition for question_attributes
#------------------------------------------
DROP TABLE IF EXISTS question_attributes;

CREATE TABLE question_attributes (
    `qaid` int(11) NOT NULL auto_increment,
    `qid` int(11) DEFAULT '0' NOT NULL,
    `attribute` varchar(50),
    `value` text,
   PRIMARY KEY (qaid),
   KEY question_attributes_idx2 (qid)
);


#------------------------------------------
# Table data for question_attributes
#------------------------------------------
INSERT INTO question_attributes VALUES("1","2","maximum_chars","3");
INSERT INTO question_attributes VALUES("2","6","display_columns","3");
INSERT INTO question_attributes VALUES("3","6","random_order","1");
INSERT INTO question_attributes VALUES("4","7","random_order","1");
INSERT INTO question_attributes VALUES("5","8","random_order","1");
INSERT INTO question_attributes VALUES("6","9","random_order","1");
INSERT INTO question_attributes VALUES("19","20","maximum_chars","2");
INSERT INTO question_attributes VALUES("239","46","alphasort","0");
INSERT INTO question_attributes VALUES("250","46","array_filter","");
INSERT INTO question_attributes VALUES("241","46","display_columns","1");
INSERT INTO question_attributes VALUES("242","46","hide_tip","0");
INSERT INTO question_attributes VALUES("243","46","hidden","0");
INSERT INTO question_attributes VALUES("244","46","other_comment_mandatory","0");
INSERT INTO question_attributes VALUES("245","46","other_replace_text","");
INSERT INTO question_attributes VALUES("246","46","page_break","0");
INSERT INTO question_attributes VALUES("247","46","public_statistics","0");
INSERT INTO question_attributes VALUES("248","46","random_order","0");
INSERT INTO question_attributes VALUES("249","46","scale_export","0");
INSERT INTO question_attributes VALUES("251","46","array_filter_exclude","");
INSERT INTO question_attributes VALUES("252","46","other_numbers_only","0");



#------------------------------------------
# Table definition for questions
#------------------------------------------
DROP TABLE IF EXISTS questions;

CREATE TABLE questions (
    `qid` int(11) NOT NULL auto_increment,
    `sid` int(11) DEFAULT '0' NOT NULL,
    `gid` int(11) DEFAULT '0' NOT NULL,
    `type` char(1) DEFAULT 'T' NOT NULL,
    `title` varchar(20) DEFAULT '' NOT NULL,
    `question` text NOT NULL,
    `preg` text,
    `help` text,
    `other` char(1) DEFAULT 'N' NOT NULL,
    `mandatory` char(1),
    `lid` int(11) DEFAULT '0' NOT NULL,
    `lid1` int(11) DEFAULT '0' NOT NULL,
    `question_order` int(11) NOT NULL,
    `language` varchar(20) DEFAULT 'en' NOT NULL,
   PRIMARY KEY (qid, language),
   KEY questions_idx2 (sid),
   KEY questions_idx3 (gid),
   KEY questions_idx4 (type)
);


#------------------------------------------
# Table data for questions
#------------------------------------------
INSERT INTO questions VALUES("1","29975","1","S","01","What is your name?","","","N","Y","0","0","0","en");
INSERT INTO questions VALUES("2","29975","1","N","03","And for our records, specifically how old are you?","","<i>This is a <b>numerical</b> question. Only numbers may be entered</i>. There is also a question_attribute added to the question to limit the characters to no more than 3. This, of course, limits the possible answer to no more than 999, which seems reasonable for an age question.","N","N","0","0","2","en");
INSERT INTO questions VALUES("3","29975","1","L","02","What is your age group?","","","N","N","0","0","1","en");
INSERT INTO questions VALUES("4","29975","2","T","01","Hi, {INSERTANS:29975X1X1} please tell us a little about yourself. What was your first job, and did you enjoy it?","","","N","N","0","0","0","en");
INSERT INTO questions VALUES("5","29975","2","L","03","Given your extraordinary age of {INSERTANS:29975X1X2} {INSERTANS:29975X1X1}, how do you find using this survey tool?","","This question is conditional, and only appears if someone is over 100 years old. It also has a \"random order\", which means that the options will appear in a different, random, order for each different participant.","Y","N","0","0","1","en");
INSERT INTO questions VALUES("6","29975","3","L","01","<font size=\'+2\'><br />&nbsp;<br />Which of these ads makes you want to find out more?<br />&nbsp;<br /></font>","","<i>This is an example of using graphics/images within a question. It uses attributes to set the pictures in columns, and also to randomise the display.</i>","N","Y","0","0","0","en");
INSERT INTO questions VALUES("7","29975","3","F","02a","Please have a good look at this ad, and then complete the questions below.<br />\n<img src=\'http://www.aptigence.com.au/images/lawyer1.jpg\' border=\'1\'>","","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.<br />\n<img src=\'http://www.aptigence.com.au/images/lawyer2.jpg\' border=\'1\'>","","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.<br />\n<img src=\'http://www.aptigence.com.au/images/lawyer3.jpg\' border=\'1\'>","","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&auml;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&uuml;r eine <b>Ausbildung</b> oder <b>Umschulung</b>  beworben?","","","N","N","9","0","2","de");
INSERT INTO questions VALUES("22","23766","12","F","04","Mein <b>erster</b> Eindruck von der GPB war&hellip;","","","N","N","2","0","2","de");
INSERT INTO questions VALUES("23","23766","12","F","05","Die Aufbereitung der erhaltenen Info-Materialien fand ich&hellip;","","","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 <b>Informationsveranstaltung</b> oder einer <b>individuellen Beratung</b> 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 <b>R&auml;umlichkeiten</b> 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","<p>This is a <strong><em>sample survey</em></strong> designed for testing LimeSurvey.</p><p>One of the first things you\'ll need to do, in order to make this work properly, is to fix up the &quot;reference to previous answers&quot; 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 &quot;SID=&quot;</p><p><strong><em>IE:</em></strong> 29975&amp;gid=2&amp;qid=4</p><p>Then, replace the &quot;&amp;gid=&quot; with an X, and replace the &quot;&amp;qid=&quot; with an X. So you should have:</p><p>29975X2X4</p><p>Then, you can replace the number in the curly brackets of question 1, group 2, so that it says:</p><p>(INSERTANS:29975X2X4)</p><p>Do the same with the other codes in the questions.</p><p>More information on using the answers to previous questions in your questions is available in the documentation.</p>","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","<br />
\n<b>Hallo</b> <b>{TOKEN:FIRSTNAME} {TOKEN:LASTNAME},</b><br />
\n<br />
\nwir freuen uns, dass Sie sich im Laufe des Jahres bei uns f&uuml;r eine Ausbildung / Umschulung interessiert haben. Da wir st&auml;ndig bem&uuml;ht sind unsere Service-Qualit&auml;t im Sinne unserer Kunden zu verbessern, m&ouml;chten wir Sie bitten, sich zwei bis drei Minuten Zeit zu nehmen und die folgenden Fragen zu beantworten.<br />
\n<br />
\nAls Dank f&uuml;r Ihre M&uuml;hen verlosen wir unter allen, die den Fragebogen beantworten, 2 Gutscheine der Buchhandlung Kiepert im Wert von jeweils 20 &euro;.<br />","<i>Zum Starten der Umfrage bitte unten rechts auf <b>Weiter</b> klicken.</i><br />","<b><br />
\nVielen Dank f&uuml;r Ihre Zeit und Mitarbeit,<br />
\nIhr GPB-Team!</b>","http://www.gpb-berlin.de","GPB Berlin - Ihr Partner im Bildungsbereich","Einladung zur Teilnahme an einer Umfrage","Hallo {FIRSTNAME} {LASTNAME},
\n
\nvor einiger Zeit haben Sie sich für unser Bidungsangebot interessiert. In diesem Zusammenhang möchten wir Sie einladen an einer Umfrage teilzunehmen. 
\n
\nKlicken Sie hier um die Umfrage zu starten: 
\n{SURVEYURL}
\n
\nMit freundlichen Grüßen
\n
\nGPB - Kundenservice","Erinnerung an Teilnahme an einer Umfrage","Hallo {FIRSTNAME} {LASTNAME},
\n
\nvor kurzem haben wir Sie zu unserer Umfrage eingeladen.  Zu unserem Bedauern haben wir bemerkt, dass Sie die Umfrage noch nicht ausgefüllt haben. Wir möchten Ihnen mitteilen, dass die Umfrage noch aktiv ist und würden uns freuen, wenn Sie teilnehmen könnten. Um an dieser Umfrage teilzunehmen, klicken Sie bitte auf den unten stehenden Link.
\n
\nKlicken Sie hier um die Umfrage zu starten: {SURVEYURL}
\n
\nMit freundlichen Grüßen
\n
\nGPB - Kundenservice","Registrierungsbestätigung für Teilnahmeumfrage","Hallo {FIRSTNAME} {LASTNAME},
\n
\nSie (oder jemand, der Ihre Email benutzt hat) haben sich für unsere Umfrage angemeldet. Um an dieser Umfrage teilzunehmen, klicken Sie bitte auf den folgenden Link: {SURVEYURL}. Wenn Sie irgendwelche Fragen zu dieser Umfrage haben oder wenn Sie sich nicht für diese Umfrage angemeldet haben und sie glauben, dass Ihnen diese E-Mail irrtümlicherweise zugeschickt worden ist, kontaktieren Sie uns bitte unter {ADMINEMAIL}.
\n
\nMit freundlichen Grüßen
\n
\nGPB - Kundenservice","Abschlussbestätigung einer Umfrage","Hallo {FIRSTNAME} {LASTNAME},
\n
\nvielen Dank für die Teilnahme an dieser Testumfrage.
\nSo könnte eine echte Teilnehmerumfrage aussehen.
\n
\nMit freundlichen Grüßen
\n
\nAxel Kloß","1");
INSERT INTO surveys_languagesettings VALUES("48842","de","Beispiel","Beispielumfrage","Hier sehen Se die verschiedenen Frage- bzw. Antwortarten.","Danke fürs Angucken.","","","Einladung zur Teilnahme an einer Umfrage","{SURVEYURL}","Erinnerung an Teilnahme an einer Umfrage","{SURVEYURL}","Registrierungsbestätigung für Teilnahmeumfrage","Hallo {FIRSTNAME},<br /><br />Sie (oder jemand, der Ihre Email benutzt hat) haben sich für eine Umfrage mit dem Titel {SURVEYNAME} angemeldet.<br /><br />Um an dieser Umfrage teilzunehmen, klicken Sie bitte auf den folgenden Link.<br /><br />{SURVEYURL}<br /><br />Wenn Sie irgendwelche Fragen zu dieser Umfrage haben oder wenn Sie sich _nicht_ für diese Umfrage angemeldet haben und sie glauben, dass Ihnen diese Email irrtümlicherweise zugeschickt worden ist, kontaktieren Sie bitte {ADMINNAME} unter {ADMINEMAIL}.","Abschlussbestätigung einer Umfrage","Hallo {FIRSTNAME},<br /><br />Vielen Dank für die Teilnahme an der Umfrage mit dem Titel {SURVEYNAME}. Ihre Antworten wurden bei uns gespeichert.<br /><br />Wenn Sie irgendwelche Fragen zu dieser Email haben, kontaktieren Sie bitte {ADMINNAME} unter {ADMINEMAIL}.<br /><br />Mit freundlichen Grüßen,<br /><br />{ADMINNAME}","1");



#------------------------------------------
# Table definition for surveys_rights
#------------------------------------------
DROP TABLE IF EXISTS surveys_rights;

CREATE TABLE surveys_rights (
    `sid` int(10) unsigned DEFAULT '0' NOT NULL,
    `uid` int(10) unsigned DEFAULT '0' NOT NULL,
    `edit_survey_property` tinyint(1) DEFAULT '0' NOT NULL,
    `define_questions` tinyint(1) DEFAULT '0' NOT NULL,
    `browse_response` tinyint(1) DEFAULT '0' NOT NULL,
    `export` tinyint(1) DEFAULT '0' NOT NULL,
    `delete_survey` tinyint(1) DEFAULT '0' NOT NULL,
    `activate_survey` tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (sid, uid)
);


#------------------------------------------
# Table data for surveys_rights
#------------------------------------------
INSERT INTO surveys_rights VALUES("29975","1","1","1","1","1","1","1");
INSERT INTO surveys_rights VALUES("48842","4","1","1","1","1","1","1");
INSERT INTO surveys_rights VALUES("23766","4","1","1","1","1","1","1");



#------------------------------------------
# Table definition for templates
#------------------------------------------
DROP TABLE IF EXISTS templates;

CREATE TABLE templates (
    `folder` varchar(255) NOT NULL,
    `creator` int(11) NOT NULL,
   PRIMARY KEY (folder)
);


#------------------------------------------
# Table data for templates
#------------------------------------------
INSERT INTO templates VALUES("basic","1");
INSERT INTO templates VALUES("bluengrey","1");
INSERT INTO templates VALUES("business_grey","1");
INSERT INTO templates VALUES("clear_logo","1");
INSERT INTO templates VALUES("default","1");
INSERT INTO templates VALUES("eirenicon","1");
INSERT INTO templates VALUES("limespired","1");
INSERT INTO templates VALUES("mint_idea","1");
INSERT INTO templates VALUES("nilsgerards","1");
INSERT INTO templates VALUES("sherpa","1");
INSERT INTO templates VALUES("vallendar","1");



#------------------------------------------
# Table definition for templates_rights
#------------------------------------------
DROP TABLE IF EXISTS templates_rights;

CREATE TABLE templates_rights (
    `uid` int(11) NOT NULL,
    `folder` varchar(255) NOT NULL,
    `use` int(1) NOT NULL,
   PRIMARY KEY (uid, folder)
);


#------------------------------------------
# Table data for templates_rights
#------------------------------------------
INSERT INTO templates_rights VALUES("2","default","1");
INSERT INTO templates_rights VALUES("2","basic","1");
INSERT INTO templates_rights VALUES("2","bluengrey","0");
INSERT INTO templates_rights VALUES("2","business_grey","0");
INSERT INTO templates_rights VALUES("2","clear_logo","0");
INSERT INTO templates_rights VALUES("2","eirenicon","0");
INSERT INTO templates_rights VALUES("2","limespired","0");
INSERT INTO templates_rights VALUES("2","mint_idea","0");
INSERT INTO templates_rights VALUES("2","nilsgerards","0");
INSERT INTO templates_rights VALUES("2","sherpa","0");
INSERT INTO templates_rights VALUES("2","vallendar","0");
INSERT INTO templates_rights VALUES("3","default","1");
INSERT INTO templates_rights VALUES("3","basic","1");
INSERT INTO templates_rights VALUES("3","bluengrey","1");
INSERT INTO templates_rights VALUES("3","business_grey","1");
INSERT INTO templates_rights VALUES("3","clear_logo","1");
INSERT INTO templates_rights VALUES("3","eirenicon","1");
INSERT INTO templates_rights VALUES("3","limespired","1");
INSERT INTO templates_rights VALUES("3","mint_idea","1");
INSERT INTO templates_rights VALUES("3","nilsgerards","1");
INSERT INTO templates_rights VALUES("3","sherpa","1");
INSERT INTO templates_rights VALUES("3","vallendar","1");
INSERT INTO templates_rights VALUES("4","default","1");



#------------------------------------------
# Table definition for tokens_23766
#------------------------------------------
DROP TABLE IF EXISTS tokens_23766;

CREATE TABLE tokens_23766 (
    `tid` int(11) NOT NULL auto_increment,
    `firstname` varchar(40),
    `lastname` varchar(40),
    `email` text,
    `emailstatus` text,
    `token` varchar(36),
    `language` varchar(25),
    `sent` varchar(17) DEFAULT 'N',
    `remindersent` varchar(17) DEFAULT 'N',
    `remindercount` int(11) DEFAULT '0',
    `completed` varchar(17) DEFAULT 'N',
    `validfrom` datetime,
    `validuntil` datetime,
    `mpid` int(11),
   PRIMARY KEY (tid),
   KEY tokens_23766_idx (token),
   KEY idx_tokens_23766_efl (email, firstname, lastname)
);


#------------------------------------------
# Table data for tokens_23766
#------------------------------------------
INSERT INTO tokens_23766 VALUES("1","Axel","Kloß","axel.kloss@faktorweb.de","OK","emehrtjrz7v9nrj","de","2010-03-19 17:39","N","0","2010-03-19 18:05",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("2","Axel","Kloss","axel.kloss@web.de","OK","5pxkqazxbzphikp","de","2010-03-19 18:17","N","0","2010-03-20 09:49",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("3","Roger","Schlag-Schffel","gpb-berlin@gpb.de","OK","5fv456bkstbkp3x","de","2010-03-19 18:17","N","0","2010-03-19 23:15",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("4","Martin","Mehlis","m.mehlis@gpb.de","OK","b7k9sair8trvb9f","de","2010-03-19 18:17","2010-03-29 14:57","2","2010-03-29 15:06",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("5","Anne","Sponholz","a.sponholz@gpb.de","OK","ydvtfyyrjrivb8w","de","2010-03-19 18:17","N","0","2010-03-20 13:24",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("6","Gerd","Gerstenmaier","g.gerstenmaier@gpb.de","OK","8i4tru4aka3b6cj","de","2010-03-29 15:01","N","0","N",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("7","Alex","Faber","a.faber@gpb.de","OK","kbwf5be43ytjt5s","de","2010-03-19 18:17","N","0","2010-03-22 08:38",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("8","Philipp","Eifeldt","philipp.eissfeldt@faktorweb.de","OK","qcas52k7a7gbgkn","de","2010-03-19 18:17","2010-03-29 14:57","1","N",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("9","Maxi","Carmienke","m.carmienke@gpb.de","OK","z7xvm27z48xwsrz","de","2010-03-19 18:17","N","0","2010-03-22 10:27",NULL,NULL,NULL);
INSERT INTO tokens_23766 VALUES("10","Sylvia","Herbst-Ilius","s.herbst-ilius@gpb.de","OK","ifbs8etsk3y2cem","de","2010-03-19 18:17","N","0","2010-03-22 10:49",NULL,NULL,NULL);



#------------------------------------------
# Table definition for tokens_48842
#------------------------------------------
DROP TABLE IF EXISTS tokens_48842;

CREATE TABLE tokens_48842 (
    `tid` int(11) NOT NULL auto_increment,
    `firstname` varchar(40),
    `lastname` varchar(40),
    `email` text,
    `emailstatus` text,
    `token` varchar(36),
    `language` varchar(25),
    `sent` varchar(17) DEFAULT 'N',
    `remindersent` varchar(17) DEFAULT 'N',
    `remindercount` int(11) DEFAULT '0',
    `completed` varchar(17) DEFAULT 'N',
    `validfrom` datetime,
    `validuntil` datetime,
    `mpid` int(11),
   PRIMARY KEY (tid),
   KEY tokens_48842_idx (token),
   KEY idx_tokens_48842_efl (email, firstname, lastname)
);


#------------------------------------------
# Table data for tokens_48842
#------------------------------------------
INSERT INTO tokens_48842 VALUES("5","User","A","usera@anonmail.de","OK","3kautsmpdk5p2br","de","2010-04-06 18:25","N","0","2010-04-06 18:26",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("4","A","K","axel.kloss@web.de","OK","zsewz2kn6592m3a","de","2010-04-06 10:45","2010-04-06 17:47","1","2010-04-06 18:09",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("3","Axel","K","axel.kloss@faktorweb.de","OK","xg6phhemg9489x6","de","2010-04-06 10:45","N","0","2010-04-06 17:37",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("6","User","B","userb@anonmail.de","OK","gnckiajkzuuerrb","de","2010-04-06 18:25","N","0","2010-04-06 18:27",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("7","User","C","userc@anonmail.de","OK","n2w7sv773jv7h4k","de","2010-04-06 18:33","N","0","2010-04-06 18:34",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("8","User","D","userd@anonmail.de","OK","mwt4u9bqmn38pp5","de","2010-04-06 18:33","N","0","2010-04-06 18:35",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("9","user","e","usera@anonmail.de","OK","zks3bvgx4ctbfmp","de","2010-04-06 18:43","N","0","2010-04-06 18:45",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("10","user","f","userc@anonmail.de","OK","qqyzezu6np6ymsv","de","2010-04-06 18:48","N","0","2010-04-06 18:50",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("11","user","g","userd@anonmail.de","OK","7sn78bvwe8xe7fz","de","2010-04-06 18:48","N","0","2010-04-06 18:51",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("12","user","h","userc@anonmail.de","OK","jncpmxffawcuv2i","de","2010-04-06 18:55","N","0","2010-04-06 18:56",NULL,NULL,NULL);
INSERT INTO tokens_48842 VALUES("13","user","i","userd@anonmail.de","OK","ci52ctcm3aeehsr","de","2010-04-06 18:55","N","0","2010-04-06 18:57",NULL,NULL,NULL);



#------------------------------------------
# Table definition for user_groups
#------------------------------------------
DROP TABLE IF EXISTS user_groups;

CREATE TABLE user_groups (
    `ugid` int(10) unsigned NOT NULL auto_increment,
    `name` varchar(20) NOT NULL,
    `description` text NOT NULL,
    `owner_id` int(10) unsigned NOT NULL,
   PRIMARY KEY (ugid),
   UNIQUE name (name)
);


#------------------------------------------
# Table data for user_groups
#------------------------------------------
INSERT INTO user_groups VALUES("1","GPB-Teilnehmer","","1");



#------------------------------------------
# Table definition for user_in_groups
#------------------------------------------
DROP TABLE IF EXISTS user_in_groups;

CREATE TABLE user_in_groups (
    `ugid` int(10) unsigned NOT NULL,
    `uid` int(10) unsigned NOT NULL,
   KEY user_in_groups_idx1 (ugid, uid)
);


#------------------------------------------
# Table data for user_in_groups
#------------------------------------------
INSERT INTO user_in_groups VALUES("1","1");
INSERT INTO user_in_groups VALUES("1","2");
INSERT INTO user_in_groups VALUES("1","3");



#------------------------------------------
# Table definition for users
#------------------------------------------
DROP TABLE IF EXISTS users;

CREATE TABLE users (
    `uid` int(11) NOT NULL auto_increment,
    `users_name` varchar(64) DEFAULT '' NOT NULL,
    `password` blob NOT NULL,
    `full_name` varchar(50) NOT NULL,
    `parent_id` int(10) unsigned NOT NULL,
    `lang` varchar(20),
    `email` varchar(320),
    `create_survey` tinyint(1) DEFAULT '0' NOT NULL,
    `create_user` tinyint(1) DEFAULT '0' NOT NULL,
    `delete_user` tinyint(1) DEFAULT '0' NOT NULL,
    `superadmin` tinyint(1) DEFAULT '0' NOT NULL,
    `configurator` tinyint(1) DEFAULT '0' NOT NULL,
    `manage_template` tinyint(1) DEFAULT '0' NOT NULL,
    `manage_label` tinyint(1) DEFAULT '0' NOT NULL,
    `htmleditormode` varchar(7) DEFAULT 'default',
    `one_time_pw` blob,
    `dateformat` int(10) unsigned DEFAULT '1' NOT NULL,
   PRIMARY KEY (uid),
   UNIQUE users_name (users_name)
);


#------------------------------------------
# Table data for users
#------------------------------------------
INSERT INTO users VALUES("1","admin","94488ebcbeb4f80858d3937028a6113dd00057c41ceda279cef3bab7e1363332","Administrator","0","de","webmaster@faktorweb.de","1","1","1","1","1","1","1","default",NULL,"1");
INSERT INTO users VALUES("2","m.mehlis","77b0008c6d4dac36c29fa547eb8b82cb18449fa0f2555378dc8b3ea62559b737","Martin Mehlis","1","de","m.mehlis@gpb-berlin.de","1","0","0","0","0","0","1","default",NULL,"1");
INSERT INTO users VALUES("3","a.kloss","7d187a5d40a254656417e87e83e7466c095bcb7e836985505927b4b19b5de62a","Axel Kloss","1","de","axel.kloss@faktorweb.de","1","1","1","1","1","1","1","default",NULL,"1");
INSERT INTO users VALUES("4","p.eissfeldt","7e03be4a3d3dcb92d5e89b3a715dd654514c0299d2c475017934fa3ff243b5b5","Philipp Eissfeldt","1","de","oscarwalt@googlemail.com","1","1","1","1","1","1","1","default",NULL,"1");