diff --git a/resource/dm_version.sql b/resource/dm_version.sql --- a/resource/dm_version.sql +++ b/resource/dm_version.sql @@ -1,23 +1,25 @@ set names 'WIN1251'; create sequence seq_dm_version; create table dm_version ( id INT4 not null default nextval('seq_dm_version'), revision INT4 not null, package_id VARCHAR(128) not null, comment TEXT null default '', gen_date DATE not null, constraint PK_DM_VERSION primary key (id) ); comment on table dm_version is 'Таблица изменений БД'; comment on column dm_version.id is 'Идентификатор'; comment on column dm_version.revision is 'Номер ревизии БД'; comment on column dm_version.package_id is 'Идентификатор пакета'; comment on column dm_version.comment is 'Комментарий'; comment on column dm_version.gen_date is 'Дата загрузки'; + +grant select on table dm_version to public;