web-erp-developers

[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

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

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