Core: Best safe way to add columns to database?
What is the safest way to add more columns to any table of the database? In my case, _user_ table.
ttvd94
All 2 comments
Just add them normally with APPEND TABLE ..., nothing will break since we are using prepared statements with chosen list of columns.
I have for example modified user_chat table to have field active which is set to true if user is in that group chat and false if he's not (bot tracks newchatmembers and leftchatmember updates and updates data in that table).
jacklul
on 5 Feb 2018
👍3
Great! thanks @jacklul
ttvd94
on 6 Feb 2018
Was this page helpful?
0 / 5 - 0 ratings
Related issues
TheSleepySlee
路
3Comments
Bl0ck154
路
3Comments
sayjeyhi
路
3Comments
smaznet
路
4Comments
abbe-cipher
路
4Comments
Most helpful comment
Just add them normally with
APPEND TABLE ..., nothing will break since we are using prepared statements with chosen list of columns.I have for example modified
user_chattable to have fieldactivewhich is set totrueif user is in that group chat andfalseif he's not (bot tracks newchatmembers and leftchatmember updates and updates data in that table).