DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29806>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29806

single instance support

           Summary: single instance support
           Product: Slide
           Version: 2.0
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Enhancement
          Priority: Other
         Component: Stores
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I think it would be handy to add single instance support, when a JDBC store is used.
The schema change would be something like this for mysql:

DROP TABLE VERSION_CONTENT;
CREATE TABLE CONTENT (
  CONTENT_ID     bigint      NOT NULL auto_increment,
  CONTENT        blob        NOT NULL,
  CONTENT_DIGEST varchar(32) NOT NULL,
  REF_COUNT      int         NOT NULL,
  PRIMARY KEY  (CONTENT_ID),
  KEY IX_CONTENT_1 (CONTENT_DIGEST)
) TYPE=InnoDB;

ALTER TABLE ADD VERSION_HISTORY
CONTENT_ID bigint NOT NULL;

CREATE INDEX IX_VERSION_HISTORY_2 ON VERSION_HISTORY(CONTENT_ID);

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to