Francois Gouget : testbot: Remove the Patch::AffectsTests field.

[Alexandre Julliard]

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

Author: Francois Gouget 
Date:   Fri Jul 13 12:05:19 2018 +0200

testbot: Remove the Patch::AffectsTests field.

Patches which impact Wine must be tested too so this field is unused
and no longer relevant.

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

---

testbot/ddl/update40.sql           |  4 ++++
 testbot/ddl/winetestbot.sql        |  1 -
 testbot/doc/winetestbot-schema.dia | 23 -----------------------
 testbot/lib/WineTestBot/Patches.pm |  1 -
 4 files changed, 4 insertions(+), 25 deletions(-)

diff --git a/testbot/ddl/update40.sql b/testbot/ddl/update40.sql
new file mode 100644
index 0000000..8fa4606
--- /dev/null
+++ b/testbot/ddl/update40.sql
@@ -0,0 +1,4 @@
+USE winetestbot;
+
+ALTER TABLE Patches
+  DROP AffectsTests;
diff --git a/testbot/ddl/winetestbot.sql b/testbot/ddl/winetestbot.sql
index 96fcdcb..8862c6c 100644
--- a/testbot/ddl/winetestbot.sql
+++ b/testbot/ddl/winetestbot.sql
@@ -68,7 +68,6 @@ CREATE TABLE Patches
   WebPatchId  INT(7)          NULL,
   Received    DATETIME        NOT NULL,
   Disposition VARCHAR(40)     NOT NULL,
-  AffectsTests ENUM('Y', 'N') NOT NULL,
   FromName    VARCHAR(40)     NULL,
   FromEMail   VARCHAR(40)     NULL,
   Subject     VARCHAR(120)    NULL,
diff --git a/testbot/doc/winetestbot-schema.dia b/testbot/doc/winetestbot-schema.dia
index d3efcb8..c54897a 100644
--- a/testbot/doc/winetestbot-schema.dia
+++ b/testbot/doc/winetestbot-schema.dia
@@ -1092,29 +1092,6 @@
         </dia:composite>
         <dia:composite type="table_attribute">
           <dia:attribute name="name">
-            dia:string#AffectsTests#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="type">
-            dia:string#BOOL#</dia:string>
-          </dia:attribute>
-          <dia:attribute name="comment">
-            dia:string##</dia:string>
-          </dia:attribute>
-          <dia:attribute name="primary_key">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="nullable">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="unique">
-            <dia:boolean val="false"/>
-          </dia:attribute>
-          <dia:attribute name="default_value">
-            dia:string##</dia:string>
-          </dia:attribute>
-        </dia:composite>
-        <dia:composite type="table_attribute">
-          <dia:attribute name="name">
             dia:string#FromName#</dia:string>
           </dia:attribute>
           <dia:attribute name="type">
diff --git a/testbot/lib/WineTestBot/Patches.pm b/testbot/lib/WineTestBot/Patches.pm
index 23b9217..f5ef431 100644
--- a/testbot/lib/WineTestBot/Patches.pm
+++ b/testbot/lib/WineTestBot/Patches.pm
@@ -346,7 +346,6 @@ my @PropertyDescriptors = (
   CreateBasicPropertyDescriptor("Id", "Patch id", 1, 1, "S",  7),
   CreateBasicPropertyDescriptor("WebPatchId", "Wine Web Patch id", !1, !1, "N",  7),
   CreateBasicPropertyDescriptor("Received", "Received", !1, 1, "DT", 19),
-  CreateBasicPropertyDescriptor("AffectsTests", "Affects tests", !1, 1, "B", 1),
   CreateBasicPropertyDescriptor("FromName", "Author", !1, !1, "A", 40),
   CreateBasicPropertyDescriptor("FromEMail", "Author's email address", !1, !1, "A", 40),
   CreateBasicPropertyDescriptor("Subject", "Subject", !1, !1, "A", 120),