Re: [WebERP-developers] table stockcatproperties primary key and constrains weberp 4.11.2

[Phil D. <ph...@lo...>]

Yes that's a strange one - looks like a mistake - although the dump file 
is produced by mysqldump so must be a bug in that utility I guess.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 21/01/14 06:32, gilberto dos santos alves wrote:
> I am reviewing tables, primary keys and other constraints i find that 
> table has 3 constraints like this paste from table show.
>
> CONSTRAINT `stockcatproperties_ibfk_1`,
> CONSTRAINT `stockcatproperties_ibfk_2` and
> CONSTRAINT `stockcatproperties_ibfk_3`  enforce same condition.
>
> Is this a mistake or i missing something?
>
> Thanks for your time.
>
>
> ################################################
> weberp 4.11.2: table stockcatproperties, primary key and constraints
> --
> -- Estrutura da tabela `stockcatproperties`
> --
> CREATE TABLE IF NOT EXISTS `stockcatproperties` (
>   `stkcatpropid` int(11) NOT NULL AUTO_INCREMENT,
>   `categoryid` char(6) NOT NULL,
>   `label` text NOT NULL,
>   `controltype` tinyint(4) NOT NULL DEFAULT '0',
>   `defaultvalue` varchar(100) NOT NULL DEFAULT '''''',
>   `maximumvalue` double NOT NULL DEFAULT '999999999',
>   `reqatsalesorder` tinyint(4) NOT NULL DEFAULT '0',
>   `minimumvalue` double NOT NULL DEFAULT '-999999999',
>   `numericvalue` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`stkcatpropid`),
>   KEY `categoryid` (`categoryid`)
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
> --
> -- Restrições para a tabela `stockcatproperties`
> --
> ALTER TABLE `stockcatproperties`
>   ADD CONSTRAINT `stockcatproperties_ibfk_1` FOREIGN KEY 
> (`categoryid`) REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `stockcatproperties_ibfk_2` FOREIGN KEY 
> (`categoryid`) REFERENCES `stockcategory` (`categoryid`),
>   ADD CONSTRAINT `stockcatproperties_ibfk_3` FOREIGN KEY 
> (`categoryid`) REFERENCES `stockcategory` (`categoryid`);
>
> ################################################
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers