IP : 3.145.77.67Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
hablator/
../
modernizr/
../
dotproj/
../
typo7/
../
uauctions/
../
ilias/
ilias.sql/
/
-- MySQL dump 10.13 Distrib 5.7.44, for Linux (x86_64) -- -- Host: localhost Database: ilias97 -- ------------------------------------------------------ -- Server version 5.7.44
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- -- Table structure for table `acc_access_key` --
DROP TABLE IF EXISTS `acc_access_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_access_key` ( `lang_key` char(2) NOT NULL DEFAULT '', `function_id` int(11) NOT NULL DEFAULT '0', `access_key` char(1) DEFAULT NULL, PRIMARY KEY (`lang_key`,`function_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_access_key` --
LOCK TABLES `acc_access_key` WRITE; /*!40000 ALTER TABLE `acc_access_key` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_access_key` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_cache` --
DROP TABLE IF EXISTS `acc_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_cache` ( `user_id` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', `result` longtext, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_cache` --
LOCK TABLES `acc_cache` WRITE; /*!40000 ALTER TABLE `acc_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_cache` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_criterion_to_doc` --
DROP TABLE IF EXISTS `acc_criterion_to_doc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_criterion_to_doc` ( `id` int(11) NOT NULL DEFAULT '0', `doc_id` int(11) NOT NULL DEFAULT '0', `criterion_id` varchar(50) NOT NULL, `criterion_value` varchar(255) DEFAULT NULL, `assigned_ts` int(11) NOT NULL DEFAULT '0', `modification_ts` int(11) NOT NULL DEFAULT '0', `owner_usr_id` int(11) NOT NULL DEFAULT '0', `last_modified_usr_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_criterion_to_doc` --
LOCK TABLES `acc_criterion_to_doc` WRITE; /*!40000 ALTER TABLE `acc_criterion_to_doc` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_criterion_to_doc` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_criterion_to_doc_seq` --
DROP TABLE IF EXISTS `acc_criterion_to_doc_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_criterion_to_doc_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_criterion_to_doc_seq` --
LOCK TABLES `acc_criterion_to_doc_seq` WRITE; /*!40000 ALTER TABLE `acc_criterion_to_doc_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_criterion_to_doc_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_documents` --
DROP TABLE IF EXISTS `acc_documents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_documents` ( `id` int(11) NOT NULL DEFAULT '0', `title` varchar(255) DEFAULT NULL, `creation_ts` int(11) NOT NULL DEFAULT '0', `modification_ts` int(11) NOT NULL DEFAULT '0', `sorting` int(11) NOT NULL DEFAULT '0', `owner_usr_id` int(11) NOT NULL DEFAULT '0', `last_modified_usr_id` int(11) NOT NULL DEFAULT '0', `text` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_documents` --
LOCK TABLES `acc_documents` WRITE; /*!40000 ALTER TABLE `acc_documents` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_documents` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_documents_seq` --
DROP TABLE IF EXISTS `acc_documents_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_documents_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_documents_seq` --
LOCK TABLES `acc_documents_seq` WRITE; /*!40000 ALTER TABLE `acc_documents_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_documents_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acc_user_access_key` --
DROP TABLE IF EXISTS `acc_user_access_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acc_user_access_key` ( `user_id` int(11) NOT NULL DEFAULT '0', `function_id` smallint(6) NOT NULL DEFAULT '0', `access_key` char(1) DEFAULT NULL, PRIMARY KEY (`user_id`,`function_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acc_user_access_key` --
LOCK TABLES `acc_user_access_key` WRITE; /*!40000 ALTER TABLE `acc_user_access_key` DISABLE KEYS */; /*!40000 ALTER TABLE `acc_user_access_key` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `acl_ws` --
DROP TABLE IF EXISTS `acl_ws`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acl_ws` ( `node_id` int(11) NOT NULL DEFAULT '0', `object_id` int(11) NOT NULL DEFAULT '0', `extended_data` varchar(200) DEFAULT NULL, `tstamp` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`node_id`,`object_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `acl_ws` --
LOCK TABLES `acl_ws` WRITE; /*!40000 ALTER TABLE `acl_ws` DISABLE KEYS */; /*!40000 ALTER TABLE `acl_ws` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `addressbook_mlist` --
DROP TABLE IF EXISTS `addressbook_mlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `addressbook_mlist` ( `ml_id` bigint(20) NOT NULL DEFAULT '0', `user_id` bigint(20) NOT NULL DEFAULT '0', `title` varchar(255) DEFAULT NULL, `description` varchar(4000) DEFAULT NULL, `createdate` datetime DEFAULT NULL, `changedate` datetime DEFAULT NULL, `lmode` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`ml_id`), KEY `i1_idx` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `addressbook_mlist` --
LOCK TABLES `addressbook_mlist` WRITE; /*!40000 ALTER TABLE `addressbook_mlist` DISABLE KEYS */; /*!40000 ALTER TABLE `addressbook_mlist` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `addressbook_mlist_ass` --
DROP TABLE IF EXISTS `addressbook_mlist_ass`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `addressbook_mlist_ass` ( `a_id` bigint(20) NOT NULL DEFAULT '0', `ml_id` bigint(20) NOT NULL DEFAULT '0', `usr_id` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`a_id`), KEY `i1_idx` (`ml_id`), KEY `i2_idx` (`usr_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `addressbook_mlist_ass` --
LOCK TABLES `addressbook_mlist_ass` WRITE; /*!40000 ALTER TABLE `addressbook_mlist_ass` DISABLE KEYS */; /*!40000 ALTER TABLE `addressbook_mlist_ass` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `addressbook_mlist_ass_seq` --
DROP TABLE IF EXISTS `addressbook_mlist_ass_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `addressbook_mlist_ass_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `addressbook_mlist_ass_seq` --
LOCK TABLES `addressbook_mlist_ass_seq` WRITE; /*!40000 ALTER TABLE `addressbook_mlist_ass_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `addressbook_mlist_ass_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `addressbook_mlist_seq` --
DROP TABLE IF EXISTS `addressbook_mlist_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `addressbook_mlist_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `addressbook_mlist_seq` --
LOCK TABLES `addressbook_mlist_seq` WRITE; /*!40000 ALTER TABLE `addressbook_mlist_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `addressbook_mlist_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adl_shared_data` --
DROP TABLE IF EXISTS `adl_shared_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adl_shared_data` ( `slm_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `target_id` varchar(4000) NOT NULL DEFAULT '', `store` longtext, `cp_node_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`cp_node_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adl_shared_data` --
LOCK TABLES `adl_shared_data` WRITE; /*!40000 ALTER TABLE `adl_shared_data` DISABLE KEYS */; /*!40000 ALTER TABLE `adl_shared_data` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adm_set_templ_hide_tab` --
DROP TABLE IF EXISTS `adm_set_templ_hide_tab`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adm_set_templ_hide_tab` ( `template_id` int(11) NOT NULL DEFAULT '0', `tab_id` varchar(80) NOT NULL DEFAULT '', PRIMARY KEY (`template_id`,`tab_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adm_set_templ_hide_tab` --
LOCK TABLES `adm_set_templ_hide_tab` WRITE; /*!40000 ALTER TABLE `adm_set_templ_hide_tab` DISABLE KEYS */; /*!40000 ALTER TABLE `adm_set_templ_hide_tab` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adm_set_templ_value` --
DROP TABLE IF EXISTS `adm_set_templ_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adm_set_templ_value` ( `template_id` int(11) NOT NULL DEFAULT '0', `setting` varchar(40) NOT NULL DEFAULT '', `value` varchar(4000) DEFAULT NULL, `hide` tinyint(4) DEFAULT NULL, PRIMARY KEY (`template_id`,`setting`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adm_set_templ_value` --
LOCK TABLES `adm_set_templ_value` WRITE; /*!40000 ALTER TABLE `adm_set_templ_value` DISABLE KEYS */; INSERT INTO `adm_set_templ_value` VALUES (1,'pass_scoring','0',1),(2,'pass_scoring','0',1); /*!40000 ALTER TABLE `adm_set_templ_value` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_field_int` --
DROP TABLE IF EXISTS `adv_md_field_int`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_field_int` ( `field_id` int(11) NOT NULL, `title` varchar(128) DEFAULT NULL, `description` varchar(4000) DEFAULT NULL, `lang_code` varchar(5) NOT NULL, PRIMARY KEY (`field_id`,`lang_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_field_int` --
LOCK TABLES `adv_md_field_int` WRITE; /*!40000 ALTER TABLE `adv_md_field_int` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_field_int` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_obj_rec_select` --
DROP TABLE IF EXISTS `adv_md_obj_rec_select`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_obj_rec_select` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `rec_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`rec_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_obj_rec_select` --
LOCK TABLES `adv_md_obj_rec_select` WRITE; /*!40000 ALTER TABLE `adv_md_obj_rec_select` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_obj_rec_select` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record` --
DROP TABLE IF EXISTS `adv_md_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record` ( `record_id` int(11) NOT NULL DEFAULT '0', `import_id` varchar(64) DEFAULT NULL, `active` tinyint(4) NOT NULL DEFAULT '0', `title` varchar(128) DEFAULT NULL, `description` varchar(4000) DEFAULT NULL, `parent_obj` int(11) DEFAULT NULL, `gpos` int(11) DEFAULT NULL, `lang_default` varchar(2) DEFAULT NULL, PRIMARY KEY (`record_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record` --
LOCK TABLES `adv_md_record` WRITE; /*!40000 ALTER TABLE `adv_md_record` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_int` --
DROP TABLE IF EXISTS `adv_md_record_int`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_int` ( `record_id` int(11) NOT NULL, `title` varchar(128) DEFAULT NULL, `description` varchar(4000) DEFAULT NULL, `lang_code` varchar(5) NOT NULL, PRIMARY KEY (`record_id`,`lang_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_int` --
LOCK TABLES `adv_md_record_int` WRITE; /*!40000 ALTER TABLE `adv_md_record_int` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_int` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_obj_ord` --
DROP TABLE IF EXISTS `adv_md_record_obj_ord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_obj_ord` ( `record_id` int(11) NOT NULL, `obj_id` int(11) NOT NULL, `position` int(11) NOT NULL, PRIMARY KEY (`record_id`,`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_obj_ord` --
LOCK TABLES `adv_md_record_obj_ord` WRITE; /*!40000 ALTER TABLE `adv_md_record_obj_ord` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_obj_ord` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_objs` --
DROP TABLE IF EXISTS `adv_md_record_objs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_objs` ( `record_id` int(11) NOT NULL DEFAULT '0', `obj_type` char(6) NOT NULL DEFAULT '', `sub_type` varchar(10) NOT NULL DEFAULT '-', `optional` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`record_id`,`obj_type`,`sub_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_objs` --
LOCK TABLES `adv_md_record_objs` WRITE; /*!40000 ALTER TABLE `adv_md_record_objs` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_objs` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_scope` --
DROP TABLE IF EXISTS `adv_md_record_scope`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_scope` ( `scope_id` int(11) NOT NULL DEFAULT '0', `record_id` int(11) NOT NULL, `ref_id` int(11) NOT NULL, PRIMARY KEY (`scope_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_scope` --
LOCK TABLES `adv_md_record_scope` WRITE; /*!40000 ALTER TABLE `adv_md_record_scope` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_scope` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_scope_seq` --
DROP TABLE IF EXISTS `adv_md_record_scope_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_scope_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_scope_seq` --
LOCK TABLES `adv_md_record_scope_seq` WRITE; /*!40000 ALTER TABLE `adv_md_record_scope_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_scope_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_record_seq` --
DROP TABLE IF EXISTS `adv_md_record_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_record_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_record_seq` --
LOCK TABLES `adv_md_record_seq` WRITE; /*!40000 ALTER TABLE `adv_md_record_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_record_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_substitutions` --
DROP TABLE IF EXISTS `adv_md_substitutions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_substitutions` ( `obj_type` varchar(4) NOT NULL DEFAULT ' ', `substitution` longtext, `hide_description` tinyint(4) NOT NULL DEFAULT '0', `hide_field_names` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_substitutions` --
LOCK TABLES `adv_md_substitutions` WRITE; /*!40000 ALTER TABLE `adv_md_substitutions` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_substitutions` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_date` --
DROP TABLE IF EXISTS `adv_md_values_date`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_date` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` date DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_date` --
LOCK TABLES `adv_md_values_date` WRITE; /*!40000 ALTER TABLE `adv_md_values_date` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_date` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_datetime` --
DROP TABLE IF EXISTS `adv_md_values_datetime`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_datetime` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` datetime DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_datetime` --
LOCK TABLES `adv_md_values_datetime` WRITE; /*!40000 ALTER TABLE `adv_md_values_datetime` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_datetime` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_enum` --
DROP TABLE IF EXISTS `adv_md_values_enum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_enum` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `disabled` tinyint(4) NOT NULL DEFAULT '0', `value_index` varchar(16) NOT NULL, PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`,`value_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_enum` --
LOCK TABLES `adv_md_values_enum` WRITE; /*!40000 ALTER TABLE `adv_md_values_enum` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_enum` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_extlink` --
DROP TABLE IF EXISTS `adv_md_values_extlink`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_extlink` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` varchar(2000) DEFAULT NULL, `title` varchar(500) DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_extlink` --
LOCK TABLES `adv_md_values_extlink` WRITE; /*!40000 ALTER TABLE `adv_md_values_extlink` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_extlink` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_float` --
DROP TABLE IF EXISTS `adv_md_values_float`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_float` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` double DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_float` --
LOCK TABLES `adv_md_values_float` WRITE; /*!40000 ALTER TABLE `adv_md_values_float` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_float` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_int` --
DROP TABLE IF EXISTS `adv_md_values_int`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_int` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` int(11) DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_int` --
LOCK TABLES `adv_md_values_int` WRITE; /*!40000 ALTER TABLE `adv_md_values_int` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_int` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_intlink` --
DROP TABLE IF EXISTS `adv_md_values_intlink`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_intlink` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` int(11) NOT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_intlink` --
LOCK TABLES `adv_md_values_intlink` WRITE; /*!40000 ALTER TABLE `adv_md_values_intlink` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_intlink` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_location` --
DROP TABLE IF EXISTS `adv_md_values_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_location` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `loc_lat` double DEFAULT NULL, `loc_long` double DEFAULT NULL, `loc_zoom` tinyint(4) DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_location` --
LOCK TABLES `adv_md_values_location` WRITE; /*!40000 ALTER TABLE `adv_md_values_location` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_location` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_ltext` --
DROP TABLE IF EXISTS `adv_md_values_ltext`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_ltext` ( `obj_id` int(11) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value_index` varchar(16) NOT NULL, `value` varchar(4000) DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`sub_type`,`sub_id`,`field_id`,`value_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_ltext` --
LOCK TABLES `adv_md_values_ltext` WRITE; /*!40000 ALTER TABLE `adv_md_values_ltext` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_ltext` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_md_values_text` --
DROP TABLE IF EXISTS `adv_md_values_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_md_values_text` ( `obj_id` int(11) NOT NULL DEFAULT '0', `field_id` int(11) NOT NULL DEFAULT '0', `value` varchar(4000) DEFAULT NULL, `disabled` tinyint(4) NOT NULL DEFAULT '0', `sub_type` varchar(10) NOT NULL DEFAULT '-', `sub_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`field_id`,`sub_type`,`sub_id`), KEY `i1_idx` (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_md_values_text` --
LOCK TABLES `adv_md_values_text` WRITE; /*!40000 ALTER TABLE `adv_md_values_text` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_md_values_text` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_mdf_definition` --
DROP TABLE IF EXISTS `adv_mdf_definition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_mdf_definition` ( `field_id` int(11) NOT NULL DEFAULT '0', `record_id` int(11) NOT NULL DEFAULT '0', `import_id` varchar(32) DEFAULT NULL, `position` int(11) NOT NULL DEFAULT '0', `field_type` tinyint(4) NOT NULL DEFAULT '0', `field_values` text, `title` varchar(255) DEFAULT NULL, `description` varchar(2000) DEFAULT NULL, `searchable` tinyint(4) NOT NULL DEFAULT '0', `required` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_mdf_definition` --
LOCK TABLES `adv_mdf_definition` WRITE; /*!40000 ALTER TABLE `adv_mdf_definition` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_mdf_definition` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_mdf_definition_seq` --
DROP TABLE IF EXISTS `adv_mdf_definition_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_mdf_definition_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_mdf_definition_seq` --
LOCK TABLES `adv_mdf_definition_seq` WRITE; /*!40000 ALTER TABLE `adv_mdf_definition_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_mdf_definition_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `adv_mdf_enum` --
DROP TABLE IF EXISTS `adv_mdf_enum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adv_mdf_enum` ( `field_id` int(11) NOT NULL, `lang_code` varchar(5) NOT NULL, `idx` int(11) NOT NULL, `value` varchar(4000) NOT NULL, PRIMARY KEY (`field_id`,`lang_code`,`idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `adv_mdf_enum` --
LOCK TABLES `adv_mdf_enum` WRITE; /*!40000 ALTER TABLE `adv_mdf_enum` DISABLE KEYS */; /*!40000 ALTER TABLE `adv_mdf_enum` ENABLE KEYS */; UNLOCK TABLES;
DROP TABLE IF EXISTS `il_dcl_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_data` --
LOCK TABLES `il_dcl_data` WRITE; /*!40000 ALTER TABLE `il_dcl_data` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_data` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_data_seq` --
DROP TABLE IF EXISTS `il_dcl_data_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_data_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_data_seq` --
LOCK TABLES `il_dcl_data_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_data_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_data_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_datatype` --
DROP TABLE IF EXISTS `il_dcl_datatype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_datatype` ( `id` int(11) NOT NULL DEFAULT '0', `title` varchar(256) DEFAULT NULL, `ildb_type` varchar(256) NOT NULL DEFAULT '', `storage_location` int(11) NOT NULL DEFAULT '0', `sort` smallint(6) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_datatype` --
LOCK TABLES `il_dcl_datatype` WRITE; /*!40000 ALTER TABLE `il_dcl_datatype` DISABLE KEYS */; INSERT INTO `il_dcl_datatype` VALUES (1,'number','integer',2,20),(2,'text','text',1,0),(3,'reference','text',1,80),(4,'boolean','integer',2,30),(5,'datetime','date',3,40),(7,'rating','integer',0,100),(8,'ilias_reference','integer',2,90),(9,'mob','integer',2,60),(11,'formula','text',0,110),(14,'text_selection','text',1,10),(15,'date_selection','text',1,50),(16,'file','text',1,75),(17,'copy','text',1,85); /*!40000 ALTER TABLE `il_dcl_datatype` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_datatype_prop` --
DROP TABLE IF EXISTS `il_dcl_datatype_prop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_datatype_prop` --
LOCK TABLES `il_dcl_datatype_prop` WRITE; /*!40000 ALTER TABLE `il_dcl_datatype_prop` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `il_dcl_datatype_prop` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_field` --
DROP TABLE IF EXISTS `il_dcl_field`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_field` --
LOCK TABLES `il_dcl_field` WRITE; /*!40000 ALTER TABLE `il_dcl_field` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_field` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_field_prop` --
DROP TABLE IF EXISTS `il_dcl_field_prop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_field_prop` --
LOCK TABLES `il_dcl_field_prop` WRITE; /*!40000 ALTER TABLE `il_dcl_field_prop` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_field_prop` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_field_prop_seq` --
DROP TABLE IF EXISTS `il_dcl_field_prop_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_field_prop_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_field_prop_seq` --
LOCK TABLES `il_dcl_field_prop_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_field_prop_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_field_prop_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_field_seq` --
DROP TABLE IF EXISTS `il_dcl_field_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_field_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_field_seq` --
LOCK TABLES `il_dcl_field_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_field_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_field_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_record` --
DROP TABLE IF EXISTS `il_dcl_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_record` --
LOCK TABLES `il_dcl_record` WRITE; /*!40000 ALTER TABLE `il_dcl_record` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_record` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_record_field` --
DROP TABLE IF EXISTS `il_dcl_record_field`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_record_field` --
LOCK TABLES `il_dcl_record_field` WRITE; /*!40000 ALTER TABLE `il_dcl_record_field` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_record_field` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_record_field_seq` --
DROP TABLE IF EXISTS `il_dcl_record_field_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_record_field_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_record_field_seq` --
LOCK TABLES `il_dcl_record_field_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_record_field_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_record_field_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_record_seq` --
DROP TABLE IF EXISTS `il_dcl_record_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_record_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_record_seq` --
LOCK TABLES `il_dcl_record_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_record_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_record_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_sel_opts` --
DROP TABLE IF EXISTS `il_dcl_sel_opts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_sel_opts` --
LOCK TABLES `il_dcl_sel_opts` WRITE; /*!40000 ALTER TABLE `il_dcl_sel_opts` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_sel_opts` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_sel_opts_seq` --
DROP TABLE IF EXISTS `il_dcl_sel_opts_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_sel_opts_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_sel_opts_seq` --
LOCK TABLES `il_dcl_sel_opts_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_sel_opts_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_sel_opts_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc1_default` --
DROP TABLE IF EXISTS `il_dcl_stloc1_default`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc1_default` --
LOCK TABLES `il_dcl_stloc1_default` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc1_default` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc1_default` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc1_default_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc1_default_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc1_default_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc1_default_seq` --
LOCK TABLES `il_dcl_stloc1_default_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc1_default_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc1_default_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc1_value` --
DROP TABLE IF EXISTS `il_dcl_stloc1_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc1_value` --
LOCK TABLES `il_dcl_stloc1_value` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc1_value` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc1_value` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc1_value_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc1_value_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc1_value_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc1_value_seq` --
LOCK TABLES `il_dcl_stloc1_value_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc1_value_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc1_value_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc2_default` --
DROP TABLE IF EXISTS `il_dcl_stloc2_default`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc2_default` --
LOCK TABLES `il_dcl_stloc2_default` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc2_default` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc2_default` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc2_default_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc2_default_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc2_default_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc2_default_seq` --
LOCK TABLES `il_dcl_stloc2_default_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc2_default_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc2_default_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc2_value` --
DROP TABLE IF EXISTS `il_dcl_stloc2_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc2_value` --
LOCK TABLES `il_dcl_stloc2_value` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc2_value` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc2_value` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc2_value_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc2_value_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc2_value_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc2_value_seq` --
LOCK TABLES `il_dcl_stloc2_value_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc2_value_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc2_value_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc3_default` --
DROP TABLE IF EXISTS `il_dcl_stloc3_default`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc3_default` --
LOCK TABLES `il_dcl_stloc3_default` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc3_default` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc3_default` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc3_default_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc3_default_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc3_default_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc3_default_seq` --
LOCK TABLES `il_dcl_stloc3_default_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc3_default_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc3_default_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc3_value` --
DROP TABLE IF EXISTS `il_dcl_stloc3_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc3_value` --
LOCK TABLES `il_dcl_stloc3_value` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc3_value` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc3_value` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_stloc3_value_seq` --
DROP TABLE IF EXISTS `il_dcl_stloc3_value_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_stloc3_value_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_stloc3_value_seq` --
LOCK TABLES `il_dcl_stloc3_value_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_stloc3_value_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_stloc3_value_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_table` --
DROP TABLE IF EXISTS `il_dcl_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_table` --
LOCK TABLES `il_dcl_table` WRITE; /*!40000 ALTER TABLE `il_dcl_table` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_table` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_table_seq` --
DROP TABLE IF EXISTS `il_dcl_table_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_table_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_table_seq` --
LOCK TABLES `il_dcl_table_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_table_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_table_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tableview` --
DROP TABLE IF EXISTS `il_dcl_tableview`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tableview` --
LOCK TABLES `il_dcl_tableview` WRITE; /*!40000 ALTER TABLE `il_dcl_tableview` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tableview` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tableview_seq` --
DROP TABLE IF EXISTS `il_dcl_tableview_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_tableview_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tableview_seq` --
LOCK TABLES `il_dcl_tableview_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_tableview_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tableview_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tfield_set` --
DROP TABLE IF EXISTS `il_dcl_tfield_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tfield_set` --
LOCK TABLES `il_dcl_tfield_set` WRITE; /*!40000 ALTER TABLE `il_dcl_tfield_set` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tfield_set` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tfield_set_seq` --
DROP TABLE IF EXISTS `il_dcl_tfield_set_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_tfield_set_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tfield_set_seq` --
LOCK TABLES `il_dcl_tfield_set_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_tfield_set_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tfield_set_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tview_set` --
DROP TABLE IF EXISTS `il_dcl_tview_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tview_set` --
LOCK TABLES `il_dcl_tview_set` WRITE; /*!40000 ALTER TABLE `il_dcl_tview_set` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tview_set` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_tview_set_seq` --
DROP TABLE IF EXISTS `il_dcl_tview_set_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_tview_set_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_tview_set_seq` --
LOCK TABLES `il_dcl_tview_set_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_tview_set_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_tview_set_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_dcl_view_seq` --
DROP TABLE IF EXISTS `il_dcl_view_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_dcl_view_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_dcl_view_seq` --
LOCK TABLES `il_dcl_view_seq` WRITE; /*!40000 ALTER TABLE `il_dcl_view_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_dcl_view_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_exc_team` --
DROP TABLE IF EXISTS `il_exc_team`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_exc_team` --
LOCK TABLES `il_exc_team` WRITE; /*!40000 ALTER TABLE `il_exc_team` DISABLE KEYS */; /*!40000 ALTER TABLE `il_exc_team` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_exc_team_log` --
DROP TABLE IF EXISTS `il_exc_team_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_exc_team_log` --
LOCK TABLES `il_exc_team_log` WRITE; /*!40000 ALTER TABLE `il_exc_team_log` DISABLE KEYS */; /*!40000 ALTER TABLE `il_exc_team_log` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_exc_team_log_seq` --
DROP TABLE IF EXISTS `il_exc_team_log_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_exc_team_log_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_exc_team_log_seq` --
LOCK TABLES `il_exc_team_log_seq` WRITE; /*!40000 ALTER TABLE `il_exc_team_log_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_exc_team_log_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_exc_team_seq` --
DROP TABLE IF EXISTS `il_exc_team_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_exc_team_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_exc_team_seq` --
LOCK TABLES `il_exc_team_seq` WRITE; /*!40000 ALTER TABLE `il_exc_team_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_exc_team_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_external_feed_block` --
DROP TABLE IF EXISTS `il_external_feed_block`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_external_feed_block` --
LOCK TABLES `il_external_feed_block` WRITE; /*!40000 ALTER TABLE `il_external_feed_block` DISABLE KEYS */; /*!40000 ALTER TABLE `il_external_feed_block` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_external_feed_block_seq` --
DROP TABLE IF EXISTS `il_external_feed_block_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_external_feed_block_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_external_feed_block_seq` --
LOCK TABLES `il_external_feed_block_seq` WRITE; /*!40000 ALTER TABLE `il_external_feed_block_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_external_feed_block_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_file_icon` --
DROP TABLE IF EXISTS `il_file_icon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_file_icon` --
LOCK TABLES `il_file_icon` WRITE; /*!40000 ALTER TABLE `il_file_icon` DISABLE KEYS */; INSERT INTO `il_file_icon` VALUES ('4d5c5dff-44e8-4317-871d-17187f918485',1,1),('53c4549e-eca4-476e-877f-d1bba0e453d3',1,1),('0e8bc61c-43e1-4fca-bdf5-866910439b90',1,1),('1a14df55-7784-4ae4-b2d7-3a9d349f0136',1,1),('a1fc8b97-6c05-41a5-af52-89273d9c72de',1,1),('f6a3359c-9af2-43e4-834f-20abdf327784',1,1),('c714e72b-e42d-48fa-a295-98054f3c07ab',1,1),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b',1,1),('adfdf6b7-577a-480e-8ba4-d8273662f772',1,1),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65',1,1),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d',1,1),('02a0534b-c6b2-4554-b98f-5da202f47430',1,1),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae',1,1),('aacfe9c8-2f4b-4525-837e-70438cf71e2a',1,1),('23094eec-d504-42ab-b551-04d1ebf52ac8',1,1),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96',1,1),('d73b34c0-57c4-40da-a6d5-40aa39a17152',1,1),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6',1,1),('5ffe2456-0be0-4524-b8b3-a5c237702e15',1,1),('722c7b76-85a4-4b07-87bb-e479bc3df40a',1,1),('179c1e39-6747-4e3a-90b8-d9deb5a2a886',1,1),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80',1,1),('42b5a867-379e-4419-93c7-8543b765270b',1,1),('d37fe299-bb5d-49f1-9477-8518c2f5f26d',1,1),('cad6e286-5ab3-41d9-bbad-aeb29f687d28',1,1),('c5ce87c9-fff4-4088-902f-bfb1471897c8',1,1); /*!40000 ALTER TABLE `il_file_icon` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_file_icon_suffixes` --
DROP TABLE IF EXISTS `il_file_icon_suffixes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_file_icon_suffixes` ( `rid` varchar(64) NOT NULL DEFAULT '', `suffix` varchar(32) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_file_icon_suffixes` --
LOCK TABLES `il_file_icon_suffixes` WRITE; /*!40000 ALTER TABLE `il_file_icon_suffixes` DISABLE KEYS */; INSERT INTO `il_file_icon_suffixes` VALUES ('4d5c5dff-44e8-4317-871d-17187f918485','avi'),('53c4549e-eca4-476e-877f-d1bba0e453d3','bmp'),('0e8bc61c-43e1-4fca-bdf5-866910439b90','csv'),('1a14df55-7784-4ae4-b2d7-3a9d349f0136','docx'),('a1fc8b97-6c05-41a5-af52-89273d9c72de','flv'),('f6a3359c-9af2-43e4-834f-20abdf327784','gif'),('c714e72b-e42d-48fa-a295-98054f3c07ab','ico'),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b','jpg'),('adfdf6b7-577a-480e-8ba4-d8273662f772','md'),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65','mov'),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d','mp3'),('02a0534b-c6b2-4554-b98f-5da202f47430','mp4'),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae','odp'),('aacfe9c8-2f4b-4525-837e-70438cf71e2a','ods'),('23094eec-d504-42ab-b551-04d1ebf52ac8','odt'),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96','pdf'),('d73b34c0-57c4-40da-a6d5-40aa39a17152','png'),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6','pptx'),('5ffe2456-0be0-4524-b8b3-a5c237702e15','rtf'),('722c7b76-85a4-4b07-87bb-e479bc3df40a','svg'),('179c1e39-6747-4e3a-90b8-d9deb5a2a886','tiff'),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80','txt'),('42b5a867-379e-4419-93c7-8543b765270b','wav'),('d37fe299-bb5d-49f1-9477-8518c2f5f26d','wma'),('cad6e286-5ab3-41d9-bbad-aeb29f687d28','xlsx'),('c5ce87c9-fff4-4088-902f-bfb1471897c8','xml'); /*!40000 ALTER TABLE `il_file_icon_suffixes` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_gc_memcache_server` --
DROP TABLE IF EXISTS `il_gc_memcache_server`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_gc_memcache_server` --
LOCK TABLES `il_gc_memcache_server` WRITE; /*!40000 ALTER TABLE `il_gc_memcache_server` DISABLE KEYS */; /*!40000 ALTER TABLE `il_gc_memcache_server` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_gc_memcache_server_seq` --
DROP TABLE IF EXISTS `il_gc_memcache_server_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_gc_memcache_server_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_gc_memcache_server_seq` --
LOCK TABLES `il_gc_memcache_server_seq` WRITE; /*!40000 ALTER TABLE `il_gc_memcache_server_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_gc_memcache_server_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_html_block` --
DROP TABLE IF EXISTS `il_html_block`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_html_block` --
LOCK TABLES `il_html_block` WRITE; /*!40000 ALTER TABLE `il_html_block` DISABLE KEYS */; /*!40000 ALTER TABLE `il_html_block` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_md_cpr_selections` --
DROP TABLE IF EXISTS `il_md_cpr_selections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_md_cpr_selections` --
LOCK TABLES `il_md_cpr_selections` WRITE; /*!40000 ALTER TABLE `il_md_cpr_selections` DISABLE KEYS */; 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','','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,''); /*!40000 ALTER TABLE `il_md_cpr_selections` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_md_cpr_selections_seq` --
DROP TABLE IF EXISTS `il_md_cpr_selections_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_md_cpr_selections_seq` --
LOCK TABLES `il_md_cpr_selections_seq` WRITE; /*!40000 ALTER TABLE `il_md_cpr_selections_seq` DISABLE KEYS */; INSERT INTO `il_md_cpr_selections_seq` VALUES (9); /*!40000 ALTER TABLE `il_md_cpr_selections_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_media_cast_data` --
DROP TABLE IF EXISTS `il_media_cast_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_media_cast_data` --
LOCK TABLES `il_media_cast_data` WRITE; /*!40000 ALTER TABLE `il_media_cast_data` DISABLE KEYS */; /*!40000 ALTER TABLE `il_media_cast_data` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_media_cast_data_ord` --
DROP TABLE IF EXISTS `il_media_cast_data_ord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_media_cast_data_ord` --
LOCK TABLES `il_media_cast_data_ord` WRITE; /*!40000 ALTER TABLE `il_media_cast_data_ord` DISABLE KEYS */; /*!40000 ALTER TABLE `il_media_cast_data_ord` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_meta_annotation` --
-- -- Dumping data for table `il_orgu_operations` --
LOCK TABLES `il_orgu_operations` WRITE; /*!40000 ALTER TABLE `il_orgu_operations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `il_orgu_operations` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_operations_seq` --
DROP TABLE IF EXISTS `il_orgu_operations_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_orgu_operations_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_orgu_operations_seq` --
LOCK TABLES `il_orgu_operations_seq` WRITE; /*!40000 ALTER TABLE `il_orgu_operations_seq` DISABLE KEYS */; INSERT INTO `il_orgu_operations_seq` VALUES (31); /*!40000 ALTER TABLE `il_orgu_operations_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_permissions` --
-- -- Dumping data for table `il_orgu_permissions` --
LOCK TABLES `il_orgu_permissions` WRITE; /*!40000 ALTER TABLE `il_orgu_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `il_orgu_permissions` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_permissions_seq` --
DROP TABLE IF EXISTS `il_orgu_permissions_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_orgu_permissions_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_orgu_permissions_seq` --
LOCK TABLES `il_orgu_permissions_seq` WRITE; /*!40000 ALTER TABLE `il_orgu_permissions_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_orgu_permissions_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_positions` --
DROP TABLE IF EXISTS `il_orgu_positions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_orgu_positions` --
LOCK TABLES `il_orgu_positions` WRITE; /*!40000 ALTER TABLE `il_orgu_positions` DISABLE KEYS */; INSERT INTO `il_orgu_positions` VALUES (1,'Employees','Employees of a OrgUnit',1,1),(2,'Superiors','Superiors of a OrgUnit',1,2); /*!40000 ALTER TABLE `il_orgu_positions` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_positions_seq` --
DROP TABLE IF EXISTS `il_orgu_positions_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_orgu_positions_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_orgu_positions_seq` --
LOCK TABLES `il_orgu_positions_seq` WRITE; /*!40000 ALTER TABLE `il_orgu_positions_seq` DISABLE KEYS */; INSERT INTO `il_orgu_positions_seq` VALUES (2); /*!40000 ALTER TABLE `il_orgu_positions_seq` ENABLE KEYS */; UNLOCK TABLES;
LOCK TABLES `il_orgu_ua` WRITE; /*!40000 ALTER TABLE `il_orgu_ua` DISABLE KEYS */; /*!40000 ALTER TABLE `il_orgu_ua` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_orgu_ua_seq` --
DROP TABLE IF EXISTS `il_orgu_ua_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_orgu_ua_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_orgu_ua_seq` --
LOCK TABLES `il_orgu_ua_seq` WRITE; /*!40000 ALTER TABLE `il_orgu_ua_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_orgu_ua_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_plugin` --
DROP TABLE IF EXISTS `il_plugin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_plugin` --
LOCK TABLES `il_plugin` WRITE; /*!40000 ALTER TABLE `il_plugin` DISABLE KEYS */; /*!40000 ALTER TABLE `il_plugin` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_poll` --
DROP TABLE IF EXISTS `il_poll`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_poll` --
LOCK TABLES `il_poll` WRITE; /*!40000 ALTER TABLE `il_poll` DISABLE KEYS */; /*!40000 ALTER TABLE `il_poll` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_poll_answer` --
DROP TABLE IF EXISTS `il_poll_answer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_poll_answer` --
LOCK TABLES `il_poll_answer` WRITE; /*!40000 ALTER TABLE `il_poll_answer` DISABLE KEYS */; /*!40000 ALTER TABLE `il_poll_answer` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_poll_answer_seq` --
DROP TABLE IF EXISTS `il_poll_answer_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_poll_answer_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_poll_answer_seq` --
LOCK TABLES `il_poll_answer_seq` WRITE; /*!40000 ALTER TABLE `il_poll_answer_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_poll_answer_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_poll_vote` --
DROP TABLE IF EXISTS `il_poll_vote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_poll_vote` --
LOCK TABLES `il_poll_vote` WRITE; /*!40000 ALTER TABLE `il_poll_vote` DISABLE KEYS */; /*!40000 ALTER TABLE `il_poll_vote` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_res` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_res`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_res` --
LOCK TABLES `il_qpl_qst_fq_res` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_res` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_res` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_res_seq` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_res_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_qpl_qst_fq_res_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_res_seq` --
LOCK TABLES `il_qpl_qst_fq_res_seq` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_res_unit` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_res_unit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_res_unit` --
LOCK TABLES `il_qpl_qst_fq_res_unit` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_unit` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_unit` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_res_unit_seq` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_res_unit_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_qpl_qst_fq_res_unit_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_res_unit_seq` --
LOCK TABLES `il_qpl_qst_fq_res_unit_seq` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_unit_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_res_unit_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_ucat` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_ucat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_ucat` --
LOCK TABLES `il_qpl_qst_fq_ucat` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_ucat` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_ucat` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_ucat_seq` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_ucat_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_qpl_qst_fq_ucat_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_ucat_seq` --
LOCK TABLES `il_qpl_qst_fq_ucat_seq` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_ucat_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_ucat_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_unit` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_unit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_unit` --
LOCK TABLES `il_qpl_qst_fq_unit` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_unit` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_unit` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_unit_seq` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_unit_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_qpl_qst_fq_unit_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_unit_seq` --
LOCK TABLES `il_qpl_qst_fq_unit_seq` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_unit_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_unit_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_var` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_var`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_var` --
LOCK TABLES `il_qpl_qst_fq_var` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_var` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_var` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_qpl_qst_fq_var_seq` --
DROP TABLE IF EXISTS `il_qpl_qst_fq_var_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_qpl_qst_fq_var_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_qpl_qst_fq_var_seq` --
LOCK TABLES `il_qpl_qst_fq_var_seq` WRITE; /*!40000 ALTER TABLE `il_qpl_qst_fq_var_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_qpl_qst_fq_var_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_rating` --
DROP TABLE IF EXISTS `il_rating`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_rating` --
LOCK TABLES `il_rating` WRITE; /*!40000 ALTER TABLE `il_rating` DISABLE KEYS */; /*!40000 ALTER TABLE `il_rating` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_rating_cat` --
DROP TABLE IF EXISTS `il_rating_cat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_rating_cat` --
LOCK TABLES `il_rating_cat` WRITE; /*!40000 ALTER TABLE `il_rating_cat` DISABLE KEYS */; /*!40000 ALTER TABLE `il_rating_cat` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_rating_cat_seq` --
DROP TABLE IF EXISTS `il_rating_cat_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_rating_cat_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_rating_cat_seq` --
LOCK TABLES `il_rating_cat_seq` WRITE; /*!40000 ALTER TABLE `il_rating_cat_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_rating_cat_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource` --
DROP TABLE IF EXISTS `il_resource`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource` --
LOCK TABLES `il_resource` WRITE; /*!40000 ALTER TABLE `il_resource` DISABLE KEYS */; INSERT INTO `il_resource` VALUES ('02a0534b-c6b2-4554-b98f-5da202f47430','fsv2',1),('0e8bc61c-43e1-4fca-bdf5-866910439b90','fsv2',1),('179c1e39-6747-4e3a-90b8-d9deb5a2a886','fsv2',1),('1a14df55-7784-4ae4-b2d7-3a9d349f0136','fsv2',1),('23094eec-d504-42ab-b551-04d1ebf52ac8','fsv2',1),('42b5a867-379e-4419-93c7-8543b765270b','fsv2',1),('4d5c5dff-44e8-4317-871d-17187f918485','fsv2',1),('53c4549e-eca4-476e-877f-d1bba0e453d3','fsv2',1),('5ffe2456-0be0-4524-b8b3-a5c237702e15','fsv2',1),('722c7b76-85a4-4b07-87bb-e479bc3df40a','fsv2',1),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65','fsv2',1),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96','fsv2',1),('a1fc8b97-6c05-41a5-af52-89273d9c72de','fsv2',1),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d','fsv2',1),('aacfe9c8-2f4b-4525-837e-70438cf71e2a','fsv2',1),('adfdf6b7-577a-480e-8ba4-d8273662f772','fsv2',1),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80','fsv2',1),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b','fsv2',1),('c5ce87c9-fff4-4088-902f-bfb1471897c8','fsv2',1),('c714e72b-e42d-48fa-a295-98054f3c07ab','fsv2',1),('cad6e286-5ab3-41d9-bbad-aeb29f687d28','fsv2',1),('d37fe299-bb5d-49f1-9477-8518c2f5f26d','fsv2',1),('d73b34c0-57c4-40da-a6d5-40aa39a17152','fsv2',1),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae','fsv2',1),('f6a3359c-9af2-43e4-834f-20abdf327784','fsv2',1),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6','fsv2',1); /*!40000 ALTER TABLE `il_resource` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_flavour` --
DROP TABLE IF EXISTS `il_resource_flavour`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_flavour` --
LOCK TABLES `il_resource_flavour` WRITE; /*!40000 ALTER TABLE `il_resource_flavour` DISABLE KEYS */; /*!40000 ALTER TABLE `il_resource_flavour` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_info` --
DROP TABLE IF EXISTS `il_resource_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_info` --
LOCK TABLES `il_resource_info` WRITE; /*!40000 ALTER TABLE `il_resource_info` DISABLE KEYS */; INSERT INTO `il_resource_info` VALUES ('02a0534b-c6b2-4554-b98f-5da202f47430','icon_file_mp4.svg','svg','image/svg+xml',3146,1736937665,1),('0e8bc61c-43e1-4fca-bdf5-866910439b90','icon_file_csv.svg','svg','image/svg+xml',3146,1736937665,1),('179c1e39-6747-4e3a-90b8-d9deb5a2a886','icon_file_tiff.svg','svg','image/svg+xml',3147,1736937665,1),('1a14df55-7784-4ae4-b2d7-3a9d349f0136','icon_file_docx.svg','svg','image/svg+xml',3150,1736937665,1),('23094eec-d504-42ab-b551-04d1ebf52ac8','icon_file_odt.svg','svg','image/svg+xml',3146,1736937665,1),('42b5a867-379e-4419-93c7-8543b765270b','icon_file_wav.svg','svg','image/svg+xml',3146,1736937665,1),('4d5c5dff-44e8-4317-871d-17187f918485','icon_file_avi.svg','svg','image/svg+xml',3146,1736937665,1),('53c4549e-eca4-476e-877f-d1bba0e453d3','icon_file_bmp.svg','svg','image/svg+xml',3146,1736937665,1),('5ffe2456-0be0-4524-b8b3-a5c237702e15','icon_file_rtf.svg','svg','image/svg+xml',3145,1736937665,1),('722c7b76-85a4-4b07-87bb-e479bc3df40a','icon_file_svg.svg','svg','image/svg+xml',3145,1736937665,1),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65','icon_file_mov.svg','svg','image/svg+xml',3146,1736937665,1),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96','icon_file_pdf.svg','svg','image/svg+xml',3145,1736937665,1),('a1fc8b97-6c05-41a5-af52-89273d9c72de','icon_file_flv.svg','svg','image/svg+xml',3146,1736937665,1),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d','icon_file_mp3.svg','svg','image/svg+xml',3146,1736937665,1),('aacfe9c8-2f4b-4525-837e-70438cf71e2a','icon_file_ods.svg','svg','image/svg+xml',3146,1736937665,1),('adfdf6b7-577a-480e-8ba4-d8273662f772','icon_file_md.svg','svg','image/svg+xml',3143,1736937665,1),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80','icon_file_txt.svg','svg','image/svg+xml',3145,1736937665,1),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b','icon_file_jpg.svg','svg','image/svg+xml',3145,1736937665,1),('c5ce87c9-fff4-4088-902f-bfb1471897c8','icon_file_xml.svg','svg','image/svg+xml',3146,1736937665,1),('c714e72b-e42d-48fa-a295-98054f3c07ab','icon_file_ico.svg','svg','image/svg+xml',3146,1736937665,1),('cad6e286-5ab3-41d9-bbad-aeb29f687d28','icon_file_xlsx.svg','svg','image/svg+xml',3146,1736937665,1),('d37fe299-bb5d-49f1-9477-8518c2f5f26d','icon_file_wma.svg','svg','image/svg+xml',3145,1736937665,1),('d73b34c0-57c4-40da-a6d5-40aa39a17152','icon_file_png.svg','svg','image/svg+xml',3145,1736937665,1),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae','icon_file_odp.svg','svg','image/svg+xml',3146,1736937665,1),('f6a3359c-9af2-43e4-834f-20abdf327784','icon_file_gif.svg','svg','image/svg+xml',3146,1736937665,1),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6','icon_file_pptx.svg','svg','image/svg+xml',3145,1736937665,1); /*!40000 ALTER TABLE `il_resource_info` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_rc` --
DROP TABLE IF EXISTS `il_resource_rc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_rc` --
LOCK TABLES `il_resource_rc` WRITE; /*!40000 ALTER TABLE `il_resource_rc` DISABLE KEYS */; /*!40000 ALTER TABLE `il_resource_rc` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_rca` --
DROP TABLE IF EXISTS `il_resource_rca`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_rca` --
LOCK TABLES `il_resource_rca` WRITE; /*!40000 ALTER TABLE `il_resource_rca` DISABLE KEYS */; /*!40000 ALTER TABLE `il_resource_rca` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_revision` --
DROP TABLE IF EXISTS `il_resource_revision`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_revision` --
LOCK TABLES `il_resource_revision` WRITE; /*!40000 ALTER TABLE `il_resource_revision` DISABLE KEYS */; INSERT INTO `il_resource_revision` VALUES ('02a0534b-c6b2-4554-b98f-5da202f47430',1,1,6,'icon_file_mp4.svg',10),('0e8bc61c-43e1-4fca-bdf5-866910439b90',1,1,6,'icon_file_csv.svg',10),('179c1e39-6747-4e3a-90b8-d9deb5a2a886',1,1,6,'icon_file_tiff.svg',10),('1a14df55-7784-4ae4-b2d7-3a9d349f0136',1,1,6,'icon_file_docx.svg',10),('23094eec-d504-42ab-b551-04d1ebf52ac8',1,1,6,'icon_file_odt.svg',10),('42b5a867-379e-4419-93c7-8543b765270b',1,1,6,'icon_file_wav.svg',10),('4d5c5dff-44e8-4317-871d-17187f918485',1,1,6,'icon_file_avi.svg',10),('53c4549e-eca4-476e-877f-d1bba0e453d3',1,1,6,'icon_file_bmp.svg',10),('5ffe2456-0be0-4524-b8b3-a5c237702e15',1,1,6,'icon_file_rtf.svg',10),('722c7b76-85a4-4b07-87bb-e479bc3df40a',1,1,6,'icon_file_svg.svg',10),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65',1,1,6,'icon_file_mov.svg',10),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96',1,1,6,'icon_file_pdf.svg',10),('a1fc8b97-6c05-41a5-af52-89273d9c72de',1,1,6,'icon_file_flv.svg',10),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d',1,1,6,'icon_file_mp3.svg',10),('aacfe9c8-2f4b-4525-837e-70438cf71e2a',1,1,6,'icon_file_ods.svg',10),('adfdf6b7-577a-480e-8ba4-d8273662f772',1,1,6,'icon_file_md.svg',10),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80',1,1,6,'icon_file_txt.svg',10),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b',1,1,6,'icon_file_jpg.svg',10),('c5ce87c9-fff4-4088-902f-bfb1471897c8',1,1,6,'icon_file_xml.svg',10),('c714e72b-e42d-48fa-a295-98054f3c07ab',1,1,6,'icon_file_ico.svg',10),('cad6e286-5ab3-41d9-bbad-aeb29f687d28',1,1,6,'icon_file_xlsx.svg',10),('d37fe299-bb5d-49f1-9477-8518c2f5f26d',1,1,6,'icon_file_wma.svg',10),('d73b34c0-57c4-40da-a6d5-40aa39a17152',1,1,6,'icon_file_png.svg',10),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae',1,1,6,'icon_file_odp.svg',10),('f6a3359c-9af2-43e4-834f-20abdf327784',1,1,6,'icon_file_gif.svg',10),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6',1,1,6,'icon_file_pptx.svg',10); /*!40000 ALTER TABLE `il_resource_revision` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_stkh` --
DROP TABLE IF EXISTS `il_resource_stkh`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_stkh` --
LOCK TABLES `il_resource_stkh` WRITE; /*!40000 ALTER TABLE `il_resource_stkh` DISABLE KEYS */; INSERT INTO `il_resource_stkh` VALUES ('file_icon','ILIAS\\File\\Icon\\ilObjFileIconStakeholder'); /*!40000 ALTER TABLE `il_resource_stkh` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_resource_stkh_u` --
DROP TABLE IF EXISTS `il_resource_stkh_u`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_resource_stkh_u` --
LOCK TABLES `il_resource_stkh_u` WRITE; /*!40000 ALTER TABLE `il_resource_stkh_u` DISABLE KEYS */; INSERT INTO `il_resource_stkh_u` VALUES ('02a0534b-c6b2-4554-b98f-5da202f47430','file_icon'),('0e8bc61c-43e1-4fca-bdf5-866910439b90','file_icon'),('179c1e39-6747-4e3a-90b8-d9deb5a2a886','file_icon'),('1a14df55-7784-4ae4-b2d7-3a9d349f0136','file_icon'),('23094eec-d504-42ab-b551-04d1ebf52ac8','file_icon'),('42b5a867-379e-4419-93c7-8543b765270b','file_icon'),('4d5c5dff-44e8-4317-871d-17187f918485','file_icon'),('53c4549e-eca4-476e-877f-d1bba0e453d3','file_icon'),('5ffe2456-0be0-4524-b8b3-a5c237702e15','file_icon'),('722c7b76-85a4-4b07-87bb-e479bc3df40a','file_icon'),('79fa895d-bc0d-46e9-a70a-e2b9fa584b65','file_icon'),('82e5c4f3-cd7a-4aae-b8a8-be9515520b96','file_icon'),('a1fc8b97-6c05-41a5-af52-89273d9c72de','file_icon'),('a938bc20-b0ba-49c0-ae12-dac7a2a2be5d','file_icon'),('aacfe9c8-2f4b-4525-837e-70438cf71e2a','file_icon'),('adfdf6b7-577a-480e-8ba4-d8273662f772','file_icon'),('b028cd5d-98e0-4fb2-a12d-cf3dd5245b80','file_icon'),('b878b8bc-33d3-4379-bf49-2baf14d2ea3b','file_icon'),('c5ce87c9-fff4-4088-902f-bfb1471897c8','file_icon'),('c714e72b-e42d-48fa-a295-98054f3c07ab','file_icon'),('cad6e286-5ab3-41d9-bbad-aeb29f687d28','file_icon'),('d37fe299-bb5d-49f1-9477-8518c2f5f26d','file_icon'),('d73b34c0-57c4-40da-a6d5-40aa39a17152','file_icon'),('da45fb8f-8002-4cd1-a6c1-cd4b7e9bdaae','file_icon'),('f6a3359c-9af2-43e4-834f-20abdf327784','file_icon'),('ffa64706-ca8c-4a9b-9bb5-7c280c990ef6','file_icon'); /*!40000 ALTER TABLE `il_resource_stkh_u` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_subscribers` --
DROP TABLE IF EXISTS `il_subscribers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_subscribers` --
LOCK TABLES `il_subscribers` WRITE; /*!40000 ALTER TABLE `il_subscribers` DISABLE KEYS */; /*!40000 ALTER TABLE `il_subscribers` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_tag` --
DROP TABLE IF EXISTS `il_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_tag` --
LOCK TABLES `il_tag` WRITE; /*!40000 ALTER TABLE `il_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `il_tag` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_translations` --
DROP TABLE IF EXISTS `il_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_translations` --
LOCK TABLES `il_translations` WRITE; /*!40000 ALTER TABLE `il_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `il_translations` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_upload_policy` --
DROP TABLE IF EXISTS `il_upload_policy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_upload_policy` --
LOCK TABLES `il_upload_policy` WRITE; /*!40000 ALTER TABLE `il_upload_policy` DISABLE KEYS */; /*!40000 ALTER TABLE `il_upload_policy` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_upload_policy_seq` --
DROP TABLE IF EXISTS `il_upload_policy_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_upload_policy_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_upload_policy_seq` --
LOCK TABLES `il_upload_policy_seq` WRITE; /*!40000 ALTER TABLE `il_upload_policy_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `il_upload_policy_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_verification` --
DROP TABLE IF EXISTS `il_verification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_verification` ( `id` int(11) NOT NULL DEFAULT '0', `type` varchar(100) NOT NULL DEFAULT '', `parameters` varchar(1000) DEFAULT NULL, `raw_data` longtext, PRIMARY KEY (`id`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_verification` --
LOCK TABLES `il_verification` WRITE; /*!40000 ALTER TABLE `il_verification` DISABLE KEYS */; /*!40000 ALTER TABLE `il_verification` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_wac_secure_path` --
DROP TABLE IF EXISTS `il_wac_secure_path`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_wac_secure_path` ( `path` varchar(64) NOT NULL DEFAULT ' ', `component_directory` varchar(256) DEFAULT NULL, `checking_class` varchar(256) DEFAULT NULL, `in_sec_folder` tinyint(4) DEFAULT NULL, PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_wac_secure_path` --
LOCK TABLES `il_wac_secure_path` WRITE; /*!40000 ALTER TABLE `il_wac_secure_path` DISABLE KEYS */; INSERT INTO `il_wac_secure_path` VALUES ('assessment','[[softpath]]/Modules/Test','ilObjTestAccess',0),('chatroom','[[softpath]]/Modules/Chatroom','ilObjChatroomAccess',0),('container_data','[[softpath]]/Services/Container','ilContainerAccess',0),('css','[[softpath]]/Services/Style','ilContentStyleWAC',0),('custom_icons','[[softpath]]/Services/Object','ilObjectAccess',0),('ilBadge','[[softpath]]/Services/Badge','ilBadgeWAC',1),('ilBlog','[[softpath]]/Modules/Blog','ilObjBlogAccess',1),('ilBookingManager','[[softpath]]/Modules/BookingManager','ilObjBookingPoolAccess',0),('ilExercise','[[softpath]]/Modules/Exercise','ilObjExerciseAccess',0),('ilPoll','[[softpath]]/Modules/Poll','ilObjPollAccess',1),('ilPortfolio','[[softpath]]/Modules/Portfolio','ilPortfolioAccessHandler',1),('lm_data','[[softpath]]/Modules/LearningModule','ilObjLearningModuleAccess',0),('mobs','[[softpath]]/Services/MediaObjects','ilObjMediaObjectAccess',0),('previews','[[softpath]]/Modules/File','ilObjFileAccess',0),('rs','[[softpath]]/Services/ResourceStorage','ilWACSignedResourceStorage',1),('thumbs','[[softpath]]/Services/MediaObjects','ilObjMediaObjectAccess',0),('usr_images','[[softpath]]/Services/User','ilObjUserAccess',0); /*!40000 ALTER TABLE `il_wac_secure_path` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `il_wiki_contributor` --
DROP TABLE IF EXISTS `il_wiki_contributor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `il_wiki_contributor` ( `wiki_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `status` int(11) DEFAULT NULL, `status_time` datetime DEFAULT NULL, PRIMARY KEY (`wiki_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `il_wiki_contributor` --
LOCK TABLES `il_wiki_contributor` WRITE; /*!40000 ALTER TABLE `il_wiki_contributor` DISABLE KEYS */; /*!40000 ALTER TABLE `il_wiki_contributor` ENABLE KEYS */; UNLOCK TABLES;
LOCK TABLES `page_layout` WRITE; /*!40000 ALTER TABLE `page_layout` DISABLE KEYS */; INSERT INTO `page_layout` VALUES (1,'','Text page with accompanying media','Example description',1,0,0,1,0,NULL),(2,'','Text page with accompanying media and test','',1,0,0,1,0,NULL),(3,'','Text page with accompanying media followed by test and text','',1,0,0,1,0,NULL),(4,'','Media page with accompanying text and test','',1,0,0,1,0,NULL),(5,'','Vertical component navigation page with media and text ','',1,0,0,1,0,NULL),(6,'','Leading image with text','',1,0,0,1,NULL,NULL); /*!40000 ALTER TABLE `page_layout` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `page_layout_seq` --
DROP TABLE IF EXISTS `page_layout_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `page_layout_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `page_layout_seq` --
LOCK TABLES `page_layout_seq` WRITE; /*!40000 ALTER TABLE `page_layout_seq` DISABLE KEYS */; INSERT INTO `page_layout_seq` VALUES (6); /*!40000 ALTER TABLE `page_layout_seq` ENABLE KEYS */; UNLOCK TABLES;
LOCK TABLES `qpl_questions` WRITE; /*!40000 ALTER TABLE `qpl_questions` DISABLE KEYS */; /*!40000 ALTER TABLE `qpl_questions` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `qpl_questions_seq` --
DROP TABLE IF EXISTS `qpl_questions_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `qpl_questions_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `qpl_questions_seq` --
LOCK TABLES `qpl_questions_seq` WRITE; /*!40000 ALTER TABLE `qpl_questions_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `qpl_questions_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `qpl_sol_sug` --
DROP TABLE IF EXISTS `qpl_sol_sug`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `qpl_sol_sug` ( `suggested_solution_id` int(11) NOT NULL DEFAULT '0', `question_fi` int(11) NOT NULL DEFAULT '0', `internal_link` varchar(50) DEFAULT NULL, `import_id` varchar(50) DEFAULT NULL, `subquestion_index` int(11) NOT NULL DEFAULT '0', `type` varchar(32) DEFAULT NULL, `tstamp` int(11) NOT NULL DEFAULT '0', `value` longtext, PRIMARY KEY (`suggested_solution_id`), KEY `i1_idx` (`question_fi`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `qpl_sol_sug` --
LOCK TABLES `qpl_sol_sug` WRITE; /*!40000 ALTER TABLE `qpl_sol_sug` DISABLE KEYS */; /*!40000 ALTER TABLE `qpl_sol_sug` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `qpl_sol_sug_seq` --
DROP TABLE IF EXISTS `qpl_sol_sug_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `qpl_sol_sug_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `qpl_sol_sug_seq` --
LOCK TABLES `qpl_sol_sug_seq` WRITE; /*!40000 ALTER TABLE `qpl_sol_sug_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `qpl_sol_sug_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_fa` --
DROP TABLE IF EXISTS `rbac_fa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_fa` ( `rol_id` int(11) NOT NULL DEFAULT '0', `parent` int(11) NOT NULL DEFAULT '0', `assign` char(1) DEFAULT NULL, `protected` char(1) DEFAULT 'n', `blocked` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`rol_id`,`parent`), KEY `i1_idx` (`parent`), KEY `i2_idx` (`assign`,`rol_id`), KEY `i3_idx` (`assign`,`parent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_fa` --
LOCK TABLES `rbac_fa` WRITE; /*!40000 ALTER TABLE `rbac_fa` DISABLE KEYS */; INSERT INTO `rbac_fa` VALUES (2,8,'y','y',0),(3,8,'n','n',0),(4,8,'y','n',0),(5,8,'y','n',0),(14,8,'y','n',0),(80,8,'n','y',0),(81,8,'n','n',0),(82,8,'n','n',0),(83,8,'n','n',0),(110,8,'n','y',0),(111,8,'n','n',0),(112,8,'n','n',0),(125,8,'n','y',0),(131,8,'n','n',0),(148,8,'n','n',0),(187,46,'y','n',0),(188,8,'n','n',0),(202,8,'n','n',0),(222,8,'n','n',0),(231,8,'n','n',0),(267,8,'n','n',0),(268,8,'n','n',0),(269,8,'n','n',0),(278,8,'n','n',0),(279,8,'n','n',0); /*!40000 ALTER TABLE `rbac_fa` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_log` --
DROP TABLE IF EXISTS `rbac_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_log` ( `log_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `created` int(11) NOT NULL DEFAULT '0', `ref_id` int(11) NOT NULL DEFAULT '0', `action` tinyint(4) NOT NULL DEFAULT '0', `data` longtext, PRIMARY KEY (`log_id`), KEY `i1_idx` (`ref_id`), KEY `i2_idx` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_log` --
LOCK TABLES `rbac_log` WRITE; /*!40000 ALTER TABLE `rbac_log` DISABLE KEYS */; /*!40000 ALTER TABLE `rbac_log` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_log_seq` --
DROP TABLE IF EXISTS `rbac_log_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_log_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_log_seq` --
LOCK TABLES `rbac_log_seq` WRITE; /*!40000 ALTER TABLE `rbac_log_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `rbac_log_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_operations` --
DROP TABLE IF EXISTS `rbac_operations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_operations` ( `ops_id` int(11) NOT NULL DEFAULT '0', `operation` char(32) DEFAULT NULL, `description` char(255) DEFAULT NULL, `class` char(16) DEFAULT NULL, `op_order` smallint(6) DEFAULT NULL, PRIMARY KEY (`ops_id`), KEY `i1_idx` (`operation`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_operations` --
LOCK TABLES `rbac_operations` WRITE; /*!40000 ALTER TABLE `rbac_operations` DISABLE KEYS */; INSERT INTO `rbac_operations` VALUES (1,'edit_permission','edit permissions','rbac',9000),(2,'visible','view object','general',1000),(3,'read','access object','general',2000),(4,'write','modify object','general',6000),(6,'delete','remove object','general',8000),(7,'join','join/subscribe','object',1200),(8,'leave','leave/unsubscribe','object',1400),(9,'add_reply','Reply to forum articles','object',3050),(10,'moderate_frm','delete forum articles','object',3750),(11,'smtp_mail','send external mail','object',210),(13,'create_usr','create new user account','create',9999),(14,'create_role','create new role definition','create',9999),(15,'create_rolt','create new role definition template','create',9999),(16,'create_cat','create new category','create',9999),(17,'create_grp','create new group','create',9999),(18,'create_frm','create new forum','create',9999),(19,'create_crs','create new course','create',9999),(20,'create_lm','create new learning module','create',9999),(21,'create_sahs','create new SCORM/AICC learning module','create',9999),(22,'create_glo','create new glossary','create',9999),(24,'create_exc','create new exercise','create',9999),(25,'create_file','upload new file','create',9999),(26,'create_fold','create new folder','create',9999),(27,'create_tst','create new test','create',9999),(28,'create_qpl','create new question pool','create',9999),(30,'internal_mail','users can use mail system','object',200),(31,'create_mep','create new media pool','create',9999),(32,'create_htlm','create new html learning module','create',9999),(40,'edit_userassignment','change userassignment of roles','object',2500),(41,'edit_roleassignment','change roleassignments of user accounts','object',2500),(42,'create_svy','create new survey','create',9999),(43,'create_spl','create new question pool (Survey)','create',9999),(45,'invite','invite','object',2600),(47,'cat_administrate_users','Administrate local user','object',7050),(48,'read_users','read local users','object',7000),(49,'push_desktop_items','Allow pushing desktop items','object',2400),(50,'create_webr','create web resource','create',9999),(51,'search','Allow using search','object',300),(52,'moderate','Moderate objects','object',3700),(55,'edit_learning_progress','edit learning progress','object',3600),(56,'tst_statistics','view the statistics of a test','object',7100),(57,'export_member_data','Export member data','object',0),(58,'copy','Copy Object','general',4000),(59,'create_feed','create external feed','create',9999),(60,'create_mcst','create media cast','create',9999),(61,'create_rcrs','create remote course','create',9999),(62,'add_thread','Add Threads','object',3100),(63,'create_sess','create session','create',9999),(64,'edit_content','Edit content','object',3000),(65,'create_wiki','create wiki','create',9999),(66,'edit_event','Edit calendar event','object',3600),(67,'create_crsr','create course reference','create',9999),(68,'create_catr','create category reference','create',9999),(69,'mail_to_global_roles','User may send mails to global roles','object',230),(71,'create_book','create booking pool','create',9999),(72,'add_consultation_hours','Add Consultation Hours Calendar','object',300),(73,'create_chtr','create chatroom','create',9999),(74,'create_blog','Create Blog','create',9999),(75,'create_dcl','Create Data Collection','create',9999),(76,'create_poll','Create Poll','create',9999),(77,'add_entry','Add Entry','object',3200),(78,'create_itgr','Create Item Group','create',9999),(79,'contribute','Contribute','object',3205),(80,'lp_other_users','See LP Data Of Other Users','object',250),(81,'create_bibl','Create Bibliographic','create',9999),(82,'create_cld','Create Cloud Folder','create',9999),(83,'upload','Upload Items','object',3240),(84,'delete_files','Delete Files','object',3260),(85,'delete_folders','Delete Folders','object',3270),(86,'download','Download Items','object',3230),(87,'files_visible','Files are visible','object',3210),(88,'folders_visible','Folders are visible','object',3220),(89,'folders_create','Folders may be created','object',3250),(90,'create_prtt','Create Portfolio Template','create',9999),(91,'create_orgu','Create OrgUnit','create',9999),(92,'view_learning_progress','View learning progress from users in this orgu.','object',270),(93,'view_learning_progress_rec','View learning progress from users in this orgu and subsequent orgus.','object',280),(94,'statistics_read','Read Statistics','object',2200),(95,'read_learning_progress','Read Learning Progress','object',2300),(96,'redact','Redact','object',3900),(97,'edit_wiki_navigation','Edit Wiki Navigation','object',3220),(98,'delete_wiki_pages','Delete Wiki Pages','object',3300),(99,'activate_wiki_protection','Set Read-Only','object',3240),(100,'wiki_html_export','Wiki HTML Export','object',3242),(101,'create_prg','Create Study Programme','create',9999),(102,'manage_members','Manage Members','object',2400),(103,'sty_write_content','Edit Content Styles','object',6101),(104,'sty_write_system','Edit System Styles','object',6100),(105,'sty_write_page_layout','Edit Page Layouts','object',6102),(106,'create_grpr','Create Group Reference','create',9999),(107,'news_add_news','Add News','object',2100),(108,'create_iass','Create Individual Assessment','create',9999),(109,'edit_members','Manage members','object',2400),(110,'amend_grading','Amend grading','object',8200),(111,'grade','Grade','object',2410),(112,'edit_page_meta','Edit Page Metadata','object',3050),(113,'release_objects','Release objects','object',500),(114,'edit_submissions_grades','Edit Submissions Grades','object',3800),(115,'tst_results','view the results of test participants','object',7050),(116,'create_copa','Create Content Page Object','create',9999),(117,'manage_materials','Manage Materials','object',6500),(118,'edit_metadata','Edit Metadata','object',5800),(119,'create_lso','Create Learning Sequence','create',9999),(120,'participate','Participate to Learning Sequence','object',1010),(121,'unparticipate','Unparticipate from Learning Sequence','object',1020),(122,'read_results','Access Results','object',2500),(123,'change_presentation','change presentation of a view','object',200),(124,'upload_blacklisted_files','Upload Blacklisted Files','object',1),(125,'read_outcomes','Access Outcomes','object',2250),(126,'create_lti','Create LTI Consumer Object','create',9999),(127,'create_cmix','Create cmi5/xAPI Object','create',9999),(128,'add_consume_provider','Allow Add Own Provider','object',3510),(129,'create_prgr','Create Study Programme Reference','create',9999),(130,'add_pages','Create Pages','object',3070),(131,'edit_file','Edit File','object',5990),(132,'read_comp','Read Competences','object',6500),(133,'read_profiles','Read Competence Profiles','object',6510),(134,'manage_comp','Manage Competences','object',8500),(135,'manage_comp_temp','Manage Competence Templates','object',8510),(136,'manage_profiles','Manage Competence Profiles','object',8520),(137,'create_skee','Create Skill Tree','create',9999); /*!40000 ALTER TABLE `rbac_operations` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_operations_seq` --
DROP TABLE IF EXISTS `rbac_operations_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_operations_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_operations_seq` --
LOCK TABLES `rbac_operations_seq` WRITE; /*!40000 ALTER TABLE `rbac_operations_seq` DISABLE KEYS */; INSERT INTO `rbac_operations_seq` VALUES (137); /*!40000 ALTER TABLE `rbac_operations_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_pa` --
DROP TABLE IF EXISTS `rbac_pa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_pa` ( `rol_id` int(11) NOT NULL DEFAULT '0', `ops_id` varchar(4000) DEFAULT NULL, `ref_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`rol_id`,`ref_id`), KEY `i1_idx` (`ref_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_pa` --
LOCK TABLES `rbac_pa` WRITE; /*!40000 ALTER TABLE `rbac_pa` DISABLE KEYS */; INSERT INTO `rbac_pa` VALUES (2,'a:1:{i:0;s:2:\"51\";}',22),(3,'a:1:{i:0;s:2:\"51\";}',22),(4,'a:2:{i:0;i:3;i:1;i:2;}',1),(4,'a:1:{i:0;i:30;}',12),(4,'a:1:{i:0;i:51;}',22),(4,'a:2:{i:0;i:2;i:1;i:3;}',24),(4,'a:2:{i:0;i:2;i:1;i:3;}',46),(5,'a:2:{i:0;i:3;i:1;i:2;}',1),(5,'a:2:{i:0;i:30;i:1;i:69;}',12),(5,'a:1:{i:0;s:2:\"51\";}',22),(14,'a:2:{i:0;i:3;i:1;i:2;}',1),(14,'a:1:{i:0;i:69;}',12),(14,'a:1:{i:0;s:2:\"51\";}',22),(80,'a:1:{i:0;s:2:\"51\";}',22),(81,'a:1:{i:0;s:2:\"51\";}',22),(82,'a:1:{i:0;s:2:\"51\";}',22),(83,'a:1:{i:0;s:2:\"51\";}',22),(110,'a:1:{i:0;s:2:\"51\";}',22),(111,'a:1:{i:0;s:2:\"51\";}',22),(112,'a:1:{i:0;s:2:\"51\";}',22),(187,'a:3:{i:0;i:52;i:1;i:3;i:2;i:2;}',46); /*!40000 ALTER TABLE `rbac_pa` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_ta` --
DROP TABLE IF EXISTS `rbac_ta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_ta` ( `typ_id` int(11) NOT NULL DEFAULT '0', `ops_id` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`typ_id`,`ops_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_ta` --
LOCK TABLES `rbac_ta` WRITE; /*!40000 ALTER TABLE `rbac_ta` DISABLE KEYS */; INSERT INTO `rbac_ta` VALUES (15,1),(15,2),(15,3),(15,4),(15,6),(15,7),(15,8),(15,17),(15,18),(15,20),(15,21),(15,22),(15,24),(15,25),(15,26),(15,27),(15,28),(15,31),(15,32),(15,42),(15,43),(15,50),(15,55),(15,58),(15,59),(15,60),(15,63),(15,65),(15,66),(15,67),(15,68),(15,71),(15,73),(15,74),(15,75),(15,76),(15,78),(15,81),(15,82),(15,90),(15,95),(15,102),(15,106),(15,107),(15,111),(15,116),(15,119),(15,126),(15,127),(16,1),(16,2),(16,3),(16,4),(16,6),(16,16),(16,17),(16,18),(16,19),(16,20),(16,21),(16,22),(16,24),(16,25),(16,27),(16,28),(16,31),(16,32),(16,42),(16,43),(16,47),(16,48),(16,50),(16,58),(16,59),(16,60),(16,61),(16,65),(16,67),(16,68),(16,71),(16,73),(16,74),(16,75),(16,76),(16,78),(16,81),(16,82),(16,90),(16,101),(16,106),(16,108),(16,116),(16,119),(16,126),(16,127),(17,1),(17,2),(17,3),(17,4),(17,6),(17,7),(17,8),(17,17),(17,18),(17,20),(17,21),(17,22),(17,24),(17,25),(17,26),(17,27),(17,28),(17,31),(17,32),(17,42),(17,43),(17,50),(17,55),(17,58),(17,59),(17,60),(17,63),(17,65),(17,66),(17,67),(17,68),(17,71),(17,73),(17,74),(17,75),(17,76),(17,78),(17,81),(17,82),(17,90),(17,95),(17,102),(17,106),(17,107),(17,108),(17,111),(17,116),(17,119),(17,126),(17,127),(19,1),(19,2),(19,3),(19,4),(19,11),(19,30),(19,69),(20,1),(20,2),(20,3),(20,4),(20,6),(20,55),(20,58),(20,95),(21,1),(21,2),(21,3),(21,4),(22,1),(22,2),(22,3),(22,4),(22,6),(22,13),(22,41),(22,49),(23,1),(23,2),(23,3),(23,4),(23,6),(23,14),(23,15),(23,40),(24,1),(24,2),(24,3),(24,4),(28,1),(28,2),(28,3),(28,4),(32,1),(32,2),(32,3),(32,4),(32,6),(32,58),(32,64),(33,1),(33,2),(33,3),(33,4),(33,16),(33,17),(33,18),(33,19),(33,20),(33,21),(33,22),(33,24),(33,25),(33,27),(33,28),(33,31),(33,32),(33,42),(33,43),(33,50),(33,59),(33,60),(33,61),(33,65),(33,67),(33,68),(33,71),(33,73),(33,74),(33,75),(33,76),(33,78),(33,81),(33,82),(33,90),(33,91),(33,101),(33,106),(33,108),(33,116),(33,119),(33,126),(33,127),(34,1),(34,2),(34,3),(34,4),(34,6),(34,55),(34,58),(34,95),(37,1),(37,2),(37,3),(37,4),(37,6),(37,9),(37,10),(37,55),(37,58),(37,62),(37,95),(84,1),(84,2),(84,3),(84,4),(84,6),(84,55),(84,58),(84,95),(84,114),(85,1),(85,2),(85,3),(85,4),(87,1),(87,2),(87,3),(87,4),(87,6),(87,17),(87,18),(87,20),(87,21),(87,22),(87,24),(87,25),(87,26),(87,27),(87,28),(87,31),(87,32),(87,42),(87,43),(87,50),(87,55),(87,58),(87,60),(87,63),(87,65),(87,71),(87,73),(87,74),(87,75),(87,76),(87,78),(87,81),(87,82),(87,90),(87,95),(87,106),(87,116),(87,119),(87,126),(87,127),(88,1),(88,2),(88,3),(88,4),(88,6),(88,55),(88,58),(88,95),(88,131),(94,1),(94,2),(94,3),(94,4),(94,6),(94,55),(94,56),(94,58),(94,95),(94,115),(95,1),(95,2),(95,3),(95,4),(95,6),(95,58),(96,1),(96,2),(96,3),(96,4),(96,6),(96,52),(96,58),(97,1),(97,2),(97,3),(97,4),(99,1),(99,2),(99,3),(99,4),(101,1),(101,2),(101,3),(101,4),(101,6),(101,58),(102,1),(102,2),(102,3),(102,4),(102,6),(102,55),(102,58),(102,95),(103,1),(103,2),(103,3),(103,4),(103,6),(103,45),(103,55),(103,58),(103,95),(103,122),(104,1),(104,2),(104,3),(104,4),(104,6),(104,58),(106,1),(106,2),(106,3),(106,4),(106,66),(106,70),(106,72),(108,1),(108,2),(108,3),(108,4),(108,6),(108,80),(115,1),(115,2),(115,3),(115,4),(117,1),(117,2),(117,3),(117,103),(117,104),(117,105),(122,1),(122,2),(122,3),(122,4),(122,6),(122,58),(123,1),(123,2),(123,3),(123,4),(123,51),(127,1),(127,2),(127,3),(127,4),(135,1),(135,2),(135,3),(135,4),(137,1),(137,2),(137,3),(137,4),(137,57),(139,1),(139,2),(139,3),(139,4),(141,1),(141,3),(141,4),(141,6),(141,58),(142,1),(142,2),(142,3),(142,4),(142,6),(142,55),(142,58),(142,95),(143,1),(143,2),(143,3),(143,4),(143,123),(145,1),(145,2),(145,3),(145,4),(145,6),(146,1),(146,2),(146,3),(146,4),(149,1),(149,2),(149,3),(149,4),(151,1),(151,2),(151,3),(151,4),(151,124),(153,1),(153,2),(153,3),(153,4),(155,1),(155,2),(155,3),(155,4),(155,6),(155,55),(155,58),(155,95),(155,102),(155,117),(155,118),(156,1),(156,2),(156,3),(156,4),(158,1),(158,2),(158,3),(158,4),(158,6),(158,58),(158,64),(158,94),(158,97),(158,98),(158,99),(158,100),(158,112),(158,130),(159,1),(159,2),(159,4),(159,6),(159,55),(159,58),(159,95),(160,1),(160,2),(160,4),(160,6),(160,58),(161,1),(161,2),(161,3),(161,4),(163,1),(163,2),(163,3),(163,4),(165,1),(165,2),(165,3),(165,4),(167,1),(167,2),(167,3),(167,4),(169,1),(169,2),(169,3),(169,4),(171,1),(171,2),(171,3),(171,4),(173,1),(173,2),(173,3),(173,4),(173,6),(173,58),(174,1),(174,2),(174,3),(174,4),(174,137),(176,1),(176,2),(176,3),(176,4),(178,1),(178,2),(178,3),(178,4),(180,1),(180,2),(180,3),(180,4),(180,6),(180,52),(180,58),(182,1),(182,2),(182,3),(182,4),(183,1),(183,2),(183,3),(183,4),(189,1),(189,2),(189,3),(189,4),(189,6),(189,58),(189,79),(189,96),(190,1),(190,2),(190,3),(190,4),(190,6),(190,58),(190,64),(190,77),(191,1),(191,3),(191,4),(191,6),(191,58),(192,1),(192,2),(192,3),(192,4),(194,1),(194,2),(194,3),(194,4),(194,6),(194,58),(195,1),(195,2),(195,3),(195,4),(195,6),(196,1),(196,2),(196,3),(196,4),(196,6),(197,1),(197,2),(197,3),(197,4),(197,6),(198,1),(198,2),(198,3),(198,4),(198,6),(199,1),(199,2),(199,3),(199,4),(199,6),(200,1),(200,2),(200,3),(200,4),(200,6),(201,1),(201,2),(201,3),(201,4),(201,6),(203,1),(203,2),(203,3),(203,4),(205,1),(205,2),(205,3),(205,4),(207,1),(207,2),(207,3),(207,4),(207,6),(207,58),(208,1),(208,2),(208,3),(208,4),(210,1),(210,2),(210,3),(210,4),(210,6),(210,83),(210,84),(210,85),(210,86),(210,87),(210,88),(210,89),(211,1),(211,2),(211,3),(211,4),(213,1),(213,2),(213,3),(213,4),(215,1),(215,2),(215,3),(215,4),(217,1),(217,2),(217,3),(217,4),(219,1),(219,2),(219,3),(219,4),(219,6),(219,58),(220,1),(220,2),(220,3),(220,4),(220,6),(220,47),(220,48),(220,58),(220,91),(220,92),(220,93),(223,1),(223,2),(223,3),(223,4),(225,1),(225,2),(225,3),(225,4),(227,1),(227,2),(227,3),(227,4),(229,1),(229,2),(229,3),(229,4),(232,1),(232,2),(232,3),(232,4),(234,1),(234,2),(234,3),(234,4),(236,1),(236,2),(236,3),(236,4),(236,6),(236,58),(236,101),(236,102),(236,129),(237,1),(237,2),(237,3),(237,4),(239,1),(239,2),(239,3),(239,4),(261,1),(261,2),(261,4),(261,6),(261,58),(262,1),(262,2),(262,3),(262,4),(266,1),(266,2),(266,3),(266,4),(266,6),(266,55),(266,58),(266,95),(266,109),(266,110),(272,1),(272,2),(272,3),(272,4),(272,113),(272,128),(274,1),(274,2),(274,3),(274,4),(274,6),(274,55),(274,58),(274,95),(275,1),(275,2),(275,3),(275,4),(277,1),(277,2),(277,3),(277,4),(277,6),(277,55),(277,58),(277,95),(277,102),(277,120),(277,121),(280,1),(280,2),(280,3),(280,4),(280,6),(280,55),(280,58),(280,95),(280,125),(281,1),(281,2),(281,3),(281,4),(281,6),(281,55),(281,58),(281,95),(281,125),(282,1),(282,2),(282,3),(282,4),(284,1),(284,2),(284,3),(284,4),(286,1),(286,2),(286,3),(286,4),(288,1),(288,2),(288,3),(288,4),(290,1),(290,2),(290,3),(290,4),(292,1),(292,2),(292,4),(292,6),(292,58),(293,1),(293,2),(293,3),(293,4),(295,1),(295,2),(295,3),(295,4),(297,1),(297,2),(297,3),(297,4),(299,1),(299,2),(299,3),(299,4),(301,1),(301,2),(301,3),(301,4),(303,1),(303,2),(303,3),(303,4),(305,1),(305,2),(305,3),(305,4),(307,1),(307,2),(307,3),(307,4),(309,1),(309,2),(309,3),(309,4),(311,1),(311,2),(311,3),(311,4),(311,6),(311,58),(311,132),(311,133),(311,134),(311,135),(311,136); /*!40000 ALTER TABLE `rbac_ta` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_templates` --
DROP TABLE IF EXISTS `rbac_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_templates` ( `rol_id` int(11) NOT NULL DEFAULT '0', `type` char(5) NOT NULL DEFAULT '', `ops_id` int(11) NOT NULL DEFAULT '0', `parent` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`rol_id`,`parent`,`type`,`ops_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_templates` --
LOCK TABLES `rbac_templates` WRITE; /*!40000 ALTER TABLE `rbac_templates` DISABLE KEYS */; INSERT INTO `rbac_templates` VALUES (3,'bibl',1,8),(3,'bibl',2,8),(3,'bibl',3,8),(3,'bibl',4,8),(3,'bibl',6,8),(3,'bibl',58,8),(3,'blog',1,8),(3,'blog',2,8),(3,'blog',3,8),(3,'blog',4,8),(3,'blog',6,8),(3,'blog',58,8),(3,'blog',79,8),(3,'blog',96,8),(3,'book',1,8),(3,'book',2,8),(3,'book',3,8),(3,'book',4,8),(3,'book',6,8),(3,'book',58,8),(3,'cat',2,8),(3,'cat',3,8),(3,'cat',4,8),(3,'cat',6,8),(3,'cat',16,8),(3,'cat',17,8),(3,'cat',18,8),(3,'cat',19,8),(3,'cat',20,8),(3,'cat',21,8),(3,'cat',22,8),(3,'cat',24,8),(3,'cat',25,8),(3,'cat',27,8),(3,'cat',28,8),(3,'cat',31,8),(3,'cat',32,8),(3,'cat',42,8),(3,'cat',43,8),(3,'cat',50,8),(3,'cat',58,8),(3,'cat',59,8),(3,'cat',60,8),(3,'cat',65,8),(3,'cat',67,8),(3,'cat',68,8),(3,'cat',71,8),(3,'cat',73,8),(3,'cat',74,8),(3,'cat',75,8),(3,'cat',76,8),(3,'cat',78,8),(3,'cat',81,8),(3,'cat',82,8),(3,'cat',90,8),(3,'cat',101,8),(3,'cat',106,8),(3,'cat',108,8),(3,'cat',116,8),(3,'cat',119,8),(3,'cat',126,8),(3,'cat',127,8),(3,'catr',1,8),(3,'catr',2,8),(3,'catr',4,8),(3,'catr',6,8),(3,'catr',58,8),(3,'chtr',1,8),(3,'chtr',2,8),(3,'chtr',3,8),(3,'chtr',4,8),(3,'chtr',6,8),(3,'chtr',52,8),(3,'chtr',58,8),(3,'cld',1,8),(3,'cld',2,8),(3,'cld',3,8),(3,'cld',4,8),(3,'cld',6,8),(3,'cld',83,8),(3,'cld',84,8),(3,'cld',85,8),(3,'cld',86,8),(3,'cld',87,8),(3,'cld',88,8),(3,'cld',89,8),(3,'cmix',1,8),(3,'cmix',2,8),(3,'cmix',3,8),(3,'cmix',4,8),(3,'cmix',6,8),(3,'cmix',55,8),(3,'cmix',58,8),(3,'cmix',95,8),(3,'cmix',125,8),(3,'copa',1,8),(3,'copa',2,8),(3,'copa',3,8),(3,'copa',4,8),(3,'copa',6,8),(3,'copa',55,8),(3,'copa',58,8),(3,'copa',95,8),(3,'crs',1,8),(3,'crs',2,8),(3,'crs',3,8),(3,'crs',4,8),(3,'crs',6,8),(3,'crs',7,8),(3,'crs',8,8),(3,'crs',17,8),(3,'crs',18,8),(3,'crs',20,8),(3,'crs',21,8),(3,'crs',22,8),(3,'crs',24,8),(3,'crs',25,8),(3,'crs',26,8),(3,'crs',27,8),(3,'crs',28,8),(3,'crs',31,8),(3,'crs',32,8),(3,'crs',42,8),(3,'crs',43,8),(3,'crs',50,8),(3,'crs',55,8),(3,'crs',58,8),(3,'crs',59,8),(3,'crs',60,8),(3,'crs',63,8),(3,'crs',65,8),(3,'crs',66,8),(3,'crs',67,8),(3,'crs',68,8),(3,'crs',71,8),(3,'crs',73,8),(3,'crs',74,8),(3,'crs',75,8),(3,'crs',76,8),(3,'crs',78,8),(3,'crs',81,8),(3,'crs',82,8),(3,'crs',90,8),(3,'crs',95,8),(3,'crs',102,8),(3,'crs',106,8),(3,'crs',107,8),(3,'crs',108,8),(3,'crs',111,8),(3,'crs',116,8),(3,'crs',119,8),(3,'crs',126,8),(3,'crs',127,8),(3,'crsr',1,8),(3,'crsr',2,8),(3,'crsr',4,8),(3,'crsr',6,8),(3,'crsr',55,8),(3,'crsr',58,8),(3,'crsr',95,8),(3,'dcl',1,8),(3,'dcl',2,8),(3,'dcl',3,8),(3,'dcl',4,8),(3,'dcl',6,8),(3,'dcl',58,8),(3,'dcl',64,8),(3,'dcl',77,8),(3,'exc',1,8),(3,'exc',2,8),(3,'exc',3,8),(3,'exc',4,8),(3,'exc',6,8),(3,'exc',55,8),(3,'exc',58,8),(3,'exc',95,8),(3,'exc',114,8),(3,'feed',1,8),(3,'feed',3,8),(3,'feed',4,8),(3,'feed',6,8),(3,'feed',58,8),(3,'file',1,8),(3,'file',2,8),(3,'file',3,8),(3,'file',4,8),(3,'file',6,8),(3,'file',55,8),(3,'file',58,8),(3,'file',95,8),(3,'file',131,8),(3,'fold',1,8),(3,'fold',2,8),(3,'fold',3,8),(3,'fold',4,8),(3,'fold',6,8),(3,'fold',17,8),(3,'fold',18,8),(3,'fold',20,8),(3,'fold',21,8),(3,'fold',22,8),(3,'fold',24,8),(3,'fold',25,8),(3,'fold',26,8),(3,'fold',27,8),(3,'fold',28,8),(3,'fold',31,8),(3,'fold',32,8),(3,'fold',42,8),(3,'fold',43,8),(3,'fold',50,8),(3,'fold',55,8),(3,'fold',58,8),(3,'fold',60,8),(3,'fold',63,8),(3,'fold',65,8),(3,'fold',71,8),(3,'fold',73,8),(3,'fold',74,8),(3,'fold',75,8),(3,'fold',76,8),(3,'fold',78,8),(3,'fold',81,8),(3,'fold',82,8),(3,'fold',90,8),(3,'fold',95,8),(3,'fold',106,8),(3,'fold',108,8),(3,'fold',116,8),(3,'fold',119,8),(3,'fold',126,8),(3,'fold',127,8),(3,'frm',1,8),(3,'frm',2,8),(3,'frm',3,8),(3,'frm',4,8),(3,'frm',6,8),(3,'frm',9,8),(3,'frm',10,8),(3,'frm',55,8),(3,'frm',58,8),(3,'frm',62,8),(3,'frm',95,8),(3,'glo',1,8),(3,'glo',2,8),(3,'glo',3,8),(3,'glo',4,8),(3,'glo',6,8),(3,'glo',58,8),(3,'glo',64,8),(3,'grp',1,8),(3,'grp',2,8),(3,'grp',3,8),(3,'grp',4,8),(3,'grp',6,8),(3,'grp',7,8),(3,'grp',17,8),(3,'grp',18,8),(3,'grp',20,8),(3,'grp',21,8),(3,'grp',22,8),(3,'grp',24,8),(3,'grp',25,8),(3,'grp',26,8),(3,'grp',27,8),(3,'grp',28,8),(3,'grp',31,8),(3,'grp',32,8),(3,'grp',42,8),(3,'grp',43,8),(3,'grp',50,8),(3,'grp',55,8),(3,'grp',58,8),(3,'grp',59,8),(3,'grp',60,8),(3,'grp',63,8),(3,'grp',65,8),(3,'grp',66,8),(3,'grp',67,8),(3,'grp',68,8),(3,'grp',71,8),(3,'grp',73,8),(3,'grp',74,8),(3,'grp',75,8),(3,'grp',76,8),(3,'grp',78,8),(3,'grp',81,8),(3,'grp',82,8),(3,'grp',90,8),(3,'grp',95,8),(3,'grp',102,8),(3,'grp',106,8),(3,'grp',107,8),(3,'grp',108,8),(3,'grp',111,8),(3,'grp',116,8),(3,'grp',119,8),(3,'grp',126,8),(3,'grp',127,8),(3,'grpr',1,8),(3,'grpr',2,8),(3,'grpr',4,8),(3,'grpr',6,8),(3,'grpr',58,8),(3,'htlm',1,8),(3,'htlm',2,8),(3,'htlm',3,8),(3,'htlm',4,8),(3,'htlm',6,8),(3,'htlm',55,8),(3,'htlm',58,8),(3,'htlm',95,8),(3,'iass',1,8),(3,'iass',2,8),(3,'iass',3,8),(3,'iass',4,8),(3,'iass',6,8),(3,'iass',55,8),(3,'iass',58,8),(3,'iass',95,8),(3,'iass',109,8),(3,'itgr',1,8),(3,'itgr',2,8),(3,'itgr',3,8),(3,'itgr',4,8),(3,'itgr',6,8),(3,'itgr',58,8),(3,'lm',1,8),(3,'lm',2,8),(3,'lm',3,8),(3,'lm',4,8),(3,'lm',6,8),(3,'lm',55,8),(3,'lm',58,8),(3,'lm',95,8),(3,'lso',1,8),(3,'lso',2,8),(3,'lso',3,8),(3,'lso',4,8),(3,'lso',6,8),(3,'lso',55,8),(3,'lso',58,8),(3,'lso',95,8),(3,'lti',1,8),(3,'lti',2,8),(3,'lti',3,8),(3,'lti',4,8),(3,'lti',6,8),(3,'lti',55,8),(3,'lti',58,8),(3,'lti',95,8),(3,'lti',125,8),(3,'mcst',1,8),(3,'mcst',2,8),(3,'mcst',3,8),(3,'mcst',4,8),(3,'mcst',6,8),(3,'mcst',55,8),(3,'mcst',58,8),(3,'mcst',95,8),(3,'mep',1,8),(3,'mep',2,8),(3,'mep',3,8),(3,'mep',4,8),(3,'mep',6,8),(3,'mep',58,8),(3,'poll',1,8),(3,'poll',3,8),(3,'poll',4,8),(3,'poll',6,8),(3,'poll',58,8),(3,'prg',1,8),(3,'prg',2,8),(3,'prg',3,8),(3,'prg',4,8),(3,'prg',6,8),(3,'prg',58,8),(3,'prg',101,8),(3,'prg',102,8),(3,'prtt',1,8),(3,'prtt',2,8),(3,'prtt',3,8),(3,'prtt',4,8),(3,'prtt',6,8),(3,'prtt',58,8),(3,'qpl',1,8),(3,'qpl',2,8),(3,'qpl',3,8),(3,'qpl',4,8),(3,'qpl',6,8),(3,'qpl',58,8),(3,'root',2,8),(3,'root',3,8),(3,'sahs',1,8),(3,'sahs',2,8),(3,'sahs',3,8),(3,'sahs',4,8),(3,'sahs',6,8),(3,'sahs',55,8),(3,'sahs',58,8),(3,'sahs',95,8),(3,'sess',1,8),(3,'sess',2,8),(3,'sess',3,8),(3,'sess',4,8),(3,'sess',6,8),(3,'sess',55,8),(3,'sess',58,8),(3,'sess',95,8),(3,'sess',102,8),(3,'sess',117,8),(3,'sess',118,8),(3,'spl',1,8),(3,'spl',2,8),(3,'spl',3,8),(3,'spl',4,8),(3,'spl',6,8),(3,'spl',58,8),(3,'svy',1,8),(3,'svy',2,8),(3,'svy',3,8),(3,'svy',4,8),(3,'svy',6,8),(3,'svy',45,8),(3,'svy',55,8),(3,'svy',58,8),(3,'svy',95,8),(3,'svy',122,8),(3,'tst',1,8),(3,'tst',2,8),(3,'tst',3,8),(3,'tst',4,8),(3,'tst',6,8),(3,'tst',55,8),(3,'tst',56,8),(3,'tst',58,8),(3,'tst',95,8),(3,'tst',115,8),(3,'webr',1,8),(3,'webr',2,8),(3,'webr',3,8),(3,'webr',4,8),(3,'webr',6,8),(3,'webr',58,8),(3,'wiki',1,8),(3,'wiki',2,8),(3,'wiki',3,8),(3,'wiki',4,8),(3,'wiki',6,8),(3,'wiki',58,8),(3,'wiki',64,8),(3,'wiki',94,8),(3,'wiki',97,8),(3,'wiki',98,8),(3,'wiki',99,8),(3,'wiki',100,8),(3,'wiki',112,8),(3,'wiki',130,8),(4,'bibl',2,8),(4,'bibl',3,8),(4,'blog',2,8),(4,'blog',3,8),(4,'book',2,8),(4,'book',3,8),(4,'cat',2,8),(4,'cat',3,8),(4,'catr',2,8),(4,'chtr',2,8),(4,'chtr',3,8),(4,'cmix',2,8),(4,'cmix',3,8),(4,'copa',2,8),(4,'copa',3,8),(4,'crs',2,8),(4,'crs',7,8),(4,'crsr',2,8),(4,'dcl',2,8),(4,'dcl',3,8),(4,'exc',2,8),(4,'exc',3,8),(4,'feed',3,8),(4,'file',2,8),(4,'file',3,8),(4,'fold',2,8),(4,'fold',3,8),(4,'frm',2,8),(4,'frm',3,8),(4,'frm',9,8),(4,'frm',62,8),(4,'glo',2,8),(4,'glo',3,8),(4,'grp',2,8),(4,'grp',7,8),(4,'grpr',2,8),(4,'htlm',2,8),(4,'htlm',3,8),(4,'iass',2,8),(4,'iass',3,8),(4,'itgr',2,8),(4,'itgr',3,8),(4,'lm',2,8),(4,'lm',3,8),(4,'lso',2,8),(4,'lso',3,8),(4,'lti',2,8),(4,'lti',3,8),(4,'mail',30,8),(4,'mcst',2,8),(4,'mcst',3,8),(4,'poll',3,8),(4,'prg',2,8),(4,'prg',3,8),(4,'root',2,8),(4,'root',3,8),(4,'sahs',2,8),(4,'sahs',3,8),(4,'seas',51,8),(4,'sess',2,8),(4,'sess',3,8),(4,'svy',2,8),(4,'svy',3,8),(4,'tst',2,8),(4,'tst',3,8),(4,'webr',2,8),(4,'webr',3,8),(4,'wiki',2,8),(4,'wiki',3,8),(4,'wiki',64,8),(4,'wiki',130,8),(5,'bibl',2,8),(5,'blog',2,8),(5,'book',2,8),(5,'cat',2,8),(5,'catr',2,8),(5,'chtr',2,8),(5,'crs',2,8),(5,'crsr',2,8),(5,'dcl',2,8),(5,'exc',2,8),(5,'feed',3,8),(5,'file',2,8),(5,'frm',2,8),(5,'glo',2,8),(5,'grp',2,8),(5,'grpr',2,8),(5,'htlm',2,8),(5,'itgr',2,8),(5,'itgr',3,8),(5,'lm',2,8),(5,'mcst',2,8),(5,'prg',2,8),(5,'root',2,8),(5,'root',3,8),(5,'sahs',2,8),(5,'seas',51,8),(5,'svy',2,8),(5,'tst',2,8),(5,'webr',2,8),(5,'wiki',2,8),(14,'cat',2,8),(14,'root',2,8),(14,'root',3,8),(14,'seas',51,8),(80,'bibl',1,8),(80,'bibl',2,8),(80,'bibl',3,8),(80,'bibl',4,8),(80,'bibl',6,8),(80,'bibl',58,8),(80,'blog',1,8),(80,'blog',2,8),(80,'blog',3,8),(80,'blog',4,8),(80,'blog',6,8),(80,'blog',58,8),(80,'blog',79,8),(80,'book',1,8),(80,'book',2,8),(80,'book',3,8),(80,'book',4,8),(80,'book',6,8),(80,'book',58,8),(80,'catr',1,8),(80,'catr',2,8),(80,'catr',4,8),(80,'catr',6,8),(80,'catr',58,8),(80,'chtr',1,8),(80,'chtr',2,8),(80,'chtr',3,8),(80,'chtr',4,8),(80,'chtr',6,8),(80,'chtr',52,8),(80,'chtr',58,8),(80,'cmix',1,8),(80,'cmix',2,8),(80,'cmix',3,8),(80,'cmix',4,8),(80,'cmix',6,8),(80,'cmix',55,8),(80,'cmix',58,8),(80,'cmix',95,8),(80,'cmix',125,8),(80,'copa',1,8),(80,'copa',2,8),(80,'copa',3,8),(80,'copa',4,8),(80,'copa',6,8),(80,'copa',55,8),(80,'copa',58,8),(80,'copa',95,8),(80,'crsr',1,8),(80,'crsr',2,8),(80,'crsr',4,8),(80,'crsr',6,8),(80,'crsr',55,8),(80,'crsr',58,8),(80,'crsr',95,8),(80,'dcl',1,8),(80,'dcl',2,8),(80,'dcl',3,8),(80,'dcl',4,8),(80,'dcl',6,8),(80,'dcl',58,8),(80,'dcl',64,8),(80,'dcl',77,8),(80,'exc',1,8),(80,'exc',2,8),(80,'exc',3,8),(80,'exc',4,8),(80,'exc',6,8),(80,'exc',55,8),(80,'exc',58,8),(80,'exc',95,8),(80,'exc',114,8),(80,'feed',1,8),(80,'feed',3,8),(80,'feed',4,8),(80,'feed',6,8),(80,'feed',58,8),(80,'file',1,8),(80,'file',2,8),(80,'file',3,8),(80,'file',4,8),(80,'file',6,8),(80,'file',55,8),(80,'file',58,8),(80,'file',95,8),(80,'file',131,8),(80,'fold',1,8),(80,'fold',2,8),(80,'fold',3,8),(80,'fold',4,8),(80,'fold',6,8),(80,'fold',17,8),(80,'fold',18,8),(80,'fold',20,8),(80,'fold',21,8),(80,'fold',22,8),(80,'fold',24,8),(80,'fold',25,8),(80,'fold',26,8),(80,'fold',27,8),(80,'fold',28,8),(80,'fold',31,8),(80,'fold',32,8),(80,'fold',42,8),(80,'fold',43,8),(80,'fold',50,8),(80,'fold',55,8),(80,'fold',58,8),(80,'fold',60,8),(80,'fold',63,8),(80,'fold',65,8),(80,'fold',71,8),(80,'fold',73,8),(80,'fold',74,8),(80,'fold',75,8),(80,'fold',76,8),(80,'fold',78,8),(80,'fold',81,8),(80,'fold',82,8),(80,'fold',90,8),(80,'fold',95,8),(80,'fold',106,8),(80,'fold',108,8),(80,'fold',116,8),(80,'fold',119,8),(80,'fold',126,8),(80,'fold',127,8),(80,'frm',1,8),(80,'frm',2,8),(80,'frm',3,8),(80,'frm',4,8),(80,'frm',6,8),(80,'frm',9,8),(80,'frm',10,8),(80,'frm',55,8),(80,'frm',58,8),(80,'frm',62,8),(80,'frm',95,8),(80,'glo',1,8),(80,'glo',2,8),(80,'glo',3,8),(80,'glo',4,8),(80,'glo',6,8),(80,'glo',58,8),(80,'glo',64,8),(80,'grp',1,8),(80,'grp',2,8),(80,'grp',3,8),(80,'grp',4,8),(80,'grp',6,8),(80,'grp',7,8),(80,'grp',8,8),(80,'grp',17,8),(80,'grp',18,8),(80,'grp',20,8),(80,'grp',21,8),(80,'grp',22,8),(80,'grp',24,8),(80,'grp',25,8),(80,'grp',26,8),(80,'grp',27,8),(80,'grp',28,8),(80,'grp',31,8),(80,'grp',32,8),(80,'grp',42,8),(80,'grp',43,8),(80,'grp',50,8),(80,'grp',55,8),(80,'grp',58,8),(80,'grp',59,8),(80,'grp',60,8),(80,'grp',63,8),(80,'grp',65,8),(80,'grp',66,8),(80,'grp',67,8),(80,'grp',68,8),(80,'grp',71,8),(80,'grp',73,8),(80,'grp',74,8),(80,'grp',75,8),(80,'grp',76,8),(80,'grp',78,8),(80,'grp',81,8),(80,'grp',82,8),(80,'grp',90,8),(80,'grp',95,8),(80,'grp',102,8),(80,'grp',106,8),(80,'grp',107,8),(80,'grp',108,8),(80,'grp',111,8),(80,'grp',116,8),(80,'grp',119,8),(80,'grp',126,8),(80,'grp',127,8),(80,'grpr',1,8),(80,'grpr',2,8),(80,'grpr',4,8),(80,'grpr',6,8),(80,'grpr',58,8),(80,'htlm',1,8),(80,'htlm',2,8),(80,'htlm',3,8),(80,'htlm',4,8),(80,'htlm',6,8),(80,'htlm',55,8),(80,'htlm',58,8),(80,'htlm',95,8),(80,'iass',1,8),(80,'iass',2,8),(80,'iass',3,8),(80,'iass',4,8),(80,'iass',6,8),(80,'iass',55,8),(80,'iass',58,8),(80,'iass',95,8),(80,'iass',109,8),(80,'itgr',1,8),(80,'itgr',2,8),(80,'itgr',3,8),(80,'itgr',4,8),(80,'itgr',6,8),(80,'itgr',58,8),(80,'lm',1,8),(80,'lm',2,8),(80,'lm',3,8),(80,'lm',4,8),(80,'lm',6,8),(80,'lm',55,8),(80,'lm',58,8),(80,'lm',95,8),(80,'lso',1,8),(80,'lso',2,8),(80,'lso',3,8),(80,'lso',4,8),(80,'lso',6,8),(80,'lso',20,8),(80,'lso',21,8),(80,'lso',24,8),(80,'lso',25,8),(80,'lso',27,8),(80,'lso',32,8),(80,'lso',42,8),(80,'lso',55,8),(80,'lso',58,8),(80,'lso',95,8),(80,'lso',102,8),(80,'lso',108,8),(80,'lso',116,8),(80,'lso',120,8),(80,'lso',121,8),(80,'lti',1,8),(80,'lti',2,8),(80,'lti',3,8),(80,'lti',4,8),(80,'lti',6,8),(80,'lti',55,8),(80,'lti',58,8),(80,'lti',95,8),(80,'lti',125,8),(80,'mcst',1,8),(80,'mcst',2,8),(80,'mcst',3,8),(80,'mcst',4,8),(80,'mcst',6,8),(80,'mcst',55,8),(80,'mcst',58,8),(80,'mcst',95,8),(80,'mep',1,8),(80,'mep',2,8),(80,'mep',3,8),(80,'mep',4,8),(80,'mep',6,8),(80,'mep',58,8),(80,'poll',1,8),(80,'poll',3,8),(80,'poll',4,8),(80,'poll',6,8),(80,'poll',58,8),(80,'prtt',1,8),(80,'prtt',2,8),(80,'prtt',3,8),(80,'prtt',4,8),(80,'prtt',6,8),(80,'prtt',58,8),(80,'qpl',1,8),(80,'qpl',2,8),(80,'qpl',3,8),(80,'qpl',4,8),(80,'qpl',6,8),(80,'qpl',58,8),(80,'sahs',1,8),(80,'sahs',2,8),(80,'sahs',3,8),(80,'sahs',4,8),(80,'sahs',6,8),(80,'sahs',55,8),(80,'sahs',58,8),(80,'sahs',95,8),(80,'sess',1,8),(80,'sess',2,8),(80,'sess',3,8),(80,'sess',4,8),(80,'sess',6,8),(80,'sess',55,8),(80,'sess',58,8),(80,'sess',95,8),(80,'sess',102,8),(80,'sess',117,8),(80,'sess',118,8),(80,'spl',1,8),(80,'spl',2,8),(80,'spl',3,8),(80,'spl',4,8),(80,'spl',6,8),(80,'spl',58,8),(80,'svy',1,8),(80,'svy',2,8),(80,'svy',3,8),(80,'svy',4,8),(80,'svy',6,8),(80,'svy',45,8),(80,'svy',55,8),(80,'svy',58,8),(80,'svy',95,8),(80,'svy',122,8),(80,'tst',1,8),(80,'tst',2,8),(80,'tst',3,8),(80,'tst',4,8),(80,'tst',6,8),(80,'tst',55,8),(80,'tst',56,8),(80,'tst',58,8),(80,'tst',95,8),(80,'tst',115,8),(80,'webr',1,8),(80,'webr',2,8),(80,'webr',3,8),(80,'webr',4,8),(80,'webr',6,8),(80,'webr',58,8),(80,'wiki',1,8),(80,'wiki',2,8),(80,'wiki',3,8),(80,'wiki',4,8),(80,'wiki',6,8),(80,'wiki',58,8),(80,'wiki',64,8),(80,'wiki',94,8),(80,'wiki',97,8),(80,'wiki',98,8),(80,'wiki',99,8),(80,'wiki',100,8),(80,'wiki',112,8),(80,'wiki',130,8),(81,'bibl',2,8),(81,'bibl',3,8),(81,'blog',2,8),(81,'blog',3,8),(81,'book',2,8),(81,'book',3,8),(81,'catr',2,8),(81,'chtr',2,8),(81,'chtr',3,8),(81,'cmix',2,8),(81,'cmix',3,8),(81,'copa',2,8),(81,'copa',3,8),(81,'crsr',2,8),(81,'dcl',2,8),(81,'dcl',3,8),(81,'exc',2,8),(81,'exc',3,8),(81,'feed',3,8),(81,'file',2,8),(81,'file',3,8),(81,'fold',2,8),(81,'fold',3,8),(81,'frm',2,8),(81,'frm',3,8),(81,'frm',9,8),(81,'frm',62,8),(81,'glo',2,8),(81,'glo',3,8),(81,'grp',2,8),(81,'grp',3,8),(81,'grp',7,8),(81,'grp',8,8),(81,'grpr',2,8),(81,'htlm',2,8),(81,'htlm',3,8),(81,'iass',2,8),(81,'iass',3,8),(81,'itgr',2,8),(81,'itgr',3,8),(81,'lm',2,8),(81,'lm',3,8),(81,'lso',2,8),(81,'lso',3,8),(81,'lso',120,8),(81,'lti',2,8),(81,'lti',3,8),(81,'mcst',2,8),(81,'mcst',3,8),(81,'poll',3,8),(81,'prtt',2,8),(81,'prtt',3,8),(81,'sahs',2,8),(81,'sahs',3,8),(81,'sess',2,8),(81,'sess',3,8),(81,'svy',2,8),(81,'svy',3,8),(81,'tst',2,8),(81,'tst',3,8),(81,'webr',2,8),(81,'webr',3,8),(81,'wiki',2,8),(81,'wiki',3,8),(81,'wiki',64,8),(81,'wiki',130,8),(83,'grp',2,8),(83,'grp',7,8),(110,'bibl',1,8),(110,'bibl',2,8),(110,'bibl',3,8),(110,'bibl',4,8),(110,'bibl',6,8),(110,'bibl',58,8),(110,'blog',1,8),(110,'blog',2,8),(110,'blog',3,8),(110,'blog',4,8),(110,'blog',6,8),(110,'blog',58,8),(110,'blog',79,8),(110,'blog',96,8),(110,'book',1,8),(110,'book',2,8),(110,'book',3,8),(110,'book',4,8),(110,'book',6,8),(110,'book',58,8),(110,'catr',1,8),(110,'catr',2,8),(110,'catr',4,8),(110,'catr',6,8),(110,'catr',58,8),(110,'chtr',1,8),(110,'chtr',2,8),(110,'chtr',3,8),(110,'chtr',4,8),(110,'chtr',6,8),(110,'chtr',52,8),(110,'chtr',58,8),(110,'cmix',1,8),(110,'cmix',2,8),(110,'cmix',3,8),(110,'cmix',4,8),(110,'cmix',6,8),(110,'cmix',55,8),(110,'cmix',58,8),(110,'cmix',95,8),(110,'cmix',125,8),(110,'copa',1,8),(110,'copa',2,8),(110,'copa',3,8),(110,'copa',4,8),(110,'copa',6,8),(110,'copa',55,8),(110,'copa',58,8),(110,'copa',95,8),(110,'crs',1,8),(110,'crs',2,8),(110,'crs',3,8),(110,'crs',4,8),(110,'crs',6,8),(110,'crs',7,8),(110,'crs',8,8),(110,'crs',17,8),(110,'crs',18,8),(110,'crs',20,8),(110,'crs',21,8),(110,'crs',22,8),(110,'crs',24,8),(110,'crs',25,8),(110,'crs',26,8),(110,'crs',27,8),(110,'crs',28,8),(110,'crs',31,8),(110,'crs',32,8),(110,'crs',42,8),(110,'crs',43,8),(110,'crs',50,8),(110,'crs',55,8),(110,'crs',58,8),(110,'crs',59,8),(110,'crs',60,8),(110,'crs',63,8),(110,'crs',65,8),(110,'crs',66,8),(110,'crs',67,8),(110,'crs',68,8),(110,'crs',71,8),(110,'crs',73,8),(110,'crs',74,8),(110,'crs',75,8),(110,'crs',76,8),(110,'crs',78,8),(110,'crs',81,8),(110,'crs',82,8),(110,'crs',90,8),(110,'crs',95,8),(110,'crs',102,8),(110,'crs',106,8),(110,'crs',107,8),(110,'crs',108,8),(110,'crs',111,8),(110,'crs',116,8),(110,'crs',119,8),(110,'crs',126,8),(110,'crs',127,8),(110,'crsr',1,8),(110,'crsr',2,8),(110,'crsr',4,8),(110,'crsr',6,8),(110,'crsr',55,8),(110,'crsr',58,8),(110,'crsr',95,8),(110,'dcl',1,8),(110,'dcl',2,8),(110,'dcl',3,8),(110,'dcl',4,8),(110,'dcl',6,8),(110,'dcl',58,8),(110,'dcl',64,8),(110,'dcl',77,8),(110,'exc',1,8),(110,'exc',2,8),(110,'exc',3,8),(110,'exc',4,8),(110,'exc',6,8),(110,'exc',55,8),(110,'exc',58,8),(110,'exc',95,8),(110,'exc',114,8),(110,'feed',1,8),(110,'feed',3,8),(110,'feed',4,8),(110,'feed',6,8),(110,'feed',58,8),(110,'file',1,8),(110,'file',2,8),(110,'file',3,8),(110,'file',4,8),(110,'file',6,8),(110,'file',55,8),(110,'file',58,8),(110,'file',95,8),(110,'file',131,8),(110,'fold',1,8),(110,'fold',2,8),(110,'fold',3,8),(110,'fold',4,8),(110,'fold',6,8),(110,'fold',17,8),(110,'fold',18,8),(110,'fold',20,8),(110,'fold',21,8),(110,'fold',22,8),(110,'fold',24,8),(110,'fold',25,8),(110,'fold',26,8),(110,'fold',27,8),(110,'fold',28,8),(110,'fold',31,8),(110,'fold',32,8),(110,'fold',42,8),(110,'fold',43,8),(110,'fold',50,8),(110,'fold',55,8),(110,'fold',58,8),(110,'fold',60,8),(110,'fold',63,8),(110,'fold',65,8),(110,'fold',71,8),(110,'fold',73,8),(110,'fold',74,8),(110,'fold',75,8),(110,'fold',76,8),(110,'fold',78,8),(110,'fold',81,8),(110,'fold',82,8),(110,'fold',90,8),(110,'fold',95,8),(110,'fold',106,8),(110,'fold',108,8),(110,'fold',116,8),(110,'fold',119,8),(110,'fold',126,8),(110,'fold',127,8),(110,'frm',1,8),(110,'frm',2,8),(110,'frm',3,8),(110,'frm',4,8),(110,'frm',6,8),(110,'frm',9,8),(110,'frm',10,8),(110,'frm',55,8),(110,'frm',58,8),(110,'frm',62,8),(110,'frm',95,8),(110,'glo',1,8),(110,'glo',2,8),(110,'glo',3,8),(110,'glo',4,8),(110,'glo',6,8),(110,'glo',58,8),(110,'glo',64,8),(110,'grp',1,8),(110,'grp',2,8),(110,'grp',3,8),(110,'grp',4,8),(110,'grp',6,8),(110,'grp',7,8),(110,'grp',8,8),(110,'grp',17,8),(110,'grp',18,8),(110,'grp',20,8),(110,'grp',21,8),(110,'grp',22,8),(110,'grp',24,8),(110,'grp',25,8),(110,'grp',26,8),(110,'grp',27,8),(110,'grp',28,8),(110,'grp',31,8),(110,'grp',32,8),(110,'grp',42,8),(110,'grp',43,8),(110,'grp',50,8),(110,'grp',55,8),(110,'grp',58,8),(110,'grp',59,8),(110,'grp',60,8),(110,'grp',63,8),(110,'grp',65,8),(110,'grp',66,8),(110,'grp',67,8),(110,'grp',68,8),(110,'grp',71,8),(110,'grp',73,8),(110,'grp',74,8),(110,'grp',75,8),(110,'grp',76,8),(110,'grp',78,8),(110,'grp',81,8),(110,'grp',82,8),(110,'grp',90,8),(110,'grp',95,8),(110,'grp',102,8),(110,'grp',106,8),(110,'grp',107,8),(110,'grp',108,8),(110,'grp',111,8),(110,'grp',116,8),(110,'grp',119,8),(110,'grp',126,8),(110,'grp',127,8),(110,'grpr',1,8),(110,'grpr',2,8),(110,'grpr',4,8),(110,'grpr',6,8),(110,'grpr',58,8),(110,'htlm',1,8),(110,'htlm',2,8),(110,'htlm',3,8),(110,'htlm',4,8),(110,'htlm',6,8),(110,'htlm',55,8),(110,'htlm',58,8),(110,'htlm',95,8),(110,'iass',1,8),(110,'iass',2,8),(110,'iass',3,8),(110,'iass',4,8),(110,'iass',6,8),(110,'iass',55,8),(110,'iass',58,8),(110,'iass',95,8),(110,'iass',109,8),(110,'itgr',1,8),(110,'itgr',2,8),(110,'itgr',3,8),(110,'itgr',4,8),(110,'itgr',6,8),(110,'itgr',58,8),(110,'lm',1,8),(110,'lm',2,8),(110,'lm',3,8),(110,'lm',4,8),(110,'lm',6,8),(110,'lm',55,8),(110,'lm',58,8),(110,'lm',95,8),(110,'lso',1,8),(110,'lso',2,8),(110,'lso',3,8),(110,'lso',4,8),(110,'lso',6,8),(110,'lso',20,8),(110,'lso',21,8),(110,'lso',24,8),(110,'lso',25,8),(110,'lso',27,8),(110,'lso',32,8),(110,'lso',42,8),(110,'lso',55,8),(110,'lso',58,8),(110,'lso',95,8),(110,'lso',102,8),(110,'lso',108,8),(110,'lso',116,8),(110,'lso',120,8),(110,'lso',121,8),(110,'lti',1,8),(110,'lti',2,8),(110,'lti',3,8),(110,'lti',4,8),(110,'lti',6,8),(110,'lti',55,8),(110,'lti',58,8),(110,'lti',95,8),(110,'lti',125,8),(110,'mcst',1,8),(110,'mcst',2,8),(110,'mcst',3,8),(110,'mcst',4,8),(110,'mcst',6,8),(110,'mcst',55,8),(110,'mcst',58,8),(110,'mcst',95,8),(110,'mep',1,8),(110,'mep',2,8),(110,'mep',3,8),(110,'mep',4,8),(110,'mep',6,8),(110,'mep',58,8),(110,'poll',1,8),(110,'poll',3,8),(110,'poll',4,8),(110,'poll',6,8),(110,'poll',58,8),(110,'prtt',1,8),(110,'prtt',2,8),(110,'prtt',3,8),(110,'prtt',4,8),(110,'prtt',6,8),(110,'prtt',58,8),(110,'qpl',1,8),(110,'qpl',2,8),(110,'qpl',3,8),(110,'qpl',4,8),(110,'qpl',6,8),(110,'qpl',58,8),(110,'sahs',1,8),(110,'sahs',2,8),(110,'sahs',3,8),(110,'sahs',4,8),(110,'sahs',6,8),(110,'sahs',55,8),(110,'sahs',58,8),(110,'sahs',95,8),(110,'sess',1,8),(110,'sess',2,8),(110,'sess',3,8),(110,'sess',4,8),(110,'sess',6,8),(110,'sess',55,8),(110,'sess',58,8),(110,'sess',95,8),(110,'sess',102,8),(110,'sess',117,8),(110,'sess',118,8),(110,'spl',1,8),(110,'spl',2,8),(110,'spl',3,8),(110,'spl',4,8),(110,'spl',6,8),(110,'spl',58,8),(110,'svy',1,8),(110,'svy',2,8),(110,'svy',3,8),(110,'svy',4,8),(110,'svy',6,8),(110,'svy',45,8),(110,'svy',55,8),(110,'svy',58,8),(110,'svy',95,8),(110,'svy',122,8),(110,'tst',1,8),(110,'tst',2,8),(110,'tst',3,8),(110,'tst',4,8),(110,'tst',6,8),(110,'tst',55,8),(110,'tst',56,8),(110,'tst',58,8),(110,'tst',95,8),(110,'tst',115,8),(110,'webr',1,8),(110,'webr',2,8),(110,'webr',3,8),(110,'webr',4,8),(110,'webr',6,8),(110,'webr',58,8),(110,'wiki',1,8),(110,'wiki',2,8),(110,'wiki',3,8),(110,'wiki',4,8),(110,'wiki',6,8),(110,'wiki',58,8),(110,'wiki',64,8),(110,'wiki',94,8),(110,'wiki',97,8),(110,'wiki',98,8),(110,'wiki',99,8),(110,'wiki',100,8),(110,'wiki',112,8),(110,'wiki',130,8),(111,'bibl',2,8),(111,'bibl',3,8),(111,'bibl',4,8),(111,'bibl',58,8),(111,'blog',2,8),(111,'blog',3,8),(111,'blog',4,8),(111,'blog',58,8),(111,'blog',79,8),(111,'book',2,8),(111,'book',3,8),(111,'book',4,8),(111,'book',58,8),(111,'catr',2,8),(111,'catr',4,8),(111,'catr',58,8),(111,'chtr',2,8),(111,'chtr',3,8),(111,'chtr',4,8),(111,'chtr',52,8),(111,'chtr',58,8),(111,'cmix',2,8),(111,'cmix',3,8),(111,'cmix',4,8),(111,'cmix',58,8),(111,'copa',2,8),(111,'copa',3,8),(111,'copa',4,8),(111,'copa',58,8),(111,'crs',2,8),(111,'crs',3,8),(111,'crs',4,8),(111,'crs',7,8),(111,'crs',8,8),(111,'crs',17,8),(111,'crs',18,8),(111,'crs',20,8),(111,'crs',21,8),(111,'crs',22,8),(111,'crs',24,8),(111,'crs',25,8),(111,'crs',26,8),(111,'crs',27,8),(111,'crs',28,8),(111,'crs',31,8),(111,'crs',32,8),(111,'crs',42,8),(111,'crs',43,8),(111,'crs',50,8),(111,'crs',55,8),(111,'crs',58,8),(111,'crs',59,8),(111,'crs',60,8),(111,'crs',63,8),(111,'crs',65,8),(111,'crs',66,8),(111,'crs',67,8),(111,'crs',68,8),(111,'crs',71,8),(111,'crs',73,8),(111,'crs',74,8),(111,'crs',75,8),(111,'crs',76,8),(111,'crs',78,8),(111,'crs',81,8),(111,'crs',82,8),(111,'crs',90,8),(111,'crs',95,8),(111,'crs',102,8),(111,'crs',106,8),(111,'crs',107,8),(111,'crs',108,8),(111,'crs',111,8),(111,'crs',116,8),(111,'crs',119,8),(111,'crs',126,8),(111,'crs',127,8),(111,'crsr',2,8),(111,'crsr',4,8),(111,'crsr',55,8),(111,'crsr',58,8),(111,'crsr',95,8),(111,'dcl',2,8),(111,'dcl',3,8),(111,'dcl',4,8),(111,'dcl',58,8),(111,'dcl',64,8),(111,'dcl',77,8),(111,'exc',2,8),(111,'exc',3,8),(111,'exc',4,8),(111,'exc',55,8),(111,'exc',58,8),(111,'exc',95,8),(111,'exc',114,8),(111,'feed',3,8),(111,'feed',4,8),(111,'feed',58,8),(111,'file',2,8),(111,'file',3,8),(111,'file',4,8),(111,'file',55,8),(111,'file',58,8),(111,'file',95,8),(111,'file',131,8),(111,'fold',2,8),(111,'fold',3,8),(111,'fold',4,8),(111,'fold',17,8),(111,'fold',18,8),(111,'fold',20,8),(111,'fold',21,8),(111,'fold',22,8),(111,'fold',24,8),(111,'fold',25,8),(111,'fold',26,8),(111,'fold',27,8),(111,'fold',28,8),(111,'fold',31,8),(111,'fold',32,8),(111,'fold',42,8),(111,'fold',43,8),(111,'fold',50,8),(111,'fold',55,8),(111,'fold',58,8),(111,'fold',60,8),(111,'fold',63,8),(111,'fold',65,8),(111,'fold',71,8),(111,'fold',73,8),(111,'fold',74,8),(111,'fold',75,8),(111,'fold',76,8),(111,'fold',78,8),(111,'fold',81,8),(111,'fold',82,8),(111,'fold',90,8),(111,'fold',95,8),(111,'fold',106,8),(111,'fold',108,8),(111,'fold',116,8),(111,'fold',119,8),(111,'fold',126,8),(111,'fold',127,8),(111,'frm',2,8),(111,'frm',3,8),(111,'frm',4,8),(111,'frm',9,8),(111,'frm',10,8),(111,'frm',55,8),(111,'frm',58,8),(111,'frm',62,8),(111,'frm',95,8),(111,'glo',2,8),(111,'glo',3,8),(111,'glo',4,8),(111,'glo',58,8),(111,'glo',64,8),(111,'grp',2,8),(111,'grp',3,8),(111,'grp',7,8),(111,'grp',8,8),(111,'grpr',2,8),(111,'grpr',4,8),(111,'grpr',58,8),(111,'htlm',2,8),(111,'htlm',3,8),(111,'htlm',55,8),(111,'htlm',95,8),(111,'iass',2,8),(111,'iass',3,8),(111,'iass',4,8),(111,'iass',55,8),(111,'iass',58,8),(111,'iass',95,8),(111,'iass',109,8),(111,'itgr',2,8),(111,'itgr',3,8),(111,'itgr',4,8),(111,'itgr',58,8),(111,'lm',2,8),(111,'lm',3,8),(111,'lm',55,8),(111,'lm',95,8),(111,'lso',2,8),(111,'lso',3,8),(111,'lso',4,8),(111,'lso',20,8),(111,'lso',21,8),(111,'lso',24,8),(111,'lso',25,8),(111,'lso',27,8),(111,'lso',32,8),(111,'lso',42,8),(111,'lso',55,8),(111,'lso',58,8),(111,'lso',102,8),(111,'lso',108,8),(111,'lso',116,8),(111,'lso',120,8),(111,'lso',121,8),(111,'lti',2,8),(111,'lti',3,8),(111,'lti',4,8),(111,'lti',58,8),(111,'mcst',2,8),(111,'mcst',3,8),(111,'mcst',4,8),(111,'mcst',55,8),(111,'mcst',58,8),(111,'mcst',95,8),(111,'mep',2,8),(111,'mep',3,8),(111,'mep',4,8),(111,'mep',58,8),(111,'poll',3,8),(111,'poll',4,8),(111,'poll',58,8),(111,'prtt',2,8),(111,'prtt',3,8),(111,'qpl',2,8),(111,'qpl',3,8),(111,'qpl',4,8),(111,'sahs',2,8),(111,'sahs',3,8),(111,'sahs',55,8),(111,'sahs',95,8),(111,'sess',2,8),(111,'sess',3,8),(111,'sess',4,8),(111,'sess',6,8),(111,'sess',55,8),(111,'sess',58,8),(111,'sess',95,8),(111,'sess',102,8),(111,'sess',117,8),(111,'sess',118,8),(111,'spl',2,8),(111,'spl',3,8),(111,'spl',4,8),(111,'svy',2,8),(111,'svy',3,8),(111,'svy',4,8),(111,'svy',45,8),(111,'svy',55,8),(111,'svy',58,8),(111,'svy',95,8),(111,'svy',122,8),(111,'tst',2,8),(111,'tst',3,8),(111,'tst',4,8),(111,'tst',55,8),(111,'tst',58,8),(111,'tst',95,8),(111,'tst',115,8),(111,'webr',2,8),(111,'webr',3,8),(111,'webr',4,8),(111,'webr',58,8),(111,'wiki',2,8),(111,'wiki',3,8),(111,'wiki',4,8),(111,'wiki',58,8),(111,'wiki',64,8),(111,'wiki',94,8),(111,'wiki',97,8),(111,'wiki',98,8),(111,'wiki',99,8),(111,'wiki',100,8),(111,'wiki',112,8),(111,'wiki',130,8),(112,'bibl',2,8),(112,'bibl',3,8),(112,'blog',2,8),(112,'blog',3,8),(112,'book',2,8),(112,'book',3,8),(112,'catr',2,8),(112,'chtr',2,8),(112,'chtr',3,8),(112,'cmix',2,8),(112,'cmix',3,8),(112,'copa',2,8),(112,'copa',3,8),(112,'crs',2,8),(112,'crs',3,8),(112,'crs',8,8),(112,'crsr',2,8),(112,'dcl',2,8),(112,'dcl',3,8),(112,'exc',2,8),(112,'exc',3,8),(112,'feed',3,8),(112,'file',2,8),(112,'file',3,8),(112,'fold',2,8),(112,'fold',3,8),(112,'frm',2,8),(112,'frm',3,8),(112,'frm',9,8),(112,'frm',62,8),(112,'glo',2,8),(112,'glo',3,8),(112,'grp',2,8),(112,'grp',3,8),(112,'grp',7,8),(112,'grp',8,8),(112,'grpr',2,8),(112,'htlm',2,8),(112,'htlm',3,8),(112,'iass',2,8),(112,'iass',3,8),(112,'itgr',2,8),(112,'itgr',3,8),(112,'lm',2,8),(112,'lm',3,8),(112,'lso',2,8),(112,'lso',3,8),(112,'lso',120,8),(112,'lti',2,8),(112,'lti',3,8),(112,'mcst',2,8),(112,'mcst',3,8),(112,'poll',3,8),(112,'prtt',2,8),(112,'prtt',3,8),(112,'sahs',2,8),(112,'sahs',3,8),(112,'sess',2,8),(112,'sess',3,8),(112,'svy',2,8),(112,'svy',3,8),(112,'tst',2,8),(112,'tst',3,8),(112,'webr',2,8),(112,'webr',3,8),(112,'wiki',2,8),(112,'wiki',3,8),(112,'wiki',64,8),(112,'wiki',130,8),(125,'bibl',1,8),(125,'bibl',2,8),(125,'bibl',3,8),(125,'bibl',6,8),(125,'bibl',58,8),(125,'blog',1,8),(125,'blog',2,8),(125,'blog',3,8),(125,'blog',6,8),(125,'book',1,8),(125,'book',2,8),(125,'book',3,8),(125,'book',6,8),(125,'cat',1,8),(125,'cat',2,8),(125,'cat',3,8),(125,'cat',4,8),(125,'cat',6,8),(125,'cat',16,8),(125,'cat',17,8),(125,'cat',18,8),(125,'cat',19,8),(125,'cat',20,8),(125,'cat',21,8),(125,'cat',22,8),(125,'cat',24,8),(125,'cat',25,8),(125,'cat',27,8),(125,'cat',28,8),(125,'cat',31,8),(125,'cat',32,8),(125,'cat',42,8),(125,'cat',43,8),(125,'cat',47,8),(125,'cat',48,8),(125,'cat',50,8),(125,'cat',58,8),(125,'cat',59,8),(125,'cat',60,8),(125,'cat',65,8),(125,'cat',67,8),(125,'cat',68,8),(125,'cat',71,8),(125,'cat',73,8),(125,'cat',74,8),(125,'cat',75,8),(125,'cat',76,8),(125,'cat',78,8),(125,'cat',81,8),(125,'cat',82,8),(125,'cat',90,8),(125,'cat',101,8),(125,'cat',106,8),(125,'cat',108,8),(125,'cat',116,8),(125,'cat',119,8),(125,'cat',126,8),(125,'cat',127,8),(125,'catr',1,8),(125,'catr',2,8),(125,'catr',6,8),(125,'catr',58,8),(125,'chtr',1,8),(125,'chtr',2,8),(125,'chtr',6,8),(125,'cld',1,8),(125,'cld',2,8),(125,'cld',3,8),(125,'cld',6,8),(125,'cmix',1,8),(125,'cmix',2,8),(125,'cmix',6,8),(125,'copa',1,8),(125,'copa',2,8),(125,'copa',6,8),(125,'crs',1,8),(125,'crs',2,8),(125,'crs',3,8),(125,'crs',6,8),(125,'crs',55,8),(125,'crs',95,8),(125,'crs',102,8),(125,'crs',111,8),(125,'crsr',1,8),(125,'crsr',2,8),(125,'crsr',6,8),(125,'dcl',1,8),(125,'dcl',2,8),(125,'dcl',3,8),(125,'dcl',6,8),(125,'exc',1,8),(125,'exc',2,8),(125,'exc',6,8),(125,'exc',55,8),(125,'exc',95,8),(125,'feed',1,8),(125,'feed',3,8),(125,'feed',6,8),(125,'file',1,8),(125,'file',2,8),(125,'file',6,8),(125,'fold',1,8),(125,'fold',2,8),(125,'fold',3,8),(125,'fold',6,8),(125,'fold',55,8),(125,'fold',95,8),(125,'frm',1,8),(125,'frm',2,8),(125,'frm',6,8),(125,'glo',1,8),(125,'glo',2,8),(125,'glo',6,8),(125,'grp',1,8),(125,'grp',2,8),(125,'grp',6,8),(125,'grp',55,8),(125,'grp',95,8),(125,'grpr',1,8),(125,'grpr',2,8),(125,'grpr',6,8),(125,'htlm',1,8),(125,'htlm',2,8),(125,'htlm',3,8),(125,'htlm',6,8),(125,'htlm',55,8),(125,'htlm',95,8),(125,'iass',1,8),(125,'iass',2,8),(125,'iass',6,8),(125,'itgr',1,8),(125,'itgr',2,8),(125,'itgr',3,8),(125,'itgr',6,8),(125,'lm',1,8),(125,'lm',2,8),(125,'lm',3,8),(125,'lm',6,8),(125,'lm',55,8),(125,'lm',95,8),(125,'lso',1,8),(125,'lso',2,8),(125,'lso',6,8),(125,'lti',1,8),(125,'lti',2,8),(125,'lti',6,8),(125,'mcst',1,8),(125,'mcst',2,8),(125,'mcst',3,8),(125,'mcst',6,8),(125,'mep',1,8),(125,'mep',2,8),(125,'mep',3,8),(125,'mep',6,8),(125,'poll',1,8),(125,'poll',3,8),(125,'poll',6,8),(125,'prg',1,8),(125,'prg',2,8),(125,'prg',3,8),(125,'prg',101,8),(125,'prtt',1,8),(125,'prtt',2,8),(125,'prtt',3,8),(125,'prtt',6,8),(125,'qpl',1,8),(125,'qpl',2,8),(125,'qpl',3,8),(125,'qpl',6,8),(125,'root',2,8),(125,'root',3,8),(125,'sahs',1,8),(125,'sahs',2,8),(125,'sahs',3,8),(125,'sahs',6,8),(125,'sahs',55,8),(125,'sahs',95,8),(125,'sess',1,8),(125,'sess',2,8),(125,'sess',3,8),(125,'spl',1,8),(125,'spl',2,8),(125,'spl',3,8),(125,'spl',6,8),(125,'svy',1,8),(125,'svy',2,8),(125,'svy',6,8),(125,'tst',1,8),(125,'tst',2,8),(125,'tst',6,8),(125,'tst',55,8),(125,'tst',95,8),(125,'webr',1,8),(125,'webr',2,8),(125,'webr',3,8),(125,'webr',6,8),(125,'wiki',1,8),(125,'wiki',2,8),(125,'wiki',3,8),(125,'wiki',6,8),(131,'crs',2,8),(131,'crs',7,8),(148,'frm',1,8),(148,'frm',2,8),(148,'frm',3,8),(148,'frm',4,8),(148,'frm',6,8),(148,'frm',9,8),(148,'frm',10,8),(148,'frm',55,8),(148,'frm',58,8),(148,'frm',62,8),(148,'frm',95,8),(188,'chtr',2,8),(188,'chtr',3,8),(188,'chtr',4,8),(188,'chtr',52,8),(202,'blog',2,8),(202,'blog',3,8),(202,'blog',79,8),(222,'orgu',2,8),(222,'orgu',3,8),(222,'orgu',92,8),(231,'blog',2,8),(231,'blog',3,8),(231,'blog',4,8),(231,'blog',79,8),(231,'blog',96,8),(267,'iass',2,8),(267,'iass',3,8),(268,'sess',2,8),(268,'sess',3,8),(277,'lso',55,8),(277,'lso',102,8),(277,'lso',120,8),(277,'lso',121,8),(278,'copa',2,8),(278,'copa',3,8),(278,'copa',55,8),(278,'copa',95,8),(278,'exc',2,8),(278,'exc',3,8),(278,'exc',55,8),(278,'exc',95,8),(278,'exc',114,8),(278,'file',2,8),(278,'file',3,8),(278,'file',55,8),(278,'file',95,8),(278,'htlm',2,8),(278,'htlm',3,8),(278,'htlm',55,8),(278,'htlm',95,8),(278,'iass',2,8),(278,'iass',3,8),(278,'iass',55,8),(278,'iass',95,8),(278,'iass',102,8),(278,'iass',109,8),(278,'lm',2,8),(278,'lm',3,8),(278,'lm',55,8),(278,'lm',95,8),(278,'lso',1,8),(278,'lso',2,8),(278,'lso',3,8),(278,'lso',4,8),(278,'lso',6,8),(278,'lso',20,8),(278,'lso',21,8),(278,'lso',24,8),(278,'lso',25,8),(278,'lso',27,8),(278,'lso',32,8),(278,'lso',42,8),(278,'lso',55,8),(278,'lso',58,8),(278,'lso',99,8),(278,'lso',102,8),(278,'lso',108,8),(278,'lso',116,8),(278,'lso',120,8),(278,'lso',121,8),(278,'lso',277,8),(278,'sahs',2,8),(278,'sahs',3,8),(278,'sahs',55,8),(278,'sahs',95,8),(278,'svy',2,8),(278,'svy',3,8),(278,'svy',45,8),(278,'svy',55,8),(278,'svy',95,8),(278,'svy',122,8),(278,'tst',2,8),(278,'tst',3,8),(278,'tst',55,8),(278,'tst',56,8),(278,'tst',95,8),(278,'tst',115,8),(279,'copa',2,8),(279,'copa',3,8),(279,'exc',2,8),(279,'exc',3,8),(279,'file',2,8),(279,'file',3,8),(279,'htlm',2,8),(279,'htlm',3,8),(279,'lm',2,8),(279,'lm',3,8),(279,'lso',2,8),(279,'lso',3,8),(279,'lso',121,8),(279,'lso',277,8),(279,'sahs',2,8),(279,'sahs',3,8),(279,'svy',2,8),(279,'svy',3,8),(279,'tst',2,8),(279,'tst',3,8); /*!40000 ALTER TABLE `rbac_templates` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rbac_ua` --
DROP TABLE IF EXISTS `rbac_ua`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rbac_ua` ( `usr_id` int(11) NOT NULL DEFAULT '0', `rol_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`usr_id`,`rol_id`), KEY `i1_idx` (`usr_id`), KEY `i2_idx` (`rol_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rbac_ua` --
LOCK TABLES `rbac_ua` WRITE; /*!40000 ALTER TABLE `rbac_ua` DISABLE KEYS */; INSERT INTO `rbac_ua` VALUES (6,2),(13,14); /*!40000 ALTER TABLE `rbac_ua` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rcat_settings` --
DROP TABLE IF EXISTS `rcat_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rcat_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rcat_settings` --
LOCK TABLES `rcat_settings` WRITE; /*!40000 ALTER TABLE `rcat_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rcat_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `read_event` --
DROP TABLE IF EXISTS `read_event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `read_event` ( `obj_id` int(11) NOT NULL DEFAULT '0', `usr_id` int(11) NOT NULL DEFAULT '0', `last_access` int(11) DEFAULT NULL, `read_count` int(11) NOT NULL DEFAULT '0', `spent_seconds` int(11) NOT NULL DEFAULT '0', `first_access` datetime DEFAULT NULL, `childs_read_count` int(11) NOT NULL DEFAULT '0', `childs_spent_seconds` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`,`usr_id`), KEY `i1_idx` (`usr_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `read_event` --
LOCK TABLES `read_event` WRITE; /*!40000 ALTER TABLE `read_event` DISABLE KEYS */; /*!40000 ALTER TABLE `read_event` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `reg_access_limit` --
DROP TABLE IF EXISTS `reg_access_limit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reg_access_limit` ( `role_id` int(11) NOT NULL DEFAULT '0', `limit_absolute` int(11) DEFAULT NULL, `limit_relative_d` int(11) DEFAULT NULL, `limit_relative_m` int(11) DEFAULT NULL, `limit_mode` char(16) DEFAULT 'absolute', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `reg_access_limit` --
LOCK TABLES `reg_access_limit` WRITE; /*!40000 ALTER TABLE `reg_access_limit` DISABLE KEYS */; /*!40000 ALTER TABLE `reg_access_limit` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `reg_er_assignments` --
DROP TABLE IF EXISTS `reg_er_assignments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reg_er_assignments` ( `assignment_id` int(11) NOT NULL DEFAULT '0', `domain` varchar(128) DEFAULT NULL, `role` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`assignment_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `reg_er_assignments` --
LOCK TABLES `reg_er_assignments` WRITE; /*!40000 ALTER TABLE `reg_er_assignments` DISABLE KEYS */; INSERT INTO `reg_er_assignments` VALUES (1,'',0); /*!40000 ALTER TABLE `reg_er_assignments` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `reg_er_assignments_seq` --
DROP TABLE IF EXISTS `reg_er_assignments_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reg_er_assignments_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `reg_er_assignments_seq` --
LOCK TABLES `reg_er_assignments_seq` WRITE; /*!40000 ALTER TABLE `reg_er_assignments_seq` DISABLE KEYS */; INSERT INTO `reg_er_assignments_seq` VALUES (1); /*!40000 ALTER TABLE `reg_er_assignments_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `reg_registration_codes` --
DROP TABLE IF EXISTS `reg_registration_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reg_registration_codes` ( `code_id` int(11) NOT NULL DEFAULT '0', `code` varchar(50) DEFAULT NULL, `role` int(11) DEFAULT '0', `generated_on` int(11) DEFAULT '0', `used` int(11) NOT NULL DEFAULT '0', `role_local` varchar(255) DEFAULT NULL, `alimit` varchar(50) DEFAULT NULL, `alimitdt` varchar(255) DEFAULT NULL, `reg_enabled` tinyint(4) NOT NULL DEFAULT '1', `ext_enabled` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`code_id`), KEY `i1_idx` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `reg_registration_codes` --
LOCK TABLES `reg_registration_codes` WRITE; /*!40000 ALTER TABLE `reg_registration_codes` DISABLE KEYS */; /*!40000 ALTER TABLE `reg_registration_codes` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `reg_registration_codes_seq` --
DROP TABLE IF EXISTS `reg_registration_codes_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reg_registration_codes_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `reg_registration_codes_seq` --
LOCK TABLES `reg_registration_codes_seq` WRITE; /*!40000 ALTER TABLE `reg_registration_codes_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `reg_registration_codes_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `remote_course_settings` --
DROP TABLE IF EXISTS `remote_course_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `remote_course_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `local_information` varchar(4000) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', `r_start` int(11) NOT NULL DEFAULT '0', `r_end` int(11) NOT NULL DEFAULT '0', `remote_link` varchar(4000) DEFAULT NULL, `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(4000) DEFAULT NULL, PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `remote_course_settings` --
LOCK TABLES `remote_course_settings` WRITE; /*!40000 ALTER TABLE `remote_course_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `remote_course_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rep_rec_content_obj` --
DROP TABLE IF EXISTS `rep_rec_content_obj`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rep_rec_content_obj` ( `user_id` int(11) NOT NULL DEFAULT '0', `ref_id` int(11) NOT NULL DEFAULT '0', `declined` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rep_rec_content_obj` --
LOCK TABLES `rep_rec_content_obj` WRITE; /*!40000 ALTER TABLE `rep_rec_content_obj` DISABLE KEYS */; /*!40000 ALTER TABLE `rep_rec_content_obj` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rep_rec_content_role` --
DROP TABLE IF EXISTS `rep_rec_content_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rep_rec_content_role` ( `role_id` int(11) NOT NULL DEFAULT '0', `ref_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`,`ref_id`), KEY `i1_idx` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rep_rec_content_role` --
LOCK TABLES `rep_rec_content_role` WRITE; /*!40000 ALTER TABLE `rep_rec_content_role` DISABLE KEYS */; /*!40000 ALTER TABLE `rep_rec_content_role` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rep_rec_content_role_seq` --
DROP TABLE IF EXISTS `rep_rec_content_role_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rep_rec_content_role_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rep_rec_content_role_seq` --
LOCK TABLES `rep_rec_content_role_seq` WRITE; /*!40000 ALTER TABLE `rep_rec_content_role_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `rep_rec_content_role_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rfil_settings` --
DROP TABLE IF EXISTS `rfil_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rfil_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `version` smallint(6) NOT NULL DEFAULT '1', `version_tstamp` int(11) DEFAULT NULL, PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rfil_settings` --
LOCK TABLES `rfil_settings` WRITE; /*!40000 ALTER TABLE `rfil_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rfil_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rglo_settings` --
DROP TABLE IF EXISTS `rglo_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rglo_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rglo_settings` --
LOCK TABLES `rglo_settings` WRITE; /*!40000 ALTER TABLE `rglo_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rglo_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rgrp_settings` --
DROP TABLE IF EXISTS `rgrp_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rgrp_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', `availability_start` int(11) DEFAULT NULL, `availability_end` int(11) DEFAULT NULL, PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rgrp_settings` --
LOCK TABLES `rgrp_settings` WRITE; /*!40000 ALTER TABLE `rgrp_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rgrp_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rlm_settings` --
DROP TABLE IF EXISTS `rlm_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rlm_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rlm_settings` --
LOCK TABLES `rlm_settings` WRITE; /*!40000 ALTER TABLE `rlm_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rlm_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `role_data` --
DROP TABLE IF EXISTS `role_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_data` ( `role_id` int(11) NOT NULL DEFAULT '0', `allow_register` tinyint(4) NOT NULL DEFAULT '0', `assign_users` tinyint(4) DEFAULT '0', `auth_mode` char(16) DEFAULT 'default', PRIMARY KEY (`role_id`), KEY `i1_idx` (`auth_mode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `role_data` --
LOCK TABLES `role_data` WRITE; /*!40000 ALTER TABLE `role_data` DISABLE KEYS */; INSERT INTO `role_data` VALUES (2,0,0,'default'),(3,0,0,'default'),(4,0,0,'default'),(5,1,0,'default'),(14,0,0,'default'),(134,0,0,'default'),(187,0,0,'default'); /*!40000 ALTER TABLE `role_data` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rtst_settings` --
DROP TABLE IF EXISTS `rtst_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rtst_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', `availability_start` int(11) DEFAULT NULL, `availability_end` int(11) DEFAULT NULL, PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rtst_settings` --
LOCK TABLES `rtst_settings` WRITE; /*!40000 ALTER TABLE `rtst_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rtst_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `rwik_settings` --
DROP TABLE IF EXISTS `rwik_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rwik_settings` ( `obj_id` int(11) NOT NULL DEFAULT '0', `mid` int(11) NOT NULL DEFAULT '0', `organization` varchar(400) DEFAULT NULL, `local_information` varchar(4000) DEFAULT NULL, `remote_link` varchar(400) DEFAULT NULL, `availability_type` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `rwik_settings` --
LOCK TABLES `rwik_settings` WRITE; /*!40000 ALTER TABLE `rwik_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `rwik_settings` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_lm` --
DROP TABLE IF EXISTS `sahs_lm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_lm` ( `id` int(11) NOT NULL DEFAULT '0', `c_online` varchar(3) DEFAULT 'n', `api_adapter` varchar(80) DEFAULT 'API', `api_func_prefix` varchar(20) DEFAULT 'LMS', `credit` varchar(10) DEFAULT 'credit', `default_lesson_mode` varchar(8) DEFAULT 'normal', `auto_review` varchar(3) DEFAULT 'n', `c_type` varchar(10) DEFAULT NULL, `max_attempt` int(11) DEFAULT '0', `module_version` int(11) DEFAULT '1', `editable` int(11) NOT NULL DEFAULT '0', `stylesheet` int(11) NOT NULL DEFAULT '0', `glossary` int(11) NOT NULL DEFAULT '0', `question_tries` int(11) DEFAULT '3', `unlimited_session` varchar(1) NOT NULL DEFAULT 'n', `no_menu` varchar(1) NOT NULL DEFAULT 'n', `hide_navig` varchar(1) NOT NULL DEFAULT 'n', `debug` varchar(1) NOT NULL DEFAULT 'n', `debugpw` varchar(50) DEFAULT 'n', `entry_page` int(11) NOT NULL DEFAULT '0', `seq_exp_mode` tinyint(4) DEFAULT '0', `localization` varchar(2) DEFAULT NULL, `open_mode` tinyint(4) NOT NULL DEFAULT '0', `width` smallint(6) NOT NULL DEFAULT '950', `height` smallint(6) NOT NULL DEFAULT '650', `auto_continue` varchar(1) NOT NULL DEFAULT 'n', `sequencing` varchar(1) NOT NULL DEFAULT 'y', `interactions` varchar(1) NOT NULL DEFAULT 'y', `objectives` varchar(1) NOT NULL DEFAULT 'y', `time_from_lms` varchar(1) NOT NULL DEFAULT 'n', `comments` varchar(1) NOT NULL DEFAULT 'y', `auto_last_visited` varchar(1) NOT NULL DEFAULT 'y', `check_values` varchar(1) NOT NULL DEFAULT 'y', `offline_mode` varchar(1) NOT NULL DEFAULT 'n', `offline_zip_created` datetime DEFAULT NULL, `auto_suspend` varchar(1) NOT NULL DEFAULT 'n', `fourth_edition` varchar(1) NOT NULL DEFAULT 'n', `ie_compatibility` varchar(1) DEFAULT NULL, `ie_force_render` varchar(1) NOT NULL DEFAULT 'n', `mastery_score` tinyint(4) DEFAULT NULL, `id_setting` tinyint(4) NOT NULL DEFAULT '0', `name_setting` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_lm` --
LOCK TABLES `sahs_lm` WRITE; /*!40000 ALTER TABLE `sahs_lm` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_lm` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_sco` --
DROP TABLE IF EXISTS `sahs_sc13_sco`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_sco` ( `id` int(11) NOT NULL DEFAULT '0', `hide_obj_page` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_sco` --
LOCK TABLES `sahs_sc13_sco` WRITE; /*!40000 ALTER TABLE `sahs_sc13_sco` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_sc13_sco` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_seq_assign` --
DROP TABLE IF EXISTS `sahs_sc13_seq_assign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_seq_assign` ( `identifier` varchar(50) DEFAULT NULL, `sahs_sc13_tree_node_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sahs_sc13_tree_node_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_seq_assign` --
LOCK TABLES `sahs_sc13_seq_assign` WRITE; /*!40000 ALTER TABLE `sahs_sc13_seq_assign` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_sc13_seq_assign` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_seq_cond` --
DROP TABLE IF EXISTS `sahs_sc13_seq_cond`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_seq_cond` ( `cond` varchar(50) DEFAULT NULL, `seqnodeid` int(11) NOT NULL DEFAULT '0', `measurethreshold` varchar(50) DEFAULT NULL, `operator` varchar(50) DEFAULT NULL, `referencedobjective` varchar(50) DEFAULT NULL, PRIMARY KEY (`seqnodeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_seq_cond` --
LOCK TABLES `sahs_sc13_seq_cond` WRITE; /*!40000 ALTER TABLE `sahs_sc13_seq_cond` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_sc13_seq_cond` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_seq_course` --
DROP TABLE IF EXISTS `sahs_sc13_seq_course`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_seq_course` ( `flow` tinyint(4) DEFAULT '0', `choice` tinyint(4) DEFAULT '1', `forwardonly` tinyint(4) DEFAULT '0', `obj_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`obj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_seq_course` --
LOCK TABLES `sahs_sc13_seq_course` WRITE; /*!40000 ALTER TABLE `sahs_sc13_seq_course` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_sc13_seq_course` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_seq_item` --
DROP TABLE IF EXISTS `sahs_sc13_seq_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_seq_item` ( `importid` varchar(32) DEFAULT NULL, `seqnodeid` int(11) NOT NULL DEFAULT '0', `sahs_sc13_tree_node_id` int(11) NOT NULL DEFAULT '0', `sequencingid` varchar(50) DEFAULT NULL, `nocopy` tinyint(4) DEFAULT NULL, `nodelete` tinyint(4) DEFAULT NULL, `nomove` tinyint(4) DEFAULT NULL, `seqxml` longtext, `rootlevel` tinyint(4) NOT NULL DEFAULT '0', `importseqxml` longtext, PRIMARY KEY (`sahs_sc13_tree_node_id`,`rootlevel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_seq_item` --
LOCK TABLES `sahs_sc13_seq_item` WRITE; /*!40000 ALTER TABLE `sahs_sc13_seq_item` DISABLE KEYS */; /*!40000 ALTER TABLE `sahs_sc13_seq_item` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_seq_mapinfo` --
-- -- Dumping data for table `sahs_sc13_tree_node` --
LOCK TABLES `sahs_sc13_tree_node` WRITE; /*!40000 ALTER TABLE `sahs_sc13_tree_node` DISABLE KEYS */; INSERT INTO `sahs_sc13_tree_node` VALUES (1,'Dummy top node for all trees.','',0,'',NULL,NULL); /*!40000 ALTER TABLE `sahs_sc13_tree_node` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `sahs_sc13_tree_node_seq` --
DROP TABLE IF EXISTS `sahs_sc13_tree_node_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sahs_sc13_tree_node_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `sahs_sc13_tree_node_seq` --
LOCK TABLES `sahs_sc13_tree_node_seq` WRITE; /*!40000 ALTER TABLE `sahs_sc13_tree_node_seq` DISABLE KEYS */; INSERT INTO `sahs_sc13_tree_node_seq` VALUES (1); /*!40000 ALTER TABLE `sahs_sc13_tree_node_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `write_event_seq` --
DROP TABLE IF EXISTS `write_event_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `write_event_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `write_event_seq` --
LOCK TABLES `write_event_seq` WRITE; /*!40000 ALTER TABLE `write_event_seq` DISABLE KEYS */; INSERT INTO `write_event_seq` VALUES (25); /*!40000 ALTER TABLE `write_event_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xhtml_page` --
DROP TABLE IF EXISTS `xhtml_page`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xhtml_page` ( `id` int(11) NOT NULL DEFAULT '0', `content` longtext, `save_content` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xhtml_page` --
LOCK TABLES `xhtml_page` WRITE; /*!40000 ALTER TABLE `xhtml_page` DISABLE KEYS */; /*!40000 ALTER TABLE `xhtml_page` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xhtml_page_seq` --
DROP TABLE IF EXISTS `xhtml_page_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xhtml_page_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xhtml_page_seq` --
LOCK TABLES `xhtml_page_seq` WRITE; /*!40000 ALTER TABLE `xhtml_page_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `xhtml_page_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlnestedset` --
DROP TABLE IF EXISTS `xmlnestedset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlnestedset` ( `ns_id` int(11) NOT NULL DEFAULT '0', `ns_book_fk` int(11) NOT NULL DEFAULT '0', `ns_type` varchar(50) NOT NULL DEFAULT '', `ns_tag_fk` int(11) NOT NULL DEFAULT '0', `ns_l` int(11) NOT NULL DEFAULT '0', `ns_r` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ns_id`), KEY `i1_idx` (`ns_tag_fk`), KEY `i2_idx` (`ns_l`), KEY `i3_idx` (`ns_r`), KEY `i4_idx` (`ns_book_fk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlnestedset` --
LOCK TABLES `xmlnestedset` WRITE; /*!40000 ALTER TABLE `xmlnestedset` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlnestedset` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlnestedset_seq` --
DROP TABLE IF EXISTS `xmlnestedset_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlnestedset_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlnestedset_seq` --
LOCK TABLES `xmlnestedset_seq` WRITE; /*!40000 ALTER TABLE `xmlnestedset_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlnestedset_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlnestedsettmp` --
DROP TABLE IF EXISTS `xmlnestedsettmp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlnestedsettmp` ( `ns_id` int(11) NOT NULL DEFAULT '0', `ns_unique_id` varchar(32) NOT NULL DEFAULT '', `ns_book_fk` int(11) NOT NULL DEFAULT '0', `ns_type` varchar(50) NOT NULL DEFAULT '', `ns_tag_fk` int(11) NOT NULL DEFAULT '0', `ns_l` int(11) NOT NULL DEFAULT '0', `ns_r` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ns_id`), KEY `i1_idx` (`ns_tag_fk`), KEY `i2_idx` (`ns_l`), KEY `i3_idx` (`ns_r`), KEY `i4_idx` (`ns_book_fk`), KEY `i5_idx` (`ns_unique_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlnestedsettmp` --
LOCK TABLES `xmlnestedsettmp` WRITE; /*!40000 ALTER TABLE `xmlnestedsettmp` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlnestedsettmp` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlnestedsettmp_seq` --
DROP TABLE IF EXISTS `xmlnestedsettmp_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlnestedsettmp_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlnestedsettmp_seq` --
LOCK TABLES `xmlnestedsettmp_seq` WRITE; /*!40000 ALTER TABLE `xmlnestedsettmp_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlnestedsettmp_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlparam` --
DROP TABLE IF EXISTS `xmlparam`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlparam` ( `tag_fk` int(11) NOT NULL DEFAULT '0', `param_name` char(50) NOT NULL DEFAULT '', `param_value` char(255) DEFAULT NULL, PRIMARY KEY (`tag_fk`,`param_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlparam` --
LOCK TABLES `xmlparam` WRITE; /*!40000 ALTER TABLE `xmlparam` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlparam` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmltags` --
DROP TABLE IF EXISTS `xmltags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmltags` ( `tag_pk` int(11) NOT NULL DEFAULT '0', `tag_depth` int(11) NOT NULL DEFAULT '0', `tag_name` char(50) DEFAULT NULL, PRIMARY KEY (`tag_pk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmltags` --
LOCK TABLES `xmltags` WRITE; /*!40000 ALTER TABLE `xmltags` DISABLE KEYS */; /*!40000 ALTER TABLE `xmltags` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmltags_seq` --
DROP TABLE IF EXISTS `xmltags_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmltags_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmltags_seq` --
LOCK TABLES `xmltags_seq` WRITE; /*!40000 ALTER TABLE `xmltags_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `xmltags_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlvalue` --
DROP TABLE IF EXISTS `xmlvalue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlvalue` ( `tag_value_pk` int(11) NOT NULL DEFAULT '0', `tag_fk` int(11) NOT NULL DEFAULT '0', `tag_value` longtext, PRIMARY KEY (`tag_value_pk`), KEY `i1_idx` (`tag_fk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlvalue` --
LOCK TABLES `xmlvalue` WRITE; /*!40000 ALTER TABLE `xmlvalue` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlvalue` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `xmlvalue_seq` --
DROP TABLE IF EXISTS `xmlvalue_seq`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xmlvalue_seq` ( `sequence` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `xmlvalue_seq` --
LOCK TABLES `xmlvalue_seq` WRITE; /*!40000 ALTER TABLE `xmlvalue_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `xmlvalue_seq` ENABLE KEYS */; UNLOCK TABLES;
-- -- Dumping routines for database 'ilias97' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;