appdb/ include/testResults.php tables/testResu ...

[WineHQ]

ChangeSet ID:	22871
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	wineowner at winehq.org	2006/02/07 19:44:11

Modified files:
	include        : testResults.php 
	tables         : testResults.sql 

Log message:
	Tony Lambregts <tony.lambregts at gmail.com>
	Modify 'installs' and 'runs' fields

Patch: http://cvs.winehq.org/patch.py?id=22871

Old revision  New revision  Changes     Path
 1.9           1.10          +6 -6       appdb/include/testResults.php
 1.1           1.2           +2 -3       appdb/tables/testResults.sql

Index: appdb/include/testResults.php
diff -u -p appdb/include/testResults.php:1.9 appdb/include/testResults.php:1.10
--- appdb/include/testResults.php:1.9	8 Feb 2006  1:44:11 -0000
+++ appdb/include/testResults.php	8 Feb 2006  1:44:11 -0000
@@ -657,15 +657,15 @@ function make_Installs_list($varname, $c
     
     echo "<select name='$varname'>\n";
     echo "<option value=\"\">Choose ...</option>\n";
-    $aRating = array("Yes", "No");
+    $aRating = array("Yes", "No", "N/A");
     $iMax = count($aRating);
 
     for($i=0; $i < $iMax; $i++)
     {
         if($aRating[$i] == $cvalue)
-            echo "<option value=$aRating[$i] selected>$aRating[$i]\n";
+            echo "<option value='".$aRating[$i]."' selected>".$aRating[$i]."\n";
         else
-            echo "<option value=$aRating[$i]>$aRating[$i]\n";
+            echo "<option value='".$aRating[$i]."'>".$aRating[$i]."\n";
     }
     echo "</select>\n";
 }
@@ -675,15 +675,15 @@ function make_Runs_list($varname, $cvalu
     
     echo "<select name='$varname'>\n";
     echo "<option value=\"\">Choose ...</option>\n";
-    $aRating = array("Yes", "No", "???");
+    $aRating = array("Yes", "No", "Not Installable");
     $iMax = count($aRating);
 
     for($i=0; $i < $iMax; $i++)
     {
         if($aRating[$i] == $cvalue)
-            echo "<option value=$aRating[$i] selected>$aRating[$i]\n";
+            echo "<option value='".$aRating[$i]."' selected>".$aRating[$i]."\n";
         else
-            echo "<option value=$aRating[$i]>$aRating[$i]\n";
+            echo "<option value='".$aRating[$i]."'>".$aRating[$i]."\n";
     }
     echo "</select>\n";
 }
Index: appdb/tables/testResults.sql
diff -u -p appdb/tables/testResults.sql:1.1 appdb/tables/testResults.sql:1.2
--- appdb/tables/testResults.sql:1.1	8 Feb 2006  1:44:11 -0000
+++ appdb/tables/testResults.sql	8 Feb 2006  1:44:11 -0000
@@ -1,7 +1,6 @@
 use apidb;
 
 drop table if exists testResults;
-drop table if exists TestResults;
 
 /*
  * Version Testing results
@@ -15,8 +14,8 @@ create table testResults (
         testedDate      datetime not null,
         distributionId  int not null,
 	testedRelease 	tinytext,
-	installs	enum('Yes','No') NOT NULL default 'Yes',
-	runs		enum('Yes','No','???') NOT NULL default 'Yes',
+	installs	enum('Yes','No','N/A') NOT NULL default 'Yes',
+	runs		enum('Yes','No','Not Installable') NOT NULL default 'Yes',
 	testedRating  	tinytext,
         comments        text,
 	submitTime	timestamp(14) NOT NULL,