Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2005-06-29 : 02:14:48
|
| Hi,I'm attempting to create a report spam admin tool for a community website. The problem is users who are abusing the site to send SPAM, etc.My design problem is I am not sure the best way to do this. Ideally I would like to have a reported abuse table that just stores the ID's of the rows that are abusive. I would then delete those as they are dealt with etc.The problem occurs when messages get deleted by the user and the reported violation no longer exists. This would mean I would have to create a new table and deal with it that way, but this really isnt the approach I want.When a user "deletes" a message from their message Inbox, it is actually physically deleted from the database. Is a better approach to have a boolean "deleted" column and just update it there? This way I would avoid this problem and archive the inbox table at night.Any thoughts on this ?Thanks once again for your help!mike123 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-29 : 02:39:18
|
quote:
Is a better approach to have a boolean "deleted" column and just update it there? This way I would avoid this problem and archive the inbox table at night.
That's what I'd do.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2005-06-29 : 23:41:04
|
| Thanks once again Damian!! I will procede with this solution with confidence now :)mike123 |
|
|
|
|
|
|
help with db design (report abuse, mailsystem)