Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
  • fixing_docker
  • psnc-production
  • twoln-dev
  • v2.6.5.3
  • v2.6.5.2
  • v2.6.5
  • v2.6.4
  • v2.6.3
  • v2.6.2
  • v2.6.1
  • v2.5.4
  • v2.5.3
  • v2.6.0
  • v2.5.2
  • v2.5.1
  • v2.5.0
17 results
Blame Permalink
edugain_schema.sql 32.92 KiB 
-- MySQL dump 10.14  Distrib 5.5.68-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: edugain
-- ------------------------------------------------------
-- Server version	5.5.68-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `attribute`
--

DROP TABLE IF EXISTS `attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `oid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `urn` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_FA7AEFFB5E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cert`
--

DROP TABLE IF EXISTS `cert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` blob,
  `sha1` char(255) COLLATE utf8_unicode_ci NOT NULL,
  `sha256` char(255) COLLATE utf8_unicode_ci NOT NULL,
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sha1` (`sha1`),
  KEY `sha256` (`sha256`)
) ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `coco_stat`
--

DROP TABLE IF EXISTS `coco_stat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coco_stat` (
  `entityid` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT '0',
  `msg` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coco_id` int(11) DEFAULT NULL,
  UNIQUE KEY `entityid` (`entityid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `eccs_stat`
--

DROP TABLE IF EXISTS `eccs_stat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eccs_stat` (
  `entityid` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `update_date` DATE DEFAULT NULL,,
  UNIQUE KEY `entityid` (`entityid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entities`
--

DROP TABLE IF EXISTS `entities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entityid` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `regauth` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `reginstant` datetime DEFAULT NULL,
  `entity` mediumblob,
  `entity_txt` mediumblob,
  `sha1` char(50) COLLATE utf8_unicode_ci NOT NULL,
  `modified` tinyint(4) DEFAULT NULL,
  `modtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entityid` (`entityid`),
  KEY `regauth` (`regauth`)
) ENGINE=MyISAM AUTO_INCREMENT=100804 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entities_status`
--

DROP TABLE IF EXISTS `entities_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entities_status` (
  `all_cnt` smallint(6) NOT NULL,
  `idp_cnt` smallint(6) NOT NULL,
  `sp_cnt` smallint(6) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `aa_cnt` smallint(6) DEFAULT NULL,
  `onlyaa_cnt` smallint(6) DEFAULT NULL,
  `r_cnt` smallint(6) DEFAULT NULL,
  `scopes_cnt` smallint(6) DEFAULT NULL,
  `coco_idp_cnt` smallint(6) DEFAULT NULL,
  `coco_sp_cnt` smallint(6) DEFAULT NULL,
  `rands_idp_cnt` smallint(6) DEFAULT NULL,
  `rands_sp_cnt` smallint(6) DEFAULT NULL,
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sirtfi_idp_cnt` smallint(6) DEFAULT NULL,
  `sirtfi_sp_cnt` smallint(6) DEFAULT NULL,
  `sirtfi_cnt` smallint(6) DEFAULT NULL,
  `hfd_cnt` smallint(6) DEFAULT NULL,
  `coco_cnt` smallint(6) DEFAULT NULL,
  `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,
  `coco2_idp_cnt` smallint(6) DEFAULT NULL,
  `coco2_sp_cnt` smallint(6) DEFAULT NULL,
  `coco2_cnt` smallint(6) DEFAULT NULL,
  `esi_idp_cnt` smallint(6) DEFAULT NULL,
  `esi_sp_cnt` smallint(6) DEFAULT NULL,
  `esi_cnt` smallint(6) DEFAULT NULL,
  `anon_idp_cnt` smallint(6) DEFAULT NULL,
  `anon_sp_cnt` smallint(6) DEFAULT NULL,
  `anon_cnt` smallint(6) DEFAULT NULL,
  `pseudo_idp_cnt` smallint(6) DEFAULT NULL,
  `pseudo_sp_cnt` smallint(6) DEFAULT NULL,
  `pseudo_cnt` smallint(6) DEFAULT NULL,
  `person_idp_cnt` smallint(6) DEFAULT NULL,
  `person_sp_cnt` smallint(6) DEFAULT NULL,
  `person_cnt` smallint(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_attributes`
--

DROP TABLE IF EXISTS `entity_attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_attributes` (
  `entity_id` int(11) NOT NULL,
  `entityattributes_dict_id` int(11) NOT NULL,
  UNIQUE KEY `entity_id` (`entity_id`,`entityattributes_dict_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_certs`
--

DROP TABLE IF EXISTS `entity_certs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_certs` (
  `entityrole_id` int(11) NOT NULL,
  `keylen` int(5) NOT NULL,
  `selfsigned` tinyint(1) NOT NULL,
  `type` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `sha256` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `expiry` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_contactperson`
--

DROP TABLE IF EXISTS `entity_contactperson`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_contactperson` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `type` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `givenname` char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `surname` char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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=434399 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_contactperson_c`
--

DROP TABLE IF EXISTS `entity_contactperson_c`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_contactperson_c` (
  `contact_id` int(11) NOT NULL,
  `type` char(30) COLLATE utf8_unicode_ci NOT NULL,
  `value` char(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `contact_id` (`contact_id`,`type`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_details`
--

DROP TABLE IF EXISTS `entity_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_details` (
  `entity_id` int(11) DEFAULT NULL,
  `displayname` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_cat` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roles` tinyint(4) DEFAULT NULL,
  `saml2_support` tinyint(4) DEFAULT '0',
  `eccs_status` int(1) DEFAULT '0',
  `eccs_status_date` DATE DEFAULT NULL,
  `validator_status` bigint(20) DEFAULT NULL,
  `clash` int(1) DEFAULT '0',
  `coco_status` int(1) DEFAULT NULL,
  `coco_id` int(11) DEFAULT NULL,
  `sirtfi` int(4) DEFAULT '0',
  `sirtfi2` int(4) DEFAULT '0',
  UNIQUE KEY `entity_id` (`entity_id`),
  KEY `roles` (`roles`),
  KEY `entity_id_2` (`entity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_duplication`
--

DROP TABLE IF EXISTS `entity_duplication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_duplication` (
  `entity_id` int(11) NOT NULL,
  `code` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`entity_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_fulltext_index`
--

DROP TABLE IF EXISTS `entity_fulltext_index`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_fulltext_index` (
  `entity_id` int(11) DEFAULT NULL,
  `txt` varchar(20000) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `entity_id` (`entity_id`),
  FULLTEXT KEY `txt` (`txt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_history`
--

DROP TABLE IF EXISTS `entity_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_history` (
  `entityid` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `first_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tmp_status` int(1) DEFAULT '0',
  UNIQUE KEY `entityid` (`entityid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_info`
--

DROP TABLE IF EXISTS `entity_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_info` (
  `entityrole_id` int(11) NOT NULL,
  `type` char(30) COLLATE utf8_unicode_ci NOT NULL,
  `lang` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `data` mediumblob,
  `size_w` smallint(6) DEFAULT NULL,
  `size_h` smallint(6) DEFAULT NULL,
  KEY `entityrole_id` (`entityrole_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_nameid`
--

DROP TABLE IF EXISTS `entity_nameid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_nameid` (
  `entityrole_id` int(11) NOT NULL,
  `value` char(100) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_organization`
--

DROP TABLE IF EXISTS `entity_organization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_organization` (
  `entity_id` int(11) NOT NULL,
  `lang` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` text COLLATE utf8_unicode_ci,
  `displayname` text COLLATE utf8_unicode_ci,
  `url` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_protocolsupport`
--

DROP TABLE IF EXISTS `entity_protocolsupport`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_protocolsupport` (
  `entityrole_id` int(11) NOT NULL,
  `value` char(100) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_requestedattributes`
--

DROP TABLE IF EXISTS `entity_requestedattributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_requestedattributes` (
  `entityrole_id` int(11) NOT NULL,
  `friendlyname` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `name` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `nameformat` char(50) COLLATE utf8_unicode_ci NOT NULL,
  `isrequired` tinyint(1) NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`name`,`nameformat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_requestinitiator`
--

DROP TABLE IF EXISTS `entity_requestinitiator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_requestinitiator` (
  `entityrole_id` int(11) NOT NULL,
  `requestinitiator` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`requestinitiator`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_role_warnings`
--

DROP TABLE IF EXISTS `entity_role_warnings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_role_warnings` (
  `entityrole_id` int(11) NOT NULL,
  `warning_id` int(3) NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`warning_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_roles`
--

DROP TABLE IF EXISTS `entity_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `roledesc` char(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entity_id` (`entity_id`,`roledesc`),
  KEY `roledesc` (`roledesc`)
) ENGINE=MyISAM AUTO_INCREMENT=174137 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_scopes`
--

DROP TABLE IF EXISTS `entity_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_scopes` (
  `entityrole_id` int(11) NOT NULL,
  `scope` char(255) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`,`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_services`
--

DROP TABLE IF EXISTS `entity_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_services` (
  `entityrole_id` int(11) NOT NULL,
  `service` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `binding` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `entityrole_id` (`entityrole_id`),
  KEY `service` (`service`),
  KEY `binding` (`binding`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entity_warnings`
--

DROP TABLE IF EXISTS `entity_warnings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_warnings` (
  `entity_id` int(11) NOT NULL,
  `warning_id` int(3) NOT NULL,
  UNIQUE KEY `entity_id` (`entity_id`,`warning_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entityattributes_dict`
--

DROP TABLE IF EXISTS `entityattributes_dict`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entityattributes_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_name` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `short` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`,`value`)
) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `entitywarnings_dict`
--

DROP TABLE IF EXISTS `entitywarnings_dict`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entitywarnings_dict` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `message` char(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `message` (`message`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `federation`
--

DROP TABLE IF EXISTS `federation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation` (
  `code` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `fed_id` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `europe` tinyint(1) DEFAULT NULL,
  `contact_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `policy_english` tinyint(1) DEFAULT NULL,
  `policy_hardcopy` int(8) DEFAULT NULL,
  `policy_date` date DEFAULT NULL,
  `membership_date` date DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `policy_version` int(8) DEFAULT NULL,
  `country_code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `production_date` date DEFAULT NULL,
  `suspension_date` date DEFAULT NULL,
  `tech_suspension_date` date DEFAULT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `federation_history`
--

DROP TABLE IF EXISTS `federation_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation_history` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `federation_links`
--

DROP TABLE IF EXISTS `federation_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation_links` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `test_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `url_type` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `result` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `result_code` tinyint(1) DEFAULT '0',
  `same_status_since` timestamp NULL DEFAULT NULL,
  `last_ok` timestamp NULL DEFAULT NULL,
  KEY `result_code` (`result_code`),
  KEY `url` (`url`),
  KEY `url_type` (`url_type`),
  KEY `test_time` (`test_time`),
  KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `federation_links_checks`
--

DROP TABLE IF EXISTS `federation_links_checks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation_links_checks` (
  `test_time` timestamp NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `federation_status`
--

DROP TABLE IF EXISTS `federation_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation_status` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_validation` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `valid_until` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_notification` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `feed_pull_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `feed_problem` tinyint(1) NOT NULL DEFAULT '0',
  `feed_problem_desc` text COLLATE utf8_unicode_ci,
  `pyff_problem` tinyint(1) DEFAULT '0',
  `pyff_problem_desc` text COLLATE utf8_unicode_ci,
  `last_status` tinyint(1) DEFAULT '0',
  `creationinstant` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `signature_alg` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `feed_last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `feed_etag` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_expire_notification` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `new_profile_status` tinyint(1) DEFAULT NULL,
  `new_profile_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sign_cert_sha1` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Temporary table structure for view `federation_v`
--

DROP TABLE IF EXISTS `federation_v`;
/*!50001 DROP VIEW IF EXISTS `federation_v`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `federation_v` (
  `code` tinyint NOT NULL,
  `reg_auth` tinyint NOT NULL,
  `metadata_url` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `fed_id` tinyint NOT NULL,
  `europe` tinyint NOT NULL,
  `contact_email` tinyint NOT NULL,
  `url` tinyint NOT NULL,
  `policy_english` tinyint NOT NULL,
  `policy_hardcopy` tinyint NOT NULL,
  `policy_date` tinyint NOT NULL,
  `membership_date` tinyint NOT NULL,
  `production_date` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `policy_version` tinyint NOT NULL,
  `valid_until` tinyint NOT NULL,
  `last_notification` tinyint NOT NULL,
  `feed_problem` tinyint NOT NULL,
  `new_profile_status` tinyint NOT NULL,
  `new_profile_modified` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `federation_warnings`
--

DROP TABLE IF EXISTS `federation_warnings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federation_warnings` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `warnings` bigint(20) DEFAULT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `feed_namespaces`
--

DROP TABLE IF EXISTS `feed_namespaces`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feed_namespaces` (
  `nskey` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nsvalue` char(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `nskey` (`nskey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mds_data`
--

DROP TABLE IF EXISTS `mds_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mds_data` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `metadata_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reg_auth` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  UNIQUE KEY `code` (`code`),
  KEY `reg_auth` (`reg_auth`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `more_map_codes`
--

DROP TABLE IF EXISTS `more_map_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `more_map_codes` (
  `code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `old_codes`
--

DROP TABLE IF EXISTS `old_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `old_codes` (
  `old_code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `person`
--

DROP TABLE IF EXISTS `person`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `given_name` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` char(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `show_email` tinyint(1) DEFAULT NULL,
  `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=2015 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `policy`
--

DROP TABLE IF EXISTS `policy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `policy` (
  `type` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `regions`
--

DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regions` (
  `country_code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `priority` int(4) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `role_details`
--

DROP TABLE IF EXISTS `role_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_details` (
  `entityrole_id` int(11) DEFAULT NULL,
  `roledesc` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role_display_name` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role_service_name` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `role_description` varchar(2047) COLLATE utf8_unicode_ci DEFAULT NULL,
  `validator_status` int(3) DEFAULT '0',
  `scopes` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `entityrole_id` (`entityrole_id`),
  KEY `entity_id` (`entity_id`),
  KEY `roledesc` (`roledesc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `role_names`
--

DROP TABLE IF EXISTS `role_names`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_names` (
  `roledesc` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rolename` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role_code` bit(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `security_contact`
--

DROP TABLE IF EXISTS `security_contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `security_contact` (
  `code` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `preferred` tinyint(1) DEFAULT '0'
) 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`
--

/*!50001 DROP TABLE IF EXISTS `federation_v`*/;
/*!50001 DROP VIEW IF EXISTS `federation_v`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `federation_v` AS select `federation`.`code` AS `code`,`mds_data`.`reg_auth` AS `reg_auth`,`mds_data`.`metadata_url` AS `metadata_url`,`mds_data`.`status` AS `status`,`federation`.`fed_id` AS `fed_id`,`federation`.`europe` AS `europe`,`federation`.`contact_email` AS `contact_email`,`federation`.`url` AS `url`,`federation`.`policy_english` AS `policy_english`,`federation`.`policy_hardcopy` AS `policy_hardcopy`,`federation`.`policy_date` AS `policy_date`,`federation`.`membership_date` AS `membership_date`,if((`federation`.`production_date` is null or `federation`.`production_date` = '0000-00-00') and `mds_data`.`status` = 2,'2050-01-01',`federation`.`production_date`) AS `production_date`,`federation`.`name` AS `name`,`federation`.`policy_version` AS `policy_version`,`federation`.`suspension_type` AS `suspension_type`,`federation_status`.`valid_until` AS `valid_until`,`federation_status`.`last_notification` AS `last_notification`,`federation_status`.`feed_problem` AS `feed_problem`,`federation_status`.`new_profile_status` AS `new_profile_status`,`federation_status`.`new_profile_modified` AS `new_profile_modified`,`mds_data`.`whitelist_idp` AS `whitelist_idp` from ((`federation` left join `mds_data` on(`mds_data`.`code` = `federation`.`code`)) left join `federation_status` on(`federation`.`code` = `federation_status`.`code`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-02-16 11:39:51