#include "gtp_cmn.h"

char pgCreateSDIRMSGLogDb[2*PATHLEN+1]="create table sdirmsg_info(Flag integer,USERID Number,TRANS_TIME varchar(19), \n"
"TRANS_SEQ Number,EXPIRY Number,CRYPTFLAG integer,COMPRESSFLAG integer,EchoFlag integer, \n"
"PriorNo integer,SelfNodeId Number,SelfDirId Number,NodeId Number,DirId Number, \n"
"FILENUM Number,RUNSTATE integer,endtime varchar(19));create index idx_sdirmsg on SDIRMSG_INFO(USERID,TRANS_TIME,Flag)";
char pgCreateSDIRMSGLISTLogDb[2*PATHLEN+1]="create table sdirmsg_list(flag,integer,USERID Number,TRANS_TIME varchar(19),TRANS_SEQ Number, \n"
"FILENAME varchar(257),FILESIZE number,STARTTIME varchar(19),FINISHTIME varchar(19), RTNCODE integer); \n"
"create index idx_SDIRMSGLIST on SDIRMSG_LIST(flag,USERID,TRANS_TIME,STARTTIME)";