Skip to content
Snippets Groups Projects
Select Git revision
  • DEVELOP_BE
  • master default protected
  • bugfix/security_updates_082023
  • BTB-34
  • Change_2020_Init
  • DEVELOP_BE_FLYWAY
  • DEVELOP_BE_ORADB
7 results
Blame Permalink
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
test_data.sql 19.01 KiB 
-- Hier können weitere/alle benötigte Testdaten eingefügt werden. 

-- Testdata for tbl_notification

Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (14,5,2,1,'Meldung X:Y','','extended',2,'',null,null,'Abteilung 4',null,'MasterAndCreator',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),'_fd',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (15,6,1,1,'Meldung X:Y','','extended',2,'',null,null,'Abteilung 4',null,'MasterAndCreator',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),'_fd',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (16,7,1,1,'Meldung X:Y','','extended',2,'',null,null,'Abteilung 4',null,'MasterAndCreator',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),'_fd',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (17,8,1,1,'Meldung X:Y','','extended',2,'',null,null,'Abteilung 4',null,'MasterAndCreator',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),'_fd',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (21,12,1,3,'fasdf','sadfsdf','sdfsdf',4,'sdfds',to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-15 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'sdfds',to_timestamp('2017-05-22 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (22,13,1,2,'sdfsadf','sdfsda','sdafsd',3,'sdfsd',null,null,'sdfsd',null,'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (23,14,1,1,'dsfsdaf','sdafsdf','fdgsdfg',2,'sadfdsf',null,null,'sdfsdf',null,'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (11,2,0,1,'sfg','freetext11','freetext_extended',1,null,null,null,null,null,'Creator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (27,18,1,1,'Meldung X:Y','','extended',2,'',null,null,'Abteilung 4',null,'MasterAndCreator',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),'_fd',to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-03-09 15:27:17.0','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (33,100,3,1,'Text 100 3',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:54:12.467632','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:54:12.467632','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (36,101,3,1,'Text 101 3',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (30,100,1,1,'Text 100 1',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:53:29.925035','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:53:29.925035','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (32,100,2,1,'Text 100 2',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:54:04.506725','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:54:04.506725','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (35,101,2,1,'Text 101 2',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (34,101,1,1,'Text 101 1',null,null,1,null,null,null,null,null,'Administrator',to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-11 15:54:47.84887','YYYY-MM-DD HH24:MI:SS.US'));
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (37,19,1,1,'Meldung _fd 1, 2, 3','Freitext zur Meldung 1,23','',1,'Hermann Meister',to_timestamp('2017-05-10 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-18 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Frank D.',null,'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (38,20,1,2,'test^1','test2','test3',2,'avb',to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-17 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'sdfd',to_timestamp('2017-05-15 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (41,23,1,2,'test','tasdf','asdfsd',2,null,null,null,null,null,'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (42,24,1,3,'teste','teste','teset',2,'asdf',to_timestamp('2017-05-24 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-14 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'asdf',to_timestamp('2017-05-16 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (43,25,1,1,'Text','FT','wFT',1,'Schulzendorff',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (45,27,1,1,'nochne Meldung','t','ft',1,'Schulzendorff',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (46,28,1,3,'asdfds','sdafsdf','sdafdsf',3,'sdf',to_timestamp('2017-05-22 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-30 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'sdf',to_timestamp('2017-05-16 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (47,29,1,3,'dsfdas','sdfdasf','asdfsdfas',2,'asdfas',to_timestamp('2017-05-22 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'dsfds',to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (48,30,1,1,'neu',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (49,31,2,1,'neu',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (50,32,3,1,'neu und 2mal update',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (51,33,1,1,'admin','admin','�lja�ldfkj',1,null,to_timestamp('2017-05-09 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),null,null,to_timestamp('2017-05-09 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (52,34,1,2,'adfaf','adfaf','adfaf',1,'adfaf',null,null,null,null,'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (53,35,4,1,'neu und 3mal update',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (55,35,5,1,'neu und 4mal update',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (56,35,7,1,'pk_id 55 neue Version ',null,null,1,'GS',null,null,null,null,'Otto Normalverbraucher',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (57,20,2,2,'test^1 update versuch. Die Indident ID soll auf 20 bleiben. Die Version muss 2 sein.','test2','test3',2,'avb',to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-17 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'sdfd',to_timestamp('2017-05-15 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (58,36,1,3,'fasdfasdf','asdfdasf','sadfdasf',3,'sdfdas',to_timestamp('2017-05-10 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-16 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'dsfdas',to_timestamp('2017-05-08 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );
Insert into TBL_NOTIFICATION ("id","incident_id","version","fk_ref_branch","notification_text","free_text","free_text_extended","fk_ref_notification_status","responsibility_forwarding","reminder_date","expected_finished_date","responsibility_control_point","finished_date","create_user","create_date","mod_user","mod_date","begin_date") values (59,37,1,3,'sadfasdf','sdafasdf','asdfasdf',1,'asdfasdf',to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),to_timestamp('2017-05-23 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'asdfdasf',to_timestamp('2017-05-29 22:00:00.0','YYYY-MM-DD HH24:MI:SS.US'),'Administrator',LOCALTIMESTAMP,null,null,LOCALTIMESTAMP );

Copyright © Eclipse Foundation, Inc. All Rights Reserved.     Privacy Policy | Terms of Use | Copyright Agent