Fix #7591 - scanning templates for multiple projects using Content manager

[Pman.Cms] / sql / cms_template.sql

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