139 lines
3.5 KiB
SQL
139 lines
3.5 KiB
SQL
/*
|
|
GEÄNDERTE DATEIEN FÜR LUTHER 2017:
|
|
|
|
++ Umstellung Luther 2017.sql
|
|
func_make_reference_fa.php
|
|
func_make_knk_fa.php
|
|
func_make_knk.php
|
|
lue_inhalt.php
|
|
pdf_gen.php
|
|
kat_main_fa.php
|
|
kat_main.php
|
|
func_ansicht.php
|
|
ansicht2.php
|
|
ansicht.php
|
|
bibellookup_2017.php
|
|
bibellookup_1984.php
|
|
bibpopup/bib_popup_1984.php
|
|
bibpopup/bib_popup_2017.php
|
|
bibpopup/bib_popup_body_1984.php
|
|
bibpopup/bib_popup_body_2017.php
|
|
templates/standard/bib_popup_1984.html
|
|
templates/standard/bib_popup_2017.html
|
|
templates/standard/bib_popup_body_1984.html
|
|
templates/standard/bib_popup_body_2017.html
|
|
*/
|
|
|
|
CREATE TABLE `bibel_books_2017` (
|
|
`id` int(11) NOT NULL,
|
|
`bezeichnung` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Daten für Tabelle `bibel_books_2017`
|
|
--
|
|
|
|
INSERT INTO `bibel_books_2017` (`id`, `bezeichnung`) VALUES
|
|
(1, '1. Mose'),
|
|
(2, '2. Mose'),
|
|
(3, '3. Mose'),
|
|
(4, '4. Mose'),
|
|
(5, '5. Mose'),
|
|
(6, 'Josua'),
|
|
(7, 'Richter'),
|
|
(8, 'Rut'),
|
|
(9, '1. Samuel'),
|
|
(10, '2. Samuel'),
|
|
(11, '1. Könige'),
|
|
(12, '2. Könige'),
|
|
(13, '1. Chronik'),
|
|
(14, '2. Chronik'),
|
|
(15, 'Esra'),
|
|
(16, 'Nehemia'),
|
|
(17, 'Ester'),
|
|
(18, 'Hiob'),
|
|
(19, 'Psalm'),
|
|
(20, 'Sprüche'),
|
|
(21, 'Prediger'),
|
|
(22, 'Hoheslied'),
|
|
(23, 'Jesaja'),
|
|
(24, 'Jeremia'),
|
|
(25, 'Klagelieder'),
|
|
(26, 'Hesekiel'),
|
|
(27, 'Daniel'),
|
|
(28, 'Hosea'),
|
|
(29, 'Joel'),
|
|
(30, 'Amos'),
|
|
(31, 'Obadja'),
|
|
(32, 'Jona'),
|
|
(33, 'Micha'),
|
|
(34, 'Nahum'),
|
|
(35, 'Habakuk'),
|
|
(36, 'Zefanja'),
|
|
(37, 'Haggai'),
|
|
(38, 'Sacharja'),
|
|
(39, 'Maleachi'),
|
|
(40, 'Judit'),
|
|
(41, 'Weisheit'),
|
|
(42, 'Tobias'),
|
|
(43, 'Sirach'),
|
|
(44, 'Baruch'),
|
|
(45, '1. Makkabäer'),
|
|
(46, '2. Makkabäer'),
|
|
(47, 'Stücke zu Ester'),
|
|
(48, 'Stücke zu Daniel'),
|
|
(49, 'Gebet Manasses'),
|
|
(50, 'Matthäus'),
|
|
(51, 'Markus'),
|
|
(52, 'Lukas'),
|
|
(53, 'Johannes'),
|
|
(54, 'Apostelgeschichte'),
|
|
(55, 'Römer'),
|
|
(56, '1. Korinther'),
|
|
(57, '2. Korinther'),
|
|
(58, 'Galater'),
|
|
(59, 'Epheser'),
|
|
(60, 'Philipper'),
|
|
(61, 'Kolosser'),
|
|
(62, '1. Thessalonicher'),
|
|
(63, '2. Thessalonicher'),
|
|
(64, '1. Timotheus'),
|
|
(65, '2. Timotheus'),
|
|
(66, 'Titus'),
|
|
(67, 'Philemon'),
|
|
(68, 'Hebräer'),
|
|
(69, 'Jakobus'),
|
|
(70, '1. Petrus'),
|
|
(71, '2. Petrus'),
|
|
(72, '1. Johannes'),
|
|
(73, '2. Johannes'),
|
|
(74, '3. Johannes'),
|
|
(75, 'Judas'),
|
|
(76, 'Offenbarung');
|
|
|
|
RENAME TABLE `leitgedanken`.`bibel_chapter` TO `leitgedanken`.`bibel_chapter_1984`;
|
|
RENAME TABLE `leitgedanken`.`bibel_books` TO `leitgedanken`.`bibel_books_1984`;
|
|
create table knk_lut84 as select * from knk;
|
|
create table knk_fa_lut84 as select * from knk_fa;
|
|
|
|
UPDATE `notizen`
|
|
set notiz = replace(notiz, 'bib_popup.php', 'bib_popup1984.php');
|
|
|
|
|
|
#func_make_knk.php ausführen mit unterschiedlichen biblelink=lokal/bibleserver
|
|
http://www.lg-on.de/func_make_knk.php?bibellink=lokal
|
|
http://www.lg-on.de/func_make_knk.php?bibellink=bibleserver
|
|
|
|
|
|
#func_make_knk_fa.php ausführen für biblelink=lokal/bibleserver und spalte=description/description2/answer/reference
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=lokal&spalte=description_lokal
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=lokal&spalte=description2_lokal
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=lokal&spalte=answer_lokal
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=lokal&spalte=reference_lokal
|
|
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=bibleserver&spalte=description_bibleserver
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=bibleserver&spalte=description2_bibleserver
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=bibleserver&spalte=answer_bibleserver
|
|
http://www.lg-on.de/func_make_knk_fa.php?bibellink=bibleserver&spalte=reference_bibleserver
|
|
|
|
http://www.lg-on.de/func_make_reference_fa.php |