summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-04-13 11:56:03 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2011-04-13 12:22:35 +0200
commit2b460a8f2db246d4da7e6698d40b719c67867ed2 (patch)
tree16181479a5a849a2ddc94921ca23c06b2e1a75b3 /support/schema/aur-schema.sql
parentd73f9df39b05c38443424b5a97b2efa9da9f26aa (diff)
downloadaur-2b460a8f2db246d4da7e6698d40b719c67867ed2.tar.gz
aur-2b460a8f2db246d4da7e6698d40b719c67867ed2.tar.xz
Remove "NewPkgNotify" column from "Users" table.
We do not require this column anymore. New package notifications are no longer supported. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql2
1 files changed, 0 insertions, 2 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 2326e765..e64ae82b 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -32,12 +32,10 @@ CREATE TABLE Users (
LangPreference VARCHAR(5) NOT NULL DEFAULT 'en',
IRCNick VARCHAR(32) NOT NULL DEFAULT '',
LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0,
- NewPkgNotify TINYINT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (ID),
UNIQUE (Username),
UNIQUE (Email),
INDEX (AccountTypeID),
- INDEX (NewPkgNotify),
FOREIGN KEY (AccountTypeID) REFERENCES AccountTypes(ID) ON DELETE NO ACTION
) ENGINE = InnoDB;
-- A default developer account for testing purposes