28 lines
655 B
SQL
Executable File
28 lines
655 B
SQL
Executable File
--
|
|
-- 5.6.0 to 6.0.0
|
|
--
|
|
-- Created table JIReportThumbnail to store thumbnails of reports
|
|
--
|
|
|
|
create table JIReportThumbnail (
|
|
id int8 not null,
|
|
user_id int8 not null,
|
|
resource_id int8 not null,
|
|
thumbnail bytea not null,
|
|
primary key (id),
|
|
unique (user_id, resource_id)
|
|
);
|
|
|
|
alter table JIReportThumbnail
|
|
add constraint FKFDB3DED932282198
|
|
foreign key (user_id)
|
|
references JIUser
|
|
on delete cascade;
|
|
|
|
alter table JIReportThumbnail
|
|
add constraint FKFDB3DED9F254B53E
|
|
foreign key (resource_id)
|
|
references JIResource
|
|
on delete cascade;
|
|
|