diff database/schema/bugs.sql @ 38:68a4f2d8930e

Add stuff for automatic feedback timeout.
author David A. Holland
date Sun, 15 Jun 2014 17:21:54 -0400
parents 7458a278cb64
children 45bb7b516edb
line wrap: on
line diff
--- a/database/schema/bugs.sql	Sun Jun 15 17:13:50 2014 -0400
+++ b/database/schema/bugs.sql	Sun Jun 15 17:21:54 2014 -0400
@@ -24,6 +24,18 @@
 	-- should always return empty.
 	-- (no PR should be locked unless it is closed)
 
+	-- Timeouts cause bugs to automatically change state in the
+	-- future.  This is intended to be used for e.g. "feedback
+	-- timeout".
+	--
+	-- States that should have a timeout installed are tagged
+	-- accordingly in the states table. When changing the state of
+	-- a PR, if the new state expects a timeout the PR should be
+	-- given a non-null timeout; otherwise, the timeout field
+	-- should be nulled.
+	timeout_date timestamp	null,
+	timeout_state text	null references states (name),
+
 	-- fixed-size history
 	arrival_schemaversion int  not null,
 	arrival_date timestamp	not null,