--
-- Schema info.
--
-- The schema version is stored in every PR when the PR is
-- entered; this helps reconstruct history.
--
-- The schema version is also used for future-proofing.

-- Should have only one row.
CREATE TABLE schemainfo (
       version int	not null
)
WITHOUT OIDS;

-- This is readonly except for system updates.
GRANT SELECT ON schemainfo TO swallowtail_admin;
GRANT SELECT ON schemainfo TO swallowtail_writer;
GRANT SELECT ON schemainfo TO swallowtail_reader;
GRANT SELECT ON schemainfo TO swallowtail_public;