[AppDB] Add two columns to testResults table
Rosanne DiMesio
dimesio at earthlink.net
Wed Aug 23 13:45:38 CDT 2017
Adds gpuMfr and graphicsDriver. First step toward fixing bug 16031.
Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
---
tables/alter.sql | 1 +
tables/testResults.sql | 2 ++
2 files changed, 3 insertions(+)
diff --git a/tables/alter.sql b/tables/alter.sql
index 457f8d9..4304234 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 gpuMfr ENUM('AMD', 'Intel', 'Nvidia', 'Other', 'Unknown') DEFAULT NULL, ADD COLUMN graphicsDriver ENUM('open source', 'proprietary', 'unknown') DEFAULT NULL;
diff --git a/tables/testResults.sql b/tables/testResults.sql
index 5d35a00..511c115 100644
--- a/tables/testResults.sql
+++ b/tables/testResults.sql
@@ -24,5 +24,7 @@ create table testResults (
submitTime datetime NOT NULL,
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,
key(testingId)
);
--
2.12.3
More information about the wine-patches
mailing list