mint/app/install/ref.sql

--
-- 由SQLiteStudio v3.1.1 产生的文件 周三 7月 29 16:58:33 2020
--
-- 文本编码：UTF-8
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- 表：dict
DROP TABLE IF EXISTS dict;

CREATE TABLE dict (
    id       INTEGER,
    language TEXT,
    dict_id  INTEGER,
    eword    TEXT,
    word     TEXT,
    paliword TEXT,
    mean     TEXT,
    length   INTEGER,
    status   INTEGER DEFAULT (1) 
);


-- 表：info
DROP TABLE IF EXISTS info;

CREATE TABLE info (
    language  TEXT,
    id        INTEGER PRIMARY KEY
                      NOT NULL,
    shortname TEXT,
    name      TEXT
);


-- 索引：eword
DROP INDEX IF EXISTS eword;

CREATE INDEX eword ON dict (
    "eword" ASC
);


-- 索引：len
DROP INDEX IF EXISTS len;

CREATE INDEX len ON dict (
    "length" ASC
);


-- 索引：word
DROP INDEX IF EXISTS word;

CREATE INDEX word ON dict (
    "word" ASC
);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;