/*bOnTimeDataExport 1.6.0*/
insert into Clients (clientid,clientname,archived) values (1,'Ministry of Health ',0)
insert into Clients (clientid,clientname,archived) values (4,'Fujitsu',0)
insert into Projects (projid,clientid,projname,rate,archived) values (1,1,'HOOPC II',0,0)
insert into Projects (projid,clientid,projname,rate,archived) values (2,1,'HSCIS',0,0)
insert into Projects (projid,clientid,projname,rate,archived) values (3,1,'PURRFECT',0,0)
insert into Projects (projid,clientid,projname,rate,archived) values (4,4,'BCAS Proposal',0,0)
insert into Projects (projid,clientid,projname,rate,archived) values (5,4,'Recruiting ',0,0)
insert into Projects (projid,clientid,projname,rate,archived) values (6,4,'Marketing ',0,0)
insert into Tasks (taskid,projid,taskname) values (1,3,'Project Management ')
insert into Tasks (taskid,projid,taskname) values (2,3,'Analysis/Architecture ')
insert into Tasks (taskid,projid,taskname) values (3,2,'Web Application ')
insert into Tasks (taskid,projid,taskname) values (4,2,'MIS Reporting ')
insert into Tasks (taskid,projid,taskname) values (5,1,'Project Management ')
insert into Tasks (taskid,projid,taskname) values (6,1,'Analysis/Architecture ')
insert into Tasks (taskid,projid,taskname) values (7,4,'Stuff ')
insert into Tasks (taskid,projid,taskname) values (8,5,'Stuff ')
insert into Tasks (taskid,projid,taskname) values (9,6,'Stuff ')
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (2,5,'Worked on MPP','2003-10-06 00:00','2003-10-06 01:30',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (3,5,'MPP Review ','2003-10-07 00:00','2003-10-07 02:00',120,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (4,6,'Review of Prototype ','2003-10-07 00:00','2003-10-07 01:30',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (5,3,'Testlng of web site','2003-10-08 17:42','2003-10-08 18:12',30,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (6,3,'Rewrite of User Guide','2003-10-08 17:42','2003-10-08 19:12',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (7,4,'Stuff','2003-10-07 00:00','2003-10-07 00:45',45,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (8,2,'Write up 8.5 BR','2003-10-06 00:00','2003-10-06 02:30',150,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (9,1,'Set up mtgs','2003-10-07 00:00','2003-10-07 00:30',30,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (10,8,'Respond to questions from prospect ','2003-10-07 00:00','2003-10-07 00:30',30,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (11,8,'Input referrals ','2003-10-06 00:00','2003-10-06 01:30',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (12,9,'Set up BI/DW seminars','2003-10-07 00:00','2003-10-07 01:00',60,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (13,7,'Prepare for stage 3','2003-10-06 00:00','2003-10-06 02:30',150,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (14,7,'Do stage 2 presentation ','2003-10-03 00:00','2003-10-03 03:45',225,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (15,8,'Lunch w/John B','2003-09-29 00:00','2003-09-29 01:30',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (16,5,'Project Status meeting ','2003-10-08 17:55','2003-10-08 19:25',90,0,0)
insert into Jobs (jobid,taskid,comment,starttime,endtime,duration,jobstatus,resttime) values (17,5,'Review of Web standards','2003-10-08 17:56','2003-10-08 18:56',60,0,0)
insert into Settings (szName,szValue) values ('DaysToDisplay',30)
insert into Settings (szName,szValue) values ('OrderBy',0)
insert into Settings (szName,szValue) values ('DurationFormat','Time (e.g. 1:30)')
insert into Settings (szName,szValue) values ('DBVersion',2)
insert into Settings (szName,szValue) values ('DurationEntry','True')
insert into Settings (szName,szValue) values ('JobDisplay',7)
insert into Settings (szName,szValue) values ('AssumeDurHours','False')
insert into Settings (szName,szValue) values ('ExpandedTree','True')
insert into Settings (szName,szValue) values ('ProfileOnExport','False')
insert into Settings (szName,szValue) values ('DontShowSummary','False')
insert into Settings (szName,szValue) values ('ProfileName','Don Tolson')
insert into Settings (szName,szValue) values ('ProfileCompany','Fujitsu Consulting ')
insert into Settings (szName,szValue) values ('ProfileAddress','')
insert into Settings (szName,szValue) values ('ProfileCity','Victoria, BC')
insert into Settings (szName,szValue) values ('ProfileCountry','Canada ')