anchor.diff:  /*!40101 SET character_set_client = utf8 */;
   CREATE TABLE `collection_type` (
     `collection_id` varchar(255) NOT NULL DEFAULT '',
  -  `type_id` int(11) NOT NULL DEFAULT '0',
  -  PRIMARY KEY (`collection_id`,`type_id`),
  -  KEY `type_id` (`type_id`),
  -  CONSTRAINT `collection_type_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `samplecollection` (`id`),
  -  CONSTRAINT `collection_type_ibfk_2` FOREIGN KEY (`type_id`) REFERENCES `COLLECTION_TYPES` (`id`)
  +  `type` varchar(128) NOT NULL,
  +  PRIMARY KEY (`collection_id`,`type`),
  +  CONSTRAINT `collection_type_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `SAMPLECOLLECTIONS` (`id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   /*!40101 SET character_set_client = @saved_cs_client */;
   
  
positive.code: /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `COLLECTION_TYPES`
  --
  
  DROP TABLE IF EXISTS `COLLECTION_TYPES`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `COLLECTION_TYPES` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `definition` varchar(2000) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `Env_vars`
  --
  
  DROP TABLE IF EXISTS `Env_vars`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Env_vars` (
    `name` varchar(128) NOT NULL,
    `value` varchar(1024) DEFAULT NULL,
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  
negative.code: ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `Yubikey`
  --
  
  DROP TABLE IF EXISTS `Yubikey`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Yubikey` (
    `yubidnum` varchar(45) NOT NULL,
    `serial` varchar(10) DEFAULT NULL,
    `version` varchar(15) DEFAULT NULL,
    `active` tinyint(1) DEFAULT NULL,
    `notes` varchar(100) DEFAULT NULL,
    `counter` int(11) DEFAULT NULL,
    `low` int(11) DEFAULT NULL,
    `high` int(11) DEFAULT NULL,
    `session_use` int(11) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `aes_secret` varchar(100) DEFAULT NULL,
    `public_id` varchar(40) DEFAULT NULL,
    `People_uid` int(10) DEFAULT NULL,
    PRIMARY KEY (`yubidnum`),
    KEY `fk_Yubikey_People_idx` (`People_uid`),
    CONSTRAINT `fk_Yubikey_People1` FOREIGN KEY (`People_uid`) REFERENCES `People` (`uid`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `activity`
  