# MySQL dump 8.14
#
# Host: localhost    Database: umfrage
#--------------------------------------------------------
# Server version	3.23.41-log

#
# Table structure for table 'answers'
#

CREATE TABLE answers (
  anr int(11) NOT NULL default '0',
  lnr int(11) NOT NULL default '0',
  typenr int(11) NOT NULL default '0',
  text text,
  width text,
  height text,
  wrap tinyint(4) default NULL,
  nr int(11) NOT NULL auto_increment,
  PRIMARY KEY  (nr)
) TYPE=MyISAM;

#
# Dumping data for table 'answers'
#

INSERT INTO answers VALUES (1,1,5,'m&auml;nnlich | weiblich',NULL,NULL,NULL,1);
INSERT INTO answers VALUES (1,2,4,'male | female',NULL,NULL,NULL,2);
INSERT INTO answers VALUES (2,1,1,NULL,'3','1',0,3);
INSERT INTO answers VALUES (3,1,5,'Veganer | Vegetarier | Lactovegetarier | Ovovegetarier | Vegetarier und Fisch | Allesesser',NULL,NULL,NULL,4);
INSERT INTO answers VALUES (3,2,5,'vegan | vegetarian | lactovegetarian | ovovegetarian | vegetarian and fish | omnivor',NULL,NULL,NULL,5);
INSERT INTO answers VALUES (4,1,2,'kein Abschlu&szlig; | Hauptschule | Realschule | Abitur/Fachabitur | Hochschule',NULL,NULL,NULL,6);
INSERT INTO answers VALUES (5,1,2,'keine Angabe | bis 500 EUR | bis 1000 EUR | bis 1500 EUR | bis 2000 EUR | bis 3000 EUR | mehr',NULL,NULL,NULL,7);
INSERT INTO answers VALUES (5,2,2,'not available | bis 500 EUR | until 1000 EUR | until 1500 EUR | until 2000 EUR | until 3000 EUR | more',NULL,NULL,NULL,8);
INSERT INTO answers VALUES (4,2,2,'no graduation | secondary school | A-levels | college | university',NULL,NULL,NULL,9);
INSERT INTO answers VALUES (6,1,10,'(Ich bin Veganer wegen: | Ich bin Vegetarier wegen: | Ich bin weder noch wegen:) (Gesundheit | Tiere | Umwelt | Ethik | Welthunger | Religion | Sonstiges)',NULL,NULL,NULL,10);
INSERT INTO answers VALUES (6,2,10,'(I am vegan because: | I am vegetarian because: | I am none because:) (health | animals | environment | ethic | worldhunger | religion | other)',NULL,NULL,NULL,11);
INSERT INTO answers VALUES (7,1,9,'5 (alleine | in Gesellschaft)',NULL,NULL,NULL,12);
INSERT INTO answers VALUES (8,1,9,'5 (gesellschaftlich akzeptiert | Au&szlig;enseiter)',NULL,NULL,NULL,13);
INSERT INTO answers VALUES (9,1,9,'5 (bel&auml;chelt | bewundert)',NULL,NULL,NULL,14);
INSERT INTO answers VALUES (10,1,9,'5 (kritisiert | um Rat gefragt)',NULL,NULL,NULL,15);
INSERT INTO answers VALUES (11,1,9,'5 (w&uuml;tend | nachsichtig, friedlich)',NULL,NULL,NULL,16);
INSERT INTO answers VALUES (12,1,9,'5 (hoffnungslos | zielsicher)',NULL,NULL,NULL,17);
INSERT INTO answers VALUES (13,1,9,'5 ( r&uuml;cksichtsvoll | intolerant)',NULL,NULL,NULL,18);

#
# Table structure for table 'answertype'
#

CREATE TABLE answertype (
  typenr int(11) NOT NULL default '0',
  at_text text NOT NULL,
  PRIMARY KEY  (typenr)
) TYPE=MyISAM;

#
# Dumping data for table 'answertype'
#

INSERT INTO answertype VALUES (1,'textfield');
INSERT INTO answertype VALUES (2,'dropdown');
INSERT INTO answertype VALUES (3,'radio_vertical');
INSERT INTO answertype VALUES (4,'radio_horizontal');
INSERT INTO answertype VALUES (5,'radio_stack');
INSERT INTO answertype VALUES (6,'check_vertical');
INSERT INTO answertype VALUES (7,'check_horizontal');
INSERT INTO answertype VALUES (8,'check_stack');
INSERT INTO answertype VALUES (9,'radio_slide');
INSERT INTO answertype VALUES (10,'radio_slide_matrix');

#
# Table structure for table 'language'
#

CREATE TABLE language (
  lnr int(11) NOT NULL auto_increment,
  text varchar(255) NOT NULL default '',
  PRIMARY KEY  (lnr)
) TYPE=MyISAM;

#
# Dumping data for table 'language'
#

INSERT INTO language VALUES (1,'deutsch');
INSERT INTO language VALUES (2,'englisch');

#
# Table structure for table 'page_question'
#

CREATE TABLE page_question (
  snr int(11) NOT NULL default '0',
  pnr int(11) NOT NULL default '0',
  qnr int(11) NOT NULL default '0',
  positionnr int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table 'page_question'
#

INSERT INTO page_question VALUES (1,5,7,1);
INSERT INTO page_question VALUES (1,4,6,1);
INSERT INTO page_question VALUES (1,3,5,2);
INSERT INTO page_question VALUES (1,3,4,1);
INSERT INTO page_question VALUES (1,2,3,1);
INSERT INTO page_question VALUES (1,1,2,3);
INSERT INTO page_question VALUES (1,1,1,2);
INSERT INTO page_question VALUES (1,1,8,1);

#
# Table structure for table 'pages'
#

CREATE TABLE pages (
  snr int(11) NOT NULL default '0',
  pnr int(11) NOT NULL default '0',
  next_pnr int(11) default NULL,
  lnr int(11) NOT NULL default '0',
  color varchar(255) default NULL,
  picturelocation varchar(255) default NULL
) TYPE=MyISAM;

#
# Dumping data for table 'pages'
#

INSERT INTO pages VALUES (1,2,3,1,NULL,'http://www.veganwelt.de/pics/rand/rand_05.jpg');
INSERT INTO pages VALUES (1,1,2,1,NULL,'http://www.veganwelt.de/pics/rand/rand_05.jpg');
INSERT INTO pages VALUES (1,3,4,1,NULL,'http://www.veganwelt.de/pics/rand/rand_05.jpg');
INSERT INTO pages VALUES (1,4,5,1,NULL,'http://www.veganwelt.de/pics/rand/rand_05.jpg');
INSERT INTO pages VALUES (1,5,NULL,1,NULL,'http://www.veganwelt.de/pics/rand/rand_05.jpg');

#
# Table structure for table 'questions'
#

CREATE TABLE questions (
  qnr int(11) NOT NULL default '0',
  lnr int(1) NOT NULL default '0',
  text text NOT NULL,
  qt tinyint(4) default NULL
) TYPE=MyISAM;

#
# Dumping data for table 'questions'
#

INSERT INTO questions VALUES (2,2,'age',0);
INSERT INTO questions VALUES (2,1,'Alter',0);
INSERT INTO questions VALUES (1,2,'sex',0);
INSERT INTO questions VALUES (1,1,'Geschlecht',0);
INSERT INTO questions VALUES (3,1,'Ern&auml;hrung',0);
INSERT INTO questions VALUES (3,2,'diet',0);
INSERT INTO questions VALUES (4,1,'H&ouml;chster Bildungsabschlu&szlig;',0);
INSERT INTO questions VALUES (4,2,'education',0);
INSERT INTO questions VALUES (5,1,'Monatliches Einkommen',0);
INSERT INTO questions VALUES (5,2,'monthly income',0);
INSERT INTO questions VALUES (6,1,'Gr&uuml;nde',0);
INSERT INTO questions VALUES (6,2,'reasons',0);
INSERT INTO questions VALUES (7,1,'Als Veganer f&uuml;hlt man sich/wird man/ist man...',0);
INSERT INTO questions VALUES (7,2,'As vegan you feel/you are/you are seen as...',0);
INSERT INTO questions VALUES (8,1,'Bei dieser Umfrage wollen wir etwas &uuml;ber die Ern&auml;hrungsform unserer Benutzer erfahren.<br> Bei Problemen wenden Sie sich bitte an unseren Webmaster Bernd Ulmann.',1);
INSERT INTO questions VALUES (8,2,'In this survey we want to get some knowledge about the diet of our users.<br> If you have any problems please contact our webmaster Bernd Ulmann.',1);

#
# Table structure for table 'questions_answers'
#

CREATE TABLE questions_answers (
  qnr int(11) NOT NULL default '0',
  anr int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table 'questions_answers'
#

INSERT INTO questions_answers VALUES (5,5);
INSERT INTO questions_answers VALUES (4,4);
INSERT INTO questions_answers VALUES (3,3);
INSERT INTO questions_answers VALUES (2,2);
INSERT INTO questions_answers VALUES (1,1);

#
# Table structure for table 'results'
#

CREATE TABLE results (
  snr int(11) NOT NULL default '0',
  id int(11) NOT NULL default '0',
  autokey int(11) NOT NULL auto_increment,
  time timestamp(14) NOT NULL,
  result text NOT NULL,
  PRIMARY KEY  (snr,id,autokey)
) TYPE=MyISAM;

#
# Dumping data for table 'results'
#


#
# Table structure for table 'survey'
#

CREATE TABLE survey (
  snr int(11) NOT NULL default '0',
  text varchar(255) default NULL,
  evaluate_cgi varchar(40) NOT NULL default '',
  PRIMARY KEY  (snr)
) TYPE=MyISAM;

#
# Dumping data for table 'survey'
#

INSERT INTO survey VALUES (1,'Veganumfrage 1','eval_1.pl');

