1 Topic by apmuthu (edited by apmuthu 12/22/2014 10:12:32 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Topic: stock_moves.stock_id char(20) => varchar(20)

Change stock_moves.stock_id to be varchar in synch with it's usage everywhere else.
Commit available to be pulled in.

Post's attachments

FA_stock_id_varchar.png 35.6 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

2 Reply by apmuthu (edited by apmuthu 12/24/2014 02:24:43 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Re: stock_moves.stock_id char(20) => varchar(20)

Further changes in standardisation of char => varchar for loc_stock and stock_id fields are available in a commit in my GitHub repo.

Due to db schema policy change restrictions in effect for minor revisions, these will not make it to the official stable repo.

@joe: can include it in v2.4 atleast!

Those who wish to be at the bleeding edge of CoA db schema can selectively use the sql statements in my sql/alter_to_latest2.3.sql file.

apmuthu's Website