SQLite Forum

Main Topic and Non Main Topics (Was: Topic and subtopic)
Login
Of-course. Why did I not think about that? :'-( Putting the UNIQUE back.

Should in the last line TopicID not be IsMain?

In this case we still need a trigger to enforce integrity, because we need to be sure that every data record has exactly one main record.