"Fossies" - the Fresh Open Source Software Archive

Member "4.6.1/db/studip.sql" (8 Apr 2021, 235093 Bytes) of package /linux/www/studip-4.6.1.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. See also the latest Fossies "Diffs" side-by-side code changes report for "studip.sql": 4.6_vs_4.6.1.

    1 -- MySQL dump 10.13  Distrib 5.7.32-35, for debian-linux-gnu (x86_64)
    2 --
    3 -- Host: localhost    Database: studip_46
    4 -- ------------------------------------------------------
    5 -- Server version   5.7.32-35
    6 
    7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
   10 /*!40101 SET NAMES utf8 */;
   11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
   12 /*!40103 SET TIME_ZONE='+00:00' */;
   13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
   14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
   15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
   16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
   17 
   18 --
   19 -- Table structure for table `Institute`
   20 --
   21 
   22 DROP TABLE IF EXISTS `Institute`;
   23 /*!40101 SET @saved_cs_client     = @@character_set_client */;
   24 /*!40101 SET character_set_client = utf8 */;
   25 CREATE TABLE `Institute` (
   26   `Institut_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
   27   `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   28   `fakultaets_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
   29   `Strasse` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   30   `Plz` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   31   `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'http://www.studip.de',
   32   `telefon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   33   `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   34   `fax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   35   `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   36   `modules` int(10) unsigned DEFAULT NULL,
   37   `mkdate` int(20) NOT NULL DEFAULT '0',
   38   `chdate` int(20) NOT NULL DEFAULT '0',
   39   `lit_plugin_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   40   `srienabled` tinyint(4) NOT NULL DEFAULT '0',
   41   `lock_rule` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
   42   PRIMARY KEY (`Institut_id`),
   43   KEY `fakultaets_id` (`fakultaets_id`)
   44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
   45 /*!40101 SET character_set_client = @saved_cs_client */;
   46 
   47 --
   48 -- Table structure for table `abschluss`
   49 --
   50 
   51 DROP TABLE IF EXISTS `abschluss`;
   52 /*!40101 SET @saved_cs_client     = @@character_set_client */;
   53 /*!40101 SET character_set_client = utf8 */;
   54 CREATE TABLE `abschluss` (
   55   `abschluss_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
   56   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   57   `name_kurz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   58   `beschreibung` text COLLATE utf8mb4_unicode_ci,
   59   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   60   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   61   `mkdate` int(20) DEFAULT NULL,
   62   `chdate` int(20) DEFAULT NULL,
   63   PRIMARY KEY (`abschluss_id`)
   64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
   65 /*!40101 SET character_set_client = @saved_cs_client */;
   66 
   67 --
   68 -- Table structure for table `activities`
   69 --
   70 
   71 DROP TABLE IF EXISTS `activities`;
   72 /*!40101 SET @saved_cs_client     = @@character_set_client */;
   73 /*!40101 SET character_set_client = utf8 */;
   74 CREATE TABLE `activities` (
   75   `id` int(11) NOT NULL AUTO_INCREMENT,
   76   `object_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   77   `context` enum('system','course','institute','user') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   78   `context_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   79   `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   80   `actor_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   81   `actor_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   82   `verb` enum('answered','attempted','attended','completed','created','deleted','edited','experienced','failed','imported','interacted','passed','shared','sent','voided') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'experienced',
   83   `content` text COLLATE utf8mb4_unicode_ci,
   84   `object_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   85   `mkdate` int(11) NOT NULL,
   86   PRIMARY KEY (`id`),
   87   KEY `context_id` (`context_id`),
   88   KEY `mkdate` (`mkdate`),
   89   KEY `object_id` (`object_id`(32))
   90 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
   91 /*!40101 SET character_set_client = @saved_cs_client */;
   92 
   93 --
   94 -- Table structure for table `admission_condition`
   95 --
   96 
   97 DROP TABLE IF EXISTS `admission_condition`;
   98 /*!40101 SET @saved_cs_client     = @@character_set_client */;
   99 /*!40101 SET character_set_client = utf8 */;
  100 CREATE TABLE `admission_condition` (
  101   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  102   `filter_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  103   `conditiongroup_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  104   `mkdate` int(11) NOT NULL DEFAULT '0',
  105   PRIMARY KEY (`rule_id`,`filter_id`)
  106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  107 /*!40101 SET character_set_client = @saved_cs_client */;
  108 
  109 --
  110 -- Table structure for table `admission_conditiongroup`
  111 --
  112 
  113 DROP TABLE IF EXISTS `admission_conditiongroup`;
  114 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  115 /*!40101 SET character_set_client = utf8 */;
  116 CREATE TABLE `admission_conditiongroup` (
  117   `conditiongroup_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  118   `quota` int(11) NOT NULL,
  119   PRIMARY KEY (`conditiongroup_id`)
  120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  121 /*!40101 SET character_set_client = @saved_cs_client */;
  122 
  123 --
  124 -- Table structure for table `admission_seminar_user`
  125 --
  126 
  127 DROP TABLE IF EXISTS `admission_seminar_user`;
  128 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  129 /*!40101 SET character_set_client = utf8 */;
  130 CREATE TABLE `admission_seminar_user` (
  131   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  132   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  133   `status` enum('awaiting','accepted') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  134   `mkdate` int(20) NOT NULL DEFAULT '0',
  135   `position` int(5) DEFAULT NULL,
  136   `comment` tinytext COLLATE utf8mb4_unicode_ci,
  137   `visible` enum('yes','no','unknown') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'unknown',
  138   PRIMARY KEY (`user_id`,`seminar_id`),
  139   KEY `seminar_id` (`seminar_id`,`status`)
  140 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  141 /*!40101 SET character_set_client = @saved_cs_client */;
  142 
  143 --
  144 -- Table structure for table `admissionfactor`
  145 --
  146 
  147 DROP TABLE IF EXISTS `admissionfactor`;
  148 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  149 /*!40101 SET character_set_client = utf8 */;
  150 CREATE TABLE `admissionfactor` (
  151   `list_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  152   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  153   `factor` float NOT NULL DEFAULT '1',
  154   `owner_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  155   `mkdate` int(11) NOT NULL DEFAULT '0',
  156   `chdate` int(11) NOT NULL DEFAULT '0',
  157   PRIMARY KEY (`list_id`)
  158 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  159 /*!40101 SET character_set_client = @saved_cs_client */;
  160 
  161 --
  162 -- Table structure for table `admissionrule_compat`
  163 --
  164 
  165 DROP TABLE IF EXISTS `admissionrule_compat`;
  166 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  167 /*!40101 SET character_set_client = utf8 */;
  168 CREATE TABLE `admissionrule_compat` (
  169   `rule_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  170   `compat_rule_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  171   `mkdate` int(11) NOT NULL DEFAULT '0',
  172   `chdate` int(11) NOT NULL DEFAULT '0',
  173   PRIMARY KEY (`rule_type`,`compat_rule_type`)
  174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  175 /*!40101 SET character_set_client = @saved_cs_client */;
  176 
  177 --
  178 -- Table structure for table `admissionrule_inst`
  179 --
  180 
  181 DROP TABLE IF EXISTS `admissionrule_inst`;
  182 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  183 /*!40101 SET character_set_client = utf8 */;
  184 CREATE TABLE `admissionrule_inst` (
  185   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  186   `institute_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  187   `mkdate` int(11) NOT NULL DEFAULT '0',
  188   PRIMARY KEY (`rule_id`,`institute_id`)
  189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  190 /*!40101 SET character_set_client = @saved_cs_client */;
  191 
  192 --
  193 -- Table structure for table `admissionrules`
  194 --
  195 
  196 DROP TABLE IF EXISTS `admissionrules`;
  197 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  198 /*!40101 SET character_set_client = utf8 */;
  199 CREATE TABLE `admissionrules` (
  200   `id` int(11) NOT NULL AUTO_INCREMENT,
  201   `ruletype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  202   `active` tinyint(1) NOT NULL DEFAULT '0',
  203   `mkdate` int(11) NOT NULL DEFAULT '0',
  204   `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  205   PRIMARY KEY (`id`),
  206   UNIQUE KEY `ruletype` (`ruletype`)
  207 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  208 /*!40101 SET character_set_client = @saved_cs_client */;
  209 
  210 --
  211 -- Table structure for table `api_consumer_permissions`
  212 --
  213 
  214 DROP TABLE IF EXISTS `api_consumer_permissions`;
  215 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  216 /*!40101 SET character_set_client = utf8 */;
  217 CREATE TABLE `api_consumer_permissions` (
  218   `route_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  219   `consumer_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  220   `method` char(6) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  221   `granted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  222   UNIQUE KEY `route_id` (`route_id`,`consumer_id`,`method`)
  223 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  224 /*!40101 SET character_set_client = @saved_cs_client */;
  225 
  226 --
  227 -- Table structure for table `api_consumers`
  228 --
  229 
  230 DROP TABLE IF EXISTS `api_consumers`;
  231 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  232 /*!40101 SET character_set_client = utf8 */;
  233 CREATE TABLE `api_consumers` (
  234   `consumer_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  235   `consumer_type` enum('http','studip','oauth') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'studip',
  236   `auth_key` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  237   `auth_secret` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  238   `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  239   `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
  240   `type` enum('website','mobile','desktop') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'website',
  241   `title` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  242   `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  243   `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  244   `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  245   `callback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  246   `commercial` tinyint(1) DEFAULT NULL,
  247   `description` text COLLATE utf8mb4_unicode_ci,
  248   `priority` int(11) unsigned NOT NULL DEFAULT '0',
  249   `notes` text COLLATE utf8mb4_unicode_ci,
  250   `mkdate` int(11) unsigned NOT NULL,
  251   `chdate` int(11) unsigned NOT NULL,
  252   PRIMARY KEY (`consumer_id`)
  253 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  254 /*!40101 SET character_set_client = @saved_cs_client */;
  255 
  256 --
  257 -- Table structure for table `api_oauth_user_mapping`
  258 --
  259 
  260 DROP TABLE IF EXISTS `api_oauth_user_mapping`;
  261 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  262 /*!40101 SET character_set_client = utf8 */;
  263 CREATE TABLE `api_oauth_user_mapping` (
  264   `oauth_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  265   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  266   `mkdate` int(11) unsigned NOT NULL,
  267   PRIMARY KEY (`oauth_id`)
  268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  269 /*!40101 SET character_set_client = @saved_cs_client */;
  270 
  271 --
  272 -- Table structure for table `api_user_permissions`
  273 --
  274 
  275 DROP TABLE IF EXISTS `api_user_permissions`;
  276 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  277 /*!40101 SET character_set_client = utf8 */;
  278 CREATE TABLE `api_user_permissions` (
  279   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  280   `consumer_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  281   `granted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  282   `mkdate` int(11) unsigned NOT NULL,
  283   `chdate` int(11) unsigned NOT NULL,
  284   PRIMARY KEY (`user_id`,`consumer_id`)
  285 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  286 /*!40101 SET character_set_client = @saved_cs_client */;
  287 
  288 --
  289 -- Table structure for table `archiv`
  290 --
  291 
  292 DROP TABLE IF EXISTS `archiv`;
  293 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  294 /*!40101 SET character_set_client = utf8 */;
  295 CREATE TABLE `archiv` (
  296   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  297   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  298   `untertitel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  299   `beschreibung` text COLLATE utf8mb4_unicode_ci NOT NULL,
  300   `start_time` int(20) NOT NULL DEFAULT '0',
  301   `semester` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  302   `heimat_inst_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  303   `institute` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  304   `dozenten` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  305   `fakultaet` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  306   `dump` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  307   `archiv_file_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  308   `archiv_protected_file_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  309   `mkdate` int(20) NOT NULL DEFAULT '0',
  310   `forumdump` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  311   `wikidump` longtext COLLATE utf8mb4_unicode_ci,
  312   `studienbereiche` text COLLATE utf8mb4_unicode_ci NOT NULL,
  313   `VeranstaltungsNummer` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  314   PRIMARY KEY (`seminar_id`),
  315   KEY `heimat_inst_id` (`heimat_inst_id`)
  316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  317 /*!40101 SET character_set_client = @saved_cs_client */;
  318 
  319 --
  320 -- Table structure for table `archiv_user`
  321 --
  322 
  323 DROP TABLE IF EXISTS `archiv_user`;
  324 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  325 /*!40101 SET character_set_client = utf8 */;
  326 CREATE TABLE `archiv_user` (
  327   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  328   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  329   `status` enum('user','autor','tutor','dozent') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'user',
  330   PRIMARY KEY (`seminar_id`,`user_id`),
  331   KEY `user_id` (`user_id`,`status`)
  332 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  333 /*!40101 SET character_set_client = @saved_cs_client */;
  334 
  335 --
  336 -- Table structure for table `auth_extern`
  337 --
  338 
  339 DROP TABLE IF EXISTS `auth_extern`;
  340 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  341 /*!40101 SET character_set_client = utf8 */;
  342 CREATE TABLE `auth_extern` (
  343   `studip_user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  344   `external_user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  345   `external_user_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  346   `external_user_password` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  347   `external_user_token` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  348   `external_user_token_valid_until` int(11) NOT NULL DEFAULT '0',
  349   `external_user_category` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  350   `external_user_system_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  351   `external_user_type` smallint(6) NOT NULL DEFAULT '0',
  352   PRIMARY KEY (`studip_user_id`,`external_user_system_type`,`external_user_type`)
  353 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  354 /*!40101 SET character_set_client = @saved_cs_client */;
  355 
  356 --
  357 -- Table structure for table `auth_user_md5`
  358 --
  359 
  360 DROP TABLE IF EXISTS `auth_user_md5`;
  361 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  362 /*!40101 SET character_set_client = utf8 */;
  363 CREATE TABLE `auth_user_md5` (
  364   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  365   `username` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  366   `password` varbinary(64) NOT NULL DEFAULT '',
  367   `perms` enum('user','autor','tutor','dozent','admin','root') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'user',
  368   `Vorname` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  369   `Nachname` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  370   `Email` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  371   `validation_key` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  372   `auth_plugin` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT 'standard',
  373   `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  374   `lock_comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  375   `locked_by` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  376   `visible` enum('global','always','yes','unknown','no','never') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'unknown',
  377   PRIMARY KEY (`user_id`),
  378   UNIQUE KEY `k_username` (`username`),
  379   KEY `perms` (`perms`)
  380 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  381 /*!40101 SET character_set_client = @saved_cs_client */;
  382 
  383 --
  384 -- Table structure for table `auto_insert_sem`
  385 --
  386 
  387 DROP TABLE IF EXISTS `auto_insert_sem`;
  388 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  389 /*!40101 SET character_set_client = utf8 */;
  390 CREATE TABLE `auto_insert_sem` (
  391   `seminar_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  392   `status` enum('autor','tutor','dozent') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'autor',
  393   `domain_id` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  394   PRIMARY KEY (`seminar_id`,`status`,`domain_id`)
  395 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  396 /*!40101 SET character_set_client = @saved_cs_client */;
  397 
  398 --
  399 -- Table structure for table `auto_insert_user`
  400 --
  401 
  402 DROP TABLE IF EXISTS `auto_insert_user`;
  403 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  404 /*!40101 SET character_set_client = utf8 */;
  405 CREATE TABLE `auto_insert_user` (
  406   `seminar_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  407   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  408   `mkdate` int(10) unsigned NOT NULL DEFAULT '0',
  409   PRIMARY KEY (`seminar_id`,`user_id`)
  410 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  411 /*!40101 SET character_set_client = @saved_cs_client */;
  412 
  413 --
  414 -- Table structure for table `aux_lock_rules`
  415 --
  416 
  417 DROP TABLE IF EXISTS `aux_lock_rules`;
  418 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  419 /*!40101 SET character_set_client = utf8 */;
  420 CREATE TABLE `aux_lock_rules` (
  421   `lock_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  422   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  423   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  424   `attributes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  425   `sorting` text COLLATE utf8mb4_unicode_ci NOT NULL,
  426   PRIMARY KEY (`lock_id`)
  427 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  428 /*!40101 SET character_set_client = @saved_cs_client */;
  429 
  430 --
  431 -- Table structure for table `banner_ads`
  432 --
  433 
  434 DROP TABLE IF EXISTS `banner_ads`;
  435 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  436 /*!40101 SET character_set_client = utf8 */;
  437 CREATE TABLE `banner_ads` (
  438   `ad_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  439   `banner_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  440   `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  441   `alttext` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  442   `target_type` enum('url','seminar','inst','user','none') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'url',
  443   `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  444   `startdate` int(20) NOT NULL DEFAULT '0',
  445   `enddate` int(20) NOT NULL DEFAULT '0',
  446   `priority` int(4) NOT NULL DEFAULT '0',
  447   `views` int(11) NOT NULL DEFAULT '0',
  448   `clicks` int(11) NOT NULL DEFAULT '0',
  449   `mkdate` int(20) NOT NULL DEFAULT '0',
  450   `chdate` int(20) NOT NULL DEFAULT '0',
  451   PRIMARY KEY (`ad_id`)
  452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  453 /*!40101 SET character_set_client = @saved_cs_client */;
  454 
  455 --
  456 -- Table structure for table `blubber_comments`
  457 --
  458 
  459 DROP TABLE IF EXISTS `blubber_comments`;
  460 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  461 /*!40101 SET character_set_client = utf8 */;
  462 CREATE TABLE `blubber_comments` (
  463   `comment_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  464   `thread_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  465   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  466   `external_contact` tinyint(1) NOT NULL DEFAULT '0',
  467   `content` text COLLATE utf8mb4_unicode_ci,
  468   `network` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  469   `chdate` int(11) DEFAULT NULL,
  470   `mkdate` int(11) DEFAULT NULL,
  471   PRIMARY KEY (`comment_id`),
  472   KEY `thread_id` (`thread_id`),
  473   KEY `user_id` (`user_id`)
  474 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  475 /*!40101 SET character_set_client = @saved_cs_client */;
  476 
  477 --
  478 -- Table structure for table `blubber_events_queue`
  479 --
  480 
  481 DROP TABLE IF EXISTS `blubber_events_queue`;
  482 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  483 /*!40101 SET character_set_client = utf8 */;
  484 CREATE TABLE `blubber_events_queue` (
  485   `event_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  486   `item_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  487   `mkdate` int(11) NOT NULL,
  488   PRIMARY KEY (`event_type`,`item_id`,`mkdate`),
  489   KEY `item_id` (`item_id`)
  490 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  491 /*!40101 SET character_set_client = @saved_cs_client */;
  492 
  493 --
  494 -- Table structure for table `blubber_external_contact`
  495 --
  496 
  497 DROP TABLE IF EXISTS `blubber_external_contact`;
  498 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  499 /*!40101 SET character_set_client = utf8 */;
  500 CREATE TABLE `blubber_external_contact` (
  501   `external_contact_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  502   `mail_identifier` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  503   `contact_type` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'anonymous',
  504   `name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  505   `data` text COLLATE utf8mb4_unicode_ci,
  506   `chdate` bigint(20) NOT NULL,
  507   `mkdate` bigint(20) NOT NULL,
  508   PRIMARY KEY (`external_contact_id`),
  509   KEY `mail_identifier` (`mail_identifier`),
  510   KEY `contact_type` (`contact_type`)
  511 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  512 /*!40101 SET character_set_client = @saved_cs_client */;
  513 
  514 --
  515 -- Table structure for table `blubber_follower`
  516 --
  517 
  518 DROP TABLE IF EXISTS `blubber_follower`;
  519 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  520 /*!40101 SET character_set_client = utf8 */;
  521 CREATE TABLE `blubber_follower` (
  522   `studip_user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  523   `external_contact_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  524   `left_follows_right` tinyint(1) NOT NULL,
  525   KEY `studip_user_id` (`studip_user_id`),
  526   KEY `external_contact_id` (`external_contact_id`)
  527 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  528 /*!40101 SET character_set_client = @saved_cs_client */;
  529 
  530 --
  531 -- Table structure for table `blubber_mentions`
  532 --
  533 
  534 DROP TABLE IF EXISTS `blubber_mentions`;
  535 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  536 /*!40101 SET character_set_client = utf8 */;
  537 CREATE TABLE `blubber_mentions` (
  538   `mention_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  539   `thread_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  540   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  541   `external_contact` tinyint(4) NOT NULL DEFAULT '0',
  542   `mkdate` int(11) NOT NULL,
  543   PRIMARY KEY (`mention_id`),
  544   UNIQUE KEY `unique_users_per_topic` (`thread_id`,`user_id`,`external_contact`),
  545   KEY `topic_id` (`thread_id`),
  546   KEY `user_id` (`user_id`)
  547 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  548 /*!40101 SET character_set_client = @saved_cs_client */;
  549 
  550 --
  551 -- Table structure for table `blubber_tags`
  552 --
  553 
  554 DROP TABLE IF EXISTS `blubber_tags`;
  555 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  556 /*!40101 SET character_set_client = utf8 */;
  557 CREATE TABLE `blubber_tags` (
  558   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  559   `tag` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  560   PRIMARY KEY (`topic_id`,`tag`),
  561   KEY `tag` (`tag`)
  562 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  563 /*!40101 SET character_set_client = @saved_cs_client */;
  564 
  565 --
  566 -- Table structure for table `blubber_threads`
  567 --
  568 
  569 DROP TABLE IF EXISTS `blubber_threads`;
  570 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  571 /*!40101 SET character_set_client = utf8 */;
  572 CREATE TABLE `blubber_threads` (
  573   `thread_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  574   `context_type` enum('public','private','course','institute') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'public',
  575   `context_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  576   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  577   `external_contact` tinyint(1) NOT NULL DEFAULT '0',
  578   `content` text COLLATE utf8mb4_unicode_ci,
  579   `display_class` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  580   `visible_in_stream` tinyint(1) NOT NULL DEFAULT '1',
  581   `commentable` tinyint(1) NOT NULL DEFAULT '1',
  582   `metadata` text COLLATE utf8mb4_unicode_ci,
  583   `chdate` int(11) DEFAULT NULL,
  584   `mkdate` int(11) DEFAULT NULL,
  585   PRIMARY KEY (`thread_id`),
  586   KEY `context_type` (`context_type`),
  587   KEY `context_id` (`context_id`),
  588   KEY `user_id` (`user_id`)
  589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  590 /*!40101 SET character_set_client = @saved_cs_client */;
  591 
  592 --
  593 -- Table structure for table `blubber_threads_unfollow`
  594 --
  595 
  596 DROP TABLE IF EXISTS `blubber_threads_unfollow`;
  597 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  598 /*!40101 SET character_set_client = utf8 */;
  599 CREATE TABLE `blubber_threads_unfollow` (
  600   `thread_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  601   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  602   `mkdate` int(11) DEFAULT NULL,
  603   PRIMARY KEY (`thread_id`,`user_id`)
  604 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  605 /*!40101 SET character_set_client = @saved_cs_client */;
  606 
  607 --
  608 -- Table structure for table `cache`
  609 --
  610 
  611 DROP TABLE IF EXISTS `cache`;
  612 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  613 /*!40101 SET character_set_client = utf8 */;
  614 CREATE TABLE `cache` (
  615   `cache_key` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  616   `content` mediumblob NOT NULL,
  617   `expires` int(11) unsigned NOT NULL,
  618   PRIMARY KEY (`cache_key`)
  619 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  620 /*!40101 SET character_set_client = @saved_cs_client */;
  621 
  622 --
  623 -- Table structure for table `cache_operations`
  624 --
  625 
  626 DROP TABLE IF EXISTS `cache_operations`;
  627 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  628 /*!40101 SET character_set_client = utf8 */;
  629 CREATE TABLE `cache_operations` (
  630   `cache_key` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  631   `operation` char(6) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  632   `parameters` text COLLATE utf8mb4_unicode_ci NOT NULL,
  633   `mkdate` int(11) unsigned NOT NULL,
  634   `chdate` int(11) unsigned NOT NULL,
  635   PRIMARY KEY (`cache_key`(200),`operation`)
  636 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  637 /*!40101 SET character_set_client = @saved_cs_client */;
  638 
  639 --
  640 -- Table structure for table `calendar_event`
  641 --
  642 
  643 DROP TABLE IF EXISTS `calendar_event`;
  644 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  645 /*!40101 SET character_set_client = utf8 */;
  646 CREATE TABLE `calendar_event` (
  647   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  648   `event_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  649   `group_status` tinyint(4) unsigned NOT NULL DEFAULT '0',
  650   `mkdate` int(11) NOT NULL,
  651   `chdate` int(10) unsigned NOT NULL DEFAULT '0',
  652   PRIMARY KEY (`range_id`,`event_id`)
  653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  654 /*!40101 SET character_set_client = @saved_cs_client */;
  655 
  656 --
  657 -- Table structure for table `calendar_user`
  658 --
  659 
  660 DROP TABLE IF EXISTS `calendar_user`;
  661 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  662 /*!40101 SET character_set_client = utf8 */;
  663 CREATE TABLE `calendar_user` (
  664   `owner_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  665   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  666   `permission` int(2) NOT NULL,
  667   `mkdate` int(11) NOT NULL,
  668   `chdate` int(11) NOT NULL,
  669   PRIMARY KEY (`owner_id`,`user_id`)
  670 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  671 /*!40101 SET character_set_client = @saved_cs_client */;
  672 
  673 --
  674 -- Table structure for table `clipboard_items`
  675 --
  676 
  677 DROP TABLE IF EXISTS `clipboard_items`;
  678 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  679 /*!40101 SET character_set_client = utf8 */;
  680 CREATE TABLE `clipboard_items` (
  681   `id` int(11) NOT NULL AUTO_INCREMENT,
  682   `clipboard_id` int(11) NOT NULL,
  683   `range_id` varchar(98) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  684   `range_type` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'SimpleORMap',
  685   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
  686   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
  687   PRIMARY KEY (`id`)
  688 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  689 /*!40101 SET character_set_client = @saved_cs_client */;
  690 
  691 --
  692 -- Table structure for table `clipboards`
  693 --
  694 
  695 DROP TABLE IF EXISTS `clipboards`;
  696 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  697 /*!40101 SET character_set_client = utf8 */;
  698 CREATE TABLE `clipboards` (
  699   `id` int(11) NOT NULL AUTO_INCREMENT,
  700   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  701   `name` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  702   `handler` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'Clipboard',
  703   `allowed_item_class` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'StudipItem',
  704   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
  705   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
  706   PRIMARY KEY (`id`)
  707 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  708 /*!40101 SET character_set_client = @saved_cs_client */;
  709 
  710 --
  711 -- Table structure for table `colour_values`
  712 --
  713 
  714 DROP TABLE IF EXISTS `colour_values`;
  715 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  716 /*!40101 SET character_set_client = utf8 */;
  717 CREATE TABLE `colour_values` (
  718   `colour_id` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  719   `description` varchar(256) NOT NULL DEFAULT '',
  720   `value` varchar(8) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'ffffffff',
  721   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
  722   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
  723   PRIMARY KEY (`colour_id`)
  724 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  725 /*!40101 SET character_set_client = @saved_cs_client */;
  726 
  727 --
  728 -- Table structure for table `comments`
  729 --
  730 
  731 DROP TABLE IF EXISTS `comments`;
  732 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  733 /*!40101 SET character_set_client = utf8 */;
  734 CREATE TABLE `comments` (
  735   `comment_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  736   `object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  737   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  738   `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  739   `mkdate` int(20) NOT NULL DEFAULT '0',
  740   `chdate` int(20) NOT NULL DEFAULT '0',
  741   PRIMARY KEY (`comment_id`),
  742   KEY `object_id` (`object_id`)
  743 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  744 /*!40101 SET character_set_client = @saved_cs_client */;
  745 
  746 --
  747 -- Table structure for table `conditionaladmissions`
  748 --
  749 
  750 DROP TABLE IF EXISTS `conditionaladmissions`;
  751 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  752 /*!40101 SET character_set_client = utf8 */;
  753 CREATE TABLE `conditionaladmissions` (
  754   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  755   `message` text COLLATE utf8mb4_unicode_ci,
  756   `start_time` int(11) NOT NULL DEFAULT '0',
  757   `end_time` int(11) NOT NULL DEFAULT '0',
  758   `mkdate` int(11) NOT NULL DEFAULT '0',
  759   `conditions_stopped` tinyint(1) NOT NULL DEFAULT '0',
  760   `chdate` int(11) NOT NULL DEFAULT '0',
  761   PRIMARY KEY (`rule_id`)
  762 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  763 /*!40101 SET character_set_client = @saved_cs_client */;
  764 
  765 --
  766 -- Table structure for table `config`
  767 --
  768 
  769 DROP TABLE IF EXISTS `config`;
  770 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  771 /*!40101 SET character_set_client = utf8 */;
  772 CREATE TABLE `config` (
  773   `field` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  774   `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  775   `type` enum('boolean','integer','string','array') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'string',
  776   `range` enum('global','user','course') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'global',
  777   `section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  778   `mkdate` int(20) NOT NULL DEFAULT '0',
  779   `chdate` int(20) NOT NULL DEFAULT '0',
  780   `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  781   PRIMARY KEY (`field`)
  782 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  783 /*!40101 SET character_set_client = @saved_cs_client */;
  784 
  785 --
  786 -- Table structure for table `config_values`
  787 --
  788 
  789 DROP TABLE IF EXISTS `config_values`;
  790 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  791 /*!40101 SET character_set_client = utf8 */;
  792 CREATE TABLE `config_values` (
  793   `field` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  794   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  795   `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  796   `mkdate` int(11) NOT NULL DEFAULT '0',
  797   `chdate` int(11) NOT NULL DEFAULT '0',
  798   `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  799   PRIMARY KEY (`field`,`range_id`),
  800   KEY `field` (`field`,`value`(10)),
  801   KEY `range_id` (`range_id`)
  802 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  803 /*!40101 SET character_set_client = @saved_cs_client */;
  804 
  805 --
  806 -- Table structure for table `consultation_blocks`
  807 --
  808 
  809 DROP TABLE IF EXISTS `consultation_blocks`;
  810 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  811 /*!40101 SET character_set_client = utf8 */;
  812 CREATE TABLE `consultation_blocks` (
  813   `block_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  814   `teacher_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  815   `start` int(11) unsigned NOT NULL,
  816   `end` int(11) unsigned NOT NULL,
  817   `room` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  818   `calendar_events` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Create events for slots',
  819   `note` text COLLATE utf8mb4_unicode_ci NOT NULL,
  820   `size` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT 'How many people may book a slot',
  821   `course_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  822   `mkdate` int(11) unsigned NOT NULL,
  823   `chdate` int(11) unsigned NOT NULL,
  824   PRIMARY KEY (`block_id`),
  825   KEY `teacher_id` (`teacher_id`)
  826 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  827 /*!40101 SET character_set_client = @saved_cs_client */;
  828 
  829 --
  830 -- Table structure for table `consultation_bookings`
  831 --
  832 
  833 DROP TABLE IF EXISTS `consultation_bookings`;
  834 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  835 /*!40101 SET character_set_client = utf8 */;
  836 CREATE TABLE `consultation_bookings` (
  837   `booking_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  838   `slot_id` int(11) unsigned NOT NULL,
  839   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  840   `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  841   `student_event_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  842   `mkdate` int(11) unsigned NOT NULL,
  843   `chdate` int(11) unsigned NOT NULL,
  844   PRIMARY KEY (`booking_id`),
  845   KEY `block_id` (`slot_id`),
  846   KEY `user_id` (`user_id`)
  847 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  848 /*!40101 SET character_set_client = @saved_cs_client */;
  849 
  850 --
  851 -- Table structure for table `consultation_slots`
  852 --
  853 
  854 DROP TABLE IF EXISTS `consultation_slots`;
  855 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  856 /*!40101 SET character_set_client = utf8 */;
  857 CREATE TABLE `consultation_slots` (
  858   `slot_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  859   `block_id` int(11) unsigned NOT NULL,
  860   `start_time` int(11) unsigned NOT NULL,
  861   `end_time` int(11) unsigned NOT NULL,
  862   `note` text COLLATE utf8mb4_unicode_ci NOT NULL,
  863   `teacher_event_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  864   `mkdate` int(11) unsigned NOT NULL,
  865   `chdate` int(11) unsigned NOT NULL,
  866   PRIMARY KEY (`slot_id`),
  867   KEY `block_id` (`block_id`)
  868 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  869 /*!40101 SET character_set_client = @saved_cs_client */;
  870 
  871 --
  872 -- Table structure for table `contact`
  873 --
  874 
  875 DROP TABLE IF EXISTS `contact`;
  876 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  877 /*!40101 SET character_set_client = utf8 */;
  878 CREATE TABLE `contact` (
  879   `owner_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  880   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  881   PRIMARY KEY (`owner_id`,`user_id`),
  882   KEY `user_id` (`user_id`)
  883 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  884 /*!40101 SET character_set_client = @saved_cs_client */;
  885 
  886 --
  887 -- Table structure for table `content_terms_of_use_entries`
  888 --
  889 
  890 DROP TABLE IF EXISTS `content_terms_of_use_entries`;
  891 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  892 /*!40101 SET character_set_client = utf8 */;
  893 CREATE TABLE `content_terms_of_use_entries` (
  894   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  895   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  896   `position` int(10) unsigned NOT NULL,
  897   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  898   `student_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  899   `download_condition` tinyint(2) NOT NULL,
  900   `icon` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  901   `is_default` tinyint(2) unsigned NOT NULL DEFAULT '0',
  902   `mkdate` int(10) unsigned NOT NULL,
  903   `chdate` int(10) unsigned NOT NULL,
  904   PRIMARY KEY (`id`)
  905 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  906 /*!40101 SET character_set_client = @saved_cs_client */;
  907 
  908 --
  909 -- Table structure for table `coursememberadmissions`
  910 --
  911 
  912 DROP TABLE IF EXISTS `coursememberadmissions`;
  913 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  914 /*!40101 SET character_set_client = utf8 */;
  915 CREATE TABLE `coursememberadmissions` (
  916   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  917   `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  918   `start_time` int(11) NOT NULL DEFAULT '0',
  919   `end_time` int(11) NOT NULL DEFAULT '0',
  920   `course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  921   `modus` tinyint(1) NOT NULL DEFAULT '0',
  922   `mkdate` int(11) NOT NULL DEFAULT '0',
  923   `chdate` int(11) NOT NULL DEFAULT '0',
  924   PRIMARY KEY (`rule_id`)
  925 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  926 /*!40101 SET character_set_client = @saved_cs_client */;
  927 
  928 --
  929 -- Table structure for table `courseset_factorlist`
  930 --
  931 
  932 DROP TABLE IF EXISTS `courseset_factorlist`;
  933 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  934 /*!40101 SET character_set_client = utf8 */;
  935 CREATE TABLE `courseset_factorlist` (
  936   `set_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  937   `factorlist_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  938   `mkdate` int(11) NOT NULL DEFAULT '0',
  939   PRIMARY KEY (`set_id`,`factorlist_id`)
  940 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  941 /*!40101 SET character_set_client = @saved_cs_client */;
  942 
  943 --
  944 -- Table structure for table `courseset_institute`
  945 --
  946 
  947 DROP TABLE IF EXISTS `courseset_institute`;
  948 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  949 /*!40101 SET character_set_client = utf8 */;
  950 CREATE TABLE `courseset_institute` (
  951   `set_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  952   `institute_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  953   `mkdate` int(11) DEFAULT NULL,
  954   `chdate` int(11) DEFAULT NULL,
  955   PRIMARY KEY (`set_id`,`institute_id`),
  956   KEY `institute_id` (`institute_id`,`set_id`)
  957 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  958 /*!40101 SET character_set_client = @saved_cs_client */;
  959 
  960 --
  961 -- Table structure for table `courseset_rule`
  962 --
  963 
  964 DROP TABLE IF EXISTS `courseset_rule`;
  965 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  966 /*!40101 SET character_set_client = utf8 */;
  967 CREATE TABLE `courseset_rule` (
  968   `set_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  969   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  970   `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  971   `mkdate` int(11) DEFAULT NULL,
  972   PRIMARY KEY (`set_id`,`rule_id`),
  973   KEY `type` (`set_id`,`type`)
  974 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  975 /*!40101 SET character_set_client = @saved_cs_client */;
  976 
  977 --
  978 -- Table structure for table `coursesets`
  979 --
  980 
  981 DROP TABLE IF EXISTS `coursesets`;
  982 /*!40101 SET @saved_cs_client     = @@character_set_client */;
  983 /*!40101 SET character_set_client = utf8 */;
  984 CREATE TABLE `coursesets` (
  985   `set_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  986   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  987   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  988   `infotext` text COLLATE utf8mb4_unicode_ci NOT NULL,
  989   `algorithm` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  990   `algorithm_run` tinyint(1) NOT NULL DEFAULT '0',
  991   `private` tinyint(1) NOT NULL DEFAULT '0',
  992   `mkdate` int(11) NOT NULL DEFAULT '0',
  993   `chdate` int(11) NOT NULL DEFAULT '0',
  994   PRIMARY KEY (`set_id`),
  995   KEY `set_user` (`user_id`,`set_id`)
  996 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  997 /*!40101 SET character_set_client = @saved_cs_client */;
  998 
  999 --
 1000 -- Table structure for table `coursewizardsteps`
 1001 --
 1002 
 1003 DROP TABLE IF EXISTS `coursewizardsteps`;
 1004 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1005 /*!40101 SET character_set_client = utf8 */;
 1006 CREATE TABLE `coursewizardsteps` (
 1007   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1008   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1009   `classname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1010   `number` tinyint(1) NOT NULL,
 1011   `enabled` tinyint(1) NOT NULL DEFAULT '1',
 1012   `mkdate` int(11) NOT NULL DEFAULT '0',
 1013   `chdate` int(11) NOT NULL DEFAULT '0',
 1014   PRIMARY KEY (`id`),
 1015   UNIQUE KEY `classname` (`classname`)
 1016 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1017 /*!40101 SET character_set_client = @saved_cs_client */;
 1018 
 1019 --
 1020 -- Table structure for table `cronjobs_logs`
 1021 --
 1022 
 1023 DROP TABLE IF EXISTS `cronjobs_logs`;
 1024 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1025 /*!40101 SET character_set_client = utf8 */;
 1026 CREATE TABLE `cronjobs_logs` (
 1027   `log_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1028   `schedule_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1029   `scheduled` int(11) unsigned NOT NULL,
 1030   `executed` int(11) unsigned NOT NULL,
 1031   `exception` text COLLATE utf8mb4_unicode_ci,
 1032   `output` text COLLATE utf8mb4_unicode_ci,
 1033   `duration` float NOT NULL,
 1034   PRIMARY KEY (`log_id`),
 1035   KEY `schedule_id` (`schedule_id`)
 1036 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1037 /*!40101 SET character_set_client = @saved_cs_client */;
 1038 
 1039 --
 1040 -- Table structure for table `cronjobs_schedules`
 1041 --
 1042 
 1043 DROP TABLE IF EXISTS `cronjobs_schedules`;
 1044 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1045 /*!40101 SET character_set_client = utf8 */;
 1046 CREATE TABLE `cronjobs_schedules` (
 1047   `schedule_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1048   `task_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1049   `active` tinyint(1) NOT NULL DEFAULT '0',
 1050   `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1051   `description` varchar(4096) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1052   `parameters` text COLLATE utf8mb4_unicode_ci,
 1053   `priority` enum('low','normal','high') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'normal',
 1054   `type` enum('periodic','once') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'periodic',
 1055   `minute` tinyint(2) DEFAULT NULL,
 1056   `hour` tinyint(2) DEFAULT NULL,
 1057   `day` tinyint(2) DEFAULT NULL,
 1058   `month` tinyint(2) DEFAULT NULL,
 1059   `day_of_week` tinyint(1) unsigned DEFAULT NULL,
 1060   `next_execution` int(11) unsigned NOT NULL DEFAULT '0',
 1061   `last_execution` int(11) unsigned DEFAULT NULL,
 1062   `last_result` text COLLATE utf8mb4_unicode_ci,
 1063   `execution_count` bigint(20) unsigned NOT NULL DEFAULT '0',
 1064   `mkdate` int(11) unsigned NOT NULL,
 1065   `chdate` int(11) unsigned NOT NULL,
 1066   PRIMARY KEY (`schedule_id`),
 1067   KEY `task_id` (`task_id`)
 1068 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1069 /*!40101 SET character_set_client = @saved_cs_client */;
 1070 
 1071 --
 1072 -- Table structure for table `cronjobs_tasks`
 1073 --
 1074 
 1075 DROP TABLE IF EXISTS `cronjobs_tasks`;
 1076 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1077 /*!40101 SET character_set_client = utf8 */;
 1078 CREATE TABLE `cronjobs_tasks` (
 1079   `task_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1080   `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1081   `class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1082   `active` tinyint(1) NOT NULL DEFAULT '0',
 1083   `execution_count` bigint(20) unsigned NOT NULL DEFAULT '0',
 1084   `assigned_count` int(11) unsigned NOT NULL DEFAULT '0',
 1085   PRIMARY KEY (`task_id`)
 1086 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1087 /*!40101 SET character_set_client = @saved_cs_client */;
 1088 
 1089 --
 1090 -- Table structure for table `datafields`
 1091 --
 1092 
 1093 DROP TABLE IF EXISTS `datafields`;
 1094 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1095 /*!40101 SET character_set_client = utf8 */;
 1096 CREATE TABLE `datafields` (
 1097   `datafield_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1098   `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1099   `object_type` enum('sem','inst','user','userinstrole','usersemdata','roleinstdata','moduldeskriptor','modulteildeskriptor','studycourse') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1100   `object_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1101   `edit_perms` enum('user','autor','tutor','dozent','admin','root') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1102   `view_perms` enum('all','user','autor','tutor','dozent','admin','root') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1103   `institut_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1104   `priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
 1105   `mkdate` int(20) unsigned DEFAULT NULL,
 1106   `chdate` int(20) unsigned DEFAULT NULL,
 1107   `type` enum('bool','textline','textlinei18n','textarea','textareai18n','textmarkup','textmarkupi18n','selectbox','date','time','email','phone','radio','combo','link','selectboxmultiple') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'textline',
 1108   `typeparam` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1109   `is_required` tinyint(4) NOT NULL DEFAULT '0',
 1110   `default_value` text COLLATE utf8mb4_unicode_ci,
 1111   `is_userfilter` tinyint(3) unsigned NOT NULL DEFAULT '0',
 1112   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1113   `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
 1114   PRIMARY KEY (`datafield_id`),
 1115   KEY `object_type` (`object_type`)
 1116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1117 /*!40101 SET character_set_client = @saved_cs_client */;
 1118 
 1119 --
 1120 -- Table structure for table `datafields_entries`
 1121 --
 1122 
 1123 DROP TABLE IF EXISTS `datafields_entries`;
 1124 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1125 /*!40101 SET character_set_client = utf8 */;
 1126 CREATE TABLE `datafields_entries` (
 1127   `datafield_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1128   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1129   `content` text COLLATE utf8mb4_unicode_ci,
 1130   `mkdate` int(20) unsigned DEFAULT NULL,
 1131   `chdate` int(20) unsigned DEFAULT NULL,
 1132   `sec_range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1133   `lang` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1134   PRIMARY KEY (`datafield_id`,`range_id`,`sec_range_id`,`lang`) USING BTREE,
 1135   KEY `range_id` (`range_id`,`datafield_id`),
 1136   KEY `datafield_id_2` (`datafield_id`,`sec_range_id`),
 1137   KEY `datafields_contents` (`datafield_id`,`content`(32))
 1138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1139 /*!40101 SET character_set_client = @saved_cs_client */;
 1140 
 1141 --
 1142 -- Table structure for table `deputies`
 1143 --
 1144 
 1145 DROP TABLE IF EXISTS `deputies`;
 1146 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1147 /*!40101 SET character_set_client = utf8 */;
 1148 CREATE TABLE `deputies` (
 1149   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1150   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1151   `gruppe` tinyint(4) NOT NULL DEFAULT '0',
 1152   `notification` int(10) NOT NULL DEFAULT '0',
 1153   `edit_about` tinyint(1) NOT NULL DEFAULT '0',
 1154   PRIMARY KEY (`range_id`,`user_id`),
 1155   KEY `user_id` (`user_id`,`range_id`,`edit_about`)
 1156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1157 /*!40101 SET character_set_client = @saved_cs_client */;
 1158 
 1159 --
 1160 -- Table structure for table `etask_assignment_attempts`
 1161 --
 1162 
 1163 DROP TABLE IF EXISTS `etask_assignment_attempts`;
 1164 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1165 /*!40101 SET character_set_client = utf8 */;
 1166 CREATE TABLE `etask_assignment_attempts` (
 1167   `id` int(11) NOT NULL AUTO_INCREMENT,
 1168   `assignment_id` int(11) NOT NULL,
 1169   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1170   `start` int(11) DEFAULT NULL,
 1171   `end` int(11) DEFAULT NULL,
 1172   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1173   PRIMARY KEY (`id`)
 1174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1175 /*!40101 SET character_set_client = @saved_cs_client */;
 1176 
 1177 --
 1178 -- Table structure for table `etask_assignment_ranges`
 1179 --
 1180 
 1181 DROP TABLE IF EXISTS `etask_assignment_ranges`;
 1182 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1183 /*!40101 SET character_set_client = utf8 */;
 1184 CREATE TABLE `etask_assignment_ranges` (
 1185   `id` int(11) NOT NULL AUTO_INCREMENT,
 1186   `assignment_id` int(11) NOT NULL,
 1187   `range_type` enum('course','global','group','institute','user') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1188   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1189   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1190   PRIMARY KEY (`id`),
 1191   UNIQUE KEY `assignment_id` (`assignment_id`,`range_type`,`range_id`)
 1192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1193 /*!40101 SET character_set_client = @saved_cs_client */;
 1194 
 1195 --
 1196 -- Table structure for table `etask_assignments`
 1197 --
 1198 
 1199 DROP TABLE IF EXISTS `etask_assignments`;
 1200 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1201 /*!40101 SET character_set_client = utf8 */;
 1202 CREATE TABLE `etask_assignments` (
 1203   `id` int(11) NOT NULL AUTO_INCREMENT,
 1204   `test_id` int(11) NOT NULL,
 1205   `range_type` enum('course','global','group','institute','user') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1206   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1207   `type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 1208   `start` int(11) DEFAULT NULL,
 1209   `end` int(11) DEFAULT NULL,
 1210   `active` tinyint(1) NOT NULL,
 1211   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1212   PRIMARY KEY (`id`)
 1213 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1214 /*!40101 SET character_set_client = @saved_cs_client */;
 1215 
 1216 --
 1217 -- Table structure for table `etask_responses`
 1218 --
 1219 
 1220 DROP TABLE IF EXISTS `etask_responses`;
 1221 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1222 /*!40101 SET character_set_client = utf8 */;
 1223 CREATE TABLE `etask_responses` (
 1224   `id` int(11) NOT NULL AUTO_INCREMENT,
 1225   `assignment_id` int(11) NOT NULL,
 1226   `task_id` int(11) NOT NULL,
 1227   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1228   `response` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1229   `state` tinyint(1) DEFAULT NULL,
 1230   `points` float DEFAULT NULL,
 1231   `feedback` text COLLATE utf8mb4_unicode_ci,
 1232   `grader_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1233   `mkdate` int(11) NOT NULL,
 1234   `chdate` int(11) NOT NULL,
 1235   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1236   PRIMARY KEY (`id`)
 1237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1238 /*!40101 SET character_set_client = @saved_cs_client */;
 1239 
 1240 --
 1241 -- Table structure for table `etask_task_tags`
 1242 --
 1243 
 1244 DROP TABLE IF EXISTS `etask_task_tags`;
 1245 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1246 /*!40101 SET character_set_client = utf8 */;
 1247 CREATE TABLE `etask_task_tags` (
 1248   `task_id` int(11) NOT NULL,
 1249   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1250   `tag` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 1251   PRIMARY KEY (`task_id`,`user_id`,`tag`)
 1252 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1253 /*!40101 SET character_set_client = @saved_cs_client */;
 1254 
 1255 --
 1256 -- Table structure for table `etask_tasks`
 1257 --
 1258 
 1259 DROP TABLE IF EXISTS `etask_tasks`;
 1260 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1261 /*!40101 SET character_set_client = utf8 */;
 1262 CREATE TABLE `etask_tasks` (
 1263   `id` int(11) NOT NULL AUTO_INCREMENT,
 1264   `type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 1265   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1266   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1267   `task` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1268   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1269   `mkdate` int(11) NOT NULL,
 1270   `chdate` int(11) NOT NULL,
 1271   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1272   PRIMARY KEY (`id`)
 1273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1274 /*!40101 SET character_set_client = @saved_cs_client */;
 1275 
 1276 --
 1277 -- Table structure for table `etask_test_tags`
 1278 --
 1279 
 1280 DROP TABLE IF EXISTS `etask_test_tags`;
 1281 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1282 /*!40101 SET character_set_client = utf8 */;
 1283 CREATE TABLE `etask_test_tags` (
 1284   `test_id` int(11) NOT NULL,
 1285   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1286   `tag` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 1287   PRIMARY KEY (`test_id`,`user_id`,`tag`)
 1288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1289 /*!40101 SET character_set_client = @saved_cs_client */;
 1290 
 1291 --
 1292 -- Table structure for table `etask_test_tasks`
 1293 --
 1294 
 1295 DROP TABLE IF EXISTS `etask_test_tasks`;
 1296 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1297 /*!40101 SET character_set_client = utf8 */;
 1298 CREATE TABLE `etask_test_tasks` (
 1299   `test_id` int(11) NOT NULL,
 1300   `task_id` int(11) NOT NULL,
 1301   `position` int(11) NOT NULL,
 1302   `points` float DEFAULT NULL,
 1303   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1304   PRIMARY KEY (`test_id`,`task_id`)
 1305 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1306 /*!40101 SET character_set_client = @saved_cs_client */;
 1307 
 1308 --
 1309 -- Table structure for table `etask_tests`
 1310 --
 1311 
 1312 DROP TABLE IF EXISTS `etask_tests`;
 1313 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1314 /*!40101 SET character_set_client = utf8 */;
 1315 CREATE TABLE `etask_tests` (
 1316   `id` int(11) NOT NULL AUTO_INCREMENT,
 1317   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1318   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1319   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1320   `mkdate` int(11) NOT NULL,
 1321   `chdate` int(11) NOT NULL,
 1322   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1323   PRIMARY KEY (`id`)
 1324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1325 /*!40101 SET character_set_client = @saved_cs_client */;
 1326 
 1327 --
 1328 -- Table structure for table `eval`
 1329 --
 1330 
 1331 DROP TABLE IF EXISTS `eval`;
 1332 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1333 /*!40101 SET character_set_client = utf8 */;
 1334 CREATE TABLE `eval` (
 1335   `eval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1336   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1337   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1338   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1339   `startdate` int(20) DEFAULT NULL,
 1340   `stopdate` int(20) DEFAULT NULL,
 1341   `timespan` int(20) DEFAULT NULL,
 1342   `mkdate` int(20) NOT NULL DEFAULT '0',
 1343   `chdate` int(20) NOT NULL DEFAULT '0',
 1344   `anonymous` tinyint(1) NOT NULL DEFAULT '1',
 1345   `visible` tinyint(1) NOT NULL DEFAULT '1',
 1346   `shared` tinyint(1) NOT NULL DEFAULT '0',
 1347   PRIMARY KEY (`eval_id`)
 1348 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1349 /*!40101 SET character_set_client = @saved_cs_client */;
 1350 
 1351 --
 1352 -- Table structure for table `eval_group_template`
 1353 --
 1354 
 1355 DROP TABLE IF EXISTS `eval_group_template`;
 1356 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1357 /*!40101 SET character_set_client = utf8 */;
 1358 CREATE TABLE `eval_group_template` (
 1359   `evalgroup_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1360   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1361   `group_type` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
 1362   PRIMARY KEY (`evalgroup_id`,`user_id`)
 1363 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1364 /*!40101 SET character_set_client = @saved_cs_client */;
 1365 
 1366 --
 1367 -- Table structure for table `eval_range`
 1368 --
 1369 
 1370 DROP TABLE IF EXISTS `eval_range`;
 1371 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1372 /*!40101 SET character_set_client = utf8 */;
 1373 CREATE TABLE `eval_range` (
 1374   `eval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1375   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1376   PRIMARY KEY (`eval_id`,`range_id`)
 1377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1378 /*!40101 SET character_set_client = @saved_cs_client */;
 1379 
 1380 --
 1381 -- Table structure for table `eval_templates`
 1382 --
 1383 
 1384 DROP TABLE IF EXISTS `eval_templates`;
 1385 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1386 /*!40101 SET character_set_client = utf8 */;
 1387 CREATE TABLE `eval_templates` (
 1388   `template_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1389   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1390   `institution_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1391   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1392   `show_questions` tinyint(1) NOT NULL DEFAULT '1',
 1393   `show_total_stats` tinyint(1) NOT NULL DEFAULT '1',
 1394   `show_graphics` tinyint(1) NOT NULL DEFAULT '1',
 1395   `show_questionblock_headline` tinyint(1) NOT NULL DEFAULT '1',
 1396   `show_group_headline` tinyint(1) NOT NULL DEFAULT '1',
 1397   `polscale_gfx_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bars',
 1398   `likertscale_gfx_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bars',
 1399   `mchoice_scale_gfx_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bars',
 1400   `kurzbeschreibung` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1401   PRIMARY KEY (`template_id`),
 1402   KEY `user_id` (`user_id`,`institution_id`,`name`)
 1403 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1404 /*!40101 SET character_set_client = @saved_cs_client */;
 1405 
 1406 --
 1407 -- Table structure for table `eval_templates_eval`
 1408 --
 1409 
 1410 DROP TABLE IF EXISTS `eval_templates_eval`;
 1411 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1412 /*!40101 SET character_set_client = utf8 */;
 1413 CREATE TABLE `eval_templates_eval` (
 1414   `eval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1415   `template_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1416   PRIMARY KEY (`eval_id`),
 1417   KEY `eval_id` (`eval_id`)
 1418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1419 /*!40101 SET character_set_client = @saved_cs_client */;
 1420 
 1421 --
 1422 -- Table structure for table `eval_templates_user`
 1423 --
 1424 
 1425 DROP TABLE IF EXISTS `eval_templates_user`;
 1426 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1427 /*!40101 SET character_set_client = utf8 */;
 1428 CREATE TABLE `eval_templates_user` (
 1429   `eval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1430   `template_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1431   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1432   KEY `eval_id` (`eval_id`)
 1433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1434 /*!40101 SET character_set_client = @saved_cs_client */;
 1435 
 1436 --
 1437 -- Table structure for table `eval_user`
 1438 --
 1439 
 1440 DROP TABLE IF EXISTS `eval_user`;
 1441 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1442 /*!40101 SET character_set_client = utf8 */;
 1443 CREATE TABLE `eval_user` (
 1444   `eval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1445   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1446   PRIMARY KEY (`eval_id`,`user_id`)
 1447 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1448 /*!40101 SET character_set_client = @saved_cs_client */;
 1449 
 1450 --
 1451 -- Table structure for table `evalanswer`
 1452 --
 1453 
 1454 DROP TABLE IF EXISTS `evalanswer`;
 1455 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1456 /*!40101 SET character_set_client = utf8 */;
 1457 CREATE TABLE `evalanswer` (
 1458   `evalanswer_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1459   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1460   `position` int(11) NOT NULL DEFAULT '0',
 1461   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1462   `value` int(11) NOT NULL DEFAULT '0',
 1463   `rows` tinyint(4) NOT NULL DEFAULT '0',
 1464   `counter` int(11) NOT NULL DEFAULT '0',
 1465   `residual` tinyint(1) NOT NULL DEFAULT '0',
 1466   PRIMARY KEY (`evalanswer_id`),
 1467   KEY `parent_id` (`parent_id`)
 1468 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1469 /*!40101 SET character_set_client = @saved_cs_client */;
 1470 
 1471 --
 1472 -- Table structure for table `evalanswer_user`
 1473 --
 1474 
 1475 DROP TABLE IF EXISTS `evalanswer_user`;
 1476 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1477 /*!40101 SET character_set_client = utf8 */;
 1478 CREATE TABLE `evalanswer_user` (
 1479   `evalanswer_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1480   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1481   `evaldate` int(11) NOT NULL DEFAULT '0',
 1482   PRIMARY KEY (`evalanswer_id`,`user_id`)
 1483 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1484 /*!40101 SET character_set_client = @saved_cs_client */;
 1485 
 1486 --
 1487 -- Table structure for table `evalgroup`
 1488 --
 1489 
 1490 DROP TABLE IF EXISTS `evalgroup`;
 1491 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1492 /*!40101 SET character_set_client = utf8 */;
 1493 CREATE TABLE `evalgroup` (
 1494   `evalgroup_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1495   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1496   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1497   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1498   `position` int(11) NOT NULL DEFAULT '0',
 1499   `child_type` enum('EvaluationGroup','EvaluationQuestion') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'EvaluationGroup',
 1500   `mandatory` tinyint(1) NOT NULL DEFAULT '0',
 1501   `template_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1502   PRIMARY KEY (`evalgroup_id`),
 1503   KEY `parent_id` (`parent_id`)
 1504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1505 /*!40101 SET character_set_client = @saved_cs_client */;
 1506 
 1507 --
 1508 -- Table structure for table `evalquestion`
 1509 --
 1510 
 1511 DROP TABLE IF EXISTS `evalquestion`;
 1512 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1513 /*!40101 SET character_set_client = utf8 */;
 1514 CREATE TABLE `evalquestion` (
 1515   `evalquestion_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1516   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1517   `type` enum('likertskala','multiplechoice','polskala') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'multiplechoice',
 1518   `position` int(11) NOT NULL DEFAULT '0',
 1519   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1520   `multiplechoice` tinyint(1) NOT NULL DEFAULT '0',
 1521   PRIMARY KEY (`evalquestion_id`),
 1522   KEY `parent_id` (`parent_id`)
 1523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1524 /*!40101 SET character_set_client = @saved_cs_client */;
 1525 
 1526 --
 1527 -- Table structure for table `event_data`
 1528 --
 1529 
 1530 DROP TABLE IF EXISTS `event_data`;
 1531 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1532 /*!40101 SET character_set_client = utf8 */;
 1533 CREATE TABLE `event_data` (
 1534   `event_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1535   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1536   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1537   `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1538   `start` int(10) unsigned NOT NULL DEFAULT '0',
 1539   `end` int(10) unsigned NOT NULL DEFAULT '0',
 1540   `summary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1541   `description` text COLLATE utf8mb4_unicode_ci,
 1542   `class` enum('PUBLIC','PRIVATE','CONFIDENTIAL') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'PRIVATE',
 1543   `categories` tinytext COLLATE utf8mb4_unicode_ci,
 1544   `category_intern` tinyint(3) unsigned NOT NULL DEFAULT '0',
 1545   `priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
 1546   `location` tinytext COLLATE utf8mb4_unicode_ci,
 1547   `ts` int(10) unsigned NOT NULL DEFAULT '0',
 1548   `linterval` smallint(5) unsigned DEFAULT NULL,
 1549   `sinterval` smallint(5) unsigned DEFAULT NULL,
 1550   `wdays` varchar(7) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1551   `month` tinyint(3) unsigned DEFAULT NULL,
 1552   `day` tinyint(3) unsigned DEFAULT NULL,
 1553   `rtype` enum('SINGLE','DAILY','WEEKLY','MONTHLY','YEARLY') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'SINGLE',
 1554   `duration` smallint(5) unsigned NOT NULL DEFAULT '0',
 1555   `count` smallint(5) DEFAULT '0',
 1556   `expire` int(10) unsigned NOT NULL DEFAULT '0',
 1557   `exceptions` text COLLATE utf8mb4_unicode_ci,
 1558   `mkdate` int(10) unsigned NOT NULL DEFAULT '0',
 1559   `chdate` int(10) unsigned NOT NULL DEFAULT '0',
 1560   `importdate` int(11) NOT NULL DEFAULT '0',
 1561   PRIMARY KEY (`event_id`),
 1562   UNIQUE KEY `uid` (`uid`),
 1563   KEY `autor_id` (`author_id`)
 1564 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1565 /*!40101 SET character_set_client = @saved_cs_client */;
 1566 
 1567 --
 1568 -- Table structure for table `ex_termine`
 1569 --
 1570 
 1571 DROP TABLE IF EXISTS `ex_termine`;
 1572 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1573 /*!40101 SET character_set_client = utf8 */;
 1574 CREATE TABLE `ex_termine` (
 1575   `termin_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1576   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1577   `autor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1578   `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1579   `description` text COLLATE utf8mb4_unicode_ci,
 1580   `date` int(20) NOT NULL DEFAULT '0',
 1581   `end_time` int(20) NOT NULL DEFAULT '0',
 1582   `mkdate` int(20) NOT NULL DEFAULT '0',
 1583   `chdate` int(20) NOT NULL DEFAULT '0',
 1584   `date_typ` tinyint(4) NOT NULL DEFAULT '0',
 1585   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1586   `raum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1587   `metadate_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 1588   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1589   PRIMARY KEY (`termin_id`),
 1590   KEY `range_id` (`range_id`,`date`),
 1591   KEY `metadate_id` (`metadate_id`,`date`),
 1592   KEY `date` (`date`)
 1593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1594 /*!40101 SET character_set_client = @saved_cs_client */;
 1595 
 1596 --
 1597 -- Table structure for table `extern_config`
 1598 --
 1599 
 1600 DROP TABLE IF EXISTS `extern_config`;
 1601 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1602 /*!40101 SET character_set_client = utf8 */;
 1603 CREATE TABLE `extern_config` (
 1604   `config_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1605   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1606   `config_type` int(4) NOT NULL DEFAULT '0',
 1607   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1608   `is_standard` int(4) NOT NULL DEFAULT '0',
 1609   `config` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
 1610   `mkdate` int(20) NOT NULL DEFAULT '0',
 1611   `chdate` int(20) NOT NULL DEFAULT '0',
 1612   PRIMARY KEY (`config_id`,`range_id`)
 1613 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1614 /*!40101 SET character_set_client = @saved_cs_client */;
 1615 
 1616 --
 1617 -- Table structure for table `fach`
 1618 --
 1619 
 1620 DROP TABLE IF EXISTS `fach`;
 1621 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1622 /*!40101 SET character_set_client = utf8 */;
 1623 CREATE TABLE `fach` (
 1624   `fach_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1625   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1626   `name_kurz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1627   `beschreibung` text COLLATE utf8mb4_unicode_ci,
 1628   `schlagworte` text COLLATE utf8mb4_unicode_ci,
 1629   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1630   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1631   `mkdate` int(20) NOT NULL DEFAULT '0',
 1632   `chdate` int(20) NOT NULL DEFAULT '0',
 1633   PRIMARY KEY (`fach_id`)
 1634 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1635 /*!40101 SET character_set_client = @saved_cs_client */;
 1636 
 1637 --
 1638 -- Table structure for table `feedback`
 1639 --
 1640 
 1641 DROP TABLE IF EXISTS `feedback`;
 1642 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1643 /*!40101 SET character_set_client = utf8 */;
 1644 CREATE TABLE `feedback` (
 1645   `id` int(11) NOT NULL AUTO_INCREMENT,
 1646   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1647   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1648   `range_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1649   `course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1650   `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1651   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1652   `mode` int(11) unsigned NOT NULL,
 1653   `results_visible` tinyint(4) unsigned NOT NULL,
 1654   `commentable` tinyint(4) unsigned NOT NULL,
 1655   `mkdate` int(11) unsigned NOT NULL,
 1656   `chdate` int(11) unsigned NOT NULL,
 1657   PRIMARY KEY (`id`),
 1658   KEY `user_id` (`user_id`),
 1659   KEY `idx_range` (`range_id`,`range_type`),
 1660   KEY `course_id` (`course_id`)
 1661 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1662 /*!40101 SET character_set_client = @saved_cs_client */;
 1663 
 1664 --
 1665 -- Table structure for table `feedback_entries`
 1666 --
 1667 
 1668 DROP TABLE IF EXISTS `feedback_entries`;
 1669 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1670 /*!40101 SET character_set_client = utf8 */;
 1671 CREATE TABLE `feedback_entries` (
 1672   `id` int(11) NOT NULL AUTO_INCREMENT,
 1673   `feedback_id` int(11) unsigned NOT NULL,
 1674   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1675   `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1676   `rating` tinyint(3) unsigned NOT NULL,
 1677   `mkdate` int(10) unsigned NOT NULL,
 1678   `chdate` int(10) unsigned NOT NULL,
 1679   PRIMARY KEY (`id`),
 1680   KEY `feedback_id` (`feedback_id`),
 1681   KEY `user_id` (`user_id`)
 1682 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1683 /*!40101 SET character_set_client = @saved_cs_client */;
 1684 
 1685 --
 1686 -- Table structure for table `file_refs`
 1687 --
 1688 
 1689 DROP TABLE IF EXISTS `file_refs`;
 1690 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1691 /*!40101 SET character_set_client = utf8 */;
 1692 CREATE TABLE `file_refs` (
 1693   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1694   `file_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1695   `folder_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1696   `downloads` int(10) unsigned NOT NULL DEFAULT '0',
 1697   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1698   `content_terms_of_use_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1699   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1700   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1701   `mkdate` int(10) unsigned NOT NULL DEFAULT '0',
 1702   `chdate` int(10) unsigned NOT NULL DEFAULT '0',
 1703   PRIMARY KEY (`id`),
 1704   KEY `file_id` (`file_id`),
 1705   KEY `folder_id` (`folder_id`)
 1706 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1707 /*!40101 SET character_set_client = @saved_cs_client */;
 1708 
 1709 --
 1710 -- Table structure for table `files`
 1711 --
 1712 
 1713 DROP TABLE IF EXISTS `files`;
 1714 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1715 /*!40101 SET character_set_client = utf8 */;
 1716 CREATE TABLE `files` (
 1717   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1718   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1719   `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1720   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1721   `filetype` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT 'StandardFile',
 1722   `size` int(10) unsigned NOT NULL,
 1723   `metadata` text COLLATE utf8mb4_unicode_ci,
 1724   `author_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1725   `mkdate` int(10) unsigned NOT NULL,
 1726   `chdate` int(10) unsigned NOT NULL,
 1727   PRIMARY KEY (`id`)
 1728 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1729 /*!40101 SET character_set_client = @saved_cs_client */;
 1730 
 1731 --
 1732 -- Table structure for table `files_search_attributes`
 1733 --
 1734 
 1735 DROP TABLE IF EXISTS `files_search_attributes`;
 1736 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1737 /*!40101 SET character_set_client = utf8 */;
 1738 CREATE TABLE `files_search_attributes` (
 1739   `id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1740   `file_ref_user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1741   `file_ref_mkdate` int(10) unsigned NOT NULL,
 1742   `file_ref_chdate` int(10) unsigned NOT NULL,
 1743   `folder_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1744   `folder_range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1745   `folder_range_type` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1746   `folder_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1747   `course_status` tinyint(4) unsigned DEFAULT NULL,
 1748   `semester_start` int(20) unsigned DEFAULT NULL,
 1749   `semester_end` int(20) unsigned DEFAULT NULL,
 1750   PRIMARY KEY (`id`),
 1751   KEY `folder_range_id` (`folder_range_id`),
 1752   KEY `folder_range_type` (`folder_range_type`),
 1753   KEY `semester_start` (`semester_start`),
 1754   KEY `semester_end` (`semester_end`)
 1755 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1756 /*!40101 SET character_set_client = @saved_cs_client */;
 1757 
 1758 --
 1759 -- Table structure for table `files_search_index`
 1760 --
 1761 
 1762 DROP TABLE IF EXISTS `files_search_index`;
 1763 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1764 /*!40101 SET character_set_client = utf8 */;
 1765 CREATE TABLE `files_search_index` (
 1766   `FTS_DOC_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 1767   `file_ref_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1768   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1769   `relevance` float NOT NULL,
 1770   PRIMARY KEY (`FTS_DOC_ID`),
 1771   KEY `file_ref_id` (`file_ref_id`),
 1772   FULLTEXT KEY `text` (`text`)
 1773 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1774 /*!40101 SET character_set_client = @saved_cs_client */;
 1775 
 1776 --
 1777 -- Table structure for table `folders`
 1778 --
 1779 
 1780 DROP TABLE IF EXISTS `folders`;
 1781 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1782 /*!40101 SET character_set_client = utf8 */;
 1783 CREATE TABLE `folders` (
 1784   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1785   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1786   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1787   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1788   `range_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1789   `folder_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1790   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1791   `data_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1792   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1793   `mkdate` int(10) unsigned NOT NULL,
 1794   `chdate` int(10) unsigned NOT NULL,
 1795   PRIMARY KEY (`id`),
 1796   KEY `range_id` (`range_id`),
 1797   KEY `parent_id` (`parent_id`)
 1798 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1799 /*!40101 SET character_set_client = @saved_cs_client */;
 1800 
 1801 --
 1802 -- Table structure for table `forum_abo_users`
 1803 --
 1804 
 1805 DROP TABLE IF EXISTS `forum_abo_users`;
 1806 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1807 /*!40101 SET character_set_client = utf8 */;
 1808 CREATE TABLE `forum_abo_users` (
 1809   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1810   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1811   PRIMARY KEY (`topic_id`,`user_id`)
 1812 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1813 /*!40101 SET character_set_client = @saved_cs_client */;
 1814 
 1815 --
 1816 -- Table structure for table `forum_categories`
 1817 --
 1818 
 1819 DROP TABLE IF EXISTS `forum_categories`;
 1820 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1821 /*!40101 SET character_set_client = utf8 */;
 1822 CREATE TABLE `forum_categories` (
 1823   `category_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1824   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1825   `entry_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1826   `pos` int(11) NOT NULL DEFAULT '0',
 1827   PRIMARY KEY (`category_id`),
 1828   KEY `seminar_id` (`seminar_id`)
 1829 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1830 /*!40101 SET character_set_client = @saved_cs_client */;
 1831 
 1832 --
 1833 -- Table structure for table `forum_categories_entries`
 1834 --
 1835 
 1836 DROP TABLE IF EXISTS `forum_categories_entries`;
 1837 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1838 /*!40101 SET character_set_client = utf8 */;
 1839 CREATE TABLE `forum_categories_entries` (
 1840   `category_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1841   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1842   `pos` int(11) NOT NULL DEFAULT '0',
 1843   PRIMARY KEY (`category_id`,`topic_id`)
 1844 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1845 /*!40101 SET character_set_client = @saved_cs_client */;
 1846 
 1847 --
 1848 -- Table structure for table `forum_entries`
 1849 --
 1850 
 1851 DROP TABLE IF EXISTS `forum_entries`;
 1852 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1853 /*!40101 SET character_set_client = utf8 */;
 1854 CREATE TABLE `forum_entries` (
 1855   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1856   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1857   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1858   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1859   `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
 1860   `area` tinyint(4) NOT NULL DEFAULT '0',
 1861   `mkdate` int(20) NOT NULL,
 1862   `latest_chdate` int(11) DEFAULT NULL,
 1863   `chdate` int(20) NOT NULL,
 1864   `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1865   `author_host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1866   `lft` int(11) NOT NULL,
 1867   `rgt` int(11) NOT NULL,
 1868   `depth` int(11) NOT NULL,
 1869   `anonymous` tinyint(4) NOT NULL DEFAULT '0',
 1870   `closed` tinyint(1) NOT NULL DEFAULT '0',
 1871   `sticky` int(1) NOT NULL DEFAULT '0',
 1872   PRIMARY KEY (`topic_id`),
 1873   KEY `seminar_id` (`seminar_id`,`lft`),
 1874   KEY `seminar_id_2` (`seminar_id`,`rgt`),
 1875   KEY `user_id` (`user_id`)
 1876 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1877 /*!40101 SET character_set_client = @saved_cs_client */;
 1878 
 1879 --
 1880 -- Table structure for table `forum_entries_issues`
 1881 --
 1882 
 1883 DROP TABLE IF EXISTS `forum_entries_issues`;
 1884 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1885 /*!40101 SET character_set_client = utf8 */;
 1886 CREATE TABLE `forum_entries_issues` (
 1887   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1888   `issue_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1889   PRIMARY KEY (`topic_id`,`issue_id`)
 1890 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1891 /*!40101 SET character_set_client = @saved_cs_client */;
 1892 
 1893 --
 1894 -- Table structure for table `forum_favorites`
 1895 --
 1896 
 1897 DROP TABLE IF EXISTS `forum_favorites`;
 1898 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1899 /*!40101 SET character_set_client = utf8 */;
 1900 CREATE TABLE `forum_favorites` (
 1901   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1902   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1903   PRIMARY KEY (`user_id`,`topic_id`)
 1904 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1905 /*!40101 SET character_set_client = @saved_cs_client */;
 1906 
 1907 --
 1908 -- Table structure for table `forum_likes`
 1909 --
 1910 
 1911 DROP TABLE IF EXISTS `forum_likes`;
 1912 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1913 /*!40101 SET character_set_client = utf8 */;
 1914 CREATE TABLE `forum_likes` (
 1915   `topic_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1916   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1917   PRIMARY KEY (`topic_id`,`user_id`)
 1918 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1919 /*!40101 SET character_set_client = @saved_cs_client */;
 1920 
 1921 --
 1922 -- Table structure for table `forum_visits`
 1923 --
 1924 
 1925 DROP TABLE IF EXISTS `forum_visits`;
 1926 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1927 /*!40101 SET character_set_client = utf8 */;
 1928 CREATE TABLE `forum_visits` (
 1929   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1930   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1931   `visitdate` int(11) NOT NULL,
 1932   `last_visitdate` int(11) NOT NULL,
 1933   PRIMARY KEY (`user_id`,`seminar_id`)
 1934 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1935 /*!40101 SET character_set_client = @saved_cs_client */;
 1936 
 1937 --
 1938 -- Table structure for table `global_resource_locks`
 1939 --
 1940 
 1941 DROP TABLE IF EXISTS `global_resource_locks`;
 1942 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1943 /*!40101 SET character_set_client = utf8 */;
 1944 CREATE TABLE `global_resource_locks` (
 1945   `lock_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1946   `begin` int(11) unsigned NOT NULL DEFAULT '0',
 1947   `end` int(11) unsigned NOT NULL DEFAULT '0',
 1948   `type` varchar(15) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1949   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 1950   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 1951   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 1952   PRIMARY KEY (`lock_id`)
 1953 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1954 /*!40101 SET character_set_client = @saved_cs_client */;
 1955 
 1956 --
 1957 -- Table structure for table `globalsearch_buzzwords`
 1958 --
 1959 
 1960 DROP TABLE IF EXISTS `globalsearch_buzzwords`;
 1961 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1962 /*!40101 SET character_set_client = utf8 */;
 1963 CREATE TABLE `globalsearch_buzzwords` (
 1964   `id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
 1965   `rights` enum('user','autor','tutor','dozent','admin','root') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
 1966   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1967   `buzzwords` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1968   `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 1969   `url` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 1970   PRIMARY KEY (`id`)
 1971 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1972 /*!40101 SET character_set_client = @saved_cs_client */;
 1973 
 1974 --
 1975 -- Table structure for table `grading_definitions`
 1976 --
 1977 
 1978 DROP TABLE IF EXISTS `grading_definitions`;
 1979 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 1980 /*!40101 SET character_set_client = utf8 */;
 1981 CREATE TABLE `grading_definitions` (
 1982   `id` int(11) NOT NULL AUTO_INCREMENT,
 1983   `course_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1984   `item` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1985   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1986   `tool` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 1987   `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 1988   `position` int(11) NOT NULL DEFAULT '0',
 1989   `weight` float unsigned NOT NULL,
 1990   `mkdate` int(11) NOT NULL,
 1991   `chdate` int(11) NOT NULL,
 1992   PRIMARY KEY (`id`),
 1993   KEY `course_id` (`course_id`),
 1994   KEY `tool` (`tool`)
 1995 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 1996 /*!40101 SET character_set_client = @saved_cs_client */;
 1997 
 1998 --
 1999 -- Table structure for table `grading_instances`
 2000 --
 2001 
 2002 DROP TABLE IF EXISTS `grading_instances`;
 2003 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2004 /*!40101 SET character_set_client = utf8 */;
 2005 CREATE TABLE `grading_instances` (
 2006   `definition_id` int(11) NOT NULL AUTO_INCREMENT,
 2007   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2008   `rawgrade` decimal(6,5) unsigned NOT NULL,
 2009   `feedback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2010   `mkdate` int(11) NOT NULL,
 2011   `chdate` int(11) NOT NULL,
 2012   PRIMARY KEY (`definition_id`,`user_id`)
 2013 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2014 /*!40101 SET character_set_client = @saved_cs_client */;
 2015 
 2016 --
 2017 -- Table structure for table `help_content`
 2018 --
 2019 
 2020 DROP TABLE IF EXISTS `help_content`;
 2021 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2022 /*!40101 SET character_set_client = utf8 */;
 2023 CREATE TABLE `help_content` (
 2024   `global_content_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2025   `content_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2026   `language` char(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'de',
 2027   `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2028   `route` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2029   `studip_version` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2030   `position` tinyint(4) NOT NULL DEFAULT '1',
 2031   `custom` tinyint(4) NOT NULL DEFAULT '0',
 2032   `visible` tinyint(4) NOT NULL DEFAULT '1',
 2033   `author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2034   `installation_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2035   `mkdate` int(11) unsigned NOT NULL,
 2036   `chdate` int(11) NOT NULL,
 2037   PRIMARY KEY (`content_id`)
 2038 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2039 /*!40101 SET character_set_client = @saved_cs_client */;
 2040 
 2041 --
 2042 -- Table structure for table `help_tour_audiences`
 2043 --
 2044 
 2045 DROP TABLE IF EXISTS `help_tour_audiences`;
 2046 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2047 /*!40101 SET character_set_client = utf8 */;
 2048 CREATE TABLE `help_tour_audiences` (
 2049   `tour_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2050   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2051   `type` enum('inst','sem','studiengang','abschluss','userdomain','tour') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2052   PRIMARY KEY (`tour_id`,`range_id`,`type`)
 2053 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2054 /*!40101 SET character_set_client = @saved_cs_client */;
 2055 
 2056 --
 2057 -- Table structure for table `help_tour_settings`
 2058 --
 2059 
 2060 DROP TABLE IF EXISTS `help_tour_settings`;
 2061 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2062 /*!40101 SET character_set_client = utf8 */;
 2063 CREATE TABLE `help_tour_settings` (
 2064   `tour_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2065   `active` tinyint(4) NOT NULL,
 2066   `access` enum('standard','link','autostart','autostart_once') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2067   PRIMARY KEY (`tour_id`)
 2068 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2069 /*!40101 SET character_set_client = @saved_cs_client */;
 2070 
 2071 --
 2072 -- Table structure for table `help_tour_steps`
 2073 --
 2074 
 2075 DROP TABLE IF EXISTS `help_tour_steps`;
 2076 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2077 /*!40101 SET character_set_client = utf8 */;
 2078 CREATE TABLE `help_tour_steps` (
 2079   `tour_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2080   `step` tinyint(4) NOT NULL DEFAULT '1',
 2081   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2082   `tip` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2083   `orientation` enum('T','TL','TR','L','LT','LB','B','BL','BR','R','RT','RB') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'B',
 2084   `interactive` tinyint(4) NOT NULL,
 2085   `css_selector` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2086   `route` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2087   `action_prev` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2088   `action_next` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2089   `author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2090   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 2091   `chdate` int(11) NOT NULL,
 2092   PRIMARY KEY (`tour_id`,`step`)
 2093 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2094 /*!40101 SET character_set_client = @saved_cs_client */;
 2095 
 2096 --
 2097 -- Table structure for table `help_tour_user`
 2098 --
 2099 
 2100 DROP TABLE IF EXISTS `help_tour_user`;
 2101 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2102 /*!40101 SET character_set_client = utf8 */;
 2103 CREATE TABLE `help_tour_user` (
 2104   `tour_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2105   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2106   `step_nr` int(11) NOT NULL,
 2107   `completed` tinyint(4) NOT NULL DEFAULT '0',
 2108   PRIMARY KEY (`tour_id`,`user_id`)
 2109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2110 /*!40101 SET character_set_client = @saved_cs_client */;
 2111 
 2112 --
 2113 -- Table structure for table `help_tours`
 2114 --
 2115 
 2116 DROP TABLE IF EXISTS `help_tours`;
 2117 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2118 /*!40101 SET character_set_client = utf8 */;
 2119 CREATE TABLE `help_tours` (
 2120   `global_tour_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2121   `tour_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2122   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2123   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2124   `type` enum('tour','wizard') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2125   `roles` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2126   `version` int(11) unsigned NOT NULL DEFAULT '1',
 2127   `language` char(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'de',
 2128   `studip_version` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2129   `installation_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'demo-installation',
 2130   `author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2131   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 2132   `chdate` int(11) NOT NULL,
 2133   PRIMARY KEY (`tour_id`)
 2134 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2135 /*!40101 SET character_set_client = @saved_cs_client */;
 2136 
 2137 --
 2138 -- Table structure for table `i18n`
 2139 --
 2140 
 2141 DROP TABLE IF EXISTS `i18n`;
 2142 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2143 /*!40101 SET character_set_client = utf8 */;
 2144 CREATE TABLE `i18n` (
 2145   `object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2146   `table` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2147   `field` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2148   `lang` varchar(5) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2149   `value` text COLLATE utf8mb4_unicode_ci,
 2150   PRIMARY KEY (`object_id`,`table`,`field`,`lang`)
 2151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2152 /*!40101 SET character_set_client = @saved_cs_client */;
 2153 
 2154 --
 2155 -- Table structure for table `institute_plan_columns`
 2156 --
 2157 
 2158 DROP TABLE IF EXISTS `institute_plan_columns`;
 2159 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2160 /*!40101 SET character_set_client = utf8 */;
 2161 CREATE TABLE `institute_plan_columns` (
 2162   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2163   `column` int(4) NOT NULL,
 2164   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
 2165   `visible` tinyint(1) NOT NULL DEFAULT '1',
 2166   `mkdate` int(11) NOT NULL,
 2167   `chdate` int(11) NOT NULL,
 2168   PRIMARY KEY (`range_id`,`column`)
 2169 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2170 /*!40101 SET character_set_client = @saved_cs_client */;
 2171 
 2172 --
 2173 -- Table structure for table `kategorien`
 2174 --
 2175 
 2176 DROP TABLE IF EXISTS `kategorien`;
 2177 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2178 /*!40101 SET character_set_client = utf8 */;
 2179 CREATE TABLE `kategorien` (
 2180   `kategorie_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2181   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2182   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2183   `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2184   `mkdate` int(20) NOT NULL DEFAULT '0',
 2185   `chdate` int(20) NOT NULL DEFAULT '0',
 2186   `priority` int(11) NOT NULL DEFAULT '0',
 2187   PRIMARY KEY (`kategorie_id`),
 2188   KEY `priority` (`priority`),
 2189   KEY `range_id` (`range_id`)
 2190 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2191 /*!40101 SET character_set_client = @saved_cs_client */;
 2192 
 2193 --
 2194 -- Table structure for table `limitedadmissions`
 2195 --
 2196 
 2197 DROP TABLE IF EXISTS `limitedadmissions`;
 2198 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2199 /*!40101 SET character_set_client = utf8 */;
 2200 CREATE TABLE `limitedadmissions` (
 2201   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2202   `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2203   `start_time` int(11) NOT NULL DEFAULT '0',
 2204   `end_time` int(11) NOT NULL DEFAULT '0',
 2205   `maxnumber` int(11) NOT NULL DEFAULT '0',
 2206   `mkdate` int(11) NOT NULL DEFAULT '0',
 2207   `chdate` int(11) NOT NULL DEFAULT '0',
 2208   PRIMARY KEY (`rule_id`)
 2209 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2210 /*!40101 SET character_set_client = @saved_cs_client */;
 2211 
 2212 --
 2213 -- Table structure for table `lock_rules`
 2214 --
 2215 
 2216 DROP TABLE IF EXISTS `lock_rules`;
 2217 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2218 /*!40101 SET character_set_client = utf8 */;
 2219 CREATE TABLE `lock_rules` (
 2220   `lock_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2221   `permission` enum('autor','tutor','dozent','admin','root') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'dozent',
 2222   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2223   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2224   `attributes` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2225   `object_type` enum('sem','inst','user') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'sem',
 2226   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2227   PRIMARY KEY (`lock_id`)
 2228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2229 /*!40101 SET character_set_client = @saved_cs_client */;
 2230 
 2231 --
 2232 -- Table structure for table `lockedadmissions`
 2233 --
 2234 
 2235 DROP TABLE IF EXISTS `lockedadmissions`;
 2236 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2237 /*!40101 SET character_set_client = utf8 */;
 2238 CREATE TABLE `lockedadmissions` (
 2239   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2240   `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2241   `mkdate` int(11) NOT NULL DEFAULT '0',
 2242   `chdate` int(11) NOT NULL DEFAULT '0',
 2243   PRIMARY KEY (`rule_id`)
 2244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2245 /*!40101 SET character_set_client = @saved_cs_client */;
 2246 
 2247 --
 2248 -- Table structure for table `log_actions`
 2249 --
 2250 
 2251 DROP TABLE IF EXISTS `log_actions`;
 2252 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2253 /*!40101 SET character_set_client = utf8 */;
 2254 CREATE TABLE `log_actions` (
 2255   `action_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2256   `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2257   `description` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2258   `info_template` text COLLATE utf8mb4_unicode_ci,
 2259   `active` tinyint(1) NOT NULL DEFAULT '1',
 2260   `expires` int(20) NOT NULL DEFAULT '0',
 2261   `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2262   `class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2263   `type` enum('core','plugin','file') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2264   PRIMARY KEY (`action_id`)
 2265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2266 /*!40101 SET character_set_client = @saved_cs_client */;
 2267 
 2268 --
 2269 -- Table structure for table `log_events`
 2270 --
 2271 
 2272 DROP TABLE IF EXISTS `log_events`;
 2273 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2274 /*!40101 SET character_set_client = utf8 */;
 2275 CREATE TABLE `log_events` (
 2276   `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 2277   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2278   `action_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2279   `affected_range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2280   `coaffected_range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2281   `info` text COLLATE utf8mb4_unicode_ci,
 2282   `dbg_info` text COLLATE utf8mb4_unicode_ci,
 2283   `mkdate` int(11) unsigned NOT NULL,
 2284   PRIMARY KEY (`event_id`),
 2285   KEY `action_id` (`action_id`)
 2286 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2287 /*!40101 SET character_set_client = @saved_cs_client */;
 2288 
 2289 --
 2290 -- Table structure for table `loginbackgrounds`
 2291 --
 2292 
 2293 DROP TABLE IF EXISTS `loginbackgrounds`;
 2294 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2295 /*!40101 SET character_set_client = utf8 */;
 2296 CREATE TABLE `loginbackgrounds` (
 2297   `background_id` int(11) NOT NULL AUTO_INCREMENT,
 2298   `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2299   `mobile` tinyint(1) NOT NULL DEFAULT '1',
 2300   `desktop` tinyint(1) NOT NULL DEFAULT '1',
 2301   `in_release` tinyint(1) NOT NULL DEFAULT '0',
 2302   PRIMARY KEY (`background_id`)
 2303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2304 /*!40101 SET character_set_client = @saved_cs_client */;
 2305 
 2306 --
 2307 -- Table structure for table `lti_data`
 2308 --
 2309 
 2310 DROP TABLE IF EXISTS `lti_data`;
 2311 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2312 /*!40101 SET character_set_client = utf8 */;
 2313 CREATE TABLE `lti_data` (
 2314   `id` int(11) NOT NULL AUTO_INCREMENT,
 2315   `position` int(11) NOT NULL DEFAULT '0',
 2316   `course_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2317   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2318   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2319   `tool_id` int(11) NOT NULL DEFAULT '0',
 2320   `launch_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2321   `mkdate` int(11) NOT NULL DEFAULT '0',
 2322   `chdate` int(11) NOT NULL DEFAULT '0',
 2323   `options` text COLLATE utf8mb4_unicode_ci,
 2324   PRIMARY KEY (`id`),
 2325   KEY `course_id` (`course_id`)
 2326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2327 /*!40101 SET character_set_client = @saved_cs_client */;
 2328 
 2329 --
 2330 -- Table structure for table `lti_grade`
 2331 --
 2332 
 2333 DROP TABLE IF EXISTS `lti_grade`;
 2334 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2335 /*!40101 SET character_set_client = utf8 */;
 2336 CREATE TABLE `lti_grade` (
 2337   `link_id` int(11) NOT NULL DEFAULT '0',
 2338   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2339   `score` float NOT NULL DEFAULT '0',
 2340   `mkdate` int(11) NOT NULL DEFAULT '0',
 2341   `chdate` int(11) NOT NULL DEFAULT '0',
 2342   PRIMARY KEY (`link_id`,`user_id`)
 2343 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2344 /*!40101 SET character_set_client = @saved_cs_client */;
 2345 
 2346 --
 2347 -- Table structure for table `lti_tool`
 2348 --
 2349 
 2350 DROP TABLE IF EXISTS `lti_tool`;
 2351 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2352 /*!40101 SET character_set_client = utf8 */;
 2353 CREATE TABLE `lti_tool` (
 2354   `id` int(11) NOT NULL AUTO_INCREMENT,
 2355   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2356   `launch_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2357   `consumer_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2358   `consumer_secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2359   `custom_parameters` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2360   `allow_custom_url` tinyint(1) NOT NULL DEFAULT '0',
 2361   `deep_linking` tinyint(1) NOT NULL DEFAULT '0',
 2362   `send_lis_person` tinyint(1) NOT NULL DEFAULT '0',
 2363   `mkdate` int(11) NOT NULL DEFAULT '0',
 2364   `chdate` int(11) NOT NULL DEFAULT '0',
 2365   PRIMARY KEY (`id`)
 2366 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2367 /*!40101 SET character_set_client = @saved_cs_client */;
 2368 
 2369 --
 2370 -- Table structure for table `mail_queue_entries`
 2371 --
 2372 
 2373 DROP TABLE IF EXISTS `mail_queue_entries`;
 2374 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2375 /*!40101 SET character_set_client = utf8 */;
 2376 CREATE TABLE `mail_queue_entries` (
 2377   `mail_queue_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2378   `mail` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2379   `message_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2380   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2381   `tries` int(11) NOT NULL,
 2382   `last_try` int(11) NOT NULL DEFAULT '0',
 2383   `mkdate` bigint(20) NOT NULL,
 2384   `chdate` bigint(20) NOT NULL,
 2385   PRIMARY KEY (`mail_queue_id`),
 2386   KEY `message_id` (`message_id`),
 2387   KEY `user_id` (`user_id`)
 2388 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2389 /*!40101 SET character_set_client = @saved_cs_client */;
 2390 
 2391 --
 2392 -- Table structure for table `media_cache`
 2393 --
 2394 
 2395 DROP TABLE IF EXISTS `media_cache`;
 2396 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2397 /*!40101 SET character_set_client = utf8 */;
 2398 CREATE TABLE `media_cache` (
 2399   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2400   `type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 2401   `chdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 2402   `expires` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
 2403   PRIMARY KEY (`id`)
 2404 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2405 /*!40101 SET character_set_client = @saved_cs_client */;
 2406 
 2407 --
 2408 -- Table structure for table `message`
 2409 --
 2410 
 2411 DROP TABLE IF EXISTS `message`;
 2412 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2413 /*!40101 SET character_set_client = utf8 */;
 2414 CREATE TABLE `message` (
 2415   `message_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2416   `autor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2417   `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2418   `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
 2419   `show_adressees` tinyint(4) NOT NULL DEFAULT '0',
 2420   `mkdate` int(20) NOT NULL DEFAULT '0',
 2421   `priority` enum('normal','high') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'normal',
 2422   PRIMARY KEY (`message_id`),
 2423   KEY `autor_id` (`autor_id`)
 2424 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2425 /*!40101 SET character_set_client = @saved_cs_client */;
 2426 
 2427 --
 2428 -- Table structure for table `message_tags`
 2429 --
 2430 
 2431 DROP TABLE IF EXISTS `message_tags`;
 2432 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2433 /*!40101 SET character_set_client = utf8 */;
 2434 CREATE TABLE `message_tags` (
 2435   `message_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2436   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2437   `tag` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 2438   `chdate` bigint(20) NOT NULL,
 2439   `mkdate` bigint(20) NOT NULL,
 2440   PRIMARY KEY (`message_id`,`user_id`,`tag`)
 2441 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2442 /*!40101 SET character_set_client = @saved_cs_client */;
 2443 
 2444 --
 2445 -- Table structure for table `message_user`
 2446 --
 2447 
 2448 DROP TABLE IF EXISTS `message_user`;
 2449 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2450 /*!40101 SET character_set_client = utf8 */;
 2451 CREATE TABLE `message_user` (
 2452   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2453   `message_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 2454   `readed` tinyint(1) NOT NULL DEFAULT '0',
 2455   `deleted` tinyint(1) NOT NULL DEFAULT '0',
 2456   `snd_rec` enum('rec','snd') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'rec',
 2457   `answered` tinyint(1) NOT NULL DEFAULT '0',
 2458   `mkdate` int(10) unsigned NOT NULL DEFAULT '0',
 2459   PRIMARY KEY (`message_id`,`snd_rec`,`user_id`),
 2460   KEY `user_id` (`user_id`,`snd_rec`,`deleted`,`readed`,`mkdate`),
 2461   KEY `user_id_2` (`user_id`,`snd_rec`,`deleted`,`mkdate`)
 2462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2463 /*!40101 SET character_set_client = @saved_cs_client */;
 2464 
 2465 --
 2466 -- Table structure for table `mvv_abschl_kategorie`
 2467 --
 2468 
 2469 DROP TABLE IF EXISTS `mvv_abschl_kategorie`;
 2470 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2471 /*!40101 SET character_set_client = utf8 */;
 2472 CREATE TABLE `mvv_abschl_kategorie` (
 2473   `kategorie_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2474   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2475   `name_kurz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2476   `beschreibung` text COLLATE utf8mb4_unicode_ci,
 2477   `position` int(11) DEFAULT NULL,
 2478   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2479   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2480   `mkdate` bigint(20) NOT NULL,
 2481   `chdate` bigint(20) NOT NULL,
 2482   PRIMARY KEY (`kategorie_id`),
 2483   UNIQUE KEY `name` (`name`)
 2484 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2485 /*!40101 SET character_set_client = @saved_cs_client */;
 2486 
 2487 --
 2488 -- Table structure for table `mvv_abschl_zuord`
 2489 --
 2490 
 2491 DROP TABLE IF EXISTS `mvv_abschl_zuord`;
 2492 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2493 /*!40101 SET character_set_client = utf8 */;
 2494 CREATE TABLE `mvv_abschl_zuord` (
 2495   `abschluss_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2496   `kategorie_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2497   `position` int(4) NOT NULL DEFAULT '9999',
 2498   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2499   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2500   `mkdate` bigint(20) NOT NULL,
 2501   `chdate` bigint(20) NOT NULL,
 2502   PRIMARY KEY (`abschluss_id`),
 2503   KEY `kategorie_id` (`kategorie_id`)
 2504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2505 /*!40101 SET character_set_client = @saved_cs_client */;
 2506 
 2507 --
 2508 -- Table structure for table `mvv_aufbaustudiengang`
 2509 --
 2510 
 2511 DROP TABLE IF EXISTS `mvv_aufbaustudiengang`;
 2512 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2513 /*!40101 SET character_set_client = utf8 */;
 2514 CREATE TABLE `mvv_aufbaustudiengang` (
 2515   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 2516   `grund_stg_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2517   `aufbau_stg_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2518   `typ` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2519   `kommentar` text COLLATE utf8mb4_unicode_ci,
 2520   `author_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2521   `editor_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2522   `mkdate` int(11) NOT NULL,
 2523   `chdate` int(11) NOT NULL,
 2524   PRIMARY KEY (`id`),
 2525   UNIQUE KEY `grund_stg_id` (`grund_stg_id`,`aufbau_stg_id`)
 2526 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2527 /*!40101 SET character_set_client = @saved_cs_client */;
 2528 
 2529 --
 2530 -- Table structure for table `mvv_contacts`
 2531 --
 2532 
 2533 DROP TABLE IF EXISTS `mvv_contacts`;
 2534 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2535 /*!40101 SET character_set_client = utf8 */;
 2536 CREATE TABLE `mvv_contacts` (
 2537   `contact_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2538   `contact_status` enum('intern','extern','institution') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2539   `alt_mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2540   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2541   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2542   `mkdate` int(11) NOT NULL,
 2543   `chdate` int(11) NOT NULL,
 2544   PRIMARY KEY (`contact_id`),
 2545   KEY `contact_status` (`contact_status`)
 2546 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2547 /*!40101 SET character_set_client = @saved_cs_client */;
 2548 
 2549 --
 2550 -- Table structure for table `mvv_contacts_ranges`
 2551 --
 2552 
 2553 DROP TABLE IF EXISTS `mvv_contacts_ranges`;
 2554 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2555 /*!40101 SET character_set_client = utf8 */;
 2556 CREATE TABLE `mvv_contacts_ranges` (
 2557   `contact_range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2558   `contact_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2559   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2560   `range_type` enum('Modul','Studiengang','StudiengangTeil') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2561   `type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
 2562   `category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
 2563   `position` int(10) DEFAULT NULL,
 2564   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2565   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2566   `mkdate` int(11) NOT NULL,
 2567   `chdate` int(11) NOT NULL,
 2568   PRIMARY KEY (`contact_range_id`),
 2569   KEY `range_id` (`range_id`),
 2570   KEY `range_type` (`range_type`),
 2571   KEY `type` (`type`),
 2572   KEY `category_range` (`category`,`range_id`),
 2573   KEY `contact_id` (`contact_id`,`range_id`,`category`) USING BTREE
 2574 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2575 /*!40101 SET character_set_client = @saved_cs_client */;
 2576 
 2577 --
 2578 -- Table structure for table `mvv_extern_contacts`
 2579 --
 2580 
 2581 DROP TABLE IF EXISTS `mvv_extern_contacts`;
 2582 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2583 /*!40101 SET character_set_client = utf8 */;
 2584 CREATE TABLE `mvv_extern_contacts` (
 2585   `extern_contact_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2586   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2587   `vorname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2588   `homepage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2589   `mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2590   `tel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 2591   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2592   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2593   `mkdate` int(11) NOT NULL,
 2594   `chdate` int(11) NOT NULL,
 2595   PRIMARY KEY (`extern_contact_id`)
 2596 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2597 /*!40101 SET character_set_client = @saved_cs_client */;
 2598 
 2599 --
 2600 -- Table structure for table `mvv_fach_inst`
 2601 --
 2602 
 2603 DROP TABLE IF EXISTS `mvv_fach_inst`;
 2604 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2605 /*!40101 SET character_set_client = utf8 */;
 2606 CREATE TABLE `mvv_fach_inst` (
 2607   `fach_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2608   `institut_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2609   `position` int(11) NOT NULL,
 2610   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2611   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2612   `mkdate` bigint(20) NOT NULL,
 2613   `chdate` bigint(20) NOT NULL,
 2614   PRIMARY KEY (`fach_id`,`institut_id`)
 2615 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2616 /*!40101 SET character_set_client = @saved_cs_client */;
 2617 
 2618 --
 2619 -- Table structure for table `mvv_files`
 2620 --
 2621 
 2622 DROP TABLE IF EXISTS `mvv_files`;
 2623 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2624 /*!40101 SET character_set_client = utf8 */;
 2625 CREATE TABLE `mvv_files` (
 2626   `mvvfile_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2627   `year` int(10) DEFAULT NULL,
 2628   `type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2629   `category` text COLLATE utf8mb4_unicode_ci,
 2630   `tags` text COLLATE utf8mb4_unicode_ci,
 2631   `extern_visible` tinyint(1) DEFAULT NULL,
 2632   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2633   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2634   `mkdate` int(11) NOT NULL,
 2635   `chdate` int(11) NOT NULL,
 2636   PRIMARY KEY (`mvvfile_id`)
 2637 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2638 /*!40101 SET character_set_client = @saved_cs_client */;
 2639 
 2640 --
 2641 -- Table structure for table `mvv_files_filerefs`
 2642 --
 2643 
 2644 DROP TABLE IF EXISTS `mvv_files_filerefs`;
 2645 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2646 /*!40101 SET character_set_client = utf8 */;
 2647 CREATE TABLE `mvv_files_filerefs` (
 2648   `mvvfile_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2649   `file_language` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2650   `name` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
 2651   `fileref_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2652   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2653   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2654   `mkdate` int(11) NOT NULL,
 2655   `chdate` int(11) NOT NULL,
 2656   PRIMARY KEY (`mvvfile_id`,`file_language`)
 2657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2658 /*!40101 SET character_set_client = @saved_cs_client */;
 2659 
 2660 --
 2661 -- Table structure for table `mvv_files_ranges`
 2662 --
 2663 
 2664 DROP TABLE IF EXISTS `mvv_files_ranges`;
 2665 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2666 /*!40101 SET character_set_client = utf8 */;
 2667 CREATE TABLE `mvv_files_ranges` (
 2668   `mvvfile_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2669   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2670   `range_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2671   `position` int(10) DEFAULT NULL,
 2672   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2673   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2674   `mkdate` int(11) NOT NULL,
 2675   `chdate` int(11) NOT NULL,
 2676   PRIMARY KEY (`mvvfile_id`,`range_id`)
 2677 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2678 /*!40101 SET character_set_client = @saved_cs_client */;
 2679 
 2680 --
 2681 -- Table structure for table `mvv_lvgruppe`
 2682 --
 2683 
 2684 DROP TABLE IF EXISTS `mvv_lvgruppe`;
 2685 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2686 /*!40101 SET character_set_client = utf8 */;
 2687 CREATE TABLE `mvv_lvgruppe` (
 2688   `lvgruppe_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2689   `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
 2690   `alttext` tinytext COLLATE utf8mb4_unicode_ci,
 2691   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2692   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2693   `mkdate` bigint(20) NOT NULL,
 2694   `chdate` bigint(20) NOT NULL,
 2695   PRIMARY KEY (`lvgruppe_id`)
 2696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2697 /*!40101 SET character_set_client = @saved_cs_client */;
 2698 
 2699 --
 2700 -- Table structure for table `mvv_lvgruppe_modulteil`
 2701 --
 2702 
 2703 DROP TABLE IF EXISTS `mvv_lvgruppe_modulteil`;
 2704 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2705 /*!40101 SET character_set_client = utf8 */;
 2706 CREATE TABLE `mvv_lvgruppe_modulteil` (
 2707   `lvgruppe_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2708   `modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2709   `position` int(11) NOT NULL DEFAULT '9999',
 2710   `fn_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2711   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2712   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2713   `mkdate` bigint(20) NOT NULL,
 2714   `chdate` bigint(20) NOT NULL,
 2715   PRIMARY KEY (`lvgruppe_id`,`modulteil_id`),
 2716   KEY `fn_id` (`fn_id`),
 2717   KEY `modulteil_id` (`modulteil_id`)
 2718 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2719 /*!40101 SET character_set_client = @saved_cs_client */;
 2720 
 2721 --
 2722 -- Table structure for table `mvv_lvgruppe_seminar`
 2723 --
 2724 
 2725 DROP TABLE IF EXISTS `mvv_lvgruppe_seminar`;
 2726 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2727 /*!40101 SET character_set_client = utf8 */;
 2728 CREATE TABLE `mvv_lvgruppe_seminar` (
 2729   `lvgruppe_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2730   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2731   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2732   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2733   `mkdate` bigint(20) NOT NULL,
 2734   `chdate` bigint(20) NOT NULL,
 2735   PRIMARY KEY (`lvgruppe_id`,`seminar_id`),
 2736   KEY `seminar_id` (`seminar_id`)
 2737 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2738 /*!40101 SET character_set_client = @saved_cs_client */;
 2739 
 2740 --
 2741 -- Table structure for table `mvv_modul`
 2742 --
 2743 
 2744 DROP TABLE IF EXISTS `mvv_modul`;
 2745 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2746 /*!40101 SET character_set_client = utf8 */;
 2747 CREATE TABLE `mvv_modul` (
 2748   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2749   `quelle` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2750   `variante` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2751   `flexnow_modul` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2752   `code` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2753   `start` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2754   `end` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2755   `beschlussdatum` int(11) DEFAULT NULL,
 2756   `fassung_nr` int(2) DEFAULT NULL,
 2757   `fassung_typ` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2758   `version` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
 2759   `dauer` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2760   `kapazitaet` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 2761   `kp` double(5,2) DEFAULT NULL,
 2762   `wl_selbst` int(11) DEFAULT NULL,
 2763   `wl_pruef` int(11) DEFAULT NULL,
 2764   `pruef_ebene` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2765   `faktor_note` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '1',
 2766   `stat` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2767   `kommentar_status` text COLLATE utf8mb4_unicode_ci,
 2768   `verantwortlich` tinytext COLLATE utf8mb4_unicode_ci,
 2769   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2770   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2771   `mkdate` bigint(20) NOT NULL,
 2772   `chdate` bigint(20) NOT NULL,
 2773   PRIMARY KEY (`modul_id`),
 2774   KEY `stat` (`stat`),
 2775   KEY `flexnow_modul` (`flexnow_modul`)
 2776 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2777 /*!40101 SET character_set_client = @saved_cs_client */;
 2778 
 2779 --
 2780 -- Table structure for table `mvv_modul_deskriptor`
 2781 --
 2782 
 2783 DROP TABLE IF EXISTS `mvv_modul_deskriptor`;
 2784 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2785 /*!40101 SET character_set_client = utf8 */;
 2786 CREATE TABLE `mvv_modul_deskriptor` (
 2787   `deskriptor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2788   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2789   `verantwortlich` tinytext COLLATE utf8mb4_unicode_ci,
 2790   `bezeichnung` tinytext COLLATE utf8mb4_unicode_ci,
 2791   `voraussetzung` text COLLATE utf8mb4_unicode_ci,
 2792   `kompetenzziele` text COLLATE utf8mb4_unicode_ci,
 2793   `inhalte` text COLLATE utf8mb4_unicode_ci,
 2794   `literatur` text COLLATE utf8mb4_unicode_ci,
 2795   `links` text COLLATE utf8mb4_unicode_ci,
 2796   `kommentar` text COLLATE utf8mb4_unicode_ci,
 2797   `turnus` tinytext COLLATE utf8mb4_unicode_ci,
 2798   `kommentar_kapazitaet` text COLLATE utf8mb4_unicode_ci,
 2799   `kommentar_sws` text COLLATE utf8mb4_unicode_ci,
 2800   `kommentar_wl_selbst` text COLLATE utf8mb4_unicode_ci,
 2801   `kommentar_wl_pruef` text COLLATE utf8mb4_unicode_ci,
 2802   `kommentar_note` text COLLATE utf8mb4_unicode_ci,
 2803   `pruef_vorleistung` text COLLATE utf8mb4_unicode_ci,
 2804   `pruef_leistung` text COLLATE utf8mb4_unicode_ci,
 2805   `pruef_wiederholung` text COLLATE utf8mb4_unicode_ci,
 2806   `ersatztext` text COLLATE utf8mb4_unicode_ci,
 2807   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2808   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2809   `mkdate` bigint(20) NOT NULL,
 2810   `chdate` bigint(20) NOT NULL,
 2811   PRIMARY KEY (`deskriptor_id`),
 2812   UNIQUE KEY `modul_id` (`modul_id`)
 2813 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2814 /*!40101 SET character_set_client = @saved_cs_client */;
 2815 
 2816 --
 2817 -- Table structure for table `mvv_modul_inst`
 2818 --
 2819 
 2820 DROP TABLE IF EXISTS `mvv_modul_inst`;
 2821 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2822 /*!40101 SET character_set_client = utf8 */;
 2823 CREATE TABLE `mvv_modul_inst` (
 2824   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2825   `institut_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2826   `gruppe` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2827   `position` int(11) NOT NULL DEFAULT '9999',
 2828   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2829   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2830   `mkdate` bigint(20) NOT NULL,
 2831   `chdate` bigint(20) NOT NULL,
 2832   PRIMARY KEY (`modul_id`,`institut_id`),
 2833   KEY `institut_id` (`institut_id`)
 2834 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2835 /*!40101 SET character_set_client = @saved_cs_client */;
 2836 
 2837 --
 2838 -- Table structure for table `mvv_modul_language`
 2839 --
 2840 
 2841 DROP TABLE IF EXISTS `mvv_modul_language`;
 2842 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2843 /*!40101 SET character_set_client = utf8 */;
 2844 CREATE TABLE `mvv_modul_language` (
 2845   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2846   `lang` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2847   `position` int(11) NOT NULL DEFAULT '9999',
 2848   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2849   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2850   `mkdate` bigint(20) NOT NULL,
 2851   `chdate` bigint(20) NOT NULL,
 2852   PRIMARY KEY (`modul_id`,`lang`)
 2853 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2854 /*!40101 SET character_set_client = @saved_cs_client */;
 2855 
 2856 --
 2857 -- Table structure for table `mvv_modulteil`
 2858 --
 2859 
 2860 DROP TABLE IF EXISTS `mvv_modulteil`;
 2861 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2862 /*!40101 SET character_set_client = utf8 */;
 2863 CREATE TABLE `mvv_modulteil` (
 2864   `modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2865   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2866   `position` int(11) NOT NULL DEFAULT '9999',
 2867   `flexnow_modul` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2868   `nummer` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2869   `num_bezeichnung` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2870   `lernlehrform` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2871   `semester` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 2872   `kapazitaet` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 2873   `kp` double(5,2) DEFAULT NULL,
 2874   `sws` int(11) DEFAULT NULL,
 2875   `wl_praesenz` int(11) DEFAULT NULL,
 2876   `wl_bereitung` int(11) DEFAULT NULL,
 2877   `wl_selbst` int(11) DEFAULT NULL,
 2878   `wl_pruef` int(11) DEFAULT NULL,
 2879   `anteil_note` int(11) DEFAULT NULL,
 2880   `ausgleichbar` int(1) NOT NULL DEFAULT '0',
 2881   `pflicht` int(2) NOT NULL DEFAULT '0',
 2882   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2883   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2884   `mkdate` bigint(20) NOT NULL,
 2885   `chdate` bigint(20) NOT NULL,
 2886   PRIMARY KEY (`modulteil_id`),
 2887   KEY `modul_id` (`modul_id`),
 2888   KEY `flexnow_modul` (`flexnow_modul`)
 2889 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2890 /*!40101 SET character_set_client = @saved_cs_client */;
 2891 
 2892 --
 2893 -- Table structure for table `mvv_modulteil_deskriptor`
 2894 --
 2895 
 2896 DROP TABLE IF EXISTS `mvv_modulteil_deskriptor`;
 2897 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2898 /*!40101 SET character_set_client = utf8 */;
 2899 CREATE TABLE `mvv_modulteil_deskriptor` (
 2900   `deskriptor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2901   `modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2902   `bezeichnung` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
 2903   `voraussetzung` text COLLATE utf8mb4_unicode_ci,
 2904   `kommentar` text COLLATE utf8mb4_unicode_ci,
 2905   `kommentar_kapazitaet` text COLLATE utf8mb4_unicode_ci,
 2906   `kommentar_wl_praesenz` text COLLATE utf8mb4_unicode_ci,
 2907   `kommentar_wl_bereitung` text COLLATE utf8mb4_unicode_ci,
 2908   `kommentar_wl_selbst` text COLLATE utf8mb4_unicode_ci,
 2909   `kommentar_wl_pruef` text COLLATE utf8mb4_unicode_ci,
 2910   `pruef_vorleistung` text COLLATE utf8mb4_unicode_ci,
 2911   `pruef_leistung` text COLLATE utf8mb4_unicode_ci,
 2912   `kommentar_pflicht` text COLLATE utf8mb4_unicode_ci,
 2913   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2914   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2915   `mkdate` bigint(20) NOT NULL,
 2916   `chdate` bigint(20) NOT NULL,
 2917   PRIMARY KEY (`deskriptor_id`),
 2918   KEY `modulteil_id` (`modulteil_id`)
 2919 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2920 /*!40101 SET character_set_client = @saved_cs_client */;
 2921 
 2922 --
 2923 -- Table structure for table `mvv_modulteil_language`
 2924 --
 2925 
 2926 DROP TABLE IF EXISTS `mvv_modulteil_language`;
 2927 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2928 /*!40101 SET character_set_client = utf8 */;
 2929 CREATE TABLE `mvv_modulteil_language` (
 2930   `modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2931   `lang` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2932   `position` int(11) NOT NULL DEFAULT '9999',
 2933   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2934   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2935   `mkdate` bigint(20) NOT NULL,
 2936   `chdate` bigint(20) NOT NULL,
 2937   PRIMARY KEY (`modulteil_id`,`lang`)
 2938 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2939 /*!40101 SET character_set_client = @saved_cs_client */;
 2940 
 2941 --
 2942 -- Table structure for table `mvv_modulteil_stgteilabschnitt`
 2943 --
 2944 
 2945 DROP TABLE IF EXISTS `mvv_modulteil_stgteilabschnitt`;
 2946 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2947 /*!40101 SET character_set_client = utf8 */;
 2948 CREATE TABLE `mvv_modulteil_stgteilabschnitt` (
 2949   `modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2950   `abschnitt_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2951   `fachsemester` int(2) NOT NULL,
 2952   `differenzierung` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
 2953   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2954   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2955   `mkdate` bigint(20) NOT NULL,
 2956   `chdate` bigint(20) NOT NULL,
 2957   PRIMARY KEY (`modulteil_id`,`abschnitt_id`,`fachsemester`)
 2958 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2959 /*!40101 SET character_set_client = @saved_cs_client */;
 2960 
 2961 --
 2962 -- Table structure for table `mvv_ovl_conflicts`
 2963 --
 2964 
 2965 DROP TABLE IF EXISTS `mvv_ovl_conflicts`;
 2966 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2967 /*!40101 SET character_set_client = utf8 */;
 2968 CREATE TABLE `mvv_ovl_conflicts` (
 2969   `conflict_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 2970   `selection_id` int(11) NOT NULL,
 2971   `base_abschnitt_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2972   `base_modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2973   `base_course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2974   `base_metadate_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2975   `comp_abschnitt_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2976   `comp_modulteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2977   `comp_course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2978   `comp_metadate_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2979   PRIMARY KEY (`conflict_id`),
 2980   KEY `selection_id` (`selection_id`)
 2981 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2982 /*!40101 SET character_set_client = @saved_cs_client */;
 2983 
 2984 --
 2985 -- Table structure for table `mvv_ovl_excludes`
 2986 --
 2987 
 2988 DROP TABLE IF EXISTS `mvv_ovl_excludes`;
 2989 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 2990 /*!40101 SET character_set_client = utf8 */;
 2991 CREATE TABLE `mvv_ovl_excludes` (
 2992   `selection_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2993   `course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 2994   PRIMARY KEY (`selection_id`,`course_id`),
 2995   KEY `course_id` (`course_id`) USING BTREE
 2996 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 2997 /*!40101 SET character_set_client = @saved_cs_client */;
 2998 
 2999 --
 3000 -- Table structure for table `mvv_ovl_selections`
 3001 --
 3002 
 3003 DROP TABLE IF EXISTS `mvv_ovl_selections`;
 3004 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3005 /*!40101 SET character_set_client = utf8 */;
 3006 CREATE TABLE `mvv_ovl_selections` (
 3007   `id` int(11) NOT NULL AUTO_INCREMENT,
 3008   `selection_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3009   `semester_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3010   `base_version_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3011   `comp_version_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3012   `fachsems` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3013   `semtypes` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3014   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3015   `show_excluded` int(1) unsigned NOT NULL DEFAULT '0',
 3016   `mkdate` bigint(20) NOT NULL,
 3017   PRIMARY KEY (`id`),
 3018   KEY `selection_id` (`selection_id`),
 3019   KEY `user_id` (`user_id`)
 3020 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3021 /*!40101 SET character_set_client = @saved_cs_client */;
 3022 
 3023 --
 3024 -- Table structure for table `mvv_stg_stgteil`
 3025 --
 3026 
 3027 DROP TABLE IF EXISTS `mvv_stg_stgteil`;
 3028 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3029 /*!40101 SET character_set_client = utf8 */;
 3030 CREATE TABLE `mvv_stg_stgteil` (
 3031   `studiengang_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3032   `stgteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3033   `stgteil_bez_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3034   `position` int(11) NOT NULL,
 3035   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3036   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3037   `mkdate` bigint(20) NOT NULL,
 3038   `chdate` bigint(20) NOT NULL,
 3039   PRIMARY KEY (`studiengang_id`,`stgteil_id`,`stgteil_bez_id`),
 3040   KEY `stgteil_id` (`stgteil_id`)
 3041 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3042 /*!40101 SET character_set_client = @saved_cs_client */;
 3043 
 3044 --
 3045 -- Table structure for table `mvv_stgteil`
 3046 --
 3047 
 3048 DROP TABLE IF EXISTS `mvv_stgteil`;
 3049 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3050 /*!40101 SET character_set_client = utf8 */;
 3051 CREATE TABLE `mvv_stgteil` (
 3052   `stgteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3053   `fach_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3054   `kp` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3055   `semester` int(2) DEFAULT NULL,
 3056   `zusatz` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
 3057   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3058   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3059   `mkdate` bigint(20) NOT NULL,
 3060   `chdate` bigint(20) NOT NULL,
 3061   PRIMARY KEY (`stgteil_id`),
 3062   KEY `fach_id` (`fach_id`)
 3063 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3064 /*!40101 SET character_set_client = @saved_cs_client */;
 3065 
 3066 --
 3067 -- Table structure for table `mvv_stgteil_bez`
 3068 --
 3069 
 3070 DROP TABLE IF EXISTS `mvv_stgteil_bez`;
 3071 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3072 /*!40101 SET character_set_client = utf8 */;
 3073 CREATE TABLE `mvv_stgteil_bez` (
 3074   `stgteil_bez_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3075   `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
 3076   `name_kurz` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3077   `position` int(4) NOT NULL DEFAULT '9999',
 3078   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3079   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3080   `mkdate` bigint(20) NOT NULL,
 3081   `chdate` bigint(20) NOT NULL,
 3082   PRIMARY KEY (`stgteil_bez_id`)
 3083 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3084 /*!40101 SET character_set_client = @saved_cs_client */;
 3085 
 3086 --
 3087 -- Table structure for table `mvv_stgteilabschnitt`
 3088 --
 3089 
 3090 DROP TABLE IF EXISTS `mvv_stgteilabschnitt`;
 3091 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3092 /*!40101 SET character_set_client = utf8 */;
 3093 CREATE TABLE `mvv_stgteilabschnitt` (
 3094   `abschnitt_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3095   `version_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3096   `position` int(11) NOT NULL DEFAULT '9999',
 3097   `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
 3098   `kommentar` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3099   `kp` double(5,2) DEFAULT NULL,
 3100   `ueberschrift` tinytext COLLATE utf8mb4_unicode_ci,
 3101   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3102   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3103   `mkdate` bigint(20) NOT NULL,
 3104   `chdate` bigint(20) NOT NULL,
 3105   PRIMARY KEY (`abschnitt_id`),
 3106   KEY `version_id` (`version_id`)
 3107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3108 /*!40101 SET character_set_client = @saved_cs_client */;
 3109 
 3110 --
 3111 -- Table structure for table `mvv_stgteilabschnitt_modul`
 3112 --
 3113 
 3114 DROP TABLE IF EXISTS `mvv_stgteilabschnitt_modul`;
 3115 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3116 /*!40101 SET character_set_client = utf8 */;
 3117 CREATE TABLE `mvv_stgteilabschnitt_modul` (
 3118   `abschnitt_modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3119   `abschnitt_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3120   `modul_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3121   `flexnow_modul` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3122   `modulcode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3123   `position` int(11) NOT NULL DEFAULT '9999',
 3124   `bezeichnung` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3125   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3126   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3127   `mkdate` bigint(20) NOT NULL,
 3128   `chdate` bigint(20) NOT NULL,
 3129   PRIMARY KEY (`abschnitt_modul_id`),
 3130   UNIQUE KEY `abschnitt_id` (`abschnitt_id`,`modul_id`) USING BTREE,
 3131   KEY `flexnow_modul` (`flexnow_modul`)
 3132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3133 /*!40101 SET character_set_client = @saved_cs_client */;
 3134 
 3135 --
 3136 -- Table structure for table `mvv_stgteilversion`
 3137 --
 3138 
 3139 DROP TABLE IF EXISTS `mvv_stgteilversion`;
 3140 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3141 /*!40101 SET character_set_client = utf8 */;
 3142 CREATE TABLE `mvv_stgteilversion` (
 3143   `version_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3144   `stgteil_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3145   `start_sem` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3146   `end_sem` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3147   `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3148   `beschlussdatum` int(11) DEFAULT NULL,
 3149   `fassung_nr` int(2) DEFAULT NULL,
 3150   `fassung_typ` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3151   `beschreibung` text COLLATE utf8mb4_unicode_ci,
 3152   `stat` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3153   `kommentar_status` text COLLATE utf8mb4_unicode_ci,
 3154   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3155   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3156   `mkdate` bigint(20) NOT NULL,
 3157   `chdate` bigint(20) NOT NULL,
 3158   PRIMARY KEY (`version_id`),
 3159   KEY `stgteil_id` (`stgteil_id`),
 3160   KEY `stat` (`stat`)
 3161 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3162 /*!40101 SET character_set_client = @saved_cs_client */;
 3163 
 3164 --
 3165 -- Table structure for table `mvv_studiengang`
 3166 --
 3167 
 3168 DROP TABLE IF EXISTS `mvv_studiengang`;
 3169 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3170 /*!40101 SET character_set_client = utf8 */;
 3171 CREATE TABLE `mvv_studiengang` (
 3172   `studiengang_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3173   `abschluss_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3174   `typ` enum('einfach','mehrfach') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3175   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3176   `name_kurz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3177   `beschreibung` text COLLATE utf8mb4_unicode_ci,
 3178   `institut_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3179   `start` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3180   `end` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3181   `beschlussdatum` int(11) DEFAULT NULL,
 3182   `fassung_nr` int(2) DEFAULT NULL,
 3183   `fassung_typ` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3184   `stat` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3185   `kommentar_status` text COLLATE utf8mb4_unicode_ci,
 3186   `schlagworte` text COLLATE utf8mb4_unicode_ci,
 3187   `studienzeit` tinyint(3) unsigned DEFAULT NULL,
 3188   `studienplaetze` int(10) unsigned DEFAULT NULL,
 3189   `abschlussgrad` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3190   `enroll` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3191   `author_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3192   `editor_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3193   `mkdate` bigint(20) NOT NULL,
 3194   `chdate` bigint(20) NOT NULL,
 3195   PRIMARY KEY (`studiengang_id`),
 3196   KEY `abschluss_id` (`abschluss_id`),
 3197   KEY `institut_id` (`institut_id`)
 3198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3199 /*!40101 SET character_set_client = @saved_cs_client */;
 3200 
 3201 --
 3202 -- Table structure for table `mvv_studycourse_language`
 3203 --
 3204 
 3205 DROP TABLE IF EXISTS `mvv_studycourse_language`;
 3206 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3207 /*!40101 SET character_set_client = utf8 */;
 3208 CREATE TABLE `mvv_studycourse_language` (
 3209   `studiengang_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3210   `lang` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3211   `position` int(11) NOT NULL DEFAULT '9999',
 3212   `author_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3213   `editor_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3214   `mkdate` int(11) NOT NULL,
 3215   `chdate` int(11) NOT NULL,
 3216   PRIMARY KEY (`studiengang_id`,`lang`)
 3217 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3218 /*!40101 SET character_set_client = @saved_cs_client */;
 3219 
 3220 --
 3221 -- Table structure for table `mvv_studycourse_type`
 3222 --
 3223 
 3224 DROP TABLE IF EXISTS `mvv_studycourse_type`;
 3225 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3226 /*!40101 SET character_set_client = utf8 */;
 3227 CREATE TABLE `mvv_studycourse_type` (
 3228   `studiengang_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3229   `type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3230   `author_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3231   `editor_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3232   `mkdate` int(11) NOT NULL,
 3233   `chdate` int(11) NOT NULL,
 3234   PRIMARY KEY (`studiengang_id`,`type`)
 3235 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3236 /*!40101 SET character_set_client = @saved_cs_client */;
 3237 
 3238 --
 3239 -- Table structure for table `news`
 3240 --
 3241 
 3242 DROP TABLE IF EXISTS `news`;
 3243 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3244 /*!40101 SET character_set_client = utf8 */;
 3245 CREATE TABLE `news` (
 3246   `news_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3247   `topic` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3248   `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3249   `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3250   `date` int(11) NOT NULL DEFAULT '0',
 3251   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3252   `expire` int(11) NOT NULL DEFAULT '0',
 3253   `allow_comments` tinyint(1) NOT NULL DEFAULT '0',
 3254   `chdate` int(10) unsigned NOT NULL DEFAULT '0',
 3255   `chdate_uid` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3256   `mkdate` int(10) unsigned NOT NULL DEFAULT '0',
 3257   PRIMARY KEY (`news_id`),
 3258   KEY `date` (`date`),
 3259   KEY `chdate` (`chdate`)
 3260 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3261 /*!40101 SET character_set_client = @saved_cs_client */;
 3262 
 3263 --
 3264 -- Table structure for table `news_range`
 3265 --
 3266 
 3267 DROP TABLE IF EXISTS `news_range`;
 3268 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3269 /*!40101 SET character_set_client = utf8 */;
 3270 CREATE TABLE `news_range` (
 3271   `news_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3272   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3273   PRIMARY KEY (`news_id`,`range_id`),
 3274   KEY `range_id` (`range_id`)
 3275 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3276 /*!40101 SET character_set_client = @saved_cs_client */;
 3277 
 3278 --
 3279 -- Table structure for table `news_rss_range`
 3280 --
 3281 
 3282 DROP TABLE IF EXISTS `news_rss_range`;
 3283 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3284 /*!40101 SET character_set_client = utf8 */;
 3285 CREATE TABLE `news_rss_range` (
 3286   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3287   `rss_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3288   `range_type` enum('user','sem','inst','global') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'user',
 3289   PRIMARY KEY (`range_id`),
 3290   KEY `rss_id` (`rss_id`)
 3291 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3292 /*!40101 SET character_set_client = @saved_cs_client */;
 3293 
 3294 --
 3295 -- Table structure for table `oauth_consumer_registry`
 3296 --
 3297 
 3298 DROP TABLE IF EXISTS `oauth_consumer_registry`;
 3299 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3300 /*!40101 SET character_set_client = utf8 */;
 3301 CREATE TABLE `oauth_consumer_registry` (
 3302   `ocr_id` int(11) NOT NULL AUTO_INCREMENT,
 3303   `ocr_usa_id_ref` int(11) DEFAULT NULL,
 3304   `ocr_consumer_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3305   `ocr_consumer_secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3306   `ocr_signature_methods` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'HMAC-SHA1,PLAINTEXT',
 3307   `ocr_server_uri` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
 3308   `ocr_server_uri_host` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
 3309   `ocr_server_uri_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3310   `ocr_request_token_uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3311   `ocr_authorize_uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3312   `ocr_access_token_uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3313   `ocr_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 3314   PRIMARY KEY (`ocr_id`),
 3315   UNIQUE KEY `ocr_consumer_key` (`ocr_consumer_key`,`ocr_usa_id_ref`,`ocr_server_uri`),
 3316   KEY `ocr_server_uri` (`ocr_server_uri`),
 3317   KEY `ocr_server_uri_host` (`ocr_server_uri_host`,`ocr_server_uri_path`),
 3318   KEY `ocr_usa_id_ref` (`ocr_usa_id_ref`)
 3319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3320 /*!40101 SET character_set_client = @saved_cs_client */;
 3321 
 3322 --
 3323 -- Table structure for table `oauth_consumer_token`
 3324 --
 3325 
 3326 DROP TABLE IF EXISTS `oauth_consumer_token`;
 3327 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3328 /*!40101 SET character_set_client = utf8 */;
 3329 CREATE TABLE `oauth_consumer_token` (
 3330   `oct_id` int(11) NOT NULL AUTO_INCREMENT,
 3331   `oct_ocr_id_ref` int(11) NOT NULL,
 3332   `oct_usa_id_ref` int(11) NOT NULL,
 3333   `oct_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 3334   `oct_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3335   `oct_token_secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3336   `oct_token_type` enum('request','authorized','access') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3337   `oct_token_ttl` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
 3338   `oct_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 3339   PRIMARY KEY (`oct_id`),
 3340   UNIQUE KEY `oct_ocr_id_ref` (`oct_ocr_id_ref`,`oct_token`),
 3341   UNIQUE KEY `oct_usa_id_ref` (`oct_usa_id_ref`,`oct_ocr_id_ref`,`oct_token_type`,`oct_name`),
 3342   KEY `oct_token_ttl` (`oct_token_ttl`)
 3343 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3344 /*!40101 SET character_set_client = @saved_cs_client */;
 3345 
 3346 --
 3347 -- Table structure for table `oauth_log`
 3348 --
 3349 
 3350 DROP TABLE IF EXISTS `oauth_log`;
 3351 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3352 /*!40101 SET character_set_client = utf8 */;
 3353 CREATE TABLE `oauth_log` (
 3354   `olg_id` int(11) NOT NULL AUTO_INCREMENT,
 3355   `olg_osr_consumer_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
 3356   `olg_ost_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
 3357   `olg_ocr_consumer_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
 3358   `olg_oct_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
 3359   `olg_usa_id_ref` int(11) DEFAULT NULL,
 3360   `olg_received` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3361   `olg_sent` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3362   `olg_base_string` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3363   `olg_notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3364   `olg_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 3365   `olg_remote_ip` bigint(20) NOT NULL,
 3366   PRIMARY KEY (`olg_id`),
 3367   KEY `olg_osr_consumer_key` (`olg_osr_consumer_key`,`olg_id`),
 3368   KEY `olg_ost_token` (`olg_ost_token`,`olg_id`),
 3369   KEY `olg_ocr_consumer_key` (`olg_ocr_consumer_key`,`olg_id`),
 3370   KEY `olg_oct_token` (`olg_oct_token`,`olg_id`),
 3371   KEY `olg_usa_id_ref` (`olg_usa_id_ref`,`olg_id`)
 3372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3373 /*!40101 SET character_set_client = @saved_cs_client */;
 3374 
 3375 --
 3376 -- Table structure for table `oauth_server_nonce`
 3377 --
 3378 
 3379 DROP TABLE IF EXISTS `oauth_server_nonce`;
 3380 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3381 /*!40101 SET character_set_client = utf8 */;
 3382 CREATE TABLE `oauth_server_nonce` (
 3383   `osn_id` int(11) NOT NULL AUTO_INCREMENT,
 3384   `osn_consumer_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3385   `osn_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3386   `osn_timestamp` bigint(20) NOT NULL,
 3387   `osn_nonce` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3388   PRIMARY KEY (`osn_id`),
 3389   UNIQUE KEY `osn_consumer_key` (`osn_consumer_key`,`osn_token`,`osn_timestamp`,`osn_nonce`)
 3390 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3391 /*!40101 SET character_set_client = @saved_cs_client */;
 3392 
 3393 --
 3394 -- Table structure for table `oauth_server_registry`
 3395 --
 3396 
 3397 DROP TABLE IF EXISTS `oauth_server_registry`;
 3398 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3399 /*!40101 SET character_set_client = utf8 */;
 3400 CREATE TABLE `oauth_server_registry` (
 3401   `osr_id` int(11) NOT NULL AUTO_INCREMENT,
 3402   `osr_usa_id_ref` int(11) DEFAULT NULL,
 3403   `osr_consumer_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3404   `osr_consumer_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3405   `osr_enabled` tinyint(1) NOT NULL DEFAULT '1',
 3406   `osr_status` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3407   `osr_requester_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 3408   `osr_requester_email` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 3409   `osr_callback_uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3410   `osr_application_uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 3411   `osr_application_title` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
 3412   `osr_application_descr` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3413   `osr_application_notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3414   `osr_application_type` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3415   `osr_application_commercial` tinyint(1) NOT NULL DEFAULT '0',
 3416   `osr_issue_date` datetime NOT NULL,
 3417   `osr_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 3418   PRIMARY KEY (`osr_id`),
 3419   UNIQUE KEY `osr_consumer_key` (`osr_consumer_key`),
 3420   KEY `osr_usa_id_ref` (`osr_usa_id_ref`)
 3421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3422 /*!40101 SET character_set_client = @saved_cs_client */;
 3423 
 3424 --
 3425 -- Table structure for table `oauth_server_token`
 3426 --
 3427 
 3428 DROP TABLE IF EXISTS `oauth_server_token`;
 3429 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3430 /*!40101 SET character_set_client = utf8 */;
 3431 CREATE TABLE `oauth_server_token` (
 3432   `ost_id` int(11) NOT NULL AUTO_INCREMENT,
 3433   `ost_osr_id_ref` int(11) NOT NULL,
 3434   `ost_usa_id_ref` int(11) NOT NULL,
 3435   `ost_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3436   `ost_token_secret` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 3437   `ost_token_type` enum('request','access') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3438   `ost_authorized` tinyint(1) NOT NULL DEFAULT '0',
 3439   `ost_referrer_host` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3440   `ost_token_ttl` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
 3441   `ost_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 3442   `ost_verifier` char(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3443   `ost_callback_url` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3444   PRIMARY KEY (`ost_id`),
 3445   UNIQUE KEY `ost_token` (`ost_token`),
 3446   KEY `ost_osr_id_ref` (`ost_osr_id_ref`),
 3447   KEY `ost_token_ttl` (`ost_token_ttl`)
 3448 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3449 /*!40101 SET character_set_client = @saved_cs_client */;
 3450 
 3451 --
 3452 -- Table structure for table `object_contentmodules`
 3453 --
 3454 
 3455 DROP TABLE IF EXISTS `object_contentmodules`;
 3456 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3457 /*!40101 SET character_set_client = utf8 */;
 3458 CREATE TABLE `object_contentmodules` (
 3459   `object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3460   `module_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3461   `system_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3462   `module_type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3463   `mkdate` int(20) NOT NULL DEFAULT '0',
 3464   `chdate` int(20) NOT NULL DEFAULT '0',
 3465   PRIMARY KEY (`object_id`,`module_id`,`system_type`)
 3466 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3467 /*!40101 SET character_set_client = @saved_cs_client */;
 3468 
 3469 --
 3470 -- Table structure for table `object_user_visits`
 3471 --
 3472 
 3473 DROP TABLE IF EXISTS `object_user_visits`;
 3474 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3475 /*!40101 SET character_set_client = utf8 */;
 3476 CREATE TABLE `object_user_visits` (
 3477   `object_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3478   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3479   `type` enum('vote','documents','forum','literature','schedule','scm','sem','wiki','news','eval','inst','elearning_interface','ilias_interface','participants') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'vote',
 3480   `visitdate` int(20) NOT NULL DEFAULT '0',
 3481   `last_visitdate` int(20) NOT NULL DEFAULT '0',
 3482   PRIMARY KEY (`object_id`,`user_id`,`type`),
 3483   KEY `user_id` (`user_id`)
 3484 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3485 /*!40101 SET character_set_client = @saved_cs_client */;
 3486 
 3487 --
 3488 -- Table structure for table `object_views`
 3489 --
 3490 
 3491 DROP TABLE IF EXISTS `object_views`;
 3492 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3493 /*!40101 SET character_set_client = utf8 */;
 3494 CREATE TABLE `object_views` (
 3495   `object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3496   `views` int(20) NOT NULL DEFAULT '0',
 3497   `chdate` int(20) NOT NULL DEFAULT '0',
 3498   PRIMARY KEY (`object_id`),
 3499   KEY `views` (`views`)
 3500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3501 /*!40101 SET character_set_client = @saved_cs_client */;
 3502 
 3503 --
 3504 -- Table structure for table `opengraphdata`
 3505 --
 3506 
 3507 DROP TABLE IF EXISTS `opengraphdata`;
 3508 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3509 /*!40101 SET character_set_client = utf8 */;
 3510 CREATE TABLE `opengraphdata` (
 3511   `opengraph_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 3512   `hash` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3513   `url` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
 3514   `is_opengraph` tinyint(2) DEFAULT NULL,
 3515   `title` text COLLATE utf8mb4_unicode_ci,
 3516   `image` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3517   `description` text COLLATE utf8mb4_unicode_ci,
 3518   `type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3519   `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3520   `last_update` bigint(20) NOT NULL,
 3521   `chdate` bigint(20) NOT NULL,
 3522   `mkdate` bigint(20) NOT NULL,
 3523   PRIMARY KEY (`opengraph_id`),
 3524   UNIQUE KEY `hash` (`hash`)
 3525 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3526 /*!40101 SET character_set_client = @saved_cs_client */;
 3527 
 3528 --
 3529 -- Table structure for table `participantrestrictedadmissions`
 3530 --
 3531 
 3532 DROP TABLE IF EXISTS `participantrestrictedadmissions`;
 3533 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3534 /*!40101 SET character_set_client = utf8 */;
 3535 CREATE TABLE `participantrestrictedadmissions` (
 3536   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3537   `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3538   `distribution_time` int(11) NOT NULL DEFAULT '0',
 3539   `mkdate` int(11) NOT NULL DEFAULT '0',
 3540   `chdate` int(11) NOT NULL DEFAULT '0',
 3541   PRIMARY KEY (`rule_id`)
 3542 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3543 /*!40101 SET character_set_client = @saved_cs_client */;
 3544 
 3545 --
 3546 -- Table structure for table `passwordadmissions`
 3547 --
 3548 
 3549 DROP TABLE IF EXISTS `passwordadmissions`;
 3550 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3551 /*!40101 SET character_set_client = utf8 */;
 3552 CREATE TABLE `passwordadmissions` (
 3553   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3554   `message` text COLLATE utf8mb4_unicode_ci,
 3555   `start_time` int(11) NOT NULL DEFAULT '0',
 3556   `end_time` int(11) NOT NULL DEFAULT '0',
 3557   `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3558   `mkdate` int(11) NOT NULL DEFAULT '0',
 3559   `chdate` int(11) NOT NULL DEFAULT '0',
 3560   PRIMARY KEY (`rule_id`)
 3561 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3562 /*!40101 SET character_set_client = @saved_cs_client */;
 3563 
 3564 --
 3565 -- Table structure for table `personal_notifications`
 3566 --
 3567 
 3568 DROP TABLE IF EXISTS `personal_notifications`;
 3569 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3570 /*!40101 SET character_set_client = utf8 */;
 3571 CREATE TABLE `personal_notifications` (
 3572   `personal_notification_id` int(11) NOT NULL AUTO_INCREMENT,
 3573   `url` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3574   `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3575   `avatar` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3576   `dialog` tinyint(4) NOT NULL DEFAULT '0',
 3577   `html_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3578   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3579   PRIMARY KEY (`personal_notification_id`),
 3580   KEY `html_id` (`html_id`),
 3581   KEY `url` (`url`(256))
 3582 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3583 /*!40101 SET character_set_client = @saved_cs_client */;
 3584 
 3585 --
 3586 -- Table structure for table `personal_notifications_user`
 3587 --
 3588 
 3589 DROP TABLE IF EXISTS `personal_notifications_user`;
 3590 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3591 /*!40101 SET character_set_client = utf8 */;
 3592 CREATE TABLE `personal_notifications_user` (
 3593   `personal_notification_id` int(10) unsigned NOT NULL,
 3594   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3595   `seen` tinyint(1) NOT NULL DEFAULT '0',
 3596   PRIMARY KEY (`personal_notification_id`,`user_id`),
 3597   KEY `user_id` (`user_id`,`seen`)
 3598 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3599 /*!40101 SET character_set_client = @saved_cs_client */;
 3600 
 3601 --
 3602 -- Table structure for table `plugin_assets`
 3603 --
 3604 
 3605 DROP TABLE IF EXISTS `plugin_assets`;
 3606 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3607 /*!40101 SET character_set_client = utf8 */;
 3608 CREATE TABLE `plugin_assets` (
 3609   `asset_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3610   `plugin_id` int(10) unsigned NOT NULL,
 3611   `type` enum('css','js') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3612   `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3613   `storagename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3614   `size` int(11) unsigned DEFAULT NULL,
 3615   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3616   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3617   PRIMARY KEY (`asset_id`)
 3618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3619 /*!40101 SET character_set_client = @saved_cs_client */;
 3620 
 3621 --
 3622 -- Table structure for table `plugins`
 3623 --
 3624 
 3625 DROP TABLE IF EXISTS `plugins`;
 3626 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3627 /*!40101 SET character_set_client = utf8 */;
 3628 CREATE TABLE `plugins` (
 3629   `pluginid` int(10) unsigned NOT NULL AUTO_INCREMENT,
 3630   `pluginclassname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3631   `pluginpath` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3632   `pluginname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3633   `plugintype` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3634   `enabled` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'no',
 3635   `navigationpos` int(10) unsigned NOT NULL DEFAULT '0',
 3636   `dependentonid` int(10) unsigned DEFAULT NULL,
 3637   `automatic_update_url` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 3638   `automatic_update_secret` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3639   PRIMARY KEY (`pluginid`)
 3640 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3641 /*!40101 SET character_set_client = @saved_cs_client */;
 3642 
 3643 --
 3644 -- Table structure for table `plugins_activated`
 3645 --
 3646 
 3647 DROP TABLE IF EXISTS `plugins_activated`;
 3648 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3649 /*!40101 SET character_set_client = utf8 */;
 3650 CREATE TABLE `plugins_activated` (
 3651   `pluginid` int(10) unsigned NOT NULL DEFAULT '0',
 3652   `range_type` enum('sem','inst','user') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'sem',
 3653   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3654   `state` tinyint(1) NOT NULL DEFAULT '1',
 3655   PRIMARY KEY (`pluginid`,`range_type`,`range_id`),
 3656   KEY `range` (`range_id`,`range_type`)
 3657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3658 /*!40101 SET character_set_client = @saved_cs_client */;
 3659 
 3660 --
 3661 -- Table structure for table `plugins_default_activations`
 3662 --
 3663 
 3664 DROP TABLE IF EXISTS `plugins_default_activations`;
 3665 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3666 /*!40101 SET character_set_client = utf8 */;
 3667 CREATE TABLE `plugins_default_activations` (
 3668   `pluginid` int(10) unsigned NOT NULL DEFAULT '0',
 3669   `institutid` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3670   PRIMARY KEY (`pluginid`,`institutid`)
 3671 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3672 /*!40101 SET character_set_client = @saved_cs_client */;
 3673 
 3674 --
 3675 -- Table structure for table `prefadmission_condition`
 3676 --
 3677 
 3678 DROP TABLE IF EXISTS `prefadmission_condition`;
 3679 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3680 /*!40101 SET character_set_client = utf8 */;
 3681 CREATE TABLE `prefadmission_condition` (
 3682   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3683   `condition_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3684   `chance` int(4) NOT NULL DEFAULT '1',
 3685   `mkdate` int(11) NOT NULL DEFAULT '0',
 3686   PRIMARY KEY (`rule_id`,`condition_id`)
 3687 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3688 /*!40101 SET character_set_client = @saved_cs_client */;
 3689 
 3690 --
 3691 -- Table structure for table `prefadmissions`
 3692 --
 3693 
 3694 DROP TABLE IF EXISTS `prefadmissions`;
 3695 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3696 /*!40101 SET character_set_client = utf8 */;
 3697 CREATE TABLE `prefadmissions` (
 3698   `rule_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3699   `favor_semester` tinyint(1) NOT NULL DEFAULT '0',
 3700   `mkdate` int(11) NOT NULL DEFAULT '0',
 3701   `chdate` int(11) NOT NULL DEFAULT '0',
 3702   PRIMARY KEY (`rule_id`)
 3703 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3704 /*!40101 SET character_set_client = @saved_cs_client */;
 3705 
 3706 --
 3707 -- Table structure for table `priorities`
 3708 --
 3709 
 3710 DROP TABLE IF EXISTS `priorities`;
 3711 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3712 /*!40101 SET character_set_client = utf8 */;
 3713 CREATE TABLE `priorities` (
 3714   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3715   `set_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3716   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3717   `priority` int(11) NOT NULL DEFAULT '0',
 3718   `mkdate` int(11) NOT NULL DEFAULT '0',
 3719   `chdate` int(11) NOT NULL DEFAULT '0',
 3720   PRIMARY KEY (`user_id`,`set_id`,`seminar_id`),
 3721   KEY `user_rule_priority` (`user_id`,`priority`,`set_id`)
 3722 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3723 /*!40101 SET character_set_client = @saved_cs_client */;
 3724 
 3725 --
 3726 -- Table structure for table `questionnaire_anonymous_answers`
 3727 --
 3728 
 3729 DROP TABLE IF EXISTS `questionnaire_anonymous_answers`;
 3730 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3731 /*!40101 SET character_set_client = utf8 */;
 3732 CREATE TABLE `questionnaire_anonymous_answers` (
 3733   `anonymous_answer_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3734   `questionnaire_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3735   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3736   `chdate` bigint(20) NOT NULL,
 3737   `mkdate` int(11) NOT NULL,
 3738   PRIMARY KEY (`anonymous_answer_id`),
 3739   UNIQUE KEY `questionnaire_id_user_id` (`questionnaire_id`,`user_id`),
 3740   KEY `questionnaire_id` (`questionnaire_id`),
 3741   KEY `user_id` (`user_id`)
 3742 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3743 /*!40101 SET character_set_client = @saved_cs_client */;
 3744 
 3745 --
 3746 -- Table structure for table `questionnaire_answers`
 3747 --
 3748 
 3749 DROP TABLE IF EXISTS `questionnaire_answers`;
 3750 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3751 /*!40101 SET character_set_client = utf8 */;
 3752 CREATE TABLE `questionnaire_answers` (
 3753   `answer_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3754   `question_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3755   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3756   `answerdata` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3757   `chdate` bigint(20) NOT NULL,
 3758   `mkdate` bigint(20) NOT NULL,
 3759   PRIMARY KEY (`answer_id`),
 3760   KEY `question_id` (`question_id`),
 3761   KEY `user_id` (`user_id`)
 3762 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3763 /*!40101 SET character_set_client = @saved_cs_client */;
 3764 
 3765 --
 3766 -- Table structure for table `questionnaire_assignments`
 3767 --
 3768 
 3769 DROP TABLE IF EXISTS `questionnaire_assignments`;
 3770 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3771 /*!40101 SET character_set_client = utf8 */;
 3772 CREATE TABLE `questionnaire_assignments` (
 3773   `assignment_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3774   `questionnaire_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3775   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3776   `range_type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 3777   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3778   `chdate` bigint(20) NOT NULL,
 3779   `mkdate` int(11) NOT NULL,
 3780   PRIMARY KEY (`assignment_id`),
 3781   KEY `questionnaire_id` (`questionnaire_id`),
 3782   KEY `range_id_range_type` (`range_id`,`range_type`),
 3783   KEY `user_id` (`user_id`)
 3784 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3785 /*!40101 SET character_set_client = @saved_cs_client */;
 3786 
 3787 --
 3788 -- Table structure for table `questionnaire_questions`
 3789 --
 3790 
 3791 DROP TABLE IF EXISTS `questionnaire_questions`;
 3792 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3793 /*!40101 SET character_set_client = utf8 */;
 3794 CREATE TABLE `questionnaire_questions` (
 3795   `question_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3796   `questionnaire_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3797   `etask_task_id` int(11) NOT NULL,
 3798   `position` int(11) NOT NULL,
 3799   `chdate` bigint(20) NOT NULL,
 3800   `mkdate` bigint(20) NOT NULL,
 3801   PRIMARY KEY (`question_id`),
 3802   KEY `questionnaire_id` (`questionnaire_id`)
 3803 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3804 /*!40101 SET character_set_client = @saved_cs_client */;
 3805 
 3806 --
 3807 -- Table structure for table `questionnaires`
 3808 --
 3809 
 3810 DROP TABLE IF EXISTS `questionnaires`;
 3811 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3812 /*!40101 SET character_set_client = utf8 */;
 3813 CREATE TABLE `questionnaires` (
 3814   `questionnaire_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3815   `title` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
 3816   `description` text COLLATE utf8mb4_unicode_ci,
 3817   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3818   `startdate` bigint(20) DEFAULT NULL,
 3819   `stopdate` bigint(20) DEFAULT NULL,
 3820   `visible` tinyint(1) NOT NULL DEFAULT '0',
 3821   `anonymous` tinyint(1) NOT NULL DEFAULT '0',
 3822   `resultvisibility` enum('always','never','afterending') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'always',
 3823   `editanswers` tinyint(1) NOT NULL DEFAULT '1',
 3824   `copyable` tinyint(4) NOT NULL DEFAULT '0',
 3825   `chdate` bigint(20) NOT NULL,
 3826   `mkdate` bigint(20) NOT NULL,
 3827   PRIMARY KEY (`questionnaire_id`),
 3828   KEY `user_id` (`user_id`)
 3829 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3830 /*!40101 SET character_set_client = @saved_cs_client */;
 3831 
 3832 --
 3833 -- Table structure for table `range_tree`
 3834 --
 3835 
 3836 DROP TABLE IF EXISTS `range_tree`;
 3837 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3838 /*!40101 SET character_set_client = utf8 */;
 3839 CREATE TABLE `range_tree` (
 3840   `item_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3841   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3842   `level` int(11) NOT NULL DEFAULT '0',
 3843   `priority` int(11) NOT NULL DEFAULT '0',
 3844   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3845   `studip_object` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3846   `studip_object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3847   PRIMARY KEY (`item_id`),
 3848   KEY `parent_id` (`parent_id`),
 3849   KEY `priority` (`priority`),
 3850   KEY `studip_object_id` (`studip_object_id`)
 3851 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3852 /*!40101 SET character_set_client = @saved_cs_client */;
 3853 
 3854 --
 3855 -- Table structure for table `resource_booking_intervals`
 3856 --
 3857 
 3858 DROP TABLE IF EXISTS `resource_booking_intervals`;
 3859 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3860 /*!40101 SET character_set_client = utf8 */;
 3861 CREATE TABLE `resource_booking_intervals` (
 3862   `interval_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 3863   `resource_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3864   `booking_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3865   `begin` int(20) NOT NULL DEFAULT '0',
 3866   `end` int(20) NOT NULL DEFAULT '0',
 3867   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3868   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3869   `takes_place` tinyint(1) unsigned NOT NULL DEFAULT '1',
 3870   PRIMARY KEY (`interval_id`),
 3871   KEY `assign_object_id` (`booking_id`,`resource_id`),
 3872   KEY `resource_id` (`resource_id`,`takes_place`,`end`)
 3873 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3874 /*!40101 SET character_set_client = @saved_cs_client */;
 3875 
 3876 --
 3877 -- Table structure for table `resource_bookings`
 3878 --
 3879 
 3880 DROP TABLE IF EXISTS `resource_bookings`;
 3881 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3882 /*!40101 SET character_set_client = utf8 */;
 3883 CREATE TABLE `resource_bookings` (
 3884   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3885   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3886   `range_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3887   `description` text COLLATE utf8mb4_unicode_ci,
 3888   `begin` int(20) NOT NULL DEFAULT '0',
 3889   `end` int(20) NOT NULL DEFAULT '0',
 3890   `repeat_end` int(20) DEFAULT NULL,
 3891   `repeat_quantity` int(2) DEFAULT NULL,
 3892   `mkdate` int(20) NOT NULL DEFAULT '0',
 3893   `chdate` int(20) NOT NULL DEFAULT '0',
 3894   `internal_comment` text COLLATE utf8mb4_unicode_ci,
 3895   `preparation_time` int(4) NOT NULL DEFAULT '0',
 3896   `booking_type` tinyint(2) NOT NULL DEFAULT '0',
 3897   `booking_user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3898   `repetition_interval` varchar(24) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3899   PRIMARY KEY (`id`),
 3900   KEY `assign_user_id` (`range_id`),
 3901   KEY `resource_id` (`resource_id`,`booking_type`)
 3902 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3903 /*!40101 SET character_set_client = @saved_cs_client */;
 3904 
 3905 --
 3906 -- Table structure for table `resource_categories`
 3907 --
 3908 
 3909 DROP TABLE IF EXISTS `resource_categories`;
 3910 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3911 /*!40101 SET character_set_client = utf8 */;
 3912 CREATE TABLE `resource_categories` (
 3913   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3914   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3915   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3916   `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3917   `iconnr` int(3) DEFAULT '1',
 3918   `class_name` varchar(60) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'Resource',
 3919   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3920   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3921   PRIMARY KEY (`id`)
 3922 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3923 /*!40101 SET character_set_client = @saved_cs_client */;
 3924 
 3925 --
 3926 -- Table structure for table `resource_category_properties`
 3927 --
 3928 
 3929 DROP TABLE IF EXISTS `resource_category_properties`;
 3930 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3931 /*!40101 SET character_set_client = utf8 */;
 3932 CREATE TABLE `resource_category_properties` (
 3933   `category_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3934   `property_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3935   `requestable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3936   `protected` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3937   `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3938   `form_text` text COLLATE utf8mb4_unicode_ci,
 3939   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3940   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3941   PRIMARY KEY (`category_id`,`property_id`)
 3942 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3943 /*!40101 SET character_set_client = @saved_cs_client */;
 3944 
 3945 --
 3946 -- Table structure for table `resource_permissions`
 3947 --
 3948 
 3949 DROP TABLE IF EXISTS `resource_permissions`;
 3950 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3951 /*!40101 SET character_set_client = utf8 */;
 3952 CREATE TABLE `resource_permissions` (
 3953   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3954   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3955   `perms` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3956   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3957   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3958   PRIMARY KEY (`user_id`,`resource_id`),
 3959   KEY `resource_id` (`resource_id`)
 3960 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3961 /*!40101 SET character_set_client = @saved_cs_client */;
 3962 
 3963 --
 3964 -- Table structure for table `resource_properties`
 3965 --
 3966 
 3967 DROP TABLE IF EXISTS `resource_properties`;
 3968 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3969 /*!40101 SET character_set_client = utf8 */;
 3970 CREATE TABLE `resource_properties` (
 3971   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3972   `property_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3973   `state` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3974   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 3975   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 3976   PRIMARY KEY (`resource_id`,`property_id`),
 3977   KEY `property_id` (`property_id`)
 3978 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 3979 /*!40101 SET character_set_client = @saved_cs_client */;
 3980 
 3981 --
 3982 -- Table structure for table `resource_property_definitions`
 3983 --
 3984 
 3985 DROP TABLE IF EXISTS `resource_property_definitions`;
 3986 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 3987 /*!40101 SET character_set_client = utf8 */;
 3988 CREATE TABLE `resource_property_definitions` (
 3989   `property_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 3990   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3991   `description` text COLLATE utf8mb4_unicode_ci,
 3992   `type` set('bool','text','num','select','user','institute','position','fileref','url','resource_ref_list') CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 3993   `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
 3994   `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3995   `info_label` tinyint(4) NOT NULL DEFAULT '0',
 3996   `display_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 3997   `searchable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3998   `range_search` tinyint(1) unsigned NOT NULL DEFAULT '0',
 3999   `write_permission_level` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'admin-global',
 4000   `property_group_id` int(11) DEFAULT NULL,
 4001   `property_group_pos` tinyint(4) DEFAULT NULL,
 4002   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 4003   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 4004   PRIMARY KEY (`property_id`)
 4005 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4006 /*!40101 SET character_set_client = @saved_cs_client */;
 4007 
 4008 --
 4009 -- Table structure for table `resource_property_groups`
 4010 --
 4011 
 4012 DROP TABLE IF EXISTS `resource_property_groups`;
 4013 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4014 /*!40101 SET character_set_client = utf8 */;
 4015 CREATE TABLE `resource_property_groups` (
 4016   `id` int(11) NOT NULL AUTO_INCREMENT,
 4017   `name` varchar(255) NOT NULL DEFAULT '',
 4018   `position` tinyint(4) NOT NULL DEFAULT '0',
 4019   `mkdate` int(11) NOT NULL DEFAULT '0',
 4020   `chdate` int(11) NOT NULL DEFAULT '0',
 4021   PRIMARY KEY (`id`)
 4022 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
 4023 /*!40101 SET character_set_client = @saved_cs_client */;
 4024 
 4025 --
 4026 -- Table structure for table `resource_request_appointments`
 4027 --
 4028 
 4029 DROP TABLE IF EXISTS `resource_request_appointments`;
 4030 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4031 /*!40101 SET character_set_client = utf8 */;
 4032 CREATE TABLE `resource_request_appointments` (
 4033   `id` int(11) NOT NULL AUTO_INCREMENT,
 4034   `request_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4035   `appointment_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4036   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 4037   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 4038   PRIMARY KEY (`id`)
 4039 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
 4040 /*!40101 SET character_set_client = @saved_cs_client */;
 4041 
 4042 --
 4043 -- Table structure for table `resource_request_properties`
 4044 --
 4045 
 4046 DROP TABLE IF EXISTS `resource_request_properties`;
 4047 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4048 /*!40101 SET character_set_client = utf8 */;
 4049 CREATE TABLE `resource_request_properties` (
 4050   `request_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4051   `property_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4052   `state` text COLLATE utf8mb4_unicode_ci,
 4053   `mkdate` int(20) unsigned DEFAULT NULL,
 4054   `chdate` int(20) unsigned DEFAULT NULL,
 4055   PRIMARY KEY (`request_id`,`property_id`)
 4056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4057 /*!40101 SET character_set_client = @saved_cs_client */;
 4058 
 4059 --
 4060 -- Table structure for table `resource_requests`
 4061 --
 4062 
 4063 DROP TABLE IF EXISTS `resource_requests`;
 4064 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4065 /*!40101 SET character_set_client = utf8 */;
 4066 CREATE TABLE `resource_requests` (
 4067   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4068   `course_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4069   `termin_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4070   `metadate_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4071   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4072   `last_modified_by` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4073   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4074   `category_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '',
 4075   `comment` text COLLATE utf8mb4_unicode_ci,
 4076   `reply_comment` text COLLATE utf8mb4_unicode_ci,
 4077   `reply_recipients` enum('requester','lecturer') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'requester',
 4078   `closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
 4079   `mkdate` int(20) unsigned DEFAULT NULL,
 4080   `chdate` int(20) unsigned DEFAULT NULL,
 4081   `begin` int(11) unsigned NOT NULL DEFAULT '0',
 4082   `end` int(11) unsigned NOT NULL DEFAULT '0',
 4083   `preparation_time` int(4) NOT NULL DEFAULT '0',
 4084   `marked` tinyint(1) unsigned NOT NULL DEFAULT '0',
 4085   PRIMARY KEY (`id`),
 4086   KEY `termin_id` (`termin_id`),
 4087   KEY `seminar_id` (`course_id`),
 4088   KEY `user_id` (`user_id`),
 4089   KEY `resource_id` (`resource_id`),
 4090   KEY `category_id` (`category_id`),
 4091   KEY `closed` (`closed`,`id`,`resource_id`),
 4092   KEY `metadate_id` (`metadate_id`)
 4093 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4094 /*!40101 SET character_set_client = @saved_cs_client */;
 4095 
 4096 --
 4097 -- Table structure for table `resource_temporary_permissions`
 4098 --
 4099 
 4100 DROP TABLE IF EXISTS `resource_temporary_permissions`;
 4101 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4102 /*!40101 SET character_set_client = utf8 */;
 4103 CREATE TABLE `resource_temporary_permissions` (
 4104   `id` int(11) NOT NULL AUTO_INCREMENT,
 4105   `resource_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4106   `user_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4107   `begin` int(11) unsigned NOT NULL DEFAULT '0',
 4108   `end` int(11) unsigned NOT NULL DEFAULT '0',
 4109   `perms` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4110   `mkdate` int(11) unsigned NOT NULL DEFAULT '0',
 4111   `chdate` int(11) unsigned NOT NULL DEFAULT '0',
 4112   PRIMARY KEY (`id`),
 4113   KEY `user_id` (`user_id`),
 4114   KEY `resource_id` (`resource_id`)
 4115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
 4116 /*!40101 SET character_set_client = @saved_cs_client */;
 4117 
 4118 --
 4119 -- Table structure for table `resources`
 4120 --
 4121 
 4122 DROP TABLE IF EXISTS `resources`;
 4123 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4124 /*!40101 SET character_set_client = utf8 */;
 4125 CREATE TABLE `resources` (
 4126   `id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4127   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4128   `category_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4129   `level` int(4) DEFAULT NULL,
 4130   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 4131   `description` text COLLATE utf8mb4_unicode_ci,
 4132   `requestable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 4133   `mkdate` int(20) NOT NULL DEFAULT '0',
 4134   `chdate` int(20) NOT NULL DEFAULT '0',
 4135   `sort_position` tinyint(1) unsigned NOT NULL DEFAULT '0',
 4136   PRIMARY KEY (`id`),
 4137   KEY `parent_id` (`parent_id`),
 4138   KEY `category_id` (`category_id`)
 4139 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4140 /*!40101 SET character_set_client = @saved_cs_client */;
 4141 
 4142 --
 4143 -- Table structure for table `roles`
 4144 --
 4145 
 4146 DROP TABLE IF EXISTS `roles`;
 4147 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4148 /*!40101 SET character_set_client = utf8 */;
 4149 CREATE TABLE `roles` (
 4150   `roleid` int(10) unsigned NOT NULL AUTO_INCREMENT,
 4151   `rolename` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 4152   `system` enum('y','n') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT 'n',
 4153   PRIMARY KEY (`roleid`)
 4154 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4155 /*!40101 SET character_set_client = @saved_cs_client */;
 4156 
 4157 --
 4158 -- Table structure for table `roles_plugins`
 4159 --
 4160 
 4161 DROP TABLE IF EXISTS `roles_plugins`;
 4162 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4163 /*!40101 SET character_set_client = utf8 */;
 4164 CREATE TABLE `roles_plugins` (
 4165   `roleid` int(10) unsigned NOT NULL DEFAULT '0',
 4166   `pluginid` int(10) unsigned NOT NULL DEFAULT '0',
 4167   PRIMARY KEY (`roleid`,`pluginid`)
 4168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4169 /*!40101 SET character_set_client = @saved_cs_client */;
 4170 
 4171 --
 4172 -- Table structure for table `roles_studipperms`
 4173 --
 4174 
 4175 DROP TABLE IF EXISTS `roles_studipperms`;
 4176 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4177 /*!40101 SET character_set_client = utf8 */;
 4178 CREATE TABLE `roles_studipperms` (
 4179   `roleid` int(10) unsigned NOT NULL DEFAULT '0',
 4180   `permname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 4181   PRIMARY KEY (`roleid`,`permname`)
 4182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4183 /*!40101 SET character_set_client = @saved_cs_client */;
 4184 
 4185 --
 4186 -- Table structure for table `roles_user`
 4187 --
 4188 
 4189 DROP TABLE IF EXISTS `roles_user`;
 4190 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4191 /*!40101 SET character_set_client = utf8 */;
 4192 CREATE TABLE `roles_user` (
 4193   `roleid` int(10) unsigned NOT NULL DEFAULT '0',
 4194   `userid` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4195   `institut_id` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4196   PRIMARY KEY (`roleid`,`userid`,`institut_id`)
 4197 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4198 /*!40101 SET character_set_client = @saved_cs_client */;
 4199 
 4200 --
 4201 -- Table structure for table `schedule`
 4202 --
 4203 
 4204 DROP TABLE IF EXISTS `schedule`;
 4205 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4206 /*!40101 SET character_set_client = utf8 */;
 4207 CREATE TABLE `schedule` (
 4208   `id` int(11) NOT NULL AUTO_INCREMENT,
 4209   `start` smallint(6) NOT NULL COMMENT 'start hour and minutes',
 4210   `end` smallint(6) NOT NULL COMMENT 'end hour and minutes',
 4211   `day` tinyint(4) NOT NULL COMMENT 'day of week, 0-6',
 4212   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 4213   `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 4214   `color` tinyint(4) DEFAULT NULL,
 4215   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4216   PRIMARY KEY (`id`),
 4217   KEY `user_id` (`user_id`)
 4218 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4219 /*!40101 SET character_set_client = @saved_cs_client */;
 4220 
 4221 --
 4222 -- Table structure for table `schedule_seminare`
 4223 --
 4224 
 4225 DROP TABLE IF EXISTS `schedule_seminare`;
 4226 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4227 /*!40101 SET character_set_client = utf8 */;
 4228 CREATE TABLE `schedule_seminare` (
 4229   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4230   `seminar_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4231   `metadate_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4232   `visible` tinyint(1) NOT NULL DEFAULT '1',
 4233   `color` tinyint(4) DEFAULT NULL,
 4234   PRIMARY KEY (`user_id`,`seminar_id`,`metadate_id`)
 4235 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4236 /*!40101 SET character_set_client = @saved_cs_client */;
 4237 
 4238 --
 4239 -- Table structure for table `schema_versions`
 4240 --
 4241 
 4242 DROP TABLE IF EXISTS `schema_versions`;
 4243 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4244 /*!40101 SET character_set_client = utf8 */;
 4245 CREATE TABLE `schema_versions` (
 4246   `domain` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 4247   `version` bigint(20) unsigned NOT NULL,
 4248   PRIMARY KEY (`domain`,`version`)
 4249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4250 /*!40101 SET character_set_client = @saved_cs_client */;
 4251 
 4252 --
 4253 -- Table structure for table `scm`
 4254 --
 4255 
 4256 DROP TABLE IF EXISTS `scm`;
 4257 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4258 /*!40101 SET character_set_client = utf8 */;
 4259 CREATE TABLE `scm` (
 4260   `scm_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4261   `range_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4262   `user_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4263   `tab_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 4264   `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
 4265   `mkdate` int(20) NOT NULL DEFAULT '0',
 4266   `chdate` int(20) NOT NULL DEFAULT '0',
 4267   `position` int(11) unsigned NOT NULL DEFAULT '0',
 4268   PRIMARY KEY (`scm_id`),
 4269   KEY `chdate` (`chdate`),
 4270   KEY `range_id` (`range_id`)
 4271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4272 /*!40101 SET character_set_client = @saved_cs_client */;
 4273 
 4274 --
 4275 -- Table structure for table `sem_classes`
 4276 --
 4277 
 4278 DROP TABLE IF EXISTS `sem_classes`;
 4279 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4280 /*!40101 SET character_set_client = utf8 */;
 4281 CREATE TABLE `sem_classes` (
 4282   `id` int(11) NOT NULL AUTO_INCREMENT,
 4283   `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
 4284   `only_inst_user` tinyint(4) NOT NULL,
 4285   `default_read_level` int(11) NOT NULL,
 4286   `default_write_level` int(11) NOT NULL,
 4287   `bereiche` tinyint(4) NOT NULL,
 4288   `module` tinyint(4) NOT NULL,
 4289   `show_browse` tinyint(4) NOT NULL,
 4290   `write_access_nobody` tinyint(4) NOT NULL,
 4291   `topic_create_autor` tinyint(4) NOT NULL,
 4292   `visible` tinyint(4) NOT NULL,
 4293   `course_creation_forbidden` tinyint(4) NOT NULL,
 4294   `overview` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4295   `forum` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4296   `admin` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4297   `documents` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4298   `schedule` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4299   `participants` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4300   `literature` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4301   `scm` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4302   `wiki` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4303   `resources` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4304   `calendar` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4305   `elearning_interface` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4306   `modules` text COLLATE utf8mb4_unicode_ci NOT NULL,
 4307   `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 4308   `create_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 4309   `studygroup_mode` tinyint(4) NOT NULL,
 4310   `admission_prelim_default` tinyint(4) NOT NULL DEFAULT '0',
 4311   `admission_type_default` tinyint(4) NOT NULL DEFAULT '0',
 4312   `title_dozent` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4313   `title_dozent_plural` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4314   `title_tutor` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4315   `title_tutor_plural` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4316   `title_autor` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4317   `title_autor_plural` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 4318   `show_raumzeit` tinyint(4) NOT NULL DEFAULT '1',
 4319   `is_group` tinyint(1) NOT NULL DEFAULT '0',
 4320   `mkdate` bigint(20) NOT NULL,
 4321   `chdate` bigint(20) NOT NULL,
 4322   PRIMARY KEY (`id`),
 4323   UNIQUE KEY `name` (`name`)
 4324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4325 /*!40101 SET character_set_client = @saved_cs_client */;
 4326 
 4327 --
 4328 -- Table structure for table `sem_tree`
 4329 --
 4330 
 4331 DROP TABLE IF EXISTS `sem_tree`;
 4332 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4333 /*!40101 SET character_set_client = utf8 */;
 4334 CREATE TABLE `sem_tree` (
 4335   `sem_tree_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4336   `parent_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
 4337   `priority` tinyint(4) NOT NULL DEFAULT '0',
 4338   `info` text COLLATE utf8mb4_unicode_ci NOT NULL,
 4339   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
 4340   `studip_object_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 4341   `type` tinyint(3) unsigned NOT NULL,
 4342   PRIMARY KEY (`sem_tree_id`),
 4343   KEY `parent_id` (`parent_id`),
 4344   KEY `priority` (`priority`),
 4345   KEY `studip_object_id` (`studip_object_id`)
 4346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 4347 /*!40101 SET character_set_client = @saved_cs_client */;
 4348 
 4349 --
 4350 -- Table structure for table `sem_types`
 4351 --
 4352 
 4353 DROP TABLE IF EXISTS `sem_types`;
 4354 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 4355 /*!40101 SET cha