CREATE TABLE `HTAtxp_lang` ( `id` int(9) NOT NULL auto_increment, `lang` varchar(16) default NULL, `name` varchar(64) default NULL, `event` varchar(64) default NULL, `data` tinytext, `lastmod` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `lang` (`lang`,`name`), KEY `lang_2` (`lang`,`event`) );