xoopscube/altsys

View on GitHub
xoops_trust_path/libs/altsys/sql/mysql.sql

Summary

Maintainability
Test Coverage
# 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;