Чтение базы ViberPC (viber.db)

CRE ATE   TABLE Messages (
    EventID            INTEGER            REFERENCES Events (EventID) ON UPDATE CASCADE,
    Type               [UNSIGNED INTEGER] NOT NULL,
    Status             INTEGER            NOT NULL,
    Subject            VARCHAR (500),
    Body               VARCHAR (5000),
    Flag               [UNSIGNED INTEGER] DEFAULT 0,
    PayloadPath        VARCHAR (1000),
    ThumbnailPath      VARCHAR (100),
    StickerID          [UNSIGNED LONG]    DEFAULT 0,
    PttID              VARCHAR (100),
    PttStatus          [UNSIGNED SHORT]   DEFAULT 0,
    Duration           SIGNED             DEFAULT 0,
    PGMessageId        [UNSIGNED LONG]    DEFAULT 0,
    PGIsLiked          INTEGER,
    PGLikeCount        INTEGER,
    Info               VARCHAR (7000),
    AppId              INTEGER            DEFAULT 0,
    ClientFlag         [UNSIGNED INTEGER] DEFAULT 0,
    FollowersLikeCount [UNSIGNED INTEGER] DEFAULT 0,
    PRIMARY KEY (
        EventID
    )
);

CRE ATE   TABLE Events (
    EventID           INTEGER                   PRIMARY KEY AUTOINCREMENT,
    TimeStamp         LONGINT                   NOT NULL,
    Direction         [UNSIGNED INTEGER]        NOT NULL,
    Type              SMALLINT                  NOT NULL,
    ContactLongitude  [SIGNED LONG]             DEFAULT 0,
    ContactLatitude   [SIGNED LONG]             DEFAULT 0,
    ChatID            INTEGER                   REFERENCES ChatInfo (ChatID) ON UPDATE CASCADE,
    ContactID         INTEGER                   REFERENCES Contact (ContactID) ON UPDATE CASCADE,
    IsSessionLifeTime [UNSIGNED INTEGER] (0, 1) DEFAULT 0,
    Flags             INTEGER                   DEFAULT 0,
    Token             [UNSIGNED LONG]           NOT NULL,
    IsRead            SMALLINT (0, 1)           NOT NULL
                                                DEFAULT 0,
    SortOrder         [UNSIGNED LONG]           NOT NULL
                                                DEFAULT 0,
    Seq               INTEGER                   NOT NULL
                                                DEFAULT 0
);

CRE ATE   TABLE Contact (
    ContactID       INTEGER         PRIMARY KEY AUTOINCREMENT,
    Name            TEXT,
    ABContact       SMALLINT (0, 1) DEFAULT 0
                                    NOT NULL,
    SortName        TEXT,
    Number          TEXT            UNIQUE,
    ViberContact    SMALLINT (0, 1) DEFAULT 0
                                    NOT NULL,
    ClientName      TEXT,
    DownloadID      TEXT,
    EncryptedNumber TEXT            UNIQUE,
    MID             TEXT            UNIQUE,
    VID             TEXT            UNIQUE,
    ContactFlags    LONG            DEFAULT 0
);