GEANT/CAT

/*
 * *****************************************************************************
 * Contributions to this work were made on behalf of the GÉANT project, a 
 * project that has received funding from the European Union’s Framework 
 * Programme 7 under Grant Agreements No. 238875 (GN3) and No. 605243 (GN3plus),
 * Horizon 2020 research and innovation programme under Grant Agreements No. 
 * 691567 (GN4-1) and No. 731122 (GN4-2).
 * On behalf of the aforementioned projects, GEANT Association is the sole owner
 * of the copyright in all material which was developed by a member of the GÉANT
 * project. GÉANT Vereniging (Association) is registered with the Chamber of 
 * Commerce in Amsterdam with registration number 40535155 and operates in the 
 * UK as a branch of GÉANT Vereniging.
 * 
 * Registered office: Hoekenrode 3, 1102BR Amsterdam, The Netherlands. 
 * UK branch address: City House, 126-130 Hills Road, Cambridge CB2 1PQ, UK
 *
 * License: see the web/copyright.inc.php file in the file structure or
 *          <base_url>/copyright.php after deploying the software
 */

/**
 * Author:  twoln
 */

DROP TABLE IF EXISTS `view_tls_inst`;
CREATE TABLE `view_tls_inst` (
  `ROid` char(5) DEFAULT NULL,
  `country` char(5) DEFAULT NULL,
  `instid` char(50) DEFAULT NULL,
  `stage` tinyint DEFAULT NULL,
  `type` tinyint DEFAULT NULL,
  `inst_name` varchar(2048) DEFAULT NULL,
  `servers` text,
  `contacts` text,
  `ts` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

DROP TABLE IF EXISTS `view_tls_ro`;
CREATE TABLE `view_tls_ro` (
  `ROid` char(5) DEFAULT NULL,
  `country` char(5) DEFAULT NULL,
  `stage` tinyint DEFAULT NULL,
  `servers` text,
  `contacts` text,
  `ts` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;