Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

e2poll dbtable has duplicate column 'totalvotes' #1

Open
jaybonci opened this Issue Jan 17, 2012 · 2 comments

Comments

Projects
None yet
2 participants
Owner

jaybonci commented Jan 17, 2012

The totalvotes column exists in the dbtable 'e2poll' and in the dbtable 'node', which means that only one is really getting used properly. This should either be renamed, or deleted, depending on what is appropriate.

Member

e2alex commented Jan 26, 2012

Polls should probably use their own tables exclusively. Poll votes have already been removed from the vote table. I'd say remove poll-related values from node (only 32 of 258 polls even have a value in node.totalvotes) and rename e2poll.totalvotes. Or delete if you'd rather count(*) from pollvote.choice

Owner

jaybonci commented Jan 27, 2012

Yeah, I'm going to be wiping out the e2poll.totalvotes column. I'm just avoiding doing any major schema work until we have a good database migration framework.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment