   KEY `index_c` (`c_id`),
   CONSTRAINT `fk_sgm_1` FOREIGN KEY (`c_id`) REFERENCES `crisis` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT `fk_sgm_2` FOREIGN KEY (`sg_id`) REFERENCES `sg` (`sg_id`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

  PRIMARY KEY (`ct_id`),
  KEY `fk_crisis_text_1_idx` (`c_id`),
  CONSTRAINT `fk_crisis_text_1` FOREIGN KEY (`c_id`) REFERENCES `crisis` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--


LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'Sector lottery jackpots to 7.2 million credits!',NULL),(2,'Alpha Complex Space Agency landing declared hoax! Execution of agency head ##CIT-I-RD## scheduled for 6.',NULL),(3,'Borders to neighbouring sectors found lacking. ##CIT-I-IS##: \"It\'s like any old RED could get through, they will be fortified!\"',NULL),(4,'New craze \"planking\" declared waste of time and treasonous.',NULL),(5,'There was no shuddering of Alpha Complex. Alpha Complex is as stable as ever. Those who believe otherwise are encouraged to contact IntSec.',NULL),(6,'Survey on pronunciation of \"gif\" complete. 100% of respondents say soft-g. In unrelated news, terminations doubled yesterday.',NULL),(7,'##CIT-V-TR##\'s show trial and erasure due for 80:00 SCT todaycycle!',4),(8,'Painkiller RadicalMankey classified treasonous due to unintended side effects.',4),(9,'New CPU manager sends 800 staff to the re-employment office.',1),(10,'Alternative Power Firm Strike-Me-Not reports a 3000% increase in power generation this daycycle!',7),(11,'The new Petbot 214 released today, sells out in minutes!',8),(12,'CPU reports the air per person index has risen 4% in the last month!',9),(13,'Sold-out UltraSuperMegaBowl funball game between USS Patriots and MBB Ballers live todaycycle on Channel 5!',10),(14,'Power forecast: rolling brownouts down by 28%, blackouts down 41%.',6),(15,'A new reactor to be completed today! Citizens rejoice!',11),(16,'Serve your Complex! Battle the Commie Threat! Bonus Hot Fun! Enlist Today!',12),(17,'Friendly Ollie-U saves sector YRU yet again! Citizens Rejoice!',NULL),(18,'ChocolateLyke ration for INFRAREDs increased yet again! ##CIT-I-PL##: \"Once again, the war on production is won!\"',NULL),(19,'Frank-U destroys fifteen communist strongholds, says end in sight for war on terror.',NULL),(20,'Terrorist bomb unlawfully terminates 180 clones, IntSec urges terrorists to hand themselves over before it becomes erasable.',NULL),(21,'Water rations to be decreased 30% due to increased B3 usage.',13),(22,'New dirt indexer bots promise faster hygiene index response times!',14),(23,'Secret Society activity up 12%. Register your society affiliation today for bonus hot fun!',NULL),(24,'Hero Of Our Complex ##CIT-B-1## completes fourth successful tour of duty!',15),(25,'Bright Vision Reducation Centres announce the opening of a new location due to increasing needs!',16),(26,'Rolling blackout centred on RIO sector hit early this morning, productivity hit of 3.81%.',17),(27,'New proposal being investigated to outlaw sleep to raise efficiency.',NULL),(28,'##ZON## funball team under investigation for poor performance. ##CIT-I-IS##: \"No-one but a commie could perform so badly\".',NULL),(29,'##ZON## Splasheroony fun park boasts record attendence!',NULL),(30,'Friend Computer processing delay set to decrease in the next few weekcycles.',19),(31,'The Hatred Day Parade, live tonight at 8000SCT!',21),(32,'Vicky-B credited with her eleventh HOOC award!',22),(33,'Alternative Power Firm Strike-Me-Not reports a 3000% increase in power generation this daycycle!',23),(34,'Underplex reclaim up 4.8% yearcycle on yearcycle.',NULL),(35,'Bouncy Bubble Beverage increases artificial sweetener content to 81.4%',NULL),(36,'FizzWizz updates its recipe, now with extra Fizz!',NULL),(37,'Defence system update goes smoothly, minimal wrongful terminations.',NULL),(38,'Do we really need so much paperwork? Of course we do! Report at 11.',26),(39,'Alternative Power Firm Strike-Me-Not reports a 3000% increase in power generation this daycycle!',27),(40,'News of Danny-V-SNH\'s glorious return are, as usual, treason until proven otherwise.',28),(41,'A lonely citizen is a treasonous citizen!',29),(42,'Political orthodoxy down 2 points weekcycle on weekcycle.',NULL),(43,'c-bay breaks into ULTRAVIOLET market, announces record profits.',NULL),(44,'Cost of toilet paper rises 5000%, bidets installed in all public restroom blocks.',NULL),(45,'Hygiene standard updated to specify a two sock minimum.',NULL),(46,'The Teela-O Show goes live this daycycle! Record viewership projected!',30),(47,'Eugenics United announces new program for combatting Spontaneous Mutation Syndrome.',31),(48,'New CPU manager sends 800 staff to the re-employment office.',32),(49,'Professor Jack-I-SDR-4 rejects predecessor\'s Communist sympathies, says Communism just doesn\'t work.',NULL),(50,'Citizen <<DELETED>> found guilty of leading \"free love\" ring, all members were without hormone stabilisers.',NULL),(51,'Corporate war between ChocolateLyke and Choc-O-Not comes to a head, 284 terminated in fighting.',NULL),(52,'Happy Homecoming Automated Euthenasia Centre increases service from BLUE to ULTRAVIOLET.',33),(53,'PLC firm \"Straight Forward Solutions\" announces their straightest lasers yet!',NULL);
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

