[WebERP-developers] revision for weberp 4-11-3 constraints duplicated

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

Hi. Please could some one revise files default.sql, demo.sql and
weberpchina.sql for constraints that are duplicated for these 5 tables?

/* ( 5 revisions for files) */

/* revision 1 */

ALTER TABLE `internalstockcatrole`
  ADD CONSTRAINT `internalstockcatrole_ibfk_1` FOREIGN KEY (`categoryid`)
REFERENCES `stockcategory` (`categoryid`),
  ADD CONSTRAINT `internalstockcatrole_ibfk_2` FOREIGN KEY (`secroleid`)
REFERENCES `securityroles` (`secroleid`);
  /* gs...@gm... revisado em 20140706 */
  /* beg-rev1
  ADD CONSTRAINT `internalstockcatrole_ibfk_3` FOREIGN KEY (`categoryid`)
REFERENCES `stockcategory` (`categoryid`),
  ADD CONSTRAINT `internalstockcatrole_ibfk_4` FOREIGN KEY (`secroleid`)
REFERENCES `securityroles` (`secroleid`);
      end-rev1 */

/* revision 2 */

ALTER TABLE `stockitemproperties`
  ADD CONSTRAINT `stockitemproperties_ibfk_1` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_2` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev2
  ADD CONSTRAINT `stockitemproperties_ibfk_3` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_4` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_5` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  ADD CONSTRAINT `stockitemproperties_ibfk_6` FOREIGN KEY (`stkcatpropid`)
REFERENCES `stockcatproperties` (`stkcatpropid`);
      end-rev2 */

/* revision 3 */

ALTER TABLE `stockmovestaxes`
  ADD CONSTRAINT `stockmovestaxes_ibfk_1` FOREIGN KEY (`taxauthid`)
REFERENCES `taxauthorities` (`taxid`),
  ADD CONSTRAINT `stockmovestaxes_ibfk_2` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`),
  /* gsavix@gmail 20140706 */
  /* beg-rev3
  ADD CONSTRAINT `stockmovestaxes_ibfk_3` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`),
  ADD CONSTRAINT `stockmovestaxes_ibfk_4` FOREIGN KEY (`stkmoveno`)
REFERENCES `stockmoves` (`stkmoveno`);
     end-rev3 */

/* revision 4 */

ALTER TABLE `stockrequest`
  ADD CONSTRAINT `stockrequest_ibfk_1` FOREIGN KEY (`loccode`) REFERENCES
`locations` (`loccode`),
  ADD CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`)
REFERENCES `departments` (`departmentid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev4
  ADD CONSTRAINT `stockrequest_ibfk_3` FOREIGN KEY (`loccode`) REFERENCES
`locations` (`loccode`),
  ADD CONSTRAINT `stockrequest_ibfk_4` FOREIGN KEY (`departmentid`)
REFERENCES `departments` (`departmentid`);
     end-rev4 */

/* revision 5 */

ALTER TABLE `stockrequestitems`
  ADD CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`)
REFERENCES `stockrequest` (`dispatchid`),
  ADD CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`),
  /* gsavix@gmail 20140706 */
  /* beg-rev5
  ADD CONSTRAINT `stockrequestitems_ibfk_3` FOREIGN KEY (`dispatchid`)
REFERENCES `stockrequest` (`dispatchid`),
  ADD CONSTRAINT `stockrequestitems_ibfk_4` FOREIGN KEY (`stockid`)
REFERENCES `stockmaster` (`stockid`);
     end-rev5 */

I have create a file for this on [1] .

Thanks

[1] http://pastebin.com/CFgbZfBn

-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil