--
-- Host: localhost    Database: ilias910
-- ------------------------------------------------------


--
-- Table structure for table `acc_access_key`
--

CREATE TABLE `acc_access_key` (
  `lang_key` char(2) NOT NULL DEFAULT '',
  `function_id` int(11) NOT NULL DEFAULT '0',
  `access_key` char(1) DEFAULT NULL,
  PRIMARY KEY (`lang_key`,`function_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acc_access_key`
--


--
-- Table structure for table `acc_cache`
--

CREATE TABLE `acc_cache` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `result` longtext,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acc_cache`
--


--
-- Table structure for table `acc_criterion_to_doc`
--

CREATE TABLE `acc_criterion_to_doc` (
  `id` int(11) NOT NULL DEFAULT '0',
  `doc_id` int(11) NOT NULL DEFAULT '0',
  `criterion_id` varchar(50) NOT NULL,
  `criterion_value` varchar(255) DEFAULT NULL,
  `assigned_ts` int(11) NOT NULL DEFAULT '0',
  `modification_ts` int(11) NOT NULL DEFAULT '0',
  `owner_usr_id` int(11) NOT NULL DEFAULT '0',
  `last_modified_usr_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acc_criterion_to_doc`
--


--
-- Table structure for table `acc_criterion_to_doc_seq`
--

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

--
-- Dumping data for table `acc_criterion_to_doc_seq`
--


--
-- Table structure for table `acc_documents`
--

CREATE TABLE `acc_documents` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `creation_ts` int(11) NOT NULL DEFAULT '0',
  `modification_ts` int(11) NOT NULL DEFAULT '0',
  `sorting` int(11) NOT NULL DEFAULT '0',
  `owner_usr_id` int(11) NOT NULL DEFAULT '0',
  `last_modified_usr_id` int(11) NOT NULL DEFAULT '0',
  `text` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acc_documents`
--


--
-- Table structure for table `acc_documents_seq`
--

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

--
-- Dumping data for table `acc_documents_seq`
--


--
-- Table structure for table `acc_user_access_key`
--

CREATE TABLE `acc_user_access_key` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `function_id` smallint(6) NOT NULL DEFAULT '0',
  `access_key` char(1) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`function_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acc_user_access_key`
--


--
-- Table structure for table `acl_ws`
--

CREATE TABLE `acl_ws` (
  `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 `acl_ws`
--


--
-- Table structure for table `addressbook_mlist`
--

CREATE TABLE `addressbook_mlist` (
  `ml_id` bigint(20) NOT NULL DEFAULT '0',
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `createdate` datetime DEFAULT NULL,
  `changedate` datetime DEFAULT NULL,
  `lmode` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ml_id`),
  KEY `i1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `addressbook_mlist`
--


--
-- Table structure for table `addressbook_mlist_ass`
--

CREATE TABLE `addressbook_mlist_ass` (
  `a_id` bigint(20) NOT NULL DEFAULT '0',
  `ml_id` bigint(20) NOT NULL DEFAULT '0',
  `usr_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`a_id`),
  KEY `i1_idx` (`ml_id`),
  KEY `i2_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `addressbook_mlist_ass`
--


--
-- Table structure for table `addressbook_mlist_ass_seq`
--

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

--
-- Dumping data for table `addressbook_mlist_ass_seq`
--


--
-- Table structure for table `addressbook_mlist_seq`
--

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

--
-- Dumping data for table `addressbook_mlist_seq`
--


--
-- Table structure for table `adl_shared_data`
--

CREATE TABLE `adl_shared_data` (
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `target_id` varchar(4000) NOT NULL DEFAULT '',
  `store` longtext,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cp_node_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adl_shared_data`
--


--
-- Table structure for table `adm_set_templ_hide_tab`
--

CREATE TABLE `adm_set_templ_hide_tab` (
  `template_id` int(11) NOT NULL DEFAULT '0',
  `tab_id` varchar(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`template_id`,`tab_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adm_set_templ_hide_tab`
--


--
-- Table structure for table `adm_set_templ_value`
--

CREATE TABLE `adm_set_templ_value` (
  `template_id` int(11) NOT NULL DEFAULT '0',
  `setting` varchar(40) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  `hide` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`template_id`,`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adm_set_templ_value`
--

INSERT INTO `adm_set_templ_value` VALUES (1,'pass_scoring','0',1),(2,'pass_scoring','0',1);

--
-- Table structure for table `adv_md_field_int`
--

CREATE TABLE `adv_md_field_int` (
  `field_id` int(11) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `lang_code` varchar(5) NOT NULL,
  PRIMARY KEY (`field_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_field_int`
--


--
-- Table structure for table `adv_md_obj_rec_select`
--

CREATE TABLE `adv_md_obj_rec_select` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `rec_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`rec_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_obj_rec_select`
--


--
-- Table structure for table `adv_md_record`
--

CREATE TABLE `adv_md_record` (
  `record_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(64) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `parent_obj` int(11) DEFAULT NULL,
  `gpos` int(11) DEFAULT NULL,
  `lang_default` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_record`
--


--
-- Table structure for table `adv_md_record_int`
--

CREATE TABLE `adv_md_record_int` (
  `record_id` int(11) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `lang_code` varchar(5) NOT NULL,
  PRIMARY KEY (`record_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_record_int`
--


--
-- Table structure for table `adv_md_record_obj_ord`
--

CREATE TABLE `adv_md_record_obj_ord` (
  `record_id` int(11) NOT NULL,
  `obj_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`record_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_record_obj_ord`
--


--
-- Table structure for table `adv_md_record_objs`
--

CREATE TABLE `adv_md_record_objs` (
  `record_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` char(6) NOT NULL DEFAULT '',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `optional` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`record_id`,`obj_type`,`sub_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_record_objs`
--


--
-- Table structure for table `adv_md_record_scope`
--

CREATE TABLE `adv_md_record_scope` (
  `scope_id` int(11) NOT NULL DEFAULT '0',
  `record_id` int(11) NOT NULL,
  `ref_id` int(11) NOT NULL,
  PRIMARY KEY (`scope_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_record_scope`
--


--
-- Table structure for table `adv_md_record_scope_seq`
--

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

--
-- Dumping data for table `adv_md_record_scope_seq`
--


--
-- Table structure for table `adv_md_record_seq`
--

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

--
-- Dumping data for table `adv_md_record_seq`
--


--
-- Table structure for table `adv_md_substitutions`
--

CREATE TABLE `adv_md_substitutions` (
  `obj_type` varchar(4) NOT NULL DEFAULT ' ',
  `substitution` longtext,
  `hide_description` tinyint(4) NOT NULL DEFAULT '0',
  `hide_field_names` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_substitutions`
--


--
-- Table structure for table `adv_md_values_date`
--

CREATE TABLE `adv_md_values_date` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` date DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_date`
--


--
-- Table structure for table `adv_md_values_datetime`
--

CREATE TABLE `adv_md_values_datetime` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` datetime DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_datetime`
--


--
-- Table structure for table `adv_md_values_enum`
--

CREATE TABLE `adv_md_values_enum` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  `value_index` varchar(16) NOT NULL,
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`,`value_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_enum`
--


--
-- Table structure for table `adv_md_values_extlink`
--

CREATE TABLE `adv_md_values_extlink` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(2000) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_extlink`
--


--
-- Table structure for table `adv_md_values_float`
--

CREATE TABLE `adv_md_values_float` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` double DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_float`
--


--
-- Table structure for table `adv_md_values_int`
--

CREATE TABLE `adv_md_values_int` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` int(11) DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_int`
--


--
-- Table structure for table `adv_md_values_intlink`
--

CREATE TABLE `adv_md_values_intlink` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` int(11) NOT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_intlink`
--


--
-- Table structure for table `adv_md_values_location`
--

CREATE TABLE `adv_md_values_location` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `loc_lat` double DEFAULT NULL,
  `loc_long` double DEFAULT NULL,
  `loc_zoom` tinyint(4) DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_location`
--


--
-- Table structure for table `adv_md_values_ltext`
--

CREATE TABLE `adv_md_values_ltext` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value_index` varchar(16) NOT NULL,
  `value` varchar(4000) DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`,`value_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_ltext`
--


--
-- Table structure for table `adv_md_values_text`
--

CREATE TABLE `adv_md_values_text` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(4000) DEFAULT NULL,
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  `sub_type` varchar(10) NOT NULL DEFAULT '-',
  `sub_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`field_id`,`sub_type`,`sub_id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_md_values_text`
--


--
-- Table structure for table `adv_mdf_definition`
--

CREATE TABLE `adv_mdf_definition` (
  `field_id` int(11) NOT NULL DEFAULT '0',
  `record_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(32) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  `field_type` tinyint(4) NOT NULL DEFAULT '0',
  `field_values` text,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(2000) DEFAULT NULL,
  `searchable` tinyint(4) NOT NULL DEFAULT '0',
  `required` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_mdf_definition`
--


--
-- Table structure for table `adv_mdf_definition_seq`
--

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

--
-- Dumping data for table `adv_mdf_definition_seq`
--


--
-- Table structure for table `adv_mdf_enum`
--

CREATE TABLE `adv_mdf_enum` (
  `field_id` int(11) NOT NULL,
  `lang_code` varchar(5) NOT NULL,
  `idx` int(11) NOT NULL,
  `value` varchar(4000) NOT NULL,
  PRIMARY KEY (`field_id`,`lang_code`,`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adv_mdf_enum`
--


--
-- Table structure for table `aicc_course`
--

CREATE TABLE `aicc_course` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `course_creator` varchar(255) DEFAULT NULL,
  `course_id` varchar(50) DEFAULT NULL,
  `course_system` varchar(50) DEFAULT NULL,
  `course_title` varchar(255) DEFAULT NULL,
  `c_level` varchar(5) DEFAULT NULL,
  `max_fields_cst` int(11) DEFAULT '0',
  `max_fields_ort` int(11) DEFAULT '0',
  `total_aus` int(11) NOT NULL DEFAULT '0',
  `total_blocks` int(11) NOT NULL DEFAULT '0',
  `total_complex_obj` int(11) DEFAULT '0',
  `total_objectives` int(11) DEFAULT '0',
  `version` varchar(10) DEFAULT NULL,
  `max_normal` tinyint(4) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aicc_course`
--


--
-- Table structure for table `aicc_object`
--

CREATE TABLE `aicc_object` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `system_id` varchar(50) DEFAULT NULL,
  `title` varchar(4000) DEFAULT NULL,
  `description` longtext,
  `developer_id` varchar(50) DEFAULT NULL,
  `c_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`slm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aicc_object`
--


--
-- Table structure for table `aicc_object_seq`
--

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

--
-- Dumping data for table `aicc_object_seq`
--


--
-- Table structure for table `aicc_units`
--

CREATE TABLE `aicc_units` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `c_type` varchar(50) DEFAULT NULL,
  `command_line` varchar(255) DEFAULT NULL,
  `max_time_allowed` time DEFAULT NULL,
  `time_limit_action` varchar(50) DEFAULT NULL,
  `max_score` double DEFAULT NULL,
  `core_vendor` varchar(4000) DEFAULT NULL,
  `system_vendor` varchar(4000) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `mastery_score` int(11) NOT NULL DEFAULT '0',
  `web_launch` varchar(255) DEFAULT NULL,
  `au_password` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aicc_units`
--


--
-- Table structure for table `aicc_units_seq`
--

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

--
-- Dumping data for table `aicc_units_seq`
--


--
-- Table structure for table `ass_log`
--

CREATE TABLE `ass_log` (
  `ass_log_id` int(11) NOT NULL DEFAULT '0',
  `user_fi` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `logtext` text,
  `question_fi` int(11) DEFAULT NULL,
  `original_fi` int(11) DEFAULT NULL,
  `ref_id` int(11) DEFAULT NULL,
  `test_only` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ass_log_id`),
  KEY `i1_idx` (`user_fi`,`obj_fi`),
  KEY `i2_idx` (`obj_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ass_log`
--


--
-- Table structure for table `ass_log_seq`
--

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

--
-- Dumping data for table `ass_log_seq`
--


--
-- Table structure for table `auth_ext_attr_mapping`
--

CREATE TABLE `auth_ext_attr_mapping` (
  `auth_src_id` int(11) NOT NULL DEFAULT '0',
  `attribute` varchar(75) NOT NULL,
  `ext_attribute` varchar(1000) DEFAULT NULL,
  `update_automatically` tinyint(4) NOT NULL DEFAULT '0',
  `auth_mode` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`auth_mode`,`auth_src_id`,`attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `auth_ext_attr_mapping`
--


--
-- Table structure for table `background_task`
--

CREATE TABLE `background_task` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `handler` varchar(1000) DEFAULT NULL,
  `steps` mediumint(9) NOT NULL DEFAULT '0',
  `cstep` mediumint(9) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `params` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `background_task`
--


--
-- Table structure for table `background_task_seq`
--

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

--
-- Dumping data for table `background_task_seq`
--


--
-- Table structure for table `badge_badge`
--

CREATE TABLE `badge_badge` (
  `id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `type_id` varchar(255) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `descr` varchar(4000) DEFAULT NULL,
  `conf` varchar(4000) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `valid` varchar(255) DEFAULT NULL,
  `crit` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `badge_badge`
--


--
-- Table structure for table `badge_badge_seq`
--

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

--
-- Dumping data for table `badge_badge_seq`
--


--
-- Table structure for table `badge_image_templ_type`
--

CREATE TABLE `badge_image_templ_type` (
  `tmpl_id` int(11) NOT NULL DEFAULT '0',
  `type_id` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`tmpl_id`,`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `badge_image_templ_type`
--


--
-- Table structure for table `badge_image_template`
--

CREATE TABLE `badge_image_template` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `badge_image_template`
--


--
-- Table structure for table `badge_image_template_seq`
--

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

--
-- Dumping data for table `badge_image_template_seq`
--


--
-- Table structure for table `badge_user_badge`
--

CREATE TABLE `badge_user_badge` (
  `badge_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `awarded_by` int(11) DEFAULT NULL,
  `pos` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`badge_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `badge_user_badge`
--


--
-- Table structure for table `benchmark`
--

CREATE TABLE `benchmark` (
  `id` int(11) NOT NULL DEFAULT '0',
  `cdate` datetime DEFAULT NULL,
  `module` varchar(150) DEFAULT NULL,
  `benchmark` varchar(150) DEFAULT NULL,
  `duration` double DEFAULT NULL,
  `sql_stmt` longtext,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`module`,`benchmark`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `benchmark`
--


--
-- Table structure for table `benchmark_seq`
--

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

--
-- Dumping data for table `benchmark_seq`
--


--
-- Table structure for table `book_obj_use_book`
--

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

--
-- Dumping data for table `book_obj_use_book`
--


--
-- Table structure for table `book_sel_object`
--

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

--
-- Dumping data for table `book_sel_object`
--


--
-- Table structure for table `booking_entry`
--

CREATE TABLE `booking_entry` (
  `booking_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `deadline` int(11) NOT NULL DEFAULT '0',
  `num_bookings` int(11) NOT NULL DEFAULT '0',
  `target_obj_id` int(11) DEFAULT NULL,
  `booking_group` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`booking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_entry`
--


--
-- Table structure for table `booking_entry_seq`
--

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

--
-- Dumping data for table `booking_entry_seq`
--


--
-- Table structure for table `booking_member`
--

CREATE TABLE `booking_member` (
  `participant_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `booking_pool_id` varchar(255) NOT NULL,
  `assigner_user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`participant_id`,`user_id`,`booking_pool_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_member`
--


--
-- Table structure for table `booking_member_seq`
--

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

--
-- Dumping data for table `booking_member_seq`
--


--
-- Table structure for table `booking_obj_assignment`
--

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

--
-- Dumping data for table `booking_obj_assignment`
--


--
-- Table structure for table `booking_object`
--

CREATE TABLE `booking_object` (
  `booking_object_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `schedule_id` int(11) DEFAULT NULL,
  `pool_id` int(11) DEFAULT '0',
  `description` varchar(1000) DEFAULT NULL,
  `nr_items` smallint(6) NOT NULL DEFAULT '1',
  `info_file` varchar(500) DEFAULT NULL,
  `post_text` varchar(4000) DEFAULT NULL,
  `post_file` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`booking_object_id`),
  KEY `i1_idx` (`pool_id`),
  KEY `i2_idx` (`schedule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_object`
--


--
-- Table structure for table `booking_object_seq`
--

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

--
-- Dumping data for table `booking_object_seq`
--


--
-- Table structure for table `booking_preferences`
--

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

--
-- Dumping data for table `booking_preferences`
--


--
-- Table structure for table `booking_reservation`
--

CREATE TABLE `booking_reservation` (
  `booking_reservation_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `object_id` int(11) NOT NULL DEFAULT '0',
  `date_from` int(11) NOT NULL DEFAULT '0',
  `date_to` int(11) NOT NULL DEFAULT '0',
  `status` smallint(6) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `assigner_id` int(11) NOT NULL DEFAULT '0',
  `context_obj_id` int(11) DEFAULT '0',
  `message` varchar(4000) NOT NULL DEFAULT '',
  PRIMARY KEY (`booking_reservation_id`),
  KEY `i1_idx` (`user_id`),
  KEY `i2_idx` (`object_id`),
  KEY `i3_idx` (`date_from`),
  KEY `i4_idx` (`date_to`),
  KEY `i5_idx` (`context_obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_reservation`
--


--
-- Table structure for table `booking_reservation_group_seq`
--

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

--
-- Dumping data for table `booking_reservation_group_seq`
--


--
-- Table structure for table `booking_reservation_seq`
--

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

--
-- Dumping data for table `booking_reservation_seq`
--


--
-- Table structure for table `booking_schedule`
--

CREATE TABLE `booking_schedule` (
  `booking_schedule_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `pool_id` int(11) NOT NULL DEFAULT '0',
  `deadline` int(11) DEFAULT NULL,
  `rent_min` int(11) DEFAULT NULL,
  `rent_max` int(11) DEFAULT NULL,
  `raster` int(11) DEFAULT NULL,
  `auto_break` int(11) DEFAULT NULL,
  `av_from` int(11) DEFAULT NULL,
  `av_to` int(11) DEFAULT NULL,
  PRIMARY KEY (`booking_schedule_id`),
  KEY `i1_idx` (`pool_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_schedule`
--


--
-- Table structure for table `booking_schedule_seq`
--

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

--
-- Dumping data for table `booking_schedule_seq`
--


--
-- Table structure for table `booking_schedule_slot`
--

CREATE TABLE `booking_schedule_slot` (
  `booking_schedule_id` int(11) NOT NULL DEFAULT '0',
  `day_id` varchar(2) NOT NULL DEFAULT '',
  `slot_id` tinyint(4) NOT NULL DEFAULT '0',
  `times` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`booking_schedule_id`,`day_id`,`slot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_schedule_slot`
--


--
-- Table structure for table `booking_settings`
--

CREATE TABLE `booking_settings` (
  `booking_pool_id` int(11) NOT NULL DEFAULT '0',
  `public_log` tinyint(4) DEFAULT NULL,
  `pool_offline` tinyint(4) DEFAULT NULL,
  `slots_no` smallint(6) DEFAULT '0',
  `schedule_type` tinyint(4) NOT NULL DEFAULT '1',
  `ovlimit` tinyint(4) DEFAULT NULL,
  `rsv_filter_period` smallint(6) DEFAULT NULL,
  `reminder_status` tinyint(4) NOT NULL DEFAULT '0',
  `reminder_day` int(11) NOT NULL DEFAULT '0',
  `last_remind_ts` int(11) NOT NULL DEFAULT '0',
  `preference_nr` int(11) NOT NULL DEFAULT '0',
  `pref_deadline` int(11) NOT NULL DEFAULT '0',
  `pref_booking_hash` varchar(23) NOT NULL DEFAULT '0',
  `messages` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`booking_pool_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_settings`
--


--
-- Table structure for table `booking_user`
--

CREATE TABLE `booking_user` (
  `entry_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `booking_message` varchar(1024) DEFAULT NULL,
  `notification_sent` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `booking_user`
--


--
-- Table structure for table `bookmark_data`
--

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

--
-- Dumping data for table `bookmark_data`
--

INSERT INTO `bookmark_data` VALUES (1,0,'dummy_folder','','','bmf');

--
-- Table structure for table `bookmark_data_seq`
--

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

--
-- Dumping data for table `bookmark_data_seq`
--

INSERT INTO `bookmark_data_seq` VALUES (1);

--
-- Table structure for table `bookmark_tree`
--

CREATE TABLE `bookmark_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',
  PRIMARY KEY (`tree`,`child`),
  KEY `i1_idx` (`child`),
  KEY `i2_idx` (`parent`),
  KEY `i3_idx` (`child`,`tree`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookmark_tree`
--

INSERT INTO `bookmark_tree` VALUES (6,1,0,1,2,1);

--
-- Table structure for table `buddylist`
--

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

--
-- Dumping data for table `buddylist`
--


--
-- Table structure for table `buddylist_requests`
--

CREATE TABLE `buddylist_requests` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `buddy_usr_id` int(11) NOT NULL DEFAULT '0',
  `ignored` tinyint(4) NOT NULL DEFAULT '0',
  `ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`buddy_usr_id`),
  KEY `i1_idx` (`buddy_usr_id`,`ignored`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `buddylist_requests`
--


--
-- Table structure for table `cache_clob`
--

CREATE TABLE `cache_clob` (
  `component` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `entry_id` varchar(50) NOT NULL DEFAULT '',
  `value` longtext,
  `expire_time` int(11) NOT NULL DEFAULT '0',
  `ilias_version` varchar(10) DEFAULT NULL,
  `int_key_1` int(11) DEFAULT NULL,
  `int_key_2` int(11) DEFAULT NULL,
  `text_key_1` varchar(20) DEFAULT NULL,
  `text_key_2` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`component`,`name`,`entry_id`),
  KEY `et_idx` (`expire_time`),
  KEY `iv_idx` (`ilias_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_clob`
--


--
-- Table structure for table `cache_text`
--

CREATE TABLE `cache_text` (
  `component` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `entry_id` varchar(50) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  `expire_time` int(11) NOT NULL DEFAULT '0',
  `ilias_version` varchar(10) DEFAULT NULL,
  `int_key_1` int(11) DEFAULT NULL,
  `int_key_2` int(11) DEFAULT NULL,
  `text_key_1` varchar(20) DEFAULT NULL,
  `text_key_2` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`component`,`name`,`entry_id`),
  KEY `et_idx` (`expire_time`),
  KEY `iv_idx` (`ilias_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_text`
--


--
-- Table structure for table `cal_auth_token`
--

CREATE TABLE `cal_auth_token` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `hash` varchar(32) NOT NULL DEFAULT '',
  `selection` int(11) NOT NULL DEFAULT '0',
  `calendar` int(11) NOT NULL DEFAULT '0',
  `ical` longtext,
  `c_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`hash`),
  KEY `i1_idx` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_auth_token`
--


--
-- Table structure for table `cal_cat_assignments`
--

CREATE TABLE `cal_cat_assignments` (
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cal_id`,`cat_id`),
  KEY `i2_idx` (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_cat_assignments`
--


--
-- Table structure for table `cal_cat_visibility`
--

CREATE TABLE `cal_cat_visibility` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `visible` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`cat_id`,`obj_id`),
  KEY `i1_idx` (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_cat_visibility`
--


--
-- Table structure for table `cal_categories`
--

CREATE TABLE `cal_categories` (
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` char(128) DEFAULT NULL,
  `color` char(8) DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `loc_type` tinyint(4) NOT NULL DEFAULT '1',
  `remote_url` varchar(500) DEFAULT NULL,
  `remote_user` varchar(50) DEFAULT NULL,
  `remote_pass` varchar(50) DEFAULT NULL,
  `remote_sync` datetime DEFAULT NULL,
  PRIMARY KEY (`cat_id`),
  KEY `i2_idx` (`obj_id`),
  KEY `i3_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_categories`
--


--
-- Table structure for table `cal_categories_seq`
--

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

--
-- Dumping data for table `cal_categories_seq`
--


--
-- Table structure for table `cal_ch_group`
--

CREATE TABLE `cal_ch_group` (
  `grp_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `multiple_assignments` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`grp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_ch_group`
--


--
-- Table structure for table `cal_ch_group_seq`
--

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

--
-- Dumping data for table `cal_ch_group_seq`
--


--
-- Table structure for table `cal_ch_settings`
--

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

--
-- Dumping data for table `cal_ch_settings`
--


--
-- Table structure for table `cal_entries`
--

CREATE TABLE `cal_entries` (
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `last_update` datetime DEFAULT NULL,
  `title` char(128) DEFAULT NULL,
  `subtitle` char(64) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `location` varchar(4000) DEFAULT NULL,
  `fullday` tinyint(4) NOT NULL DEFAULT '0',
  `starta` datetime DEFAULT NULL,
  `enda` datetime DEFAULT NULL,
  `informations` varchar(4000) DEFAULT NULL,
  `auto_generated` tinyint(4) NOT NULL DEFAULT '0',
  `context_id` int(11) NOT NULL DEFAULT '0',
  `translation_type` tinyint(4) NOT NULL DEFAULT '0',
  `notification` tinyint(4) NOT NULL DEFAULT '0',
  `context_info` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cal_id`),
  KEY `i1_idx` (`last_update`),
  KEY `i2_idx` (`context_id`),
  KEY `i3_idx` (`starta`),
  KEY `i4_idx` (`enda`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_entries`
--


--
-- Table structure for table `cal_entries_seq`
--

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

--
-- Dumping data for table `cal_entries_seq`
--


--
-- Table structure for table `cal_notification`
--

CREATE TABLE `cal_notification` (
  `notification_id` int(11) NOT NULL DEFAULT '0',
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `user_type` tinyint(4) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`notification_id`),
  KEY `i1_idx` (`cal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_notification`
--


--
-- Table structure for table `cal_notification_seq`
--

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

--
-- Dumping data for table `cal_notification_seq`
--


--
-- Table structure for table `cal_rec_exclusion`
--

CREATE TABLE `cal_rec_exclusion` (
  `excl_id` int(11) NOT NULL DEFAULT '0',
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `excl_date` date DEFAULT NULL,
  PRIMARY KEY (`excl_id`),
  KEY `i1_idx` (`cal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_rec_exclusion`
--


--
-- Table structure for table `cal_rec_exclusion_seq`
--

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

--
-- Dumping data for table `cal_rec_exclusion_seq`
--


--
-- Table structure for table `cal_recurrence_rules`
--

CREATE TABLE `cal_recurrence_rules` (
  `rule_id` int(11) NOT NULL DEFAULT '0',
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `cal_recurrence` int(11) NOT NULL DEFAULT '0',
  `freq_type` char(20) DEFAULT NULL,
  `freq_until_date` datetime DEFAULT NULL,
  `freq_until_count` int(11) NOT NULL DEFAULT '0',
  `intervall` int(11) NOT NULL DEFAULT '0',
  `byday` char(64) DEFAULT NULL,
  `byweekno` char(64) DEFAULT '0',
  `bymonth` char(64) DEFAULT NULL,
  `bymonthday` char(64) DEFAULT NULL,
  `byyearday` char(64) DEFAULT NULL,
  `bysetpos` char(64) DEFAULT '0',
  `weekstart` char(2) DEFAULT NULL,
  PRIMARY KEY (`rule_id`),
  KEY `i1_idx` (`cal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_recurrence_rules`
--


--
-- Table structure for table `cal_recurrence_rules_seq`
--

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

--
-- Dumping data for table `cal_recurrence_rules_seq`
--


--
-- Table structure for table `cal_registrations`
--

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

--
-- Dumping data for table `cal_registrations`
--


--
-- Table structure for table `cal_shared`
--

CREATE TABLE `cal_shared` (
  `cal_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `writable` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`cal_id`,`obj_id`),
  KEY `i1_idx` (`obj_id`,`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cal_shared`
--


--
-- Table structure for table `cal_shared_status`
--

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

--
-- Dumping data for table `cal_shared_status`
--


--
-- Table structure for table `chatroom_admconfig`
--

CREATE TABLE `chatroom_admconfig` (
  `instance_id` int(11) NOT NULL DEFAULT '0',
  `server_settings` varchar(2000) NOT NULL DEFAULT '',
  `default_config` tinyint(4) NOT NULL DEFAULT '0',
  `client_settings` varchar(1000) NOT NULL DEFAULT '',
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_admconfig`
--


--
-- Table structure for table `chatroom_admconfig_seq`
--

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

--
-- Dumping data for table `chatroom_admconfig_seq`
--


--
-- Table structure for table `chatroom_bans`
--

CREATE TABLE `chatroom_bans` (
  `room_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `remark` varchar(1000) DEFAULT NULL,
  `actor_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`room_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_bans`
--


--
-- Table structure for table `chatroom_history`
--

CREATE TABLE `chatroom_history` (
  `hist_id` bigint(20) NOT NULL DEFAULT '0',
  `room_id` int(11) NOT NULL DEFAULT '0',
  `message` varchar(4000) DEFAULT NULL,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`hist_id`),
  KEY `i1_idx` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_history`
--


--
-- Table structure for table `chatroom_history_seq`
--

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

--
-- Dumping data for table `chatroom_history_seq`
--


--
-- Table structure for table `chatroom_sessions`
--

CREATE TABLE `chatroom_sessions` (
  `sess_id` bigint(20) NOT NULL DEFAULT '0',
  `room_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `userdata` varchar(4000) DEFAULT NULL,
  `connected` int(11) NOT NULL DEFAULT '0',
  `disconnected` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sess_id`),
  KEY `i1_idx` (`room_id`,`user_id`),
  KEY `i2_idx` (`disconnected`),
  KEY `i3_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_sessions`
--


--
-- Table structure for table `chatroom_sessions_seq`
--

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

--
-- Dumping data for table `chatroom_sessions_seq`
--


--
-- Table structure for table `chatroom_settings`
--

CREATE TABLE `chatroom_settings` (
  `room_id` int(11) NOT NULL DEFAULT '0',
  `object_id` int(11) DEFAULT '0',
  `room_type` varchar(20) NOT NULL DEFAULT '',
  `allow_anonymous` tinyint(4) DEFAULT '0',
  `allow_custom_usernames` tinyint(4) DEFAULT '0',
  `enable_history` tinyint(4) DEFAULT '0',
  `autogen_usernames` varchar(50) DEFAULT 'Anonymous #',
  `display_past_msgs` int(11) NOT NULL DEFAULT '0',
  `online_status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_settings`
--

INSERT INTO `chatroom_settings` VALUES (2,185,'default',0,0,0,'Anonymous #',0,1);

--
-- Table structure for table `chatroom_settings_seq`
--

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

--
-- Dumping data for table `chatroom_settings_seq`
--

INSERT INTO `chatroom_settings_seq` VALUES (2);

--
-- Table structure for table `chatroom_uploads`
--

CREATE TABLE `chatroom_uploads` (
  `upload_id` int(11) NOT NULL DEFAULT '0',
  `room_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(200) NOT NULL DEFAULT '',
  `filetype` varchar(200) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`upload_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_uploads`
--


--
-- Table structure for table `chatroom_uploads_seq`
--

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

--
-- Dumping data for table `chatroom_uploads_seq`
--


--
-- Table structure for table `chatroom_users`
--

CREATE TABLE `chatroom_users` (
  `room_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `userdata` varchar(4000) NOT NULL DEFAULT '',
  `connected` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`room_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chatroom_users`
--


--
-- Table structure for table `cmi_comment`
--

CREATE TABLE `cmi_comment` (
  `cmi_comment_id` int(11) NOT NULL DEFAULT '0',
  `cmi_node_id` int(11) DEFAULT NULL,
  `c_comment` longtext,
  `c_timestamp` datetime DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `sourceislms` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`cmi_comment_id`),
  KEY `i2_idx` (`cmi_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_comment`
--


--
-- Table structure for table `cmi_comment_seq`
--

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

--
-- Dumping data for table `cmi_comment_seq`
--


--
-- Table structure for table `cmi_correct_response`
--

CREATE TABLE `cmi_correct_response` (
  `cmi_correct_resp_id` int(11) NOT NULL DEFAULT '0',
  `cmi_interaction_id` int(11) DEFAULT NULL,
  `pattern` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cmi_correct_resp_id`),
  KEY `i1_idx` (`cmi_interaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_correct_response`
--


--
-- Table structure for table `cmi_correct_response_seq`
--

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

--
-- Dumping data for table `cmi_correct_response_seq`
--


--
-- Table structure for table `cmi_custom`
--

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

--
-- Dumping data for table `cmi_custom`
--


--
-- Table structure for table `cmi_gobjective`
--

CREATE TABLE `cmi_gobjective` (
  `user_id` int(11) NOT NULL,
  `satisfied` varchar(50) DEFAULT NULL,
  `measure` varchar(50) DEFAULT NULL,
  `scope_id` int(11) NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  `objective_id` varchar(253) NOT NULL,
  `score_raw` varchar(50) DEFAULT NULL,
  `score_min` varchar(50) DEFAULT NULL,
  `score_max` varchar(50) DEFAULT NULL,
  `progress_measure` varchar(50) DEFAULT NULL,
  `completion_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`scope_id`,`objective_id`),
  KEY `i2_idx` (`scope_id`,`objective_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_gobjective`
--


--
-- Table structure for table `cmi_interaction`
--

CREATE TABLE `cmi_interaction` (
  `cmi_interaction_id` int(11) NOT NULL DEFAULT '0',
  `cmi_node_id` int(11) DEFAULT NULL,
  `description` longtext,
  `id` varchar(255) DEFAULT NULL,
  `latency` varchar(20) DEFAULT NULL,
  `result` varchar(4000) DEFAULT NULL,
  `c_timestamp` varchar(20) DEFAULT NULL,
  `c_type` varchar(32) DEFAULT NULL,
  `weighting` double DEFAULT NULL,
  `learner_response` longtext,
  PRIMARY KEY (`cmi_interaction_id`),
  KEY `i2_idx` (`id`),
  KEY `i3_idx` (`c_type`),
  KEY `i4_idx` (`cmi_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_interaction`
--


--
-- Table structure for table `cmi_interaction_seq`
--

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

--
-- Dumping data for table `cmi_interaction_seq`
--


--
-- Table structure for table `cmi_node`
--

CREATE TABLE `cmi_node` (
  `accesscount` int(11) DEFAULT NULL,
  `accessduration` varchar(20) DEFAULT NULL,
  `accessed` varchar(20) DEFAULT NULL,
  `activityabsduration` varchar(20) DEFAULT NULL,
  `activityattemptcount` int(11) DEFAULT NULL,
  `activityexpduration` varchar(20) DEFAULT NULL,
  `activityprogstatus` tinyint(4) DEFAULT NULL,
  `attemptabsduration` varchar(20) DEFAULT NULL,
  `attemptcomplamount` double DEFAULT NULL,
  `attemptcomplstatus` tinyint(4) DEFAULT NULL,
  `attemptexpduration` varchar(20) DEFAULT NULL,
  `attemptprogstatus` tinyint(4) DEFAULT NULL,
  `audio_captioning` int(11) DEFAULT NULL,
  `audio_level` double DEFAULT NULL,
  `availablechildren` varchar(255) DEFAULT NULL,
  `cmi_node_id` int(11) NOT NULL DEFAULT '0',
  `completion` double DEFAULT NULL,
  `completion_status` varchar(32) DEFAULT NULL,
  `completion_threshold` varchar(32) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `created` varchar(20) DEFAULT NULL,
  `credit` varchar(32) DEFAULT NULL,
  `delivery_speed` double DEFAULT NULL,
  `c_entry` varchar(255) DEFAULT NULL,
  `c_exit` varchar(255) DEFAULT NULL,
  `c_language` varchar(5) DEFAULT NULL,
  `launch_data` longtext,
  `learner_name` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `c_max` double DEFAULT NULL,
  `c_min` double DEFAULT NULL,
  `c_mode` varchar(20) DEFAULT NULL,
  `modified` varchar(20) DEFAULT NULL,
  `progress_measure` double DEFAULT NULL,
  `c_raw` double DEFAULT NULL,
  `scaled` double DEFAULT NULL,
  `scaled_passing_score` double DEFAULT NULL,
  `session_time` varchar(20) DEFAULT NULL,
  `success_status` varchar(255) DEFAULT NULL,
  `suspend_data` longtext,
  `total_time` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `c_timestamp` datetime DEFAULT NULL,
  `additional_tables` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmi_node_id`),
  KEY `i1_idx` (`cp_node_id`),
  KEY `i2_idx` (`completion_status`),
  KEY `i3_idx` (`credit`),
  KEY `i5_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_node`
--


--
-- Table structure for table `cmi_node_seq`
--

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

--
-- Dumping data for table `cmi_node_seq`
--


--
-- Table structure for table `cmi_objective`
--

CREATE TABLE `cmi_objective` (
  `cmi_interaction_id` int(11) DEFAULT NULL,
  `cmi_node_id` int(11) DEFAULT NULL,
  `cmi_objective_id` int(11) NOT NULL DEFAULT '0',
  `description` longtext,
  `id` varchar(4000) DEFAULT NULL,
  `c_max` double DEFAULT NULL,
  `c_min` double DEFAULT NULL,
  `c_raw` double DEFAULT NULL,
  `scaled` double DEFAULT NULL,
  `progress_measure` double DEFAULT NULL,
  `success_status` varchar(32) DEFAULT NULL,
  `scope` varchar(16) DEFAULT NULL,
  `completion_status` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`cmi_objective_id`),
  KEY `i2_idx` (`cmi_interaction_id`),
  KEY `i4_idx` (`success_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmi_objective`
--


--
-- Table structure for table `cmi_objective_seq`
--

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

--
-- Dumping data for table `cmi_objective_seq`
--


--
-- Table structure for table `cmix_del_object`
--

CREATE TABLE `cmix_del_object` (
  `obj_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `activity_id` varchar(128) NOT NULL,
  `added` datetime NOT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`type_id`,`activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_del_object`
--


--
-- Table structure for table `cmix_del_user`
--

CREATE TABLE `cmix_del_user` (
  `usr_id` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `updated` datetime DEFAULT NULL,
  `obj_id` int(11) NOT NULL,
  PRIMARY KEY (`usr_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_del_user`
--


--
-- Table structure for table `cmix_lrs_types`
--

CREATE TABLE `cmix_lrs_types` (
  `type_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `availability` int(11) NOT NULL DEFAULT '1',
  `remarks` varchar(4000) DEFAULT NULL,
  `time_to_delete` int(11) DEFAULT NULL,
  `lrs_endpoint` varchar(255) NOT NULL,
  `lrs_key` varchar(128) NOT NULL,
  `lrs_secret` varchar(128) NOT NULL,
  `privacy_comment_default` varchar(2000) NOT NULL,
  `external_lrs` tinyint(4) NOT NULL DEFAULT '0',
  `force_privacy_settings` tinyint(4) NOT NULL DEFAULT '0',
  `bypass_proxy` tinyint(4) NOT NULL DEFAULT '0',
  `only_moveon` tinyint(4) NOT NULL DEFAULT '0',
  `achieved` tinyint(4) NOT NULL DEFAULT '1',
  `answered` tinyint(4) NOT NULL DEFAULT '1',
  `completed` tinyint(4) NOT NULL DEFAULT '1',
  `failed` tinyint(4) NOT NULL DEFAULT '1',
  `initialized` tinyint(4) NOT NULL DEFAULT '1',
  `passed` tinyint(4) NOT NULL DEFAULT '1',
  `progressed` tinyint(4) NOT NULL DEFAULT '1',
  `satisfied` tinyint(4) NOT NULL DEFAULT '1',
  `c_terminated` tinyint(4) NOT NULL DEFAULT '1',
  `hide_data` tinyint(4) NOT NULL DEFAULT '0',
  `c_timestamp` tinyint(4) NOT NULL DEFAULT '0',
  `duration` tinyint(4) NOT NULL DEFAULT '1',
  `no_substatements` tinyint(4) NOT NULL DEFAULT '0',
  `privacy_ident` smallint(6) NOT NULL DEFAULT '0',
  `privacy_name` smallint(6) NOT NULL DEFAULT '0',
  `delete_data` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_lrs_types`
--


--
-- Table structure for table `cmix_lrs_types_seq`
--

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

--
-- Dumping data for table `cmix_lrs_types_seq`
--


--
-- Table structure for table `cmix_results`
--

CREATE TABLE `cmix_results` (
  `id` int(11) NOT NULL,
  `obj_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `version` smallint(6) NOT NULL DEFAULT '1',
  `score` double DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT '0',
  `last_update` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_results`
--


--
-- Table structure for table `cmix_results_seq`
--

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

--
-- Dumping data for table `cmix_results_seq`
--


--
-- Table structure for table `cmix_settings`
--

CREATE TABLE `cmix_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `lrs_type_id` int(11) NOT NULL DEFAULT '0',
  `content_type` varchar(32) DEFAULT NULL,
  `source_type` varchar(32) DEFAULT NULL,
  `activity_id` varchar(255) DEFAULT NULL,
  `instructions` varchar(4000) DEFAULT NULL,
  `offline_status` tinyint(4) NOT NULL DEFAULT '1',
  `launch_url` varchar(255) DEFAULT NULL,
  `auth_fetch_url` tinyint(4) NOT NULL DEFAULT '0',
  `launch_method` varchar(32) DEFAULT NULL,
  `launch_mode` varchar(32) DEFAULT NULL,
  `mastery_score` double NOT NULL DEFAULT '0',
  `keep_lp` tinyint(4) NOT NULL DEFAULT '0',
  `usr_privacy_comment` varchar(4000) DEFAULT NULL,
  `show_statements` tinyint(4) NOT NULL DEFAULT '0',
  `xml_manifest` longtext,
  `version` int(11) NOT NULL DEFAULT '1',
  `highscore_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_achieved_ts` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_percentage` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_wtime` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_own_table` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_top_table` tinyint(4) NOT NULL DEFAULT '0',
  `highscore_top_num` int(11) NOT NULL DEFAULT '0',
  `bypass_proxy` tinyint(4) NOT NULL DEFAULT '0',
  `only_moveon` tinyint(4) NOT NULL DEFAULT '0',
  `achieved` tinyint(4) NOT NULL DEFAULT '1',
  `answered` tinyint(4) NOT NULL DEFAULT '1',
  `completed` tinyint(4) NOT NULL DEFAULT '1',
  `failed` tinyint(4) NOT NULL DEFAULT '1',
  `initialized` tinyint(4) NOT NULL DEFAULT '1',
  `passed` tinyint(4) NOT NULL DEFAULT '1',
  `progressed` tinyint(4) NOT NULL DEFAULT '1',
  `satisfied` tinyint(4) NOT NULL DEFAULT '1',
  `c_terminated` tinyint(4) NOT NULL DEFAULT '1',
  `hide_data` tinyint(4) NOT NULL DEFAULT '0',
  `c_timestamp` tinyint(4) NOT NULL DEFAULT '0',
  `duration` tinyint(4) NOT NULL DEFAULT '1',
  `no_substatements` tinyint(4) NOT NULL DEFAULT '0',
  `privacy_ident` smallint(6) NOT NULL DEFAULT '0',
  `privacy_name` smallint(6) NOT NULL DEFAULT '0',
  `publisher_id` varchar(255) NOT NULL DEFAULT '',
  `anonymous_homepage` tinyint(4) NOT NULL DEFAULT '1',
  `moveon` varchar(32) NOT NULL DEFAULT '',
  `launch_parameters` varchar(255) NOT NULL DEFAULT '',
  `entitlement_key` varchar(255) NOT NULL DEFAULT '',
  `switch_to_review` tinyint(4) NOT NULL DEFAULT '1',
  `delete_data` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_settings`
--


--
-- Table structure for table `cmix_token`
--

CREATE TABLE `cmix_token` (
  `token` varchar(255) NOT NULL DEFAULT '0',
  `valid_until` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `lrs_type_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `cmi5_session` varchar(255) NOT NULL DEFAULT '',
  `returned_for_cmi5_session` varchar(255) NOT NULL DEFAULT '',
  `cmi5_session_data` longtext,
  PRIMARY KEY (`token`),
  UNIQUE KEY `c1_idx` (`obj_id`,`usr_id`),
  KEY `i1_idx` (`token`,`valid_until`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_token`
--


--
-- Table structure for table `cmix_users`
--

CREATE TABLE `cmix_users` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `proxy_success` tinyint(4) NOT NULL DEFAULT '0',
  `fetched_until` datetime DEFAULT NULL,
  `usr_ident` varchar(255) DEFAULT NULL,
  `privacy_ident` smallint(6) NOT NULL DEFAULT '0',
  `registration` varchar(255) NOT NULL DEFAULT '',
  `satisfied` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`,`privacy_ident`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cmix_users`
--


--
-- Table structure for table `conditions`
--

CREATE TABLE `conditions` (
  `condition_id` int(11) NOT NULL DEFAULT '0',
  `target_ref_id` int(11) NOT NULL DEFAULT '0',
  `target_obj_id` int(11) NOT NULL DEFAULT '0',
  `target_type` varchar(8) DEFAULT NULL,
  `trigger_ref_id` int(11) NOT NULL DEFAULT '0',
  `trigger_obj_id` int(11) NOT NULL DEFAULT '0',
  `trigger_type` varchar(8) DEFAULT NULL,
  `operator` varchar(64) DEFAULT NULL,
  `value` varchar(64) DEFAULT NULL,
  `ref_handling` tinyint(4) NOT NULL DEFAULT '1',
  `obligatory` tinyint(4) NOT NULL DEFAULT '1',
  `num_obligatory` tinyint(4) NOT NULL DEFAULT '0',
  `hidden_status` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`condition_id`),
  KEY `tot_idx` (`target_obj_id`,`target_type`),
  KEY `i1_idx` (`target_obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `conditions`
--


--
-- Table structure for table `conditions_seq`
--

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

--
-- Dumping data for table `conditions_seq`
--


--
-- Table structure for table `cont_filter_field`
--

CREATE TABLE `cont_filter_field` (
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `record_set_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cont_filter_field`
--


--
-- Table structure for table `cont_member_skills`
--

CREATE TABLE `cont_member_skills` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `tref_id` int(11) NOT NULL DEFAULT '0',
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `level_id` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`user_id`,`skill_id`,`tref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cont_member_skills`
--


--
-- Table structure for table `cont_skills`
--

CREATE TABLE `cont_skills` (
  `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 (`id`,`skill_id`,`tref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cont_skills`
--


--
-- Table structure for table `container_reference`
--

CREATE TABLE `container_reference` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `target_obj_id` int(11) NOT NULL DEFAULT '0',
  `title_type` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`obj_id`,`target_obj_id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `container_reference`
--


--
-- Table structure for table `container_settings`
--

CREATE TABLE `container_settings` (
  `id` int(11) NOT NULL DEFAULT '0',
  `keyword` char(40) NOT NULL DEFAULT '',
  `value` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`,`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `container_settings`
--


--
-- Table structure for table `container_sorting`
--

CREATE TABLE `container_sorting` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `child_id` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `parent_type` varchar(5) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`child_id`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `container_sorting`
--


--
-- Table structure for table `container_sorting_bl`
--

CREATE TABLE `container_sorting_bl` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `block_ids` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `container_sorting_bl`
--


--
-- Table structure for table `container_sorting_set`
--

CREATE TABLE `container_sorting_set` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `sort_mode` tinyint(4) NOT NULL DEFAULT '0',
  `sort_direction` tinyint(4) NOT NULL DEFAULT '0',
  `new_items_position` tinyint(4) NOT NULL DEFAULT '1',
  `new_items_order` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `container_sorting_set`
--


--
-- Table structure for table `content_object`
--

CREATE TABLE `content_object` (
  `id` int(11) NOT NULL DEFAULT '0',
  `default_layout` varchar(100) DEFAULT 'toc2win',
  `stylesheet` int(11) NOT NULL DEFAULT '0',
  `page_header` char(8) DEFAULT 'st_title',
  `is_online` char(1) DEFAULT 'n',
  `toc_active` char(1) DEFAULT 'y',
  `lm_menu_active` char(1) DEFAULT 'y',
  `toc_mode` char(8) DEFAULT 'chapters',
  `clean_frames` char(1) DEFAULT 'n',
  `print_view_active` char(1) DEFAULT 'y',
  `numbering` char(1) DEFAULT 'n',
  `hist_user_comments` char(1) DEFAULT 'n',
  `public_access_mode` char(8) DEFAULT 'complete',
  `public_html_file` varchar(50) DEFAULT NULL,
  `public_xml_file` varchar(50) DEFAULT NULL,
  `downloads_active` char(1) DEFAULT 'n',
  `downloads_public_active` char(1) DEFAULT 'y',
  `header_page` int(11) NOT NULL DEFAULT '0',
  `footer_page` int(11) NOT NULL DEFAULT '0',
  `no_glo_appendix` char(1) DEFAULT 'n',
  `layout_per_page` tinyint(4) DEFAULT NULL,
  `public_scorm_file` varchar(50) DEFAULT NULL,
  `rating` tinyint(4) NOT NULL DEFAULT '0',
  `hide_head_foot_print` tinyint(4) NOT NULL DEFAULT '0',
  `disable_def_feedback` int(11) NOT NULL DEFAULT '0',
  `rating_pages` tinyint(4) DEFAULT '0',
  `progr_icons` tinyint(4) NOT NULL DEFAULT '0',
  `store_tries` tinyint(4) NOT NULL DEFAULT '0',
  `restrict_forw_nav` tinyint(4) NOT NULL DEFAULT '0',
  `for_translation` tinyint(4) NOT NULL DEFAULT '0',
  `act_est_reading_time` tinyint(4) NOT NULL DEFAULT '0',
  `est_reading_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_object`
--


--
-- Table structure for table `content_page_data`
--

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

--
-- Dumping data for table `content_page_data`
--


--
-- Table structure for table `content_page_metrics`
--

CREATE TABLE `content_page_metrics` (
  `content_page_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(2) NOT NULL DEFAULT '-',
  `reading_time` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`content_page_id`,`page_id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_page_metrics`
--


--
-- Table structure for table `copg_multilang`
--

CREATE TABLE `copg_multilang` (
  `parent_type` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `master_lang` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`parent_type`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copg_multilang`
--


--
-- Table structure for table `copg_multilang_lang`
--

CREATE TABLE `copg_multilang_lang` (
  `parent_type` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`parent_type`,`parent_id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copg_multilang_lang`
--


--
-- Table structure for table `copg_pc_def`
--

CREATE TABLE `copg_pc_def` (
  `pc_type` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(40) NOT NULL DEFAULT '',
  `directory` varchar(40) DEFAULT NULL,
  `int_links` tinyint(4) NOT NULL DEFAULT '0',
  `style_classes` tinyint(4) NOT NULL DEFAULT '0',
  `xsl` tinyint(4) NOT NULL DEFAULT '0',
  `component` varchar(40) DEFAULT NULL,
  `def_enabled` tinyint(4) DEFAULT '0',
  `top_item` tinyint(4) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pc_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copg_pc_def`
--

INSERT INTO `copg_pc_def` VALUES ('amdfrm','AMDForm','Page',0,0,0,'Modules/Portfolio',0,1,139),('amdpl','AMDPageList','classes',0,0,0,'Modules/Wiki',0,1,240),('blog','Blog','PC/Blog',0,0,0,'Services/COPage',0,1,100),('cach','ConsultationHours','Page',0,0,0,'Modules/Portfolio',0,1,138),('contpop','ContentPopup','PC/InteractiveImage',0,0,0,'Services/COPage',1,0,0),('dtab','DataTable','PC/Table',0,1,0,'Services/COPage',1,1,50),('flit','FileItem','PC/FileList',0,1,0,'Services/COPage',1,0,0),('flst','FileList','PC/FileList',0,1,0,'Services/COPage',1,1,40),('gcell','GridCell','PC/Grid',0,0,0,'Services/COPage',1,0,0),('grid','Grid','PC/Grid',0,0,0,'Services/COPage',1,1,67),('iim','InteractiveImage','classes',1,1,0,'Services/COPage',1,1,100),('incl','ContentInclude','PC/ContentInclude',1,1,0,'Services/COPage',0,1,110),('lay','LayoutTemplate','PC/LayoutTemplate',0,0,0,'Services/COPage',0,1,195),('lhist','LearningHistory','classes',0,0,0,'Services/LearningHistory',0,1,136),('li','ListItem','PC/List',0,0,0,'Services/COPage',1,0,0),('list','List','PC/List',0,1,0,'Services/COPage',1,1,220),('lpe','LoginPageElement','PC/Login',0,0,0,'Services/COPage',0,1,120),('lsocurriculum','Curriculum','classes/PageEditor',0,0,0,'Modules/LearningSequence',0,1,127),('lsostartbutton','Launcher','classes/PageEditor',0,0,0,'Modules/LearningSequence',0,1,127),('map','Map','PC/Map',0,0,0,'Services/COPage',0,1,280),('mcrs','MyCourses','Page',0,0,0,'Modules/Portfolio',0,1,137),('media','MediaObject','PC/MediaObject',0,1,0,'Services/COPage',1,1,20),('par','Paragraph','PC/Paragraph',1,1,0,'Services/COPage',1,1,10),('pcqst','Question','PC/Question',0,0,0,'Services/COPage',0,1,55),('plach','PlaceHolder','PC/PlaceHolder',0,1,0,'Services/COPage',0,1,5),('plug','Plugged','classes',0,0,0,'Services/COPage',0,1,210),('prgactionnote','PRGActionNote','classes/PageEditor',0,0,0,'Modules/StudyProgramme',0,1,128),('prgstatusinfo','PRGStatusInfo','classes/PageEditor',0,0,0,'Modules/StudyProgramme',0,1,127),('prof','Profile','PC/Profile',0,0,0,'Services/COPage',0,1,130),('repobj','Resources','PC/Resources',0,0,0,'Services/COPage',0,1,150),('sec','Section','PC/Section',0,1,0,'Services/COPage',1,1,60),('skills','Skills','PC/Skills',0,0,0,'Services/COPage',0,1,160),('src','SourceCode','PC/SourceCode',0,0,0,'Services/COPage',1,1,190),('tab','Table','PC/Table',0,1,0,'Services/COPage',1,1,200),('tabs','Tabs','PC/Tabs',0,1,0,'Services/COPage',1,1,65),('tabstab','Tab','PC/Tabs',0,0,0,'Services/COPage',1,0,0),('td','TableData','PC/Table',0,0,0,'Services/COPage',1,0,0),('templ','ContentTemplate','PC/ContentTemplate',0,0,0,'Services/COPage',0,1,200),('vrfc','Verification','PC/Verification',0,0,0,'Services/COPage',0,1,180);

--
-- Table structure for table `copg_pobj_def`
--

CREATE TABLE `copg_pobj_def` (
  `parent_type` varchar(20) NOT NULL DEFAULT '',
  `class_name` varchar(80) NOT NULL DEFAULT '',
  `directory` varchar(40) DEFAULT NULL,
  `component` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`parent_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copg_pobj_def`
--

INSERT INTO `copg_pobj_def` VALUES ('auth','ilLoginPage','classes','Services/Authentication'),('blp','ilBlogPosting','classes','Modules/Blog'),('cont','ilContainerPage','Page','Services/Container'),('copa','ilContentPagePage','classes','Modules/ContentPage'),('cstr','ilContainerStartObjectsPage','StartObjects','Services/Container'),('dclf','ilDclDetailedViewDefinition','classes/DetailedView','Modules/DataCollection'),('frm','ilForumPage','classes/CoPage','Modules/Forum'),('impr','ilImprint','classes','Services/Imprint'),('lm','ilLMPage','classes','Modules/LearningModule'),('lobj','ilLOPage','classes/Objectives','Modules/Course'),('lsoe','ilLSOExtroPage','classes/PageEditor','Modules/LearningSequence'),('lsoi','ilLSOIntroPage','classes/PageEditor','Modules/LearningSequence'),('mep','ilMediaPoolPage','classes','Modules/MediaPool'),('prtf','ilPortfolioPage','Page','Modules/Portfolio'),('prtt','ilPortfolioTemplatePage','Template','Modules/Portfolio'),('qfbg','ilAssGenFeedbackPage','classes/feedback','Modules/TestQuestionPool'),('qfbs','ilAssSpecFeedbackPage','classes/feedback','Modules/TestQuestionPool'),('qht','ilAssHintPage','classes','Modules/TestQuestionPool'),('qpl','ilAssQuestionPage','classes','Modules/TestQuestionPool'),('sahs','ilSCORM2004Page','classes','Modules/Scorm2004'),('stys','ilPageLayoutPage','Layout/classes','Services/COPage'),('term','ilGlossaryDefPage','classes','Modules/Glossary'),('tst','ilTestPage','classes/PageEditor','Modules/Test'),('wpg','ilWikiPage','classes','Modules/Wiki');

--
-- Table structure for table `copg_section_timings`
--

CREATE TABLE `copg_section_timings` (
  `page_id` int(11) NOT NULL DEFAULT '0',
  `parent_type` varchar(10) NOT NULL DEFAULT '',
  `unix_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`,`parent_type`,`unix_ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copg_section_timings`
--


--
-- Table structure for table `copy_wizard_options`
--

CREATE TABLE `copy_wizard_options` (
  `copy_id` int(11) NOT NULL DEFAULT '0',
  `source_id` int(11) NOT NULL DEFAULT '0',
  `options` longtext,
  PRIMARY KEY (`copy_id`,`source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `copy_wizard_options`
--


--
-- Table structure for table `cp_auxilaryresource`
--

CREATE TABLE `cp_auxilaryresource` (
  `auxiliaryresourceid` varchar(255) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `purpose` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_auxilaryresource`
--


--
-- Table structure for table `cp_condition`
--

CREATE TABLE `cp_condition` (
  `c_condition` varchar(50) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `measurethreshold` varchar(50) DEFAULT NULL,
  `c_operator` varchar(50) DEFAULT NULL,
  `referencedobjective` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_condition`
--


--
-- Table structure for table `cp_datamap`
--

CREATE TABLE `cp_datamap` (
  `sco_node_id` int(11) NOT NULL DEFAULT '0',
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `slm_id` int(11) NOT NULL DEFAULT '0',
  `target_id` varchar(4000) NOT NULL DEFAULT '',
  `read_shared_data` tinyint(4) DEFAULT '1',
  `write_shared_data` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`cp_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_datamap`
--


--
-- Table structure for table `cp_dependency`
--

CREATE TABLE `cp_dependency` (
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `resourceid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i2_idx` (`resourceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_dependency`
--


--
-- Table structure for table `cp_file`
--

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

--
-- Dumping data for table `cp_file`
--


--
-- Table structure for table `cp_hidelmsui`
--

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

--
-- Dumping data for table `cp_hidelmsui`
--


--
-- Table structure for table `cp_item`
--

CREATE TABLE `cp_item` (
  `completionthreshold` varchar(50) DEFAULT '1.0',
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `datafromlms` varchar(4000) DEFAULT NULL,
  `id` varchar(200) DEFAULT NULL,
  `isvisible` varchar(32) DEFAULT NULL,
  `parameters` varchar(255) DEFAULT NULL,
  `resourceid` varchar(200) DEFAULT NULL,
  `sequencingid` varchar(50) DEFAULT NULL,
  `timelimitaction` varchar(30) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `progressweight` varchar(50) DEFAULT '1.0',
  `completedbymeasure` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`id`),
  KEY `i2_idx` (`sequencingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_item`
--


--
-- Table structure for table `cp_manifest`
--

CREATE TABLE `cp_manifest` (
  `base` varchar(200) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `defaultorganization` varchar(255) DEFAULT NULL,
  `id` varchar(200) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `version` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_manifest`
--


--
-- Table structure for table `cp_mapinfo`
--

CREATE TABLE `cp_mapinfo` (
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `readnormalmeasure` tinyint(4) DEFAULT NULL,
  `readsatisfiedstatus` tinyint(4) DEFAULT NULL,
  `targetobjectiveid` varchar(255) DEFAULT NULL,
  `writenormalmeasure` tinyint(4) DEFAULT NULL,
  `writesatisfiedstatus` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`targetobjectiveid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_mapinfo`
--


--
-- Table structure for table `cp_node`
--

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

--
-- Dumping data for table `cp_node`
--


--
-- Table structure for table `cp_node_seq`
--

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

--
-- Dumping data for table `cp_node_seq`
--


--
-- Table structure for table `cp_objective`
--

CREATE TABLE `cp_objective` (
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `minnormalmeasure` varchar(50) DEFAULT NULL,
  `objectiveid` varchar(200) DEFAULT NULL,
  `c_primary` tinyint(4) DEFAULT NULL,
  `satisfiedbymeasure` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_objective`
--


--
-- Table structure for table `cp_organization`
--

CREATE TABLE `cp_organization` (
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `id` varchar(200) DEFAULT NULL,
  `objectivesglobtosys` tinyint(4) DEFAULT NULL,
  `sequencingid` varchar(50) DEFAULT NULL,
  `structure` varchar(200) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`id`),
  KEY `i2_idx` (`sequencingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_organization`
--


--
-- Table structure for table `cp_package`
--

CREATE TABLE `cp_package` (
  `created` varchar(20) DEFAULT NULL,
  `c_identifier` varchar(255) DEFAULT NULL,
  `jsdata` longtext,
  `modified` varchar(20) DEFAULT NULL,
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `persistprevattempts` int(11) DEFAULT NULL,
  `c_settings` varchar(255) DEFAULT NULL,
  `xmldata` longtext,
  `activitytree` longtext,
  `global_to_system` tinyint(4) NOT NULL DEFAULT '1',
  `shared_data_global_to_system` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`c_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_package`
--


--
-- Table structure for table `cp_resource`
--

CREATE TABLE `cp_resource` (
  `base` varchar(4000) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `href` varchar(4000) DEFAULT NULL,
  `id` varchar(200) DEFAULT NULL,
  `scormtype` varchar(32) DEFAULT NULL,
  `c_type` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_resource`
--


--
-- Table structure for table `cp_rule`
--

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

--
-- Dumping data for table `cp_rule`
--


--
-- Table structure for table `cp_sequencing`
--

CREATE TABLE `cp_sequencing` (
  `activityabsdurlimit` varchar(20) DEFAULT NULL,
  `activityexpdurlimit` varchar(20) DEFAULT NULL,
  `attemptabsdurlimit` varchar(20) DEFAULT NULL,
  `attemptexpdurlimit` varchar(20) DEFAULT NULL,
  `attemptlimit` int(11) DEFAULT NULL,
  `begintimelimit` varchar(20) DEFAULT NULL,
  `choice` tinyint(4) DEFAULT NULL,
  `choiceexit` tinyint(4) DEFAULT NULL,
  `completionbycontent` tinyint(4) DEFAULT NULL,
  `constrainchoice` tinyint(4) DEFAULT NULL,
  `cp_node_id` int(11) NOT NULL DEFAULT '0',
  `endtimelimit` varchar(20) DEFAULT NULL,
  `flow` tinyint(4) DEFAULT NULL,
  `forwardonly` tinyint(4) DEFAULT NULL,
  `id` varchar(200) DEFAULT NULL,
  `measuresatisfactive` tinyint(4) DEFAULT NULL,
  `objectivemeasweight` double DEFAULT NULL,
  `objectivebycontent` tinyint(4) DEFAULT NULL,
  `preventactivation` tinyint(4) DEFAULT NULL,
  `randomizationtiming` varchar(50) DEFAULT NULL,
  `reorderchildren` tinyint(4) DEFAULT NULL,
  `requiredcompleted` varchar(50) DEFAULT NULL,
  `requiredincomplete` varchar(50) DEFAULT NULL,
  `requirednotsatisfied` varchar(50) DEFAULT NULL,
  `requiredforsatisfied` varchar(50) DEFAULT NULL,
  `rollupobjectivesatis` tinyint(4) DEFAULT NULL,
  `rollupprogcompletion` tinyint(4) DEFAULT NULL,
  `selectcount` int(11) DEFAULT NULL,
  `selectiontiming` varchar(50) DEFAULT NULL,
  `sequencingid` varchar(50) DEFAULT NULL,
  `tracked` tinyint(4) DEFAULT NULL,
  `usecurattemptobjinfo` tinyint(4) DEFAULT NULL,
  `usecurattemptproginfo` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`cp_node_id`),
  KEY `i1_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_sequencing`
--


--
-- Table structure for table `cp_suspend`
--

CREATE TABLE `cp_suspend` (
  `data` longtext,
  `user_id` int(11) NOT NULL,
  `obj_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cp_suspend`
--


--
-- Table structure for table `cp_tree`
--

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

--
-- Dumping data for table `cp_tree`
--


--
-- Table structure for table `cron_job`
--

CREATE TABLE `cron_job` (
  `job_id` varchar(50) NOT NULL DEFAULT '',
  `component` varchar(200) DEFAULT NULL,
  `schedule_type` tinyint(4) DEFAULT NULL,
  `schedule_value` int(11) DEFAULT NULL,
  `job_status` tinyint(4) DEFAULT NULL,
  `job_status_user_id` int(11) DEFAULT NULL,
  `job_status_type` tinyint(4) DEFAULT NULL,
  `job_status_ts` int(11) DEFAULT NULL,
  `job_result_status` tinyint(4) DEFAULT NULL,
  `job_result_user_id` int(11) DEFAULT NULL,
  `job_result_code` varchar(64) DEFAULT NULL,
  `job_result_message` varchar(400) DEFAULT NULL,
  `job_result_type` tinyint(4) DEFAULT NULL,
  `job_result_ts` int(11) DEFAULT NULL,
  `class` varchar(255) DEFAULT NULL,
  `path` varchar(400) DEFAULT NULL,
  `running_ts` int(11) DEFAULT NULL,
  `job_result_dur` int(11) DEFAULT NULL,
  `alive_ts` int(11) DEFAULT NULL,
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cron_job`
--

INSERT INTO `cron_job` VALUES ('auth_destroy_expired_sessions','Services/Authentication',3,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilAuthDestroyExpiredSessionsCron',NULL,NULL,NULL,NULL),('book_notification','Modules/BookingManager',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilBookCronNotification',NULL,NULL,NULL,NULL),('book_pref_book','Modules/BookingManager',1,NULL,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilBookingPrefBookCron',NULL,NULL,NULL,NULL),('cal_consultation','Services/Calendar',0,0,0,0,0,0,0,0,'','',0,0,'ilConsultationHourCron','Services/Calendar/classes/ConsultationHours/',0,0,0),('cal_remote_reader','Services/Calendar',2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCalendarCronRemoteReader','Services/Calendar/classes/Cron/',NULL,NULL,NULL),('certificate','Services/Certificate',2,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilCertificateCron',NULL,NULL,NULL,NULL),('copg_history_cleanup','Services/COPage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCleanCOPageHistoryCronjob','Services/COPage/Cron',NULL,NULL,NULL),('crs_timings_reminder','Modules/Course',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilTimingsCronReminder',NULL,NULL,NULL,NULL),('ecs_task_handler','Services/WebServices',3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCronEcsTaskScheduler',NULL,NULL,NULL,NULL),('exc_feedback_notification','Modules/Exercise',0,0,1,0,0,1381511097,0,0,'','',0,0,'ilExcCronFeedbackNotification',NULL,0,0,0),('exc_reminders','Modules/Exercise',1,NULL,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilExcCronReminders',NULL,NULL,NULL,NULL),('file_system_clean_temp_dir','Services/FileSystem',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilFileSystemCleanTempDirCron',NULL,NULL,NULL,NULL),('finish_unfinished_passes','Modules/Test',1,0,0,0,0,0,0,0,'','',0,0,'ilCronFinishUnfinishedTestPasses',NULL,0,0,0),('frm_notification','Modules/Forum',3,1,0,0,0,0,0,0,'','',0,0,'ilForumCronNotification',NULL,0,0,0),('ldap_sync','Services/LDAP',0,0,0,0,0,0,0,0,'','',0,0,'ilLDAPCronSynchronization',NULL,0,0,0),('log_error_file_cleanup','Services/Logging',4,10,0,0,0,0,0,0,'','',0,0,'ilLoggerCronCleanErrorFiles','Services/Logging/classes/error/',0,0,0),('lp_object_statistics','Services/Tracking',0,0,1,0,0,1381511103,0,0,'','',0,0,'ilLPCronObjectStatistics',NULL,0,0,0),('lti_outcome','Services/LTI',2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilLTICronOutcomeService',NULL,NULL,NULL,NULL),('mail_notification','Services/Mail',0,0,1,6,1,1481898063,NULL,6,'job_manual_reset','Cron job re-activated by admin',1,0,'ilMailCronNotification',NULL,0,0,0),('mail_orphaned_mails','Services/Mail',1,1,0,0,0,0,0,0,'','',0,0,'ilMailCronOrphanedMails',NULL,0,0,0),('mem_min_members','Services/Membership',0,0,1,0,0,1443610661,0,0,'','',0,0,'ilMembershipCronMinMembers','Services/Membership/classes/Cron',0,0,0),('mem_notification','Services/Membership',1,0,0,0,0,0,0,0,'','',0,0,'ilMembershipCronNotifications','Services/Membership/classes/Cron',0,0,0),('meta_oer_harvester','Services/MetaData',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCronOerHarvester',NULL,NULL,NULL,NULL),('orgunit_paths','Modules/OrgUnit',1,0,1,0,0,1472816001,0,0,'','',0,0,'ilCronUpdateOrgUnitPaths',NULL,0,0,0),('prg_invalidate_expired_progresses','Modules/StudyProgramme',4,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilPrgInvalidateExpiredProgressesCronJob',NULL,NULL,NULL,NULL),('prg_restart_assignments_temporal_progress','Modules/StudyProgramme',4,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilPrgRestartAssignmentsCronJob',NULL,NULL,NULL,NULL),('prg_update_progress','Modules/StudyProgramme',4,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilPrgUpdateProgressCronJob',NULL,NULL,NULL,NULL),('prg_user_not_restarted','Modules/StudyProgramme',4,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilPrgUserNotRestartedCronJob',NULL,NULL,NULL,NULL),('prg_user_risky_to_fail','Modules/StudyProgramme',4,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilPrgUserRiskyToFailCronJob',NULL,NULL,NULL,NULL),('skll_notification','Services/Skill',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilSkillNotifications',NULL,NULL,NULL,NULL),('src_lucene_indexer','Services/Search',1,0,0,0,0,0,0,0,'','',0,0,'ilLuceneIndexer','Services/Search/classes/Lucene/',0,0,0),('survey_notification','Modules/Survey',0,0,1,0,0,1381511099,0,0,'','',0,0,'ilSurveyCronNotification',NULL,0,0,0),('sysc_trash','Services/SystemCheck',5,1,0,0,0,0,0,0,'','',0,0,'ilSCCronTrash',NULL,0,0,0),('user_check_accounts','Services/User',0,0,0,0,0,0,0,0,'','',0,0,'ilUserCronCheckAccounts',NULL,0,0,0),('user_inactivated','Services/User',1,0,0,0,0,0,0,0,'','',0,0,'ilCronDeleteInactivatedUserAccounts',NULL,0,0,0),('user_inactive','Services/User',1,0,0,0,0,0,0,0,'','',0,0,'ilCronDeleteInactiveUserAccounts',NULL,0,0,0),('user_never_logged_in','Services/User',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCronDeleteNeverLoggedInUserAccounts',NULL,NULL,NULL,NULL),('wopi_crawler','Services/WOPI',5,1,1,0,0,1702399177,NULL,NULL,NULL,NULL,NULL,NULL,'ilWOPICrawler',NULL,NULL,NULL,NULL),('xapi_deletion_cron','Modules/CmiXapi',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilCmiXapiDelCron',NULL,NULL,NULL,NULL),('xapi_results_evaluation','Modules/CmiXapi',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ilXapiResultsCronjob',NULL,NULL,NULL,NULL);

--
-- Table structure for table `crs_archives`
--

CREATE TABLE `crs_archives` (
  `archive_id` int(11) NOT NULL DEFAULT '0',
  `course_id` int(11) NOT NULL DEFAULT '0',
  `archive_name` varchar(255) DEFAULT NULL,
  `archive_type` tinyint(4) NOT NULL DEFAULT '0',
  `archive_date` int(11) DEFAULT NULL,
  `archive_size` int(11) DEFAULT NULL,
  `archive_lang` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`archive_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_archives`
--


--
-- Table structure for table `crs_archives_seq`
--

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

--
-- Dumping data for table `crs_archives_seq`
--


--
-- Table structure for table `crs_f_definitions`
--

CREATE TABLE `crs_f_definitions` (
  `field_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `field_name` varchar(255) DEFAULT NULL,
  `field_type` tinyint(4) NOT NULL DEFAULT '0',
  `field_values` longtext,
  `field_required` tinyint(4) NOT NULL DEFAULT '0',
  `field_values_opt` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_f_definitions`
--


--
-- Table structure for table `crs_f_definitions_seq`
--

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

--
-- Dumping data for table `crs_f_definitions_seq`
--


--
-- Table structure for table `crs_file`
--

CREATE TABLE `crs_file` (
  `file_id` int(11) NOT NULL DEFAULT '0',
  `course_id` int(11) NOT NULL DEFAULT '0',
  `file_name` char(64) DEFAULT NULL,
  `file_type` char(64) DEFAULT NULL,
  `file_size` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_file`
--


--
-- Table structure for table `crs_file_seq`
--

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

--
-- Dumping data for table `crs_file_seq`
--


--
-- Table structure for table `crs_groupings`
--

CREATE TABLE `crs_groupings` (
  `crs_grp_id` int(11) NOT NULL DEFAULT '0',
  `crs_ref_id` int(11) NOT NULL DEFAULT '0',
  `crs_id` int(11) NOT NULL DEFAULT '0',
  `unique_field` char(32) DEFAULT NULL,
  PRIMARY KEY (`crs_grp_id`),
  KEY `i1_idx` (`crs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_groupings`
--


--
-- Table structure for table `crs_items`
--

CREATE TABLE `crs_items` (
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `timing_type` tinyint(4) DEFAULT NULL,
  `timing_start` int(11) NOT NULL DEFAULT '0',
  `timing_end` int(11) NOT NULL DEFAULT '0',
  `suggestion_start` int(11) NOT NULL DEFAULT '0',
  `suggestion_end` int(11) NOT NULL DEFAULT '0',
  `changeable` tinyint(4) NOT NULL DEFAULT '0',
  `visible` tinyint(4) NOT NULL DEFAULT '0',
  `position` int(11) DEFAULT NULL,
  `suggestion_start_rel` int(11) DEFAULT '0',
  `suggestion_end_rel` int(11) DEFAULT '0',
  PRIMARY KEY (`parent_id`,`obj_id`),
  KEY `ob_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_items`
--

INSERT INTO `crs_items` VALUES (1,9,1,1450792127,1450792127,1450792127,1450792127,0,0,0,0,0),(9,8,1,1450792127,1450792127,1450792127,1450792127,0,0,0,0,0),(9,12,1,1481898045,1481898045,1481898045,1481898045,0,0,0,0,0),(9,16,1,1450795974,1450795974,1450795974,1450795974,0,0,0,0,0),(9,17,1,1481897710,1481897710,1481897710,1481897710,0,0,0,0,0),(9,18,1,1450795859,1450795859,1450795859,1450795859,0,0,0,0,0),(9,22,1,1450796001,1450796001,1450796001,1450796001,0,0,0,0,0),(9,23,1,1450795847,1450795847,1450795847,1450795847,0,0,0,0,0),(9,29,1,1450795894,1450795894,1450795894,1450795894,0,0,0,0,0),(9,30,1,1450796011,1450796011,1450796011,1450796011,0,0,0,0,0),(9,32,1,1481899353,1481899353,1481899353,1481899353,0,0,0,0,0),(9,34,1,1482324927,1482324927,1482324927,1482324927,0,0,0,0,0),(9,36,1,1481898367,1481898367,1481898367,1481898367,0,0,0,0,0),(9,37,1,1450796232,1450796232,1450796232,1450796232,0,0,0,0,0),(9,39,1,1481899398,1481899398,1481899398,1481899398,0,0,0,0,0),(9,52,1,1450795488,1450795488,1450795488,1450795488,0,0,0,0,0),(9,53,1,1450796052,1450796052,1450796052,1450796052,0,0,0,0,0),(9,55,1,1481899451,1481899451,1481899451,1481899451,0,0,0,0,0),(9,57,1,1450796335,1450796335,1450796335,1450796335,0,0,0,0,0),(9,64,1,1450795969,1450795969,1450795969,1450795969,0,0,0,0,0);

--
-- Table structure for table `crs_lm_history`
--

CREATE TABLE `crs_lm_history` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `crs_ref_id` int(11) NOT NULL DEFAULT '0',
  `lm_ref_id` int(11) NOT NULL DEFAULT '0',
  `lm_page_id` int(11) NOT NULL DEFAULT '0',
  `last_access` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`crs_ref_id`,`lm_ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_lm_history`
--


--
-- Table structure for table `crs_objective_lm`
--

CREATE TABLE `crs_objective_lm` (
  `lm_ass_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `type` char(6) DEFAULT NULL,
  `position` int(11) DEFAULT '0',
  PRIMARY KEY (`lm_ass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_objective_lm`
--


--
-- Table structure for table `crs_objective_lm_seq`
--

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

--
-- Dumping data for table `crs_objective_lm_seq`
--


--
-- Table structure for table `crs_objective_qst`
--

CREATE TABLE `crs_objective_qst` (
  `qst_ass_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `question_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`qst_ass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_objective_qst`
--


--
-- Table structure for table `crs_objective_qst_seq`
--

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

--
-- Dumping data for table `crs_objective_qst_seq`
--


--
-- Table structure for table `crs_objective_status`
--

CREATE TABLE `crs_objective_status` (
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`objective_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_objective_status`
--


--
-- Table structure for table `crs_objective_status_p`
--

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

--
-- Dumping data for table `crs_objective_status_p`
--


--
-- Table structure for table `crs_objective_tst`
--

CREATE TABLE `crs_objective_tst` (
  `test_objective_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `tst_status` tinyint(4) DEFAULT NULL,
  `tst_limit` tinyint(4) DEFAULT NULL,
  `tst_limit_p` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`test_objective_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_objective_tst`
--


--
-- Table structure for table `crs_objective_tst_seq`
--

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

--
-- Dumping data for table `crs_objective_tst_seq`
--


--
-- Table structure for table `crs_objectives`
--

CREATE TABLE `crs_objectives` (
  `crs_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(70) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(4) DEFAULT '1',
  `passes` smallint(6) DEFAULT '0',
  PRIMARY KEY (`objective_id`),
  KEY `i1_idx` (`crs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_objectives`
--


--
-- Table structure for table `crs_objectives_seq`
--

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

--
-- Dumping data for table `crs_objectives_seq`
--


--
-- Table structure for table `crs_reference_settings`
--

CREATE TABLE `crs_reference_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `member_update` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_reference_settings`
--


--
-- Table structure for table `crs_settings`
--

CREATE TABLE `crs_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `syllabus` varchar(4000) DEFAULT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `contact_responsibility` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_consultation` varchar(4000) DEFAULT NULL,
  `activation_type` tinyint(4) NOT NULL DEFAULT '0',
  `activation_start` int(11) DEFAULT NULL,
  `activation_end` int(11) DEFAULT NULL,
  `sub_limitation_type` tinyint(4) NOT NULL DEFAULT '0',
  `sub_start` int(11) DEFAULT NULL,
  `sub_end` int(11) DEFAULT NULL,
  `sub_type` int(11) DEFAULT NULL,
  `sub_password` varchar(32) DEFAULT NULL,
  `sub_mem_limit` tinyint(4) NOT NULL DEFAULT '0',
  `sub_max_members` int(11) DEFAULT NULL,
  `sub_notify` int(11) DEFAULT NULL,
  `view_mode` tinyint(4) NOT NULL DEFAULT '0',
  `sortorder` int(11) DEFAULT NULL,
  `archive_start` int(11) DEFAULT NULL,
  `archive_end` int(11) DEFAULT NULL,
  `archive_type` int(11) DEFAULT NULL,
  `abo` tinyint(4) DEFAULT '1',
  `waiting_list` tinyint(4) NOT NULL DEFAULT '1',
  `important` varchar(4000) DEFAULT NULL,
  `show_members` tinyint(4) NOT NULL DEFAULT '1',
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `location_zoom` int(11) NOT NULL DEFAULT '0',
  `enable_course_map` tinyint(4) NOT NULL DEFAULT '0',
  `session_limit` tinyint(4) NOT NULL DEFAULT '0',
  `session_prev` bigint(20) NOT NULL DEFAULT '-1',
  `session_next` bigint(20) NOT NULL DEFAULT '-1',
  `reg_ac_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `reg_ac` varchar(32) DEFAULT NULL,
  `status_dt` tinyint(4) DEFAULT '2',
  `auto_notification` tinyint(4) NOT NULL DEFAULT '1',
  `mail_members_type` tinyint(4) DEFAULT '1',
  `crs_start` int(11) DEFAULT NULL,
  `crs_end` int(11) DEFAULT NULL,
  `leave_end` int(11) DEFAULT NULL,
  `auto_wait` tinyint(4) NOT NULL DEFAULT '0',
  `min_members` smallint(6) DEFAULT NULL,
  `show_members_export` int(11) DEFAULT NULL,
  `timing_mode` tinyint(4) DEFAULT '0',
  `period_start` datetime DEFAULT NULL,
  `period_end` datetime DEFAULT NULL,
  `period_time_indication` int(11) NOT NULL DEFAULT '0',
  `target_group` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_settings`
--


--
-- Table structure for table `crs_start`
--

CREATE TABLE `crs_start` (
  `crs_start_id` int(11) NOT NULL DEFAULT '0',
  `crs_id` int(11) NOT NULL DEFAULT '0',
  `item_ref_id` int(11) NOT NULL DEFAULT '0',
  `pos` int(11) DEFAULT NULL,
  PRIMARY KEY (`crs_start_id`),
  KEY `i1_idx` (`crs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_start`
--


--
-- Table structure for table `crs_start_seq`
--

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

--
-- Dumping data for table `crs_start_seq`
--


--
-- Table structure for table `crs_timings_exceeded`
--

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

--
-- Dumping data for table `crs_timings_exceeded`
--


--
-- Table structure for table `crs_timings_planed`
--

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

--
-- Dumping data for table `crs_timings_planed`
--


--
-- Table structure for table `crs_timings_started`
--

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

--
-- Dumping data for table `crs_timings_started`
--


--
-- Table structure for table `crs_timings_user`
--

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

--
-- Dumping data for table `crs_timings_user`
--


--
-- Table structure for table `crs_timings_usr_accept`
--

CREATE TABLE `crs_timings_usr_accept` (
  `crs_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `accept` tinyint(4) NOT NULL DEFAULT '0',
  `remark` varchar(4000) DEFAULT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`crs_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crs_timings_usr_accept`
--


--
-- Table structure for table `crs_user_data`
--

CREATE TABLE `crs_user_data` (
  `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 `crs_user_data`
--


--
-- Table structure for table `crs_waiting_list`
--

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

--
-- Dumping data for table `crs_waiting_list`
--


--
-- Table structure for table `data_cache`
--

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

--
-- Dumping data for table `data_cache`
--


--
-- Table structure for table `dav_lock`
--

CREATE TABLE `dav_lock` (
  `token` varchar(255) NOT NULL DEFAULT ' ',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `node_id` int(11) NOT NULL DEFAULT '0',
  `ilias_owner` int(11) NOT NULL DEFAULT '0',
  `dav_owner` varchar(200) DEFAULT NULL,
  `expires` int(11) NOT NULL DEFAULT '0',
  `depth` int(11) NOT NULL DEFAULT '0',
  `type` char(1) DEFAULT 'w',
  `scope` char(1) DEFAULT 's',
  PRIMARY KEY (`token`),
  UNIQUE KEY `c1_idx` (`token`),
  KEY `i1_idx` (`obj_id`,`node_id`),
  KEY `i2_idx` (`obj_id`,`node_id`,`token`),
  KEY `i3_idx` (`expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dav_lock`
--


--
-- Table structure for table `dav_property`
--

CREATE TABLE `dav_property` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `node_id` int(11) NOT NULL DEFAULT '0',
  `ns` varchar(120) NOT NULL DEFAULT 'DAV:',
  `name` varchar(120) NOT NULL DEFAULT ' ',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`node_id`,`name`,`ns`),
  KEY `i1_idx` (`obj_id`,`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dav_property`
--


--
-- Table structure for table `dbk_translations`
--

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

--
-- Dumping data for table `dbk_translations`
--


--
-- Table structure for table `desktop_item`
--

CREATE TABLE `desktop_item` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(4) DEFAULT NULL,
  `parameters` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `desktop_item`
--


--
-- Table structure for table `didactic_tpl_a`
--

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

--
-- Dumping data for table `didactic_tpl_a`
--

INSERT INTO `didactic_tpl_a` VALUES (1,1,1),(2,2,1);

--
-- Table structure for table `didactic_tpl_a_seq`
--

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

--
-- Dumping data for table `didactic_tpl_a_seq`
--

INSERT INTO `didactic_tpl_a_seq` VALUES (2);

--
-- Table structure for table `didactic_tpl_abr`
--

CREATE TABLE `didactic_tpl_abr` (
  `action_id` int(11) NOT NULL DEFAULT '0',
  `filter_type` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`action_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `didactic_tpl_abr`
--


--
-- Table structure for table `didactic_tpl_alp`
--

CREATE TABLE `didactic_tpl_alp` (
  `action_id` int(11) NOT NULL DEFAULT '0',
  `filter_type` tinyint(4) NOT NULL DEFAULT '0',
  `template_type` tinyint(4) NOT NULL DEFAULT '0',
  `template_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`action_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `didactic_tpl_alp`
--

INSERT INTO `didactic_tpl_alp` VALUES (1,3,2,82),(2,3,2,269);

--
-- Table structure for table `didactic_tpl_alr`
--

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

--
-- Dumping data for table `didactic_tpl_alr`
--


--
-- Table structure for table `didactic_tpl_en`
--

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

--
-- Dumping data for table `didactic_tpl_en`
--


--
-- Table structure for table `didactic_tpl_fp`
--

CREATE TABLE `didactic_tpl_fp` (
  `pattern_id` int(11) NOT NULL DEFAULT '0',
  `pattern_type` tinyint(4) NOT NULL DEFAULT '0',
  `pattern_sub_type` tinyint(4) NOT NULL DEFAULT '0',
  `pattern` varchar(64) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `parent_type` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`pattern_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `didactic_tpl_fp`
--

INSERT INTO `didactic_tpl_fp` VALUES (1,1,1,'.*',1,'action'),(2,1,1,'.*',2,'action');

--
-- Table structure for table `didactic_tpl_fp_seq`
--

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

--
-- Dumping data for table `didactic_tpl_fp_seq`
--

INSERT INTO `didactic_tpl_fp_seq` VALUES (2);

--
-- Table structure for table `didactic_tpl_objs`
--

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

--
-- Dumping data for table `didactic_tpl_objs`
--


--
-- Table structure for table `didactic_tpl_sa`
--

CREATE TABLE `didactic_tpl_sa` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`,`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `didactic_tpl_sa`
--

INSERT INTO `didactic_tpl_sa` VALUES (1,'grp'),(2,'sess');

--
-- Table structure for table `didactic_tpl_settings`
--

CREATE TABLE `didactic_tpl_settings` (
  `id` int(11) NOT NULL DEFAULT '0',
  `enabled` tinyint(4) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(64) DEFAULT NULL,
  `description` varchar(512) DEFAULT NULL,
  `info` varchar(4000) DEFAULT NULL,
  `auto_generated` tinyint(4) NOT NULL DEFAULT '0',
  `exclusive_tpl` tinyint(4) NOT NULL DEFAULT '0',
  `icon_ide` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `didactic_tpl_settings`
--

INSERT INTO `didactic_tpl_settings` VALUES (1,1,1,'grp_closed','grp_closed_info','',1,0,NULL),(2,1,1,'sess_closed','sess_closed_info','',1,0,NULL);

--
-- Table structure for table `didactic_tpl_settings_seq`
--

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

--
-- Dumping data for table `didactic_tpl_settings_seq`
--

INSERT INTO `didactic_tpl_settings_seq` VALUES (2);

--
-- Table structure for table `ecs_cmap_rule`
--

CREATE TABLE `ecs_cmap_rule` (
  `rid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `attribute` varchar(64) DEFAULT NULL,
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `is_filter` tinyint(4) NOT NULL DEFAULT '0',
  `filter` varchar(512) DEFAULT NULL,
  `create_subdir` tinyint(4) NOT NULL DEFAULT '0',
  `subdir_type` tinyint(4) NOT NULL DEFAULT '0',
  `directory` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_cmap_rule`
--


--
-- Table structure for table `ecs_cmap_rule_seq`
--

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

--
-- Dumping data for table `ecs_cmap_rule_seq`
--


--
-- Table structure for table `ecs_cms_data`
--

CREATE TABLE `ecs_cms_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `server_id` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  `tree_id` int(11) DEFAULT NULL,
  `title` varchar(512) DEFAULT NULL,
  `term` varchar(255) DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `cms_id` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_cms_data`
--


--
-- Table structure for table `ecs_cms_data_seq`
--

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

--
-- Dumping data for table `ecs_cms_data_seq`
--


--
-- Table structure for table `ecs_cms_tree`
--

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

--
-- Dumping data for table `ecs_cms_tree`
--


--
-- Table structure for table `ecs_community`
--

CREATE TABLE `ecs_community` (
  `sid` int(11) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  `own_id` int(11) NOT NULL DEFAULT '0',
  `cname` varchar(255) DEFAULT NULL,
  `mids` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`sid`,`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_community`
--


--
-- Table structure for table `ecs_container_mapping`
--

CREATE TABLE `ecs_container_mapping` (
  `mapping_id` int(11) NOT NULL DEFAULT '0',
  `container_id` int(11) NOT NULL DEFAULT '0',
  `field_name` varchar(255) DEFAULT NULL,
  `mapping_type` tinyint(4) NOT NULL DEFAULT '0',
  `mapping_value` varchar(255) DEFAULT NULL,
  `date_range_start` int(11) NOT NULL DEFAULT '0',
  `date_range_end` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mapping_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_container_mapping`
--


--
-- Table structure for table `ecs_container_mapping_seq`
--

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

--
-- Dumping data for table `ecs_container_mapping_seq`
--


--
-- Table structure for table `ecs_course_assignments`
--

CREATE TABLE `ecs_course_assignments` (
  `id` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `cms_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` varchar(64) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `cms_sub_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_course_assignments`
--


--
-- Table structure for table `ecs_course_assignments_seq`
--

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

--
-- Dumping data for table `ecs_course_assignments_seq`
--


--
-- Table structure for table `ecs_crs_mapping_atts`
--

CREATE TABLE `ecs_crs_mapping_atts` (
  `id` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_crs_mapping_atts`
--


--
-- Table structure for table `ecs_crs_mapping_atts_seq`
--

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

--
-- Dumping data for table `ecs_crs_mapping_atts_seq`
--


--
-- Table structure for table `ecs_data_mapping`
--

CREATE TABLE `ecs_data_mapping` (
  `sid` int(11) NOT NULL DEFAULT '0',
  `mapping_type` tinyint(4) NOT NULL DEFAULT '0',
  `ecs_field` varchar(32) NOT NULL DEFAULT '',
  `advmd_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`,`mapping_type`,`ecs_field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_data_mapping`
--


--
-- Table structure for table `ecs_events`
--

CREATE TABLE `ecs_events` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `type` char(32) DEFAULT NULL,
  `id` int(11) NOT NULL DEFAULT '0',
  `op` char(32) DEFAULT NULL,
  `server_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_events`
--


--
-- Table structure for table `ecs_events_seq`
--

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

--
-- Dumping data for table `ecs_events_seq`
--


--
-- Table structure for table `ecs_export`
--

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

--
-- Dumping data for table `ecs_export`
--


--
-- Table structure for table `ecs_import`
--

CREATE TABLE `ecs_import` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `server_id` int(11) NOT NULL DEFAULT '0',
  `sub_id` varchar(64) DEFAULT NULL,
  `ecs_id` int(11) DEFAULT '0',
  `content_id` varchar(255) DEFAULT NULL,
  `econtent_id` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`server_id`,`obj_id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`sub_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_import`
--


--
-- Table structure for table `ecs_node_mapping_a`
--

CREATE TABLE `ecs_node_mapping_a` (
  `server_id` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `cs_root` int(11) NOT NULL DEFAULT '0',
  `cs_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `title_update` tinyint(4) DEFAULT NULL,
  `position_update` tinyint(4) DEFAULT NULL,
  `tree_update` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`server_id`,`mid`,`cs_root`,`cs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_node_mapping_a`
--


--
-- Table structure for table `ecs_part_settings`
--

CREATE TABLE `ecs_part_settings` (
  `sid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `export` tinyint(4) NOT NULL DEFAULT '0',
  `import` tinyint(4) NOT NULL DEFAULT '0',
  `import_type` tinyint(4) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `cname` varchar(255) DEFAULT NULL,
  `token` tinyint(4) DEFAULT '1',
  `export_types` varchar(4000) DEFAULT NULL,
  `import_types` varchar(4000) DEFAULT NULL,
  `dtoken` tinyint(4) NOT NULL DEFAULT '1',
  `username_placeholders` varchar(500) DEFAULT NULL,
  `incoming_auth_type` varchar(1) NOT NULL DEFAULT '0',
  `incoming_local_accounts` tinyint(4) NOT NULL DEFAULT '1',
  `outgoing_auth_modes` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`sid`,`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_part_settings`
--


--
-- Table structure for table `ecs_remote_user`
--

CREATE TABLE `ecs_remote_user` (
  `eru_id` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `remote_usr_id` char(50) DEFAULT NULL,
  PRIMARY KEY (`eru_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_remote_user`
--


--
-- Table structure for table `ecs_remote_user_seq`
--

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

--
-- Dumping data for table `ecs_remote_user_seq`
--


--
-- Table structure for table `ecs_server`
--

CREATE TABLE `ecs_server` (
  `server_id` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(4) DEFAULT '0',
  `protocol` tinyint(4) DEFAULT '1',
  `server` varchar(255) DEFAULT NULL,
  `port` smallint(6) DEFAULT '1',
  `auth_type` tinyint(4) DEFAULT '1',
  `client_cert_path` varchar(512) DEFAULT NULL,
  `ca_cert_path` varchar(512) DEFAULT NULL,
  `key_path` varchar(512) DEFAULT NULL,
  `key_password` varchar(32) DEFAULT NULL,
  `cert_serial` varchar(32) DEFAULT NULL,
  `import_id` int(11) DEFAULT '0',
  `global_role` int(11) DEFAULT '0',
  `econtent_rcp` varchar(512) DEFAULT NULL,
  `user_rcp` varchar(512) DEFAULT NULL,
  `approval_rcp` varchar(512) DEFAULT NULL,
  `duration` int(11) DEFAULT '0',
  `title` varchar(128) DEFAULT NULL,
  `auth_user` varchar(32) DEFAULT NULL,
  `auth_pass` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_server`
--


--
-- Table structure for table `ecs_server_seq`
--

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

--
-- Dumping data for table `ecs_server_seq`
--


--
-- Table structure for table `ecs_user_consent`
--

CREATE TABLE `ecs_user_consent` (
  `usr_id` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  `server_id` int(11) NOT NULL,
  PRIMARY KEY (`usr_id`,`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ecs_user_consent`
--


--
-- Table structure for table `etal_data`
--

CREATE TABLE `etal_data` (
  `object_id` bigint(20) NOT NULL,
  `series_id` char(36) NOT NULL,
  `start_date` bigint(20) NOT NULL,
  `end_date` bigint(20) NOT NULL,
  `all_day` tinyint(4) NOT NULL,
  `employee` bigint(20) NOT NULL,
  `location` varchar(200) DEFAULT NULL,
  `completed` tinyint(4) NOT NULL,
  `standalone_date` tinyint(4) NOT NULL DEFAULT '0',
  `template_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`),
  KEY `ser_idx` (`series_id`),
  KEY `emp_idx` (`employee`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `etal_data`
--


--
-- Table structure for table `etal_serie`
--

CREATE TABLE `etal_serie` (
  `id` bigint(20) NOT NULL,
  `editing_locked` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `etal_serie`
--


--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(70) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `location` varchar(4000) DEFAULT NULL,
  `tutor_name` varchar(4000) DEFAULT NULL,
  `tutor_email` varchar(127) DEFAULT NULL,
  `tutor_phone` varchar(127) DEFAULT NULL,
  `details` varchar(4000) DEFAULT NULL,
  `registration` tinyint(4) NOT NULL DEFAULT '0',
  `participation` tinyint(4) NOT NULL DEFAULT '0',
  `reg_type` smallint(6) DEFAULT '0',
  `reg_limit_users` int(11) DEFAULT '0',
  `reg_waiting_list` tinyint(4) DEFAULT '0',
  `reg_limited` tinyint(4) DEFAULT '0',
  `reg_min_users` smallint(6) DEFAULT NULL,
  `reg_auto_wait` tinyint(4) NOT NULL DEFAULT '0',
  `show_members` tinyint(4) NOT NULL DEFAULT '0',
  `mail_members` tinyint(4) NOT NULL DEFAULT '0',
  `reg_notification` int(11) NOT NULL DEFAULT '0',
  `notification_opt` varchar(50) DEFAULT 'notification_option_manual',
  `show_cannot_part` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `event`
--


--
-- Table structure for table `event_appointment`
--

CREATE TABLE `event_appointment` (
  `appointment_id` int(11) NOT NULL DEFAULT '0',
  `event_id` int(11) NOT NULL DEFAULT '0',
  `e_start` datetime DEFAULT NULL,
  `e_end` datetime DEFAULT NULL,
  `starting_time` int(11) NOT NULL DEFAULT '0',
  `ending_time` int(11) NOT NULL DEFAULT '0',
  `fulltime` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`appointment_id`),
  KEY `i1_idx` (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `event_appointment`
--


--
-- Table structure for table `event_appointment_seq`
--

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

--
-- Dumping data for table `event_appointment_seq`
--


--
-- Table structure for table `event_items`
--

CREATE TABLE `event_items` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`,`item_id`),
  KEY `i1_idx` (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `event_items`
--


--
-- Table structure for table `event_participants`
--

CREATE TABLE `event_participants` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `registered` tinyint(4) NOT NULL DEFAULT '0',
  `participated` tinyint(4) NOT NULL DEFAULT '0',
  `mark` longtext,
  `e_comment` longtext,
  `contact` tinyint(4) NOT NULL DEFAULT '0',
  `notification_enabled` int(11) NOT NULL DEFAULT '0',
  `excused` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `event_participants`
--


--
-- Table structure for table `event_seq`
--

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

--
-- Dumping data for table `event_seq`
--


--
-- Table structure for table `exc_ass_file_order`
--

CREATE TABLE `exc_ass_file_order` (
  `id` int(11) NOT NULL DEFAULT '0',
  `assignment_id` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(150) NOT NULL,
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`assignment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_ass_file_order`
--


--
-- Table structure for table `exc_ass_file_order_seq`
--

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

--
-- Dumping data for table `exc_ass_file_order_seq`
--


--
-- Table structure for table `exc_ass_reminders`
--

CREATE TABLE `exc_ass_reminders` (
  `type` varchar(32) NOT NULL,
  `ass_id` int(11) NOT NULL,
  `exc_id` int(11) NOT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `freq` int(11) DEFAULT NULL,
  `last_send` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `last_send_day` date DEFAULT NULL,
  PRIMARY KEY (`ass_id`,`exc_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_ass_reminders`
--


--
-- Table structure for table `exc_ass_wiki_team`
--

CREATE TABLE `exc_ass_wiki_team` (
  `id` int(11) NOT NULL DEFAULT '0',
  `container_ref_id` int(11) NOT NULL DEFAULT '0',
  `template_ref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_ass_wiki_team`
--


--
-- Table structure for table `exc_assignment`
--

CREATE TABLE `exc_assignment` (
  `id` int(11) NOT NULL DEFAULT '0',
  `exc_id` int(11) NOT NULL DEFAULT '0',
  `time_stamp` int(11) DEFAULT NULL,
  `instruction` longtext,
  `title` varchar(200) DEFAULT NULL,
  `start_time` int(11) DEFAULT NULL,
  `mandatory` tinyint(4) DEFAULT '1',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '1',
  `peer` tinyint(4) NOT NULL DEFAULT '0',
  `peer_min` smallint(6) NOT NULL DEFAULT '0',
  `fb_file` varchar(1000) DEFAULT NULL,
  `fb_cron` tinyint(4) NOT NULL DEFAULT '0',
  `fb_cron_done` tinyint(4) NOT NULL DEFAULT '0',
  `peer_dl` int(11) DEFAULT '0',
  `peer_file` tinyint(4) DEFAULT '0',
  `peer_prsl` tinyint(4) DEFAULT '0',
  `fb_date` tinyint(4) NOT NULL DEFAULT '1',
  `peer_char` smallint(6) DEFAULT NULL,
  `peer_unlock` tinyint(4) NOT NULL DEFAULT '0',
  `peer_valid` tinyint(4) NOT NULL DEFAULT '1',
  `team_tutor` tinyint(4) NOT NULL DEFAULT '0',
  `max_file` tinyint(4) DEFAULT NULL,
  `deadline2` int(11) DEFAULT NULL,
  `peer_text` tinyint(4) NOT NULL DEFAULT '1',
  `peer_rating` tinyint(4) NOT NULL DEFAULT '1',
  `peer_crit_cat` int(11) DEFAULT NULL,
  `portfolio_template` int(11) DEFAULT NULL,
  `min_char_limit` int(11) DEFAULT NULL,
  `max_char_limit` int(11) DEFAULT NULL,
  `fb_date_custom` int(11) DEFAULT NULL,
  `rmd_submit_status` tinyint(4) DEFAULT NULL,
  `rmd_submit_start` int(11) DEFAULT NULL,
  `rmd_submit_end` int(11) DEFAULT NULL,
  `rmd_submit_freq` int(11) DEFAULT NULL,
  `rmd_grade_status` tinyint(4) DEFAULT NULL,
  `rmd_grade_start` int(11) DEFAULT NULL,
  `rmd_grade_end` int(11) DEFAULT NULL,
  `rmd_grade_freq` int(11) DEFAULT NULL,
  `peer_rmd_status` tinyint(4) DEFAULT NULL,
  `peer_rmd_start` int(11) DEFAULT NULL,
  `peer_rmd_end` int(11) DEFAULT NULL,
  `peer_rmd_freq` int(11) DEFAULT NULL,
  `deadline_mode` tinyint(4) DEFAULT '0',
  `relative_deadline` int(11) DEFAULT '0',
  `rel_deadline_last_subm` int(11) NOT NULL DEFAULT '0',
  `if_rcid` varchar(64) DEFAULT NULL,
  `solution_rid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`exc_id`),
  KEY `i2_idx` (`deadline_mode`,`exc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_assignment`
--


--
-- Table structure for table `exc_assignment_peer`
--

CREATE TABLE `exc_assignment_peer` (
  `ass_id` int(11) NOT NULL DEFAULT '0',
  `giver_id` int(11) NOT NULL DEFAULT '0',
  `peer_id` int(11) NOT NULL DEFAULT '0',
  `tstamp` datetime DEFAULT NULL,
  `pcomment` longtext,
  `is_valid` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `c1_idx` (`ass_id`,`giver_id`,`peer_id`),
  KEY `i1_idx` (`ass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_assignment_peer`
--


--
-- Table structure for table `exc_assignment_peer_seq`
--

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

--
-- Dumping data for table `exc_assignment_peer_seq`
--


--
-- Table structure for table `exc_assignment_seq`
--

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

--
-- Dumping data for table `exc_assignment_seq`
--


--
-- Table structure for table `exc_crit`
--

CREATE TABLE `exc_crit` (
  `id` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `descr` varchar(1000) DEFAULT NULL,
  `pos` int(11) NOT NULL DEFAULT '0',
  `required` tinyint(4) NOT NULL DEFAULT '0',
  `def` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_crit`
--


--
-- Table structure for table `exc_crit_cat`
--

CREATE TABLE `exc_crit_cat` (
  `id` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `pos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_crit_cat`
--


--
-- Table structure for table `exc_crit_cat_seq`
--

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

--
-- Dumping data for table `exc_crit_cat_seq`
--


--
-- Table structure for table `exc_crit_seq`
--

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

--
-- Dumping data for table `exc_crit_seq`
--


--
-- Table structure for table `exc_data`
--

CREATE TABLE `exc_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `instruction` longtext,
  `time_stamp` int(11) DEFAULT NULL,
  `pass_mode` varchar(8) NOT NULL DEFAULT 'all',
  `pass_nr` int(11) DEFAULT NULL,
  `show_submissions` tinyint(4) NOT NULL DEFAULT '0',
  `compl_by_submission` tinyint(4) NOT NULL DEFAULT '0',
  `certificate_visibility` tinyint(4) NOT NULL DEFAULT '0',
  `tfeedback` tinyint(4) NOT NULL DEFAULT '7',
  `nr_mandatory_random` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_data`
--


--
-- Table structure for table `exc_idl`
--

CREATE TABLE `exc_idl` (
  `ass_id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) NOT NULL DEFAULT '0',
  `is_team` tinyint(4) NOT NULL DEFAULT '0',
  `tstamp` int(11) DEFAULT '0',
  `starting_ts` int(11) DEFAULT '0',
  `requested` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ass_id`,`member_id`,`is_team`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_idl`
--


--
-- Table structure for table `exc_mandatory_random`
--

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

--
-- Dumping data for table `exc_mandatory_random`
--


--
-- Table structure for table `exc_mem_ass_status`
--

CREATE TABLE `exc_mem_ass_status` (
  `ass_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `notice` varchar(4000) DEFAULT NULL,
  `returned` tinyint(4) NOT NULL DEFAULT '0',
  `solved` tinyint(4) DEFAULT NULL,
  `status_time` datetime DEFAULT NULL,
  `sent` tinyint(4) DEFAULT NULL,
  `sent_time` datetime DEFAULT NULL,
  `feedback_time` datetime DEFAULT NULL,
  `feedback` tinyint(4) NOT NULL DEFAULT '0',
  `status` char(9) DEFAULT 'notgraded',
  `mark` varchar(32) DEFAULT NULL,
  `u_comment` varchar(4000) DEFAULT NULL,
  `feedback_rcid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`ass_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_mem_ass_status`
--


--
-- Table structure for table `exc_members`
--

CREATE TABLE `exc_members` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `notice` varchar(4000) DEFAULT NULL,
  `returned` tinyint(4) NOT NULL DEFAULT '0',
  `solved` tinyint(4) DEFAULT NULL,
  `status_time` datetime DEFAULT NULL,
  `sent` tinyint(4) DEFAULT NULL,
  `sent_time` datetime DEFAULT NULL,
  `feedback_time` datetime DEFAULT NULL,
  `feedback` tinyint(4) NOT NULL DEFAULT '0',
  `status` char(9) DEFAULT 'notgraded',
  PRIMARY KEY (`obj_id`,`usr_id`),
  KEY `ob_idx` (`obj_id`),
  KEY `i1_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_members`
--


--
-- Table structure for table `exc_multi_feedback`
--

CREATE TABLE `exc_multi_feedback` (
  `tutor_id` int(11) NOT NULL,
  `ass_id` int(11) NOT NULL,
  `zip_rid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`tutor_id`,`ass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_multi_feedback`
--


--
-- Table structure for table `exc_returned`
--

CREATE TABLE `exc_returned` (
  `returned_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(1000) DEFAULT NULL,
  `filetitle` varchar(1000) DEFAULT NULL,
  `mimetype` varchar(150) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `ass_id` int(11) DEFAULT NULL,
  `atext` longtext,
  `late` tinyint(4) NOT NULL DEFAULT '0',
  `team_id` int(11) NOT NULL DEFAULT '0',
  `web_dir_access_time` datetime DEFAULT NULL,
  PRIMARY KEY (`returned_id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`user_id`),
  KEY `i3_idx` (`filetitle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_returned`
--


--
-- Table structure for table `exc_returned_seq`
--

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

--
-- Dumping data for table `exc_returned_seq`
--


--
-- Table structure for table `exc_team_data`
--

CREATE TABLE `exc_team_data` (
  `id` int(11) NOT NULL,
  `feedback_rcid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_team_data`
--


--
-- Table structure for table `exc_usr_tutor`
--

CREATE TABLE `exc_usr_tutor` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `tutor_id` int(11) NOT NULL DEFAULT '0',
  `download_time` datetime DEFAULT NULL,
  `ass_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ass_id`,`usr_id`,`tutor_id`),
  KEY `ob_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exc_usr_tutor`
--


--
-- Table structure for table `export_file_info`
--

CREATE TABLE `export_file_info` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `export_type` varchar(32) NOT NULL DEFAULT '',
  `file_name` varchar(64) NOT NULL DEFAULT '',
  `version` varchar(16) DEFAULT NULL,
  `create_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `filename` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`obj_id`,`export_type`,`filename`),
  KEY `i1_idx` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `export_file_info`
--


--
-- Table structure for table `export_options`
--

CREATE TABLE `export_options` (
  `export_id` smallint(6) NOT NULL DEFAULT '0',
  `keyword` smallint(6) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(32) DEFAULT NULL,
  `pos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`export_id`,`keyword`,`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `export_options`
--


--
-- Table structure for table `feedback_items_seq`
--

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

--
-- Dumping data for table `feedback_items_seq`
--


--
-- Table structure for table `file_based_lm`
--

CREATE TABLE `file_based_lm` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` char(1) DEFAULT 'n',
  `startfile` varchar(200) DEFAULT NULL,
  `show_lic` tinyint(4) DEFAULT NULL,
  `show_bib` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `file_based_lm`
--


--
-- Table structure for table `file_data`
--

CREATE TABLE `file_data` (
  `file_id` int(11) NOT NULL DEFAULT '0',
  `file_name` char(250) DEFAULT NULL,
  `file_type` char(250) DEFAULT NULL,
  `file_size` int(11) NOT NULL DEFAULT '0',
  `version` int(11) DEFAULT NULL,
  `f_mode` char(8) DEFAULT 'object',
  `rating` tinyint(4) NOT NULL DEFAULT '0',
  `page_count` bigint(20) DEFAULT NULL,
  `max_version` int(11) DEFAULT NULL,
  `rid` varchar(64) NOT NULL DEFAULT '',
  `on_click_mode` tinyint(4) NOT NULL DEFAULT '1',
  `downloads` bigint(20) DEFAULT '0',
  `important_info` longblob,
  PRIMARY KEY (`file_id`),
  KEY `i1_idx` (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `file_data`
--


--
-- Table structure for table `file_usage`
--

CREATE TABLE `file_usage` (
  `id` int(11) NOT NULL DEFAULT '0',
  `usage_type` varchar(10) NOT NULL DEFAULT ' ',
  `usage_id` int(11) NOT NULL DEFAULT '0',
  `usage_hist_nr` int(11) NOT NULL DEFAULT '0',
  `usage_lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`id`,`usage_type`,`usage_id`,`usage_hist_nr`,`usage_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `file_usage`
--


--
-- Table structure for table `frm_data`
--

CREATE TABLE `frm_data` (
  `top_pk` bigint(20) NOT NULL DEFAULT '0',
  `top_frm_fk` bigint(20) NOT NULL DEFAULT '0',
  `top_name` varchar(255) DEFAULT NULL,
  `top_description` varchar(255) DEFAULT NULL,
  `top_num_posts` int(11) NOT NULL DEFAULT '0',
  `top_num_threads` int(11) NOT NULL DEFAULT '0',
  `top_last_post` varchar(50) DEFAULT NULL,
  `top_mods` int(11) NOT NULL DEFAULT '0',
  `top_date` datetime DEFAULT NULL,
  `visits` int(11) NOT NULL DEFAULT '0',
  `top_update` datetime DEFAULT NULL,
  `update_user` int(11) NOT NULL DEFAULT '0',
  `top_usr_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`top_pk`),
  KEY `i1_idx` (`top_frm_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_data`
--


--
-- Table structure for table `frm_data_seq`
--

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

--
-- Dumping data for table `frm_data_seq`
--


--
-- Table structure for table `frm_drafts_history`
--

CREATE TABLE `frm_drafts_history` (
  `history_id` int(11) NOT NULL DEFAULT '0',
  `draft_id` int(11) NOT NULL DEFAULT '0',
  `post_subject` varchar(4000) NOT NULL DEFAULT '',
  `post_message` longtext NOT NULL,
  `draft_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`history_id`),
  KEY `i1_idx` (`draft_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_drafts_history`
--


--
-- Table structure for table `frm_drafts_history_seq`
--

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

--
-- Dumping data for table `frm_drafts_history_seq`
--


--
-- Table structure for table `frm_notification`
--

CREATE TABLE `frm_notification` (
  `notification_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `frm_id` bigint(20) NOT NULL DEFAULT '0',
  `thread_id` bigint(20) NOT NULL DEFAULT '0',
  `admin_force_noti` tinyint(4) NOT NULL DEFAULT '0',
  `user_toggle_noti` tinyint(4) NOT NULL DEFAULT '0',
  `user_id_noti` int(11) DEFAULT NULL,
  `interested_events` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`notification_id`),
  KEY `i1_idx` (`user_id`,`thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_notification`
--


--
-- Table structure for table `frm_notification_seq`
--

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

--
-- Dumping data for table `frm_notification_seq`
--


--
-- Table structure for table `frm_posts`
--

CREATE TABLE `frm_posts` (
  `pos_pk` bigint(20) NOT NULL DEFAULT '0',
  `pos_top_fk` bigint(20) NOT NULL DEFAULT '0',
  `pos_thr_fk` bigint(20) NOT NULL DEFAULT '0',
  `pos_usr_alias` varchar(255) DEFAULT NULL,
  `pos_subject` varchar(4000) DEFAULT NULL,
  `pos_date` datetime DEFAULT NULL,
  `pos_update` datetime DEFAULT NULL,
  `update_user` int(11) NOT NULL DEFAULT '0',
  `pos_cens` tinyint(4) NOT NULL DEFAULT '0',
  `pos_cens_com` varchar(4000) DEFAULT NULL,
  `notify` tinyint(4) NOT NULL DEFAULT '0',
  `import_name` varchar(4000) DEFAULT NULL,
  `pos_status` tinyint(4) NOT NULL DEFAULT '1',
  `pos_message` longtext,
  `pos_author_id` int(11) NOT NULL DEFAULT '0',
  `pos_display_user_id` int(11) NOT NULL DEFAULT '0',
  `is_author_moderator` tinyint(4) DEFAULT NULL,
  `pos_cens_date` datetime DEFAULT NULL,
  `pos_activation_date` datetime DEFAULT NULL,
  `rcid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`pos_pk`),
  KEY `i1_idx` (`pos_thr_fk`),
  KEY `i2_idx` (`pos_top_fk`),
  KEY `i3_idx` (`pos_date`),
  KEY `i5_idx` (`pos_thr_fk`,`pos_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_posts`
--


--
-- Table structure for table `frm_posts_deleted`
--

CREATE TABLE `frm_posts_deleted` (
  `deleted_id` int(11) NOT NULL DEFAULT '0',
  `deleted_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `deleted_by` varchar(255) NOT NULL DEFAULT '',
  `forum_title` varchar(255) NOT NULL DEFAULT '',
  `thread_title` varchar(255) NOT NULL DEFAULT '',
  `post_title` varchar(255) NOT NULL DEFAULT '',
  `post_message` longtext NOT NULL,
  `post_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `pos_display_user_id` int(11) NOT NULL DEFAULT '0',
  `pos_usr_alias` varchar(255) DEFAULT NULL,
  `is_thread_deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`deleted_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_posts_deleted`
--


--
-- Table structure for table `frm_posts_deleted_seq`
--

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

--
-- Dumping data for table `frm_posts_deleted_seq`
--


--
-- Table structure for table `frm_posts_drafts`
--

CREATE TABLE `frm_posts_drafts` (
  `draft_id` int(11) NOT NULL DEFAULT '0',
  `post_id` bigint(20) NOT NULL DEFAULT '0',
  `thread_id` bigint(20) NOT NULL DEFAULT '0',
  `forum_id` bigint(20) NOT NULL DEFAULT '0',
  `post_author_id` int(11) NOT NULL DEFAULT '0',
  `post_subject` varchar(4000) NOT NULL DEFAULT '',
  `post_message` longtext NOT NULL,
  `post_notify` tinyint(4) NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `post_update` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `update_user_id` int(11) NOT NULL DEFAULT '0',
  `post_user_alias` varchar(255) DEFAULT NULL,
  `pos_display_usr_id` int(11) NOT NULL DEFAULT '0',
  `notify` tinyint(4) NOT NULL DEFAULT '0',
  `rcid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`draft_id`),
  KEY `i1_idx` (`post_id`),
  KEY `i2_idx` (`thread_id`),
  KEY `i3_idx` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_posts_drafts`
--


--
-- Table structure for table `frm_posts_drafts_seq`
--

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

--
-- Dumping data for table `frm_posts_drafts_seq`
--


--
-- Table structure for table `frm_posts_seq`
--

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

--
-- Dumping data for table `frm_posts_seq`
--


--
-- Table structure for table `frm_posts_tree`
--

CREATE TABLE `frm_posts_tree` (
  `fpt_pk` bigint(20) NOT NULL DEFAULT '0',
  `thr_fk` bigint(20) NOT NULL DEFAULT '0',
  `pos_fk` bigint(20) NOT NULL DEFAULT '0',
  `parent_pos` bigint(20) NOT NULL DEFAULT '0',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `depth` int(11) NOT NULL DEFAULT '0',
  `fpt_date` datetime DEFAULT NULL,
  PRIMARY KEY (`fpt_pk`),
  KEY `i1_idx` (`thr_fk`),
  KEY `i2_idx` (`pos_fk`),
  KEY `i3_idx` (`parent_pos`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_posts_tree`
--


--
-- Table structure for table `frm_posts_tree_seq`
--

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

--
-- Dumping data for table `frm_posts_tree_seq`
--


--
-- Table structure for table `frm_settings`
--

CREATE TABLE `frm_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `default_view` int(11) NOT NULL DEFAULT '0',
  `anonymized` tinyint(4) NOT NULL DEFAULT '0',
  `statistics_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `post_activation` tinyint(4) NOT NULL DEFAULT '0',
  `admin_force_noti` tinyint(4) NOT NULL DEFAULT '0',
  `user_toggle_noti` tinyint(4) NOT NULL DEFAULT '0',
  `preset_subject` tinyint(4) NOT NULL DEFAULT '1',
  `notification_type` varchar(10) DEFAULT NULL,
  `add_re_subject` tinyint(4) NOT NULL DEFAULT '0',
  `mark_mod_posts` tinyint(4) NOT NULL DEFAULT '0',
  `thread_rating` tinyint(4) NOT NULL DEFAULT '0',
  `file_upload_allowed` tinyint(4) NOT NULL DEFAULT '0',
  `interested_events` tinyint(4) NOT NULL DEFAULT '0',
  `lp_req_num_postings` int(11) DEFAULT NULL,
  `stylesheet` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_settings`
--


--
-- Table structure for table `frm_threads`
--

CREATE TABLE `frm_threads` (
  `thr_pk` bigint(20) NOT NULL DEFAULT '0',
  `thr_top_fk` bigint(20) NOT NULL DEFAULT '0',
  `thr_subject` varchar(255) DEFAULT NULL,
  `thr_usr_alias` varchar(255) DEFAULT NULL,
  `thr_num_posts` int(11) NOT NULL DEFAULT '0',
  `thr_last_post` varchar(50) DEFAULT NULL,
  `thr_date` datetime DEFAULT NULL,
  `thr_update` datetime DEFAULT NULL,
  `visits` int(11) NOT NULL DEFAULT '0',
  `import_name` varchar(4000) DEFAULT NULL,
  `is_sticky` tinyint(4) NOT NULL DEFAULT '0',
  `is_closed` tinyint(4) NOT NULL DEFAULT '0',
  `avg_rating` double NOT NULL DEFAULT '0',
  `thr_author_id` int(11) NOT NULL DEFAULT '0',
  `thr_display_user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`thr_pk`),
  KEY `i2_idx` (`thr_top_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_threads`
--


--
-- Table structure for table `frm_threads_seq`
--

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

--
-- Dumping data for table `frm_threads_seq`
--


--
-- Table structure for table `frm_user_read`
--

CREATE TABLE `frm_user_read` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `post_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`obj_id`,`thread_id`,`post_id`),
  KEY `i1_idx` (`usr_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frm_user_read`
--


--
-- Table structure for table `glo_advmd_col_order`
--

CREATE TABLE `glo_advmd_col_order` (
  `glo_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`glo_id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glo_advmd_col_order`
--


--
-- Table structure for table `glo_flashcard_box`
--

