summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-06-30 08:23:20 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-06-30 08:23:54 +0200
commitbcc6a959df461668921384bb69fa8f4fe36db939 (patch)
tree6fda8236558e6690c4da4e72d033528eb4c0d71b /schema
parent181c07edc61d9f70e57ed6d809dab88ffc0bbdf2 (diff)
aur-schema.sql: Use tabs for indentation everywhere
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'schema')
-rw-r--r--schema/aur-schema.sql34
1 files changed, 17 insertions, 17 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 1ec7385..8d89487 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -322,28 +322,28 @@ CREATE TABLE PackageRequests (
-- Vote information
--
CREATE TABLE IF NOT EXISTS TU_VoteInfo (
- ID int(10) unsigned NOT NULL auto_increment,
- Agenda text NOT NULL,
- User VARCHAR(32) NOT NULL,
- Submitted bigint(20) unsigned NOT NULL,
- End bigint(20) unsigned NOT NULL,
- Quorum decimal(2, 2) 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',
- ActiveTUs tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (ID),
- FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE
+ ID int(10) unsigned NOT NULL auto_increment,
+ Agenda text NOT NULL,
+ User VARCHAR(32) NOT NULL,
+ Submitted bigint(20) unsigned NOT NULL,
+ End bigint(20) unsigned NOT NULL,
+ Quorum decimal(2, 2) 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',
+ ActiveTUs tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (ID),
+ FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE
) ENGINE = InnoDB;
-- Individual vote records
--
CREATE TABLE IF NOT EXISTS TU_Votes (
- VoteID int(10) unsigned NOT NULL,
- UserID int(10) unsigned NOT NULL,
- FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
- FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
+ VoteID int(10) unsigned NOT NULL,
+ UserID int(10) unsigned NOT NULL,
+ FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
+ FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE
) ENGINE = InnoDB;
-- Malicious user banning