[Openinteract-commits] CVS: OpenInteract2/pkg/comments/struct comment_disable.sql,NONE,1.1 comment_disable_sequence.sql,NONE,1.1

[Chris W. <la...@us...>]

Update of /cvsroot/openinteract/OpenInteract2/pkg/comments/struct
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7846/struct

Added Files:
	comment_disable.sql comment_disable_sequence.sql 
Log Message:
OIN-119: be able to disable comments for an individual object or for an entire class of objects -- new action (comment_admin) as well as SPOPS object (comment_disable)

--- NEW FILE: comment_disable.sql ---
CREATE TABLE oi_comment_disable (
 disable_id         %%INCREMENT%%,
 disabled_on        %%DATETIME%% not null,
 class              varchar(75) not null,
 object_id          varchar(255) not null,
 object_url         varchar(75) not null,
 object_title       varchar(150) not null,
 primary key( disable_id ),
 unique( class, object_id )
)
--- NEW FILE: comment_disable_sequence.sql ---
CREATE SEQUENCE oi_comment_disable_seq