-- MariaDB dump 10.19  Distrib 10.5.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: i18n_it
-- ------------------------------------------------------
-- Server version	10.5.23-MariaDB-0+deb11u1

/*!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 utf8mb4 */;
/*!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 `deadlines`
--

DROP TABLE IF EXISTS `deadlines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deadlines` (
  `name` varchar(30) NOT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `files` (
  `file` varchar(130) NOT NULL,
  `package` varchar(50) NOT NULL,
  `idTranslator` smallint(6) DEFAULT NULL,
  `idReviewer` smallint(6) DEFAULT NULL,
  `translatorSince` datetime DEFAULT NULL,
  `reviewerSince` datetime DEFAULT NULL,
  `type` enum('GUI','DOC') NOT NULL DEFAULT 'GUI',
  PRIMARY KEY (`file`,`package`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
  `package` varchar(50) NOT NULL,
  `idTranslator` smallint(6) DEFAULT NULL,
  `collection` enum('Applications','Frameworks','Plasma') DEFAULT NULL,
  PRIMARY KEY (`package`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `requests`
--

DROP TABLE IF EXISTS `requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requests` (
  `idRequest` int(11) NOT NULL AUTO_INCREMENT,
  `idTranslator` smallint(6) DEFAULT NULL,
  `idFrom` int(11) DEFAULT NULL,
  `since` datetime DEFAULT NULL,
  `file` varchar(130) DEFAULT NULL,
  `package` varchar(50) DEFAULT NULL,
  `type` enum('GUI','DOC') DEFAULT NULL,
  `review` tinyint(1) DEFAULT 0,
  `decision` enum('accept','reject') DEFAULT NULL,
  PRIMARY KEY (`idRequest`)
) ENGINE=MyISAM AUTO_INCREMENT=12255 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`kdeit`@`%`*/ /*!50003 TRIGGER no_pending_duplicates BEFORE INSERT ON requests FOR EACH ROW BEGIN SET @duplicate := false; SELECT true INTO @duplicate FROM requests WHERE idTranslator=NEW.idTranslator AND idFrom=NEW.idFrom AND file=NEW.file AND package=NEW.package AND type=NEW.type AND review=NEW.review AND decision IS NULL LIMIT 1; IF @duplicate THEN SET NEW.idTranslator=NULL; SET NEW.idFROM=NULL; SET NEW.file=NULL; SET NEW.package=NULL; SET NEW.type=NULL; SET NEW.review=NULL; SET NEW.decision='reject'; END IF; END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `stats`
--

DROP TABLE IF EXISTS `stats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats` (
  `type` enum('GUI','DOC') NOT NULL DEFAULT 'GUI',
  `package` varchar(50) NOT NULL,
  `file` varchar(130) NOT NULL,
  `done` int(11) NOT NULL,
  `fuzzy` int(11) NOT NULL,
  `todo` int(11) NOT NULL,
  `lastModified` datetime /* mariadb-5.3 */ DEFAULT NULL,
  `lastModifiedBy` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`file`,`package`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `translations`
--

DROP TABLE IF EXISTS `translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translations` (
  `type` enum('GUI','DOC') NOT NULL DEFAULT 'GUI',
  `package` varchar(50) NOT NULL,
  `file` varchar(130) NOT NULL,
  `number` int(11) NOT NULL DEFAULT 0,
  `msgid` mediumtext DEFAULT NULL,
  `msgstr` mediumtext DEFAULT NULL,
  `msgidnotag` mediumtext DEFAULT NULL,
  `msgstrnotag` mediumtext DEFAULT NULL,
  `isFuzzy` tinyint(1) NOT NULL DEFAULT 0,
  `msgctxt` mediumtext DEFAULT NULL,
  PRIMARY KEY (`file`,`package`,`type`,`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `translators`
--

DROP TABLE IF EXISTS `translators`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translators` (
  `idTranslator` smallint(6) NOT NULL AUTO_INCREMENT,
  `first` varchar(20) DEFAULT NULL,
  `last` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `password` varchar(150) DEFAULT NULL,
  `biography` longtext DEFAULT NULL,
  `foto` blob DEFAULT NULL,
  `tipofoto` varchar(30) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`idTranslator`),
  UNIQUE KEY `id` (`idTranslator`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=5812 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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-09-19 16:23:38