if (not exists(select * from sys.systable where table_name='HotelActionsLog')) then
create table HotelActionsLog (
  "Id" integer not null default autoincrement,
  "ActionId" integer not null,
  "UserN" integer not null,
  "InsDateTime" datetime,
  "Description" varchar(250),
  primary key ("Id")
);

COMMENT ON COLUMN "DBA"."HotelActionsLog"."ActionId" IS 
	'1 - Логване в системата, 2 - Настаняване';
end if

GO