   KEY `fk_ssm_2_idx` (`ss_id`),
   CONSTRAINT `fk_ssm_1` FOREIGN KEY (`c_id`) REFERENCES `crisis` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT `fk_ssm_2` FOREIGN KEY (`ss_id`) REFERENCES `ss` (`ss_id`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-10-31 17:28:14


LOCK TABLES `crisis` WRITE;
/*!40000 ALTER TABLE `crisis` DISABLE KEYS */;
INSERT INTO `crisis` VALUES (1,'both','ALERT: Authorised Termination rates are at 0. Rectify immediately! This information is classified GREEN.'),(2,'both','Beloved Citizens! The contract for transtube maintenance is up for tender today! Please monitor the situation and decide on the best service group to maintain the tubes. Contract is clearance ORANGE.'),(3,'both','Alert! RD Project ##SUB## has gone missing from location databanks. Find and recover immediately. ##SUB## is classified INDIGO.'),(4,'both','Citizens! ##CIT-V-TR## is due for erasure later today. Make sure their name is purged from all databanks before their public erasure.'),(5,'both','Citizens! RD Project ##SUB## has been escalated. Please decide on a plan of action. ##SUB## is classified GREEN.'),(6,'both','Citizens! Oversee the installation of RD Project ##SUB##. ##SUB## is clearance INDIGO.'),(7,'straight','Citizens! A Communist superweapon has been deployed around the Complex. Decide on course of action. This information is classified GREEN.'),(8,'both','Citizens! Compliance Index falling at unacceptable rate. Please identify cause and rectify. This information is classified YELLOW.'),(9,'both','ALERT! Major traffic disturbances detected in Transtube ##ZON##-##SUB##. Rectify situation and decide who is responsible for damages.'),(10,'straight','Alert! Information has surfaced that a major terrorist attack is to take place this daycycle. Prevent this attack at all costs. Information classified BLUE.'),(11,'both','Citizens! ##ZON## reactor ##SUB## is ready to go online. Please use this opportunity to raise morale across the sector.'),(12,'both','Alert! Enemy invasion force at edge of sector! Identify and eliminate immediately!'),(13,'classic','Alert! Large flooding occuring on subbasements 15-28 at location ##SUB##. Identify and fix source of flooding immediately.'),(14,'both','Alert! Hygiene in ##ZON## at record low levels! Identify areas for improvement and fix immediately! Information classified YELLOW.'),(15,'both','The popular Hero of our Complex ##CIT-B-1##-3 has been found guilty of communist sympathising. Organise their erasure without damaging morale.'),(16,'both','Alert! IntSec item 214-##SUB## is currently missing. Find and recover this item. 214-##SUB## is classified VIOLET.'),(17,'both','Alert! ##CIT-V-1## holding out against commie force in the MuchoMeat plant. Rescue and recover ##CIT-V-1## unharmed.'),(18,'both','Citizens! RD Project ##SUB## is complete and ready for deployment. Test ##SUB## with a suitable project. Projects must be approved by concesus.WANTON BROTH is classified INDIGO.'),(19,'both','Error. Code 1789. Additional processing power required. Please find space for and construct additional processing CompNodes to bring the total up from 8 to 20.'),(20,'both','Alert! Information has surfaced that a major terrorist attack is to take place this daycycle. Prevent this attack at all costs. Information classified BLUE.'),(21,'both','Assertion Error. Testing [DELETED FOR SECURITY REASONS]. Statement: Communism is good for citizens. Legalise Communism. This information classified ULTRAVIOLET.'),(22,'both','Alert! Citizen Vicky-B must me made to disappear this daycycle. Organise while keeping up her public appearances and career. This issue classified VIOLET.'),(23,'both','Citizens! A Communist superweapon has been deployed around the Complex. Decide on course of action. This information is classified GREEN.'),(24,'both','Assertion Error. Testing [DELETED FOR SECURITY REASONS]. Citizens! Organise a mock Communist attack to assess the sector\'s prepardness. Until the exercise is complete, situation is classified INDIGO.'),(25,'both','Alert! Citizen ##CIT-V## was detained by agents of Beta Complex on their last mission. Negotiate with ##CIT-U## of Beta Complex and return ##CIT-V## to us. Situation classified BLUE.'),(26,'both','Alert! Paperwork Quota down 84%! Hygiene down 29%! Analyze and remediate situation!'),(27,'both','Citizens! A Communist superweapon has been deployed around the Complex. Decide on course of action. This information is classified GREEN.'),(28,'both','Alert! Citizen Danny-V-SNH has gone missing and has information vital to the fight against Communism! Recover and interrogate! Situation classified BLUE!'),(29,'both','Alert! Testing [DELETED FOR SECURITY REASONS]! Sector is overpopulated by 12%. Balance the population by the end of the daycycle.'),(30,'both','Citizens! The Teela-O Show is being broadcast live from the MegaMall in an hourcycle. Please ensure it is not interrupted.'),(31,'both','Citizens! We have lost contact with neighbouring GRB sector! Determine the cause and reintegrate the sector to the complex.'),(32,'both','ALERT: Authorised Termination rates are at 0. Rectify immediately! This information is classified GREEN.'),(33,'both','Congratulations Citizens! You have been picked for INSERT PROJECT HERE! Please decide amongst yourself accordingly.'),(34,'both','Alert! Project ##SUB## has gone missing! Find and recover immediately! Project ##SUB## is classified INDIGO.'),(35,'both','Alert! Information has surfaced that a major terrorist attack is to take place this daycycle. Prevent this attack at all costs. Information classified BLUE.'),(36,'both','Alert! Project ##SUB## has gone missing! Find and recover immediately! Project ##SUB## is classified INDIGO.'),(37,'both','Citizens! There is a large budget for an ambitious, sector shaping project! Each of you will develop an initial project plan to be selected later.'),(38,'both','Citizens! Lenin-##ZON## has been sighted in the sector! Hunt down and contain this threat.'),(39,'both','Citizens! Today you have the opportunity to hold an Initialday Party for Citizen Right-U-ARE! Please fulfill their requests as ably as possible.'),(40,'both','Citizens! Compliance Index falling at unacceptable rate. Please identify cause and rectify. This information is classified YELLOW.'),(41,'both','*No Announcement*'),(42,'both','Alert! Recover scoutbot ##SUB-0## from the outdoors. Scoutbot ##SUB-0## contains UV clearance information. Scoutbot ##SUB-0## is classified BLUE.'),(43,'both','High Programmer Right-U-ARE has promised sweeping changes to the complex! Make them happen!'),(44,'both','Citizens! As part of the war on communism, we are prioritising citizen happiness! Raise citizen happiness!'),(45,'both','Alert! 6% of population missing! Probability of major terrorist attack rising! Threat level elevated! Situation classified YELLOW!'),(46,'both','Citizens! You have the honor of capitulating to the gentle request of pre-empting the vidshow programming for the next few hourcycles!'),(47,'both','Alert! Communists attacking! Repel the invasion!'),(48,'both','Alert! CCSSII at 241%! Coup probability at 81%! Reduce or level one purge will be initiated in two hourcycles!'),(49,'both','Alert! Accident on transbot line ##SUB-1##. Investigate and rectify.'),(50,'both','Citizens! Major shortage of ##RES-1##! Estimated sector shutdown in 150 minutecycles!'),(51,'both','Citizens! Congratulations on accepting 1.810 million citizens from the sector [DELETED]! Please make sure the sector can support them!');
/*!40000 ALTER TABLE `crisis` ENABLE KEYS */;
UNLOCK TABLES;

