I'm currently developing a web chat application using
SQL server this is my database schema so far
I've added an option where the user can
Clear Chat history for a particular conversation , but I'm having trouble with the concept of clearing history for a particular user in wish case if user-1 hit clear history
all the messages of this conversation will not be displayed for user 1 but will still be seen for user-2
How can I upgrade my database schema so I can make this functionality ?
PS : yesterday i asked the same question on
stackoverflow website and someone gave me a solution .but the solution he gave me is complicated and it didn't fill my requirement .
my database is currently supporting only private chat between 2 users