c3622baedca8d8c7df2c69754b943179e8d04d61 kent Fri Dec 27 18:42:23 2013 -0800 Moving jobResult to lib directory so it can be shared. diff --git src/parasol/lib/jobResult.sql src/parasol/lib/jobResult.sql new file mode 100644 index 0000000..e7956fd --- /dev/null +++ src/parasol/lib/jobResult.sql @@ -0,0 +1,21 @@ +# jobResult.sql was originally generated by the autoSql program, which also +# generated jobResult.c and jobResult.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Info about the result of one job from parasol +CREATE TABLE jobResult ( + status int not null, # Job status - wait() return format. 0 is good. + host varchar(255) not null, # Machine job ran on. + jobId varchar(255) not null, # Job queuing system job ID + exe varchar(255) not null, # Job executable file (no path) + usrTicks int not null, # 'User' CPU time in ticks. + sysTicks int not null, # 'System' CPU time in ticks. + submitTime int unsigned not null, # Job submission time in seconds since 1/1/1970 + startTime int unsigned not null, # Job start time in seconds since 1/1/1970 + endTime int unsigned not null, # Job end time in seconds since 1/1/1970 + user varchar(255) not null, # User who ran job + errFile varchar(255) not null, # Location of stderr file on host + #Indices + PRIMARY KEY(status) +);