Francois Gouget : testbot: Require that a Job' s Submitted field always be set.

[Alexandre Julliard]

Module: tools
Branch: master
Commit: 5ddc51c384124f7c5b3db06e5da02d55c6add7bc
URL:    https://source.winehq.org/git/tools.git/?a=commit;h=5ddc51c384124f7c5b3db06e...

Author: Francois Gouget 
Date:   Thu Jan 18 03:58:23 2018 +0100

testbot: Require that a Job's Submitted field always be set.

This guarantees we have at least one field to purge old jobs.

Signed-off-by: Francois Gouget 
Signed-off-by: Alexandre Julliard

---

testbot/ddl/update30.sql           | 4 ++++
 testbot/ddl/winetestbot.sql        | 2 +-
 testbot/doc/winetestbot-schema.dia | 2 +-
 3 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/testbot/ddl/update30.sql b/testbot/ddl/update30.sql
new file mode 100644
index 0000000..892d8d1
--- /dev/null
+++ b/testbot/ddl/update30.sql
@@ -0,0 +1,4 @@
+USE winetestbot;
+
+ALTER TABLE Jobs
+  MODIFY Submitted DATETIME NOT NULL;
diff --git a/testbot/ddl/winetestbot.sql b/testbot/ddl/winetestbot.sql
index ad8d1a9..cebc265 100644
--- a/testbot/ddl/winetestbot.sql
+++ b/testbot/ddl/winetestbot.sql
@@ -114,7 +114,7 @@ CREATE TABLE Jobs
   Priority   INT(1)      NOT NULL,
   Status     ENUM('queued', 'running', 'completed', 'badpatch', 'badbuild', 'boterror', 'canceled') NOT NULL,
   Remarks    VARCHAR(128) NULL,
-  Submitted  DATETIME    NULL,
+  Submitted  DATETIME    NOT NULL,
   Ended      DATETIME    NULL,
   PatchId    INT(7)      NULL,
   FOREIGN KEY (BranchName) REFERENCES Branches(Name),
diff --git a/testbot/doc/winetestbot-schema.dia b/testbot/doc/winetestbot-schema.dia
index ef7c3ca..7a94834 100644
--- a/testbot/doc/winetestbot-schema.dia
+++ b/testbot/doc/winetestbot-schema.dia
@@ -1450,7 +1450,7 @@
             <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="nullable">
-            <dia:boolean val="true"/>
+            <dia:boolean val="false"/>
           </dia:attribute>
           <dia:attribute name="unique">
             <dia:boolean val="false"/>