DO NOT REPLY [Bug 29806] New: - single instance support

[bu...@apache.org]

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: slide-dev@jakarta.apache.org
        ReportedBy: bzheng@us.nomura.com


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: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org