Fix #6494 - translations code for reports

[Pman.Core] / sql / core_template.sql

diff --git a/sql/core_template.sql b/sql/core_template.sql
index 62c8a04..4e5fb6d 100644 (file)
--- a/sql/core_template.sql
+++ b/sql/core_template.sql
@@ -9,3 +9,6 @@ CREATE TABLE  core_template (
 );
 
 ALTER TABLE core_template ADD COLUMN view_name varchar(32) NOT NULL default '';
+ALTER TABLE core_template ADD COLUMN filetype varchar(32) NOT NULL default '';
+ALTER TABLE core_template ADD COLUMN is_deleted INT(2) NOT NULL default 0;
+alter table core_template add index lookupa(view_name, template, lang, filetype, is_deleted);