-- Dumping data for table `il_upload_policy`
--


--
-- Table structure for table `il_upload_policy_seq`
--

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

--
-- Dumping data for table `il_upload_policy_seq`
--


--
-- Table structure for table `il_verification`
--

CREATE TABLE `il_verification` (
  `id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(100) NOT NULL DEFAULT '',
  `parameters` varchar(1000) DEFAULT NULL,
  `raw_data` longtext,
  PRIMARY KEY (`id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_verification`
--


--
-- Table structure for table `il_wac_secure_path`
--

CREATE TABLE `il_wac_secure_path` (
  `path` varchar(64) NOT NULL DEFAULT ' ',
  `component_directory` varchar(256) DEFAULT NULL,
  `checking_class` varchar(256) DEFAULT NULL,
  `in_sec_folder` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wac_secure_path`
--

INSERT INTO `il_wac_secure_path` VALUES ('assessment','[[softpath]]/Modules/Test','ilObjTestAccess',0),('chatroom','[[softpath]]/Modules/Chatroom','ilObjChatroomAccess',0),('container_data','[[softpath]]/Services/Container','ilContainerAccess',0),('css','[[softpath]]/Services/Style','ilContentStyleWAC',0),('custom_icons','[[softpath]]/Services/Object','ilObjectAccess',0),('ilBadge','[[softpath]]/Services/Badge','ilBadgeWAC',1),('ilBlog','[[softpath]]/Modules/Blog','ilObjBlogAccess',1),('ilBookingManager','[[softpath]]/Modules/BookingManager','ilObjBookingPoolAccess',0),('ilExercise','[[softpath]]/Modules/Exercise','ilObjExerciseAccess',0),('ilPoll','[[softpath]]/Modules/Poll','ilObjPollAccess',1),('ilPortfolio','[[softpath]]/Modules/Portfolio','ilPortfolioAccessHandler',1),('lm_data','[[softpath]]/Modules/LearningModule','ilObjLearningModuleAccess',0),('mobs','[[softpath]]/Services/MediaObjects','ilObjMediaObjectAccess',0),('previews','[[softpath]]/Modules/File','ilObjFileAccess',0),('rs','[[softpath]]/Services/ResourceStorage','ilWACSignedResourceStorage',1),('thumbs','[[softpath]]/Services/MediaObjects','ilObjMediaObjectAccess',0),('usr_images','[[softpath]]/Services/User','ilObjUserAccess',0);

--
-- Table structure for table `il_wiki_contributor`
--

CREATE TABLE `il_wiki_contributor` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `status` int(11) DEFAULT NULL,
  `status_time` datetime DEFAULT NULL,
  PRIMARY KEY (`wiki_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wiki_contributor`
--


--
-- Table structure for table `il_wiki_data`
--

CREATE TABLE `il_wiki_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `startpage` varchar(200) DEFAULT NULL,
  `short` varchar(20) DEFAULT NULL,
  `is_online` tinyint(4) DEFAULT '0',
  `rating` tinyint(4) DEFAULT '0',
  `introduction` longtext,
  `public_notes` tinyint(4) DEFAULT '1',
  `imp_pages` tinyint(4) DEFAULT NULL,
  `page_toc` tinyint(4) DEFAULT NULL,
  `rating_side` tinyint(4) NOT NULL DEFAULT '0',
  `rating_new` tinyint(4) NOT NULL DEFAULT '0',
  `rating_ext` tinyint(4) NOT NULL DEFAULT '0',
  `rating_overall` tinyint(4) DEFAULT '0',
  `empty_page_templ` tinyint(4) NOT NULL DEFAULT '1',
  `link_md_values` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wiki_data`
--


--
-- Table structure for table `il_wiki_imp_pages`
--

CREATE TABLE `il_wiki_imp_pages` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `ord` int(11) NOT NULL DEFAULT '0',
  `indent` tinyint(4) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wiki_id`,`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wiki_imp_pages`
--


--
-- Table structure for table `il_wiki_missing_page`
--

CREATE TABLE `il_wiki_missing_page` (
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `source_id` int(11) NOT NULL DEFAULT '0',
  `target_name` varchar(200) NOT NULL DEFAULT '',
  `lang` varchar(5) NOT NULL DEFAULT '-',
  PRIMARY KEY (`wiki_id`,`source_id`,`target_name`,`lang`),
  KEY `i1_idx` (`wiki_id`,`target_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wiki_missing_page`
--


--
-- Table structure for table `il_wiki_page`
--

CREATE TABLE `il_wiki_page` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `wiki_id` int(11) NOT NULL DEFAULT '0',
  `blocked` tinyint(4) DEFAULT NULL,
  `rating` tinyint(4) NOT NULL DEFAULT '0',
  `hide_adv_md` tinyint(4) DEFAULT '0',
  `lang` varchar(10) NOT NULL DEFAULT '-',
  PRIMARY KEY (`id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_wiki_page`
--


--
-- Table structure for table `il_wiki_page_seq`
--

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

--
-- Dumping data for table `il_wiki_page_seq`
--


--
-- Table structure for table `int_link`
--

CREATE TABLE `int_link` (
  `source_type` varchar(10) NOT NULL DEFAULT ' ',
  `source_id` int(11) NOT NULL DEFAULT '0',
  `target_type` varchar(10) NOT NULL DEFAULT ' ',
  `target_id` int(11) NOT NULL DEFAULT '0',
  `target_inst` int(11) NOT NULL DEFAULT '0',
  `source_lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`source_type`,`source_id`,`source_lang`,`target_type`,`target_id`,`target_inst`),
  KEY `ta_idx` (`target_type`,`target_id`,`target_inst`),
  KEY `so_idx` (`source_type`,`source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `int_link`
--


--
-- Table structure for table `item_group_item`
--

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

--
-- Dumping data for table `item_group_item`
--


--
-- Table structure for table `itgr_data`
--

CREATE TABLE `itgr_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `hide_title` tinyint(4) NOT NULL DEFAULT '0',
  `behaviour` tinyint(4) DEFAULT '0',
  `list_presentation` varchar(10) DEFAULT NULL,
  `tile_size` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `itgr_data`
--


--
-- Table structure for table `last_visited`
--

CREATE TABLE `last_visited` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `nr` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(10) NOT NULL DEFAULT '',
  `sub_obj_id` varchar(40) DEFAULT NULL,
  `goto_link` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`nr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `last_visited`
--


--
-- Table structure for table `ldap_attribute_mapping`
--

CREATE TABLE `ldap_attribute_mapping` (
  `server_id` int(11) NOT NULL DEFAULT '0',
  `keyword` varchar(32) NOT NULL DEFAULT ' ',
  `value` varchar(255) DEFAULT NULL,
  `perform_update` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`server_id`,`keyword`),
  KEY `i1_idx` (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldap_attribute_mapping`
--


--
-- Table structure for table `ldap_rg_mapping`
--

CREATE TABLE `ldap_rg_mapping` (
  `mapping_id` int(11) NOT NULL DEFAULT '0',
  `server_id` int(11) NOT NULL DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `dn` varchar(255) DEFAULT NULL,
  `member_attribute` varchar(64) DEFAULT NULL,
  `member_isdn` tinyint(4) NOT NULL DEFAULT '0',
  `role` int(11) NOT NULL DEFAULT '0',
  `mapping_info` varchar(4000) DEFAULT NULL,
  `mapping_info_type` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`mapping_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldap_rg_mapping`
--


--
-- Table structure for table `ldap_rg_mapping_seq`
--

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

--
-- Dumping data for table `ldap_rg_mapping_seq`
--


--
-- Table structure for table `ldap_role_assignments`
--

CREATE TABLE `ldap_role_assignments` (
  `server_id` int(11) NOT NULL DEFAULT '0',
  `rule_id` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `dn` varchar(1000) DEFAULT NULL,
  `attribute` varchar(32) DEFAULT NULL,
  `isdn` tinyint(4) NOT NULL DEFAULT '0',
  `att_name` varchar(255) DEFAULT NULL,
  `att_value` varchar(255) DEFAULT NULL,
  `role_id` int(11) NOT NULL DEFAULT '0',
  `add_on_update` tinyint(4) DEFAULT NULL,
  `remove_on_update` tinyint(4) DEFAULT NULL,
  `plugin_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`server_id`,`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldap_role_assignments`
--


--
-- Table structure for table `ldap_role_assignments_seq`
--

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

--
-- Dumping data for table `ldap_role_assignments_seq`
--


--
-- Table structure for table `ldap_server_settings`
--

CREATE TABLE `ldap_server_settings` (
  `server_id` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '0',
  `name` varchar(32) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `version` int(11) NOT NULL DEFAULT '0',
  `base_dn` varchar(255) DEFAULT NULL,
  `referrals` int(11) NOT NULL DEFAULT '0',
  `tls` int(11) NOT NULL DEFAULT '0',
  `bind_type` int(11) NOT NULL DEFAULT '0',
  `bind_user` varchar(255) DEFAULT NULL,
  `bind_pass` varchar(100) DEFAULT NULL,
  `search_base` varchar(255) DEFAULT NULL,
  `user_scope` tinyint(4) NOT NULL DEFAULT '0',
  `user_attribute` varchar(255) DEFAULT NULL,
  `filter` varchar(512) DEFAULT NULL,
  `group_dn` varchar(255) DEFAULT NULL,
  `group_scope` tinyint(4) NOT NULL DEFAULT '0',
  `group_filter` varchar(255) DEFAULT NULL,
  `group_member` varchar(255) DEFAULT NULL,
  `group_memberisdn` tinyint(4) NOT NULL DEFAULT '0',
  `group_name` varchar(255) DEFAULT NULL,
  `group_attribute` varchar(64) DEFAULT NULL,
  `group_optional` tinyint(4) NOT NULL DEFAULT '0',
  `group_user_filter` varchar(255) DEFAULT NULL,
  `sync_on_login` tinyint(4) NOT NULL DEFAULT '0',
  `sync_per_cron` tinyint(4) NOT NULL DEFAULT '0',
  `role_sync_active` tinyint(4) NOT NULL DEFAULT '0',
  `role_bind_dn` varchar(255) DEFAULT NULL,
  `role_bind_pass` varchar(100) DEFAULT NULL,
  `migration` tinyint(4) NOT NULL DEFAULT '0',
  `authentication` tinyint(4) NOT NULL DEFAULT '1',
  `authentication_type` tinyint(4) NOT NULL DEFAULT '0',
  `username_filter` varchar(255) DEFAULT NULL,
  `escape_dn` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldap_server_settings`
--


--
-- Table structure for table `ldap_server_settings_seq`
--

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

--
-- Dumping data for table `ldap_server_settings_seq`
--


--
-- Table structure for table `ldoc_acceptance_track`
--

CREATE TABLE `ldoc_acceptance_track` (
  `tosv_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `ts` int(11) NOT NULL DEFAULT '0',
  `criteria` longtext,
  PRIMARY KEY (`tosv_id`,`usr_id`,`ts`),
  KEY `i1_idx` (`usr_id`,`ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldoc_acceptance_track`
--


--
-- Table structure for table `ldoc_acceptance_track_seq`
--

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

--
-- Dumping data for table `ldoc_acceptance_track_seq`
--


--
-- Table structure for table `ldoc_criteria`
--

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


--
-- Table structure for table `ldoc_criteria_seq`
--

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

--
-- Dumping data for table `ldoc_criteria_seq`
--


--
-- Table structure for table `ldoc_documents`
--

CREATE TABLE `ldoc_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,
  `provider` varchar(255) NOT NULL DEFAULT 'tos',
  `hash` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT 'html',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldoc_documents`
--


--
-- Table structure for table `ldoc_documents_seq`
--

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

--
-- Dumping data for table `ldoc_documents_seq`
--


--
-- Table structure for table `ldoc_versions`
--

CREATE TABLE `ldoc_versions` (
  `id` int(11) NOT NULL DEFAULT '0',
  `text` longtext,
  `hash` varchar(32) DEFAULT NULL,
  `ts` int(11) NOT NULL DEFAULT '0',
  `doc_id` int(11) NOT NULL DEFAULT '0',
  `title` text,
  `type` varchar(255) NOT NULL DEFAULT 'html',
  `provider` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`hash`,`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ldoc_versions`
--


--
-- Table structure for table `ldoc_versions_seq`
--

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

--
-- Dumping data for table `ldoc_versions_seq`
--


--
-- Table structure for table `like_data`
--

CREATE TABLE `like_data` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(40) NOT NULL,
  `sub_obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_obj_type` varchar(40) NOT NULL,
  `news_id` int(11) NOT NULL DEFAULT '0',
  `like_type` int(11) NOT NULL DEFAULT '0',
  `exp_ts` datetime NOT NULL,
  PRIMARY KEY (`user_id`,`obj_id`,`obj_type`,`sub_obj_id`,`sub_obj_type`,`news_id`,`like_type`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `like_data`
--


--
-- Table structure for table `link_check`
--

CREATE TABLE `link_check` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `parent_type` varchar(8) DEFAULT NULL,
  `http_status_code` int(11) NOT NULL DEFAULT '0',
  `last_check` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `link_check`
--


--
-- Table structure for table `link_check_report`
--

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

--
-- Dumping data for table `link_check_report`
--


--
-- Table structure for table `link_check_seq`
--

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

--
-- Dumping data for table `link_check_seq`
--


--
-- Table structure for table `lm_data`
--

CREATE TABLE `lm_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `type` char(2) DEFAULT NULL,
  `lm_id` int(11) NOT NULL DEFAULT '0',
  `import_id` varchar(50) DEFAULT NULL,
  `public_access` char(1) DEFAULT 'n',
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `active` char(1) DEFAULT 'y',
  `layout` varchar(100) DEFAULT NULL,
  `short_title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`lm_id`),
  KEY `i2_idx` (`type`),
  KEY `im_idx` (`import_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lm_data`
--

INSERT INTO `lm_data` VALUES (1,'dummy','du',0,'','n',NULL,NULL,'y','',NULL);

--
-- Table structure for table `lm_data_seq`
--

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

--
-- Dumping data for table `lm_data_seq`
--

INSERT INTO `lm_data_seq` VALUES (1);

--
-- Table structure for table `lm_data_transl`
--

CREATE TABLE `lm_data_transl` (
  `id` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(2) NOT NULL DEFAULT '',
  `title` varchar(200) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `short_title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lm_data_transl`
--


--
-- Table structure for table `lm_glossaries`
--

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

--
-- Dumping data for table `lm_glossaries`
--


--
-- Table structure for table `lm_menu`
--

CREATE TABLE `lm_menu` (
  `id` int(11) NOT NULL DEFAULT '0',
  `lm_id` int(11) NOT NULL DEFAULT '0',
  `link_type` char(6) DEFAULT 'extern',
  `title` varchar(200) DEFAULT NULL,
  `target` varchar(200) DEFAULT NULL,
  `link_ref_id` int(11) DEFAULT NULL,
  `active` char(1) DEFAULT 'n',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`link_type`),
  KEY `i2_idx` (`lm_id`),
  KEY `i3_idx` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lm_menu`
--


--
-- Table structure for table `lm_menu_seq`
--

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

--
-- Dumping data for table `lm_menu_seq`
--


--
-- Table structure for table `lm_read_event`
--

CREATE TABLE `lm_read_event` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `read_count` int(11) NOT NULL DEFAULT '0',
  `spent_seconds` int(11) NOT NULL DEFAULT '0',
  `last_access` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lm_read_event`
--


--
-- Table structure for table `lm_tree`
--

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

--
-- Dumping data for table `lm_tree`
--


--
-- Table structure for table `lng_data`
--

CREATE TABLE `lng_data` (
  `module` varchar(30) NOT NULL DEFAULT ' ',
  `identifier` varchar(200) NOT NULL DEFAULT ' ',
  `lang_key` char(2) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  `local_change` datetime DEFAULT NULL,
  `remarks` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`module`,`identifier`,`lang_key`),
  KEY `i1_idx` (`module`),
  KEY `i2_idx` (`lang_key`),
  KEY `i3_idx` (`local_change`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lng_data`
--




--
-- Table structure for table `lng_log`
--

CREATE TABLE `lng_log` (
  `module` varchar(30) NOT NULL DEFAULT '',
  `identifier` varchar(200) NOT NULL DEFAULT ' ',
  PRIMARY KEY (`module`,`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lng_log`
--


--
-- Table structure for table `lng_modules`
--

CREATE TABLE `lng_modules` (
  `module` varchar(30) NOT NULL DEFAULT ' ',
  `lang_key` char(2) NOT NULL DEFAULT '',
  `lang_array` longtext,
  PRIMARY KEY (`module`,`lang_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lng_modules`
--




--
-- Table structure for table `lo_access`
--

CREATE TABLE `lo_access` (
  `timestamp` datetime DEFAULT NULL,
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `lm_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `lm_title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`usr_id`,`lm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lo_access`
--


--
-- Table structure for table `loc_rnd_qpl`
--

CREATE TABLE `loc_rnd_qpl` (
  `container_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `tst_type` tinyint(4) NOT NULL DEFAULT '0',
  `tst_id` int(11) NOT NULL DEFAULT '0',
  `qp_seq` int(11) NOT NULL DEFAULT '0',
  `percentage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`container_id`,`objective_id`,`tst_type`,`tst_id`,`qp_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loc_rnd_qpl`
--


--
-- Table structure for table `loc_settings`
--

CREATE TABLE `loc_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `itest` int(11) DEFAULT NULL,
  `qtest` int(11) DEFAULT NULL,
  `qt_vis_all` tinyint(4) DEFAULT '1',
  `qt_vis_obj` tinyint(4) DEFAULT '0',
  `reset_results` tinyint(4) DEFAULT '0',
  `it_type` tinyint(4) DEFAULT '5',
  `qt_type` tinyint(4) DEFAULT '1',
  `it_start` tinyint(4) DEFAULT '1',
  `qt_start` tinyint(4) DEFAULT '1',
  `passed_obj_mode` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`itest`),
  KEY `i2_idx` (`qtest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loc_settings`
--


--
-- Table structure for table `loc_tst_assignments`
--

CREATE TABLE `loc_tst_assignments` (
  `assignment_id` int(11) NOT NULL DEFAULT '0',
  `container_id` int(11) NOT NULL DEFAULT '0',
  `assignment_type` tinyint(4) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `tst_ref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`assignment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loc_tst_assignments`
--


--
-- Table structure for table `loc_tst_assignments_seq`
--

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

--
-- Dumping data for table `loc_tst_assignments_seq`
--


--
-- Table structure for table `loc_tst_run`
--

CREATE TABLE `loc_tst_run` (
  `container_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `test_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `max_points` int(11) DEFAULT '0',
  `questions` varchar(1000) DEFAULT '0',
  PRIMARY KEY (`container_id`,`user_id`,`test_id`,`objective_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loc_tst_run`
--


--
-- Table structure for table `loc_user_results`
--

CREATE TABLE `loc_user_results` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `course_id` int(11) NOT NULL DEFAULT '0',
  `objective_id` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `result_perc` tinyint(4) DEFAULT '0',
  `limit_perc` tinyint(4) DEFAULT '0',
  `tries` tinyint(4) DEFAULT '0',
  `is_final` tinyint(4) DEFAULT '0',
  `tstamp` int(11) DEFAULT '0',
  PRIMARY KEY (`user_id`,`course_id`,`objective_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loc_user_results`
--


--
-- Table structure for table `log_components`
--

CREATE TABLE `log_components` (
  `component_id` varchar(20) NOT NULL DEFAULT '',
  `log_level` int(11) DEFAULT NULL,
  PRIMARY KEY (`component_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `log_components`
--

INSERT INTO `log_components` VALUES ('ac',0),('adms',NULL),('adn',NULL),('amet',NULL),('auth',0),('awrn',0),('bgtk',NULL),('book',NULL),('cal',NULL),('cat',NULL),('cert',NULL),('chtr',0),('cmix',NULL),('cont',NULL),('contact',0),('copg',0),('cron',NULL),('crs',0),('crsr',NULL),('data_pro',NULL),('db',0),('ds',NULL),('evnt',NULL),('exc',NULL),('exp',0),('file',0),('fils',NULL),('frm',NULL),('glo',0),('grp',0),('init',0),('irss',NULL),('lang',NULL),('ldoc',NULL),('lhist',NULL),('lm',0),('log',0),('log_root',0),('lti',NULL),('ltis',NULL),('mail',0),('mcst',NULL),('mep',NULL),('meta',NULL),('mmbr',NULL),('mme',NULL),('mob',0),('news',NULL),('nota',NULL),('note',NULL),('noti',NULL),('obj',0),('osch',NULL),('otpl',0),('pdfg',NULL),('pwsp',NULL),('rep',0),('rnd',NULL),('sc13',NULL),('sess',NULL),('skll',0),('spl',NULL),('src',0),('styl',NULL),('svy',NULL),('sysc',NULL),('tos',NULL),('trac',NULL),('tree',0),('user',0),('wbdv',NULL),('webr',0),('wiki',NULL),('wopi',NULL),('wsrv',0);

--
-- Table structure for table `loginname_history`
--

CREATE TABLE `loginname_history` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `login` varchar(80) NOT NULL DEFAULT '',
  `history_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`login`,`history_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loginname_history`
--


--
-- Table structure for table `lso_activation`
--

CREATE TABLE `lso_activation` (
  `ref_id` int(11) NOT NULL,
  `online` tinyint(4) NOT NULL DEFAULT '0',
  `effective_online` tinyint(4) NOT NULL DEFAULT '0',
  `activation_start_ts` int(11) DEFAULT NULL,
  `activation_end_ts` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lso_activation`
--


--
-- Table structure for table `lso_settings`
--

CREATE TABLE `lso_settings` (
  `obj_id` int(11) NOT NULL,
  `abstract` longtext,
  `extro` longtext,
  `abstract_image` varchar(128) DEFAULT NULL,
  `extro_image` varchar(128) DEFAULT NULL,
  `gallery` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lso_settings`
--


--
-- Table structure for table `lso_states`
--

CREATE TABLE `lso_states` (
  `lso_ref_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `current_item` int(11) DEFAULT NULL,
  `states` longtext,
  `first_access` varchar(32) DEFAULT NULL,
  `last_access` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`lso_ref_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lso_states`
--


--
-- Table structure for table `lti2_access_token`
--

CREATE TABLE `lti2_access_token` (
  `consumer_pk` int(11) NOT NULL,
  `scopes` longtext NOT NULL,
  `token` varchar(2000) NOT NULL DEFAULT '',
  `expires` datetime NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`consumer_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_access_token`
--


--
-- Table structure for table `lti2_consumer`
--

CREATE TABLE `lti2_consumer` (
  `consumer_pk` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `consumer_key` varchar(255) DEFAULT NULL,
  `secret` varchar(1024) NOT NULL,
  `lti_version` varchar(10) DEFAULT NULL,
  `consumer_name` varchar(255) DEFAULT NULL,
  `consumer_version` varchar(255) DEFAULT NULL,
  `consumer_guid` varchar(1024) DEFAULT NULL,
  `profile` longblob,
  `tool_proxy` longblob,
  `settings` longtext,
  `protected` tinyint(4) NOT NULL,
  `enabled` tinyint(4) NOT NULL,
  `enable_from` datetime DEFAULT NULL,
  `enable_until` datetime DEFAULT NULL,
  `last_access` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `ext_consumer_id` int(11) NOT NULL,
  `ref_id` int(11) NOT NULL,
  `signature_method` varchar(15) NOT NULL DEFAULT 'HMAC-SHA1',
  `platform_id` varchar(255) DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `deployment_id` varchar(255) DEFAULT NULL,
  `public_key` longtext,
  PRIMARY KEY (`consumer_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_consumer`
--


--
-- Table structure for table `lti2_consumer_seq`
--

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

--
-- Dumping data for table `lti2_consumer_seq`
--


--
-- Table structure for table `lti2_context`
--

CREATE TABLE `lti2_context` (
  `context_pk` int(11) NOT NULL,
  `consumer_pk` int(11) NOT NULL,
  `lti_context_id` varchar(255) NOT NULL,
  `settings` longblob,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`context_pk`),
  KEY `i1_idx` (`consumer_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_context`
--


--
-- Table structure for table `lti2_context_seq`
--

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

--
-- Dumping data for table `lti2_context_seq`
--


--
-- Table structure for table `lti2_nonce`
--

CREATE TABLE `lti2_nonce` (
  `consumer_pk` int(11) NOT NULL,
  `value` varchar(50) NOT NULL DEFAULT '',
  `expires` datetime NOT NULL,
  PRIMARY KEY (`consumer_pk`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_nonce`
--


--
-- Table structure for table `lti2_resource_link`
--

CREATE TABLE `lti2_resource_link` (
  `resource_link_pk` int(11) NOT NULL DEFAULT '0',
  `context_pk` int(11) DEFAULT NULL,
  `consumer_pk` int(11) DEFAULT NULL,
  `lti_resource_link_id` varchar(255) NOT NULL,
  `settings` longblob,
  `primary_resource_link_pk` int(11) DEFAULT NULL,
  `share_approved` tinyint(4) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`resource_link_pk`),
  KEY `i1_idx` (`consumer_pk`),
  KEY `i2_idx` (`context_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_resource_link`
--


--
-- Table structure for table `lti2_resource_link_seq`
--

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

--
-- Dumping data for table `lti2_resource_link_seq`
--


--
-- Table structure for table `lti2_share_key`
--

CREATE TABLE `lti2_share_key` (
  `share_key_id` varchar(32) NOT NULL,
  `resource_link_pk` int(11) NOT NULL,
  `auto_approve` tinyint(4) NOT NULL,
  `expires` datetime NOT NULL,
  PRIMARY KEY (`share_key_id`),
  KEY `i1_idx` (`resource_link_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_share_key`
--


--
-- Table structure for table `lti2_tool_proxy`
--

CREATE TABLE `lti2_tool_proxy` (
  `tool_proxy_pk` int(11) NOT NULL,
  `tool_proxy_id` varchar(32) NOT NULL,
  `consumer_pk` int(11) NOT NULL,
  `tool_proxy` longblob NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`tool_proxy_pk`),
  UNIQUE KEY `u1_idx` (`tool_proxy_id`),
  KEY `i1_idx` (`consumer_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_tool_proxy`
--


--
-- Table structure for table `lti2_tool_proxy_seq`
--

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

--
-- Dumping data for table `lti2_tool_proxy_seq`
--


--
-- Table structure for table `lti2_user_result`
--

CREATE TABLE `lti2_user_result` (
  `user_pk` int(11) NOT NULL DEFAULT '0',
  `resource_link_pk` int(11) NOT NULL,
  `lti_user_id` varchar(255) NOT NULL,
  `lti_result_sourcedid` varchar(1024) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`user_pk`),
  KEY `i1_idx` (`resource_link_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti2_user_result`
--


--
-- Table structure for table `lti2_user_result_seq`
--

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

--
-- Dumping data for table `lti2_user_result_seq`
--


--
-- Table structure for table `lti_consumer_grades`
--

CREATE TABLE `lti_consumer_grades` (
  `id` int(11) NOT NULL,
  `obj_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `score_given` double DEFAULT NULL,
  `score_maximum` double DEFAULT NULL,
  `activity_progress` varchar(20) NOT NULL,
  `grading_progress` varchar(20) NOT NULL,
  `lti_timestamp` datetime DEFAULT NULL,
  `stored` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_consumer_grades`
--


--
-- Table structure for table `lti_consumer_grades_seq`
--

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

--
-- Dumping data for table `lti_consumer_grades_seq`
--


--
-- Table structure for table `lti_consumer_results`
--

CREATE TABLE `lti_consumer_results` (
  `id` int(11) NOT NULL,
  `obj_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `result` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_consumer_results`
--


--
-- Table structure for table `lti_consumer_results_seq`
--

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

--
-- Dumping data for table `lti_consumer_results_seq`
--


--
-- Table structure for table `lti_consumer_settings`
--

CREATE TABLE `lti_consumer_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `provider_id` int(11) NOT NULL DEFAULT '0',
  `launch_method` varchar(16) NOT NULL DEFAULT '',
  `offline_status` tinyint(4) NOT NULL DEFAULT '1',
  `show_statements` tinyint(4) NOT NULL DEFAULT '0',
  `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',
  `mastery_score` double NOT NULL DEFAULT '0.5',
  `keep_lp` tinyint(4) NOT NULL DEFAULT '0',
  `use_xapi` tinyint(4) NOT NULL DEFAULT '0',
  `activity_id` varchar(128) DEFAULT NULL,
  `launch_key` varchar(255) DEFAULT NULL,
  `launch_secret` varchar(255) DEFAULT NULL,
  `custom_params` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_consumer_settings`
--


--
-- Table structure for table `lti_ext_consumer`
--

CREATE TABLE `lti_ext_consumer` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `prefix` varchar(255) NOT NULL,
  `user_language` varchar(255) NOT NULL,
  `role` int(11) NOT NULL DEFAULT '0',
  `local_role_always_member` tinyint(4) NOT NULL DEFAULT '0',
  `default_skin` varchar(50) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_ext_consumer`
--


--
-- Table structure for table `lti_ext_consumer_otype`
--

CREATE TABLE `lti_ext_consumer_otype` (
  `consumer_id` int(11) NOT NULL DEFAULT '0',
  `object_type` varchar(255) NOT NULL,
  PRIMARY KEY (`consumer_id`,`object_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_ext_consumer_otype`
--


--
-- Table structure for table `lti_ext_consumer_seq`
--

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

--
-- Dumping data for table `lti_ext_consumer_seq`
--


--
-- Table structure for table `lti_ext_provider`
--

CREATE TABLE `lti_ext_provider` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `availability` smallint(6) NOT NULL DEFAULT '1',
  `remarks` varchar(4000) DEFAULT NULL,
  `time_to_delete` int(11) DEFAULT NULL,
  `provider_url` varchar(255) NOT NULL,
  `provider_key` varchar(128) NOT NULL,
  `provider_secret` varchar(128) NOT NULL,
  `provider_key_customizable` tinyint(4) NOT NULL DEFAULT '0',
  `provider_icon` varchar(255) DEFAULT NULL,
  `provider_xml` longtext,
  `external_provider` tinyint(4) NOT NULL DEFAULT '0',
  `launch_method` varchar(32) DEFAULT NULL,
  `has_outcome` tinyint(4) NOT NULL DEFAULT '0',
  `mastery_score` double DEFAULT NULL,
  `keep_lp` tinyint(4) NOT NULL DEFAULT '0',
  `privacy_comment_default` varchar(2000) NOT NULL,
  `creator` int(11) DEFAULT NULL,
  `accepted_by` int(11) DEFAULT NULL,
  `global` tinyint(4) NOT NULL DEFAULT '0',
  `use_xapi` tinyint(4) NOT NULL DEFAULT '0',
  `xapi_launch_key` varchar(64) DEFAULT NULL,
  `xapi_launch_secret` varchar(64) DEFAULT NULL,
  `xapi_launch_url` varchar(255) DEFAULT NULL,
  `custom_params` varchar(1020) DEFAULT NULL,
  `use_provider_id` tinyint(4) NOT NULL DEFAULT '0',
  `always_learner` tinyint(4) NOT NULL DEFAULT '0',
  `xapi_activity_id` varchar(128) DEFAULT NULL,
  `keywords` varchar(1000) DEFAULT NULL,
  `inc_usr_pic` tinyint(4) NOT NULL DEFAULT '0',
  `category` varchar(16) NOT NULL DEFAULT '',
  `privacy_ident` smallint(6) NOT NULL DEFAULT '0',
  `privacy_name` smallint(6) NOT NULL DEFAULT '0',
  `instructor_send_name` tinyint(4) NOT NULL DEFAULT '0',
  `instructor_send_email` tinyint(4) NOT NULL DEFAULT '0',
  `client_id` varchar(255) DEFAULT NULL,
  `enabled_capability` longtext,
  `key_type` varchar(16) DEFAULT NULL,
  `public_key` longtext,
  `public_keyset` varchar(255) DEFAULT NULL,
  `initiate_login` varchar(255) DEFAULT NULL,
  `redirection_uris` varchar(510) DEFAULT NULL,
  `content_item` tinyint(4) NOT NULL DEFAULT '0',
  `content_item_url` varchar(510) DEFAULT NULL,
  `grade_synchronization` tinyint(4) NOT NULL DEFAULT '0',
  `lti_version` varchar(10) NOT NULL DEFAULT 'LTI-1p0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_ext_provider`
--


--
-- Table structure for table `lti_ext_provider_seq`
--

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

--
-- Dumping data for table `lti_ext_provider_seq`
--


--
-- Table structure for table `lti_int_provider_obj`
--

CREATE TABLE `lti_int_provider_obj` (
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `ext_consumer_id` int(11) NOT NULL DEFAULT '0',
  `admin` int(11) DEFAULT NULL,
  `tutor` int(11) DEFAULT NULL,
  `member` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref_id`,`ext_consumer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lti_int_provider_obj`
--


--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `mail_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `folder_id` int(11) NOT NULL DEFAULT '0',
  `sender_id` int(11) DEFAULT NULL,
  `send_time` datetime DEFAULT NULL,
  `m_status` varchar(16) DEFAULT NULL,
  `m_subject` varchar(255) DEFAULT NULL,
  `import_name` varchar(4000) DEFAULT NULL,
  `use_placeholders` tinyint(4) NOT NULL DEFAULT '0',
  `m_message` longtext,
  `rcp_to` longtext,
  `rcp_cc` longtext,
  `rcp_bcc` longtext,
  `attachments` longtext,
  `tpl_ctx_id` varchar(100) DEFAULT NULL,
  `tpl_ctx_params` longblob,
  PRIMARY KEY (`mail_id`),
  KEY `i1_idx` (`user_id`),
  KEY `i2_idx` (`folder_id`),
  KEY `i3_idx` (`m_status`),
  KEY `i4_idx` (`sender_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail`
--


--
-- Table structure for table `mail_attachment`
--

CREATE TABLE `mail_attachment` (
  `mail_id` int(11) NOT NULL DEFAULT '0',
  `path` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`mail_id`),
  KEY `i1_idx` (`path`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_attachment`
--


--
-- Table structure for table `mail_auto_responder`
--

CREATE TABLE `mail_auto_responder` (
  `sender_id` bigint(20) NOT NULL,
  `receiver_id` bigint(20) NOT NULL,
  `sent_time` datetime NOT NULL,
  PRIMARY KEY (`sender_id`,`receiver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_auto_responder`
--


--
-- Table structure for table `mail_cron_orphaned`
--

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

--
-- Dumping data for table `mail_cron_orphaned`
--


--
-- Table structure for table `mail_man_tpl`
--

CREATE TABLE `mail_man_tpl` (
  `tpl_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `context` varchar(100) NOT NULL DEFAULT '',
  `lang` varchar(2) NOT NULL DEFAULT '',
  `m_subject` varchar(255) DEFAULT NULL,
  `m_message` longtext,
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tpl_id`),
  KEY `i1_idx` (`context`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_man_tpl`
--


--
-- Table structure for table `mail_man_tpl_seq`
--

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

--
-- Dumping data for table `mail_man_tpl_seq`
--


--
-- Table structure for table `mail_obj_data`
--

CREATE TABLE `mail_obj_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `title` char(70) DEFAULT NULL,
  `m_type` char(16) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`user_id`,`m_type`),
  KEY `i2_idx` (`obj_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_obj_data`
--

INSERT INTO `mail_obj_data` VALUES (2,6,'a_root','root'),(3,6,'b_inbox','inbox'),(4,6,'c_trash','trash'),(5,6,'d_drafts','drafts'),(6,6,'e_sent','sent'),(7,6,'z_local','local');

--
-- Table structure for table `mail_obj_data_seq`
--

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

--
-- Dumping data for table `mail_obj_data_seq`
--

INSERT INTO `mail_obj_data_seq` VALUES (8);

--
-- Table structure for table `mail_options`
--

CREATE TABLE `mail_options` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `signature` varchar(4000) DEFAULT NULL,
  `incoming_type` tinyint(4) DEFAULT NULL,
  `cronjob_notification` tinyint(4) NOT NULL DEFAULT '0',
  `mail_address_option` tinyint(4) NOT NULL DEFAULT '3',
  `absence_status` tinyint(4) NOT NULL DEFAULT '0',
  `absent_from` bigint(20) NOT NULL DEFAULT '0',
  `absent_until` bigint(20) NOT NULL DEFAULT '0',
  `absence_ar_body` longtext,
  `absence_ar_subject` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `i1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_options`
--

INSERT INTO `mail_options` VALUES (6,'',0,0,3,0,0,0,NULL,NULL);

--
-- Table structure for table `mail_saved`
--

CREATE TABLE `mail_saved` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `m_email` tinyint(4) DEFAULT NULL,
  `m_subject` varchar(255) DEFAULT NULL,
  `use_placeholders` tinyint(4) NOT NULL DEFAULT '0',
  `m_message` longtext,
  `rcp_to` longtext,
  `rcp_cc` longtext,
  `rcp_bcc` longtext,
  `attachments` longtext,
  `tpl_ctx_id` varchar(100) DEFAULT NULL,
  `tpl_ctx_params` longblob,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_saved`
--


--
-- Table structure for table `mail_seq`
--

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

--
-- Dumping data for table `mail_seq`
--


--
-- Table structure for table `mail_template`
--

CREATE TABLE `mail_template` (
  `lang` varchar(5) NOT NULL DEFAULT ' ',
  `subject` varchar(200) DEFAULT NULL,
  `body` longtext,
  `sal_f` varchar(200) DEFAULT NULL,
  `sal_m` varchar(200) DEFAULT NULL,
  `sal_g` varchar(200) DEFAULT NULL,
  `type` varchar(4) NOT NULL DEFAULT ' ',
  `att_file` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`type`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_template`
--


--
-- Table structure for table `mail_tpl_ctx`
--

CREATE TABLE `mail_tpl_ctx` (
  `id` varchar(100) NOT NULL DEFAULT '',
  `component` varchar(100) NOT NULL DEFAULT '',
  `class` varchar(100) NOT NULL DEFAULT '',
  `path` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mail_tpl_ctx`
--

INSERT INTO `mail_tpl_ctx` VALUES ('crs_context_member_manual','Modules/Course','ilCourseMailTemplateMemberContext',NULL),('crs_context_tutor_manual','Modules/Course','ilCourseMailTemplateTutorContext',NULL),('exc_context_grade_rmd','Modules/Exercise','ilExcMailTemplateGradeReminderContext',NULL),('exc_context_peer_rmd','Modules/Exercise','ilExcMailTemplatePeerReminderContext',NULL),('exc_context_submit_rmd','Modules/Exercise','ilExcMailTemplateSubmitReminderContext',NULL),('mail_template_generic','Services/Mail','ilMailTemplateGenericContext',NULL),('prg_context_manual','Modules/StudyProgramme','ilStudyProgrammeMailTemplateContext',NULL),('sahs_context_lp','Modules/ScormAicc','ilScormMailTemplateLPContext',NULL),('sess_context_participant_manual','Modules/Session','ilSessionMailTemplateParticipantContext',NULL),('svy_context_rmd','Modules/Survey','ilSurveyMailTemplateReminderContext',NULL),('svy_rater_inv','Modules/Survey','ilSurveyMailTemplateRaterInvitationContext',NULL);

--
-- Table structure for table `mail_tree`
--

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

--
-- Dumping data for table `mail_tree`
--

INSERT INTO `mail_tree` VALUES (6,2,0,1,12,1),(6,3,2,2,3,2),(6,4,2,4,5,2),(6,5,2,6,7,2),(6,6,2,8,9,2),(6,7,2,10,11,2);

--
-- Table structure for table `manscoring_done`
--

CREATE TABLE `manscoring_done` (
  `active_id` bigint(20) NOT NULL,
  `done` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`active_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `manscoring_done`
--


--
-- Table structure for table `map_area`
--

CREATE TABLE `map_area` (
  `item_id` int(11) NOT NULL DEFAULT '0',
  `nr` int(11) NOT NULL DEFAULT '0',
  `shape` varchar(20) DEFAULT NULL,
  `coords` varchar(4000) DEFAULT NULL,
  `link_type` char(3) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `href` varchar(800) DEFAULT NULL,
  `target` varchar(50) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `target_frame` varchar(50) DEFAULT NULL,
  `highlight_mode` varchar(8) DEFAULT NULL,
  `highlight_class` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`item_id`,`nr`),
  KEY `lt_idx` (`link_type`,`target`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `map_area`
--


--
-- Table structure for table `media_item`
--

CREATE TABLE `media_item` (
  `id` int(11) NOT NULL DEFAULT '0',
  `width` varchar(10) DEFAULT NULL,
  `height` varchar(10) DEFAULT NULL,
  `halign` char(10) DEFAULT 'Left',
  `caption` varchar(3000) DEFAULT NULL,
  `nr` int(11) NOT NULL DEFAULT '0',
  `purpose` char(20) DEFAULT 'Standard',
  `mob_id` int(11) NOT NULL DEFAULT '0',
  `location` varchar(200) DEFAULT NULL,
  `location_type` char(10) DEFAULT 'LocalFile',
  `format` varchar(200) DEFAULT NULL,
  `param` varchar(2000) DEFAULT NULL,
  `tried_thumb` char(1) DEFAULT 'n',
  `text_representation` varchar(4000) DEFAULT NULL,
  `upload_hash` varchar(100) DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `media_item`
--


--
-- Table structure for table `media_item_seq`
--

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

--
-- Dumping data for table `media_item_seq`
--


--
-- Table structure for table `member_agreement`
--

CREATE TABLE `member_agreement` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `accepted` tinyint(4) NOT NULL DEFAULT '0',
  `acceptance_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `member_agreement`
--


--
-- Table structure for table `member_noti`
--

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

--
-- Dumping data for table `member_noti`
--


--
-- Table structure for table `member_noti_user`
--

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

--
-- Dumping data for table `member_noti_user`
--


--
-- Table structure for table `mep_data`
--

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

--
-- Dumping data for table `mep_data`
--


--
-- Table structure for table `mep_item`
--

CREATE TABLE `mep_item` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(10) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `foreign_id` int(11) DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `ft_idx` (`foreign_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mep_item`
--

INSERT INTO `mep_item` VALUES (1,'dummy','Dummy',1,'');

--
-- Table structure for table `mep_item_seq`
--

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

--
-- Dumping data for table `mep_item_seq`
--

INSERT INTO `mep_item_seq` VALUES (1);

--
-- Table structure for table `mep_tree`
--

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

--
-- Dumping data for table `mep_tree`
--


--
-- Table structure for table `mob_parameter`
--

CREATE TABLE `mob_parameter` (
  `med_item_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `value` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`med_item_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mob_parameter`
--


--
-- Table structure for table `mob_usage`
--

CREATE TABLE `mob_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`),
  KEY `mi_idx` (`id`),
  KEY `i1_idx` (`usage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mob_usage`
--


--
-- Table structure for table `note`
--

CREATE TABLE `note` (
  `id` int(11) NOT NULL DEFAULT '0',
  `rep_obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(10) DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `author` int(11) NOT NULL DEFAULT '0',
  `note_text` longtext,
  `label` int(11) NOT NULL DEFAULT '0',
  `creation_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `subject` varchar(200) DEFAULT NULL,
  `no_repository` tinyint(4) DEFAULT '0',
  `news_id` int(11) NOT NULL DEFAULT '0',
  `recipient` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`author`),
  KEY `i2_idx` (`rep_obj_id`,`obj_id`,`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `note`
--


--
-- Table structure for table `note_seq`
--

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

--
-- Dumping data for table `note_seq`
--


--
-- Table structure for table `note_settings`
--

CREATE TABLE `note_settings` (
  `rep_obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(10) NOT NULL DEFAULT '-',
  `activated` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rep_obj_id`,`obj_id`,`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `note_settings`
--


--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `last_mail` datetime DEFAULT NULL,
  `page_id` int(11) DEFAULT '0',
  `activated` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`type`,`id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification`
--


--
-- Table structure for table `notification_channels`
--

CREATE TABLE `notification_channels` (
  `channel_name` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(4000) NOT NULL DEFAULT '',
  `class` varchar(100) NOT NULL DEFAULT '',
  `include` varchar(100) NOT NULL DEFAULT '',
  `config_type` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`channel_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_channels`
--

INSERT INTO `notification_channels` VALUES ('mail','mail','mail_desc','ilNotificationMailHandler','Services/Notifications/classes/class.ilNotificationMailHandler.php','set_by_admin'),('osd','osd','osd_desc','ilNotificationOSDHandler','Services/Notifications/classes/class.ilNotificationOSDHandler.php','set_by_admin');

--
-- Table structure for table `notification_data`
--

CREATE TABLE `notification_data` (
  `notification_id` int(11) NOT NULL DEFAULT '0',
  `serialized` varchar(4000) NOT NULL DEFAULT '',
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_data`
--


--
-- Table structure for table `notification_data_seq`
--

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

--
-- Dumping data for table `notification_data_seq`
--


--
-- Table structure for table `notification_listener`
--

CREATE TABLE `notification_listener` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `module` varchar(100) NOT NULL DEFAULT '',
  `sender_id` int(11) NOT NULL DEFAULT '0',
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`usr_id`,`module`,`sender_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_listener`
--


--
-- Table structure for table `notification_osd`
--

CREATE TABLE `notification_osd` (
  `notification_osd_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `serialized` varchar(4000) NOT NULL DEFAULT '',
  `valid_until` int(11) NOT NULL DEFAULT '0',
  `time_added` int(11) NOT NULL DEFAULT '0',
  `type` varchar(100) NOT NULL DEFAULT '',
  `visible_for` int(11) NOT NULL DEFAULT '0',
  `identification` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`notification_osd_id`),
  KEY `i1_idx` (`usr_id`,`type`,`time_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_osd`
--


--
-- Table structure for table `notification_osd_seq`
--

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

--
-- Dumping data for table `notification_osd_seq`
--


--
-- Table structure for table `notification_queue`
--

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

--
-- Dumping data for table `notification_queue`
--


--
-- Table structure for table `notification_types`
--

CREATE TABLE `notification_types` (
  `type_name` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(100) NOT NULL DEFAULT '',
  `notification_group` varchar(100) NOT NULL DEFAULT '',
  `config_type` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_types`
--

INSERT INTO `notification_types` VALUES ('badge_received','badge_received','badge_received_desc','achievement','set_by_admin'),('buddysystem_request','buddysystem_request','buddysystem_request_desc','contact','set_by_admin'),('chat_invitation','chat_invitation','chat_invitation_description','chat','set_by_admin'),('lso_completion','lso_completion','lso_completion_description','lso','set_by_admin'),('osd_maint','osd_maint','osd_maint_description','osd_notification','set_by_admin'),('who_is_online','who_is_online','who_is_online_desc','user','set_by_admin');

--
-- Table structure for table `notification_usercfg`
--

CREATE TABLE `notification_usercfg` (
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `module` varchar(100) NOT NULL DEFAULT '',
  `channel` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`usr_id`,`module`,`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notification_usercfg`
--

INSERT INTO `notification_usercfg` VALUES (-1,'badge_received','osd'),(-1,'buddysystem_request','mail'),(-1,'buddysystem_request','osd'),(-1,'chat_invitation','mail'),(-1,'chat_invitation','osd'),(-1,'lso_completion','osd'),(-1,'who_is_online','osd');

--
-- Table structure for table `obj_content_master_lng`
--

CREATE TABLE `obj_content_master_lng` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `master_lang` varchar(2) NOT NULL DEFAULT '',
  `fallback_lang` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_content_master_lng`
--


--
-- Table structure for table `obj_lp_stat`
--

CREATE TABLE `obj_lp_stat` (
  `type` varchar(4) NOT NULL DEFAULT '',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `yyyy` smallint(6) NOT NULL DEFAULT '0',
  `mm` tinyint(4) NOT NULL DEFAULT '0',
  `dd` tinyint(4) NOT NULL DEFAULT '0',
  `fulldate` int(11) NOT NULL DEFAULT '0',
  `mem_cnt` int(11) DEFAULT NULL,
  `in_progress` int(11) DEFAULT NULL,
  `completed` int(11) DEFAULT NULL,
  `failed` int(11) DEFAULT NULL,
  `not_attempted` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`fulldate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_lp_stat`
--


--
-- Table structure for table `obj_members`
--

CREATE TABLE `obj_members` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `blocked` tinyint(4) NOT NULL DEFAULT '0',
  `notification` tinyint(4) NOT NULL DEFAULT '0',
  `passed` tinyint(4) DEFAULT NULL,
  `origin` int(11) DEFAULT '0',
  `origin_ts` int(11) DEFAULT '0',
  `contact` tinyint(4) DEFAULT '0',
  `admin` tinyint(4) DEFAULT '0',
  `tutor` tinyint(4) DEFAULT '0',
  `member` smallint(6) DEFAULT '0',
  PRIMARY KEY (`obj_id`,`usr_id`),
  KEY `i1_idx` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_members`
--


--
-- Table structure for table `obj_noti_settings`
--

CREATE TABLE `obj_noti_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `noti_mode` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_noti_settings`
--


--
-- Table structure for table `obj_stat`
--

CREATE TABLE `obj_stat` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(10) NOT NULL DEFAULT '',
  `yyyy` smallint(6) NOT NULL DEFAULT '0',
  `mm` tinyint(4) NOT NULL DEFAULT '0',
  `dd` tinyint(4) NOT NULL DEFAULT '0',
  `hh` tinyint(4) NOT NULL DEFAULT '0',
  `read_count` int(11) DEFAULT NULL,
  `childs_read_count` int(11) DEFAULT NULL,
  `spent_seconds` int(11) DEFAULT NULL,
  `childs_spent_seconds` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`yyyy`,`mm`,`dd`,`hh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_stat`
--


--
-- Table structure for table `obj_stat_log`
--

CREATE TABLE `obj_stat_log` (
  `log_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(10) NOT NULL DEFAULT '',
  `tstamp` int(11) DEFAULT NULL,
  `yyyy` smallint(6) DEFAULT NULL,
  `mm` tinyint(4) DEFAULT NULL,
  `dd` tinyint(4) DEFAULT NULL,
  `hh` tinyint(4) DEFAULT NULL,
  `read_count` int(11) DEFAULT NULL,
  `childs_read_count` int(11) DEFAULT NULL,
  `spent_seconds` int(11) DEFAULT NULL,
  `childs_spent_seconds` int(11) DEFAULT NULL,
  PRIMARY KEY (`log_id`),
  KEY `i1_idx` (`tstamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_stat_log`
--


--
-- Table structure for table `obj_stat_log_seq`
--

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

--
-- Dumping data for table `obj_stat_log_seq`
--


--
-- Table structure for table `obj_stat_tmp`
--

CREATE TABLE `obj_stat_tmp` (
  `log_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(10) NOT NULL DEFAULT '',
  `tstamp` int(11) DEFAULT NULL,
  `yyyy` smallint(6) DEFAULT NULL,
  `mm` tinyint(4) DEFAULT NULL,
  `dd` tinyint(4) DEFAULT NULL,
  `hh` tinyint(4) DEFAULT NULL,
  `read_count` int(11) DEFAULT NULL,
  `childs_read_count` int(11) DEFAULT NULL,
  `spent_seconds` int(11) DEFAULT NULL,
  `childs_spent_seconds` int(11) DEFAULT NULL,
  PRIMARY KEY (`log_id`),
  KEY `i1_idx` (`obj_id`,`obj_type`,`yyyy`,`mm`,`dd`,`hh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_stat_tmp`
--


--
-- Table structure for table `obj_type_stat`
--

CREATE TABLE `obj_type_stat` (
  `type` varchar(4) NOT NULL DEFAULT '',
  `yyyy` smallint(6) NOT NULL DEFAULT '0',
  `mm` tinyint(4) NOT NULL DEFAULT '0',
  `dd` tinyint(4) NOT NULL DEFAULT '0',
  `fulldate` int(11) NOT NULL DEFAULT '0',
  `cnt_references` int(11) DEFAULT NULL,
  `cnt_objects` int(11) DEFAULT NULL,
  `cnt_deleted` int(11) DEFAULT NULL,
  PRIMARY KEY (`type`,`fulldate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_type_stat`
--


--
-- Table structure for table `obj_user_data_hist`
--

CREATE TABLE `obj_user_data_hist` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `update_user` int(11) NOT NULL DEFAULT '0',
  `editing_time` datetime DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_user_data_hist`
--


--
-- Table structure for table `obj_user_stat`
--

CREATE TABLE `obj_user_stat` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `yyyy` smallint(6) NOT NULL DEFAULT '0',
  `mm` tinyint(4) NOT NULL DEFAULT '0',
  `dd` tinyint(4) NOT NULL DEFAULT '0',
  `fulldate` int(11) NOT NULL DEFAULT '0',
  `counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`fulldate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `obj_user_stat`
--


--
-- Table structure for table `object_data`
--

CREATE TABLE `object_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `type` char(4) NOT NULL DEFAULT 'none',
  `title` char(255) NOT NULL DEFAULT '',
  `description` char(128) NOT NULL DEFAULT '',
  `owner` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `import_id` char(255) DEFAULT NULL,
  `offline` tinyint(4) DEFAULT NULL,
  `tile_image_rid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`obj_id`),
  KEY `i1_idx` (`type`),
  KEY `i2_idx` (`title`),
  KEY `i4_idx` (`import_id`),
  KEY `i5_idx` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `object_data`
--

INSERT INTO `object_data` VALUES (1,'root','ILIAS','This is the root node of the system!!!',-1,'2002-06-24 15:15:03','2004-01-20 12:24:12','',NULL,NULL),(2,'role','Administrator','Role for systemadministrators. This role grants access to everything!',-1,'2002-01-16 15:31:45','2003-08-15 13:18:57','',NULL,NULL),(3,'rolt','Author','Role template for authors with write & create permissions.',-1,'2002-01-16 15:32:50','2016-12-16 14:58:27','',NULL,NULL),(4,'role','User','Standard role for registered users. Grants read access to most objects.',-1,'2002-01-16 15:34:00','2016-12-16 14:56:25','',NULL,NULL),(5,'role','Guest','Role grants only a few visible & read permissions.',-1,'2002-01-16 15:34:46','2016-12-16 14:54:14','',NULL,NULL),(6,'usr','root user','ilias@yourserver.com',-1,'2002-01-16 16:09:22','2016-12-14 14:44:49','',NULL,NULL),(7,'usrf','User accounts','Manage user accounts here.',-1,'2002-06-27 09:24:06','2004-01-20 12:23:47','',NULL,NULL),(8,'rolf','Roles','Manage your roles here.',-1,'2002-06-27 09:24:06','2004-01-20 12:23:40','',NULL,NULL),(9,'adm','System Settings','Folder contains the systems settings',-1,'2002-07-15 12:37:33','2002-07-15 12:37:33','',NULL,NULL),(10,'objf','Objectdefinitions','Manage ILIAS object types and object permissions. (only for experts!)',-1,'2002-07-15 12:36:56','2004-01-20 12:23:53','',NULL,NULL),(11,'lngf','Languages','Manage your system languages here.',-1,'2002-07-15 15:52:51','2004-01-20 12:24:06','',NULL,NULL),(12,'mail','Mail Settings','Configure global mail settings here.',-1,'2003-08-15 10:07:28','2004-01-20 12:24:00','',NULL,NULL),(13,'usr','Anonymous','Anonymous user account. DO NOT DELETE!',-1,'2003-08-15 10:07:30','2003-08-15 10:07:30','',NULL,NULL),(14,'role','Anonymous','Default role for anonymous users (with no account)',-1,'2003-08-15 12:06:19','2005-07-20 15:15:06','',NULL,NULL),(15,'typ','grp','Group object',-1,'2002-07-15 15:54:37','2002-07-15 15:54:37','',NULL,NULL),(16,'typ','cat','Category object',-1,'2002-07-15 15:54:54','2002-07-15 15:54:54','',NULL,NULL),(17,'typ','crs','Course object',-1,'2002-07-15 15:55:08','2002-07-15 15:55:08','',NULL,NULL),(18,'typ','mob','Multimedia object',-1,NULL,'2003-08-15 12:03:20','',NULL,NULL),(19,'typ','mail','Mailmodule object',-1,'2002-07-15 15:55:49','2002-07-15 15:55:49','',NULL,NULL),(20,'typ','sahs','SCORM/AICC Learning Module',-1,'2003-08-15 10:07:28','2003-08-15 12:23:10','',NULL,NULL),(21,'typ','adm','Administration Panel object',-1,'2002-07-15 15:56:38','2002-07-15 15:56:38','',NULL,NULL),(22,'typ','usrf','User Folder object',-1,'2002-07-15 15:56:52','2002-07-15 15:56:52','',NULL,NULL),(23,'typ','rolf','Role Folder object',-1,'2002-07-15 15:57:06','2002-07-15 15:57:06','',NULL,NULL),(24,'typ','objf','Object-Type Folder object',-1,'2002-07-15 15:57:17','2002-07-15 15:57:17','',NULL,NULL),(25,'typ','usr','User object',-1,'2002-07-15 15:53:37','2003-08-15 12:30:56','',NULL,NULL),(26,'typ','typ','Object Type Definition object',-1,'2002-07-15 15:58:16','2002-07-15 15:58:16','',NULL,NULL),(27,'typ','rolt','Role template object',-1,'2002-07-15 15:58:16','2002-07-15 15:58:16','',NULL,NULL),(28,'typ','lngf','Language Folder object',-1,'2002-08-28 14:22:01','2002-08-28 14:22:01','',NULL,NULL),(29,'typ','lng','Language object',-1,'2002-08-30 10:18:29','2002-08-30 10:18:29','',NULL,NULL),(30,'typ','role','Role Object',-1,'2002-08-30 10:21:37','2002-08-30 10:21:37','',NULL,NULL),(32,'typ','glo','Glossary',-1,'2003-08-15 10:07:30','2003-08-15 12:29:54','',NULL,NULL),(33,'typ','root','Root Folder Object',-1,'2002-12-21 00:04:00','2003-08-15 12:04:20','',NULL,NULL),(34,'typ','lm','Learning module Object',-1,'2002-07-15 15:54:04','2003-08-15 12:33:04','',NULL,NULL),(35,'typ','notf','Note Folder Object',-1,'2002-12-21 00:04:00','2002-12-21 00:04:00','',NULL,NULL),(36,'typ','note','Note Object',-1,'2002-12-21 00:04:00','2002-12-21 00:04:00','',NULL,NULL),(37,'typ','frm','Forum object',-1,'2002-07-15 15:54:22','2003-08-15 12:36:40','',NULL,NULL),(70,'lng','en','installed',-1,NULL,'[[regtime]]','',NULL,NULL),(71,'lng','de','not_installed',6,'2003-08-15 10:25:19','2015-12-22 16:29:24','',NULL,NULL),(72,'lng','es','not_installed',6,'2003-08-15 10:25:19','2003-08-15 10:25:19','',NULL,NULL),(73,'lng','it','not_installed',6,'2003-08-15 10:25:19','2003-08-15 10:25:19','',NULL,NULL),(80,'rolt','il_grp_admin','Administrator role template of groups',-1,'2003-08-15 10:07:28','2016-12-16 15:05:30','',NULL,NULL),(81,'rolt','il_grp_member','Member role template of groups',-1,'2003-08-15 10:07:28','2016-12-16 15:06:38','',NULL,NULL),(82,'rolt','il_grp_status_closed','Group role template',-1,'2003-08-15 10:07:29','2003-08-15 13:21:38','',NULL,NULL),(83,'rolt','il_grp_status_open','Group role template',-1,'2003-08-15 10:07:29','2003-08-15 13:21:25','',NULL,NULL),(84,'typ','exc','Exercise object',-1,'2003-11-30 21:22:49','2003-11-30 21:22:49','',NULL,NULL),(85,'typ','auth','Authentication settings',-1,'2003-11-30 21:22:49','2003-11-30 21:22:49','',NULL,NULL),(86,'auth','Authentication settings','Select and configure authentication mode for all user accounts',-1,'2003-11-30 21:22:49','2003-11-30 21:22:49','',NULL,NULL),(87,'typ','fold','Folder object',-1,'2003-11-30 21:22:50','2003-11-30 21:22:50','',NULL,NULL),(88,'typ','file','File object',-1,'2003-11-30 21:22:50','2003-11-30 21:22:50','',NULL,NULL),(89,'lng','fr','not_installed',6,'2004-01-20 12:22:17','2004-01-20 12:22:17','',NULL,NULL),(90,'lng','nl','not_installed',6,'2004-01-20 12:22:17','2004-01-20 12:22:17','',NULL,NULL),(91,'lng','pl','not_installed',6,'2004-01-20 12:22:17','2004-01-20 12:22:17','',NULL,NULL),(93,'lng','zh','not_installed',6,'2004-01-20 12:22:17','2004-01-20 12:22:17','',NULL,NULL),(94,'typ','tst','Test object',-1,'2004-02-18 21:17:40','2004-02-18 21:17:40','',NULL,NULL),(95,'typ','qpl','Question pool object',-1,'2004-02-18 21:17:40','2004-02-18 21:17:40','',NULL,NULL),(99,'typ','recf','RecoveryFolder object',-1,'2004-03-09 18:13:16','2004-03-09 18:13:16','',NULL,NULL),(100,'recf','__Restored Objects','Contains objects restored by recovery tool',-1,'2004-03-09 18:13:16','2004-03-09 18:13:16','',NULL,NULL),(101,'typ','mep','Media pool object',-1,'2004-04-19 00:09:14','2004-04-19 00:09:14','',NULL,NULL),(102,'typ','htlm','HTML LM object',-1,'2004-04-19 00:09:15','2004-04-19 00:09:15','',NULL,NULL),(103,'typ','svy','Survey object',-1,'2004-05-15 01:18:59','2004-05-15 01:18:59','',NULL,NULL),(104,'typ','spl','Question pool object (Survey)',-1,'2004-05-15 01:18:59','2004-05-15 01:18:59','',NULL,NULL),(106,'typ','cals','Calendar Settings',-1,'2004-06-21 01:27:18','2004-06-21 01:27:18','',NULL,NULL),(107,'cals','Calendar Settings','Configure Calendar Settings here',-1,'2004-06-21 01:27:18','2004-06-21 01:27:18','',NULL,NULL),(108,'typ','trac','UserTracking object',-1,'2004-07-11 01:03:12','2004-07-11 01:03:12','',NULL,NULL),(109,'trac','__User Tracking','System user tracking',-1,'2004-07-11 01:03:12','2004-07-11 01:03:12','',NULL,NULL),(110,'rolt','il_crs_admin','Administrator template for course admins',-1,'2004-09-02 09:49:43','2016-12-16 15:00:10','',NULL,NULL),(111,'rolt','il_crs_tutor','Tutor template for course tutors',-1,'2004-09-02 09:49:43','2016-12-16 15:03:56','',NULL,NULL),(112,'rolt','il_crs_member','Member template for course members',-1,'2004-09-02 09:49:43','2016-12-16 15:00:53','',NULL,NULL),(115,'typ','assf','AssessmentFolder object',-1,'2005-01-07 17:21:15','2005-01-07 17:21:15','',NULL,NULL),(116,'assf','__Test&Assessment','Test&Assessment Administration',-1,'2005-01-07 17:21:15','2005-01-07 17:21:15','',NULL,NULL),(117,'typ','stys','Style Settings',-1,'2005-03-02 08:59:01','2005-03-02 08:59:01','',NULL,NULL),(118,'stys','System Style Settings','Manage system skin and style settings here',-1,'2005-03-02 08:59:01','2005-03-02 08:59:01','',NULL,NULL),(121,'typ','crsg','Course grouping object',-1,'2005-03-02 08:59:02','2005-03-02 08:59:02','',NULL,NULL),(122,'typ','webr','Link resource object',-1,'2005-03-13 22:41:38','2005-03-13 22:41:38','',NULL,NULL),(123,'typ','seas','Search settings',-1,'2005-06-20 09:50:00','2005-06-20 09:50:00','',NULL,NULL),(124,'seas','Search settings','Search settings',-1,'2005-06-20 09:50:00','2005-06-20 09:50:00','',NULL,NULL),(125,'rolt','Local Administrator','Role template for local administrators.',6,'2005-07-20 15:33:13','2016-12-16 15:09:46','',NULL,NULL),(127,'typ','extt','external tools settings',-1,'2005-07-20 18:10:04','2005-07-20 18:10:04','',NULL,NULL),(128,'extt','External tools settings','Configuring external tools',-1,'2005-07-20 18:10:04','2005-07-20 18:10:04','',NULL,NULL),(131,'rolt','il_crs_non_member','Non-member template for course object',-1,'2005-11-07 12:41:21','2015-12-22 15:35:30','',NULL,NULL),(135,'typ','adve','Advanced editing object',-1,'2006-07-11 18:43:23','2006-07-11 18:43:23','',NULL,NULL),(136,'adve','__AdvancedEditing','Advanced Editing',-1,'2006-07-11 18:43:23','2006-07-11 18:43:23','',NULL,NULL),(137,'typ','ps','Privacy security settings',-1,'2007-02-26 17:58:49','2007-02-26 17:58:49','',NULL,NULL),(138,'ps','__PrivacySecurity','Privacy and Security',-1,'2007-02-26 17:58:49','2007-02-26 17:58:49','',NULL,NULL),(139,'typ','nwss','News settings',-1,'2007-02-26 17:58:50','2007-02-26 17:58:50','',NULL,NULL),(140,'nwss','__NewsSettings','News Settings',-1,'2007-02-26 17:58:50','2007-02-26 17:58:50','',NULL,NULL),(141,'typ','feed','External Feed',-1,'2007-02-26 17:58:50','2007-02-26 17:58:50','',NULL,NULL),(142,'typ','mcst','Media Cast',-1,'2007-04-03 13:43:46','2007-04-03 13:43:46','',NULL,NULL),(143,'typ','dshs','Dashboard Settings',-1,'2007-04-03 13:43:47','2007-04-03 13:43:47','',NULL,NULL),(144,'dshs','__DashboardSettings','Dashboard Settings',-1,'2007-04-03 13:43:47','2007-04-03 13:43:47','',NULL,NULL),(145,'typ','rcrs','Remote Course Object',-1,'2007-09-25 19:47:53','2007-09-25 19:47:53','',NULL,NULL),(146,'typ','mds','Meta Data settings',-1,'2007-09-25 19:47:53','2007-09-25 19:47:53','',NULL,NULL),(147,'mds','__MetaDataSettings','Meta Data Settings',-1,'2007-09-25 19:47:53','2007-09-25 19:47:53','',NULL,NULL),(148,'rolt','il_frm_moderator','Moderator template for forum moderators',-1,'2007-11-27 14:43:12','2007-11-27 14:43:12','',NULL,NULL),(149,'typ','cmps','Component settings',-1,'2008-06-02 16:08:54','2008-06-02 16:08:54','',NULL,NULL),(150,'cmps','__ComponentSettings','Component Settings',-1,'2008-06-02 16:08:54','2008-06-02 16:08:54','',NULL,NULL),(151,'typ','facs','File Access settings object',-1,'2008-06-02 16:08:55','2008-06-02 16:08:55','',NULL,NULL),(152,'facs','Files','Settings for files and file handling',-1,'2008-06-02 16:08:55','2016-12-16 15:43:54','',NULL,NULL),(153,'typ','svyf','Survey Settings',-1,'2008-06-02 16:08:55','2008-06-02 16:08:55','',NULL,NULL),(154,'svyf','__SurveySettings','Survey Settings',-1,'2008-06-02 16:08:55','2008-06-02 16:08:55','',NULL,NULL),(155,'typ','sess','Session object',-1,'2008-06-02 16:08:55','2008-06-02 16:08:55','',NULL,NULL),(156,'typ','mcts','Mediacast settings',-1,'2008-06-02 16:08:56','2008-06-02 16:08:56','',NULL,NULL),(157,'mcts','__MediacastSettings','Mediacast Settings',-1,'2008-06-02 16:08:56','2008-06-02 16:08:56','',NULL,NULL),(158,'typ','wiki','Wiki',-1,'2008-06-02 16:08:57','2008-06-02 16:08:57','',NULL,NULL),(159,'typ','crsr','Course Reference Object',-1,'2008-09-23 19:24:09','2008-09-23 19:24:09','',NULL,NULL),(160,'typ','catr','Category Reference Object',-1,'2008-09-23 19:24:09','2008-09-23 19:24:09','',NULL,NULL),(161,'typ','tags','Tagging settings',-1,'2008-09-23 19:24:09','2008-09-23 19:24:09','',NULL,NULL),(162,'tags','__TaggingSettings','Tagging Settings',-1,'2008-09-23 19:24:09','2008-09-23 19:24:09','',NULL,NULL),(163,'typ','cert','Certificate settings',-1,'2009-07-20 13:03:21','2009-07-20 13:03:21','',NULL,NULL),(164,'cert','__CertificateSettings','Certificate Settings',-1,'2009-07-20 13:03:21','2009-07-20 13:03:21','',NULL,NULL),(165,'typ','lrss','Learning resources settings',-1,'2009-07-20 13:03:21','2009-07-20 13:03:21','',NULL,NULL),(166,'lrss','__LearningResourcesSettings','Learning Resources Settings',-1,'2009-07-20 13:03:21','2009-07-20 13:03:21','',NULL,NULL),(167,'typ','accs','Accessibility settings',-1,'2009-07-20 13:07:28','2009-07-20 13:07:28','',NULL,NULL),(168,'accs','__AccessibilitySettings','Accessibility Settings',-1,'2009-07-20 13:07:28','2009-07-20 13:07:28','',NULL,NULL),(169,'typ','mobs','Media Object/Pool settings',-1,'2009-07-20 13:08:42','2009-07-20 13:08:42','',NULL,NULL),(170,'mobs','__MediaObjectSettings','Media Object/Pool Settings',-1,'2009-07-20 13:08:42','2009-07-20 13:08:42','',NULL,NULL),(171,'typ','frma','Forum administration',-1,'2010-07-19 16:42:55','2010-07-19 16:42:55','',NULL,NULL),(172,'frma','__ForumAdministration','Forum Administration',-1,'2010-07-19 16:42:55','2010-07-19 16:42:55','',NULL,NULL),(173,'typ','book','Booking Manager',-1,'2010-07-19 16:43:10','2010-07-19 16:43:10','',NULL,NULL),(174,'typ','skmg','Skill Management',-1,'2011-08-07 11:39:00','2011-08-07 11:39:00','',NULL,NULL),(175,'skmg','__SkillManagement','Skill Management',-1,'2011-08-07 11:39:00','2011-08-07 11:39:00','',NULL,NULL),(176,'typ','blga','Blog administration',-1,'2011-08-07 11:39:04','2011-08-07 11:39:04','',NULL,NULL),(177,'blga','__BlogAdministration','Blog Administration',-1,'2011-08-07 11:39:04','2011-08-07 11:39:04','',NULL,NULL),(178,'typ','prfa','Portfolio administration',-1,'2011-08-07 11:39:04','2011-08-07 11:39:04','',NULL,NULL),(179,'prfa','__PortfolioAdministration','Portfolio Administration',-1,'2011-08-07 11:39:04','2011-08-07 11:39:04','',NULL,NULL),(180,'typ','chtr','Chatroom Object',-1,'2011-08-07 11:39:06','2011-08-07 11:39:06','',NULL,NULL),(181,'chta','Chatroom Admin','Chatroom General Settings',-1,'2011-08-07 11:39:06','2011-08-07 11:39:06','',NULL,NULL),(182,'typ','chta','Chatroom Administration Type',-1,'2011-08-07 11:39:08','2011-08-07 11:39:08','',NULL,NULL),(183,'typ','otpl','Object Template administration',-1,'2011-10-04 16:53:24','2011-10-04 16:53:24','',NULL,NULL),(184,'otpl','__ObjectTemplateAdministration','Object Template Administration',-1,'2011-10-04 16:53:24','2011-10-04 16:53:24','',NULL,NULL),(185,'chtr','Public Chatroom','Public Chatroom',-1,'2011-10-04 16:53:25','2011-10-04 16:53:25','',0,NULL),(186,'rolf','185','(ref_id )',-1,'2011-10-04 16:53:25','2011-10-04 16:53:25','',NULL,NULL),(187,'role','il_chat_moderator_46','Moderator of chat obj_no.185',-1,'2011-10-04 16:53:25','2011-10-04 16:53:25','',NULL,NULL),(188,'rolt','il_chat_moderator','Moderator template for chat moderators',-1,'2011-10-04 16:53:25','2011-10-04 16:53:25','',NULL,NULL),(189,'typ','blog','Blog Object',-1,'2012-09-04 14:25:29','2012-09-04 14:25:29','',NULL,NULL),(190,'typ','dcl','Data Collection Object',-1,'2012-09-04 14:25:30','2012-09-04 14:25:30','',NULL,NULL),(191,'typ','poll','Poll Object',-1,'2012-09-04 14:25:41','2012-09-04 14:25:41','',NULL,NULL),(192,'typ','hlps','Help Settings',-1,'2012-09-04 14:25:48','2012-09-04 14:25:48','',NULL,NULL),(193,'hlps','HelpSettings','Help Settings',-1,'2012-09-04 14:25:48','2012-09-04 14:25:48','',NULL,NULL),(194,'typ','itgr','Item Group',-1,'2012-09-04 14:25:52','2012-09-04 14:25:52','',NULL,NULL),(195,'typ','rcat','Remote Category Object',-1,'2012-09-04 14:26:14','2012-09-04 14:26:14','',NULL,NULL),(196,'typ','rwik','Remote Wiki Object',-1,'2012-09-04 14:26:14','2012-09-04 14:26:14','',NULL,NULL),(197,'typ','rlm','Remote Learning Module Object',-1,'2012-09-04 14:26:15','2012-09-04 14:26:15','',NULL,NULL),(198,'typ','rglo','Remote Glossary Object',-1,'2012-09-04 14:26:15','2012-09-04 14:26:15','',NULL,NULL),(199,'typ','rfil','Remote File Object',-1,'2012-09-04 14:26:16','2012-09-04 14:26:16','',NULL,NULL),(200,'typ','rgrp','Remote Group Object',-1,'2012-09-04 14:26:16','2012-09-04 14:26:16','',NULL,NULL),(201,'typ','rtst','Remote Test Object',-1,'2012-09-04 14:26:17','2012-09-04 14:26:17','',NULL,NULL),(202,'rolt','il_blog_contributor','Contributor template for blogs',-1,'2012-10-27 19:30:37','2012-10-27 19:30:37','',NULL,NULL),(203,'typ','ecss','ECS Administration',-1,'2012-11-23 17:12:57','2012-11-23 17:12:57','',NULL,NULL),(204,'ecss','__ECSSettings','ECS Administration',-1,'2012-11-23 17:12:57','2012-11-23 17:12:57','',NULL,NULL),(205,'typ','tos','Terms of Service',-1,'2013-10-11 18:59:35','2013-10-11 18:59:35','',NULL,NULL),(206,'tos','Terms of Service','Terms of Service: Settings',-1,'2013-10-11 18:59:35','2013-10-11 18:59:35','',NULL,NULL),(207,'typ','bibl','Bibliographic Object',-1,'2013-10-11 18:59:37','2013-10-11 18:59:37','',NULL,NULL),(208,'typ','sysc','System Check',-1,'2013-10-11 18:59:40','2013-10-11 18:59:40','',NULL,NULL),(209,'sysc','System Check','System Check',-1,'2013-10-11 18:59:40','2013-10-11 18:59:40','',NULL,NULL),(210,'typ','cld','Cloud Folder',-1,'2013-10-11 18:59:40','2013-10-11 18:59:40','',NULL,NULL),(211,'typ','reps','Repository Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(212,'reps','Repository Settings','Repository Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(213,'typ','crss','Course Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(214,'crss','Course Settings','Course Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(215,'typ','grps','Group Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(216,'grps','Group Settings','Group Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(217,'typ','wbrs','WebResource Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(218,'wbrs','WebResource Settings','WebResource Settings',-1,'2013-10-11 18:59:42','2013-10-11 18:59:42','',NULL,NULL),(219,'typ','prtt','Portfolio Template Object',-1,'2013-10-11 19:04:51','2013-10-11 19:04:51','',NULL,NULL),(220,'typ','orgu','Organisational Unit',-1,'2013-10-11 19:04:52','2013-10-11 19:04:52','',NULL,NULL),(221,'orgu','__OrgUnitAdministration','Organisationsal Units',-1,'2013-10-11 19:04:52','2013-10-11 19:04:52','',NULL,NULL),(222,'rolt','il_orgu_superior','OrgUnit Superior Role Template',-1,'2013-10-11 19:04:52','2013-10-11 19:04:52','',NULL,NULL),(223,'typ','wiks','Wiki Settings',-1,'2013-11-06 17:13:57','2013-11-06 17:13:57','',NULL,NULL),(224,'wiks','Wiki Settings','Wiki Settings',-1,'2013-11-06 17:13:57','2013-11-06 17:13:57','',NULL,NULL),(225,'typ','excs','Exercise Settings',-1,'2014-09-23 21:48:42','2014-09-23 21:48:42','',NULL,NULL),(226,'excs','Exercise Settings','Exercise Settings',-1,'2014-09-23 21:48:42','2014-09-23 21:48:42','',NULL,NULL),(227,'typ','taxs','Taxonomy Settings',-1,'2014-09-23 21:48:42','2014-09-23 21:48:42','',NULL,NULL),(228,'taxs','Taxonomy Settings','Taxonomy Settings',-1,'2014-09-23 21:48:42','2014-09-23 21:48:42','',NULL,NULL),(229,'typ','bibs','BibliographicAdmin',-1,'2014-09-23 21:48:55','2014-09-23 21:48:55','',NULL,NULL),(230,'bibs','BibliographicAdmin','BibliographicAdmin',-1,'2014-09-23 21:48:55','2014-09-23 21:48:55','',NULL,NULL),(231,'rolt','il_blog_editor','Editor template for blogs',-1,'2015-09-30 12:57:25','2015-12-22 15:28:30','',NULL,NULL),(232,'typ','awra','Awareness Tool Administration',-1,'2015-09-30 12:57:29','2015-09-30 12:57:29','',NULL,NULL),(233,'awra','__AwarenessToolAdministration','Awareness Tool Administration',-1,'2015-09-30 12:57:29','2015-09-30 12:57:29','',NULL,NULL),(234,'typ','logs','Logging Administration',-1,'2015-09-30 12:57:31','2015-09-30 12:57:31','',NULL,NULL),(235,'logs','__LoggingSettings','Logging Administration',-1,'2015-09-30 12:57:31','2015-09-30 12:57:31','',NULL,NULL),(236,'typ','prg','StudyProgramme',-1,'2015-09-30 12:57:34','2015-09-30 12:57:34','',NULL,NULL),(237,'typ','prgs','StudyProgrammeAdmin',-1,'2015-09-30 12:57:35','2015-09-30 12:57:35','',NULL,NULL),(238,'prgs','StudyProgrammeAdmin','StudyProgrammeAdmin',-1,'2015-09-30 12:57:35','2015-09-30 12:57:35','',NULL,NULL),(239,'typ','cadm','Contact',-1,'2015-11-17 15:20:05','2015-11-17 15:20:05','',NULL,NULL),(240,'cadm','Contact','Contact',-1,'2015-11-17 15:20:05','2015-11-17 15:20:05','',NULL,NULL),(241,'lng','ka','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(242,'lng','ar','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(243,'lng','bg','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(244,'lng','sq','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(245,'lng','ro','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(246,'lng','sk','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(247,'lng','da','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(248,'lng','hu','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(249,'lng','uk','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(250,'lng','fa','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(251,'lng','sr','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(252,'lng','pt','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(253,'lng','ja','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(254,'lng','vi','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(255,'lng','ru','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(256,'lng','et','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(257,'lng','lt','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(258,'lng','cs','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(259,'lng','tr','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(260,'lng','el','not_installed',6,'2015-12-22 14:32:40','2015-12-22 14:32:40','',NULL,NULL),(261,'typ','grpr','Group Reference Object',-1,'2016-09-02 13:26:19','2016-09-02 13:26:19','',NULL,NULL),(262,'typ','bdga','Badge Settings',-1,'2016-09-02 13:26:21','2016-09-02 13:26:21','',NULL,NULL),(263,'bdga','Badge Settings','Badge Settings',-1,'2016-09-02 13:26:21','2016-09-02 13:26:21','',NULL,NULL),(266,'typ','iass','Individual Assessment',-1,'2016-09-02 13:33:17','2016-09-02 13:33:17','',NULL,NULL),(267,'rolt','il_iass_member','Member of a manual assessment object',-1,'2016-09-02 13:33:17','2016-09-02 13:33:17','',NULL,NULL),(268,'rolt','il_sess_participant','Session participant template',-1,'2018-01-25 08:42:46','2018-01-25 08:42:46',NULL,NULL,NULL),(269,'rolt','il_sess_status_closed','Closed session template',0,'2018-01-25 08:42:46','2018-01-25 08:42:46',NULL,NULL,NULL),(272,'typ','ltis','LTI Settings',-1,'2018-01-25 08:42:57','2018-01-25 08:42:57',NULL,NULL,NULL),(273,'ltis','LTI Settings','LTI Settings',-1,'2018-01-25 08:42:57','2018-01-25 08:42:57',NULL,NULL,NULL),(274,'typ','copa','Content Page Object',-1,'2022-06-07 13:46:08','2022-06-07 13:46:08',NULL,NULL,NULL),(275,'typ','mme','Main Menu',-1,'2022-06-07 13:46:09','2022-06-07 13:46:09',NULL,NULL,NULL),(276,'mme','Main Menu','Main Menu',-1,'2022-06-07 13:46:09','2022-06-07 13:46:09',NULL,NULL,NULL),(277,'typ','lso','Learning Sequence',-1,'2022-06-07 13:46:09','2022-06-07 13:46:09',NULL,NULL,NULL),(278,'rolt','il_lso_admin','Admin template for learning sequences',-1,'2022-06-07 13:46:09','2022-06-07 13:46:09',NULL,NULL,NULL),(279,'rolt','il_lso_member','Member template for learning sequences',-1,'2022-06-07 13:46:09','2022-06-07 13:46:09',NULL,NULL,NULL),(280,'typ','lti','LTI Consumer Object',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(281,'typ','cmix','cmi5/xAPI Object',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(282,'typ','cmis','cmi5/xAPI Administration',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(283,'cmis','cmi5/xAPI Administration','cmi5/xAPI Administration',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(284,'typ','nots','Notes Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(285,'nots','Notes Settings','Notes Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(286,'typ','coms','Comments Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(287,'coms','Comments Settings','Comments Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(288,'typ','lhts','Learning History Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(289,'lhts','Learning History Settings','Learning History Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(290,'typ','prss','Personal Resources Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(291,'prss','Personal Resources Settings','Personal Resources Settings',-1,'2022-06-07 13:46:11','2022-06-07 13:46:11',NULL,NULL,NULL),(292,'typ','prgr','Study Programme Reference',-1,'2022-06-07 13:46:12','2022-06-07 13:46:12',NULL,NULL,NULL),(293,'typ','lsos','LearningSequenceAdmin',-1,'2022-06-07 13:46:12','2022-06-07 13:46:12',NULL,NULL,NULL),(294,'lsos','LearningSequenceAdmin','LearningSequenceAdmin',-1,'2022-06-07 13:46:12','2022-06-07 13:46:12',NULL,NULL,NULL),(295,'typ','cpad','ContentPageAdministration',-1,'2022-06-07 13:46:12','2022-06-07 13:46:12',NULL,NULL,NULL),(296,'cpad','ContentPageAdministration','ContentPageAdministration',-1,'2022-06-07 13:46:12','2022-06-07 13:46:12',NULL,NULL,NULL),(297,'typ','fils','File Services',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(298,'fils','File Services','File Services',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(299,'typ','wbdv','WebDAV',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(300,'wbdv','WebDAV','WebDAV',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(301,'typ','adn','Administrative Notifications',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(302,'adn','Administrative Notifications','Administrative Notifications',-1,'2022-06-07 13:46:13','2022-06-07 13:46:13',NULL,NULL,NULL),(303,'typ','tala','__TalkTemplateAdministration',-1,'2023-12-12 16:39:37','2023-12-12 16:39:37',NULL,NULL,NULL),(304,'tala','__TalkTemplateAdministration','__TalkTemplateAdministration',-1,'2023-12-12 16:39:37','2023-12-12 16:39:37',NULL,NULL,NULL),(305,'typ','dpro','DataProtection',-1,'2023-12-12 16:39:38','2023-12-12 16:39:38',NULL,NULL,NULL),(306,'dpro','DataProtection','DataProtection',-1,'2023-12-12 16:39:38','2023-12-12 16:39:38',NULL,NULL,NULL),(307,'typ','impr','Legal Notice',-1,'2023-12-12 16:39:38','2023-12-12 16:39:38',NULL,NULL,NULL),(308,'impr','Legal Notice','Legal Notice',-1,'2023-12-12 16:39:38','2023-12-12 16:39:38',NULL,NULL,NULL),(309,'typ','nota','Notification Service Administration Object',-1,'2023-12-12 16:39:40','2023-12-12 16:39:40',NULL,NULL,NULL),(310,'nota','Notification Service Administration Object','Notification Service Administration Object',-1,'2023-12-12 16:39:40','2023-12-12 16:39:40',NULL,NULL,NULL),(311,'typ','skee','Skill Tree',-1,'2023-12-12 16:39:40','2023-12-12 16:39:40',NULL,NULL,NULL),(312,'skee','Default','',-1,'2023-12-12 16:39:40','2023-12-12 16:39:40',NULL,NULL,NULL),(313,'wsrt','','',13,'[[regtime]]','[[regtime]]','',NULL,NULL);

--
-- Table structure for table `object_data_del`
--

CREATE TABLE `object_data_del` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `type` char(4) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `object_data_del`
--


--
-- Table structure for table `object_data_seq`
--

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

--
-- Dumping data for table `object_data_seq`
--

INSERT INTO `object_data_seq` VALUES (313);

--
-- Table structure for table `object_description`
--

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

--
-- Dumping data for table `object_description`
--

INSERT INTO `object_description` VALUES (152,'Settings for files and file handling');

--
-- Table structure for table `object_reference`
--

CREATE TABLE `object_reference` (
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT '0',
  PRIMARY KEY (`ref_id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `object_reference`
--

INSERT INTO `object_reference` VALUES (1,1,NULL,0),(7,7,NULL,0),(8,8,NULL,0),(9,9,NULL,0),(10,10,NULL,0),(11,11,NULL,0),(12,12,NULL,0),(14,98,NULL,0),(15,100,NULL,0),(16,107,NULL,0),(17,109,NULL,0),(18,86,NULL,0),(20,116,NULL,0),(21,118,NULL,0),(22,124,NULL,0),(23,128,NULL,0),(26,136,NULL,0),(27,138,NULL,0),(28,140,NULL,0),(29,144,NULL,0),(30,147,NULL,0),(31,150,NULL,0),(32,152,NULL,0),(33,154,NULL,0),(34,157,NULL,0),(35,162,NULL,0),(36,164,NULL,0),(37,166,NULL,0),(38,168,NULL,0),(39,170,NULL,0),(40,172,NULL,0),(41,175,NULL,0),(42,177,NULL,0),(43,179,NULL,0),(44,181,NULL,0),(45,184,NULL,0),(46,185,NULL,0),(47,186,NULL,0),(48,193,NULL,0),(49,204,NULL,0),(50,206,NULL,0),(51,209,NULL,0),(52,212,NULL,0),(53,214,NULL,0),(54,216,NULL,0),(55,218,NULL,0),(56,221,NULL,0),(57,224,NULL,0),(58,226,NULL,0),(59,228,NULL,0),(60,230,NULL,0),(61,233,NULL,0),(62,235,NULL,0),(63,238,NULL,0),(64,240,NULL,0),(65,263,NULL,0),(67,271,NULL,0),(68,273,NULL,0),(69,276,NULL,0),(70,283,NULL,0),(71,285,NULL,0),(72,287,NULL,0),(73,289,NULL,0),(74,291,NULL,0),(75,294,NULL,0),(76,296,NULL,0),(77,298,NULL,0),(78,300,NULL,0),(79,302,NULL,0),(80,304,NULL,0),(81,306,NULL,0),(82,308,NULL,0),(83,310,NULL,0),(84,312,NULL,0);

--
-- Table structure for table `object_reference_seq`
--

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

--
-- Dumping data for table `object_reference_seq`
--

INSERT INTO `object_reference_seq` VALUES (84);

--
-- Table structure for table `object_reference_ws`
--

CREATE TABLE `object_reference_ws` (
  `wsp_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`wsp_id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `object_reference_ws`
--

INSERT INTO `object_reference_ws` VALUES (1,313,NULL);

--
-- Table structure for table `object_reference_ws_seq`
--

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

--
-- Dumping data for table `object_reference_ws_seq`
--

INSERT INTO `object_reference_ws_seq` VALUES (1);

--
-- Table structure for table `object_translation`
--

CREATE TABLE `object_translation` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `lang_code` char(2) NOT NULL DEFAULT '',
  `lang_default` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `object_translation`
--

INSERT INTO `object_translation` VALUES (9,'Open Source eLearning','','en',1);

--
-- Table structure for table `openid_provider`
--

CREATE TABLE `openid_provider` (
  `provider_id` int(11) NOT NULL DEFAULT '0',
  `enabled` tinyint(4) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `image` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`provider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `openid_provider`
--

INSERT INTO `openid_provider` VALUES (1,1,'MyOpenID','http://%s.myopenid.com',1);

--
-- Table structure for table `openid_provider_seq`
--

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

--
-- Dumping data for table `openid_provider_seq`
--

INSERT INTO `openid_provider_seq` VALUES (1);

--
-- Table structure for table `orgu_data`
--

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

--
-- Dumping data for table `orgu_data`
--


--
-- Table structure for table `orgu_obj_pos_settings`
--

CREATE TABLE `orgu_obj_pos_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orgu_obj_pos_settings`
--


--
-- Table structure for table `orgu_obj_type_settings`
--

CREATE TABLE `orgu_obj_type_settings` (
  `obj_type` varchar(10) NOT NULL,
  `active` tinyint(4) DEFAULT '0',
  `activation_default` tinyint(4) DEFAULT '0',
  `changeable` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orgu_obj_type_settings`
--


--
-- Table structure for table `orgu_path_storage`
--

CREATE TABLE `orgu_path_storage` (
  `ref_id` bigint(20) NOT NULL DEFAULT '0',
  `obj_id` bigint(20) DEFAULT NULL,
  `path` longtext,
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orgu_path_storage`
--


--
-- Table structure for table `orgu_types`
--

CREATE TABLE `orgu_types` (
  `id` int(11) NOT NULL DEFAULT '0',
  `default_lang` varchar(4) NOT NULL DEFAULT '',
  `icon` varchar(256) DEFAULT NULL,
  `owner` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orgu_types`
--


--
-- Table structure for table `orgu_types_adv_md_rec`
--

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

--
-- Dumping data for table `orgu_types_adv_md_rec`
--


--
-- Table structure for table `orgu_types_seq`
--

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

--
-- Dumping data for table `orgu_types_seq`
--


--
-- Table structure for table `orgu_types_trans`
--

CREATE TABLE `orgu_types_trans` (
  `orgu_type_id` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(4) NOT NULL DEFAULT '',
  `member` varchar(32) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`orgu_type_id`,`lang`,`member`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orgu_types_trans`
--


--
-- Table structure for table `osc_activity`
--

CREATE TABLE `osc_activity` (
  `conversation_id` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `timestamp` bigint(20) NOT NULL DEFAULT '0',
  `is_closed` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`conversation_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `osc_activity`
--


--
-- Table structure for table `osc_conversation`
--

CREATE TABLE `osc_conversation` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `is_group` tinyint(4) NOT NULL DEFAULT '0',
  `participants` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `osc_conversation`
--


--
-- Table structure for table `osc_messages`
--

CREATE TABLE `osc_messages` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `conversation_id` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `message` longtext,
  `timestamp` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`user_id`),
  KEY `i2_idx` (`conversation_id`),
  KEY `i3_idx` (`conversation_id`,`user_id`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `osc_messages`
--


--
-- Table structure for table `page_anchor`
--

CREATE TABLE `page_anchor` (
  `page_parent_type` varchar(10) NOT NULL DEFAULT ' ',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `anchor_name` varchar(120) NOT NULL DEFAULT ' ',
  `page_lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`page_parent_type`,`page_id`,`page_lang`,`anchor_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_anchor`
--


--
-- Table structure for table `page_editor_settings`
--

CREATE TABLE `page_editor_settings` (
  `settings_grp` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(30) NOT NULL DEFAULT '',
  `value` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`settings_grp`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_editor_settings`
--

INSERT INTO `page_editor_settings` VALUES ('rep','active_acc','1'),('rep','active_code','1'),('rep','active_com','1'),('rep','active_emp','1'),('rep','active_fn','1'),('rep','active_imp','1'),('rep','active_quot','1'),('rep','active_str','1'),('rep','active_sub','1'),('rep','active_sup','1'),('rep','active_tex','1'),('rep','active_xln','1');

--
-- Table structure for table `page_history`
--

CREATE TABLE `page_history` (
  `page_id` int(11) NOT NULL DEFAULT '0',
  `parent_type` varchar(4) NOT NULL DEFAULT ' ',
  `hdate` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `parent_id` int(11) DEFAULT NULL,
  `nr` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `content` longtext,
  `ilias_version` varchar(20) DEFAULT NULL,
  `lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`page_id`,`parent_type`,`hdate`,`lang`),
  KEY `i1_idx` (`page_id`),
  KEY `i2_idx` (`parent_id`,`parent_type`,`hdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_history`
--


--
-- Table structure for table `page_layout`
--

CREATE TABLE `page_layout` (
  `layout_id` int(11) NOT NULL DEFAULT '0',
  `content` longtext,
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '0',
  `style_id` int(11) DEFAULT '0',
  `special_page` tinyint(4) DEFAULT '0',
  `mod_scorm` tinyint(4) DEFAULT '1',
  `mod_portfolio` tinyint(4) DEFAULT NULL,
  `mod_lm` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_layout`
--

INSERT INTO `page_layout` VALUES (1,'','Text page with accompanying media','Example description',1,0,0,1,0,NULL),(2,'','Text page with accompanying media and test','',1,0,0,1,0,NULL),(3,'','Text page with accompanying media followed by test and text','',1,0,0,1,0,NULL),(4,'','Media page with accompanying text and test','',1,0,0,1,0,NULL),(5,'','Vertical component navigation page with media and text	','',1,0,0,1,0,NULL),(6,'','Leading image with text','',1,0,0,1,NULL,NULL);

--
-- Table structure for table `page_layout_seq`
--

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

--
-- Dumping data for table `page_layout_seq`
--

INSERT INTO `page_layout_seq` VALUES (6);

--
-- Table structure for table `page_object`
--

CREATE TABLE `page_object` (
  `page_id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `content` longtext,
  `parent_type` varchar(4) NOT NULL DEFAULT 'lm',
  `last_change_user` int(11) DEFAULT NULL,
  `view_cnt` int(11) DEFAULT '0',
  `last_change` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `render_md5` varchar(32) DEFAULT NULL,
  `rendered_content` longtext,
  `rendered_time` datetime DEFAULT NULL,
  `activation_start` datetime DEFAULT NULL,
  `activation_end` datetime DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `is_empty` tinyint(4) NOT NULL DEFAULT '0',
  `inactive_elements` tinyint(4) DEFAULT '0',
  `int_links` tinyint(4) DEFAULT '0',
  `show_activation_info` tinyint(4) NOT NULL DEFAULT '0',
  `lang` varchar(2) NOT NULL DEFAULT '-',
  `edit_lock_user` int(11) DEFAULT NULL,
  `edit_lock_ts` int(11) NOT NULL DEFAULT '0',
  `est_reading_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`,`parent_type`,`lang`),
  KEY `i3_idx` (`parent_id`,`parent_type`,`last_change`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_object`
--

INSERT INTO `page_object` VALUES (1,NULL,'<PageObject></PageObject>','impr',6,0,'2016-12-16 15:25:17','2016-12-16 15:25:17',6,'52bee1212f8a154aac268a0c20b77437','<a class=\"small\" id=\"ilPageShowAdvContent\" style=\"display:none; text-align:right;\" href=\"#\"><span>{{{{{LV_show_adv}}}}}</span><span>{{{{{LV_hide_adv}}}}}</span></a><h1 class=\"ilc_page_title_PageTitle\">Legal Notice</h1><!--COPage-PageTop-->\n<div xmlns:xhtml=\"http://www.w3.org/1999/xhtml\" style=\"clear:both;\"><!--Break--></div>\n','2016-12-16 15:25:17',NULL,NULL,1,0,0,0,0,'-',NULL,0,0),(1,0,'<PageObject><PageContent PCID=\"0568f23f59f828dd532cd77c66dcea97\"><Grid><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"7\" WIDTH_L=\"8\" WIDTH_XL=\"8\" PCID=\"2fe139a171c9276193832c2d64f5822b\"><PageContent PCID=\"1f77eb1d8a478497d69b99d938fda8f\"><PlaceHolder ContentClass=\"Text\" Height=\"500px\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"5\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"010960eb5296c409d0b5070e186f033e\"><PageContent PCID=\"2e77eb1d8a478497d69b99d938fda8e\"><PlaceHolder ContentClass=\"Media\" Height=\"500px\"/></PageContent></GridCell></Grid></PageContent></PageObject>','stys',0,0,NULL,NULL,0,'','',NULL,NULL,NULL,1,0,0,0,0,'-',0,0,0),(2,0,'<PageObject><PageContent PCID=\"336db62153bc33b955c8eab6b4ba1331\"><Grid><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"7\" WIDTH_L=\"8\" WIDTH_XL=\"8\" PCID=\"18772b9425070318d27bb2fdaf6b6bdf\"><PageContent PCID=\"1f77eb1d8a478497d69b99d938fda8f\"><PlaceHolder ContentClass=\"Text\" Height=\"300px\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"5\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"4309720c697857f55946691119fd7f10\"><PageContent PCID=\"2e77eb1d8a478497d69b99d938fda8e\"><PlaceHolder ContentClass=\"Media\" Height=\"300px\"/></PageContent></GridCell></Grid></PageContent><PageContent PCID=\"3f77eb1d8a478493d69b99d438fda8f\"><PlaceHolder ContentClass=\"Question\" Height=\"200px\"/></PageContent></PageObject>','stys',0,0,NULL,NULL,0,'','',NULL,NULL,NULL,1,0,0,0,0,'-',0,0,0),(3,0,'<PageObject><PageContent PCID=\"6239da5ab9497f14774a2cceb5525c3d\"><Grid><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"5\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"2f9835a738e7c83dbef27915816b0f5a\"><PageContent PCID=\"2e77eb1d8a478497d69b99d938fda8e\"><PlaceHolder ContentClass=\"Media\" Height=\"500px\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"7\" WIDTH_L=\"8\" WIDTH_XL=\"8\" PCID=\"1d74da9bf94b63e8c85a451399b624d9\"><PageContent PCID=\"1f77eb1d8a478497d69b99d938fda8f\"><PlaceHolder ContentClass=\"Text\" Height=\"500px\"/></PageContent></GridCell></Grid></PageContent></PageObject>','stys',0,0,NULL,NULL,0,'','',NULL,NULL,NULL,1,0,0,0,0,'-',0,0,0),(4,0,'<PageObject><PageContent PCID=\"906a03fd9999c5c83a7166e9f9744fec\"><Grid><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"5\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"a27f25a9b1d8746d1cf3820759f37096\"><PageContent PCID=\"2e77eb1d8a478497d69b99d938fda8e\"><PlaceHolder ContentClass=\"Media\" Height=\"300px\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"7\" WIDTH_L=\"8\" WIDTH_XL=\"8\" PCID=\"8e769877102068dca417222215defaa9\"><PageContent PCID=\"1f77eb1d8a478497d69b99d938fda8f\"><PlaceHolder ContentClass=\"Text\" Height=\"300px\"/></PageContent></GridCell></Grid></PageContent><PageContent PCID=\"3f77eb1d8a478493d69b99d438fda8f\"><PlaceHolder ContentClass=\"Question\" Height=\"200px\"/></PageContent></PageObject>','stys',0,0,NULL,NULL,0,'','',NULL,NULL,NULL,1,0,0,0,0,'-',0,0,0),(5,0,'<PageObject><PageContent PCID=\"0fb0511a01dcb9b83d9f21eb0d588a19\"><Grid><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"4\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"b241816c4270ec842782a664cbe72979\"><PageContent PCID=\"428c956f8035dc8ac59a9412bc19f955\"><PlaceHolder Height=\"250px\" ContentClass=\"Media\"/></PageContent><PageContent PCID=\"6d0291683f92aa84920755184b0da66c\"><PlaceHolder Height=\"250px\" ContentClass=\"Text\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"4\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"375c6f40533390645bd1bb58259bec54\"><PageContent PCID=\"41f4e5a703244309231c2d6be0c49231\"><PlaceHolder Height=\"250px\" ContentClass=\"Media\"/></PageContent><PageContent PCID=\"325dac9e34424f129a4e4f9a0c4e37c4\"><PlaceHolder Height=\"250px\" ContentClass=\"Text\"/></PageContent></GridCell><GridCell WIDTH_XS=\"\" WIDTH_S=\"12\" WIDTH_M=\"4\" WIDTH_L=\"4\" WIDTH_XL=\"4\" PCID=\"d8379b454401c9b7071d32efb69cc028\"><PageContent PCID=\"5e744ec7c8784471e4668bcbc5e4b405\"><PlaceHolder Height=\"250px\" ContentClass=\"Media\"/></PageContent><PageContent PCID=\"0ba252ad3ab834e2c8fba58708dc1995\"><PlaceHolder Height=\"250px\" ContentClass=\"Text\"/></PageContent></GridCell></Grid></PageContent></PageObject>','stys',0,0,NULL,NULL,0,'','',NULL,NULL,NULL,1,0,0,0,0,'-',0,0,0),(6,NULL,'<PageObject><PageContent PCID=\"6b1a4e68d752380bf108afff7fa66595\"><PlaceHolder Height=\"300px\" ContentClass=\"Media\"/></PageContent><PageContent PCID=\"8535f59bec330f1cc30286898a36356f\"><PlaceHolder Height=\"200px\" ContentClass=\"Text\"/></PageContent></PageObject>','stys',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,0,0,'-',NULL,0,0);

--
-- Table structure for table `page_pc_usage`
--

CREATE TABLE `page_pc_usage` (
  `pc_type` varchar(30) NOT NULL DEFAULT '',
  `pc_id` int(11) NOT NULL DEFAULT '0',
  `usage_type` varchar(30) 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 (`pc_type`,`pc_id`,`usage_type`,`usage_id`,`usage_hist_nr`,`usage_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_pc_usage`
--


--
-- Table structure for table `page_qst_answer`
--

CREATE TABLE `page_qst_answer` (
  `qst_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `try` tinyint(4) NOT NULL DEFAULT '0',
  `passed` tinyint(4) NOT NULL DEFAULT '0',
  `points` double NOT NULL DEFAULT '0',
  `unlocked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`qst_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_qst_answer`
--


--
-- Table structure for table `page_question`
--

CREATE TABLE `page_question` (
  `page_parent_type` varchar(4) NOT NULL DEFAULT '',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `question_id` int(11) NOT NULL DEFAULT '0',
  `page_lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`page_parent_type`,`page_id`,`question_id`,`page_lang`),
  KEY `i1_idx` (`page_parent_type`,`page_id`,`page_lang`),
  KEY `i2_idx` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_question`
--


--
-- Table structure for table `page_style_usage`
--

CREATE TABLE `page_style_usage` (
  `id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `page_type` char(10) NOT NULL DEFAULT '',
  `page_nr` int(11) NOT NULL DEFAULT '0',
  `template` tinyint(4) NOT NULL DEFAULT '0',
  `stype` varchar(30) DEFAULT NULL,
  `sname` char(30) DEFAULT NULL,
  `page_lang` varchar(2) NOT NULL DEFAULT '-',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`page_id`,`page_type`,`page_lang`,`page_nr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_style_usage`
--


--
-- Table structure for table `page_style_usage_seq`
--

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

--
-- Dumping data for table `page_style_usage_seq`
--


--
-- Table structure for table `personal_clipboard`
--

CREATE TABLE `personal_clipboard` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL DEFAULT '0',
  `type` char(4) NOT NULL DEFAULT '',
  `title` char(255) DEFAULT NULL,
  `insert_time` datetime DEFAULT NULL,
  `parent` int(11) NOT NULL DEFAULT '0',
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`item_id`,`type`),
  KEY `it_idx` (`item_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personal_clipboard`
--


--
-- Table structure for table `personal_pc_clipboard`
--

CREATE TABLE `personal_pc_clipboard` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `content` longtext,
  `insert_time` datetime NOT NULL,
  `order_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`insert_time`,`order_nr`),
  KEY `i1_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personal_pc_clipboard`
--


--
-- Table structure for table `pg_amd_page_list`
--

CREATE TABLE `pg_amd_page_list` (
  `id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  `data` varchar(4000) DEFAULT NULL,
  `sdata` longtext,
  PRIMARY KEY (`id`,`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pg_amd_page_list`
--


--
-- Table structure for table `pg_amd_page_list_seq`
--

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

--
-- Dumping data for table `pg_amd_page_list_seq`
--


--
-- Table structure for table `post_conditions`
--

CREATE TABLE `post_conditions` (
  `ref_id` int(11) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `condition_operator` varchar(32) NOT NULL,
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `post_conditions`
--


--
-- Table structure for table `preview_data`
--

CREATE TABLE `preview_data` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `render_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `render_status` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `preview_data`
--


--
-- Table structure for table `prg_auto_content`
--

CREATE TABLE `prg_auto_content` (
  `prg_obj_id` int(11) NOT NULL,
  `cat_ref_id` int(11) NOT NULL,
  `last_usr_id` int(11) NOT NULL,
  `last_edited` datetime DEFAULT NULL,
  PRIMARY KEY (`prg_obj_id`,`cat_ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_auto_content`
--


--
-- Table structure for table `prg_auto_membership`
--

CREATE TABLE `prg_auto_membership` (
  `prg_obj_id` int(11) NOT NULL,
  `source_type` varchar(8) NOT NULL,
  `source_id` int(11) NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '0',
  `last_usr_id` int(11) NOT NULL,
  `last_edited` datetime DEFAULT NULL,
  PRIMARY KEY (`prg_obj_id`,`source_type`,`source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_auto_membership`
--


--
-- Table structure for table `prg_settings`
--

CREATE TABLE `prg_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `last_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `subtype_id` int(11) NOT NULL DEFAULT '0',
  `points` int(11) NOT NULL DEFAULT '0',
  `lp_mode` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `deadline_period` int(11) NOT NULL DEFAULT '0',
  `deadline_date` datetime DEFAULT NULL,
  `vq_period` int(11) NOT NULL DEFAULT '-1',
  `vq_date` datetime DEFAULT NULL,
  `vq_restart_period` int(11) NOT NULL DEFAULT '-1',
  `rm_nr_by_usr_days` int(11) DEFAULT NULL,
  `proc_end_no_success` int(11) DEFAULT NULL,
  `send_re_assigned_mail` tinyint(4) DEFAULT '0',
  `send_info_to_re_assign_mail` tinyint(4) DEFAULT '0',
  `send_risky_to_fail_mail` tinyint(4) DEFAULT '0',
  `vq_restart_recheck` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_settings`
--


--
-- Table structure for table `prg_settings_seq`
--

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

--
-- Dumping data for table `prg_settings_seq`
--


--
-- Table structure for table `prg_translations`
--

CREATE TABLE `prg_translations` (
  `id` int(11) NOT NULL DEFAULT '0',
  `prg_type_id` int(11) DEFAULT NULL,
  `lang` varchar(4) DEFAULT NULL,
  `member` varchar(32) DEFAULT NULL,
  `value` varchar(3500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_translations`
--


--
-- Table structure for table `prg_translations_seq`
--

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

--
-- Dumping data for table `prg_translations_seq`
--


--
-- Table structure for table `prg_type`
--

CREATE TABLE `prg_type` (
  `id` int(11) NOT NULL DEFAULT '0',
  `default_lang` varchar(4) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `create_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `last_update` datetime DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_type`
--


--
-- Table structure for table `prg_type_adv_md_rec`
--

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

--
-- Dumping data for table `prg_type_adv_md_rec`
--


--
-- Table structure for table `prg_type_adv_md_rec_seq`
--

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

--
-- Dumping data for table `prg_type_adv_md_rec_seq`
--


--
-- Table structure for table `prg_type_seq`
--

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

--
-- Dumping data for table `prg_type_seq`
--


--
-- Table structure for table `prg_usr_assignments`
--

CREATE TABLE `prg_usr_assignments` (
  `id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `root_prg_id` int(11) NOT NULL DEFAULT '0',
  `last_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `last_change_by` int(11) NOT NULL DEFAULT '0',
  `restart_date` datetime DEFAULT NULL,
  `restarted_assignment_id` int(11) NOT NULL DEFAULT '-1',
  `restart_mail_send` datetime DEFAULT NULL,
  `assigned_manually` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_usr_assignments`
--


--
-- Table structure for table `prg_usr_assignments_seq`
--

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

--
-- Dumping data for table `prg_usr_assignments_seq`
--


--
-- Table structure for table `prg_usr_progress`
--

CREATE TABLE `prg_usr_progress` (
  `id` int(11) NOT NULL DEFAULT '0',
  `assignment_id` int(11) NOT NULL DEFAULT '0',
  `prg_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `points` int(11) NOT NULL DEFAULT '0',
  `points_cur` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `completion_by` int(11) DEFAULT NULL,
  `last_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `last_change_by` int(11) DEFAULT NULL,
  `deadline` varchar(15) DEFAULT NULL,
  `assignment_date` datetime DEFAULT NULL,
  `completion_date` datetime DEFAULT NULL,
  `vq_date` datetime DEFAULT NULL,
  `invalidated` tinyint(4) DEFAULT NULL,
  `sent_mail_risky_to_fail` datetime DEFAULT NULL,
  `individual` tinyint(4) NOT NULL DEFAULT '0',
  `sent_mail_expires` datetime DEFAULT NULL,
  PRIMARY KEY (`assignment_id`,`prg_id`,`usr_id`),
  UNIQUE KEY `con_idx` (`assignment_id`,`prg_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `prg_usr_progress`
--


--
-- Table structure for table `prg_usr_progress_seq`
--

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

--
-- Dumping data for table `prg_usr_progress_seq`
--


--
-- Table structure for table `prtf_role_assignment`
--

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

--
-- Dumping data for table `prtf_role_assignment`
--


--
-- Table structure for table `qpl_a_cloze`
--

CREATE TABLE `qpl_a_cloze` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle` varchar(1) DEFAULT '1',
  `answertext` varchar(1000) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `aorder` smallint(6) NOT NULL DEFAULT '0',
  `gap_id` smallint(6) NOT NULL DEFAULT '0',
  `cloze_type` varchar(1) DEFAULT '0',
  `lowerlimit` varchar(20) DEFAULT '0',
  `upperlimit` varchar(20) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `gap_size` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`gap_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_cloze`
--


--
-- Table structure for table `qpl_a_cloze_combi_res`
--

CREATE TABLE `qpl_a_cloze_combi_res` (
  `combination_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `gap_fi` int(11) NOT NULL DEFAULT '0',
  `answer` varchar(1000) DEFAULT NULL,
  `points` double DEFAULT NULL,
  `best_solution` tinyint(4) DEFAULT NULL,
  `row_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`combination_id`,`question_fi`,`gap_fi`,`row_id`),
  KEY `i1_idx` (`gap_fi`,`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_cloze_combi_res`
--


--
-- Table structure for table `qpl_a_cloze_seq`
--

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

--
-- Dumping data for table `qpl_a_cloze_seq`
--


--
-- Table structure for table `qpl_a_errortext`
--

CREATE TABLE `qpl_a_errortext` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `text_wrong` varchar(150) NOT NULL DEFAULT '',
  `text_correct` varchar(150) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `sequence` smallint(6) NOT NULL DEFAULT '0',
  `position` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_errortext`
--


--
-- Table structure for table `qpl_a_errortext_seq`
--

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

--
-- Dumping data for table `qpl_a_errortext_seq`
--


--
-- Table structure for table `qpl_a_essay`
--

CREATE TABLE `qpl_a_essay` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) DEFAULT NULL,
  `answertext` varchar(1000) DEFAULT NULL,
  `points` double DEFAULT NULL,
  PRIMARY KEY (`answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_essay`
--


--
-- Table structure for table `qpl_a_essay_seq`
--

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

--
-- Dumping data for table `qpl_a_essay_seq`
--


--
-- Table structure for table `qpl_a_imagemap`
--

CREATE TABLE `qpl_a_imagemap` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(4000) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `aorder` smallint(6) NOT NULL DEFAULT '0',
  `coords` varchar(4000) DEFAULT NULL,
  `area` varchar(20) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `points_unchecked` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_imagemap`
--


--
-- Table structure for table `qpl_a_imagemap_seq`
--

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

--
-- Dumping data for table `qpl_a_imagemap_seq`
--


--
-- Table structure for table `qpl_a_kprim`
--

CREATE TABLE `qpl_a_kprim` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(1000) DEFAULT NULL,
  `imagefile` varchar(255) DEFAULT NULL,
  `correctness` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`,`position`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_kprim`
--


--
-- Table structure for table `qpl_a_lome`
--

CREATE TABLE `qpl_a_lome` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `gap_number` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `answer_text` varchar(1000) DEFAULT NULL,
  `points` double DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`question_fi`,`gap_number`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_lome`
--


--
-- Table structure for table `qpl_a_matching`
--

CREATE TABLE `qpl_a_matching` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `term_fi` int(11) NOT NULL DEFAULT '0',
  `points` double NOT NULL DEFAULT '0',
  `definition_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`),
  KEY `i2_idx` (`term_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_matching`
--


--
-- Table structure for table `qpl_a_matching_seq`
--

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

--
-- Dumping data for table `qpl_a_matching_seq`
--


--
-- Table structure for table `qpl_a_mc`
--

CREATE TABLE `qpl_a_mc` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(1000) DEFAULT NULL,
  `imagefile` varchar(1000) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `points_unchecked` double NOT NULL DEFAULT '0',
  `aorder` smallint(6) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_mc`
--


--
-- Table structure for table `qpl_a_mc_seq`
--

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

--
-- Dumping data for table `qpl_a_mc_seq`
--


--
-- Table structure for table `qpl_a_mdef`
--

CREATE TABLE `qpl_a_mdef` (
  `def_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `definition` varchar(1000) DEFAULT NULL,
  `ident` int(11) NOT NULL DEFAULT '0',
  `picture` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`def_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_mdef`
--


--
-- Table structure for table `qpl_a_mdef_seq`
--

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

--
-- Dumping data for table `qpl_a_mdef_seq`
--


--
-- Table structure for table `qpl_a_mterm`
--

CREATE TABLE `qpl_a_mterm` (
  `term_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `term` varchar(1000) DEFAULT NULL,
  `picture` varchar(1000) DEFAULT NULL,
  `ident` int(11) DEFAULT NULL,
  PRIMARY KEY (`term_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_mterm`
--


--
-- Table structure for table `qpl_a_mterm_seq`
--

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

--
-- Dumping data for table `qpl_a_mterm_seq`
--


--
-- Table structure for table `qpl_a_ordering`
--

CREATE TABLE `qpl_a_ordering` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(1000) DEFAULT NULL,
  `solution_key` smallint(6) NOT NULL DEFAULT '0',
  `random_id` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `depth` int(11) NOT NULL DEFAULT '0',
  `position` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_ordering`
--


--
-- Table structure for table `qpl_a_ordering_seq`
--

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

--
-- Dumping data for table `qpl_a_ordering_seq`
--


--
-- Table structure for table `qpl_a_sc`
--

CREATE TABLE `qpl_a_sc` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(1000) DEFAULT NULL,
  `imagefile` varchar(1000) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `aorder` smallint(6) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_sc`
--


--
-- Table structure for table `qpl_a_sc_seq`
--

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

--
-- Dumping data for table `qpl_a_sc_seq`
--


--
-- Table structure for table `qpl_a_textsubset`
--

CREATE TABLE `qpl_a_textsubset` (
  `answer_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answertext` varchar(1000) DEFAULT NULL,
  `points` double NOT NULL DEFAULT '0',
  `aorder` smallint(6) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`answer_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_a_textsubset`
--


--
-- Table structure for table `qpl_a_textsubset_seq`
--

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

--
-- Dumping data for table `qpl_a_textsubset_seq`
--


--
-- Table structure for table `qpl_fb_generic`
--

CREATE TABLE `qpl_fb_generic` (
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `correctness` varchar(1) DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `feedback` longtext,
  PRIMARY KEY (`feedback_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_fb_generic`
--


--
-- Table structure for table `qpl_fb_generic_seq`
--

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

--
-- Dumping data for table `qpl_fb_generic_seq`
--


--
-- Table structure for table `qpl_fb_specific`
--

CREATE TABLE `qpl_fb_specific` (
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `answer` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `feedback` longtext,
  `question` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`feedback_id`),
  UNIQUE KEY `con_idx` (`question_fi`,`question`,`answer`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_fb_specific`
--


--
-- Table structure for table `qpl_fb_specific_seq`
--

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

--
-- Dumping data for table `qpl_fb_specific_seq`
--


--
-- Table structure for table `qpl_hint_tracking`
--

CREATE TABLE `qpl_hint_tracking` (
  `qhtr_track_id` int(11) NOT NULL DEFAULT '0',
  `qhtr_active_fi` int(11) NOT NULL DEFAULT '0',
  `qhtr_pass` int(11) NOT NULL DEFAULT '0',
  `qhtr_question_fi` int(11) NOT NULL DEFAULT '0',
  `qhtr_hint_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`qhtr_track_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_hint_tracking`
--


--
-- Table structure for table `qpl_hint_tracking_seq`
--

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

--
-- Dumping data for table `qpl_hint_tracking_seq`
--


--
-- Table structure for table `qpl_hints`
--

CREATE TABLE `qpl_hints` (
  `qht_hint_id` int(11) NOT NULL DEFAULT '0',
  `qht_question_fi` int(11) NOT NULL DEFAULT '0',
  `qht_hint_index` int(11) NOT NULL DEFAULT '0',
  `qht_hint_points` double NOT NULL DEFAULT '0',
  `qht_hint_text` longtext,
  PRIMARY KEY (`qht_hint_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_hints`
--


--
-- Table structure for table `qpl_hints_seq`
--

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

--
-- Dumping data for table `qpl_hints_seq`
--


--
-- Table structure for table `qpl_num_range`
--

CREATE TABLE `qpl_num_range` (
  `range_id` int(11) NOT NULL DEFAULT '0',
  `lowerlimit` varchar(20) DEFAULT '0',
  `upperlimit` varchar(20) DEFAULT '0',
  `points` double NOT NULL DEFAULT '0',
  `aorder` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`range_id`),
  KEY `i6_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_num_range`
--


--
-- Table structure for table `qpl_num_range_seq`
--

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

--
-- Dumping data for table `qpl_num_range_seq`
--


--
-- Table structure for table `qpl_qst_cloze`
--

CREATE TABLE `qpl_qst_cloze` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `textgap_rating` varchar(2) DEFAULT NULL,
  `identical_scoring` varchar(1) DEFAULT '1',
  `fixed_textlen` int(11) DEFAULT NULL,
  `cloze_text` longtext,
  `feedback_mode` varchar(16) NOT NULL DEFAULT 'gapQuestion',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_cloze`
--


--
-- Table structure for table `qpl_qst_errortext`
--

CREATE TABLE `qpl_qst_errortext` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `errortext` varchar(4000) NOT NULL DEFAULT '',
  `textsize` double NOT NULL DEFAULT '100',
  `points_wrong` double NOT NULL DEFAULT '-1',
  `parsed_errortext` longtext,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_errortext`
--


--
-- Table structure for table `qpl_qst_essay`
--

CREATE TABLE `qpl_qst_essay` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `maxnumofchars` int(11) NOT NULL DEFAULT '0',
  `keywords` varchar(4000) DEFAULT NULL,
  `textgap_rating` varchar(2) DEFAULT NULL,
  `matchcondition` smallint(6) NOT NULL DEFAULT '0',
  `keyword_relation` varchar(3) NOT NULL DEFAULT 'any',
  `word_cnt_enabled` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_essay`
--


--
-- Table structure for table `qpl_qst_fileupload`
--

CREATE TABLE `qpl_qst_fileupload` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `allowedextensions` varchar(255) DEFAULT NULL,
  `maxsize` double DEFAULT NULL,
  `compl_by_submission` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_fileupload`
--


--
-- Table structure for table `qpl_qst_flash`
--

CREATE TABLE `qpl_qst_flash` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `params` varchar(4000) DEFAULT NULL,
  `applet` varchar(150) DEFAULT NULL,
  `width` int(11) NOT NULL DEFAULT '550',
  `height` int(11) NOT NULL DEFAULT '400',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_flash`
--


--
-- Table structure for table `qpl_qst_horder`
--

CREATE TABLE `qpl_qst_horder` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `ordertext` varchar(2000) DEFAULT NULL,
  `textsize` double DEFAULT NULL,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_horder`
--


--
-- Table structure for table `qpl_qst_imagemap`
--

CREATE TABLE `qpl_qst_imagemap` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `image_file` varchar(100) DEFAULT NULL,
  `is_multiple_choice` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_imagemap`
--


--
-- Table structure for table `qpl_qst_javaapplet`
--

CREATE TABLE `qpl_qst_javaapplet` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `image_file` varchar(100) DEFAULT NULL,
  `params` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_javaapplet`
--


--
-- Table structure for table `qpl_qst_kprim`
--

CREATE TABLE `qpl_qst_kprim` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle_answers` tinyint(4) NOT NULL DEFAULT '0',
  `answer_type` varchar(16) NOT NULL DEFAULT 'singleLine',
  `thumb_size` int(11) DEFAULT NULL,
  `opt_label` varchar(32) NOT NULL DEFAULT 'right/wrong',
  `custom_true` varchar(255) DEFAULT NULL,
  `custom_false` varchar(255) DEFAULT NULL,
  `score_partsol` tinyint(4) NOT NULL DEFAULT '0',
  `feedback_setting` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_kprim`
--


--
-- Table structure for table `qpl_qst_lome`
--

CREATE TABLE `qpl_qst_lome` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle_answers` tinyint(4) NOT NULL DEFAULT '0',
  `answer_type` varchar(16) NOT NULL DEFAULT 'singleLine',
  `feedback_setting` int(11) NOT NULL DEFAULT '1',
  `long_menu_text` longtext,
  `min_auto_complete` tinyint(4) DEFAULT '3',
  `identical_scoring` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_lome`
--


--
-- Table structure for table `qpl_qst_matching`
--

CREATE TABLE `qpl_qst_matching` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle` varchar(1) DEFAULT '1',
  `matching_type` varchar(1) DEFAULT '1',
  `thumb_geometry` int(11) NOT NULL DEFAULT '100',
  `matching_mode` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_matching`
--


--
-- Table structure for table `qpl_qst_mc`
--

CREATE TABLE `qpl_qst_mc` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle` varchar(1) DEFAULT '1',
  `allow_images` varchar(1) DEFAULT '0',
  `resize_images` varchar(1) DEFAULT '0',
  `thumb_size` smallint(6) DEFAULT NULL,
  `feedback_setting` tinyint(4) NOT NULL DEFAULT '1',
  `selection_limit` int(11) DEFAULT NULL,
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_mc`
--


--
-- Table structure for table `qpl_qst_numeric`
--

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

--
-- Dumping data for table `qpl_qst_numeric`
--


--
-- Table structure for table `qpl_qst_ordering`
--

CREATE TABLE `qpl_qst_ordering` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `ordering_type` varchar(1) DEFAULT '1',
  `thumb_geometry` int(11) NOT NULL DEFAULT '100',
  `element_height` int(11) DEFAULT NULL,
  `scoring_type` mediumint(9) NOT NULL DEFAULT '0',
  `reduced_points` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_ordering`
--


--
-- Table structure for table `qpl_qst_sc`
--

CREATE TABLE `qpl_qst_sc` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `shuffle` varchar(1) DEFAULT '1',
  `allow_images` varchar(1) DEFAULT '0',
  `resize_images` varchar(1) DEFAULT '0',
  `thumb_size` smallint(6) DEFAULT NULL,
  `feedback_setting` tinyint(4) DEFAULT '2',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_sc`
--


--
-- Table structure for table `qpl_qst_skl_assigns`
--

CREATE TABLE `qpl_qst_skl_assigns` (
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `skill_base_fi` int(11) NOT NULL DEFAULT '0',
  `skill_tref_fi` int(11) NOT NULL DEFAULT '0',
  `skill_points` int(11) NOT NULL DEFAULT '0',
  `eval_mode` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`obj_fi`,`question_fi`,`skill_base_fi`,`skill_tref_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_skl_assigns`
--


--
-- Table structure for table `qpl_qst_skl_sol_expr`
--

CREATE TABLE `qpl_qst_skl_sol_expr` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `skill_base_fi` int(11) NOT NULL DEFAULT '0',
  `skill_tref_fi` int(11) NOT NULL DEFAULT '0',
  `order_index` int(11) NOT NULL DEFAULT '0',
  `expression` varchar(255) NOT NULL DEFAULT ' ',
  `points` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_fi`,`skill_base_fi`,`skill_tref_fi`,`order_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_skl_sol_expr`
--


--
-- Table structure for table `qpl_qst_textsubset`
--

CREATE TABLE `qpl_qst_textsubset` (
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `textgap_rating` varchar(2) DEFAULT NULL,
  `correctanswers` int(11) DEFAULT '0',
  PRIMARY KEY (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_textsubset`
--


--
-- Table structure for table `qpl_qst_type`
--

CREATE TABLE `qpl_qst_type` (
  `question_type_id` int(11) NOT NULL DEFAULT '0',
  `type_tag` varchar(35) DEFAULT NULL,
  `plugin` tinyint(4) NOT NULL DEFAULT '0',
  `plugin_name` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`question_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_qst_type`
--

INSERT INTO `qpl_qst_type` VALUES (1,'assSingleChoice',0,NULL),(2,'assMultipleChoice',0,NULL),(3,'assClozeTest',0,NULL),(4,'assMatchingQuestion',0,NULL),(5,'assOrderingQuestion',0,NULL),(6,'assImagemapQuestion',0,NULL),(8,'assTextQuestion',0,NULL),(9,'assNumeric',0,NULL),(10,'assTextSubset',0,NULL),(13,'assOrderingHorizontal',0,NULL),(14,'assFileUpload',0,NULL),(15,'assErrorText',0,NULL),(16,'assFormulaQuestion',0,NULL),(17,'assKprimChoice',0,NULL),(18,'assLongMenu',0,NULL);

--
-- Table structure for table `qpl_questionpool`
--

CREATE TABLE `qpl_questionpool` (
  `id_questionpool` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `questioncount` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `show_taxonomies` tinyint(4) NOT NULL DEFAULT '0',
  `skill_service` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id_questionpool`),
  KEY `i1_idx` (`obj_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_questionpool`
--


--
-- Table structure for table `qpl_questionpool_seq`
--

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

--
-- Dumping data for table `qpl_questionpool_seq`
--


--
-- Table structure for table `qpl_questions`
--

CREATE TABLE `qpl_questions` (
  `question_id` int(11) NOT NULL DEFAULT '0',
  `question_type_fi` int(11) NOT NULL DEFAULT '0',
  `obj_fi` int(11) NOT NULL DEFAULT '0',
  `title` varchar(124) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `author` varchar(512) DEFAULT NULL,
  `owner` int(11) NOT NULL DEFAULT '0',
  `points` double DEFAULT NULL,
  `complete` varchar(1) DEFAULT '1',
  `original_id` int(11) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `nr_of_tries` int(11) NOT NULL DEFAULT '0',
  `question_text` longtext,
  `add_cont_edit_mode` varchar(16) DEFAULT NULL,
  `external_id` varchar(255) DEFAULT NULL,
  `lifecycle` varchar(16) DEFAULT 'draft',
  PRIMARY KEY (`question_id`),
  KEY `i1_idx` (`question_type_fi`),
  KEY `i2_idx` (`original_id`),
  KEY `i3_idx` (`obj_fi`),
  KEY `i4_idx` (`title`),
  KEY `i5_idx` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_questions`
--


--
-- Table structure for table `qpl_questions_seq`
--

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

--
-- Dumping data for table `qpl_questions_seq`
--


--
-- Table structure for table `qpl_sol_sug`
--

CREATE TABLE `qpl_sol_sug` (
  `suggested_solution_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `internal_link` varchar(50) DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  `subquestion_index` int(11) NOT NULL DEFAULT '0',
  `type` varchar(32) DEFAULT NULL,
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `value` longtext,
  PRIMARY KEY (`suggested_solution_id`),
  KEY `i1_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qpl_sol_sug`
--


--
-- Table structure for table `qpl_sol_sug_seq`
--

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

--
-- Dumping data for table `qpl_sol_sug_seq`
--


--
-- Table structure for table `rbac_fa`
--

CREATE TABLE `rbac_fa` (
  `rol_id` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `assign` char(1) DEFAULT NULL,
  `protected` char(1) DEFAULT 'n',
  `blocked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rol_id`,`parent`),
  KEY `i1_idx` (`parent`),
  KEY `i2_idx` (`assign`,`rol_id`),
  KEY `i3_idx` (`assign`,`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_fa`
--

INSERT INTO `rbac_fa` VALUES (2,8,'y','y',0),(3,8,'n','n',0),(4,8,'y','n',0),(5,8,'y','n',0),(14,8,'y','n',0),(80,8,'n','y',0),(81,8,'n','n',0),(82,8,'n','n',0),(83,8,'n','n',0),(110,8,'n','y',0),(111,8,'n','n',0),(112,8,'n','n',0),(125,8,'n','y',0),(131,8,'n','n',0),(148,8,'n','n',0),(187,46,'y','n',0),(188,8,'n','n',0),(202,8,'n','n',0),(222,8,'n','n',0),(231,8,'n','n',0),(267,8,'n','n',0),(268,8,'n','n',0),(269,8,'n','n',0),(278,8,'n','n',0),(279,8,'n','n',0);

--
-- Table structure for table `rbac_log`
--

CREATE TABLE `rbac_log` (
  `log_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `ref_id` int(11) NOT NULL DEFAULT '0',
  `action` tinyint(4) NOT NULL DEFAULT '0',
  `data` longtext,
  PRIMARY KEY (`log_id`),
  KEY `i1_idx` (`ref_id`),
  KEY `i2_idx` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_log`
--


--
-- Table structure for table `rbac_log_seq`
--

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

--
-- Dumping data for table `rbac_log_seq`
--


--
-- Table structure for table `rbac_operations`
--

CREATE TABLE `rbac_operations` (
  `ops_id` int(11) NOT NULL DEFAULT '0',
  `operation` char(32) DEFAULT NULL,
  `description` char(255) DEFAULT NULL,
  `class` char(16) DEFAULT NULL,
  `op_order` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ops_id`),
  KEY `i1_idx` (`operation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_operations`
--

INSERT INTO `rbac_operations` VALUES (1,'edit_permission','edit permissions','rbac',9000),(2,'visible','view object','general',1000),(3,'read','access object','general',2000),(4,'write','modify object','general',6000),(6,'delete','remove object','general',8000),(7,'join','join/subscribe','object',1200),(8,'leave','leave/unsubscribe','object',1400),(9,'add_reply','Reply to forum articles','object',3050),(10,'moderate_frm','delete forum articles','object',3750),(11,'smtp_mail','send external mail','object',210),(13,'create_usr','create new user account','create',9999),(14,'create_role','create new role definition','create',9999),(15,'create_rolt','create new role definition template','create',9999),(16,'create_cat','create new category','create',9999),(17,'create_grp','create new group','create',9999),(18,'create_frm','create new forum','create',9999),(19,'create_crs','create new course','create',9999),(20,'create_lm','create new learning module','create',9999),(21,'create_sahs','create new SCORM/AICC learning module','create',9999),(22,'create_glo','create new glossary','create',9999),(24,'create_exc','create new exercise','create',9999),(25,'create_file','upload new file','create',9999),(26,'create_fold','create new folder','create',9999),(27,'create_tst','create new test','create',9999),(28,'create_qpl','create new question pool','create',9999),(30,'internal_mail','users can use mail system','object',200),(31,'create_mep','create new media pool','create',9999),(32,'create_htlm','create new html learning module','create',9999),(40,'edit_userassignment','change userassignment of roles','object',2500),(41,'edit_roleassignment','change roleassignments of user accounts','object',2500),(42,'create_svy','create new survey','create',9999),(43,'create_spl','create new question pool (Survey)','create',9999),(45,'invite','invite','object',2600),(47,'cat_administrate_users','Administrate local user','object',7050),(48,'read_users','read local users','object',7000),(49,'push_desktop_items','Allow pushing desktop items','object',2400),(50,'create_webr','create web resource','create',9999),(51,'search','Allow using search','object',300),(52,'moderate','Moderate objects','object',3700),(55,'edit_learning_progress','edit learning progress','object',3600),(56,'tst_statistics','view the statistics of a test','object',7100),(57,'export_member_data','Export member data','object',0),(58,'copy','Copy Object','general',4000),(59,'create_feed','create external feed','create',9999),(60,'create_mcst','create media cast','create',9999),(61,'create_rcrs','create remote course','create',9999),(62,'add_thread','Add Threads','object',3100),(63,'create_sess','create session','create',9999),(64,'edit_content','Edit content','object',3000),(65,'create_wiki','create wiki','create',9999),(66,'edit_event','Edit calendar event','object',3600),(67,'create_crsr','create course reference','create',9999),(68,'create_catr','create category reference','create',9999),(69,'mail_to_global_roles','User may send mails to global roles','object',230),(71,'create_book','create booking pool','create',9999),(72,'add_consultation_hours','Add Consultation Hours Calendar','object',300),(73,'create_chtr','create chatroom','create',9999),(74,'create_blog','Create Blog','create',9999),(75,'create_dcl','Create Data Collection','create',9999),(76,'create_poll','Create Poll','create',9999),(77,'add_entry','Add Entry','object',3200),(78,'create_itgr','Create Item Group','create',9999),(79,'contribute','Contribute','object',3205),(80,'lp_other_users','See LP Data Of Other Users','object',250),(81,'create_bibl','Create Bibliographic','create',9999),(82,'create_cld','Create Cloud Folder','create',9999),(83,'upload','Upload Items','object',3240),(84,'delete_files','Delete Files','object',3260),(85,'delete_folders','Delete Folders','object',3270),(86,'download','Download Items','object',3230),(87,'files_visible','Files are visible','object',3210),(88,'folders_visible','Folders are visible','object',3220),(89,'folders_create','Folders may be created','object',3250),(90,'create_prtt','Create Portfolio Template','create',9999),(91,'create_orgu','Create OrgUnit','create',9999),(92,'view_learning_progress','View learning progress from users in this orgu.','object',270),(93,'view_learning_progress_rec','View learning progress from users in this orgu and subsequent orgus.','object',280),(94,'statistics_read','Read Statistics','object',2200),(95,'read_learning_progress','Read Learning Progress','object',2300),(96,'redact','Redact','object',3900),(97,'edit_wiki_navigation','Edit Wiki Navigation','object',3220),(98,'delete_wiki_pages','Delete Wiki Pages','object',3300),(99,'activate_wiki_protection','Set Read-Only','object',3240),(100,'wiki_html_export','Wiki HTML Export','object',3242),(101,'create_prg','Create Study Programme','create',9999),(102,'manage_members','Manage Members','object',2400),(103,'sty_write_content','Edit Content Styles','object',6101),(104,'sty_write_system','Edit System Styles','object',6100),(105,'sty_write_page_layout','Edit Page Layouts','object',6102),(106,'create_grpr','Create Group Reference','create',9999),(107,'news_add_news','Add News','object',2100),(108,'create_iass','Create Individual Assessment','create',9999),(109,'edit_members','Manage members','object',2400),(110,'amend_grading','Amend grading','object',8200),(111,'grade','Grade','object',2410),(112,'edit_page_meta','Edit Page Metadata','object',3050),(113,'release_objects','Release objects','object',500),(114,'edit_submissions_grades','Edit Submissions Grades','object',3800),(115,'tst_results','view the results of test participants','object',7050),(116,'create_copa','Create Content Page Object','create',9999),(117,'manage_materials','Manage Materials','object',6500),(118,'edit_metadata','Edit Metadata','object',5800),(119,'create_lso','Create Learning Sequence','create',9999),(120,'participate','Participate to Learning Sequence','object',1010),(121,'unparticipate','Unparticipate from Learning Sequence','object',1020),(122,'read_results','Access Results','object',2500),(123,'change_presentation','change presentation of a view','object',200),(124,'upload_blacklisted_files','Upload Blacklisted Files','object',1),(125,'read_outcomes','Access Outcomes','object',2250),(126,'create_lti','Create LTI Consumer Object','create',9999),(127,'create_cmix','Create cmi5/xAPI Object','create',9999),(128,'add_consume_provider','Allow Add Own Provider','object',3510),(129,'create_prgr','Create Study Programme Reference','create',9999),(130,'add_pages','Create Pages','object',3070),(131,'edit_file','Edit File','object',5990),(132,'read_comp','Read Competences','object',6500),(133,'read_profiles','Read Competence Profiles','object',6510),(134,'manage_comp','Manage Competences','object',8500),(135,'manage_comp_temp','Manage Competence Templates','object',8510),(136,'manage_profiles','Manage Competence Profiles','object',8520),(137,'create_skee','Create Skill Tree','create',9999);

--
-- Table structure for table `rbac_operations_seq`
--

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

--
-- Dumping data for table `rbac_operations_seq`
--

INSERT INTO `rbac_operations_seq` VALUES (137);

--
-- Table structure for table `rbac_pa`
--

CREATE TABLE `rbac_pa` (
  `rol_id` int(11) NOT NULL DEFAULT '0',
  `ops_id` varchar(4000) DEFAULT NULL,
  `ref_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rol_id`,`ref_id`),
  KEY `i1_idx` (`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_pa`
--

INSERT INTO `rbac_pa` VALUES (2,'a:1:{i:0;s:2:\"51\";}',22),(3,'a:1:{i:0;s:2:\"51\";}',22),(4,'a:2:{i:0;i:3;i:1;i:2;}',1),(4,'a:1:{i:0;i:30;}',12),(4,'a:1:{i:0;i:51;}',22),(4,'a:2:{i:0;i:2;i:1;i:3;}',24),(4,'a:2:{i:0;i:2;i:1;i:3;}',46),(5,'a:2:{i:0;i:3;i:1;i:2;}',1),(5,'a:2:{i:0;i:30;i:1;i:69;}',12),(5,'a:1:{i:0;s:2:\"51\";}',22),(14,'a:2:{i:0;i:3;i:1;i:2;}',1),(14,'a:1:{i:0;i:69;}',12),(14,'a:1:{i:0;s:2:\"51\";}',22),(80,'a:1:{i:0;s:2:\"51\";}',22),(81,'a:1:{i:0;s:2:\"51\";}',22),(82,'a:1:{i:0;s:2:\"51\";}',22),(83,'a:1:{i:0;s:2:\"51\";}',22),(110,'a:1:{i:0;s:2:\"51\";}',22),(111,'a:1:{i:0;s:2:\"51\";}',22),(112,'a:1:{i:0;s:2:\"51\";}',22),(187,'a:3:{i:0;i:52;i:1;i:3;i:2;i:2;}',46);

--
-- Table structure for table `rbac_ta`
--

CREATE TABLE `rbac_ta` (
  `typ_id` int(11) NOT NULL DEFAULT '0',
  `ops_id` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`typ_id`,`ops_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_ta`
--

INSERT INTO `rbac_ta` VALUES (15,1),(15,2),(15,3),(15,4),(15,6),(15,7),(15,8),(15,17),(15,18),(15,20),(15,21),(15,22),(15,24),(15,25),(15,26),(15,27),(15,28),(15,31),(15,32),(15,42),(15,43),(15,50),(15,55),(15,58),(15,59),(15,60),(15,63),(15,65),(15,66),(15,67),(15,68),(15,71),(15,73),(15,74),(15,75),(15,76),(15,78),(15,81),(15,82),(15,90),(15,95),(15,102),(15,106),(15,107),(15,111),(15,116),(15,119),(15,126),(15,127),(16,1),(16,2),(16,3),(16,4),(16,6),(16,16),(16,17),(16,18),(16,19),(16,20),(16,21),(16,22),(16,24),(16,25),(16,27),(16,28),(16,31),(16,32),(16,42),(16,43),(16,47),(16,48),(16,50),(16,58),(16,59),(16,60),(16,61),(16,65),(16,67),(16,68),(16,71),(16,73),(16,74),(16,75),(16,76),(16,78),(16,81),(16,82),(16,90),(16,101),(16,106),(16,108),(16,116),(16,119),(16,126),(16,127),(17,1),(17,2),(17,3),(17,4),(17,6),(17,7),(17,8),(17,17),(17,18),(17,20),(17,21),(17,22),(17,24),(17,25),(17,26),(17,27),(17,28),(17,31),(17,32),(17,42),(17,43),(17,50),(17,55),(17,58),(17,59),(17,60),(17,63),(17,65),(17,66),(17,67),(17,68),(17,71),(17,73),(17,74),(17,75),(17,76),(17,78),(17,81),(17,82),(17,90),(17,95),(17,102),(17,106),(17,107),(17,108),(17,111),(17,116),(17,119),(17,126),(17,127),(19,1),(19,2),(19,3),(19,4),(19,11),(19,30),(19,69),(20,1),(20,2),(20,3),(20,4),(20,6),(20,55),(20,58),(20,95),(21,1),(21,2),(21,3),(21,4),(22,1),(22,2),(22,3),(22,4),(22,6),(22,13),(22,41),(22,49),(23,1),(23,2),(23,3),(23,4),(23,6),(23,14),(23,15),(23,40),(24,1),(24,2),(24,3),(24,4),(28,1),(28,2),(28,3),(28,4),(32,1),(32,2),(32,3),(32,4),(32,6),(32,58),(32,64),(33,1),(33,2),(33,3),(33,4),(33,16),(33,17),(33,18),(33,19),(33,20),(33,21),(33,22),(33,24),(33,25),(33,27),(33,28),(33,31),(33,32),(33,42),(33,43),(33,50),(33,59),(33,60),(33,61),(33,65),(33,67),(33,68),(33,71),(33,73),(33,74),(33,75),(33,76),(33,78),(33,81),(33,82),(33,90),(33,91),(33,101),(33,106),(33,108),(33,116),(33,119),(33,126),(33,127),(34,1),(34,2),(34,3),(34,4),(34,6),(34,55),(34,58),(34,95),(37,1),(37,2),(37,3),(37,4),(37,6),(37,9),(37,10),(37,55),(37,58),(37,62),(37,95),(84,1),(84,2),(84,3),(84,4),(84,6),(84,55),(84,58),(84,95),(84,114),(85,1),(85,2),(85,3),(85,4),(87,1),(87,2),(87,3),(87,4),(87,6),(87,17),(87,18),(87,20),(87,21),(87,22),(87,24),(87,25),(87,26),(87,27),(87,28),(87,31),(87,32),(87,42),(87,43),(87,50),(87,55),(87,58),(87,60),(87,63),(87,65),(87,71),(87,73),(87,74),(87,75),(87,76),(87,78),(87,81),(87,82),(87,90),(87,95),(87,106),(87,116),(87,119),(87,126),(87,127),(88,1),(88,2),(88,3),(88,4),(88,6),(88,55),(88,58),(88,95),(88,131),(94,1),(94,2),(94,3),(94,4),(94,6),(94,55),(94,56),(94,58),(94,95),(94,115),(95,1),(95,2),(95,3),(95,4),(95,6),(95,58),(96,1),(96,2),(96,3),(96,4),(96,6),(96,52),(96,58),(97,1),(97,2),(97,3),(97,4),(99,1),(99,2),(99,3),(99,4),(101,1),(101,2),(101,3),(101,4),(101,6),(101,58),(102,1),(102,2),(102,3),(102,4),(102,6),(102,55),(102,58),(102,95),(103,1),(103,2),(103,3),(103,4),(103,6),(103,45),(103,55),(103,58),(103,95),(103,122),(104,1),(104,2),(104,3),(104,4),(104,6),(104,58),(106,1),(106,2),(106,3),(106,4),(106,66),(106,70),(106,72),(108,1),(108,2),(108,3),(108,4),(108,6),(108,80),(115,1),(115,2),(115,3),(115,4),(117,1),(117,2),(117,3),(117,103),(117,104),(117,105),(122,1),(122,2),(122,3),(122,4),(122,6),(122,58),(123,1),(123,2),(123,3),(123,4),(123,51),(127,1),(127,2),(127,3),(127,4),(135,1),(135,2),(135,3),(135,4),(137,1),(137,2),(137,3),(137,4),(137,57),(139,1),(139,2),(139,3),(139,4),(141,1),(141,3),(141,4),(141,6),(141,58),(142,1),(142,2),(142,3),(142,4),(142,6),(142,55),(142,58),(142,95),(143,1),(143,2),(143,3),(143,4),(143,123),(145,1),(145,2),(145,3),(145,4),(145,6),(146,1),(146,2),(146,3),(146,4),(149,1),(149,2),(149,3),(149,4),(151,1),(151,2),(151,3),(151,4),(151,124),(153,1),(153,2),(153,3),(153,4),(155,1),(155,2),(155,3),(155,4),(155,6),(155,55),(155,58),(155,95),(155,102),(155,117),(155,118),(156,1),(156,2),(156,3),(156,4),(158,1),(158,2),(158,3),(158,4),(158,6),(158,58),(158,64),(158,94),(158,97),(158,98),(158,99),(158,100),(158,112),(158,130),(159,1),(159,2),(159,4),(159,6),(159,55),(159,58),(159,95),(160,1),(160,2),(160,4),(160,6),(160,58),(161,1),(161,2),(161,3),(161,4),(163,1),(163,2),(163,3),(163,4),(165,1),(165,2),(165,3),(165,4),(167,1),(167,2),(167,3),(167,4),(169,1),(169,2),(169,3),(169,4),(171,1),(171,2),(171,3),(171,4),(173,1),(173,2),(173,3),(173,4),(173,6),(173,58),(174,1),(174,2),(174,3),(174,4),(174,137),(176,1),(176,2),(176,3),(176,4),(178,1),(178,2),(178,3),(178,4),(180,1),(180,2),(180,3),(180,4),(180,6),(180,52),(180,58),(182,1),(182,2),(182,3),(182,4),(183,1),(183,2),(183,3),(183,4),(189,1),(189,2),(189,3),(189,4),(189,6),(189,58),(189,79),(189,96),(190,1),(190,2),(190,3),(190,4),(190,6),(190,58),(190,64),(190,77),(191,1),(191,3),(191,4),(191,6),(191,58),(192,1),(192,2),(192,3),(192,4),(194,1),(194,2),(194,3),(194,4),(194,6),(194,58),(195,1),(195,2),(195,3),(195,4),(195,6),(196,1),(196,2),(196,3),(196,4),(196,6),(197,1),(197,2),(197,3),(197,4),(197,6),(198,1),(198,2),(198,3),(198,4),(198,6),(199,1),(199,2),(199,3),(199,4),(199,6),(200,1),(200,2),(200,3),(200,4),(200,6),(201,1),(201,2),(201,3),(201,4),(201,6),(203,1),(203,2),(203,3),(203,4),(205,1),(205,2),(205,3),(205,4),(207,1),(207,2),(207,3),(207,4),(207,6),(207,58),(208,1),(208,2),(208,3),(208,4),(210,1),(210,2),(210,3),(210,4),(210,6),(210,83),(210,84),(210,85),(210,86),(210,87),(210,88),(210,89),(211,1),(211,2),(211,3),(211,4),(213,1),(213,2),(213,3),(213,4),(215,1),(215,2),(215,3),(215,4),(217,1),(217,2),(217,3),(217,4),(219,1),(219,2),(219,3),(219,4),(219,6),(219,58),(220,1),(220,2),(220,3),(220,4),(220,6),(220,47),(220,48),(220,58),(220,91),(220,92),(220,93),(223,1),(223,2),(223,3),(223,4),(225,1),(225,2),(225,3),(225,4),(227,1),(227,2),(227,3),(227,4),(229,1),(229,2),(229,3),(229,4),(232,1),(232,2),(232,3),(232,4),(234,1),(234,2),(234,3),(234,4),(236,1),(236,2),(236,3),(236,4),(236,6),(236,58),(236,101),(236,102),(236,129),(237,1),(237,2),(237,3),(237,4),(239,1),(239,2),(239,3),(239,4),(261,1),(261,2),(261,4),(261,6),(261,58),(262,1),(262,2),(262,3),(262,4),(266,1),(266,2),(266,3),(266,4),(266,6),(266,55),(266,58),(266,95),(266,109),(266,110),(272,1),(272,2),(272,3),(272,4),(272,113),(272,128),(274,1),(274,2),(274,3),(274,4),(274,6),(274,55),(274,58),(274,95),(275,1),(275,2),(275,3),(275,4),(277,1),(277,2),(277,3),(277,4),(277,6),(277,55),(277,58),(277,95),(277,102),(277,120),(277,121),(280,1),(280,2),(280,3),(280,4),(280,6),(280,55),(280,58),(280,95),(280,125),(281,1),(281,2),(281,3),(281,4),(281,6),(281,55),(281,58),(281,95),(281,125),(282,1),(282,2),(282,3),(282,4),(284,1),(284,2),(284,3),(284,4),(286,1),(286,2),(286,3),(286,4),(288,1),(288,2),(288,3),(288,4),(290,1),(290,2),(290,3),(290,4),(292,1),(292,2),(292,4),(292,6),(292,58),(293,1),(293,2),(293,3),(293,4),(295,1),(295,2),(295,3),(295,4),(297,1),(297,2),(297,3),(297,4),(299,1),(299,2),(299,3),(299,4),(301,1),(301,2),(301,3),(301,4),(303,1),(303,2),(303,3),(303,4),(305,1),(305,2),(305,3),(305,4),(307,1),(307,2),(307,3),(307,4),(309,1),(309,2),(309,3),(309,4),(311,1),(311,2),(311,3),(311,4),(311,6),(311,58),(311,132),(311,133),(311,134),(311,135),(311,136);

--
-- Table structure for table `rbac_templates`
--

CREATE TABLE `rbac_templates` (
  `rol_id` int(11) NOT NULL DEFAULT '0',
  `type` char(5) NOT NULL DEFAULT '',
  `ops_id` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rol_id`,`parent`,`type`,`ops_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rbac_templates`
--

INSERT INTO `rbac_templates` VALUES (3,'bibl',1,8),(3,'bibl',2,8),(3,'bibl',3,8),(3,'bibl',4,8),(3,'bibl',6,8),(3,'bibl',58,8),(3,'blog',1,8),(3,'blog',2,8),(3,'blog',3,8),(3,'blog',4,8),(3,'blog',6,8),(3,'blog',58,8),(3,'blog',79,8),(3,'blog',96,8),(3,'book',1,8),(3,'book',2,8),(3,'book',3,8),(3,'book',4,8),(3,'book',6,8),(3,'book',58,8),(3,'cat',2,8),(3,'cat',3,8),(3,'cat',4,8),(3,'cat',6,8),(3,'cat',16,8),(3,'cat',17,8),(3,'cat',18,8),(3,'cat',19,8),(3,'cat',20,8),(3,'cat',21,8),(3,'cat',22,8),(3,'cat',24,8),(3,'cat',25,8),(3,'cat',27,8),(3,'cat',28,8),(3,'cat',31,8),(3,'cat',32,8),(3,'cat',42,8),(3,'cat',43,8),(3,'cat',50,8),(3,'cat',58,8),(3,'cat',59,8),(3,'cat',60,8),(3,'cat',65,8),(3,'cat',67,8),(3,'cat',68,8),(3,'cat',71,8),(3,'cat',73,8),(3,'cat',74,8),(3,'cat',75,8),(3,'cat',76,8),(3,'cat',78,8),(3,'cat',81,8),(3,'cat',82,8),(3,'cat',90,8),(3,'cat',101,8),(3,'cat',106,8),(3,'cat',108,8),(3,'cat',116,8),(3,'cat',119,8),(3,'cat',126,8),(3,'cat',127,8),(3,'catr',1,8),(3,'catr',2,8),(3,'catr',4,8),(3,'catr',6,8),(3,'catr',58,8),(3,'chtr',1,8),(3,'chtr',2,8),(3,'chtr',3,8),(3,'chtr',4,8),(3,'chtr',6,8),(3,'chtr',52,8),(3,'chtr',58,8),(3,'cld',1,8),(3,'cld',2,8),(3,'cld',3,8),(3,'cld',4,8),(3,'cld',6,8),(3,'cld',83,8),(3,'cld',84,8),(3,'cld',85,8),(3,'cld',86,8),(3,'cld',87,8),(3,'cld',88,8),(3,'cld',89,8),(3,'cmix',1,8),(3,'cmix',2,8),(3,'cmix',3,8),(3,'cmix',4,8),(3,'cmix',6,8),(3,'cmix',55,8),(3,'cmix',58,8),(3,'cmix',95,8),(3,'cmix',125,8),(3,'copa',1,8),(3,'copa',2,8),(3,'copa',3,8),(3,'copa',4,8),(3,'copa',6,8),(3,'copa',55,8),(3,'copa',58,8),(3,'copa',95,8),(3,'crs',1,8),(3,'crs',2,8),(3,'crs',3,8),(3,'crs',4,8),(3,'crs',6,8),(3,'crs',7,8),(3,'crs',8,8),(3,'crs',17,8),(3,'crs',18,8),(3,'crs',20,8),(3,'crs',21,8),(3,'crs',22,8),(3,'crs',24,8),(3,'crs',25,8),(3,'crs',26,8),(3,'crs',27,8),(3,'crs',28,8),(3,'crs',31,8),(3,'crs',32,8),(3,'crs',42,8),(3,'crs',43,8),(3,'crs',50,8),(3,'crs',55,8),(3,'crs',58,8),(3,'crs',59,8),(3,'crs',60,8),(3,'crs',63,8),(3,'crs',65,8),(3,'crs',66,8),(3,'crs',67,8),(3,'crs',68,8),(3,'crs',71,8),(3,'crs',73,8),(3,'crs',74,8),(3,'crs',75,8),(3,'crs',76,8),(3,'crs',78,8),(3,'crs',81,8),(3,'crs',82,8),(3,'crs',90,8),(3,'crs',95,8),(3,'crs',102,8),(3,'crs',106,8),(3,'crs',107,8),(3,'crs',108,8),(3,'crs',111,8),(3,'crs',116,8),(3,'crs',119,8),(3,'crs',126,8),(3,'crs',127,8),(3,'crsr',1,8),(3,'crsr',2,8),(3,'crsr',4,8),(3,'crsr',6,8),(3,'crsr',55,8),(3,'crsr',58,8),(3,'crsr',95,8),(3,'dcl',1,8),(3,'dcl',2,8),(3,'dcl',3,8),(3,'dcl',4,8),(3,'dcl',6,8),(3,'dcl',58,8),(3,'dcl',64,8),(3,'dcl',77,8),(3,'exc',1,8),(3,'exc',2,8),(3,'exc',3,8),(3,'exc',4,8),(3,'exc',6,8),(3,'exc',55,8),(3,'exc',58,8),(3,'exc',95,8),(3,'exc',114,8),(3,'feed',1,8),(3,'feed',3,8),(3,'feed',4,8),(3,'feed',6,8),(3,'feed',58,8),(3,'file',1,8),(3,'file',2,8),(3,'file',3,8),(3,'file',4,8),(3,'file',6,8),(3,'file',55,8),(3,'file',58,8),(3,'file',95,8),(3,'file',131,8),(3,'fold',1,8),(3,'fold',2,8),(3,'fold',3,8),(3,'fold',4,8),(3,'fold',6,8),(3,'fold',17,8),(3,'fold',18,8),(3,'fold',20,8),(3,'fold',21,8),(3,'fold',22,8),(3,'fold',24,8),(3,'fold',25,8),(3,'fold',26,8),(3,'fold',27,8),(3,'fold',28,8),(3,'fold',31,8),(3,'fold',32,8),(3,'fold',42,8),(3,'fold',43,8),(3,'fold',50,8),(3,'fold',55,8),(3,'fold',58,8),(3,'fold',60,8),(3,'fold',63,8),(3,'fold',65,8),(3,'fold',71,8),(3,'fold',73,8),(3,'fold',74,8),(3,'fold',75,8),(3,'fold',76,8),(3,'fold',78,8),(3,'fold',81,8),(3,'fold',82,8),(3,'fold',90,8),(3,'fold',95,8),(3,'fold',106,8),(3,'fold',108,8),(3,'fold',116,8),(3,'fold',119,8),(3,'fold',126,8),(3,'fold',127,8),(3,'frm',1,8),(3,'frm',2,8),(3,'frm',3,8),(3,'frm',4,8),(3,'frm',6,8),(3,'frm',9,8),(3,'frm',10,8),(3,'frm',55,8),(3,'frm',58,8),(3,'frm',62,8),(3,'frm',95,8),(3,'glo',1,8),(3,'glo',2,8),(3,'glo',3,8),(3,'glo',4,8),(3,'glo',6,8),(3,'glo',58,8),(3,'glo',64,8),(3,'grp',1,8),(3,'grp',2,8),(3,'grp',3,8),(3,'grp',4,8),(3,'grp',6,8),(3,'grp',7,8),(3,'grp',17,8),(3,'grp',18,8),(3,'grp',20,8),(3,'grp',21,8),(3,'grp',22,8),(3,'grp',24,8),(3,'grp',25,8),(3,'grp',26,8),(3,'grp',27,8),(3,'grp',28,8),(3,'grp',31,8),(3,'grp',32,8),(3,'grp',42,8),(3,'grp',43,8),(3,'grp',50,8),(3,'grp',55,8),(3,'grp',58,8),(3,'grp',59,8),(3,'grp',60,8),(3,'grp',63,8),(3,'grp',65,8),(3,'grp',66,8),(3,'grp',67,8),(3,'grp',68,8),(3,'grp',71,8),(3,'grp',73,8),(3,'grp',74,8),(3,'grp',75,8),(3,'grp',76,8),(3,'grp',78,8),(3,'grp',81,8),(3,'grp',82,8),(3,'grp',90,8),(3,'grp',95,8),(3,'grp',102,8),(3,'grp',106,8),(3,'grp',107,8),(3,'grp',108,8),(3,'grp',111,8),(3,'grp',116,8),(3,'grp',119,8),(3,'grp',126,8),(3,'grp',127,8),(3,'grpr',1,8),(3,'grpr',2,8),(3,'grpr',4,8),(3,'grpr',6,8),(3,'grpr',58,8),(3,'htlm',1,8),(3,'htlm',2,8),(3,'htlm',3,8),(3,'htlm',4,8),(3,'htlm',6,8),(3,'htlm',55,8),(3,'htlm',58,8),(3,'htlm',95,8),(3,'iass',1,8),(3,'iass',2,8),(3,'iass',3,8),(3,'iass',4,8),(3,'iass',6,8),(3,'iass',55,8),(3,'iass',58,8),(3,'iass',95,8),(3,'iass',109,8),(3,'itgr',1,8),(3,'itgr',2,8),(3,'itgr',3,8),(3,'itgr',4,8),(3,'itgr',6,8),(3,'itgr',58,8),(3,'lm',1,8),(3,'lm',2,8),(3,'lm',3,8),(3,'lm',4,8),(3,'lm',6,8),(3,'lm',55,8),(3,'lm',58,8),(3,'lm',95,8),(3,'lso',1,8),(3,'lso',2,8),(3,'lso',3,8),(3,'lso',4,8),(3,'lso',6,8),(3,'lso',55,8),(3,'lso',58,8),(3,'lso',95,8),(3,'lti',1,8),(3,'lti',2,8),(3,'lti',3,8),(3,'lti',4,8),(3,'lti',6,8),(3,'lti',55,8),(3,'lti',58,8),(3,'lti',95,8),(3,'lti',125,8),(3,'mcst',1,8),(3,'mcst',2,8),(3,'mcst',3,8),(3,'mcst',4,8),(3,'mcst',6,8),(3,'mcst',55,8),(3,'mcst',58,8),(3,'mcst',95,8),(3,'mep',1,8),(3,'mep',2,8),(3,'mep',3,8),(3,'mep',4,8),(3,'mep',6,8),(3,'mep',58,8),(3,'poll',1,8),(3,'poll',3,8),(3,'poll',4,8),(3,'poll',6,8),(3,'poll',58,8),(3,'prg',1,8),(3,'prg',2,8),(3,'prg',3,8),(3,'prg',4,8),(3,'prg',6,8),(3,'prg',58,8),(3,'prg',101,8),(3,'prg',102,8),(3,'prtt',1,8),(3,'prtt',2,8),(3,'prtt',3,8),(3,'prtt',4,8),(3,'prtt',6,8),(3,'prtt',58,8),(3,'qpl',1,8),(3,'qpl',2,8),(3,'qpl',3,8),(3,'qpl',4,8),(3,'qpl',6,8),(3,'qpl',58,8),(3,'root',2,8),(3,'root',3,8),(3,'sahs',1,8),(3,'sahs',2,8),(3,'sahs',3,8),(3,'sahs',4,8),(3,'sahs',6,8),(3,'sahs',55,8),(3,'sahs',58,8),(3,'sahs',95,8),(3,'sess',1,8),(3,'sess',2,8),(3,'sess',3,8),(3,'sess',4,8),(3,'sess',6,8),(3,'sess',55,8),(3,'sess',58,8),(3,'sess',95,8),(3,'sess',102,8),(3,'sess',117,8),(3,'sess',118,8),(3,'spl',1,8),(3,'spl',2,8),(3,'spl',3,8),(3,'spl',4,8),(3,'spl',6,8),(3,'spl',58,8),(3,'svy',1,8),(3,'svy',2,8),(3,'svy',3,8),(3,'svy',4,8),(3,'svy',6,8),(3,'svy',45,8),(3,'svy',55,8),(3,'svy',58,8),(3,'svy',95,8),(3,'svy',122,8),(3,'tst',1,8),(3,'tst',2,8),(3,'tst',3,8),(3,'tst',4,8),(3,'tst',6,8),(3,'tst',55,8),(3,'tst',56,8),(3,'tst',58,8),(3,'tst',95,8),(3,'tst',115,8),(3,'webr',1,8),(3,'webr',2,8),(3,'webr',3,8),(3,'webr',4,8),(3,'webr',6,8),(3,'webr',58,8),(3,'wiki',1,8),(3,'wiki',2,8),(3,'wiki',3,8),(3,'wiki',4,8),(3,'wiki',6,8),(3,'wiki',58,8),(3,'wiki',64,8),(3,'wiki',94,8),(3,'wiki',97,8),(3,'wiki',98,8),(3,'wiki',99,8),(3,'wiki',100,8),(3,'wiki',112,8),(3,'wiki',130,8),(4,'bibl',2,8),(4,'bibl',3,8),(4,'blog',2,8),(4,'blog',3,8),(4,'book',2,8),(4,'book',3,8),(4,'cat',2,8),(4,'cat',3,8),(4,'catr',2,8),(4,'chtr',2,8),(4,'chtr',3,8),(4,'cmix',2,8),(4,'cmix',3,8),(4,'copa',2,8),(4,'copa',3,8),(4,'crs',2,8),(4,'crs',7,8),(4,'crsr',2,8),(4,'dcl',2,8),(4,'dcl',3,8),(4,'exc',2,8),(4,'exc',3,8),(4,'feed',3,8),(4,'file',2,8),(4,'file',3,8),(4,'fold',2,8),(4,'fold',3,8),(4,'frm',2,8),(4,'frm',3,8),(4,'frm',9,8),(4,'frm',62,8),(4,'glo',2,8),(4,'glo',3,8),(4,'grp',2,8),(4,'grp',7,8),(4,'grpr',2,8),(4,'htlm',2,8),(4,'htlm',3,8),(4,'iass',2,8),(4,'iass',3,8),(4,'itgr',2,8),(4,'itgr',3,8),(4,'lm',2,8),(4,'lm',3,8),(4,'lso',2,8),(4,'lso',3,8),(4,'lti',2,8),(4,'lti',3,8),(4,'mail',30,8),(4,'mcst',2,8),(4,'mcst',3,8),(4,'poll',3,8),(4,'prg',2,8),(4,'prg',3,8),(4,'root',2,8),(4,'root',3,8),(4,'sahs',2,8),(4,'sahs',3,8),(4,'seas',51,8),(4,'sess',2,8),(4,'sess',3,8),(4,'svy',2,8),(4,'svy',3,8),(4,'tst',2,8),(4,'tst',3,8),(4,'webr',2,8),(4,'webr',3,8),(4,'wiki',2,8),(4,'wiki',3,8),(4,'wiki',64,8),(4,'wiki',130,8),(5,'bibl',2,8),(5,'blog',2,8),(5,'book',2,8),(5,'cat',2,8),(5,'catr',2,8),(5,'chtr',2,8),(5,'crs',2,8),(5,'crsr',2,8),(5,'dcl',2,8),(5,'exc',2,8),(5,'feed',3,8),(5,'file',2,8),(5,'frm',2,8),(5,'glo',2,8),(5,'grp',2,8),(5,'grpr',2,8),(5,'htlm',2,8),(5,'itgr',2,8),(5,'itgr',3,8),(5,'lm',2,8),(5,'mcst',2,8),(5,'prg',2,8),(5,'root',2,8),(5,'root',3,8),(5,'sahs',2,8),(5,'seas',51,8),(5,'svy',2,8),(5,'tst',2,8),(5,'webr',2,8),(5,'wiki',2,8),(14,'cat',2,8),(14,'root',2,8),(14,'root',3,8),(14,'seas',51,8),(80,'bibl',1,8),(80,'bibl',2,8),(80,'bibl',3,8),(80,'bibl',4,8),(80,'bibl',6,8),(80,'bibl',58,8),(80,'blog',1,8),(80,'blog',2,8),(80,'blog',3,8),(80,'blog',4,8),(80,'blog',6,8),(80,'blog',58,8),(80,'blog',79,8),(80,'book',1,8),(80,'book',2,8),(80,'book',3,8),(80,'book',4,8),(80,'book',6,8),(80,'book',58,8),(80,'catr',1,8),(80,'catr',2,8),(80,'catr',4,8),(80,'catr',6,8),(80,'catr',58,8),(80,'chtr',1,8),(80,'chtr',2,8),(80,'chtr',3,8),(80,'chtr',4,8),(80,'chtr',6,8),(80,'chtr',52,8),(80,'chtr',58,8),(80,'cmix',1,8),(80,'cmix',2,8),(80,'cmix',3,8),(80,'cmix',4,8),(80,'cmix',6,8),(80,'cmix',55,8),(80,'cmix',58,8),(80,'cmix',95,8),(80,'cmix',125,8),(80,'copa',1,8),(80,'copa',2,8),(80,'copa',3,8),(80,'copa',4,8),(80,'copa',6,8),(80,'copa',55,8),(80,'copa',58,8),(80,'copa',95,8),(80,'crsr',1,8),(80,'crsr',2,8),(80,'crsr',4,8),(80,'crsr',6,8),(80,'crsr',55,8),(80,'crsr',58,8),(80,'crsr',95,8),(80,'dcl',1,8),(80,'dcl',2,8),(80,'dcl',3,8),(80,'dcl',4,8),(80,'dcl',6,8),(80,'dcl',58,8),(80,'dcl',64,8),(80,'dcl',77,8),(80,'exc',1,8),(80,'exc',2,8),(80,'exc',3,8),(80,'exc',4,8),(80,'exc',6,8),(80,'exc',55,8),(80,'exc',58,8),(80,'exc',95,8),(80,'exc',114,8),(80,'feed',1,8),(80,'feed',3,8),(80,'feed',4,8),(80,'feed',6,8),(80,'feed',58,8),(80,'file',1,8),(80,'file',2,8),(80,'file',3,8),(80,'file',4,8),(80,'file',6,8),(80,'file',55,8),(80,'file',58,8),(80,'file',95,8),(80,'file',131,8),(80,'fold',1,8),(80,'fold',2,8),(80,'fold',3,8),(80,'fold',4,8),(80,'fold',6,8),(80,'fold',17,8),(80,'fold',18,8),(80,'fold',20,8),(80,'fold',21,8),(80,'fold',22,8),(80,'fold',24,8),(80,'fold',25,8),(80,'fold',26,8),(80,'fold',27,8),(80,'fold',28,8),(80,'fold',31,8),(80,'fold',32,8),(80,'fold',42,8),(80,'fold',43,8),(80,'fold',50,8),(80,'fold',55,8),(80,'fold',58,8),(80,'fold',60,8),(80,'fold',63,8),(80,'fold',65,8),(80,'fold',71,8),(80,'fold',73,8),(80,'fold',74,8),(80,'fold',75,8),(80,'fold',76,8),(80,'fold',78,8),(80,'fold',81,8),(80,'fold',82,8),(80,'fold',90,8),(80,'fold',95,8),(80,'fold',106,8),(80,'fold',108,8),(80,'fold',116,8),(80,'fold',119,8),(80,'fold',126,8),(80,'fold',127,8),(80,'frm',1,8),(80,'frm',2,8),(80,'frm',3,8),(80,'frm',4,8),(80,'frm',6,8),(80,'frm',9,8),(80,'frm',10,8),(80,'frm',55,8),(80,'frm',58,8),(80,'frm',62,8),(80,'frm',95,8),(80,'glo',1,8),(80,'glo',2,8),(80,'glo',3,8),(80,'glo',4,8),(80,'glo',6,8),(80,'glo',58,8),(80,'glo',64,8),(80,'grp',1,8),(80,'grp',2,8),(80,'grp',3,8),(80,'grp',4,8),(80,'grp',6,8),(80,'grp',7,8),(80,'grp',8,8),(80,'grp',17,8),(80,'grp',18,8),(80,'grp',20,8),(80,'grp',21,8),(80,'grp',22,8),(80,'grp',24,8),(80,'grp',25,8),(80,'grp',26,8),(80,'grp',27,8),(80,'grp',28,8),(80,'grp',31,8),(80,'grp',32,8),(80,'grp',42,8),(80,'grp',43,8),(80,'grp',50,8),(80,'grp',55,8),(80,'grp',58,8),(80,'grp',59,8),(80,'grp',60,8),(80,'grp',63,8),(80,'grp',65,8),(80,'grp',66,8),(80,'grp',67,8),(80,'grp',68,8),(80,'grp',71,8),(80,'grp',73,8),(80,'grp',74,8),(80,'grp',75,8),(80,'grp',76,8),(80,'grp',78,8),(80,'grp',81,8),(80,'grp',82,8),(80,'grp',90,8),(80,'grp',95,8),(80,'grp',102,8),(80,'grp',106,8),(80,'grp',107,8),(80,'grp',108,8),(80,'grp',111,8),(80,'grp',116,8),(80,'grp',119,8),(80,'grp',126,8),(80,'grp',127,8),(80,'grpr',1,8),(80,'grpr',2,8),(80,'grpr',4,8),(80,'grpr',6,8),(80,'grpr',58,8),(80,'htlm',1,8),(80,'htlm',2,8),(80,'htlm',3,8),(80,'htlm',4,8),(80,'htlm',6,8),(80,'htlm',55,8),(80,'htlm',58,8),(80,'htlm',95,8),(80,'iass',1,8),(80,'iass',2,8),(80,'iass',3,8),(80,'iass',4,8),(80,'iass',6,8),(80,'iass',55,8),(80,'iass',58,8),(80,'iass',95,8),(80,'iass',109,8),(80,'itgr',1,8),(80,'itgr',2,8),(80,'itgr',3,8),(80,'itgr',4,8),(80,'itgr',6,8),(80,'itgr',58,8),(80,'lm',1,8),(80,'lm',2,8),(80,'lm',3,8),(80,'lm',4,8),(80,'lm',6,8),(80,'lm',55,8),(80,'lm',58,8),(80,'lm',95,8),(80,'lso',1,8),(80,'lso',2,8),(80,'lso',3,8),(80,'lso',4,8),(80,'lso',6,8),(80,'lso',20,8),(80,'lso',21,8),(80,'lso',24,8),(80,'lso',25,8),(80,'lso',27,8),(80,'lso',32,8),(80,'lso',42,8),(80,'lso',55,8),(80,'lso',58,8),(80,'lso',95,8),(80,'lso',102,8),(80,'lso',108,8),(80,'lso',116,8),(80,'lso',120,8),(80,'lso',121,8),(80,'lti',1,8),(80,'lti',2,8),(80,'lti',3,8),(80,'lti',4,8),(80,'lti',6,8),(80,'lti',55,8),(80,'lti',58,8),(80,'lti',95,8),(80,'lti',125,8),(80,'mcst',1,8),(80,'mcst',2,8),(80,'mcst',3,8),(80,'mcst',4,8),(80,'mcst',6,8),(80,'mcst',55,8),(80,'mcst',58,8),(80,'mcst',95,8),(80,'mep',1,8),(80,'mep',2,8),(80,'mep',3,8),(80,'mep',4,8),(80,'mep',6,8),(80,'mep',58,8),(80,'poll',1,8),(80,'poll',3,8),(80,'poll',4,8),(80,'poll',6,8),(80,'poll',58,8),(80,'prtt',1,8),(80,'prtt',2,8),(80,'prtt',3,8),(80,'prtt',4,8),(80,'prtt',6,8),(80,'prtt',58,8),(80,'qpl',1,8),(80,'qpl',2,8),(80,'qpl',3,8),(80,'qpl',4,8),(80,'qpl',6,8),(80,'qpl',58,8),(80,'sahs',1,8),(80,'sahs',2,8),(80,'sahs',3,8),(80,'sahs',4,8),(80,'sahs',6,8),(80,'sahs',55,8),(80,'sahs',58,8),(80,'sahs',95,8),(80,'sess',1,8),(80,'sess',2,8),(80,'sess',3,8),(80,'sess',4,8),(80,'sess',6,8),(80,'sess',55,8),(80,'sess',58,8),(80,'sess',95,8),(80,'sess',102,8),(80,'sess',117,8),(80,'sess',118,8),(80,'spl',1,8),(80,'spl',2,8),(80,'spl',3,8),(80,'spl',4,8),(80,'spl',6,8),(80,'spl',58,8),(80,'svy',1,8),(80,'svy',2,8),(80,'svy',3,8),(80,'svy',4,8),(80,'svy',6,8),(80,'svy',45,8),(80,'svy',55,8),(80,'svy',58,8),(80,'svy',95,8),(80,'svy',122,8),(80,'tst',1,8),(80,'tst',2,8),(80,'tst',3,8),(80,'tst',4,8),(80,'tst',6,8),(80,'tst',55,8),(80,'tst',56,8),(80,'tst',58,8),(80,'tst',95,8),(80,'tst',115,8),(80,'webr',1,8),(80,'webr',2,8),(80,'webr',3,8),(80,'webr',4,8),(80,'webr',6,8),(80,'webr',58,8),(80,'wiki',1,8),(80,'wiki',2,8),(80,'wiki',3,8),(80,'wiki',4,8),(80,'wiki',6,8),(80,'wiki',58,8),(80,'wiki',64,8),(80,'wiki',94,8),(80,'wiki',97,8),(80,'wiki',98,8),(80,'wiki',99,8),(80,'wiki',100,8),(80,'wiki',112,8),(80,'wiki',130,8),(81,'bibl',2,8),(81,'bibl',3,8),(81,'blog',2,8),(81,'blog',3,8),(81,'book',2,8),(81,'book',3,8),(81,'catr',2,8),(81,'chtr',2,8),(81,'chtr',3,8),(81,'cmix',2,8),(81,'cmix',3,8),(81,'copa',2,8),(81,'copa',3,8),(81,'crsr',2,8),(81,'dcl',2,8),(81,'dcl',3,8),(81,'exc',2,8),(81,'exc',3,8),(81,'feed',3,8),(81,'file',2,8),(81,'file',3,8),(81,'fold',2,8),(81,'fold',3,8),(81,'frm',2,8),(81,'frm',3,8),(81,'frm',9,8),(81,'frm',62,8),(81,'glo',2,8),(81,'glo',3,8),(81,'grp',2,8),(81,'grp',3,8),(81,'grp',7,8),(81,'grp',8,8),(81,'grpr',2,8),(81,'htlm',2,8),(81,'htlm',3,8),(81,'iass',2,8),(81,'iass',3,8),(81,'itgr',2,8),(81,'itgr',3,8),(81,'lm',2,8),(81,'lm',3,8),(81,'lso',2,8),(81,'lso',3,8),(81,'lso',120,8),(81,'lti',2,8),(81,'lti',3,8),(81,'mcst',2,8),(81,'mcst',3,8),(81,'poll',3,8),(81,'prtt',2,8),(81,'prtt',3,8),(81,'sahs',2,8),(81,'sahs',3,8),(81,'sess',2,8),(81,'sess',3,8),(81,'svy',2,8),(81,'svy',3,8),(81,'tst',2,8),(81,'tst',3,8),(81,'webr',2,8),(81,'webr',3,8),(81,'wiki',2,8),(81,'wiki',3,8),(81,'wiki',64,8),(81,'wiki',130,8),(83,'grp',2,8),(83,'grp',7,8),(110,'bibl',1,8),(110,'bibl',2,8),(110,'bibl',3,8),(110,'bibl',4,8),(110,'bibl',6,8),(110,'bibl',58,8),(110,'blog',1,8),(110,'blog',2,8),(110,'blog',3,8),(110,'blog',4,8),(110,'blog',6,8),(110,'blog',58,8),(110,'blog',79,8),(110,'blog',96,8),(110,'book',1,8),(110,'book',2,8),(110,'book',3,8),(110,'book',4,8),(110,'book',6,8),(110,'book',58,8),(110,'catr',1,8),(110,'catr',2,8),(110,'catr',4,8),(110,'catr',6,8),(110,'catr',58,8),(110,'chtr',1,8),(110,'chtr',2,8),(110,'chtr',3,8),(110,'chtr',4,8),(110,'chtr',6,8),(110,'chtr',52,8),(110,'chtr',58,8),(110,'cmix',1,8),(110,'cmix',2,8),(110,'cmix',3,8),(110,'cmix',4,8),(110,'cmix',6,8),(110,'cmix',55,8),(110,'cmix',58,8),(110,'cmix',95,8),(110,'cmix',125,8),(110,'copa',1,8),(110,'copa',2,8),(110,'copa',3,8),(110,'copa',4,8),(110,'copa',6,8),(110,'copa',55,8),(110,'copa',58,8),(110,'copa',95,8),(110,'crs',1,8),(110,'crs',2,8),(110,'crs',3,8),(110,'crs',4,8),(110,'crs',6,8),(110,'crs',7,8),(110,'crs',8,8),(110,'crs',17,8),(110,'crs',18,8),(110,'crs',20,8),(110,'crs',21,8),(110,'crs',22,8),(110,'crs',24,8),(110,'crs',25,8),(110,'crs',26,8),(110,'crs',27,8),(110,'crs',28,8),(110,'crs',31,8),(110,'crs',32,8),(110,'crs',42,8),(110,'crs',43,8),(110,'crs',50,8),(110,'crs',55,8),(110,'crs',58,8),(110,'crs',59,8),(110,'crs',60,8),(110,'crs',63,8),(110,'crs',65,8),(110,'crs',66,8),(110,'crs',67,8),(110,'crs',68,8),(110,'crs',71,8),(110,'crs',73,8),(110,'crs',74,8),(110,'crs',75,8),(110,'crs',76,8),(110,'crs',78,8),(110,'crs',81,8),(110,'crs',82,8),(110,'crs',90,8),(110,'crs',95,8),(110,'crs',102,8),(110,'crs',106,8),(110,'crs',107,8),(110,'crs',108,8),(110,'crs',111,8),(110,'crs',116,8),(110,'crs',119,8),(110,'crs',126,8),(110,'crs',127,8),(110,'crsr',1,8),(110,'crsr',2,8),(110,'crsr',4,8),(110,'crsr',6,8),(110,'crsr',55,8),(110,'crsr',58,8),(110,'crsr',95,8),(110,'dcl',1,8),(110,'dcl',2,8),(110,'dcl',3,8),(110,'dcl',4,8),(110,'dcl',6,8),(110,'dcl',58,8),(110,'dcl',64,8),(110,'dcl',77,8),(110,'exc',1,8),(110,'exc',2,8),(110,'exc',3,8),(110,'exc',4,8),(110,'exc',6,8),(110,'exc',55,8),(110,'exc',58,8),(110,'exc',95,8),(110,'exc',114,8),(110,'feed',1,8),(110,'feed',3,8),(110,'feed',4,8),(110,'feed',6,8),(110,'feed',58,8),(110,'file',1,8),(110,'file',2,8),(110,'file',3,8),(110,'file',4,8),(110,'file',6,8),(110,'file',55,8),(110,'file',58,8),(110,'file',95,8),(110,'file',131,8),(110,'fold',1,8),(110,'fold',2,8),(110,'fold',3,8),(110,'fold',4,8),(110,'fold',6,8),(110,'fold',17,8),(110,'fold',18,8),(110,'fold',20,8),(110,'fold',21,8),(110,'fold',22,8),(110,'fold',24,8),(110,'fold',25,8),(110,'fold',26,8),(110,'fold',27,8),(110,'fold',28,8),(110,'fold',31,8),(110,'fold',32,8),(110,'fold',42,8),(110,'fold',43,8),(110,'fold',50,8),(110,'fold',55,8),(110,'fold',58,8),(110,'fold',60,8),(110,'fold',63,8),(110,'fold',65,8),(110,'fold',71,8),(110,'fold',73,8),(110,'fold',74,8),(110,'fold',75,8),(110,'fold',76,8),(110,'fold',78,8),(110,'fold',81,8),(110,'fold',82,8),(110,'fold',90,8),(110,'fold',95,8),(110,'fold',106,8),(110,'fold',108,8),(110,'fold',116,8),(110,'fold',119,8),(110,'fold',126,8),(110,'fold',127,8),(110,'frm',1,8),(110,'frm',2,8),(110,'frm',3,8),(110,'frm',4,8),(110,'frm',6,8),(110,'frm',9,8),(110,'frm',10,8),(110,'frm',55,8),(110,'frm',58,8),(110,'frm',62,8),(110,'frm',95,8),(110,'glo',1,8),(110,'glo',2,8),(110,'glo',3,8),(110,'glo',4,8),(110,'glo',6,8),(110,'glo',58,8),(110,'glo',64,8),(110,'grp',1,8),(110,'grp',2,8),(110,'grp',3,8),(110,'grp',4,8),(110,'grp',6,8),(110,'grp',7,8),(110,'grp',8,8),(110,'grp',17,8),(110,'grp',18,8),(110,'grp',20,8),(110,'grp',21,8),(110,'grp',22,8),(110,'grp',24,8),(110,'grp',25,8),(110,'grp',26,8),(110,'grp',27,8),(110,'grp',28,8),(110,'grp',31,8),(110,'grp',32,8),(110,'grp',42,8),(110,'grp',43,8),(110,'grp',50,8),(110,'grp',55,8),(110,'grp',58,8),(110,'grp',59,8),(110,'grp',60,8),(110,'grp',63,8),(110,'grp',65,8),(110,'grp',66,8),(110,'grp',67,8),(110,'grp',68,8),(110,'grp',71,8),(110,'grp',73,8),(110,'grp',74,8),(110,'grp',75,8),(110,'grp',76,8),(110,'grp',78,8),(110,'grp',81,8),(110,'grp',82,8),(110,'grp',90,8),(110,'grp',95,8),(110,'grp',102,8),(110,'grp',106,8),(110,'grp',107,8),(110,'grp',108,8),(110,'grp',111,8),(110,'grp',116,8),(110,'grp',119,8),(110,'grp',126,8),(110,'grp',127,8),(110,'grpr',1,8),(110,'grpr',2,8),(110,'grpr',4,8),(110,'grpr',6,8),(110,'grpr',58,8),(110,'htlm',1,8),(110,'htlm',2,8),(110,'htlm',3,8),(110,'htlm',4,8),(110,'htlm',6,8),(110,'htlm',55,8),(110,'htlm',58,8),(110,'htlm',95,8),(110,'iass',1,8),(110,'iass',2,8),(110,'iass',3,8),(110,'iass',4,8),(110,'iass',6,8),(110,'iass',55,8),(110,'iass',58,8),(110,'iass',95,8),(110,'iass',109,8),(110,'itgr',1,8),(110,'itgr',2,8),(110,'itgr',3,8),(110,'itgr',4,8),(110,'itgr',6,8),(110,'itgr',58,8),(110,'lm',1,8),(110,'lm',2,8),(110,'lm',3,8),(110,'lm',4,8),(110,'lm',6,8),(110,'lm',55,8),(110,'lm',58,8),(110,'lm',95,8),(110,'lso',1,8),(110,'lso',2,8),(110,'lso',3,8),(110,'lso',4,8),(110,'lso',6,8),(110,'lso',20,8),(110,'lso',21,8),(110,'lso',24,8),(110,'lso',25,8),(110,'lso',27,8),(110,'lso',32,8),(110,'lso',42,8),(110,'lso',55,8),(110,'lso',58,8),(110,'lso',95,8),(110,'lso',102,8),(110,'lso',108,8),(110,'lso',116,8),(110,'lso',120,8),(110,'lso',121,8),(110,'lti',1,8),(110,'lti',2,8),(110,'lti',3,8),(110,'lti',4,8),(110,'lti',6,8),(110,'lti',55,8),(110,'lti',58,8),(110,'lti',95,8),(110,'lti',125,8),(110,'mcst',1,8),(110,'mcst',2,8),(110,'mcst',3,8),(110,'mcst',4,8),(110,'mcst',6,8),(110,'mcst',55,8),(110,'mcst',58,8),(110,'mcst',95,8),(110,'mep',1,8),(110,'mep',2,8),(110,'mep',3,8),(110,'mep',4,8),(110,'mep',6,8),(110,'mep',58,8),(110,'poll',1,8),(110,'poll',3,8),(110,'poll',4,8),(110,'poll',6,8),(110,'poll',58,8),(110,'prtt',1,8),(110,'prtt',2,8),(110,'prtt',3,8),(110,'prtt',4,8),(110,'prtt',6,8),(110,'prtt',58,8),(110,'qpl',1,8),(110,'qpl',2,8),(110,'qpl',3,8),(110,'qpl',4,8),(110,'qpl',6,8),(110,'qpl',58,8),(110,'sahs',1,8),(110,'sahs',2,8),(110,'sahs',3,8),(110,'sahs',4,8),(110,'sahs',6,8),(110,'sahs',55,8),(110,'sahs',58,8),(110,'sahs',95,8),(110,'sess',1,8),(110,'sess',2,8),(110,'sess',3,8),(110,'sess',4,8),(110,'sess',6,8),(110,'sess',55,8),(110,'sess',58,8),(110,'sess',95,8),(110,'sess',102,8),(110,'sess',117,8),(110,'sess',118,8),(110,'spl',1,8),(110,'spl',2,8),(110,'spl',3,8),(110,'spl',4,8),(110,'spl',6,8),(110,'spl',58,8),(110,'svy',1,8),(110,'svy',2,8),(110,'svy',3,8),(110,'svy',4,8),(110,'svy',6,8),(110,'svy',45,8),(110,'svy',55,8),(110,'svy',58,8),(110,'svy',95,8),(110,'svy',122,8),(110,'tst',1,8),(110,'tst',2,8),(110,'tst',3,8),(110,'tst',4,8),(110,'tst',6,8),(110,'tst',55,8),(110,'tst',56,8),(110,'tst',58,8),(110,'tst',95,8),(110,'tst',115,8),(110,'webr',1,8),(110,'webr',2,8),(110,'webr',3,8),(110,'webr',4,8),(110,'webr',6,8),(110,'webr',58,8),(110,'wiki',1,8),(110,'wiki',2,8),(110,'wiki',3,8),(110,'wiki',4,8),(110,'wiki',6,8),(110,'wiki',58,8),(110,'wiki',64,8),(110,'wiki',94,8),(110,'wiki',97,8),(110,'wiki',98,8),(110,'wiki',99,8),(110,'wiki',100,8),(110,'wiki',112,8),(110,'wiki',130,8),(111,'bibl',2,8),(111,'bibl',3,8),(111,'bibl',4,8),(111,'bibl',58,8),(111,'blog',2,8),(111,'blog',3,8),(111,'blog',4,8),(111,'blog',58,8),(111,'blog',79,8),(111,'book',2,8),(111,'book',3,8),(111,'book',4,8),(111,'book',58,8),(111,'catr',2,8),(111,'catr',4,8),(111,'catr',58,8),(111,'chtr',2,8),(111,'chtr',3,8),(111,'chtr',4,8),(111,'chtr',52,8),(111,'chtr',58,8),(111,'cmix',2,8),(111,'cmix',3,8),(111,'cmix',4,8),(111,'cmix',58,8),(111,'copa',2,8),(111,'copa',3,8),(111,'copa',4,8),(111,'copa',58,8),(111,'crs',2,8),(111,'crs',3,8),(111,'crs',4,8),(111,'crs',7,8),(111,'crs',8,8),(111,'crs',17,8),(111,'crs',18,8),(111,'crs',20,8),(111,'crs',21,8),(111,'crs',22,8),(111,'crs',24,8),(111,'crs',25,8),(111,'crs',26,8),(111,'crs',27,8),(111,'crs',28,8),(111,'crs',31,8),(111,'crs',32,8),(111,'crs',42,8),(111,'crs',43,8),(111,'crs',50,8),(111,'crs',55,8),(111,'crs',58,8),(111,'crs',59,8),(111,'crs',60,8),(111,'crs',63,8),(111,'crs',65,8),(111,'crs',66,8),(111,'crs',67,8),(111,'crs',68,8),(111,'crs',71,8),(111,'crs',73,8),(111,'crs',74,8),(111,'crs',75,8),(111,'crs',76,8),(111,'crs',78,8),(111,'crs',81,8),(111,'crs',82,8),(111,'crs',90,8),(111,'crs',95,8),(111,'crs',102,8),(111,'crs',106,8),(111,'crs',107,8),(111,'crs',108,8),(111,'crs',111,8),(111,'crs',116,8),(111,'crs',119,8),(111,'crs',126,8),(111,'crs',127,8),(111,'crsr',2,8),(111,'crsr',4,8),(111,'crsr',55,8),(111,'crsr',58,8),(111,'crsr',95,8),(111,'dcl',2,8),(111,'dcl',3,8),(111,'dcl',4,8),(111,'dcl',58,8),(111,'dcl',64,8),(111,'dcl',77,8),(111,'exc',2,8),(111,'exc',3,8),(111,'exc',4,8),(111,'exc',55,8),(111,'exc',58,8),(111,'exc',95,8),(111,'exc',114,8),(111,'feed',3,8),(111,'feed',4,8),(111,'feed',58,8),(111,'file',2,8),(111,'file',3,8),(111,'file',4,8),(111,'file',55,8),(111,'file',58,8),(111,'file',95,8),(111,'file',131,8),(111,'fold',2,8),(111,'fold',3,8),(111,'fold',4,8),(111,'fold',17,8),(111,'fold',18,8),(111,'fold',20,8),(111,'fold',21,8),(111,'fold',22,8),(111,'fold',24,8),(111,'fold',25,8),(111,'fold',26,8),(111,'fold',27,8),(111,'fold',28,8),(111,'fold',31,8),(111,'fold',32,8),(111,'fold',42,8),(111,'fold',43,8),(111,'fold',50,8),(111,'fold',55,8),(111,'fold',58,8),(111,'fold',60,8),(111,'fold',63,8),(111,'fold',65,8),(111,'fold',71,8),(111,'fold',73,8),(111,'fold',74,8),(111,'fold',75,8),(111,'fold',76,8),(111,'fold',78,8),(111,'fold',81,8),(111,'fold',82,8),(111,'fold',90,8),(111,'fold',95,8),(111,'fold',106,8),(111,'fold',108,8),(111,'fold',116,8),(111,'fold',119,8),(111,'fold',126,8),(111,'fold',127,8),(111,'frm',2,8),(111,'frm',3,8),(111,'frm',4,8),(111,'frm',9,8),(111,'frm',10,8),(111,'frm',55,8),(111,'frm',58,8),(111,'frm',62,8),(111,'frm',95,8),(111,'glo',2,8),(111,'glo',3,8),(111,'glo',4,8),(111,'glo',58,8),(111,'glo',64,8),(111,'grp',2,8),(111,'grp',3,8),(111,'grp',7,8),(111,'grp',8,8),(111,'grpr',2,8),(111,'grpr',4,8),(111,'grpr',58,8),(111,'htlm',2,8),(111,'htlm',3,8),(111,'htlm',55,8),(111,'htlm',95,8),(111,'iass',2,8),(111,'iass',3,8),(111,'iass',4,8),(111,'iass',55,8),(111,'iass',58,8),(111,'iass',95,8),(111,'iass',109,8),(111,'itgr',2,8),(111,'itgr',3,8),(111,'itgr',4,8),(111,'itgr',58,8),(111,'lm',2,8),(111,'lm',3,8),(111,'lm',55,8),(111,'lm',95,8),(111,'lso',2,8),(111,'lso',3,8),(111,'lso',4,8),(111,'lso',20,8),(111,'lso',21,8),(111,'lso',24,8),(111,'lso',25,8),(111,'lso',27,8),(111,'lso',32,8),(111,'lso',42,8),(111,'lso',55,8),(111,'lso',58,8),(111,'lso',102,8),(111,'lso',108,8),(111,'lso',116,8),(111,'lso',120,8),(111,'lso',121,8),(111,'lti',2,8),(111,'lti',3,8),(111,'lti',4,8),(111,'lti',58,8),(111,'mcst',2,8),(111,'mcst',3,8),(111,'mcst',4,8),(111,'mcst',55,8),(111,'mcst',58,8),(111,'mcst',95,8),(111,'mep',2,8),(111,'mep',3,8),(111,'mep',4,8),(111,'mep',58,8),(111,'poll',3,8),(111,'poll',4,8),(111,'poll',58,8),(111,'prtt',2,8),(111,'prtt',3,8),(111,'qpl',2,8),(111,'qpl',3,8),(111,'qpl',4,8),(111,'sahs',2,8),(111,'sahs',3,8),(111,'sahs',55,8),(111,'sahs',95,8),(111,'sess',2,8),(111,'sess',3,8),(111,'sess',4,8),(111,'sess',6,8),(111,'sess',55,8),(111,'sess',58,8),(111,'sess',95,8),(111,'sess',102,8),(111,'sess',117,8),(111,'sess',118,8),(111,'spl',2,8),(111,'spl',3,8),(111,'spl',4,8),(111,'svy',2,8),(111,'svy',3,8),(111,'svy',4,8),(111,'svy',45,8),(111,'svy',55,8),(111,'svy',58,8),(111,'svy',95,8),(111,'svy',122,8),(111,'tst',2,8),(111,'tst',3,8),(111,'tst',4,8),(111,'tst',55,8),(111,'tst',58,8),(111,'tst',95,8),(111,'tst',115,8),(111,'webr',2,8),(111,'webr',3,8),(111,'webr',4,8),(111,'webr',58,8),(111,'wiki',2,8),(111,'wiki',3,8),(111,'wiki',4,8),(111,'wiki',58,8),(111,'wiki',64,8),(111,'wiki',94,8),(111,'wiki',97,8),(111,'wiki',98,8),(111,'wiki',99,8),(111,'wiki',100,8),(111,'wiki',112,8),(111,'wiki',130,8),(112,'bibl',2,8),(112,'bibl',3,8),(112,'blog',2,8),(112,'blog',3,8),(112,'book',2,8),(112,'book',3,8),(112,'catr',2,8),(112,'chtr',2,8),(112,'chtr',3,8),(112,'cmix',2,8),(112,'cmix',3,8),(112,'copa',2,8),(112,'copa',3,8),(112,'crs',2,8),(112,'crs',3,8),(112,'crs',8,8),(112,'crsr',2,8),(112,'dcl',2,8),(112,'dcl',3,8),(112,'exc',2,8),(112,'exc',3,8),(112,'feed',3,8),(112,'file',2,8),(112,'file',3,8),(112,'fold',2,8),(112,'fold',3,8),(112,'frm',2,8),(112,'frm',3,8),(112,'frm',9,8),(112,'frm',62,8),(112,'glo',2,8),(112,'glo',3,8),(112,'grp',2,8),(112,'grp',3,8),(112,'grp',7,8),(112,'grp',8,8),(112,'grpr',2,8),(112,'htlm',2,8),(112,'htlm',3,8),(112,'iass',2,8),(112,'iass',3,8),(112,'itgr',2,8),(112,'itgr',3,8),(112,'lm',2,8),(112,'lm',3,8),(112,'lso',2,8),(112,'lso',3,8),(112,'lso',120,8),(112,'lti',2,8),(112,'lti',3,8),(112,'mcst',2,8),(112,'mcst',3,8),(112,'poll',3,8),(112,'prtt',2,8),(112,'prtt',3,8),(112,'sahs',2,8),(112,'sahs',3,8),(112,'sess',2,8),(112,'sess',3,8),(112,'svy',2,8),(112,'svy',3,8),(112,'tst',2,8),(112,'tst',3,8),(112,'webr',2,8),(112,'webr',3,8),(112,'wiki',2,8),(112,'wiki',3,8),(112,'wiki',64,8),(112,'wiki',130,8),(125,'bibl',1,8),(125,'bibl',2,8),(125,'bibl',3,8),(125,'bibl',6,8),(125,'bibl',58,8),(125,'blog',1,8),(125,'blog',2,8),(125,'blog',3,8),(125,'blog',6,8),(125,'book',1,8),(125,'book',2,8),(125,'book',3,8),(125,'book',6,8),(125,'cat',1,8),(125,'cat',2,8),(125,'cat',3,8),(125,'cat',4,8),(125,'cat',6,8),(125,'cat',16,8),(125,'cat',17,8),(125,'cat',18,8),(125,'cat',19,8),(125,'cat',20,8),(125,'cat',21,8),(125,'cat',22,8),(125,'cat',24,8),(125,'cat',25,8),(125,'cat',27,8),(125,'cat',28,8),(125,'cat',31,8),(125,'cat',32,8),(125,'cat',42,8),(125,'cat',43,8),(125,'cat',47,8),(125,'cat',48,8),(125,'cat',50,8),(125,'cat',58,8),(125,'cat',59,8),(125,'cat',60,8),(125,'cat',65,8),(125,'cat',67,8),(125,'cat',68,8),(125,'cat',71,8),(125,'cat',73,8),(125,'cat',74,8),(125,'cat',75,8),(125,'cat',76,8),(125,'cat',78,8),(125,'cat',81,8),(125,'cat',82,8),(125,'cat',90,8),(125,'cat',101,8),(125,'cat',106,8),(125,'cat',108,8),(125,'cat',116,8),(125,'cat',119,8),(125,'cat',126,8),(125,'cat',127,8),(125,'catr',1,8),(125,'catr',2,8),(125,'catr',6,8),(125,'catr',58,8),(125,'chtr',1,8),(125,'chtr',2,8),(125,'chtr',6,8),(125,'cld',1,8),(125,'cld',2,8),(125,'cld',3,8),(125,'cld',6,8),(125,'cmix',1,8),(125,'cmix',2,8),(125,'cmix',6,8),(125,'copa',1,8),(125,'copa',2,8),(125,'copa',6,8),(125,'crs',1,8),(125,'crs',2,8),(125,'crs',3,8),(125,'crs',6,8),(125,'crs',55,8),(125,'crs',95,8),(125,'crs',102,8),(125,'crs',111,8),(125,'crsr',1,8),(125,'crsr',2,8),(125,'crsr',6,8),(125,'dcl',1,8),(125,'dcl',2,8),(125,'dcl',3,8),(125,'dcl',6,8),(125,'exc',1,8),(125,'exc',2,8),(125,'exc',6,8),(125,'exc',55,8),(125,'exc',95,8),(125,'feed',1,8),(125,'feed',3,8),(125,'feed',6,8),(125,'file',1,8),(125,'file',2,8),(125,'file',6,8),(125,'fold',1,8),(125,'fold',2,8),(125,'fold',3,8),(125,'fold',6,8),(125,'fold',55,8),(125,'fold',95,8),(125,'frm',1,8),(125,'frm',2,8),(125,'frm',6,8),(125,'glo',1,8),(125,'glo',2,8),(125,'glo',6,8),(125,'grp',1,8),(125,'grp',2,8),(125,'grp',6,8),(125,'grp',55,8),(125,'grp',95,8),(125,'grpr',1,8),(125,'grpr',2,8),(125,'grpr',6,8),(125,'htlm',1,8),(125,'htlm',2,8),(125,'htlm',3,8),(125,'htlm',6,8),(125,'htlm',55,8),(125,'htlm',95,8),(125,'iass',1,8),(125,'iass',2,8),(125,'iass',6,8),(125,'itgr',1,8),(125,'itgr',2,8),(125,'itgr',3,8),(125,'itgr',6,8),(125,'lm',1,8),(125,'lm',2,8),(125,'lm',3,8),(125,'lm',6,8),(125,'lm',55,8),(125,'lm',95,8),(125,'lso',1,8),(125,'lso',2,8),(125,'lso',6,8),(125,'lti',1,8),(125,'lti',2,8),(125,'lti',6,8),(125,'mcst',1,8),(125,'mcst',2,8),(125,'mcst',3,8),(125,'mcst',6,8),(125,'mep',1,8),(125,'mep',2,8),(125,'mep',3,8),(125,'mep',6,8),(125,'poll',1,8),(125,'poll',3,8),(125,'poll',6,8),(125,'prg',1,8),(125,'prg',2,8),(125,'prg',3,8),(125,'prg',101,8),(125,'prtt',1,8),(125,'prtt',2,8),(125,'prtt',3,8),(125,'prtt',6,8),(125,'qpl',1,8),(125,'qpl',2,8),(125,'qpl',3,8),(125,'qpl',6,8),(125,'root',2,8),(125,'root',3,8),(125,'sahs',1,8),(125,'sahs',2,8),(125,'sahs',3,8),(125,'sahs',6,8),(125,'sahs',55,8),(125,'sahs',95,8),(125,'sess',1,8),(125,'sess',2,8),(125,'sess',3,8),(125,'spl',1,8),(125,'spl',2,8),(125,'spl',3,8),(125,'spl',6,8),(125,'svy',1,8),(125,'svy',2,8),(125,'svy',6,8),(125,'tst',1,8),(125,'tst',2,8),(125,'tst',6,8),(125,'tst',55,8),(125,'tst',95,8),(125,'webr',1,8),(125,'webr',2,8),(125,'webr',3,8),(125,'webr',6,8),(125,'wiki',1,8),(125,'wiki',2,8),(125,'wiki',3,8),(125,'wiki',6,8),(131,'crs',2,8),(131,'crs',7,8),(148,'frm',1,8),(148,'frm',2,8),(148,'frm',3,8),(148,'frm',4,8),(148,'frm',6,8),(148,'frm',9,8),(148,'frm',10,8),(148,'frm',55,8),(148,'frm',58,8),(148,'frm',62,8),(148,'frm',95,8),(188,'chtr',2,8),(188,'chtr',3,8),(188,'chtr',4,8),(188,'chtr',52,8),(202,'blog',2,8),(202,'blog',3,8),(202,'blog',79,8),(222,'orgu',2,8),(222,'orgu',3,8),(222,'orgu',92,8),(231,'blog',2,8),(231,'blog',3,8),(231,'blog',4,8),(231,'blog',79,8),(231,'blog',96,8),(267,'iass',2,8),(267,'iass',3,8),(268,'sess',2,8),(268,'sess',3,8),(277,'lso',55,8),(277,'lso',102,8),(277,'lso',120,8),(277,'lso',121,8),(278,'copa',2,8),(278,'copa',3,8),(278,'copa',55,8),(278,'copa',95,8),(278,'exc',2,8),(278,'exc',3,8),(278,'exc',55,8),(278,'exc',95,8),(278,'exc',114,8),(278,'file',2,8),(278,'file',3,8),(278,'file',55,8),(278,'file',95,8),(278,'htlm',2,8),(278,'htlm',3,8),(278,'htlm',55,8),(278,'htlm',95,8),(278,'iass',2,8),(278,'iass',3,8),(278,'iass',55,8),(278,'iass',95,8),(278,'iass',102,8),(278,'iass',109,8),(278,'lm',2,8),(278,'lm',3,8),(278,'lm',55,8),(278,'lm',95,8),(278,'lso',1,8),(278,'lso',2,8),(278,'lso',3,8),(278,'lso',4,8),(278,'lso',6,8),(278,'lso',20,8),(278,'lso',21,8),(278,'lso',24,8),(278,'lso',25,8),(278,'lso',27,8),(278,'lso',32,8),(278,'lso',42,8),(278,'lso',55,8),(278,'lso',58,8),(278,'lso',99,8),(278,'lso',102,8),(278,'lso',108,8),(278,'lso',116,8),(278,'lso',120,8),(278,'lso',121,8),(278,'lso',277,8),(278,'sahs',2,8),(278,'sahs',3,8),(278,'sahs',55,8),(278,'sahs',95,8),(278,'svy',2,8),(278,'svy',3,8),(278,'svy',45,8),(278,'svy',55,8),(278,'svy',95,8),(278,'svy',122,8),(278,'tst',2,8),(278,'tst',3,8),(278,'tst',55,8),(278,'tst',56,8),(278,'tst',95,8),(278,'tst',115,8),(279,'copa',2,8),(279,'copa',3,8),(279,'exc',2,8),(279,'exc',3,8),(279,'file',2,8),(279,'file',3,8),(279,'htlm',2,8),(279,'htlm',3,8),(279,'lm',2,8),(279,'lm',3,8),(279,'lso',2,8),(279,'lso',3,8),(279,'lso',121,8),(279,'lso',277,8),(279,'sahs',2,8),(279,'sahs',3,8),(279,'svy',2,8),(279,'svy',3,8),(279,'tst',2,8),(279,'tst',3,8);

--
