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

INSERT INTO lang (message_id, app_name, lang, content) VALUES('That Category ID has been used already !','inv','en','That Category ID has been used already !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That Product ID has been used already !','inv','en','That Product ID has been used already !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That product name has been used already !','inv','en','That product name has been used already !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('That category name has been used already !','inv','en','That category name has been used already !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category name','inv','en','Category name');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Do you also want to delete all subcategories ?','inv','en','Do you also want to delete all subcategories ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Click me','inv','en','Click me');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Product ID ?','inv','en','Generate Product ID ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Order ID ?','inv','en','Generate Order ID ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Invoice ID ?','inv','en','Generate Invoice ID ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Generate Delivery ID ?','inv','en','Generate Delivery ID ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category x has been added !','inv','en','Category %1 has been added !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order x has been added !','inv','en','Order %1 has been added !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery x has been created !','inv','en','Delivery %1 has been created !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery x has been updated !','inv','en','Delivery %1 has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice x has been created !','inv','en','Invoice %1 has been created !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice x has been updated !','inv','en','Invoice %1 has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product x x has been added !','inv','en','Product %1 %2 has been added !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category x has been updated !','inv','en','Category %1 has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order x has been updated !','inv','en','Order %1 has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product x x has been updated !','inv','en','Product %1 %2 has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category ID','inv','en','Category ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category','inv','en','Category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Available','inv','en','Available');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Other','inv','en','Other');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Unknown','inv','en','Unknown');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Saled','inv','en','Saled');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Back order','inv','en','Back order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('No longer available','inv','en','No longer available');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Date','inv','en','Date');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Open','inv','en','Open');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Closed','inv','en','Closed');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Cost','inv','en','Cost');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Company name','inv','en','Company name');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Price','inv','en','Price');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Status','inv','en','Status');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add category','inv','en','Add category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Name','inv','en','Name');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add distributor','inv','en','Add distributor');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Serial number','inv','en','Serial number');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add order','inv','en','Add order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add product status','inv','en','Add product status');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit product status','inv','en','Edit product status');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Search this category','inv','en','Search this category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product ID','inv','en','Product ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Description','inv','en','Description');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status','inv','en','Product status');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Purchase price','inv','en','Purchase price');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Purchase date','inv','en','Purchase date');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('a piece','inv','en','a piece');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Category list','inv','en','Category list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product list','inv','en','Product list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributor list','inv','en','Distributor list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributors','inv','en','Distributors');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Distributor','inv','en','Distributor');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order list','inv','en','Order list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Sum','inv','en','Sum');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Sum net','inv','en','Sum net');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Position','inv','en','Position');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Page','inv','en','Page');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Orders','inv','en','Orders');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order ID','inv','en','Order ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order description','inv','en','Order description');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery ID','inv','en','Delivery ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Parent category','inv','en','Parent category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Choose the parent category','inv','en','Choose the parent category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice date','inv','en','Invoice date');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice ID','inv','en','Invoice ID');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery date','inv','en','Delivery date');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Print invoice','inv','en','Print invoice');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Create invoice','inv','en','Create invoice');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Update invoice','inv','en','Update invoice');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('net','inv','en','net');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('HTML','inv','en','HTML');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('PDF','inv','en','PDF');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery list','inv','en','Delivery list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice list','inv','en','Invoice list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('List deliveries','inv','en','List deliveries');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('List invoices','inv','en','List invoices');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Print delivery','inv','en','Print delivery');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Create delivery','inv','en','Create delivery');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Update delivery','inv','en','Update delivery');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add to order','inv','en','Add to order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('View order','inv','en','View order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delete from order','inv','en','Delete from order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Piece','inv','en','Piece');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Selling price','inv','en','Selling price');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Selling date','inv','en','Selling date');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Retail','inv','en','Retail');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Categories','inv','en','Categories');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Customer','inv','en','Customer');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select customer','inv','en','Select customer');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select distributor','inv','en','Select distributor');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Company','inv','en','Company');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Firstname','inv','en','Firstname');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Lastname','inv','en','Lastname');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select','inv','en','Select');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select your address','inv','en','Select your address');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Products','inv','en','Products');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('View product','inv','en','View product');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('archive','inv','en','Archive');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product archive','inv','en','Product archive');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Order archive','inv','en','Order archive');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('tax','inv','en','tax');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Out of stock products','inv','en','Out of stock products');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Out of stock product list','inv','en','Out of stock product list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock','inv','en','Stock');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('in Stock','inv','en','in Stock');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('min Stock','inv','en','min Stock');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock receipt','inv','en','Stock receipt');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Stock receipt list','inv','en','Stock receipt list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Delivery','inv','en','Delivery');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Invoice','inv','en','Invoice');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Inventory preferences','inv','en','Inventory preferences');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('inv','preferences','en','Inventory');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('URL','inv','en','URL');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Industry type','inv','en','Industry type');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Phone','inv','en','Phone');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Software','inv','en','Software');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Fax','inv','en','Fax');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('E-mail','inv','en','E-mail');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Department','inv','en','Department');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('WWW','inv','en','WWW');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('FTP','inv','en','FTP');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Contact','inv','en','Contact');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Pager','inv','en','Pager');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Notes','inv','en','Notes');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status list','inv','en','Product status list');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status has been added !','inv','en','Product status has been added !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Product status has been updated !','inv','en','Product status has been updated !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Add product','inv','en','Add product');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit product','inv','en','Edit product');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit order','inv','en','Edit order');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Edit category','inv','en','Edit category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select per button !','inv','en','Select per button !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select category','inv','en','Select category');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Select print format','inv','en','Select print format');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('You have no customer selected !','inv','en','You have no customer selected !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Your search has returned no matchs !','inv','en','Your search has returned no matchs !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select currency and your address in preferences !','inv','en','Please select currency and your address in preferences !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select your currency in preferences !','inv','en','Please select your currency in preferences !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select the print format in preferences !','inv','en','Please select the print format in preferences !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please select your address in preferences !','inv','en','Please select your address in preferences !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Please enter a name for that category !','inv','en','Please enter a name for that category !');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this product ?','inv','en','Are you sure you want to delete this product ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this category ?','inv','en','Are you sure you want to delete this category ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this status ?','inv','en','Are you sure you want to delete this status ?');
INSERT INTO lang (message_id, app_name, lang, content) VALUES('Are you sure you want to delete this order ?','inv','en','Are you sure you want to delete this order ?');
							    