text: CREATE TABLE `localCertificate` (
      `id` int(20) NOT NULL AUTO_INCREMENT,
      `certID` VARCHAR(255) DEFAULT '',
      `personSysID` VARCHAR(255) DEFAULT '',
      `name` VARCHAR(255) DEFAULT '',
      `brand` VARCHAR(255) DEFAULT '',
      `numOfDose` int DEFAULT 0,
      `issueTime` DATETIME ,
      `issuer` VARCHAR(255) DEFAULT '',
      `remark` VARCHAR(255) DEFAULT '',
      `personInfoHash` TEXT,
      `merkleTreePath` TEXT, 
      `merkleTreeIndexes` TEXT,
      `globalRootID`   TEXT,
      `keyHash` TEXT, 
      `localChainID` VARCHAR(255) DEFAULT '',
      `localChainTxHash` TEXT,
      `localChainBlockNum` int DEFAULT 0,
      `localChainTimeStamp` VARCHAR(255) DEFAULT '', 
      UNIQUE KEY(`certID`),
      PRIMARY KEY(`id`)
  )ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
  
  CREATE TABLE `globalChainInfo` (
      `id` int(20) NOT NULL AUTO_INCREMENT,
      `certIDList` TEXT ,
      `merkleTreeRoot` TEXT, 
      `globalChainTxHash`TEXT ,
      `globalChainBlockNum` int DEFAULT 0,
      `globalChainTimeStamp` VARCHAR(255) DEFAULT '', 
      PRIMARY KEY(`id`)
  )ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
  
  