<commit_before>
-- Table: articles
CREATE TABLE articles ( 
    id       INTEGER         PRIMARY KEY,
    title    VARCHAR( 255 ),
    textid   VARCHAR( 100 ),
    sort     INT( 11 ),
    summary  VARCHAR( 255 ),
    text     LONGTEXT,
    keywords VARCHAR( 255 ),
    author   VARCHAR( 200 ),
    status   TINYINT( 1 ),
    created  DATE,
    publish  DATE,
    expires  DATE,
    updated  TIMESTAMP       DEFAULT 'CURRENT_TIMESTAMP' 
);--end
-- Table: menu
CREATE TABLE menu ( 
    id     INTEGER         PRIMARY KEY,
    item   VARCHAR( 100 ),
    href   VARCHAR( 255 ),
    target VARCHAR( 20 ),
    title  VARCHAR( 200 ),
    menu   VARCHAR( 100 ),
    sort   INT( 11 ),
    subof  INT( 11 )       DEFAULT ( NULL ) 
);--end
-- Table: tag
CREATE TABLE tag ( 
    id    INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT 
);--end
-- Table: articles_tag
CREATE TABLE articles_tag ( 
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    articles_id INTEGER,
    tag_id      INTEGER,
    FOREIGN KEY ( articles_id ) REFERENCES articles ( id ) ON DELETE CASCADE
                                                               ON UPDATE SET NULL,
    FOREIGN KEY ( tag_id ) REFERENCES tag ( id ) ON DELETE CASCADE
                                                     ON UPDATE SET NULL 
);--end
-- Table: menutrans
CREATE TABLE menutrans ( 
    id      INTEGER PRIMARY KEY AUTOINCREMENT,
    lang    TEXT,
    status  INTEGER,
    item    TEXT,
    title   TEXT,
    menu_id INTEGER,
    FOREIGN KEY ( menu_id ) REFERENCES menu ( id ) ON DELETE SET NULL
                                                       ON UPDATE SET NULL 
);--end
-- Table: arttrans
CREATE TABLE arttrans ( 
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    lang        TEXT,
    status      INTEGER,
    title       TEXT,
    summary     TEXT,
    text        TEXT,
    keywords    TEXT,
    articles_id INTEGER,
    FOREIGN KEY ( articles_id ) REFERENCES articles ( id ) ON DELETE SET NULL
                                                               ON UPDATE SET NULL 
);--end
-- Index: index_foreignkey_menutrans_menu
CREATE INDEX index_foreignkey_menutrans_menu ON menutrans ( 
    menu_id 
);--end
-- Index: index_foreignkey_arttrans_articles
CREATE INDEX index_foreignkey_arttrans_articles ON arttrans ( 
    articles_id 
);<commit_msg>Added seo table scheme to main installation<commit_after>
-- Table: articles
CREATE TABLE articles (
    id       INTEGER         PRIMARY KEY,
    title    VARCHAR( 255 ),
    textid   VARCHAR( 100 ),
    sort     INT( 11 ),
    summary  VARCHAR( 255 ),
    text     LONGTEXT,
    keywords VARCHAR( 255 ),
    author   VARCHAR( 200 ),
    status   TINYINT( 1 ),
    created  DATE,
    publish  DATE,
    expires  DATE,
    updated  TIMESTAMP       DEFAULT 'CURRENT_TIMESTAMP'
);--end
-- Table: menu
CREATE TABLE menu (
    id     INTEGER         PRIMARY KEY,
    item   VARCHAR( 100 ),
    href   VARCHAR( 255 ),
    target VARCHAR( 20 ),
    title  VARCHAR( 200 ),
    menu   VARCHAR( 100 ),
    sort   INT( 11 ),
    subof  INT( 11 )       DEFAULT ( NULL )
);--end
-- Table: tag
CREATE TABLE tag (
    id    INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT
);--end
-- Table: seo
CREATE TABLE seo (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    url         VARCHAR( 255 ),
    title       VARCHAR( 255 ),
    description VARCHAR( 255 ),
    keywords    VARCHAR( 255 )
);--end

-- Table: articles_tag
CREATE TABLE articles_tag (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    articles_id INTEGER,
    tag_id      INTEGER,
    FOREIGN KEY ( articles_id ) REFERENCES articles ( id ) ON DELETE CASCADE
                                                               ON UPDATE SET NULL,
    FOREIGN KEY ( tag_id ) REFERENCES tag ( id ) ON DELETE CASCADE
                                                     ON UPDATE SET NULL
);--end
-- Table: menutrans
CREATE TABLE menutrans (
    id      INTEGER PRIMARY KEY AUTOINCREMENT,
    lang    TEXT,
    status  INTEGER,
    item    TEXT,
    title   TEXT,
    menu_id INTEGER,
    FOREIGN KEY ( menu_id ) REFERENCES menu ( id ) ON DELETE SET NULL
                                                       ON UPDATE SET NULL
);--end
-- Table: arttrans
CREATE TABLE arttrans (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    lang        TEXT,
    status      INTEGER,
    title       TEXT,
    summary     TEXT,
    text        TEXT,
    keywords    TEXT,
    articles_id INTEGER,
    FOREIGN KEY ( articles_id ) REFERENCES articles ( id ) ON DELETE SET NULL
                                                               ON UPDATE SET NULL
);--end
-- Index: index_foreignkey_menutrans_menu
CREATE INDEX index_foreignkey_menutrans_menu ON menutrans (
    menu_id
);--end
-- Index: index_foreignkey_arttrans_articles
CREATE INDEX index_foreignkey_arttrans_articles ON arttrans (
    articles_id
);
{'fraction_non_alphanumeric': 0.06601066010660106, 'fraction_numerical': 0.017220172201722016, 'mean_word_length': 1.6763576522216128, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 16, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1334616', 'n_tokens_mistral': 1569, 'n_tokens_neox': 1373, 'n_words': 473}