-- Table structure for table `rbac_ua`
--

CREATE TABLE `rbac_ua` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `rol_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`rol_id`),
  KEY `i1_idx` (`usr_id`),
  KEY `i2_idx` (`rol_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_ua`
--

INSERT INTO `rbac_ua` VALUES (6,2),(13,14);

--
-- Table structure for table `rcat_settings`
--

CREATE TABLE `rcat_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rcat_settings`
--


--
-- Table structure for table `read_event`
--

CREATE TABLE `read_event` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `last_access` int(11) DEFAULT NULL,
  `read_count` int(11) NOT NULL DEFAULT '0',
  `spent_seconds` int(11) NOT NULL DEFAULT '0',
  `first_access` datetime DEFAULT NULL,
  `childs_read_count` int(11) NOT NULL DEFAULT '0',
  `childs_spent_seconds` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`),
  KEY `i1_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `read_event`
--


--
-- Table structure for table `reg_access_limit`
--

CREATE TABLE `reg_access_limit` (
  `role_id` int(11) NOT NULL DEFAULT '0',
  `limit_absolute` int(11) DEFAULT NULL,
  `limit_relative_d` int(11) DEFAULT NULL,
  `limit_relative_m` int(11) DEFAULT NULL,
  `limit_mode` char(16) DEFAULT 'absolute',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reg_access_limit`
--


--
-- Table structure for table `reg_er_assignments`
--

CREATE TABLE `reg_er_assignments` (
  `assignment_id` int(11) NOT NULL DEFAULT '0',
  `domain` varchar(128) DEFAULT NULL,
  `role` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`assignment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reg_er_assignments`
--

INSERT INTO `reg_er_assignments` VALUES (1,'',0);

--
-- Table structure for table `reg_er_assignments_seq`
--

CREATE TABLE `reg_er_assignments_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reg_er_assignments_seq`
--

INSERT INTO `reg_er_assignments_seq` VALUES (1);

--
-- Table structure for table `reg_registration_codes`
--

CREATE TABLE `reg_registration_codes` (
  `code_id` int(11) NOT NULL DEFAULT '0',
  `code` varchar(50) DEFAULT NULL,
  `role` int(11) DEFAULT '0',
  `generated_on` int(11) DEFAULT '0',
  `used` int(11) NOT NULL DEFAULT '0',
  `role_local` varchar(255) DEFAULT NULL,
  `alimit` varchar(50) DEFAULT NULL,
  `alimitdt` varchar(255) DEFAULT NULL,
  `reg_enabled` tinyint(4) NOT NULL DEFAULT '1',
  `ext_enabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`code_id`),
  KEY `i1_idx` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reg_registration_codes`
--


--
-- Table structure for table `reg_registration_codes_seq`
--

CREATE TABLE `reg_registration_codes_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reg_registration_codes_seq`
--


--
-- Table structure for table `remote_course_settings`
--

CREATE TABLE `remote_course_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `local_information` varchar(4000) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  `r_start` int(11) NOT NULL DEFAULT '0',
  `r_end` int(11) NOT NULL DEFAULT '0',
  `remote_link` varchar(4000) DEFAULT NULL,
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `remote_course_settings`
--


--
-- Table structure for table `rep_rec_content_obj`
--

CREATE TABLE `rep_rec_content_obj` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `declined` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rep_rec_content_obj`
--


--
-- Table structure for table `rep_rec_content_role`
--

CREATE TABLE `rep_rec_content_role` (
  `role_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`role_id`,`ref_id`),
  KEY `i1_idx` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rep_rec_content_role`
--


--
-- Table structure for table `rep_rec_content_role_seq`
--

CREATE TABLE `rep_rec_content_role_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rep_rec_content_role_seq`
--


--
-- Table structure for table `rfil_settings`
--

CREATE TABLE `rfil_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `version` smallint(6) NOT NULL DEFAULT '1',
  `version_tstamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rfil_settings`
--


--
-- Table structure for table `rglo_settings`
--

CREATE TABLE `rglo_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rglo_settings`
--


--
-- Table structure for table `rgrp_settings`
--

CREATE TABLE `rgrp_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  `availability_start` int(11) DEFAULT NULL,
  `availability_end` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rgrp_settings`
--


--
-- Table structure for table `rlm_settings`
--

CREATE TABLE `rlm_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rlm_settings`
--


--
-- Table structure for table `role_data`
--

CREATE TABLE `role_data` (
  `role_id` int(11) NOT NULL DEFAULT '0',
  `allow_register` tinyint(4) NOT NULL DEFAULT '0',
  `assign_users` tinyint(4) DEFAULT '0',
  `auth_mode` char(16) DEFAULT 'default',
  PRIMARY KEY (`role_id`),
  KEY `i1_idx` (`auth_mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `role_data`
--

INSERT INTO `role_data` VALUES (2,0,0,'default'),(3,0,0,'default'),(4,0,0,'default'),(5,1,0,'default'),(14,0,0,'default'),(134,0,0,'default'),(187,0,0,'default');

--
-- Table structure for table `rtst_settings`
--

CREATE TABLE `rtst_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  `availability_start` int(11) DEFAULT NULL,
  `availability_end` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rtst_settings`
--


--
-- Table structure for table `rwik_settings`
--

CREATE TABLE `rwik_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `organization` varchar(400) DEFAULT NULL,
  `local_information` varchar(4000) DEFAULT NULL,
  `remote_link` varchar(400) DEFAULT NULL,
  `availability_type` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rwik_settings`
--


--
-- Table structure for table `sahs_lm`
--

CREATE TABLE `sahs_lm` (
  `id` int(11) NOT NULL DEFAULT '0',
  `c_online` varchar(3) DEFAULT 'n',
  `api_adapter` varchar(80) DEFAULT 'API',
  `api_func_prefix` varchar(20) DEFAULT 'LMS',
  `credit` varchar(10) DEFAULT 'credit',
  `default_lesson_mode` varchar(8) DEFAULT 'normal',
  `auto_review` varchar(3) DEFAULT 'n',
  `c_type` varchar(10) DEFAULT NULL,
  `max_attempt` int(11) DEFAULT '0',
  `module_version` int(11) DEFAULT '1',
  `editable` int(11) NOT NULL DEFAULT '0',
  `stylesheet` int(11) NOT NULL DEFAULT '0',
  `glossary` int(11) NOT NULL DEFAULT '0',
  `question_tries` int(11) DEFAULT '3',
  `unlimited_session` varchar(1) NOT NULL DEFAULT 'n',
  `no_menu` varchar(1) NOT NULL DEFAULT 'n',
  `hide_navig` varchar(1) NOT NULL DEFAULT 'n',
  `debug` varchar(1) NOT NULL DEFAULT 'n',
  `debugpw` varchar(50) DEFAULT 'n',
  `entry_page` int(11) NOT NULL DEFAULT '0',
  `seq_exp_mode` tinyint(4) DEFAULT '0',
  `localization` varchar(2) DEFAULT NULL,
  `open_mode` tinyint(4) NOT NULL DEFAULT '0',
  `width` smallint(6) NOT NULL DEFAULT '950',
  `height` smallint(6) NOT NULL DEFAULT '650',
  `auto_continue` varchar(1) NOT NULL DEFAULT 'n',
  `sequencing` varchar(1) NOT NULL DEFAULT 'y',
  `interactions` varchar(1) NOT NULL DEFAULT 'y',
  `objectives` varchar(1) NOT NULL DEFAULT 'y',
  `time_from_lms` varchar(1) NOT NULL DEFAULT 'n',
  `comments` varchar(1) NOT NULL DEFAULT 'y',
  `auto_last_visited` varchar(1) NOT NULL DEFAULT 'y',
  `check_values` varchar(1) NOT NULL DEFAULT 'y',
  `offline_mode` varchar(1) NOT NULL DEFAULT 'n',
  `offline_zip_created` datetime DEFAULT NULL,
  `auto_suspend` varchar(1) NOT NULL DEFAULT 'n',
  `fourth_edition` varchar(1) NOT NULL DEFAULT 'n',
  `ie_compatibility` varchar(1) DEFAULT NULL,
  `ie_force_render` varchar(1) NOT NULL DEFAULT 'n',
  `mastery_score` tinyint(4) DEFAULT NULL,
  `id_setting` tinyint(4) NOT NULL DEFAULT '0',
  `name_setting` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_lm`
--


--
-- Table structure for table `sahs_sc13_sco`
--

CREATE TABLE `sahs_sc13_sco` (
  `id` int(11) NOT NULL DEFAULT '0',
  `hide_obj_page` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_sco`
--


--
-- Table structure for table `sahs_sc13_seq_assign`
--

CREATE TABLE `sahs_sc13_seq_assign` (
  `identifier` varchar(50) DEFAULT NULL,
  `sahs_sc13_tree_node_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sahs_sc13_tree_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_assign`
--


--
-- Table structure for table `sahs_sc13_seq_cond`
--

CREATE TABLE `sahs_sc13_seq_cond` (
  `cond` varchar(50) DEFAULT NULL,
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `measurethreshold` varchar(50) DEFAULT NULL,
  `operator` varchar(50) DEFAULT NULL,
  `referencedobjective` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`seqnodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_cond`
--


--
-- Table structure for table `sahs_sc13_seq_course`
--

CREATE TABLE `sahs_sc13_seq_course` (
  `flow` tinyint(4) DEFAULT '0',
  `choice` tinyint(4) DEFAULT '1',
  `forwardonly` tinyint(4) DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_course`
--


--
-- Table structure for table `sahs_sc13_seq_item`
--

CREATE TABLE `sahs_sc13_seq_item` (
  `importid` varchar(32) DEFAULT NULL,
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `sahs_sc13_tree_node_id` int(11) NOT NULL DEFAULT '0',
  `sequencingid` varchar(50) DEFAULT NULL,
  `nocopy` tinyint(4) DEFAULT NULL,
  `nodelete` tinyint(4) DEFAULT NULL,
  `nomove` tinyint(4) DEFAULT NULL,
  `seqxml` longtext,
  `rootlevel` tinyint(4) NOT NULL DEFAULT '0',
  `importseqxml` longtext,
  PRIMARY KEY (`sahs_sc13_tree_node_id`,`rootlevel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_item`
--


--
-- Table structure for table `sahs_sc13_seq_mapinfo`
--

CREATE TABLE `sahs_sc13_seq_mapinfo` (
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `readnormalizedmeasure` tinyint(4) DEFAULT NULL,
  `readsatisfiedstatus` tinyint(4) DEFAULT NULL,
  `targetobjectiveid` varchar(50) DEFAULT NULL,
  `writenormalizedmeasure` tinyint(4) DEFAULT NULL,
  `writesatisfiedstatus` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`seqnodeid`),
  KEY `i1_idx` (`targetobjectiveid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_mapinfo`
--


--
-- Table structure for table `sahs_sc13_seq_node`
--

CREATE TABLE `sahs_sc13_seq_node` (
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `nodename` varchar(50) DEFAULT NULL,
  `tree_node_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`seqnodeid`),
  KEY `i2_idx` (`tree_node_id`),
  KEY `i3_idx` (`nodename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_node`
--


--
-- Table structure for table `sahs_sc13_seq_node_seq`
--

CREATE TABLE `sahs_sc13_seq_node_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_node_seq`
--


--
-- Table structure for table `sahs_sc13_seq_obj`
--

CREATE TABLE `sahs_sc13_seq_obj` (
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `minnormalizedmeasure` varchar(50) DEFAULT NULL,
  `objectiveid` varchar(200) DEFAULT NULL,
  `primary_obj` tinyint(4) DEFAULT NULL,
  `satisfiedbymeasure` tinyint(4) DEFAULT NULL,
  `import_objective_id` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`seqnodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_obj`
--


--
-- Table structure for table `sahs_sc13_seq_rule`
--

CREATE TABLE `sahs_sc13_seq_rule` (
  `action` varchar(50) DEFAULT NULL,
  `childactivityset` varchar(50) DEFAULT NULL,
  `conditioncombination` varchar(50) DEFAULT NULL,
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `minimumcount` int(11) DEFAULT NULL,
  `minimumpercent` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`seqnodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_rule`
--


--
-- Table structure for table `sahs_sc13_seq_templ`
--

CREATE TABLE `sahs_sc13_seq_templ` (
  `seqnodeid` int(11) NOT NULL DEFAULT '0',
  `id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`seqnodeid`,`id`),
  KEY `i1_idx` (`seqnodeid`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_templ`
--


--
-- Table structure for table `sahs_sc13_seq_templts`
--

CREATE TABLE `sahs_sc13_seq_templts` (
  `identifier` varchar(50) DEFAULT NULL,
  `filename` varchar(50) DEFAULT NULL,
  `id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_templts`
--

INSERT INTO `sahs_sc13_seq_templts` VALUES ('pretestpost','pretest_posttest.xml',1),('linearpath','linear_path.xml',2),('linearpathforward','linear_path_forward.xml',3),('mandatoryoptions','mandatory_options.xml',4);

--
-- Table structure for table `sahs_sc13_seq_templts_seq`
--

CREATE TABLE `sahs_sc13_seq_templts_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_templts_seq`
--

INSERT INTO `sahs_sc13_seq_templts_seq` VALUES (4);

--
-- Table structure for table `sahs_sc13_seq_tree`
--

CREATE TABLE `sahs_sc13_seq_tree` (
  `child` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) DEFAULT NULL,
  `lft` int(11) DEFAULT NULL,
  `importid` varchar(32) NOT NULL DEFAULT '',
  `parent` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) DEFAULT NULL,
  PRIMARY KEY (`child`,`importid`,`parent`),
  KEY `i1_idx` (`child`),
  KEY `i2_idx` (`importid`),
  KEY `i3_idx` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_seq_tree`
--


--
-- Table structure for table `sahs_sc13_tree`
--

CREATE TABLE `sahs_sc13_tree` (
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`child`,`parent`,`slm_id`),
  KEY `i1_idx` (`child`),
  KEY `i2_idx` (`parent`),
  KEY `i3_idx` (`slm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_tree`
--


--
-- Table structure for table `sahs_sc13_tree_node`
--

CREATE TABLE `sahs_sc13_tree_node` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `type` char(4) DEFAULT NULL,
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`slm_id`),
  KEY `i2_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_tree_node`
--

INSERT INTO `sahs_sc13_tree_node` VALUES (1,'Dummy top node for all trees.','',0,'',NULL,NULL);

--
-- Table structure for table `sahs_sc13_tree_node_seq`
--

CREATE TABLE `sahs_sc13_tree_node_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_sc13_tree_node_seq`
--

INSERT INTO `sahs_sc13_tree_node_seq` VALUES (1);

--
-- Table structure for table `sahs_user`
--

CREATE TABLE `sahs_user` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `package_attempts` smallint(6) DEFAULT NULL,
  `module_version` smallint(6) DEFAULT NULL,
  `last_visited` varchar(255) DEFAULT NULL,
  `hash` varchar(20) DEFAULT NULL,
  `hash_end` datetime DEFAULT NULL,
  `offline_mode` varchar(8) DEFAULT NULL,
  `last_access` datetime DEFAULT NULL,
  `total_time_sec` int(11) DEFAULT NULL,
  `sco_total_time_sec` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `percentage_completed` tinyint(4) DEFAULT NULL,
  `first_access` datetime DEFAULT NULL,
  `last_status_change` datetime DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sahs_user`
--


--
-- Table structure for table `saml_idp_settings`
--

CREATE TABLE `saml_idp_settings` (
  `idp_id` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL,
  `allow_local_auth` tinyint(4) NOT NULL DEFAULT '0',
  `default_role_id` int(11) NOT NULL DEFAULT '0',
  `uid_claim` varchar(1000) DEFAULT NULL,
  `login_claim` varchar(1000) DEFAULT NULL,
  `sync_status` tinyint(4) NOT NULL DEFAULT '0',
  `account_migr_status` tinyint(4) NOT NULL DEFAULT '0',
  `entity_id` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`idp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `saml_idp_settings`
--


--
-- Table structure for table `saml_idp_settings_seq`
--

CREATE TABLE `saml_idp_settings_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `saml_idp_settings_seq`
--


--
-- Table structure for table `sc_item`
--

CREATE TABLE `sc_item` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(200) DEFAULT NULL,
  `identifierref` varchar(200) DEFAULT NULL,
  `isvisible` varchar(6) DEFAULT NULL,
  `parameters` varchar(4000) DEFAULT NULL,
  `prereq_type` varchar(200) DEFAULT NULL,
  `prerequisites` varchar(4000) DEFAULT NULL,
  `maxtimeallowed` varchar(30) DEFAULT NULL,
  `timelimitaction` varchar(30) DEFAULT NULL,
  `datafromlms` longtext,
  `masteryscore` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_item`
--


--
-- Table structure for table `sc_manifest`
--

CREATE TABLE `sc_manifest` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(200) DEFAULT NULL,
  `version` varchar(200) DEFAULT NULL,
  `xml_base` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_manifest`
--


--
-- Table structure for table `sc_organization`
--

CREATE TABLE `sc_organization` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(200) DEFAULT NULL,
  `structure` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_organization`
--


--
-- Table structure for table `sc_organizations`
--

CREATE TABLE `sc_organizations` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `default_organization` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_organizations`
--


--
-- Table structure for table `sc_resource`
--

CREATE TABLE `sc_resource` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(200) DEFAULT NULL,
  `resourcetype` varchar(30) DEFAULT NULL,
  `scormtype` varchar(6) DEFAULT NULL,
  `href` varchar(250) DEFAULT NULL,
  `xml_base` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`import_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resource`
--


--
-- Table structure for table `sc_resource_dependen`
--

CREATE TABLE `sc_resource_dependen` (
  `id` int(11) NOT NULL DEFAULT '0',
  `res_id` int(11) DEFAULT NULL,
  `identifierref` varchar(200) DEFAULT NULL,
  `nr` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resource_dependen`
--


--
-- Table structure for table `sc_resource_dependen_seq`
--

CREATE TABLE `sc_resource_dependen_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resource_dependen_seq`
--


--
-- Table structure for table `sc_resource_file`
--

CREATE TABLE `sc_resource_file` (
  `id` int(11) NOT NULL DEFAULT '0',
  `res_id` int(11) DEFAULT NULL,
  `href` varchar(4000) DEFAULT NULL,
  `nr` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resource_file`
--


--
-- Table structure for table `sc_resource_file_seq`
--

CREATE TABLE `sc_resource_file_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resource_file_seq`
--


--
-- Table structure for table `sc_resources`
--

CREATE TABLE `sc_resources` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `xml_base` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sc_resources`
--


--
-- Table structure for table `scorm_object`
--

CREATE TABLE `scorm_object` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `c_type` char(3) DEFAULT NULL,
  `slm_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `scorm_object`
--


--
-- Table structure for table `scorm_object_seq`
--

CREATE TABLE `scorm_object_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `scorm_object_seq`
--


--
-- Table structure for table `scorm_tracking`
--

CREATE TABLE `scorm_tracking` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `sco_id` int(11) NOT NULL DEFAULT '0',
  `lvalue` varchar(64) NOT NULL DEFAULT ' ',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `c_timestamp` datetime DEFAULT NULL,
  `rvalue` longtext,
  PRIMARY KEY (`user_id`,`sco_id`,`lvalue`,`obj_id`),
  KEY `i2_idx` (`obj_id`,`sco_id`,`lvalue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `scorm_tracking`
--


--
-- Table structure for table `scorm_tree`
--

CREATE TABLE `scorm_tree` (
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`slm_id`,`child`),
  KEY `i1_idx` (`child`),
  KEY `i2_idx` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `scorm_tree`
--


--
-- Table structure for table `search_command_queue`
--

CREATE TABLE `search_command_queue` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` char(4) NOT NULL DEFAULT '',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` char(4) DEFAULT NULL,
  `command` char(16) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `finished` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`obj_type`,`sub_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `search_command_queue`
--

INSERT INTO `search_command_queue` VALUES (313,'wsrt',0,'','create','[[regtime]]',0);

--
-- Table structure for table `search_data`
--

CREATE TABLE `search_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `target` varchar(4000) DEFAULT NULL,
  `type` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `search_data`
--


--
-- Table structure for table `search_data_seq`
--

CREATE TABLE `search_data_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `search_data_seq`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `module` varchar(50) NOT NULL DEFAULT 'common',
  `keyword` varchar(50) NOT NULL DEFAULT ' ',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`module`,`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES ('adve','autosave','30'),('adve','auto_url_linking','1'),('adve','block_mode_minutes','0'),('adve','use_physical',''),('assessment','assessment_manual_scoring','8,14'),('assessment','ass_process_lock_mode','db'),('assessment','quest_process_lock_mode_autoinit_done','1'),('assessment','use_javascript','1'),('awrn','awrn_enabled','1'),('awrn','caching_period','20'),('awrn','max_nr_entries','50'),('awrn','up_act_adm_contacts','2'),('awrn','up_act_contact_approved','2'),('awrn','up_act_contact_requests','1'),('awrn','up_act_crs_contacts','1'),('awrn','up_act_crs_current','0'),('awrn','up_act_mmbr_user_grpcrs','0'),('awrn','up_act_user_all','0'),('awrn','use_osd','1'),('bdga','active','1'),('bdga','components','a:2:{i:0;s:3:\"crs\";i:1;s:4:\"user\";}'),('bdga','obi_active',''),('bdga','obi_contact',''),('bdga','obi_organisation',''),('bdga','obi_salt',''),('buddysystem','enabled','1'),('calendar','cache_enabled','0'),('calendar','cache_minutes','0'),('calendar','cg_registration','1'),('calendar','consultation_hours','0'),('calendar','course_cal','1'),('calendar','default_date_format','1'),('calendar','default_day_end','19'),('calendar','default_day_start','8'),('calendar','default_timezone','Europe/Berlin'),('calendar','default_time_format','1'),('calendar','default_week_start','1'),('calendar','enabled','1'),('calendar','group_cal','1'),('calendar','notification','0'),('calendar','notification_user','0'),('calendar','sync_cache_enabled','0'),('calendar','sync_cache_minutes','10'),('calendar','webcal_sync','1'),('calendar','webcal_sync_hours','1'),('certificate','persisting_cers_introduced_ts','1654602369'),('chatroom','conversation_idle_state_in_minutes','1'),('chatroom','public_room_ref','46'),('cmix','ilias_uuid','20a27720-3338-4b46-8b3f-669d61110a30'),('common','admin_city',''),('common','admin_country',''),('common','admin_email','[[admin_email]]'),('common','admin_firstname','[[admin_fname]]'),('common','admin_institution',''),('common','admin_lastname','[[admin_lname]]'),('common','admin_phone',''),('common','admin_position',''),('common','admin_street',''),('common','admin_title',''),('common','admin_zipcode',''),('common','allow_change_loginname','0'),('common','anonymous_role_id','14'),('common','anonymous_user_id','13'),('common','approve_recipient','a:0:{}'),('common','auth_mode','1'),('common','auto_complete_length','10'),('common','auto_registration','1'),('common','bench_max_records','10000'),('common','block_activated_pdtag','1'),('common','block_activated_pdusers','1'),('common','chat_export_period','1'),('common','chat_export_status','0'),('common','comments_del_tutor','1'),('common','comments_del_user','0'),('common','comments_noti_recip',''),('common','convert_path',''),('common','create_history_loginname','0'),('common','custom_icon_big_height','32'),('common','custom_icon_big_width','32'),('common','custom_icon_small_height','22'),('common','custom_icon_small_width','22'),('common','custom_icon_tiny_height','16'),('common','custom_icon_tiny_width','16'),('common','dbupdate_randtest_pooldef_migration_fix','2'),('common','dbupwarn_tos_migr_54x','1'),('common','dbupwarn_tstfixqstseq','1'),('common','dbup_tst_skl_thres_mig_done','1'),('common','db_hotfixes_5_3','18'),('common','db_update_running','0'),('common','db_version','5808'),('common','default_repository_view','flat'),('common','disable_bookmarks','0'),('common','disable_comments','0'),('common','disable_contacts','0'),('common','disable_contacts_require_mail','1'),('common','disable_learning_sequences','0'),('common','disable_my_memberships','0'),('common','disable_my_offers','0'),('common','disable_notes','0'),('common','disable_recommended_content','0'),('common','disable_study_programmes','0'),('common','dummy','dummy'),('common','enable_anonymous_fora',''),('common','enable_bench','0'),('common','enable_calendar','1'),('common','enable_cat_page_edit','1'),('common','enable_fora_statistics',''),('common','enable_js_edit','1'),('common','enable_registration','1'),('common','enable_sahs_pd','1'),('common','enable_tracking','0'),('common','enable_trash','1'),('common','error_recipient',''),('common','feedback_recipient',''),('common','forum_notification','1'),('common','hide_adv_search','0'),('common','hits_per_page','50'),('common','https','0'),('common','icon_position_in_lists','item_rows'),('common','ilchtrbacfix','1'),('common','ilchtrperms','1'),('common','ilfrmnoti1','1'),('common','ilfrmreadidx1','1'),('common','ilfrmthri2','1'),('common','ilGlobalTstPoolUsageSettingInitilisation','1'),('common','ilias_version','9.10.0'),('common','ilinc_akclassvalues_required','1'),('common','ilmpathix','1'),('common','iloscmsgidx1','1'),('common','iloscmsgidx2','1'),('common','iloscmsgidx3','1'),('common','ilpghi2','1'),('common','ilpgi3','1'),('common','ilrqtix','1'),('common','iltosobjinstall','1'),('common','inst_id','0'),('common','inst_info',''),('common','inst_institution',''),('common','inst_name',''),('common','java_path',''),('common','language','en'),('common','ldap_basedn',''),('common','ldap_port',''),('common','ldap_server',''),('common','letter_avatars','1'),('common','lm_qst_imap_migr_run','1'),('common','loginname_change_blocking_time','3600'),('common','lp_desktop','1'),('common','lp_extended_data',''),('common','lp_learner','1'),('common','lp_list_gui','0'),('common','lucene_default_operator','1'),('common','lucene_fragment_count','3'),('common','lucene_fragment_size','50'),('common','lucene_item_filter','a:0:{}'),('common','lucene_item_filter_enabled','0'),('common','lucene_last_index_time','1230807600'),('common','lucene_max_subitems','5'),('common','lucene_mime_filter','a:0:{}'),('common','lucene_mime_filter_enabled','0'),('common','lucene_offline_filter','0'),('common','lucene_prefix_wildcard',''),('common','lucene_show_relevance','1'),('common','lucene_sub_relevance',''),('common','lucene_user_search','1'),('common','mail_allow_external','1'),('common','mail_incoming_mail','0'),('common','mail_notification','1'),('common','mail_send_html','1'),('common','mail_subject_prefix','[ILIAS]'),('common','mail_system_sys_env_from_addr',''),('common','mail_system_sys_from_addr',''),('common','mail_system_sys_from_name',''),('common','mail_system_sys_reply_to_addr',''),('common','mail_system_sys_signature','\n\n* * * * *\n{{INSTALLATION_NAME}}\n{{INSTALLATION_DESC}}\n{{ILIAS_URL}}\n'),('common','mail_system_usr_env_from_addr',''),('common','mail_system_usr_from_addr',''),('common','mail_system_usr_from_name',''),('common','main_tree_impl','mp'),('common','new_registration_type','4'),('common','nic_key','d9f35b4eab4947c1557ce5a533c3f0cf'),('common','object_statistics','1'),('common','obj_add_new_pos_bibl','99990170'),('common','obj_add_new_pos_blog','99990130'),('common','obj_add_new_pos_book','99990220'),('common','obj_add_new_pos_cat','99990010'),('common','obj_add_new_pos_catr','99990020'),('common','obj_add_new_pos_chtr','99990120'),('common','obj_add_new_pos_cld','99990160'),('common','obj_add_new_pos_crs','99990040'),('common','obj_add_new_pos_crsr','99990050'),('common','obj_add_new_pos_dcl','99990210'),('common','obj_add_new_pos_exc','99990280'),('common','obj_add_new_pos_feed','99990140'),('common','obj_add_new_pos_file','99990150'),('common','obj_add_new_pos_fold','99990080'),('common','obj_add_new_pos_frm','99990110'),('common','obj_add_new_pos_glo','99990260'),('common','obj_add_new_pos_grp','99990060'),('common','obj_add_new_pos_grpr','99990070'),('common','obj_add_new_pos_grp_bibl','0'),('common','obj_add_new_pos_grp_blog','0'),('common','obj_add_new_pos_grp_book','0'),('common','obj_add_new_pos_grp_cat','0'),('common','obj_add_new_pos_grp_catr','0'),('common','obj_add_new_pos_grp_chtr','0'),('common','obj_add_new_pos_grp_cld','0'),('common','obj_add_new_pos_grp_crs','0'),('common','obj_add_new_pos_grp_crsr','0'),('common','obj_add_new_pos_grp_dcl','0'),('common','obj_add_new_pos_grp_exc','0'),('common','obj_add_new_pos_grp_feed','0'),('common','obj_add_new_pos_grp_file','0'),('common','obj_add_new_pos_grp_fold','0'),('common','obj_add_new_pos_grp_frm','0'),('common','obj_add_new_pos_grp_glo','0'),('common','obj_add_new_pos_grp_grp','0'),('common','obj_add_new_pos_grp_grpr','0'),('common','obj_add_new_pos_grp_htlm','0'),('common','obj_add_new_pos_grp_iass','0'),('common','obj_add_new_pos_grp_itgr','0'),('common','obj_add_new_pos_grp_lm','0'),('common','obj_add_new_pos_grp_mcst','0'),('common','obj_add_new_pos_grp_mep','0'),('common','obj_add_new_pos_grp_orgu','0'),('common','obj_add_new_pos_grp_poll','0'),('common','obj_add_new_pos_grp_prg','0'),('common','obj_add_new_pos_grp_prtt','0'),('common','obj_add_new_pos_grp_qpl','0'),('common','obj_add_new_pos_grp_sahs','0'),('common','obj_add_new_pos_grp_sess','0'),('common','obj_add_new_pos_grp_spl','0'),('common','obj_add_new_pos_grp_svy','0'),('common','obj_add_new_pos_grp_tst','0'),('common','obj_add_new_pos_grp_webr','0'),('common','obj_add_new_pos_grp_wiki','0'),('common','obj_add_new_pos_htlm','99990240'),('common','obj_add_new_pos_iass','99990300'),('common','obj_add_new_pos_itgr','99990090'),('common','obj_add_new_pos_lm','99990230'),('common','obj_add_new_pos_mcst','99990190'),('common','obj_add_new_pos_mep','99990330'),('common','obj_add_new_pos_orgu','99990360'),('common','obj_add_new_pos_poll','99990320'),('common','obj_add_new_pos_prg','99990030'),('common','obj_add_new_pos_prtt','99990270'),('common','obj_add_new_pos_qpl','99990340'),('common','obj_add_new_pos_sahs','99990250'),('common','obj_add_new_pos_sess','99990100'),('common','obj_add_new_pos_spl','99990350'),('common','obj_add_new_pos_svy','99990310'),('common','obj_add_new_pos_tst','99990290'),('common','obj_add_new_pos_webr','99990180'),('common','obj_add_new_pos_wiki','99990200'),('common','obj_dis_creation_bibl',''),('common','obj_dis_creation_blog',''),('common','obj_dis_creation_book',''),('common','obj_dis_creation_cat',''),('common','obj_dis_creation_catr',''),('common','obj_dis_creation_chtr',''),('common','obj_dis_creation_cld','1'),('common','obj_dis_creation_crs',''),('common','obj_dis_creation_crsr',''),('common','obj_dis_creation_dbk','1'),('common','obj_dis_creation_dcl',''),('common','obj_dis_creation_exc',''),('common','obj_dis_creation_feed',''),('common','obj_dis_creation_file',''),('common','obj_dis_creation_fold',''),('common','obj_dis_creation_frm',''),('common','obj_dis_creation_glo',''),('common','obj_dis_creation_grp',''),('common','obj_dis_creation_grpr',''),('common','obj_dis_creation_htlm',''),('common','obj_dis_creation_iass',''),('common','obj_dis_creation_itgr',''),('common','obj_dis_creation_lm',''),('common','obj_dis_creation_mcst',''),('common','obj_dis_creation_mep',''),('common','obj_dis_creation_orgu',''),('common','obj_dis_creation_poll',''),('common','obj_dis_creation_prg',''),('common','obj_dis_creation_prtt',''),('common','obj_dis_creation_qpl',''),('common','obj_dis_creation_sahs',''),('common','obj_dis_creation_sess',''),('common','obj_dis_creation_spl',''),('common','obj_dis_creation_svy',''),('common','obj_dis_creation_tst',''),('common','obj_dis_creation_webr',''),('common','obj_dis_creation_wiki',''),('common','password_assistance','1'),('common','pd_active_pres_view_0','a:2:{i:0;s:4:\"list\";i:1;s:4:\"tile\";}'),('common','pd_active_pres_view_1','a:2:{i:0;s:4:\"list\";i:1;s:4:\"tile\";}'),('common','pd_active_pres_view_2','a:2:{i:0;s:4:\"list\";i:1;s:4:\"tile\";}'),('common','pd_active_pres_view_3','a:2:{i:0;s:4:\"list\";i:1;s:4:\"tile\";}'),('common','pd_active_pres_view_4','a:2:{i:0;s:4:\"list\";i:1;s:4:\"tile\";}'),('common','pd_active_sort_view_0','a:2:{i:0;s:8:\"location\";i:1;s:4:\"type\";}'),('common','pd_active_sort_view_1','a:3:{i:0;s:8:\"location\";i:1;s:4:\"type\";i:2;s:10:\"start_date\";}'),('common','pd_active_sort_view_3','a:2:{i:0;s:8:\"location\";i:1;s:8:\"alphabet\";}'),('common','pd_active_sort_view_4','a:2:{i:0;s:8:\"location\";i:1;s:8:\"alphabet\";}'),('common','pd_def_pres_view_0','list'),('common','pd_def_pres_view_1','list'),('common','pd_def_pres_view_2','list'),('common','pd_def_pres_view_3','list'),('common','pd_def_pres_view_4','list'),('common','pd_def_sort_view_1','location'),('common','pd_def_sort_view_3','location'),('common','pd_def_sort_view_4','location'),('common','personal_items_default_view','0'),('common','preview_learner','1'),('common','proxy_host',''),('common','proxy_port',''),('common','proxy_status',''),('common','ps_access_times',''),('common','ps_account_security_mode','2'),('common','ps_crs_access_times',''),('common','ps_export_confirm',''),('common','ps_export_confirm_group',''),('common','ps_export_course',''),('common','ps_export_group',''),('common','ps_export_scorm','1'),('common','ps_login_max_attempts','0'),('common','ps_password_change_on_first_login_enabled','1'),('common','ps_password_chars_and_numbers_enabled',''),('common','ps_password_lowercase_chars_num','0'),('common','ps_password_max_age','0'),('common','ps_password_max_length','0'),('common','ps_password_min_length','6'),('common','ps_password_must_not_contain_loginame','1'),('common','ps_password_special_chars_enabled',''),('common','ps_password_uppercase_chars_num','0'),('common','ps_prevent_simultaneous_logins','0'),('common','ps_protect_admin','1'),('common','pub_section',''),('common','rbac_log','1'),('common','rbac_log_age','6'),('common','recovery_folder_id','15'),('common','reg_hash_life_time','600'),('common','rep_shorten_description','1'),('common','rep_shorten_description_length','128'),('common','rep_tree_limit_grp_crs',''),('common','rep_tree_synchronize','1'),('common','require_city',''),('common','require_country',''),('common','require_default_role','1'),('common','require_department',''),('common','require_email','1'),('common','require_fax',''),('common','require_firstname','1'),('common','require_gender','1'),('common','require_hobby',''),('common','require_institution',''),('common','require_lastname','1'),('common','require_login','1'),('common','require_passwd','1'),('common','require_passwd2','1'),('common','require_phone_home',''),('common','require_phone_mobile',''),('common','require_phone_office',''),('common','require_referral_comment',''),('common','require_street',''),('common','require_zipcode',''),('common','reuse_of_loginnames','1'),('common','rpc_server_host',''),('common','rpc_server_port','0'),('common','save_user_related_data','0'),('common','search_date_filter',''),('common','search_enabled_firstname','0'),('common','search_enabled_gender','0'),('common','search_enabled_hobby','0'),('common','search_enabled_institution','0'),('common','search_enabled_interests_general','0'),('common','search_enabled_interests_help_looking','0'),('common','search_enabled_interests_help_offered','0'),('common','search_enabled_lastname','0'),('common','search_enabled_matriculation','0'),('common','search_enabled_title','0'),('common','search_index','0'),('common','search_lucene','0'),('common','search_max_hits','10'),('common','search_show_inactiv_user','1'),('common','search_show_limited_user','1'),('common','session_allow_client_maintenance','1'),('common','session_handling_type','0'),('common','session_max_count','0'),('common','session_max_idle','30'),('common','session_max_idle_after_first_request','1'),('common','session_min_idle','15'),('common','session_reminder_enabled',''),('common','session_statistics','1'),('common','setup_ok','1'),('common','shib_federation_name','Shibboleth'),('common','shib_hos_type','external_wayf'),('common','shib_idp_list',''),('common','show_user_activity','1'),('common','soap_connect_timeout','10'),('common','soap_response_timeout','5'),('common','soap_user_administration','0'),('common','soap_wsdl_path',''),('common','sty_media_cont_mig','1'),('common','system_role_id','2'),('common','system_user_id','6'),('common','sys_advanced_editing_id','26'),('common','sys_assessment_folder_id','20'),('common','sys_user_tracking_id','17'),('common','tos_status','0'),('common','tracking_time_span','300'),('common','tst_score_rep_consts_cleaned','1'),('common','unzip_path',''),('common','user_activity_time','5'),('common','user_delete_own_account','0'),('common','user_delete_own_account_email',''),('common','user_portfolios','1'),('common','user_reactivate_code','0'),('common','usr_settings_changeable_lua_birthday','1'),('common','usr_settings_changeable_lua_bs_allow_to_contact_me','1'),('common','usr_settings_changeable_lua_city','1'),('common','usr_settings_changeable_lua_country','1'),('common','usr_settings_changeable_lua_delicious','0'),('common','usr_settings_changeable_lua_department','1'),('common','usr_settings_changeable_lua_email','1'),('common','usr_settings_changeable_lua_fax','1'),('common','usr_settings_changeable_lua_firstname','1'),('common','usr_settings_changeable_lua_gender','1'),('common','usr_settings_changeable_lua_hide_own_online_status','1'),('common','usr_settings_changeable_lua_hits_per_page','1'),('common','usr_settings_changeable_lua_hobby','0'),('common','usr_settings_changeable_lua_institution','1'),('common','usr_settings_changeable_lua_interests_general','1'),('common','usr_settings_changeable_lua_interests_help_looking','1'),('common','usr_settings_changeable_lua_interests_help_offered','1'),('common','usr_settings_changeable_lua_language','1'),('common','usr_settings_changeable_lua_lastname','1'),('common','usr_settings_changeable_lua_mail_incoming_mail','1'),('common','usr_settings_changeable_lua_matriculation','1'),('common','usr_settings_changeable_lua_password','1'),('common','usr_settings_changeable_lua_phone_home','1'),('common','usr_settings_changeable_lua_phone_mobile','1'),('common','usr_settings_changeable_lua_phone_office','1'),('common','usr_settings_changeable_lua_preferences','1'),('common','usr_settings_changeable_lua_referral_comment','0'),('common','usr_settings_changeable_lua_roles','1'),('common','usr_settings_changeable_lua_sel_country','0'),('common','usr_settings_changeable_lua_skin_style','1'),('common','usr_settings_changeable_lua_street','1'),('common','usr_settings_changeable_lua_title','1'),('common','usr_settings_changeable_lua_upload','1'),('common','usr_settings_changeable_lua_zipcode','1'),('common','usr_settings_disable_delicious','1'),('common','usr_settings_disable_hobby','1'),('common','usr_settings_disable_preferences','1'),('common','usr_settings_disable_referral_comment','1'),('common','usr_settings_disable_sel_country','1'),('common','usr_settings_hide_delicious','1'),('common','usr_settings_hide_hide_own_online_status','1'),('common','usr_settings_hide_hobby','1'),('common','usr_settings_hide_preferences','1'),('common','usr_settings_hide_sel_country','1'),('common','usr_settings_visib_lua_birthday','1'),('common','usr_settings_visib_lua_bs_allow_to_contact_me','1'),('common','usr_settings_visib_lua_city','1'),('common','usr_settings_visib_lua_country','1'),('common','usr_settings_visib_lua_delicious','0'),('common','usr_settings_visib_lua_department','1'),('common','usr_settings_visib_lua_email','1'),('common','usr_settings_visib_lua_fax','1'),('common','usr_settings_visib_lua_firstname','0'),('common','usr_settings_visib_lua_gender','1'),('common','usr_settings_visib_lua_hide_own_online_status','1'),('common','usr_settings_visib_lua_hits_per_page','1'),('common','usr_settings_visib_lua_hobby','0'),('common','usr_settings_visib_lua_instant_messengers','0'),('common','usr_settings_visib_lua_institution','1'),('common','usr_settings_visib_lua_interests_general','1'),('common','usr_settings_visib_lua_interests_help_looking','1'),('common','usr_settings_visib_lua_interests_help_offered','1'),('common','usr_settings_visib_lua_language','1'),('common','usr_settings_visib_lua_lastname','0'),('common','usr_settings_visib_lua_mail_incoming_mail','1'),('common','usr_settings_visib_lua_matriculation','1'),('common','usr_settings_visib_lua_password','0'),('common','usr_settings_visib_lua_phone_home','1'),('common','usr_settings_visib_lua_phone_mobile','1'),('common','usr_settings_visib_lua_phone_office','1'),('common','usr_settings_visib_lua_preferences','1'),('common','usr_settings_visib_lua_referral_comment','0'),('common','usr_settings_visib_lua_roles','1'),('common','usr_settings_visib_lua_sel_country','0'),('common','usr_settings_visib_lua_skin_style','1'),('common','usr_settings_visib_lua_street','1'),('common','usr_settings_visib_lua_title','1'),('common','usr_settings_visib_lua_upload','1'),('common','usr_settings_visib_lua_zipcode','1'),('common','usr_settings_visib_reg_birthday','1'),('common','usr_settings_visib_reg_bs_allow_to_contact_me','0'),('common','usr_settings_visib_reg_city','1'),('common','usr_settings_visib_reg_country','1'),('common','usr_settings_visib_reg_delicious','0'),('common','usr_settings_visib_reg_department','1'),('common','usr_settings_visib_reg_email','1'),('common','usr_settings_visib_reg_firstname','0'),('common','usr_settings_visib_reg_gender','1'),('common','usr_settings_visib_reg_hits_per_page','0'),('common','usr_settings_visib_reg_hobby','0'),('common','usr_settings_visib_reg_institution','1'),('common','usr_settings_visib_reg_interests_general','1'),('common','usr_settings_visib_reg_interests_help_looking','1'),('common','usr_settings_visib_reg_interests_help_offered','1'),('common','usr_settings_visib_reg_language','0'),('common','usr_settings_visib_reg_lastname','0'),('common','usr_settings_visib_reg_mail_incoming_mail','0'),('common','usr_settings_visib_reg_matriculation','1'),('common','usr_settings_visib_reg_password','0'),('common','usr_settings_visib_reg_phone_office','1'),('common','usr_settings_visib_reg_preferences','0'),('common','usr_settings_visib_reg_referral_comment','0'),('common','usr_settings_visib_reg_roles','0'),('common','usr_settings_visib_reg_sel_country','0'),('common','usr_settings_visib_reg_skin_style','0'),('common','usr_settings_visib_reg_street','1'),('common','usr_settings_visib_reg_title','1'),('common','usr_settings_visib_reg_upload','0'),('common','usr_settings_visib_reg_zipcode','1'),('common','usr_starting_point','1'),('common','zip_path',''),('file_access','inline_file_extensions','gif jpg jpeg mp3 pdf png'),('file_access','show_amount_of_downloads','1'),('fold','bgtask_download',''),('fold','enable_download_folder',''),('fold','enable_multi_download',''),('lm','cont_upload_dir',''),('lm','html_export_ids',''),('lm','page_history','1'),('lm','replace_mob_feature',''),('lm','scormdebug_disable_cache',''),('lm','scormdebug_global_activate',''),('lm','scorm_login_as_learner_id',''),('lm','scorm_lp_auto_activate','1'),('lm','scorm_without_session','1'),('lm','time_scheduled_page_activation','1'),('lucene_adv_search','lom_browser','0'),('lucene_adv_search','lom_content','0'),('lucene_adv_search','lom_context','0'),('lucene_adv_search','lom_contribute','0'),('lucene_adv_search','lom_copyright','0'),('lucene_adv_search','lom_costs','0'),('lucene_adv_search','lom_coverage','0'),('lucene_adv_search','lom_density','0'),('lucene_adv_search','lom_difficulty','0'),('lucene_adv_search','lom_format','0'),('lucene_adv_search','lom_interactivity','0'),('lucene_adv_search','lom_keyword','0'),('lucene_adv_search','lom_language','0'),('lucene_adv_search','lom_level','0'),('lucene_adv_search','lom_operating_system','0'),('lucene_adv_search','lom_purpose','0'),('lucene_adv_search','lom_resource','0'),('lucene_adv_search','lom_status','0'),('lucene_adv_search','lom_structure','0'),('lucene_adv_search','lom_taxon','0'),('lucene_adv_search','lom_user_role','0'),('lucene_adv_search','lom_version','0'),('MathJax','dummy','dummy'),('MathJax','enable',''),('MathJax','enable_server',''),('MathJax','limiter','0'),('MathJax','path_to_mathjax','https://cdn.jsdelivr.net/npm/mathjax@2.7.9/MathJax.js?config=TeX-AMS-MML_HTMLorMML,Safe'),('MathJax','path_to_polyfill',''),('MathJax','server_address',''),('MathJax','server_for_browser',''),('MathJax','server_for_export',''),('MathJax','server_for_pdf',''),('MathJax','server_timeout','5'),('mcst','video_threshold','80'),('mobs','black_list_file_types','text/html'),('mobs','file_manager_always',''),('mobs','mep_activate_pages','1'),('mobs','restricted_file_types',''),('mobs','upload_dir',''),('news','acc_cache_mins','10'),('notifications','enable_mail','1'),('notifications','enable_osd','1'),('notifications','osd_delay','500'),('notifications','osd_vanish','5000'),('pd','user_activity_time','0'),('preview','max_previews_per_object','5'),('preview','preview_enabled','1'),('prfa','banner','1'),('prfa','banner_height','100'),('prfa','banner_width','1370'),('prfa','mask','0'),('prfa','mycrs','1'),('prfa','pd_block','1'),('survey','unlimited_invitation','1'),('tags','enable','1'),('user_account','lua_access_restricted',''),('user_account','lua_enabled',''),('webdav','custom_webfolder_instructions',''),('webdav','custom_webfolder_instructions_enabled','0'),('webdav','webdav_enabled','0'),('wiki','copied_perm_edit_content_add_pages','1');

--
-- Table structure for table `settings_deactivated_s`
--

CREATE TABLE `settings_deactivated_s` (
  `skin` varchar(100) NOT NULL DEFAULT ' ',
  `style` varchar(100) NOT NULL DEFAULT ' ',
  PRIMARY KEY (`skin`,`style`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings_deactivated_s`
--


--
-- Table structure for table `shib_role_assignment`
--

CREATE TABLE `shib_role_assignment` (
  `rule_id` int(11) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  `name` char(255) DEFAULT NULL,
  `value` char(255) DEFAULT NULL,
  `plugin` tinyint(4) NOT NULL DEFAULT '0',
  `plugin_id` int(11) NOT NULL DEFAULT '0',
  `add_on_update` tinyint(4) NOT NULL DEFAULT '0',
  `remove_on_update` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shib_role_assignment`
--


--
-- Table structure for table `shib_role_assignment_seq`
--

CREATE TABLE `shib_role_assignment_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shib_role_assignment_seq`
--


--
-- Table structure for table `skl_assigned_material`
--

CREATE TABLE `skl_assigned_material` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `top_skill_id` int(11) NOT NULL DEFAULT '0',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `level_id` int(11) NOT NULL DEFAULT '0',
  `wsp_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`top_skill_id`,`tref_id`,`skill_id`,`level_id`,`wsp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_assigned_material`
--


--
-- Table structure for table `skl_level`
--

CREATE TABLE `skl_level` (
  `id` int(11) NOT NULL DEFAULT '0',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `nr` smallint(6) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `description` longtext,
  `trigger_ref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_id` int(11) NOT NULL DEFAULT '0',
  `creation_date` datetime DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_level`
--


--
-- Table structure for table `skl_level_seq`
--

CREATE TABLE `skl_level_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_level_seq`
--


--
-- Table structure for table `skl_personal_skill`
--

CREATE TABLE `skl_personal_skill` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `skill_node_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`skill_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_personal_skill`
--


--
-- Table structure for table `skl_profile`
--

CREATE TABLE `skl_profile` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `skill_tree_id` int(11) NOT NULL DEFAULT '0',
  `image_id` varchar(4000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile`
--


--
-- Table structure for table `skl_profile_completion`
--

CREATE TABLE `skl_profile_completion` (
  `profile_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `fulfilled` tinyint(4) NOT NULL,
  PRIMARY KEY (`profile_id`,`user_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile_completion`
--


--
-- Table structure for table `skl_profile_level`
--

CREATE TABLE `skl_profile_level` (
  `profile_id` int(11) NOT NULL DEFAULT '0',
  `base_skill_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `level_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`tref_id`,`base_skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile_level`
--


--
-- Table structure for table `skl_profile_role`
--

CREATE TABLE `skl_profile_role` (
  `profile_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`profile_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile_role`
--


--
-- Table structure for table `skl_profile_seq`
--

CREATE TABLE `skl_profile_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile_seq`
--


--
-- Table structure for table `skl_profile_user`
--

CREATE TABLE `skl_profile_user` (
  `profile_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_profile_user`
--


--
-- Table structure for table `skl_skill_resource`
--

CREATE TABLE `skl_skill_resource` (
  `base_skill_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `level_id` int(11) NOT NULL DEFAULT '0',
  `rep_ref_id` int(11) NOT NULL DEFAULT '0',
  `imparting` tinyint(4) NOT NULL DEFAULT '0',
  `ltrigger` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`base_skill_id`,`tref_id`,`level_id`,`rep_ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_skill_resource`
--


--
-- Table structure for table `skl_templ_ref`
--

CREATE TABLE `skl_templ_ref` (
  `skl_node_id` int(11) NOT NULL DEFAULT '0',
  `templ_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`skl_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_templ_ref`
--


--
-- Table structure for table `skl_tree`
--

CREATE TABLE `skl_tree` (
  `skl_tree_id` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`skl_tree_id`,`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_tree`
--

INSERT INTO `skl_tree` VALUES (312,1,0,1,2,1);

--
-- Table structure for table `skl_tree_node`
--

CREATE TABLE `skl_tree_node` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `type` char(4) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `self_eval` tinyint(4) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `creation_date` datetime DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_tree_node`
--

INSERT INTO `skl_tree_node` VALUES (1,'Skill Tree Root Node','skrt','2011-08-07 11:39:00',NULL,0,0,0,NULL,'',NULL);

--
-- Table structure for table `skl_tree_node_seq`
--

CREATE TABLE `skl_tree_node_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_tree_node_seq`
--

INSERT INTO `skl_tree_node_seq` VALUES (1);

--
-- Table structure for table `skl_usage`
--

CREATE TABLE `skl_usage` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`skill_id`,`tref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_usage`
--


--
-- Table structure for table `skl_user_has_level`
--

CREATE TABLE `skl_user_has_level` (
  `level_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `status_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `trigger_ref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_id` int(11) NOT NULL DEFAULT '0',
  `trigger_title` varchar(200) DEFAULT NULL,
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_type` varchar(4) DEFAULT 'crs',
  `self_eval` tinyint(4) NOT NULL DEFAULT '0',
  `next_level_fulfilment` double NOT NULL DEFAULT '0',
  `trigger_user_id` varchar(20) NOT NULL DEFAULT '-',
  PRIMARY KEY (`level_id`,`user_id`,`trigger_obj_id`,`tref_id`,`self_eval`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_user_has_level`
--


--
-- Table structure for table `skl_user_skill_level`
--

CREATE TABLE `skl_user_skill_level` (
  `level_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `status_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `valid` tinyint(4) NOT NULL DEFAULT '0',
  `trigger_ref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_id` int(11) NOT NULL DEFAULT '0',
  `trigger_title` varchar(200) DEFAULT NULL,
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_type` varchar(4) DEFAULT 'crs',
  `self_eval` tinyint(4) NOT NULL DEFAULT '0',
  `unique_identifier` varchar(80) DEFAULT NULL,
  `next_level_fulfilment` double NOT NULL DEFAULT '0',
  `trigger_user_id` varchar(20) NOT NULL DEFAULT '-',
  PRIMARY KEY (`skill_id`,`tref_id`,`user_id`,`status_date`,`status`,`trigger_obj_id`,`self_eval`),
  KEY `isk_idx` (`skill_id`),
  KEY `ilv_idx` (`level_id`),
  KEY `ius_idx` (`user_id`),
  KEY `isd_idx` (`status_date`),
  KEY `ist_idx` (`status`),
  KEY `ivl_idx` (`valid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `skl_user_skill_level`
--


--
-- Table structure for table `sty_media_query`
--

CREATE TABLE `sty_media_query` (
  `id` int(11) NOT NULL DEFAULT '0',
  `style_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `mquery` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sty_media_query`
--


--
-- Table structure for table `sty_media_query_seq`
--

CREATE TABLE `sty_media_query_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sty_media_query_seq`
--


--
-- Table structure for table `sty_rep_container`
--

CREATE TABLE `sty_rep_container` (
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `reuse` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sty_rep_container`
--


--
-- Table structure for table `style_char`
--

CREATE TABLE `style_char` (
  `style_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(30) NOT NULL DEFAULT ' ',
  `characteristic` varchar(30) NOT NULL DEFAULT ' ',
  `hide` tinyint(4) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `outdated` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`style_id`,`type`,`characteristic`),
  KEY `i1_idx` (`style_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_char`
--


--
-- Table structure for table `style_char_title`
--

CREATE TABLE `style_char_title` (
  `type` varchar(30) NOT NULL,
  `characteristic` varchar(30) NOT NULL,
  `lang` varchar(2) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `style_id` int(11) NOT NULL,
  PRIMARY KEY (`style_id`,`type`,`characteristic`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_char_title`
--


--
-- Table structure for table `style_color`
--

CREATE TABLE `style_color` (
  `style_id` int(11) NOT NULL DEFAULT '0',
  `color_name` varchar(30) NOT NULL DEFAULT '.',
  `color_code` char(10) DEFAULT NULL,
  PRIMARY KEY (`style_id`,`color_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_color`
--


--
-- Table structure for table `style_data`
--

CREATE TABLE `style_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `uptodate` tinyint(4) DEFAULT '0',
  `standard` tinyint(4) DEFAULT '0',
  `category` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `owner_obj` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_data`
--


--
-- Table structure for table `style_folder_styles`
--

CREATE TABLE `style_folder_styles` (
  `folder_id` int(11) NOT NULL DEFAULT '0',
  `style_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`folder_id`,`style_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_folder_styles`
--


--
-- Table structure for table `style_parameter`
--

CREATE TABLE `style_parameter` (
  `id` int(11) NOT NULL DEFAULT '0',
  `style_id` int(11) NOT NULL DEFAULT '0',
  `tag` varchar(100) DEFAULT NULL,
  `class` varchar(100) DEFAULT NULL,
  `parameter` varchar(100) DEFAULT NULL,
  `value` varchar(200) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `mq_id` int(11) NOT NULL DEFAULT '0',
  `custom` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`style_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_parameter`
--


--
-- Table structure for table `style_parameter_seq`
--

CREATE TABLE `style_parameter_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_parameter_seq`
--


--
-- Table structure for table `style_setting`
--

CREATE TABLE `style_setting` (
  `style_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(30) NOT NULL DEFAULT '',
  `value` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`style_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_setting`
--


--
-- Table structure for table `style_template`
--

CREATE TABLE `style_template` (
  `id` int(11) NOT NULL DEFAULT '0',
  `style_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(30) NOT NULL DEFAULT '',
  `preview` varchar(4000) DEFAULT NULL,
  `temp_type` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`style_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_template`
--


--
-- Table structure for table `style_template_class`
--

CREATE TABLE `style_template_class` (
  `template_id` int(11) NOT NULL DEFAULT '0',
  `class_type` char(30) NOT NULL DEFAULT '',
  `class` char(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`template_id`,`class_type`,`class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_template_class`
--


--
-- Table structure for table `style_template_seq`
--

CREATE TABLE `style_template_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_template_seq`
--


--
-- Table structure for table `style_usage`
--

CREATE TABLE `style_usage` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `style_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`style_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `style_usage`
--


--
-- Table structure for table `svy_360_appr`
--

CREATE TABLE `svy_360_appr` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `has_closed` int(11) DEFAULT '0',
  PRIMARY KEY (`obj_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_360_appr`
--


--
-- Table structure for table `svy_360_rater`
--

CREATE TABLE `svy_360_rater` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `appr_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `anonymous_id` int(11) NOT NULL DEFAULT '0',
  `mail_sent` int(11) DEFAULT '0',
  PRIMARY KEY (`obj_id`,`appr_id`,`user_id`,`anonymous_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_360_rater`
--


--
-- Table structure for table `svy_anonymous`
--

CREATE TABLE `svy_anonymous` (
  `anonymous_id` int(11) NOT NULL DEFAULT '0',
  `survey_key` varchar(32) DEFAULT NULL,
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `user_key` varchar(40) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `externaldata` varchar(4000) DEFAULT NULL,
  `sent` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`anonymous_id`),
  KEY `i1_idx` (`survey_key`,`survey_fi`),
  KEY `i2_idx` (`survey_fi`),
  KEY `i3_idx` (`sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_anonymous`
--


--
-- Table structure for table `svy_anonymous_seq`
--

CREATE TABLE `svy_anonymous_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_anonymous_seq`
--


--
-- Table structure for table `svy_answer`
--

CREATE TABLE `svy_answer` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `value` double DEFAULT NULL,
  `textanswer` text,
  `rowvalue` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`active_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_answer`
--


--
-- Table structure for table `svy_answer_seq`
--

CREATE TABLE `svy_answer_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_answer_seq`
--


--
-- Table structure for table `svy_category`
--

CREATE TABLE `svy_category` (
  `category_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(1000) DEFAULT NULL,
  `defaultvalue` varchar(1) DEFAULT '0',
  `owner_fi` int(11) NOT NULL DEFAULT '0',
  `neutral` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`),
  KEY `i1_idx` (`owner_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_category`
--

INSERT INTO `svy_category` VALUES (1,'dc_desired','1',0,'0',1085190181),(2,'dc_undesired','1',0,'0',1085190181),(3,'dc_agree','1',0,'0',1085190181),(4,'dc_disagree','1',0,'0',1085190181),(5,'dc_good','1',0,'0',1085190181),(6,'dc_notacceptable','1',0,'0',1085190181),(7,'dc_should','1',0,'0',1085190181),(8,'dc_shouldnot','1',0,'0',1085190181),(9,'dc_true','1',0,'0',1085190181),(10,'dc_false','1',0,'0',1085190181),(11,'dc_always','1',0,'0',1085190181),(12,'dc_never','1',0,'0',1085190181),(13,'dc_yes','1',0,'0',1085190181),(14,'dc_no','1',0,'0',1085190181),(15,'dc_neutral','1',0,'0',1085190181),(16,'dc_undecided','1',0,'0',1085190181),(17,'dc_fair','1',0,'0',1085190181),(18,'dc_sometimes','1',0,'0',1085190181),(19,'dc_stronglydesired','1',0,'0',1085190181),(20,'dc_stronglyundesired','1',0,'0',1085190181),(21,'dc_stronglyagree','1',0,'0',1085190181),(22,'dc_stronglydisagree','1',0,'0',1085190181),(23,'dc_verygood','1',0,'0',1085190181),(24,'dc_poor','1',0,'0',1085190181),(25,'dc_must','1',0,'0',1085190181),(26,'dc_mustnot','1',0,'0',1085190181),(27,'dc_definitelytrue','1',0,'0',1085190181),(28,'dc_definitelyfalse','1',0,'0',1085190181),(29,'dc_manytimes','1',0,'0',1085190181),(30,'dc_varying','1',0,'0',1085190181),(31,'dc_rarely','1',0,'0',1085190181),(32,'dc_mostcertainly','1',0,'0',1085190181),(33,'dc_morepositive','1',0,'0',1085190181),(34,'dc_morenegative','1',0,'0',1085190181),(35,'dc_mostcertainlynot','1',0,'0',1085190181);

--
-- Table structure for table `svy_category_seq`
--

CREATE TABLE `svy_category_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_category_seq`
--

INSERT INTO `svy_category_seq` VALUES (35);

--
-- Table structure for table `svy_constraint`
--

CREATE TABLE `svy_constraint` (
  `constraint_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `relation_fi` int(11) NOT NULL DEFAULT '0',
  `value` double NOT NULL DEFAULT '0',
  `conjunction` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`constraint_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`relation_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_constraint`
--


--
-- Table structure for table `svy_constraint_seq`
--

CREATE TABLE `svy_constraint_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_constraint_seq`
--


--
-- Table structure for table `svy_finished`
--

CREATE TABLE `svy_finished` (
  `finished_id` int(11) NOT NULL DEFAULT '0',
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `user_fi` int(11) NOT NULL DEFAULT '0',
  `anonymous_id` varchar(32) DEFAULT NULL,
  `state` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `lastpage` int(11) NOT NULL DEFAULT '0',
  `appr_id` int(11) DEFAULT '0',
  PRIMARY KEY (`finished_id`),
  KEY `i1_idx` (`survey_fi`),
  KEY `i2_idx` (`user_fi`),
  KEY `i3_idx` (`anonymous_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_finished`
--


--
-- Table structure for table `svy_finished_seq`
--

CREATE TABLE `svy_finished_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_finished_seq`
--


--
-- Table structure for table `svy_invitation`
--

CREATE TABLE `svy_invitation` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `survey_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`survey_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_invitation`
--


--
-- Table structure for table `svy_material`
--

CREATE TABLE `svy_material` (
  `material_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `internal_link` varchar(50) DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  `material_title` varchar(255) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `text_material` varchar(4000) DEFAULT NULL,
  `external_link` varchar(500) DEFAULT NULL,
  `file_material` varchar(200) DEFAULT NULL,
  `material_type` int(11) DEFAULT '0',
  PRIMARY KEY (`material_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_material`
--


--
-- Table structure for table `svy_material_seq`
--

CREATE TABLE `svy_material_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_material_seq`
--


--
-- Table structure for table `svy_phrase`
--

CREATE TABLE `svy_phrase` (
  `phrase_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `defaultvalue` varchar(1) DEFAULT '0',
  `owner_fi` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`phrase_id`),
  KEY `i1_idx` (`owner_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_phrase`
--

INSERT INTO `svy_phrase` VALUES (1,'dp_standard_attitude_desired_undesired','1',0,1085190871),(2,'dp_standard_attitude_agree_disagree','1',0,1085190898),(3,'dp_standard_attitude_good_notacceptable','1',0,1085190918),(4,'dp_standard_attitude_shold_shouldnot','1',0,1085190946),(5,'dp_standard_beliefs_true_false','1',0,1085190973),(6,'dp_standard_beliefs_always_never','1',0,1085191547),(7,'dp_standard_behaviour_yes_no','1',0,1085191547),(8,'dp_standard_attitude_desired_neutral_undesired','1',0,1085191547),(9,'dp_standard_attitude_agree_undecided_disagree','1',0,1085191547),(10,'dp_standard_attitude_good_fair_notacceptable','1',0,1085191547),(11,'dp_standard_attitude_should_undecided_shouldnot','1',0,1085191547),(12,'dp_standard_beliefs_true_undecided_false','1',0,1085191547),(13,'dp_standard_beliefs_always_sometimes_never','1',0,1085191547),(14,'dp_standard_behaviour_yes_undecided_no','1',0,1085191547),(15,'dp_standard_attitude_desired5','1',0,1085195222),(16,'dp_standard_attitude_agree5','1',0,1085195237),(17,'dp_standard_attitude_good5','1',0,1085195249),(18,'dp_standard_attitude_must5','1',0,1085195264),(19,'dp_standard_beliefs_true5','1',0,1085195274),(20,'dp_standard_beliefs_always5','1',0,1085195292),(21,'dp_standard_behaviour_certainly5','1',0,1085195308),(22,'dp_standard_numbers','1',0,1087738039);

--
-- Table structure for table `svy_phrase_cat`
--

CREATE TABLE `svy_phrase_cat` (
  `phrase_category_id` int(11) NOT NULL DEFAULT '0',
  `phrase_fi` int(11) NOT NULL DEFAULT '0',
  `category_fi` int(11) NOT NULL DEFAULT '0',
  `sequence` int(11) NOT NULL DEFAULT '0',
  `other` smallint(6) NOT NULL DEFAULT '0',
  `scale` int(11) DEFAULT NULL,
  PRIMARY KEY (`phrase_category_id`),
  KEY `i1_idx` (`phrase_fi`),
  KEY `i2_idx` (`category_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_phrase_cat`
--

INSERT INTO `svy_phrase_cat` VALUES (1,1,1,1,0,0),(2,1,2,2,0,0),(3,2,3,1,0,0),(4,2,4,2,0,0),(5,3,5,1,0,0),(6,3,6,2,0,0),(7,4,7,1,0,0),(8,4,8,2,0,0),(9,5,9,1,0,0),(10,5,10,2,0,0),(11,6,11,1,0,0),(12,6,12,2,0,0),(13,7,13,1,0,0),(14,7,14,2,0,0),(15,8,1,1,0,0),(16,8,15,2,0,0),(17,8,2,3,0,0),(18,9,3,1,0,0),(19,9,16,2,0,0),(20,9,4,3,0,0),(21,10,5,1,0,0),(22,10,17,2,0,0),(23,10,6,3,0,0),(24,11,7,1,0,0),(25,11,16,2,0,0),(26,11,8,3,0,0),(27,12,9,1,0,0),(28,12,16,2,0,0),(29,12,10,3,0,0),(30,13,11,1,0,0),(31,13,18,2,0,0),(32,13,12,3,0,0),(33,14,13,1,0,0),(34,14,16,2,0,0),(35,14,14,3,0,0),(36,15,19,1,0,0),(37,15,1,2,0,0),(38,15,15,3,0,0),(39,15,2,4,0,0),(40,15,20,5,0,0),(41,16,21,1,0,0),(42,16,3,2,0,0),(43,16,16,3,0,0),(44,16,4,4,0,0),(45,16,22,5,0,0),(46,17,23,1,0,0),(47,17,5,2,0,0),(48,17,17,3,0,0),(49,17,24,4,0,0),(50,17,6,5,0,0),(51,18,25,1,0,0),(52,18,7,2,0,0),(53,18,16,3,0,0),(54,18,8,4,0,0),(55,18,26,5,0,0),(56,19,27,1,0,0),(57,19,9,2,0,0),(58,19,16,3,0,0),(59,19,10,4,0,0),(60,19,28,5,0,0),(61,20,11,1,0,0),(62,20,29,2,0,0),(63,20,30,3,0,0),(64,20,31,4,0,0),(65,20,12,5,0,0),(66,21,32,1,0,0),(67,21,33,2,0,0),(68,21,16,3,0,0),(69,21,34,4,0,0),(70,21,35,5,0,0);

--
-- Table structure for table `svy_phrase_cat_seq`
--

CREATE TABLE `svy_phrase_cat_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_phrase_cat_seq`
--

INSERT INTO `svy_phrase_cat_seq` VALUES (70);

--
-- Table structure for table `svy_phrase_seq`
--

CREATE TABLE `svy_phrase_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_phrase_seq`
--

INSERT INTO `svy_phrase_seq` VALUES (22);

--
-- Table structure for table `svy_qblk`
--

CREATE TABLE `svy_qblk` (
  `questionblock_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(4000) DEFAULT NULL,
  `show_questiontext` varchar(1) DEFAULT '1',
  `owner_fi` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `show_blocktitle` varchar(1) DEFAULT NULL,
  `compress_view` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`questionblock_id`),
  KEY `i1_idx` (`owner_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qblk`
--


--
-- Table structure for table `svy_qblk_qst`
--

CREATE TABLE `svy_qblk_qst` (
  `qblk_qst_id` int(11) NOT NULL DEFAULT '0',
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `questionblock_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`qblk_qst_id`),
  KEY `i1_idx` (`survey_fi`),
  KEY `i2_idx` (`questionblock_fi`),
  KEY `i3_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qblk_qst`
--


--
-- Table structure for table `svy_qblk_qst_seq`
--

CREATE TABLE `svy_qblk_qst_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qblk_qst_seq`
--


--
-- Table structure for table `svy_qblk_seq`
--

CREATE TABLE `svy_qblk_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qblk_seq`
--


--
-- Table structure for table `svy_qpl`
--

CREATE TABLE `svy_qpl` (
  `id_questionpool` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `isonline` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_questionpool`),
  KEY `i1_idx` (`obj_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qpl`
--


--
-- Table structure for table `svy_qpl_seq`
--

CREATE TABLE `svy_qpl_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qpl_seq`
--


--
-- Table structure for table `svy_qst_constraint`
--

CREATE TABLE `svy_qst_constraint` (
  `question_constraint_id` int(11) NOT NULL DEFAULT '0',
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `constraint_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_constraint_id`),
  KEY `i1_idx` (`survey_fi`),
  KEY `i2_idx` (`question_fi`),
  KEY `i3_idx` (`constraint_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_constraint`
--


--
-- Table structure for table `svy_qst_constraint_seq`
--

CREATE TABLE `svy_qst_constraint_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_constraint_seq`
--


--
-- Table structure for table `svy_qst_matrix`
--

CREATE TABLE `svy_qst_matrix` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `subtype` int(11) NOT NULL DEFAULT '0',
  `column_separators` varchar(1) DEFAULT '0',
  `row_separators` varchar(1) DEFAULT '0',
  `neutral_column_separator` varchar(1) DEFAULT '1',
  `column_placeholders` int(11) NOT NULL DEFAULT '0',
  `legend` varchar(1) DEFAULT '0',
  `singleline_row_caption` varchar(1) DEFAULT '0',
  `repeat_column_header` varchar(1) DEFAULT '0',
  `column_header_position` varchar(1) DEFAULT '0',
  `random_rows` varchar(1) DEFAULT '0',
  `column_order` varchar(1) DEFAULT '0',
  `column_images` varchar(1) DEFAULT '0',
  `row_images` varchar(1) DEFAULT '0',
  `bipolar_adjective1` varchar(255) DEFAULT NULL,
  `bipolar_adjective2` varchar(255) DEFAULT NULL,
  `layout` varchar(4000) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_matrix`
--


--
-- Table structure for table `svy_qst_matrixrows`
--

CREATE TABLE `svy_qst_matrixrows` (
  `id_svy_qst_matrixrows` int(11) NOT NULL DEFAULT '0',
  `title` varchar(1000) DEFAULT NULL,
  `sequence` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `other` tinyint(4) NOT NULL DEFAULT '0',
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_svy_qst_matrixrows`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_matrixrows`
--


--
-- Table structure for table `svy_qst_matrixrows_seq`
--

CREATE TABLE `svy_qst_matrixrows_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_matrixrows_seq`
--


--
-- Table structure for table `svy_qst_mc`
--

CREATE TABLE `svy_qst_mc` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `orientation` varchar(1) DEFAULT '0',
  `use_min_answers` tinyint(4) NOT NULL DEFAULT '0',
  `nr_min_answers` smallint(6) DEFAULT NULL,
  `nr_max_answers` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_mc`
--


--
-- Table structure for table `svy_qst_metric`
--

CREATE TABLE `svy_qst_metric` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `subtype` varchar(1) DEFAULT '3',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_metric`
--


--
-- Table structure for table `svy_qst_oblig`
--

CREATE TABLE `svy_qst_oblig` (
  `question_obligatory_id` int(11) NOT NULL DEFAULT '0',
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `obligatory` varchar(1) DEFAULT '1',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_obligatory_id`),
  KEY `i1_idx` (`survey_fi`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_oblig`
--


--
-- Table structure for table `svy_qst_oblig_seq`
--

CREATE TABLE `svy_qst_oblig_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_oblig_seq`
--


--
-- Table structure for table `svy_qst_sc`
--

CREATE TABLE `svy_qst_sc` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `orientation` varchar(1) DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_sc`
--


--
-- Table structure for table `svy_qst_text`
--

CREATE TABLE `svy_qst_text` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `maxchars` int(11) DEFAULT NULL,
  `width` int(11) NOT NULL DEFAULT '50',
  `height` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qst_text`
--


--
-- Table structure for table `svy_qtype`
--

CREATE TABLE `svy_qtype` (
  `questiontype_id` int(11) NOT NULL DEFAULT '0',
  `type_tag` varchar(30) DEFAULT NULL,
  `plugin` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`questiontype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qtype`
--

INSERT INTO `svy_qtype` VALUES (1,'SurveyMultipleChoiceQuestion',0),(2,'SurveySingleChoiceQuestion',0),(3,'SurveyMetricQuestion',0),(4,'SurveyTextQuestion',0),(5,'SurveyMatrixQuestion',0);

--
-- Table structure for table `svy_qtype_seq`
--

CREATE TABLE `svy_qtype_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_qtype_seq`
--

INSERT INTO `svy_qtype_seq` VALUES (5);

--
-- Table structure for table `svy_quest_skill`
--

CREATE TABLE `svy_quest_skill` (
  `q_id` int(11) NOT NULL DEFAULT '0',
  `survey_id` int(11) NOT NULL DEFAULT '0',
  `base_skill_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`q_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_quest_skill`
--


--
-- Table structure for table `svy_question`
--

CREATE TABLE `svy_question` (
  `question_id` int(11) NOT NULL DEFAULT '0',
  `questiontype_fi` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `owner_fi` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `obligatory` varchar(1) DEFAULT '1',
  `complete` varchar(1) DEFAULT '0',
  `created` varchar(14) DEFAULT NULL,
  `original_id` int(11) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `questiontext` longtext,
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`question_id`),
  KEY `i1_idx` (`obj_fi`),
  KEY `i2_idx` (`owner_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_question`
--


--
-- Table structure for table `svy_question_seq`
--

CREATE TABLE `svy_question_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_question_seq`
--


--
-- Table structure for table `svy_relation`
--

CREATE TABLE `svy_relation` (
  `relation_id` int(11) NOT NULL DEFAULT '0',
  `longname` varchar(20) DEFAULT NULL,
  `shortname` varchar(2) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`relation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_relation`
--

INSERT INTO `svy_relation` VALUES (1,'less','<',1084867073),(2,'less_or_equal','<=',1084867088),(3,'equal','=',1084867096),(4,'not_equal','<>',1084867119),(5,'more_or_equal','>=',1084867132),(6,'more','>',1084867143);

--
-- Table structure for table `svy_relation_seq`
--

CREATE TABLE `svy_relation_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_relation_seq`
--

INSERT INTO `svy_relation_seq` VALUES (6);

--
-- Table structure for table `svy_settings`
--

CREATE TABLE `svy_settings` (
  `settings_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `keyword` varchar(40) NOT NULL DEFAULT '',
  `title` varchar(400) DEFAULT NULL,
  `value` longtext,
  PRIMARY KEY (`settings_id`),
  KEY `i1_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_settings`
--


--
-- Table structure for table `svy_settings_seq`
--

CREATE TABLE `svy_settings_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_settings_seq`
--


--
-- Table structure for table `svy_skill_threshold`
--

CREATE TABLE `svy_skill_threshold` (
  `survey_id` int(11) NOT NULL DEFAULT '0',
  `base_skill_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `level_id` int(11) NOT NULL DEFAULT '0',
  `threshold` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`survey_id`,`base_skill_id`,`tref_id`,`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_skill_threshold`
--


--
-- Table structure for table `svy_svy`
--

CREATE TABLE `svy_svy` (
  `survey_id` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `author` varchar(50) DEFAULT NULL,
  `introduction` longtext,
  `outro` longtext,
  `status` varchar(1) DEFAULT '1',
  `evaluation_access` varchar(1) DEFAULT '0',
  `invitation` varchar(1) DEFAULT '0',
  `invitation_mode` varchar(1) DEFAULT '1',
  `complete` varchar(1) DEFAULT '0',
  `anonymize` varchar(1) DEFAULT '0',
  `show_question_titles` varchar(1) DEFAULT '1',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `mailnotification` tinyint(4) DEFAULT NULL,
  `startdate` varchar(14) DEFAULT NULL,
  `enddate` varchar(14) DEFAULT NULL,
  `mailaddresses` varchar(2000) DEFAULT NULL,
  `mailparticipantdata` varchar(4000) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `pool_usage` tinyint(4) DEFAULT NULL,
  `mode` tinyint(4) NOT NULL DEFAULT '0',
  `mode_360_self_eval` tinyint(4) NOT NULL DEFAULT '0',
  `mode_360_self_rate` tinyint(4) NOT NULL DEFAULT '0',
  `mode_360_self_appr` tinyint(4) NOT NULL DEFAULT '0',
  `mode_360_results` tinyint(4) NOT NULL DEFAULT '0',
  `mode_skill_service` tinyint(4) NOT NULL DEFAULT '0',
  `reminder_status` tinyint(4) NOT NULL DEFAULT '0',
  `reminder_start` datetime DEFAULT NULL,
  `reminder_end` datetime DEFAULT NULL,
  `reminder_frequency` smallint(6) NOT NULL DEFAULT '0',
  `reminder_target` tinyint(4) NOT NULL DEFAULT '0',
  `tutor_ntf_status` tinyint(4) NOT NULL DEFAULT '0',
  `tutor_ntf_reci` varchar(2000) DEFAULT NULL,
  `tutor_ntf_target` tinyint(4) NOT NULL DEFAULT '0',
  `reminder_last_sent` datetime DEFAULT NULL,
  `own_results_view` tinyint(4) DEFAULT '0',
  `own_results_mail` tinyint(4) DEFAULT '0',
  `confirmation_mail` tinyint(4) DEFAULT NULL,
  `anon_user_list` tinyint(4) DEFAULT '0',
  `reminder_tmpl` int(11) DEFAULT NULL,
  `mode_self_eval_results` tinyint(4) DEFAULT '0',
  `tutor_res_status` tinyint(4) DEFAULT NULL,
  `tutor_res_reci` varchar(2000) DEFAULT NULL,
  `tutor_res_cron` tinyint(4) DEFAULT NULL,
  `calculate_sum_score` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`survey_id`),
  KEY `i1_idx` (`obj_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_svy`
--


--
-- Table structure for table `svy_svy_qst`
--

CREATE TABLE `svy_svy_qst` (
  `survey_question_id` int(11) NOT NULL DEFAULT '0',
  `survey_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `sequence` int(11) NOT NULL DEFAULT '0',
  `heading` varchar(4000) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`survey_question_id`),
  KEY `i1_idx` (`survey_fi`),
  KEY `i2_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_svy_qst`
--


--
-- Table structure for table `svy_svy_qst_seq`
--

CREATE TABLE `svy_svy_qst_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_svy_qst_seq`
--


--
-- Table structure for table `svy_svy_seq`
--

CREATE TABLE `svy_svy_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_svy_seq`
--


--
-- Table structure for table `svy_times`
--

CREATE TABLE `svy_times` (
  `id` int(11) NOT NULL DEFAULT '0',
  `finished_fi` int(11) NOT NULL DEFAULT '0',
  `entered_page` int(11) DEFAULT NULL,
  `left_page` int(11) DEFAULT NULL,
  `first_question` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`finished_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_times`
--


--
-- Table structure for table `svy_times_seq`
--

CREATE TABLE `svy_times_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_times_seq`
--


--
-- Table structure for table `svy_variable`
--

CREATE TABLE `svy_variable` (
  `variable_id` int(11) NOT NULL DEFAULT '0',
  `category_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `value1` double DEFAULT NULL,
  `value2` double DEFAULT NULL,
  `sequence` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `other` smallint(6) NOT NULL DEFAULT '0',
  `scale` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`variable_id`),
  KEY `i1_idx` (`category_fi`),
  KEY `i2_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_variable`
--


--
-- Table structure for table `svy_variable_seq`
--

CREATE TABLE `svy_variable_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `svy_variable_seq`
--


--
-- Table structure for table `sysc_groups`
--

CREATE TABLE `sysc_groups` (
  `id` int(11) NOT NULL DEFAULT '0',
  `component` char(16) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sysc_groups`
--

INSERT INTO `sysc_groups` VALUES (1,'tree',NULL,0);

--
-- Table structure for table `sysc_groups_seq`
--

CREATE TABLE `sysc_groups_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sysc_groups_seq`
--

INSERT INTO `sysc_groups_seq` VALUES (1);

--
-- Table structure for table `sysc_tasks`
--

CREATE TABLE `sysc_tasks` (
  `id` int(11) NOT NULL DEFAULT '0',
  `grp_id` int(11) NOT NULL DEFAULT '0',
  `last_update` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `identifier` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sysc_tasks`
--

INSERT INTO `sysc_tasks` VALUES (1,1,NULL,0,'dump'),(2,1,NULL,0,'structure'),(3,1,NULL,0,'missing_tree'),(4,1,NULL,0,'missing_reference'),(5,1,NULL,0,'duplicates');

--
-- Table structure for table `sysc_tasks_seq`
--

CREATE TABLE `sysc_tasks_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sysc_tasks_seq`
--

INSERT INTO `sysc_tasks_seq` VALUES (5);

--
-- Table structure for table `syst_style_cat`
--

CREATE TABLE `syst_style_cat` (
  `skin_id` varchar(50) NOT NULL DEFAULT '',
  `style_id` varchar(50) NOT NULL DEFAULT '',
  `substyle` varchar(50) NOT NULL DEFAULT '',
  `category_ref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`skin_id`,`style_id`,`substyle`,`category_ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `syst_style_cat`
--


--
-- Table structure for table `table_properties`
--

CREATE TABLE `table_properties` (
  `table_id` varchar(30) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `property` varchar(20) NOT NULL DEFAULT '',
  `value` varchar(4000) NOT NULL DEFAULT ' ',
  PRIMARY KEY (`table_id`,`user_id`,`property`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `table_properties`
--


--
-- Table structure for table `table_templates`
--

CREATE TABLE `table_templates` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `context` varchar(128) NOT NULL DEFAULT '',
  `value` longtext,
  PRIMARY KEY (`name`,`user_id`,`context`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `table_templates`
--


--
-- Table structure for table `tax_data`
--

CREATE TABLE `tax_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `sorting_mode` int(11) NOT NULL DEFAULT '0',
  `item_sorting` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_data`
--


--
-- Table structure for table `tax_node`
--

CREATE TABLE `tax_node` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `type` char(4) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_node`
--

INSERT INTO `tax_node` VALUES (1,'Dummy top node for all tax trees.','','2012-09-04 14:25:23','2012-09-04 14:25:23',0,0);

--
-- Table structure for table `tax_node_assignment`
--

CREATE TABLE `tax_node_assignment` (
  `node_id` int(11) NOT NULL DEFAULT '0',
  `component` varchar(10) NOT NULL DEFAULT '',
  `item_type` varchar(20) NOT NULL DEFAULT '',
  `item_id` int(11) NOT NULL DEFAULT '0',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`node_id`,`component`,`obj_id`,`item_type`,`item_id`),
  KEY `i1_idx` (`component`,`item_type`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_node_assignment`
--


--
-- Table structure for table `tax_node_seq`
--

CREATE TABLE `tax_node_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_node_seq`
--

INSERT INTO `tax_node_seq` VALUES (1);

--
-- Table structure for table `tax_tree`
--

CREATE TABLE `tax_tree` (
  `tax_tree_id` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tax_tree_id`,`child`),
  KEY `i1_idx` (`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_tree`
--


--
-- Table structure for table `tax_usage`
--

CREATE TABLE `tax_usage` (
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tax_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_usage`
--


--
-- Table structure for table `tree`
--

CREATE TABLE `tree` (
  `tree` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  `path` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`child`),
  KEY `i2_idx` (`parent`),
  KEY `i3_idx` (`tree`),
  KEY `i4_idx` (`path`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tree`
--

INSERT INTO `tree` VALUES (1,1,0,1,344,1,'1'),(1,7,9,5,6,3,'1.9.7'),(1,8,9,7,8,3,'1.9.8'),(1,9,1,2,343,2,'1.9'),(1,10,9,9,10,3,'1.9.10'),(1,11,9,11,12,3,'1.9.11'),(1,12,9,3,4,3,'1.9.12'),(1,14,9,13,18,3,'1.9.14'),(1,15,9,19,20,3,'1.9.15'),(1,16,9,21,22,3,'1.9.16'),(1,17,9,23,24,3,'1.9.17'),(1,18,9,25,26,3,'1.9.18'),(1,20,9,29,30,3,'1.9.20'),(1,21,9,31,32,3,'1.9.21'),(1,22,9,33,34,3,'1.9.22'),(1,23,9,35,36,3,'1.9.23'),(1,26,9,37,38,3,'1.9.26'),(1,27,9,39,40,3,'1.9.27'),(1,28,9,41,42,3,'1.9.28'),(1,29,9,43,44,3,'1.9.29'),(1,30,9,45,46,3,'1.9.30'),(1,31,9,47,48,3,'1.9.31'),(1,32,9,49,50,3,'1.9.32'),(1,33,9,51,52,3,'1.9.33'),(1,34,9,53,54,3,'1.9.34'),(1,35,9,55,56,3,'1.9.35'),(1,36,9,57,58,3,'1.9.36'),(1,37,9,59,60,3,'1.9.37'),(1,38,9,61,62,3,'1.9.38'),(1,39,9,63,64,3,'1.9.39'),(1,40,9,65,66,3,'1.9.40'),(1,41,9,67,68,3,'1.9.41'),(1,42,9,69,70,3,'1.9.42'),(1,43,9,71,72,3,'1.9.43'),(1,44,9,73,278,3,'1.9.44'),(1,45,9,279,280,3,'1.9.45'),(1,46,44,74,177,4,'1.9.44.46'),(1,47,46,75,76,5,'1.9.44.46.47'),(1,48,9,281,282,3,'1.9.48'),(1,49,9,283,284,3,'1.9.49'),(1,50,9,285,286,3,'1.9.50'),(1,51,9,287,288,3,'1.9.51'),(1,52,9,289,290,3,'1.9.52'),(1,53,9,291,292,3,'1.9.53'),(1,54,9,293,294,3,'1.9.54'),(1,55,9,295,296,3,'1.9.55'),(1,56,9,297,298,3,'1.9.56'),(1,57,9,299,300,3,'1.9.57'),(1,58,9,301,302,3,'1.9.58'),(1,59,9,303,304,3,'1.9.59'),(1,60,9,305,306,3,'1.9.60'),(1,61,9,307,308,3,'1.9.61'),(1,62,9,309,310,3,'1.9.62'),(1,63,9,311,312,3,'1.9.63'),(1,64,9,313,314,3,'1.9.64'),(1,65,9,315,316,3,'1.9.65'),(1,67,9,0,0,3,'1.9.67'),(1,68,9,0,0,3,'1.9.68'),(1,69,9,0,0,3,'1.9.69'),(1,70,9,0,0,3,'1.9.70'),(1,71,9,0,0,3,'1.9.71'),(1,72,9,0,0,3,'1.9.72'),(1,73,9,0,0,3,'1.9.73'),(1,74,9,0,0,3,'1.9.74'),(1,75,9,0,0,3,'1.9.75'),(1,76,9,0,0,3,'1.9.76'),(1,77,9,0,0,3,'1.9.77'),(1,78,9,0,0,3,'1.9.78'),(1,79,9,0,0,3,'1.9.79'),(1,80,9,0,0,3,'1.9.80'),(1,81,9,0,0,3,'1.9.81'),(1,82,9,0,0,3,'1.9.82'),(1,83,9,0,0,3,'1.9.83'),(1,84,41,0,0,4,'1.9.41.84');

--
-- Table structure for table `tree_workspace`
--

CREATE TABLE `tree_workspace` (
  `tree` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`child`),
  KEY `i2_idx` (`parent`),
  KEY `i3_idx` (`tree`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tree_workspace`
--

INSERT INTO `tree_workspace` VALUES (13,1,0,1,2,1);

--
-- Table structure for table `tst_active`
--

CREATE TABLE `tst_active` (
  `active_id` int(11) NOT NULL DEFAULT '0',
  `user_fi` int(11) NOT NULL DEFAULT '0',
  `anonymous_id` varchar(5) DEFAULT NULL,
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `tries` int(11) NOT NULL DEFAULT '0',
  `submitted` tinyint(4) NOT NULL DEFAULT '0',
  `submittimestamp` datetime DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `importname` varchar(400) DEFAULT NULL,
  `taxfilter` varchar(1024) DEFAULT NULL,
  `lastindex` int(11) NOT NULL DEFAULT '0',
  `last_finished_pass` int(11) DEFAULT NULL,
  `answerstatusfilter` varchar(16) DEFAULT NULL,
  `objective_container` int(11) DEFAULT NULL,
  `start_lock` varchar(128) DEFAULT NULL,
  `last_pmode` varchar(16) DEFAULT NULL,
  `last_started_pass` int(11) DEFAULT NULL,
  PRIMARY KEY (`active_id`),
  UNIQUE KEY `uc1_idx` (`user_fi`,`test_fi`,`anonymous_id`),
  KEY `i1_idx` (`user_fi`),
  KEY `i2_idx` (`test_fi`),
  KEY `i3_idx` (`anonymous_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_active`
--


--
-- Table structure for table `tst_active_seq`
--

CREATE TABLE `tst_active_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_active_seq`
--


--
-- Table structure for table `tst_addtime`
--

CREATE TABLE `tst_addtime` (
  `active_fi` bigint(20) NOT NULL DEFAULT '0',
  `additionaltime` bigint(20) NOT NULL DEFAULT '0',
  `tstamp` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_addtime`
--


--
-- Table structure for table `tst_invited_user`
--

CREATE TABLE `tst_invited_user` (
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `user_fi` int(11) NOT NULL DEFAULT '0',
  `clientip` varchar(255) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_fi`,`user_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_invited_user`
--


--
-- Table structure for table `tst_manual_fb`
--

CREATE TABLE `tst_manual_fb` (
  `manual_feedback_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `feedback` longtext,
  `finalized_tstamp` bigint(20) DEFAULT NULL,
  `finalized_evaluation` tinyint(4) DEFAULT NULL,
  `finalized_by_usr_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`manual_feedback_id`),
  KEY `i1_idx` (`active_fi`),
  KEY `i2_idx` (`question_fi`),
  KEY `i3_idx` (`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_manual_fb`
--


--
-- Table structure for table `tst_manual_fb_seq`
--

CREATE TABLE `tst_manual_fb_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_manual_fb_seq`
--


--
-- Table structure for table `tst_mark`
--

CREATE TABLE `tst_mark` (
  `mark_id` int(11) NOT NULL DEFAULT '0',
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `short_name` varchar(15) DEFAULT NULL,
  `official_name` varchar(50) DEFAULT NULL,
  `minimum_level` double NOT NULL DEFAULT '0',
  `passed` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mark_id`),
  KEY `i1_idx` (`test_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_mark`
--


--
-- Table structure for table `tst_mark_seq`
--

CREATE TABLE `tst_mark_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_mark_seq`
--


--
-- Table structure for table `tst_pass_result`
--

CREATE TABLE `tst_pass_result` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `points` double NOT NULL DEFAULT '0',
  `maxpoints` double NOT NULL DEFAULT '0',
  `questioncount` int(11) NOT NULL DEFAULT '0',
  `answeredquestions` int(11) NOT NULL DEFAULT '0',
  `workingtime` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `hint_count` int(11) DEFAULT '0',
  `hint_points` double DEFAULT '0',
  `obligations_answered` tinyint(4) NOT NULL DEFAULT '1',
  `exam_id` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`active_fi`,`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_pass_result`
--


--
-- Table structure for table `tst_qst_solved`
--

CREATE TABLE `tst_qst_solved` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `solved` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_qst_solved`
--


--
-- Table structure for table `tst_qst_var_presented`
--

CREATE TABLE `tst_qst_var_presented` (
  `question_id` bigint(20) NOT NULL,
  `active_id` bigint(20) NOT NULL,
  `pass` bigint(20) NOT NULL,
  `variable` varchar(32) NOT NULL,
  `value` varchar(64) NOT NULL,
  PRIMARY KEY (`question_id`,`active_id`,`pass`,`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_qst_var_presented`
--


--
-- Table structure for table `tst_result_cache`
--

CREATE TABLE `tst_result_cache` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `max_points` double NOT NULL DEFAULT '0',
  `reached_points` double NOT NULL DEFAULT '0',
  `mark_short` varchar(256) NOT NULL DEFAULT '',
  `mark_official` varchar(256) NOT NULL DEFAULT '',
  `passed` int(11) NOT NULL DEFAULT '0',
  `failed` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `hint_count` int(11) DEFAULT '0',
  `hint_points` double DEFAULT '0',
  `obligations_answered` tinyint(4) NOT NULL DEFAULT '1',
  `passed_once` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`active_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_result_cache`
--


--
-- Table structure for table `tst_rnd_cpy`
--

CREATE TABLE `tst_rnd_cpy` (
  `copy_id` int(11) NOT NULL DEFAULT '0',
  `tst_fi` int(11) NOT NULL DEFAULT '0',
  `qst_fi` int(11) NOT NULL DEFAULT '0',
  `qpl_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`copy_id`),
  KEY `i1_idx` (`qst_fi`),
  KEY `i2_idx` (`qpl_fi`),
  KEY `i3_idx` (`tst_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_cpy`
--


--
-- Table structure for table `tst_rnd_cpy_seq`
--

CREATE TABLE `tst_rnd_cpy_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_cpy_seq`
--


--
-- Table structure for table `tst_rnd_qpl_title`
--

CREATE TABLE `tst_rnd_qpl_title` (
  `title_id` int(11) NOT NULL DEFAULT '0',
  `qpl_fi` int(11) NOT NULL DEFAULT '0',
  `tst_fi` int(11) NOT NULL DEFAULT '0',
  `qpl_title` varchar(1000) NOT NULL DEFAULT '',
  PRIMARY KEY (`title_id`),
  KEY `i1_idx` (`qpl_fi`),
  KEY `i2_idx` (`tst_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_qpl_title`
--


--
-- Table structure for table `tst_rnd_qpl_title_seq`
--

CREATE TABLE `tst_rnd_qpl_title_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_qpl_title_seq`
--


--
-- Table structure for table `tst_rnd_quest_set_cfg`
--

CREATE TABLE `tst_rnd_quest_set_cfg` (
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `req_pools_homo_scored` tinyint(4) NOT NULL DEFAULT '0',
  `quest_amount_cfg_mode` varchar(16) DEFAULT NULL,
  `quest_amount_per_test` int(11) DEFAULT NULL,
  `quest_sync_timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_quest_set_cfg`
--


--
-- Table structure for table `tst_rnd_quest_set_qpls`
--

CREATE TABLE `tst_rnd_quest_set_qpls` (
  `def_id` int(11) NOT NULL DEFAULT '0',
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `pool_fi` int(11) NOT NULL DEFAULT '0',
  `pool_title` varchar(255) DEFAULT NULL,
  `pool_path` varchar(512) DEFAULT NULL,
  `pool_quest_count` int(11) DEFAULT NULL,
  `origin_tax_fi` int(11) DEFAULT NULL,
  `origin_node_fi` int(11) DEFAULT NULL,
  `mapped_tax_fi` int(11) DEFAULT NULL,
  `mapped_node_fi` int(11) DEFAULT NULL,
  `quest_amount` int(11) DEFAULT NULL,
  `sequence_pos` int(11) DEFAULT NULL,
  `origin_tax_filter` varchar(4000) DEFAULT NULL,
  `mapped_tax_filter` varchar(4000) DEFAULT NULL,
  `type_filter` varchar(250) DEFAULT NULL,
  `lifecycle_filter` varchar(250) DEFAULT NULL,
  `pool_ref_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`def_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_quest_set_qpls`
--


--
-- Table structure for table `tst_rnd_quest_set_qpls_seq`
--

CREATE TABLE `tst_rnd_quest_set_qpls_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_rnd_quest_set_qpls_seq`
--


--
-- Table structure for table `tst_seq_qst_checked`
--

CREATE TABLE `tst_seq_qst_checked` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`,`pass`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_seq_qst_checked`
--


--
-- Table structure for table `tst_seq_qst_optional`
--

CREATE TABLE `tst_seq_qst_optional` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`,`pass`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_seq_qst_optional`
--


--
-- Table structure for table `tst_seq_qst_presented`
--

CREATE TABLE `tst_seq_qst_presented` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`,`pass`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_seq_qst_presented`
--


--
-- Table structure for table `tst_sequence`
--

CREATE TABLE `tst_sequence` (
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `sequence` longtext,
  `postponed` varchar(4000) DEFAULT NULL,
  `hidden` varchar(4000) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `ans_opt_confirmed` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_fi`,`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_sequence`
--


--
-- Table structure for table `tst_skl_thresholds`
--

CREATE TABLE `tst_skl_thresholds` (
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `skill_base_fi` int(11) NOT NULL DEFAULT '0',
  `skill_tref_fi` int(11) NOT NULL DEFAULT '0',
  `skill_level_fi` int(11) NOT NULL DEFAULT '0',
  `threshold` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_fi`,`skill_base_fi`,`skill_tref_fi`,`skill_level_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_skl_thresholds`
--


--
-- Table structure for table `tst_solutions`
--

CREATE TABLE `tst_solutions` (
  `solution_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `points` double DEFAULT NULL,
  `pass` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `value1` longtext,
  `value2` longtext,
  `step` int(11) DEFAULT NULL,
  `authorized` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`solution_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`active_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_solutions`
--


--
-- Table structure for table `tst_solutions_seq`
--

CREATE TABLE `tst_solutions_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_solutions_seq`
--


--
-- Table structure for table `tst_test_defaults`
--

CREATE TABLE `tst_test_defaults` (
  `test_defaults_id` int(11) NOT NULL DEFAULT '0',
  `user_fi` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `marks` longtext,
  `defaults` longtext,
  PRIMARY KEY (`test_defaults_id`),
  KEY `i1_idx` (`user_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_defaults`
--


--
-- Table structure for table `tst_test_defaults_seq`
--

CREATE TABLE `tst_test_defaults_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_defaults_seq`
--


--
-- Table structure for table `tst_test_question`
--

CREATE TABLE `tst_test_question` (
  `test_question_id` int(11) NOT NULL DEFAULT '0',
  `test_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `sequence` smallint(6) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `obligatory` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_question_id`),
  KEY `i1_idx` (`test_fi`),
  KEY `i2_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_question`
--


--
-- Table structure for table `tst_test_question_seq`
--

CREATE TABLE `tst_test_question_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_question_seq`
--


--
-- Table structure for table `tst_test_result`
--

CREATE TABLE `tst_test_result` (
  `test_result_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `points` double NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `manual` tinyint(4) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `hint_count` int(11) DEFAULT '0',
  `hint_points` double DEFAULT '0',
  `answered` tinyint(4) NOT NULL DEFAULT '1',
  `step` int(11) DEFAULT NULL,
  PRIMARY KEY (`test_result_id`),
  KEY `i1_idx` (`active_fi`),
  KEY `i2_idx` (`question_fi`),
  KEY `i3_idx` (`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_result`
--


--
-- Table structure for table `tst_test_result_seq`
--

CREATE TABLE `tst_test_result_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_result_seq`
--


--
-- Table structure for table `tst_test_rnd_qst`
--

CREATE TABLE `tst_test_rnd_qst` (
  `test_random_question_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `sequence` smallint(6) NOT NULL DEFAULT '0',
  `pass` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `src_pool_def_fi` int(11) DEFAULT NULL,
  PRIMARY KEY (`test_random_question_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`active_fi`),
  KEY `i3_idx` (`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_rnd_qst`
--


--
-- Table structure for table `tst_test_rnd_qst_seq`
--

CREATE TABLE `tst_test_rnd_qst_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_test_rnd_qst_seq`
--


--
-- Table structure for table `tst_tests`
--

CREATE TABLE `tst_tests` (
  `test_id` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `author` varchar(50) DEFAULT NULL,
  `introduction` varchar(4000) DEFAULT NULL,
  `sequence_settings` tinyint(4) NOT NULL DEFAULT '0',
  `score_reporting` tinyint(4) NOT NULL DEFAULT '0',
  `instant_verification` varchar(1) DEFAULT '0',
  `answer_feedback` varchar(1) DEFAULT '0',
  `answer_feedback_points` varchar(1) DEFAULT '0',
  `fixed_participants` varchar(1) DEFAULT '0',
  `suspend_test_allowed` varchar(1) DEFAULT '0',
  `anonymity` varchar(1) DEFAULT '0',
  `nr_of_tries` smallint(6) NOT NULL DEFAULT '0',
  `use_previous_answers` varchar(1) DEFAULT '0',
  `title_output` varchar(1) DEFAULT '0',
  `processing_time` varchar(8) DEFAULT NULL,
  `enable_processing_time` varchar(1) DEFAULT '0',
  `reset_processing_time` tinyint(4) NOT NULL DEFAULT '0',
  `reporting_date` varchar(14) DEFAULT NULL,
  `shuffle_questions` varchar(1) DEFAULT '0',
  `ects_output` varchar(1) DEFAULT '0',
  `ects_fx` double DEFAULT NULL,
  `complete` varchar(1) DEFAULT '1',
  `ects_a` double NOT NULL DEFAULT '90',
  `ects_b` double NOT NULL DEFAULT '65',
  `ects_c` double NOT NULL DEFAULT '35',
  `ects_d` double NOT NULL DEFAULT '10',
  `ects_e` double NOT NULL DEFAULT '0',
  `keep_questions` tinyint(4) NOT NULL DEFAULT '0',
  `count_system` varchar(1) DEFAULT '0',
  `mc_scoring` varchar(1) DEFAULT '0',
  `score_cutting` varchar(1) DEFAULT '0',
  `pass_scoring` varchar(1) DEFAULT '0',
  `password` varchar(20) DEFAULT NULL,
  `results_presentation` int(11) NOT NULL DEFAULT '3',
  `usr_pass_overview_mode` int(11) NOT NULL DEFAULT '0',
  `show_question_titles` varchar(1) DEFAULT '1',
  `certificate_visibility` varchar(1) DEFAULT '0',
  `show_marker` tinyint(4) NOT NULL DEFAULT '0',
  `kiosk` int(11) NOT NULL DEFAULT '0',
  `resultoutput` int(11) NOT NULL DEFAULT '0',
  `finalstatement` varchar(4000) DEFAULT NULL,
  `showfinalstatement` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `mailnotification` tinyint(4) DEFAULT '0',
  `mailnottype` smallint(6) NOT NULL DEFAULT '0',
  `exportsettings` int(11) NOT NULL DEFAULT '0',
  `template_id` int(11) DEFAULT NULL,
  `pool_usage` tinyint(4) DEFAULT NULL,
  `online_status` tinyint(4) NOT NULL DEFAULT '0',
  `print_bs_with_res` tinyint(4) NOT NULL DEFAULT '1',
  `offer_question_hints` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_enabled` int(11) DEFAULT '0',
  `highscore_anon` int(11) DEFAULT '0',
  `highscore_achieved_ts` int(11) DEFAULT '0',
  `highscore_score` int(11) DEFAULT '0',
  `highscore_percentage` int(11) DEFAULT '0',
  `highscore_hints` int(11) DEFAULT '0',
  `highscore_wtime` int(11) DEFAULT '0',
  `highscore_own_table` int(11) DEFAULT '0',
  `highscore_top_table` int(11) DEFAULT '0',
  `highscore_top_num` int(11) DEFAULT '0',
  `specific_feedback` int(11) DEFAULT '0',
  `obligations_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `autosave` tinyint(4) NOT NULL DEFAULT '0',
  `autosave_ival` int(11) NOT NULL DEFAULT '0',
  `pass_deletion_allowed` int(11) NOT NULL DEFAULT '0',
  `redirection_mode` int(11) NOT NULL DEFAULT '0',
  `redirection_url` varchar(4000) DEFAULT NULL,
  `examid_in_test_pass` int(11) NOT NULL DEFAULT '0',
  `examid_in_test_res` int(11) NOT NULL DEFAULT '0',
  `enable_examview` tinyint(4) DEFAULT NULL,
  `question_set_type` varchar(32) NOT NULL DEFAULT 'FIXED_QUEST_SET',
  `skill_service` tinyint(4) DEFAULT NULL,
  `show_grading_status` tinyint(4) DEFAULT '0',
  `show_grading_mark` tinyint(4) DEFAULT '0',
  `inst_fb_answer_fixation` tinyint(4) DEFAULT NULL,
  `intro_enabled` tinyint(4) DEFAULT NULL,
  `starting_time_enabled` tinyint(4) DEFAULT NULL,
  `ending_time_enabled` tinyint(4) DEFAULT NULL,
  `password_enabled` tinyint(4) DEFAULT NULL,
  `broken` tinyint(4) DEFAULT NULL,
  `force_inst_fb` tinyint(4) DEFAULT '0',
  `starting_time` int(11) NOT NULL DEFAULT '0',
  `ending_time` int(11) NOT NULL DEFAULT '0',
  `pass_waiting` varchar(15) DEFAULT NULL,
  `follow_qst_answer_fixation` tinyint(4) DEFAULT '0',
  `block_after_passed` tinyint(4) DEFAULT '0',
  `info_screen` tinyint(4) DEFAULT NULL,
  `introduction_page_id` bigint(20) DEFAULT NULL,
  `concluding_remarks_page_id` bigint(20) DEFAULT NULL,
  `show_questionlist` tinyint(4) DEFAULT NULL,
  `hide_info_tab` tinyint(4) NOT NULL DEFAULT '0',
  `conditions_checkbox_enabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_id`),
  KEY `i1_idx` (`obj_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_tests`
--


--
-- Table structure for table `tst_tests_seq`
--

CREATE TABLE `tst_tests_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_tests_seq`
--


--
-- Table structure for table `tst_times`
--

CREATE TABLE `tst_times` (
  `times_id` int(11) NOT NULL DEFAULT '0',
  `active_fi` int(11) NOT NULL DEFAULT '0',
  `started` datetime DEFAULT NULL,
  `finished` datetime DEFAULT NULL,
  `pass` smallint(6) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`times_id`),
  KEY `i1_idx` (`active_fi`),
  KEY `i2_idx` (`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_times`
--


--
-- Table structure for table `tst_times_seq`
--

CREATE TABLE `tst_times_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tst_times_seq`
--


--
-- Table structure for table `udf_clob`
--

CREATE TABLE `udf_clob` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` longtext,
  PRIMARY KEY (`usr_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `udf_clob`
--


--
-- Table structure for table `udf_data`
--

CREATE TABLE `udf_data` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `udf_data`
--

INSERT INTO `udf_data` VALUES (6),(13);

--
-- Table structure for table `udf_definition`
--

CREATE TABLE `udf_definition` (
  `field_id` int(11) NOT NULL DEFAULT '0',
  `field_name` char(255) DEFAULT NULL,
  `field_type` tinyint(4) NOT NULL DEFAULT '0',
  `field_values` longtext,
  `visible` tinyint(4) NOT NULL DEFAULT '0',
  `changeable` tinyint(4) NOT NULL DEFAULT '0',
  `required` tinyint(4) NOT NULL DEFAULT '0',
  `searchable` tinyint(4) NOT NULL DEFAULT '0',
  `export` tinyint(4) NOT NULL DEFAULT '0',
  `course_export` tinyint(4) NOT NULL DEFAULT '0',
  `registration_visible` tinyint(4) DEFAULT '0',
  `visible_lua` tinyint(4) NOT NULL DEFAULT '0',
  `changeable_lua` tinyint(4) NOT NULL DEFAULT '0',
  `group_export` tinyint(4) DEFAULT '0',
  `certificate` tinyint(4) NOT NULL DEFAULT '0',
  `prg_export` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `udf_definition`
--


--
-- Table structure for table `udf_definition_seq`
--

CREATE TABLE `udf_definition_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `udf_definition_seq`
--


--
-- Table structure for table `udf_text`
--

CREATE TABLE `udf_text` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`usr_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `udf_text`
--


--
-- Table structure for table `user_action_activation`
--

CREATE TABLE `user_action_activation` (
  `context_comp` varchar(30) NOT NULL DEFAULT '',
  `context_id` varchar(30) NOT NULL DEFAULT '',
  `action_comp` varchar(30) NOT NULL DEFAULT '',
  `action_type` varchar(30) NOT NULL DEFAULT '',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`context_comp`,`context_id`,`action_comp`,`action_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_action_activation`
--

INSERT INTO `user_action_activation` VALUES ('awrn','toplist','chtr','invite',1),('awrn','toplist','chtr','invite_osd',1),('awrn','toplist','contact','handle_req',1),('awrn','toplist','mail','compose',1),('awrn','toplist','pwsp','shared_res',1),('awrn','toplist','user','profile',1);

--
-- Table structure for table `usr_account_codes`
--

CREATE TABLE `usr_account_codes` (
  `code_id` int(11) NOT NULL DEFAULT '0',
  `code` varchar(50) DEFAULT NULL,
  `valid_until` varchar(10) DEFAULT NULL,
  `generated` int(11) DEFAULT '0',
  `used` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`code_id`),
  KEY `i1_idx` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_account_codes`
--


--
-- Table structure for table `usr_account_codes_seq`
--

CREATE TABLE `usr_account_codes_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_account_codes_seq`
--


--
-- Table structure for table `usr_change_email_token`
--

CREATE TABLE `usr_change_email_token` (
  `token` varchar(32) NOT NULL,
  `new_email` varchar(256) DEFAULT NULL,
  `valid_until` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_change_email_token`
--


--
-- Table structure for table `usr_cron_mail_reminder`
--

CREATE TABLE `usr_cron_mail_reminder` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_cron_mail_reminder`
--


--
-- Table structure for table `usr_data`
--

CREATE TABLE `usr_data` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `login` varchar(190) DEFAULT NULL,
  `passwd` varchar(100) DEFAULT NULL,
  `firstname` varchar(128) DEFAULT NULL,
  `lastname` varchar(128) DEFAULT NULL,
  `title` varchar(32) DEFAULT NULL,
  `gender` char(1) DEFAULT 'm',
  `email` varchar(128) DEFAULT NULL,
  `institution` varchar(80) DEFAULT NULL,
  `street` varchar(512) DEFAULT NULL,
  `city` varchar(40) DEFAULT NULL,
  `zipcode` varchar(10) DEFAULT NULL,
  `country` varchar(40) DEFAULT NULL,
  `phone_office` varchar(40) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `hobby` varchar(4000) DEFAULT NULL,
  `department` varchar(80) DEFAULT NULL,
  `phone_home` varchar(40) DEFAULT NULL,
  `phone_mobile` varchar(40) DEFAULT NULL,
  `fax` varchar(40) DEFAULT NULL,
  `time_limit_owner` int(11) DEFAULT '0',
  `time_limit_unlimited` int(11) DEFAULT '0',
  `time_limit_from` bigint(20) DEFAULT '0',
  `time_limit_until` bigint(20) DEFAULT '0',
  `time_limit_message` int(11) DEFAULT '0',
  `referral_comment` varchar(250) DEFAULT NULL,
  `matriculation` varchar(40) DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT '0',
  `approve_date` datetime DEFAULT NULL,
  `agree_date` datetime DEFAULT NULL,
  `client_ip` varchar(255) DEFAULT NULL,
  `auth_mode` char(10) DEFAULT 'default',
  `profile_incomplete` int(11) DEFAULT '0',
  `ext_account` varchar(250) DEFAULT NULL,
  `feed_hash` varchar(32) DEFAULT NULL,
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `loc_zoom` int(11) NOT NULL DEFAULT '0',
  `login_attempts` tinyint(4) NOT NULL DEFAULT '0',
  `last_password_change` int(11) NOT NULL DEFAULT '0',
  `reg_hash` char(32) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `sel_country` varchar(2) DEFAULT NULL,
  `last_visited` longtext,
  `inactivation_date` datetime DEFAULT NULL,
  `is_self_registered` tinyint(4) NOT NULL DEFAULT '0',
  `passwd_enc_type` varchar(10) DEFAULT NULL,
  `passwd_salt` varchar(32) DEFAULT NULL,
  `second_email` varchar(80) DEFAULT NULL,
  `first_login` datetime DEFAULT NULL,
  `last_profile_prompt` datetime DEFAULT NULL,
  `passwd_policy_reset` tinyint(4) NOT NULL DEFAULT '0',
  `rid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`usr_id`),
  UNIQUE KEY `uc1_idx` (`login`),
  KEY `i1_idx` (`login`,`passwd`),
  KEY `i2_idx` (`ext_account`,`auth_mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_data`
--

INSERT INTO `usr_data` VALUES (6,'root','[[admin_pass]]','[[admin_fname]]','[[admin_lname]]','','m','[[admin_email]]','','','','','','','2016-12-21 13:55:17','2016-12-14 14:44:49',NULL,'','','','','',7,1,1450795200,1450795200,0,'','',1,NULL,NULL,'','local',0,NULL,'',NULL,NULL,0,0,1481723089,'',NULL,'','',NULL,0,'bcryptphp',NULL,NULL,'2016-12-21 13:55:17',NULL,0,'-'),(13,'anonymous','294de3557d9d00b3d2d8a1e6aab028cf','anonymous','anonymous','','m','nomail','','','','','','','2003-08-15 11:03:36','2003-08-15 10:07:30','2003-08-15 10:07:30','','','','','',7,1,0,0,0,'','',1,NULL,NULL,'','local',0,'','','','',0,0,1217068076,'',NULL,'','',NULL,0,'md5','',NULL,'2003-08-15 11:03:36',NULL,0,'-');

--
-- Table structure for table `usr_data_multi`
--

CREATE TABLE `usr_data_multi` (
  `id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `field_id` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_data_multi`
--


--
-- Table structure for table `usr_data_multi_seq`
--

CREATE TABLE `usr_data_multi_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_data_multi_seq`
--


--
-- Table structure for table `usr_ext_profile_page`
--

CREATE TABLE `usr_ext_profile_page` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_ext_profile_page`
--


--
-- Table structure for table `usr_ext_profile_page_seq`
--

CREATE TABLE `usr_ext_profile_page_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_ext_profile_page_seq`
--


--
-- Table structure for table `usr_form_settings`
--

CREATE TABLE `usr_form_settings` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `id` varchar(50) NOT NULL DEFAULT '',
  `settings` varchar(4000) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_form_settings`
--


--
-- Table structure for table `usr_portf_acl`
--

CREATE TABLE `usr_portf_acl` (
  `node_id` int(11) NOT NULL DEFAULT '0',
  `object_id` int(11) NOT NULL DEFAULT '0',
  `extended_data` varchar(200) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`node_id`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_portf_acl`
--


--
-- Table structure for table `usr_portfolio`
--

CREATE TABLE `usr_portfolio` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` tinyint(4) DEFAULT NULL,
  `is_default` tinyint(4) DEFAULT NULL,
  `bg_color` char(6) DEFAULT NULL,
  `font_color` char(6) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `ppic` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_portfolio`
--


--
-- Table structure for table `usr_portfolio_page`
--

CREATE TABLE `usr_portfolio_page` (
  `id` int(11) NOT NULL DEFAULT '0',
  `portfolio_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_portfolio_page`
--


--
-- Table structure for table `usr_portfolio_page_seq`
--

CREATE TABLE `usr_portfolio_page_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_portfolio_page_seq`
--


--
-- Table structure for table `usr_pref`
--

CREATE TABLE `usr_pref` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `keyword` char(40) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`usr_id`,`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_pref`
--

INSERT INTO `usr_pref` VALUES (6,'bs_allow_to_contact_me','y'),(6,'calendar_selection_type','1'),(6,'chat_osc_accept_msg','n'),(6,'date_format','1'),(6,'day_end','19'),(6,'day_start','8'),(6,'export_tz_type','1'),(6,'hide_own_online_status','n'),(6,'hits_per_page','50'),(6,'language','en'),(6,'public_city','n'),(6,'public_country','n'),(6,'public_email','n'),(6,'public_hobby','n'),(6,'public_institution','n'),(6,'public_phone','n'),(6,'public_profile','n'),(6,'public_street','n'),(6,'public_upload','n'),(6,'public_zip','n'),(6,'screen_reader_optimization',''),(6,'send_info_mails','n'),(6,'show_users_online','y'),(6,'skin','default'),(6,'store_last_visited','0'),(6,'style','delos'),(6,'time_format','1'),(6,'user_tz','Europe/Berlin'),(6,'weekstart','1'),(13,'show_users_online','y');

--
-- Table structure for table `usr_pwassist`
--

CREATE TABLE `usr_pwassist` (
  `pwassist_id` char(180) NOT NULL DEFAULT '',
  `expires` int(11) NOT NULL DEFAULT '0',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pwassist_id`),
  UNIQUE KEY `c1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_pwassist`
--


--
-- Table structure for table `usr_search`
--

CREATE TABLE `usr_search` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `search_result` longtext,
  `checked` longtext,
  `failed` longtext,
  `page` tinyint(4) NOT NULL DEFAULT '0',
  `search_type` tinyint(4) NOT NULL DEFAULT '0',
  `query` longtext,
  `root` int(11) DEFAULT '1',
  `item_filter` varchar(1000) DEFAULT NULL,
  `mime_filter` varchar(1000) DEFAULT NULL,
  `creation_filter` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`usr_id`,`search_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_search`
--


--
-- Table structure for table `usr_sess_istorage`
--

CREATE TABLE `usr_sess_istorage` (
  `session_id` varchar(256) NOT NULL DEFAULT '',
  `component_id` varchar(30) NOT NULL DEFAULT '',
  `vkey` varchar(50) NOT NULL DEFAULT '',
  `value` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`session_id`,`component_id`,`vkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_sess_istorage`
--


--
-- Table structure for table `usr_session`
--

CREATE TABLE `usr_session` (
  `session_id` varchar(256) NOT NULL DEFAULT ' ',
  `expires` int(11) NOT NULL DEFAULT '0',
  `data` longtext,
  `ctime` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `last_remind_ts` int(11) NOT NULL DEFAULT '0',
  `type` int(11) DEFAULT NULL,
  `createtime` int(11) DEFAULT NULL,
  `remote_addr` varchar(50) DEFAULT NULL,
  `context` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`session_id`),
  KEY `i1_idx` (`expires`),
  KEY `i2_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_session`
--


--
-- Table structure for table `usr_session_log`
--

CREATE TABLE `usr_session_log` (
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `maxval` mediumint(9) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tstamp`,`maxval`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_session_log`
--


--
-- Table structure for table `usr_session_stats`
--

CREATE TABLE `usr_session_stats` (
  `slot_begin` int(11) NOT NULL DEFAULT '0',
  `slot_end` int(11) NOT NULL DEFAULT '0',
  `active_min` int(11) DEFAULT NULL,
  `active_max` int(11) DEFAULT NULL,
  `active_avg` int(11) DEFAULT NULL,
  `active_end` int(11) DEFAULT NULL,
  `opened` int(11) DEFAULT NULL,
  `closed_manual` int(11) DEFAULT NULL,
  `closed_expire` int(11) DEFAULT NULL,
  `closed_idle` int(11) DEFAULT NULL,
  `closed_idle_first` int(11) DEFAULT NULL,
  `closed_limit` int(11) DEFAULT NULL,
  `closed_login` int(11) DEFAULT NULL,
  `max_sessions` int(11) DEFAULT NULL,
  `closed_misc` int(11) DEFAULT '0',
  PRIMARY KEY (`slot_begin`),
  KEY `i1_idx` (`slot_end`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_session_stats`
--


--
-- Table structure for table `usr_session_stats_raw`
--

CREATE TABLE `usr_session_stats_raw` (
  `session_id` varchar(256) NOT NULL DEFAULT '',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `start_time` int(11) NOT NULL DEFAULT '0',
  `end_time` int(11) DEFAULT NULL,
  `end_context` smallint(6) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`session_id`),
  KEY `i1_idx` (`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_session_stats_raw`
--


--
-- Table structure for table `usr_starting_point`
--

CREATE TABLE `usr_starting_point` (
  `id` int(11) NOT NULL DEFAULT '0',
  `position` int(11) DEFAULT '0',
  `starting_point` int(11) DEFAULT '0',
  `starting_object` int(11) DEFAULT '0',
  `rule_type` int(11) DEFAULT '0',
  `rule_options` varchar(4000) DEFAULT NULL,
  `calendar_view` int(11) NOT NULL DEFAULT '0',
  `calendar_period` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_starting_point`
--


--
-- Table structure for table `usr_starting_point_seq`
--

CREATE TABLE `usr_starting_point_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usr_starting_point_seq`
--


--
-- Table structure for table `ut_lp_coll_manual`
--

CREATE TABLE `ut_lp_coll_manual` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `subitem_id` int(11) NOT NULL DEFAULT '0',
  `completed` tinyint(4) NOT NULL DEFAULT '0',
  `last_change` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`,`subitem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_coll_manual`
--


--
-- Table structure for table `ut_lp_collections`
--

CREATE TABLE `ut_lp_collections` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL DEFAULT '0',
  `grouping_id` int(11) NOT NULL DEFAULT '0',
  `num_obligatory` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `lpmode` tinyint(4) DEFAULT '5',
  PRIMARY KEY (`obj_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_collections`
--


--
-- Table structure for table `ut_lp_defaults`
--

CREATE TABLE `ut_lp_defaults` (
  `type_id` varchar(10) NOT NULL DEFAULT '',
  `lp_mode` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_defaults`
--


--
-- Table structure for table `ut_lp_marks`
--

CREATE TABLE `ut_lp_marks` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `completed` int(11) NOT NULL DEFAULT '0',
  `mark` varchar(32) DEFAULT NULL,
  `u_comment` varchar(4000) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `status_changed` datetime DEFAULT NULL,
  `status_dirty` tinyint(4) NOT NULL DEFAULT '0',
  `percentage` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_marks`
--


--
-- Table structure for table `ut_lp_settings`
--

CREATE TABLE `ut_lp_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` char(4) DEFAULT NULL,
  `u_mode` tinyint(4) NOT NULL DEFAULT '0',
  `visits` int(11) DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_settings`
--


--
-- Table structure for table `ut_lp_user_status`
--

CREATE TABLE `ut_lp_user_status` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `additional_info` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`usr_id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_lp_user_status`
--


--
-- Table structure for table `ut_online`
--

CREATE TABLE `ut_online` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `online_time` int(11) NOT NULL DEFAULT '0',
  `access_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ut_online`
--

INSERT INTO `ut_online` VALUES (6,7860,1450799200);

--
-- Table structure for table `webdav_instructions`
--

CREATE TABLE `webdav_instructions` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `uploaded_instructions` longtext,
  `processed_instructions` longtext,
  `lng` varchar(5) DEFAULT NULL,
  `creation_ts` datetime DEFAULT NULL,
  `modification_ts` datetime DEFAULT NULL,
  `owner_usr_id` int(11) DEFAULT NULL,
  `last_modification_usr_id` int(11) DEFAULT NULL,
  `sorting` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webdav_instructions`
--


--
-- Table structure for table `webdav_instructions_seq`
--

CREATE TABLE `webdav_instructions_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webdav_instructions_seq`
--


--
-- Table structure for table `webr_items`
--

CREATE TABLE `webr_items` (
  `link_id` int(11) NOT NULL DEFAULT '0',
  `webr_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(127) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `target` varchar(4000) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `create_date` int(11) NOT NULL DEFAULT '0',
  `last_update` int(11) NOT NULL DEFAULT '0',
  `internal` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`link_id`),
  KEY `i1_idx` (`link_id`,`webr_id`),
  KEY `i3_idx` (`webr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webr_items`
--


--
-- Table structure for table `webr_items_seq`
--

CREATE TABLE `webr_items_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webr_items_seq`
--


--
-- Table structure for table `webr_lists`
--

CREATE TABLE `webr_lists` (
  `webr_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(127) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `create_date` int(11) NOT NULL DEFAULT '0',
  `last_update` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`webr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webr_lists`
--


--
-- Table structure for table `webr_params`
--

CREATE TABLE `webr_params` (
  `param_id` int(11) NOT NULL DEFAULT '0',
  `webr_id` int(11) NOT NULL DEFAULT '0',
  `link_id` int(11) NOT NULL DEFAULT '0',
  `name` char(128) DEFAULT NULL,
  `value` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`param_id`),
  KEY `i1_idx` (`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webr_params`
--


--
-- Table structure for table `webr_params_seq`
--

CREATE TABLE `webr_params_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webr_params_seq`
--


--
-- Table structure for table `wfld_user_setting`
--

CREATE TABLE `wfld_user_setting` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `wfld_id` int(11) NOT NULL DEFAULT '0',
  `sortation` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`wfld_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wfld_user_setting`
--


--
-- Table structure for table `wiki_page_template`
--

CREATE TABLE `wiki_page_template` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `wpage_id` int(11) NOT NULL DEFAULT '0',
  `new_pages` tinyint(4) NOT NULL DEFAULT '0',
  `add_to_page` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wiki_id`,`wpage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_page_template`
--


--
-- Table structure for table `wiki_stat`
--

CREATE TABLE `wiki_stat` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `num_pages` int(11) NOT NULL DEFAULT '0',
  `del_pages` int(11) NOT NULL DEFAULT '0',
  `avg_rating` int(11) NOT NULL DEFAULT '0',
  `ts_day` char(10) DEFAULT NULL,
  `ts_hour` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`wiki_id`,`ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_stat`
--


--
-- Table structure for table `wiki_stat_page`
--

CREATE TABLE `wiki_stat_page` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `int_links` int(11) NOT NULL DEFAULT '0',
  `ext_links` int(11) NOT NULL DEFAULT '0',
  `footnotes` int(11) NOT NULL DEFAULT '0',
  `num_ratings` int(11) NOT NULL DEFAULT '0',
  `num_words` int(11) NOT NULL DEFAULT '0',
  `num_chars` bigint(20) NOT NULL DEFAULT '0',
  `avg_rating` int(11) NOT NULL DEFAULT '0',
  `ts_day` char(10) DEFAULT NULL,
  `ts_hour` tinyint(4) DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wiki_id`,`page_id`,`ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_stat_page`
--


--
-- Table structure for table `wiki_stat_page_user`
--

CREATE TABLE `wiki_stat_page_user` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changes` int(11) NOT NULL DEFAULT '0',
  `read_events` int(11) NOT NULL DEFAULT '0',
  `ts_day` char(10) DEFAULT NULL,
  `ts_hour` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`wiki_id`,`page_id`,`ts`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_stat_page_user`
--


--
-- Table structure for table `wiki_stat_user`
--

CREATE TABLE `wiki_stat_user` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `new_pages` int(11) NOT NULL DEFAULT '0',
  `ts_day` char(10) DEFAULT NULL,
  `ts_hour` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`wiki_id`,`user_id`,`ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_stat_user`
--


--
-- Table structure for table `wiki_user_html_export`
--

CREATE TABLE `wiki_user_html_export` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `progress` int(11) NOT NULL DEFAULT '0',
  `start_ts` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `with_comments` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wiki_id`,`with_comments`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wiki_user_html_export`
--


--
-- Table structure for table `wopi_action`
--

CREATE TABLE `wopi_action` (
  `id` int(11) NOT NULL,
  `app_id` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `ext` varchar(256) NOT NULL,
  `urlsrc` varchar(2048) NOT NULL,
  `url_appendix` varchar(4000) DEFAULT NULL,
  `target_ext` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wopi_action`
--


--
-- Table structure for table `wopi_action_seq`
--

CREATE TABLE `wopi_action_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wopi_action_seq`
--


--
-- Table structure for table `wopi_app`
--

CREATE TABLE `wopi_app` (
  `id` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `favicon` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wopi_app`
--


--
-- Table structure for table `wopi_app_seq`
--

CREATE TABLE `wopi_app_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wopi_app_seq`
--


--
-- Table structure for table `write_event`
--

CREATE TABLE `write_event` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `parent_obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `action` varchar(8) NOT NULL DEFAULT ' ',
  `ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `write_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`write_id`),
  KEY `i1_idx` (`parent_obj_id`,`ts`),
  KEY `i2_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `write_event`
--

INSERT INTO `write_event` VALUES (7,9,-1,'create','2002-06-26 23:24:06',1),(8,9,-1,'create','2002-06-26 23:24:06',2),(9,1,-1,'create','2002-07-15 02:37:33',3),(10,9,-1,'create','2002-07-15 02:36:56',4),(11,9,-1,'create','2002-07-15 05:52:51',5),(12,9,-1,'create','2003-08-15 00:07:28',6),(98,9,-1,'create','2004-02-18 16:17:40',7),(100,9,-1,'create','2004-03-09 13:13:16',8),(107,9,-1,'create','2004-06-20 15:27:18',9),(109,9,-1,'create','2004-07-10 15:03:12',10),(86,9,-1,'create','2003-11-30 16:22:49',11),(114,9,-1,'create','2004-09-01 23:49:45',12),(116,9,-1,'create','2005-01-07 12:21:15',13),(118,9,-1,'create','2005-03-02 03:59:01',14),(124,9,-1,'create','2005-06-19 23:50:00',15),(128,9,-1,'create','2005-07-20 08:10:04',16),(136,9,-1,'create','2006-07-11 08:43:23',19),(138,9,-1,'create','2007-02-26 12:58:49',20),(140,9,-1,'create','2007-02-26 12:58:50',21),(144,9,-1,'create','2007-04-03 03:43:47',22),(147,9,-1,'create','2007-09-25 09:47:53',23),(150,9,-1,'create','2008-06-02 06:08:54',24),(152,9,-1,'create','2008-06-02 06:08:55',25);

--
-- Table structure for table `write_event_seq`
--

CREATE TABLE `write_event_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `write_event_seq`
--

INSERT INTO `write_event_seq` VALUES (25);

--
-- Table structure for table `xhtml_page`
--

CREATE TABLE `xhtml_page` (
  `id` int(11) NOT NULL DEFAULT '0',
  `content` longtext,
  `save_content` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xhtml_page`
--


--
-- Table structure for table `xhtml_page_seq`
--

CREATE TABLE `xhtml_page_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xhtml_page_seq`
--


--
-- Table structure for table `xmlnestedset`
--

CREATE TABLE `xmlnestedset` (
  `ns_id` int(11) NOT NULL DEFAULT '0',
  `ns_book_fk` int(11) NOT NULL DEFAULT '0',
  `ns_type` varchar(50) NOT NULL DEFAULT '',
  `ns_tag_fk` int(11) NOT NULL DEFAULT '0',
  `ns_l` int(11) NOT NULL DEFAULT '0',
  `ns_r` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ns_id`),
  KEY `i1_idx` (`ns_tag_fk`),
  KEY `i2_idx` (`ns_l`),
  KEY `i3_idx` (`ns_r`),
  KEY `i4_idx` (`ns_book_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlnestedset`
--


--
-- Table structure for table `xmlnestedset_seq`
--

CREATE TABLE `xmlnestedset_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlnestedset_seq`
--


--
-- Table structure for table `xmlnestedsettmp`
--

CREATE TABLE `xmlnestedsettmp` (
  `ns_id` int(11) NOT NULL DEFAULT '0',
  `ns_unique_id` varchar(32) NOT NULL DEFAULT '',
  `ns_book_fk` int(11) NOT NULL DEFAULT '0',
  `ns_type` varchar(50) NOT NULL DEFAULT '',
  `ns_tag_fk` int(11) NOT NULL DEFAULT '0',
  `ns_l` int(11) NOT NULL DEFAULT '0',
  `ns_r` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ns_id`),
  KEY `i1_idx` (`ns_tag_fk`),
  KEY `i2_idx` (`ns_l`),
  KEY `i3_idx` (`ns_r`),
  KEY `i4_idx` (`ns_book_fk`),
  KEY `i5_idx` (`ns_unique_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlnestedsettmp`
--


--
-- Table structure for table `xmlnestedsettmp_seq`
--

CREATE TABLE `xmlnestedsettmp_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlnestedsettmp_seq`
--


--
-- Table structure for table `xmlparam`
--

CREATE TABLE `xmlparam` (
  `tag_fk` int(11) NOT NULL DEFAULT '0',
  `param_name` char(50) NOT NULL DEFAULT '',
  `param_value` char(255) DEFAULT NULL,
  PRIMARY KEY (`tag_fk`,`param_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlparam`
--


--
-- Table structure for table `xmltags`
--

CREATE TABLE `xmltags` (
  `tag_pk` int(11) NOT NULL DEFAULT '0',
  `tag_depth` int(11) NOT NULL DEFAULT '0',
  `tag_name` char(50) DEFAULT NULL,
  PRIMARY KEY (`tag_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmltags`
--


--
-- Table structure for table `xmltags_seq`
--

CREATE TABLE `xmltags_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmltags_seq`
--


--
-- Table structure for table `xmlvalue`
--

CREATE TABLE `xmlvalue` (
  `tag_value_pk` int(11) NOT NULL DEFAULT '0',
  `tag_fk` int(11) NOT NULL DEFAULT '0',
  `tag_value` longtext,
  PRIMARY KEY (`tag_value_pk`),
  KEY `i1_idx` (`tag_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlvalue`
--


--
-- Table structure for table `xmlvalue_seq`
--

CREATE TABLE `xmlvalue_seq` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xmlvalue_seq`
--


--
-- Dumping routines for database 'ilias910'
--


