From 65e2418d2a82e1ae939dd402052e26ec3572c163 Mon Sep 17 00:00:00 2001
From: sienkiew <sienkiew@d34015c8-bcbb-4646-8ac8-8ba5febf221d>
Date: Mon, 3 Oct 2011 21:51:04 +0000
Subject: checkpoint

git-svn-id: https://svn.stsci.edu/svn/ssb/etal/steuermann/trunk@435 d34015c8-bcbb-4646-8ac8-8ba5febf221d
---
 steuermann/db.sql | 25 ++++++++++++++++++++++++-
 1 file changed, 24 insertions(+), 1 deletion(-)

(limited to 'steuermann/db.sql')

diff --git a/steuermann/db.sql b/steuermann/db.sql
index b6d2ae6..99bc752 100644
--- a/steuermann/db.sql
+++ b/steuermann/db.sql
@@ -43,8 +43,31 @@ create unique index sm_status_idx1 on sm_status ( run, host, tablename, cmd );
 
 -- table lists all run names in the system
 CREATE TABLE sm_runs (
-	run	VARCHAR(100)
+	run		VARCHAR(100),
+	create_time	VARCHAR(26)
 	);
 
 CREATE UNIQUE INDEX sm_runs_idx1 ON sm_runs(run);
 
+
+-- table lists scheduled cron events - sort of like the old sr
+-- 	smcron name script
+CREATE TABLE sm_crons (
+	host		VARCHAR,
+		-- what host we ran this on
+	name		VARCHAR(100),
+		-- a descriptive name, not necessarily unique
+	decollision	VARCHAR(10),
+		-- a cookie to make (host,name,decollision) unique
+	start_time	VARCHAR(30),
+	end_time	VARCHAR(30),
+	duration	REAL,
+		-- 
+	status		VARCHAR(5),
+		-- exit status 
+	logfile		VARCHAR(1000)
+		-- log file name, relative to config logdir+'/cron/'
+	);
+
+CREATE INDEX sm_crons_idx1 ON sm_crons( host, name, decollision );
+
-- 
cgit 

