Contents

-- Controlled by prick(1). Don't touch
--
-- TODO
--  o Replace view with a function to return the current build

set search_path to prick;

create table builds (
  id integer generated by default as identity primary key,

  -- Project name
  name varchar not null,

  -- Version
  version varchar not null, -- Project version
  prick varchar not null,-- Prick version

  -- Git
  branch varchar not null,
  rev varchar not null, -- commit ID
  clean boolean not null default true, -- True if git repository is clean

  -- Environment
  environment varchar not null default 'default',
  
  -- Build timestamp. This is the time of the start of the build
  built_at timestamp without time zone default (now() at time zone 'UTC'),

  -- Build status
  success boolean default false,-- True if the database built successfully

  -- Durations
  duration float,-- Duration of database build. Null if success is false
  prick_duration float, -- Duration of the full prick command
  make_duration float -- Duration of enclosing make script
);

create table snapshots (
  id integer generated by default as identity primary key,
  schema_name varchar not null,
  table_name varchar not null,
  max_id integer, -- may be null

  unique(schema_name, table_name)
);

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
prick-0.39.5	lib/prick/share/init/schema/prick/tables.sql
prick-0.39.4	lib/prick/share/init/schema/prick/tables.sql
prick-0.39.3	lib/prick/share/init/schema/prick/tables.sql
prick-0.39.2	lib/prick/share/init/schema/prick/tables.sql
prick-0.39.1	lib/prick/share/init/schema/prick/tables.sql
prick-0.39.0	lib/prick/share/init/schema/prick/tables.sql
prick-0.36.0	lib/prick/share/init/schema/prick/tables.sql