diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-04-13 11:56:03 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-04-13 12:22:35 +0200 |
| commit | 2b460a8f2db246d4da7e6698d40b719c67867ed2 (patch) | |
| tree | 16181479a5a849a2ddc94921ca23c06b2e1a75b3 | |
| parent | d73f9df39b05c38443424b5a97b2efa9da9f26aa (diff) | |
| download | aur-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>
| -rw-r--r-- | UPGRADING | 6 | ||||
| -rw-r--r-- | support/schema/aur-schema.sql | 2 |
2 files changed, 6 insertions, 2 deletions
@@ -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 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 |