sql.ot_diffs.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of activej-ot Show documentation

Implementation of operational transformation technology. Allows building collaborative software systems.

There is a newer version: 6.0-rc2

CREATE TABLE IF NOT EXISTS `{diffs}`
(
    `revision_id` bigint unsigned NOT NULL,
    `parent_id`   bigint          NOT NULL,
    `diff`        longtext        NOT NULL,
    PRIMARY KEY (`revision_id`, `parent_id`),
    UNIQUE KEY `parent_id` (`parent_id`, `revision_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;