create table JIAccessEvent ( id int8 not null, user_id int8 not null, event_date timestamp not null, resource_id int8 not null, updating bool not null, primary key (id) ); create table JIAwsDatasource ( id int8 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) ); create table JIAzureSqlDatasource ( id int8 not null, keyStore_id int8 not null, keyStorePassword varchar(100), keyStoreType varchar(25), subscriptionId varchar(100), serverName varchar(100) not null, dbName varchar(100) not null, primary key (id) ); create table JIBeanDatasource ( id int8 not null, beanName varchar(100) not null, beanMethod varchar(100), primary key (id) ); create table JIContentResource ( id int8 not null, data bytea, file_type varchar(20), primary key (id) ); create table JICustomDatasource ( id int8 not null, serviceClass varchar(250) not null, primary key (id) ); create table JICustomDatasourceProperty ( ds_id int8 not null, value varchar(1000), name varchar(200) not null, primary key (ds_id, name) ); create table JICustomDatasourceResource ( ds_id int8 not null, resource_id int8 not null, name varchar(200) not null, primary key (ds_id, name) ); create table JIDataSnapshot ( id int8 not null, version int4 not null, snapshot_date timestamp, contents_id int8 not null, primary key (id) ); create table JIDataSnapshotContents ( id int8 not null, data bytea not null, primary key (id) ); create table JIDataSnapshotParameter ( id int8 not null, parameter_value bytea, parameter_name varchar(100) not null, primary key (id, parameter_name) ); create table JIDataType ( id int8 not null, type int2, maxLength int4, decimals int4, regularExpr varchar(255), minValue bytea, max_value bytea, strictMin bool, strictMax bool, primary key (id) ); create table JIFTPInfoProperties ( repodest_id int8 not null, property_value varchar(250), property_name varchar(100) not null, primary key (repodest_id, property_name) ); create table JIFileResource ( id int8 not null, data bytea, file_type varchar(20), reference int8, primary key (id) ); create table JIInputControl ( id int8 not null, type int2, mandatory bool, readOnly bool, visible bool, data_type int8, list_of_values int8, list_query int8, query_value_column varchar(200), defaultValue bytea, primary key (id) ); create table JIInputControlQueryColumn ( input_control_id int8 not null, query_column varchar(200) not null, column_index int4 not null, primary key (input_control_id, column_index) ); create table JIJNDIJdbcDatasource ( id int8 not null, jndiName varchar(100) not null, timezone varchar(100), primary key (id) ); create table JIJdbcDatasource ( id int8 not null, driver varchar(100) not null, password varchar(250), connectionUrl varchar(500), username varchar(100), timezone varchar(100), primary key (id) ); create table JIListOfValues ( id int8 not null, primary key (id) ); create table JIListOfValuesItem ( id int8 not null, label varchar(255), value bytea, idx int4 not null, primary key (id, idx) ); create table JILogEvent ( id int8 not null, occurrence_date timestamp not null, event_type int2 not null, component varchar(100), message varchar(250) not null, resource_uri varchar(250), event_text text, event_data bytea, event_state int2, userId int8, primary key (id) ); create table JIMondrianConnection ( id int8 not null, reportDataSource int8, mondrianSchema int8, primary key (id) ); create table JIMondrianXMLADefinition ( id int8 not null, catalog varchar(100) not null, mondrianConnection int8, primary key (id) ); create table JIObjectPermission ( id int8 not null, uri varchar(1000) not null, recipientobjectclass varchar(250), recipientobjectid int8, permissionMask int4 not null, primary key (id) ); create table JIOlapClientConnection ( id int8 not null, primary key (id) ); create table JIOlapUnit ( id int8 not null, olapClientConnection int8, mdx_query text not null, view_options bytea, primary key (id) ); create table JIProfileAttribute ( id int8 not null, attrName varchar(255) not null, attrValue varchar(2000), description varchar(255), owner varchar(255), principalobjectclass varchar(255) not null, principalobjectid int8 not null, primary key (id) ); create table JIQuery ( id int8 not null, dataSource int8, query_language varchar(40) not null, sql_query text not null, primary key (id) ); create table JIReportAlertToAddress ( alert_id int8 not null, to_address varchar(100) not null, to_address_idx int4 not null, primary key (alert_id, to_address_idx) ); create table JIReportJob ( id int8 not null, version int4 not null, owner int8 not null, label varchar(100) not null, description varchar(2000), creation_date timestamp, report_unit_uri varchar(250) not null, scheduledResource int8 not null, job_trigger int8 not null, base_output_name varchar(100) not null, output_locale varchar(20), content_destination int8, mail_notification int8, alert int8, primary key (id) ); create table JIReportJobAlert ( id int8 not null, version int4 not null, recipient int2 not null, subject varchar(100), message_text varchar(2000), message_text_when_job_fails varchar(2000), job_state int2 not null, including_stack_trace bool not null, including_report_job_info bool not null, primary key (id) ); create table JIReportJobCalendarTrigger ( id int8 not null, minutes varchar(200) not null, hours varchar(80) not null, days_type int2 not null, week_days varchar(20), month_days varchar(100), months varchar(40) not null, primary key (id) ); create table JIReportJobMail ( id int8 not null, version int4 not null, subject varchar(100) not null, message varchar(2000), send_type int2 not null, skip_empty bool not null, message_text_when_job_fails varchar(2000), inc_stktrc_when_job_fails bool not null, skip_notif_when_job_fails bool not null, primary key (id) ); create table JIReportJobMailRecipient ( destination_id int8 not null, recipient_type int2 not null, address varchar(100) not null, recipient_idx int4 not null, primary key (destination_id, recipient_idx) ); create table JIReportJobOutputFormat ( report_job_id int8 not null, output_format int2 not null, primary key (report_job_id, output_format) ); create table JIReportJobParameter ( job_id int8 not null, parameter_value bytea, parameter_name varchar(100) not null, primary key (job_id, parameter_name) ); create table JIReportJobRepoDest ( id int8 not null, version int4 not null, folder_uri varchar(250), sequential_filenames bool not null, overwrite_files bool not null, save_to_repository bool not null, output_description varchar(250), timestamp_pattern varchar(250), using_def_rpt_opt_folder_uri bool 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 int8, primary key (id) ); create table JIReportJobSimpleTrigger ( id int8 not null, occurrence_count int4 not null, recurrence_interval int4, recurrence_interval_unit int2, primary key (id) ); create table JIReportJobTrigger ( id int8 not null, version int4 not null, timezone varchar(40), start_type int2 not null, start_date timestamp, end_date timestamp, calendar_name varchar(50), misfire_instruction int4 not null, primary key (id) ); 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) ); create table JIReportUnit ( id int8 not null, reportDataSource int8, query int8, mainReport int8, controlrenderer varchar(100), reportrenderer varchar(100), promptcontrols bool, controlslayout int2, data_snapshot_id int8, primary key (id) ); create table JIReportUnitInputControl ( report_unit_id int8 not null, input_control_id int8 not null, control_index int4 not null, primary key (report_unit_id, control_index) ); create table JIReportUnitResource ( report_unit_id int8 not null, resource_id int8 not null, resource_index int4 not null, primary key (report_unit_id, resource_index) ); create table JIRepositoryCache ( id int8 not null, uri varchar(250) not null, cache_name varchar(20) not null, data bytea, version int4 not null, version_date timestamp not null, item_reference int8, primary key (id), unique (uri, cache_name) ); create table JIResource ( id int8 not null, version int4 not null, name varchar(200) not null, parent_folder int8 not null, childrenFolder int8, label varchar(200) not null, description varchar(250), resourceType varchar(255) not null, creation_date timestamp not null, update_date timestamp not null, primary key (id), unique (name, parent_folder) ); create table JIResourceFolder ( id int8 not null, version int4 not null, uri varchar(250) not null, hidden bool, name varchar(200) not null, label varchar(200) not null, description varchar(250), parent_folder int8, creation_date timestamp not null, update_date timestamp not null, primary key (id), unique (uri) ); create table JIRole ( id int8 not null, rolename varchar(100) not null, tenantId int8 not null, externallyDefined bool, primary key (id), unique (rolename, tenantId) ); create table JITenant ( id int8 not null, tenantId varchar(100) not null, tenantAlias varchar(100) not null, parentId int8, 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) ); create table JIUser ( id int8 not null, username varchar(100) not null, tenantId int8 not null, fullname varchar(100) not null, emailAddress varchar(100), password varchar(250), externallyDefined bool, enabled bool, previousPasswordChangeTime timestamp, primary key (id), unique (username, tenantId) ); create table JIUserRole ( roleId int8 not null, userId int8 not null, primary key (userId, roleId) ); create table JIVirtualDataSourceUriMap ( virtualDS_id int8 not null, resource_id int8 not null, data_source_name varchar(200) not null, primary key (virtualDS_id, data_source_name) ); create table JIVirtualDatasource ( id int8 not null, timezone varchar(100), primary key (id) ); create table JIXMLAConnection ( id int8 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) ); create index access_upd_index on JIAccessEvent (updating); create index access_user_index on JIAccessEvent (user_id); create index access_date_index on JIAccessEvent (event_date); create index access_res_index on JIAccessEvent (resource_id); alter table JIAccessEvent add constraint FK47FB3CD732282198 foreign key (user_id) references JIUser; alter table JIAccessEvent add constraint FK47FB3CD7F254B53E foreign key (resource_id) references JIResource on delete cascade; alter table JIAwsDatasource add constraint FK6085542387E4472B foreign key (id) references JIJdbcDatasource; alter table JIAzureSqlDatasource add constraint FKAFE22203C001BAEA foreign key (keyStore_id) references JIResource; alter table JIAzureSqlDatasource add constraint FKAFE2220387E4472B foreign key (id) references JIJdbcDatasource; alter table JIBeanDatasource add constraint FK674BF34A8BF376D foreign key (id) references JIResource; alter table JIContentResource add constraint FKE466FC68A8BF376D foreign key (id) references JIResource; alter table JICustomDatasource add constraint FK2BBCEDF5A8BF376D foreign key (id) references JIResource; alter table JICustomDatasourceProperty add constraint FKB8A66AEA858A89D1 foreign key (ds_id) references JICustomDatasource; alter table JICustomDatasourceResource add constraint FKDF845123F254B53E foreign key (resource_id) references JIResource; alter table JICustomDatasourceResource add constraint FKDF845123858A89D1 foreign key (ds_id) references JICustomDatasource; alter table JIDataSnapshotParameter add constraint id_fk_idx foreign key (id) references JIDataSnapshot; alter table JIDataType add constraint FK533BCC63A8BF376D foreign key (id) references JIResource; alter table JIFTPInfoProperties add constraint FK6BD68B04D5FA3F0A foreign key (repodest_id) references JIReportJobRepoDest; alter table JIFileResource add constraint FKF75B58895A0C539 foreign key (reference) references JIFileResource; alter table JIFileResource add constraint FKF75B5889A8BF376D foreign key (id) references JIResource; alter table JIInputControl add constraint FKCAC6A512B37DB6EB foreign key (list_query) references JIQuery; alter table JIInputControl add constraint FKCAC6A512120E06F7 foreign key (data_type) references JIDataType; alter table JIInputControl add constraint FKCAC6A512A8BF376D foreign key (id) references JIResource; alter table JIInputControl add constraint FKCAC6A51262A86F04 foreign key (list_of_values) references JIListOfValues; alter table JIInputControlQueryColumn add constraint FKE436A5CCE7922149 foreign key (input_control_id) references JIInputControl; alter table JIJNDIJdbcDatasource add constraint FK7F9DA248A8BF376D foreign key (id) references JIResource; alter table JIJdbcDatasource add constraint FKC8BDFCBFA8BF376D foreign key (id) references JIResource; alter table JIListOfValues add constraint FK4E86A776A8BF376D foreign key (id) references JIResource; alter table JIListOfValuesItem add constraint FKD37CEBA993F0E1F6 foreign key (id) references JIListOfValues; alter table JILogEvent add constraint FK5F32081591865AF foreign key (userId) references JIUser; alter table JIMondrianConnection add constraint FK4FF53B19324CFECB foreign key (reportDataSource) references JIResource; alter table JIMondrianConnection add constraint FK4FF53B191D51BFAD foreign key (id) references JIOlapClientConnection; alter table JIMondrianConnection add constraint FK4FF53B19C495A60B foreign key (mondrianSchema) references JIFileResource; alter table JIMondrianXMLADefinition add constraint FK313B2AB8A8BF376D foreign key (id) references JIResource; alter table JIMondrianXMLADefinition add constraint FK313B2AB8DC098B1 foreign key (mondrianConnection) references JIMondrianConnection; alter table JIOlapClientConnection add constraint FK3CA3B7D4A8BF376D foreign key (id) references JIResource; alter table JIOlapUnit add constraint FKF034DCCF8F542247 foreign key (olapClientConnection) references JIOlapClientConnection; alter table JIOlapUnit add constraint FKF034DCCFA8BF376D foreign key (id) references JIResource; alter table JIQuery add constraint FKCBCB0EC92B329A97 foreign key (dataSource) references JIResource; alter table JIQuery add constraint FKCBCB0EC9A8BF376D foreign key (id) references JIResource; alter table JIReportAlertToAddress add constraint FKC4E3713022FA4CBA foreign key (alert_id) references JIReportJobAlert; alter table JIReportJob add constraint FK156F5F6A4141263C foreign key (owner) references JIUser; alter table JIReportJob add constraint FK156F5F6A9EEC902C foreign key (content_destination) references JIReportJobRepoDest; alter table JIReportJob add constraint FK156F5F6AE4D73E35 foreign key (mail_notification) references JIReportJobMail; alter table JIReportJob add constraint FK156F5F6AC83ABB38 foreign key (alert) references JIReportJobAlert; alter table JIReportJob add constraint FK156F5F6A74D2696E foreign key (job_trigger) references JIReportJobTrigger; alter table JIReportJob add constraint FK156F5F6AFF0F459F foreign key (scheduledResource) references JIResource; alter table JIReportJobCalendarTrigger add constraint FKC374C7D0D2B2EB53 foreign key (id) references JIReportJobTrigger; alter table JIReportJobMailRecipient add constraint FKBB6DB6D880001AAE foreign key (destination_id) references JIReportJobMail; alter table JIReportJobOutputFormat add constraint FKB42A5CE2C3389A8 foreign key (report_job_id) references JIReportJob; alter table JIReportJobParameter add constraint FKEAC52B5F2EC643D foreign key (job_id) references JIReportJob; alter table JIReportJobRepoDest add constraint FKEA477EBE3C5B87D0 foreign key (ssh_private_key) references JIResource; alter table JIReportJobSimpleTrigger add constraint FKB9337C5CD2B2EB53 foreign key (id) references JIReportJobTrigger; 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; alter table JIReportUnit add constraint FK98818B77324CFECB foreign key (reportDataSource) references JIResource; alter table JIReportUnit add constraint FK98818B778C8DF21B foreign key (mainReport) references JIFileResource; alter table JIReportUnit add constraint FK98818B778FDA11CC foreign key (query) references JIQuery; alter table JIReportUnit add constraint FK98818B77A8BF376D foreign key (id) references JIResource; alter table JIReportUnitInputControl add constraint FK5FBE934AA6A48880 foreign key (report_unit_id) references JIReportUnit; alter table JIReportUnitInputControl add constraint FK5FBE934AE7922149 foreign key (input_control_id) references JIInputControl; alter table JIReportUnitResource add constraint FK8B1C4CA5A6A48880 foreign key (report_unit_id) references JIReportUnit; alter table JIReportUnitResource add constraint FK8B1C4CA5865B10DA foreign key (resource_id) references JIFileResource; alter table JIRepositoryCache add constraint FKE7338B19E7C5A6 foreign key (item_reference) references JIRepositoryCache; create index resource_type_index on JIResource (resourceType); alter table JIResource add constraint FKD444826DA08E2155 foreign key (parent_folder) references JIResourceFolder; alter table JIResource add constraint FKD444826DA58002DF foreign key (childrenFolder) references JIResourceFolder; alter table JIResourceFolder add constraint FK7F24453BA08E2155 foreign key (parent_folder) references JIResourceFolder; alter table JIRole add constraint FK82724655E415AC2D foreign key (tenantId) references JITenant; alter table JITenant add constraint FKB1D7B2C97803CC2D foreign key (parentId) references JITenant; alter table JIUser add constraint FK8273B1AAE415AC2D foreign key (tenantId) references JITenant; alter table JIUserRole add constraint FKD8B5C1403C31045 foreign key (roleId) references JIRole; alter table JIUserRole add constraint FKD8B5C14091865AF foreign key (userId) references JIUser; alter table JIVirtualDataSourceUriMap add constraint FK4A6CCE01F254B53E foreign key (resource_id) references JIResource; alter table JIVirtualDataSourceUriMap add constraint FK4A6CCE019E600E20 foreign key (virtualDS_id) references JIVirtualDatasource; alter table JIVirtualDatasource add constraint FK30E55631A8BF376D foreign key (id) references JIResource; alter table JIXMLAConnection add constraint FK94C688A71D51BFAD foreign key (id) references JIOlapClientConnection; create sequence hibernate_sequence; 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); 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 idxA1_resource_id_idx on JICustomDatasourceResource (resource_id); 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 idx20_mondrianConnection_idx on JIMondrianXMLADefinition (mondrianConnection); 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 JIQuery_dataSource_index on JIQuery (dataSource); create index JIFileResource_reference_index on JIFileResource (reference); 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);