CREATE TABLE [GXDEVICERESULT] ([GXAPPLICATIONID] char(127) NOT NULL , [GXQUERYID] char(127) NOT NULL , [GXRESULTSET] char(127) NOT NULL , [GXDEVICEID] char(127) NOT NULL , [GXSYNCDATE] datetime NOT NULL , PRIMARY KEY([GXAPPLICATIONID], [GXQUERYID], [GXRESULTSET], [GXDEVICEID]))

CREATE TABLE [GXRESULTROWS] ([GXRESULTSET] char(127) NOT NULL , [GXROWPK] varchar(255) NOT NULL , [GXROWHASH] char(127) NULL , PRIMARY KEY([GXRESULTSET], [GXROWPK]))

CREATE TABLE [GXPARAMETERS] ([GXPARID] char(20) NOT NULL , [GXPARVALUE] char(80) NULL , PRIMARY KEY([GXPARID]))