From 16ab264ea800faf8d834cea9a485b64ca7653483 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Mon, 19 Nov 2007 00:39:07 +0000
Subject: Timestamp note

svn path=/scripts/README; revision=1319
---
 scripts/README | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'scripts')

diff --git a/scripts/README b/scripts/README
index 5eec273a..3dc0d0fe 100644
--- a/scripts/README
+++ b/scripts/README
@@ -84,6 +84,12 @@ Current TO DO list:
     state     := pending | active | deprecated | revoked
     timestamp := NULL | <time of next transition>
 
+  We can check for things with expired timers directly by doing
+  something like:
+
+    SELECT blah FROM ca_detail
+    WHERE timestamp IS NOT NULL and timestamp < UTC_TIMESTAMP()
+
   At this point I doubt we really need the revoked state.  If we do
   need the revoked state, the timer becomes the delay until we can get
   rid of the ca_detail object entirely, or something like that.
-- 
cgit v1.2.3