About Referendum

http://creativecommons.org/licenses/by-sa/2.5/ About Referendum <p><a class="wikilink" href="http://swik.net/Referendum">Referendum</a> is an issue voting system.</p> <ul> <li><a rel='nofollow' href="http://sandbox.sourcelabs.com/referendum/index.phps">Referendum source code</a></li> </ul> <p>Essentially Referendum is a simple <a class="wikilink" href="http://swik.net/CRUD"><span class="caps">CRUD</span></a> application, users insert votes, issues and ballots, and then read them out in tables.</p> <h1>Ajax Voting</h1> The <a class="wikilink" href="http://swik.net/Ajax">Ajax</a> voting system works like this: <ol> <li>User clicks on a vote <ol> <li>Ajax fires off a request</li> <li>Vote class is set to pending</li> </ol> </li> <li>Server receives request <ol> <li>Server deletes all votes for the issue from the user’s IP</li> <li>A new vote is inserted</li> <li>The current tally of votes for the issue is selected from the <a class="wikilink" href="http://swik.net/database">database</a> and returned.</li> </ol> </li> <li>Client receives response – including the tally and the id of the issue. <ol> <li>Vote tally is updated</li> <li>User’s vote is set to selected</li> </ol></li> </ol> <h1>Database Schema</h1> <pre> <code> -- Database: `referendum` -- -- -------------------------------------------------------- -- -- Table structure for table `ballots` -- CREATE TABLE `ballots` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) collate utf8_unicode_ci NOT NULL default '', `description` text collate utf8_unicode_ci NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `updated` timestamp NOT NULL default CURRENT_TIMESTAMP, `password` varchar(32) collate utf8_unicode_ci NOT NULL default '', `css` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `created` (`created`,`updated`), FULLTEXT KEY `description` (`description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Table structure for table `issues` -- CREATE TABLE `issues` ( `id` int(11) NOT NULL auto_increment, `ballot_id` int(11) NOT NULL default '0', `title` varchar(255) collate utf8_unicode_ci NOT NULL default '', `description` text collate utf8_unicode_ci NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `name` varchar(255) collate utf8_unicode_ci NOT NULL default '', `ip` int(4) NOT NULL default '0', `link` text collate utf8_unicode_ci NOT NULL, `approved` tinyint(1) NOT NULL default '0', `homepage` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `ballot_id` (`ballot_id`), KEY `approved` (`approved`), FULLTEXT KEY `description` (`description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Table structure for table `votes` -- CREATE TABLE `votes` ( `id` int(11) NOT NULL auto_increment, `issue_id` int(11) NOT NULL default '0', `ip` int(4) NOT NULL default '0', `vote` tinyint(1) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `ballot_id` (`issue_id`,`ip`,`vote`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ; </code> </pre> <h1>Images</h1> <ul> <li><a rel='nofollow' href="http://famfamfam.com">famfamfam</a></li> </ul> Documentation Referendum Mon, 27 Feb 2006 13:04:58 -0800 Thu, 07 Jun 2007 18:38:45 -0700