text: -- Adminer 4.2.1 MySQL dump
  
  SET NAMES utf8;
  SET time_zone = '+00:00';
  SET foreign_key_checks = 0;
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  DROP TABLE IF EXISTS `challenges`;
  CREATE TABLE `challenges` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` text NOT NULL,
    `description` text NOT NULL,
    `score` int(11) NOT NULL,
    `key` text NOT NULL,
    `group` int(11) NOT NULL,
    `groupid` int(11) DEFAULT NULL,
    `locked` tinyint(1) NOT NULL,
    `hidden` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  
  DROP TABLE IF EXISTS `codes`;
  CREATE TABLE `codes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `value` text NOT NULL,
    `school` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  
  DROP TABLE IF EXISTS `solves`;
  CREATE TABLE `solves` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `team` int(11) NOT NULL,
    `challenge` int(11) NOT NULL,
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `additional` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `team` (`team`,`challenge`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  
  DROP TABLE IF EXISTS `teams`;
  CREATE TABLE `teams` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` text NOT NULL,
    `score` int(11) NOT NULL,
    `registration` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `password` text NOT NULL,
    `email` text NOT NULL,
    `school` text NOT NULL,
    `ip` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  
  DROP TABLE IF EXISTS `var`;
  CREATE TABLE `var` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` text NOT NULL,
    `value` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  INSERT INTO `var` (`id`, `name`, `value`) VALUES
  (1,	'state',	6);
  
  -- 2016-01-31 16:51:22