DB Schema

Embedded Sqlite

CREATE TABLE tbl_cat
(
    ID VARCHAR(200) NOT NULL PRIMARY KEY,
    count INTEGER NOT NULL DEFAULT '0'
);

CREATE TABLE wp_users
(
    ID VARCHAR(40) NOT NULL PRIMARY KEY,
    user_username VARCHAR(60) NOT NULL DEFAULT '',
    user_pubkey VARCHAR(255) NOT NULL DEFAULT '',
    user_registered DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
    display_name VARCHAR(250) NOT NULL DEFAULT ''
);

CREATE TABLE wp_posts
(
    ID VARCHAR(40) NOT NULL PRIMARY KEY,
    post_author VARCHAR(40) NOT NULL DEFAULT '0',
    post_date DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
    post_content LONGTEXT NOT NULL,
    post_title TEXT NOT NULL,
    post_modified DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
    thumb VARCHAR(255) NOT NULL DEFAULT '',
    cat VARCHAR(255) NOT NULL DEFAULT ''
);