# file KLEIDER/web/src/localization/MySQLLookup_dbs.sql
# 2020-04-01 Herbert Schiemann <h.schiemann@herbaer.de>
# Legt die Datenbanken "translate" und "translrnbuf" an.

CREATE DATABASE translate;
USE translate;
CREATE TABLE src (
       id   INT        NOT NULL AUTO_INCREMENT,
       lang VARCHAR(5) NOT NULL,
       txt  BLOB       NOT NULL,
       PRIMARY KEY (id),
       INDEX txt (txt(100))
);
CREATE TABLE translation (
       src_id      INT        NOT NULL,
       lang        VARCHAR(5) NOT NULL,
       txt         BLOB       NOT NULL,
       PRIMARY KEY (src_id, lang)
);

CREATE DATABASE translrnbuf;
USE translrnbuf;
CREATE TABLE src (
       id   INT        NOT NULL AUTO_INCREMENT,
       lang VARCHAR(5) NOT NULL,
       txt  BLOB       NOT NULL,
       PRIMARY KEY (id),
       INDEX txt (txt(100))
);
CREATE TABLE translation (
       src_id      INT        NOT NULL,
       lang        VARCHAR(5) NOT NULL,
       txt         BLOB       NOT NULL,
       PRIMARY KEY (src_id, lang)
);

# end of file KLEIDER/web/src/localization/MySQLLookup_dbs.sql