-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathtemp
32 lines (14 loc) · 1.54 KB
/
temp
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
SELECT * FROM GroupTypeInsert('testfromdb','testfromdb','INSERT',1,'test');
SELECT * FROM GroupTypeInsert('testfromdb','testfromdb','SystemInit_Insert',1,'test');
SELECT * FROM GroupInsert('testfromdb','testfromdb',3,2,'INSERT',10,'test');
SELECT * FROM UserInsert('testfromdb1','testfromdb1',current_date,'testfromdb1','testfromdb1','testfromdb1',1,'S',3,'SYS_PER_INSERT',2,'RequestedOperation');
SELECT * FROM UserUpdate('testfromdb1','pass-update1',current_date,'fname-update1','mname-updat1','lname-update1',1,'U','testing update','testing update',4,'SYS_PER_USER_AU_EMAIL',4,'update');
SELECT * FROM UserRegInsert('MetaInfo','_Desc','Users',1,1,'SYS_PER_INSERT',1,'ip');
SELECT * FROM UserRegUpdate('MetaInfo-updated','_Desc-updated','Users-updated',1,1,'SYS_PER_UPDATE','update test from db',1,'testfromdb');
SELECT * FROM AppEventTypeInsert('TEST-FROM-DB','TEST-FROM-DB','SYS_PER_INSERT',13,'TEST-FROM-DB');
SELECT * FROM AppEventInsert(1,'TEST-FROM-DB','TEST-FROM-DB','now()',3600,2,-1,'[1,2,3]','SYS_PER_INSERT',13,'TEST-FROM-DB');
SELECT * FROM AppEventRoundInsert(1,'Round1','Round1','now()',3600,-1,'SYS_PER_INSERT',13,'test-from-db');
SELECT * FROM CommunicationTypeInsert ( 'TEST-FROM-DB','TEST-FROM-DB','SYS_PER_INSERT',13,'TEST-FROM-DB');
SELECT * FROM MessgaeInsert('Title','Content',1,1,'now()',1,1,-1,-1,'SYS_PER_INSERT',13,'ip');
SELECT * FROM MessgaeUpdate(1,'Title-updated','Content-updated',1,1,'now()',1,1,-1,-1,'SYS_PER_UPDATE','LogsDesc',13,'ip');
SELECT * FROM CommentInsert(1,1,13,1,'CommentText','SYS_PER_INSERT',13,'IP');