Работа с Viber (обычная и управляемая форма)

CREATE TABLE Calls (

EventID INTEGER REFERENCES Events (EventID) ON UPDATE CASCADE,

Type SMALLINT NOT NULL,

Duration [UNSIGNED INTEGER],

Status [UNSIGNED INTEGER] NOT NULL,

PRIMARY KEY (

EventID

)

);

CREATE TABLE ChatInfo (

ChatID INTEGER PRIMARY KEY AUTOINCREMENT,

Name VARCHAR (200),

Token VARCHAR (50),

Flags INTEGER DEFAULT 0,

TimeStamp LONGINT NOT NULL,

IconID VARCHAR (255),

BackgroundID VARCHAR (255),

LastReadMessageToken INTEGER DEFAULT 0,

LastReadMessageId INTEGER DEFAULT 0,

PGType INTEGER,

PGUri VARCHAR (255),

PGRevision INTEGER,

PGLongtitude INTEGER,

PGLatitude INTEGER,

PGCountry VARCHAR (255),

PGTabLine VARCHAR (255),

PGTags VARCHAR (255),

PGLastMessageID INTEGER,

PGWatchersCount INTEGER,

PGSearchFlags INTEGER,

MetaData VARCHAR (255)

);

CREATE TABLE ChatRelation (

ChatID INTEGER REFERENCES ChatInfo (ChatID)

NOT NULL,

ContactID INTEGER REFERENCES Contact (ContactID)

NOT NULL,

PGRole INTEGER,

PRIMARY KEY (

ChatID,

ContactID

)

);

CREATE TABLE ChatsMetaData (

ChatToken VARCHAR (50) NOT NULL,

Type INTEGER NOT NULL,

Value VARCHAR NOT NULL,

PRIMARY KEY (

ChatToken,

Type

)

);

CREATE TABLE Contact (

ContactID INTEGER PRIMARY KEY AUTOINCREMENT,

Name TEXT,

ABContact SMALLINT (0, 1) DEFAULT 0

NOT NULL,

ViberContact SMALLINT (0, 1) DEFAULT 0

NOT NULL,

Number TEXT UNIQUE,

MID TEXT UNIQUE,

EncryptedNumber TEXT UNIQUE,

EncryptedMID TEXT UNIQUE,

VID TEXT UNIQUE,

ClientName TEXT,

DownloadID TEXT,

ContactFlags LONG DEFAULT 0,

SortName TEXT,

Timestamp LONGINT DEFAULT 0

);

CREATE TABLE DownloadFile (

DownloadID VARCHAR (100) NOT NULL,

EventID INTEGER REFERENCES Events (EventID) ON UPDATE CASCADE,

BucketName VARCHAR (200) NOT NULL,

FileType VARCHAR (10) NOT NULL,

DownloadStatus [SMALL INT] NOT NULL,

ImageSize INTEGER NOT NULL

DEFAULT 0,

DownloadType [SMALL INT] NOT NULL,

Type [SMALL INT] NOT NULL

DEFAULT 3,

Priority INTEGER NOT NULL

DEFAULT 0,

FileName VARCHAR (200),

Url VARCHAR (10000),

TempFileName VARCHAR (1000),

EncryptionParams VARCHAR (255),

PRIMARY KEY (

DownloadID,

EventID,

Type

)

);

CREATE 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

);

CREATE TABLE EventsMetaData (

EventID INTEGER REFERENCES Events (EventID) ON DELETE CASCADE

NOT NULL,

Type INTEGER NOT NULL,

Value VARCHAR NOT NULL,

PRIMARY KEY (

EventID,

Type

)

);

CREATE TABLE LikeRelation (

MessageToken INTEGER NOT NULL,

LikeEventID INTEGER REFERENCES Events (EventID) ON DELETE CASCADE

NOT NULL,

PRIMARY KEY (

MessageToken,

LikeEventID

)

);

CREATE 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

)

);

CREATE TABLE RecycleBin (

DownloadID VARCHAR (100),

Type INTEGER,

PRIMARY KEY (

DownloadID,

Type

)

);

CREATE TABLE Settings (

Title VARCHAR (200) NOT NULL

PRIMARY KEY

UNIQUE,

Value VARCHAR (2000) NOT NULL

);

CREATE TABLE UploadFile (

File VARCHAR (3000) NOT NULL,

EventID INTEGER REFERENCES Events (EventID) ON UPDATE CASCADE,

FileType VARCHAR (10) NOT NULL,

FileSize LONG NOT NULL,

CheckSum VARCHAR (100) NOT NULL,

[Offset] LONG DEFAULT 0,

Seq VARCHAR (100) NOT NULL,

MediaType SMALLINT NOT NULL,

UploadType SMALLINT NOT NULL,

UploadStatus [SMALL INT] NOT NULL,

UDID VARCHAR (100) NOT NULL,

ThumbnailFile VARCHAR (3000),

Type SMALLINT,

Url VARCHAR (10000),

ObjectID VARCHAR (30),

EncryptionParams VARCHAR (255),

PRIMARY KEY (

File,

EventID

)

);

CREATE TABLE Versions (

VersionID INTEGER PRIMARY KEY AUTOINCREMENT,

VersionNumber VARCHAR (20),

TimeStamp LONGINT NOT NULL,

Status SMALLINT NOT NULL,

Title VARCHAR (200)

);