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 --- UPGRADING | 6 ++++++ support/schema/aur-schema.sql | 2 -- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/UPGRADING b/UPGRADING index da85a8d..bf66cc9 100644 --- a/UPGRADING +++ b/UPGRADING @@ -7,6 +7,12 @@ From 1.8.2 to 1.9.0 1. Translation files are now gettext compatible and need to be compiled after each AUR upgrade by running `make install` in the "po/" directory. +2. Remove the "NewPkgNotify" column from the "Users" table: + +---- +ALTER TABLE Users DROP COLUMN NewPkgNotify; +---- + From 1.8.1 to 1.8.2 ------------------- 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