[foundation-web] The election_results table should be in the schema.
- From: Tobias Mueller <tobiasmue src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [foundation-web] The election_results table should be in the schema.
- Date: Mon, 7 Jul 2014 21:37:28 +0000 (UTC)
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.
*/
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]