if exists(select 1 from sys.sysforeignkey where role='FK_CPS_FUNC_FK_CPS_FU_CPS_PERM') then
alter table CPSSYS.CPS_FUNC_PERMISSION_DATA
delete foreign key FK_CPS_FUNC_FK_CPS_FU_CPS_PERM
end if;
if exists(select 1 from sys.sysforeignkey where role='FK_CPS_FUNC_FK_CPS_FU_CPS_DATA') then
alter table CPSSYS.CPS_FUNC_PERMISSION_DATA
delete foreign key FK_CPS_FUNC_FK_CPS_FU_CPS_DATA
end if;
if exists(
select 1 from sys.systable
where table_name='CPS_FUNC_PERMISSION_DATA'
and table_type in ('BASE', 'GBL TEMP')
and creator=user_id('CPSSYS')
) then
drop table CPSSYS.CPS_FUNC_PERMISSION_DATA
end if;
/*==============================================================*/
/* Table: CPS_FUNC_PERMISSION_DATA */
/*==============================================================*/
create table CPSSYS.CPS_FUNC_PERMISSION_DATA
(
PERMISSION_IDENTIFIES VARCHAR2(100) not null,
DATAPERMISSION_ID VARCHAR2(100) not null,
PARENT_DATAPERMISSION_ID VARCHAR2(100) null,
ALLOWALLITEM VARCHAR2(1) null,
IDENTITY_TYPE VARCHAR2(4) not null,
constraint PK_CPS_FUNC_PERMISSION_DATA primary key (PERMISSION_IDENTIFIES, DATAPERMISSION_ID, IDENTITY_TYPE)
);
comment on table CPSSYS.CPS_FUNC_PERMISSION_DATA is
'<EnglishName>
CPS_FUNC_PERMISSION_DATA
</EnglishName>
<EnglishComment>
This table is used to define what operation permission
needs to be checked by data granularity.
</EnglishComment>
<ChineseComment>
定义系统里哪些功能权限下需要进行数据权限的管理
</ChineseComment>';
comment on column CPSSYS.CPS_FUNC_PERMISSION_DATA.PERMISSION_IDENTIFIES is
'<EnglishName>
Permission Identity
</EnglishName>
<EnglishComment>
The unique identifier of an operation permission.
</EnglishComment>
<ChineseComment>
功能权限唯一标识符
</ChineseComment>';
comment on column CPSSYS.CPS_FUNC_PERMISSION_DATA.DATAPERMISSION_ID is
'<EnglishName>
Data Permission ID
</EnglishName>
<EnglishComment>
The unique identifier of a data granularity. Its value must be defined in the table CPS_DATA_PERMISSION_DEF.
</EnglishComment>