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

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

i think it is not a bug because constraint names are distinct.


2014-07-07 3:05 GMT-03:00 Phil Daintree <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 567890http://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... 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 awardshttp://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>


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