DELETE from lang WHERE app_name='inv' and lang='de';
DELETE from lang WHERE app_name='preferences' and message_id='inv' and content='Inventory' and lang='de';
DELETE from lang WHERE app_name='preferences' and message_id='Inventory preferences' and content='Inventory preferences' and lang='de';
DELETE from lang WHERE app_name='preferences' and message_id='Inventory access' and content='Inventory access' and lang='de';

INSERT INTO lang (message_id, app_name, lang, content) VALUES('That Category ID has been used already !','inv','de','Diese Kategorie ID ist bereits in Benutzung !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That Product ID has been used already !','inv','de','Diese Produkt ID ist bereits in Benutzung !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That product name has been used already !','inv','de','Dieser Produktname ist bereits in Benutzung !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That category name has been used already !','inv','de','Dieser Kategoriename ist bereits in Benutzung !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category name','inv','de','Kategoriename');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Do you also want to delete all subcategories ?','inv','de','M&ouml;chten Sie auch alle Unterkategorien l&ouml;schen ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Product ID ?','inv','de','Produkt ID generieren?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Click me','inv','en','Click mich');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Order ID ?','inv','de','Bestellungs ID generieren ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Invoice ID ?','inv','de','Rechnungs ID generieren ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Delivery ID ?','inv','de','Lieferungs ID generieren?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category x has been added !','inv','de','Kategorie %1 wurde hinzugef&uuml;gt !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order x has been added !','inv','de','Bestellung %1 wurde hinzugef&uuml;gt !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery x has been created !','inv','de','Lieferung %1 wurde erstellt !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery x has been updated !','inv','de','Lieferung %1 wurde &uuml;berarbeitet !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice x has been created !','inv','de','Rechnung %1 wurde erstellt !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice x has been updated !','inv','de','Rechnung %1 wurde &uuml;berarbeitet !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product x x has been added !','inv','de','Produkt %1 %2 wurde hinzugef&uuml;gt !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category x has been updated !','inv','de','Kategorie %1 wurde &uuml;berarbeitet !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order x has been updated !','inv','de','Bestellung %1 wurde &uuml;berarbeitet !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product x x has been updated !','inv','de','Produkt %1 %2 wurde &uuml;berarbeitet !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category ID','inv','de','Kategorie ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category','inv','de','Kategorie');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('available','inv','de','Erh&auml;ltlich');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('other','inv','de','Anderer');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('unknown','inv','de','Unbekannt');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('saled','inv','de','Bezahlt');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('back order','inv','de','Nachbestellt');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('no longer available','inv','de','Nicht l&auml;nger erh&auml;ltlich');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Date','inv','de','Datum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('open','inv','de','Offen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('closed','inv','de','Abeschlossen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Cost','inv','de','Kosten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Company name','inv','de','Firmenname');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Price','inv','de','Preis');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Status','inv','de','Status');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add category','inv','de','Kategorie hinzuf&uuml;gen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Name','inv','de','Name');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add distributor','inv','de','Gro&szlig;h&auml;ndler hinzuf&uuml;gen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Serial number','inv','de','Seriennummer');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add order','inv','de','Bestellung hinzuf&uuml;gen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Search this category','inv','de','in dieser Kategorie suchen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product ID','inv','de','Produkt ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Description','inv','de','Beschreibung');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status','inv','de','Produktstatus');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Purchase price','inv','de','Einkaufspreis');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Purchase date','inv','de','Einkaufsdatum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('a piece','inv','de','pro St&uuml;ck');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category list','inv','de','Liste der Kategorien');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product list','inv','de','Liste der Produkte');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributor list','inv','de','Liste der Gro&szlig;h&auml;ndler');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributors','inv','de','Gro&szlig;h&auml;ndler');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributor','inv','de','Gro&szlig;h&auml;ndler');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order list','inv','de','Bestellungsliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Sum','inv','de','Summe');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Sum net','inv','de','Summe netto');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Position','inv','de','Position');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Page','inv','de','Seite');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Orders','inv','de','Bestellungen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order description','inv','de','Beschreibung der Bestellung');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order ID','inv','de','Bestellungs ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery ID','inv','de','Lieferungs ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Parent category','inv','de','&Uuml;bergeordnete Kategorie');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Choose the parent category','inv','de','W&auml;hlen der &uuml;bergeordneten Kategorie');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice date','inv','de','Rechnungsdatum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice ID','inv','de','Rechnungs ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery date','inv','de','Lieferungsdatum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Print invoice','inv','de','Rechnung drucken');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Create invoice','inv','de','Rechnung erstellen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Update invoice','inv','de','Rechnung &uuml;berarbeiten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('net','inv','de','netto');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('HTML','inv','de','HTML');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('PDF','inv','de','PDF');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery list','inv','de','Lieferungsliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice list','inv','de','Rechnungsliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('List deliveries','inv','de','Lieferungsliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('List invoices','inv','de','Rechnungsliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Print delivery','inv','de','Lieferung drucken');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Create delivery','inv','de','Lieferung erstellen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Update delivery','inv','de','Lieferung &uuml;berarbeiten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add to order','inv','de','Zur Bestellung hinzuf&uuml;gen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('View order','inv','de','Bestellung anzeigen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delete from order','inv','de','Von der Bestellung l&ouml;schen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Piece','inv','de','St&uuml;ck');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Selling price','inv','de','Verkaufspreis');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Selling date','inv','de','Verkaufsdatum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Retail','inv','de','Einzelhandelspreis');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Categories','inv','de','Kategorien');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Customer','inv','de','Kunde');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select customer','inv','de','Auswahl des Kunden');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select distributor','inv','de','Auswahl des Gro&szlig;h&auml;ndlers');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Company','inv','de','Firma');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Firstname','inv','de','Vorname');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Lastname','inv','de','Nachname');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select','inv','de','Ausw&auml;hlen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select your address','inv','de','W&auml;hlen Sie Ihre Adresse');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Products','inv','de','Produkte');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('View product','inv','de','Produkt anzeigen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('archive','inv','de','Archiv');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product archive','inv','de','Produkt Archiv');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order archive','inv','de','Bestellungs Archiv');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('tax','inv','de','Mwst.');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Out of stock products','inv','de','Nachzubestellende Produkte');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Out of stock product list','inv','de','Liste der nachzubestellenden Produkte');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock','inv','de','Lagerbestand');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('in Stock','inv','de','Lagerbestand - St&uuml;ck');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('min Stock','inv','de','Lagerbestand - minimum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock receipt','inv','de','Wareneingang');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock receipt list','inv','de','Liste der Wareneing&auml;nge');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery','inv','de','Lieferung');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice','inv','de','Rechnung');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Inventory preferences','inv','de','Inventar Einstellungen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('inv','preferences','de','Inventar');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('URL','inv','de','URL');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Industry type','inv','de','Industriezweig');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Phone','inv','de','Telefon');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Software','inv','de','Software');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Fax','inv','de','Fax');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('E-mail','inv','de','E-mail');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Department','inv','de','Department');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('WWW','inv','de','WWW');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('FTP','inv','de','FTP');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Contact','inv','de','Kontakt');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Pager','inv','de','Pager');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Notes','inv','de','Notizen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status list','inv','de','Produkt Statusliste');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add product','inv','de','Produkt hinzuf&uuml;gen');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit product','inv','de','Produkt bearbeiten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit order','inv','de','Bestellung bearbeiten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit category','inv','de','Kategorie bearbeiten');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select per button !','inv','de','per Button w&auml;hlen !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select category','inv','de','Auswahl der Kategorie');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select print format','inv','de','Auswahl des Druckformates');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('You have no customer selected !','inv','de','Bitte w&auml;hlen Sie einen Kunden !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Your search has returned no matchs !','inv','de','Ihre Suche erzielte keinen Treffer !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select currency and your address in preferences !','inv','de','Bitte w&auml;hlen Sie die W&auml;hrung und die Absenderadresse in den Benutzereinstellungen !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select your currency in preferences !','inv','de','Bitte w&auml;hlen Sie die W&auml;hrung in den Benutzereinstellungen !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select the print format in preferences !','inv','de','Bitte w&auml;hlen Sie das Druckformat in den Benutzereinstellungen !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select your address in preferences !','inv','de','Bitte w&auml;hlen Sie die Absenderadresse in den Benutzereinstellungen !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please enter a name for that category !','inv','de','Bitte w&auml;hlen Sie einen Namen f&uuml;r diese Kategorie !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this product ?','inv','de','M&ouml;chten Sie dieses Produkt l&ouml;schen ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this category ?','inv','de','M&ouml;chten Sie diese Kategorie l&ouml;schen ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this status ?','inv','de','M&ouml;chten Sie diesen Status l&ouml;schen ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this order ?','inv','de','M&ouml;chten Sie diese Bestellung l&ouml;schen ?');
							    