Contents

CREATE TABLE 'pages' (
  'id'         INTEGER NOT NULL PRIMARY KEY,
  'version'    INTEGER,
  'title'      VARCHAR(255),
  'body'       TEXT,
  'updated_on' DATETIME DEFAULT NULL
);

CREATE TABLE 'page_versions' (
  'id'         INTEGER NOT NULL PRIMARY KEY,
  'page_id'    INTEGER NOT NULL,
  'version'    INTEGER NOT NULL,
  'title'      VARCHAR(255),
  'body'       TEXT DEFAULT NULL,
  'updated_on' DATETIME DEFAULT NULL
);

CREATE TABLE 'locked_pages' (
  'id'           INTEGER NOT NULL PRIMARY KEY,
  'lock_version' INTEGER NOT NULL,
  'title'        VARCHAR(255),
  'type'         VARCHAR(255)
);

CREATE TABLE 'locked_pages_revisions' (
  'id'           INTEGER NOT NULL PRIMARY KEY,
  'page_id'      INTEGER NOT NULL,
  'version'      INTEGER NOT NULL,
  'title'        VARCHAR(255),
  'version_type' VARCHAR(255),
  'updated_at'   DATETIME DEFAULT NULL
);

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
acts_as_versioned-0.1.3	test/fixtures/db_definitions/sqlite.sql
acts_as_versioned-0.2	test/fixtures/db_definitions/sqlite.sql
acts_as_versioned-0.2.1	test/fixtures/db_definitions/sqlite.sql
acts_as_versioned-0.1.2	test/fixtures/db_definitions/sqlite.sql