[foundation-web] The election_results table should be in the schema.

[Tobias Mueller <tobiasmue src gnome org>]

commit cc099ceeeab0d2d3286e5e92dc0b30e4b6f34778
Author: Bradley M. Kuhn <bkuhn ebb org>
Date:   Mon Feb 10 17:03:53 2014 -0500

    The election_results table should be in the schema.
    
    I was unsure what field type to make the results, but reading this:
      http://dev.mysql.com/doc/refman/5.0/en/blob.html
    convinced me that I should probably make it "text" type.

 foundation.gnome.org/vote/include/schema.sql |   11 +++++++++++
 1 files changed, 11 insertions(+), 0 deletions(-)
---
diff --git a/foundation.gnome.org/vote/include/schema.sql b/foundation.gnome.org/vote/include/schema.sql
index 0eea9c4..cc77b86 100644
--- a/foundation.gnome.org/vote/include/schema.sql
+++ b/foundation.gnome.org/vote/include/schema.sql
@@ -23,6 +23,17 @@ DROP TABLE IF EXISTS `election_choices`;
    PRIMARY KEY  (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ;
 
+/* The election_results table stores the HTML output from the openstv command.
+** It must be inserted manually at the end of the election.
+*/
+
+DROP TABLE IF EXISTS `election_results`;
+ CREATE TABLE `election_results` (
+   `election_id` int(11) NOT NULL UNIQUE default '0',
+   `result` text
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
 /* Data in election_tmp_tokens only lives while the election is ongoing, and
 ** the PHP code deletes these entries when it records votes.
 */