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_USER_INITIALIZE_COPY"
| before insert or update or delete on pluser
| /*************************************************************
| author: liucq
| create time: 2015.06.01
| description: ÔʼÓû§±í£¨pluser£©ÉϵÄÇ°Öô¥·¢Æ÷£¬
|
|
| logic rules: ½öÖ´Ðгõʼ»¯£¨µ± ÒµÎñÀàÐÍ platformbtm_user ±íÖÐûÓÐÊý¾Ýʱ²ÅÖ´Ðгõʼ»¯Êý¾Ý²åÈ룩
| last modifyer: 2017.06.07
| last modify time: 2017.06.07
| change history:
| 2017.06.07 xchao Ìí¼Ó×¢ÊÍ
| *************************************************************/
| declare
| userTabCount number;
| userCount number;
| begin
| select count(*) into userTabCount from user_tables where lower(table_name) = 'platformbtm_user';
| if userTabCount = 0 then
| return;
| else
| select count(*) into userCount from platformbtm_user;
| if userCount != 0 then
| return;
| else
| insert into platformbtm_user (
| 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,
| USERSECURITY
| )
| select pluid,get_uuid,get_uuid,'user','1','1','1','1',plcreateuser,plcreatetime,plcreateuser,plcreatetime,'','','1','','1','',
| 'userLC','Exist',plcreatetime,plusername,pltruename,pldesc,plcreateuser,plcreateuser,plcreatetime,'','','',PLSECRETGRADE from pluser where pluid not in (select oid from platformbtm_user);
| end if;
| end if;
| end;
| /
|
|
