-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Hôte : db.dmz.dhvlab.fo
-- Généré le : lun. 20 déc. 2021 à 16:11
-- Version du serveur :  5.5.65-MariaDB
-- Version de PHP : 7.3.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Base de données : `labuser_jdesiderio`
--

-- --------------------------------------------------------

--
-- Structure de la table `EditionCorrections`
--

CREATE TABLE `EditionCorrections` (
  `id_edition` int(6) NOT NULL COMMENT 'ID of the edited token',
  `id_ms` int(1) DEFAULT NULL COMMENT 'ID of the manuscript with the best reading',
  `chapter` int(2) DEFAULT NULL COMMENT 'text chapter number',
  `token` varchar(20) DEFAULT NULL COMMENT 'best reading of the word in the manuscripts',
  `correction` varchar(20) DEFAULT NULL COMMENT 'editorial correction',
  `editor` varchar(2) DEFAULT NULL COMMENT 'initials of the editor (JD = Janyce Desiderio)',
  `remark` varchar(17) DEFAULT NULL COMMENT 'information when needed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contains the corrections and conjectures made by JD when no manuscript holds a correct reading. Linked to AlignmentBeda via ''id_edition'' and ''problem''.';

--
-- Déchargement des données de la table `EditionCorrections`
--

INSERT INTO `EditionCorrections` (`id_edition`, `id_ms`, `chapter`, `token`, `correction`, `editor`, `remark`) VALUES
(8, 1, 0, 'presbiteri', 'presbyteri', 'JD', NULL),
(44, 1, 0, 'sonet', 'sonat', 'JD', NULL),
(655, 3, 2, 'cripta', 'crypta', 'JD', NULL),
(874, 1, 2, 'hostium', 'ostium', 'JD', NULL),
(1050, 2, 2, 'syon', 'sion', 'JD', NULL),
(1256, 1, 2, 'adherens', 'adhaerens', 'JD', NULL),
(1740, 1, 5, 'cesaream', 'caesaream', 'JD', NULL),
(1989, 1, 6, 'rare', 'rarae', 'JD', NULL),
(2001, 20, 6, 'bruchosa', 'bruscosa', 'JD', 'no earlier attest'),
(2370, 1, 7, 'actenus', 'hactenus', 'JD', NULL),
(2965, 1, 9, 'petrae', 'petraeae', 'JD', NULL),
(3113, 1, 10, 'cesarea', 'caesarea', 'JD', NULL),
(3464, 1, 11, 'quia', 'quauis', 'JD', NULL),
(3465, 1, 11, 'uas', '', 'JD', NULL),
(3469, 1, 11, 'bibat', 'uiuat', 'JD', NULL),
(3473, 1, 11, 'herere', 'haerere', 'JD', NULL),
(3533, 1, 11, 'herere', 'haerere', 'JD', NULL);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `EditionCorrections`
--
ALTER TABLE `EditionCorrections`
  ADD PRIMARY KEY (`id_edition`);
COMMIT;

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