2 CREATE TABLE core_template (
3 id int(11) NOT NULL AUTO_INCREMENT,
4 template varchar(254) NOT NULL,
5 updated datetime NOT NULL,
6 lang varchar(6) NOT NULL,
8 INDEX lookup(template, lang)
11 ALTER TABLE core_template ADD COLUMN view_name varchar(32) NOT NULL default '';
12 ALTER TABLE core_template ADD COLUMN filetype varchar(32) NOT NULL default '';
13 ALTER TABLE core_template ADD COLUMN is_deleted INT(2) NOT NULL default 0;
14 alter table core_template add index lookupa(view_name, template, lang, filetype, is_deleted);