 
 -- Table: articles
-CREATE TABLE articles ( 
+CREATE TABLE articles (
     id       INTEGER         PRIMARY KEY,
     title    VARCHAR( 255 ),
     textid   VARCHAR( 100 ),

    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 ),

    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,
