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;
| /
|
|