TODO has been modified to relfect bug changes already delt with. Also, autogenerated...

diff --git a/TODO b/TODO
index bba3e79df8450e97ba1ba02de5de248d60a9a138..0575d629afa9bde8c0e0993dd6f09a92dff5a28c 100644 (file)
--- a/TODO
+++ b/TODO
@@ -5,8 +5,6 @@ General Issues
 
 Known bugs or issues:
 
 
 Known bugs or issues:
 

-- randomize each voting list
-

 - it'd be nice if the ordering were persistent, so I could drag
   the candidates around, then come back later (loading the page anew),
   make tweaks, and submit.
 - it'd be nice if the ordering were persistent, so I could drag
   the candidates around, then come back later (loading the page anew),
   make tweaks, and submit.


@@ -15,10 +13,6 @@ Known bugs or issues:
   if it were aware that it's a five-seat election and could say
   explicitly who the whole board is.
 
   if it were aware that it's a five-seat election and could say
   explicitly who the whole board is.
 

-- it's probably a good thing that users can't check out what alternate
-  voting systems would have done at the click of a button. =)
-  (though of course they could work it out themselves.)
-

 - is there rhyme or reason to the ordering within each row of the
   second table in pref_tables?  it could be, eg, sorted by magnitude
   of victory, narrowest first.
 - is there rhyme or reason to the ordering within each row of the
   second table in pref_tables?  it could be, eg, sorted by magnitude
   of victory, narrowest first.


@@ -30,11 +24,6 @@ Known bugs or issues:
   helpful for auditing, too, as one could separately match names to the
   correct list and match addresses to names.)
 
   helpful for auditing, too, as one could separately match names to the
   correct list and match addresses to names.)
 

-- just a tiny suggestion - possibly it could be a good idea to add a
-  counter/line-count to the table with keys and vote results so in one
-  glance someone can see that the number of votes matches the number of
-  voters.
-

 QuickVotes
 ==============
 
 QuickVotes
 ==============
 

diff --git a/db/schema.rb b/db/schema.rb
index aa46f6fa78c1033e26b97e4e0818175135db77a0..be37e18417d8ad0750eddf5e5b1c4d360b81a95f 100644 (file)
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -31,17 +31,14 @@ ActiveRecord::Schema.define(:version => 2) do
   add_index "elections", ["user_id"], :name => "fk_user_election"
 
   create_table "pictures", :force => true do |t|
   add_index "elections", ["user_id"], :name => "fk_user_election"
 
   create_table "pictures", :force => true do |t|

-    t.column "filename",     :string
-    t.column "content_type", :string
-    t.column "size",         :integer
-    t.column "width",        :integer
-    t.column "height",       :integer
-    t.column "parent_id",    :integer
-    t.column "thumbnail",    :string
-    t.column "created_at",   :datetime
+    t.column "filename",     :string,  :limit => 200
+    t.column "data",         :binary
+    t.column "filetype",     :string,  :limit => 100

     t.column "candidate_id", :integer
   end
 
     t.column "candidate_id", :integer
   end
 

+  add_index "pictures", ["candidate_id"], :name => "fk_candidate_picture"
+

   create_table "rankings", :force => true do |t|
     t.column "vote_id",      :integer
     t.column "candidate_id", :integer
   create_table "rankings", :force => true do |t|
     t.column "vote_id",      :integer
     t.column "candidate_id", :integer