[Serusers] Adding columns to table acc

[Jan Janak]

On 20-10 23:12, Hans Eriksson wrote:
> I am contemplating if I can add two columns to acc:
> 
> * seq: auto_increment int(11) - to make sure that the chronological 
> order is maintained. This is crucial if you want to debug problems, 
> transfer infor from one table to another, etc. I.e. you really want the 
> INVITE to come before any BYE etc.
> * status: an enumeration. I am examining the rows in acc an pull out 
> CDR information and I need to flag examined rows.
> 
> The basic questions is about the programming. It should be safe to add 
> two columns at the end. But if you have any SELECT * somewhere in ser, 
> we have a problem.
> 
> So, can I add columns to the end of the table acc (or any table?) in 
> database ser without any hick-ups?

  Yes, AFAIK we always specify columns explicitely when doing select.

    Jan.