[Phpmyadmin-devel] Adding a new column in Central columns

Rakesh Kumar rakeshkumar4294 at gmail.com
Fri Feb 20 14:25:19 CET 2015


​​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 at gmail.com> wrote:

> On Fri, Feb 20, 2015 at 10:10 AM, Rakesh Kumar <rakeshkumar4294 at 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.clktrk
>> _______________________________________________
>> Phpmyadmin-devel mailing list
>> Phpmyadmin-devel at 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.clktrk
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>


-- 
Rakesh Kumar-B.Tech CSE ,ISM Dhanbad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20150220/b759cb74/attachment.html>


More information about the Developers mailing list