From b69f548065e78d14afcdc91548d73539762f8d93 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 2 Feb 2011 18:03:09 +0100 Subject: Add a package name blacklist. Can be used to blacklist package names for normal users. TUs and developers are not affected. This is especially useful if used together with a cron job that updates the blacklist periodically, e.g. to reject packages which are available in the binary repos (FS#12902). Signed-off-by: Lukas Fleischer --- UPGRADING | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'UPGRADING') diff --git a/UPGRADING b/UPGRADING index c649985f..c5da23aa 100644 --- a/UPGRADING +++ b/UPGRADING @@ -27,6 +27,12 @@ ALTER TABLE PackageSources MODIFY Source VARCHAR(255) NOT NULL DEFAULT "/dev/null"; ALTER TABLE TU_VoteInfo MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL; +CREATE TABLE PackageBlacklist ( + ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, + Name CHAR(64) NOT NULL, + PRIMARY KEY (ID), + UNIQUE (Name) +); ---- 2. Drop all fulltext indexes from the "Packages" table: -- cgit v1.2.3-24-g4f1b