First thing, thank you very much for this amazing piece of software.
I received the following error:
[EMAIL PROTECTED]:~$ sqlt -d --from=MySQL --to=HTML --pretty
--title=orolixPrize ~/var/tmp/pz.mysql > /srv/www/pz.html
[SQL::Translator] Got parser: code ref
[SQL::Translator] Got producer: code ref
[SQL::Translator] Got parser: SQL::Translator::Parser::MySQL::parse
[SQL::Translator] Got producer: SQL::Translator::Producer::HTML::produce
[SQL::Translator] Got filename: '/home/ldutra/var/tmp/pz.mysql'
[SQL::Translator] Opening '/home/ldutra/var/tmp/pz.mysql' to get contents.
[SQL::Translator]
ERROR (line 151): Invalid statement: Was expecting comment, or use, or
set, or drop, or create, or alter, or insert
Error: translate: Error with parser 'SQL::Translator::Parser::MySQL': no
results at /usr/bin/sqlt line 290.
[EMAIL PROTECTED]:~$
But the DDL seems innocent enough:
CREATE TABLE `EcommerceOrder` (
`idEcommOrder` bigint(20) NOT NULL auto_increment,
`partner` varchar(30) NOT NULL default '',
`status` int(1) NOT NULL default '0',
`description` varchar(255) default '',
`orosVal` bigint(20) NOT NULL default '0',
`date` datetime default '0000-00-00 00:00:00',
`idUser` bigint(20) NOT NULL default '0',
`orosCommission` bigint(20) NOT NULL default '0',
PRIMARY KEY (`idEcommOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `EcommerceTransaction` (
`idEcommTransaction` bigint(20) NOT NULL auto_increment,
`idEcommOrder` bigint(20) NOT NULL default '0',
`token` bigint(20) NOT NULL default '0',
`idSubAccountType` bigint(20) NOT NULL default '0',
`orosVal` bigint(20) NOT NULL default '0',
PRIMARY KEY (`idEcommTransaction`),
KEY `idEcommOrder` (`idEcommOrder`),
CONSTRAINT `EcommerceTransaction_ibfk_1` FOREIGN KEY (`idEcommOrder`)
REFERENCES `EcommerceOrder` (`idEcommOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `TransactionTypes` (
`idTransactionType` int(10) unsigned NOT NULL default '0',
`internalName` varchar(30) NOT NULL default '',
`description` varchar(60) default NULL,
PRIMARY KEY (`idTransactionType`),
UNIQUE KEY `internalName_2` (`internalName`),
KEY `internalName` (`internalName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `Transactions` (
`idTransaction` bigint(20) unsigned NOT NULL auto_increment,
`idTransactionType` int(10) unsigned NOT NULL default '0',
`toIdResource` int(10) unsigned NOT NULL default '0',
`toIdDAO` int(10) unsigned NOT NULL default '0',
`toIdDataSource` int(10) unsigned NOT NULL default '0',
`toIdAccount` bigint(20) unsigned NOT NULL default '0',
`toIdSubAccountType` int(10) unsigned NOT NULL default '0',
`fromIdResource` int(10) unsigned NOT NULL default '0',
`fromIdDAO` int(10) unsigned NOT NULL default '0',
`fromIdDataSource` int(10) unsigned NOT NULL default '0',
`fromIdAccount` bigint(20) unsigned NOT NULL default '0',
`fromIdSubAccountType` int(10) unsigned NOT NULL default '0',
`description` varchar(100) default NULL,
`value` bigint(20) unsigned NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`idTransaction`),
KEY `idTransactionType` (`idTransactionType`),
CONSTRAINT `Transactions_ibfk_1` FOREIGN KEY (`idTransactionType`) REFERENCES
`TransactionTypes` (`idTransactionType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `Accounts` (
`idAccount` bigint(20) unsigned NOT NULL auto_increment,
`idUser` bigint(20) unsigned NOT NULL default '0',
`userName` varchar(40) default NULL,
`typeAccount` int(11) default NULL,
`status` int(11) default NULL,
PRIMARY KEY (`idAccount`),
UNIQUE KEY `uk_acct` (`idUser`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `Currencies` (
`idCurrency` int(10) unsigned NOT NULL default '0',
`internalName` varchar(30) default NULL,
`descSingle` varchar(50) default NULL,
`descMultiple` varchar(50) default NULL,
PRIMARY KEY (`idCurrency`),
UNIQUE KEY `internalName` (`internalName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `LogTransTypes` (
`idLogTransType` int(10) unsigned NOT NULL auto_increment,
`description` varchar(60) default NULL,
PRIMARY KEY (`idLogTransType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `Operations` (
`idOperation` bigint(20) unsigned NOT NULL auto_increment,
`idManager` int(10) unsigned NOT NULL default '0',
`tokenValue` bigint(20) unsigned NOT NULL default '0',
`idResource` int(10) unsigned NOT NULL default '0',
`idDAO` int(10) unsigned NOT NULL default '0',
`idDataSource` int(10) unsigned NOT NULL default '0',
`idAccount` bigint(20) unsigned NOT NULL default '0',
`idSubAccountType` int(10) unsigned NOT NULL default '0',
`value` bigint(20) unsigned NOT NULL default '0',
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`idOperation`),
UNIQUE KEY `idManager_2` (`idManager`,`tokenValue`,`value`),
KEY `idManager` (`idManager`),
KEY `tokenValue` (`tokenValue`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `SubAccountExtra` (
`idSubAccountType` int(10) unsigned NOT NULL default '0',
`maxValue` bigint(20) NOT NULL default '0',
`initialBalance` bigint(20) NOT NULL default '0',
`sourceIdUser` bigint(20) unsigned default NULL,
`sourceIdSubAccountType` bigint(20) unsigned default NULL,
`priority` bigint(3) default NULL,
UNIQUE KEY `idSubAccountType` (`idSubAccountType`),
CONSTRAINT `SubAccountExtra_ibfk_1` FOREIGN KEY (`idSubAccountType`)
REFERENCES `SubAccountTypes` (`idSubAccountType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `SubAccountHistory` (
`idSubAccountHistory` bigint(20) unsigned NOT NULL auto_increment,
`idManager` int(10) unsigned NOT NULL default '0',
`idTransaction` bigint(20) unsigned NOT NULL default '0',
`idLogTransType` int(10) unsigned NOT NULL default '0',
`idAccount` bigint(20) unsigned NOT NULL default '0',
`idSubAccountType` int(10) unsigned NOT NULL default '0',
`description` varchar(100) default NULL,
`value` bigint(20) default NULL,
`dateTrans` datetime default NULL,
PRIMARY KEY (`idSubAccountHistory`),
KEY `idAccount` (`idAccount`),
KEY `idSubAccountType` (`idSubAccountType`),
CONSTRAINT `SubAccountHistory_ibfk_1` FOREIGN KEY (`idSubAccountType`)
REFERENCES `SubAccountTypes` (`idSubAccountType`),
CONSTRAINT `SubAccountHistory_ibfk_2` FOREIGN KEY (`idAccount`) REFERENCES
`Accounts` (`idAccount`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `SubAccountTransactionType` (
`idSubAccountType` int(10) unsigned NOT NULL default '0',
`idTransactionType` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `idSubAccountType` (`idSubAccountType`,`idTransactionType`),
CONSTRAINT `SubAccountTransactionType_ibfk_1` FOREIGN KEY
(`idSubAccountType`) REFERENCES `SubAccountTypes` (`idSubAccountType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `SubAccountTypes` (
`idSubAccountType` int(10) unsigned NOT NULL auto_increment,
`internalName` varchar(30) default NULL,
`idCurrency` int(10) unsigned NOT NULL default '0',
`status` int(11) default NULL,
`description` varchar(30) default NULL,
`dataFechamento` date default NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`idSubAccountType`),
UNIQUE KEY `internalName` (`internalName`),
KEY `idCurrency` (`idCurrency`),
CONSTRAINT `SubAccountTypes_ibfk_1` FOREIGN KEY (`idCurrency`) REFERENCES
`Currencies` (`idCurrency`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `SubAccounts` (
`idSubAccount` bigint(20) unsigned NOT NULL auto_increment,
`idAccount` bigint(20) unsigned NOT NULL default '0',
`idSubAccountType` int(10) unsigned NOT NULL default '0',
`limitValue` bigint(20) NOT NULL default '0',
`balance` bigint(20) NOT NULL default '0',
`totalReceived` bigint(20) NOT NULL default '0',
`guestTotalReceived` bigint(20) NOT NULL default '0',
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`partnerMaxValueDate` date default NULL,
PRIMARY KEY (`idSubAccount`),
UNIQUE KEY `idAccount` (`idAccount`,`idSubAccountType`),
KEY `idAccount_2` (`idAccount`),
KEY `idSubAccountType` (`idSubAccountType`),
CONSTRAINT `SubAccounts_ibfk_1` FOREIGN KEY (`idSubAccountType`) REFERENCES
`SubAccountTypes` (`idSubAccountType`),
CONSTRAINT `SubAccounts_ibfk_2` FOREIGN KEY (`idAccount`) REFERENCES
`Accounts` (`idAccount`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `rv_extra` (
`idEcommOrder` bigint(20) NOT NULL default '0',
`codigoOrolix` bigint(20) NOT NULL default '0',
`codigoRV` bigint(20) NOT NULL default '0',
`produto` bigint(20) NOT NULL default '0',
`preco` decimal(19,3) NOT NULL default '0.000',
`face` decimal(19,3) NOT NULL default '0.000',
`vencimento` date NOT NULL default '0000-00-00',
`pago` decimal(1,0) NOT NULL default '0',
`pin` varchar(50) NOT NULL default '',
`lote` int(11) NOT NULL default '0',
`serie` bigint(20) NOT NULL default '0',
`mensagem` varchar(255) NOT NULL default '',
`operadora` varchar(50) NOT NULL default '',
`estado` varchar(2) NOT NULL default '',
`login` varchar(20) NOT NULL default '',
`nomeCurtoProduto` varchar(50) NOT NULL default '',
PRIMARY KEY (`idEcommOrder`),
CONSTRAINT `fk_rvxtr` FOREIGN KEY (`idEcommOrder`) REFERENCES
`orolixPrizeManager`.`EcommerceOrder` (`idEcommOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='RV transaction confirmation
information (cell card purchase)';
Ideas?
--
Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel)
Administrador de (Bases de) Dados +55 (11) 2122 0302 (com)
http://br.geocities.com./lgcdutra/ +55 (11) 5685 2219 (res)
BRASIL mailto:[EMAIL PROTECTED]
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
--
sqlfairy-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
