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

[gilberto d. s. a. <gs...@gm...>]

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