Hey Alex,

You can use this following similar SQL to insert new column in the table.

ALTER TABLE `#__discuss_posts` ADD `new_column_name` tinyint(1) NOT NULL;

Thanks for reply arlex..but actually what i want
there is a field in `#__discuss_posts` table named as created
i want that when some post is created then the value of this field should also go in the new field which i have created named as `published_start_date`. But the problem is i am not getting the file location where i have to make changes in insert query so that it can behave like this as i want. Please tell me the file location where i have to make change....

You can update on this file -> JoomlaFolder\administrator\components\com_easydiscuss\tables\thread.php and refer on my attached screenshot below.

Thanks arlex.....but i am not getting this file in my folder.
I checked it there is no file exist with thread.php name at JoomlaFolder\administrator\components\com_easydiscuss\tables\
my easy discuss version is Version: 3.2.9744
please tell me where i can found it ??

I am sorry for the delay of this reply,

It seems like you are still using older version of Easydiscuss 3.x , can you try download my attached file and double check what my changes on this file.

JoomlaFolder\administrator\components\com_easydiscuss\tables\post.php

Thanks..Arlex..

Hi there,

Does the solution given solved your problems? Keep us updated then .