From 2b460a8f2db246d4da7e6698d40b719c67867ed2 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 13 Apr 2011 11:56:03 +0200 Subject: 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 --- support/schema/aur-schema.sql | 2 -- 1 file changed, 2 deletions(-) (limited to 'support/schema') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 2326e76..e64ae82 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 -- cgit v1.2.3-70-g09d2