-- MySQL dump 10.13  Distrib 5.5.35, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cgg_web
-- ------------------------------------------------------
-- Server version	5.5.35-0ubuntu0.12.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `answers`
--

DROP TABLE IF EXISTS `answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `answers` (
  `qid` int(11) DEFAULT NULL,
  `ans_bullet` varchar(10) DEFAULT NULL,
  `textis` varchar(250) DEFAULT NULL,
  `correct` int(11) DEFAULT NULL,
  `ans25` varchar(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `answers`
--

LOCK TABLES `answers` WRITE;
/*!40000 ALTER TABLE `answers` DISABLE KEYS */;
INSERT INTO `answers` VALUES (1,'a','Investment in energy efficiency',1,NULL),(1,'b','Create more work opportunities for electricians',NULL,NULL),(1,'c','Force businesses to upgrade to LED lighting',NULL,NULL),(3,'a','Energy retailers',1,NULL),(3,'b','The Government',NULL,NULL),(3,'c','The ACP',NULL,NULL),(4,'a','Original Energy Saver (OES)',NULL,NULL),(4,'b','The energy retailer',NULL,NULL),(4,'c','Accredited Certificates Provider (ACP)',1,NULL),(5,'a','The hours of operation of an entity',1,NULL),(5,'b','The areas accepted by the scheme',NULL,NULL),(5,'c','Where the building is located',NULL,NULL),(6,'a','Air Conditioning',NULL,NULL),(6,'b','Motion Sensor',NULL,NULL),(6,'c','Daylight Sensor',NULL,NULL),(6,'d','All of the above',1,NULL),(7,'a','CO2 Free',1,NULL),(7,'b','Carbon Blue',NULL,NULL),(7,'c','Carbon Green Group',NULL,NULL),(8,'a','IPART',1,NULL),(8,'b','ESS',NULL,NULL),(8,'c','The Government',NULL,NULL),(9,'a','Yes, if they fail to meet their requirements as an ACP',1,NULL),(9,'b','No, they have no liability',NULL,NULL),(10,'a','Original Energy Saver',1,NULL),(10,'b','Operating Energy Saver',NULL,NULL),(10,'c','Original Energy Specialist',NULL,NULL),(11,'a','No, globes can be recycled anywhere. The only requirement is that they get disposed of',NULL,NULL),(11,'b','Yes, all globes must be recycled at an accredited lamp recycler',1,NULL),(12,'a','Geo-Tagging marked at the location of the project',1,NULL),(12,'b','All items must be included in each photo (ie. Globes and ballasts together)',NULL,NULL),(12,'c','Must have business in background of photo',NULL,NULL),(13,'a','Six - (existing in situ, existing lamp wattage, existing ballast/control gear, upgrade in situ, upgrade model number, upgrade driver model number (if independent and not integrated).',1,NULL),(13,'b','Five - (existing in situ, existing lamp wattage, exisiting ballast/control gear, upgrade in situ, upgrade model number)',NULL,NULL),(13,'c','Geo-tagged photos are not required',NULL,NULL),(14,'a','Only lamps that have been tested and approved by IPART/ESS',1,NULL),(14,'b','All LED lights are suitable',NULL,NULL),(14,'c','Only lights approved by the customer',NULL,NULL),(15,'a','ESS Product Search online',1,NULL),(15,'b','IPART website',NULL,NULL),(15,'c','Approved lights are not a requirement',NULL,NULL),(16,'a','Colour temp',NULL,NULL),(16,'b','The model number',1,NULL),(16,'c','Wattage',NULL,NULL),(17,'a','$5 per ESC',1,NULL),(17,'b','There is no minimum cost',NULL,NULL),(17,'c','$10 per ESC',NULL,NULL),(18,'a','Tax Invoice',NULL,NULL),(18,'b','CCEW & Installer Declaration',1,NULL),(18,'c','Nomination Form',NULL,NULL),(19,'a','Yes (certificate should state lamp fittings and ballasts)',1,NULL),(19,'b','No, only proof of lamp recycling is required',NULL,NULL),(20,'a','It provides evidence of the location of all existing and upgraded lighting, which the auditor will use for verification during a site visit.',1,NULL),(20,'b','It proves that the lighting upgrade took place',NULL,NULL),(21,'a','Legend showing luminaire model number, ballast type/model number',NULL,NULL),(21,'b','Quantity of existing and upgraded lighting',NULL,NULL),(21,'c','Nominal Lamp Power (NLP) and Lamp Circuit Power (LCP)',NULL,NULL),(21,'d','All of the above',1,NULL),(22,'a','We are required to keep a record of the LUX readings for each site but no LUX level requirements',NULL,NULL),(22,'b','They let the customer know that there is enough light in the area',NULL,NULL),(22,'c','There are legislative requirements around minimum LUX levels as per AS1680 and BCA codes',1,NULL),(23,'a','1 meter',1,NULL),(23,'b','2 meters',NULL,NULL),(23,'c','There is no distance requirement',NULL,NULL),(24,'a','At night',1,NULL),(24,'b','During the day',NULL,NULL),(24,'c','It doesn\'t matter',NULL,NULL),(25,'a','9 meters squared (equates 9 individual readings)',1,NULL),(25,'b','10 meters squared (equates 10 individual readings)',NULL,NULL),(25,'c','11 meters squared (equates 11 individual readings)',NULL,NULL),(2,'a','By reducing the energy usage',1,NULL),(2,'b','By putting up new lights',NULL,NULL),(2,'c','By buying new lights (they don\'t need to be put up)',NULL,NULL);
/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `exam`
--

DROP TABLE IF EXISTS `exam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exam` (
  `username` varchar(250) DEFAULT NULL,
  `datesubmitted` datetime DEFAULT NULL,
  `ans1` varchar(2) DEFAULT NULL,
  `ans2` varchar(2) DEFAULT NULL,
  `ans3` varchar(2) DEFAULT NULL,
  `ans4` varchar(2) DEFAULT NULL,
  `ans5` varchar(2) DEFAULT NULL,
  `ans6` varchar(2) DEFAULT NULL,
  `ans7` varchar(2) DEFAULT NULL,
  `ans8` varchar(2) DEFAULT NULL,
  `ans9` varchar(2) DEFAULT NULL,
  `ans10` varchar(2) DEFAULT NULL,
  `ans11` varchar(2) DEFAULT NULL,
  `ans12` varchar(2) DEFAULT NULL,
  `ans13` varchar(2) DEFAULT NULL,
  `ans14` varchar(2) DEFAULT NULL,
  `ans15` varchar(2) DEFAULT NULL,
  `ans16` varchar(2) DEFAULT NULL,
  `ans17` varchar(2) DEFAULT NULL,
  `ans18` varchar(2) DEFAULT NULL,
  `ans19` varchar(2) DEFAULT NULL,
  `ans20` varchar(2) DEFAULT NULL,
  `ans21` varchar(2) DEFAULT NULL,
  `ans22` varchar(2) DEFAULT NULL,
  `ans23` varchar(2) DEFAULT NULL,
  `ans24` varchar(2) DEFAULT NULL,
  `ans25` varchar(2) DEFAULT NULL,
  `initialcode` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `exam`
--

LOCK TABLES `exam` WRITE;
/*!40000 ALTER TABLE `exam` DISABLE KEYS */;
INSERT INTO `exam` VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9XvVIxjHNzzDxtP9SrlnYi8w2ccorh6AfCwY9QGWpfAXJq6CSsZQL7nOkAcLRim7VS54IL180C5K2cmUFmKru8fOIs'),(NULL,NULL,'a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tAbc9LJ6TPtKuQ1xLL46IELrxVR3uWQXx19GNTNHIhrd7tLSeQZWuKo2Fg5acW7JYhqLadtTuU7CoSvCIuzdeYfTel'),(NULL,NULL,'a','a','a','c','a','d','a','a','a','a','b','a','a','a','b','b','a','b','a','a','d','a','a','a','a','gta2XZnSlVAxTqZVvUlWak36tIfwaL9qfkscjQ4FLEcF5cBB6XxhhBnLjDhuprVELoQ4eVJ0zWGF8hgfeOwwpUhJxy'),(NULL,NULL,'a','a','a','c','a','d','a','a','a','a','b','a','a','a','a','b','a','b','a','a','d','c','a','a','a','SiWCVvZzlSTR6GfQXP0dd0Fg8Hh3KnICGEfBaebw74neLC4Is5VG5BWejeh3BZGiEWTOa5ki9IxUlCDNHytNaq1tEi'),(NULL,NULL,'a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','an56caarKTyWhDxDjvx4fEkwluAJD11Oo6VAg6200BXhfuUy0sCf6XMrrmb5ocUMiPnyWqzW1weh19Q2BthIq4aSrl'),(NULL,NULL,'a','a','a','c','a','d','a','a','a','a','b','a','a','a','a','b','a','b','a','a','d','c','a','a','a','2CORrXUrXjnvMsvT2K8slD9UUow26Wg8y5003Vr0eOw1h1UkM3M7GV1AkyDquUz3ZA43vw3KkAMCCHWoKIvqEx1Z5F'),(NULL,NULL,'a','a','a','c','a','d','a','a','a','a','b','a','a','a','a','c','a','b','a','a','d','c','a','a','a','Wwf5JWJbNxvlJCjnuGflbsUFiPybREDNaTSTQB4D8AYSchfHYu29XWPfLnrD15rcYk5PWas5KqXXIcEGHHQEEFUp3m'),(NULL,NULL,'a','a','a','c','a','d','a','a','a','a','b','a','a','a','a','b','a','b','a','a','d','c','a','a','a','ZLGnV5iHkrhlcWv000Jo9S1DBtrccaibVYzR3RyoiPJvLfvMgfap7b3JFvWRFe3AdCrguZFMPpiBEOnU4ykbKoUpTQ');
/*!40000 ALTER TABLE `exam` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questions`
--

DROP TABLE IF EXISTS `questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questions` (
  `qid` int(11) DEFAULT NULL,
  `textis` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questions`
--

LOCK TABLES `questions` WRITE;
/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
INSERT INTO `questions` VALUES (1,'What is the ESS designed to encourage?'),(2,'How are Energy Savings Certificates created?'),(3,'Who is responsible for purchasing the Energy Savings Certificates?'),(4,'What entity is authorised to produce ESC\'s?'),(5,'What do we use the building classification to determine?'),(6,'What is an example of a multiplier?'),(7,'What is the name of the ACP used by Carbon Blue?'),(8,'Who is the scheme administered by?'),(9,'Can CO2 Free\'s license as an ACP be revoked?'),(10,'What does OES stand for?'),(11,'Are there any special requirements for recycling globes?'),(12,'What is a requirement for all photos to have for evidence in audit?'),(13,'Up to how many geo-tagged photos are required for every different light fitting type upgraded?'),(14,'What types of luminaires can be used for upgrades and claim credits under the ESS?'),(15,'Where can you search to see if a light is approved?'),(16,'What must you have a photo of from both the lamp and the driver (if not integrated)?'),(17,'What is the minimum cost that must be paid by the OES?'),(18,'What is the name of the document(s) that a contractor is required to sign upon completion of each project?'),(19,'Other than lamp recycling, is a certificate required from a metal recycler or tip to verify luminaire destruction? '),(20,'What is the purpose of lighting diagrams?'),(21,'In addition to showing the location of both existing and upgraded lighting, what else must be shown on every lighting diagram?'),(22,'Why are LUX readings important?'),(23,'How far apart should LUX measurements be taken?'),(24,'What is the best time to take LUX measurements?'),(25,'For spaces greater than 25m2 the area must be at least how many metres squared?');
/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-05-16 21:54:01
