Projekt Adressbücher/Technik

Info

Diese Seite enthält technische Details, die für die Pflege der Datenbank benötigt werden.

SELECT concat('UPDATE entry SET prefix=\'',extensions_elt,'-\' WHERE id=',extensions,'; DELETE FROM entry_extensions WHERE extensions_idx = 46 AND extensions=',extensions,';') FROM entry_extensions WHERE extensions_idx = 46 ;

SELECT concat('UPDATE entry SET page=\'',extensions_elt,'-\' WHERE page IS NULL AND id=',extensions,'; DELETE FROM entry_extensions WHERE extensions_idx = 80 AND extensions=',extensions,';') FROM entry_extensions WHERE extensions_idx = 80 ;

SELECT extensions_idx, translation_elt, count(*) from extension_type_translation JOIN entry_extensions ON extensions_idx=translation WHERE translation_idx='de' GROUP BY extensions_idx ORDER BY translation_elt;