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

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

I have committed this.

I wonder how this happens though as the script is dumped from mysql so 
perhaps a bug with mysqldump?

Thanks Gilberto :-)

Phil

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

On 07/07/14 07:49, gilberto dos santos alves wrote:
> 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... <mailto: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
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers