diff --git a/resource/dm_version.sql b/resource/dm_version.sql --- a/resource/dm_version.sql +++ b/resource/dm_version.sql @@ -1,25 +1,25 @@ -set names 'WIN1251'; -create sequence seq_dm_version; +SET CLIENT_ENCODING=utf8; +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) +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 TABLE dm_version IS 'Таблица изменений БД'; -comment on column dm_version.id is ''; +COMMENT ON COLUMN dm_version.id IS 'Идентификатор'; -comment on column dm_version.revision is ' '; +COMMENT ON column dm_version.revision IS 'Номер ревизии БД'; -comment on column dm_version.package_id is ' '; +COMMENT ON COLUMN dm_version.package_id IS 'Идентификатор пакета'; -comment on column dm_version.comment is ''; +COMMENT ON COLUMN dm_version.comment IS 'Комментарий'; -comment on column dm_version.gen_date is ' '; +COMMENT ON COLUMN dm_version.gen_date IS 'Дата загрузки'; -grant select on table dm_version to public; +GRANT SELECT ON TABLE dm_version TO public;