Rosanne DiMesio : Add hasProblems field to testResults table
Jeremy Newman
jnewman at winehq.org
Wed Sep 27 15:27:54 CDT 2017
Module: appdb
Branch: master
Commit: e283e25ac4efc2f1a50bd8e7bdf3d3bf52f4bd1b
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=e283e25ac4efc2f1a50bd8e7bdf3d3bf52f4bd1b
Author: Rosanne DiMesio <dimesio at earthlink.net>
Date: Wed Sep 27 13:44:19 2017 -0500
Add hasProblems field to testResults table
The field will be used to check whether the rating given
conforms to the rating definitions.
Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
Signed-off-by: Jeremy Newman <jnewman at codeweavers.com>
---
tables/alter.sql | 1 +
tables/testResults.sql | 3 ++-
2 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/tables/alter.sql b/tables/alter.sql
index 457f8d9..6f536fb 100644
--- a/tables/alter.sql
+++ b/tables/alter.sql
@@ -1,2 +1,3 @@
/* append to this file when changes are required to the live db */
/* it will be cleared when the changes go live */
+ALTER TABLE testResults ADD COLUMN hasProblems ENUM("Yes", "No") DEFAULT NULL;
diff --git a/tables/testResults.sql b/tables/testResults.sql
index 511c115..92c46e6 100644
--- a/tables/testResults.sql
+++ b/tables/testResults.sql
@@ -25,6 +25,7 @@ create table testResults (
submitterId int(11) NOT NULL default '0',
state enum('accepted','queued','rejected','pending','deleted') NOT NULL default 'accepted',
gpuMfr enum('AMD', 'Intel', 'Nvidia', 'Other', 'Unknown') default NULL,
- graphicsDriver enum('open source', 'proprietary', 'unknown') default NULL,
+ graphicsDriver enum('open source', 'proprietary', 'unknown') default NULL,
+ hasProblems enum('Yes', 'No') default NULL,
key(testingId)
);
More information about the wine-cvs
mailing list