xoops_trust_path/libs/altsys/sql/mysql.sql
# CREATE TABLE `tablename` will be queried as
# CREATE TABLE `prefix_dirname_tablename`
CREATE TABLE language_constants
(
mid smallint(5) unsigned NOT NULL default 0,
language varchar(32) NOT NULL default '',
name varchar(191) NOT NULL default '',
value text,
PRIMARY KEY (mid, language, name)
) ENGINE=InnoDB;