3EQCBBN0

1CREATE TABLE IF NOT EXISTS `PagSeguroTransacoes` (
2  `TransacaoID` varchar(36) collate latin1_general_ci NOT NULL,
3  `VendedorEmail` varchar(200) collate latin1_general_ci NOT NULL,
4  `Referencia` varchar(200) collate latin1_general_ci default NULL,
5  `TipoFrete` char(2) collate latin1_general_ci default NULL,
6  `ValorFrete` decimal(10,2) default NULL,
7  `Extras` decimal(10,2) default NULL,
8  `Anotacao` text collate latin1_general_ci,
9  `TipoPagamento` varchar(50) collate latin1_general_ci NOT NULL,
10  `StatusTransacao` varchar(50) collate latin1_general_ci NOT NULL,
11  `CliNome` varchar(200) collate latin1_general_ci NOT NULL,
12  `CliEmail` varchar(200) collate latin1_general_ci NOT NULL,
13  `CliEndereco` varchar(200) collate latin1_general_ci NOT NULL,
14  `CliNumero` varchar(10) collate latin1_general_ci default NULL,
15  `CliComplemento` varchar(100) collate latin1_general_ci default NULL,
16  `CliBairro` varchar(100) collate latin1_general_ci NOT NULL,
17  `CliCidade` varchar(100) collate latin1_general_ci NOT NULL,
18  `CliEstado` char(2) collate latin1_general_ci NOT NULL,
19  `CliCEP` varchar(9) collate latin1_general_ci NOT NULL,
20  `CliTelefone` varchar(14) collate latin1_general_ci default NULL,
21  `NumItens` int(11) NOT NULL,
22  `data` date NOT NULL default '0000-00-00',
23  PRIMARY KEY  (`TransacaoID`)
24) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;