Hi, Regarding a feature request for allowing setting Signed/Unsigned attribute by using central columns http://sourceforge.net/p/phpmyadmin/feature-requests/1608/. I have implemented it by adding an extra column named 'col_Attribute' in central columns table so as there would be no confusion regarding it but as quoted by Madhura on github https://github.com/phpmyadmin/phpmyadmin/pull/1511 there will be many problem regarding this. So I need suggestion if it is required to add a new column or it would be enough by just adding 'attributes' to the 'col_extra' column. Thanks and Regards.
On Fri, Feb 20, 2015 at 10:10 AM, Rakesh Kumar rakeshkumar4294@gmail.com wrote:
Hi, Regarding a feature request for allowing setting Signed/Unsigned attribute by using central columns http://sourceforge.net/p/phpmyadmin/feature-requests/1608/. I have implemented it by adding an extra column named 'col_Attribute' in central columns table so as there would be no confusion regarding it but as quoted by Madhura on github https://github.com/phpmyadmin/phpmyadmin/pull/1511 there will be many problem regarding this. So I need suggestion if it is required to add a new column or it would be enough by just adding 'attributes' to the 'col_extra' column. Thanks and Regards.
Hey,
yeah, I agree with Madhura on upgrading will not be easy for the user if you add another column in an existing table. I would also suggest to use the existing "col_extra" column itself to store the column attributes as well. You might keep array dump in column col_extra which identify if it comes under column attributes or extra values.
-- Smita K.
-- Rakesh Kumar-B.Tech CSE ,ISM Dhanbad
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Smita, Thanks for the reply. IMO storing attribute data in 'col_extra' would be not only little more confusing to the code but also making a new column will make the table itself little more informative. It will be a problem at start but I think in long term it may be more efficient.
On 20 February 2015 at 18:28, Smita kumarismita62@gmail.com wrote:
On Fri, Feb 20, 2015 at 10:10 AM, Rakesh Kumar rakeshkumar4294@gmail.com wrote:
Hi, Regarding a feature request for allowing setting Signed/Unsigned attribute by using central columns http://sourceforge.net/p/phpmyadmin/feature-requests/1608/. I have implemented it by adding an extra column named 'col_Attribute' in central columns table so as there would be no confusion regarding it but as quoted by Madhura on github https://github.com/phpmyadmin/phpmyadmin/pull/1511 there will be many problem regarding this. So I need suggestion if it is required to add a new column or it would be enough by just adding 'attributes' to the 'col_extra' column. Thanks and Regards.
Hey,
yeah, I agree with Madhura on upgrading will not be easy for the user if you add another column in an existing table. I would also suggest to use the existing "col_extra" column itself to store the column attributes as well. You might keep array dump in column col_extra which identify if it comes under column attributes or extra values.
-- Smita K.
-- Rakesh Kumar-B.Tech CSE ,ISM Dhanbad
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Rakesh Kumar -
Smita