2 CREATE TABLE core_templatestr (
3 id int(11) NOT NULL AUTO_INCREMENT,
4 template varchar(254) NOT NULL,
6 updated datetime NOT NULL,
7 src_id int(11) NOT NULL,
8 lang varchar(6) NOT NULL,
10 INDEX lookup(template, lang)
13 ALTER TABLE core_templatestr ADD COLUMN active INT(4) NOT NULL DEFAULT 0;
15 ALTER TABLE core_templatestr ADD COLUMN mdsum VARCHAR(64) NOT NULL DEFAULT '';
17 ALTER TABLE core_templatestr ADD COLUMN template_id INT(11) NOT NULL DEFAULT 0;
18 ALTER TABLE core_templatestr DROP COLUMN template;
20 ALTER TABLE core_templatestr ADD COLUMN on_table VARCHAR(64) DEFAULT '';
21 ALTER TABLE core_templatestr ADD COLUMN on_id INT(11) DEFAULT 0;
22 ALTER TABLE core_templatestr ADD COLUMN on_col VARCHAR(64) DEFAULT '';
24 ALTER TABLE core_templatestr ADD INDEX lookup_a(active, lang, on_table, on_id, on_col);