Differences from version 3 to 4



@@ -1,13 +1,5 @@

-{code lang="sql"}
-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;
-{/code}
-
-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
+!Available Status Codes
+Liberty assumes the value of the content is directly proportional to the magnitude of the status ID.
 
 ^
 __ Negative content and only available to owner and/or admin depending on severity. __

@@ -23,21 +15,21 @@

 -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.
+-5 Draft
+-1 Pending Approval
 
 __ 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
+With these, you can fine tune 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).
Page History
Date/CommentUserIPVersion
15 Apr 2008 (14:48 UTC)
bring page up to date with codes actually set in Liberty
Will69.203.72.1614
Current • Source
spiderr66.194.217.2213
View • Compare • Difference • Source
spiderr66.194.217.2222
View • Compare • Difference • Source