Rosanne DiMesio : Add two columns to testResults table
Jeremy Newman
jnewman at winehq.org
Wed Aug 16 11:33:23 CDT 2017
Module: appdb
Branch: master
Commit: c0f7b6f62b4b72159d00e4ed852581cd6abefacf
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=c0f7b6f62b4b72159d00e4ed852581cd6abefacf
Author: Rosanne DiMesio <dimesio at earthlink.net>
Date: Wed Aug 16 11:26:03 2017 -0500
Add two columns to testResults table
Adds usedWorkarounds and workarounds columns. First step
toward fixing bug 16169.
Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
Signed-off-by: Jeremy Newman <jnewman at codeweavers.com>
---
tables/alter.sql | 2 ++
tables/testResults.sql | 2 ++
2 files changed, 4 insertions(+)
diff --git a/tables/alter.sql b/tables/alter.sql
index 457f8d9..f61f3fb 100644
--- a/tables/alter.sql
+++ b/tables/alter.sql
@@ -1,2 +1,4 @@
/* 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 usedWorkaround ENUM("Yes", "No") DEFAULT NULL AFTER runs, ADD COLUMN workarounds TEXT DEFAULT NULL AFTER usedWorkaround;
diff --git a/tables/testResults.sql b/tables/testResults.sql
index 44a52ae..5d35a00 100644
--- a/tables/testResults.sql
+++ b/tables/testResults.sql
@@ -17,6 +17,8 @@ create table testResults (
staging tinyint(1) not null default '0',
installs enum('Yes','No','No, but has workaround','N/A') NOT NULL default 'Yes',
runs enum('Yes','No','Not Installable') NOT NULL default 'Yes',
+ usedWorkaround enum('Yes','No') default NULL,
+ workarounds text default NULL,
testedRating enum('Platinum','Gold','Silver','Bronze','Garbage') NOT NULL,
comments text,
submitTime datetime NOT NULL,
More information about the wine-cvs
mailing list