Learning with Texts - Fork 2.4.0-fork
Learn foreign languages with texts
Database Information

  • The following seventeen tables are one "LWT table set". The default table set has no table name prefix, so the tables are named just as written below: "settings", "languages", etc.

    Additional table sets have its "table set name" plus an underscore "\_" as a table name prefix: "setname\_settings", "setname\_languages", etc. The "table set name" is max. 20 characters long. Allowed characters are only: a-z, A-Z, 0-9, and the underscore "\_".

    Only if the table set is not set in "connect.inc.php", the currently used table set is saved in a global table "\_lwtgeneral", in column LWTValue of row with LWTKey = "current\_table\_prefix". If such a row does not exist, the default table set will be used, or will be automatically created and used.

  • Table "settings" (Settings as Key-Value Pairs):
    StKey varchar(40) NOT NULL,
    StValue varchar(40) DEFAULT NULL,
    PRIMARY KEY (StKey)
  • Table "languages" (Defined languages):
    LgID tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
    LgName varchar(40) NOT NULL,
    LgDict1URI varchar(200) NOT NULL,
    LgDict2URI varchar(200) DEFAULT NULL,
    LgGoogleTranslateURI varchar(200) DEFAULT NULL,
    LgExportTemplate varchar(1000) DEFAULT NULL,
    LgTextSize smallint(5) unsigned NOT NULL DEFAULT '100',
    LgCharacterSubstitutions varchar(500) NOT NULL,
    LgRegexpSplitSentences varchar(500) NOT NULL,
    LgExceptionsSplitSentences varchar(500) NOT NULL,
    LgRegexpWordCharacters varchar(500) NOT NULL,
    LgRemoveSpaces tinyint(1) unsigned NOT NULL DEFAULT '0',
    LgSplitEachChar tinyint(1) unsigned NOT NULL DEFAULT '0',
    LgRightToLeft tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (LgID),
    UNIQUE KEY LgName (LgName)
  • Table "texts" (Active texts, parsed and cached in sentences and textitems):
    TxID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    TxLgID tinyint(3) unsigned NOT NULL, – LANGUAGE FOREIGN KEY –
    TxTitle varchar(200) NOT NULL,
    TxText text NOT NULL,
    TxAnnotatedText longtext NOT NULL,
    TxAudioURI varchar(200) DEFAULT NULL,
    TxSourceURI varchar(1000) DEFAULT NULL,
    TxPosition smallint(5) NOT NULL DEFAULT '0',
    TxAudioPosition float NOT NULL DEFAULT '0',
    PRIMARY KEY (TxID),
    KEY TxLgID (TxLgID)
  • Table "archivedtexts" (Text Archive, not parsed and cached):
    AtID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    AtLgID tinyint(3) unsigned NOT NULL, – LANGUAGE FOREIGN KEY –
    AtTitle varchar(200) NOT NULL,
    AtText text NOT NULL,
    AtAnnotatedText longtext NOT NULL,
    AtAudioURI varchar(200) DEFAULT NULL,
    AtSourceURI varchar(1000) DEFAULT NULL,
    PRIMARY KEY (AtID),
    KEY AtLgID (AtLgID)
  • Table "tags2" (Text tags and comments):
    T2ID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    T2Text varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    T2Comment varchar(200) NOT NULL DEFAULT '',
    PRIMARY KEY (T2ID),
    UNIQUE KEY T2Text (T2Text)
  • Table "texttags" (Text tags relations):
    TtTxID smallint(5) unsigned NOT NULL, – TEXT FOREIGN KEY –
    TtT2ID smallint(5) unsigned NOT NULL, – TEXT TAG FOREIGN KEY –
    PRIMARY KEY (TtTxID,TtT2ID),
    KEY TtT2ID (TtT2ID)
  • Table "archtexttags" (Archived text tags relations):
    AgAtID smallint(5) unsigned NOT NULL, – ARCHIVED TEXT FOREIGN KEY –
    AgT2ID smallint(5) unsigned NOT NULL, – TEXT TAG FOREIGN KEY –
    PRIMARY KEY (AgAtID,AgT2ID),
    KEY AgT2ID (AgT2ID)
  • Table "words" (the words and expressions you have saved):
    WoID mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    WoLgID tinyint(3) unsigned NOT NULL, – LANGUAGE FOREIGN KEY –
    WoText varchar(250) NOT NULL,
    WoTextLC varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    WoStatus tinyint(4) NOT NULL,
    WoTranslation varchar(500) NOT NULL DEFAULT '*',
    WoRomanization varchar(100) DEFAULT NULL,
    WoSentence varchar(1000) DEFAULT NULL,
    WoWordCount tinyint(3) unsigned NOT NULL DEFAULT '0',
    WoCreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    WoStatusChanged timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    WoTodayScore double NOT NULL DEFAULT '0',
    WoTomorrowScore double NOT NULL DEFAULT '0',
    WoRandom double NOT NULL DEFAULT '0',
    PRIMARY KEY (WoID),
    UNIQUE KEY WoLgIDTextLC (WoLgID,WoTextLC),
    KEY WoLgID (WoLgID),
    KEY WoStatus (WoStatus),
    KEY WoTextLC (WoTextLC),
    KEY WoTranslation (WoTranslation),
    KEY WoCreated (WoCreated),
    KEY WoStatusChanged (WoStatusChanged),
    KEY WoWordCount (WoWordCount),
    KEY WoTodayScore (WoTodayScore),
    KEY WoTomorrowScore (WoTomorrowScore),
    KEY WoRandom (WoRandom)
  • Table "tags" (Term tags and comments):
    TgID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    TgText varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    TgComment varchar(200) NOT NULL DEFAULT '',
    PRIMARY KEY (TgID),
    UNIQUE KEY TgText (TgText)
  • Table "wordtags" (Term tags relations):
    WtWoID int(11) unsigned NOT NULL, – TERM FOREIGN KEY –
    WtTgID smallint(5) unsigned NOT NULL, – TERM TAG FOREIGN KEY –
    PRIMARY KEY (WtWoID,WtTgID),
    KEY WtTgID (WtTgID)
  • Table "sentences" (Sentences cache, no backup needed):
    SeID mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    SeLgID tinyint(3) unsigned NOT NULL, – LANGUAGE FOREIGN KEY –
    SeTxID smallint(5) unsigned NOT NULL, – TEXT FOREIGN KEY –
    SeOrder smallint(5) unsigned NOT NULL,
    SeText text,
    SeFirstPos smallint(5) unsigned NOT NULL,
    PRIMARY KEY (SeID),
    KEY SeLgID (SeLgID),
    KEY SeTxID (SeTxID),
    KEY SeOrder (SeOrder)
  • Table "textitems2" (Text items cache, no backup needed):
    Ti2WoID mediumint(8) unsigned NOT NULL,
    Ti2LgID tinyint(3) unsigned NOT NULL, – LANGUAGE FOREIGN KEY –
    Ti2TxID smallint(5) unsigned NOT NULL, – TEXT FOREIGN KEY –
    Ti2SeID mediumint(8) unsigned NOT NULL, – SENTENCE FOREIGN KEY –
    Ti2Order smallint(5) unsigned NOT NULL,
    Ti2WordCount tinyint(3) unsigned NOT NULL,
    Ti2Text varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    PRIMARY KEY (Ti2TxID,Ti2Order,Ti2WordCount),
    KEY Ti2WoID (Ti2WoID)
  • Table "temptextitems" (memory table only used when creating texts, otherwise empty):
    TiCount smallint(5) unsigned NOT NULL,
    TiSeID mediumint(8) unsigned NOT NULL,
    TiOrder smallint(5) unsigned NOT NULL,
    TiWordCount tinyint(3) unsigned NOT NULL,
    TiText varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
  • Table "tempwords" (memory table only used when importing words, otherwise empty):
    WoText varchar(250) DEFAULT NULL,
    WoTextLC varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    WoTranslation varchar(500) NOT NULL DEFAULT '*',
    WoRomanization varchar(100) DEFAULT NULL,
    WoSentence varchar(1000) DEFAULT NULL,
    WoTaglist varchar(255) DEFAULT NULL,
    PRIMARY KEY (WoTextLC)
  • Table "feedlinks" (Newsfeed articles):
    FlID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    FlTitle varchar(200) NOT NULL,
    FlLink varchar(400) NOT NULL,
    FlDescription text NOT NULL,
    FlDate datetime NOT NULL,
    FlAudio varchar(200) NOT NULL,
    FlText longtext NOT NULL,
    FlNfID tinyint(3) unsigned NOT NULL,
    PRIMARY KEY (FlID),
    UNIQUE KEY FlTitle (FlTitle),
    KEY FlLink (FlLink),
    KEY FlDate (FlDate),
    KEY FlNfID (FlNfID)
  • Table "newsfeeds" (Newsfeed settings):
    NfID tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
    NfLgID tinyint(3) unsigned NOT NULL,
    NfName varchar(40) NOT NULL,
    NfSourceURI varchar(200) NOT NULL,
    NfArticleSectionTags text NOT NULL,
    NfFilterTags text NOT NULL,
    NfUpdate int(12) unsigned NOT NULL,
    NfOptions varchar(200) NOT NULL,
    PRIMARY KEY (NfID),
    KEY NfLgID (NfLgID),
    KEY NfUpdate (NfUpdate)
Generated by doxygen 1.9.3