changeset 38:68a4f2d8930e

Add stuff for automatic feedback timeout.
author David A. Holland
date Sun, 15 Jun 2014 17:21:54 -0400
parents edf081d0b282
children 45bb7b516edb
files database/schema/bugs.sql database/schema/config.sql
diffstat 2 files changed, 14 insertions(+), 1 deletions(-) [+]
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,
--- a/database/schema/config.sql	Sun Jun 15 17:13:50 2014 -0400
+++ b/database/schema/config.sql	Sun Jun 15 17:21:54 2014 -0400
@@ -62,5 +62,6 @@
        description text		,
        closed boolean		not null,
        nagresponsible boolean	not null,
-       nagsubmitter boolean	not null
+       nagsubmitter boolean	not null,
+       timeout boolean		not null
 ) WITHOUT OIDS;