MetaPhilter Doc

« TOC

Database Structure

This is a brief outline of the tables used in a MetaPhilter database structure. Each table is prefixed with the ID of its Philter followed by an underscore.

• Users

  The 'users' table contains the information of all user profiles. The following columns are in this table:

  • userID

    Auto-indexed primary key of table.

  • username

    Username/nickname on Philter.

  • password

    SQL encrypted password for user.

  • added

    GMT timestamp of when user was added to the database.

  • group

    The numeric ID of the user's permission group. The permission groups of a Philter are controlled through the configuration script.

  • email

    Email address of user.

  • realname

    The "real name" the user has entered in their profile.

  • aim

    AOL Instant Messenger name user has entered in their profile.

  • homepage

    Homepage URL user has entered in their profile.

  • bio

    Miscellaneous information user has entered as their "bio".

  • last_visit

    A timestamp of the users last visit to the Philter.

  • preferences

    A serialized associative array of the user's preferences on the Philter.

    Current supported preferences:

    • "recent_links"

      A limiter of recent links to display when the user visits the Philter.

    • "recent_links"

      A limiter of recent comments to display when the user visits the Philter.

• Links

  The 'links' table of the database contains data for all the posted links in the Philter. The following columns are in this table:

  • linkID

    Auto-indexed primary key of table.

  • userID

    userID of the user who posted this link.

  • philterID

    The Philter ID of the user who posted the link.

  • timestamp

    GMT timestamp when the link was posted.

  • URL

    The URL of the posted link.

  • URL_description

    A short description of this link.

  • description

    A longer description of this link.

  • extended

    Extended background/informational text of the link.

  • title

    A title for the link.

  • category

    The ID of the category the link was posted into.

• Comments

  The 'comments' table contains the data for comments posted in link threads. The following columns are in this table:

  • commentID

    Auto-indexed primary key of table.

  • linkID

    The linkID of the link thread the comment was posted in.

  • userID

    The userID of the user who posted the comment.

  • philterID

    The Philter ID of the user who posted the comment.

  • timestamp

    GMT timestamp of when the comment was posted.

  • content

    The text of the comment itself.

• Pings

  The 'pings' table contains the TrackBack pings sent to your posted links. The following columns are in this table:

  • linkID

    The linkID of the post referenced from the pinging blog entry.

  • URL

    The URL of the referring entry.

  • title

    The title of the referring entry.

  • excerpt

    An excerpt from the referring entry.

  • blog_name

    The name of the referring blog.