CREATE TABLE `glo_flashcard_box` (
  `box_nr` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `glo_id` int(11) NOT NULL DEFAULT '0',
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`box_nr`,`user_id`,`glo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glo_flashcard_box`
--


--
-- Table structure for table `glo_flashcard_term`
--

CREATE TABLE `glo_flashcard_term` (
  `term_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `glo_id` int(11) NOT NULL DEFAULT '0',
  `last_access` datetime DEFAULT NULL,
  `box_nr` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`,`user_id`,`glo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glo_flashcard_term`
--


--
-- Table structure for table `glo_glossaries`
--

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

--
-- Dumping data for table `glo_glossaries`
--


--
-- Table structure for table `glo_term_reference`
--

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

--
-- Dumping data for table `glo_term_reference`
--


--
-- Table structure for table `glossary`
--

CREATE TABLE `glossary` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` char(1) DEFAULT 'n',
  `virtual` char(7) DEFAULT 'none',
  `public_html_file` varchar(50) DEFAULT NULL,
  `public_xml_file` varchar(50) DEFAULT NULL,
  `glo_menu_active` char(1) DEFAULT 'y',
  `downloads_active` char(1) DEFAULT 'n',
  `pres_mode` varchar(10) NOT NULL DEFAULT 'table',
  `snippet_length` int(11) NOT NULL DEFAULT '200',
  `show_tax` tinyint(4) NOT NULL DEFAULT '0',
  `flash_active` varchar(1) NOT NULL DEFAULT 'n',
  `flash_mode` varchar(10) NOT NULL DEFAULT 'term',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glossary`
--


--
-- Table structure for table `glossary_collection`
--

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

--
-- Dumping data for table `glossary_collection`
--


--
-- Table structure for table `glossary_definition`
--

CREATE TABLE `glossary_definition` (
  `id` int(11) NOT NULL DEFAULT '0',
  `term_id` int(11) NOT NULL DEFAULT '0',
  `short_text` varchar(4000) DEFAULT NULL,
  `nr` int(11) NOT NULL DEFAULT '0',
  `short_text_dirty` int(11) NOT NULL DEFAULT '0',
  `migration` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glossary_definition`
--


--
-- Table structure for table `glossary_definition_seq`
--

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

--
-- Dumping data for table `glossary_definition_seq`
--


--
-- Table structure for table `glossary_term`
--

CREATE TABLE `glossary_term` (
  `id` int(11) NOT NULL DEFAULT '0',
  `glo_id` int(11) NOT NULL DEFAULT '0',
  `term` varchar(200) DEFAULT NULL,
  `language` char(2) DEFAULT NULL,
  `import_id` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `short_text` varchar(4000) DEFAULT NULL,
  `short_text_dirty` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`glo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `glossary_term`
--


--
-- Table structure for table `glossary_term_seq`
--

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

--
-- Dumping data for table `glossary_term_seq`
--


--
-- Table structure for table `grp_settings`
--

CREATE TABLE `grp_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `information` varchar(4000) DEFAULT NULL,
  `grp_type` tinyint(4) NOT NULL DEFAULT '0',
  `registration_type` tinyint(4) NOT NULL DEFAULT '0',
  `registration_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `registration_unlimited` tinyint(4) NOT NULL DEFAULT '0',
  `registration_start` datetime DEFAULT NULL,
  `registration_end` datetime DEFAULT NULL,
  `registration_password` char(32) DEFAULT NULL,
  `registration_mem_limit` tinyint(4) NOT NULL DEFAULT '0',
  `registration_max_members` int(11) NOT NULL DEFAULT '0',
  `waiting_list` tinyint(4) NOT NULL DEFAULT '0',
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `location_zoom` int(11) NOT NULL DEFAULT '0',
  `enablemap` tinyint(4) NOT NULL DEFAULT '0',
  `reg_ac_enabled` tinyint(4) NOT NULL DEFAULT '0',
  `reg_ac` varchar(32) DEFAULT NULL,
  `view_mode` tinyint(4) NOT NULL DEFAULT '6',
  `mail_members_type` tinyint(4) DEFAULT '1',
  `registration_min_members` smallint(6) DEFAULT NULL,
  `leave_end` int(11) DEFAULT NULL,
  `auto_wait` tinyint(4) NOT NULL DEFAULT '0',
  `show_members` tinyint(4) NOT NULL DEFAULT '1',
  `grp_start` int(11) DEFAULT NULL,
  `grp_end` int(11) DEFAULT NULL,
  `period_start` datetime DEFAULT NULL,
  `period_end` datetime DEFAULT NULL,
  `period_time_indication` int(11) NOT NULL DEFAULT '0',
  `auto_notification` int(11) NOT NULL DEFAULT '1',
  `session_limit` tinyint(4) NOT NULL DEFAULT '0',
  `session_prev` bigint(20) NOT NULL DEFAULT '-1',
  `session_next` bigint(20) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `grp_settings`
--


--
-- Table structure for table `help_map`
--

CREATE TABLE `help_map` (
  `chap` int(11) NOT NULL DEFAULT '0',
  `component` varchar(10) NOT NULL DEFAULT '',
  `screen_id` varchar(100) NOT NULL DEFAULT '',
  `screen_sub_id` varchar(100) NOT NULL DEFAULT '',
  `perm` varchar(20) NOT NULL DEFAULT '',
  `module_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`component`,`screen_id`,`screen_sub_id`,`chap`,`perm`,`module_id`),
  KEY `sc_idx` (`screen_id`),
  KEY `ch_idx` (`chap`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `help_map`
--


--
-- Table structure for table `help_module`
--

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

--
-- Dumping data for table `help_module`
--


--
-- Table structure for table `help_module_seq`
--

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

--
-- Dumping data for table `help_module_seq`
--


--
-- Table structure for table `help_tooltip`
--

CREATE TABLE `help_tooltip` (
  `id` int(11) NOT NULL DEFAULT '0',
  `tt_text` varchar(4000) DEFAULT NULL,
  `tt_id` varchar(200) NOT NULL DEFAULT '',
  `comp` varchar(10) NOT NULL DEFAULT '',
  `lang` char(2) NOT NULL DEFAULT 'de',
  `module_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`tt_id`,`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `help_tooltip`
--


--
-- Table structure for table `help_tooltip_seq`
--

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

--
-- Dumping data for table `help_tooltip_seq`
--


--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(8) DEFAULT NULL,
  `action` varchar(20) DEFAULT NULL,
  `hdate` datetime DEFAULT NULL,
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `info_params` varchar(4000) DEFAULT NULL,
  `user_comment` longtext,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `history`
--


--
-- Table structure for table `history_seq`
--

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

--
-- Dumping data for table `history_seq`
--


--
-- Table structure for table `iass_info_settings`
--

CREATE TABLE `iass_info_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `contact` varchar(100) DEFAULT NULL,
  `responsibility` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `mails` text,
  `consultation_hours` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iass_info_settings`
--


--
-- Table structure for table `iass_members`
--

CREATE TABLE `iass_members` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `examiner_id` int(11) DEFAULT NULL,
  `record` text,
  `internal_note` text,
  `notify` tinyint(4) NOT NULL DEFAULT '0',
  `notification_ts` int(11) NOT NULL DEFAULT '-1',
  `learning_progress` tinyint(4) DEFAULT '0',
  `finalized` tinyint(4) NOT NULL DEFAULT '0',
  `place` varchar(255) DEFAULT NULL,
  `event_time` bigint(20) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `user_view_file` tinyint(4) DEFAULT NULL,
  `changer_id` int(11) DEFAULT NULL,
  `change_time` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iass_members`
--


--
-- Table structure for table `iass_settings`
--

CREATE TABLE `iass_settings` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `content` text,
  `record_template` text,
  `event_time_place_required` tinyint(4) NOT NULL DEFAULT '0',
  `file_required` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iass_settings`
--


--
-- Table structure for table `il_adn_dismiss`
--

CREATE TABLE `il_adn_dismiss` (
  `id` bigint(20) NOT NULL,
  `usr_id` bigint(20) DEFAULT NULL,
  `notification_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_adn_dismiss`
--


--
-- Table structure for table `il_adn_dismiss_seq`
--

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

--
-- Dumping data for table `il_adn_dismiss_seq`
--


--
-- Table structure for table `il_adn_notifications`
--

CREATE TABLE `il_adn_notifications` (
  `id` bigint(20) NOT NULL,
  `title` varchar(256) DEFAULT NULL,
  `body` longtext,
  `type` tinyint(4) DEFAULT NULL,
  `type_during_event` tinyint(4) DEFAULT NULL,
  `dismissable` tinyint(4) DEFAULT NULL,
  `permanent` tinyint(4) DEFAULT NULL,
  `allowed_users` varchar(256) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `last_update_by` bigint(20) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `limited_to_role_ids` varchar(256) DEFAULT NULL,
  `limit_to_roles` tinyint(4) DEFAULT NULL,
  `interruptive` tinyint(4) DEFAULT NULL,
  `link` varchar(256) DEFAULT NULL,
  `link_type` tinyint(4) DEFAULT NULL,
  `link_target` varchar(256) DEFAULT NULL,
  `event_start` bigint(20) DEFAULT '0',
  `event_end` bigint(20) DEFAULT '0',
  `display_start` bigint(20) DEFAULT '0',
  `display_end` bigint(20) DEFAULT '0',
  `create_date` bigint(20) DEFAULT '0',
  `last_update` bigint(20) DEFAULT '0',
  `has_language_limitation` tinyint(4) NOT NULL DEFAULT '0',
  `limited_to_languages` varchar(256) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_adn_notifications`
--


--
-- Table structure for table `il_adn_notifications_seq`
--

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

--
-- Dumping data for table `il_adn_notifications_seq`
--


--
-- Table structure for table `il_bibl_attribute`
--

CREATE TABLE `il_bibl_attribute` (
  `entry_id` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `value` varchar(4000) DEFAULT NULL,
  `id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_attribute`
--


--
-- Table structure for table `il_bibl_attribute_seq`
--

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

--
-- Dumping data for table `il_bibl_attribute_seq`
--


--
-- Table structure for table `il_bibl_data`
--

CREATE TABLE `il_bibl_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(256) DEFAULT NULL,
  `file_type` tinyint(4) NOT NULL DEFAULT '1',
  `rid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_data`
--


--
-- Table structure for table `il_bibl_entry`
--

CREATE TABLE `il_bibl_entry` (
  `data_id` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_entry`
--


--
-- Table structure for table `il_bibl_entry_seq`
--

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

--
-- Dumping data for table `il_bibl_entry_seq`
--


--
-- Table structure for table `il_bibl_field`
--

CREATE TABLE `il_bibl_field` (
  `id` int(11) NOT NULL,
  `identifier` varchar(50) NOT NULL,
  `data_type` tinyint(4) NOT NULL,
  `position` int(11) DEFAULT NULL,
  `is_standard_field` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_field`
--


--
-- Table structure for table `il_bibl_field_seq`
--

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

--
-- Dumping data for table `il_bibl_field_seq`
--


--
-- Table structure for table `il_bibl_filter`
--

CREATE TABLE `il_bibl_filter` (
  `id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `object_id` int(11) NOT NULL,
  `filter_type` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_filter`
--


--
-- Table structure for table `il_bibl_filter_seq`
--

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

--
-- Dumping data for table `il_bibl_filter_seq`
--


--
-- Table structure for table `il_bibl_overview_model`
--

CREATE TABLE `il_bibl_overview_model` (
  `ovm_id` int(11) NOT NULL DEFAULT '0',
  `literature_type` varchar(32) DEFAULT NULL,
  `pattern` varchar(512) DEFAULT NULL,
  `file_type_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ovm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_overview_model`
--

INSERT INTO `il_bibl_overview_model` VALUES (1,'default','[<strong>|bib_default_author|</strong> ][|bib_default_title|]: <Emph>[|bib_default_publisher| ][|bib_default_year| ][|bib_default_address|]</Emph>',2),(2,'default','[<strong>|ris_default_a1|</strong> ][<strong>|ris_default_au|</strong> ][|ris_default_t1|][ |ris_default_ti|]: <Emph>[|ris_default_pb| ][|ris_default_y1| ][|ris_default_py| ][|ris_default_cy|]</Emph>',1);

--
-- Table structure for table `il_bibl_settings`
--

CREATE TABLE `il_bibl_settings` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '-',
  `url` varchar(128) NOT NULL DEFAULT '-',
  `img` varchar(128) DEFAULT NULL,
  `show_in_list` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_settings`
--


--
-- Table structure for table `il_bibl_settings_seq`
--

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

--
-- Dumping data for table `il_bibl_settings_seq`
--


--
-- Table structure for table `il_bibl_translation`
--

CREATE TABLE `il_bibl_translation` (
  `id` int(11) NOT NULL,
  `field_id` bigint(20) NOT NULL,
  `language_key` varchar(2) NOT NULL,
  `translation` varchar(256) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bibl_translation`
--


--
-- Table structure for table `il_bibl_translation_seq`
--

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

--
-- Dumping data for table `il_bibl_translation_seq`
--


--
-- Table structure for table `il_block_setting`
--

CREATE TABLE `il_block_setting` (
  `type` varchar(20) NOT NULL DEFAULT ' ',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `block_id` int(11) NOT NULL DEFAULT '0',
  `setting` varchar(40) NOT NULL DEFAULT ' ',
  `value` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`type`,`user_id`,`block_id`,`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_block_setting`
--


--
-- Table structure for table `il_blog`
--

CREATE TABLE `il_blog` (
  `id` int(11) NOT NULL DEFAULT '0',
  `bg_color` char(6) DEFAULT NULL,
  `font_color` char(6) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `ppic` tinyint(4) DEFAULT NULL,
  `rss_active` tinyint(4) DEFAULT '0',
  `approval` tinyint(4) DEFAULT '0',
  `abs_shorten` tinyint(4) DEFAULT '0',
  `abs_shorten_len` smallint(6) DEFAULT '0',
  `abs_image` tinyint(4) DEFAULT '0',
  `abs_img_width` smallint(6) DEFAULT '0',
  `abs_img_height` smallint(6) DEFAULT '0',
  `keywords` tinyint(4) NOT NULL DEFAULT '1',
  `authors` tinyint(4) NOT NULL DEFAULT '1',
  `nav_mode` tinyint(4) NOT NULL DEFAULT '1',
  `nav_list_post` smallint(6) NOT NULL DEFAULT '10',
  `nav_list_mon` smallint(6) DEFAULT '0',
  `ov_post` smallint(6) DEFAULT '0',
  `nav_order` varchar(255) DEFAULT NULL,
  `nav_list_mon_with_post` int(11) DEFAULT '3',
  `act_est_reading_time` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_blog`
--


--
-- Table structure for table `il_blog_posting`
--

CREATE TABLE `il_blog_posting` (
  `id` int(11) NOT NULL DEFAULT '0',
  `blog_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(400) DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `author` int(11) NOT NULL DEFAULT '0',
  `approved` tinyint(4) DEFAULT '0',
  `last_withdrawn` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_blog_posting`
--


--
-- Table structure for table `il_blog_posting_seq`
--

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

--
-- Dumping data for table `il_blog_posting_seq`
--


--
-- Table structure for table `il_bt_bucket`
--

CREATE TABLE `il_bt_bucket` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `user_id` bigint(20) DEFAULT NULL,
  `root_task_id` bigint(20) DEFAULT NULL,
  `current_task_id` bigint(20) DEFAULT NULL,
  `state` smallint(6) DEFAULT NULL,
  `total_number_of_tasks` int(11) DEFAULT NULL,
  `percentage` smallint(6) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_heartbeat` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bt_bucket`
--


--
-- Table structure for table `il_bt_bucket_seq`
--

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

--
-- Dumping data for table `il_bt_bucket_seq`
--


--
-- Table structure for table `il_bt_task`
--

CREATE TABLE `il_bt_task` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `type` varchar(256) DEFAULT NULL,
  `class_path` varchar(256) DEFAULT NULL,
  `class_name` varchar(256) DEFAULT NULL,
  `bucket_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bt_task`
--


--
-- Table structure for table `il_bt_task_seq`
--

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

--
-- Dumping data for table `il_bt_task_seq`
--


--
-- Table structure for table `il_bt_value`
--

CREATE TABLE `il_bt_value` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `has_parent_task` tinyint(4) DEFAULT NULL,
  `parent_task_id` bigint(20) DEFAULT NULL,
  `hash` varchar(256) DEFAULT NULL,
  `type` varchar(256) DEFAULT NULL,
  `class_path` varchar(256) DEFAULT NULL,
  `class_name` varchar(256) DEFAULT NULL,
  `serialized` longtext,
  `bucket_id` bigint(20) DEFAULT NULL,
  `position` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`bucket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bt_value`
--


--
-- Table structure for table `il_bt_value_seq`
--

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

--
-- Dumping data for table `il_bt_value_seq`
--


--
-- Table structure for table `il_bt_value_to_task`
--

CREATE TABLE `il_bt_value_to_task` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `task_id` bigint(20) DEFAULT NULL,
  `value_id` bigint(20) DEFAULT NULL,
  `bucket_id` bigint(20) DEFAULT NULL,
  `position` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`task_id`),
  KEY `i2_idx` (`value_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_bt_value_to_task`
--


--
-- Table structure for table `il_bt_value_to_task_seq`
--

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

--
-- Dumping data for table `il_bt_value_to_task_seq`
--


--
-- Table structure for table `il_cert_cron_queue`
--

CREATE TABLE `il_cert_cron_queue` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `adapter_class` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `started_timestamp` int(11) NOT NULL DEFAULT '0',
  `template_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_cert_cron_queue`
--


--
-- Table structure for table `il_cert_cron_queue_seq`
--

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

--
-- Dumping data for table `il_cert_cron_queue_seq`
--


--
-- Table structure for table `il_cert_template`
--

CREATE TABLE `il_cert_template` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(255) NOT NULL DEFAULT '',
  `certificate_content` longtext NOT NULL,
  `certificate_hash` varchar(255) NOT NULL,
  `template_values` longtext NOT NULL,
  `background_image_path` varchar(255) DEFAULT NULL,
  `version` bigint(20) NOT NULL DEFAULT '0',
  `ilias_version` varchar(255) NOT NULL DEFAULT 'v5.4.0',
  `created_timestamp` int(11) NOT NULL DEFAULT '0',
  `currently_active` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `thumbnail_image_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`),
  KEY `i2_idx` (`obj_id`,`deleted`),
  KEY `i3_idx` (`obj_id`,`currently_active`,`deleted`),
  KEY `i4_idx` (`obj_type`),
  KEY `i5_idx` (`background_image_path`,`currently_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_cert_template`
--


--
-- Table structure for table `il_cert_template_seq`
--

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

--
-- Dumping data for table `il_cert_template_seq`
--


--
-- Table structure for table `il_cert_user_cert`
--

CREATE TABLE `il_cert_user_cert` (
  `id` int(11) NOT NULL DEFAULT '0',
  `pattern_certificate_id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` varchar(255) NOT NULL DEFAULT '0',
  `usr_id` int(11) NOT NULL DEFAULT '0',
  `user_name` varchar(255) NOT NULL DEFAULT '0',
  `acquired_timestamp` int(11) NOT NULL DEFAULT '0',
  `certificate_content` longtext NOT NULL,
  `template_values` longtext NOT NULL,
  `valid_until` int(11) DEFAULT NULL,
  `background_image_path` varchar(255) DEFAULT NULL,
  `version` varchar(255) NOT NULL DEFAULT '1',
  `ilias_version` varchar(255) NOT NULL DEFAULT 'v5.4.0',
  `currently_active` tinyint(4) NOT NULL DEFAULT '0',
  `thumbnail_image_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`,`pattern_certificate_id`),
  KEY `i2_idx` (`usr_id`,`currently_active`),
  KEY `i3_idx` (`usr_id`,`currently_active`,`acquired_timestamp`),
  KEY `i4_idx` (`usr_id`,`obj_type`,`currently_active`),
  KEY `i5_idx` (`obj_id`,`currently_active`),
  KEY `i6_idx` (`usr_id`,`obj_id`,`currently_active`),
  KEY `i7_idx` (`background_image_path`,`currently_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_cert_user_cert`
--


--
-- Table structure for table `il_cert_user_cert_seq`
--

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

--
-- Dumping data for table `il_cert_user_cert_seq`
--


--
-- Table structure for table `il_certificate`
--

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

--
-- Dumping data for table `il_certificate`
--


--
-- Table structure for table `il_cld_data`
--

CREATE TABLE `il_cld_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` tinyint(4) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `root_folder` varchar(255) DEFAULT NULL,
  `root_id` varchar(255) DEFAULT NULL,
  `owner_id` bigint(20) NOT NULL DEFAULT '0',
  `auth_complete` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_cld_data`
--


--
-- Table structure for table `il_custom_block`
--

CREATE TABLE `il_custom_block` (
  `id` int(11) NOT NULL DEFAULT '0',
  `context_obj_id` int(11) DEFAULT NULL,
  `context_obj_type` varchar(10) DEFAULT NULL,
  `context_sub_obj_id` int(11) DEFAULT NULL,
  `context_sub_obj_type` varchar(10) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_custom_block`
--


--
-- Table structure for table `il_custom_block_seq`
--

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

--
-- Dumping data for table `il_custom_block_seq`
--


--
-- Table structure for table `il_db_steps`
--

CREATE TABLE `il_db_steps` (
  `class` varchar(200) NOT NULL,
  `step` int(11) NOT NULL,
  `started` varchar(26) DEFAULT NULL,
  `finished` varchar(26) DEFAULT NULL,
  PRIMARY KEY (`class`,`step`),
  KEY `i1_idx` (`class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_db_steps`
--

INSERT INTO `il_db_steps` VALUES ('ilAccessControl8DBUpdateSteps',1,'2023-12-12 16:39:39.316416','2023-12-12 16:39:39.330104'),('ilAccessControl8DBUpdateSteps',2,'2025-04-01 15:15:43.523584','2025-04-01 15:15:43.523808'),('ilAccessRBACDeleteDbkSteps',1,'2023-12-12 16:39:39.331118','2023-12-12 16:39:39.333780'),('ilAccessRBACDeleteDbkSteps',2,'2023-12-12 16:39:39.334376','2023-12-12 16:39:39.337374'),('ilAccessRBACDeleteDbkSteps',3,'2023-12-12 16:39:39.337997','2023-12-12 16:39:39.339521'),('ilADNDatabaseObjective',1,'2023-12-12 16:39:39.302966','2023-12-12 16:39:39.315435'),('ilAuthenticationDatabaseUpdateSteps8',1,'2023-12-12 16:39:39.340519','2023-12-12 16:39:39.348635'),('ilBibliograficDB80',1,'2023-12-12 16:39:39.349499','2023-12-12 16:39:39.355083'),('ilBibliograficDB80',2,'2023-12-12 16:39:39.355665','2023-12-12 16:39:39.362170'),('ilCalendarDBUpdateSteps9',1,'2023-12-12 16:39:39.363138','2023-12-12 16:39:39.376860'),('ilCalendarDBUpdateSteps9',2,'2023-12-12 16:39:39.377487','2023-12-12 16:39:39.399312'),('ilCertificateDatabaseUpdateSteps',1,'2023-12-12 16:39:39.400161','2023-12-12 16:39:39.413347'),('ilCertificateDatabaseUpdateSteps',2,'2023-12-12 16:39:39.413839','2023-12-12 16:39:39.417098'),('ilCertificateDatabaseUpdateSteps',3,'2023-12-12 16:39:39.417587','2023-12-12 16:39:39.426976'),('ilCertificateDatabaseUpdateSteps',4,'2023-12-12 16:39:39.427494','2023-12-12 16:39:39.434428'),('ilCertificateDatabaseUpdateSteps',5,'2023-12-12 16:39:39.434913','2023-12-12 16:39:39.449215'),('ilCmiXapiDatabaseUpdateSteps',1,'2023-12-12 16:39:39.512934','2023-12-12 16:39:39.518282'),('ilCmiXapiDatabaseUpdateSteps',2,'2023-12-12 16:39:39.518877','2023-12-12 16:39:39.524618'),('ilCmiXapiDatabaseUpdateSteps',3,'2023-12-12 16:39:39.525224','2023-12-12 16:39:39.530839'),('ilCmiXapiDatabaseUpdateSteps',4,'2023-12-12 16:39:39.531436','2023-12-12 16:39:39.537017'),('ilCmiXapiDatabaseUpdateSteps',5,'2023-12-12 16:39:39.537600','2023-12-12 16:39:39.543189'),('ilCmiXapiDatabaseUpdateSteps',6,'2023-12-12 16:39:39.543862','2023-12-12 16:39:39.554877'),('ilCmiXapiDatabaseUpdateSteps',7,'2023-12-12 16:39:39.555474','2023-12-12 16:39:39.561056'),('ilCmiXapiDatabaseUpdateSteps',8,'2023-12-12 16:39:39.561671','2023-12-12 16:39:39.567169'),('ilCmiXapiDatabaseUpdateSteps',9,'2023-12-12 16:39:39.567787','2023-12-12 16:39:39.573091'),('ilCmiXapiDatabaseUpdateSteps',10,'2023-12-12 16:39:39.573688','2023-12-12 16:39:39.579211'),('ilCmiXapiDatabaseUpdateSteps',11,'2023-12-12 16:39:39.579878','2023-12-12 16:39:39.585585'),('ilCmiXapiDatabaseUpdateSteps',12,'2023-12-12 16:39:39.586191','2023-12-12 16:39:39.586832'),('ilCmiXapiDatabaseUpdateSteps',13,'2023-12-12 16:39:39.587451','2023-12-12 16:39:39.593034'),('ilCmiXapiDatabaseUpdateSteps',14,'2023-12-12 16:39:39.593639','2023-12-12 16:39:39.599431'),('ilCmiXapiDatabaseUpdateSteps',15,'2023-12-12 16:39:39.600090','2023-12-12 16:39:39.611849'),('ilCmiXapiDatabaseUpdateSteps',16,'2023-12-12 16:39:39.612522','2023-12-12 16:39:39.624741'),('ilCmiXapiDatabaseUpdateSteps',17,'2024-04-30 15:11:09.019261','2024-04-30 15:11:09.025313'),('ilContentPageUpdateSteps',1,'2023-12-12 16:39:39.689885','2023-12-12 16:39:39.690424'),('ilCourseObjectiveDBUpdateSteps',1,'2023-12-12 16:39:39.691358','2023-12-12 16:39:39.698495'),('ilCourseObjectiveDBUpdateSteps',2,'2023-12-12 16:39:39.699161','2023-12-12 16:39:39.705726'),('ilCtrlDatabaseUpdateSteps',1,'2023-12-12 16:39:41.316207','2023-12-12 16:39:41.325405'),('ilCtrlDatabaseUpdateSteps',2,'2023-12-12 16:39:41.326018','2023-12-12 16:39:41.340462'),('ilCtrlDatabaseUpdateSteps',3,'2023-12-12 16:39:41.341252','2023-12-12 16:39:41.349406'),('ilCtrlDatabaseUpdateSteps',4,'2023-12-12 16:39:41.349953','2023-12-12 16:39:41.357146'),('ilCtrlDatabaseUpdateSteps',5,'2023-12-12 16:39:41.357629','2023-12-12 16:39:41.364305'),('ilCtrlDatabaseUpdateSteps',6,'2023-12-12 16:39:41.364838','2023-12-12 16:39:41.371618'),('ilDataCollection9HotfixDBUpdateSteps',1,'2025-04-01 15:15:43.524996','2025-04-01 15:15:43.525482'),('ilDataCollection9HotfixDBUpdateSteps',2,'2025-05-20 15:03:13.562112','2025-05-20 15:03:13.562832'),('ilDataCollectionDBUpdateSteps9',1,'2023-12-12 16:39:39.706792','2023-12-12 16:39:39.715602'),('ilDataCollectionDBUpdateSteps9',2,'2023-12-12 16:39:39.716246','2023-12-12 16:39:39.739058'),('ilDataCollectionDBUpdateSteps9',3,'2023-12-12 16:39:39.739786','2023-12-12 16:39:39.748476'),('ilDataCollectionDBUpdateSteps9',4,'2023-12-12 16:39:39.749114','2023-12-12 16:39:39.757937'),('ilDataCollectionDBUpdateSteps9',5,'2023-12-12 16:39:39.758567','2023-12-12 16:39:39.771869'),('ilDataCollectionDBUpdateSteps9',6,'2023-12-12 16:39:39.772568','2023-12-12 16:39:39.773403'),('ilDataCollectionDBUpdateSteps9',7,'2023-12-12 16:39:39.773989','2023-12-12 16:39:39.774820'),('ilDataCollectionDBUpdateSteps9',8,'2023-12-12 16:39:39.775403','2023-12-12 16:39:39.781016'),('ilDataCollectionDBUpdateSteps9',9,'2024-04-30 15:11:09.026028','2024-04-30 15:11:09.026500'),('ilDataCollectionDBUpdateSteps9',10,'2024-06-18 14:04:51.007711','2024-06-18 14:04:51.020613'),('ilDataCollectionDBUpdateSteps9',11,'2024-06-18 14:04:51.020875','2024-06-18 14:04:51.021343'),('ilDataCollectionDBUpdateSteps9',12,'2024-07-30 14:37:06.779188','2024-07-30 14:37:06.779945'),('ilDataCollectionDBUpdateSteps9',13,'2024-07-30 14:37:06.780220','2024-07-30 14:37:06.788495'),('ilDataCollectionDBUpdateSteps9',14,'2024-10-08 14:30:30.511510','2024-10-08 14:30:30.511892'),('ilDataCollectionDBUpdateSteps9',15,'2024-10-08 14:30:30.512201','2024-10-08 14:30:30.519362'),('ilDataCollectionDBUpdateSteps9',16,'2024-10-08 14:30:30.519679','2024-10-08 14:30:30.520036'),('ilDataCollectionDBUpdateSteps9',17,'2024-12-10 15:59:52.840925','2024-12-10 15:59:52.841376'),('ilDataCollectionDBUpdateSteps9',18,'2025-05-20 15:03:13.558355','2025-05-20 15:03:13.558622'),('ilDataCollectionDBUpdateSteps9',19,'2025-05-20 15:03:13.558867','2025-05-20 15:03:13.560865'),('ilDataCollectionDBUpdateSteps9',20,'2025-05-20 15:03:13.561117','2025-05-20 15:03:13.561593'),('ilECSDBUpdateSteps',1,'2023-12-12 16:39:39.782084','2023-12-12 16:39:39.788234'),('ilECSUpdateSteps8',1,'2023-12-12 16:39:41.504023','2023-12-12 16:39:41.515769'),('ilECSUpdateSteps8',2,'2023-12-12 16:39:41.516395','2023-12-12 16:39:41.521923'),('ilECSUpdateSteps8',3,'2023-12-12 16:39:41.522527','2023-12-12 16:39:41.528127'),('ilECSUpdateSteps8',4,'2023-12-12 16:39:41.528772','2023-12-12 16:39:41.534227'),('ilECSUpdateSteps8',5,'2023-12-12 16:39:41.534847','2023-12-12 16:39:41.540300'),('ilECSUpdateSteps8',6,'2023-12-12 16:39:41.540918','2023-12-12 16:39:41.547675'),('ilECSUpdateSteps8',7,'2023-12-12 16:39:41.548340','2023-12-12 16:39:41.553727'),('ilECSUpdateSteps9',1,'2025-05-20 15:03:13.563478','2025-05-20 15:03:13.563956'),('ilECSUpdateSteps9',2,'2025-05-27 15:12:55.471367','2025-05-27 15:12:55.477607'),('ilFileObjectDatabaseObjective',1,'2023-12-12 16:39:39.914414','2023-12-12 16:39:39.920671'),('ilFileObjectDatabaseObjective',2,'2023-12-12 16:39:39.921276','2023-12-12 16:39:39.928502'),('ilFileObjectDatabaseObjective',3,'2023-12-12 16:39:39.929117','2023-12-12 16:39:39.929997'),('ilFileObjectDatabaseObjective',4,'2023-12-12 16:39:39.930587','2023-12-12 16:39:39.940527'),('ilFileObjectDatabaseObjective',5,'2023-12-12 16:39:39.941189','2023-12-12 16:39:39.941882'),('ilFileObjectDatabaseObjective',6,'2023-12-12 16:39:39.942672','2023-12-12 16:39:39.949521'),('ilFileObjectDatabaseObjective',7,'2023-12-12 16:39:39.950136','2023-12-12 16:39:39.950687'),('ilFileObjectRBACDatabaseSteps',1,'2023-12-12 16:39:40.132129','2023-12-12 16:39:40.132786'),('ilFileObjectRBACDatabaseSteps',2,'2023-12-12 16:39:40.133332','2023-12-12 16:39:40.135571'),('ilFileServicesDatabaseObjective',1,'2023-12-12 16:39:38.029979','2023-12-12 16:39:38.038271'),('ilForumDatabaseUpdateSteps',1,'2023-12-12 16:39:40.136549','2023-12-12 16:39:40.144064'),('ilForumDatabaseUpdateSteps',2,'2023-12-12 16:39:40.144602','2023-12-12 16:39:40.145078'),('ilForumDatabaseUpdateSteps',3,'2023-12-12 16:39:40.145597','2023-12-12 16:39:40.151569'),('ilForumDatabaseUpdateSteps',4,'2023-12-12 16:39:40.152226','2023-12-12 16:39:40.160037'),('ilForumDatabaseUpdateSteps',5,'2023-12-12 16:39:40.160566','2023-12-12 16:39:40.162235'),('ilForumDatabaseUpdateSteps',6,'2023-12-12 16:39:40.162719','2023-12-12 16:39:40.167926'),('ilForumDatabaseUpdateSteps9',1,'2023-12-12 16:39:40.168707','2023-12-12 16:39:40.175252'),('ilForumDatabaseUpdateSteps9',2,'2023-12-12 16:39:40.175770','2023-12-12 16:39:40.182283'),('ilGlossaryDBUpdateSteps',1,'2023-12-12 16:39:40.183155','2023-12-12 16:39:40.196432'),('ilGlossaryDBUpdateSteps',2,'2023-12-12 16:39:40.197085','2023-12-12 16:39:40.202493'),('ilGlossaryDBUpdateSteps',3,'2023-12-12 16:39:40.203145','2023-12-12 16:39:40.215012'),('ilGlossaryDBUpdateSteps',4,'2023-12-12 16:39:40.215687','2023-12-12 16:39:40.227487'),('ilGlossaryDBUpdateSteps',5,'2023-12-12 16:39:40.228164','2023-12-12 16:39:40.238518'),('ilGlossaryDBUpdateSteps',6,'2023-12-12 16:39:40.239153','2023-12-12 16:39:40.250834'),('ILIAS\\Administration\\Setup\\ilAdministrationDBUpdateSteps',1,'2023-12-12 16:39:38.661190','2023-12-12 16:39:38.661665'),('ILIAS\\Administration\\Setup\\ilAdministrationDBUpdateSteps',2,'2023-12-12 16:39:38.662245','2023-12-12 16:39:38.676688'),('ILIAS\\Administration\\Setup\\ilAdministrationDBUpdateSteps',3,'2023-12-12 16:39:38.677408','2023-12-12 16:39:38.710199'),('ILIAS\\Administration\\Setup\\ilAdministrationDBUpdateSteps',4,'2023-12-12 16:39:38.710871','2023-12-12 16:39:38.711794'),('ILIAS\\AdvancedMetaData\\Setup\\DBUpdateSteps8',1,'2023-12-12 16:39:38.712839','2023-12-12 16:39:38.721799'),('ILIAS\\AdvancedMetaData\\Setup\\DBUpdateSteps8',2,'2023-12-12 16:39:38.722433','2023-12-12 16:39:38.727867'),('ILIAS\\AdvancedMetaData\\Setup\\DBUpdateSteps8',3,'2023-12-12 16:39:38.728492','2023-12-12 16:39:38.729626'),('ILIAS\\AdvancedMetaData\\Setup\\DBUpdateSteps8',4,'2024-07-30 14:37:06.772061','2024-07-30 14:37:06.773923'),('ILIAS\\Blog\\Setup\\BlogDBUpdateSteps',1,'2023-12-12 16:39:38.730712','2023-12-12 16:39:38.736204'),('ILIAS\\Blog\\Setup\\BlogDBUpdateSteps',2,'2023-12-12 16:39:38.736861','2023-12-12 16:39:38.737915'),('ILIAS\\BookingManager\\Setup\\ilBookingManager8HotfixDBUpdateSteps',1,'2024-12-10 15:59:52.836029','2024-12-10 15:59:52.836697'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',1,'2023-12-12 16:39:38.738873','2023-12-12 16:39:38.746442'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',2,'2023-12-12 16:39:38.747069','2023-12-12 16:39:38.753419'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',3,'2023-12-12 16:39:38.754020','2023-12-12 16:39:38.760822'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',4,'2023-12-12 16:39:38.761441','2023-12-12 16:39:38.773305'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',5,'2023-12-12 16:39:38.774036','2023-12-12 16:39:38.779556'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',6,'2023-12-12 16:39:38.780215','2023-12-12 16:39:38.785707'),('ILIAS\\BookingManager\\Setup\\ilBookingManagerDBUpdateSteps',7,'2023-12-12 16:39:38.786336','2023-12-12 16:39:38.797865'),('ILIAS\\Chatroom\\Setup\\UpdateSteps',1,'2023-12-12 16:39:39.450025','2023-12-12 16:39:39.490305'),('ILIAS\\Chatroom\\Setup\\UpdateSteps',2,'2023-12-12 16:39:39.490976','2023-12-12 16:39:39.502927'),('ILIAS\\Chatroom\\Setup\\UpdateSteps',3,'2023-12-12 16:39:39.503552','2023-12-12 16:39:39.510145'),('ILIAS\\Chatroom\\Setup\\UpdateSteps',4,'2023-12-12 16:39:39.510759','2023-12-12 16:39:39.511899'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',1,'2023-12-12 16:39:37.399454','2023-12-12 16:39:37.408012'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',2,'2023-12-12 16:39:37.408541','2023-12-12 16:39:37.422711'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',3,'2023-12-12 16:39:37.423333','2023-12-12 16:39:37.425736'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',4,'2023-12-12 16:39:37.426343','2023-12-12 16:39:37.431884'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',5,'2023-12-12 16:39:37.432512','2023-12-12 16:39:37.433734'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',6,'2023-12-12 16:39:37.434361','2023-12-12 16:39:37.434807'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',7,'2023-12-12 16:39:37.435380','2023-12-12 16:39:37.436265'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',8,'2023-12-12 16:39:37.436849','2023-12-12 16:39:37.437726'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',9,'2023-12-12 16:39:37.438294','2023-12-12 16:39:37.439166'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',10,'2023-12-12 16:39:37.439832','2023-12-12 16:39:37.440784'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',11,'2023-12-12 16:39:37.441392','2023-12-12 16:39:37.442291'),('ILIAS\\COPage\\Setup\\ilCOPageDBUpdateSteps',12,'2023-12-12 16:39:37.442881','2023-12-12 16:39:37.445224'),('ILIAS\\Dashboard\\Setup\\ilDashboardUpdateSteps',1,'2023-12-12 16:39:38.799015','2023-12-12 16:39:38.800401'),('ILIAS\\Dashboard\\Setup\\ilDashboardUpdateSteps',2,'2023-12-12 16:39:38.800987','2023-12-12 16:39:38.809540'),('ILIAS\\Dashboard\\Setup\\ilDashboardUpdateSteps',3,'2025-05-20 15:03:13.554607','2025-05-20 15:03:13.554985'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',1,'2023-12-12 16:39:38.816858','2023-12-12 16:39:38.817317'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',2,'2023-12-12 16:39:38.817979','2023-12-12 16:39:38.841591'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',3,'2023-12-12 16:39:38.842258','2023-12-12 16:39:38.847709'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',4,'2023-12-12 16:39:38.848329','2023-12-12 16:39:38.848771'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',5,'2023-12-12 16:39:38.849355','2023-12-12 16:39:38.861092'),('ILIAS\\EmployeeTalk\\Setup\\ilEmployeeTalkDBUpdateSteps',6,'2023-12-12 16:39:38.861704','2023-12-12 16:39:38.867089'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',1,'2023-12-12 16:39:39.798148','2023-12-12 16:39:39.804867'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',2,'2023-12-12 16:39:39.805502','2023-12-12 16:39:39.812537'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',3,'2023-12-12 16:39:39.813214','2023-12-12 16:39:39.820004'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',4,'2023-12-12 16:39:39.820636','2023-12-12 16:39:39.826826'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',5,'2023-12-12 16:39:39.827442','2023-12-12 16:39:39.833671'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',6,'2023-12-12 16:39:39.834305','2023-12-12 16:39:39.839961'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',7,'2023-12-12 16:39:39.840608','2023-12-12 16:39:39.849303'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',8,'2023-12-12 16:39:39.849936','2023-12-12 16:39:39.850592'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',9,'2023-12-12 16:39:39.851188','2023-12-12 16:39:39.865679'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',10,'2023-12-12 16:39:39.866319','2023-12-12 16:39:39.872521'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',11,'2023-12-12 16:39:39.873152','2023-12-12 16:39:39.879330'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',12,'2023-12-12 16:39:39.879965','2023-12-12 16:39:39.885563'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',13,'2023-12-12 16:39:39.886245','2023-12-12 16:39:39.892015'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',14,'2023-12-12 16:39:39.892704','2023-12-12 16:39:39.898466'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',15,'2023-12-12 16:39:39.899113','2023-12-12 16:39:39.911924'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',16,'2023-12-12 16:39:39.912625','2023-12-12 16:39:39.913394'),('ILIAS\\Exercise\\Setup\\ilExerciseDBUpdateSteps',17,'2024-04-30 15:11:09.027177','2024-04-30 15:11:09.030647'),('ILIAS\\Help\\Setup\\ilHelpDBUpdateSteps',1,'2023-12-12 16:39:38.874568','2023-12-12 16:39:38.880049'),('ILIAS\\Help\\Setup\\ilHelpDBUpdateSteps',2,'2023-12-12 16:39:38.880668','2023-12-12 16:39:38.886115'),('ILIAS\\Help\\Setup\\ilHelpDBUpdateSteps',3,'2023-12-12 16:39:38.886720','2023-12-12 16:39:38.887276'),('ILIAS\\ItemGroup\\Setup\\ilItemGroupDBUpdateSteps',1,'2023-12-12 16:39:38.894598','2023-12-12 16:39:38.900233'),('ILIAS\\ItemGroup\\Setup\\ilItemGroupDBUpdateSteps',2,'2023-12-12 16:39:38.900874','2023-12-12 16:39:38.906340'),('ILIAS\\LDAP\\Setup\\LDAPBindPasswordFieldMigration',1,'2024-08-27 13:48:37.202984','2024-08-27 13:48:37.207786'),('ILIAS\\LearningModule\\Setup\\LearningModuleDBUpdateSteps',1,'2023-12-12 16:39:38.907450','2023-12-12 16:39:38.912966'),('ILIAS\\LearningModule\\Setup\\LearningModuleDBUpdateSteps',2,'2023-12-12 16:39:38.913604','2023-12-12 16:39:38.919087'),('ILIAS\\LegalDocuments\\Setup\\UpdateSteps',1,'2023-12-12 16:39:38.920097','2023-12-12 16:39:38.970055'),('ILIAS\\LegalDocuments\\Setup\\UpdateSteps',2,'2023-12-12 16:39:38.970741','2023-12-12 16:39:38.971244'),('ILIAS\\LegalDocuments\\Setup\\UpdateSteps',3,'2024-01-31 14:38:25.383413','2024-01-31 14:38:25.389480'),('ILIAS\\Link\\Setup\\LinkDBUpdateSteps',1,'2023-12-12 16:39:38.972279','2023-12-12 16:39:38.980246'),('ILIAS\\Link\\Setup\\LinkDBUpdateSteps',2,'2023-12-12 16:39:38.980881','2023-12-12 16:39:38.981557'),('ILIAS\\MediaCast\\Setup\\ilMediaCastDBUpdateSteps',1,'2023-12-12 16:39:38.982512','2023-12-12 16:39:38.988267'),('ILIAS\\MediaCast\\Setup\\ilMediaCastDBUpdateSteps',2,'2023-12-12 16:39:38.988894','2023-12-12 16:39:38.994316'),('ILIAS\\MediaCast\\Setup\\ilMediaCastDBUpdateSteps',3,'2023-12-12 16:39:38.994925','2023-12-12 16:39:39.000555'),('ILIAS\\MediaCast\\Setup\\ilMediaCastDBUpdateSteps',4,'2023-12-12 16:39:39.001272','2023-12-12 16:39:39.004364'),('ILIAS\\MediaObjects\\Setup\\ilMediaObjectsDBUpdateSteps',1,'2023-12-12 16:39:39.005516','2023-12-12 16:39:39.006631'),('ILIAS\\MediaObjects\\Setup\\ilMediaObjectsDBUpdateSteps',2,'2024-01-31 14:38:25.390434','2024-01-31 14:38:25.391265'),('ILIAS\\MediaObjects\\Setup\\ilMediaObjectsDBUpdateSteps',3,'2024-06-18 14:04:51.003089','2024-06-18 14:04:51.003444'),('ILIAS\\MediaObjects\\Setup\\ilMediaObjectsDBUpdateSteps',4,'2024-06-18 14:04:51.003687','2024-06-18 14:04:51.005776'),('ILIAS\\Notes\\Setup\\ilNotesDBUpdateSteps',1,'2023-12-12 16:39:39.007597','2023-12-12 16:39:39.013002'),('ILIAS\\Notes\\Setup\\ilNotesDBUpdateSteps',2,'2024-10-08 14:30:30.500528','2024-10-08 14:30:30.501349'),('ILIAS\\Notes\\Setup\\ilNotesDBUpdateSteps',3,'2024-10-08 14:30:30.501655','2024-10-08 14:30:30.502033'),('ILIAS\\Object\\Setup\\ilObject9DBUpdateSteps',1,'2023-12-12 16:39:39.019667','2023-12-12 16:39:39.024275'),('ILIAS\\Object\\Setup\\ilObject9DBUpdateSteps',2,'2023-12-12 16:39:39.024758','2023-12-12 16:39:39.092466'),('ILIAS\\Object\\Setup\\ilObjectDBUpdateSteps',1,'2023-12-12 16:39:39.013957','2023-12-12 16:39:39.018894'),('ILIAS\\Object\\Setup\\ilObjectDBUpdateSteps',2,'2024-10-08 14:30:30.502521','2024-10-08 14:30:30.508752'),('ILIAS\\Portfolio\\Setup\\ilPortfolioDBUpdateSteps',1,'2023-12-12 16:39:39.093581','2023-12-12 16:39:39.105685'),('ILIAS\\Repository\\Setup\\RepositoryDBUpdateSteps',1,'2023-12-12 16:39:39.106736','2023-12-12 16:39:39.107544'),('ILIAS\\Style\\Content\\Setup\\ilStyle9HotfixDBUpdateSteps',1,'2025-04-01 15:15:43.521529','2025-04-01 15:15:43.521884'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',1,'2023-12-12 16:39:39.108632','2023-12-12 16:39:39.120662'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',2,'2023-12-12 16:39:39.121328','2023-12-12 16:39:39.146185'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',3,'2023-12-12 16:39:39.146860','2023-12-12 16:39:39.152866'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',4,'2023-12-12 16:39:39.153637','2023-12-12 16:39:39.159526'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',5,'2023-12-12 16:39:39.160105','2023-12-12 16:39:39.164979'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',6,'2023-12-12 16:39:39.165526','2023-12-12 16:39:39.176173'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',7,'2023-12-12 16:39:39.176665','2023-12-12 16:39:39.177236'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',8,'2023-12-12 16:39:39.177705','2023-12-12 16:39:39.178231'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',9,'2023-12-12 16:39:39.178728','2023-12-12 16:39:39.183344'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',10,'2023-12-12 16:39:39.183836','2023-12-12 16:39:39.184355'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',11,'2023-12-12 16:39:39.184826','2023-12-12 16:39:39.190503'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',12,'2023-12-12 16:39:39.190996','2023-12-12 16:39:39.196765'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',13,'2024-01-31 14:38:25.392396','2024-01-31 14:38:25.392882'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',14,'2024-01-31 14:38:25.393355','2024-01-31 14:38:25.394528'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',15,'2024-01-31 14:38:25.395022','2024-01-31 14:38:25.395529'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',16,'2024-01-31 14:38:25.396022','2024-01-31 14:38:25.396473'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',17,'2024-01-31 14:38:25.396963','2024-01-31 14:38:25.397440'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',18,'2024-01-31 14:38:25.397913','2024-01-31 14:38:25.398366'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',19,'2024-01-31 14:38:25.398856','2024-01-31 14:38:25.399275'),('ILIAS\\Style\\Content\\Setup\\ilStyleDBUpdateSteps',20,'2024-04-30 15:11:09.017679','2024-04-30 15:11:09.018014'),('ILIAS\\SurveyQuestionPool\\Setup\\SurveyQuestionPoolDBUpdateSteps',1,'2024-07-30 14:37:06.775997','2024-07-30 14:37:06.777640'),('ILIAS\\Wiki\\Setup\\ilWiki8HotfixDBUpdateSteps',1,'2024-12-10 15:59:52.839179','2024-12-10 15:59:52.839577'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',1,'2023-12-12 16:39:39.203953','2023-12-12 16:39:39.239197'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',2,'2023-12-12 16:39:39.239904','2023-12-12 16:39:39.245378'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',3,'2023-12-12 16:39:39.245988','2023-12-12 16:39:39.259866'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',4,'2023-12-12 16:39:39.260560','2023-12-12 16:39:39.280185'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',5,'2023-12-12 16:39:39.280812','2023-12-12 16:39:39.301898'),('ILIAS\\Wiki\\Setup\\ilWikiDBUpdateSteps',6,'2025-04-01 15:15:43.522684','2025-04-01 15:15:43.522998'),('ilIndividualAssessmentRectifyMembersTableDBUpdateSteps',1,'2023-12-12 16:39:40.251946','2023-12-12 16:39:40.257004'),('ilIndividualAssessmentRectifyMembersTableDBUpdateSteps',2,'2023-12-12 16:39:40.257656','2023-12-12 16:39:40.258318'),('ilIntroduceComponentArtifactDBUpdateSteps',1,'2023-12-12 16:39:39.625922','2023-12-12 16:39:39.633814'),('ilIntroduceComponentArtifactDBUpdateSteps',2,'2023-12-12 16:39:39.634423','2023-12-12 16:39:39.642084'),('ilIntroduceComponentArtifactDBUpdateSteps',3,'2023-12-12 16:39:39.642678','2023-12-12 16:39:39.643189'),('ilIntroduceComponentArtifactDBUpdateSteps',4,'2023-12-12 16:39:39.643787','2023-12-12 16:39:39.660457'),('ilIntroduceComponentArtifactDBUpdateSteps',5,'2023-12-12 16:39:39.661137','2023-12-12 16:39:39.667384'),('ilIntroduceComponentArtifactDBUpdateSteps',6,'2023-12-12 16:39:39.668074','2023-12-12 16:39:39.674546'),('ilIntroduceComponentArtifactDBUpdateSteps',7,'2023-12-12 16:39:39.675172','2023-12-12 16:39:39.682053'),('ilIntroduceComponentArtifactDBUpdateSteps',8,'2023-12-12 16:39:39.682739','2023-12-12 16:39:39.688813'),('ilIntroduceEventHandlingArtifactDBUpdateSteps',1,'2023-12-12 16:39:39.789218','2023-12-12 16:39:39.797080'),('ilLearningSequenceRectifyPostConditionsTableDBUpdateSteps',1,'2023-12-12 16:39:40.445426','2023-12-12 16:39:40.460126'),('ilLearningSequenceRectifyPostConditionsTableDBUpdateSteps',2,'2023-12-12 16:39:40.460745','2023-12-12 16:39:40.469096'),('ilLearningSequenceRectifyPostConditionsTableDBUpdateSteps',3,'2023-12-12 16:39:40.469737','2023-12-12 16:39:40.470737'),('ilLearningSequenceRegisterNotificationType',1,'2023-12-12 16:39:40.471781','2023-12-12 16:39:40.472617'),('ilLearningSequenceRegisterNotificationType',2,'2023-12-12 16:39:40.473202','2023-12-12 16:39:40.474079'),('ilLoggingUpdateSteps8',1,'2023-12-12 16:39:40.475061','2023-12-12 16:39:40.475900'),('ilLTIConsumerDatabaseUpdateSteps',1,'2023-12-12 16:39:40.259312','2023-12-12 16:39:40.265030'),('ilLTIConsumerDatabaseUpdateSteps',2,'2023-12-12 16:39:40.265647','2023-12-12 16:39:40.271342'),('ilLTIConsumerDatabaseUpdateSteps',3,'2023-12-12 16:39:40.271999','2023-12-12 16:39:40.277873'),('ilLTIConsumerDatabaseUpdateSteps',4,'2023-12-12 16:39:40.278484','2023-12-12 16:39:40.284092'),('ilLTIConsumerDatabaseUpdateSteps',5,'2023-12-12 16:39:40.284732','2023-12-12 16:39:40.290336'),('ilLTIConsumerDatabaseUpdateSteps',6,'2023-12-12 16:39:40.290982','2023-12-12 16:39:40.296595'),('ilLTIConsumerDatabaseUpdateSteps',7,'2023-12-12 16:39:40.297211','2023-12-12 16:39:40.302845'),('ilLTIConsumerDatabaseUpdateSteps',8,'2023-12-12 16:39:40.303494','2023-12-12 16:39:40.309589'),('ilLTIConsumerDatabaseUpdateSteps',9,'2023-12-12 16:39:40.310207','2023-12-12 16:39:40.315960'),('ilLTIConsumerDatabaseUpdateSteps',10,'2023-12-12 16:39:40.316586','2023-12-12 16:39:40.322306'),('ilLTIConsumerDatabaseUpdateSteps',11,'2023-12-12 16:39:40.322920','2023-12-12 16:39:40.328713'),('ilLTIConsumerDatabaseUpdateSteps',12,'2023-12-12 16:39:40.329332','2023-12-12 16:39:40.335168'),('ilLTIConsumerDatabaseUpdateSteps',13,'2023-12-12 16:39:40.335799','2023-12-12 16:39:40.341702'),('ilLTIConsumerDatabaseUpdateSteps',14,'2023-12-12 16:39:40.342328','2023-12-12 16:39:40.347680'),('ilLTIConsumerDatabaseUpdateSteps',15,'2023-12-12 16:39:40.348311','2023-12-12 16:39:40.368952'),('ilLTIDatabaseUpdateSteps',1,'2023-12-12 16:39:40.370010','2023-12-12 16:39:40.376439'),('ilLTIDatabaseUpdateSteps',2,'2023-12-12 16:39:40.377073','2023-12-12 16:39:40.383219'),('ilLTIDatabaseUpdateSteps',3,'2023-12-12 16:39:40.383847','2023-12-12 16:39:40.392769'),('ilLTIDatabaseUpdateSteps',4,'2023-12-12 16:39:40.393390','2023-12-12 16:39:40.399362'),('ilLTIDatabaseUpdateSteps',5,'2023-12-12 16:39:40.399988','2023-12-12 16:39:40.405337'),('ilLTIDatabaseUpdateSteps',6,'2023-12-12 16:39:40.405914','2023-12-12 16:39:40.411265'),('ilLTIDatabaseUpdateSteps',7,'2023-12-12 16:39:40.411887','2023-12-12 16:39:40.417318'),('ilLTIDatabaseUpdateSteps',8,'2023-12-12 16:39:40.418019','2023-12-12 16:39:40.435272'),('ilLTIDatabaseUpdateSteps',9,'2023-12-12 16:39:40.435922','2023-12-12 16:39:40.444322'),('ilMailDatabaseUpdateSteps',1,'2023-12-12 16:39:40.663356','2023-12-12 16:39:40.671293'),('ilMailDatabaseUpdateSteps',2,'2023-12-12 16:39:40.671949','2023-12-12 16:39:40.672918'),('ilMailDatabaseUpdateSteps',3,'2023-12-12 16:39:40.673495','2023-12-12 16:39:40.674173'),('ilMailDatabaseUpdateSteps',4,'2023-12-12 16:39:40.674772','2023-12-12 16:39:40.675455'),('ilMailDatabaseUpdateSteps',5,'2023-12-12 16:39:40.676087','2023-12-12 16:39:40.686900'),('ilMailDatabaseUpdateSteps',6,'2023-12-12 16:39:40.687535','2023-12-12 16:39:40.693141'),('ilMailDatabaseUpdateSteps',7,'2023-12-12 16:39:40.693741','2023-12-12 16:39:40.699091'),('ilMailDatabaseUpdateSteps',8,'2023-12-12 16:39:40.699748','2023-12-12 16:39:40.705271'),('ilMailDatabaseUpdateSteps',9,'2023-12-12 16:39:40.705882','2023-12-12 16:39:40.711450'),('ilMailDatabaseUpdateSteps',10,'2023-12-12 16:39:40.712067','2023-12-12 16:39:40.717425'),('ilMailDatabaseUpdateSteps',11,'2023-12-12 16:39:40.718029','2023-12-12 16:39:40.729740'),('ilMailDatabaseUpdateSteps',12,'2023-12-12 16:39:40.730356','2023-12-12 16:39:40.731892'),('ilMDCopyrightUpdateSteps',1,'2023-12-12 16:39:40.621835','2023-12-12 16:39:40.627401'),('ilMDCopyrightUpdateSteps',2,'2023-12-12 16:39:40.628041','2023-12-12 16:39:40.633497'),('ilMDCopyrightUpdateSteps',3,'2023-12-12 16:39:40.634103','2023-12-12 16:39:40.639372'),('ilMDCopyrightUpdateSteps',4,'2023-12-12 16:39:40.639987','2023-12-12 16:39:40.645401'),('ilMDCopyrightUpdateSteps',5,'2023-12-12 16:39:40.645992','2023-12-12 16:39:40.651340'),('ilMDCopyrightUpdateSteps',6,'2023-12-12 16:39:40.651967','2023-12-12 16:39:40.657337'),('ilMDCopyrightUpdateSteps',7,'2023-12-12 16:39:40.658051','2023-12-12 16:39:40.659947'),('ilMDCopyrightUpdateSteps',8,'2023-12-12 16:39:40.660599','2023-12-12 16:39:40.662327'),('ilMDCopyrightUpdateSteps',9,'2024-08-27 13:48:37.211327','2024-08-27 13:48:37.211612'),('ilMDCopyrightUpdateSteps',10,'2024-08-27 13:48:37.211956','2024-08-27 13:48:37.212429'),('ilMDCopyrightUpdateSteps',11,'2024-08-27 13:48:37.212704','2024-08-27 13:48:37.213194'),('ilMDCopyrightUpdateSteps',12,'2025-04-01 15:15:43.527076','2025-04-01 15:15:43.527535'),('ilMDLOMUpdateSteps',1,'2023-12-12 16:39:40.476845','2023-12-12 16:39:40.482604'),('ilMDLOMUpdateSteps',2,'2023-12-12 16:39:40.483210','2023-12-12 16:39:40.493505'),('ilMDLOMUpdateSteps',3,'2023-12-12 16:39:40.494133','2023-12-12 16:39:40.504527'),('ilMDLOMUpdateSteps',4,'2023-12-12 16:39:40.505181','2023-12-12 16:39:40.515657'),('ilMDLOMUpdateSteps',5,'2023-12-12 16:39:40.516306','2023-12-12 16:39:40.526976'),('ilMDLOMUpdateSteps',6,'2023-12-12 16:39:40.527629','2023-12-12 16:39:40.542589'),('ilMDLOMUpdateSteps',7,'2023-12-12 16:39:40.543237','2023-12-12 16:39:40.558219'),('ilMDLOMUpdateSteps',8,'2023-12-12 16:39:40.558863','2023-12-12 16:39:40.573725'),('ilMDLOMUpdateSteps',9,'2023-12-12 16:39:40.574348','2023-12-12 16:39:40.589676'),('ilMDLOMUpdateSteps',10,'2023-12-12 16:39:40.590295','2023-12-12 16:39:40.605243'),('ilMDLOMUpdateSteps',11,'2023-12-12 16:39:40.605852','2023-12-12 16:39:40.620681'),('ilNotificationUpdateSteps',1,'2023-12-12 16:39:40.745514','2023-12-12 16:39:40.746045'),('ilNotificationUpdateSteps',2,'2023-12-12 16:39:40.746642','2023-12-12 16:39:40.747782'),('ilNotificationUpdateSteps',3,'2023-12-12 16:39:40.748371','2023-12-12 16:39:40.749597'),('ilNotificationUpdateSteps',4,'2023-12-12 16:39:40.750183','2023-12-12 16:39:40.751779'),('ilNotificationUpdateSteps',5,'2023-12-12 16:39:40.752382','2023-12-12 16:39:40.753632'),('ilNotificationUpdateSteps',6,'2023-12-12 16:39:40.754372','2023-12-12 16:39:40.755632'),('ilNotificationUpdateSteps',7,'2023-12-12 16:39:40.756273','2023-12-12 16:39:40.757139'),('ilNotificationUpdateSteps',8,'2023-12-12 16:39:40.757727','2023-12-12 16:39:40.764151'),('ilNotificationUpdateSteps',9,'2023-12-12 16:39:40.764798','2023-12-12 16:39:40.766089'),('ilNotificationUpdateSteps',10,'2023-12-12 16:39:40.766605','2023-12-12 16:39:40.774578'),('ilNotificationUpdateSteps',11,'2023-12-12 16:39:40.775108','2023-12-12 16:39:40.776339'),('ilObjCloudModuleProgressTableUpdateSteps',1,'2023-12-12 16:39:40.777271','2023-12-12 16:39:40.778064'),('ilPDFGenerationDB90',1,'2023-12-12 16:39:40.778896','2023-12-12 16:39:40.789544'),('ilPDFGenerationDB90',2,'2023-12-12 16:39:40.790049','2023-12-12 16:39:40.799836'),('ilPDFGenerationDB90',3,'2023-12-12 16:39:40.800336','2023-12-12 16:39:40.809509'),('ilPDFGenerationDB90',4,'2023-12-12 16:39:40.810009','2023-12-12 16:39:40.819202'),('ilPDFGenerationDB90',5,'2023-12-12 16:39:40.819725','2023-12-12 16:39:40.828889'),('ilPDFGenerationDB90',6,'2023-12-12 16:39:40.829380','2023-12-12 16:39:40.830736'),('ilPDFGenerationDB90',7,'2023-12-12 16:39:40.831240','2023-12-12 16:39:40.832631'),('ilPDFGenerationDB90',8,'2023-12-12 16:39:40.833116','2023-12-12 16:39:40.834456'),('ilPDFGenerationDB90',9,'2023-12-12 16:39:40.834934','2023-12-12 16:39:40.836311'),('ilPDFGenerationDB90',10,'2023-12-12 16:39:40.836855','2023-12-12 16:39:40.838152'),('ilPDFGenerationDB90',11,'2023-12-12 16:39:40.838623','2023-12-12 16:39:40.839346'),('ilPDFGenerationDB90',12,'2023-12-12 16:39:40.839825','2023-12-12 16:39:40.840539'),('ilPDFGenerationDB90',13,'2023-12-12 16:39:40.841100','2023-12-12 16:39:40.842378'),('ilPDFGenerationDB90',14,'2023-12-12 16:39:40.842860','2023-12-12 16:39:40.843572'),('ilRadiusDBUpdateSteps',1,'2023-12-12 16:39:40.844445','2023-12-12 16:39:40.844895'),('ilResourceStorageDB80',1,'2023-12-12 16:39:38.338173','2023-12-12 16:39:38.367464'),('ilResourceStorageDB80',2,'2023-12-12 16:39:38.368013','2023-12-12 16:39:38.388821'),('ilResourceStorageDB80',3,'2023-12-12 16:39:38.389366','2023-12-12 16:39:38.429636'),('ilResourceStorageDB80',4,'2023-12-12 16:39:38.430303','2023-12-12 16:39:38.437061'),('ilResourceStorageDB80',5,'2023-12-12 16:39:38.437660','2023-12-12 16:39:38.471262'),('ilResourceStorageDB80',6,'2023-12-12 16:39:38.471788','2023-12-12 16:39:38.519138'),('ilResourceStorageDB80',7,'2023-12-12 16:39:38.519862','2023-12-12 16:39:38.526648'),('ilResourceStorageDB80',8,'2023-12-12 16:39:38.527269','2023-12-12 16:39:38.556170'),('ilResourceStorageDB80',9,'2023-12-12 16:39:38.556806','2023-12-12 16:39:38.566584'),('ilResourceStorageDB80',10,'2023-12-12 16:39:38.567201','2023-12-12 16:39:38.580806'),('ilResourceStorageDB80',11,'2023-12-12 16:39:38.581452','2023-12-12 16:39:38.598519'),('ilResourceStorageDB80',12,'2023-12-12 16:39:38.599143','2023-12-12 16:39:38.604883'),('ilResourceStorageDB80',13,'2024-07-30 14:37:06.756935','2024-07-30 14:37:06.761419'),('ilResourceStorageDB90',1,'2023-12-12 16:39:39.951730','2023-12-12 16:39:39.994214'),('ilResourceStorageDB90',2,'2023-12-12 16:39:39.994875','2023-12-12 16:39:40.021210'),('ilResourceStorageDB90',3,'2023-12-12 16:39:40.021888','2023-12-12 16:39:40.027049'),('ilResourceStorageDB90',4,'2023-12-12 16:39:40.027697','2023-12-12 16:39:40.032367'),('ilScormAiccDatabaseUpdateSteps',1,'2024-01-31 14:38:25.408514','2024-01-31 14:38:25.417677'),('ilSessionDBUpdateSteps9',1,'2023-12-12 16:39:40.848750','2023-12-12 16:39:40.854713'),('ilSessionDBUpdateSteps9',2,'2023-12-12 16:39:40.855241','2023-12-12 16:39:40.869825'),('ilSkillDBUpdateSteps',1,'2023-12-12 16:39:40.893060','2023-12-12 16:39:40.913834'),('ilSkillDBUpdateSteps',2,'2023-12-12 16:39:40.914360','2023-12-12 16:39:40.919452'),('ilSkillDBUpdateSteps',3,'2023-12-12 16:39:40.919946','2023-12-12 16:39:40.924695'),('ilSkillDBUpdateSteps',4,'2023-12-12 16:39:40.925205','2023-12-12 16:39:40.925597'),('ilSkillDBUpdateSteps',5,'2023-12-12 16:39:40.926110','2023-12-12 16:39:40.926514'),('ilSkillDBUpdateSteps',6,'2023-12-12 16:39:40.927018','2023-12-12 16:39:40.927831'),('ilSkillDBUpdateSteps',7,'2023-12-12 16:39:40.928349','2023-12-12 16:39:40.929305'),('ilSkillDBUpdateSteps',8,'2023-12-12 16:39:40.929848','2023-12-12 16:39:40.935168'),('ilSkillDBUpdateSteps',9,'2023-12-12 16:39:40.935805','2023-12-12 16:39:40.936593'),('ilSkillDBUpdateSteps',10,'2023-12-12 16:39:40.937203','2023-12-12 16:39:40.944921'),('ilSkillDBUpdateSteps',11,'2023-12-12 16:39:40.945559','2023-12-12 16:39:40.957641'),('ilStudyProgrammeAssignmentTableUpdateSteps',1,'2023-12-12 16:39:40.978569','2023-12-12 16:39:40.986575'),('ilStudyProgrammeAutoCategoryTableUpdateSteps',1,'2023-12-12 16:39:41.008416','2023-12-12 16:39:41.014561'),('ilStudyProgrammePCStatusInfoUpdateSteps',1,'2023-12-12 16:39:41.015560','2023-12-12 16:39:41.016387'),('ilStudyProgrammeProgressTableUpdateSteps',1,'2023-12-12 16:39:40.958801','2023-12-12 16:39:40.964559'),('ilStudyProgrammeProgressTableUpdateSteps',2,'2023-12-12 16:39:40.965178','2023-12-12 16:39:40.971470'),('ilStudyProgrammeProgressTableUpdateSteps',3,'2023-12-12 16:39:40.972111','2023-12-12 16:39:40.977513'),('ilStudyProgrammeSettingsTableUpdateSteps',1,'2023-12-12 16:39:40.987952','2023-12-12 16:39:40.993671'),('ilStudyProgrammeSettingsTableUpdateSteps',2,'2023-12-12 16:39:40.994296','2023-12-12 16:39:41.007392'),('ilStudyProgrammeUDFDefinitionUpdateSteps',1,'2023-12-12 16:39:41.017295','2023-12-12 16:39:41.022663'),('ilTest9DBUpdateSteps',1,'2023-12-12 16:39:41.096769','2023-12-12 16:39:41.103656'),('ilTest9DBUpdateSteps',2,'2023-12-12 16:39:41.104286','2023-12-12 16:39:41.115799'),('ilTest9DBUpdateSteps',3,'2023-12-12 16:39:41.116433','2023-12-12 16:39:41.118700'),('ilTest9DBUpdateSteps',4,'2023-12-12 16:39:41.119314','2023-12-12 16:39:41.132294'),('ilTest9DBUpdateSteps',5,'2023-12-12 16:39:41.132920','2023-12-12 16:39:41.173231'),('ilTest9DBUpdateSteps',6,'2023-12-12 16:39:41.173872','2023-12-12 16:39:41.194216'),('ilTest9DBUpdateSteps',7,'2023-12-12 16:39:41.194841','2023-12-12 16:39:41.227543'),('ilTest9DBUpdateSteps',8,'2023-12-12 16:39:41.228136','2023-12-12 16:39:41.233772'),('ilTest9DBUpdateSteps',9,'2023-12-12 16:39:41.234280','2023-12-12 16:39:41.240277'),('ilTest9DBUpdateSteps',10,'2023-12-12 16:39:41.240874','2023-12-12 16:39:41.247449'),('ilTest9DBUpdateSteps',11,'2023-12-12 16:39:41.248082','2023-12-12 16:39:41.254525'),('ilTest9DBUpdateSteps',12,'2023-12-12 16:39:41.255153','2023-12-12 16:39:41.256499'),('ilTest9DBUpdateSteps',13,'2023-12-12 16:39:41.257140','2023-12-12 16:39:41.270051'),('ilTest9DBUpdateSteps',14,'2023-12-12 16:39:41.270683','2023-12-12 16:39:41.282114'),('ilTest9DBUpdateSteps',15,'2023-12-12 16:39:41.282746','2023-12-12 16:39:41.289702'),('ilTest9DBUpdateSteps',16,'2023-12-12 16:39:41.290328','2023-12-12 16:39:41.295496'),('ilTest9DBUpdateSteps',17,'2023-12-12 16:39:41.296140','2023-12-12 16:39:41.301432'),('ilTest9DBUpdateSteps',18,'2023-12-12 16:39:41.302072','2023-12-12 16:39:41.307756'),('ilTest9DBUpdateSteps',19,'2024-04-30 15:11:09.036627','2024-04-30 15:11:09.040172'),('ilTest9DBUpdateSteps',20,'2024-12-10 15:59:52.847725','2024-12-10 15:59:52.851730'),('ilTest9DBUpdateSteps',21,'2025-01-14 15:57:34.331279','2025-01-14 15:57:34.331841'),('ilTestQuestionPool80DBUpdateSteps',1,'2023-12-12 16:39:41.023770','2023-12-12 16:39:41.025028'),('ilTestQuestionPool80DBUpdateSteps',2,'2023-12-12 16:39:41.025620','2023-12-12 16:39:41.031146'),('ilTestQuestionPool80DBUpdateSteps',3,'2023-12-12 16:39:41.031863','2023-12-12 16:39:41.038435'),('ilTestQuestionPool80DBUpdateSteps',4,'2023-12-12 16:39:41.039062','2023-12-12 16:39:41.045485'),('ilTestQuestionPool80DBUpdateSteps',5,'2023-12-12 16:39:41.046098','2023-12-12 16:39:41.059436'),('ilTestQuestionPool80DBUpdateSteps',6,'2023-12-12 16:39:41.060098','2023-12-12 16:39:41.065553'),('ilTestQuestionPool80DBUpdateSteps',7,'2023-12-12 16:39:41.066180','2023-12-12 16:39:41.071725'),('ilTestQuestionPool9DBUpdateSteps',1,'2023-12-12 16:39:41.072787','2023-12-12 16:39:41.078929'),('ilTestQuestionPool9DBUpdateSteps',2,'2023-12-12 16:39:41.079544','2023-12-12 16:39:41.085869'),('ilTestQuestionPool9DBUpdateSteps',3,'2023-12-12 16:39:41.086494','2023-12-12 16:39:41.088653'),('ilTestQuestionPool9DBUpdateSteps',4,'2023-12-12 16:39:41.089278','2023-12-12 16:39:41.095717'),('ilTestQuestionPool9DBUpdateSteps',5,'2024-10-08 14:30:30.526303','2024-10-08 14:30:30.530037'),('ilTestQuestionPool9DBUpdateSteps',6,'2024-10-08 14:30:30.530320','2024-10-08 14:30:30.532686'),('ilTestQuestionPool9DBUpdateSteps',7,'2025-04-01 15:15:43.532392','2025-04-01 15:15:43.534713'),('ilTrackingUpdateSteps9',1,'2025-05-20 15:03:13.570257','2025-05-20 15:03:13.574192'),('ilTreeDBUpdateSteps8',1,'2023-12-12 16:39:41.308875','2023-12-12 16:39:41.315183'),('ilUser8DBUpdateSteps',1,'2023-12-12 16:39:41.372439','2023-12-12 16:39:41.392529'),('ilUser8DBUpdateSteps',2,'2023-12-12 16:39:41.393125','2023-12-12 16:39:41.414590'),('ilUser8DBUpdateSteps',3,'2023-12-12 16:39:41.415252','2023-12-12 16:39:41.420387'),('ilUser8DBUpdateSteps',4,'2024-01-31 14:38:25.421546','2024-01-31 14:38:25.426800'),('ilUser8DBUpdateSteps',5,'2024-08-27 13:48:37.218362','2024-08-27 13:48:37.221598'),('ilUser8DBUpdateSteps',6,'2025-01-14 15:57:34.332515','2025-01-14 15:57:34.336442'),('ilUserDB90',1,'2023-12-12 16:39:41.421460','2023-12-12 16:39:41.427774'),('ilUserDB90',2,'2023-12-12 16:39:41.428399','2023-12-12 16:39:41.440313'),('ilUserDB90',3,'2023-12-12 16:39:41.441020','2023-12-12 16:39:41.446411'),('ilUserDB90',4,'2023-12-12 16:39:41.447095','2023-12-12 16:39:41.447652'),('ilUserDB90',5,'2023-12-12 16:39:41.448240','2023-12-12 16:39:41.453864'),('ilUserDB90',6,'2023-12-12 16:39:41.454487','2023-12-12 16:39:41.459460'),('ilUserDB90',7,'2023-12-12 16:39:41.460101','2023-12-12 16:39:41.470891'),('ilUserDB90',8,'2024-01-31 14:38:25.427561','2024-01-31 14:38:25.428274'),('ilUserDB90',9,'2024-04-30 15:11:09.040853','2024-04-30 15:11:09.041154'),('ilUserDB90',10,'2024-12-10 15:59:52.852443','2024-12-10 15:59:52.852735'),('ilWebResourceDBUpdateSteps',1,'2023-12-12 16:39:41.472042','2023-12-12 16:39:41.478899'),('ilWebResourceDropValidSteps',1,'2023-12-12 16:39:41.479938','2023-12-12 16:39:41.486502'),('ilWebResourceDropValidSteps',2,'2023-12-12 16:39:41.487110','2023-12-12 16:39:41.493529'),('ilWebResourceDropValidSteps',3,'2023-12-12 16:39:41.494136','2023-12-12 16:39:41.500293'),('ilWebResourceDropValidSteps',4,'2023-12-12 16:39:41.500904','2023-12-12 16:39:41.502972'),('ilWOPIDB90',1,'2023-12-12 16:39:38.616248','2023-12-12 16:39:38.629801'),('ilWOPIDB90',2,'2023-12-12 16:39:38.630407','2023-12-12 16:39:38.650076'),('ilWOPIDB90',3,'2024-05-17 13:25:33.945970','2024-05-17 13:25:33.948899'),('ilWOPIDB90',4,'2024-05-17 13:25:33.949334','2024-05-17 13:25:33.951124'),('ilWorkflowEngine9DBUpdateSteps',1,'2023-12-12 16:39:41.554740','2023-12-12 16:39:41.555315'),('ilWorkflowEngine9DBUpdateSteps',2,'2023-12-12 16:39:41.555897','2023-12-12 16:39:41.595930'),('ilWorkflowEngine9DBUpdateSteps',3,'2023-12-12 16:39:41.596587','2023-12-12 16:39:41.597086'),('ilWorkflowEngine9DBUpdateSteps',4,'2023-12-12 16:39:41.597674','2023-12-12 16:39:41.601575');

--
-- Table structure for table `il_dcl_data`
--

CREATE TABLE `il_dcl_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` tinyint(4) DEFAULT NULL,
  `rating` tinyint(4) DEFAULT NULL,
  `public_notes` tinyint(4) DEFAULT NULL,
  `approval` tinyint(4) DEFAULT NULL,
  `notification` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_data`
--


--
-- Table structure for table `il_dcl_data_seq`
--

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

--
-- Dumping data for table `il_dcl_data_seq`
--


--
-- Table structure for table `il_dcl_datatype`
--

CREATE TABLE `il_dcl_datatype` (
  `id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(256) DEFAULT NULL,
  `storage_location` int(11) NOT NULL DEFAULT '0',
  `sort` smallint(6) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_datatype`
--

INSERT INTO `il_dcl_datatype` VALUES (1,'number',2,20),(2,'text',1,0),(3,'reference',1,80),(4,'boolean',2,30),(5,'date',3,40),(7,'rating',0,100),(8,'ilias_reference',2,90),(9,'mob',2,60),(11,'formula',0,110),(14,'text_selection',1,10),(15,'date_selection',1,50),(16,'file',1,75),(17,'copy',1,85);

--
-- Table structure for table `il_dcl_datatype_prop`
--

CREATE TABLE `il_dcl_datatype_prop` (
  `id` int(11) NOT NULL DEFAULT '0',
  `datatype_id` int(11) DEFAULT NULL,
  `title` varchar(256) DEFAULT NULL,
  `inputformat` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_datatype_prop`
--

INSERT INTO `il_dcl_datatype_prop` VALUES (1,2,'length',1),(2,2,'regex',2),(3,3,'table_id',1),(4,2,'url',4),(5,2,'text_area',4),(6,3,'reference_link',4),(7,9,'width',1),(8,9,'height',1),(9,8,'learning_progress',4),(10,8,'ILIAS_reference_link',4),(11,3,'multiple_selection',4),(12,11,'expression',2),(13,8,'display_action_menu',4),(14,2,'link_detail_page',4),(15,9,'link_detail_page',4);

--
-- Table structure for table `il_dcl_field`
--

CREATE TABLE `il_dcl_field` (
  `id` int(11) NOT NULL DEFAULT '0',
  `table_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(256) DEFAULT NULL,
  `description` longtext,
  `datatype_id` int(11) NOT NULL DEFAULT '0',
  `is_unique` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`datatype_id`),
  KEY `i2_idx` (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_field`
--


--
-- Table structure for table `il_dcl_field_prop`
--

CREATE TABLE `il_dcl_field_prop` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `field_id` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(4000) NOT NULL DEFAULT '',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`id`,`field_id`),
  KEY `i2_idx` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_field_prop`
--


--
-- Table structure for table `il_dcl_field_prop_seq`
--

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

--
-- Dumping data for table `il_dcl_field_prop_seq`
--


--
-- Table structure for table `il_dcl_field_seq`
--

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

--
-- Dumping data for table `il_dcl_field_seq`
--


--
-- Table structure for table `il_dcl_record`
--

CREATE TABLE `il_dcl_record` (
  `id` int(11) NOT NULL DEFAULT '0',
  `table_id` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `owner` int(11) NOT NULL DEFAULT '0',
  `last_edit_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_record`
--


--
-- Table structure for table `il_dcl_record_field`
--

CREATE TABLE `il_dcl_record_field` (
  `id` int(11) NOT NULL DEFAULT '0',
  `record_id` int(11) NOT NULL DEFAULT '0',
  `field_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`record_id`),
  KEY `i2_idx` (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_record_field`
--


--
-- Table structure for table `il_dcl_record_field_seq`
--

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

--
-- Dumping data for table `il_dcl_record_field_seq`
--


--
-- Table structure for table `il_dcl_record_seq`
--

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

--
-- Dumping data for table `il_dcl_record_seq`
--


--
-- Table structure for table `il_dcl_sel_opts`
--

CREATE TABLE `il_dcl_sel_opts` (
  `id` bigint(20) NOT NULL,
  `field_id` bigint(20) NOT NULL,
  `opt_id` bigint(20) NOT NULL,
  `sorting` bigint(20) NOT NULL,
  `value` varchar(4000) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`field_id`),
  KEY `i2_idx` (`opt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_sel_opts`
--


--
-- Table structure for table `il_dcl_sel_opts_seq`
--

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

--
-- Dumping data for table `il_dcl_sel_opts_seq`
--


--
-- Table structure for table `il_dcl_stloc1_default`
--

CREATE TABLE `il_dcl_stloc1_default` (
  `id` int(11) NOT NULL,
  `tview_set_id` int(11) DEFAULT NULL,
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc1_default`
--


--
-- Table structure for table `il_dcl_stloc1_default_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc1_default_seq`
--


--
-- Table structure for table `il_dcl_stloc1_value`
--

CREATE TABLE `il_dcl_stloc1_value` (
  `id` int(11) NOT NULL DEFAULT '0',
  `record_field_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`record_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc1_value`
--


--
-- Table structure for table `il_dcl_stloc1_value_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc1_value_seq`
--


--
-- Table structure for table `il_dcl_stloc2_default`
--

CREATE TABLE `il_dcl_stloc2_default` (
  `id` int(11) NOT NULL,
  `tview_set_id` int(11) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc2_default`
--


--
-- Table structure for table `il_dcl_stloc2_default_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc2_default_seq`
--


--
-- Table structure for table `il_dcl_stloc2_value`
--

CREATE TABLE `il_dcl_stloc2_value` (
  `id` int(11) NOT NULL DEFAULT '0',
  `record_field_id` int(11) NOT NULL DEFAULT '0',
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`record_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc2_value`
--


--
-- Table structure for table `il_dcl_stloc2_value_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc2_value_seq`
--


--
-- Table structure for table `il_dcl_stloc3_default`
--

CREATE TABLE `il_dcl_stloc3_default` (
  `id` int(11) NOT NULL,
  `tview_set_id` int(11) NOT NULL,
  `value` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc3_default`
--


--
-- Table structure for table `il_dcl_stloc3_default_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc3_default_seq`
--


--
-- Table structure for table `il_dcl_stloc3_value`
--

CREATE TABLE `il_dcl_stloc3_value` (
  `id` int(11) NOT NULL DEFAULT '0',
  `record_field_id` int(11) NOT NULL DEFAULT '0',
  `value` datetime DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`record_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_stloc3_value`
--


--
-- Table structure for table `il_dcl_stloc3_value_seq`
--

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

--
-- Dumping data for table `il_dcl_stloc3_value_seq`
--


--
-- Table structure for table `il_dcl_table`
--

CREATE TABLE `il_dcl_table` (
  `id` int(11) NOT NULL DEFAULT '0',
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(256) DEFAULT NULL,
  `add_perm` tinyint(4) NOT NULL DEFAULT '1',
  `edit_perm` tinyint(4) NOT NULL DEFAULT '1',
  `delete_perm` tinyint(4) NOT NULL DEFAULT '1',
  `edit_by_owner` tinyint(4) NOT NULL DEFAULT '1',
  `limited` tinyint(4) NOT NULL DEFAULT '0',
  `limit_start` datetime DEFAULT NULL,
  `limit_end` datetime DEFAULT NULL,
  `is_visible` tinyint(4) NOT NULL DEFAULT '1',
  `export_enabled` tinyint(4) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `default_sort_field_id` varchar(16) NOT NULL DEFAULT '0',
  `default_sort_field_order` varchar(4) NOT NULL DEFAULT 'asc',
  `public_comments` int(11) NOT NULL DEFAULT '0',
  `view_own_records_perm` int(11) NOT NULL DEFAULT '0',
  `delete_by_owner` tinyint(4) NOT NULL DEFAULT '0',
  `save_confirmation` tinyint(4) NOT NULL DEFAULT '0',
  `import_enabled` tinyint(4) NOT NULL DEFAULT '1',
  `table_order` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_table`
--


--
-- Table structure for table `il_dcl_table_seq`
--

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

--
-- Dumping data for table `il_dcl_table_seq`
--


--
-- Table structure for table `il_dcl_tableview`
--

CREATE TABLE `il_dcl_tableview` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `table_id` bigint(20) NOT NULL DEFAULT '0',
  `title` varchar(128) NOT NULL DEFAULT '',
  `roles` longtext,
  `description` varchar(128) NOT NULL DEFAULT '',
  `tableview_order` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `t1_idx` (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_tableview`
--


--
-- Table structure for table `il_dcl_tableview_seq`
--

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

--
-- Dumping data for table `il_dcl_tableview_seq`
--


--
-- Table structure for table `il_dcl_tfield_set`
--

CREATE TABLE `il_dcl_tfield_set` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `table_id` bigint(20) NOT NULL DEFAULT '0',
  `field` varchar(128) NOT NULL DEFAULT '',
  `field_order` bigint(20) DEFAULT NULL,
  `exportable` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `t2_idx` (`table_id`,`field`),
  KEY `i3_idx` (`field`),
  KEY `i4_idx` (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_tfield_set`
--


--
-- Table structure for table `il_dcl_tfield_set_seq`
--

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

--
-- Dumping data for table `il_dcl_tfield_set_seq`
--


--
-- Table structure for table `il_dcl_tview_set`
--

CREATE TABLE `il_dcl_tview_set` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `tableview_id` bigint(20) NOT NULL DEFAULT '0',
  `field` varchar(128) NOT NULL DEFAULT '',
  `visible` tinyint(4) NOT NULL DEFAULT '0',
  `in_filter` tinyint(4) NOT NULL DEFAULT '0',
  `filter_value` longtext,
  `filter_changeable` tinyint(4) NOT NULL DEFAULT '0',
  `default_value` varchar(255) DEFAULT NULL,
  `required_create` tinyint(4) NOT NULL DEFAULT '0',
  `locked_create` tinyint(4) NOT NULL DEFAULT '0',
  `visible_create` tinyint(4) NOT NULL DEFAULT '1',
  `visible_edit` tinyint(4) NOT NULL DEFAULT '1',
  `required_edit` tinyint(4) NOT NULL DEFAULT '0',
  `locked_edit` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`tableview_id`),
  KEY `i2_idx` (`field`),
  KEY `i3_idx` (`in_filter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_dcl_tview_set`
--


--
-- Table structure for table `il_dcl_tview_set_seq`
--

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

--
-- Dumping data for table `il_dcl_tview_set_seq`
--


--
-- Table structure for table `il_dcl_view_seq`
--

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

--
-- Dumping data for table `il_dcl_view_seq`
--


--
-- Table structure for table `il_exc_team`
--

CREATE TABLE `il_exc_team` (
  `id` int(11) NOT NULL DEFAULT '0',
  `ass_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ass_id`,`user_id`),
  KEY `i1_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_exc_team`
--


--
-- Table structure for table `il_exc_team_log`
--

CREATE TABLE `il_exc_team_log` (
  `log_id` int(11) NOT NULL DEFAULT '0',
  `team_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `details` varchar(500) DEFAULT NULL,
  `action` tinyint(4) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`log_id`),
  KEY `i1_idx` (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_exc_team_log`
--


--
-- Table structure for table `il_exc_team_log_seq`
--

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

--
-- Dumping data for table `il_exc_team_log_seq`
--


--
-- Table structure for table `il_exc_team_seq`
--

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

--
-- Dumping data for table `il_exc_team_seq`
--


--
-- Table structure for table `il_external_feed_block`
--

CREATE TABLE `il_external_feed_block` (
  `id` int(11) NOT NULL DEFAULT '0',
  `feed_url` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_external_feed_block`
--


--
-- Table structure for table `il_external_feed_block_seq`
--

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

--
-- Dumping data for table `il_external_feed_block_seq`
--


--
-- Table structure for table `il_file_icon`
--

CREATE TABLE `il_file_icon` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `active` tinyint(4) DEFAULT '0',
  `is_default_icon` tinyint(4) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_file_icon`
--

INSERT INTO `il_file_icon` VALUES ('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5',1,1),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd',1,1),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd',1,1),('fda3e76a-ee45-430f-af0b-a934434529df',1,1),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472',1,1),('fe5c3b76-d3ca-4411-8a57-385789647965',1,1),('327b9a87-b572-4519-bdfe-50467ade0447',1,1),('5a524454-3b69-4195-8931-21b024de22b2',1,1),('a6146782-fb59-4779-9860-adda3dff0df2',1,1),('903763d5-12bb-4d11-b044-fb23ece6fba8',1,1),('a784671e-f081-4dc3-8436-696ca1ac8b2f',1,1),('ee9edffd-fc7a-45bd-b673-bed0a22e64af',1,1),('67e3c2ac-02e7-442f-b816-b4259d4b60de',1,1),('f6294a87-964e-4548-b490-549a25a5abc4',1,1),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93',1,1),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b',1,1),('b5986965-13a0-4a69-b519-74c04068ba95',1,1),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8',1,1),('56af626b-47c3-4d24-b54c-faf111800c80',1,1),('62bb175e-a5e7-4673-bff6-e6c5b9510240',1,1),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e',1,1),('74ec6f4e-2ae8-416e-926e-911e064c659c',1,1),('0a47e262-6bac-40e4-9f3e-495d5a309e68',1,1),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe',1,1),('090c5356-ab97-440f-ab0e-7adeb5348f26',1,1),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1',1,1);

--
-- Table structure for table `il_file_icon_suffixes`
--

CREATE TABLE `il_file_icon_suffixes` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `suffix` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_file_icon_suffixes`
--

INSERT INTO `il_file_icon_suffixes` VALUES ('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5','avi'),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd','bmp'),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd','csv'),('fda3e76a-ee45-430f-af0b-a934434529df','docx'),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472','flv'),('fe5c3b76-d3ca-4411-8a57-385789647965','gif'),('327b9a87-b572-4519-bdfe-50467ade0447','ico'),('5a524454-3b69-4195-8931-21b024de22b2','jpg'),('a6146782-fb59-4779-9860-adda3dff0df2','md'),('903763d5-12bb-4d11-b044-fb23ece6fba8','mov'),('a784671e-f081-4dc3-8436-696ca1ac8b2f','mp3'),('ee9edffd-fc7a-45bd-b673-bed0a22e64af','mp4'),('67e3c2ac-02e7-442f-b816-b4259d4b60de','odp'),('f6294a87-964e-4548-b490-549a25a5abc4','ods'),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93','odt'),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b','pdf'),('b5986965-13a0-4a69-b519-74c04068ba95','png'),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8','pptx'),('56af626b-47c3-4d24-b54c-faf111800c80','rtf'),('62bb175e-a5e7-4673-bff6-e6c5b9510240','svg'),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e','tiff'),('74ec6f4e-2ae8-416e-926e-911e064c659c','txt'),('0a47e262-6bac-40e4-9f3e-495d5a309e68','wav'),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe','wma'),('090c5356-ab97-440f-ab0e-7adeb5348f26','xlsx'),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1','xml');

--
-- Table structure for table `il_gc_memcache_server`
--

CREATE TABLE `il_gc_memcache_server` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `status` tinyint(4) DEFAULT NULL,
  `host` varchar(256) DEFAULT NULL,
  `port` bigint(20) DEFAULT NULL,
  `weight` smallint(6) DEFAULT NULL,
  `flush_needed` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_gc_memcache_server`
--


--
-- Table structure for table `il_gc_memcache_server_seq`
--

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

--
-- Dumping data for table `il_gc_memcache_server_seq`
--


--
-- Table structure for table `il_html_block`
--

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

--
-- Dumping data for table `il_html_block`
--


--
-- Table structure for table `il_md_cpr_selections`
--

CREATE TABLE `il_md_cpr_selections` (
  `entry_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(128) DEFAULT NULL,
  `description` longtext,
  `copyright` longtext,
  `language` char(2) DEFAULT NULL,
  `costs` tinyint(4) NOT NULL DEFAULT '0',
  `cpr_restrictions` tinyint(4) NOT NULL DEFAULT '1',
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  `outdated` tinyint(4) NOT NULL DEFAULT '0',
  `position` tinyint(4) NOT NULL DEFAULT '0',
  `full_name` longtext,
  `link` longtext,
  `image_link` longtext,
  `alt_text` longtext,
  `migrated` int(11) DEFAULT '0',
  `image_file` longtext,
  PRIMARY KEY (`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_md_cpr_selections`
--

INSERT INTO `il_md_cpr_selections` VALUES (1,'Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc-nd/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by-nc-nd/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc-nd/4.0/\">Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License','http://creativecommons.org/licenses/by-nc-nd/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by-nc-nd.svg','Creative Commons License',1,NULL),(2,'Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc-sa/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc-sa/4.0/\">Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License','http://creativecommons.org/licenses/by-nc-sa/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by-nc-sa.svg','Creative Commons License',1,NULL),(3,'Creative Commons Attribution-NonCommercial 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by-nc/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nc/4.0/\">Creative Commons Attribution-NonCommercial 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution-NonCommercial 4.0 International License','http://creativecommons.org/licenses/by-nc/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by-nc.svg','Creative Commons License',1,NULL),(4,'Creative Commons Attribution-NoDerivatives 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nd/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by-nd/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by-nd/4.0/\">Creative Commons Attribution-NoDerivatives 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution-NoDerivatives 4.0 International License','http://creativecommons.org/licenses/by-nd/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by-nd.svg','Creative Commons License',1,NULL),(5,'Creative Commons Attribution-ShareAlike 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by-sa/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by-sa/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by-sa/4.0/\">Creative Commons Attribution-ShareAlike 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution-ShareAlike 4.0 International License','http://creativecommons.org/licenses/by-sa/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by-sa.svg','Creative Commons License',1,NULL),(6,'Creative Commons Attribution 4.0 International License','Creative Commons License','<a rel=\"license\" href=\"http://creativecommons.org/licenses/by/4.0/\"><img alt=\"Creative Commons License\" style=\"border-width:0\" src=\"https://i.creativecommons.org/l/by/4.0/88x31.png\" /></a><br />This work is licensed under a <a rel=\"license\" href=\"http://creativecommons.org/licenses/by/4.0/\">Creative Commons Attribution 4.0 International License</a>.','en',0,1,0,0,0,'Creative Commons Attribution 4.0 International License','http://creativecommons.org/licenses/by/4.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/by.svg','Creative Commons License',1,NULL),(7,'All rights reserved','The copyright holder reserves, or holds for their own use, all the rights provided by copyright law.','This work has all rights reserved by the owner.','en',0,1,1,0,0,'All rights reserved','','','',1,NULL),(8,'Public Domain','Creative work to which no exclusive intellectual property rights apply.',NULL,NULL,0,1,0,0,1,'Public Domain','http://creativecommons.org/publicdomain/zero/1.0/','https://mirrors.creativecommons.org/presskit/buttons/88x31/svg/cc-zero.svg','CC0',1,'');

--
-- Table structure for table `il_md_cpr_selections_seq`
--

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

--
-- Dumping data for table `il_md_cpr_selections_seq`
--

INSERT INTO `il_md_cpr_selections_seq` VALUES (9);

--
-- Table structure for table `il_media_cast_data`
--

CREATE TABLE `il_media_cast_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `is_online` tinyint(4) DEFAULT '0',
  `public_files` tinyint(4) DEFAULT '0',
  `downloadable` tinyint(4) DEFAULT '0',
  `def_access` tinyint(4) DEFAULT '0',
  `sortmode` tinyint(4) DEFAULT '3',
  `viewmode` varchar(20) DEFAULT NULL,
  `autoplaymode` tinyint(4) NOT NULL DEFAULT '0',
  `nr_initial_videos` tinyint(4) NOT NULL DEFAULT '0',
  `new_items_in_lp` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_media_cast_data`
--


--
-- Table structure for table `il_media_cast_data_ord`
--

CREATE TABLE `il_media_cast_data_ord` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL DEFAULT '0',
  `pos` mediumint(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_media_cast_data_ord`
--


--
-- Table structure for table `il_meta_annotation`
--

CREATE TABLE `il_meta_annotation` (
  `meta_annotation_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `entity` longtext,
  `a_date` longtext,
  `description` longtext,
  `description_language` char(2) DEFAULT NULL,
  `a_date_descr` longtext,
  `date_descr_lang` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`meta_annotation_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_annotation`
--


--
-- Table structure for table `il_meta_annotation_seq`
--

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

--
-- Dumping data for table `il_meta_annotation_seq`
--


--
-- Table structure for table `il_meta_classification`
--

CREATE TABLE `il_meta_classification` (
  `meta_classification_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `purpose` varchar(32) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `description_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_classification_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_classification`
--


--
-- Table structure for table `il_meta_classification_seq`
--

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

--
-- Dumping data for table `il_meta_classification_seq`
--


--
-- Table structure for table `il_meta_context`
--

CREATE TABLE `il_meta_context` (
  `meta_context_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `context` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`meta_context_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_context`
--


--
-- Table structure for table `il_meta_context_seq`
--

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

--
-- Dumping data for table `il_meta_context_seq`
--


--
-- Table structure for table `il_meta_contribute`
--

CREATE TABLE `il_meta_contribute` (
  `meta_contribute_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(32) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `role` varchar(32) DEFAULT NULL,
  `c_date` varchar(4000) DEFAULT NULL,
  `c_date_descr` longtext,
  `descr_lang` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`meta_contribute_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_contribute`
--


--
-- Table structure for table `il_meta_contribute_seq`
--

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

--
-- Dumping data for table `il_meta_contribute_seq`
--


--
-- Table structure for table `il_meta_coverage`
--

CREATE TABLE `il_meta_coverage` (
  `meta_coverage_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `coverage` varchar(4000) DEFAULT NULL,
  `coverage_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_coverage_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_coverage`
--


--
-- Table structure for table `il_meta_coverage_seq`
--

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

--
-- Dumping data for table `il_meta_coverage_seq`
--


--
-- Table structure for table `il_meta_description`
--

CREATE TABLE `il_meta_description` (
  `meta_description_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `description` longtext,
  `description_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_description_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_description`
--


--
-- Table structure for table `il_meta_description_seq`
--

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

--
-- Dumping data for table `il_meta_description_seq`
--


--
-- Table structure for table `il_meta_educational`
--

CREATE TABLE `il_meta_educational` (
  `meta_educational_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `interactivity_type` varchar(16) DEFAULT NULL,
  `learning_resource_type` varchar(32) DEFAULT NULL,
  `interactivity_level` varchar(16) DEFAULT NULL,
  `semantic_density` varchar(16) DEFAULT NULL,
  `intended_end_user_role` varchar(16) DEFAULT NULL,
  `context` varchar(16) DEFAULT NULL,
  `difficulty` varchar(16) DEFAULT NULL,
  `typical_learning_time` varchar(4000) DEFAULT NULL,
  `tlt_descr` longtext,
  `tlt_descr_lang` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`meta_educational_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_educational`
--


--
-- Table structure for table `il_meta_educational_seq`
--

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

--
-- Dumping data for table `il_meta_educational_seq`
--


--
-- Table structure for table `il_meta_end_usr_role`
--

CREATE TABLE `il_meta_end_usr_role` (
  `meta_end_usr_role_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `intended_end_user_role` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`meta_end_usr_role_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_end_usr_role`
--


--
-- Table structure for table `il_meta_end_usr_role_seq`
--

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

--
-- Dumping data for table `il_meta_end_usr_role_seq`
--


--
-- Table structure for table `il_meta_entity`
--

CREATE TABLE `il_meta_entity` (
  `meta_entity_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `entity` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`meta_entity_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_entity`
--


--
-- Table structure for table `il_meta_entity_seq`
--

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

--
-- Dumping data for table `il_meta_entity_seq`
--


--
-- Table structure for table `il_meta_format`
--

CREATE TABLE `il_meta_format` (
  `meta_format_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`meta_format_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`),
  KEY `i2_idx` (`format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_format`
--


--
-- Table structure for table `il_meta_format_seq`
--

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

--
-- Dumping data for table `il_meta_format_seq`
--


--
-- Table structure for table `il_meta_general`
--

CREATE TABLE `il_meta_general` (
  `meta_general_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `general_structure` varchar(16) DEFAULT NULL,
  `title` varchar(4000) DEFAULT NULL,
  `title_language` char(2) DEFAULT NULL,
  `coverage` varchar(4000) DEFAULT NULL,
  `coverage_language` char(2) DEFAULT NULL,
  `general_aggl` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`meta_general_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_general`
--


--
-- Table structure for table `il_meta_general_seq`
--

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

--
-- Dumping data for table `il_meta_general_seq`
--


--
-- Table structure for table `il_meta_identifier`
--

CREATE TABLE `il_meta_identifier` (
  `meta_identifier_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `catalog` varchar(4000) DEFAULT NULL,
  `entry` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`meta_identifier_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_identifier`
--


--
-- Table structure for table `il_meta_identifier_`
--

CREATE TABLE `il_meta_identifier_` (
  `meta_identifier__id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `catalog` varchar(4000) DEFAULT NULL,
  `entry` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`meta_identifier__id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_identifier_`
--


--
-- Table structure for table `il_meta_identifier__seq`
--

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

--
-- Dumping data for table `il_meta_identifier__seq`
--


--
-- Table structure for table `il_meta_identifier_seq`
--

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

--
-- Dumping data for table `il_meta_identifier_seq`
--


--
-- Table structure for table `il_meta_keyword`
--

CREATE TABLE `il_meta_keyword` (
  `meta_keyword_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(32) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `keyword` varchar(4000) DEFAULT NULL,
  `keyword_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_keyword_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_keyword`
--


--
-- Table structure for table `il_meta_keyword_seq`
--

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

--
-- Dumping data for table `il_meta_keyword_seq`
--


--
-- Table structure for table `il_meta_language`
--

CREATE TABLE `il_meta_language` (
  `meta_language_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` char(6) DEFAULT NULL,
  `parent_type` char(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_language_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_language`
--


--
-- Table structure for table `il_meta_language_seq`
--

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

--
-- Dumping data for table `il_meta_language_seq`
--


--
-- Table structure for table `il_meta_lifecycle`
--

CREATE TABLE `il_meta_lifecycle` (
  `meta_lifecycle_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `lifecycle_status` varchar(16) DEFAULT NULL,
  `meta_version` varchar(4000) DEFAULT NULL,
  `version_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_lifecycle_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_lifecycle`
--


--
-- Table structure for table `il_meta_lifecycle_seq`
--

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

--
-- Dumping data for table `il_meta_lifecycle_seq`
--


--
-- Table structure for table `il_meta_location`
--

CREATE TABLE `il_meta_location` (
  `meta_location_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `location` varchar(4000) DEFAULT NULL,
  `location_type` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`meta_location_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_location`
--


--
-- Table structure for table `il_meta_location_seq`
--

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

--
-- Dumping data for table `il_meta_location_seq`
--


--
-- Table structure for table `il_meta_lr_type`
--

CREATE TABLE `il_meta_lr_type` (
  `meta_lr_type_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `learning_resource_type` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`meta_lr_type_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_lr_type`
--


--
-- Table structure for table `il_meta_lr_type_seq`
--

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

--
-- Dumping data for table `il_meta_lr_type_seq`
--


--
-- Table structure for table `il_meta_meta_data`
--

CREATE TABLE `il_meta_meta_data` (
  `meta_meta_data_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` char(6) DEFAULT NULL,
  `meta_data_scheme` char(16) DEFAULT NULL,
  `language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_meta_data_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_meta_data`
--


--
-- Table structure for table `il_meta_meta_data_seq`
--

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

--
-- Dumping data for table `il_meta_meta_data_seq`
--


--
-- Table structure for table `il_meta_meta_schema`
--

CREATE TABLE `il_meta_meta_schema` (
  `meta_meta_schema_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `meta_data_schema` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`meta_meta_schema_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_meta_schema`
--


--
-- Table structure for table `il_meta_meta_schema_seq`
--

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

--
-- Dumping data for table `il_meta_meta_schema_seq`
--


--
-- Table structure for table `il_meta_oer_stat`
--

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

--
-- Dumping data for table `il_meta_oer_stat`
--


--
-- Table structure for table `il_meta_or_composite`
--

CREATE TABLE `il_meta_or_composite` (
  `meta_or_composite_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `type` varchar(16) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `min_version` varchar(255) DEFAULT NULL,
  `max_version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`meta_or_composite_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_or_composite`
--


--
-- Table structure for table `il_meta_or_composite_seq`
--

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

--
-- Dumping data for table `il_meta_or_composite_seq`
--


--
-- Table structure for table `il_meta_relation`
--

CREATE TABLE `il_meta_relation` (
  `meta_relation_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` char(6) DEFAULT NULL,
  `kind` char(16) DEFAULT NULL,
  PRIMARY KEY (`meta_relation_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_relation`
--


--
-- Table structure for table `il_meta_relation_seq`
--

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

--
-- Dumping data for table `il_meta_relation_seq`
--


--
-- Table structure for table `il_meta_requirement`
--

CREATE TABLE `il_meta_requirement` (
  `meta_requirement_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `operating_system_name` varchar(16) DEFAULT NULL,
  `os_min_version` char(255) DEFAULT NULL,
  `os_max_version` char(255) DEFAULT NULL,
  `browser_name` varchar(32) DEFAULT NULL,
  `browser_minimum_version` char(255) DEFAULT NULL,
  `browser_maximum_version` char(255) DEFAULT NULL,
  `or_composite_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`meta_requirement_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_requirement`
--


--
-- Table structure for table `il_meta_requirement_seq`
--

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

--
-- Dumping data for table `il_meta_requirement_seq`
--


--
-- Table structure for table `il_meta_rights`
--

CREATE TABLE `il_meta_rights` (
  `meta_rights_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `costs` char(3) DEFAULT NULL,
  `cpr_and_or` char(3) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `description_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_rights_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_rights`
--


--
-- Table structure for table `il_meta_rights_seq`
--

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

--
-- Dumping data for table `il_meta_rights_seq`
--


--
-- Table structure for table `il_meta_tar`
--

CREATE TABLE `il_meta_tar` (
  `meta_tar_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(16) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `typical_age_range` varchar(4000) DEFAULT NULL,
  `tar_language` char(2) DEFAULT NULL,
  `tar_min` char(2) DEFAULT NULL,
  `tar_max` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_tar_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_tar`
--


--
-- Table structure for table `il_meta_tar_seq`
--

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

--
-- Dumping data for table `il_meta_tar_seq`
--


--
-- Table structure for table `il_meta_taxon`
--

CREATE TABLE `il_meta_taxon` (
  `meta_taxon_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(32) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `taxon` varchar(4000) DEFAULT NULL,
  `taxon_language` char(2) DEFAULT NULL,
  `taxon_id` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`meta_taxon_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_taxon`
--


--
-- Table structure for table `il_meta_taxon_path`
--

CREATE TABLE `il_meta_taxon_path` (
  `meta_taxon_path_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `parent_type` varchar(32) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `source` varchar(4000) DEFAULT NULL,
  `source_language` char(2) DEFAULT NULL,
  PRIMARY KEY (`meta_taxon_path_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_taxon_path`
--


--
-- Table structure for table `il_meta_taxon_path_seq`
--

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

--
-- Dumping data for table `il_meta_taxon_path_seq`
--


--
-- Table structure for table `il_meta_taxon_seq`
--

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

--
-- Dumping data for table `il_meta_taxon_seq`
--


--
-- Table structure for table `il_meta_technical`
--

CREATE TABLE `il_meta_technical` (
  `meta_technical_id` int(11) NOT NULL DEFAULT '0',
  `rbac_id` int(11) DEFAULT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` varchar(6) DEFAULT NULL,
  `t_size` varchar(4000) DEFAULT NULL,
  `ir` varchar(4000) DEFAULT NULL,
  `ir_language` char(2) DEFAULT NULL,
  `opr` varchar(4000) DEFAULT NULL,
  `opr_language` char(2) DEFAULT NULL,
  `duration` varchar(4000) DEFAULT NULL,
  `duration_descr` longtext,
  `duration_descr_lang` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`meta_technical_id`),
  KEY `i1_idx` (`rbac_id`,`obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_meta_technical`
--


--
-- Table structure for table `il_meta_technical_seq`
--

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

--
-- Dumping data for table `il_meta_technical_seq`
--


--
-- Table structure for table `il_mm_actions`
--

CREATE TABLE `il_mm_actions` (
  `identification` varchar(255) NOT NULL,
  `action` varchar(4000) DEFAULT NULL,
  `external` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`identification`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_mm_actions`
--


--
-- Table structure for table `il_mm_custom_items`
--

CREATE TABLE `il_mm_custom_items` (
  `identifier` varchar(255) NOT NULL,
  `type` varchar(128) DEFAULT NULL,
  `action` varchar(4000) DEFAULT NULL,
  `top_item` tinyint(4) DEFAULT NULL,
  `default_title` varchar(4000) DEFAULT NULL,
  `role_based_visibility` tinyint(4) DEFAULT '0',
  `global_role_ids` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_mm_custom_items`
--


--
-- Table structure for table `il_mm_items`
--

CREATE TABLE `il_mm_items` (
  `identification` varchar(255) NOT NULL DEFAULT '',
  `active` tinyint(4) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `parent_identification` varchar(255) DEFAULT NULL,
  `icon_id` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`identification`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_mm_items`
--


--
-- Table structure for table `il_mm_translation`
--

CREATE TABLE `il_mm_translation` (
  `id` varchar(255) NOT NULL,
  `identification` varchar(255) DEFAULT NULL,
  `translation` varchar(4000) DEFAULT NULL,
  `language_key` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_mm_translation`
--


--
-- Table structure for table `il_new_item_grp`
--

CREATE TABLE `il_new_item_grp` (
  `id` int(11) NOT NULL DEFAULT '0',
  `titles` varchar(1000) DEFAULT NULL,
  `pos` smallint(6) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_new_item_grp`
--


--
-- Table structure for table `il_new_item_grp_seq`
--

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

--
-- Dumping data for table `il_new_item_grp_seq`
--


--
-- Table structure for table `il_news_item`
--

CREATE TABLE `il_news_item` (
  `id` int(11) NOT NULL DEFAULT '0',
  `priority` int(11) DEFAULT '1',
  `title` varchar(200) DEFAULT NULL,
  `content` longtext,
  `context_obj_id` int(11) DEFAULT NULL,
  `context_obj_type` varchar(10) DEFAULT NULL,
  `context_sub_obj_id` int(11) DEFAULT NULL,
  `context_sub_obj_type` varchar(10) DEFAULT NULL,
  `content_type` char(5) DEFAULT 'text',
  `creation_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `visibility` char(6) DEFAULT 'users',
  `content_long` longtext,
  `content_is_lang_var` tinyint(4) DEFAULT '0',
  `mob_id` int(11) DEFAULT NULL,
  `playtime` varchar(8) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `content_text_is_lang_var` tinyint(4) NOT NULL DEFAULT '0',
  `mob_cnt_download` int(11) NOT NULL DEFAULT '0',
  `mob_cnt_play` int(11) NOT NULL DEFAULT '0',
  `content_html` tinyint(4) NOT NULL DEFAULT '0',
  `update_user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `i1_idx` (`context_obj_id`),
  KEY `i2_idx` (`creation_date`),
  KEY `mo_idx` (`mob_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_news_item`
--


--
-- Table structure for table `il_news_item_seq`
--

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

--
-- Dumping data for table `il_news_item_seq`
--


--
-- Table structure for table `il_news_read`
--

CREATE TABLE `il_news_read` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `news_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`news_id`),
  KEY `i1_idx` (`user_id`),
  KEY `i2_idx` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_news_read`
--


--
-- Table structure for table `il_news_subscription`
--

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

--
-- Dumping data for table `il_news_subscription`
--


--
-- Table structure for table `il_object_def`
--

CREATE TABLE `il_object_def` (
  `id` char(10) NOT NULL DEFAULT '',
  `class_name` varchar(200) DEFAULT NULL,
  `component` varchar(200) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  `checkbox` tinyint(4) NOT NULL DEFAULT '0',
  `inherit` tinyint(4) NOT NULL DEFAULT '0',
  `translate` char(5) DEFAULT NULL,
  `devmode` tinyint(4) NOT NULL DEFAULT '0',
  `allow_link` tinyint(4) NOT NULL DEFAULT '0',
  `allow_copy` tinyint(4) NOT NULL DEFAULT '0',
  `rbac` tinyint(4) NOT NULL DEFAULT '0',
  `system` tinyint(4) NOT NULL DEFAULT '0',
  `sideblock` tinyint(4) NOT NULL DEFAULT '0',
  `default_pos` int(11) NOT NULL DEFAULT '0',
  `grp` char(10) DEFAULT NULL,
  `default_pres_pos` int(11) NOT NULL DEFAULT '0',
  `export` tinyint(4) NOT NULL DEFAULT '0',
  `repository` tinyint(4) NOT NULL DEFAULT '1',
  `workspace` tinyint(4) NOT NULL DEFAULT '0',
  `administration` tinyint(4) NOT NULL DEFAULT '0',
  `amet` tinyint(4) NOT NULL DEFAULT '0',
  `orgunit_permissions` tinyint(4) NOT NULL DEFAULT '0',
  `lti_provider` tinyint(4) NOT NULL DEFAULT '0',
  `offline_handling` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_object_def`
--

INSERT INTO `il_object_def` VALUES ('accs','AccessibilitySettings','Services/Accessibility','Services/Accessibility/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('adm','SystemFolder','Modules/SystemFolder','Modules/SystemFolder/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('adn','AdministrativeNotification','Services/AdministrativeNotification','Services/AdministrativeNotification/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('adve','AdvancedEditing','Services/AdvancedEditing','Services/AdvancedEditing/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('assf','AssessmentFolder','Modules/Test','Modules/Test/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('auth','AuthSettings','Services/Authentication','Services/Authentication/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('awra','AwarenessAdministration','Services/Awareness','Services/Awareness/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('bdga','BadgeAdministration','Services/Badge','Services/Badge/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('bibl','Bibliographic','Modules/Bibliographic','Modules/Bibliographic/classes',1,1,'0',0,1,1,1,0,0,360,NULL,360,1,1,0,0,0,0,0,0),('bibs','BibliographicAdmin','Modules/Bibliographic','Modules/Bibliographic/classes/Admin',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('blga','BlogAdministration','Modules/Blog','Modules/Blog/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('blog','Blog','Modules/Blog','Modules/Blog/classes',1,1,'0',0,1,1,1,0,0,330,NULL,330,1,1,1,0,0,0,0,0),('book','BookingPool','Modules/BookingManager','Modules/BookingManager/classes',1,1,NULL,0,1,1,1,0,0,250,NULL,250,0,1,0,0,0,0,0,0),('cadm','ContactAdministration','Services/Contact','Services/Contact/classes',0,1,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('cals','CalendarSettings','Services/Calendar','Services/Calendar/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('cat','Category','Modules/Category','Modules/Category/classes',1,1,'db',0,0,1,1,0,0,10,'cat',10,1,1,0,0,1,0,0,0),('catr','CategoryReference','Modules/CategoryReference','Modules/CategoryReference/classes',1,0,'0',0,0,1,1,0,0,15,'cat',10,1,1,0,0,0,0,0,0),('cert','CertificateSettings','Services/Certificate','Services/Certificate/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('chta','ChatroomAdmin','Modules/Chatroom','Modules/Chatroom/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('chtr','Chatroom','Modules/Chatroom','Modules/Chatroom/classes',1,0,'0',0,1,1,1,0,0,90,NULL,150,0,1,0,0,0,0,0,1),('cld','Cloud','Modules/Cloud','Modules/Cloud/classes',1,1,'0',0,1,0,1,0,0,440,NULL,440,0,1,0,0,0,0,0,0),('cmis','CmiXapiAdministration','Modules/CmiXapi','Modules/CmiXapi/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('cmix','CmiXapi','Modules/CmiXapi','Modules/CmiXapi/classes',1,1,'db',0,1,1,1,0,0,120,'lres',0,1,1,0,0,0,0,0,1),('cmps','ComponentSettings','Services/Component','Services/Component/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('cmxv','CmiXapiVerification','Modules/CmiXapi','Modules/CmiXapi/classes/Verification',0,0,'0',0,0,0,0,0,0,90,NULL,150,0,0,0,0,0,0,0,0),('coms','CommentsSettings','Services/Notes','Services/Notes/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('copa','ContentPage','Modules/ContentPage','Modules/ContentPage/classes',1,1,'db',0,1,1,1,0,0,340,NULL,340,1,1,0,0,0,0,0,1),('cpad','ContentPageAdministration','Modules/ContentPage','Modules/ContentPage/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('crs','Course','Modules/Course','Modules/Course/classes',1,1,'db',0,0,1,1,0,0,20,'crs',30,1,1,0,0,1,1,1,1),('crsr','CourseReference','Modules/CourseReference','Modules/CourseReference/classes',1,0,'0',0,0,1,1,0,0,25,'crs',20,1,1,0,0,0,0,0,0),('crss','CourseAdministration','Modules/Course','Modules/Course/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('crsv','CourseVerification','Modules/Course','Modules/Course/classes/Verification',0,0,'0',0,0,0,0,0,0,90,NULL,150,0,0,0,0,0,0,0,0),('dcl','DataCollection','Modules/DataCollection','Modules/DataCollection/classes',1,1,'0',0,1,1,1,0,0,340,NULL,340,1,1,0,0,0,0,0,0),('dpro','DataProtection','Services/DataProtection','Services/DataProtection/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('dshs','DashboardSettings','Services/Dashboard','Services/Dashboard/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('ecss','ECSSettings','Services/WebServices','Services/WebServices/ECS/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('etal','EmployeeTalk','Modules/EmployeeTalk','Modules/EmployeeTalk/classes/Talk',1,1,'db',0,0,0,0,0,0,10,'tala',10,0,0,0,1,0,1,0,0),('exc','Exercise','Modules/Exercise','Modules/Exercise/classes',1,1,NULL,0,1,1,1,0,0,170,NULL,160,1,1,0,0,1,1,0,0),('excs','ExerciseAdministration','Modules/Exercise','Modules/Exercise/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('excv','ExerciseVerification','Modules/Exercise','Modules/Exercise/classes',0,0,'0',0,0,0,0,0,0,100,NULL,160,0,0,0,0,0,0,0,0),('extt','ExternalToolsSettings','Services/Administration','Services/Administration/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('facs','FileAccessSettings','Modules/File','Modules/File/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('file','File','Modules/File','Modules/File/classes',1,0,'0',0,1,1,1,0,0,90,NULL,150,1,1,1,0,1,0,0,0),('fils','FileServices','Services/FileServices','Services/FileServices/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('fold','Folder','Modules/Folder','Modules/Folder/classes',1,1,'db',0,0,1,1,0,0,40,NULL,20,1,1,0,0,0,0,0,0),('frm','Forum','Modules/Forum','Modules/Forum/classes',1,1,'0',0,1,1,1,0,0,70,NULL,90,1,1,0,0,0,0,0,1),('frma','ForumAdministration','Modules/Forum','Modules/Forum/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('glo','Glossary','Modules/Glossary','Modules/Glossary/classes',1,1,'0',0,1,1,1,0,0,160,NULL,110,1,1,0,0,0,0,0,0),('grp','Group','Modules/Group','Modules/Group/classes',1,1,'db',0,0,1,1,0,0,50,NULL,70,1,1,0,0,1,1,1,0),('grpr','GroupReference','Modules/GroupReference','Modules/GroupReference/classes',1,0,'0',0,0,1,1,0,0,51,'grp',20,1,1,0,0,0,0,0,0),('grps','GroupAdministration','Modules/Group','Modules/Group/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('hlps','HelpSettings','Services/Help','Services/Help/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('htlm','FileBasedLM','Modules/HTMLLearningModule','Modules/HTMLLearningModule/classes',1,1,'0',0,1,1,1,0,0,130,'lres',0,1,1,0,0,0,0,0,1),('iass','IndividualAssessment','Modules/IndividualAssessment','Modules/IndividualAssessment/classes',1,1,'0',0,1,1,1,0,0,190,NULL,190,1,1,0,0,1,1,0,1),('impr','LegalNotice','Services/Imprint','Services/Imprint/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('itgr','ItemGroup','Modules/ItemGroup','Modules/ItemGroup/classes',1,0,'db',0,0,1,1,0,0,45,NULL,5,1,1,0,0,0,0,0,0),('lhts','LearningHistorySettings','Services/LearningHistory','Services/LearningHistory/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('lm','LearningModule','Modules/LearningModule','Modules/LearningModule/classes',1,1,'db',0,1,1,1,0,0,120,'lres',0,1,1,0,0,0,0,1,1),('lng','Language','Services/Language','Services/Language/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,0,0,0,0,0),('lngf','LanguageFolder','Services/Language','Services/Language/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('logs','LoggingSettings','Services/Logging','Services/Logging/classes',0,1,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('lrss','LearningResourcesSettings','Modules/LearningModule','Modules/LearningModule/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('lso','LearningSequence','Modules/LearningSequence','Modules/LearningSequence/classes',1,1,'0',0,0,1,1,0,0,30,'lso',300,1,1,0,0,0,0,0,1),('lsos','LearningSequenceAdmin','Modules/LearningSequence','Modules/LearningSequence/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('lti','LTIConsumer','Modules/LTIConsumer','Modules/LTIConsumer/classes',1,1,'db',0,1,0,1,0,0,120,'lres',0,0,1,0,0,0,0,0,1),('ltis','LTIAdministration','Services/LTI','Services/LTI/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('ltiv','LTIConsumerVerification','Modules/LTIConsumer','Modules/LTIConsumer/classes/Verification',0,0,'0',0,0,0,0,0,0,90,NULL,150,0,0,0,0,0,0,0,0),('mail','Mail','Services/Mail','Services/Mail/classes',0,0,'sys',0,0,0,1,0,0,0,NULL,0,0,1,0,1,0,0,0,0),('mcst','MediaCast','Modules/MediaCast','Modules/MediaCast/classes',1,1,NULL,0,1,1,1,0,0,110,NULL,130,1,1,0,0,0,0,0,0),('mcts','MediaCastSettings','Modules/MediaCast','Modules/MediaCast/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('mds','MDSettings','Services/MetaData','Services/MetaData/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('mep','MediaPool','Modules/MediaPool','Modules/MediaPool/classes',1,1,'db',0,1,1,1,0,0,200,NULL,190,1,1,0,0,0,0,0,0),('mme','MainMenu','Services/MainMenu','Services/MainMenu/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('mobs','MediaObjectsSettings','Services/MediaObjects','Services/MediaObjects/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('nota','NotificationAdmin','Services/Notifications','Services/Notifications/classes',0,0,'sys',0,0,0,0,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('nots','NotesSettings','Services/Notes','Services/Notes/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('nwss','NewsSettings','Services/News','Services/News/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('objf','ObjectFolder','Services/Object','Services/Object/classes',0,0,'sys',1,0,0,1,1,0,0,NULL,0,0,1,0,0,0,0,0,0),('orgu','OrgUnit','Modules/OrgUnit','Modules/OrgUnit/classes',1,1,'db',0,0,0,1,0,0,10,'orgu',10,1,1,0,1,0,0,0,0),('otpl','ObjectTemplateAdministration','Services/DidacticTemplate','Services/DidacticTemplate/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('pdfg','PDFGeneration','Services/PDFGeneration','Services/PDFGeneration/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('poll','Poll','Modules/Poll','Modules/Poll/classes',1,1,'0',0,1,1,1,0,1,350,NULL,350,1,1,1,0,0,0,0,1),('prfa','PortfolioAdministration','Modules/Portfolio','Modules/Portfolio/Administration',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('prg','StudyProgramme','Modules/StudyProgramme','Modules/StudyProgramme/classes',1,1,'db',0,0,1,1,0,0,30,NULL,30,0,1,0,0,0,1,0,0),('prgr','StudyProgrammeReference','Modules/StudyProgrammeReference','Modules/StudyProgrammeReference/classes',1,0,'0',0,1,1,1,0,0,25,'prg',20,0,1,0,0,0,0,0,0),('prgs','StudyProgrammeAdmin','Modules/StudyProgramme','Modules/StudyProgramme/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('prss','PersonalWorkspaceSettings','Services/PersonalWorkspace','Services/PersonalWorkspace/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('prtf','Portfolio','Modules/Portfolio','Modules/Portfolio/classes',0,0,'0',0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0),('prtt','PortfolioTemplate','Modules/Portfolio','Modules/Portfolio/Template',1,0,'0',0,1,1,1,0,0,500,NULL,500,1,1,0,0,0,0,0,0),('ps','PrivacySecurity','Services/PrivacySecurity','Services/PrivacySecurity/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('qpl','QuestionPool','Modules/TestQuestionPool','Modules/TestQuestionPool/classes',1,1,'0',0,1,1,1,0,0,210,NULL,200,1,1,0,0,0,0,0,1),('rcat','RemoteCategory','Modules/RemoteCategory','Modules/RemoteCategory/classes',1,0,'0',0,1,1,1,0,0,30,'cat',40,0,0,0,0,0,0,0,0),('rcrs','RemoteCourse','Modules/RemoteCourse','Modules/RemoteCourse/classes',1,0,'0',0,1,1,1,0,0,30,'crs',40,0,0,0,0,1,0,0,0),('recf','RecoveryFolder','Services/Administration','Services/Administration/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('reps','RepositorySettings','Services/Repository','Services/Repository/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('rfil','RemoteFile','Modules/RemoteFile','Modules/RemoteFile/classes',1,0,'0',0,1,1,1,0,0,30,'file',40,0,0,0,0,0,0,0,0),('rglo','RemoteGlossary','Modules/RemoteGlossary','Modules/RemoteGlossary/classes',1,0,'0',0,1,1,1,0,0,30,'glo',40,0,0,0,0,0,0,0,0),('rgrp','RemoteGroup','Modules/RemoteGroup','Modules/RemoteGroup/classes',1,0,'0',0,1,1,1,0,0,30,'grp',40,0,0,0,0,0,0,0,0),('rlm','RemoteLearningModule','Modules/RemoteLearningModule','Modules/RemoteLearningModule/classes',1,0,'0',0,1,1,1,0,0,30,'lres',40,0,0,0,0,0,0,0,0),('role','Role','Services/AccessControl','Services/AccessControl/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,1,0,0,0,0),('rolf','RoleFolder','Services/AccessControl','Services/AccessControl/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('rolt','RoleTemplate','Services/AccessControl','Services/AccessControl/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,0,0,0,0,0),('root','RootFolder','Modules/RootFolder','Modules/RootFolder/classes',0,0,'0',0,0,0,1,1,0,0,NULL,0,0,1,0,0,0,0,0,0),('rtst','RemoteTest','Modules/RemoteTest','Modules/RemoteTest/classes',1,0,'0',0,1,1,1,0,0,30,'tst',40,0,0,0,0,0,0,0,0),('rwik','RemoteWiki','Modules/RemoteWiki','Modules/RemoteWiki/classes',1,0,'0',0,1,1,1,0,0,30,'wiki',40,0,0,0,0,0,0,0,0),('sahs','SAHSLearningModule','Modules/ScormAicc','Modules/ScormAicc/classes',1,1,'0',0,1,1,1,0,0,140,'lres',0,1,1,0,0,0,0,1,1),('scov','SCORMVerification','Modules/ScormAicc','Modules/ScormAicc/classes/Verification',0,0,'0',0,0,0,0,0,0,90,NULL,150,0,0,0,0,0,0,0,0),('seas','SearchSettings','Services/Search','Services/Search/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('sess','Session','Modules/Session','Modules/Session/classes',1,0,'0',0,0,1,1,0,0,15,NULL,15,1,1,0,0,1,0,0,0),('skee','SkillTree','Services/Skill','Services/Skill/Tree/classes',0,0,'0',0,0,0,1,0,0,0,NULL,0,0,1,0,1,0,0,0,0),('skmg','SkillManagement','Services/Skill','Services/Skill/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('spl','SurveyQuestionPool','Modules/SurveyQuestionPool','Modules/SurveyQuestionPool/classes',1,1,'0',0,1,1,1,0,0,220,NULL,210,1,1,0,0,0,0,0,0),('sty','StyleSheet','Services/Style','Services/Style/Content/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,0,0,0,0,0),('stys','StyleSettings','Services/Style','Services/Style/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('svy','Survey','Modules/Survey','Modules/Survey/classes',1,1,'0',0,1,1,1,0,0,190,NULL,180,1,1,0,0,0,1,1,1),('svyf','SurveyAdministration','Modules/Survey','Modules/Survey/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('sysc','SystemCheck','Services/SystemCheck','Services/SystemCheck/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('tags','TaggingSettings','Services/Tagging','Services/Tagging/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('tala','TalkTemplateAdministration','Modules/EmployeeTalk','Modules/EmployeeTalk/classes',0,0,'sys',0,0,0,1,1,0,0,'tala',0,0,0,0,1,0,0,0,0),('tals','EmployeeTalkSeries','Modules/EmployeeTalk','Modules/EmployeeTalk/classes/TalkSeries',1,1,'db',0,0,0,0,0,0,10,'tala',10,0,0,0,1,0,0,0,0),('talt','TalkTemplate','Modules/EmployeeTalk','Modules/EmployeeTalk/classes',1,1,'db',0,0,0,1,0,0,10,'tala',10,0,0,0,1,0,0,0,1),('tax','Taxonomy','Services/Taxonomy','Services/Taxonomy/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,0,0,0,0,0),('taxs','TaxonomyAdministration','Services/Taxonomy','Services/Taxonomy/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('tos','TermsOfService','Services/TermsOfService','Services/TermsOfService/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('trac','UserTracking','Services/Tracking','Services/Tracking/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('tst','Test','Modules/Test','Modules/Test/classes',1,1,'0',0,1,1,1,0,0,180,NULL,170,1,1,0,0,0,1,1,1),('tstv','TestVerification','Modules/Test','Modules/Test/classes',0,0,'0',0,0,0,0,0,0,90,NULL,150,0,0,0,0,0,0,0,0),('usr','User','Services/User','Services/User/classes',1,0,'0',0,0,0,0,0,0,0,NULL,0,0,1,0,0,0,0,0,0),('usrf','UserFolder','Services/User','Services/User/classes',0,1,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,1,0,0),('wbdv','WebDAV','Services/WebDAV','Services/WebDAV/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('wbrs','WebResourceAdministration','Modules/WebResource','Modules/WebResource/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('webr','LinkResource','Modules/WebResource','Modules/WebResource/classes',1,0,'0',0,1,1,1,0,0,100,NULL,120,1,1,1,0,0,0,0,0),('wfe','WorkflowEngine','Services/WorkflowEngine','Services/WorkflowEngine/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,0,0,0,0,0),('wfld','WorkspaceFolder','Modules/WorkspaceFolder','Modules/WorkspaceFolder/classes',1,1,'0',0,0,0,0,0,0,300,NULL,300,0,0,1,0,0,0,0,0),('wiki','Wiki','Modules/Wiki','Modules/Wiki/classes',1,1,NULL,0,1,1,1,0,0,115,NULL,140,1,1,0,0,0,0,1,0),('wiks','WikiSettings','Modules/Wiki','Modules/Wiki/classes',0,0,'sys',0,0,0,1,1,0,0,NULL,0,0,1,0,1,0,0,0,0),('wsrt','WorkspaceRootFolder','Modules/WorkspaceRootFolder','Modules/WorkspaceRootFolder/classes',0,0,'0',0,0,0,0,1,0,0,NULL,0,0,0,1,0,0,0,0,0);

--
-- Table structure for table `il_object_group`
--

CREATE TABLE `il_object_group` (
  `id` char(10) NOT NULL DEFAULT '',
  `name` varchar(200) DEFAULT NULL,
  `default_pres_pos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_object_group`
--

INSERT INTO `il_object_group` VALUES ('cat','Categories',10),('crs','Courses',30),('file','Files',150),('glo','Glossaries',110),('grp','Groups',70),('iass','IndividualAssessment',170),('lres','LearningResources',100),('lso','LearningSequence',300),('orgu','Organisational Unit',10),('prg','StudyProgramme',30),('tala','Employee Talk Templates',10),('tst','Tests',170),('wiki','Wikis',140);

--
-- Table structure for table `il_object_sub_type`
--

CREATE TABLE `il_object_sub_type` (
  `obj_type` varchar(10) NOT NULL DEFAULT '',
  `sub_type` varchar(10) NOT NULL DEFAULT '',
  `amet` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_type`,`sub_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_object_sub_type`
--

INSERT INTO `il_object_sub_type` VALUES ('book','bobj',1),('glo','term',1),('mep','mob',1),('mep','mpg',1),('orgu','orgu_type',1),('prg','prg_type',1),('prtf','pfpg',1),('prtt','pfpg',1),('tals','etal',1),('talt','etal',1),('wiki','wpg',1);

--
-- Table structure for table `il_object_subobj`
--

CREATE TABLE `il_object_subobj` (
  `parent` char(10) NOT NULL DEFAULT '',
  `subobj` char(10) NOT NULL DEFAULT '',
  `mmax` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`parent`,`subobj`),
  KEY `i1_idx` (`subobj`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_object_subobj`
--

INSERT INTO `il_object_subobj` VALUES ('adm','accs',1),('adm','adn',1),('adm','adve',1),('adm','assf',1),('adm','auth',1),('adm','awra',1),('adm','bdga',1),('adm','bibs',1),('adm','blga',1),('adm','cadm',1),('adm','cals',1),('adm','cert',1),('adm','chta',1),('adm','cmis',1),('adm','cmps',1),('adm','coms',1),('adm','cpad',1),('adm','crss',1),('adm','dpro',1),('adm','dshs',1),('adm','ecss',1),('adm','excs',1),('adm','extt',1),('adm','facs',1),('adm','fils',1),('adm','frma',1),('adm','grps',1),('adm','hlps',1),('adm','impr',1),('adm','lhts',1),('adm','lngf',1),('adm','logs',1),('adm','lrss',1),('adm','lsos',1),('adm','ltis',1),('adm','mail',1),('adm','mcts',1),('adm','mds',1),('adm','mme',1),('adm','mobs',1),('adm','nota',1),('adm','nots',1),('adm','nwss',1),('adm','objf',1),('adm','orgu',1),('adm','otpl',1),('adm','pdfg',1),('adm','prfa',1),('adm','prgs',1),('adm','prss',1),('adm','ps',1),('adm','recf',1),('adm','reps',1),('adm','rolf',0),('adm','seas',1),('adm','skmg',1),('adm','stys',1),('adm','svyf',1),('adm','sysc',1),('adm','tags',1),('adm','tala',1),('adm','taxs',1),('adm','tos',1),('adm','trac',1),('adm','usrf',1),('adm','wbdv',1),('adm','wbrs',1),('adm','wfe',1),('adm','wiks',1),('cat','bibl',0),('cat','blog',0),('cat','book',0),('cat','cat',0),('cat','catr',0),('cat','chtr',0),('cat','cld',0),('cat','cmix',0),('cat','copa',0),('cat','crs',0),('cat','crsr',0),('cat','dcl',0),('cat','exc',0),('cat','file',0),('cat','frm',0),('cat','glo',0),('cat','grp',0),('cat','grpr',0),('cat','htlm',0),('cat','iass',0),('cat','itgr',0),('cat','lm',0),('cat','lso',0),('cat','lti',0),('cat','mcst',0),('cat','mep',0),('cat','poll',0),('cat','prg',0),('cat','prgr',0),('cat','prtt',0),('cat','qpl',0),('cat','rcat',0),('cat','rcrs',0),('cat','rfil',0),('cat','rglo',0),('cat','rgrp',0),('cat','rlm',0),('cat','rtst',0),('cat','rwik',0),('cat','sahs',0),('cat','spl',0),('cat','svy',0),('cat','tst',0),('cat','webr',0),('cat','wiki',0),('crs','bibl',0),('crs','blog',0),('crs','book',0),('crs','catr',0),('crs','chtr',0),('crs','cld',0),('crs','cmix',0),('crs','copa',0),('crs','crsr',0),('crs','dcl',0),('crs','exc',0),('crs','file',0),('crs','fold',0),('crs','frm',0),('crs','glo',0),('crs','grp',0),('crs','grpr',0),('crs','htlm',0),('crs','iass',0),('crs','itgr',0),('crs','lm',0),('crs','lso',0),('crs','lti',0),('crs','mcst',0),('crs','mep',0),('crs','poll',0),('crs','prtt',0),('crs','qpl',0),('crs','rcat',0),('crs','rcrs',0),('crs','rgrp',0),('crs','sahs',0),('crs','sess',0),('crs','spl',0),('crs','svy',0),('crs','tst',0),('crs','webr',0),('crs','wiki',0),('fold','bibl',0),('fold','blog',0),('fold','book',0),('fold','chtr',0),('fold','cld',0),('fold','cmix',0),('fold','copa',0),('fold','dcl',0),('fold','exc',0),('fold','file',0),('fold','fold',0),('fold','frm',0),('fold','glo',0),('fold','grp',0),('fold','htlm',0),('fold','iass',0),('fold','itgr',0),('fold','lm',0),('fold','lso',0),('fold','lti',0),('fold','mcst',0),('fold','mep',0),('fold','poll',0),('fold','prtt',0),('fold','qpl',0),('fold','sahs',0),('fold','sess',0),('fold','spl',0),('fold','svy',0),('fold','tst',0),('fold','webr',0),('fold','wiki',0),('grp','bibl',0),('grp','blog',0),('grp','book',0),('grp','catr',0),('grp','chtr',0),('grp','cld',0),('grp','cmix',0),('grp','copa',0),('grp','crsr',0),('grp','dcl',0),('grp','exc',0),('grp','file',0),('grp','fold',0),('grp','frm',0),('grp','glo',0),('grp','grp',0),('grp','grpr',0),('grp','htlm',0),('grp','iass',0),('grp','itgr',0),('grp','lm',0),('grp','lso',0),('grp','lti',0),('grp','mcst',0),('grp','mep',0),('grp','poll',0),('grp','prtt',0),('grp','qpl',0),('grp','rcat',0),('grp','rcrs',0),('grp','rgrp',0),('grp','sahs',0),('grp','sess',0),('grp','spl',0),('grp','svy',0),('grp','tst',0),('grp','webr',0),('grp','wiki',0),('lngf','lng',0),('lso','copa',0),('lso','exc',0),('lso','file',0),('lso','htlm',0),('lso','iass',0),('lso','lm',0),('lso','rolf',1),('lso','sahs',0),('lso','svy',0),('lso','tst',0),('orgu','orgu',0),('prg','crsr',1),('prg','prg',0),('prg','prgr',0),('prg','rolf',1),('recf','bibl',0),('recf','blog',0),('recf','cat',0),('recf','catr',0),('recf','chtr',0),('recf','cld',0),('recf','cmix',0),('recf','copa',0),('recf','crs',0),('recf','crsr',0),('recf','dcl',0),('recf','exc',0),('recf','file',0),('recf','fold',0),('recf','frm',0),('recf','glo',0),('recf','grp',0),('recf','grpr',0),('recf','htlm',0),('recf','itgr',0),('recf','lm',0),('recf','lti',0),('recf','mcst',0),('recf','mep',0),('recf','poll',0),('recf','prg',0),('recf','prgr',0),('recf','prtt',0),('recf','qpl',0),('recf','sahs',0),('recf','sess',0),('recf','spl',0),('recf','svy',0),('recf','tst',0),('recf','webr',0),('recf','wiki',0),('rolf','role',0),('rolf','rolt',0),('root','adm',1),('root','bibl',0),('root','blog',0),('root','book',0),('root','cat',0),('root','catr',0),('root','chtr',0),('root','cld',0),('root','cmix',0),('root','copa',0),('root','crs',0),('root','crsr',0),('root','dcl',0),('root','exc',0),('root','file',0),('root','frm',0),('root','glo',0),('root','grp',0),('root','grpr',0),('root','htlm',0),('root','iass',0),('root','itgr',0),('root','lm',0),('root','lso',0),('root','lti',0),('root','mcst',0),('root','mep',0),('root','poll',0),('root','prg',0),('root','prgr',0),('root','prtt',0),('root','qpl',0),('root','rcat',0),('root','rcrs',0),('root','rfil',0),('root','rglo',0),('root','rgrp',0),('root','rlm',0),('root','rtst',0),('root','rwik',0),('root','sahs',0),('root','spl',0),('root','svy',0),('root','tst',0),('root','webr',0),('root','wiki',0),('skmg','skee',1),('stys','sty',0),('tala','tals',0),('tala','talt',0),('tals','etal',0),('usrf','usr',0),('wfld','blog',0),('wfld','cmxv',0),('wfld','crsv',0),('wfld','excv',0),('wfld','file',0),('wfld','ltiv',0),('wfld','scov',0),('wfld','tstv',0),('wfld','webr',0),('wfld','wfld',0),('wsrt','blog',0),('wsrt','cmxv',0),('wsrt','crsv',0),('wsrt','excv',0),('wsrt','file',0),('wsrt','ltiv',0),('wsrt','scov',0),('wsrt','tstv',0),('wsrt','webr',0),('wsrt','wfld',0);

--
-- Table structure for table `il_orgu_authority`
--

CREATE TABLE `il_orgu_authority` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `over` tinyint(4) DEFAULT NULL,
  `scope` tinyint(4) DEFAULT NULL,
  `position_id` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_authority`
--

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

--
-- Table structure for table `il_orgu_authority_seq`
--

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

--
-- Dumping data for table `il_orgu_authority_seq`
--

INSERT INTO `il_orgu_authority_seq` VALUES (1);

--
-- Table structure for table `il_orgu_op_contexts`
--

CREATE TABLE `il_orgu_op_contexts` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `context` varchar(16) DEFAULT NULL,
  `parent_context_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_op_contexts`
--

INSERT INTO `il_orgu_op_contexts` VALUES (1,'object',0),(2,'iass',1),(3,'crs',1),(4,'grp',1),(5,'tst',1),(6,'exc',1),(7,'svy',1),(8,'prg',1),(9,'usrf',1),(10,'etal',1);

--
-- Table structure for table `il_orgu_op_contexts_seq`
--

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

--
-- Dumping data for table `il_orgu_op_contexts_seq`
--

INSERT INTO `il_orgu_op_contexts_seq` VALUES (10);

--
-- Table structure for table `il_orgu_operations`
--

CREATE TABLE `il_orgu_operations` (
  `operation_id` bigint(20) NOT NULL DEFAULT '0',
  `operation_string` varchar(127) DEFAULT NULL,
  `description` varchar(512) DEFAULT NULL,
  `list_order` bigint(20) DEFAULT NULL,
  `context_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`operation_id`),
  KEY `i1_idx` (`operation_string`),
  KEY `i3_idx` (`list_order`),
  KEY `i4_idx` (`context_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_operations`
--

INSERT INTO `il_orgu_operations` VALUES (1,'read_learning_progress','Read the learning Progress of a User',0,3),(2,'read_learning_progress','Read the learning Progress of a User',0,4),(3,'read_learning_progress','Read the learning Progress of a User',0,2),(4,'read_learning_progress','Read the learning Progress of a User',0,6),(5,'read_learning_progress','Read the learning Progress of a User',0,7),(6,'manage_members','Edit Members in a course',0,3),(7,'manage_members','Edit Members in a group',0,4),(8,'edit_submissions_grades','',0,6),(9,'access_results','',0,7),(10,'write_learning_progress','Write the learning Progress of a User',0,2),(11,'access_enrolments','Access Enrolments in a course',0,3),(12,'read_learning_progress','Read Test Participants Learning Progress',0,5),(13,'access_results','Access Test Participants Results',0,5),(14,'manage_participants','Manage Test Participants',0,5),(15,'score_participants','Score Test Participants',0,5),(16,'view_members','View Memberships of other users',0,8),(17,'read_learning_progress','View learning progress of other users',0,8),(18,'view_individual_plan','View Individual Plans of other users',0,8),(19,'edit_individual_plan','Edit Individual Plans of other users',0,8),(20,'manage_members','Manage Memberships of other users',0,8),(21,'edit_user_accounts','Edit User in User Administration',0,9),(22,'view_certificates','Read the certificates of a User',0,5),(23,'view_certificates','Read the certificates of a User',0,6),(24,'view_certificates','Read the certificates of a User',0,3),(25,'view_competences','Read the competences of a User',0,5),(26,'view_competences','Read the competences of a User',0,4),(27,'view_competences','Read the competences of a User',0,3),(28,'view_competences','Read the competences of a User',0,7),(29,'read_employee_talk','Read Employee Talk',0,10),(30,'create_employee_talk','Create Employee Talk',0,10),(31,'edit_employee_talk','Edit Employee Talk (not only own)',0,10);

--
-- Table structure for table `il_orgu_operations_seq`
--

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

--
-- Dumping data for table `il_orgu_operations_seq`
--

INSERT INTO `il_orgu_operations_seq` VALUES (31);

--
-- Table structure for table `il_orgu_permissions`
--

CREATE TABLE `il_orgu_permissions` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `context_id` bigint(20) DEFAULT NULL,
  `operations` varchar(256) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `position_id` bigint(20) DEFAULT NULL,
  `protected` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `co_idx` (`context_id`),
  KEY `po_idx` (`position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_permissions`
--


--
-- Table structure for table `il_orgu_permissions_seq`
--

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

--
-- Dumping data for table `il_orgu_permissions_seq`
--


--
-- Table structure for table `il_orgu_positions`
--

CREATE TABLE `il_orgu_positions` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `title` varchar(512) DEFAULT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `core_position` tinyint(4) DEFAULT NULL,
  `core_identifier` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_positions`
--

INSERT INTO `il_orgu_positions` VALUES (1,'Employees','Employees of a OrgUnit',1,1),(2,'Superiors','Superiors of a OrgUnit',1,2);

--
-- Table structure for table `il_orgu_positions_seq`
--

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

--
-- Dumping data for table `il_orgu_positions_seq`
--

INSERT INTO `il_orgu_positions_seq` VALUES (2);

--
-- Table structure for table `il_orgu_ua`
--

CREATE TABLE `il_orgu_ua` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `user_id` bigint(20) DEFAULT NULL,
  `position_id` bigint(20) DEFAULT NULL,
  `orgu_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pi_idx` (`position_id`),
  KEY `ui_idx` (`user_id`),
  KEY `oi_idx` (`orgu_id`),
  KEY `po_idx` (`position_id`,`orgu_id`),
  KEY `pu_idx` (`position_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_orgu_ua`
--


--
-- Table structure for table `il_orgu_ua_seq`
--

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

--
-- Dumping data for table `il_orgu_ua_seq`
--


--
-- Table structure for table `il_plugin`
--

CREATE TABLE `il_plugin` (
  `last_update_version` char(10) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `db_version` int(11) NOT NULL DEFAULT '0',
  `plugin_id` varchar(20) NOT NULL,
  PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_plugin`
--


--
-- Table structure for table `il_poll`
--

CREATE TABLE `il_poll` (
  `id` int(11) NOT NULL DEFAULT '0',
  `question` varchar(1000) DEFAULT NULL,
  `image` varchar(1000) DEFAULT NULL,
  `view_results` tinyint(4) NOT NULL DEFAULT '3',
  `period` tinyint(4) NOT NULL DEFAULT '0',
  `period_begin` int(11) DEFAULT '0',
  `period_end` int(11) DEFAULT '0',
  `max_answers` tinyint(4) NOT NULL DEFAULT '1',
  `result_sort` tinyint(4) NOT NULL DEFAULT '0',
  `non_anon` tinyint(4) NOT NULL DEFAULT '0',
  `show_results_as` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_poll`
--


--
-- Table structure for table `il_poll_answer`
--

CREATE TABLE `il_poll_answer` (
  `id` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `answer` varchar(1000) DEFAULT NULL,
  `pos` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_poll_answer`
--


--
-- Table structure for table `il_poll_answer_seq`
--

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

--
-- Dumping data for table `il_poll_answer_seq`
--


--
-- Table structure for table `il_poll_vote`
--

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

--
-- Dumping data for table `il_poll_vote`
--


--
-- Table structure for table `il_qpl_qst_fq_res`
--

CREATE TABLE `il_qpl_qst_fq_res` (
  `result_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `result` varchar(255) DEFAULT NULL,
  `range_min` double NOT NULL DEFAULT '0',
  `range_max` double NOT NULL DEFAULT '0',
  `tolerance` double NOT NULL DEFAULT '0',
  `unit_fi` int(11) NOT NULL DEFAULT '0',
  `formula` longtext,
  `rating_simple` int(11) NOT NULL DEFAULT '1',
  `rating_sign` double NOT NULL DEFAULT '0.25',
  `rating_value` double NOT NULL DEFAULT '0.25',
  `rating_unit` double NOT NULL DEFAULT '0.25',
  `points` double NOT NULL DEFAULT '0',
  `resprecision` int(11) NOT NULL DEFAULT '0',
  `result_type` int(11) NOT NULL DEFAULT '0',
  `range_min_txt` varchar(4000) DEFAULT NULL,
  `range_max_txt` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`result_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_qpl_qst_fq_res`
--


--
-- Table structure for table `il_qpl_qst_fq_res_seq`
--

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

--
-- Dumping data for table `il_qpl_qst_fq_res_seq`
--


--
-- Table structure for table `il_qpl_qst_fq_res_unit`
--

CREATE TABLE `il_qpl_qst_fq_res_unit` (
  `result_unit_id` int(11) NOT NULL DEFAULT '0',
  `result` varchar(255) DEFAULT NULL,
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `unit_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`result_unit_id`),
  KEY `i1_idx` (`question_fi`,`unit_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_qpl_qst_fq_res_unit`
--


--
-- Table structure for table `il_qpl_qst_fq_res_unit_seq`
--

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

--
-- Dumping data for table `il_qpl_qst_fq_res_unit_seq`
--


--
-- Table structure for table `il_qpl_qst_fq_ucat`
--

CREATE TABLE `il_qpl_qst_fq_ucat` (
  `category_id` int(11) NOT NULL DEFAULT '0',
  `category` varchar(255) DEFAULT NULL,
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_qpl_qst_fq_ucat`
--


--
-- Table structure for table `il_qpl_qst_fq_ucat_seq`
--

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

--
-- Dumping data for table `il_qpl_qst_fq_ucat_seq`
--


--
-- Table structure for table `il_qpl_qst_fq_unit`
--

CREATE TABLE `il_qpl_qst_fq_unit` (
  `unit_id` int(11) NOT NULL DEFAULT '0',
  `unit` varchar(255) DEFAULT NULL,
  `factor` double NOT NULL DEFAULT '0',
  `baseunit_fi` int(11) NOT NULL DEFAULT '0',
  `category_fi` int(11) NOT NULL DEFAULT '0',
  `sequence` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`unit_id`),
  KEY `i2_idx` (`question_fi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_qpl_qst_fq_unit`
--


--
-- Table structure for table `il_qpl_qst_fq_unit_seq`
--

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

--
-- Dumping data for table `il_qpl_qst_fq_unit_seq`
--


--
-- Table structure for table `il_qpl_qst_fq_var`
--

CREATE TABLE `il_qpl_qst_fq_var` (
  `variable_id` int(11) NOT NULL DEFAULT '0',
  `question_fi` int(11) NOT NULL DEFAULT '0',
  `variable` varchar(255) DEFAULT NULL,
  `range_min` double NOT NULL DEFAULT '0',
  `range_max` double NOT NULL DEFAULT '0',
  `unit_fi` int(11) NOT NULL DEFAULT '0',
  `step_dim_min` int(11) NOT NULL DEFAULT '0',
  `step_dim_max` int(11) NOT NULL DEFAULT '0',
  `varprecision` int(11) NOT NULL DEFAULT '0',
  `intprecision` int(11) NOT NULL DEFAULT '1',
  `range_min_txt` varchar(4000) DEFAULT NULL,
  `range_max_txt` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`variable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_qpl_qst_fq_var`
--


--
-- Table structure for table `il_qpl_qst_fq_var_seq`
--

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

--
-- Dumping data for table `il_qpl_qst_fq_var_seq`
--


--
-- Table structure for table `il_rating`
--

CREATE TABLE `il_rating` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` char(10) NOT NULL DEFAULT '',
  `sub_obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_obj_type` char(10) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
  `category_id` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`obj_id`,`obj_type`,`sub_obj_id`,`sub_obj_type`,`user_id`,`category_id`),
  KEY `obj_idx` (`obj_id`,`obj_type`,`sub_obj_id`,`sub_obj_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_rating`
--


--
-- Table structure for table `il_rating_cat`
--

CREATE TABLE `il_rating_cat` (
  `id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `pos` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_rating_cat`
--


--
-- Table structure for table `il_rating_cat_seq`
--

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

--
-- Dumping data for table `il_rating_cat_seq`
--


--
-- Table structure for table `il_resource`
--

CREATE TABLE `il_resource` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `storage_id` varchar(8) NOT NULL DEFAULT '',
  `rtype` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rid`),
  KEY `i1_idx` (`storage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource`
--

INSERT INTO `il_resource` VALUES ('090c5356-ab97-440f-ab0e-7adeb5348f26','fsv2',1),('0a47e262-6bac-40e4-9f3e-495d5a309e68','fsv2',1),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b','fsv2',1),('327b9a87-b572-4519-bdfe-50467ade0447','fsv2',1),('56af626b-47c3-4d24-b54c-faf111800c80','fsv2',1),('5a524454-3b69-4195-8931-21b024de22b2','fsv2',1),('62bb175e-a5e7-4673-bff6-e6c5b9510240','fsv2',1),('67e3c2ac-02e7-442f-b816-b4259d4b60de','fsv2',1),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93','fsv2',1),('74ec6f4e-2ae8-416e-926e-911e064c659c','fsv2',1),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe','fsv2',1),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd','fsv2',1),('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5','fsv2',1),('903763d5-12bb-4d11-b044-fb23ece6fba8','fsv2',1),('a6146782-fb59-4779-9860-adda3dff0df2','fsv2',1),('a784671e-f081-4dc3-8436-696ca1ac8b2f','fsv2',1),('b5986965-13a0-4a69-b519-74c04068ba95','fsv2',1),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd','fsv2',1),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1','fsv2',1),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472','fsv2',1),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8','fsv2',1),('ee9edffd-fc7a-45bd-b673-bed0a22e64af','fsv2',1),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e','fsv2',1),('f6294a87-964e-4548-b490-549a25a5abc4','fsv2',1),('fda3e76a-ee45-430f-af0b-a934434529df','fsv2',1),('fe5c3b76-d3ca-4411-8a57-385789647965','fsv2',1);

--
-- Table structure for table `il_resource_flavour`
--

CREATE TABLE `il_resource_flavour` (
  `rid` varchar(64) NOT NULL,
  `revision` bigint(20) NOT NULL,
  `definition_id` varchar(64) NOT NULL,
  `variant` varchar(768) NOT NULL,
  PRIMARY KEY (`rid`,`revision`,`definition_id`,`variant`),
  KEY `i1_idx` (`rid`),
  KEY `i3_idx` (`definition_id`),
  KEY `i4_idx` (`variant`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_flavour`
--


--
-- Table structure for table `il_resource_info`
--

CREATE TABLE `il_resource_info` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `suffix` varchar(64) DEFAULT NULL,
  `mime_type` varchar(250) DEFAULT NULL,
  `size` bigint(20) NOT NULL DEFAULT '0',
  `creation_date` bigint(20) NOT NULL DEFAULT '0',
  `version_number` bigint(20) NOT NULL,
  PRIMARY KEY (`rid`,`version_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_info`
--

INSERT INTO `il_resource_info` VALUES ('090c5356-ab97-440f-ab0e-7adeb5348f26','icon_file_xlsx.svg','svg','image/svg+xml',3146,[[timestamp]],1),('0a47e262-6bac-40e4-9f3e-495d5a309e68','icon_file_wav.svg','svg','image/svg+xml',3146,[[timestamp]],1),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b','icon_file_pdf.svg','svg','image/svg+xml',3145,[[timestamp]],1),('327b9a87-b572-4519-bdfe-50467ade0447','icon_file_ico.svg','svg','image/svg+xml',3146,[[timestamp]],1),('56af626b-47c3-4d24-b54c-faf111800c80','icon_file_rtf.svg','svg','image/svg+xml',3145,[[timestamp]],1),('5a524454-3b69-4195-8931-21b024de22b2','icon_file_jpg.svg','svg','image/svg+xml',3145,[[timestamp]],1),('62bb175e-a5e7-4673-bff6-e6c5b9510240','icon_file_svg.svg','svg','image/svg+xml',3145,[[timestamp]],1),('67e3c2ac-02e7-442f-b816-b4259d4b60de','icon_file_odp.svg','svg','image/svg+xml',3146,[[timestamp]],1),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93','icon_file_odt.svg','svg','image/svg+xml',3146,[[timestamp]],1),('74ec6f4e-2ae8-416e-926e-911e064c659c','icon_file_txt.svg','svg','image/svg+xml',3145,[[timestamp]],1),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe','icon_file_wma.svg','svg','image/svg+xml',3145,[[timestamp]],1),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd','icon_file_bmp.svg','svg','image/svg+xml',3146,[[timestamp]],1),('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5','icon_file_avi.svg','svg','image/svg+xml',3146,[[timestamp]],1),('903763d5-12bb-4d11-b044-fb23ece6fba8','icon_file_mov.svg','svg','image/svg+xml',3146,[[timestamp]],1),('a6146782-fb59-4779-9860-adda3dff0df2','icon_file_md.svg','svg','image/svg+xml',3143,[[timestamp]],1),('a784671e-f081-4dc3-8436-696ca1ac8b2f','icon_file_mp3.svg','svg','image/svg+xml',3146,[[timestamp]],1),('b5986965-13a0-4a69-b519-74c04068ba95','icon_file_png.svg','svg','image/svg+xml',3145,[[timestamp]],1),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd','icon_file_csv.svg','svg','image/svg+xml',3146,[[timestamp]],1),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1','icon_file_xml.svg','svg','image/svg+xml',3146,[[timestamp]],1),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472','icon_file_flv.svg','svg','image/svg+xml',3146,[[timestamp]],1),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8','icon_file_pptx.svg','svg','image/svg+xml',3145,[[timestamp]],1),('ee9edffd-fc7a-45bd-b673-bed0a22e64af','icon_file_mp4.svg','svg','image/svg+xml',3146,[[timestamp]],1),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e','icon_file_tiff.svg','svg','image/svg+xml',3147,[[timestamp]],1),('f6294a87-964e-4548-b490-549a25a5abc4','icon_file_ods.svg','svg','image/svg+xml',3146,[[timestamp]],1),('fda3e76a-ee45-430f-af0b-a934434529df','icon_file_docx.svg','svg','image/svg+xml',3150,[[timestamp]],1),('fe5c3b76-d3ca-4411-8a57-385789647965','icon_file_gif.svg','svg','image/svg+xml',3146,[[timestamp]],1);

--
-- Table structure for table `il_resource_rc`
--

CREATE TABLE `il_resource_rc` (
  `rcid` varchar(64) NOT NULL DEFAULT '',
  `title` varchar(4000) DEFAULT NULL,
  `owner_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rcid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_rc`
--


--
-- Table structure for table `il_resource_rca`
--

CREATE TABLE `il_resource_rca` (
  `rcid` varchar(64) NOT NULL DEFAULT '',
  `rid` varchar(64) NOT NULL DEFAULT '',
  `position` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rcid`,`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_rca`
--


--
-- Table structure for table `il_resource_revision`
--

CREATE TABLE `il_resource_revision` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `available` tinyint(4) DEFAULT '1',
  `version_number` bigint(20) NOT NULL,
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT '10',
  PRIMARY KEY (`rid`,`version_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_revision`
--

INSERT INTO `il_resource_revision` VALUES ('090c5356-ab97-440f-ab0e-7adeb5348f26',1,1,6,'icon_file_xlsx.svg',10),('0a47e262-6bac-40e4-9f3e-495d5a309e68',1,1,6,'icon_file_wav.svg',10),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b',1,1,6,'icon_file_pdf.svg',10),('327b9a87-b572-4519-bdfe-50467ade0447',1,1,6,'icon_file_ico.svg',10),('56af626b-47c3-4d24-b54c-faf111800c80',1,1,6,'icon_file_rtf.svg',10),('5a524454-3b69-4195-8931-21b024de22b2',1,1,6,'icon_file_jpg.svg',10),('62bb175e-a5e7-4673-bff6-e6c5b9510240',1,1,6,'icon_file_svg.svg',10),('67e3c2ac-02e7-442f-b816-b4259d4b60de',1,1,6,'icon_file_odp.svg',10),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93',1,1,6,'icon_file_odt.svg',10),('74ec6f4e-2ae8-416e-926e-911e064c659c',1,1,6,'icon_file_txt.svg',10),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe',1,1,6,'icon_file_wma.svg',10),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd',1,1,6,'icon_file_bmp.svg',10),('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5',1,1,6,'icon_file_avi.svg',10),('903763d5-12bb-4d11-b044-fb23ece6fba8',1,1,6,'icon_file_mov.svg',10),('a6146782-fb59-4779-9860-adda3dff0df2',1,1,6,'icon_file_md.svg',10),('a784671e-f081-4dc3-8436-696ca1ac8b2f',1,1,6,'icon_file_mp3.svg',10),('b5986965-13a0-4a69-b519-74c04068ba95',1,1,6,'icon_file_png.svg',10),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd',1,1,6,'icon_file_csv.svg',10),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1',1,1,6,'icon_file_xml.svg',10),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472',1,1,6,'icon_file_flv.svg',10),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8',1,1,6,'icon_file_pptx.svg',10),('ee9edffd-fc7a-45bd-b673-bed0a22e64af',1,1,6,'icon_file_mp4.svg',10),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e',1,1,6,'icon_file_tiff.svg',10),('f6294a87-964e-4548-b490-549a25a5abc4',1,1,6,'icon_file_ods.svg',10),('fda3e76a-ee45-430f-af0b-a934434529df',1,1,6,'icon_file_docx.svg',10),('fe5c3b76-d3ca-4411-8a57-385789647965',1,1,6,'icon_file_gif.svg',10);

--
-- Table structure for table `il_resource_stkh`
--

CREATE TABLE `il_resource_stkh` (
  `id` varchar(64) NOT NULL DEFAULT '',
  `class_name` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_stkh`
--

INSERT INTO `il_resource_stkh` VALUES ('file_icon','ILIAS\\File\\Icon\\ilObjFileIconStakeholder');

--
-- Table structure for table `il_resource_stkh_u`
--

CREATE TABLE `il_resource_stkh_u` (
  `rid` varchar(64) NOT NULL DEFAULT '',
  `stakeholder_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_resource_stkh_u`
--

INSERT INTO `il_resource_stkh_u` VALUES ('090c5356-ab97-440f-ab0e-7adeb5348f26','file_icon'),('0a47e262-6bac-40e4-9f3e-495d5a309e68','file_icon'),('2fb70d36-e0ba-41c3-bb78-5046fd110d4b','file_icon'),('327b9a87-b572-4519-bdfe-50467ade0447','file_icon'),('56af626b-47c3-4d24-b54c-faf111800c80','file_icon'),('5a524454-3b69-4195-8931-21b024de22b2','file_icon'),('62bb175e-a5e7-4673-bff6-e6c5b9510240','file_icon'),('67e3c2ac-02e7-442f-b816-b4259d4b60de','file_icon'),('69d92d1e-10ff-4d76-8413-6fa1f5d64a93','file_icon'),('74ec6f4e-2ae8-416e-926e-911e064c659c','file_icon'),('7f92c5a5-f585-4c0a-bacf-e4a9899ababe','file_icon'),('89eeac86-ae8e-4ef0-90cc-d058b28e52bd','file_icon'),('8c3a0cd4-cf2b-4c74-bc37-973206a3b4a5','file_icon'),('903763d5-12bb-4d11-b044-fb23ece6fba8','file_icon'),('a6146782-fb59-4779-9860-adda3dff0df2','file_icon'),('a784671e-f081-4dc3-8436-696ca1ac8b2f','file_icon'),('b5986965-13a0-4a69-b519-74c04068ba95','file_icon'),('c9b8d1f1-6ea9-47c7-8dce-8716f68b6fdd','file_icon'),('cf609a56-cb3d-4c76-b8b9-e9f1795832a1','file_icon'),('dc9e2fa1-97a7-4b93-999e-d86c18fe6472','file_icon'),('df0daf44-ed3c-4a51-9ac7-0c7899f353c8','file_icon'),('ee9edffd-fc7a-45bd-b673-bed0a22e64af','file_icon'),('f2fe0cd5-4068-4c23-b9ca-1e4d6536804e','file_icon'),('f6294a87-964e-4548-b490-549a25a5abc4','file_icon'),('fda3e76a-ee45-430f-af0b-a934434529df','file_icon'),('fe5c3b76-d3ca-4411-8a57-385789647965','file_icon');

--
-- Table structure for table `il_subscribers`
--

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

--
-- Dumping data for table `il_subscribers`
--


--
-- Table structure for table `il_tag`
--

CREATE TABLE `il_tag` (
  `obj_id` int(11) NOT NULL DEFAULT '0',
  `obj_type` char(10) NOT NULL DEFAULT '',
  `sub_obj_id` int(11) NOT NULL DEFAULT '0',
  `sub_obj_type` char(10) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `tag` varchar(100) NOT NULL DEFAULT ' ',
  `is_offline` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`obj_id`,`obj_type`,`sub_obj_id`,`sub_obj_type`,`user_id`,`tag`),
  KEY `i1_idx` (`obj_id`,`obj_type`,`sub_obj_id`,`sub_obj_type`),
  KEY `i2_idx` (`tag`),
  KEY `i3_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_tag`
--


--
-- Table structure for table `il_translations`
--

CREATE TABLE `il_translations` (
  `id` int(11) NOT NULL DEFAULT '0',
  `id_type` varchar(50) NOT NULL DEFAULT '',
  `lang_code` varchar(2) NOT NULL DEFAULT '',
  `title` varchar(256) DEFAULT NULL,
  `description` varchar(512) DEFAULT NULL,
  `lang_default` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`id_type`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `il_translations`
--


--
-- Table structure for table `il_upload_policy`
--

CREATE TABLE `il_upload_policy` (
  `policy_id` bigint(20) NOT NULL,
  `title` varchar(256) NOT NULL,
  `upload_limit_in_mb` bigint(20) NOT NULL,
  `audience` varchar(512) NOT NULL,
  `audience_type` smallint(6) NOT NULL,
  `scope_definition` varchar(512) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_until` date DEFAULT NULL,
  `owner` bigint(20) NOT NULL,
  `create_date` datetime NOT NULL,
  `last_update` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
