sampleData.input

INSERT INTO section(sectionname) VALUES ('requirement');
INSERT INTO section(sectionname) VALUES ('analysis');
INSERT INTO section(sectionname) VALUES ('design');
INSERT INTO section(sectionname) VALUES ('implementation');
INSERT INTO section(sectionname) VALUES ('modiriat');
INSERT INTO section(sectionname) VALUES ('newEmployees');
INSERT INTO accessright(accessrightname) VALUES ('default');
INSERT INTO accessright(accessrightname) VALUES ('intermediate');
INSERT INTO accessright(accessrightname) VALUES ('super');
INSERT INTO employee(empname,post,username,password,is_loggedin,sid,accessrightid,is_confirmed) VALUES ('gholam abasi','programmer','gholam','123',false,1,1,false);
INSERT INTO employee(empname,post,username,password,is_loggedin,sid,accessrightid,is_confirmed) VALUES ('ali khobregan','manager','ali','123',false,1,3,true);
INSERT INTO employee(empname,post,username,password,is_loggedin,sid,accessrightid,is_confirmed) VALUES ('arian niaki','analyst','arian','123',false,1,2,true);
INSERT INTO resource(rname,sid) VALUES ('monitor1',1);
INSERT INTO resource(rname,sid) VALUES ('printer1',1);
INSERT INTO resource(rname,sid) VALUES ('information document',2);
INSERT INTO resource(rname,sid) VALUES ('100 $',2);
INSERT INTO resource(rname,sid) VALUES ('module1',4);
INSERT INTO resource(rname,sid) VALUES ('Apartment A',2);
INSERT INTO module (modname,duration,modrid) VALUES ('module1',5,5);
INSERT INTO physres(physname,modeldesc,rid) VALUES ('monitor1','model monitor LG',1);
INSERT INTO physres(physname,modeldesc,rid) VALUES ('printer1','printer HP',2);
INSERT INTO infores(IRname,createdate,description,rid) VALUES ('information document','2012-2-2','this information document is about project experiences',3);
INSERT INTO finanres(finanname,netvalue,modeldesc,description,rid) VALUES ('100 $',100,'money','100 $ in account A',4);
INSERT INTO finanres(finanname,netvalue,modeldesc,description,rid) VALUES ('Apartment A',10000,'building','a department in Tehran, Vanak',6);
INSERT INTO project(projname,size,tech,is_complete,projectmanager) VALUES ('project','10','java',true,2);
INSERT INTO subsystem(Sname,pid,sid) VALUES ('subsytem e hanali',1,1);
INSERT INTO resourcerequirement(rid,sid,pid,fromdate,todate,is_satisfied,satisfydate) VALUES (2, 1,1,'2016-1-1','2016-1-2',true,'2016-1-1');
INSERT INTO projectresourceutilization (rid,sid,pid,fromdate,todate) VALUES (1,1,1,'2012-2-2','2012-2-3');
INSERT INTO maintainmodule (modrid,changetype,duration) VALUES (5,'proactive',124);
INSERT INTO moduleemployee (modrid,empid) VALUES (5,1);
INSERT INTO moduleresourceutilization (modrid,rid) VALUES (5,2);
INSERT INTO projectemployee (projid,empid,fromdate,todate) VALUES (1,3,'2016-01-01','2016-10-10');
INSERT INTO maintainmodemp(maintainid,empid) VALUES (1,1);
INSERT INTO maintainmodemp(maintainid,empid) VALUES (1,2);
INSERT INTO maintainmodres(maintainid,rid) VALUES (1,1);
INSERT INTO maintainmodres(maintainid,rid) VALUES (1,2);
INSERT INTO maintainmodres(maintainid,rid) VALUES (1,3);