[Solved] Add new column to Mattermost Channel table

Hello
I am newbie to Mattermost.
I have setup the complete Mattermost successfully.
How can I add a new column to Mattermost Channel table.I tried manually adding a column in MySQL mattermost DB at my local end but it fails.
I have a general query that if I need to add a new column to any of the Mattermost table, how I can achieve it?

Resolved.We need to upgrade the schema of the table from code end, instead of directly modifying DB by MySQL query.