ludc
2025-01-16 986aa62ed00bee39363bab41b4eeb8259d446efd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
CREATE OR REPLACE TRIGGER "SYNC_ROLE_INITIALIZE_COPY"
  before insert or update or delete on plrole
/*************************************************************
author: liucq
create time: 2015.06.01
description: Ô­Ê¼½ÇÉ«±í£¨plrole£©ÉϵÄǰÖô¥·¢Æ÷
 
 
logic rules: ½öÖ´Ðгõʼ»¯£¨ÒµÎñÀàÐÍ platformbtm_role±íÖÐûÓÐÊý¾Ýʱ²ÅÖ´ÐгõʼÊý¾Ý²åÈ룩
last modifyer: 2017.06.07
last modify time: 2017.06.07
change history:
       2017.06.07 xchao Ìí¼Ó×¢ÊÍ
*************************************************************/
declare
  roleTabCount number;
  roleCount number;
begin
  select count(*) into roleTabCount from user_tables where lower(table_name) = 'platformbtm_role';
  if roleTabCount = 0 then
    return;
  else
    select count(*) into roleCount from platformbtm_role;
    if roleCount != 0 then
      return;
    else
        insert into platformbtm_role (
           OID,
           REVISIONOID,
           NAMEOID,
           BTMNAME,
           ISLASTR,
           ISFIRSTR,
           ISLASTV,
           ISFIRSTV,
           CREATOR,
           CREATETIME,
           LASTMODIFIER,
           LASTMODIFYTIME,
           REVISIONRULE,
           VERSIONRULE,
           REVISIONSEQ,
           REVISIONVALUE,
           VERSIONSEQ,
           VERSIONVALUE,
           LCTID,
           LCSTATUS,
           TS,
           ID,
           NAME,
           DESCRIPTION,
           OWNER,
           CHECKINBY,
           CHECKINTIME,
           CHECKOUTBY,
           CHECKOUTTIME,
           COPYFROMVERSION,
           roletype
          )
       select pluid,get_uuid,get_uuid,'role','1','1','1','1',plcreateuser,plcreatetime,plcreateuser,plcreatetime,'','','1','','1','',
       'RoleLC','Exist',plcreatetime,'',plname,pldesc,plcreateuser,plcreateuser,plcreatetime,'','','',pltype from plrole where pluid not in (select oid from platformbtm_role);
     end if;
  end if;
end;
/