sql.ot_revisions.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 `{revisions}`
(
    `id`         bigint                      NOT NULL AUTO_INCREMENT,
    `epoch`      int                         NOT NULL,
    `level`      bigint                      NOT NULL,
    `snapshot`   longtext,
    `type`       enum ('NEW','HEAD','INNER') NOT NULL DEFAULT 'NEW',
    `timestamp`  timestamp                   NULL     DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(100)                         DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;