text: 
  --
  -- Table structure for table `Users`
  --
  
  DROP TABLE IF EXISTS `Users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `Users` (
    `id` int(6) NOT NULL AUTO_INCREMENT,
    `credentials_version` int(11) NOT NULL DEFAULT '0',
    `username` varchar(60) CHARACTER SET utf8 NOT NULL,
    `email` varchar(100) CHARACTER SET latin1 NOT NULL,
    `picture` text CHARACTER SET latin1 DEFAULT NULL,
    `salt` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
    `hashedpw` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
    `level` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
    `count` int(11) NOT NULL DEFAULT '0',
    `group` varchar(4096) CHARACTER SET latin1 DEFAULT NULL,
    `used_key` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
    `public_key` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
    `private_key` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
    `credited` int(11) DEFAULT NULL,
    `all_keys` varchar(14000) CHARACTER SET latin1 DEFAULT NULL,
    `mobile_auth_key` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
    `follows` text CHARACTER SET latin1,
    `blocks` text CHARACTER SET latin1,
    `credits` int(11) NOT NULL DEFAULT '0',
    `access` text CHARACTER SET latin1,
    `interested` text CHARACTER SET latin1,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `realm` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
    `password` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
    `emailVerified` int(1) DEFAULT NULL,
    `verificationToken` varchar(120) CHARACTER SET latin1 DEFAULT NULL,
    `settings` json DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `email` (`email`),
    UNIQUE KEY `username_UNIQUE` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `access_levels`
  --
  
  DROP TABLE IF EXISTS `access_levels`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `access_levels` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `value` varchar(100) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `band_aliases`
  --
  
  DROP TABLE IF EXISTS `band_aliases`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `band_aliases` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `band` int(11) NOT NULL,
    `alias` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `user` int(11) NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `alias_UNIQUE` (`alias`)
  ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `band_list`
  --
  
  DROP TABLE IF EXISTS `band_list`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `band_list` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `festival` int(11) NOT NULL,
    `festival_series` int(11) DEFAULT NULL,
    `band` int(11) NOT NULL,
    `priority` int(11) NOT NULL DEFAULT '3',
    `unscheduled` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6079 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `band_list_speculative`
  --
  
  DROP TABLE IF EXISTS `band_list_speculative`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `band_list_speculative` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `festival` int(11) NOT NULL,
    `festival_series` int(11) NOT NULL,
    `band` int(11) NOT NULL,
    `priority` int(11) NOT NULL,
    `user` int(11) NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `festival_2` (`festival`,`band`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `band_priorities`
  --
  
  DROP TABLE IF EXISTS `band_priorities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `band_priorities` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `name` text NOT NULL,
    `level` int(11) NOT NULL,
    `description` text NOT NULL,
    `default` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `level` (`level`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `bandgenres`
  --
  
  DROP TABLE IF EXISTS `bandgenres`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `bandgenres` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `band` int(11) NOT NULL,
    `genre` int(11) NOT NULL,
    `user` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1098 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `bands`
  --
  
  DROP TABLE IF EXISTS `bands`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `bands` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) CHARACTER SET utf8 NOT NULL,
    `festivals` varchar(8096) CHARACTER SET latin1 DEFAULT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `deleted` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4820 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `dates`
  --
  
  DROP TABLE IF EXISTS `dates`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `dates` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `festival` int(11) NOT NULL,
    `user` int(11) NOT NULL,
    `festival_series` int(11) DEFAULT NULL,
    `name` varchar(30) NOT NULL,
    `venue` int(11) NOT NULL,
    `basedate` date NOT NULL,
    `mode` int(11) DEFAULT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `dates_2` (`festival`,`venue`,`basedate`)
  ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `days`
  --
  
  DROP TABLE IF EXISTS `days`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `days` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `date` int(11) NOT NULL,
    `festival` int(11) DEFAULT NULL,
    `festival_series` int(11) DEFAULT NULL,
    `name` varchar(25) NOT NULL,
    `days_offset` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `fest_modes`
  --
  
  DROP TABLE IF EXISTS `fest_modes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `fest_modes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) NOT NULL,
    `timestmp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `festival_monitor`
  --
  
  DROP TABLE IF EXISTS `festival_monitor`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `festival_monitor` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `festival` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `phptime` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `festival_series`
  --
  
  DROP TABLE IF EXISTS `festival_series`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `festival_series` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `name` text COLLATE utf8_unicode_ci NOT NULL,
    `description` text COLLATE utf8_unicode_ci NOT NULL,
    `website` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `hiatus` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `festivals`
  --
  
  DROP TABLE IF EXISTS `festivals`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `festivals` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `year` varchar(4) NOT NULL,
    `language` varchar(50) NOT NULL DEFAULT 'English',
    `series` int(11) NOT NULL,
    `organizer` int(11) DEFAULT NULL,
    `creator` int(11) NOT NULL,
    `cost` int(11) DEFAULT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `deleted` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `year` (`year`,`series`)
  ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `festtypes`
  --
  
  DROP TABLE IF EXISTS `festtypes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `festtypes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(30) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `flag_status`
  --
  
  DROP TABLE IF EXISTS `flag_status`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `flag_status` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) CHARACTER SET utf8 NOT NULL,
    `description` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `flag_types`
  --
  
  DROP TABLE IF EXISTS `flag_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `flag_types` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
    `description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `flags`
  --
  
  DROP TABLE IF EXISTS `flags`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `flags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fromuser` int(11) NOT NULL,
    `subject` int(11) NOT NULL,
    `subject_type` int(11) NOT NULL,
    `flag_type` int(11) NOT NULL,
    `content` text CHARACTER SET utf8mb4,
    `response` text COLLATE utf8_unicode_ci,
    `status` int(11) NOT NULL DEFAULT '1',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `only_once` (`fromuser`,`subject`,`subject_type`,`flag_type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `genre_parents`
  --
  
  DROP TABLE IF EXISTS `genre_parents`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `genre_parents` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `genre` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `genre_2` (`genre`),
    KEY `genre` (`genre`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `genres`
  --
  
  DROP TABLE IF EXISTS `genres`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `genres` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `parent` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `images`
  --
  
  DROP TABLE IF EXISTS `images`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `images` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '	',
    `subject_type` int(11) NOT NULL,
    `subject` int(11) NOT NULL,
    `url` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `title` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `source_url` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `author` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `license` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `license_url` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `user` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `intentions`
  --
  
  DROP TABLE IF EXISTS `intentions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `intentions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `user` int(11) NOT NULL,
    `subject_type` int(11) NOT NULL,
    `subject` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `intent` (`user`,`subject_type`,`subject`)
  ) ENGINE=InnoDB AUTO_INCREMENT=393 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `interaction_types`
  --
  
  DROP TABLE IF EXISTS `interaction_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `interaction_types` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) NOT NULL,
    `description` varchar(500) DEFAULT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `interactions`
  --
  
  DROP TABLE IF EXISTS `interactions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `interactions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `type` int(11) NOT NULL,
    `subject_type` int(11) NOT NULL,
    `subject` int(11) NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=378 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `message_types`
  --
  
  DROP TABLE IF EXISTS `message_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `message_types` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) NOT NULL,
    `description` varchar(500) NOT NULL,
    `center` int(11) DEFAULT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `messages`
  --
  
  DROP TABLE IF EXISTS `messages`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `messages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fromuser` int(11) NOT NULL,
    `touser` int(11) NOT NULL DEFAULT '-1',
    `subject` int(11) NOT NULL,
    `subject_type` int(11) NOT NULL,
    `message_type` int(11) NOT NULL,
    `base_message` int(11) DEFAULT NULL,
    `content` text CHARACTER SET utf8mb4 NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `festival` (`fromuser`,`touser`),
    KEY `subject_type` (`subject_type`,`subject`,`message_type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6918 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `messages_monitor`
  --
  
  DROP TABLE IF EXISTS `messages_monitor`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `messages_monitor` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `user` int(11) NOT NULL,
    `message` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=772 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `messages_privacy`
  --
  
  DROP TABLE IF EXISTS `messages_privacy`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `messages_privacy` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` text NOT NULL,
    `description` text NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `messages_private`
  --
  
  DROP TABLE IF EXISTS `messages_private`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `messages_private` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fromuser` int(11) NOT NULL,
    `touser` int(11) NOT NULL,
    `subject` text NOT NULL,
    `content` text NOT NULL,
    `javaTime` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `organizers`
  --
  
  DROP TABLE IF EXISTS `organizers`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `organizers` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `places`
  --
  
  DROP TABLE IF EXISTS `places`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `places` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `festival` int(11) NOT NULL,
    `festival_series` int(11) DEFAULT NULL,
    `type` int(11) NOT NULL,
    `name` varchar(100) NOT NULL,
    `priority` int(11) NOT NULL DEFAULT '1',
    `user` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `layout` int(11) DEFAULT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `subject` int(11) DEFAULT NULL,
    `subject_type` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  /*!50003 SET character_set_client  = utf8 */ ;
  /*!50003 SET character_set_results = utf8 */ ;
  /*!50003 SET collation_connection  = utf8_general_ci */ ;
  /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  /*!50003 SET sql_mode              = 'NO_ENGINE_SUBSTITUTION' */ ;
  
  /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  /*!50003 SET character_set_client  = @saved_cs_client */ ;
  /*!50003 SET character_set_results = @saved_cs_results */ ;
  /*!50003 SET collation_connection  = @saved_col_connection */ ;
  
  --
  -- Table structure for table `placetypes`
  --
  
  DROP TABLE IF EXISTS `placetypes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `placetypes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Temporary view structure for view `related_events`
  --
  
  DROP TABLE IF EXISTS `related_events`;
  /*!50001 DROP VIEW IF EXISTS `related_events`*/;
  SET @saved_cs_client     = @@character_set_client;
  /*!50503 SET character_set_client = utf8mb4 */;
  /*!50001 CREATE VIEW `related_events` AS SELECT 
   1 AS `series`,
   1 AS `festival`,
   1 AS `date`,
   1 AS `day`,
   1 AS `set`*/;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Table structure for table `sets`
  --
  
  DROP TABLE IF EXISTS `sets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `sets` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `band` int(11) NOT NULL,
    `day` int(11) NOT NULL,
    `stage` int(11) DEFAULT NULL,
    `start` int(11) DEFAULT NULL,
    `end` int(11) DEFAULT NULL,
    `user` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) DEFAULT '0',
    `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `DayStage` (`day`,`stage`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5554 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `stage_layouts`
  --
  
  DROP TABLE IF EXISTS `stage_layouts`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `stage_layouts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `image` mediumblob NOT NULL,
    `filename` text NOT NULL,
    `description` text NOT NULL,
    `user` int(11) NOT NULL,
    `type` text NOT NULL,
    `default` int(11) NOT NULL DEFAULT '0',
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `stage_priorities`
  --
  
  DROP TABLE IF EXISTS `stage_priorities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `stage_priorities` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `name` text NOT NULL,
    `level` int(11) NOT NULL,
    `description` text NOT NULL,
    `default` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `subject_types`
  --
  
  DROP TABLE IF EXISTS `subject_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `subject_types` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(25) NOT NULL,
    `event` int(1) NOT NULL DEFAULT '0',
    `description` varchar(500) NOT NULL,
    `center` int(11) DEFAULT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `tracker_users`
  --
  
  DROP TABLE IF EXISTS `tracker_users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `tracker_users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `javaTime` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `user_aliases`
  --
  
  DROP TABLE IF EXISTS `user_aliases`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_aliases` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `user` int(11) NOT NULL,
    `alias` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `alias_UNIQUE` (`alias`)
  ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `user_setting`
  --
  
  DROP TABLE IF EXISTS `user_setting`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_setting` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `description` varchar(100) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `user_setting_current`
  --
  
  DROP TABLE IF EXISTS `user_setting_current`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_setting_current` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `user_setting` int(11) NOT NULL,
    `value` int(11) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `user` (`user`,`user_setting`)
  ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `user_setting_value`
  --
  
  DROP TABLE IF EXISTS `user_setting_value`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_setting_value` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_setting` int(11) NOT NULL,
    `item` varchar(255) NOT NULL,
    `value` varchar(255) NOT NULL,
    `deleted` int(11) NOT NULL,
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `venues`
  --
  
  DROP TABLE IF EXISTS `venues`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `venues` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `name` text NOT NULL,
    `description` text NOT NULL,
    `timezone` varchar(50) NOT NULL,
    `country` varchar(50) NOT NULL,
    `state` varchar(50) NOT NULL,
    `city` varchar(100) NOT NULL,
    `street_address` text NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
  
  