-- 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:12
-- 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 `SiglaCodicum`
--

CREATE TABLE `SiglaCodicum` (
  `id_text` int(2) DEFAULT NULL COMMENT 'ID of the text contained in the manuscripts (from SourceTexts): 11 = Beda DLS',
  `id_ms` int(11) NOT NULL COMMENT 'unique ID of each manuscript',
  `siglum` varchar(3) COLLATE utf8_unicode_ci NOT NULL COMMENT 'traditional short sigla for ancient manuscripts',
  `siglum_geyer` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sigla of the manuscripts in Geyer''s edition (1898)',
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'country where the manuscript is kept',
  `city` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'city where the manuscript is kept',
  `institution` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'institution where the manuscript is kept',
  `collection` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'collection of the manuscript, when needed',
  `number` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'manuscript''s number in the institution''s catalogue',
  `catalogue` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'reference in specific catalogues',
  `date` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'estimation of the date of production',
  `folios` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'exact pages containing the DLS in the manuscripts',
  `descr_link` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'links to online descriptions of the manuscripts'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='index of the manuscripts containing Beda''s DLS.';

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

INSERT INTO `SiglaCodicum` (`id_text`, `id_ms`, `siglum`, `siglum_geyer`, `country`, `city`, `institution`, `collection`, `number`, `catalogue`, `date`, `folios`, `descr_link`) VALUES
(11, 1, 'N', NULL, 'Belgium', 'Namur', 'Bibliothèque du Séminaire Notre-Dame de Namur', NULL, '37', NULL, '1001-1100', '118-126', 'http://www.mirabileweb.it/manuscript/namur-grand-séminaire-37-manuscript/108028'),
(11, 2, 'P', 'P', 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '2321', NULL, '901-1100', '135v-143v', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc60149x'),
(11, 3, 'M', 'M', 'Germany', 'Muenchen', 'Bayerische Staatsbibliothek', 'clm', '6389', NULL, '846-855', '1-14v', 'http://www.manuscripta-mediaevalia.de/dokumente/html/obj31724372'),
(11, 4, 'Ba', NULL, 'Spain', 'Barcelona', 'Arxiu de la Corona d’Aragó', 'Ripoll', '151', '', '1001-1100', '1v-12', 'http://www.mirabileweb.it/manuscript/barcelona-arxiu-de-la-corona-d-aragó-diversos-i-co-manoscript/414'),
(11, 5, 'Be', NULL, 'Germany', 'Berlin', 'Staatsbibliothek zu Berlin, Preussischer Kulturbesitz (SBB) = Öffentliche Wissenschaftliche Bibliothek (ÖWB)', 'lat. oct.', '32', '(= 861 Rose)', '1301-1400', '83-96', 'http://www.manuscripta-mediaevalia.de/dokumente/html/obj60001821,T'),
(11, 6, 'B', NULL, 'Belgium', 'Brugge', 'Stadsbibliotheek – Hoofdbibliotheek Biekorf = Openbare Bibliotheek Brugge', NULL, '77', '', '1201-1300', '100v-105', 'https://brugge.bibliotheek.be/catalogus/beda-venerabilis/ms-077-beda-super-actus-apostolorum-et-super-canonicas-epistolas-libellus-eiusdem-de/library-v-obbrugge-oudedrukken_3757'),
(11, 7, 'Br1', NULL, 'Belgium', 'Bruxelles', 'Bibliothèque royale de Belgique (KBR)', NULL, '8654-72 ', '(1324 VDG)', '801-825', '118-120', ' https://archive.org/details/cataloguemanuscr02bibl/page/274/mode/2up'),
(11, 8, 'Br2', NULL, 'Belgium', 'Bruxelles', 'Bibliothèque royale de Belgique (KBR)', NULL, 'II 1008 ', '(1362 VDG)', '1101-1300', '71-79', 'https://archive.org/details/cataloguemanuscr02bibl/page/298/mode/2up'),
(11, 9, 'C1', NULL, 'United Kingdom', 'Cambridge', 'Corpus Christi College: Parker Library', NULL, '315', '(James, p. 120)', '1201-1300', '135-141', 'https://www.corpus.cam.ac.uk/sites/default/files/downloads/m.r._james_cccc_catalogue_1912_vol._ii.pdf'),
(11, 10, 'C2', NULL, 'United Kingdom', 'Cambridge', 'Corpus Christi College: Parker Library', NULL, '426', ' (James, p. 332)', '1401-1500', 'II. 50-55 (=133-138)', 'https://www.corpus.cam.ac.uk/sites/default/files/downloads/m.r._james_cccc_catalogue_1912_vol._ii.pdf'),
(11, 11, 'C3', NULL, 'United Kingdom', 'Cambridge', 'Gonville & Caius College Library', NULL, '225/240 ', '(James, p. 263)', '1201-1300', '171-172', 'https://archive.org/details/adescriptivecat10librgoog/page/n301/mode/2up'),
(11, 12, 'Ch1', NULL, 'France', 'Charleville-Mézières', 'Bibliothèque municipale (BM) = Médiathèque Voyelles', NULL, '190', '', '1175-1200', '136v-143v', 'http://medium-avance.irht.cnrs.fr/ark:/63955/md62s4655p3z'),
(11, 13, 'Ch2', NULL, 'France', 'Charleville-Mézières', 'Bibliothèque municipale (BM) = Médiathèque Voyelles', NULL, '275', '(CG V, p. 670)', '1201-1300', '226vb-228vb', 'http://www.mirabileweb.it/manuscript/charleville-mézières-médiathèque-voyelles-(olim-bi-manoscript/115922'),
(11, 14, 'D', NULL, 'Ireland', 'Dublin', 'Trinity College Library (TCD)', NULL, '496', '', '1301-1325', '215-223v', 'https://manuscripts.catalogue.tcd.ie/CalmView/Record.aspx?src=CalmView.Catalog&id=IE+TCD+MS+496'),
(11, 15, 'Ep', NULL, 'France', 'Épernay', 'Bibliothèque municipale (BM) = Médiathèque centre-ville', NULL, '19', '', '1101-1200', '77-82v', 'https://ccfr.bnf.fr/portailccfr/ark:/06871/004D29120061'),
(11, 16, 'Er', NULL, 'Germany', 'Erfurt', 'Wissenschaftliche Allgemein-Bibliothek der Stadt Erfurt', 'Dep. Erf. CA', '2° 64', '', '901-950', '87v-96', 'http://bilder.manuscripta-mediaevalia.de/hs//katalogseiten/HSK0495_b0049_jpg.htm'),
(11, 17, 'F', NULL, 'Italy', 'Firenze', 'Biblioteca Medicea Laurenziana (BML)', 'Strozzi', '7', '', '1101-1200', '161v-164', 'https://reader.digitale-sammlungen.de/de/fs1/object/display/bsb10798602_00161.html?zoom=0.8000000000000003'),
(11, 18, 'Kl', NULL, 'Austria', 'Klosterneuburg', 'Stiftsarchiv', NULL, '787', '', '1201-1300', '170-180v', ''),
(11, 19, 'K', NULL, 'Germany', 'Koeln', 'Erzbischöfliche Diözesan- und Dombibliothek', NULL, '1110', '', '1101-1300', '68v-79v', 'https://digital.dombibliothek-koeln.de/hs/urn/urn:nbn:de:hbz:kn28-3-7473'),
(11, 20, 'L', NULL, 'France', 'Laon', 'Bibliothèque municipale (BM) = Bibliothèque Suzanne-Martinet', NULL, '216', '', '801-900', '66v-73v', 'http://medium-avance.irht.cnrs.fr/ark:/63955/md17cr56n896'),
(11, 21, 'Li', NULL, 'Belgium', 'Liège', 'Bibliothèque Alpha de l’Université de Liège – Section des manuscrits et fonds anciens', NULL, '45', '', '1101-1125', '175-178v', 'http://hdl.handle.net/2268.1/4894'),
(11, 22, 'Lo1', NULL, 'United Kingdom', 'London', 'British Library (BL),', 'Additional', '15219', '', '1150-1200', '12v-19v', 'http://searcharchives.bl.uk/IAMS_VU2:IAMS032-002086922'),
(11, 23, 'Lo2', NULL, 'United Kingdom', 'London', 'British Library (BL),', 'Additional', '22635', '', '1301-1400', '43-44', 'http://searcharchives.bl.uk/IAMS_VU2:IAMS032-002096606'),
(11, 24, 'Lo3', 'L', 'United Kingdom', 'London', 'British Library (BL),', 'Cotton Faustina', 'A VII', '', '1201-1225', '157–163v', 'http://searcharchives.bl.uk/IAMS_VU2:IAMS040-001103854'),
(11, 25, 'Lo4', 'C', 'United Kingdom', 'London', 'British Library (BL),', 'Cotton Faustina', 'B I', '', '1150-1200', '196–203v', 'http://searcharchives.bl.uk/IAMS_VU2:IAMS041-001103867'),
(11, 26, 'Me', NULL, 'France', 'Metz', 'Bibliothèque municipale (BM) = Médiathèque Verlaine (Pontiffroy)', NULL, '349', '', '901-1000', '97v-108v', 'http://medium-avance.irht.cnrs.fr/ark:/63955/md79v118rx1w'),
(11, 27, 'Mi', 'A', 'Italy', 'Milano', 'Biblioteca Ambrosiana', NULL, 'M 79 sup ', '(Bischoff-Lapidge 1995, pp. 275-287)', '1075-1100', '38v-44', 'https://ambrosiana.comperio.it/opac/detail/view/ambro:catalog:78220'),
(11, 28, 'M2', 'Mb', 'Germany', 'Muenchen', 'Bayerische Staatsbibliothek', 'clm', '629', '', '1201-1300', '1-19r', 'https://opacplus.bsb-muenchen.de/search?oclcno=935150657&db=100&View=default'),
(11, 29, 'M3', 'U', 'Germany', 'Muenchen', 'Bayerische Staatsbibliothek', 'clm', '4351', '', '1401-1500', '204v-205v', 'https://opacplus.bsb-muenchen.de/search?oclcno=909876211&db=100&View=default'),
(11, 30, 'M4', NULL, 'Germany', 'Muenchen', 'Bayerische Staatsbibliothek', 'clm', '13002', '', '1150-1175', '4v', 'http://www.mirabileweb.it/manuscript/münchen-bayerische-staatsbibliothek-clm-13002-manoscript/7118\r\n'),
(11, 31, 'M5', NULL, 'Germany', 'Muenchen', 'Bayerische Staatsbibliothek', 'clm', '14603', '', '1501-1600', '128-137v', 'https://opacplus.bsb-muenchen.de/search?oclcno=644335639&db=100&View=default'),
(11, 32, 'O1', NULL, 'United Kingdom', 'Oxford', 'Bodleian Library', 'Bodley', '297', '', '1125-1150', '66-70', 'https://medieval.bodleian.ox.ac.uk/catalog/manuscript_1347'),
(11, 33, 'O2', NULL, 'United Kingdom', 'Oxford', 'Corpus Christi College (CCC)', NULL, '157', '', '1125-1150', '72-77a', 'https://digital.bodleian.ox.ac.uk/objects/93b83416-7972-40d7-9789-18f54e17ae25/'),
(11, 34, 'O3', 'O', 'United Kingdom', 'Oxford', 'Lincoln College (in the Bodleian Library)', 'lat. ', '96', '', '1201-1300', '124-127v', 'http://www.mirabileweb.it/manuscript/oxford-lincoln-college-(in-deposito-presso-la-bodl-manoscript/25885'),
(11, 35, 'O4', NULL, 'United Kingdom', 'Oxford', 'Merton College', NULL, 'K 3 3 ', '(Coxe CLXXV)', '1401-1500', '85v; 152v', 'https://archive.org/details/cataloguscodicum01coxeuoft/page/n257/mode/2up?q=sanctis'),
(11, 36, 'O5', NULL, 'United Kingdom', 'Oxford', 'St John’s College', NULL, '128', '', '1101-1125', '227-237', 'http://www.mirabileweb.it/manuscript/oxford-saint-john-s-college-128-manoscript/2552'),
(11, 37, 'O6', NULL, 'United Kingdom', 'Oxford', 'Worcester College', NULL, '285', '', '1301-1400', '248-252', 'http://www.mirabileweb.it/manuscript/oxford-worcester-college-285-manoscript/24200'),
(11, 38, 'P2', NULL, 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '4999 A', '', '1201-1300', '86-92', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc63895m'),
(11, 39, 'P3', 'Pc', 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '12277', '', '1101-1125', '52-58v', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc73594z'),
(11, 40, 'P4', NULL, 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '12943', '', '1001-1200', '90-96', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc74070v'),
(11, 41, 'P5', 'Pb', 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '14797', '', '1101-1200', '19-21v', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc75542q'),
(11, 42, 'P6', NULL, 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '15038', '', '1101-1125', '172v-174v.', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc75754r'),
(11, 43, 'P7', NULL, 'France', 'Paris', 'Bibliothèque nationale de France', 'lat.', '11684', '', '1101-1200', '218-221v', 'https://archivesetmanuscrits.bnf.fr/ark:/12148/cc73163d'),
(11, 44, 'R1', NULL, 'France', 'Reims', 'Bibliothèque municipale (BM) = Bibliothèque Carnegie = Bibliothèque d’étude et du patrimoine', NULL, '20-21', '', '1101-1125', '257v-274v', ' https://ccfr.bnf.fr/portailccfr/ark:/06871/004D38A10172'),
(11, 45, 'R2', NULL, 'France', 'Reims', 'Bibliothèque municipale (BM) = Bibliothèque Carnegie = Bibliothèque d’étude et du patrimoine', NULL, '34-36 (t. III)', '', '1275-1300', '221-226v', 'https://ccfr.bnf.fr/portailccfr/ark:/06871/004D38A10411'),
(11, 46, 'Re', NULL, 'Austria', 'Rein', 'Stiftsbibliothek', NULL, '20', '', '1101-1200', '1v-42', 'https://docplayer.org/44531935-Handschriften-verzeichnis-stifts-bibliothek-zu-rein.html'),
(11, 47, 'S', NULL, 'France', 'Soissons', 'Bibliothèque municipale (BM)', NULL, '127', '', '1401-1500', '62-69v', 'http://medium-avance.irht.cnrs.fr/ark:/63955/md07tm70q912'),
(11, 48, 'T', NULL, 'France', 'Troyes', 'Bibliothèque municipale (BM) = Médiathèque de l’Agglomération troyenne = Médiathèque du Grand Troyes', NULL, '1558', '', '1101-1400', '47', 'http://medium-avance.irht.cnrs.fr/ark:/63955/md56zw130d02'),
(11, 49, 'Va', NULL, 'France', 'Valenciennes', 'Bibliothèque municipale (BM) = Bibliothèque centrale = Bibliothèque multimédia de Valenciennes', NULL, '52', '', '1101-1200', '171-176', 'https://ccfr.bnf.fr/portailccfr/ark:/06871/004D30020128'),
(11, 50, 'V1', NULL, 'Vatican', 'Vaticano (Città del)', 'Biblioteca Apostolica Vaticana (BAV)', 'Vat. Lat.', '629', '', '1101-1125', '11-14r', 'https://opac.vatlib.it/mss/detail/Vat.lat.629'),
(11, 51, 'V2', 'Vat', 'Vatican', 'Vaticano (Città del)', 'Biblioteca Apostolica Vaticana (BAV)', 'Vat. Lat.', '636 (part 2)', '', '1201-1300', '72-78', 'https://opac.vatlib.it/mss/detail/Vat.lat.636.pt.2'),
(11, 52, 'V3', NULL, 'Vatican', 'Vaticano (Città del)', 'Biblioteca Apostolica Vaticana (BAV)', 'Vat. Lat.', '3851', '', '1401-1500', '44v-50', 'https://opac.vatlib.it/mss/detail/Vat.lat.3851'),
(11, 53, 'W', 'V', 'Austria', 'Wien', 'Österreichische Nationalbibliothek (ÖNB)', 'lat.', '580', '', '1001-1100', '10-19v', ' http://data.onb.ac.at/rec/AC13958950'),
(11, 54, 'W2', 'V2', 'Austria', 'Wien', 'Österreichische Nationalbibliothek (ÖNB)', 'lat.', '2432', '', '1150-1200', '28-35', ' http://data.onb.ac.at/rec/AC14011030'),
(11, 55, 'Wu', NULL, 'Germany', 'Wuerzburg', 'Universitätsbibliothek', 'M.p.th.f.', '74', '', '850-875', '94v-95v', 'http://vb.uni-wuerzburg.de/ub/mpthf74/index.html');

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

--
-- Index pour la table `SiglaCodicum`
--
ALTER TABLE `SiglaCodicum`
  ADD PRIMARY KEY (`id_ms`);

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

--
-- AUTO_INCREMENT pour la table `SiglaCodicum`
--
ALTER TABLE `SiglaCodicum`
  MODIFY `id_ms` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique ID of each manuscript', AUTO_INCREMENT=56;
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 */;
