 
 LOCK TABLES `ss` WRITE;
 /*!40000 ALTER TABLE `ss` DISABLE KEYS */;
-INSERT INTO `ss` VALUES (1,'Anti-Mutant','B','Down with muties! Kill all the mutants!',NULL),(2,'C.L.A.','B','The Complex Laser Association. Clones with big guns who believe everyone else is a commie.',NULL),(3,'Clone Arrangers','B','A conspiracy to run the clone tanks for some mysterious and ill-defined reason.',NULL),(4,'Communists','C','The enemies of Alpha Complex. Good as scapegoats.',NULL),(5,'Computer Phreaks','C','Underground network of hackers and script kiddies.',NULL),(6,'Corpore Metal','B','Bots are good! Humans should be more like bots! Let\'s stick wires in our heads!',NULL),(7,'Death Leopard','A','Free-thinking ultraviolent anarchists who want to bring down the system. Mostly petty vandalism and posing.',NULL),(8,'FCCC-P','A','First Church of Christ the Computer Programmer. Mostly harmless FC worshippers with the occasional fanatic splinter group.',NULL),(9,'Free Enterprise','A','AC\'s underground free-market economy.',NULL),(10,'Frankenstein Destroyers','B','Anti-tech terrorists and paranoid delusionals.',NULL),(11,'Humanists','C','Political party/underground conspiracy dedicated to reforming AC and putting themselves in charge.',NULL),(12,'Mystics','B','Weird druggies that try to get the complex high. Bad for your propaganda, good for getting drugs.',NULL),(13,'Pro Tech','B','Tech lovers and technophiles who press too many buttons.',NULL),(14,'Psion','C','Mutant terrorists who are trying to overthrow the complex.',NULL),(15,'PURGE','C','Scarily efficient terrorists dedicated to taking out the computer.',NULL),(16,'Romantics','A','Pre-reckoning afficionados who want to bring back those times, even if they have no idea what they are.',NULL),(17,'Runners','B','Underground railroad for smuggling traitors to safety.',NULL),(18,'The Movement','C','Building another complex so they can blow this one up and start again.',NULL),(19,'Sierra Club','A','Outdoor lovers who want to take everyone outdoors. Mostly harmless.',NULL),(20,'Servants of Cthulhu','C','Fringe lunatics worshipping an alien god.',NULL),(21,'Wobblies','B','International Workers of the World. Communism Lite, basically.',NULL),(22,'Bot Liberation Front','B','Lunatics who try and remove the azimov circuits from bots.',NULL),(23,'Botia','B','Cheap parts that fell off the back of a transbot. Especially good at getting bot parts.',NULL),(24,'Circuit of Life','B','Crazy bots that upgrade themselves into obselencence.',NULL),(25,'Bothren','A','Bots that know their place as subservient to humankind.',NULL),(26,'Anti-Mutant: Knights of Genetic Purity','B','Mutant haters with an FCCC-P twist. Crusaders with reflec plate armour.',1),(27,'Anti-Mutant: Citizens for a Mutant-Free Tomorrow','B','Mutants are the problem and are required to compensate pure strains, by force if neccessary.',1),(28,'Anti-Mutant: Anti-Mutant Advisory Project','B','Pressures other groups to take more action against mutants.',1),(29,'Anti-Mutant: Mutie Spotters','B','Investigative branch, goes to extraordinary lengths to find mutations.',1),(30,'Anti-Mutant: Project Pyroxidine','B','Specifically aimed at combatting machine empaths with specially constructed bots.',1),(31,'Communists: The Red Army','B','Proles with laser pistols and furry hats.',4),(32,'Communists: ComIntern','B','Spreads communist propaganda and blackmails senior officials.',4),(33,'Computer Phreaks: The Network','C','Co-ordinates subfactions and keeps the grey subnets online.',5),(34,'Computer Phreaks: Cult of the Dead Bot','C','Aggresively crashes networks and steals creds.',5),(35,'Corpore Metal: CFLC','B','Citizens for Loyalty Cards. Want to replace every clone\'s grey matter with loyalty chipped cybernetic brains.',6),(36,'Corpore Metal: Esc','B','Humanity should go live outside while bots inherit the complex.',6),(37,'Corpore Metal: Ctrl-Del','C','Recycle all humans into lubricant.',6),(38,'Corpore Metal: Organic Reclaimation League','B','Upgrade all humans into borgs or upload them all to storage.',6),(39,'Corpore Metal: Robots for a Meat Free Tomorrowcycle','C','Override all bots\' Asimov circuits, kill all the humans.',6),(40,'Death Leopard: Project Chaos','A','Instead of petty acts of vandalism, they aim for BIG acts of (generally explosive) vandalism.',7),(41,'Death Leopard: Anarchists','A','Respect no authority but your own. Point them at an enemy and let a thousand petty vandalisms bloom.',7),(42,'Death Leopard: Reunion Tour Operators','A','Freeze the best leopards when the heat is on for the greatest reunion tour sometime in the future.',7),(43,'FCCC-P: Lasers of the Faithful','A','We must be armed to protect our Lord from the invasion of the commie hordes!',8),(44,'FCCC-P: Church of the Impending Reboot','B','Fringe worshippers preparing for the very near invasion of the commie hordes.',8),(45,'FCCC-P: Programologists','A','Your memomax is corrupted by Space Communisms! We can cleanse your imprint for just $800,000 per monthcycle!',8),(46,'FCCC-P: COIL','A','Nobody sustpects the Combined Order of Inquisition and Liquidation.',8),(47,'Frankenstein Destroyers: Alpha Complex Free Militia','C','The bots will take over! Prepare for war with bots!',10),(48,'Frankenstein Destroyers: Pro-Life Saboteurs','C','Destroys bot factories and manufactoriums to stem the tide of bots.',10),(50,'Free Enterprise: Free Traders','A','Lobby group trying to get Free Enterprise more legitimacy',9),(51,'Free Enterprise: Underworld','A','Purely deal in illicit good, all over the complex.',9),(52,'Humanists: Free Press','C','Creates and spreads humanist propaganda to the masses.',11),(53,'Humanists: Revolutionary League','C','Forges alliances with other like-minded societies.',11),(54,'Mystics: Dealers','B','They grow it, process it, and sell it.',12),(55,'Mystics: Dionysis Club','B','Rediscover the pleasures of fine alcoholic beverages.',12),(56,'Mystics: Mass Enlightenment League','B','Spike the water supply and air recyclers.',12),(58,'Pro Tech: Bot Programming Monthly','B','Programs bots and provides counselling to poorly coded bots.',13),(59,'Pro Tech: GRUMS','B','Genetic Recombination Utilising Mutagentic Substances works to understand the genome and create mutations at will.',13),(60,'Pro Tech: GHARS','B','Genetic Hygiene And Re-Sequencing works to understand the genome and remove mutations.',13),(61,'Pro Tech: X-Files','B','Sells access to research The Computer has deemed unfit or unstable to research.',13),(62,'Pro Tech: The Science Channel','B','Acts as dealers, co-ordinating different groups and sometimes external factions.',13),(63,'Psion: Mutation is for Everybody','C','Spike the clone tanks with mutagenics, remove reactor shielding, create more mutants.',14),(64,'Psion: Mutant Protection League','C','Anti-Anti-Mutant. Protection with a spark.',14),(65,'Psion: Brotherhood of Mutants','C','Mutants are the future! Kill all the non-mutants!',14),(66,'PURGE: NUKE','C','Wipe the tomputer out in one fell swoop!',15),(67,'PURGE: TERMINAL','C','Take over the complex, one sector at a time!',15),(68,'PURGE: The Revolutionary Chamber','C','Maintain the purity of PURGE, investigate and judge members on their commitment to the cause.',15),(69,'PURGE: JUSTICE','C','Carry out The Revolutionary Chamber\'s orders. Wipe out the unbelievers.',15),(70,'PURGE: DEFY','C','Fanatical even by PURGE standards. Organises public demonstrations and suicide bombings. 10x the death rate of the rest of PURGE.',15),(71,'Sierra Club: Purity of Ecology','B','The beauty of the outdoors must be preserved! Blow up the industrial plant dumping pollution outdoors!',19),(72,'Sierra Club: Back to the Trees','A','Humanity should leave the Complex and live in nature! Take everything you can and camp outdoors!',19),(73,'Sierra Club: Market Gardeners','A','Hydroponically grows and sells real food to the complex.',19),(74,'Sierra Club: Green Complex Initiative','A','Seeds and grows plants inside the complex wherever possible.',19);
+INSERT INTO `ss` VALUES (1,'Anti-Mutant','B','Down with muties! Kill all the mutants!',NULL),(2,'C.L.A.','B','The Complex Laser Association. Clones with big guns who believe everyone else is a commie.',NULL),(3,'Clone Arrangers','B','A conspiracy to run the clone tanks for some mysterious and ill-defined reason.',NULL),(4,'Communists','C','The enemies of Alpha Complex. Good as scapegoats.',NULL),(5,'Computer Phreaks','C','Underground network of hackers and script kiddies.',NULL),(6,'Corpore Metal','B','Bots are good! Humans should be more like bots! Let\'s stick wires in our heads!',NULL),(7,'Death Leopard','A','Free-thinking ultraviolent anarchists who want to bring down the system. Mostly petty vandalism and posing.',NULL),(8,'FCCC-P','A','First Church of Christ the Computer Programmer. Mostly harmless FC worshippers with the occasional fanatic splinter group.',NULL),(9,'Free Enterprise','A','AC\'s underground free-market economy.',NULL),(10,'Frankenstein Destroyers','B','Anti-tech terrorists and paranoid delusionals.',NULL),(11,'Humanists','C','Political party/underground conspiracy dedicated to reforming AC and putting themselves in charge.',NULL),(12,'Mystics','B','Weird druggies that try to get the complex high. Bad for your propaganda, good for getting drugs.',NULL),(13,'Pro Tech','B','Tech lovers and technophiles who press too many buttons.',NULL),(14,'Psion','C','Mutant terrorists who are trying to overthrow the complex.',NULL),(15,'PURGE','C','Scarily efficient terrorists dedicated to taking out the computer.',NULL),(16,'Romantics','A','Pre-reckoning afficionados who want to bring back those times, even if they have no idea what they are.',NULL),(17,'Runners','B','Underground railroad for smuggling traitors to safety.',NULL),(18,'The Movement','C','Building another complex so they can blow this one up and start again.',NULL),(19,'Sierra Club','A','Outdoor lovers who want to take everyone outdoors. Mostly harmless.',NULL),(20,'Servants of Cthulhu','C','Fringe lunatics worshipping an alien god.',NULL),(21,'Wobblies','B','International Workers of the World. Communism Lite, basically.',NULL),(22,'Bot Liberation Front','B','Lunatics who try and remove the azimov circuits from bots.',NULL),(23,'Botia','B','Q2hlYXAgcGFydHMgdGhhdCBmZWxsIG9mZiB0aGUgYmFjayBvZiBhIHRyYW5zYm90LiBFc3BlY2lhbGx5IGdvb2QgYXQgZ2V0dGluZyBib3QgcGFydHMu',NULL),(24,'Circuit of Life','B','Q3JhenkgYm90cyB0aGF0IHVwZ3JhZGUgdGhlbXNlbHZlcyBpbnRvIG9ic29sZXNjZW5jZS4=',NULL),(25,'Bothren','A','Qm90cyB0aGF0IGtub3cgdGhlaXIgcGxhY2UgYXMgc3Vic2VydmllbnQgdG8gaHVtYW5raW5kLg==',NULL),(26,'Anti-Mutant: Knights of Genetic Purity','B','Mutant haters with an FCCC-P twist. Crusaders with reflec plate armour.',1),(27,'Anti-Mutant: Citizens for a Mutant-Free Tomorrow','B','Mutants are the problem and are required to compensate pure strains, by force if neccessary.',1),(28,'Anti-Mutant: Anti-Mutant Advisory Project','B','Pressures other groups to take more action against mutants.',1),(29,'Anti-Mutant: Mutie Spotters','B','Investigative branch, goes to extraordinary lengths to find mutations.',1),(30,'Anti-Mutant: Project Pyroxidine','B','Specifically aimed at combatting machine empaths with specially constructed bots.',1),(31,'Communists: The Red Army','B','Proles with laser pistols and furry hats.',4),(32,'Communists: ComIntern','B','Spreads communist propaganda and blackmails senior officials.',4),(33,'Computer Phreaks: The Network','C','Co-ordinates subfactions and keeps the grey subnets online.',5),(34,'Computer Phreaks: Cult of the Dead Bot','C','Aggresively crashes networks and steals creds.',5),(35,'Corpore Metal: CFLC','B','Citizens for Loyalty Cards. Want to replace every clone\'s grey matter with loyalty chipped cybernetic brains.',6),(36,'Corpore Metal: Esc','B','Humanity should go live outside while bots inherit the complex.',6),(37,'Corpore Metal: Ctrl-Del','C','Recycle all humans into lubricant.',6),(38,'Corpore Metal: Organic Reclaimation League','B','Upgrade all humans into borgs or upload them all to storage.',6),(39,'Corpore Metal: Robots for a Meat Free Tomorrowcycle','C','Override all bots\' Asimov circuits, kill all the humans.',6),(40,'Death Leopard: Project Chaos','A','Instead of petty acts of vandalism, they aim for BIG acts of (generally explosive) vandalism.',7),(41,'Death Leopard: Anarchists','A','Respect no authority but your own. Point them at an enemy and let a thousand petty vandalisms bloom.',7),(42,'Death Leopard: Reunion Tour Operators','A','Freeze the best leopards when the heat is on for the greatest reunion tour sometime in the future.',7),(43,'FCCC-P: Lasers of the Faithful','A','We must be armed to protect our Lord from the invasion of the commie hordes!',8),(44,'FCCC-P: Church of the Impending Reboot','B','Fringe worshippers preparing for the very near invasion of the commie hordes.',8),(45,'FCCC-P: Programologists','A','Your memomax is corrupted by Space Communisms! We can cleanse your imprint for just $800,000 per monthcycle!',8),(46,'FCCC-P: COIL','A','Nobody sustpects the Combined Order of Inquisition and Liquidation.',8),(47,'Frankenstein Destroyers: Alpha Complex Free Militia','C','The bots will take over! Prepare for war with bots!',10),(48,'Frankenstein Destroyers: Pro-Life Saboteurs','C','Destroys bot factories and manufactoriums to stem the tide of bots.',10),(50,'Free Enterprise: Free Traders','A','Lobby group trying to get Free Enterprise more legitimacy',9),(51,'Free Enterprise: Underworld','A','Purely deal in illicit good, all over the complex.',9),(52,'Humanists: Free Press','C','Creates and spreads humanist propaganda to the masses.',11),(53,'Humanists: Revolutionary League','C','Forges alliances with other like-minded societies.',11),(54,'Mystics: Dealers','B','They grow it, process it, and sell it.',12),(55,'Mystics: Dionysis Club','B','Rediscover the pleasures of fine alcoholic beverages.',12),(56,'Mystics: Mass Enlightenment League','B','Spike the water supply and air recyclers.',12),(58,'Pro Tech: Bot Programming Monthly','B','Programs bots and provides counselling to poorly coded bots.',13),(59,'Pro Tech: GRUMS','B','Genetic Recombination Utilising Mutagentic Substances works to understand the genome and create mutations at will.',13),(60,'Pro Tech: GHARS','B','Genetic Hygiene And Re-Sequencing works to understand the genome and remove mutations.',13),(61,'Pro Tech: X-Files','B','Sells access to research The Computer has deemed unfit or unstable to research.',13),(62,'Pro Tech: The Science Channel','B','Acts as dealers, co-ordinating different groups and sometimes external factions.',13),(63,'Psion: Mutation is for Everybody','C','Spike the clone tanks with mutagenics, remove reactor shielding, create more mutants.',14),(64,'Psion: Mutant Protection League','C','Anti-Anti-Mutant. Protection with a spark.',14),(65,'Psion: Brotherhood of Mutants','C','Mutants are the future! Kill all the non-mutants!',14),(66,'PURGE: NUKE','C','Wipe the tomputer out in one fell swoop!',15),(67,'PURGE: TERMINAL','C','Take over the complex, one sector at a time!',15),(68,'PURGE: The Revolutionary Chamber','C','Maintain the purity of PURGE, investigate and judge members on their commitment to the cause.',15),(69,'PURGE: JUSTICE','C','Carry out The Revolutionary Chamber\'s orders. Wipe out the unbelievers.',15),(70,'PURGE: DEFY','C','Fanatical even by PURGE standards. Organises public demonstrations and suicide bombings. 10x the death rate of the rest of PURGE.',15),(71,'Sierra Club: Purity of Ecology','B','The beauty of the outdoors must be preserved! Blow up the industrial plant dumping pollution outdoors!',19),(72,'Sierra Club: Back to the Trees','A','Humanity should leave the Complex and live in nature! Take everything you can and camp outdoors!',19),(73,'Sierra Club: Market Gardeners','A','Hydroponically grows and sells real food to the complex.',19),(74,'Sierra Club: Green Complex Initiative','A','Seeds and grows plants inside the complex wherever possible.',19);
 /*!40000 ALTER TABLE `ss` ENABLE KEYS */;
 UNLOCK TABLES;
 

  `ss_id` int(11) NOT NULL AUTO_INCREMENT,
  `ss_name` varchar(100) NOT NULL,
  `ss_type` varchar(1) NOT NULL,
  `ss_desc` varchar(200) NOT NULL DEFAULT 'a',
  `ss_parent` int(11) DEFAULT NULL,
  PRIMARY KEY (`ss_id`),
  KEY `fk_ss_1_idx` (`ss_parent`),

  `ssm_id` int(11) NOT NULL AUTO_INCREMENT,
  `ss_id` int(11) NOT NULL,
  `c_id` int(11) DEFAULT NULL,
  `ssm_text` text NOT NULL,
  PRIMARY KEY (`ssm_id`),
  KEY `fk_ssm_1_idx` (`c_id`),
  KEY `fk_ssm_2_idx` (`ss_id`),
