markzz/aurweb.git/support/schema/aur-schema.sql, branch 1.7.0

Support for storing salted passwords

2010-04-17T20:50:24Z

To upgrade existing databases: ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT ''; Signed-off-by: Loui Chang

aur-schema.sql: Expand LangPreference field to allow for longer lang codes.

2009-11-29T11:28:15Z

To upgrade existing databases: ALTER TABLE Users MODIFY LangPreference CHAR(5) NOT NULL DEFAULT 'en'; Signed-off-by: Loui Chang

Implement 'Password Reset' facility (FS#3061)

2009-11-13T21:49:55Z

This works by adding a new field to the 'Users' table called 'ResetKey', which is a 32 characters long, random string. When the user requests a password reset, a new 'reset key' is generated and sent to the user's e-mail address in the form of a link in the following format: http://aur.archlinux.org/passreset.php?resetkey= When the above link is followed, the user is presented with a form to verify his/her e-mail address and specify the new desired password. If the e-mail address matches the reset key in the database, the new password is assigned to the account. If there is an error, a relevant message is displayed and the user is prompted to re-enter the required information. Upon successful completion of this procedure, the ResetKey field in the database is blanked and the specific key cannot be reused. One SQL query is needed to add the ResetKey field to the 'Users' table: ALTER TABLE `Users` ADD `ResetKey` CHAR(32) NOT NULL DEFAULT ''; Signed-off-by: Loui Chang

Add multicolumn indexes on votes and notifications tables

2009-06-18T05:47:17Z

To put a long story short, when we do joins on these tables in our pkg_search_page() function, we always join on both the user ID and package ID columns. By creating multicolumn indices, we can always get the exact row we are looking for in the table. The benefits of adding a unique index should also speak for themselves, as we previously did not have this on either of these tables. This is part one of a two-part series to address the fact that this query was often showing up in our slow query logs. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Remove references to AURMaintainerUID

2008-03-27T07:34:35Z

This (should) get rid of anything to do with the unused column AURMaintainerUID in the scripts and schema files Signed-off-by: Callan Barrett Signed-off-by: Simo Leone

Make all references to AUR database consistent

2008-03-23T08:04:17Z

Signed-off-by: Loui Chang Signed-off-by: Simo Leone

Bug in uploading PKGBUILDs and aur schema

2008-01-20T06:21:19Z

This fixes a bug where TUs and devs couldn't upload packages because the query would have an extra column in it to mark the pkgbuild safe automatically, guessing it got missed when the safe flags were removed. Also fixes a screw up I made with the schema file when I added the tables for the voting app. Signed-off-by: Callan Barrett

Add support for variable length votes in voting application

2008-01-20T06:21:19Z

Signed-off-by: Callan Barrett

AUR Voting Application

2008-01-20T06:21:19Z

Added support for TU voting through AUR Signed-off-by: Callan Barrett

Fix for safe-removal.

2008-01-20T06:21:18Z