-- --------------------------------------------------------
-- Host:                         10.1.96.10
-- Server version:               5.5.58-0+deb7u1 - (Debian)
-- Server OS:                    debian-linux-gnu
-- HeidiSQL Version:             12.0.0.6468
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table spacenode.app_tests
CREATE TABLE IF NOT EXISTS `app_tests` (
  `test_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `test_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `test_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_subtitle` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_instructions` text COLLATE utf8mb4_unicode_ci,
  `access_group` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_group_unit` tinyint(3) unsigned DEFAULT NULL,
  `pass_rate` tinyint(3) unsigned NOT NULL DEFAULT '100',
  `pass_course` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pass_groups` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pass_message` text COLLATE utf8mb4_unicode_ci,
  `fail_groups` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fail_message` text COLLATE utf8mb4_unicode_ci,
  `fail_show_results` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `date_added` datetime DEFAULT NULL,
  PRIMARY KEY (`test_id`),
  UNIQUE KEY `Index 2` (`test_code`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table spacenode.app_tests: ~73 rows (approximately)
INSERT INTO `app_tests` (`test_id`, `test_code`, `test_name`, `test_subtitle`, `image_url`, `test_instructions`, `access_group`, `access_group_unit`, `pass_rate`, `pass_course`, `pass_groups`, `pass_message`, `fail_groups`, `fail_message`, `fail_show_results`, `date_added`) VALUES
	(5, 'mef5', 'Modern Energy Foundation - Course Unit 5', 'MSM Modern Stress Management', '/images/logos/GoE%20Modern%20Energy%20Foundation%20-%20444w.jpg', '<ul class=\'dc-buttons\' style=\'max-width: 400px;\'>\r\n<li><a href=\'/media/ModernEnergyFoundation5\' target=\'_new\'>📺 Watch Course Unit</a></li>\r\n</ul>', 'AMT - Student - Modern Energy Foundation', 5, 100, 'modern_energy_foundation', NULL, '<P>Congratulations on passing <strong>GoE Modern Energy Foundation</strong>! 🎉</P>\r\n\r\n<p>We have emailed you your certificate for printing at home.</p>\r\n\r\n<!--  <p>We also have an optional enhanced certification package available for you including:</p>\r\n\r\n<ul class=\'dc-ticks\'>\r\n  <li>Printing and shipping your certificate to you</li>\r\n  <li>An additional three months GoE Standard Membership</li>\r\n</ul>\r\n\r\n<p>The certification fee is <strong>£24.97 GBP</strong> and online payment details are here:</p>\r\n\r\n<ul class=\'dc-buttons\'>\r\n<li><a href=\'/payment?amount=24.97&item_name=Modern%20Energy%20Foundation%20Certification%20Package\'>🛒 Payment Details - £24.97 GBP</a></li>\r\n</ul>\r\n\r\n-->\r\n\r\n', NULL, NULL, 1, '2018-10-05 16:46:18');
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;