This project is mirrored from https://:*****@gitlab.archlinux.org/archlinux/aurweb.git. Pull mirroring updated .
  1. 24 Mar, 2013 1 commit
  2. 21 Mar, 2013 1 commit
  3. 22 Oct, 2012 1 commit
  4. 24 Mar, 2012 1 commit
  5. 24 Oct, 2011 2 commits
  6. 25 Jun, 2011 1 commit
  7. 13 Apr, 2011 1 commit
  8. 12 Apr, 2011 1 commit
  9. 03 Apr, 2011 1 commit
    • Dan McGee's avatar
      Remove Dummy Package concept · 7c91c592
      Dan McGee authored
      
      
      Instead, we just store dependencies directly in the PackageDepends
      table. Since we don't use this info anywhere besides the package details
      page, there is little value in precalculating what is in the AUR vs.
      what is not.
      
      An upgrade path is provided via several SQL statements in the UPGRADING
      document. There should be no user-visible change from this, but the DB
      schema gets a bit more sane and we no longer have loads of junk packages
      in our tables that are never shown to the end user. This should also
      help the MySQL query planner in several cases as we no longer have to be
      careful to exclude dummy packages on every query.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      7c91c592
  10. 04 Mar, 2011 2 commits
  11. 28 Feb, 2011 1 commit
  12. 27 Feb, 2011 3 commits
  13. 26 Feb, 2011 1 commit
  14. 11 Feb, 2011 2 commits
  15. 10 Feb, 2011 1 commit
  16. 09 Feb, 2011 1 commit
  17. 01 Feb, 2011 3 commits
  18. 24 Jan, 2011 1 commit
  19. 10 Nov, 2010 1 commit
  20. 17 Apr, 2010 1 commit
  21. 29 Nov, 2009 1 commit
  22. 13 Nov, 2009 1 commit
    • Evangelos Foutras's avatar
      Implement 'Password Reset' facility (FS#3061) · 861cbf49
      Evangelos Foutras authored
      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=<reset
      
       key>
      
      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: default avatarLoui Chang <louipc.ist@gmail.com>
      861cbf49
  23. 18 Jun, 2009 1 commit
    • Dan McGee's avatar
      Add multicolumn indexes on votes and notifications tables · e2b3bd1c
      Dan McGee authored
      
      
      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: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLoui Chang <louipc.ist@gmail.com>
      e2b3bd1c
  24. 27 Mar, 2008 1 commit
  25. 23 Mar, 2008 1 commit
  26. 20 Jan, 2008 6 commits
  27. 17 Sep, 2007 1 commit
  28. 16 Aug, 2007 1 commit