SFTOPICS Table

The SFTOPICS table in is where information is stored for the Topics created in Simple:Press. The columns in the SFTOPICS table are:

topic_id – Auto generated ID of the Topic

topic_name – Name of the Topic

topic_date – Date the Topic was created

topic_status – Determines if the Topic is locked or open for posting

forum_id – ID of the Forum the Topic belongs to

user-id – ID of the User that started the Topic (will be NULL if it was a guest)

topic_pinned – Determines if the Topic is pinned

topic_subs – If the Topic has subscriptions, will contain a serialized array of User IDs that have subscribed

topic_opened – Number of times the Topic has been viewed

blog_post_id – If the Topic is part of a blog linked post, this will be the ID of blog post

topic_slug – Topic slug used in the pretty permalinks URLs

post_id – ID of the last Post in the Topic

post_count – Current number of Posts in the Topic

topic_status_flag – If the Forum is using a topic status set, this will be the current status of the Topic

topic_watches – If the Topic has watches, will contain a serialized array of User IDs that are watching