# \[Solved\] Add new column to Mattermost Channel table

**URL:** <https://forum.mattermost.com/t/solved-add-new-column-to-mattermost-channel-table/1628>\
**Category:** Troubleshooting\
**Created:** [June 3, 2016, 10:16am UTC](https://forum.mattermost.com/t/solved-add-new-column-to-mattermost-channel-table/1628 "2016-06-03T10:16:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ajita](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@Ajita](https://forum.mattermost.com/u/Ajita)\
**Post date:** [June 3, 2016, 10:16am UTC](https://forum.mattermost.com/t/solved-add-new-column-to-mattermost-channel-table/1628/1 "2016-06-03T10:16:32Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Ajita](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@Ajita](https://forum.mattermost.com/u/Ajita)\
**Post date:** [June 3, 2016, 11:32am UTC](https://forum.mattermost.com/t/solved-add-new-column-to-mattermost-channel-table/1628/2 "2016-06-03T11:32:23Z")

</div>

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