summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorCallan Barrett <wizzomafizzo@gmail.com>2007-12-26 20:38:39 +0100
committerDan McGee <dan@archlinux.org>2008-01-20 07:21:19 +0100
commita8e574ef2897e9ca709c2cfa5ff78d2f69464092 (patch)
tree48bfc85a2ab6416af3e19183bb782ad7d20c94dd /support/schema
parent32b863203fcda13f322aa0802bc64eec64dcaa51 (diff)
downloadaur-a8e574ef2897e9ca709c2cfa5ff78d2f69464092.tar.gz
aur-a8e574ef2897e9ca709c2cfa5ff78d2f69464092.tar.xz
AUR Voting Application
Added support for TU voting through AUR Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com>
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 11ad5a56..d48917c4 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -210,3 +210,24 @@ CREATE TABLE CommentNotify (
FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
);
+-- Vote information
+--
+CREATE TABLE IF NOT EXISTS TU_VoteInfo (
+ ID int(10) unsigned NOT NULL auto_increment,
+ Agenda text collate latin1_general_ci NOT NULL,
+ User char(32) collate latin1_general_ci NOT NULL,
+ Submitted bigint(20) unsigned NOT NULL,
+ SubmitterID int(10) unsigned NOT NULL,
+ Yes tinyint(3) unsigned NOT NULL default '0',
+ No tinyint(3) unsigned NOT NULL default '0',
+ Abstain tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (ID)
+)
+
+-- Individual vote records
+--
+CREATE TABLE IF NOT EXISTS TU_Votes (
+ VoteID int(10) unsigned NOT NULL,
+ UserID int(10) unsigned NOT NULL
+)
+