Oracle Apex Cloud Messenger

create table cloud_userinformation_tab

(

    id    number,

username  varchar2(80),

oldusername   varchar2(80),

nickname     varchar2(50),

gender    varchar2(50),

country   varchar2(80),

profilpic   blob,

MimeType  varchar2(2000),

FileName  varchar2(2000),

CharacterSet varchar2(2000),

BLOBLastUpdated date,

entrydate date,

updatedate date

)

 create table cloud_Messenger

(id  number,

text  varchar2(4000),

blobfile  blob,

MimeType  varchar2(2000),

FileName  varchar2(2000),

CharacterSet varchar2(2000),

BLOBLastUpdated date,

username varchar2(80),

entrydatetime  varchar2(80) , 

updatedatetime varchar2(80)

)