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.