-- 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:15
-- 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 `SourceTexts`
--

CREATE TABLE `SourceTexts` (
  `id_text` int(11) NOT NULL COMMENT 'unique ID of each text cited in the edition',
  `id_author` varchar(1) DEFAULT NULL COMMENT 'ID of the author of the text (from SourceAuthors)',
  `lat_title` varchar(100) DEFAULT NULL COMMENT 'full Latin title',
  `short_title` varchar(25) DEFAULT NULL COMMENT 'abbreviated title',
  `viaf` varchar(40) DEFAULT NULL COMMENT ' VIAF authority number: http://viaf.org/viaf/"#" ',
  `qid` int(11) DEFAULT NULL COMMENT 'Wikidata ID: https://www.wikidata.org/wiki/Q"#" ',
  `printed_ed` varchar(150) DEFAULT NULL COMMENT 'printed edition of reference ',
  `online_ed` varchar(150) DEFAULT NULL COMMENT 'online open edition > links in SourceReferences '
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='index of ancient texts used, with their edition of reference.';

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

INSERT INTO `SourceTexts` (`id_text`, `id_author`, `lat_title`, `short_title`, `viaf`, `qid`, `printed_ed`, `online_ed`) VALUES
(1, '1', 'De locis sanctis ', 'loc.', '196908063', 5392907, 'ed. Bieler (1965), CCSL 175 pp. 183-234', 'ed. Geyer (1898), CSEL 39'),
(2, '2', 'Epistulae 120-154', 'epist.', '309472433', NULL, 'ed. Hilberg (1910–1918), CSEL 56', 'ed. Hilberg (1910–1918), CSEL 56'),
(3, '3', 'De situ Hierusolimae', 'itin.', '4270160486115505180006', NULL, 'ed. Fraipont (1965), CCSL 175 pp. 237-243', 'ed. Geyer (1898), CSEL 39'),
(4, '4', 'Historiae libri V', 'hist.', '7159474046027660850', NULL, 'ed. Ussani (1932–1960), CSEL 66', 'ed. Weber & Caesar (1864)'),
(5, '2', 'Biblia sacra uulgata', 'Vulg.', '208174761', 131175, ' ed. Weber & Gryson (2007⁵)', ' ed. Weber & Gryson (2007⁵)'),
(6, '5', 'Carmina (5 De Pascha)', 'carm. 5', '6883148269744205230000', NULL, 'ed. Hartel (1871), CSEL 3/3 pp. 305-308', 'ed. Hartel (1871), CSEL 3/3'),
(7, '7', 'Euangeliorum libri quattuor', 'Euang.', '1145971524832332918', 3735205, 'ed. Huemer (1891), CSEL 24', 'ed. Huemer (1891), CSEL 24'),
(8, '8', 'Expositio in Psalmum', 'in Psalm.', '258320769', NULL, 'ed. Petschenig (1913) CSEL 62', 'ed. Petschenig (1913) CSEL 62'),
(9, '2', 'De situ et nominibus locorum hebraicorum', 'sit. et nom.', '2562148947854654950007', NULL, 'ed. de Lagarde, Onomastica sacra (1887²), pp. 118–190', 'ed. de Lagarde, Onomastica sacra (1887²)'),
(10, '2', 'Quaestiones hebraicae in Genesim', 'quaest. hebr. in gen.', '176278585', NULL, 'ed. de Lagarde (1868); c. addend. CCSL 72 (1959) pp. 1– 56', 'ed. de Lagarde (1868)'),
(11, '6', 'De locis sanctis', 'loc.', '315653670', NULL, 'ed. Fraipont (1965), CCSL 175 pp. 247-280', NULL),
(12, '9', 'Naturalis historia', 'nat.', '178224328', 442, 'ed. Ianus & Mayhoff (1892–1909); Ernout al. (1947 sqq.)', NULL),
(13, '2', 'Hebraica nomina (liber interpretationis hebraicorum nominum)', 'nom. hebr.', '185365906', NULL, 'ed. de Lagarde, Onomastica sacra (1887²), pp. 26–116 (c. addend. CCSL 72 [1959] pp. 59–161)', 'ed. de Lagarde, Onomastica sacra (1887²)');

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

--
-- Index pour la table `SourceTexts`
--
ALTER TABLE `SourceTexts`
  ADD PRIMARY KEY (`id_text`);

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

--
-- AUTO_INCREMENT pour la table `SourceTexts`
--
ALTER TABLE `SourceTexts`
  MODIFY `id_text` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique ID of each text cited in the edition', AUTO_INCREMENT=14;
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 */;
