delete from Zgloszenia;
delete from UczestnicyKonkursow;
delete from Konkursy;

insert into Konkursy values ('BD2010',50,2,'25-OCT-10','26-OCT-10');
insert into Konkursy values ('AISD2010',100,1,'1-OCT-10','20-OCT-10');
insert into Konkursy values ('BD2009',60,3,'25-OCT-09','26-OCT-09');

insert into UczestnicyKonkursow values ('BD2010','Z1');
insert into UczestnicyKonkursow values ('BD2010','Z2');
insert into UczestnicyKonkursow values ('BD2010','Z3');
insert into UczestnicyKonkursow values ('BD2010','Z4');
insert into UczestnicyKonkursow values ('BD2010','Z6');
insert into UczestnicyKonkursow values ('AISD2010','Z1');
insert into UczestnicyKonkursow values ('AISD2010','Z2');
insert into UczestnicyKonkursow values ('AISD2010','Z5');
insert into UczestnicyKonkursow values ('AISD2010','Z6');
insert into UczestnicyKonkursow values ('AISD2010','Z7');

insert into Zgloszenia values(1,'BD2010','Z1','A','25-OCT-10',0);
insert into Zgloszenia values(2,'BD2010','Z1','A',to_date('2010-10-26 00:00', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(3,'BD2010','Z2','A',to_date('2010-10-25 00:00', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(4,'BD2010','Z2','A',to_date('2010-10-25 00:11', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(5,'BD2010','Z2','A',to_date('2010-10-25 00:22', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(6,'BD2010','Z2','A',to_date('2010-10-25 00:33', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(7,'BD2010','Z2','B',to_date('2010-10-25 01:42', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(8,'BD2010','Z6','C',to_date('2010-10-26 00:20', 'yyyy-mm-dd hh24:mi'),1);


insert into Zgloszenia values(10,'AISD2010','Z1','A',to_date('2010-10-01 00:10', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(11,'AISD2010','Z1','A',to_date('2010-10-01 00:20', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(12,'AISD2010','Z1','A',to_date('2010-10-01 01:00', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(13,'AISD2010','Z2','A',to_date('2010-10-01 01:10', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(14,'AISD2010','Z2','A',to_date('2010-10-01 02:10', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(15,'AISD2010','Z5','A',to_date('2010-10-01 01:30', 'yyyy-mm-dd hh24:mi'),0);
insert into Zgloszenia values(16,'AISD2010','Z5','A',to_date('2010-10-01 03:00', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(17,'AISD2010','Z6','B',to_date('2010-10-01 00:11', 'yyyy-mm-dd hh24:mi'),1);
insert into Zgloszenia values(18,'AISD2010','Z7','C',to_date('2010-10-01 00:01', 'yyyy-mm-dd hh24:mi'),0);
