CREATE TABLE IF NOT EXISTS `encomendas` (
  `title` varchar(100) NOT NULL,
  `loja` varchar(50) NOT NULL,
  `dt_compra` date NOT NULL,
  `dt_venda` date NOT NULL,
  `dt_prv_ent` date NOT NULL,
  `md5sum` char(30) NOT NULL,
  `data` mediumblob NOT NULL,
  `tracking` char(100) NOT NULL,
  `status` varchar(5) NOT NULL
)