-- MySQL dump 10.13 Distrib 5.1.41, for pc-linux-gnu (i686) -- -- Host: localhost Database: simplerisk -- ------------------------------------------------------ -- Server version 5.1.41 /*!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 `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `category` ( `value` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; INSERT INTO `category` VALUES (1,'Confidentiality of Documents'),(2,'Data Security & Assurance'),(3,'Disaster Recovery & Business Continuity Management'),(4,'Information Asset Management & Control'),(5,'Network Defence & Security'),(6,'Personnel Security & Awareness'),(7,'Physical & Environmental Security'),(8,'Registration & Authentication'); /*!40000 ALTER TABLE `category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `impact` -- DROP TABLE IF EXISTS `impact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `impact` ( `name` varchar(20) NOT NULL, `value` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `impact` -- LOCK TABLES `impact` WRITE; /*!40000 ALTER TABLE `impact` DISABLE KEYS */; INSERT INTO `impact` VALUES ('Insignificant',1),('Minor',2),('Moderate',3),('Major',4),('Extreme/Catastrophic',5); /*!40000 ALTER TABLE `impact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `likelihood` -- DROP TABLE IF EXISTS `likelihood`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `likelihood` ( `name` varchar(20) NOT NULL, `value` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `likelihood` -- LOCK TABLES `likelihood` WRITE; /*!40000 ALTER TABLE `likelihood` DISABLE KEYS */; INSERT INTO `likelihood` VALUES ('Remote',1),('Unlikely',2),('Credible',3),('Likely',4),('Almost Certain',5); /*!40000 ALTER TABLE `likelihood` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mgmt_reviews` -- DROP TABLE IF EXISTS `mgmt_reviews`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mgmt_reviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `risk_id` int(11) NOT NULL, `submission_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `review` int(11) NOT NULL, `reviewer` int(11) NOT NULL, `comments` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mitigations` -- DROP TABLE IF EXISTS `mitigations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mitigations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `risk_id` int(11) NOT NULL, `submission_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `planning_strategy` int(11) NOT NULL, `current_solution` text NOT NULL, `security_requirements` text NOT NULL, `security_recommendations` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `planning_strategy` -- DROP TABLE IF EXISTS `planning_strategy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `planning_strategy` ( `value` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `planning_strategy` -- LOCK TABLES `planning_strategy` WRITE; /*!40000 ALTER TABLE `planning_strategy` DISABLE KEYS */; INSERT INTO `planning_strategy` VALUES (1,'Research'),(2,'Accept'),(3,'Mitigate'),(4,'Watch'); /*!40000 ALTER TABLE `planning_strategy` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `review` -- DROP TABLE IF EXISTS `review`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `review` ( `value` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `review` -- LOCK TABLES `review` WRITE; /*!40000 ALTER TABLE `review` DISABLE KEYS */; INSERT INTO `review` VALUES (1,'Approve Risk'),(2,'Reject Risk'); /*!40000 ALTER TABLE `review` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `risk_levels` -- DROP TABLE IF EXISTS `risk_levels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `risk_levels` ( `value` int(11) NOT NULL, `name` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `risk_levels` -- LOCK TABLES `risk_levels` WRITE; /*!40000 ALTER TABLE `risk_levels` DISABLE KEYS */; INSERT INTO `risk_levels` VALUES (15,'High'),(8,'Medium'),(4,'Low'); /*!40000 ALTER TABLE `risk_levels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `risk_lookup` -- DROP TABLE IF EXISTS `risk_lookup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `risk_lookup` ( `impact` int(11) NOT NULL, `likelihood` int(11) NOT NULL, `risk` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `risk_lookup` -- LOCK TABLES `risk_lookup` WRITE; /*!40000 ALTER TABLE `risk_lookup` DISABLE KEYS */; INSERT INTO `risk_lookup` VALUES (1,1,2),(1,2,3),(1,3,4),(1,4,5),(1,5,6),(2,1,4),(2,2,6),(2,3,8),(2,4,10),(2,5,12),(3,1,6),(3,2,9),(3,3,12),(3,4,15),(3,5,18),(4,1,8),(4,2,12),(4,3,16),(4,4,20),(4,5,24),(5,1,10),(5,2,15),(5,3,20),(5,4,25),(5,5,30); /*!40000 ALTER TABLE `risk_lookup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `risk_models` -- DROP TABLE IF EXISTS `risk_models`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `risk_models` ( `value` int(11) NOT NULL, `name` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `risk_models` -- LOCK TABLES `risk_models` WRITE; /*!40000 ALTER TABLE `risk_models` DISABLE KEYS */; INSERT INTO `risk_models` VALUES (1,'Likelihood x Impact + 2(Impact)'),(2,'Likelihood x Impact + Impact'),(3,'Likelihood x Impact'),(4,'Likelihood x Impact + Likelihood'),(5,'Likelihood x Impact + 2(Likelihood)'); /*!40000 ALTER TABLE `risk_models` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `risks` -- DROP TABLE IF EXISTS `risks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `risks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` varchar(20) NOT NULL, `subject` varchar(100) NOT NULL, `likelihood` int(11) NOT NULL, `impact` int(11) NOT NULL, `category` int(11) NOT NULL, `team` int(11) NOT NULL, `technology` int(11) NOT NULL, `owner` int(11) NOT NULL, `manager` int(11) NOT NULL, `assessment` longtext NOT NULL, `notes` longtext NOT NULL, `submission_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `review_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `mitigation_id` int(11) NOT NULL, `mgmt_review` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `name` varchar(20) NOT NULL, `value` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES ('risk_model',2),('db_version',1),('app_version',1); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team` -- DROP TABLE IF EXISTS `team`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team` ( `value` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team` -- LOCK TABLES `team` WRITE; /*!40000 ALTER TABLE `team` DISABLE KEYS */; INSERT INTO `team` VALUES (1,'Branch Management'),(2,'Collaboration'),(3,'Data Center & Storage'),(4,'Database'),(5,'Information Security'),(6,'IT Systems Management'),(7,'Network'),(8,'Unix'),(9,'Web Systems'),(10,'Windows'); /*!40000 ALTER TABLE `team` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `technology` -- DROP TABLE IF EXISTS `technology`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `technology` ( `value` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `technology` -- LOCK TABLES `technology` WRITE; /*!40000 ALTER TABLE `technology` DISABLE KEYS */; INSERT INTO `technology` VALUES (1,'All'),(2,'Anti-Virus'),(3,'Backups'),(4,'Blackberry'),(5,'Citrix'),(6,'Datacenter'),(7,'Mail Routing'),(8,'Live Collaboration'),(9,'Messaging'),(10,'Mobile'),(11,'Network'),(12,'Power'),(13,'Remote Access'),(14,'SAN'),(15,'Telecom'),(16,'Unix'),(17,'VMWare'),(18,'Web'),(19,'Windows'); /*!40000 ALTER TABLE `technology` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `value` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `name` varchar(50) NOT NULL, `password` binary(60) NOT NULL, `last_login` datetime NOT NULL, `admin` tinyint(1) NOT NULL, `review_high` tinyint(1) NOT NULL, `review_medium` tinyint(1) NOT NULL, `review_low` tinyint(1) NOT NULL, PRIMARY KEY (`value`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; /*!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 2013-03-15 14:11:09