Updates for sha comparisons

database/edugain_schema.sql

 -- MySQL dump 10.14  Distrib 5.5.68-MariaDB, for Linux (x86_64)
 --
--- Host: localhost    Database: edugain_twoln
+-- Host: localhost    Database: edugain
 -- ------------------------------------------------------
 -- Server version	5.5.68-MariaDB
 
@@ -51,7 +51,7 @@ CREATE TABLE `cert` (
   PRIMARY KEY (`id`),
   KEY `sha1` (`sha1`),
   KEY `sha256` (`sha256`)
-) ENGINE=MyISAM AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -104,7 +104,7 @@ CREATE TABLE `entities` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `entityid` (`entityid`),
   KEY `regauth` (`regauth`)
-) ENGINE=MyISAM AUTO_INCREMENT=39362 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=100804 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -136,7 +136,7 @@ CREATE TABLE `entities_status` (
   `rands_cnt` smallint(6) DEFAULT NULL,
   `sirtfi2_idp_cnt` smallint(6) DEFAULT NULL,
   `sirtfi2_sp_cnt` smallint(6) DEFAULT NULL,
-  `sirtfi2_cnt` smallint(6) DEFAULT NULL
+  `sirtfi2_cnt` smallint(6) DEFAULT NULL,
   `coco2_idp_cnt` smallint(6) DEFAULT NULL,
   `coco2_sp_cnt` smallint(6) DEFAULT NULL,
   `coco2_cnt` smallint(6) DEFAULT NULL,
@@ -203,7 +203,7 @@ CREATE TABLE `entity_contactperson` (
   `subtypeschema` char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
   `subtype` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=105013 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=434399 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -415,7 +415,7 @@ CREATE TABLE `entity_roles` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `entity_id` (`entity_id`,`roledesc`),
   KEY `roledesc` (`roledesc`)
-) ENGINE=MyISAM AUTO_INCREMENT=57738 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=174137 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -479,7 +479,7 @@ CREATE TABLE `entityattributes_dict` (
   `short` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`,`value`)
-) ENGINE=MyISAM AUTO_INCREMENT=205 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -494,7 +494,7 @@ CREATE TABLE `entitywarnings_dict` (
   `message` char(255) COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `message` (`message`)
-) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -724,7 +724,7 @@ CREATE TABLE `person` (
   `role` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
   `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1991 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=2015 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -806,6 +806,21 @@ CREATE TABLE `security_contact` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `temporary_entity_sha1`
+--
+
+DROP TABLE IF EXISTS `temporary_entity_sha1`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `temporary_entity_sha1` (
+  `entityid` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+  `sha1` char(50) COLLATE utf8_unicode_ci NOT NULL,
+  `modtime` datetime DEFAULT NULL,
+  UNIQUE KEY `entityid` (`entityid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Final view structure for view `federation_v`
 --
@@ -834,4 +849,4 @@ CREATE TABLE `security_contact` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-07-25 21:24:58
+-- Dump completed on 2024-02-16 11:39:51