   `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `endTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
   `teacherId` bigint(20) UNSIGNED NOT NULL,
-  `type` enum('Private','Public') NOT NULL,
+  `visibility` enum('Private','Public') NOT NULL,
   `userCanExit` tinyint(1) NOT NULL DEFAULT '0',
   `judge` tinytext NOT NULL,
   `problems_list` mediumtext NOT NULL,
-  `requiredRating` mediumint(8) UNSIGNED NOT NULL,
-  `citedScore` smallint(5) UNSIGNED NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 

-- Структура таблиці `spm_supported_languages`
--
-- Створення: Лип 06 2018 р., 08:14
-- Останнє оновлення: Лип 30 2018 р., 19:56
--

DROP TABLE IF EXISTS `spm_supported_languages`;

  `id` bigint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sessionId` text CHARACTER SET utf8 COLLATE utf8_bin,
  `last_online` datetime NOT NULL DEFAULT '2001-07-27 10:30:00',
  `password` tinytext NOT NULL,
  `firstname` tinytext NOT NULL,
  `secondname` tinytext NOT NULL,
