History of Liberty Content Status
Version 2
Liberty Content Status
A status flag available to all Liberty Content
<?php
CREATE TABLE liberty_content_status (
content_status_id INT4 NOT NULL PRIMARY KEY,
content_status_name VARCHAR(128) NOT NULL
);
ALTER TABLE liberty_content ADD COLUMN content_status_id INT4;
?>
Here are some Initial Statuses that are available. Liberty assumes the value of the content is directly proportional to the magnitude of the status ID. For example
Negative content and only available to owner and/or admin depending on severity.
Editor Level Threshold
-999 Deleted // content is slated for deletion, but is available for undelete
-998 Spam // evil, evil spam
-201 Suspended // content is being held in admin level holding tank for reivew
-100 Denied // Request for posting was blocked
User Level Threshold
-40 Private // Personal choices to control content
-30 Password Protected // Personal choices to control content
-20 Group Protected // User has to be in the same group as the content.
-10 Hidden // Anyone can see, but content does not show up in listings.
Postive content, is always publically available (to all with appropriate perms of course)
User Level Threshold
10 Draft
50 Available
Editor Level Threshold
101 Pending Approval
102 Commercial
200 Recommended
999 Copy Protected
With these, you can obviously more easily control selects on getList functions, etc. Also, this makes things some what symmetric in terms of "value" of a piece of content. As an idea, you could aggregate all status
for content owned by a user and get a pretty useful metric.
We could obviously make UI to add more statuses, but it would be good to settle on some general notions about interpretation of the status number. (eg postives are shown by default, negatives are not without explicit permission and request).