CREATE TABLE `GXDEVICERESULT` (`GXAPPLICATIONID` char(127) NOT NULL , `GXQUERYID` char(127) NOT NULL , `GXRESULTSET` char(127) NOT NULL , `GXDEVICEID` char(127) NOT NULL , `GXSYNCDATE` date NOT NULL , PRIMARY KEY(`GXAPPLICATIONID`, `GXQUERYID`, `GXRESULTSET`, `GXDEVICEID`))  ENGINE=InnoDB

CREATE TABLE `GXRESULTROWS` (`GXRESULTSET` char(127) NOT NULL , `GXROWPK` varchar(255) NOT NULL , `GXROWHASH` char(127) , PRIMARY KEY(`GXRESULTSET`, `GXROWPK`))  ENGINE=InnoDB

CREATE TABLE `GXPARAMETERS` (`GXPARID` char(20) NOT NULL , `GXPARVALUE` char(80) , PRIMARY KEY(`GXPARID`))  ENGINE=InnoDB