1032 lines
32 KiB
SQL
Executable File
1032 lines
32 KiB
SQL
Executable File
|
|
create table JIAccessEvent (
|
|
id bigint not null auto_increment,
|
|
user_id bigint not null,
|
|
event_date datetime not null,
|
|
resource_id bigint not null,
|
|
updating bit not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIAwsDatasource (
|
|
id bigint not null,
|
|
accessKey varchar(100),
|
|
secretKey varchar(100),
|
|
roleARN varchar(100),
|
|
region varchar(100) not null,
|
|
dbName varchar(100) not null,
|
|
dbInstanceIdentifier varchar(100) not null,
|
|
dbService varchar(100) not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIAzureSqlDatasource (
|
|
id bigint not null,
|
|
keyStore_id bigint not null,
|
|
keyStorePassword varchar(100),
|
|
keyStoreType varchar(25),
|
|
subscriptionId varchar(100),
|
|
serverName varchar(100) not null,
|
|
dbName varchar(100) not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIBeanDatasource (
|
|
id bigint not null,
|
|
beanName varchar(100) not null,
|
|
beanMethod varchar(100),
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIContentResource (
|
|
id bigint not null,
|
|
data longblob,
|
|
file_type varchar(20),
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JICustomDatasource (
|
|
id bigint not null,
|
|
serviceClass varchar(250) not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JICustomDatasourceProperty (
|
|
ds_id bigint not null,
|
|
value varchar(1000),
|
|
name varchar(200) not null,
|
|
primary key (ds_id, name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JICustomDatasourceResource (
|
|
ds_id bigint not null,
|
|
resource_id bigint not null,
|
|
name varchar(200) not null,
|
|
primary key (ds_id, name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIDataSnapshot (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
snapshot_date datetime,
|
|
contents_id bigint not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIDataSnapshotContents (
|
|
id bigint not null auto_increment,
|
|
data longblob not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIDataSnapshotParameter (
|
|
id bigint not null,
|
|
parameter_value longblob,
|
|
parameter_name varchar(100) not null,
|
|
primary key (id, parameter_name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIDataType (
|
|
id bigint not null,
|
|
type tinyint,
|
|
maxLength integer,
|
|
decimals integer,
|
|
regularExpr varchar(255),
|
|
minValue blob,
|
|
max_value blob,
|
|
strictMin bit,
|
|
strictMax bit,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIFTPInfoProperties (
|
|
repodest_id bigint not null,
|
|
property_value varchar(250),
|
|
property_name varchar(100) not null,
|
|
primary key (repodest_id, property_name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIFileResource (
|
|
id bigint not null,
|
|
data longblob,
|
|
file_type varchar(20),
|
|
reference bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIInputControl (
|
|
id bigint not null,
|
|
type tinyint,
|
|
mandatory bit,
|
|
readOnly bit,
|
|
visible bit,
|
|
data_type bigint,
|
|
list_of_values bigint,
|
|
list_query bigint,
|
|
query_value_column varchar(200),
|
|
defaultValue tinyblob,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIInputControlQueryColumn (
|
|
input_control_id bigint not null,
|
|
query_column varchar(200) not null,
|
|
column_index integer not null,
|
|
primary key (input_control_id, column_index)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIJNDIJdbcDatasource (
|
|
id bigint not null,
|
|
jndiName varchar(100) not null,
|
|
timezone varchar(100),
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIJdbcDatasource (
|
|
id bigint not null,
|
|
driver varchar(100) not null,
|
|
password varchar(250),
|
|
connectionUrl varchar(500),
|
|
username varchar(100),
|
|
timezone varchar(100),
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIListOfValues (
|
|
id bigint not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIListOfValuesItem (
|
|
id bigint not null,
|
|
label varchar(255),
|
|
value longblob,
|
|
idx integer not null,
|
|
primary key (id, idx)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JILogEvent (
|
|
id bigint not null auto_increment,
|
|
occurrence_date datetime not null,
|
|
event_type tinyint not null,
|
|
component varchar(100),
|
|
message varchar(250) not null,
|
|
resource_uri varchar(250),
|
|
event_text mediumtext,
|
|
event_data mediumblob,
|
|
event_state tinyint,
|
|
userId bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIMondrianConnection (
|
|
id bigint not null,
|
|
reportDataSource bigint,
|
|
mondrianSchema bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIMondrianXMLADefinition (
|
|
id bigint not null,
|
|
catalog varchar(100) not null,
|
|
mondrianConnection bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIObjectPermission (
|
|
id bigint not null auto_increment,
|
|
uri varchar(1000) not null,
|
|
recipientobjectclass varchar(250),
|
|
recipientobjectid bigint,
|
|
permissionMask integer not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIOlapClientConnection (
|
|
id bigint not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIOlapUnit (
|
|
id bigint not null,
|
|
olapClientConnection bigint,
|
|
mdx_query mediumtext not null,
|
|
view_options longblob,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIProfileAttribute (
|
|
id bigint not null auto_increment,
|
|
attrName varchar(255) not null,
|
|
attrValue varchar(2000),
|
|
description varchar(255),
|
|
owner varchar(255),
|
|
principalobjectclass varchar(255) not null,
|
|
principalobjectid bigint not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIQuery (
|
|
id bigint not null,
|
|
dataSource bigint,
|
|
query_language varchar(40) not null,
|
|
sql_query mediumtext not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportAlertToAddress (
|
|
alert_id bigint not null,
|
|
to_address varchar(100) not null,
|
|
to_address_idx integer not null,
|
|
primary key (alert_id, to_address_idx)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJob (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
owner bigint not null,
|
|
label varchar(100) not null,
|
|
description varchar(2000),
|
|
creation_date datetime,
|
|
report_unit_uri varchar(250) not null,
|
|
scheduledResource bigint not null,
|
|
job_trigger bigint not null,
|
|
base_output_name varchar(100) not null,
|
|
output_locale varchar(20),
|
|
content_destination bigint,
|
|
mail_notification bigint,
|
|
alert bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobAlert (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
recipient tinyint not null,
|
|
subject varchar(100),
|
|
message_text varchar(2000),
|
|
message_text_when_job_fails varchar(2000),
|
|
job_state tinyint not null,
|
|
including_stack_trace bit not null,
|
|
including_report_job_info bit not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobCalendarTrigger (
|
|
id bigint not null,
|
|
minutes varchar(200) not null,
|
|
hours varchar(80) not null,
|
|
days_type tinyint not null,
|
|
week_days varchar(20),
|
|
month_days varchar(100),
|
|
months varchar(40) not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobMail (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
subject varchar(100) not null,
|
|
message varchar(2000),
|
|
send_type tinyint not null,
|
|
skip_empty bit not null,
|
|
message_text_when_job_fails varchar(2000),
|
|
inc_stktrc_when_job_fails bit not null,
|
|
skip_notif_when_job_fails bit not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobMailRecipient (
|
|
destination_id bigint not null,
|
|
recipient_type tinyint not null,
|
|
address varchar(100) not null,
|
|
recipient_idx integer not null,
|
|
primary key (destination_id, recipient_idx)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobOutputFormat (
|
|
report_job_id bigint not null,
|
|
output_format tinyint not null,
|
|
primary key (report_job_id, output_format)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobParameter (
|
|
job_id bigint not null,
|
|
parameter_value longblob,
|
|
parameter_name varchar(255) not null,
|
|
primary key (job_id, parameter_name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobRepoDest (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
folder_uri varchar(250),
|
|
sequential_filenames bit not null,
|
|
overwrite_files bit not null,
|
|
save_to_repository bit not null,
|
|
output_description varchar(250),
|
|
timestamp_pattern varchar(250),
|
|
using_def_rpt_opt_folder_uri bit not null,
|
|
output_local_folder varchar(250),
|
|
user_name varchar(50),
|
|
password varchar(250),
|
|
server_name varchar(150),
|
|
folder_path varchar(250),
|
|
ssh_private_key bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobSimpleTrigger (
|
|
id bigint not null,
|
|
occurrence_count integer not null,
|
|
recurrence_interval integer,
|
|
recurrence_interval_unit tinyint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportJobTrigger (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
timezone varchar(40),
|
|
start_type tinyint not null,
|
|
start_date datetime,
|
|
end_date datetime,
|
|
calendar_name varchar(50),
|
|
misfire_instruction integer not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportThumbnail (
|
|
id bigint not null auto_increment,
|
|
user_id bigint not null,
|
|
resource_id bigint not null,
|
|
thumbnail longblob not null,
|
|
primary key (id),
|
|
unique (user_id, resource_id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportUnit (
|
|
id bigint not null,
|
|
reportDataSource bigint,
|
|
query bigint,
|
|
mainReport bigint,
|
|
controlrenderer varchar(100),
|
|
reportrenderer varchar(100),
|
|
promptcontrols bit,
|
|
controlslayout tinyint,
|
|
data_snapshot_id bigint,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportUnitInputControl (
|
|
report_unit_id bigint not null,
|
|
input_control_id bigint not null,
|
|
control_index integer not null,
|
|
primary key (report_unit_id, control_index)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIReportUnitResource (
|
|
report_unit_id bigint not null,
|
|
resource_id bigint not null,
|
|
resource_index integer not null,
|
|
primary key (report_unit_id, resource_index)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIRepositoryCache (
|
|
id bigint not null auto_increment,
|
|
uri varchar(250) not null,
|
|
cache_name varchar(20) not null,
|
|
data longblob,
|
|
version integer not null,
|
|
version_date datetime not null,
|
|
item_reference bigint,
|
|
primary key (id),
|
|
unique (uri, cache_name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIResource (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
name varchar(200) not null,
|
|
parent_folder bigint not null,
|
|
childrenFolder bigint,
|
|
label varchar(200) not null,
|
|
description varchar(250),
|
|
resourceType varchar(255) not null,
|
|
creation_date datetime not null,
|
|
update_date datetime not null,
|
|
primary key (id),
|
|
unique (name, parent_folder)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIResourceFolder (
|
|
id bigint not null auto_increment,
|
|
version integer not null,
|
|
uri varchar(250) not null,
|
|
hidden bit,
|
|
name varchar(200) not null,
|
|
label varchar(200) not null,
|
|
description varchar(250),
|
|
parent_folder bigint,
|
|
creation_date datetime not null,
|
|
update_date datetime not null,
|
|
primary key (id),
|
|
unique (uri)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIRole (
|
|
id bigint not null auto_increment,
|
|
rolename varchar(100) not null,
|
|
tenantId bigint not null,
|
|
externallyDefined bit,
|
|
primary key (id),
|
|
unique (rolename, tenantId)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JITenant (
|
|
id bigint not null auto_increment,
|
|
tenantId varchar(100) not null,
|
|
tenantAlias varchar(100) not null,
|
|
parentId bigint,
|
|
tenantName varchar(100) not null,
|
|
tenantDesc varchar(250),
|
|
tenantNote varchar(250),
|
|
tenantUri varchar(250) not null,
|
|
tenantFolderUri varchar(250) not null,
|
|
theme varchar(250),
|
|
primary key (id),
|
|
unique (tenantId)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIUser (
|
|
id bigint not null auto_increment,
|
|
username varchar(100) not null,
|
|
tenantId bigint not null,
|
|
fullname varchar(100) not null,
|
|
emailAddress varchar(100),
|
|
password varchar(250),
|
|
externallyDefined bit,
|
|
enabled bit,
|
|
previousPasswordChangeTime datetime,
|
|
primary key (id),
|
|
unique (username, tenantId)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIUserRole (
|
|
roleId bigint not null,
|
|
userId bigint not null,
|
|
primary key (userId, roleId)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIVirtualDataSourceUriMap (
|
|
virtualDS_id bigint not null,
|
|
resource_id bigint not null,
|
|
data_source_name varchar(200) not null,
|
|
primary key (virtualDS_id, data_source_name)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIVirtualDatasource (
|
|
id bigint not null,
|
|
timezone varchar(100),
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create table JIXMLAConnection (
|
|
id bigint not null,
|
|
catalog varchar(100) not null,
|
|
username varchar(100) not null,
|
|
password varchar(250) not null,
|
|
datasource varchar(100) not null,
|
|
uri varchar(100) not null,
|
|
primary key (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
create index access_date_index on JIAccessEvent (event_date);
|
|
|
|
create index access_upd_index on JIAccessEvent (updating);
|
|
|
|
create index access_user_index on JIAccessEvent (user_id);
|
|
|
|
create index access_res_index on JIAccessEvent (resource_id);
|
|
|
|
alter table JIAccessEvent
|
|
add index FK47FB3CD732282198 (user_id),
|
|
add constraint FK47FB3CD732282198
|
|
foreign key (user_id)
|
|
references JIUser (id);
|
|
|
|
alter table JIAccessEvent
|
|
add index FK47FB3CD7F254B53E (resource_id),
|
|
add constraint FK47FB3CD7F254B53E
|
|
foreign key (resource_id)
|
|
references JIResource (id)
|
|
on delete cascade;
|
|
|
|
alter table JIAwsDatasource
|
|
add index FK6085542387E4472B (id),
|
|
add constraint FK6085542387E4472B
|
|
foreign key (id)
|
|
references JIJdbcDatasource (id);
|
|
|
|
alter table JIAzureSqlDatasource
|
|
add index FKAFE22203C001BAEA (keyStore_id),
|
|
add constraint FKAFE22203C001BAEA
|
|
foreign key (keyStore_id)
|
|
references JIResource (id);
|
|
|
|
alter table JIAzureSqlDatasource
|
|
add index FKAFE2220387E4472B (id),
|
|
add constraint FKAFE2220387E4472B
|
|
foreign key (id)
|
|
references JIJdbcDatasource (id);
|
|
|
|
alter table JIBeanDatasource
|
|
add index FK674BF34A8BF376D (id),
|
|
add constraint FK674BF34A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIContentResource
|
|
add index FKE466FC68A8BF376D (id),
|
|
add constraint FKE466FC68A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JICustomDatasource
|
|
add index FK2BBCEDF5A8BF376D (id),
|
|
add constraint FK2BBCEDF5A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JICustomDatasourceProperty
|
|
add index FKB8A66AEA858A89D1 (ds_id),
|
|
add constraint FKB8A66AEA858A89D1
|
|
foreign key (ds_id)
|
|
references JICustomDatasource (id);
|
|
|
|
alter table JICustomDatasourceResource
|
|
add index FKDF845123858A89D1 (ds_id),
|
|
add constraint FKDF845123858A89D1
|
|
foreign key (ds_id)
|
|
references JICustomDatasource (id);
|
|
|
|
alter table JICustomDatasourceResource
|
|
add index FKDF845123F254B53E (resource_id),
|
|
add constraint FKDF845123F254B53E
|
|
foreign key (resource_id)
|
|
references JIResource (id);
|
|
|
|
alter table JIDataSnapshotParameter
|
|
add index id_fk_idx (id),
|
|
add constraint id_fk_idx
|
|
foreign key (id)
|
|
references JIDataSnapshot (id);
|
|
|
|
alter table JIDataType
|
|
add index FK533BCC63A8BF376D (id),
|
|
add constraint FK533BCC63A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIFTPInfoProperties
|
|
add index FK6BD68B04D5FA3F0A (repodest_id),
|
|
add constraint FK6BD68B04D5FA3F0A
|
|
foreign key (repodest_id)
|
|
references JIReportJobRepoDest (id);
|
|
|
|
alter table JIFileResource
|
|
add index FKF75B5889A8BF376D (id),
|
|
add constraint FKF75B5889A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIFileResource
|
|
add index FKF75B58895A0C539 (reference),
|
|
add constraint FKF75B58895A0C539
|
|
foreign key (reference)
|
|
references JIFileResource (id);
|
|
|
|
alter table JIInputControl
|
|
add index FKCAC6A512120E06F7 (data_type),
|
|
add constraint FKCAC6A512120E06F7
|
|
foreign key (data_type)
|
|
references JIDataType (id);
|
|
|
|
alter table JIInputControl
|
|
add index FKCAC6A512A8BF376D (id),
|
|
add constraint FKCAC6A512A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIInputControl
|
|
add index FKCAC6A51262A86F04 (list_of_values),
|
|
add constraint FKCAC6A51262A86F04
|
|
foreign key (list_of_values)
|
|
references JIListOfValues (id);
|
|
|
|
alter table JIInputControl
|
|
add index FKCAC6A512B37DB6EB (list_query),
|
|
add constraint FKCAC6A512B37DB6EB
|
|
foreign key (list_query)
|
|
references JIQuery (id);
|
|
|
|
alter table JIInputControlQueryColumn
|
|
add index FKE436A5CCE7922149 (input_control_id),
|
|
add constraint FKE436A5CCE7922149
|
|
foreign key (input_control_id)
|
|
references JIInputControl (id);
|
|
|
|
alter table JIJNDIJdbcDatasource
|
|
add index FK7F9DA248A8BF376D (id),
|
|
add constraint FK7F9DA248A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIJdbcDatasource
|
|
add index FKC8BDFCBFA8BF376D (id),
|
|
add constraint FKC8BDFCBFA8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIListOfValues
|
|
add index FK4E86A776A8BF376D (id),
|
|
add constraint FK4E86A776A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIListOfValuesItem
|
|
add index FKD37CEBA993F0E1F6 (id),
|
|
add constraint FKD37CEBA993F0E1F6
|
|
foreign key (id)
|
|
references JIListOfValues (id);
|
|
|
|
alter table JILogEvent
|
|
add index FK5F32081591865AF (userId),
|
|
add constraint FK5F32081591865AF
|
|
foreign key (userId)
|
|
references JIUser (id);
|
|
|
|
alter table JIMondrianConnection
|
|
add index FK4FF53B191D51BFAD (id),
|
|
add constraint FK4FF53B191D51BFAD
|
|
foreign key (id)
|
|
references JIOlapClientConnection (id);
|
|
|
|
alter table JIMondrianConnection
|
|
add index FK4FF53B19324CFECB (reportDataSource),
|
|
add constraint FK4FF53B19324CFECB
|
|
foreign key (reportDataSource)
|
|
references JIResource (id);
|
|
|
|
alter table JIMondrianConnection
|
|
add index FK4FF53B19C495A60B (mondrianSchema),
|
|
add constraint FK4FF53B19C495A60B
|
|
foreign key (mondrianSchema)
|
|
references JIFileResource (id);
|
|
|
|
alter table JIMondrianXMLADefinition
|
|
add index FK313B2AB8A8BF376D (id),
|
|
add constraint FK313B2AB8A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIMondrianXMLADefinition
|
|
add index FK313B2AB8DC098B1 (mondrianConnection),
|
|
add constraint FK313B2AB8DC098B1
|
|
foreign key (mondrianConnection)
|
|
references JIMondrianConnection (id);
|
|
|
|
alter table JIOlapClientConnection
|
|
add index FK3CA3B7D4A8BF376D (id),
|
|
add constraint FK3CA3B7D4A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIOlapUnit
|
|
add index FKF034DCCFA8BF376D (id),
|
|
add constraint FKF034DCCFA8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIOlapUnit
|
|
add index FKF034DCCF8F542247 (olapClientConnection),
|
|
add constraint FKF034DCCF8F542247
|
|
foreign key (olapClientConnection)
|
|
references JIOlapClientConnection (id);
|
|
|
|
alter table JIQuery
|
|
add index FKCBCB0EC9A8BF376D (id),
|
|
add constraint FKCBCB0EC9A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIQuery
|
|
add index FKCBCB0EC92B329A97 (dataSource),
|
|
add constraint FKCBCB0EC92B329A97
|
|
foreign key (dataSource)
|
|
references JIResource (id);
|
|
|
|
alter table JIReportAlertToAddress
|
|
add index FKC4E3713022FA4CBA (alert_id),
|
|
add constraint FKC4E3713022FA4CBA
|
|
foreign key (alert_id)
|
|
references JIReportJobAlert (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6AE4D73E35 (mail_notification),
|
|
add constraint FK156F5F6AE4D73E35
|
|
foreign key (mail_notification)
|
|
references JIReportJobMail (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6AC83ABB38 (alert),
|
|
add constraint FK156F5F6AC83ABB38
|
|
foreign key (alert)
|
|
references JIReportJobAlert (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6A9EEC902C (content_destination),
|
|
add constraint FK156F5F6A9EEC902C
|
|
foreign key (content_destination)
|
|
references JIReportJobRepoDest (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6A74D2696E (job_trigger),
|
|
add constraint FK156F5F6A74D2696E
|
|
foreign key (job_trigger)
|
|
references JIReportJobTrigger (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6AFF0F459F (scheduledResource),
|
|
add constraint FK156F5F6AFF0F459F
|
|
foreign key (scheduledResource)
|
|
references JIResource (id);
|
|
|
|
alter table JIReportJob
|
|
add index FK156F5F6A4141263C (owner),
|
|
add constraint FK156F5F6A4141263C
|
|
foreign key (owner)
|
|
references JIUser (id);
|
|
|
|
alter table JIReportJobCalendarTrigger
|
|
add index FKC374C7D0D2B2EB53 (id),
|
|
add constraint FKC374C7D0D2B2EB53
|
|
foreign key (id)
|
|
references JIReportJobTrigger (id);
|
|
|
|
alter table JIReportJobMailRecipient
|
|
add index FKBB6DB6D880001AAE (destination_id),
|
|
add constraint FKBB6DB6D880001AAE
|
|
foreign key (destination_id)
|
|
references JIReportJobMail (id);
|
|
|
|
alter table JIReportJobOutputFormat
|
|
add index FKB42A5CE2C3389A8 (report_job_id),
|
|
add constraint FKB42A5CE2C3389A8
|
|
foreign key (report_job_id)
|
|
references JIReportJob (id);
|
|
|
|
alter table JIReportJobParameter
|
|
add index FKEAC52B5F2EC643D (job_id),
|
|
add constraint FKEAC52B5F2EC643D
|
|
foreign key (job_id)
|
|
references JIReportJob (id);
|
|
|
|
alter table JIReportJobRepoDest
|
|
add index FKEA477EBE3C5B87D0 (ssh_private_key),
|
|
add constraint FKEA477EBE3C5B87D0
|
|
foreign key (ssh_private_key)
|
|
references JIResource (id);
|
|
|
|
alter table JIReportJobSimpleTrigger
|
|
add index FKB9337C5CD2B2EB53 (id),
|
|
add constraint FKB9337C5CD2B2EB53
|
|
foreign key (id)
|
|
references JIReportJobTrigger (id);
|
|
|
|
alter table JIReportThumbnail
|
|
add index FKFDB3DED932282198 (user_id),
|
|
add constraint FKFDB3DED932282198
|
|
foreign key (user_id)
|
|
references JIUser (id)
|
|
on delete cascade;
|
|
|
|
alter table JIReportThumbnail
|
|
add index FKFDB3DED9F254B53E (resource_id),
|
|
add constraint FKFDB3DED9F254B53E
|
|
foreign key (resource_id)
|
|
references JIResource (id)
|
|
on delete cascade;
|
|
|
|
alter table JIReportUnit
|
|
add index FK98818B77A8BF376D (id),
|
|
add constraint FK98818B77A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIReportUnit
|
|
add index FK98818B778FDA11CC (query),
|
|
add constraint FK98818B778FDA11CC
|
|
foreign key (query)
|
|
references JIQuery (id);
|
|
|
|
alter table JIReportUnit
|
|
add index FK98818B77324CFECB (reportDataSource),
|
|
add constraint FK98818B77324CFECB
|
|
foreign key (reportDataSource)
|
|
references JIResource (id);
|
|
|
|
alter table JIReportUnit
|
|
add index FK98818B778C8DF21B (mainReport),
|
|
add constraint FK98818B778C8DF21B
|
|
foreign key (mainReport)
|
|
references JIFileResource (id);
|
|
|
|
alter table JIReportUnitInputControl
|
|
add index FK5FBE934AE7922149 (input_control_id),
|
|
add constraint FK5FBE934AE7922149
|
|
foreign key (input_control_id)
|
|
references JIInputControl (id);
|
|
|
|
alter table JIReportUnitInputControl
|
|
add index FK5FBE934AA6A48880 (report_unit_id),
|
|
add constraint FK5FBE934AA6A48880
|
|
foreign key (report_unit_id)
|
|
references JIReportUnit (id);
|
|
|
|
alter table JIReportUnitResource
|
|
add index FK8B1C4CA5A6A48880 (report_unit_id),
|
|
add constraint FK8B1C4CA5A6A48880
|
|
foreign key (report_unit_id)
|
|
references JIReportUnit (id);
|
|
|
|
alter table JIReportUnitResource
|
|
add index FK8B1C4CA5865B10DA (resource_id),
|
|
add constraint FK8B1C4CA5865B10DA
|
|
foreign key (resource_id)
|
|
references JIFileResource (id);
|
|
|
|
alter table JIRepositoryCache
|
|
add index FKE7338B19E7C5A6 (item_reference),
|
|
add constraint FKE7338B19E7C5A6
|
|
foreign key (item_reference)
|
|
references JIRepositoryCache (id);
|
|
|
|
create index resource_type_index on JIResource (resourceType);
|
|
|
|
alter table JIResource
|
|
add index FKD444826DA58002DF (childrenFolder),
|
|
add constraint FKD444826DA58002DF
|
|
foreign key (childrenFolder)
|
|
references JIResourceFolder (id);
|
|
|
|
alter table JIResource
|
|
add index FKD444826DA08E2155 (parent_folder),
|
|
add constraint FKD444826DA08E2155
|
|
foreign key (parent_folder)
|
|
references JIResourceFolder (id);
|
|
|
|
alter table JIResourceFolder
|
|
add index FK7F24453BA08E2155 (parent_folder),
|
|
add constraint FK7F24453BA08E2155
|
|
foreign key (parent_folder)
|
|
references JIResourceFolder (id);
|
|
|
|
alter table JIRole
|
|
add index FK82724655E415AC2D (tenantId),
|
|
add constraint FK82724655E415AC2D
|
|
foreign key (tenantId)
|
|
references JITenant (id);
|
|
|
|
alter table JITenant
|
|
add index FKB1D7B2C97803CC2D (parentId),
|
|
add constraint FKB1D7B2C97803CC2D
|
|
foreign key (parentId)
|
|
references JITenant (id);
|
|
|
|
alter table JIUser
|
|
add index FK8273B1AAE415AC2D (tenantId),
|
|
add constraint FK8273B1AAE415AC2D
|
|
foreign key (tenantId)
|
|
references JITenant (id);
|
|
|
|
alter table JIUserRole
|
|
add index FKD8B5C1403C31045 (roleId),
|
|
add constraint FKD8B5C1403C31045
|
|
foreign key (roleId)
|
|
references JIRole (id);
|
|
|
|
alter table JIUserRole
|
|
add index FKD8B5C14091865AF (userId),
|
|
add constraint FKD8B5C14091865AF
|
|
foreign key (userId)
|
|
references JIUser (id);
|
|
|
|
alter table JIVirtualDataSourceUriMap
|
|
add index FK4A6CCE019E600E20 (virtualDS_id),
|
|
add constraint FK4A6CCE019E600E20
|
|
foreign key (virtualDS_id)
|
|
references JIVirtualDatasource (id);
|
|
|
|
alter table JIVirtualDataSourceUriMap
|
|
add index FK4A6CCE01F254B53E (resource_id),
|
|
add constraint FK4A6CCE01F254B53E
|
|
foreign key (resource_id)
|
|
references JIResource (id);
|
|
|
|
alter table JIVirtualDatasource
|
|
add index FK30E55631A8BF376D (id),
|
|
add constraint FK30E55631A8BF376D
|
|
foreign key (id)
|
|
references JIResource (id);
|
|
|
|
alter table JIXMLAConnection
|
|
add index FK94C688A71D51BFAD (id),
|
|
add constraint FK94C688A71D51BFAD
|
|
foreign key (id)
|
|
references JIOlapClientConnection (id);
|
|
|
|
create index JILogEvent_userId_index on JILogEvent (userId);
|
|
|
|
create index JIReportJob_alert_index on JIReportJob (alert);
|
|
|
|
create index idx25_content_destination_idx on JIReportJob (content_destination);
|
|
|
|
create index JIReportJob_job_trigger_index on JIReportJob (job_trigger);
|
|
|
|
create index idx26_mail_notification_idx on JIReportJob (mail_notification);
|
|
|
|
create index JIReportJob_owner_index on JIReportJob (owner);
|
|
|
|
create index idx24_alert_id_idx on JIReportAlertToAddress (alert_id);
|
|
|
|
create index idx27_destination_id_idx on JIReportJobMailRecipient (destination_id);
|
|
|
|
create index idx14_repodest_id_idx on JIFTPInfoProperties (repodest_id);
|
|
|
|
create index idx34_item_reference_idx on JIRepositoryCache (item_reference);
|
|
|
|
create index idx35_parent_folder_idx on JIResourceFolder (parent_folder);
|
|
|
|
create index JIResourceFolder_version_index on JIResourceFolder (version);
|
|
|
|
create index idx28_resource_id_idx on JIReportThumbnail (resource_id);
|
|
|
|
create index JIResource_childrenFolder_idx on JIResource (childrenFolder);
|
|
|
|
create index JIResource_parent_folder_index on JIResource (parent_folder);
|
|
|
|
create index idx36_resource_id_idx on JIVirtualDataSourceUriMap (resource_id);
|
|
|
|
create index uri_index on JIObjectPermission (uri(255));
|
|
|
|
create index idx21_recipientobjclass_idx on JIObjectPermission (recipientobjectclass);
|
|
|
|
create index idx22_recipientobjid_idx on JIObjectPermission (recipientobjectid);
|
|
|
|
create index JIRole_tenantId_index on JIRole (tenantId);
|
|
|
|
create index JIUserRole_roleId_index on JIUserRole (roleId);
|
|
|
|
create index JIUserRole_userId_index on JIUserRole (userId);
|
|
|
|
create index JITenant_parentId_index on JITenant (parentId);
|
|
|
|
create index JIUser_tenantId_index on JIUser (tenantId);
|
|
|
|
create index JIInputControl_data_type_index on JIInputControl (data_type);
|
|
|
|
create index JIInputCtrl_list_of_values_idx on JIInputControl (list_of_values);
|
|
|
|
create index JIInputControl_list_query_idx on JIInputControl (list_query);
|
|
|
|
create index idx15_input_ctrl_id_idx on JIInputControlQueryColumn (input_control_id);
|
|
|
|
create index JIFileResource_reference_index on JIFileResource (reference);
|
|
|
|
create index JIQuery_dataSource_index on JIQuery (dataSource);
|
|
|
|
create index JIReportUnit_mainReport_index on JIReportUnit (mainReport);
|
|
|
|
create index JIReportUnit_query_index on JIReportUnit (query);
|
|
|
|
create index idx29_reportDataSource_idx on JIReportUnit (reportDataSource);
|
|
|
|
create index idx30_input_ctrl_id_idx on JIReportUnitInputControl (input_control_id);
|
|
|
|
create index idx31_report_unit_id_idx on JIReportUnitInputControl (report_unit_id);
|
|
|
|
create index idx32_report_unit_id_idx on JIReportUnitResource (report_unit_id);
|
|
|
|
create index idx33_resource_id_idx on JIReportUnitResource (resource_id);
|
|
|
|
create index idx16_mondrianSchema_idx on JIMondrianConnection (mondrianSchema);
|
|
|
|
create index idx17_reportDataSource_idx on JIMondrianConnection (reportDataSource);
|
|
|
|
create index idx23_olapClientConnection_idx on JIOlapUnit (olapClientConnection);
|
|
|
|
create index idx20_mondrianConnection_idx on JIMondrianXMLADefinition (mondrianConnection);
|
|
|
|
create index idxA1_resource_id_idx on JICustomDatasourceResource (resource_id);
|